-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathext_tables.sql
188 lines (171 loc) · 7.15 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
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
#
# Table structure for table 'tx_bulmapackage_settings'
#
CREATE TABLE tx_bulmapackage_settings
(
title_seo varchar(255) DEFAULT '' NOT NULL,
wsd_name varchar(255) DEFAULT '' NOT NULL,
wsd_alternate_name varchar(255) DEFAULT '' NOT NULL,
logo_main int(11) unsigned DEFAULT '0' NOT NULL,
logos_partners int(11) unsigned DEFAULT '0' NOT NULL,
favicon int(11) unsigned DEFAULT '0' NOT NULL,
code_analytics varchar(255) DEFAULT '' NOT NULL,
address_title varchar(255) DEFAULT '' NOT NULL,
address tinytext,
zip varchar(20) DEFAULT '' NOT NULL,
city varchar(255) DEFAULT '' NOT NULL,
country varchar(128) DEFAULT '' NOT NULL,
phone varchar(30) DEFAULT '' NOT NULL,
fax varchar(30) DEFAULT '' NOT NULL,
email varchar(255) DEFAULT '' NOT NULL,
latitude varchar(255) DEFAULT '' NOT NULL,
longitude varchar(255) DEFAULT '' NOT NULL,
tx_bulmapackage_settings_link_item int(11) unsigned DEFAULT '0',
menu_layout varchar(30) DEFAULT '' NOT NULL,
sharing_services text,
);
#
# Table structure for table 'tx_bulmapackage_custom_color'
#
CREATE TABLE tx_bulmapackage_custom_color
(
label varchar(255) DEFAULT '' NOT NULL,
var_primary varchar(255) DEFAULT '' NOT NULL,
var_link varchar(255) DEFAULT '' NOT NULL,
var_success varchar(255) DEFAULT '' NOT NULL,
var_info varchar(255) DEFAULT '' NOT NULL,
var_warning varchar(255) DEFAULT '' NOT NULL,
var_danger varchar(255) DEFAULT '' NOT NULL,
var_text_dark smallint unsigned DEFAULT '0' NOT NULL
);
#
# Table structure for table 'tx_bulmapackage_meta_tags'
#
CREATE TABLE tx_bulmapackage_meta_tags
(
name varchar(255) DEFAULT '' NOT NULL,
content varchar(255) DEFAULT '' NOT NULL
);
#
# Table structure for table 'tx_bulmapackage_settings_link_item'
#
CREATE TABLE tx_bulmapackage_settings_link_item
(
tx_bulmapackage_settings int(11) unsigned DEFAULT '0',
label varchar(255) DEFAULT '' NOT NULL,
link varchar(1024) DEFAULT '' NOT NULL,
icon varchar(255) DEFAULT '' NOT NULL,
icon_file int(11) unsigned DEFAULT '0',
force_label tinyint(4) unsigned DEFAULT '0' NOT NULL,
standalone tinyint(4) unsigned DEFAULT '0' NOT NULL,
icon_custom tinyint(4) unsigned DEFAULT '0' NOT NULL
);
#
# Table structure for table 'tt_content'
#
CREATE TABLE tt_content
(
header_position varchar(10) DEFAULT '' NOT NULL,
background_color_class varchar(255) DEFAULT '' NOT NULL,
background_frame varchar(255) DEFAULT 'limited' NOT NULL,
file_folder text,
readmore_label varchar(255) DEFAULT '' NOT NULL,
message_class varchar(60) DEFAULT 'default' NOT NULL,
gallery_size varchar(10) DEFAULT '' NOT NULL,
ignore_nav_hide tinyint(4) DEFAULT '0' NOT NULL,
max_items varchar(255) DEFAULT '' NOT NULL,
tx_bulmapackage_card_group_item int(11) unsigned DEFAULT '0',
tx_bulmapackage_thumbnail_group_item int(11) unsigned DEFAULT '0',
tx_bulmapackage_icon_group_item int(11) unsigned DEFAULT '0',
tx_bulmapackage_tab_item_parent int(11) DEFAULT '0' NOT NULL,
tx_bulmapackage_tab_item int(11) unsigned DEFAULT '0' NOT NULL,
tx_bulmapackage_accordion_item_parent int(11) DEFAULT '0' NOT NULL,
tx_bulmapackage_accordion_item int(11) unsigned DEFAULT '0' NOT NULL,
tx_bulmapackage_accordion_item_active int(11) unsigned DEFAULT '0' NOT NULL,
tx_bulmapackage_carousel_item int(11) unsigned DEFAULT '0',
tx_bulmapackage_sharing_services text,
tx_bulmapackage_sharing_services_label varchar(255) DEFAULT NULL,
tx_mask_content_role varchar(255) DEFAULT '' NOT NULL
);
#
# Table structure for table 'pages'
#
CREATE TABLE pages
(
thumbnail int(11) unsigned DEFAULT '0',
exclude_slug_for_subpages tinyint(1) DEFAULT '0' NOT NULL,
hide_breadcrumb tinyint(1) DEFAULT '0' NOT NULL,
);
#
# Table structure for table 'tx_bulmapackage_accordion_item'
#
CREATE TABLE tx_bulmapackage_accordion_item
(
tt_content int(11) DEFAULT '0' NOT NULL,
record int(11) unsigned DEFAULT '0' NOT NULL,
title tinytext
);
#
# Table structure for table 'tx_bulmapackage_tab_item'
#
CREATE TABLE tx_bulmapackage_tab_item
(
tt_content int(11) DEFAULT '0' NOT NULL,
record int(11) unsigned DEFAULT '0' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL
);
#
# Table structure for table 'tx_bulmapackage_card_group_item'
#
CREATE TABLE tx_bulmapackage_card_group_item
(
tt_content int(11) unsigned DEFAULT '0',
header varchar(255) DEFAULT '' NOT NULL,
subheader varchar(255) DEFAULT '' NOT NULL,
media int(11) DEFAULT '0' NOT NULL,
bodytext text,
link varchar(1024) DEFAULT '' NOT NULL,
link_title varchar(255) DEFAULT '' NOT NULL
);
#
# Table structure for table 'tx_bulmapackage_thumbnail_group_item'
#
CREATE TABLE tx_bulmapackage_thumbnail_group_item
(
tt_content int(11) unsigned DEFAULT '0',
header varchar(255) DEFAULT '' NOT NULL,
subheader varchar(255) DEFAULT '' NOT NULL,
media int(11) DEFAULT '0' NOT NULL,
link varchar(1024) DEFAULT '' NOT NULL,
);
#
# Table structure for table 'tx_bulmapackage_carousel_item'
#
CREATE TABLE tx_bulmapackage_carousel_item
(
tt_content int(11) unsigned DEFAULT '0',
item_type varchar(255) DEFAULT '' NOT NULL,
header varchar(255) DEFAULT '' NOT NULL,
header_layout varchar(30) DEFAULT '0' NOT NULL,
text_color varchar(255) DEFAULT '' NOT NULL,
subheader varchar(255) DEFAULT '' NOT NULL,
button_text varchar(255) DEFAULT '' NOT NULL,
button_class varchar(255) DEFAULT '' NOT NULL,
link varchar(1024) DEFAULT '' NOT NULL,
background_color varchar(255) DEFAULT '' NOT NULL,
image int(11) unsigned DEFAULT '0'
);
#
# Table structure for table 'tx_bulmapackage_icon_group_item'
#
CREATE TABLE tx_bulmapackage_icon_group_item
(
tt_content int(11) unsigned DEFAULT '0',
bodytext mediumtext,
link varchar(1024) DEFAULT '' NOT NULL,
icon varchar(255) DEFAULT '' NOT NULL,
icon_set varchar(255) DEFAULT '' NOT NULL,
icon_file int(11) unsigned DEFAULT '0',
icon_size varchar(255) DEFAULT '' NOT NULL,
icon_color varchar(255) DEFAULT '' NOT NULL
);