From 5d84485001ace75c49cdc295b4ed3540db83e988 Mon Sep 17 00:00:00 2001 From: Mike Cochrane Date: Sun, 20 Jul 2008 01:57:02 -0400 Subject: First cut at hastags support. darcs-hash:20080720055702-533db-193ed842b0d0a952bef71a3c5287213ada0ef15c.gz --- db/laconica.sql | 11 ++++++++++- 1 file changed, 10 insertions(+), 1 deletion(-) (limited to 'db/laconica.sql') diff --git a/db/laconica.sql b/db/laconica.sql index 4a09670a2..277b792e3 100644 --- a/db/laconica.sql +++ b/db/laconica.sql @@ -123,7 +123,7 @@ create table reply ( profile_id integer not null comment 'profile replied to' references profile (id), modified timestamp not null comment 'date this record was modified', replied_id integer comment 'notice replied to (not used, see notice.reply_to)', - + constraint primary key (notice_id, profile_id), index reply_notice_id_idx (notice_id), index reply_profile_id_idx (profile_id), @@ -226,3 +226,12 @@ create table queue_item ( ) ENGINE=MyISAM; +/* Hash tags */ +create table notice_tag ( + tag varchar( 64 ) not null comment 'hash tag associated with this notice', + notice_id integer not null comment 'notice tagged' references notice (id), + created datetime not null comment 'date this record was created', + + constraint primary key (tag, notice_id), + index notice_tag_created_idx (created) +) ENGINE=MyISAM; -- cgit v1.2.3-54-g00ecf