CREATE TABLE IF NOT EXISTS {{prefix}}jzzf_form ( id bigint(20) AUTO_INCREMENT, `title` TEXT NOT NULL, `name` varchar(1024) NOT NULL, `theme` int(12) NOT NULL, `css` LONGTEXT NOT NULL, `realtime` int(1) NOT NULL DEFAULT 1, `incomplete` TEXT NOT NULL,  PRIMARY KEY (id) ) {{charset_collate}};
CREATE TABLE IF NOT EXISTS {{prefix}}jzzf_element ( id bigint(20) AUTO_INCREMENT, `form` bigint(20) NOT NULL, `order` int(12) NOT NULL, `type` varchar(1024) NOT NULL, `title` TEXT NOT NULL, `name` varchar(1024) NOT NULL, `formula` TEXT NOT NULL, `value` varchar(1024) NOT NULL, `value2` varchar(1024) NOT NULL, `default` varchar(1024) NOT NULL, `external` int(1) NOT NULL, `params` varchar(2048) NOT NULL, `visible` int(12) NOT NULL DEFAULT 1, `prefix` varchar(16) NOT NULL, `postfix` varchar(16) NOT NULL, `zeros` int(1) NOT NULL, `decimals` int(1) NOT NULL DEFAULT 9, `fixed` int(1) NOT NULL DEFAULT 0, `thousands` varchar(1) NOT NULL, `point` varchar(1) NOT NULL DEFAULT '.', `classes` varchar(1024) NOT NULL, `divisions` int(1) NOT NULL DEFAULT 1, `break` int(1) NOT NULL DEFAULT 1, `required` int(1) NOT NULL DEFAULT 0, `missing` TEXT NOT NULL,  PRIMARY KEY (id) ) {{charset_collate}};
CREATE TABLE IF NOT EXISTS {{prefix}}jzzf_email ( id bigint(20) AUTO_INCREMENT, `form` bigint(20) NOT NULL, `to` TEXT NOT NULL, `cc` TEXT NOT NULL, `bcc` TEXT NOT NULL, `from` varchar(1024) NOT NULL, `subject` TEXT NOT NULL, `message` LONGTEXT NOT NULL, `sending` TEXT NOT NULL, `ok` TEXT NOT NULL, `fail` TEXT NOT NULL,  PRIMARY KEY (id) ) {{charset_collate}};
CREATE TABLE IF NOT EXISTS {{prefix}}jzzf_option ( id bigint(20) AUTO_INCREMENT, `order` int(12) NOT NULL, `element` bigint(20) NOT NULL, `default` int(1) NOT NULL, `title` varchar(1024) NOT NULL, `name` varchar(1024) NOT NULL, `value` varchar(1024) NOT NULL,  PRIMARY KEY (id) ) {{charset_collate}};
