From 5b2a6f5946120a3420b97f9af0ff4f81b60b2a95 Mon Sep 17 00:00:00 2001 From: Evan Prodromou Date: Sun, 17 Aug 2008 11:21:33 -0400 Subject: trim whitespace in laconica.sql darcs-hash:20080817152133-84dde-36313e2aa0f37dd43ae8ed17c1194e4a2289a2eb.gz --- db/laconica.sql | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) (limited to 'db/laconica.sql') diff --git a/db/laconica.sql b/db/laconica.sql index 7fadd05b9..16faf53a0 100644 --- a/db/laconica.sql +++ b/db/laconica.sql @@ -65,7 +65,7 @@ create table user ( autosubscribe tinyint default 0 comment 'automatically subscribe to users who subscribe to us', created datetime not null comment 'date this record was created', modified timestamp comment 'date this record was modified', - + index user_smsemail_idx (smsemail) ) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_bin; @@ -106,7 +106,7 @@ create table notice ( 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(32) comment 'source of comment, like "web", "im", or "clientname"', - + index notice_profile_id_idx (profile_id), index notice_created_idx (created), FULLTEXT(content) @@ -139,14 +139,14 @@ 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