forked from jweiland-net/maps2
-
Notifications
You must be signed in to change notification settings - Fork 0
/
ext_tables.sql
37 lines (36 loc) · 1.52 KB
/
ext_tables.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
#
# Table structure for table 'tx_maps2_domain_model_poicollection'
#
CREATE TABLE tx_maps2_domain_model_poicollection (
map_provider varchar(25) DEFAULT '' NOT NULL,
collection_type varchar(255) DEFAULT '' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
configuration_map text,
latitude double(11,6) DEFAULT '0.000000' NOT NULL,
longitude double(11,6) DEFAULT '0.000000' NOT NULL,
radius int(11) unsigned DEFAULT '0' NOT NULL,
stroke_color varchar(7) DEFAULT '' NOT NULL,
stroke_opacity varchar(5) DEFAULT '' NOT NULL,
stroke_weight varchar(5) DEFAULT '' NOT NULL,
fill_color varchar(7) DEFAULT '' NOT NULL,
fill_opacity varchar(5) DEFAULT '' NOT NULL,
address varchar(255) DEFAULT '' NOT NULL,
info_window_content text,
info_window_images int(11) unsigned DEFAULT '0' NOT NULL,
marker_icons int(11) unsigned DEFAULT '0' NOT NULL,
marker_icon_width int(11) unsigned DEFAULT '0' NOT NULL,
marker_icon_height int(11) unsigned DEFAULT '0' NOT NULL,
marker_icon_anchor_pos_x int(11) unsigned DEFAULT '0' NOT NULL,
marker_icon_anchor_pos_y int(11) unsigned DEFAULT '0' NOT NULL,
categories int(11) DEFAULT '0' NOT NULL
);
#
# Extend table structure of table 'sys_category'
#
CREATE TABLE sys_category (
maps2_marker_icons int(11) unsigned DEFAULT '0' NOT NULL,
maps2_marker_icon_width int(11) unsigned DEFAULT '0' NOT NULL,
maps2_marker_icon_height int(11) unsigned DEFAULT '0' NOT NULL,
maps2_marker_icon_anchor_pos_x int(11) unsigned DEFAULT '0' NOT NULL,
maps2_marker_icon_anchor_pos_y int(11) unsigned DEFAULT '0' NOT NULL
);