1 # Add folder node into `content` table
2 ALTER TABLE `content` add `content_type` tinyint NOT NULL DEFAULT 0;
4 # --------------------------------------------------------
5 # Table structure for table `content_forums_assoc`
7 CREATE TABLE `content_forums_assoc` (
8 `content_id` INTEGER UNSIGNED NOT NULL,
9 `forum_id` INTEGER UNSIGNED NOT NULL,
10 PRIMARY KEY ( `content_id` , `forum_id` )
14 # --------------------------------------------------------
15 # Replace (TEXT NOT NULL) with (TEXT)
16 ALTER TABLE `admin_log` MODIFY `details` TEXT;
18 ALTER TABLE `backups` MODIFY `description` TEXT, MODIFY `file_name` TEXT, MODIFY `contents` TEXT;
20 ALTER TABLE `blog_posts` MODIFY `body` TEXT;
22 ALTER TABLE `blog_posts_comments` MODIFY `comment` TEXT;
24 ALTER TABLE `config` MODIFY `value` TEXT;
26 ALTER TABLE `content` MODIFY `keywords` TEXT, MODIFY `content_path` TEXT, MODIFY `text` TEXT, MODIFY `head` TEXT, MODIFY `test_message` TEXT;
28 ALTER TABLE `courses` MODIFY `description` TEXT, MODIFY `copyright` TEXT, MODIFY `home_links` TEXT, MODIFY `main_links` TEXT, MODIFY `banner` TEXT;
30 ALTER TABLE `faq_topics` MODIFY `name` TEXT;
32 ALTER TABLE `faq_entries` MODIFY `question` TEXT, MODIFY `answer` TEXT;
34 ALTER TABLE `files` MODIFY `description` TEXT;
36 ALTER TABLE `files_comments` MODIFY `comment` TEXT;
38 ALTER TABLE `forums` MODIFY `description` TEXT;
40 ALTER TABLE `forums_threads` MODIFY `body` TEXT;
42 ALTER TABLE `glossary` MODIFY `definition` TEXT;
44 ALTER TABLE `groups` MODIFY `description` TEXT;
46 ALTER TABLE `handbook_notes` MODIFY `note` TEXT;
48 ALTER TABLE `instructor_approvals` MODIFY `notes` TEXT;
50 ALTER TABLE `links` MODIFY `Description` TEXT;
52 ALTER TABLE `members` MODIFY `address` TEXT, MODIFY `preferences` TEXT;
54 ALTER TABLE `messages` MODIFY `body` TEXT;
56 ALTER TABLE `messages_sent` MODIFY `body` TEXT;
58 ALTER TABLE `news` MODIFY `body` TEXT;
60 ALTER TABLE `mail_queue` MODIFY `body` TEXT;
62 ALTER TABLE `reading_list` MODIFY `comment` TEXT;
64 ALTER TABLE `external_resources` MODIFY `comments` TEXT;
66 ALTER TABLE `tests` MODIFY `instructions` TEXT, MODIFY `description` TEXT, MODIFY `passfeedback` TEXT, MODIFY `failfeedback` TEXT;
68 ALTER TABLE `tests_answers` MODIFY `answer` TEXT, MODIFY `notes` TEXT;
70 ALTER TABLE `tests_questions` MODIFY `feedback` TEXT, MODIFY `question` TEXT, MODIFY `choice_0` TEXT
71 , MODIFY `choice_1` TEXT, MODIFY `choice_2` TEXT, MODIFY `choice_3` TEXT, MODIFY `choice_4` TEXT
72 , MODIFY `choice_5` TEXT, MODIFY `choice_6` TEXT, MODIFY `choice_7` TEXT, MODIFY `choice_8` TEXT
73 , MODIFY `choice_9` TEXT, MODIFY `option_0` TEXT, MODIFY `option_1` TEXT, MODIFY `option_2` TEXT
74 , MODIFY `option_3` TEXT, MODIFY `option_4` TEXT, MODIFY `option_5` TEXT, MODIFY `option_6` TEXT
75 , MODIFY `option_7` TEXT, MODIFY `option_8` TEXT, MODIFY `option_9` TEXT;
77 ALTER TABLE `themes` MODIFY `extra_info` TEXT;
79 ALTER TABLE `patches` MODIFY `description` TEXT, MODIFY `sql_statement` TEXT, MODIFY `remove_permission_files` TEXT,
80 MODIFY `backup_files` TEXT, MODIFY `patch_files` TEXT;
82 ALTER TABLE `patches_files` MODIFY `name` TEXT;
84 ALTER TABLE `patches_files_actions` MODIFY `code_from` TEXT, MODIFY `code_to` TEXT;
86 ALTER TABLE `myown_patches` MODIFY `description` TEXT, MODIFY `sql_statement` TEXT;
88 ALTER TABLE `myown_patches_files` MODIFY `code_from` TEXT, MODIFY `code_to` TEXT, MODIFY `uploaded_file` TEXT;
90 ALTER TABLE `primary_resources` MODIFY `resource` TEXT;
92 ALTER TABLE `resource_types` MODIFY `type` TEXT;
94 ALTER TABLE `secondary_resources` MODIFY `secondary_resource` TEXT;
96 ALTER TABLE `fha_student_tools` MODIFY `links` TEXT;
98 ALTER TABLE `social_applications` MODIFY `description` TEXT, MODIFY `settings` TEXT, MODIFY `views` TEXT;
100 ALTER TABLE `social_application_settings` MODIFY `value` TEXT;
102 ALTER TABLE `social_member_position` MODIFY `description` TEXT;
104 ALTER TABLE `social_member_education` MODIFY `description` TEXT;
106 ALTER TABLE `social_privacy_preferences` MODIFY `preferences` TEXT;
108 ALTER TABLE `social_groups` MODIFY `description` TEXT;
110 ALTER TABLE `social_groups_board` MODIFY `body` TEXT;
112 ALTER TABLE `social_user_settings` MODIFY `app_settings` TEXT;
114 # added by Bologna CC.
115 INSERT INTO `modules` VALUES ('_core/tool_manager', 2, 0, 0, 0, 0);
117 # --------------------------------------------------------
118 # Adding feature of content pre-requisites
119 # Table structure for table `content_prerequisites`
121 CREATE TABLE `content_prerequisites` (
122 `content_id` MEDIUMINT NOT NULL,
123 `type` varchar(50) NOT NULL DEFAULT '',
124 `item_id` MEDIUMINT NOT NULL,
125 PRIMARY KEY (content_id,type, item_id)
129 CREATE TABLE `social_member_contact` (
130 `contact_id` int(10) unsigned NOT NULL auto_increment,
131 `member_id` int(10) unsigned NOT NULL,
132 `con_name` varchar(200) NOT NULL,
133 `con_phone` varchar(15) NOT NULL,
134 `con_email` varchar(50) NOT NULL,
135 `con_address` text NOT NULL,
136 PRIMARY KEY (`contact_id`)
137 ) ENGINE = MyISAM DEFAULT CHARSET=utf8 ;
140 CREATE TABLE `social_member_representation` (
141 `rep_id` int(10) unsigned NOT NULL auto_increment,
142 `member_id` int(10) unsigned NOT NULL,
143 `rep_name` varchar(200) NOT NULL,
144 `rep_title` varchar(50) NOT NULL,
145 `rep_phone` varchar(15) NOT NULL,
146 `rep_email` varchar(50) NOT NULL,
147 `rep_address` text NOT NULL,
148 PRIMARY KEY (`rep_id`)
149 ) ENGINE = MyISAM DEFAULT CHARSET=utf8 ;
151 CREATE TABLE `social_member_personal` (
152 `per_id` int(10) unsigned NOT NULL auto_increment,
153 `member_id` int(10) unsigned NOT NULL,
154 `per_weight` varchar(200) NOT NULL,
155 `per_height` varchar(50) NOT NULL,
156 `per_hair` varchar(15) NOT NULL,
157 `per_eyes` varchar(50) NOT NULL,
158 `per_ethnicity` varchar(50) NOT NULL,
159 `per_languages` varchar(255) NOT NULL,
160 `per_disabilities` varchar(255) NOT NULL,
161 PRIMARY KEY (`per_id`)
165 INSERT INTO `themes` VALUES ('Mobile', '1.6.4', 'mobile', NOW(), 'This is the default theme for mobile devices.', 1);