DROP TABLE IF EXISTS `site_plugin_googlemaps`;
CREATE TABLE IF NOT EXISTS `site_plugin_googlemaps` (
  `gmap_id` int(11) NOT NULL AUTO_INCREMENT,
  `gmap_slider` int(11) NOT NULL,
  `gmap_remove` int(1) NOT NULL,
  `gmap_menu_float` int(1) NOT NULL,
  `gmap_name` varchar(255) NOT NULL,
  `gmap_lat` varchar(100) NOT NULL,
  `gmap_long` varchar(100) NOT NULL,
  `gmap_zoom` int(2) NOT NULL,
  `gmap_type` varchar(20) NOT NULL,
  `gmap_height` int(4) NOT NULL,
  `gmap_height_type` int(1) NOT NULL,
  PRIMARY KEY (`gmap_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

ALTER TABLE  `site_plugin_googlemaps` ADD  `gmap_grayscale` INT( 1 ) NOT NULL AFTER  `gmap_height`;

DROP TABLE IF EXISTS `site_plugin_googlemaps_markers`;
CREATE TABLE IF NOT EXISTS `site_plugin_googlemaps_markers` (
  `item_id` int(11) NOT NULL AUTO_INCREMENT,
  `item_slider` int(11) NOT NULL,
  `item_lat` varchar(100) NOT NULL,
  `item_long` varchar(100) NOT NULL,
  `item_image` int(1) NOT NULL,
  `item_show` int(1) NOT NULL,
  PRIMARY KEY (`item_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `site_plugin_googlemaps_markers_lang`;
CREATE TABLE IF NOT EXISTS `site_plugin_googlemaps_markers_lang` (
  `item_id` int(11) NOT NULL,
  `lang_id` int(11) NOT NULL,
  `item_title` varchar(255) NOT NULL,
  `item_body` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


ALTER TABLE  `site_plugin_googlemaps_markers` ADD  `item_css` VARCHAR( 255 ) NOT NULL;
ALTER TABLE  `site_plugin_googlemaps_markers` ADD  `item_position` VARCHAR( 20 ) NOT NULL;
ALTER TABLE  `site_plugin_googlemaps_markers` ADD  `item_close_button` INT( 1 ) NOT NULL;
ALTER TABLE  `site_plugin_googlemaps_markers` ADD  `item_close_outside` INT( 1 ) NOT NULL;
ALTER TABLE  `site_plugin_googlemaps_markers` ADD  `item_width` INT( 4 ) NOT NULL;
ALTER TABLE  `site_plugin_googlemaps_markers` ADD  `item_type` INT( 1 ) NOT NULL;
ALTER TABLE  `site_plugin_googlemaps_markers` ADD  `item_marker` INT( 1 ) NOT NULL;
ALTER TABLE  `site_plugin_googlemaps_markers` ADD  `item_show_marker` INT( 1 ) NOT NULL;
ALTER TABLE  `site_plugin_googlemaps_markers` ADD  `item_max_width` INT( 4 ) NOT NULL;
ALTER TABLE  `site_plugin_googlemaps_markers` ADD  `item_max_height` INT( 4 ) NOT NULL;

ALTER TABLE  `site_plugin_googlemaps_markers_lang` ADD  `item_html` TEXT NOT NULL;
