-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathext_tables.sql
executable file
·114 lines (95 loc) · 3.4 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
#
# Table structure for table 'tx_addressmgmt_domain_model_address'
#
CREATE TABLE tx_addressmgmt_domain_model_address (
type varchar(100) DEFAULT '' NOT NULL,
first_name varchar(100) DEFAULT '' NOT NULL,
name varchar(100) DEFAULT '' NOT NULL,
gender int(11) DEFAULT '0' NOT NULL,
title varchar(40) DEFAULT '' NOT NULL,
organization varchar(120) DEFAULT '' NOT NULL,
department varchar(80) DEFAULT '' NOT NULL,
street varchar(120) DEFAULT '' NOT NULL,
street_number varchar(25) DEFAULT '' NOT NULL,
address_supplement varchar(80) DEFAULT '' NOT NULL,
city varchar(100) DEFAULT '' NOT NULL,
zip varchar(10) DEFAULT '' NOT NULL,
country varchar(80) DEFAULT '' NOT NULL,
state varchar(80) DEFAULT '' NOT NULL,
closest_city varchar(100) DEFAULT '' NOT NULL,
email varchar(255) DEFAULT '' NOT NULL,
phone varchar(60) DEFAULT '' NOT NULL,
mobile varchar(60) DEFAULT '' NOT NULL,
fax varchar(60) DEFAULT '' NOT NULL,
www varchar(255) DEFAULT '' NOT NULL,
description text NOT NULL,
directions text NOT NULL,
counterpart text NOT NULL,
images int(11) unsigned DEFAULT '0',
latitude varchar(255) DEFAULT '' NOT NULL,
longitude varchar(255) DEFAULT '' NOT NULL,
geojson longtext NOT NULL,
fe_user int(11) unsigned DEFAULT '0' NOT NULL,
social_identifiers int(11) unsigned DEFAULT '0' NOT NULL,
link int(11) unsigned DEFAULT '0',
map_zoom int(11) unsigned DEFAULT NULL,
category int(11) unsigned DEFAULT '0' NOT NULL,
relation int(11) unsigned DEFAULT '0',
publish_state int(11) DEFAULT '0' NOT NULL,
);
#
# Table structure for table 'tx_addressmgmt_domain_model_socialidentifier'
#
CREATE TABLE tx_addressmgmt_domain_model_socialidentifier (
identifier varchar(100) DEFAULT '' NOT NULL,
url_override varchar(255) DEFAULT '' NOT NULL,
provider int(11) unsigned DEFAULT '0' NOT NULL,
address int(11) unsigned DEFAULT '0' NOT NULL,
);
#
# Table structure for table 'tx_addressmgmt_domain_model_socialprovider'
#
CREATE TABLE tx_addressmgmt_domain_model_socialprovider (
name varchar(80) DEFAULT '' NOT NULL,
identifier_label varchar(80) DEFAULT '' NOT NULL,
identifier_description varchar(80) DEFAULT '' NOT NULL,
url_scheme varchar(255) DEFAULT '' NOT NULL,
url_override_label varchar(255) DEFAULT '' NOT NULL,
url_override_description varchar(255) DEFAULT '' NOT NULL,
show_url_override tinyint(4) DEFAULT '0' NOT NULL,
www varchar(120) DEFAULT '' NOT NULL,
image int(11) DEFAULT '0' NOT NULL,
);
#
# Table structure for table 'tx_addressmgmt_domain_model_link'
#
CREATE TABLE tx_addressmgmt_domain_model_link (
text varchar(255) DEFAULT '' NOT NULL,
link varchar(255) DEFAULT '' NOT NULL,
);
#
# Table structure for table 'tx_eventmgmt_event_category_mm'
#
CREATE TABLE tx_addressmgmt_address_category_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)
);
#
# Table structure for table 'tx_addressmgmt_domain_model_relation'
#
CREATE TABLE tx_addressmgmt_domain_model_relation (
room int(11) unsigned DEFAULT '0',
location int(11) unsigned DEFAULT '0',
);
#
# Table structure for table 'tx_addressmgmt_domain_model_room'
#
CREATE TABLE tx_addressmgmt_domain_model_room (
name varchar(255) DEFAULT '' NOT NULL,
capacity int(11) unsigned DEFAULT '0' NOT NULL,
description text NOT NULL,
);