X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=db%2Fstatusnet.sql;h=97117c80aab6b69898012f695d0902eb6ee1554c;hb=a306ac39768ff6cbae4f14b565acf2850c979f8b;hp=343464801662d0fd7ff37828632952214f873fb5;hpb=823939ca84bd19ced394771d3f08b7c72a9dec84;p=quix0rs-gnu-social.git diff --git a/db/statusnet.sql b/db/statusnet.sql index 3434648016..97117c80aa 100644 --- a/db/statusnet.sql +++ b/db/statusnet.sql @@ -633,3 +633,11 @@ create table inbox ( constraint primary key (user_id) ) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin; + +create table conversation ( + id integer auto_increment primary key comment 'unique identifier', + 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; +