summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
authorEvan Prodromou <evan@prodromou.name>2008-07-05 23:12:34 -0400
committerEvan Prodromou <evan@prodromou.name>2008-07-05 23:12:34 -0400
commit13ac93481c7080434329e83caf52db9c95692e17 (patch)
tree7c6f996cd75b19b66e0a5495dfcbd9026200b224 /db
parent293ad758f76143cf0e23c8d4a65f66d8a1ba7bab (diff)
add queueing variables to confirm_address
darcs-hash:20080706031234-84dde-42e06c969ef6e8a63c527c197d7f074f7346d223.gz
Diffstat (limited to 'db')
-rw-r--r--db/laconica.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/db/laconica.sql b/db/laconica.sql
index 66d9a9781..6db9b6cf6 100644
--- a/db/laconica.sql
+++ b/db/laconica.sql
@@ -165,6 +165,8 @@ create table confirm_address (
address varchar(255) not null comment 'address (email, Jabber, SMS, etc.)',
address_extra varchar(255) not null comment 'carrier ID, for SMS',
address_type varchar(8) not null comment 'address type ("email", "jabber", "sms")',
+ claimed datetime comment 'date this was claimed for queueing',
+ sent datetime comment 'date this was sent for queueing',
modified timestamp comment 'date this record was modified'
) ENGINE=InnoDB;