DROP TABLE IF EXISTS `site_plugin_usp`;
CREATE TABLE IF NOT EXISTS `site_plugin_usp` (
  `usp_id` int(11) NOT NULL AUTO_INCREMENT,
  `usp_default` int(1) NOT NULL,
  `usp_modules` text NOT NULL,
  `usp_modules_global` text NOT NULL,
  `usp_link_target` varchar(20) NOT NULL,
  `usp_link_module` int(11) NOT NULL,
  `usp_image` int(11) NOT NULL,
  `usp_status` int(1) NOT NULL,
  `usp_name` VARCHAR(255) NOT NULL,
  PRIMARY KEY (`usp_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;


DROP TABLE IF EXISTS `site_plugin_usp_lang`;
CREATE TABLE IF NOT EXISTS `site_plugin_usp_lang` (
  `usp_id` int(11) NOT NULL,
  `lang_id` int(11) NOT NULL,
  `usp_title` TEXT NOT NULL,
  `usp_text` text NOT NULL,
  `usp_link_button` text NOT NULL,
  `usp_link_type` int(1) NOT NULL,
  `usp_link` varchar(255) NOT NULL,
  `usp_image_alt` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
