1 ###############################################################
2 # Database upgrade SQL from ATutor 1.4 to ATutor 1.4.1
3 ###############################################################
5 # Table structure for table `polls`
7 `poll_id` MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT ,
8 `course_id` MEDIUMINT UNSIGNED NOT NULL ,
9 `question` VARCHAR( 100 ) NOT NULL ,
10 `created_date` DATETIME NOT NULL ,
11 `total` SMALLINT UNSIGNED NOT NULL ,
12 `choice1` VARCHAR( 100 ) NOT NULL ,
13 `count1` SMALLINT UNSIGNED NOT NULL ,
14 `choice2` VARCHAR( 100 ) NOT NULL ,
15 `count2` SMALLINT UNSIGNED NOT NULL ,
16 `choice3` VARCHAR( 100 ) NOT NULL ,
17 `count3` SMALLINT UNSIGNED NOT NULL ,
18 `choice4` VARCHAR( 100 ) NOT NULL ,
19 `count4` SMALLINT UNSIGNED NOT NULL ,
20 `choice5` VARCHAR( 100 ) NOT NULL ,
21 `count5` SMALLINT UNSIGNED NOT NULL ,
22 `choice6` VARCHAR( 100 ) NOT NULL ,
23 `count6` SMALLINT UNSIGNED NOT NULL ,
24 `choice7` VARCHAR( 100 ) NOT NULL ,
25 `count7` SMALLINT UNSIGNED NOT NULL ,
26 PRIMARY KEY ( `poll_id` ) ,
30 # --------------------------------------------------------
32 # Table structure for table `polls_members`
34 CREATE TABLE `polls_members` (
35 `poll_id` MEDIUMINT UNSIGNED NOT NULL ,
36 `member_id` MEDIUMINT UNSIGNED NOT NULL ,
37 PRIMARY KEY ( `poll_id` , `member_id` )
41 # Change age to date of birth
42 ALTER TABLE `members` CHANGE `age` `dob` DATE NOT NULL;
44 # Add `primary_language` to the `courses` table
45 ALTER TABLE `courses` ADD `primary_language` VARCHAR( 4 ) DEFAULT 'en' NOT NULL;