summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
authorBrenda Wallace <shiny@cpan.org>2010-05-22 20:50:30 +1200
committerBrenda Wallace <shiny@cpan.org>2010-05-22 20:50:30 +1200
commit249c820559a09e167c99d085172b93f65bf36bfc (patch)
treeaf4586483a918049aeed5af46be5d899fae03987 /db
parentf4d0f721c83fdfebeb94b62af6f781c51d557e03 (diff)
migration of data in queue_item to new table
Diffstat (limited to 'db')
-rw-r--r--db/08to09_pg.sql15
1 files changed, 15 insertions, 0 deletions
diff --git a/db/08to09_pg.sql b/db/08to09_pg.sql
index ecf100884..b7a0eb8e8 100644
--- a/db/08to09_pg.sql
+++ b/db/08to09_pg.sql
@@ -86,3 +86,18 @@ ALTER TABLE consumer add COLUMN consumer_secret varchar(255) not null ; /*commen
ALTER TABLE token ADD COLUMN verifier varchar(255); /* comment 'verifier string for OAuth 1.0a',*/
ALTER TABLE token ADD COLUMN verified_callback varchar(255); /* comment 'verified callback URL for OAuth 1.0a',*/
+create table queue_item_new (
+ 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)
+);
+
+insert into queue_item_new (frame,transport,created,claimed)
+ select ('0x' || notice_id::text)::bytea,transport,created,claimed from queue_item;
+alter table queue_item rename to queue_item_old;
+alter table queue_item_new rename to queue_item;
+
+