
DROP TABLE IF EXISTS `site_plugin_topintro`;
CREATE TABLE `site_plugin_topintro` (
  `item_id` int(11) NOT NULL AUTO_INCREMENT,
  `item_status` int(1) NOT NULL,
  `item_note` varchar(255) NOT NULL,
  `item_default` int(1) NOT NULL,
  `item_modules` text NOT NULL,
  `item_modules_global` text 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_show_menu` int(1) NOT NULL,
  `item_align` varchar(30) NOT NULL,
  `item_background` int(11) NOT NULL,
  `item_background_style` int(1) NOT NULL,
  `item_content_type` int(1) NOT NULL,
  `item_link_global` int(11) NOT NULL,
  `item_link2_type` int(1) NOT NULL,
  `item_link2_module` int(11) NOT NULL,
  `item_link2_global` int(11) NOT NULL,
  `item_link2_target` varchar(20) NOT NULL,
  `item_link_size` varchar(20) NOT NULL,
  `item_link2_size` varchar(20) 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_text_1_css_class` varchar(255) NOT NULL,
  `item_text_2_css_class` varchar(255) NOT NULL,
  `item_title_css_class` varchar(255) NOT NULL,
  `item_buttons_css_class` varchar(255) NOT NULL,
  PRIMARY KEY (`item_id`),
  KEY `item_status` (`item_status`,`item_default`),
  FULLTEXT KEY `item_modules` (`item_modules`,`item_modules_global`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `site_plugin_topintro_lang`;
CREATE TABLE `site_plugin_topintro_lang` (
  `item_id` int(11) NOT NULL,
  `lang_id` int(11) NOT NULL,
  `item_title` text NOT NULL,
  `item_text_1` text NOT NULL,
  `item_text_2` text NOT NULL,
  `item_link_text` varchar(255) NOT NULL,
  `item_link_link` text NOT NULL,
  `item_html` text NOT NULL,
  `item_link2_text` varchar(255) NOT NULL,
  `item_link2_link` text NOT NULL,
  KEY `item_id` (`item_id`,`lang_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
