| | |
| | | -- RoundCube Webmail initial database structure |
| | | -- Roundcube Webmail initial database structure |
| | | |
| | | |
| | | /*!40014 SET FOREIGN_KEY_CHECKS=0 */; |
| | |
| | | `mail_host` varchar(128) NOT NULL, |
| | | `alias` varchar(128) NOT NULL, |
| | | `created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', |
| | | `last_login` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', |
| | | `last_login` datetime DEFAULT NULL, |
| | | `language` varchar(5), |
| | | `preferences` text, |
| | | PRIMARY KEY(`user_id`), |
| | | INDEX `username_index` (`username`), |
| | | UNIQUE `username` (`username`, `mail_host`), |
| | | INDEX `alias_index` (`alias`) |
| | | ) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */; |
| | | |
| | |
| | | `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` varchar(128) NOT NULL, |
| | | `email` varchar(255) NOT NULL, |
| | | `firstname` varchar(128) NOT NULL DEFAULT '', |
| | | `surname` varchar(128) NOT NULL DEFAULT '', |
| | | `vcard` text NULL, |
| | | `vcard` longtext NULL, |
| | | `words` text NULL, |
| | | `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0', |
| | | PRIMARY KEY(`contact_id`), |
| | | CONSTRAINT `user_id_fk_contacts` FOREIGN KEY (`user_id`) |
| | |
| | | CONSTRAINT `contactgroup_id_fk_contactgroups` FOREIGN KEY (`contactgroup_id`) |
| | | REFERENCES `contactgroups`(`contactgroup_id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| | | CONSTRAINT `contact_id_fk_contacts` FOREIGN KEY (`contact_id`) |
| | | REFERENCES `contacts`(`contact_id`) ON DELETE CASCADE ON UPDATE CASCADE |
| | | REFERENCES `contacts`(`contact_id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| | | INDEX `contactgroupmembers_contact_index` (`contact_id`) |
| | | ) /*!40000 ENGINE=INNODB */; |
| | | |
| | | |