1 # sql file for hello world module
6 certify_id mediumint(8) unsigned NOT NULL auto_increment,
7 course_id mediumint(8) unsigned NOT NULL,
8 title varchar(60) NOT NULL,
9 description varchar(600) NOT NULL,
10 PRIMARY KEY (certify_id)
14 CREATE TABLE certify_tests (
15 certify_id mediumint(8) unsigned NOT NULL,
16 test_id mediumint(8) unsigned NOT NULL,
17 PRIMARY KEY (certify_id, test_id)
21 INSERT INTO `language_text` VALUES
22 ('en', '_module','Certify','Certify',NOW(),''),
23 ('en', '_module','certify_certificates','Certificates',NOW(),''),
24 ('en', '_module','certify_certificate','Add new certificate',NOW(),''),
25 ('en', '_module','certify_file','Certificate template',NOW(),''),
26 ('en', '_module','certify_tests','Tests in this certificate',NOW(),''),
27 ('en', '_module','certify_title','Certificate name',NOW(),''),
28 ('en', '_module','certify_description','Description',NOW(),''),
29 ('en', '_module','certify_status','Status',NOW(),''),
30 ('en', '_module','certify_download_certificate','Download certificate',NOW(),''),
31 ('en', '_module','certify_add_new','Add new certificate',NOW(),''),
32 ('en', '_module','certify_add_certificate','Add new certificate',NOW(),''),
33 ('en', '_module','certify_student_status','Student status',NOW(),''),
34 ('en', '_module','certify_edit_tests','Edit tests',NOW(),''),
35 ('en', '_msgs', 'AT_INFOS_CERTIFY_NO_CERTIFICATES', 'There are no certificates yet, let us <a href="mods/certify/certify_add_new.php">add one</a>!', NOW(), '');