From e1361cdf489fc87aecb84261c5e2b7b47ce9c829 Mon Sep 17 00:00:00 2001 From: Evan Prodromou Date: Tue, 22 Jul 2008 10:16:14 -0400 Subject: mark notices as local darcs-hash:20080722141614-84dde-b80c6945fdb90a5f67acaba65a1e4c2b306b1f8e.gz --- db/laconica.sql | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) (limited to 'db') diff --git a/db/laconica.sql b/db/laconica.sql index 66510b148..b6de405f9 100644 --- a/db/laconica.sql +++ b/db/laconica.sql @@ -100,8 +100,11 @@ create table notice ( created datetime not null comment 'date this record was created', 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', + index notice_profile_id_idx (profile_id), + index notice_created_idx (profile_id), + FULLTEXT(content) ) ENGINE=MyISAM; -- cgit v1.2.3-54-g00ecf