summaryrefslogtreecommitdiff
path: root/db/laconica.sql
diff options
context:
space:
mode:
authorEvan Prodromou <evan@prodromou.name>2008-08-17 11:21:33 -0400
committerEvan Prodromou <evan@prodromou.name>2008-08-17 11:21:33 -0400
commit5b2a6f5946120a3420b97f9af0ff4f81b60b2a95 (patch)
tree8575ddc1291af1c3fd9202b0bcee76eb5bacd473 /db/laconica.sql
parentf8bdefefd739c5121057e085c2748007fc19ce09 (diff)
trim whitespace in laconica.sql
darcs-hash:20080817152133-84dde-36313e2aa0f37dd43ae8ed17c1194e4a2289a2eb.gz
Diffstat (limited to 'db/laconica.sql')
-rw-r--r--db/laconica.sql10
1 files changed, 5 insertions, 5 deletions
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 (