summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
Diffstat (limited to 'db')
-rw-r--r--db/laconica.sql9
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),