diff options
Diffstat (limited to 'db/laconica.sql')
| -rw-r--r-- | db/laconica.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/db/laconica.sql b/db/laconica.sql index b6de405f9..4a09670a2 100644 --- a/db/laconica.sql +++ b/db/laconica.sql @@ -101,6 +101,7 @@ create table notice ( modified timestamp comment 'date this record was modified', reply_to integer comment 'notice replied to (usually a guess)' references notice (id), is_local tinyint default 0 comment 'notice was generated by a user', + source varchar(8) comment 'source of comment, like "web", "im", or "clientname"', index notice_profile_id_idx (profile_id), index notice_created_idx (profile_id), @@ -108,6 +109,14 @@ create table notice ( FULLTEXT(content) ) ENGINE=MyISAM; +create table notice_source ( + code varchar(8) primary key not null comment 'source code', + name varchar(255) not null comment 'name of the source', + url varchar(255) not null comment 'url to link to', + created datetime not null comment 'date this record was created', + modified timestamp comment 'date this record was modified' +) ENGINE=MyISAM; + create table reply ( notice_id integer not null comment 'notice that is the reply' references notice (id), |