| commit | author | age | ||
| f7bfec | 1 | -- RoundCube Webmail update script for MySQL databases |
| T | 2 | -- Updates from version 0.1-20051007 |
| 3 | ||
| 4 | ||
| 5 | ALTER TABLE `session` ADD `ip` VARCHAR(15) NOT NULL AFTER changed; | |
| 6 | ALTER TABLE `users` ADD `alias` VARCHAR(128) NOT NULL AFTER mail_host; | |
| 7 | ||
| 8 | ||
| 9 | ||
| 10 | -- RoundCube Webmail update script for MySQL databases | |
| 11 | -- Updates from version 0.1-20051021 | |
| 12 | ||
| 13 | ALTER TABLE `session` CHANGE `sess_id` `sess_id` VARCHAR(40) NOT NULL; | |
| 14 | ||
| 15 | ALTER TABLE `contacts` CHANGE `del` `del` TINYINT(1) NOT NULL; | |
| 16 | ALTER TABLE `contacts` ADD `changed` DATETIME NOT NULL AFTER `user_id`; | |
| 17 | ||
| 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 '', | |
| 34 | `created` datetime NOT NULL default '0000-00-00 00:00:00', | |
| 35 | `idx` int(11) unsigned NOT NULL default '0', | |
| 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 | `structure` text, | |
| 45 | PRIMARY KEY (`message_id`), | |
| 46 | KEY `user_id` (`user_id`), | |
| 47 | KEY `idx` (`idx`), | |
| 48 | KEY `uid` (`uid`), | |
| 49 | UNIQUE `uniqueness` (`cache_key`, `uid`) | |
| 50 | ) TYPE=MyISAM; | |
| 51 | ||
