1 ###############################################################
\r
2 # Database upgrade SQL from ATutor 1.5.1 to ATutor 1.5.2
\r
3 ###############################################################
\r
5 # --------------------------------------------------------
\r
6 # Table structure for table `faq_topics`
\r
8 CREATE TABLE `faq_topics` (
\r
9 `topic_id` mediumint(8) NOT NULL auto_increment,
\r
10 `course_id` mediumint(8) unsigned NOT NULL default '0',
\r
11 `name` varchar(250) NOT NULL default '',
\r
12 KEY `course_id` (`course_id`),
\r
13 PRIMARY KEY (`topic_id`)
\r
16 # --------------------------------------------------------
\r
17 # Table structure for table `faq_entries`
\r
18 CREATE TABLE `faq_entries` (
\r
19 `entry_id` mediumint(8) NOT NULL auto_increment,
\r
20 `topic_id` mediumint(8) NOT NULL default '0',
\r
21 `revised_date` datetime NOT NULL default '0000-00-00 00:00:00',
\r
22 `approved` tinyint(4) NOT NULL default '0',
\r
23 `question` varchar(250) NOT NULL default '',
\r
24 `answer` text NOT NULL,
\r
25 PRIMARY KEY (`entry_id`)
\r
28 # --------------------------------------------------------
\r
29 # Table structure for table `feeds`
\r
30 CREATE TABLE `feeds` (
\r
31 `feed_id` mediumint(8) unsigned NOT NULL auto_increment,
\r
32 `url` varchar(255) NOT NULL default '',
\r
33 PRIMARY KEY (`feed_id`)
\r
38 # Table structure for table `config`
\r
40 CREATE TABLE `config` (
\r
41 `name` CHAR( 30 ) NOT NULL ,
\r
42 `value` CHAR( 255 ) NOT NULL ,
\r
43 PRIMARY KEY ( `name` )
\r
48 CREATE TABLE `modules` (
\r
49 `dir_name` VARCHAR( 50 ) NOT NULL ,
\r
50 `status` TINYINT NOT NULL ,
\r
51 `privilege` MEDIUMINT UNSIGNED NOT NULL ,
\r
52 `admin_privilege` MEDIUMINT UNSIGNED NOT NULL ,
\r
53 PRIMARY KEY ( `dir_name` )
\r
56 INSERT INTO `modules` VALUES ('_core/properties', 2, 1, 0);
\r
57 INSERT INTO `modules` VALUES ('_standard/statistics', 2, 1, 0);
\r
58 INSERT INTO `modules` VALUES ('_core/content', 2, 2, 0);
\r
59 INSERT INTO `modules` VALUES ('_core/glossary', 2, 4, 0);
\r
60 INSERT INTO `modules` VALUES ('_standard/tests', 2, 8, 0);
\r
61 INSERT INTO `modules` VALUES ('_standard/chat', 2, 16, 0);
\r
62 INSERT INTO `modules` VALUES ('_core/file_manager', 2, 32, 0);
\r
63 INSERT INTO `modules` VALUES ('_standard/links', 2, 64, 0);
\r
64 INSERT INTO `modules` VALUES ('_standard/forums', 2, 128, 16);
\r
65 INSERT INTO `modules` VALUES ('_standard/student_tools', 2, 256, 0);
\r
66 INSERT INTO `modules` VALUES ('_core/enrolment', 2, 512, 0);
\r
67 INSERT INTO `modules` VALUES ('_standard/course_email', 2, 1024, 0);
\r
68 INSERT INTO `modules` VALUES ('_standard/announcements', 2, 2048, 0);
\r
69 # INSERT INTO `modules` VALUES ('acollab', 2, 8192+4096, 0);
\r
70 INSERT INTO `modules` VALUES ('_standard/polls', 2, 16384, 0);
\r
71 INSERT INTO `modules` VALUES ('_standard/faq', 2, 32768, 0);
\r
72 INSERT INTO `modules` VALUES ('_core/users', 2, 0, 2);
\r
73 INSERT INTO `modules` VALUES ('_core/courses', 2, 0, 4);
\r
74 INSERT INTO `modules` VALUES ('_core/backups', 2, 1, 8);
\r
75 INSERT INTO `modules` VALUES ('_core/cats_categories', 2, 0, 32);
\r
76 INSERT INTO `modules` VALUES ('_core/languages', 2, 0, 64);
\r
77 INSERT INTO `modules` VALUES ('_core/themes', 2, 0, 128);
\r
78 INSERT INTO `modules` VALUES ('_standard/rss_feeds', 2, 0, 256);
\r
79 INSERT INTO `modules` VALUES ('_core/groups', 2, 0, 0);
\r
80 INSERT INTO `modules` VALUES ('_standard/directory', 2, 0, 0);
\r
81 INSERT INTO `modules` VALUES ('_standard/tile_search', 2, 0, 0);
\r
82 INSERT INTO `modules` VALUES ('_standard/sitemap', 2, 0, 0);
\r
83 INSERT INTO `modules` VALUES ('_standard/tracker', 2, 0, 0);
\r
84 INSERT INTO `modules` VALUES ('_core/content_packaging', 2, 0, 0);
\r
85 INSERT INTO `modules` VALUES ('_standard/google_search', 2, 0, 0);
\r
88 ALTER TABLE `admin_log` CHANGE `details` `details` TEXT NOT NULL;
\r
91 ALTER TABLE `courses` CHANGE `home_links` `home_links` TEXT NOT NULL ,CHANGE `main_links` `main_links` TEXT NOT NULL;
\r