cmoreira

map database table

Aug 12th, 2015
284
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.13 KB | None | 0 0
  1.  
  2. DROP TABLE IF EXISTS `wp_i_world_map`;
  3. CREATE TABLE `wp_i_world_map` (
  4. `id` int(11) NOT NULL,
  5. `name` varchar(255) DEFAULT NULL,
  6. `description` longtext,
  7. `use_defaults` int(11) DEFAULT NULL,
  8. `bg_color` varchar(100) DEFAULT NULL,
  9. `border_color` varchar(100) DEFAULT NULL,
  10. `border_stroke` varchar(100) DEFAULT NULL,
  11. `ina_color` varchar(100) DEFAULT NULL,
  12. `act_color` varchar(100) DEFAULT NULL,
  13. `marker_size` int(11) DEFAULT NULL,
  14. `width` varchar(100) DEFAULT NULL,
  15. `height` varchar(100) DEFAULT NULL,
  16. `aspect_ratio` int(11) DEFAULT NULL,
  17. `interactive` int(11) DEFAULT '1',
  18. `showtooltip` int(11) DEFAULT '1',
  19. `region` varchar(100) DEFAULT NULL,
  20. `display_mode` varchar(100) DEFAULT NULL,
  21. `map_action` varchar(100) DEFAULT NULL,
  22. `places` longtext,
  23. `custom_action` longtext,
  24. `custom_css` longtext,
  25. `created` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  26. `image` longtext NOT NULL
  27. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  28.  
  29. ALTER TABLE `wp_i_world_map`
  30. ADD UNIQUE KEY `id` (`id`);
  31.  
  32.  
  33. ALTER TABLE `wp_i_world_map`
  34. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1;
Advertisement
Add Comment
Please, Sign In to add comment