CREATE TABLE IF NOT EXISTS `contactform_subjects` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `contactform_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `firstName` varchar(255) NOT NULL,
  `lastName` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

INSERT INTO `application_registry` (`name`, `value`) VALUES ('ContactForm', '{"id":"2","show_captcha":"1","panel":{"submit":"Save Settings"}}');

CREATE TABLE IF NOT EXISTS `contactform_form_data` (
  `id` int(11) NOT NULL auto_increment,
  `userId` int(11) NOT NULL,
  `elementId` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `elementId` (`elementId`,`userId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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