summaryrefslogtreecommitdiff
path: root/db/statusnet_pg.sql
diff options
context:
space:
mode:
authorBrenda Wallace <shiny@cpan.org>2010-05-25 16:25:35 +1200
committerBrenda Wallace <shiny@cpan.org>2010-05-25 16:25:35 +1200
commitf429c1aaa0d8fc69567d698bf033cf25f089d6c9 (patch)
tree4ac5590345e3df1fbeb99ac7094bf5ba75464dac /db/statusnet_pg.sql
parentbfef9184820fd1fc40d86c8e65c628c6ae88a691 (diff)
the sent column wasn't being populated, needed default
Diffstat (limited to 'db/statusnet_pg.sql')
-rw-r--r--db/statusnet_pg.sql2
1 files changed, 1 insertions, 1 deletions
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' */
);