search

KarelWintersky / LiveMapEngine

LiveMap project
0 stars 1 forks source link

Архитектура: БД #10

Closed KarelWintersky closed 5 months ago

KarelWintersky commented 6 years ago 
CREATE TABLE `lme_winterland_map_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `map_title` varchar(200) DEFAULT NULL,
  `map_alias` char(48) DEFAULT NULL,
  `description` longtext,
  `image_filename` varchar(60) DEFAULT NULL,
  `image_width` int(11) DEFAULT NULL,
  `image_height` int(11) DEFAULT NULL,
  `layout_filename` varchar(60) DEFAULT NULL,
  `region_border_color` varchar(8) DEFAULT NULL,
  `region_border_width` tinyint(4) DEFAULT NULL,
  `region_border_opacity` float DEFAULT NULL,
  `region_fill_color` varchar(8) DEFAULT NULL,
  `region_fill_opacity` float DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

CREATE TABLE `lme_winterland_map_regions_layout` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'uniq id',
  `id_project` int(11) DEFAULT '1' COMMENT 'project id (always = 1 for confmap singltone app)',
  `id_map` int(11) NOT NULL DEFAULT '1' COMMENT 'unique map id (always = 1 for confmap singltone app)',
  `id_svg_path` varchar(12) DEFAULT NULL COMMENT 'svg path id',
  `def_svg_path` varchar(2000) DEFAULT NULL COMMENT 'svg path d',
  `def_polygon_path` varchar(2000) DEFAULT NULL COMMENT 'js polygon path',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8