From 13ac93481c7080434329e83caf52db9c95692e17 Mon Sep 17 00:00:00 2001 From: Evan Prodromou Date: Sat, 5 Jul 2008 23:12:34 -0400 Subject: add queueing variables to confirm_address darcs-hash:20080706031234-84dde-42e06c969ef6e8a63c527c197d7f074f7346d223.gz --- classes/Confirm_address.php | 2 ++ classes/stoica.ini | 2 ++ db/laconica.sql | 2 ++ 3 files changed, 6 insertions(+) diff --git a/classes/Confirm_address.php b/classes/Confirm_address.php index 50711999f..80dc94621 100644 --- a/classes/Confirm_address.php +++ b/classes/Confirm_address.php @@ -15,6 +15,8 @@ class Confirm_address extends DB_DataObject public $address; // varchar(255) not_null public $address_extra; // varchar(255) not_null public $address_type; // varchar(8) not_null + public $claimed; // datetime() + public $sent; // datetime() public $modified; // timestamp() not_null default_CURRENT_TIMESTAMP /* Static get */ diff --git a/classes/stoica.ini b/classes/stoica.ini index 3d59be8ee..67992ea7f 100644 --- a/classes/stoica.ini +++ b/classes/stoica.ini @@ -22,6 +22,8 @@ user_id = 129 address = 130 address_extra = 130 address_type = 130 +claimed = 14 +sent = 14 modified = 384 [confirm_address__keys] 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; -- cgit v1.2.3-54-g00ecf