summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorEvan Prodromou <evan@prodromou.name>2008-07-15 18:19:46 -0400
committerEvan Prodromou <evan@prodromou.name>2008-07-15 18:19:46 -0400
commit72fda63585b4c6dae290ae08de4a0f33e1bb252c (patch)
treed4af18d929c94ffe1195c1e85c64352105165a45
parent61487d4cd0d85a24a2c4737fa90bfe71cb967212 (diff)
unique key on a boolean value is not scalable
darcs-hash:20080715221946-84dde-cd843d283da019b102073bc64732f4abb89a6456.gz
-rw-r--r--db/laconica.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/db/laconica.sql b/db/laconica.sql
index e906b05fe..bb9f16459 100644
--- a/db/laconica.sql
+++ b/db/laconica.sql
@@ -45,7 +45,7 @@ create table user (
nickname varchar(64) unique key comment 'nickname or username, duped in profile',
password varchar(255) comment 'salted password, can be null for OpenID users',
email varchar(255) unique key comment 'email address for password recovery etc.',
- emailnotifysub tinyint default 1 unique key comment 'Notify by email of subscriptions',
+ emailnotifysub tinyint default 1 comment 'Notify by email of subscriptions',
jabber varchar(255) unique key comment 'jabber ID for notices',
jabbernotify tinyint default 0 comment 'whether to send notices to jabber',
jabberreplies tinyint default 0 comment 'whether to send notices to jabber on replies',