-Fixed Mysql DDL for default identities creation (#1485070)
| | |
| | | CHANGELOG RoundCube Webmail |
| | | --------------------------- |
| | | |
| | | 2008/05/19 (alec) |
| | | ---------- |
| | | - Fixed Mysql DDL for default identities creation (#1485070) |
| | | |
| | | 2008/05/16 (alec) |
| | | ---------- |
| | | - In Preferences added possibility to configure 'read_when_deleted', |
| | |
| | | `user_id` int(10) unsigned NOT NULL default '0', |
| | | `del` tinyint(1) NOT NULL default '0', |
| | | `standard` tinyint(1) NOT NULL default '0', |
| | | `name` varchar(128) NOT NULL default '', |
| | | `name` varchar(128) NOT NULL, |
| | | `organization` varchar(128) NOT NULL default '', |
| | | `email` varchar(128) NOT NULL default '', |
| | | `email` varchar(128) NOT NULL, |
| | | `reply-to` varchar(128) NOT NULL default '', |
| | | `bcc` varchar(128) NOT NULL default '', |
| | | `signature` text NOT NULL, |
| | | `signature` text NOT NULL default '', |
| | | `html_signature` tinyint(1) NOT NULL default '0', |
| | | PRIMARY KEY (`identity_id`), |
| | | KEY `user_id` (`user_id`) |
| | |
| | | ALTER TABLE `users` |
| | | ADD INDEX `username_index` (`username`), |
| | | ADD INDEX `alias_index` (`alias`); |
| | | |
| | | -- Updates from version 0.1.1 |
| | | |
| | | ALTER TABLE `identities` |
| | | MODIFY `signature` text NOT NULL DEFAULT '', |
| | | MODIFY `bcc` varchar(128) NOT NULL DEFAULT '', |
| | | MODIFY `reply-to` varchar(128) NOT NULL DEFAULT '', |
| | | MODIFY `organization` varchar(128) NOT NULL DEFAULT '', |
| | | MODIFY `name` varchar(128) NOT NULL, |
| | | MODIFY `email` varchar(128) NOT NULL; |
| | |
| | | `del` tinyint(1) NOT NULL DEFAULT '0', |
| | | `standard` tinyint(1) NOT NULL DEFAULT '0', |
| | | `name` varchar(128) NOT NULL, |
| | | `organization` varchar(128) NOT NULL, |
| | | `organization` varchar(128) NOT NULL DEFAULT '', |
| | | `email` varchar(128) NOT NULL, |
| | | `reply-to` varchar(128) NOT NULL, |
| | | `bcc` varchar(128) NOT NULL, |
| | | `signature` text NOT NULL, |
| | | `reply-to` varchar(128) NOT NULL DEFAULT '', |
| | | `bcc` varchar(128) NOT NULL DEFAULT '', |
| | | `signature` text NOT NULL DEFAULT '', |
| | | `html_signature` tinyint(1) NOT NULL DEFAULT '0', |
| | | `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0', |
| | | PRIMARY KEY(`identity_id`), |