From ba0dd0a4c3339c88a0d2be88c70759e9aec717db Mon Sep 17 00:00:00 2001
From: Evan Prodromou <evan@prodromou.name>
Date: Sat, 23 Aug 2008 15:10:15 -0400
Subject: data classes for invitations

darcs-hash:20080823191015-84dde-05263d6e9a2535c726b98aacc5f3269f66fe22bd.gz
---
 db/laconica.sql | 12 ++++++++++++
 1 file changed, 12 insertions(+)

(limited to 'db/laconica.sql')

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
-- 
cgit v1.2.3-54-g00ecf

