This repository has been archived by the owner on Nov 19, 2017. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 1
/
ext_tables.sql
executable file
·690 lines (612 loc) · 20.8 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
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
#
# Table structure for table 'tt_products'
#
CREATE TABLE tt_products (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
sorting int(10) DEFAULT '0' NOT NULL,
deleted tinyint(3) 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,
fe_group int(11) DEFAULT '0' NOT NULL,
title tinytext NOT NULL,
subtitle mediumtext NOT NULL,
prod_uid int(11) DEFAULT '0' NOT NULL,
accessory_uid int(11) DEFAULT '0' NOT NULL,
related_uid int(11) DEFAULT '0' NOT NULL,
dam_uid int(11) DEFAULT '0' NOT NULL,
itemnumber varchar(40) DEFAULT '' NOT NULL,
ean varchar(48) DEFAULT '' NOT NULL,
directcost decimal(19,2) DEFAULT '0.00' NOT NULL,
price decimal(19,2) DEFAULT '0.00' NOT NULL,
price2 decimal(19,2) DEFAULT '0.00' NOT NULL,
creditpoints int(11) DEFAULT '0' NOT NULL,
graduated_price_uid int(11) DEFAULT '0' NOT NULL,
article_uid int(11) DEFAULT '0' NOT NULL,
note text NOT NULL,
note2 text NOT NULL,
note_uid int(11) DEFAULT '0' NOT NULL,
text_uid int(11) DEFAULT '0' NOT NULL,
unit varchar(20) DEFAULT '' NOT NULL,
unit_factor varchar(6) DEFAULT '' NOT NULL,
image text NOT NULL,
datasheet text NOT NULL,
www varchar(160) DEFAULT '' NOT NULL,
category int(11) unsigned DEFAULT '0' NOT NULL,
damcat int(11) unsigned DEFAULT '0' NOT NULL,
address int(11) unsigned DEFAULT '0' NOT NULL,
inStock int(11) DEFAULT '1' NOT NULL,
basketminquantity decimal(19,2) DEFAULT '0.00' NOT NULL,
tax_id tinyint(3) unsigned DEFAULT '1',
tax decimal(19,2) DEFAULT '0.00' NOT NULL,
weight decimal(19,6) DEFAULT '0.000000' NOT NULL,
usebydate int(11) unsigned DEFAULT '0' NOT NULL,
bulkily int(11) DEFAULT '0' NOT NULL,
offer int(11) DEFAULT '0' NOT NULL,
highlight int(11) DEFAULT '0' NOT NULL,
bargain int(11) DEFAULT '0' NOT NULL,
color mediumtext NOT NULL,
color2 mediumtext NOT NULL,
color3 mediumtext NOT NULL,
size mediumtext NOT NULL,
size2 mediumtext NOT NULL,
size3 mediumtext NOT NULL,
description mediumtext NOT NULL,
gradings mediumtext NOT NULL,
material mediumtext NOT NULL,
quality mediumtext NOT NULL,
additional_type varchar(36) DEFAULT '' NOT NULL,
additional mediumtext NOT NULL,
special_preparation int(11) DEFAULT '0' NOT NULL,
shipping decimal(19,2) DEFAULT '0.00' NOT NULL,
shipping2 decimal(19,2) DEFAULT '0.00' NOT NULL,
handling decimal(19,2) DEFAULT '0.00' NOT NULL,
delivery int(11) DEFAULT '0' NOT NULL,
sellstarttime int(11) unsigned DEFAULT '0' NOT NULL,
sellendtime int(11) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
KEY comp1 (pid,deleted,sorting),
KEY comp2 (pid,deleted,hidden,starttime,endtime,fe_group),
);
#
# Table structure for table 'tt_products_language'
#
CREATE TABLE tt_products_language (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
sorting int(10) DEFAULT '0' NOT NULL,
t3ver_oid int(11) DEFAULT '0' NOT NULL,
t3ver_id int(11) DEFAULT '0' NOT NULL,
t3ver_label varchar(30) DEFAULT '' NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
deleted tinyint(4) DEFAULT '0' NOT NULL,
hidden tinyint(4) DEFAULT '0' NOT NULL,
starttime int(11) DEFAULT '0' NOT NULL,
endtime int(11) DEFAULT '0' NOT NULL,
fe_group int(11) DEFAULT '0' NOT NULL,
title tinytext NOT NULL,
subtitle mediumtext NOT NULL,
itemnumber varchar(40) DEFAULT '' NOT NULL,
prod_uid int(11) DEFAULT '0' NOT NULL,
text_uid int(11) DEFAULT '0' NOT NULL,
note text NOT NULL,
note2 text NOT NULL,
unit varchar(20) DEFAULT '' NOT NULL,
image text NOT NULL,
datasheet text NOT NULL,
www varchar(160) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
KEY comp1 (pid,deleted,sorting),
);
#
# Table structure for table 'tt_products_related_products_products_mm'
#
#
CREATE TABLE tt_products_related_products_products_mm (
uid_local int(11) DEFAULT '0' NOT NULL,
uid_foreign int(11) DEFAULT '0' NOT NULL,
sorting int(11) DEFAULT '0' NOT NULL,
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign),
);
#
# Table structure for table 'tt_products_accessory_products_products_mm'
#
#
CREATE TABLE tt_products_accessory_products_products_mm (
uid_local int(11) DEFAULT '0' NOT NULL,
uid_foreign int(11) DEFAULT '0' NOT NULL,
sorting int(11) DEFAULT '0' NOT NULL,
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign),
);
#
# Table structure for table 'tt_products_products_dam_mm'
#
#
CREATE TABLE tt_products_products_dam_mm (
uid_local int(11) DEFAULT '0' NOT NULL,
uid_foreign int(11) DEFAULT '0' NOT NULL,
sorting int(11) DEFAULT '0' NOT NULL,
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign),
);
#
# Table structure for table 'tt_products_products_note_pages_mm'
#
#
CREATE TABLE tt_products_products_note_pages_mm (
uid_local int(11) DEFAULT '0' NOT NULL,
uid_foreign int(11) DEFAULT '0' NOT NULL,
sorting int(11) DEFAULT '0' NOT NULL,
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign),
);
#
# Table structure for table 'tt_products_cat'
#
CREATE TABLE tt_products_cat (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
sorting int(10) DEFAULT '0' NOT NULL,
deleted tinyint(3) 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,
fe_group int(11) DEFAULT '0' NOT NULL,
title tinytext NOT NULL,
subtitle mediumtext NOT NULL,
note text NOT NULL,
note2 text NOT NULL,
image text NOT NULL,
email_uid int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
KEY comp1 (pid,deleted,sorting),
);
#
# Table structure for table 'tt_products_cat_language'
#
CREATE TABLE tt_products_cat_language (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
sorting int(10) DEFAULT '0' NOT NULL,
t3ver_oid int(11) DEFAULT '0' NOT NULL,
t3ver_id int(11) DEFAULT '0' NOT NULL,
t3ver_label varchar(30) DEFAULT '' NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
deleted tinyint(4) DEFAULT '0' NOT NULL,
hidden tinyint(4) DEFAULT '0' NOT NULL,
starttime int(11) DEFAULT '0' NOT NULL,
endtime int(11) DEFAULT '0' NOT NULL,
fe_group int(11) DEFAULT '0' NOT NULL,
title tinytext NOT NULL,
subtitle mediumtext NOT NULL,
note text NOT NULL,
note2 text NOT NULL,
cat_uid int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
KEY comp1 (pid,deleted,sorting),
);
#
# Table structure for table 'tt_products_products_mm_articles'
#
CREATE TABLE tt_products_products_mm_articles (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
uid_local int(11) DEFAULT '0' NOT NULL,
uid_foreign int(11) DEFAULT '0' NOT NULL,
tablenames varchar(30) DEFAULT '' NOT NULL,
sorting int(10) DEFAULT '0' NOT NULL,
articlesort int(10) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign),
KEY parent (pid)
);
#
# Table structure for table 'tt_products_articles'
#
CREATE TABLE tt_products_articles (
uid int(11) DEFAULT '0' NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
sorting int(10) DEFAULT '0' NOT NULL,
t3ver_oid int(11) DEFAULT '0' NOT NULL,
t3ver_id int(11) DEFAULT '0' NOT NULL,
t3ver_label varchar(30) DEFAULT '' NOT NULL,
deleted tinyint(4) DEFAULT '0' NOT NULL,
hidden tinyint(4) DEFAULT '0' NOT NULL,
starttime int(11) DEFAULT '0' NOT NULL,
endtime int(11) DEFAULT '0' NOT NULL,
fe_group int(11) DEFAULT '0' NOT NULL,
title varchar(80) DEFAULT '' NOT NULL,
subtitle varchar(80) DEFAULT '' NOT NULL,
itemnumber varchar(40) DEFAULT '' NOT NULL,
price decimal(19,2) DEFAULT '0.00' NOT NULL,
price2 decimal(19,2) DEFAULT '0.00' NOT NULL,
note text NOT NULL,
note2 text NOT NULL,
image text NOT NULL,
inStock int(11) DEFAULT '1' NOT NULL,
basketminquantity decimal(19,2) DEFAULT '0.00' NOT NULL,
weight decimal(19,6) DEFAULT '0.000000' NOT NULL,
color mediumtext NOT NULL,
color2 mediumtext NOT NULL,
color3 mediumtext NOT NULL,
size mediumtext NOT NULL,
size2 mediumtext NOT NULL,
size3 mediumtext NOT NULL,
description mediumtext NOT NULL,
gradings mediumtext NOT NULL,
material mediumtext NOT NULL,
quality mediumtext NOT NULL,
config_type varchar(36) DEFAULT '' NOT NULL,
config mediumtext NOT NULL,
uid_product int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
KEY comp1 (pid,deleted,sorting),
);
#
# Table structure for table 'tt_products_articles_language'
#
CREATE TABLE tt_products_articles_language (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
sorting int(10) DEFAULT '0' NOT NULL,
t3ver_oid int(11) DEFAULT '0' NOT NULL,
t3ver_id int(11) DEFAULT '0' NOT NULL,
t3ver_label varchar(30) DEFAULT '' NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
deleted tinyint(4) DEFAULT '0' NOT NULL,
hidden tinyint(4) DEFAULT '0' NOT NULL,
starttime int(11) DEFAULT '0' NOT NULL,
endtime int(11) DEFAULT '0' NOT NULL,
fe_group int(11) DEFAULT '0' NOT NULL,
title varchar(80) DEFAULT '' NOT NULL,
subtitle varchar(80) DEFAULT '' NOT NULL,
article_uid int(11) DEFAULT '0' NOT NULL,
note text NOT NULL,
note2 text NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
KEY comp1 (pid,deleted,sorting),
);
#
# Table structure for table 'tt_products_gifts'
#
CREATE TABLE tt_products_gifts (
uid int(11) DEFAULT '0' NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
deleted tinyint(4) DEFAULT '0' NOT NULL,
sorting int(10) DEFAULT '0' NOT NULL,
ordernumber int(11) DEFAULT '0' NOT NULL,
personname varchar(80) DEFAULT '' NOT NULL,
personemail varchar(80) DEFAULT '' NOT NULL,
deliveryname varchar(80) DEFAULT '' NOT NULL,
deliveryemail varchar(80) DEFAULT '' NOT NULL,
note text NOT NULL,
amount decimal(19,2) DEFAULT '0.00' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
KEY comp1 (pid,deleted,sorting),
);
#
# Table structure for table 'tt_products_gifts_articles_mm'
#
#
CREATE TABLE tt_products_gifts_articles_mm (
uid_local int(11) DEFAULT '0' NOT NULL,
uid_foreign int(11) DEFAULT '0' NOT NULL,
count int(11) DEFAULT '0' NOT NULL,
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign),
);
#
# Table structure for table 'tt_products_emails'
#
CREATE TABLE tt_products_emails (
uid int(11) DEFAULT '0' NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
sorting int(10) DEFAULT '0' NOT NULL,
t3ver_oid int(11) DEFAULT '0' NOT NULL,
t3ver_id int(11) DEFAULT '0' NOT NULL,
t3ver_label varchar(30) DEFAULT '' NOT NULL,
deleted tinyint(4) DEFAULT '0' NOT NULL,
hidden tinyint(4) DEFAULT '0' NOT NULL,
starttime int(11) DEFAULT '0' NOT NULL,
endtime int(11) DEFAULT '0' NOT NULL,
fe_group int(11) DEFAULT '0' NOT NULL,
name varchar(80) DEFAULT '' NOT NULL,
email varchar(80) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
KEY comp1 (pid,deleted,sorting),
);
#
# Table structure for table 'tt_products_texts'
#
CREATE TABLE tt_products_texts (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
sorting int(10) DEFAULT '0' NOT NULL,
deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
starttime int(11) DEFAULT '0' NOT NULL,
endtime int(11) DEFAULT '0' NOT NULL,
fe_group int(11) DEFAULT '0' NOT NULL,
title tinytext NOT NULL,
marker varchar(30) DEFAULT '' NOT NULL,
note text NOT NULL,
parentid int(11) DEFAULT '0' NOT NULL,
parenttable varchar(30) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
KEY comp1 (pid,deleted,sorting),
);
#
# Table structure for table 'tt_products_texts_language'
#
CREATE TABLE tt_products_texts_language (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
sorting int(10) DEFAULT '0' NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
deleted tinyint(4) DEFAULT '0' NOT NULL,
hidden tinyint(4) DEFAULT '0' NOT NULL,
starttime int(11) DEFAULT '0' NOT NULL,
endtime int(11) DEFAULT '0' NOT NULL,
fe_group int(11) DEFAULT '0' NOT NULL,
text_uid int(11) DEFAULT '0' NOT NULL,
title tinytext NOT NULL,
note text NOT NULL,
parentid int(11) DEFAULT '0' NOT NULL,
parenttable varchar(30) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
KEY comp1 (pid,deleted,sorting),
);
#
# Table structure for table 'tt_products_products_mm_graduated_price'
#
CREATE TABLE tt_products_mm_graduated_price (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
title tinytext NOT NULL,
product_uid int(11) DEFAULT '0' NOT NULL,
graduated_price_uid int(11) DEFAULT '0' NOT NULL,
tablenames varchar(30) DEFAULT '' NOT NULL,
productsort int(10) DEFAULT '0' NOT NULL,
graduatedsort int(10) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY product_uid (product_uid),
KEY graduated_price_uid (graduated_price_uid),
KEY parent (pid)
);
#
# Table structure for table 'tt_products_graduated_price'
#
CREATE TABLE tt_products_graduated_price (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
sorting int(10) DEFAULT '0' NOT NULL,
deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
starttime int(11) DEFAULT '0' NOT NULL,
endtime int(11) DEFAULT '0' NOT NULL,
fe_group int(11) DEFAULT '0' NOT NULL,
title tinytext NOT NULL,
formula text NOT NULL,
startamount decimal(19,2) DEFAULT '0.00' NOT NULL,
note text NOT NULL,
items int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
KEY comp1 (pid,deleted,sorting),
);
#
# Table structure for table 'sys_products_accounts'
#
CREATE TABLE sys_products_accounts (
uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
owner_name varchar(255) DEFAULT '' NOT NULL,
ac_number varchar(255) DEFAULT '' NOT NULL,
bic varchar(11) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'sys_products_cards'
#
CREATE TABLE sys_products_cards (
uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
endtime int(11) DEFAULT '0' NOT NULL,
owner_name varchar(255) DEFAULT '' NOT NULL,
cc_number varchar(255) DEFAULT '' NOT NULL,
cc_type varchar(20) DEFAULT '' NOT NULL,
cvv2 int(11) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'sys_products_orders'
#
CREATE TABLE sys_products_orders (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
feusers_uid int(11) DEFAULT '0' NOT NULL,
name varchar(80) DEFAULT '' NOT NULL,
first_name varchar(50) DEFAULT '' NOT NULL,
last_name varchar(50) DEFAULT '' NOT NULL,
salutation int(11) DEFAULT '0' NOT NULL,
company varchar(80) DEFAULT '' NOT NULL,
vat_id varchar(20) DEFAULT '' NOT NULL,
address tinytext NOT NULL,
zip varchar(20) DEFAULT '' NOT NULL,
city varchar(50) DEFAULT '' NOT NULL,
country varchar(60) DEFAULT '' NOT NULL,
# country_code char(3) DEFAULT '' NOT NULL,
telephone varchar(20) DEFAULT '' NOT NULL,
email varchar(80) DEFAULT '' NOT NULL,
fax varchar(20) DEFAULT '' NOT NULL,
business_partner int(11) DEFAULT '0' NOT NULL,
organisation_form varchar(2) DEFAULT 'U' NOT NULL,
payment varchar(80) DEFAULT '' NOT NULL,
shipping varchar(80) DEFAULT '' NOT NULL,
amount decimal(19,2) DEFAULT '0.00' NOT NULL,
tax_mode tinyint(3) DEFAULT '0' NOT NULL,
pay_mode tinyint(3) DEFAULT '0' NOT NULL,
email_notify tinyint(4) unsigned DEFAULT '0' NOT NULL,
tracking_code varchar(64) DEFAULT '' NOT NULL,
status tinyint(4) unsigned DEFAULT '0' NOT NULL,
status_log blob NOT NULL,
orderData mediumblob NOT NULL,
# session_id varchar(30) DEFAULT '' NOT NULL,
# amount_num int(10) unsigned DEFAULT '0' NOT NULL,
creditpoints decimal(10,0) default '0' NOT NULL,
creditpoints_spended decimal(10,0) default '0' NOT NULL,
creditpoints_saved decimal(10,0) default '0' NOT NULL,
creditpoints_gifts decimal(10,0) default '0' NOT NULL,
agb tinyint(1) DEFAULT '0' NOT NULL,
desired_date varchar(30) DEFAULT '' NOT NULL,
desired_time varchar(30) DEFAULT '' NOT NULL,
client_ip varchar(15) DEFAULT '' NOT NULL,
note text NOT NULL,
giftservice text NOT NULL,
cc_uid int(11) unsigned DEFAULT '0' NOT NULL,
ac_uid int(11) unsigned DEFAULT '0' NOT NULL,
foundby int(11) DEFAULT '0' NOT NULL,
giftcode varchar(80) DEFAULT '' NOT NULL,
date_of_birth int(11) DEFAULT '0' NOT NULL,
date_of_payment int(11) DEFAULT '0' NOT NULL,
date_of_delivery int(11) DEFAULT '0' NOT NULL,
bill_no varchar(80) DEFAULT '' NOT NULL,
radio1 int(11) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY tracking (tracking_code),
KEY status (status)
KEY comp1 (pid,deleted),
);
#
# Table structure for table 'sys_products_orders_mm_tt_products'
#
CREATE TABLE sys_products_orders_mm_tt_products (
sys_products_orders_uid int(11) unsigned DEFAULT '0' NOT NULL,
sys_products_orders_qty int(11) unsigned DEFAULT '0' NOT NULL,
tt_products_uid int(11) unsigned DEFAULT '0' NOT NULL,
tt_products_articles_uid int(11) unsigned DEFAULT '0' NOT NULL,
tablenames varchar(50) DEFAULT '' NOT NULL,
KEY tt_products_uid (tt_products_uid),
KEY tt_products_articles_uid (tt_products_articles_uid),
KEY sys_products_orders_uid (sys_products_orders_uid)
);
#
# Table structure for table 'fe_users'
#
CREATE TABLE fe_users (
tt_products_memoItems tinytext NOT NULL,
tt_products_memodam tinytext NOT NULL,
tt_products_discount decimal(19,2) DEFAULT '0.00' NOT NULL,
tt_products_creditpoints decimal(10,0) DEFAULT '0' NOT NULL,
tt_products_vouchercode varchar(50) DEFAULT '',
tt_products_vat varchar(15) DEFAULT '' NOT NULL,
tt_products_business_partner int(11) DEFAULT '0' NOT NULL,
tt_products_organisation_form varchar(2) DEFAULT 'U' NOT NULL
);
#
# Table structure for table 'pages_language_overlay'
#
CREATE TABLE pages_language_overlay (
sorting int(11) DEFAULT '0' NOT NULL,
);
#
# Table structure for table 'tt_products_products_mm_damcat'
#
CREATE TABLE tt_products_products_mm_damcat (
uid_local int(11) unsigned DEFAULT '0' NOT NULL,
uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
tablenames varchar(30) DEFAULT '' NOT NULL,
sorting int(11) unsigned DEFAULT '0' NOT NULL,
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
);
### cache tables needed only for TYPO3 4.3 - 4.5
#
# TABLE structure FOR TABLE 'tt_products_cache'
#
CREATE TABLE tt_products_cache (
id int(11) unsigned NOT NULL auto_increment,
identifier varchar(250) DEFAULT '' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
content mediumblob,
lifetime int(11) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (id),
KEY cache_id (identifier)
) ENGINE=InnoDB;
#
# TABLE structure FOR TABLE 'tt_products_cache_tags'
#
CREATE TABLE tt_products_cache_tags (
id int(11) unsigned NOT NULL auto_increment,
identifier varchar(250) DEFAULT '' NOT NULL,
tag varchar(250) DEFAULT '' NOT NULL,
PRIMARY KEY (id),
KEY cache_id (identifier),
KEY cache_tag (tag)
) ENGINE=InnoDB;