removed mods directory from the ATutor codebase

[atutor.git] / mods / certificate / module.sql

diff --git a/mods/certificate/module.sql b/mods/certificate/module.sql
deleted file mode 100644 (file)
index 76ad363..0000000
--- a/mods/certificate/module.sql
+++ /dev/null
@@ -1,52 +0,0 @@
-# sql file for certificate module\r
-\r
-CREATE TABLE `certificate` (\r
-   `certificate_id` MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,\r
-   `test_id` mediumint(8) unsigned NOT NULL ,\r
-   `passscore` mediumint(9) ,\r
-   `passpercent` mediumint(9) ,\r
-   `organization` varchar(255),\r
-   `enable_download` tinyint(4) unsigned ,\r
-   `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ,\r
-   PRIMARY KEY ( `certificate_id` )\r
-);\r
-\r
-CREATE TABLE `certificate_text` (\r
-   `certificate_text_id` MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,\r
-   `certificate_id` MEDIUMINT UNSIGNED NOT NULL,\r
-   `field_name` VARCHAR(100) NOT NULL ,\r
-   `field_value` VARCHAR(255) NOT NULL ,\r
-   PRIMARY KEY ( `certificate_text_id` )\r
-);\r
-\r
-INSERT INTO `language_text` VALUES ('en', '_module','certificate','Certificate',NOW(),'');\r
-INSERT INTO `language_text` VALUES ('en', '_template', 'create_certificate', 'Create Certificate', now(), '');\r
-INSERT INTO `language_text` VALUES ('en', '_template', 'delete_certificate', 'Delete Certificate', now(), '');\r
-INSERT INTO `language_text` VALUES ('en', '_template', 'edit_certificate', 'Edit Certificate', now(), '');\r
-INSERT INTO `language_text` VALUES ('en', '_template', 'certificate_id', 'Certificate ID', now(), '');\r
-INSERT INTO `language_text` VALUES ('en', '_template', 'test_title', 'Test Title', now(), '');\r
-INSERT INTO `language_text` VALUES ('en', '_template', 'choose_test', 'Choose Test', now(), '');\r
-INSERT INTO `language_text` VALUES ('en', '_template', 'certificate_template', 'Certificate Template', now(), '');\r
-INSERT INTO `language_text` VALUES ('en', '_template', 'organization_name', 'Name of Organization', now(), '');\r
-INSERT INTO `language_text` VALUES ('en', '_template', 'certificate_text', 'Certificate Text', now(), '');\r
-INSERT INTO `language_text` VALUES ('en', '_template', 'field_name', 'Field Name', now(), '');\r
-INSERT INTO `language_text` VALUES ('en', '_template', 'field_value', 'Field Value', now(), '');\r
-INSERT INTO `language_text` VALUES ('en', '_template', 'enable_download_certificate', 'Enable Download Certificate', now(), '');\r
-INSERT INTO `language_text` VALUES ('en', '_template', 'issue_certificate', 'Issue certificate if test is passed', now(), '');\r
-INSERT INTO `language_text` VALUES ('en', '_template', 'define_pass_score', 'Please define pass score <a href="%s" target="_blank">here</a> and save again', now(), '');\r
-INSERT INTO `language_text` VALUES ('en', '_template', 'require_acrobat', 'In order to %s certificate, you will require Adobe Acrobat Reader.<a href="http://www.adobe.com/products/acrobat/readstep2.html" target="_blank"><img src="mods/certificate/get_adobe_reader.gif" style="border-width: 0px;"></a>', now(), '');\r
-INSERT INTO `language_text` VALUES ('en', '_msgs', 'AT_CONFIRM_DELETE_CERTIFICATE', 'Are you sure you want to <strong>delete</strong> certificate for <strong>%s</strong>', now(), '');\r
-INSERT INTO `language_text` VALUES ('en', '_template', 'certificate_tokens', '<strong>Certificate Tokens</strong><br>[TNAME]: Test Title<br>\r
-[FNAME]: First Name<br>\r
-[LNAME]: Last Name<br>\r
-[CNAME]: Course Name<br>\r
-[USERMAIL]: Email Address<br>\r
-[USCORE]: Users test score<br>\r
-[OSCORE]: Out of test score<br>\r
-[PSCORE]: Test score in percentage<br>\r
-[SYSDATE]: Date time of last attempt at passed test<br>\r
-[USERID]: ATutor Member ID', now(), '');\r
-\r
-INSERT INTO `language_text` VALUES ('en', '_template', 'pass_score', 'Pass Score', now(), '');\r
-INSERT INTO `language_text` VALUES ('en', '_template', 'percentage_score', 'percentage score', now(), '');\r
-INSERT INTO `language_text` VALUES ('en', '_template', 'points_score', 'points score', now(), '');\r