Extension:Petition/petition data table
CREATE TABLE petition_data (
pt_id int unsigned PRIMARY KEY auto_increment,
pt_petitionname varchar(255),
pt_source varchar(255),
pt_name varchar(255),
pt_email varchar(255),
pt_country varchar(2),
pt_message blob,
pt_share boolean,
pt_timestamp varbinary(14)
);
CREATE INDEX pt_petitionname ON petition_data (pt_petitionname);