cmoreira

create map database table

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