-
Notifications
You must be signed in to change notification settings - Fork 14
/
ext_tables.sql
237 lines (210 loc) · 8.79 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
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
#
# Table structure for table 'tx_pxaproductmanager_domain_model_product'
#
CREATE TABLE tx_pxaproductmanager_domain_model_product
(
name varchar(255) DEFAULT '' NOT NULL,
sku varchar(55) DEFAULT '' NOT NULL,
price double(11, 2) DEFAULT '0.00' NOT NULL,
tax_rate double(11, 2) DEFAULT '0.00' NOT NULL,
teaser text,
description text,
usp text,
parent int(11) unsigned DEFAULT '0' NOT NULL,
related_products int(11) unsigned DEFAULT '0' NOT NULL,
sub_products int(11) unsigned DEFAULT '0' NOT NULL,
accessories int(11) unsigned DEFAULT '0' NOT NULL,
images int(11) unsigned DEFAULT '0' NOT NULL,
attribute_files int(11) unsigned DEFAULT '0' NOT NULL,
links int(11) unsigned DEFAULT '0' NOT NULL,
fal_links int(11) unsigned DEFAULT '0' NOT NULL,
assets int(11) unsigned DEFAULT '0' NOT NULL,
attributes_values int(11) unsigned DEFAULT '0' NOT NULL,
product_type int(11) unsigned DEFAULT '0' NOT NULL,
alternative_title varchar(255) DEFAULT '' NOT NULL,
keywords text,
meta_description text,
slug varchar(2048),
singleview_page varchar(2048),
KEY parent(parent),
KEY language_identifier (l10n_parent,sys_language_uid),
);
#
# Table structure for table 'tx_pxaproductmanager_domain_model_attributeset'
#
CREATE TABLE tx_pxaproductmanager_domain_model_attributeset
(
name varchar(255) DEFAULT '' NOT NULL,
label varchar(255) DEFAULT '' NOT NULL,
attributes int(11) unsigned DEFAULT '0' NOT NULL,
product_types int(11) unsigned DEFAULT '0' NOT NULL,
layout varchar(60) DEFAULT 'Default' NOT NULL,
);
#
# Table structure for table 'tx_pxaproductmanager_domain_model_attribute'
#
CREATE TABLE tx_pxaproductmanager_domain_model_attribute
(
name varchar(255) DEFAULT '' NOT NULL,
label varchar(255) DEFAULT '' NOT NULL,
type int(11) DEFAULT '0' NOT NULL,
required smallint(5) unsigned DEFAULT '0' NOT NULL,
show_in_attribute_listing smallint(5) unsigned DEFAULT '0' NOT NULL,
identifier varchar(255) DEFAULT '' NOT NULL,
default_value varchar(255) DEFAULT '' NOT NULL,
options int(11) unsigned DEFAULT '0' NOT NULL,
label_checked varchar(255) DEFAULT '' NOT NULL,
label_unchecked varchar(255) DEFAULT '' NOT NULL,
image int(11) unsigned DEFAULT '0' NOT NULL
);
#
# Table structure for table 'tx_pxaproductmanager_domain_model_attributevalue'
#
CREATE TABLE tx_pxaproductmanager_domain_model_attributevalue
(
value text,
product int(11) unsigned DEFAULT '0' NOT NULL,
attribute int(11) unsigned DEFAULT '0' NOT NULL,
KEY product(product),
KEY attribute(attribute),
KEY attribute_value(value(40)),
KEY language_identifier (l10n_parent,sys_language_uid),
);
#
# Table structure for table 'tx_pxaproductmanager_domain_model_option'
#
CREATE TABLE tx_pxaproductmanager_domain_model_option
(
attribute int(11) unsigned DEFAULT '0' NOT NULL,
value varchar(255) DEFAULT '' NOT NULL,
KEY attribute(attribute),
);
#
# Table structure for table 'tx_pxaproductmanager_domain_model_link'
#
CREATE TABLE tx_pxaproductmanager_domain_model_link
(
product int(11) unsigned DEFAULT '0' NOT NULL,
name varchar(255) DEFAULT '' NOT NULL,
link varchar(255) DEFAULT '' NOT NULL,
description varchar(255) DEFAULT '' NOT NULL,
KEY product(product),
);
#
# Table structure for table 'tx_pxaproductmanager_product_product_mm'
#
CREATE TABLE tx_pxaproductmanager_product_product_mm
(
uid_local int(11) DEFAULT '0' NOT NULL,
uid_foreign int(11) DEFAULT '0' NOT NULL,
tablenames varchar(255) DEFAULT '' NOT NULL,
fieldname varchar(255) DEFAULT '' NOT NULL,
sorting int(11) DEFAULT '0' NOT NULL,
sorting_foreign int(11) DEFAULT '0' NOT NULL,
KEY uid_local_foreign (uid_local, uid_foreign),
KEY uid_foreign_tablefield (uid_foreign, tablenames(40), fieldname(3), sorting_foreign)
);
#
# Table structure for table 'sys_category'
#
CREATE TABLE sys_category
(
pxapm_image int(11) unsigned DEFAULT '0' NOT NULL,
pxapm_alternative_title varchar(255) DEFAULT '' NOT NULL,
pxapm_keywords text,
pxapm_meta_description text,
pxapm_subcategories int(11) unsigned DEFAULT '0' NOT NULL,
pxapm_products int(11) unsigned DEFAULT '0' NOT NULL,
pxapm_description text,
pxapm_banner_image int(11) unsigned DEFAULT '0' NOT NULL,
pxapm_tax_rate decimal(11, 2) DEFAULT '0.00' NOT NULL,
pxapm_slug varchar(2048),
pxapm_content_page int(11) unsigned DEFAULT '0' NOT NULL,
pxapm_content_colpos int(11) unsigned DEFAULT '0' NOT NULL,
pxapm_hidden_in_navigation smallint(5) unsigned DEFAULT '0' NOT NULL,
pxapm_hide_products smallint(5) unsigned DEFAULT '0' NOT NULL,
pxapm_hide_subcategories smallint(5) unsigned DEFAULT '0' NOT NULL
);
#
# Add type to file reference
#
CREATE TABLE sys_file_reference
(
pxapm_type int(11) DEFAULT '0' NOT NULL,
pxa_attribute int(11) unsigned DEFAULT '0' NOT NULL
);
#
# Table structure for table 'tx_pxaproductmanager_attributeset_record_mm'
#
CREATE TABLE tx_pxaproductmanager_attributeset_record_mm
(
uid_local int(11) DEFAULT '0' NOT NULL,
uid_foreign int(11) DEFAULT '0' NOT NULL,
tablenames varchar(255) DEFAULT '' NOT NULL,
fieldname varchar(255) DEFAULT '' NOT NULL,
sorting int(11) DEFAULT '0' NOT NULL,
sorting_foreign int(11) DEFAULT '0' NOT NULL,
KEY uid_local_foreign (uid_local, uid_foreign),
KEY uid_foreign_tablefield (uid_foreign, tablenames(40), fieldname(3), sorting_foreign)
);
#
# Table structure for table 'tx_pxaproductmanager_domain_model_filter'
#
CREATE TABLE tx_pxaproductmanager_domain_model_filter
(
type int(11) DEFAULT '0' NOT NULL,
name varchar(255) DEFAULT '' NOT NULL,
label varchar(255) DEFAULT '' NOT NULL,
category int(11) unsigned DEFAULT '0' NOT NULL,
attribute int(11) unsigned DEFAULT '0' NOT NULL,
conjunction varchar(10) DEFAULT '' NOT NULL,
gui_type varchar(25) DEFAULT '' NOT NULL,
gui_state varchar(25) DEFAULT '' NOT NULL,
);
#
# Table structure for table 'tx_pxaproductmanager_domain_model_producttype'
#
CREATE TABLE tx_pxaproductmanager_domain_model_producttype
(
name varchar(255) DEFAULT '' NOT NULL,
attribute_sets int(11) unsigned DEFAULT '0' NOT NULL,
inherit_fields text,
template_layout varchar(255) DEFAULT '' NOT NULL,
);
#
# Table structure for table 'tx_pxaproductmanager_product_pages_mm'
#
CREATE TABLE tx_pxaproductmanager_product_pages_mm
(
uid_local int(11) DEFAULT '0' NOT NULL,
uid_foreign int(11) DEFAULT '0' NOT NULL,
tablenames varchar(255) DEFAULT '' NOT NULL,
fieldname varchar(255) DEFAULT '' NOT NULL,
sorting int(11) DEFAULT '0' NOT NULL,
sorting_foreign int(11) DEFAULT '0' NOT NULL,
KEY uid_local_foreign (uid_local, uid_foreign),
KEY uid_foreign_tablefield (uid_foreign, tablenames(40), fieldname(3), sorting_foreign)
);
#
# Table structure for table 'tx_pxaproductmanager_relation_inheritance_index'
# Keeps track of inheritance between inline relation records for parent/child products.
#
CREATE TABLE tx_pxaproductmanager_relation_inheritance_index
(
uid_parent int(11) DEFAULT '0' NOT NULL,
uid_child int(11) DEFAULT '0' NOT NULL,
tablename varchar(255) DEFAULT '' NOT NULL,
child_parent_id int(11) DEFAULT '0' NOT NULL,
child_parent_tablename varchar(255) DEFAULT '' NOT NULL,
KEY uid_child_table (uid_child, tablename, child_parent_id, child_parent_tablename),
KEY uid_parent_table (uid_parent, tablename, child_parent_id, child_parent_tablename)
);
#
# Table structure for table 'tx_pxaproductmanager_inheritance_queue_item'
#
CREATE TABLE tx_pxaproductmanager_inheritance_queue_item (
product_uid int(11) DEFAULT '0' NOT NULL,
indexed int(11) DEFAULT '0' NOT NULL,
errors text NOT NULL,
KEY product_uid (product_uid),
);