From f8bdefefd739c5121057e085c2748007fc19ce09 Mon Sep 17 00:00:00 2001 From: Evan Prodromou Date: Sun, 17 Aug 2008 11:21:08 -0400 Subject: restore fave table lost when doing utf8 upgrade darcs-hash:20080817152108-84dde-9ca19fbe374ad021771f175f587f19902b3f927b.gz --- db/laconica.sql | 13 +++++++++++++ 1 file changed, 13 insertions(+) diff --git a/db/laconica.sql b/db/laconica.sql index 3615340c1..7fadd05b9 100644 --- a/db/laconica.sql +++ b/db/laconica.sql @@ -134,6 +134,19 @@ create table reply ( ) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_bin; +create table fave ( + + notice_id integer not null comment 'notice that is the favorite' references notice (id), + user_id integer not null comment 'user who likes this notice' references user (id), + modified timestamp not null comment 'date this record was modified', + + constraint primary key (notice_id, user_id), + index fave_notice_id_idx (notice_id), + index fave_user_id_idx (user_id), + index fave_modified_idx (modified) + +) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_bin; + /* tables for OAuth */ create table consumer ( -- cgit v1.2.3-54-g00ecf