Create Tables manually – WP Bing Map Pro

If the plugin is not creating the tables upon installation run the following sql scripts.

There are 6 tables in order to run the plugin:

bingmappro_maps
bingmappro_map_shortcodes
bingmappro_pins
bingmappro_map_pins
bingmappro_shapes
bingmappro_map_shapes

All the above need to have the wordpress prefix you have set, check your wordpress settings, or look in db, should be as follows:

eg: wp_bingmappro_maps ( wp_ is the table prefix)

*** DONT FORGET TO CHANGE THE PREFIX FOR EACH TABLE NAME WHEN RUNNING THE SQL QUERY ***

bingmappro_maps



CREATE TABLE IF NOT EXISTS [DB_PREFIX]bingmappro_maps (

id mediumint(4) NOT NULL auto_increment,

map_title varchar(100) NOT NULL default '',

map_width varchar(5) NOT NULL default '100',

map_height varchar(5) NOT NULL default '400',

map_width_type varchar(5) NOT NULL default '%',

map_height_type varchar(5) NOT NULL default 'px',

map_start_lat varchar(100) NOT NULL default '53.350140',

map_start_long varchar(100) NOT NULL default '-6.266155',

map_zoom tinyint(3) NOT NULL default '2',

map_type tinyint(1) NOT NULL default '0',

map_active boolean NOT NULL default '1',

styling_json longtext default '',

styling_enabled boolean NOT NULL default '0',

alignment tinyint(5) default '0',

kml longtext NOT NULL default '',

html_class varchar(50) default '',

map_disabled boolean NOT NULL default '0',

map_shortcode varchar(100) default '',

map_refresh boolean NOT NULL default '0',

compact_nav boolean NOT NULL default '0',

context_menu boolean NOT NULL default '0',

show_pan_btns boolean NOT NULL default '0',

look_at_location boolean NOT NULL default '0',

bicycle boolean NOT NULL default '0',

traffic boolean NOT NULL default '0',

custom_map_style boolean NOT NULL default '0',

toggle_fullscreen boolean NOT NULL default '0',

disable_mousewheel boolean NOT NULL default '0',

disable_zoom boolean NOT NULL default '0',

show_user_location boolean NOT NULL default '0',

street_view boolean NOT NULL default '0',

custom_map_style_script longtext NOT NULL default '',

other_settings longtext NOT NULL default '',

cluster smallint(3) NOT NULL default '-1',

created_at datetime default CURRENT_TIMESTAMP,

PRIMARY KEY  (id),

KEY map_active (map_active)

)

bingmappro_map_shortcodes



CREATE TABLE IF NOT EXISTS [DB_PREFIX]bingmappro_map_shortcodes(

id mediumint(4) NOT NULL auto_increment,

map_id mediumint(4) NOT NULL DEFAULT '0',

shortcode varchar(200) NOT NULL DEFAULT '',

s_lat varchar(50) NOT NULL DEFAULT '',

s_long varchar(50) NOT NULL DEFAULT '',

s_zoom mediumint(2) NOT NULL DEFAULT '0',

s_checkone boolean NOT NULL DEFAULT '0',

s_string varchar(200) NOT NULL DEFAULT '',

s_text text NOT NULL DEFAULT '',

created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

PRIMARY KEY  (id),

KEY map_id (map_id)

)

bingmappro_pins



CREATE TABLE IF NOT EXISTS [DB_PREFIX]bingmappro_pins (

id mediumint(4) NOT NULL auto_increment,

active boolean NOT NULL default '1',

pin_name varchar(255) NOT NULL default '',

pin_lat varchar(100) NOT NULL default '',

pin_long varchar(100) NOT NULL default '',

pin_address varchar(255) NOT NULL default '',

pin_title varchar(255) NOT NULL default '',

pin_desc text NOT NULL default '',

pin_custom_url varchar(255) NOT NULL default '',

pin_iframe_url varchar(255) NOT NULL default '',

pin_image_one varchar(255) NOT NULL default '',

pin_image_two varchar(255) NOT NULL default '',

pin_image_three varchar(255) NOT NULL default '',

pin_image_four varchar(255) NOT NULL default '',

pin_link_one varchar(255) NOT NULL default '',

pin_link_two varchar(255) NOT NULL default '',

pin_link_three varchar(255) NOT NULL default '',

pin_link_four varchar(255) NOT NULL default '',

pin_link_one_txt varchar(50) NOT NULL default '',

pin_link_one_open varchar(10) NOT NULL default '',

pin_link_two_txt varchar(50) NOT NULL default '',

pin_link_two_open varchar(10) NOT NULL default '',

pin_link_three_txt varchar(50) NOT NULL default '',

pin_link_three_open varchar(10) NOT NULL default '',

pin_link_four_txt varchar(50) NOT NULL default '',

pin_link_four_open varchar(10) NOT NULL default '',

img_desc varchar(200) NOT NULL default '',

icon_link varchar(200) NOT NULL default '',

icon varchar(100) NOT NULL default '',

animation tinyint(1) NOT NULL default '0',

category tinyint(1) NOT NULL default '0',

pin_type tinyint(2) NOT NULL default '0',

direction_to_here boolean NOT NULL default '0',

data_json longtext NOT NULL default '',

other_settings text NOT NULL default '',

created_at datetime NOT NULL default CURRENT_TIMESTAMP,

approved boolean NOT NULL default '1',

approved_by varchar(50) NOT NULL default '',

text_pin varchar(50) NOT NULL default '',

use_text_pin boolean NOT NULL default '0',

groupid smallint(3) NOT NULL default '0',

tag varchar(255) NOT NULL default '',

PRIMARY KEY  (id),

KEY active (active),

KEY approved (approved)

)

bingmappro_map_pins



CREATE TABLE IF NOT EXISTS [DB_PREFIX]bingmappro_map_pins(

id mediumint(4) NOT NULL auto_increment,

map_id mediumint(4) NOT NULL default '0',

pin_id mediumint(4) NOT NULL default '0',

pin_active boolean NOT NULL default '1',

created_at datetime NOT NULL default CURRENT_TIMESTAMP,

PRIMARY KEY  (id),

KEY map_id (map_id),

KEY pin_id (pin_id),

KEY pin_active (pin_active)

)

bingmappro_shapes



CREATE TABLE IF NOT EXISTS [DB_PREFIX]bingmappro_shapes(

id mediumint(4) NOT NULL auto_increment,

s_name varchar(50) NOT NULL default '',

s_type varchar(50) NOT NULL default '',

bodycolor varchar(50) NOT NULL default '',

strokecolor varchar(50) NOT NULL default '',

stroketickness mediumint(2) NOT NULL default '1',

bodyopacity float NOT NULL default '0.4',

shapedata text NOT NULL default '',

s_style text NOT NULL default '',

infotype varchar(15) NOT NULL default '',

infosimpletitle varchar(250) NOT NULL default '',

infosimpledesc text NOT NULL default '',

infoadvanced text NOT NULL default '',

caption varchar(250) NOT NULL default '',

maplat varchar(50) NOT NULL default '',

maplong varchar(50) NOT NULL default '',

mapzoom tinyint(1) NOT NULL default '12',

maptype varchar(20) NOT NULL default 'r',

tickboxone boolean NOT NULL DEFAULT '0',

tickboxtwo boolean NOT NULL DEFAULT '0',

tickboxthree boolean NOT NULL DEFAULT '1',

textfieldone varchar(30) NOT NULL DEFAULT '',

textfiledtwo varchar(30) NOT NULL DEFAULT '',

textone text NOT NULL DEFAULT '',

texttwo text NOT NULL DEFAULT '',

textthree text NOT NULL DEFAULT '',

textfour text NOT NULL DEFAULT '',

s_import varchar(20) NOT NULL DEFAULT '',

s_tags varchar(200) NOT NULL DEFAULT '',

s_caption varchar(100) NOT NULL DEFAULT '',

created_at datetime NOT NULL default CURRENT_TIMESTAMP,

created_by varchar(40) NOT NULL DEFAULT '',

PRIMARY KEY  (id)

)

bingmappro_map_shapes



CREATE TABLE IF NOT EXISTS [DB_PREFIX]bingmappro_map_shapes(

id mediumint(4) NOT NULL auto_increment,

map_id mediumint(4) NOT NULL default '0',

shape_id mediumint(4) NOT NULL default '0',

shape_active boolean NOT NULL default '1',

created_at datetime NOT NULL default CURRENT_TIMESTAMP,

PRIMARY KEY  (id),

KEY map_id (map_id),

KEY shape_id (shape_id),

KEY shape_active (shape_active)

)