summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
authorBrenda Wallace <shiny@cpan.org>2010-05-22 20:52:53 +1200
committerBrenda Wallace <shiny@cpan.org>2010-05-22 20:52:53 +1200
commitbfef9184820fd1fc40d86c8e65c628c6ae88a691 (patch)
tree07e2e6211a5331898345e42281d86d9ec120cff7 /db
parent249c820559a09e167c99d085172b93f65bf36bfc (diff)
queue_item in _pg now matches mysql
Diffstat (limited to 'db')
-rw-r--r--db/statusnet_pg.sql14
1 files changed, 6 insertions, 8 deletions
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);