From be8e9d36160d8a45bb11c3ab9ecdbf0c4f5cdf7d Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
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

