- Fix failure on MySQL database upgrade from 0.7 - text column can't have default value (#1488300)
| | |
| | | CHANGELOG Roundcube Webmail |
| | | =========================== |
| | | |
| | | - Fix failure on MySQL database upgrade from 0.7 - text column can't have default value (#1488300) |
| | | - Added address book widget on compose screen |
| | | - Use proper timezones from PHP's internal timezonedb (#1485592) |
| | | - Add separate pagesize setting for mail messages and contacts (#1488269) |
| | |
| | | `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', |
| | | `del` tinyint(1) NOT NULL DEFAULT '0', |
| | | `name` varchar(128) NOT NULL DEFAULT '', |
| | | `email` text NOT NULL DEFAULT '', |
| | | `email` text NOT NULL, |
| | | `firstname` varchar(128) NOT NULL DEFAULT '', |
| | | `surname` varchar(128) NOT NULL DEFAULT '', |
| | | `vcard` longtext NULL, |
| | |
| | | |
| | | ALTER TABLE `contacts` DROP FOREIGN KEY `user_id_fk_contacts`; |
| | | ALTER TABLE `contacts` DROP INDEX `user_contacts_index`; |
| | | ALTER TABLE `contacts` MODIFY `email` text NOT NULL DEFAULT ''; |
| | | ALTER TABLE `contacts` MODIFY `email` text NOT NULL; |
| | | ALTER TABLE `contacts` ADD INDEX `user_contacts_index` (`user_id`,`del`); |
| | | ALTER TABLE `contacts` ADD CONSTRAINT `user_id_fk_contacts` FOREIGN KEY (`user_id`) |
| | | REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE; |