forked from mhirdes/go_maps_ext
-
Notifications
You must be signed in to change notification settings - Fork 0
/
ext_tables.sql
155 lines (136 loc) · 5.64 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
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
#
# Table structure for table 'tx_gomapsext_domain_model_address'
#
CREATE TABLE tx_gomapsext_domain_model_address (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
map int(11) unsigned DEFAULT '0' NOT NULL,
categories int(11) unsigned DEFAULT '0' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
configuration_map varchar(255) DEFAULT '' NOT NULL,
latitude double(11,6) DEFAULT '0.000000' NOT NULL,
longitude double(11,6) DEFAULT '0.000000' NOT NULL,
address varchar(255) DEFAULT '' NOT NULL,
marker int(11) unsigned NOT NULL default '0',
image_size tinyint(1) unsigned DEFAULT '0' NOT NULL,
image_width int(11) DEFAULT '0' NOT NULL,
image_height int(11) DEFAULT '0' NOT NULL,
info_window_content text NOT NULL,
info_window_link int(11) DEFAULT '0' NOT NULL,
info_window_images int(11) unsigned NOT NULL default '0',
close_by_click tinyint(1) unsigned DEFAULT '0' NOT NULL,
open_by_click tinyint(1) unsigned DEFAULT '0' NOT NULL,
opened tinyint(1) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
starttime int(11) unsigned DEFAULT '0' NOT NULL,
endtime int(11) unsigned DEFAULT '0' NOT NULL,
t3ver_oid int(11) DEFAULT '0' NOT NULL,
t3ver_id int(11) DEFAULT '0' NOT NULL,
t3ver_wsid int(11) DEFAULT '0' NOT NULL,
t3ver_label varchar(255) DEFAULT '' NOT NULL,
t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
t3ver_stage int(11) DEFAULT '0' NOT NULL,
t3ver_count int(11) DEFAULT '0' NOT NULL,
t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
t3ver_move_id int(11) DEFAULT '0' NOT NULL,
t3_origuid int(11) DEFAULT '0' NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l10n_parent int(11) DEFAULT '0' NOT NULL,
l10n_diffsource mediumblob,
PRIMARY KEY (uid),
KEY parent (pid),
KEY t3ver_oid (t3ver_oid,t3ver_wsid),
KEY language (l10n_parent,sys_language_uid)
);
#
# Table structure for table 'tx_gomapsext_domain_model_map'
#
CREATE TABLE tx_gomapsext_domain_model_map (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
width varchar(11) DEFAULT '' NOT NULL,
height varchar(11) DEFAULT '' NOT NULL,
zoom int(11) DEFAULT '0' NOT NULL,
addresses int(11) unsigned DEFAULT '0' NOT NULL,
show_addresses tinyint(1) unsigned DEFAULT '0' NOT NULL,
show_categories tinyint(1) unsigned DEFAULT '0' NOT NULL,
kml_url text NOT NULL,
kml_preserve_viewport tinyint(1) unsigned DEFAULT '0' NOT NULL,
kml_local tinyint(1) unsigned DEFAULT '0' NOT NULL,
scroll_zoom tinyint(1) unsigned DEFAULT '0' NOT NULL,
zoom_min int(11) DEFAULT '0' NOT NULL,
zoom_max int(11) DEFAULT '0' NOT NULL,
draggable tinyint(1) unsigned DEFAULT '0' NOT NULL,
double_click_zoom tinyint(1) unsigned DEFAULT '0' NOT NULL,
marker_cluster tinyint(1) unsigned DEFAULT '0' NOT NULL,
marker_cluster_zoom int(11) DEFAULT '0' NOT NULL,
marker_cluster_size int(11) DEFAULT '0' NOT NULL,
marker_cluster_style text NOT NULL,
marker_search tinyint(1) unsigned DEFAULT '0' NOT NULL,
default_type int(11) DEFAULT '0' NOT NULL,
pan_control tinyint(1) unsigned DEFAULT '0' NOT NULL,
scale_control tinyint(1) unsigned DEFAULT '0' NOT NULL,
streetview_control tinyint(1) unsigned DEFAULT '0' NOT NULL,
fullscreen_control tinyint(1) unsigned DEFAULT '0' NOT NULL,
zoom_control tinyint(1) unsigned DEFAULT '0' NOT NULL,
zoom_control_type int(11) DEFAULT '0' NOT NULL,
map_type_control tinyint(1) unsigned DEFAULT '0' NOT NULL,
map_types varchar(255) DEFAULT '' NOT NULL,
show_route tinyint(1) unsigned DEFAULT '0' NOT NULL,
calc_route tinyint(1) unsigned DEFAULT '0' NOT NULL,
travel_mode int(11) DEFAULT '0' NOT NULL,
unit_system int(11) DEFAULT '0' NOT NULL,
styled_map_name varchar(255) DEFAULT '' NOT NULL,
styled_map_code text NOT NULL,
longitude double(11,6) DEFAULT '0.000000' NOT NULL,
latitude double(11,6) DEFAULT '0.000000' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
starttime int(11) unsigned DEFAULT '0' NOT NULL,
endtime int(11) unsigned DEFAULT '0' NOT NULL,
t3ver_oid int(11) DEFAULT '0' NOT NULL,
t3ver_id int(11) DEFAULT '0' NOT NULL,
t3ver_wsid int(11) DEFAULT '0' NOT NULL,
t3ver_label varchar(255) DEFAULT '' NOT NULL,
t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
t3ver_stage int(11) DEFAULT '0' NOT NULL,
t3ver_count int(11) DEFAULT '0' NOT NULL,
t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
t3ver_move_id int(11) DEFAULT '0' NOT NULL,
t3_origuid int(11) DEFAULT '0' NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l10n_parent int(11) DEFAULT '0' NOT NULL,
l10n_diffsource mediumblob,
PRIMARY KEY (uid),
KEY parent (pid),
KEY t3ver_oid (t3ver_oid,t3ver_wsid),
KEY language (l10n_parent,sys_language_uid)
);
#
# Table structure for table 'tx_gomapsext_map_address_mm'
#
CREATE TABLE tx_gomapsext_map_address_mm (
uid_local int(11) unsigned DEFAULT '0' NOT NULL,
uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
sorting int(11) unsigned DEFAULT '0' NOT NULL,
sorting_foreign int(11) unsigned DEFAULT '0' NOT NULL,
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
);
#
# Extend table structure of table 'sys_category'
#
CREATE TABLE sys_category (
gme_marker int(11) unsigned NOT NULL default '0',
gme_image_size tinyint(1) unsigned DEFAULT '0' NOT NULL,
gme_image_width int(11) DEFAULT '0' NOT NULL,
gme_image_height int(11) DEFAULT '0' NOT NULL,
);