- conversation.uri needs to be nullable

- factory method for creating new local conversations

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;