-
Notifications
You must be signed in to change notification settings - Fork 22
/
ext_tables.sql
144 lines (132 loc) · 4.55 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
--
-- Table structure for table 'fe_users'
--
CREATE TABLE fe_users (
tx_odsosm_lon decimal(9,6) NOT NULL DEFAULT '0.000000',
tx_odsosm_lat decimal(8,6) NOT NULL DEFAULT '0.000000'
);
--
-- Table structure for table 'fe_groups'
--
CREATE TABLE fe_groups (
tx_odsosm_marker int(10) unsigned NOT NULL DEFAULT '0'
);
--
-- Table structure for table 'sys_category'
--
CREATE TABLE sys_category (
tx_odsosm_marker int(10) unsigned NOT NULL DEFAULT '0'
);
--
-- Table structure for table 'tx_odsosm_geocache'
--
CREATE TABLE tx_odsosm_geocache (
uid int(10) unsigned NOT NULL auto_increment,
pid int(10) unsigned NOT NULL DEFAULT '0',
tstamp int(10) unsigned NOT NULL DEFAULT '0',
crdate int(10) unsigned NOT NULL DEFAULT '0',
deleted tinyint(1) unsigned NOT NULL DEFAULT '0',
cache_hit int(10) unsigned NOT NULL DEFAULT '0',
service_hit int(10) unsigned NOT NULL DEFAULT '0',
search_city varchar(255) NOT NULL DEFAULT '',
country char(128) NOT NULL DEFAULT '',
state varchar(255) NOT NULL DEFAULT '',
city varchar(255) NOT NULL DEFAULT '',
zip char(10) NOT NULL DEFAULT '',
street varchar(255) NOT NULL DEFAULT '',
housenumber varchar(10) NOT NULL DEFAULT '',
lon decimal(9,6) NOT NULL DEFAULT '0.000000',
lat decimal(8,6) NOT NULL DEFAULT '0.000000',
PRIMARY KEY (uid),
KEY parent (pid),
KEY zip (zip)
);
--
-- Table structure for table 'tx_odsosm_layer'
--
CREATE TABLE tx_odsosm_layer (
uid int(10) unsigned NOT NULL auto_increment,
pid int(10) unsigned NOT NULL DEFAULT '0',
tstamp int(10) unsigned NOT NULL DEFAULT '0',
crdate int(10) unsigned NOT NULL DEFAULT '0',
sorting int(10) unsigned NOT NULL DEFAULT '0',
deleted tinyint(1) unsigned NOT NULL DEFAULT '0',
hidden tinyint(1) unsigned NOT NULL DEFAULT '0',
title varchar(64) NOT NULL DEFAULT '',
overlay tinyint(1) unsigned NOT NULL DEFAULT '0',
javascript_include varchar(255) NOT NULL DEFAULT '',
javascript_openlayers varchar(1024) NOT NULL DEFAULT '',
static_url varchar(255) NOT NULL DEFAULT '',
tile_url varchar(255) NOT NULL DEFAULT '',
tile_https tinyint(2) unsigned NOT NULL DEFAULT '0',
min_zoom tinyint(2) unsigned NOT NULL DEFAULT '0',
max_zoom tinyint(2) unsigned NOT NULL DEFAULT '0',
subdomains varchar(8) NOT NULL DEFAULT '',
attribution varchar(300) NOT NULL default '',
homepage varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (uid),
KEY parent (pid)
);
--
-- Table structure for table 'tx_odsosm_marker'
--
CREATE TABLE tx_odsosm_marker (
uid int(10) unsigned NOT NULL auto_increment,
pid int(10) unsigned NOT NULL DEFAULT '0',
tstamp int(10) unsigned NOT NULL DEFAULT '0',
crdate int(10) unsigned NOT NULL DEFAULT '0',
deleted tinyint(1) unsigned NOT NULL DEFAULT '0',
title tinytext NOT NULL,
icon text NOT NULL,
size_x smallint(10) unsigned NOT NULL DEFAULT '0',
size_y smallint(10) unsigned NOT NULL DEFAULT '0',
offset_x smallint(11) NOT NULL DEFAULT '0',
offset_y smallint(11) NOT NULL DEFAULT '0',
PRIMARY KEY (uid),
KEY parent (pid)
);
--
-- Table structure for table 'tx_odsosm_track'
--
CREATE TABLE tx_odsosm_track (
uid int(10) unsigned NOT NULL auto_increment,
pid int(10) unsigned NOT NULL DEFAULT '0',
tstamp int(10) unsigned NOT NULL DEFAULT '0',
crdate int(10) unsigned NOT NULL DEFAULT '0',
deleted tinyint(1) unsigned NOT NULL DEFAULT '0',
hidden tinyint(1) unsigned NOT NULL DEFAULT '0',
title tinytext NOT NULL,
color varchar(10) NOT NULL DEFAULT '#37b7ff',
width tinyint(3) unsigned NOT NULL DEFAULT '5',
file int(11) unsigned NOT NULL DEFAULT '0',
min_lon decimal(9,6) NOT NULL DEFAULT '0.000000',
min_lat decimal(8,6) NOT NULL DEFAULT '0.000000',
max_lon decimal(9,6) NOT NULL DEFAULT '0.000000',
max_lat decimal(8,6) NOT NULL DEFAULT '0.000000',
PRIMARY KEY (uid),
KEY parent (pid)
);
--
-- Table structure for table 'tx_odsosm_vector'
--
CREATE TABLE tx_odsosm_vector (
uid int(10) unsigned NOT NULL auto_increment,
pid int(10) unsigned NOT NULL DEFAULT '0',
tstamp int(10) unsigned NOT NULL DEFAULT '0',
crdate int(10) unsigned NOT NULL DEFAULT '0',
deleted tinyint(1) unsigned NOT NULL DEFAULT '0',
hidden tinyint(1) unsigned NOT NULL DEFAULT '0',
title tinytext NOT NULL,
color varchar(10) NOT NULL DEFAULT '#3388ff',
width tinyint(3) unsigned NOT NULL DEFAULT '3',
data text NOT NULL,
file int(11) unsigned NOT NULL DEFAULT '0',
properties text NOT NULL,
properties_from_file tinyint(1) unsigned NOT NULL DEFAULT '0',
min_lon decimal(9,6) NOT NULL DEFAULT '0.000000',
min_lat decimal(8,6) NOT NULL DEFAULT '0.000000',
max_lon decimal(9,6) NOT NULL DEFAULT '0.000000',
max_lat decimal(8,6) NOT NULL DEFAULT '0.000000',
PRIMARY KEY (uid),
KEY parent (pid)
);