Create Tables manually – WP Bing Map Pro

by | posted in: Free Version, Plugins, Wordpress, WP Bing Map Pro | 0

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:

  1. bingmappro_maps
  2. bingmappro_map_shortcodes
  3. bingmappro_pins
  4. bingmappro_map_pins
  5. bingmappro_shapes
  6. 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 t