summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--classes/Invitation.php23
-rw-r--r--classes/stoica.ini9
-rw-r--r--db/laconica.sql12
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