
DROP TABLE IF EXISTS `site_plugin_timeline_items`;
CREATE TABLE `site_plugin_timeline_items` (
  `item_id` int(11) NOT NULL AUTO_INCREMENT,
  `module_id` int(11) NOT NULL,
  `item_date` int(11) NOT NULL,
  `item_status` int(1) NOT NULL,
  `item_show_title` int(1) NOT NULL,
  `item_link_type` int(1) NOT NULL,
  `item_link_module` int(11) NOT NULL,
  `item_link_target` varchar(20) NOT NULL,
  `item_type` int(1) NOT NULL,
  `item_image` int(1) NOT NULL,
  `item_video` varchar(100) NOT NULL,
  `item_audio` int(1) NOT NULL,
  `item_show_date` int(1) DEFAULT '1',
  `item_order` int(11) NOT NULL,
  `item_link_size` varchar(10) NOT NULL DEFAULT 'btn-small',
  `item_link_global` int(11) NOT NULL,
  `item_link_rel` varchar(30) NOT NULL,
  `item_link2_rel` varchar(30) NOT NULL,
  `item_link_style` varchar(50) NOT NULL,
  `item_link2_style` varchar(50) NOT NULL,
  `item_css_list` varchar(255) NOT NULL,
  PRIMARY KEY (`item_id`),
  KEY `module_id` (`module_id`,`item_date`,`item_status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `site_plugin_timeline_items_lang`;
CREATE TABLE `site_plugin_timeline_items_lang` (
  `item_id` int(11) NOT NULL,
  `lang_id` int(11) NOT NULL,
  `module_id` int(11) NOT NULL,
  `item_title` varchar(255) NOT NULL,
  `item_body` text NOT NULL,
  `item_link_text` varchar(255) NOT NULL,
  `item_link_link` text NOT NULL,
  `item_image_alt` text NOT NULL,
  KEY `item_id` (`item_id`,`lang_id`,`module_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
