From bfef9184820fd1fc40d86c8e65c628c6ae88a691 Mon Sep 17 00:00:00 2001
From: Brenda Wallace <shiny@cpan.org>
Date: Sat, 22 May 2010 20:52:53 +1200
Subject: queue_item in _pg now matches mysql

---
 db/statusnet_pg.sql | 14 ++++++--------
 1 file changed, 6 insertions(+), 8 deletions(-)

(limited to 'db/statusnet_pg.sql')

diff --git a/db/statusnet_pg.sql b/db/statusnet_pg.sql
index 27c4adc98..3f62ab752 100644
--- a/db/statusnet_pg.sql
+++ b/db/statusnet_pg.sql
@@ -287,14 +287,12 @@ create table remember_me (
 );
 
 create table queue_item (
-
-    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 timestamp not null default CURRENT_TIMESTAMP /* comment 'date this record was created' */,
-    claimed timestamp /* comment 'date this item was claimed' */,
-
-    primary key (notice_id, transport)
-
+     id serial /* comment 'unique identifier'*/,
+     frame bytea not null /* comment 'data: object reference or opaque string'*/,
+     transport varchar(8) not null /*comment 'queue for what? "email", "jabber", "sms", "irc", ...'*/,
+     created timestamp not null default CURRENT_TIMESTAMP /*comment 'date this record was created'*/,
+     claimed timestamp /*comment 'date this item was claimed'*/,
+     PRIMARY KEY (id)
 );
 create index queue_item_created_idx on queue_item using btree(created);
 
-- 
cgit v1.2.3-54-g00ecf

