| | |
|---|
| | | `created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', |
|---|
| | | `last_login` datetime DEFAULT NULL, |
|---|
| | | `language` varchar(5), |
|---|
| | | `preferences` text, |
|---|
| | | `preferences` longtext, |
|---|
| | | PRIMARY KEY(`user_id`), |
|---|
| | | UNIQUE `username` (`username`, `mail_host`) |
|---|
| | | ) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */; |
|---|
| | |
|---|
| | | `email` varchar(128) NOT NULL, |
|---|
| | | `reply-to` varchar(128) NOT NULL DEFAULT '', |
|---|
| | | `bcc` varchar(128) NOT NULL DEFAULT '', |
|---|
| | | `signature` text, |
|---|
| | | `signature` longtext, |
|---|
| | | `html_signature` tinyint(1) NOT NULL DEFAULT '0', |
|---|
| | | PRIMARY KEY(`identity_id`), |
|---|
| | | CONSTRAINT `user_id_fk_identities` FOREIGN KEY (`user_id`) |
|---|
| | |
|---|
| | | |
|---|
| | | /*!40014 SET FOREIGN_KEY_CHECKS=1 */; |
|---|
| | | |
|---|
| | | INSERT INTO system (name, value) VALUES ('roundcube-version', '2013061000'); |
|---|
| | | INSERT INTO system (name, value) VALUES ('roundcube-version', '2015030800'); |
|---|
