
DROP TABLE IF EXISTS `user_form_data`;
DROP TABLE IF EXISTS `user_form_data_i18n`;

CREATE TABLE IF NOT EXISTS `formBuilder_formData` (
  `id` int(11) NOT NULL auto_increment,
  `formName` varchar(255) NOT NULL,
  `elementName` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `id` (`id`,`formName`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `formBuilder_formData_i18n` (
  `id` int(11) NOT NULL,
  `elementValue` varchar(255) NOT NULL,
  `locale` varchar(5) NOT NULL default 'en_US',
  PRIMARY KEY  (`id`),
  KEY `id` (`id`,`locale`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

ALTER TABLE `formBuilder_elements` CHANGE `type` `type` ENUM( 'text', 'email', 'select', 'multiselect', 'textarea', 'checkbox', 'radio', 'multicheckbox', 'captcha', 'imagebrowser' ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;