diff options
| -rw-r--r-- | classes/Invitation.php | 23 | ||||
| -rw-r--r-- | classes/stoica.ini | 9 | ||||
| -rw-r--r-- | db/laconica.sql | 12 |
3 files changed, 44 insertions, 0 deletions
diff --git a/classes/Invitation.php b/classes/Invitation.php new file mode 100644 index 000000000..7480acebe --- /dev/null +++ b/classes/Invitation.php @@ -0,0 +1,23 @@ +<?php +/** + * Table Definition for invitation + */ +require_once 'DB/DataObject.php'; + +class Invitation extends DB_DataObject +{ + ###START_AUTOCODE + /* the code below is auto generated do not remove the above tag */ + + public $__table = 'invitation'; // table name + public $code; // varchar(32) primary_key not_null + public $user_id; // int(4) not_null + public $address; // varchar(255) multiple_key not_null + public $address_type; // varchar(8) multiple_key not_null + + /* Static get */ + function staticGet($k,$v=NULL) { return DB_DataObject::staticGet('Invitation',$k,$v); } + + /* the code above is auto generated do not remove the tag below */ + ###END_AUTOCODE +} diff --git a/classes/stoica.ini b/classes/stoica.ini index 4e78dd325..b4a4d26f9 100644 --- a/classes/stoica.ini +++ b/classes/stoica.ini @@ -84,6 +84,15 @@ id = K service = K uri = U +[invitation] +code = 130 +user_id = 129 +address = 130 +address_type = 130 + +[invitation__keys] +code = K + [nonce] consumer_key = 130 tok = 130 diff --git a/db/laconica.sql b/db/laconica.sql index c90a33d35..52d52cd75 100644 --- a/db/laconica.sql +++ b/db/laconica.sql @@ -287,3 +287,15 @@ create table foreign_subscription ( index foreign_subscription_subscriber_idx (subscriber), index foreign_subscription_subscribed_idx (subscribed) ) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin; + +create table invitation ( + code varchar(32) not null primary key comment 'random code for an invitation', + user_id int not null comment 'who sent the invitation' references user (id), + address varchar(255) not null comment 'invitation sent to', + address_type varchar(8) not null comment 'address type ("email", "jabber", "sms")', + + index invitation_address_idx (address, address_type), + index invitation_user_id_idx (user_id) +) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_bin; + +
\ No newline at end of file |