DROP TABLE `DLanguage`;

CREATE TABLE IF NOT EXISTS `DLanguage` (
  `name` varchar(3) NOT NULL DEFAULT '',
  `title` varchar(255) NOT NULL DEFAULT '',
  `shortTitle` varchar(255) NOT NULL DEFAULT '',
  `icon` varchar(64) NOT NULL DEFAULT '',
  `locale` varchar(16) NOT NULL,
  `dir` enum('ltr','rtl') DEFAULT NULL,
  `def` enum('y','n') NOT NULL DEFAULT 'n',
  `enabled` enum('y','n') NOT NULL DEFAULT 'y',
  `sorter` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `DLanguage` (`name`, `title`, `shortTitle`, `icon`, `locale`, `dir`, `def`, `enabled`, `sorter`) VALUES
('en', 'English', 'eng', 'images/language/us.gif', 'en_US', NULL, 'y', 'y', 0),
('es', 'Spanish', 'esp', 'images/language/es.gif', 'es_ES', NULL, 'n', 'y', 1);

ALTER TABLE `DLanguage`
 ADD PRIMARY KEY (`name`), ADD KEY `enabled` (`enabled`);
 
--------------
--------------
--------------
 
UPDATE `PageContent` SET `language` = 'en' WHERE `language` = 'eng';  
UPDATE `DraftPageContent` SET `language` = 'en' WHERE `language` = 'eng';

UPDATE `DraftHtmlBlockContent` SET `language` = 'en' WHERE `language` = 'eng';
UPDATE `HtmlBlockContent` SET `language` = 'en' WHERE `language` = 'eng';

-------------
-------------
-------------

CREATE TABLE IF NOT EXISTS `WideSlideContent` (
`id` int(11) unsigned NOT NULL,
  `lang` varchar(3) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `linkText` varchar(255) DEFAULT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


ALTER TABLE `WideSlideContent`
 ADD PRIMARY KEY (`id`,`lang`), ADD KEY `lang` (`lang`);

 
 INSERT INTO `WideSlideContent` (`id`, `lang`, `title`, `description`, `url`, `linkText`) VALUES
(1, 'en', 'Main Slide', '<p class="lead">What are my best<br />health coverage options?</p><p class="lead">Can I get help<br />with costs?</p><p><strong>Get a quick estimate of your costs</strong></p><p><strong>Want more information? Click </strong><u><a href="/questionnaire/instructions" target="_blank"><font color="#0066cc"><strong>here</strong></font></a></u></p><p><strong>Need further hints and instructions? Click <u><a href="/questionnaire/hints" target="_blank"><font color="#0066cc">here</font></a></u></strong></p>', '', 'START NOW');

ALTER TABLE `WideSlide`
  DROP `title`,
  DROP `description`,
  DROP `url`,
  DROP `linkText`;