summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
authorZach Copley <zach@status.net>2010-02-17 01:11:14 -0800
committerZach Copley <zach@status.net>2010-02-17 01:11:14 -0800
commited46a38ecfea0a87e01aacfcde181087d5e0f19f (patch)
tree075f3217fac9f7c66c902b3db1d4e7411c05f353 /db
parenta2f8c5da171d23790811677affd7ca5301a995a5 (diff)
- conversation.uri needs to be nullable
- factory method for creating new local conversations
Diffstat (limited to 'db')
-rw-r--r--db/statusnet.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/db/statusnet.sql b/db/statusnet.sql
index 74e5b6954..97117c80a 100644
--- a/db/statusnet.sql
+++ b/db/statusnet.sql
@@ -636,7 +636,7 @@ create table inbox (
create table conversation (
id integer auto_increment primary key comment 'unique identifier',
- uri varchar(225) not null unique comment 'URI of the conversation',
+ uri varchar(225) unique comment 'URI of the conversation',
created datetime not null comment 'date this record was created',
modified timestamp comment 'date this record was modified'
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin;