| commit | author | age | ||
| 79fe17 | 1 | -- RoundCube Webmail update script for MySQL databases |
| 535da2 | 2 | -- Updates from version 0.1-20051007 |
| 79fe17 | 3 | |
| T | 4 | |
| 15a9d1 | 5 | ALTER TABLE `session` ADD `ip` VARCHAR(15) NOT NULL AFTER changed; |
| T | 6 | ALTER TABLE `users` ADD `alias` VARCHAR(128) NOT NULL AFTER mail_host; |
| e0ddd4 | 7 | |
| T | 8 | |
| 9 | ||
| 10 | -- RoundCube Webmail update script for MySQL databases | |
| 535da2 | 11 | -- Updates from version 0.1-20051021 |
| e0ddd4 | 12 | |
| T | 13 | ALTER TABLE `session` CHANGE `sess_id` `sess_id` VARCHAR(40) NOT NULL; |
| 1cded8 | 14 | |
| T | 15 | ALTER TABLE `contacts` CHANGE `del` `del` TINYINT(1) NOT NULL; |
| e0ddd4 | 16 | ALTER TABLE `contacts` ADD `changed` DATETIME NOT NULL AFTER `user_id`; |
| 1cded8 | 17 | |
| T | 18 | UPDATE `contacts` SET `del`=0 WHERE `del`=1; |
| 19 | UPDATE `contacts` SET `del`=1 WHERE `del`=2; | |
| 20 | ||
| 21 | ALTER TABLE `identities` CHANGE `default` `standard` TINYINT(1) NOT NULL; | |
| 22 | ALTER TABLE `identities` CHANGE `del` `del` TINYINT(1) NOT NULL; | |
| 23 | ||
| 24 | UPDATE `identities` SET `del`=0 WHERE `del`=1; | |
| 25 | UPDATE `identities` SET `del`=1 WHERE `del`=2; | |
| 26 | UPDATE `identities` SET `standard`=0 WHERE `standard`=1; | |
| 27 | UPDATE `identities` SET `standard`=1 WHERE `standard`=2; | |
| 28 | ||
| 29 | CREATE TABLE `messages` ( | |
| 30 | `message_id` int(11) unsigned NOT NULL auto_increment, | |
| 31 | `user_id` int(11) unsigned NOT NULL default '0', | |
| 32 | `del` tinyint(1) NOT NULL default '0', | |
| 33 | `cache_key` varchar(128) NOT NULL default '', | |
| c6e808 | 34 | `created` datetime NOT NULL default '0000-00-00 00:00:00', |
| 1cded8 | 35 | `idx` int(11) unsigned NOT NULL default '0', |
| T | 36 | `uid` int(11) unsigned NOT NULL default '0', |
| 37 | `subject` varchar(255) NOT NULL default '', | |
| 38 | `from` varchar(255) NOT NULL default '', | |
| 39 | `to` varchar(255) NOT NULL default '', | |
| 40 | `cc` varchar(255) NOT NULL default '', | |
| 41 | `date` datetime NOT NULL default '0000-00-00 00:00:00', | |
| 42 | `size` int(11) unsigned NOT NULL default '0', | |
| 43 | `headers` text NOT NULL, | |
| 44 | `body` longtext, | |
| 45 | PRIMARY KEY (`message_id`), | |
| 46 | KEY `user_id` (`user_id`), | |
| 47 | KEY `cache_key` (`cache_key`), | |
| 48 | KEY `idx` (`idx`), | |
| 49 | KEY `uid` (`uid`) | |
| 50 | ) TYPE=MyISAM; | |
| b59474 | 51 | |
| T | 52 | |
| 53 | ||
| 54 | -- RoundCube Webmail update script for MySQL databases | |
| 535da2 | 55 | -- Updates from version 0.1-20051216 |
| b59474 | 56 | |
| T | 57 | ALTER TABLE `messages` ADD `created` DATETIME NOT NULL AFTER `cache_key` ; |
