1 # sql file for reading list module
\r
3 CREATE TABLE `assignments` (
\r
4 `assignment_id` MEDIUMINT(6) UNSIGNED NOT NULL AUTO_INCREMENT DEFAULT 0,
\r
5 `course_id` MEDIUMINT UNSIGNED NOT NULL ,
\r
6 `title` VARCHAR(60) NOT NULL,
\r
7 `assign_to` MEDIUMINT UNSIGNED DEFAULT 0,
\r
8 `date_due` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
\r
9 `date_cutoff` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
\r
10 `multi_submit` TINYINT DEFAULT '0',
\r
11 PRIMARY KEY (`assignment_id`),
\r
15 REPLACE INTO `language_text` VALUES ('en', '_msgs','AT_CONFIRM_DELETE_ASSIGNMENT','Do you wish to delete this assignment: <strong>%s</strong>?',NOW(),'');
\r
16 REPLACE INTO `language_text` VALUES ('en', '_msgs','AT_ERROR_DUE_DATE_EMPTY','Due date is not set.',NOW(),'');
\r
17 REPLACE INTO `language_text` VALUES ('en', '_msgs','AT_ERROR_ASSIGNMENT_NOT_FOUND','Assignment not found.',NOW(),'');
\r
18 REPLACE INTO `language_text` VALUES ('en', '_msgs','AT_FEEDBACK_ASSIGNMENT_DELETED','Assignment Deleted',NOW(),'');
\r
19 REPLACE INTO `language_text` VALUES ('en', '_msgs','AT_FEEDBACK_ASSIGNMENT_UPDATED','Assignment Updated',NOW(),'');
\r
20 REPLACE INTO `language_text` VALUES ('en', '_module','assignments','Assignments',NOW(),'');
\r
21 REPLACE INTO `language_text` VALUES ('en', '_module','add_assignment','Add Assignment',NOW(),'');
\r
22 REPLACE INTO `language_text` VALUES ('en', '_module','edit_assignment','Edit Assignment',NOW(),'');
\r
23 REPLACE INTO `language_text` VALUES ('en', '_module','delete_assignment','Delete Assignment',NOW(),'');
\r
24 REPLACE INTO `language_text` VALUES ('en', '_module','due_date','Due Date',NOW(),'');
\r
25 REPLACE INTO `language_text` VALUES ('en', '_module','accept_late_submissions','Accept Late Submissions',NOW(),'');
\r
26 REPLACE INTO `language_text` VALUES ('en', '_module','allow_re_submissions','Allow Re-Submissions',NOW(),'');
\r
27 REPLACE INTO `language_text` VALUES ('en', '_module','assign_to','Assign To',NOW(),'');
\r
28 REPLACE INTO `language_text` VALUES ('en', '_module','time','Time',NOW(),'');
\r
29 REPLACE INTO `language_text` VALUES ('en', '_module','always','Always',NOW(),'');
\r
30 REPLACE INTO `language_text` VALUES ('en', '_module','until','Until',NOW(),'');
\r
31 REPLACE INTO `language_text` VALUES ('en', '_module','all_students','Everyone',NOW(),'');
\r
32 REPLACE INTO `language_text` VALUES ('en', '_module','options','Options',NOW(),'');
\r
33 REPLACE INTO `language_text` VALUES ('en', '_module','specific_groups','Specific Groups',NOW(),'');
\r