CREATE TABLE IF NOT EXISTS `microsite_microsites` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `keyword` varchar(250) NOT NULL,
  `basename` varchar(250) NOT NULL,
  `host` varchar(250) DEFAULT NULL,
  `dbname` varchar(250) DEFAULT NULL,
  `username` varchar(250) DEFAULT NULL,
  `password` varchar(250) DEFAULT NULL,
  `homeTemplate` varchar(255) NOT NULL,
  `otherTemplate` varchar(255) NOT NULL,
  `status` enum('Enabled','Disabled') NOT NULL DEFAULT 'Enabled',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `keyword` (`keyword`),
  KEY `status` (`status`),
  KEY `basename` (`basename`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

CREATE TABLE IF NOT EXISTS `microsite_microsites_i18n` (
  `id` int(11) NOT NULL,
  `title` varchar(500) NOT NULL,
  `description` text,
  `locale` varchar(5) NOT NULL DEFAULT 'en_US',
  KEY `id` (`id`),
  KEY `locale` (`locale`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
