modules/volunteer/volunteer.mysql

--
-- Table structure for table `volunteer`
--

CREATE TABLE volunteer (
  nid int(10) unsigned NOT NULL default '0',
  wanted int(3) default '2',
  uid int(11) default NULL,
  message_approve text,
  message_deny text,
  message_wait text,
  message_reminder text,
  message_follow_up text,
  PRIMARY KEY (nid)
) TYPE=MyISAM;

--
-- Table structure for table `volunteer_contact_event`
--

CREATE TABLE volunteer_contact_event (
  cid int(10) unsigned NOT NULL default '0',
  timestamp int(10) unsigned NOT NULL default '0',
  rating int(2) default NULL,
  comments text,
  nid int(10) unsigned NOT NULL default '0',
  stage int(2) unsigned default NULL,
  PRIMARY KEY  (nid, cid)
) TYPE=MyISAM;

1	--
2	-- Table structure for table `volunteer`
3	--
4
5	CREATE TABLE volunteer (
6	nid int(10) unsigned NOT NULL default '0',
7	wanted int(3) default '2',
8	uid int(11) default NULL,
9	message_approve text,
10	message_deny text,
11	message_wait text,
12	message_reminder text,
13	message_follow_up text,
14	PRIMARY KEY (nid)
15	) TYPE=MyISAM;
16
17	--
18	-- Table structure for table `volunteer_contact_event`
19	--
20
21	CREATE TABLE volunteer_contact_event (
22	cid int(10) unsigned NOT NULL default '0',
23	timestamp int(10) unsigned NOT NULL default '0',
24	rating int(2) default NULL,
25	comments text,
26	nid int(10) unsigned NOT NULL default '0',
27	stage int(2) unsigned default NULL,
28	PRIMARY KEY (nid, cid)
29	) TYPE=MyISAM;
30