20 lines
785 B
SQL
Executable File
20 lines
785 B
SQL
Executable File
CREATE TABLE tx_a2gmaps_domain_model_mapentry (
|
|
latitude decimal(11,8) default NULL,
|
|
longitude decimal(11,8) default NULL,
|
|
title varchar(120) NOT NULL DEFAULT '',
|
|
path_segment varchar(80) DEFAULT '' NOT NULL,
|
|
image int(11) unsigned NOT NULL DEFAULT '0',
|
|
rel_marker int(11) NOT NULL DEFAULT '0',
|
|
popup_content text NOT NULL DEFAULT '',
|
|
addressline varchar(100) DEFAULT '' NOT NULL,
|
|
zip varchar(11) DEFAULT '' NOT NULL,
|
|
city varchar(50) DEFAULT '' NOT NULL,
|
|
region varchar(50) DEFAULT '' NOT NULL,
|
|
nav_to_url varchar(500) DEFAULT '' NOT NULL
|
|
);
|
|
|
|
CREATE TABLE tx_a2gmaps_domain_model_marker (
|
|
title varchar(120) DEFAULT '' NOT NULL,
|
|
map_icon int(11) unsigned NOT NULL DEFAULT '0',
|
|
rel_map_entry int(11) NOT NULL DEFAULT '0'
|
|
); |