From f429c1aaa0d8fc69567d698bf033cf25f089d6c9 Mon Sep 17 00:00:00 2001 From: Brenda Wallace Date: Tue, 25 May 2010 16:25:35 +1200 Subject: the sent column wasn't being populated, needed default --- db/08to09_pg.sql | 1 + db/statusnet_pg.sql | 2 +- 2 files changed, 2 insertions(+), 1 deletion(-) diff --git a/db/08to09_pg.sql b/db/08to09_pg.sql index b7a0eb8e8..1c9a31699 100644 --- a/db/08to09_pg.sql +++ b/db/08to09_pg.sql @@ -100,4 +100,5 @@ insert into queue_item_new (frame,transport,created,claimed) alter table queue_item rename to queue_item_old; alter table queue_item_new rename to queue_item; +ALTER TABLE confirm_address ALTER column sent set default CURRENT_TIMESTAMP; diff --git a/db/statusnet_pg.sql b/db/statusnet_pg.sql index 3f62ab752..2db98550c 100644 --- a/db/statusnet_pg.sql +++ b/db/statusnet_pg.sql @@ -276,7 +276,7 @@ create table confirm_address ( address_extra varchar(255) not null default '' /* comment 'carrier ID, for SMS' */, address_type varchar(8) not null /* comment 'address type ("email", "jabber", "sms")' */, claimed timestamp /* comment 'date this was claimed for queueing' */, - sent timestamp /* comment 'date this was sent for queueing' */, + sent timestamp default CURRENT_TIMESTAMP /* comment 'date this was sent for queueing' */, modified timestamp /* comment 'date this record was modified' */ ); -- cgit v1.2.3