diff options
| -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; |