summaryrefslogtreecommitdiff
path: root/db/laconica.sql
diff options
context:
space:
mode:
authorEvan Prodromou <evan@prodromou.name>2008-08-27 17:12:39 -0400
committerEvan Prodromou <evan@prodromou.name>2008-08-27 17:12:39 -0400
commit35ed6f473c842d1530645d9d6779fc5917cecd03 (patch)
treea2a3cfd5539d3161e314411673583dda77b4085d /db/laconica.sql
parentf59ead93eed6a7177a5b20bf23979f17354afdd0 (diff)
change queue_item to use a compound primary key
Breaking up to use multiple queue handlers means we need multiple queue items for the same notice. So, change the queue_item table to have a compound pkey, (notice_id,transport). darcs-hash:20080827211239-84dde-db118799bfd43be62fb02380829c64813c9334f8.gz
Diffstat (limited to 'db/laconica.sql')
-rw-r--r--db/laconica.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/db/laconica.sql b/db/laconica.sql
index da2a1c89d..f8e5fce87 100644
--- a/db/laconica.sql
+++ b/db/laconica.sql
@@ -233,11 +233,12 @@ create table remember_me (
create table queue_item (
- notice_id integer not null primary key comment 'notice queued' references notice (id),
+ notice_id integer not null comment 'notice queued' references notice (id),
transport varchar(8) not null comment 'queue for what? "email", "jabber", "sms", "irc", ...',
created datetime not null comment 'date this record was created',
claimed datetime comment 'date this item was claimed',
+ constraint primary key (notice_id, transport),
index queue_item_created_idx (created)
) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_bin;