forked from extcode/cart
-
Notifications
You must be signed in to change notification settings - Fork 0
/
ext_tables.sql
313 lines (246 loc) · 9.61 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
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
#
# Table structure for table 'tx_cart_domain_model_order_item'
#
CREATE TABLE tx_cart_domain_model_order_item (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
cart_pid int(11) DEFAULT '0' NOT NULL,
fe_user int(11) unsigned DEFAULT '0',
billing_address int(11) unsigned DEFAULT '0' NOT NULL,
shipping_address int(11) unsigned DEFAULT '0' NOT NULL,
order_number varchar(255) DEFAULT '' NOT NULL,
order_date int(11) unsigned DEFAULT '0' NOT NULL,
order_pdfs int(11) unsigned DEFAULT '0',
invoice_number varchar(255) DEFAULT '' NOT NULL,
invoice_date int(11) unsigned DEFAULT '0' NOT NULL,
invoice_pdfs int(11) unsigned DEFAULT '0',
delivery_number varchar(255) DEFAULT '' NOT NULL,
delivery_date int(11) unsigned DEFAULT '0' NOT NULL,
delivery_pdfs int(11) unsigned DEFAULT '0',
currency varchar(255) DEFAULT '' NOT NULL,
currency_code varchar(255) DEFAULT '' NOT NULL,
currency_sign varchar(255) DEFAULT '' NOT NULL,
currency_translation varchar(255) DEFAULT '' NOT NULL,
gross double(11,2) DEFAULT '0.00' NOT NULL,
net double(11,2) DEFAULT '0.00' NOT NULL,
total_gross double(11,2) DEFAULT '0.00' NOT NULL,
total_net double(11,2) DEFAULT '0.00' NOT NULL,
tax int(11) unsigned DEFAULT '0' NOT NULL,
total_tax int(11) unsigned DEFAULT '0' NOT NULL,
tax_class int(11) unsigned DEFAULT '0' NOT NULL,
products int(11) unsigned DEFAULT '0' NOT NULL,
discounts int(11) unsigned DEFAULT '0' NOT NULL,
shipping int(11) unsigned DEFAULT '0',
payment int(11) unsigned DEFAULT '0',
comment text NOT NULL,
additional text NOT NULL,
additional_data text NOT NULL,
INDEX `parent` (pid), INDEX `t3ver_oid` (t3ver_oid,t3ver_wsid),
PRIMARY KEY (uid)
);
#
# Table structure for table 'tx_cart_domain_model_order_address'
#
CREATE TABLE tx_cart_domain_model_order_address (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
record_type varchar(255) DEFAULT '' NOT NULL,
item int(11) unsigned DEFAULT '0' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
salutation varchar(255) DEFAULT '' NOT NULL,
first_name varchar(255) DEFAULT '' NOT NULL,
last_name varchar(255) DEFAULT '' NOT NULL,
email varchar(255) DEFAULT '' NOT NULL,
phone varchar(255) DEFAULT '' NOT NULL,
fax varchar(255) DEFAULT '' NOT NULL,
company varchar(255) DEFAULT '' NOT NULL,
tax_identification_number varchar(255) DEFAULT '' NOT NULL,
street varchar(255) DEFAULT '' NOT NULL,
street_number varchar(255) DEFAULT '' NOT NULL,
zip varchar(255) DEFAULT '' NOT NULL,
city varchar(255) DEFAULT '' NOT NULL,
country varchar(255) DEFAULT '' NOT NULL,
additional text NOT NULL,
INDEX `parent` (pid), INDEX `t3ver_oid` (t3ver_oid,t3ver_wsid),
PRIMARY KEY (uid)
);
#
# Table structure for table 'tx_cart_domain_model_order_taxclass'
#
CREATE TABLE tx_cart_domain_model_order_taxclass (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
item int(11) unsigned DEFAULT '0' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
value varchar(255) DEFAULT '' NOT NULL,
calc double(11,2) DEFAULT '0.00' NOT NULL,
INDEX `parent` (pid), INDEX `t3ver_oid` (t3ver_oid,t3ver_wsid),
PRIMARY KEY (uid)
);
#
# Table structure for table 'tx_cart_domain_model_order_tax'
#
CREATE TABLE tx_cart_domain_model_order_tax (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tax double(11,2) DEFAULT '0.00' NOT NULL,
tax_class int(11) unsigned DEFAULT '0' NOT NULL,
INDEX `parent` (pid), INDEX `t3ver_oid` (t3ver_oid,t3ver_wsid),
PRIMARY KEY (uid)
);
#
# Table structure for table 'tx_cart_domain_model_order_product'
#
CREATE TABLE tx_cart_domain_model_order_product (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
item int(11) unsigned DEFAULT '0' NOT NULL,
product_type varchar(255) DEFAULT '' NOT NULL,
sku varchar(255) DEFAULT '' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
count int(11) DEFAULT '0' NOT NULL,
price double(11,2) DEFAULT '0.00' NOT NULL,
discount double(11,2) DEFAULT '0.00' NOT NULL,
gross double(11,2) DEFAULT '0.00' NOT NULL,
net double(11,2) DEFAULT '0.00' NOT NULL,
tax double(11,2) DEFAULT '0.00' NOT NULL,
tax_class int(11) unsigned DEFAULT '0' NOT NULL,
additional text NOT NULL,
additional_data text NOT NULL,
product_additional int(11) unsigned DEFAULT '0' NOT NULL,
INDEX `parent` (pid), INDEX `t3ver_oid` (t3ver_oid,t3ver_wsid),
PRIMARY KEY (uid)
);
#
# Table structure for table 'tx_cart_domain_model_order_discount'
#
CREATE TABLE tx_cart_domain_model_order_discount (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
item int(11) unsigned DEFAULT '0' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
code varchar(255) DEFAULT '' NOT NULL,
gross double(11,2) DEFAULT '0.00' NOT NULL,
net double(11,2) DEFAULT '0.00' NOT NULL,
tax_class_id int(11) unsigned DEFAULT '1' NOT NULL,
tax double(11,2) DEFAULT '0.00' NOT NULL,
INDEX `parent` (pid), INDEX `t3ver_oid` (t3ver_oid,t3ver_wsid),
PRIMARY KEY (uid)
);
#
# Table structure for table 'tx_cart_domain_model_order_productadditional'
#
CREATE TABLE tx_cart_domain_model_order_productadditional (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
product int(11) unsigned DEFAULT '0' NOT NULL,
additional_type varchar(255) DEFAULT '' NOT NULL,
additional_key varchar(255) DEFAULT '' NOT NULL,
additional_value varchar(255) DEFAULT '' NOT NULL,
additional text NOT NULL,
additional_data text NOT NULL,
INDEX `parent` (pid), INDEX `t3ver_oid` (t3ver_oid,t3ver_wsid),
PRIMARY KEY (uid)
);
#
# Table structure for table 'tx_cart_domain_model_order_shipping'
#
CREATE TABLE tx_cart_domain_model_order_shipping (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
item int(11) unsigned DEFAULT '0' NOT NULL,
service_country varchar(255) DEFAULT '' NOT NULL,
service_id int(11) DEFAULT '0' NOT NULL,
name varchar(255) DEFAULT '' NOT NULL,
status varchar(255) DEFAULT '0' NOT NULL,
gross double(11,2) DEFAULT '0.00' NOT NULL,
net double(11,2) DEFAULT '0.00' NOT NULL,
tax double(11,2) DEFAULT '0.00' NOT NULL,
tax_class int(11) unsigned DEFAULT '0' NOT NULL,
note text NOT NULL,
INDEX `parent` (pid), INDEX `t3ver_oid` (t3ver_oid,t3ver_wsid),
PRIMARY KEY (uid)
);
#
# Table structure for table 'tx_cart_domain_model_order_payment'
#
CREATE TABLE tx_cart_domain_model_order_payment (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
item int(11) unsigned DEFAULT '0' NOT NULL,
service_country varchar(255) DEFAULT '' NOT NULL,
service_id int(11) DEFAULT '0' NOT NULL,
name varchar(255) DEFAULT '' NOT NULL,
provider varchar(255) DEFAULT '' NOT NULL,
status varchar(255) DEFAULT '0' NOT NULL,
gross double(11,2) DEFAULT '0.00' NOT NULL,
net double(11,2) DEFAULT '0.00' NOT NULL,
tax double(11,2) DEFAULT '0.00' NOT NULL,
tax_class int(11) unsigned DEFAULT '0' NOT NULL,
note text NOT NULL,
transactions int(11) unsigned DEFAULT '0' NOT NULL,
INDEX `parent` (pid), INDEX `t3ver_oid` (t3ver_oid,t3ver_wsid),
PRIMARY KEY (uid)
);
#
# Table structure for table 'tx_cart_domain_model_order_transaction'
#
CREATE TABLE tx_cart_domain_model_order_transaction (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
payment int(11) unsigned DEFAULT '0' NOT NULL,
provider varchar(20) DEFAULT '' NOT NULL,
txn_id varchar(255) DEFAULT '' NOT NULL,
txn_txt text NOT NULL,
status varchar(255) DEFAULT 'unknown' NOT NULL,
external_status_code varchar(255) DEFAULT '' NOT NULL,
note text NOT NULL,
INDEX `parent` (pid),
PRIMARY KEY (uid)
);
#
# Table structure for table 'tx_cart_domain_model_coupon'
#
CREATE TABLE tx_cart_domain_model_coupon (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
code varchar(255) DEFAULT '' NOT NULL,
coupon_type varchar(255) DEFAULT 'cartdiscount' NOT NULL,
discount double(11,2) DEFAULT '0.00' NOT NULL,
tax_class_id int(11) unsigned DEFAULT '1' NOT NULL,
cart_min_price double(11,2) DEFAULT '0.00' NOT NULL,
is_combinable tinyint(4) unsigned DEFAULT '0' NOT NULL,
is_relative_discount tinyint(4) unsigned DEFAULT '0' NOT NULL,
handle_available tinyint(4) unsigned DEFAULT '0' NOT NULL,
number_available int(11) DEFAULT '0' NOT NULL,
number_used int(11) DEFAULT '0' NOT NULL,
INDEX `parent` (pid), INDEX `t3ver_oid` (t3ver_oid,t3ver_wsid),
PRIMARY KEY (uid)
);
#
# Table structure for table 'tx_cart_domain_model_cart'
#
CREATE TABLE tx_cart_domain_model_cart (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
f_hash varchar(255) DEFAULT '' NOT NULL,
s_hash varchar(255) DEFAULT '' NOT NULL,
fe_user int(11) DEFAULT '0' NOT NULL,
order_item int(11) unsigned DEFAULT '0' NOT NULL,
cart text NOT NULL,
was_ordered tinyint(4) unsigned DEFAULT '0' NOT NULL,
INDEX `parent` (pid),
PRIMARY KEY (uid)
);
#
# Table structure for table 'tx_cart_domain_model_tag'
#
CREATE TABLE tx_cart_domain_model_tag (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
KEY language (l10n_parent,sys_language_uid),
INDEX `parent` (pid), INDEX `t3ver_oid` (t3ver_oid,t3ver_wsid),
PRIMARY KEY (uid)
);