- Fix adding contacts SQL error on mysql (#1486459)
| | |
| | | CHANGELOG RoundCube Webmail |
| | | =========================== |
| | | |
| | | - Fix adding contacts SQL error on mysql (#1486459) |
| | | - Squirrelmail_usercopy: support reply-to field (#1486506) |
| | | - Fix IE spellcheck suggestion popup issue (#1486471) |
| | | - Fix email address auto-completion shows regexp pattern (#1486258) |
| | |
| | | `contact_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
| | | `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', |
| | | `del` tinyint(1) NOT NULL DEFAULT '0', |
| | | `name` varchar(128) NOT NULL, |
| | | `name` varchar(128) NOT NULL DEFAULT '', |
| | | `email` varchar(128) NOT NULL, |
| | | `firstname` varchar(128) NOT NULL, |
| | | `surname` varchar(128) NOT NULL, |
| | | `firstname` varchar(128) NOT NULL DEFAULT '', |
| | | `surname` varchar(128) NOT NULL DEFAULT '', |
| | | `vcard` text NULL, |
| | | `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0', |
| | | PRIMARY KEY(`contact_id`), |
| | |
| | | ALTER TABLE `identities` ADD CONSTRAINT `user_id_fk_identities` FOREIGN KEY (`user_id`) |
| | | REFERENCES `users`(`user_id`) /*!40008 ON DELETE CASCADE ON UPDATE CASCADE */; |
| | | |
| | | ALTER TABLE `contacts` ALTER `name` SET DEFAULT ''; |
| | | ALTER TABLE `contacts` ALTER `firstname` SET DEFAULT ''; |
| | | ALTER TABLE `contacts` ALTER `surname` SET DEFAULT ''; |
| | | |
| | | /*!40014 SET FOREIGN_KEY_CHECKS=1 */; |