DROP TABLE IF EXISTS `site_plugin_shortcodes`;
CREATE TABLE `site_plugin_shortcodes` (
  `shortcode_id` int(11) NOT NULL AUTO_INCREMENT,
  `shortcode_type` int(2) NOT NULL,
  `shortcode_code` varchar(255) NOT NULL,
  `shortcode_variables` text NOT NULL,
  `shortcode_replace` text NOT NULL,
  `shortcode_multi` int(1) NOT NULL,
  `shortcode_multi_replace` text NOT NULL,
  `shortcode_status` int(1) NOT NULL,
  `shortcode_sample` varchar(255) NOT NULL,
  `shortcode_nested` int(1) NOT NULL,
  `shortcode_note` varchar(255) NOT NULL,
  `shortcode_device` varchar(10) NOT NULL,
  PRIMARY KEY (`shortcode_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;