| | |
| | | `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, |
| | | `vars` mediumtext NOT NULL, |
| | | PRIMARY KEY(`sess_id`), |
| | | INDEX `changed_index` (`changed`) |
| | | ) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */; |
| | |
| | | `vcard` text NULL, |
| | | `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0', |
| | | PRIMARY KEY(`contact_id`), |
| | | INDEX `user_contacts_index` (`user_id`,`email`), |
| | | CONSTRAINT `user_id_fk_contacts` FOREIGN KEY (`user_id`) |
| | | REFERENCES `users`(`user_id`) |
| | | /*!40008 |