modules/rsvp/rsvp.mysql

CREATE TABLE rsvp (
  rid int(10) unsigned NOT NULL auto_increment,
  nid int(10) unsigned NOT NULL default '0',
  uid int(10) unsigned NOT NULL default '0',
  name varchar(128) default '',
  invite_text text,
  blind int(3) unsigned NOT NULL default '0',
  list_email int(3) unsigned NOT NULL default '0',
  allow_invite int(3) unsigned NOT NULL default '0',
  timestamp int(10) unsigned NOT NULL default '0',
  PRIMARY KEY (rid,uid,nid)
); 

CREATE TABLE rsvp_invite (
  response enum('yes','no','maybe','none') NOT NULL default 'none',
  rid int(10) unsigned NOT NULL default '0',
  uid int(10) NOT NULL default '0',
  email varchar(128) NOT NULL default '',
  hash varchar(255) NOT NULL default '',
  invited int(10) unsigned NOT NULL default '0',
  received int(10) unsigned NOT NULL default '0',
  timestamp int(10) unsigned NOT NULL default '0',
  PRIMARY KEY (rid,email,uid)
);
1	CREATE TABLE rsvp (
2	rid int(10) unsigned NOT NULL auto_increment,
3	nid int(10) unsigned NOT NULL default '0',
4	uid int(10) unsigned NOT NULL default '0',
5	name varchar(128) default '',
6	invite_text text,
7	blind int(3) unsigned NOT NULL default '0',
8	list_email int(3) unsigned NOT NULL default '0',
9	allow_invite int(3) unsigned NOT NULL default '0',
10	timestamp int(10) unsigned NOT NULL default '0',
11	PRIMARY KEY (rid,uid,nid)
12	);
13
14	CREATE TABLE rsvp_invite (
15	response enum('yes','no','maybe','none') NOT NULL default 'none',
16	rid int(10) unsigned NOT NULL default '0',
17	uid int(10) NOT NULL default '0',
18	email varchar(128) NOT NULL default '',
19	hash varchar(255) NOT NULL default '',
20	invited int(10) unsigned NOT NULL default '0',
21	received int(10) unsigned NOT NULL default '0',
22	timestamp int(10) unsigned NOT NULL default '0',
23	PRIMARY KEY (rid,email,uid)
24	);