diff options
| author | friendica <info@friendica.com> | 2011-12-06 00:16:13 -0800 |
|---|---|---|
| committer | friendica <info@friendica.com> | 2011-12-06 00:16:13 -0800 |
| commit | be8e9d36160d8a45bb11c3ab9ecdbf0c4f5cdf7d (patch) | |
| tree | 9bad78a28b7c7fc77b25741018d4fda5f11eb9d3 /database.sql | |
| parent | 47f369e052d296f4a744c1508efc58f6168b7e8b (diff) | |
| download | volse-hubzilla-be8e9d36160d8a45bb11c3ab9ecdbf0c4f5cdf7d.tar.gz volse-hubzilla-be8e9d36160d8a45bb11c3ab9ecdbf0c4f5cdf7d.tar.bz2 volse-hubzilla-be8e9d36160d8a45bb11c3ab9ecdbf0c4f5cdf7d.zip | |
d* pm
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; |