-- $Id: citizenspeak.mysql,v 1.5 2005/11/01 17:08:04 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)
);