From 471e4056f4b2c0ea7d5bb3646b9f6ae24ece8da8 Mon Sep 17 00:00:00 2001
From: Evan Prodromou <evan@prodromou.name>
Date: Tue, 22 Jul 2008 12:46:39 -0400
Subject: add notice sources (currently unused)

darcs-hash:20080722164639-84dde-19c6300516443862da016120cf9eed40e5972b6d.gz
---
 db/laconica.sql | 9 +++++++++
 1 file changed, 9 insertions(+)

(limited to 'db/laconica.sql')

diff --git a/db/laconica.sql b/db/laconica.sql
index b6de405f9..4a09670a2 100644
--- a/db/laconica.sql
+++ b/db/laconica.sql
@@ -101,6 +101,7 @@ create table notice (
     modified timestamp comment 'date this record was modified',
     reply_to integer comment 'notice replied to (usually a guess)' references notice (id),
     is_local tinyint default 0 comment 'notice was generated by a user',
+    source varchar(8) comment 'source of comment, like "web", "im", or "clientname"',
     
     index notice_profile_id_idx (profile_id),
     index notice_created_idx (profile_id),
@@ -108,6 +109,14 @@ create table notice (
     FULLTEXT(content)
 ) ENGINE=MyISAM;
 
+create table notice_source (
+     code varchar(8) primary key not null comment 'source code',
+     name varchar(255) not null comment 'name of the source',
+     url varchar(255) not null comment 'url to link to',
+     created datetime not null comment 'date this record was created',
+     modified timestamp comment 'date this record was modified'
+) ENGINE=MyISAM;
+
 create table reply (
 
     notice_id integer not null comment 'notice that is the reply' references notice (id),
-- 
cgit v1.2.3-54-g00ecf

