From 0b21ac3dd79d2bf39341a4f0ff3566def8282eae Mon Sep 17 00:00:00 2001 From: "matthew.gregg" 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') 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