diff options
| author | Evan Prodromou <evan@prodromou.name> | 2008-07-05 23:12:34 -0400 |
|---|---|---|
| committer | Evan Prodromou <evan@prodromou.name> | 2008-07-05 23:12:34 -0400 |
| commit | 13ac93481c7080434329e83caf52db9c95692e17 (patch) | |
| tree | 7c6f996cd75b19b66e0a5495dfcbd9026200b224 | |
| parent | 293ad758f76143cf0e23c8d4a65f66d8a1ba7bab (diff) | |
add queueing variables to confirm_address
darcs-hash:20080706031234-84dde-42e06c969ef6e8a63c527c197d7f074f7346d223.gz
| -rw-r--r-- | classes/Confirm_address.php | 2 | ||||
| -rw-r--r-- | classes/stoica.ini | 2 | ||||
| -rw-r--r-- | db/laconica.sql | 2 |
3 files changed, 6 insertions, 0 deletions
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; |