forked from joachimruhs/myttaddressmap
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathext_tables.sql
42 lines (29 loc) · 1002 Bytes
/
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
#
# Table structure for table 'tx_myttaddressmap_domain_model_address'
#
CREATE TABLE tx_myttaddressmap_domain_model_address (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
name varchar(255) DEFAULT '' 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,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l10n_parent int(11) DEFAULT '0' NOT NULL,
l10n_diffsource mediumblob,
t3ver_oid int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY language (l10n_parent,sys_language_uid)
);
#
# Table structure for table 'tt_address'
#
CREATE TABLE tt_address (
mapicon varchar(255) DEFAULT '' NOT NULL,
mapgeocode int(4) DEFAULT '1' NOT NULL,
);