summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
Diffstat (limited to 'db')
-rw-r--r--db/laconica.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/db/laconica.sql b/db/laconica.sql
index f1d3a484f..872481ace 100644
--- a/db/laconica.sql
+++ b/db/laconica.sql
@@ -336,6 +336,7 @@ create table notice_inbox (
user_id integer not null comment 'user receiving the message' references user (id),
notice_id integer not null comment 'notice received' references notice (id),
+ created datetime not null comment 'date the notice was created',
source tinyint default 1 comment 'reason it is in the inbox; 1=subscription',
constraint primary key (user_id, notice_id),