1 ###############################################################
\r
2 # Database upgrade SQL from ATutor 1.5.3.2 to ATutor 1.5.3.3
\r
3 ###############################################################
\r
5 # convert DATETIME fields to TIMESTAMP
\r
6 ALTER TABLE `admins` CHANGE `last_login` `last_login` TIMESTAMP NULL ;
\r
7 ALTER TABLE `admin_log` CHANGE `time` `time` TIMESTAMP NOT NULL ;
\r
9 ALTER TABLE `backups` CHANGE `date` `date` TIMESTAMP NOT NULL ;
\r
10 ALTER TABLE `blog_posts` CHANGE `date` `date` TIMESTAMP NOT NULL ;
\r
11 ALTER TABLE `blog_posts_comments` CHANGE `date` `date` TIMESTAMP NOT NULL ;
\r
12 ALTER TABLE `content` CHANGE `last_modified` `last_modified` TIMESTAMP NOT NULL ;
\r
14 ALTER TABLE `faq_entries` CHANGE `revised_date` `revised_date` TIMESTAMP NOT NULL ;
\r
15 ALTER TABLE `files` CHANGE `date` `date` TIMESTAMP NOT NULL ;
\r
16 ALTER TABLE `files_comments` CHANGE `date` `date` TIMESTAMP NOT NULL ;
\r
17 ALTER TABLE `forums` CHANGE `last_post` `last_post` TIMESTAMP NOT NULL ;
\r
18 ALTER TABLE `forums_threads` CHANGE `last_comment` `last_comment` TIMESTAMP NOT NULL ,
\r
19 CHANGE `date` `date` TIMESTAMP NOT NULL ;
\r
20 ALTER TABLE `handbook_notes` CHANGE `date` `date` TIMESTAMP NOT NULL ;
\r
21 ALTER TABLE `instructor_approvals` CHANGE `request_date` `request_date` TIMESTAMP NOT NULL ;
\r
22 ALTER TABLE `members` CHANGE `creation_date` `creation_date` TIMESTAMP NOT NULL ;
\r
23 ALTER TABLE `member_track` CHANGE `last_accessed` `last_accessed` TIMESTAMP NULL ;
\r
24 ALTER TABLE `messages` CHANGE `date_sent` `date_sent` TIMESTAMP NOT NULL ;
\r
25 ALTER TABLE `news` CHANGE `date` `date` TIMESTAMP NOT NULL ;
\r
26 ALTER TABLE `polls` CHANGE `created_date` `created_date` TIMESTAMP NOT NULL ;
\r
27 ALTER TABLE `tests_results` CHANGE `date_taken` `date_taken` TIMESTAMP NOT NULL ;
\r