summaryrefslogtreecommitdiff
path: root/db/laconica.sql
diff options
context:
space:
mode:
authormatthew.gregg <matthew.gregg@gmail.com>2008-06-22 23:08:37 -0400
committermatthew.gregg <matthew.gregg@gmail.com>2008-06-22 23:08:37 -0400
commit0b21ac3dd79d2bf39341a4f0ff3566def8282eae (patch)
tree61ed08b832cda8e104dee168b300133c90540231 /db/laconica.sql
parent6dbf7beb0bfce429f1c39b64e85cdac8229cb72d (diff)
First pass at replies support http://laconi.ca/PITS/00080
Doesn't handle a reply to a user that has never updated. darcs-hash:20080623030837-982e4-532ccd8899fd8be00575f8840da0defb44cd56f8.gz
Diffstat (limited to 'db/laconica.sql')
-rw-r--r--db/laconica.sql13
1 files changed, 13 insertions, 0 deletions
diff --git a/db/laconica.sql b/db/laconica.sql
index 6db9b6cf6..af94e3b61 100644
--- a/db/laconica.sql
+++ b/db/laconica.sql
@@ -92,6 +92,19 @@ create table notice (
index notice_profile_id_idx (profile_id)
) ENGINE=InnoDB;
+create table reply (
+ id integer auto_increment primary key comment 'unique identifier',
+ notice_id integer comment 'foreign key to notice table',
+ user_id integer comment 'foreign key to user table',
+ replied_id integer comment 'foreign key to notice table',
+ created datetime not null comment 'date this reply was created',
+
+ index notice_id_idx (notice_id),
+ index user_id_idx (user_id),
+ index replied_id_idx (replied_id)
+
+) ENGINE=InnoDB;
+
/* tables for OAuth */
create table consumer (