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

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 (