| | |
|---|
| | | `uid` int(11) UNSIGNED NOT NULL DEFAULT '0', |
|---|
| | | `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', |
|---|
| | | `data` longtext NOT NULL, |
|---|
| | | `seen` tinyint(1) NOT NULL DEFAULT '0', |
|---|
| | | `deleted` tinyint(1) NOT NULL DEFAULT '0', |
|---|
| | | `answered` tinyint(1) NOT NULL DEFAULT '0', |
|---|
| | | `forwarded` tinyint(1) NOT NULL DEFAULT '0', |
|---|
| | | `flagged` tinyint(1) NOT NULL DEFAULT '0', |
|---|
| | | `mdnsent` tinyint(1) NOT NULL DEFAULT '0', |
|---|
| | | `flags` int(11) NOT NULL DEFAULT '0', |
|---|
| | | CONSTRAINT `user_id_fk_cache_messages` FOREIGN KEY (`user_id`) |
|---|
| | | REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|---|
| | | INDEX `changed_index` (`changed`), |
|---|
