From be8e9d36160d8a45bb11c3ab9ecdbf0c4f5cdf7d Mon Sep 17 00:00:00 2001 From: friendica Date: Tue, 6 Dec 2011 00:16:13 -0800 Subject: d* pm --- database.sql | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) (limited to 'database.sql') 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; -- cgit v1.2.3