X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=db%2Flaconica.sql;h=f8e5fce87265e813632a3b0ac24a0243add7a750;hb=35ed6f473c842d1530645d9d6779fc5917cecd03;hp=da2a1c89dfff14245a7c066843c5197480ef5ea8;hpb=f59ead93eed6a7177a5b20bf23979f17354afdd0;p=quix0rs-gnu-social.git

diff --git a/db/laconica.sql b/db/laconica.sql
index da2a1c89df..f8e5fce872 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;