CREATE TABLE `liaise_forms` (
  `form_id` smallint(5) NOT NULL auto_increment,
  `form_send_method` char(1) NOT NULL default 'e',
  `form_send_to_group` smallint(3) NOT NULL default '0',
  `form_order` smallint(3) NOT NULL default '0',
  `form_delimiter` char(1) NOT NULL default 's',
  `form_title` varchar(255) NOT NULL default '',
  `form_submit_text` varchar(50) NOT NULL default '',
  `form_desc` text NOT NULL,
  `form_intro` text NOT NULL,
  `form_whereto` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`form_id`),
  KEY `form_order` (`form_order`)
) TYPE=MyISAM;

INSERT INTO `liaise_forms` VALUES (1, 'e', 0, 1, 'b', 'Send feedback', 'Submit', 'Tell us about your comments for this site.', 'Contact us by filling out this form.', '');

CREATE TABLE `liaise_formelements` (
  `ele_id` smallint(5) unsigned NOT NULL auto_increment,
  `form_id` smallint(5) NOT NULL default '0',
  `ele_type` varchar(10) NOT NULL default '',
  `ele_caption` varchar(255) NOT NULL default '',
  `ele_order` smallint(2) NOT NULL default '0',
  `ele_req` tinyint(1) NOT NULL default '1',
  `ele_value` text NOT NULL,
  `ele_display` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`ele_id`),
  KEY `ele_display` (`ele_display`),
  KEY `ele_order` (`ele_order`)
) TYPE=MyISAM;

INSERT INTO `liaise_formelements` VALUES (1, 1, 'checkbox', 'What are your hobbies?', 11, 1, 'a:7:{s:13:"I\'m a dreary.";i:1;s:35:"Searching adult contents on the net";i:0;s:66:"Arguing with people about those stupid things on discussion boards";i:0;s:33:"Searching software serial numbers";i:0;s:6:"Speech";i:0;s:34:"Making weapons of mass destruction";i:0;s:10:"{OTHER|30}";i:0;}', 1);
INSERT INTO `liaise_formelements` VALUES (2, 1, 'text', 'Your name', 0, 1, 'a:3:{i:0;i:30;i:1;i:255;i:2;s:7:"{UNAME}";}', 1);
INSERT INTO `liaise_formelements` VALUES (3, 1, 'text', 'Email', 1, 1, 'a:3:{i:0;i:30;i:1;i:255;i:2;s:7:"{EMAIL}";}', 1);
INSERT INTO `liaise_formelements` VALUES (4, 1, 'text', 'Website', 3, 0, 'a:3:{i:0;i:30;i:1;i:255;i:2;s:7:"http://";}', 1);
INSERT INTO `liaise_formelements` VALUES (5, 1, 'text', 'Company', 4, 0, 'a:3:{i:0;i:30;i:1;i:255;i:2;s:0:"";}', 1);
INSERT INTO `liaise_formelements` VALUES (6, 1, 'text', 'Location', 5, 0, 'a:3:{i:0;i:30;i:1;i:255;i:2;s:0:"";}', 1);
INSERT INTO `liaise_formelements` VALUES (7, 1, 'textarea', 'Comments', 6, 1, 'a:3:{i:0;s:0:"";i:1;i:5;i:2;i:35;}', 1);
INSERT INTO `liaise_formelements` VALUES (8, 1, 'select', 'How are you today?', 7, 0, 'a:3:{i:0;i:1;i:1;i:0;i:2;a:6:{s:6:"Great!";i:0;s:9:"I\'m fine.";i:1;s:6:"So so.";i:0;s:8:"No good.";i:0;s:9:"I\'m sick.";i:0;s:5:"What?";i:0;}}', 1);
INSERT INTO `liaise_formelements` VALUES (9, 1, 'text', 'Your credit card number', 14, 0, 'a:3:{i:0;i:30;i:1;i:255;i:2;s:15:"Are you crazy!?";}', 1);
INSERT INTO `liaise_formelements` VALUES (10, 1, 'radio', 'How old are you?', 9, 0, 'a:8:{s:3:"0-9";i:0;s:5:"10-19";i:0;s:5:"20-29";i:0;s:5:"30-39";i:0;s:5:"40-49";i:0;s:5:"50-59";i:0;s:3:"60+";i:0;s:27:"It\'s none of your business.";i:1;}', 1);
INSERT INTO `liaise_formelements` VALUES (11, 1, 'checkbox', 'foo', 13, 0, 'a:1:{s:3:"bar";i:0;}', 0);
INSERT INTO `liaise_formelements` VALUES (12, 1, 'select', 'Why did you buy a computer?', 8, 1, 'a:3:{i:0;i:10;i:1;i:1;i:2;a:6:{s:25:"My room is too big for me";i:1;s:25:"I don\'t have a girlfriend";i:0;s:18:"My wife is a biddy";i:0;s:17:"I like spam mails";i:0;s:29:"That makes me look more smart";i:0;s:13:"I just forgot";i:0;}}', 1);
INSERT INTO `liaise_formelements` VALUES (13, 1, 'radio', 'Gender', 2, 0, 'a:3:{s:4:"Male";i:0;s:6:"Female";i:0;s:15:"I won\'t tell ya";i:1;}', 1);
INSERT INTO `liaise_formelements` VALUES (14, 1, 'yn', 'Do you believe your government?', 12, 0, 'a:2:{s:4:"_YES";i:1;s:3:"_NO";i:0;}', 1);
INSERT INTO `liaise_formelements` VALUES (15, 1, 'html', '', 10, 0, 'a:3:{i:0;s:316:"I have no idea what should be placed here. Maybe a chapter from the holy bible? [url=http://www.randomwebsearch.com/cgi-bin/randomWebSearch.pl?mode=generate]Click here[/url] if you have too much time to waste, or [url=http://www.landoverbaptist.org/news0104/ps2.html]get a free PlayStation 2[/url] if you are boring.";i:1;i:10;i:2;i:50;}', 1);

