summaryrefslogtreecommitdiff
path: root/db/laconica.sql
diff options
context:
space:
mode:
authorEvan Prodromou <evan@prodromou.name>2008-08-17 11:21:08 -0400
committerEvan Prodromou <evan@prodromou.name>2008-08-17 11:21:08 -0400
commitf8bdefefd739c5121057e085c2748007fc19ce09 (patch)
tree7fd76590f6ee09fe6f464252e9effb86699b2bff /db/laconica.sql
parent95b4d89742093af5b033f314bb45d33185614a79 (diff)
restore fave table lost when doing utf8 upgrade
darcs-hash:20080817152108-84dde-9ca19fbe374ad021771f175f587f19902b3f927b.gz
Diffstat (limited to 'db/laconica.sql')
-rw-r--r--db/laconica.sql13
1 files changed, 13 insertions, 0 deletions
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 (