From 0b21ac3dd79d2bf39341a4f0ff3566def8282eae Mon Sep 17 00:00:00 2001
From: "matthew.gregg" <matthew.gregg@gmail.com>
Date: Sun, 22 Jun 2008 23:08:37 -0400
Subject: 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
---
 db/laconica.sql | 13 +++++++++++++
 1 file changed, 13 insertions(+)

(limited to 'db/laconica.sql')

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 (
-- 
cgit v1.2.3-54-g00ecf

