diff options
| author | Brenda Wallace <shiny@cpan.org> | 2010-05-25 16:25:35 +1200 |
|---|---|---|
| committer | Brenda Wallace <shiny@cpan.org> | 2010-05-25 16:25:35 +1200 |
| commit | f429c1aaa0d8fc69567d698bf033cf25f089d6c9 (patch) | |
| tree | 4ac5590345e3df1fbeb99ac7094bf5ba75464dac /db/08to09_pg.sql | |
| parent | bfef9184820fd1fc40d86c8e65c628c6ae88a691 (diff) | |
the sent column wasn't being populated, needed default
Diffstat (limited to 'db/08to09_pg.sql')
| -rw-r--r-- | db/08to09_pg.sql | 1 |
1 files changed, 1 insertions, 0 deletions
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; |