diff options
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/database.sql b/database.sql index 18fe5f8c3..cdbc8a93b 100644 --- a/database.sql +++ b/database.sql @@ -714,5 +714,11 @@ CREATE TABLE IF NOT EXISTS `conv` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , `guid` CHAR( 64 ) NOT NULL , `recips` MEDIUMTEXT NOT NULL , - `uid` INT NOT NULL + `uid` INT NOT NULL, + `creator` CHAR( 255 ) NOT NULL , + `created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', + `updated` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', + `subject` MEDIUMTEXT NOT NULL, + INDEX ( `created` ), + INDEX ( `updated` ) ) ENGINE = MyISAM DEFAULT CHARSET=utf8; |