add queueing variables to confirm_address

[quix0rs-gnu-social.git] / db / laconica.sql

diff --git a/db/laconica.sql b/db/laconica.sql
index 66d9a978142a22257bf965a0400b3a64ce7df0eb..6db9b6cf6bfc4265038bd05d2f26b09d742482a6 100644 (file)
--- 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;