File was renamed from SQL/mysql5.initial.sql |
| | |
| | | |
| | | CREATE TABLE `session` ( |
| | | `sess_id` varchar(40) NOT NULL, |
| | | `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', |
| | | `changed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', |
| | | `created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', |
| | | `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', |
| | | `ip` varchar(40) NOT NULL, |
| | | `vars` text NOT NULL, |
| | | PRIMARY KEY(`sess_id`), |
| | |
| | | `username` varchar(128) NOT NULL, |
| | | `mail_host` varchar(128) NOT NULL, |
| | | `alias` varchar(128) NOT NULL, |
| | | `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', |
| | | `last_login` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', |
| | | `created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', |
| | | `last_login` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', |
| | | `language` varchar(5), |
| | | `preferences` text, |
| | | PRIMARY KEY(`user_id`), |
| | |
| | | `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0', |
| | | `del` tinyint(1) NOT NULL DEFAULT '0', |
| | | `cache_key` varchar(128) /*!40101 CHARACTER SET ascii COLLATE ascii_general_ci */ NOT NULL, |
| | | `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', |
| | | `created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', |
| | | `idx` int(11) UNSIGNED NOT NULL DEFAULT '0', |
| | | `uid` int(11) UNSIGNED NOT NULL DEFAULT '0', |
| | | `subject` varchar(255) NOT NULL, |
| | | `from` varchar(255) NOT NULL, |
| | | `to` varchar(255) NOT NULL, |
| | | `cc` varchar(255) NOT NULL, |
| | | `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', |
| | | `date` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', |
| | | `size` int(11) UNSIGNED NOT NULL DEFAULT '0', |
| | | `headers` text NOT NULL, |
| | | `structure` text, |
| | |
| | | CREATE TABLE `cache` ( |
| | | `cache_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
| | | `cache_key` varchar(128) /*!40101 CHARACTER SET ascii COLLATE ascii_general_ci */ NOT NULL , |
| | | `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', |
| | | `created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', |
| | | `data` longtext NOT NULL, |
| | | `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0', |
| | | PRIMARY KEY(`cache_id`), |
| | |
| | | |
| | | CREATE TABLE `contacts` ( |
| | | `contact_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
| | | `changed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', |
| | | `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', |
| | | `del` tinyint(1) NOT NULL DEFAULT '0', |
| | | `name` varchar(128) NOT NULL, |
| | | `email` varchar(128) NOT NULL, |