modules/citizenspeak/citizenspeak.mysql

-- $Id: citizenspeak.mysql,v 1.4 2005/10/31 21:33:39 georgehotelling Exp $
CREATE TABLE citizenspeak_campaigns (
nid int(11) not null,
email_message text not null,
email_recipients text not null,
campaign_format int(1) unsigned not null default 0,
index (nid)
);

CREATE TABLE citizenspeak_participants (
nid int(11) not null,
id int(11) unsigned not null,
name varchar(255),
organization varchar(255),
email varchar(255),
address varchar(255),
city varchar(255),
state char(255),
zip char(5),
phone varchar(255),
fax varchar(255) default null,
personal_statement text,
sent_at datetime,
index (nid),
primary key (id)
);

CREATE TABLE citizenspeak_thankyou_options (
uid int(10) not null default 0,
use_redirect int(1) unsigned not null default 0,
redirect_url varchar(255),
request_volunteers int(1) unsigned not null default 0,
volunteer_email varchar(255),
request_donations int(1) unsigned not null default 0,
donation_paypal_id varchar(255),
request_memberships int(1) unsigned not null default 0,
membership_paypal_id varchar(255),
membership_paypal_amount varchar(255),
include_additional_text int(1) unsigned not null default 0,
additional_text_language varchar(255),
additional_text text,
request_feedback int(1) unsigned not null default 0,
feedback_email varchar(255),
primary key (uid)
);
1	-- $Id: citizenspeak.mysql,v 1.4 2005/10/31 21:33:39 georgehotelling Exp $
2	CREATE TABLE citizenspeak_campaigns (
3	nid int(11) not null,
4	email_message text not null,
5	email_recipients text not null,
6	campaign_format int(1) unsigned not null default 0,
7	index (nid)
8	);
9
10	CREATE TABLE citizenspeak_participants (
11	nid int(11) not null,
12	id int(11) unsigned not null,
13	name varchar(255),
14	organization varchar(255),
15	email varchar(255),
16	address varchar(255),
17	city varchar(255),
18	state char(255),
19	zip char(5),
20	phone varchar(255),
21	fax varchar(255) default null,
22	personal_statement text,
23	sent_at datetime,
24	index (nid),
25	primary key (id)
26	);
27
28	CREATE TABLE citizenspeak_thankyou_options (
29	uid int(10) not null default 0,
30	use_redirect int(1) unsigned not null default 0,
31	redirect_url varchar(255),
32	request_volunteers int(1) unsigned not null default 0,
33	volunteer_email varchar(255),
34	request_donations int(1) unsigned not null default 0,
35	donation_paypal_id varchar(255),
36	request_memberships int(1) unsigned not null default 0,
37	membership_paypal_id varchar(255),
38	membership_paypal_amount varchar(255),
39	include_additional_text int(1) unsigned not null default 0,
40	additional_text_language varchar(255),
41	additional_text text,
42	request_feedback int(1) unsigned not null default 0,
43	feedback_email varchar(255),
44	primary key (uid)
45	);