1 # sql file for certificate module
\r
3 CREATE TABLE `certificate` (
\r
4 `certificate_id` MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
\r
5 `test_id` mediumint(8) unsigned NOT NULL ,
\r
6 `passscore` mediumint(9) ,
\r
7 `passpercent` mediumint(9) ,
\r
8 `organization` varchar(255),
\r
9 `enable_download` tinyint(4) unsigned ,
\r
10 `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ,
\r
11 PRIMARY KEY ( `certificate_id` )
\r
14 CREATE TABLE `certificate_text` (
\r
15 `certificate_text_id` MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
\r
16 `certificate_id` MEDIUMINT UNSIGNED NOT NULL,
\r
17 `field_name` VARCHAR(100) NOT NULL ,
\r
18 `field_value` VARCHAR(255) NOT NULL ,
\r
19 PRIMARY KEY ( `certificate_text_id` )
\r
22 INSERT INTO `language_text` VALUES ('en', '_module','certificate','Certificate',NOW(),'');
\r
23 INSERT INTO `language_text` VALUES ('en', '_template', 'create_certificate', 'Create Certificate', now(), '');
\r
24 INSERT INTO `language_text` VALUES ('en', '_template', 'delete_certificate', 'Delete Certificate', now(), '');
\r
25 INSERT INTO `language_text` VALUES ('en', '_template', 'edit_certificate', 'Edit Certificate', now(), '');
\r
26 INSERT INTO `language_text` VALUES ('en', '_template', 'certificate_id', 'Certificate ID', now(), '');
\r
27 INSERT INTO `language_text` VALUES ('en', '_template', 'test_title', 'Test Title', now(), '');
\r
28 INSERT INTO `language_text` VALUES ('en', '_template', 'choose_test', 'Choose Test', now(), '');
\r
29 INSERT INTO `language_text` VALUES ('en', '_template', 'certificate_template', 'Certificate Template', now(), '');
\r
30 INSERT INTO `language_text` VALUES ('en', '_template', 'organization_name', 'Name of Organization', now(), '');
\r
31 INSERT INTO `language_text` VALUES ('en', '_template', 'certificate_text', 'Certificate Text', now(), '');
\r
32 INSERT INTO `language_text` VALUES ('en', '_template', 'field_name', 'Field Name', now(), '');
\r
33 INSERT INTO `language_text` VALUES ('en', '_template', 'field_value', 'Field Value', now(), '');
\r
34 INSERT INTO `language_text` VALUES ('en', '_template', 'enable_download_certificate', 'Enable Download Certificate', now(), '');
\r
35 INSERT INTO `language_text` VALUES ('en', '_template', 'issue_certificate', 'Issue certificate if test is passed', now(), '');
\r
36 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
37 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
38 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
39 INSERT INTO `language_text` VALUES ('en', '_template', 'certificate_tokens', '<strong>Certificate Tokens</strong><br>[TNAME]: Test Title<br>
\r
40 [FNAME]: First Name<br>
\r
41 [LNAME]: Last Name<br>
\r
42 [CNAME]: Course Name<br>
\r
43 [USERMAIL]: Email Address<br>
\r
44 [USCORE]: Users test score<br>
\r
45 [OSCORE]: Out of test score<br>
\r
46 [PSCORE]: Test score in percentage<br>
\r
47 [SYSDATE]: Date time of last attempt at passed test<br>
\r
48 [USERID]: ATutor Member ID', now(), '');
\r
50 INSERT INTO `language_text` VALUES ('en', '_template', 'pass_score', 'Pass Score', now(), '');
\r
51 INSERT INTO `language_text` VALUES ('en', '_template', 'percentage_score', 'percentage score', now(), '');
\r
52 INSERT INTO `language_text` VALUES ('en', '_template', 'points_score', 'points score', now(), '');
\r