0QfqLbqS

1-- Adminer 4.6.3 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8DROP TABLE IF EXISTS `abc_discount_group`;
9CREATE TABLE `abc_discount_group` (
10  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
11  `discount_site_id` int(11) unsigned NOT NULL,
12  `has_discount` tinyint(1) unsigned NOT NULL,
13  `discount_type` tinyint(1) NOT NULL,
14  `discount_value` double unsigned NOT NULL,
15  `order_id` int(11) NOT NULL,
16  PRIMARY KEY (`id`)
17) ENGINE=InnoDB DEFAULT CHARSET=latin1;
18
19
20DROP TABLE IF EXISTS `abc_discount_group_x_producttypes`;
21CREATE TABLE `abc_discount_group_x_producttypes` (
22  `id` int(11) NOT NULL AUTO_INCREMENT,
23  `abc_discount_group_id` int(11) unsigned NOT NULL,
24  `product_type_id` int(11) NOT NULL,
25  PRIMARY KEY (`id`),
26  KEY `abc_discount_group_id` (`abc_discount_group_id`,`product_type_id`)
27) ENGINE=InnoDB DEFAULT CHARSET=latin1;
28
29
30DROP TABLE IF EXISTS `abc_productjumps`;
31CREATE TABLE `abc_productjumps` (
32  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
33  `productgroup_id` int(11) unsigned NOT NULL,
34  `productjump_id` int(11) NOT NULL DEFAULT '0',
35  `productjump_v5_id` int(11) NOT NULL DEFAULT '0',
36  `order_id` int(11) NOT NULL,
37  PRIMARY KEY (`id`)
38) ENGINE=InnoDB DEFAULT CHARSET=latin1;
39
40
41DROP TABLE IF EXISTS `acl_resources`;
42CREATE TABLE `acl_resources` (
43  `id` int(12) NOT NULL AUTO_INCREMENT,
44  `resource` text COLLATE utf8_unicode_ci NOT NULL,
45  PRIMARY KEY (`id`)
46) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
47
48
49DROP TABLE IF EXISTS `acl_rules`;
50CREATE TABLE `acl_rules` (
51  `id` int(12) NOT NULL AUTO_INCREMENT,
52  `userId` int(12) NOT NULL,
53  `resourceId` int(12) NOT NULL,
54  PRIMARY KEY (`id`)
55) ENGINE=InnoDB DEFAULT CHARSET=latin1;
56
57
58DROP TABLE IF EXISTS `addresses`;
59CREATE TABLE `addresses` (
60  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
61  `type` enum('customer','financial','delivery') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'customer',
62  `first_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
63  `insertion` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
64  `last_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
65  `gender_id` int(11) DEFAULT NULL,
66  `street` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
67  `number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
68  `suffix` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
69  `zipcode` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
70  `city` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
71  `region_id` int(11) DEFAULT NULL,
72  `region` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
73  `country_id` int(11) DEFAULT NULL,
74  `country` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
75  `phone` varchar(25) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
76  `extra` text COLLATE utf8_unicode_ci,
77  `kiosk_address_id` int(10) NOT NULL DEFAULT '0',
78  `company_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
79  `external_address_provider_handle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
80  `birth_date` date DEFAULT NULL,
81  `mailbox` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
82  PRIMARY KEY (`id`)
83) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
84
85
86DROP TABLE IF EXISTS `address_book`;
87CREATE TABLE `address_book` (
88  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
89  `type` enum('customer','financial','delivery') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'customer',
90  `customer_id` int(11) NOT NULL DEFAULT '0',
91  `first_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
92  `insertion` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
93  `last_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
94  `company_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
95  `gender_id` int(11) DEFAULT NULL,
96  `street` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
97  `number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
98  `suffix` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
99  `zipcode` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
100  `city` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
101  `region_id` int(11) DEFAULT NULL,
102  `region` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
103  `country_id` int(11) DEFAULT NULL,
104  `country` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
105  `phone` varchar(25) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
106  `extra` text COLLATE utf8_unicode_ci,
107  `kiosk_address_id` int(10) NOT NULL DEFAULT '0',
108  `default_address` int(1) NOT NULL DEFAULT '0',
109  `mailbox` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
110  PRIMARY KEY (`id`),
111  KEY `customer_id_default_address_index` (`customer_id`,`default_address`)
112) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
113
114
115DROP TABLE IF EXISTS `address_layout`;
116CREATE TABLE `address_layout` (
117  `id` int(10) NOT NULL AUTO_INCREMENT,
118  `name` varchar(255) NOT NULL,
119  `layout` text NOT NULL,
120  `layout_v5` text NOT NULL,
121  PRIMARY KEY (`id`)
122) ENGINE=InnoDB DEFAULT CHARSET=latin1;
123
124
125DROP TABLE IF EXISTS `apps`;
126CREATE TABLE `apps` (
127  `id` int(11) NOT NULL AUTO_INCREMENT,
128  `system_name` varchar(255) NOT NULL,
129  `date_from` date NOT NULL,
130  `date_to` date NOT NULL,
131  `bg_image` varchar(255) DEFAULT NULL,
132  `center_spin_image` varchar(255) DEFAULT NULL,
133  `spins` int(11) NOT NULL DEFAULT '1',
134  `fb_app_id` varchar(255) NOT NULL,
135  `fb_app_secret` varchar(255) NOT NULL,
136  PRIMARY KEY (`id`)
137) ENGINE=InnoDB DEFAULT CHARSET=utf8;
138
139
140DROP TABLE IF EXISTS `apps_prizes`;
141CREATE TABLE `apps_prizes` (
142  `id` int(11) NOT NULL AUTO_INCREMENT,
143  `app_id` int(11) NOT NULL,
144  `prize_id` int(11) NOT NULL,
145  `discount_site_id` int(11) DEFAULT NULL,
146  `system_name` varchar(255) NOT NULL,
147  `frequency` int(11) NOT NULL COMMENT 'Times a day that a prize is given away',
148  `image` varchar(255) NOT NULL,
149  `sequence` int(11) NOT NULL,
150  PRIMARY KEY (`id`)
151) ENGINE=InnoDB DEFAULT CHARSET=utf8;
152
153
154DROP TABLE IF EXISTS `apps_prizes_translations`;
155CREATE TABLE `apps_prizes_translations` (
156  `id` int(11) NOT NULL AUTO_INCREMENT,
157  `language_id` int(11) NOT NULL,
158  `app_prize_id` int(11) NOT NULL,
159  `translation` varchar(255) NOT NULL,
160  PRIMARY KEY (`id`),
161  UNIQUE KEY `app_prizes_translations_idx` (`language_id`,`app_prize_id`)
162) ENGINE=InnoDB DEFAULT CHARSET=utf8;
163
164
165DROP TABLE IF EXISTS `apps_prizes_types`;
166CREATE TABLE `apps_prizes_types` (
167  `id` int(11) NOT NULL AUTO_INCREMENT,
168  `system_name` varchar(255) NOT NULL,
169  `show_in_winners` int(11) NOT NULL DEFAULT '0' COMMENT 'Show this prize in /cms/app/winners?',
170  PRIMARY KEY (`id`)
171) ENGINE=InnoDB DEFAULT CHARSET=utf8;
172
173
174DROP TABLE IF EXISTS `apps_prizes_won`;
175CREATE TABLE `apps_prizes_won` (
176  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
177  `app_id` int(10) unsigned NOT NULL,
178  `user_id` int(10) unsigned NOT NULL,
179  `fb_id` int(10) unsigned NOT NULL,
180  `name` varchar(255) DEFAULT NULL,
181  `email_address` varchar(255) NOT NULL,
182  `prize_id` int(10) unsigned NOT NULL,
183  `date` int(10) unsigned NOT NULL,
184  PRIMARY KEY (`id`),
185  KEY `apps_prizes_won_app_id_user_id_idx` (`app_id`,`user_id`)
186) ENGINE=InnoDB DEFAULT CHARSET=utf8;
187
188
189DROP TABLE IF EXISTS `apps_spins`;
190CREATE TABLE `apps_spins` (
191  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
192  `app_id` int(10) unsigned NOT NULL,
193  `user_id` int(10) unsigned NOT NULL,
194  `prize_id` int(10) unsigned DEFAULT NULL,
195  `discount_site_code_id` int(11) DEFAULT NULL,
196  `date` int(10) unsigned NOT NULL,
197  `finished` int(11) DEFAULT NULL,
198  PRIMARY KEY (`id`),
199  KEY `apps_spins_app_id_user_id_idx` (`app_id`,`user_id`)
200) ENGINE=InnoDB DEFAULT CHARSET=utf8;
201
202
203DROP TABLE IF EXISTS `apps_translations`;
204CREATE TABLE `apps_translations` (
205  `id` int(11) NOT NULL AUTO_INCREMENT,
206  `app_id` int(11) NOT NULL,
207  `translation_id` int(11) NOT NULL,
208  `language_id` int(11) NOT NULL,
209  `translation` varchar(255) NOT NULL,
210  PRIMARY KEY (`id`),
211  UNIQUE KEY `app_translation_language_idx` (`app_id`,`translation_id`,`language_id`)
212) ENGINE=InnoDB DEFAULT CHARSET=utf8;
213
214
215DROP TABLE IF EXISTS `apps_translation_items`;
216CREATE TABLE `apps_translation_items` (
217  `id` int(11) NOT NULL AUTO_INCREMENT,
218  `item` varchar(255) NOT NULL,
219  `input_type` varchar(12) NOT NULL DEFAULT 'input',
220  PRIMARY KEY (`id`)
221) ENGINE=InnoDB DEFAULT CHARSET=utf8;
222
223
224DROP TABLE IF EXISTS `apps_users`;
225CREATE TABLE `apps_users` (
226  `id` int(11) NOT NULL AUTO_INCREMENT,
227  `identifier` bigint(20) NOT NULL COMMENT 'Probably the Facebook user ID',
228  `email_address` varchar(255) DEFAULT NULL,
229  `date_created` int(10) unsigned NOT NULL,
230  `date_last_seen` int(10) unsigned NOT NULL,
231  `name_user` varchar(45) DEFAULT NULL,
232  PRIMARY KEY (`id`)
233) ENGINE=InnoDB DEFAULT CHARSET=utf8;
234
235
236DROP TABLE IF EXISTS `app_bonus_spins`;
237CREATE TABLE `app_bonus_spins` (
238  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
239  `app_id` int(10) unsigned NOT NULL,
240  `user_id` int(10) unsigned NOT NULL,
241  `date` int(10) unsigned NOT NULL,
242  `finished` int(10) DEFAULT NULL,
243  PRIMARY KEY (`id`)
244) ENGINE=InnoDB DEFAULT CHARSET=utf8;
245
246
247DROP TABLE IF EXISTS `auth_ip`;
248CREATE TABLE `auth_ip` (
249  `id` int(12) NOT NULL AUTO_INCREMENT,
250  `ip` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
251  `active` tinyint(1) NOT NULL,
252  `label` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
253  PRIMARY KEY (`id`)
254) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
255
256
257DROP TABLE IF EXISTS `banner`;
258CREATE TABLE `banner` (
259  `id` int(11) NOT NULL AUTO_INCREMENT,
260  `language_id` int(11) NOT NULL,
261  `url_banner_1` varchar(255) NOT NULL,
262  `url_banner_2` varchar(255) NOT NULL,
263  `url_banner_3` varchar(255) NOT NULL,
264  `input_color_banner_1` varchar(255) NOT NULL DEFAULT '#000',
265  `input_color_banner_2` varchar(255) NOT NULL DEFAULT '#000',
266  `input_color_banner_3` varchar(255) NOT NULL DEFAULT '#000',
267  `text_line_1` varchar(255) NOT NULL,
268  `text_color_line_1` varchar(255) NOT NULL DEFAULT '#FFF',
269  `text_line_2` varchar(255) NOT NULL,
270  `text_color_line_2` varchar(255) NOT NULL DEFAULT '#FFF',
271  PRIMARY KEY (`id`)
272) ENGINE=InnoDB DEFAULT CHARSET=utf8;
273
274
275DROP TABLE IF EXISTS `category_page_categories`;
276CREATE TABLE `category_page_categories` (
277  `id` int(11) NOT NULL AUTO_INCREMENT,
278  `system_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
279  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
280  PRIMARY KEY (`id`),
281  UNIQUE KEY `system_name_UNIQUE` (`system_name`)
282) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
283
284
285DROP TABLE IF EXISTS `category_page_items`;
286CREATE TABLE `category_page_items` (
287  `id` int(11) NOT NULL AUTO_INCREMENT,
288  `category_page_category_id` int(11) NOT NULL,
289  `product_type_id` int(10) DEFAULT '0',
290  `system_name` varchar(255) NOT NULL,
291  `sequence` int(3) NOT NULL,
292  `active` tinyint(3) unsigned NOT NULL DEFAULT '0',
293  `product_banner_id` int(11) NOT NULL,
294  `temporary_price` float DEFAULT NULL,
295  `start_datetime` datetime DEFAULT NULL,
296  `end_datetime` datetime DEFAULT NULL,
297  `temporary_discount_id` int(10) NOT NULL DEFAULT '0',
298  `show_number_of_colors` tinyint(1) DEFAULT NULL,
299  PRIMARY KEY (`id`),
300  KEY `category_page_category_id` (`category_page_category_id`),
301  KEY `product_type_id` (`product_type_id`)
302) ENGINE=InnoDB DEFAULT CHARSET=latin1;
303
304
305DROP TABLE IF EXISTS `category_page_product_banners`;
306CREATE TABLE `category_page_product_banners` (
307  `id` int(11) NOT NULL AUTO_INCREMENT,
308  `item` varchar(255) NOT NULL,
309  PRIMARY KEY (`id`)
310) ENGINE=InnoDB DEFAULT CHARSET=latin1;
311
312
313DROP TABLE IF EXISTS `children`;
314CREATE TABLE `children` (
315  `id` int(11) NOT NULL AUTO_INCREMENT,
316  `customer_id` int(11) NOT NULL,
317  `firstname` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
318  `birthdate` date NOT NULL,
319  `gender_id` int(11) NOT NULL DEFAULT '3',
320  `copernica` int(1) NOT NULL COMMENT 'copernica',
321  `created` datetime NOT NULL,
322  PRIMARY KEY (`id`),
323  KEY `customer_id` (`customer_id`),
324  KEY `copernica` (`copernica`),
325  KEY `birthdate` (`birthdate`)
326) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
327
328
329DROP TABLE IF EXISTS `cib_activity_log`;
330CREATE TABLE `cib_activity_log` (
331  `id` int(11) NOT NULL AUTO_INCREMENT,
332  `datetime` varchar(45) DEFAULT NULL,
333  `path` varchar(45) DEFAULT NULL,
334  `kiosk_id` int(8) NOT NULL,
335  PRIMARY KEY (`id`)
336) ENGINE=InnoDB DEFAULT CHARSET=latin1;
337
338
339DROP TABLE IF EXISTS `cib_log`;
340CREATE TABLE `cib_log` (
341  `id` int(11) NOT NULL AUTO_INCREMENT,
342  `event_code` tinytext,
343  `merchant_reference` int(11) DEFAULT NULL,
344  `merchant_account_code` varchar(45) DEFAULT NULL,
345  `payment_method` varchar(45) DEFAULT NULL,
346  `event_date` datetime DEFAULT NULL,
347  `currency` varchar(45) DEFAULT NULL,
348  `value` int(11) DEFAULT NULL,
349  `signature` varchar(255) DEFAULT NULL,
350  PRIMARY KEY (`id`)
351) ENGINE=InnoDB DEFAULT CHARSET=latin1;
352
353
354DROP TABLE IF EXISTS `ClickTaleCache`;
355CREATE TABLE `ClickTaleCache` (
356  `cache_key` varchar(20) NOT NULL,
357  `block_num` int(10) unsigned NOT NULL,
358  `block_contents` varchar(230) NOT NULL,
359  `timestamp` int(10) unsigned NOT NULL,
360  PRIMARY KEY (`cache_key`,`block_num`)
361) ENGINE=MEMORY DEFAULT CHARSET=latin1;
362
363
364DROP TABLE IF EXISTS `companies`;
365CREATE TABLE `companies` (
366  `id` int(11) NOT NULL AUTO_INCREMENT,
367  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
368  `commercial_register` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
369  `credit` float NOT NULL DEFAULT '0',
370  `balance` float NOT NULL DEFAULT '0',
371  `debit_days` int(11) NOT NULL DEFAULT '0',
372  `second_debit_days` int(11) NOT NULL,
373  `credit_worthy` tinyint(1) NOT NULL DEFAULT '1',
374  `active` tinyint(1) NOT NULL DEFAULT '1',
375  `bcc_addresses` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
376  PRIMARY KEY (`id`)
377) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
378
379
380DROP TABLE IF EXISTS `company_orders`;
381CREATE TABLE `company_orders` (
382  `id` int(11) NOT NULL AUTO_INCREMENT,
383  `company_id` int(11) NOT NULL,
384  `order_id` int(11) NOT NULL,
385  `payment_date` datetime NOT NULL,
386  `reminder_sent` tinyint(1) NOT NULL DEFAULT '0',
387  PRIMARY KEY (`id`),
388  KEY `company_id` (`company_id`,`order_id`)
389) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
390
391
392DROP TABLE IF EXISTS `company_tokens`;
393CREATE TABLE `company_tokens` (
394  `id` int(11) NOT NULL AUTO_INCREMENT,
395  `company_id` int(11) NOT NULL,
396  `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
397  `active` tinyint(1) NOT NULL DEFAULT '1',
398  PRIMARY KEY (`id`),
399  KEY `company_id` (`company_id`)
400) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
401
402
403DROP TABLE IF EXISTS `complaints`;
404CREATE TABLE `complaints` (
405  `id` int(11) NOT NULL AUTO_INCREMENT,
406  `order_rule_product_id` int(11) NOT NULL,
407  `type_complaint` int(11) NOT NULL,
408  `text_complaint` mediumtext NOT NULL,
409  `date_complaint` datetime NOT NULL,
410  `cms_user` varchar(45) NOT NULL,
411  PRIMARY KEY (`id`)
412) ENGINE=InnoDB DEFAULT CHARSET=latin1;
413
414
415DROP TABLE IF EXISTS `complaint_types`;
416CREATE TABLE `complaint_types` (
417  `id` int(11) NOT NULL AUTO_INCREMENT,
418  `system_name` varchar(45) NOT NULL,
419  `active` tinyint(3) unsigned NOT NULL DEFAULT '0',
420  PRIMARY KEY (`id`)
421) ENGINE=InnoDB DEFAULT CHARSET=latin1;
422
423
424DROP TABLE IF EXISTS `configurations`;
425CREATE TABLE `configurations` (
426  `id` int(11) NOT NULL AUTO_INCREMENT,
427  `active` tinyint(1) NOT NULL DEFAULT '1',
428  `price_print_illustration_text` float NOT NULL DEFAULT '0',
429  `price_print_fullcolor` float NOT NULL DEFAULT '0',
430  `price_print_strass` float NOT NULL,
431  `price_print_multiple_text_lines` float NOT NULL DEFAULT '0',
432  `price_gift_service` float NOT NULL DEFAULT '0',
433  `cart_return_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '/',
434  `service_mail_days` int(11) NOT NULL DEFAULT '0',
435  `free_shipping_from` float NOT NULL DEFAULT '0',
436  `express_orders` tinyint(1) NOT NULL DEFAULT '0',
437  `express_order_costs` float NOT NULL DEFAULT '0',
438  `express_shipping_costs` float unsigned NOT NULL DEFAULT '0',
439  `valuta_sign_left` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
440  `valuta_sign_right` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
441  `vat_included` tinyint(1) NOT NULL DEFAULT '1',
442  `vat_percentage` float NOT NULL DEFAULT '0',
443  `emails_from` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
444  `emails_from_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
445  `emails_bcc` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
446  `emails_bcc_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
447  `order_reminder_days` int(11) DEFAULT NULL,
448  `default_country_id` int(11) DEFAULT NULL,
449  `default_language_id` int(11) DEFAULT NULL,
450  `order_auto_delete_days` int(11) DEFAULT NULL,
451  `site_id` int(11) NOT NULL,
452  `price_print_picture` float NOT NULL,
453  `shippingCostTax` int(5) NOT NULL DEFAULT '0',
454  `useShippingCostTax` int(1) NOT NULL DEFAULT '0',
455  `rushOrderCostTax` int(5) NOT NULL DEFAULT '0',
456  `userushOrderCostTax` int(1) NOT NULL DEFAULT '0',
457  `giftServiceCostTax` int(5) NOT NULL DEFAULT '0',
458  `usegiftServiceCostTax` int(1) NOT NULL DEFAULT '0',
459  `paymentCostTax` int(5) NOT NULL DEFAULT '0',
460  `usepaymentCostTax` int(1) NOT NULL DEFAULT '0',
461  PRIMARY KEY (`id`)
462) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
463
464
465DROP TABLE IF EXISTS `contents`;
466CREATE TABLE `contents` (
467  `id` int(11) NOT NULL AUTO_INCREMENT,
468  `system_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
469  `active` tinyint(1) NOT NULL DEFAULT '1',
470  PRIMARY KEY (`id`),
471  UNIQUE KEY `sn` (`system_name`)
472) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
473
474
475DROP TABLE IF EXISTS `copernicaSyncLog`;
476CREATE TABLE `copernicaSyncLog` (
477  `id` int(255) NOT NULL AUTO_INCREMENT,
478  `syncDate` datetime NOT NULL,
479  `entityType` varchar(255) NOT NULL,
480  `change` varchar(255) NOT NULL,
481  `entityId` varchar(255) NOT NULL,
482  PRIMARY KEY (`id`)
483) ENGINE=InnoDB DEFAULT CHARSET=latin1;
484
485
486DROP TABLE IF EXISTS `customerIdentities`;
487CREATE TABLE `customerIdentities` (
488  `id` int(20) NOT NULL AUTO_INCREMENT,
489  `discriminator` varchar(255) NOT NULL,
490  `customer` int(20) NOT NULL,
491  PRIMARY KEY (`id`),
492  KEY `customer` (`customer`)
493) ENGINE=InnoDB DEFAULT CHARSET=latin1;
494
495
496DROP TABLE IF EXISTS `customerIdentities_hashedPassword`;
497CREATE TABLE `customerIdentities_hashedPassword` (
498  `id` int(20) NOT NULL,
499  `passwordhash` varchar(50) NOT NULL,
500  KEY `id` (`id`,`passwordhash`)
501) ENGINE=InnoDB DEFAULT CHARSET=latin1;
502
503
504DROP TABLE IF EXISTS `customerIdentities_secureCookie`;
505CREATE TABLE `customerIdentities_secureCookie` (
506  `id` int(20) NOT NULL,
507  `hash` varchar(50) NOT NULL,
508  `hashCreationDate` datetime NOT NULL,
509  KEY `id` (`id`)
510) ENGINE=InnoDB DEFAULT CHARSET=latin1;
511
512
513DROP TABLE IF EXISTS `customers`;
514CREATE TABLE `customers` (
515  `id` int(11) NOT NULL AUTO_INCREMENT,
516  `address_id` int(11) NOT NULL,
517  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
518  `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
519  `phone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
520  `language_id` int(11) NOT NULL,
521  `company_id` int(11) DEFAULT NULL,
522  `active` tinyint(1) NOT NULL DEFAULT '1',
523  `is_v1` tinyint(1) NOT NULL DEFAULT '0',
524  `VATnumber` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
525  `apiaccess` smallint(1) NOT NULL DEFAULT '0',
526  `partner_leadsource_id` int(10) NOT NULL,
527  `childrenNewsletter` tinyint(1) NOT NULL DEFAULT '1',
528  `usedInV3` int(1) NOT NULL DEFAULT '0',
529  `copernica` int(1) NOT NULL,
530  `cop_sync_date` int(10) NOT NULL,
531  `guest` int(1) NOT NULL DEFAULT '0',
532  `subscription_import` int(1) NOT NULL DEFAULT '0',
533  `force_algemeen_update` int(11) NOT NULL,
534  `force_baby_update` int(11) NOT NULL,
535  PRIMARY KEY (`id`),
536  KEY `address_id` (`address_id`,`company_id`),
537  KEY `email` (`email`),
538  KEY `company_id` (`company_id`),
539  KEY `cop_sync_date` (`cop_sync_date`),
540  KEY `guest` (`guest`)
541) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
542
543
544DROP TABLE IF EXISTS `customer_product_designs`;
545CREATE TABLE `customer_product_designs` (
546  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
547  `customer_id` int(10) unsigned NOT NULL,
548  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
549  `uuid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
550  PRIMARY KEY (`id`),
551  KEY `customer_id` (`customer_id`)
552) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
553
554
555DROP TABLE IF EXISTS `customer_service_images`;
556CREATE TABLE `customer_service_images` (
557  `id` int(11) NOT NULL AUTO_INCREMENT,
558  `type` varchar(50) NOT NULL COMMENT 'values:{wellcome,product, print, delivery_policy, order, pay, conditions}',
559  `language_id` int(11) NOT NULL,
560  `image_path` varchar(150) NOT NULL,
561  `image_url` varchar(150) NOT NULL,
562  `image_alt` varchar(45) NOT NULL,
563  PRIMARY KEY (`id`),
564  UNIQUE KEY `unique_indx` (`language_id`,`type`)
565) ENGINE=InnoDB DEFAULT CHARSET=latin1;
566
567
568DROP TABLE IF EXISTS `customer_subscriptions`;
569CREATE TABLE `customer_subscriptions` (
570  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
571  `customer_id` int(11) unsigned DEFAULT NULL,
572  `subscription_id` int(11) unsigned DEFAULT NULL,
573  `opt_in` tinyint(1) DEFAULT NULL,
574  `opt_in_datetime` datetime DEFAULT NULL,
575  `opt_out` tinyint(1) DEFAULT NULL,
576  `opt_out_datetime` datetime DEFAULT NULL,
577  PRIMARY KEY (`id`),
578  UNIQUE KEY `customer_id_uindex` (`customer_id`,`subscription_id`),
579  KEY `opt_in_datetime_index` (`opt_in_datetime`)
580) ENGINE=InnoDB DEFAULT CHARSET=latin1;
581
582INSERT INTO `customer_subscriptions` (`id`, `customer_id`, `subscription_id`, `opt_in`, `opt_in_datetime`, `opt_out`, `opt_out_datetime`) VALUES
583(1036526,	1069192,	1,	0,	'0000-00-00 00:00:00',	1,	'2018-08-29 13:45:45'),
584(1036528,	1069193,	1,	0,	'0000-00-00 00:00:00',	1,	'2018-08-29 16:03:15');
585
586DROP TABLE IF EXISTS `customer_subscriptions_org`;
587CREATE TABLE `customer_subscriptions_org` (
588  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
589  `customer_id` int(11) unsigned DEFAULT NULL,
590  `subscription_id` int(11) unsigned DEFAULT NULL,
591  `start_date` datetime DEFAULT NULL,
592  `end_date` datetime DEFAULT NULL,
593  PRIMARY KEY (`id`),
594  KEY `subscription_id` (`subscription_id`),
595  KEY `customer_id` (`customer_id`,`subscription_id`),
596  KEY `customer_id_index` (`customer_id`)
597) ENGINE=InnoDB DEFAULT CHARSET=latin1;
598
599
600DROP TABLE IF EXISTS `custom_images`;
601CREATE TABLE `custom_images` (
602  `id` int(11) NOT NULL AUTO_INCREMENT,
603  `session_id` varchar(50) CHARACTER SET utf8 NOT NULL,
604  `filename` varchar(100) CHARACTER SET utf8 NOT NULL,
605  `src` varchar(100) CHARACTER SET utf8 NOT NULL,
606  `title` varchar(20) CHARACTER SET utf8 NOT NULL,
607  `width` int(4) NOT NULL,
608  `height` int(4) NOT NULL,
609  `mimetype` varchar(50) CHARACTER SET utf8 NOT NULL,
610  `created` datetime NOT NULL,
611  PRIMARY KEY (`id`)
612) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='user uploaded photos';
613
614
615DROP TABLE IF EXISTS `del_children_list`;
616CREATE TABLE `del_children_list` (
617  `id` int(10) NOT NULL AUTO_INCREMENT,
618  `customer_id` int(10) NOT NULL,
619  `firstname` varchar(255) NOT NULL,
620  PRIMARY KEY (`id`)
621) ENGINE=InnoDB DEFAULT CHARSET=latin1;
622
623
624DROP TABLE IF EXISTS `discount_sites`;
625CREATE TABLE `discount_sites` (
626  `id` int(11) NOT NULL AUTO_INCREMENT,
627  `system_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
628  `type_id` int(11) NOT NULL,
629  `unique_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
630  `unique_code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
631  `shipping_automail` tinyint(1) NOT NULL DEFAULT '0',
632  `payment_automail` tinyint(1) NOT NULL DEFAULT '0',
633  `confirmation_automail` tinyint(1) NOT NULL DEFAULT '0',
634  `image` tinyint(1) DEFAULT '0',
635  `image_id` int(11) NOT NULL DEFAULT '0',
636  `leadsource_id` int(11) DEFAULT NULL,
637  `end_date` datetime DEFAULT NULL,
638  `code_recycle` tinyint(1) NOT NULL DEFAULT '0',
639  `value` float NOT NULL DEFAULT '0',
640  `display_all` tinyint(1) NOT NULL DEFAULT '0',
641  `discount_address_label` tinyint(1) NOT NULL DEFAULT '0',
642  `active` tinyint(1) NOT NULL DEFAULT '1',
643  `free_shipping` tinyint(1) NOT NULL DEFAULT '0',
644  `xy_product_type_id` int(11) DEFAULT '0',
645  `x_amount` int(4) NOT NULL DEFAULT '0',
646  `y_amount` int(4) NOT NULL DEFAULT '0',
647  `landing_page_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
648  `show_product_discount` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'show discount on product page',
649  `max_product_amount` int(4) DEFAULT '0',
650  `show_custom_thankyou` tinyint(1) NOT NULL DEFAULT '0',
651  `old_id` int(11) DEFAULT NULL,
652  `old_leadsource_id` int(11) DEFAULT NULL,
653  `old_type_id` int(11) DEFAULT NULL,
654  `print_type_tabs_token` tinyint(1) NOT NULL DEFAULT '15' COMMENT '1 = text, 2 = illustration/photo 4 = illustration/text. zelfde algoritm als chmod. 8 = photo_text',
655  `amount_discount_set` int(10) unsigned NOT NULL,
656  `free_kraampakket` int(1) NOT NULL,
657  `prijs_vanaf` int(10) NOT NULL DEFAULT '0',
658  `logo_source` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
659  `logo_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
660  `hides_navigation` tinyint(4) NOT NULL DEFAULT '0',
661  `hides_site_search` tinyint(4) NOT NULL DEFAULT '0',
662  `show_captcha` tinyint(1) DEFAULT '0',
663  `multiple_codes` tinyint(1) DEFAULT '0',
664  PRIMARY KEY (`id`),
665  KEY `leadsource_id` (`leadsource_id`)
666) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
667
668
669DROP TABLE IF EXISTS `discount_site_codes`;
670CREATE TABLE `discount_site_codes` (
671  `id` int(11) NOT NULL AUTO_INCREMENT,
672  `discount_site_id` int(11) NOT NULL,
673  `code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
674  `created` datetime NOT NULL,
675  `used` datetime DEFAULT NULL,
676  `old_id` int(11) DEFAULT NULL,
677  `old_discount_site_id` int(11) DEFAULT NULL,
678  PRIMARY KEY (`id`),
679  UNIQUE KEY `uc` (`code`,`discount_site_id`),
680  KEY `discount_site_id` (`discount_site_id`)
681) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
682
683
684DROP TABLE IF EXISTS `discount_site_combination_conditions`;
685CREATE TABLE `discount_site_combination_conditions` (
686  `id` int(11) NOT NULL AUTO_INCREMENT,
687  `system_name` varchar(100) NOT NULL,
688  `active` tinyint(1) NOT NULL DEFAULT '1',
689  PRIMARY KEY (`id`)
690) ENGINE=InnoDB DEFAULT CHARSET=utf8;
691
692
693DROP TABLE IF EXISTS `discount_site_combination_results`;
694CREATE TABLE `discount_site_combination_results` (
695  `id` int(11) NOT NULL AUTO_INCREMENT,
696  `system_name` varchar(100) NOT NULL,
697  `active` tinyint(1) NOT NULL DEFAULT '1',
698  PRIMARY KEY (`id`)
699) ENGINE=InnoDB DEFAULT CHARSET=utf8;
700
701
702DROP TABLE IF EXISTS `discount_site_combination_rules`;
703CREATE TABLE `discount_site_combination_rules` (
704  `id` int(11) NOT NULL AUTO_INCREMENT,
705  `first_type_id` int(11) NOT NULL,
706  `second_type_id` int(11) NOT NULL,
707  `active` tinyint(1) NOT NULL DEFAULT '1',
708  `condition_id` int(11) NOT NULL,
709  `result_id` int(11) NOT NULL,
710  PRIMARY KEY (`id`)
711) ENGINE=InnoDB DEFAULT CHARSET=utf8;
712
713
714DROP TABLE IF EXISTS `discount_site_options`;
715CREATE TABLE `discount_site_options` (
716  `id` int(11) NOT NULL AUTO_INCREMENT,
717  `discount_site_id` int(11) NOT NULL,
718  `class_name` enum('print_color','font','illustration','print_side','product_color','product_type','free_shipping_country','print_type_tabs','print_side_options') COLLATE utf8_unicode_ci NOT NULL,
719  `class_id` int(11) NOT NULL,
720  PRIMARY KEY (`id`),
721  UNIQUE KEY `class_name` (`class_name`,`class_id`,`discount_site_id`),
722  KEY `discount_site_id` (`discount_site_id`,`class_name`)
723) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
724
725
726DROP TABLE IF EXISTS `domains`;
727CREATE TABLE `domains` (
728  `id` int(20) NOT NULL AUTO_INCREMENT,
729  `url` varchar(255) NOT NULL,
730  `active` tinyint(1) NOT NULL,
731  `outlet` int(20) NOT NULL,
732  PRIMARY KEY (`id`),
733  KEY `outlet` (`outlet`)
734) ENGINE=InnoDB DEFAULT CHARSET=latin1;
735
736
737DROP TABLE IF EXISTS `examples`;
738CREATE TABLE `examples` (
739  `id` int(11) NOT NULL AUTO_INCREMENT,
740  `active` tinyint(4) NOT NULL DEFAULT '0',
741  `view_order` smallint(6) NOT NULL DEFAULT '-1',
742  `system_name` varchar(250) NOT NULL,
743  PRIMARY KEY (`id`),
744  UNIQUE KEY `name_UNIQUE` (`system_name`)
745) ENGINE=InnoDB DEFAULT CHARSET=latin1;
746
747
748DROP TABLE IF EXISTS `examples_multilingual_info`;
749CREATE TABLE `examples_multilingual_info` (
750  `id` int(11) NOT NULL AUTO_INCREMENT,
751  `example_id` int(11) NOT NULL,
752  `language_id` int(11) NOT NULL,
753  `image_path` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
754  `link` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
755  `alt_text` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
756  PRIMARY KEY (`id`),
757  UNIQUE KEY `unique_ex_lang` (`language_id`,`example_id`)
758) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
759
760
761DROP TABLE IF EXISTS `examples_per_category`;
762CREATE TABLE `examples_per_category` (
763  `example_id` int(11) NOT NULL,
764  `category_id` int(11) NOT NULL,
765  PRIMARY KEY (`example_id`,`category_id`)
766) ENGINE=InnoDB DEFAULT CHARSET=latin1;
767
768
769DROP TABLE IF EXISTS `example_categories`;
770CREATE TABLE `example_categories` (
771  `id` int(11) NOT NULL AUTO_INCREMENT,
772  `active` tinyint(4) NOT NULL DEFAULT '0',
773  `view_order` smallint(6) NOT NULL,
774  `system_name` varchar(250) NOT NULL,
775  PRIMARY KEY (`id`)
776) ENGINE=InnoDB DEFAULT CHARSET=latin1;
777
778
779DROP TABLE IF EXISTS `example_category_images`;
780CREATE TABLE `example_category_images` (
781  `id` int(11) NOT NULL AUTO_INCREMENT,
782  `example_category_id` int(11) DEFAULT NULL,
783  `language_id` int(11) DEFAULT NULL,
784  `path` varchar(250) DEFAULT NULL,
785  PRIMARY KEY (`id`),
786  UNIQUE KEY `unique` (`example_category_id`,`language_id`) USING BTREE
787) ENGINE=InnoDB DEFAULT CHARSET=latin1;
788
789
790DROP TABLE IF EXISTS `external_address_providers`;
791CREATE TABLE `external_address_providers` (
792  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
793  `external_address_provider_id` int(10) unsigned NOT NULL,
794  PRIMARY KEY (`id`)
795) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
796
797
798DROP TABLE IF EXISTS `external_mail_templates`;
799CREATE TABLE `external_mail_templates` (
800  `id` int(10) NOT NULL AUTO_INCREMENT,
801  `system_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
802  `html_template` text COLLATE utf8_unicode_ci NOT NULL,
803  PRIMARY KEY (`id`),
804  UNIQUE KEY `system_name` (`system_name`)
805) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
806
807
808DROP TABLE IF EXISTS `fairs`;
809CREATE TABLE `fairs` (
810  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
811  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
812  `json` text COLLATE utf8_unicode_ci,
813  `status` int(1) DEFAULT '0',
814  PRIMARY KEY (`id`)
815) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
816
817
818DROP TABLE IF EXISTS `feedback`;
819CREATE TABLE `feedback` (
820  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
821  `date` int(10) unsigned NOT NULL,
822  `name` varchar(255) NOT NULL,
823  `email_address` varchar(255) NOT NULL,
824  `user_agent` varchar(255) NOT NULL,
825  `user_agent_orig` varchar(255) NOT NULL,
826  PRIMARY KEY (`id`)
827) ENGINE=InnoDB DEFAULT CHARSET=latin1;
828
829
830DROP TABLE IF EXISTS `feedback_lines`;
831CREATE TABLE `feedback_lines` (
832  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
833  `feedback_id` int(10) unsigned NOT NULL,
834  `type` varchar(255) NOT NULL,
835  `line` text NOT NULL,
836  PRIMARY KEY (`id`)
837) ENGINE=InnoDB DEFAULT CHARSET=latin1;
838
839
840DROP TABLE IF EXISTS `fonts`;
841CREATE TABLE `fonts` (
842  `id` int(11) NOT NULL AUTO_INCREMENT,
843  `cid` int(11) NOT NULL,
844  `active` tinyint(1) unsigned NOT NULL DEFAULT '0',
845  `order_id` int(11) DEFAULT NULL,
846  PRIMARY KEY (`id`),
847  UNIQUE KEY `cid` (`cid`)
848) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
849
850
851DROP TABLE IF EXISTS `gift_boxes`;
852CREATE TABLE `gift_boxes` (
853  `id` int(11) NOT NULL AUTO_INCREMENT,
854  `product_type_id` int(11) NOT NULL,
855  `redirect_id` int(11) DEFAULT NULL,
856  `system_name` varchar(45) CHARACTER SET latin1 NOT NULL,
857  `price` float DEFAULT NULL,
858  `image_path` varchar(150) CHARACTER SET latin1 DEFAULT NULL,
859  `default_illustration_id` int(11) DEFAULT NULL,
860  `default_print_color_id` int(11) DEFAULT NULL,
861  `default_font_id` int(11) DEFAULT NULL,
862  `view_order` smallint(6) DEFAULT NULL,
863  `active` tinyint(4) DEFAULT NULL,
864  `is_standard` tinyint(4) DEFAULT NULL,
865  PRIMARY KEY (`id`)
866) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
867
868
869DROP TABLE IF EXISTS `gift_boxes_excluded_products`;
870CREATE TABLE `gift_boxes_excluded_products` (
871  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
872  `gift_box_id` int(11) NOT NULL,
873  `product_type_id` int(11) NOT NULL,
874  PRIMARY KEY (`id`),
875  KEY `gift_box_id` (`gift_box_id`)
876) ENGINE=InnoDB DEFAULT CHARSET=utf8;
877
878
879DROP TABLE IF EXISTS `gift_box_multilingual_info`;
880CREATE TABLE `gift_box_multilingual_info` (
881  `id` int(11) NOT NULL AUTO_INCREMENT,
882  `language_id` int(11) NOT NULL,
883  `gift_box_id` int(11) NOT NULL,
884  `name` varchar(50) DEFAULT NULL,
885  PRIMARY KEY (`id`),
886  KEY `foreign_keys_indx` (`language_id`,`gift_box_id`)
887) ENGINE=InnoDB DEFAULT CHARSET=latin1;
888
889
890DROP TABLE IF EXISTS `gift_coupons`;
891CREATE TABLE `gift_coupons` (
892  `id` int(11) NOT NULL AUTO_INCREMENT,
893  `gift_coupon_batch_id` int(11) NOT NULL,
894  `order_id` int(11) NOT NULL,
895  `order_date` datetime NOT NULL,
896  `used_order_id` int(11) DEFAULT NULL,
897  `used_order_date` datetime DEFAULT NULL,
898  `code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
899  `value` float NOT NULL,
900  `expiration_date` datetime NOT NULL,
901  `remove_date` datetime NOT NULL,
902  `free` tinyint(1) NOT NULL DEFAULT '0',
903  `old_id` int(11) DEFAULT NULL,
904  `old_gift_coupon_batch_id` int(11) DEFAULT NULL,
905  `old_order_id` int(11) DEFAULT NULL,
906  `old_used_order_id` int(11) DEFAULT NULL,
907  PRIMARY KEY (`id`),
908  UNIQUE KEY `code` (`code`,`order_id`),
909  KEY `batch_id` (`gift_coupon_batch_id`,`order_id`,`used_order_id`),
910  KEY `order_id` (`order_id`)
911) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
912
913
914DROP TABLE IF EXISTS `gift_coupon_batches`;
915CREATE TABLE `gift_coupon_batches` (
916  `id` int(11) NOT NULL AUTO_INCREMENT,
917  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
918  `description` text COLLATE utf8_unicode_ci NOT NULL,
919  `date` datetime NOT NULL,
920  `amount` int(11) NOT NULL DEFAULT '0',
921  `value` float NOT NULL DEFAULT '0',
922  `old_id` int(11) DEFAULT NULL,
923  `user` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
924  PRIMARY KEY (`id`)
925) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
926
927
928DROP TABLE IF EXISTS `gift_services`;
929CREATE TABLE `gift_services` (
930  `id` int(11) NOT NULL AUTO_INCREMENT,
931  `order_id` int(11) NOT NULL,
932  `message_1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
933  `message_2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
934  `message_3` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
935  `message_4` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
936  `message_5` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
937  `price` float NOT NULL DEFAULT '0',
938  PRIMARY KEY (`id`),
939  KEY `order_id` (`order_id`)
940) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
941
942
943DROP TABLE IF EXISTS `guestbooks`;
944CREATE TABLE `guestbooks` (
945  `id` int(11) NOT NULL AUTO_INCREMENT,
946  `guestbook_token_id` int(11) NOT NULL,
947  `guestbook_image_id` int(11) NOT NULL,
948  `reply_date` int(10) unsigned NOT NULL DEFAULT '0',
949  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
950  `city` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
951  `country_id` int(11) DEFAULT NULL,
952  `country` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
953  `message` text COLLATE utf8_unicode_ci NOT NULL,
954  `active` tinyint(1) NOT NULL DEFAULT '1',
955  `old_id` int(11) DEFAULT NULL,
956  `dev` int(11) NOT NULL DEFAULT '0',
957  PRIMARY KEY (`id`),
958  KEY `guestbook_image_id` (`guestbook_image_id`)
959) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
960
961
962DROP TABLE IF EXISTS `guestbook_images`;
963CREATE TABLE `guestbook_images` (
964  `id` int(11) NOT NULL AUTO_INCREMENT,
965  `file` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
966  `changed` int(10) unsigned NOT NULL DEFAULT '0',
967  PRIMARY KEY (`id`)
968) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
969
970
971DROP TABLE IF EXISTS `guestbook_tokens`;
972CREATE TABLE `guestbook_tokens` (
973  `id` int(11) NOT NULL AUTO_INCREMENT,
974  `order_id` int(11) NOT NULL,
975  `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
976  `active` tinyint(1) NOT NULL DEFAULT '1',
977  `old_order_id` int(11) DEFAULT NULL,
978  PRIMARY KEY (`id`),
979  KEY `order_id` (`order_id`)
980) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
981
982
983DROP TABLE IF EXISTS `home_items`;
984CREATE TABLE `home_items` (
985  `id` int(11) NOT NULL AUTO_INCREMENT,
986  `image_id` tinyint(1) unsigned NOT NULL DEFAULT '1',
987  PRIMARY KEY (`id`),
988  UNIQUE KEY `img_id` (`image_id`)
989) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
990
991
992DROP TABLE IF EXISTS `images`;
993CREATE TABLE `images` (
994  `id` int(11) NOT NULL AUTO_INCREMENT,
995  `system_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
996  `active` tinyint(1) unsigned NOT NULL DEFAULT '0',
997  PRIMARY KEY (`id`),
998  UNIQUE KEY `sn` (`system_name`)
999) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1000
1001
1002DROP TABLE IF EXISTS `inactive_working_days`;
1003CREATE TABLE `inactive_working_days` (
1004  `id` int(11) NOT NULL AUTO_INCREMENT,
1005  `event_date` datetime NOT NULL,
1006  PRIMARY KEY (`id`),
1007  UNIQUE KEY `event_date_UNIQUE` (`event_date`)
1008) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1009
1010
1011DROP TABLE IF EXISTS `incentives`;
1012CREATE TABLE `incentives` (
1013  `id` int(11) NOT NULL AUTO_INCREMENT,
1014  `system_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1015  `product_type_id` int(11) NOT NULL,
1016  `amount` float NOT NULL DEFAULT '0',
1017  `active` tinyint(1) NOT NULL DEFAULT '1',
1018  `purchase_costs` float NOT NULL DEFAULT '0',
1019  `stock` int(10) unsigned NOT NULL DEFAULT '0',
1020  `sold` int(11) NOT NULL DEFAULT '0',
1021  `rejected` int(11) NOT NULL DEFAULT '0',
1022  `reserved` int(11) NOT NULL DEFAULT '0',
1023  `type` enum('items','product_total') COLLATE utf8_unicode_ci NOT NULL,
1024  PRIMARY KEY (`id`),
1025  KEY `product_type_id` (`product_type_id`)
1026) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1027
1028
1029DROP TABLE IF EXISTS `kiosks`;
1030CREATE TABLE `kiosks` (
1031  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1032  `cibl` bigint(10) NOT NULL,
1033  `leadsource_id` int(11) NOT NULL,
1034  `partner_id` int(11) NOT NULL,
1035  `system_name` varchar(255) NOT NULL,
1036  `hardware` varchar(255) NOT NULL,
1037  `description` varchar(255) NOT NULL,
1038  `ping_of_life` datetime DEFAULT NULL,
1039  `kiosk_alert_active` int(1) NOT NULL DEFAULT '0',
1040  `kiosk_alert_addresses` varchar(255) NOT NULL,
1041  `kiosk_alert_mail_send` int(11) NOT NULL DEFAULT '0',
1042  `sound_file` varchar(45) DEFAULT NULL,
1043  `ignore_print_price` int(11) NOT NULL DEFAULT '0',
1044  PRIMARY KEY (`id`)
1045) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1046
1047
1048DROP TABLE IF EXISTS `kiosks_afleveradressen`;
1049CREATE TABLE `kiosks_afleveradressen` (
1050  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
1051  `naam` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1052  `extra_info` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1053  `straat` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1054  `huisnummer` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
1055  `huisnummer_toevoeging` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
1056  `postcode` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
1057  `plaats` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1058  `land` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1059  `partner_id` int(11) NOT NULL,
1060  PRIMARY KEY (`id`)
1061) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1062
1063
1064DROP TABLE IF EXISTS `kiosks_afleveradres_per_kiosk`;
1065CREATE TABLE `kiosks_afleveradres_per_kiosk` (
1066  `id` int(11) NOT NULL AUTO_INCREMENT,
1067  `kiosk_id` int(11) NOT NULL,
1068  `afleveradres_id` int(11) NOT NULL,
1069  PRIMARY KEY (`id`)
1070) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1071
1072
1073DROP TABLE IF EXISTS `kiosks_fonts`;
1074CREATE TABLE `kiosks_fonts` (
1075  `id` int(11) NOT NULL AUTO_INCREMENT,
1076  `kiosk_id` int(11) NOT NULL,
1077  `font_id` int(11) NOT NULL,
1078  PRIMARY KEY (`id`)
1079) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1080
1081
1082DROP TABLE IF EXISTS `kiosks_illustrations`;
1083CREATE TABLE `kiosks_illustrations` (
1084  `id` int(11) NOT NULL AUTO_INCREMENT,
1085  `kiosk_id` int(11) NOT NULL,
1086  `illustration_id` int(11) NOT NULL,
1087  PRIMARY KEY (`id`)
1088) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1089
1090
1091DROP TABLE IF EXISTS `kiosks_illustrations_categories`;
1092CREATE TABLE `kiosks_illustrations_categories` (
1093  `id` int(11) NOT NULL AUTO_INCREMENT,
1094  `kiosk_id` int(11) NOT NULL,
1095  `illustration_category_id` int(11) NOT NULL,
1096  PRIMARY KEY (`id`)
1097) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1098
1099
1100DROP TABLE IF EXISTS `kiosks_kiosk_content`;
1101CREATE TABLE `kiosks_kiosk_content` (
1102  `id` int(11) NOT NULL AUTO_INCREMENT,
1103  `html` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1104  `kiosk_id` int(11) DEFAULT NULL,
1105  PRIMARY KEY (`id`)
1106) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1107
1108
1109DROP TABLE IF EXISTS `kiosks_kiosk_content_images`;
1110CREATE TABLE `kiosks_kiosk_content_images` (
1111  `id` int(11) NOT NULL AUTO_INCREMENT,
1112  `location` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1113  `kiosk_id` int(11) NOT NULL,
1114  PRIMARY KEY (`id`)
1115) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1116
1117
1118DROP TABLE IF EXISTS `kiosks_partners`;
1119CREATE TABLE `kiosks_partners` (
1120  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1121  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
1122  `password` varchar(255) NOT NULL,
1123  PRIMARY KEY (`id`)
1124) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1125
1126
1127DROP TABLE IF EXISTS `kiosks_partners_fonts`;
1128CREATE TABLE `kiosks_partners_fonts` (
1129  `id` int(11) NOT NULL AUTO_INCREMENT,
1130  `partner_id` int(11) NOT NULL,
1131  `font_id` int(11) NOT NULL,
1132  PRIMARY KEY (`id`)
1133) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1134
1135
1136DROP TABLE IF EXISTS `kiosks_partners_illustrations`;
1137CREATE TABLE `kiosks_partners_illustrations` (
1138  `id` int(11) NOT NULL AUTO_INCREMENT,
1139  `partner_id` int(11) NOT NULL,
1140  `illustration_id` int(11) NOT NULL,
1141  PRIMARY KEY (`id`)
1142) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1143
1144
1145DROP TABLE IF EXISTS `kiosks_partners_illustrations_categories`;
1146CREATE TABLE `kiosks_partners_illustrations_categories` (
1147  `id` int(11) NOT NULL AUTO_INCREMENT,
1148  `partner_id` int(11) NOT NULL,
1149  `illustration_category_id` int(11) NOT NULL,
1150  PRIMARY KEY (`id`)
1151) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1152
1153
1154DROP TABLE IF EXISTS `kiosks_partners_languages`;
1155CREATE TABLE `kiosks_partners_languages` (
1156  `id` int(11) NOT NULL AUTO_INCREMENT,
1157  `kiosk_partner_id` int(11) NOT NULL,
1158  `language_id` int(11) NOT NULL,
1159  PRIMARY KEY (`id`)
1160) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1161
1162
1163DROP TABLE IF EXISTS `kiosks_partners_print_colors`;
1164CREATE TABLE `kiosks_partners_print_colors` (
1165  `id` int(11) NOT NULL AUTO_INCREMENT,
1166  `partner_id` int(11) NOT NULL,
1167  `print_color_id` int(11) NOT NULL,
1168  PRIMARY KEY (`id`)
1169) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1170
1171
1172DROP TABLE IF EXISTS `kiosks_partners_products`;
1173CREATE TABLE `kiosks_partners_products` (
1174  `id` int(11) NOT NULL AUTO_INCREMENT,
1175  `partner_id` int(11) NOT NULL,
1176  `product_type_id` int(11) NOT NULL,
1177  `product_color_id` int(11) NOT NULL,
1178  `product_size_id` int(11) NOT NULL,
1179  `price` float NOT NULL DEFAULT '0',
1180  PRIMARY KEY (`id`)
1181) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1182
1183
1184DROP TABLE IF EXISTS `kiosks_partners_product_colors`;
1185CREATE TABLE `kiosks_partners_product_colors` (
1186  `id` int(11) NOT NULL AUTO_INCREMENT,
1187  `partner_id` int(11) NOT NULL,
1188  `product_color_id` int(11) NOT NULL,
1189  PRIMARY KEY (`id`)
1190) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1191
1192
1193DROP TABLE IF EXISTS `kiosks_partners_product_types`;
1194CREATE TABLE `kiosks_partners_product_types` (
1195  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1196  `partner_id` int(11) NOT NULL,
1197  `product_type_id` int(11) NOT NULL,
1198  `sequence` int(11) NOT NULL DEFAULT '0',
1199  `jump_id` int(11) NOT NULL,
1200  `front_text` int(11) NOT NULL DEFAULT '0',
1201  `front_illustration_text` int(11) NOT NULL DEFAULT '0',
1202  `front_illustration` int(11) NOT NULL DEFAULT '0',
1203  `back_text` int(11) NOT NULL DEFAULT '0',
1204  `back_illustration_text` int(11) NOT NULL DEFAULT '0',
1205  `back_illustration` int(11) NOT NULL DEFAULT '0',
1206  PRIMARY KEY (`id`),
1207  KEY `kiosk_id` (`partner_id`)
1208) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1209
1210
1211DROP TABLE IF EXISTS `kiosks_partner_content`;
1212CREATE TABLE `kiosks_partner_content` (
1213  `id` int(11) NOT NULL AUTO_INCREMENT,
1214  `html` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1215  `partner_id` int(11) DEFAULT NULL,
1216  PRIMARY KEY (`id`)
1217) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1218
1219
1220DROP TABLE IF EXISTS `kiosks_partner_content_images`;
1221CREATE TABLE `kiosks_partner_content_images` (
1222  `id` int(11) NOT NULL AUTO_INCREMENT,
1223  `location` varchar(255) NOT NULL,
1224  `partner_id` int(11) NOT NULL,
1225  PRIMARY KEY (`id`)
1226) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1227
1228
1229DROP TABLE IF EXISTS `kiosks_print_colors`;
1230CREATE TABLE `kiosks_print_colors` (
1231  `id` int(11) NOT NULL AUTO_INCREMENT,
1232  `kiosk_id` int(11) NOT NULL,
1233  `print_color_id` int(11) NOT NULL,
1234  PRIMARY KEY (`id`)
1235) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1236
1237
1238DROP TABLE IF EXISTS `kiosks_products`;
1239CREATE TABLE `kiosks_products` (
1240  `id` int(11) NOT NULL AUTO_INCREMENT,
1241  `kiosk_id` int(11) NOT NULL,
1242  `product_type_id` int(11) NOT NULL,
1243  `product_color_id` int(11) NOT NULL,
1244  `product_size_id` int(11) NOT NULL,
1245  `price` float NOT NULL DEFAULT '0',
1246  PRIMARY KEY (`id`)
1247) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1248
1249
1250DROP TABLE IF EXISTS `kiosks_product_colors`;
1251CREATE TABLE `kiosks_product_colors` (
1252  `id` int(11) NOT NULL AUTO_INCREMENT,
1253  `kiosk_id` int(11) NOT NULL,
1254  `product_color_id` int(11) NOT NULL,
1255  PRIMARY KEY (`id`)
1256) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1257
1258
1259DROP TABLE IF EXISTS `kiosks_product_types`;
1260CREATE TABLE `kiosks_product_types` (
1261  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1262  `kiosk_id` int(11) NOT NULL,
1263  `jump_id` int(11) NOT NULL,
1264  `product_type_id` int(11) NOT NULL,
1265  `front_text` int(11) NOT NULL DEFAULT '0',
1266  `front_illustration_text` int(11) NOT NULL DEFAULT '0',
1267  `front_illustration` int(11) NOT NULL DEFAULT '0',
1268  `back_text` int(11) NOT NULL DEFAULT '0',
1269  `back_illustration_text` int(11) NOT NULL DEFAULT '0',
1270  `back_illustration` int(11) NOT NULL DEFAULT '0',
1271  `custom` int(11) NOT NULL DEFAULT '0',
1272  `sequence` int(11) NOT NULL DEFAULT '0',
1273  PRIMARY KEY (`id`),
1274  KEY `kiosk_id` (`kiosk_id`)
1275) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1276
1277
1278DROP TABLE IF EXISTS `kiosks_product_types_hidden`;
1279CREATE TABLE `kiosks_product_types_hidden` (
1280  `id` int(11) NOT NULL AUTO_INCREMENT,
1281  `kiosk_id` int(11) NOT NULL,
1282  `product_type_id` int(11) NOT NULL,
1283  PRIMARY KEY (`id`)
1284) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1285
1286
1287DROP TABLE IF EXISTS `kiosks_product_type_sequence`;
1288CREATE TABLE `kiosks_product_type_sequence` (
1289  `id` int(11) NOT NULL AUTO_INCREMENT,
1290  `sequence` int(11) NOT NULL,
1291  `product_type_id` int(11) NOT NULL,
1292  `kiosk_id` int(11) NOT NULL,
1293  PRIMARY KEY (`id`),
1294  UNIQUE KEY `kiosk_productype` (`product_type_id`,`kiosk_id`)
1295) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1296
1297
1298DROP TABLE IF EXISTS `kraampakketten`;
1299CREATE TABLE `kraampakketten` (
1300  `id` int(10) NOT NULL AUTO_INCREMENT,
1301  `system_name` varchar(255) NOT NULL,
1302  `price` float NOT NULL,
1303  `photo` varchar(255) NOT NULL,
1304  `default_sexe` int(1) NOT NULL,
1305  `print_var_name` varchar(255) NOT NULL,
1306  `active` int(10) NOT NULL DEFAULT '1',
1307  `order_id` int(10) NOT NULL,
1308  PRIMARY KEY (`id`)
1309) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1310
1311
1312DROP TABLE IF EXISTS `kraampakket_kleuren`;
1313CREATE TABLE `kraampakket_kleuren` (
1314  `id` int(10) NOT NULL AUTO_INCREMENT,
1315  `system_name` varchar(255) NOT NULL,
1316  `sexe` int(10) NOT NULL DEFAULT '1',
1317  `hex` varchar(7) NOT NULL DEFAULT '#FFFFFF',
1318  `active` int(10) NOT NULL DEFAULT '1',
1319  PRIMARY KEY (`id`)
1320) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1321
1322
1323DROP TABLE IF EXISTS `kraampakket_kleuren_link`;
1324CREATE TABLE `kraampakket_kleuren_link` (
1325  `id` int(10) NOT NULL AUTO_INCREMENT,
1326  `kleur_id` int(10) NOT NULL,
1327  `type_id` int(10) NOT NULL,
1328  `color_id` int(10) NOT NULL,
1329  PRIMARY KEY (`id`),
1330  UNIQUE KEY `kleur_id` (`kleur_id`,`type_id`,`color_id`)
1331) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1332
1333
1334DROP TABLE IF EXISTS `kraampakket_link`;
1335CREATE TABLE `kraampakket_link` (
1336  `id` int(10) NOT NULL AUTO_INCREMENT,
1337  `pakket_id` int(10) NOT NULL,
1338  `type` int(10) NOT NULL,
1339  `item_id` int(10) NOT NULL,
1340  PRIMARY KEY (`id`),
1341  UNIQUE KEY `pakket_id` (`pakket_id`,`type`,`item_id`)
1342) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1343
1344
1345DROP TABLE IF EXISTS `kraampakket_maten`;
1346CREATE TABLE `kraampakket_maten` (
1347  `id` int(10) NOT NULL AUTO_INCREMENT,
1348  `system_name` varchar(255) NOT NULL,
1349  `active` int(10) NOT NULL DEFAULT '1',
1350  PRIMARY KEY (`id`)
1351) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1352
1353
1354DROP TABLE IF EXISTS `kraampakket_maten_link`;
1355CREATE TABLE `kraampakket_maten_link` (
1356  `id` int(10) NOT NULL AUTO_INCREMENT,
1357  `maat_id` int(10) NOT NULL,
1358  `type_id` int(10) NOT NULL,
1359  `size_id` int(10) NOT NULL,
1360  PRIMARY KEY (`id`),
1361  UNIQUE KEY `maat_id` (`maat_id`,`type_id`,`size_id`)
1362) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1363
1364
1365DROP TABLE IF EXISTS `kraampakket_products`;
1366CREATE TABLE `kraampakket_products` (
1367  `id` int(10) NOT NULL AUTO_INCREMENT,
1368  `pakket_id` int(10) NOT NULL,
1369  `system_name` varchar(255) NOT NULL,
1370  `type_id` int(10) NOT NULL,
1371  `view_side` int(10) NOT NULL,
1372  `sexe` int(10) NOT NULL DEFAULT '1',
1373  `font_id` int(10) NOT NULL,
1374  `print_color_id` int(10) NOT NULL,
1375  `text1_1` varchar(255) NOT NULL,
1376  `text1_2` varchar(255) NOT NULL,
1377  `text1_3` varchar(255) NOT NULL,
1378  `text2_1` varchar(255) NOT NULL,
1379  `text2_2` varchar(255) NOT NULL,
1380  `text2_3` varchar(255) NOT NULL,
1381  `height1_1` int(10) NOT NULL DEFAULT '100',
1382  `height1_2` int(10) NOT NULL DEFAULT '100',
1383  `height1_3` int(10) NOT NULL DEFAULT '100',
1384  `height2_1` int(10) NOT NULL DEFAULT '100',
1385  `height2_2` int(10) NOT NULL DEFAULT '100',
1386  `height2_3` int(10) NOT NULL DEFAULT '100',
1387  `width1_1` int(10) NOT NULL DEFAULT '100',
1388  `width1_2` int(10) NOT NULL DEFAULT '100',
1389  `width1_3` int(10) NOT NULL DEFAULT '100',
1390  `width2_1` int(10) NOT NULL DEFAULT '100',
1391  `width2_2` int(10) NOT NULL DEFAULT '100',
1392  `width2_3` int(10) NOT NULL DEFAULT '100',
1393  `active` int(10) NOT NULL DEFAULT '1',
1394  `order_id` int(11) NOT NULL,
1395  PRIMARY KEY (`id`)
1396) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1397
1398
1399DROP TABLE IF EXISTS `landing_pages`;
1400CREATE TABLE `landing_pages` (
1401  `id` int(11) NOT NULL AUTO_INCREMENT,
1402  `name` varchar(100) NOT NULL,
1403  `description` varchar(250) DEFAULT NULL,
1404  PRIMARY KEY (`id`)
1405) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1406
1407
1408DROP TABLE IF EXISTS `landing_pages_multilang_info`;
1409CREATE TABLE `landing_pages_multilang_info` (
1410  `id` int(11) NOT NULL AUTO_INCREMENT,
1411  `landing_page_id` int(11) NOT NULL,
1412  `language_id` int(11) NOT NULL,
1413  `title` varchar(50) CHARACTER SET latin1 NOT NULL,
1414  `content` text CHARACTER SET latin1 NOT NULL,
1415  `image1` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
1416  `image2` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
1417  `image3` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
1418  `image4` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
1419  `link1` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
1420  `link2` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
1421  `link3` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
1422  `link4` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
1423  `alt1` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
1424  `alt2` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
1425  `alt3` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
1426  `alt4` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
1427  `meta_keywords` varchar(250) CHARACTER SET latin1 DEFAULT NULL,
1428  `meta_description` varchar(250) CHARACTER SET latin1 DEFAULT NULL,
1429  `button_text` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
1430  `title_tag` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
1431  PRIMARY KEY (`id`),
1432  KEY `indx_page_lang` (`landing_page_id`,`language_id`),
1433  KEY `indx_land` (`language_id`) USING BTREE
1434) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1435
1436
1437DROP TABLE IF EXISTS `leadsources`;
1438CREATE TABLE `leadsources` (
1439  `id` int(11) NOT NULL AUTO_INCREMENT,
1440  `parent_id` int(11) NOT NULL DEFAULT '0',
1441  `system_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1442  `password` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
1443  `order_id` int(11) DEFAULT NULL,
1444  `is_reseller` tinyint(1) NOT NULL DEFAULT '0',
1445  `active` tinyint(1) NOT NULL DEFAULT '1',
1446  `old_id` int(11) DEFAULT NULL,
1447  PRIMARY KEY (`id`),
1448  KEY `old_id` (`old_id`)
1449) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1450
1451
1452DROP TABLE IF EXISTS `leadsource_payment_methods`;
1453CREATE TABLE `leadsource_payment_methods` (
1454  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1455  `leadsource_id` int(10) unsigned NOT NULL,
1456  `payment_method_id` int(10) unsigned NOT NULL,
1457  `enabled` tinyint(1) unsigned NOT NULL,
1458  PRIMARY KEY (`id`)
1459) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1460
1461
1462DROP TABLE IF EXISTS `logs`;
1463CREATE TABLE `logs` (
1464  `id` int(11) NOT NULL AUTO_INCREMENT,
1465  `user_id` int(11) NOT NULL,
1466  `date` datetime NOT NULL,
1467  `ip_address` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1468  `request_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1469  `controller` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1470  `action` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1471  `get` text COLLATE utf8_unicode_ci NOT NULL,
1472  `post` text COLLATE utf8_unicode_ci NOT NULL,
1473  PRIMARY KEY (`id`),
1474  KEY `user_id` (`user_id`)
1475) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1476
1477
1478DROP TABLE IF EXISTS `mail_logs`;
1479CREATE TABLE `mail_logs` (
1480  `id` int(11) NOT NULL AUTO_INCREMENT,
1481  `to` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1482  `from` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1483  `subject` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1484  `body_text` text COLLATE utf8_unicode_ci,
1485  `body_html` text COLLATE utf8_unicode_ci,
1486  `date` datetime NOT NULL,
1487  PRIMARY KEY (`id`)
1488) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1489
1490
1491DROP TABLE IF EXISTS `marked_customers`;
1492CREATE TABLE `marked_customers` (
1493  `id` int(11) NOT NULL AUTO_INCREMENT,
1494  `customer_id` int(11) DEFAULT NULL,
1495  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1496  `comment` text COLLATE utf8_unicode_ci NOT NULL,
1497  `amount` float NOT NULL,
1498  `active` tinyint(1) NOT NULL DEFAULT '1',
1499  `old_id` int(11) DEFAULT NULL,
1500  PRIMARY KEY (`id`),
1501  UNIQUE KEY `email` (`email`)
1502) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1503
1504
1505DROP TABLE IF EXISTS `menu_items`;
1506CREATE TABLE `menu_items` (
1507  `id` int(11) NOT NULL AUTO_INCREMENT,
1508  `system_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1509  `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1510  `parent_id` int(11) NOT NULL,
1511  `order_id` int(11) unsigned DEFAULT '0',
1512  `outlet_id` int(11) NOT NULL,
1513  PRIMARY KEY (`id`),
1514  KEY `outlet_id` (`outlet_id`)
1515) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1516
1517
1518DROP TABLE IF EXISTS `menu_items_banners`;
1519CREATE TABLE `menu_items_banners` (
1520  `id` int(11) NOT NULL AUTO_INCREMENT,
1521  `menu_item_id` int(11) NOT NULL,
1522  `language_id` int(11) NOT NULL,
1523  `banner` text NOT NULL,
1524  PRIMARY KEY (`id`)
1525) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1526
1527
1528DROP TABLE IF EXISTS `menu_items_photo_locations`;
1529CREATE TABLE `menu_items_photo_locations` (
1530  `id` int(11) NOT NULL AUTO_INCREMENT,
1531  `menu_item_id` int(11) NOT NULL,
1532  `language_id` int(11) NOT NULL,
1533  `photo_location` text NOT NULL,
1534  PRIMARY KEY (`id`)
1535) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1536
1537
1538DROP TABLE IF EXISTS `newsletters`;
1539CREATE TABLE `newsletters` (
1540  `id` int(11) NOT NULL AUTO_INCREMENT,
1541  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1542  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1543  `date_start` datetime NOT NULL,
1544  `date_end` datetime DEFAULT NULL,
1545  `language_id` int(11) NOT NULL,
1546  `order_id` int(11) DEFAULT NULL,
1547  `active` tinyint(1) NOT NULL DEFAULT '1',
1548  `old_id` int(11) DEFAULT NULL,
1549  `old_order_id` int(11) DEFAULT NULL,
1550  `model_hash` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
1551  `copernica` int(1) NOT NULL,
1552  PRIMARY KEY (`id`),
1553  UNIQUE KEY `email` (`email`),
1554  KEY `order_id` (`order_id`),
1555  KEY `copernica` (`copernica`)
1556) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1557
1558
1559DROP TABLE IF EXISTS `offers`;
1560CREATE TABLE `offers` (
1561  `id` int(11) NOT NULL AUTO_INCREMENT,
1562  `language_id` int(11) NOT NULL,
1563  `img` varchar(255) NOT NULL,
1564  `text` varchar(255) NOT NULL,
1565  `url` varchar(255) NOT NULL,
1566  `button_text` varchar(255) NOT NULL,
1567  `new_window` int(11) NOT NULL DEFAULT '0',
1568  `sequence` int(2) NOT NULL,
1569  PRIMARY KEY (`id`)
1570) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1571
1572
1573DROP TABLE IF EXISTS `orders`;
1574CREATE TABLE `orders` (
1575  `id` int(11) NOT NULL AUTO_INCREMENT,
1576  `order_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1577  `order_status` int(10) unsigned NOT NULL DEFAULT '1',
1578  `order_date` datetime NOT NULL,
1579  `payment_date` datetime DEFAULT NULL,
1580  `session_last_seen_date` datetime DEFAULT NULL COMMENT 'The date / time the order in the session was last updated by the customer',
1581  `product_total` decimal(10,5) NOT NULL DEFAULT '0.00000',
1582  `shipping_costs` decimal(10,5) NOT NULL DEFAULT '0.00000',
1583  `express_costs` decimal(10,5) NOT NULL DEFAULT '0.00000',
1584  `payment_costs` decimal(10,5) NOT NULL DEFAULT '0.00000',
1585  `discount_costs` decimal(10,5) NOT NULL DEFAULT '0.00000',
1586  `giftservice_costs` decimal(10,5) NOT NULL DEFAULT '0.00000',
1587  `order_total` decimal(10,5) NOT NULL DEFAULT '0.00000',
1588  `facturation_date` datetime DEFAULT NULL,
1589  `facturation_number` int(10) NOT NULL,
1590  `no_shipping` tinyint(1) NOT NULL DEFAULT '0',
1591  `service_mail` tinyint(1) NOT NULL DEFAULT '0',
1592  `reminder_mail` tinyint(1) NOT NULL DEFAULT '0',
1593  `financial_address_id` int(11) NOT NULL,
1594  `delivery_address_id` int(11) NOT NULL,
1595  `ip_address` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1596  `leadsource_id` int(11) NOT NULL,
1597  `discount_site_id` int(11) NOT NULL,
1598  `payment_method_id` int(11) NOT NULL,
1599  `shipping_method_id` int(11) NOT NULL,
1600  `shipping_type_id` int(10) unsigned NOT NULL DEFAULT '0',
1601  `cancel_date` datetime DEFAULT NULL,
1602  `document_date` datetime DEFAULT NULL,
1603  `production_date` datetime DEFAULT NULL,
1604  `shipping_date` datetime DEFAULT NULL,
1605  `estimated_shipping_date` datetime DEFAULT NULL,
1606  `customer_id` int(10) NOT NULL,
1607  `customer_comment` text COLLATE utf8_unicode_ci,
1608  `customer_comment_handled` tinyint(1) NOT NULL DEFAULT '0',
1609  `service_comment` text COLLATE utf8_unicode_ci NOT NULL,
1610  `accepted` tinyint(1) NOT NULL DEFAULT '0',
1611  `newsletter` tinyint(1) NOT NULL DEFAULT '0',
1612  `vat_included` tinyint(1) NOT NULL DEFAULT '1',
1613  `vat_percentage` decimal(10,5) NOT NULL,
1614  `gift_coupon_id` int(11) NOT NULL,
1615  `coupon_package` int(10) unsigned NOT NULL DEFAULT '0',
1616  `express_shipping` tinyint(1) NOT NULL DEFAULT '0',
1617  `express_order` tinyint(1) unsigned NOT NULL DEFAULT '0',
1618  `old_id` int(11) DEFAULT NULL,
1619  `old_leadsource_id` int(11) DEFAULT NULL,
1620  `old_discount_site_id` int(11) DEFAULT NULL,
1621  `old_payment_method_id` int(11) DEFAULT NULL,
1622  `old_shipping_method_id` int(11) DEFAULT NULL,
1623  `old_gift_coupon_id` int(11) DEFAULT NULL,
1624  `tnt` int(10) NOT NULL,
1625  `copy_of_order_id` int(22) NOT NULL DEFAULT '0',
1626  `partner_id` int(10) NOT NULL,
1627  `model_change_date` datetime NOT NULL,
1628  `paymentHash` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1629  `user_agent` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1630  `reference_company` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
1631  `kiosk_event_code` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
1632  `kiosk_id` int(11) DEFAULT NULL,
1633  `is_new_customer` tinyint(1) NOT NULL DEFAULT '0',
1634  `product_review_inventation_link` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1635  `pickup` tinyint(2) DEFAULT '0',
1636  PRIMARY KEY (`id`),
1637  KEY `status` (`order_status`),
1638  KEY `order_number` (`order_number`),
1639  KEY `facturation_number` (`facturation_number`),
1640  KEY `order_date` (`order_date`),
1641  KEY `payment_date` (`payment_date`),
1642  KEY `customer_id` (`customer_id`),
1643  KEY `payment_method_id` (`payment_method_id`),
1644  KEY `copy_of_order` (`copy_of_order_id`),
1645  KEY `paymentHash` (`paymentHash`),
1646  KEY `is_new_customer` (`is_new_customer`),
1647  KEY `estimated_shipping_date_index` (`estimated_shipping_date`),
1648  KEY `shipping_date_index` (`shipping_date`)
1649) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1650
1651
1652DROP TABLE IF EXISTS `order_comments`;
1653CREATE TABLE `order_comments` (
1654  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1655  `order_id` int(10) unsigned NOT NULL,
1656  `user_id` int(10) unsigned NOT NULL,
1657  `comment_date` datetime NOT NULL,
1658  `comment` text NOT NULL,
1659  PRIMARY KEY (`id`),
1660  KEY `order_id` (`order_id`)
1661) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1662
1663
1664DROP TABLE IF EXISTS `order_discounts`;
1665CREATE TABLE `order_discounts` (
1666  `id` int(11) NOT NULL AUTO_INCREMENT,
1667  `order_id` int(11) NOT NULL,
1668  `type` enum('gift_coupon','discount_site','discount_abc') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'discount_site',
1669  `code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1670  `discount_id` int(11) NOT NULL,
1671  `price` float NOT NULL DEFAULT '0',
1672  PRIMARY KEY (`id`),
1673  KEY `order_id` (`order_id`,`discount_id`)
1674) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1675
1676
1677DROP TABLE IF EXISTS `order_incentives`;
1678CREATE TABLE `order_incentives` (
1679  `id` int(11) NOT NULL AUTO_INCREMENT,
1680  `incentive_id` int(11) NOT NULL,
1681  `order_id` int(11) NOT NULL,
1682  `price` float NOT NULL DEFAULT '0',
1683  PRIMARY KEY (`id`),
1684  KEY `incentive_id` (`incentive_id`),
1685  KEY `order_id` (`order_id`)
1686) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1687
1688
1689DROP TABLE IF EXISTS `order_rules`;
1690CREATE TABLE `order_rules` (
1691  `id` int(11) NOT NULL AUTO_INCREMENT,
1692  `order_id` int(11) NOT NULL,
1693  `amount` float NOT NULL DEFAULT '0',
1694  `price` float NOT NULL DEFAULT '0',
1695  `uuid` char(36) COLLATE utf8_unicode_ci DEFAULT NULL,
1696  `gift_coupon` tinyint(1) unsigned NOT NULL DEFAULT '0',
1697  `set_id` int(10) NOT NULL,
1698  `set_uuid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1699  `pakket_id` int(10) NOT NULL,
1700  `pakket_maat` int(10) NOT NULL,
1701  `pakket_kleur` int(10) NOT NULL,
1702  `pakket_sexe` int(10) NOT NULL,
1703  `abc_set_uuid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1704  `abc_group_id` int(10) NOT NULL,
1705  `groupId` int(12) DEFAULT NULL,
1706  `abcSetUuid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1707  `childname` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1708  `outlet_id` int(11) DEFAULT NULL,
1709  `domain_id` int(11) DEFAULT NULL,
1710  `birthyear` int(4) NOT NULL,
1711  `birthmonth` int(2) NOT NULL,
1712  `birthday` int(2) NOT NULL,
1713  `birthdate_unknown` int(1) NOT NULL,
1714  `jump_uuid` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
1715  PRIMARY KEY (`id`),
1716  KEY `order_id` (`order_id`)
1717) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1718
1719
1720DROP TABLE IF EXISTS `order_rule_products`;
1721CREATE TABLE `order_rule_products` (
1722  `id` int(11) NOT NULL AUTO_INCREMENT,
1723  `order_rule_id` int(11) NOT NULL,
1724  `product_id` int(10) unsigned NOT NULL,
1725  `price` float NOT NULL DEFAULT '0',
1726  `product_color_id` int(11) NOT NULL,
1727  `product_size_id` int(11) NOT NULL,
1728  `product_type_id` int(11) NOT NULL,
1729  `promotion_product_type_id` int(10) unsigned NOT NULL,
1730  `uuid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1731  `complaints_id` int(11) NOT NULL,
1732  PRIMARY KEY (`id`),
1733  KEY `order_rule_id` (`order_rule_id`),
1734  KEY `product_id` (`product_id`),
1735  KEY `product_type_id` (`product_type_id`,`product_size_id`,`product_color_id`)
1736) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1737
1738
1739DROP TABLE IF EXISTS `order_rule_products_stock`;
1740CREATE TABLE `order_rule_products_stock` (
1741  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1742  `order_rule_product_id` int(10) unsigned NOT NULL,
1743  `warehouse_id` int(10) unsigned NOT NULL,
1744  `amount` smallint(4) NOT NULL DEFAULT '0',
1745  PRIMARY KEY (`id`),
1746  KEY `order_rule_product_id` (`order_rule_product_id`)
1747) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1748
1749
1750DROP TABLE IF EXISTS `order_rule_product_prints`;
1751CREATE TABLE `order_rule_product_prints` (
1752  `id` int(11) NOT NULL AUTO_INCREMENT,
1753  `order_rule_product_id` int(11) NOT NULL,
1754  `side_id` int(11) NOT NULL,
1755  `type` enum('text','illustration_text','illustration') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'text',
1756  `print_color_id` int(11) NOT NULL,
1757  `text_1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1758  `text_2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1759  `text_3` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1760  `text_4` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1761  `width_1` float NOT NULL DEFAULT '0',
1762  `width_2` float NOT NULL DEFAULT '0',
1763  `width_3` float NOT NULL DEFAULT '0',
1764  `width_4` float NOT NULL DEFAULT '0',
1765  `size_1` float NOT NULL DEFAULT '0',
1766  `size_2` float NOT NULL DEFAULT '0',
1767  `size_3` float NOT NULL DEFAULT '0',
1768  `font_id` int(11) DEFAULT NULL,
1769  `print_id` int(11) DEFAULT NULL,
1770  `print_size` int(11) DEFAULT NULL,
1771  `price` float NOT NULL DEFAULT '0',
1772  `custom_image_id` int(10) NOT NULL,
1773  `cutout_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1774  `image` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1775  `print_color_text1` int(10) NOT NULL DEFAULT '0',
1776  `print_color_text2` int(10) NOT NULL DEFAULT '0',
1777  `print_color_text3` int(10) NOT NULL DEFAULT '0',
1778  `font_text1` int(10) NOT NULL DEFAULT '0',
1779  `font_text2` int(10) NOT NULL DEFAULT '0',
1780  `font_text3` int(10) NOT NULL DEFAULT '0',
1781  `pattern_color_id` int(10) NOT NULL DEFAULT '0',
1782  `svg` longtext COLLATE utf8_unicode_ci NOT NULL,
1783  `pattern_width` float NOT NULL DEFAULT '0',
1784  PRIMARY KEY (`id`),
1785  KEY `order_rule_product_id` (`order_rule_product_id`,`side_id`,`print_color_id`,`font_id`,`print_id`)
1786) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1787
1788
1789DROP TABLE IF EXISTS `order_type_groups`;
1790CREATE TABLE `order_type_groups` (
1791  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1792  `order_id` int(10) unsigned NOT NULL,
1793  `digital` tinyint(1) DEFAULT '0',
1794  `full_color` tinyint(1) DEFAULT '0',
1795  `name_logo` tinyint(1) DEFAULT '0',
1796  `white` tinyint(1) DEFAULT '0',
1797  `color` tinyint(1) DEFAULT '0',
1798  `sublimation` tinyint(1) DEFAULT '0',
1799  `empty` tinyint(1) DEFAULT '0',
1800  `embroider` tinyint(1) DEFAULT '0',
1801  `sticker` tinyint(1) DEFAULT '0',
1802  PRIMARY KEY (`id`),
1803  UNIQUE KEY `order_id` (`order_id`)
1804) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1805
1806
1807DROP TABLE IF EXISTS `outlets`;
1808CREATE TABLE `outlets` (
1809  `id` int(20) NOT NULL AUTO_INCREMENT,
1810  `site` int(20) NOT NULL,
1811  `name` varchar(255) NOT NULL,
1812  `active` tinyint(1) NOT NULL,
1813  `defaultLeadsource` int(20) DEFAULT NULL,
1814  `useDifferentHomepage` tinyint(1) NOT NULL,
1815  `useDifferentHeader` tinyint(1) NOT NULL,
1816  `defaultDomain` int(20) DEFAULT NULL,
1817  `showFooter1` tinyint(1) NOT NULL,
1818  `showFooter2` tinyint(1) NOT NULL,
1819  `css_color_text` varchar(255) NOT NULL,
1820  `css_bg_img` varchar(255) NOT NULL,
1821  `css_header_img` varchar(255) NOT NULL,
1822  `css_color_bg` varchar(255) NOT NULL,
1823  `css_color_bg_tabs` varchar(255) NOT NULL,
1824  `css_navi_color_text` varchar(255) NOT NULL,
1825  `css_color_text_tabs` varchar(255) NOT NULL,
1826  `css_advanced` text NOT NULL,
1827  `site_id` int(10) NOT NULL,
1828  PRIMARY KEY (`id`),
1829  KEY `site` (`site`,`defaultLeadsource`)
1830) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1831
1832
1833DROP TABLE IF EXISTS `outlet_illustrations`;
1834CREATE TABLE `outlet_illustrations` (
1835  `outlet_id` int(10) unsigned NOT NULL,
1836  `illustration_id` int(10) unsigned NOT NULL,
1837  PRIMARY KEY (`outlet_id`,`illustration_id`)
1838) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1839
1840
1841DROP TABLE IF EXISTS `pattern_check`;
1842CREATE TABLE `pattern_check` (
1843  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1844  `order_rule_product_print_id` int(10) unsigned NOT NULL,
1845  `width_1` float unsigned NOT NULL,
1846  `width_2` float unsigned NOT NULL,
1847  `width_3` float unsigned NOT NULL,
1848  `width_4` float unsigned NOT NULL,
1849  `svg` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
1850  PRIMARY KEY (`id`),
1851  KEY `order_rule_product_print_id` (`order_rule_product_print_id`)
1852) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1853
1854
1855DROP TABLE IF EXISTS `payment_methods`;
1856CREATE TABLE `payment_methods` (
1857  `id` int(11) NOT NULL AUTO_INCREMENT,
1858  `system_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1859  `costs` float NOT NULL DEFAULT '0',
1860  `info` text COLLATE utf8_unicode_ci NOT NULL,
1861  `automail_ordered` text COLLATE utf8_unicode_ci NOT NULL,
1862  `automail_payment` text COLLATE utf8_unicode_ci NOT NULL,
1863  `psp` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1864  `order_id` int(11) DEFAULT NULL,
1865  `active` tinyint(1) NOT NULL DEFAULT '1',
1866  `old_id` int(11) DEFAULT NULL,
1867  PRIMARY KEY (`id`),
1868  KEY `old_id` (`old_id`)
1869) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1870
1871
1872DROP TABLE IF EXISTS `pdfgen_jobs`;
1873CREATE TABLE `pdfgen_jobs` (
1874  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1875  `date` int(10) unsigned NOT NULL,
1876  `user_id` int(10) unsigned NOT NULL,
1877  `mold_id` int(10) unsigned NOT NULL,
1878  `status` int(11) NOT NULL DEFAULT '0' COMMENT '0 = open, 1 = closed',
1879  `test_order` int(1) NOT NULL DEFAULT '0',
1880  PRIMARY KEY (`id`),
1881  KEY `user_id_index` (`user_id`)
1882) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1883
1884
1885DROP TABLE IF EXISTS `pdfgen_jobs_lines`;
1886CREATE TABLE `pdfgen_jobs_lines` (
1887  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1888  `batch_id` int(10) unsigned NOT NULL,
1889  `order_rule_product_print_id` int(10) unsigned NOT NULL,
1890  `sequence` int(10) NOT NULL,
1891  PRIMARY KEY (`id`),
1892  KEY `batch_id_index` (`batch_id`),
1893  KEY `order_rule_product_print_id_index` (`order_rule_product_print_id`)
1894) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1895
1896
1897DROP TABLE IF EXISTS `pdfgen_orders`;
1898CREATE TABLE `pdfgen_orders` (
1899  `id` int(11) NOT NULL AUTO_INCREMENT,
1900  `session_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1901  `state` text COLLATE utf8_unicode_ci NOT NULL,
1902  `order_rule` text COLLATE utf8_unicode_ci NOT NULL,
1903  `date_created` datetime NOT NULL,
1904  PRIMARY KEY (`id`),
1905  KEY `date_created` (`date_created`),
1906  KEY `session_id` (`session_id`)
1907) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1908
1909
1910DROP TABLE IF EXISTS `pdfgen_orders_csv`;
1911CREATE TABLE `pdfgen_orders_csv` (
1912  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1913  `content` text COLLATE utf8_unicode_ci,
1914  PRIMARY KEY (`id`)
1915) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1916
1917
1918DROP TABLE IF EXISTS `picbon_selection`;
1919CREATE TABLE `picbon_selection` (
1920  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1921  `batch_id` int(255) NOT NULL,
1922  `order_id` int(10) unsigned NOT NULL,
1923  `date` datetime NOT NULL,
1924  `file_count` int(10) unsigned NOT NULL,
1925  PRIMARY KEY (`id`),
1926  UNIQUE KEY `order_id` (`order_id`)
1927) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1928
1929
1930DROP TABLE IF EXISTS `plot_items`;
1931CREATE TABLE `plot_items` (
1932  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1933  `plot_job_id` bigint(20) unsigned NOT NULL DEFAULT '0',
1934  `order_id` bigint(20) NOT NULL,
1935  `line_1` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
1936  `line_2` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
1937  `line_3` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
1938  `size_1` int(10) unsigned NOT NULL,
1939  `size_2` int(10) unsigned NOT NULL,
1940  `size_3` int(10) unsigned NOT NULL,
1941  `font_id` int(10) unsigned NOT NULL,
1942  `print_id` int(10) unsigned NOT NULL,
1943  `print_size` int(10) unsigned NOT NULL,
1944  `file_number` int(10) unsigned NOT NULL,
1945  `curved` tinyint(1) DEFAULT '0',
1946  `max_height` int(10) NOT NULL DEFAULT '0',
1947  PRIMARY KEY (`id`),
1948  KEY `plot_job_id` (`plot_job_id`)
1949) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1950
1951
1952DROP TABLE IF EXISTS `plot_jobs`;
1953CREATE TABLE `plot_jobs` (
1954  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1955  `user_id` int(11) unsigned DEFAULT NULL,
1956  `batch_id` int(11) NOT NULL,
1957  `print_color_id` int(10) unsigned NOT NULL,
1958  `status_id` int(11) NOT NULL,
1959  `date` datetime NOT NULL,
1960  `file_count` int(10) unsigned NOT NULL,
1961  `priority` tinyint(4) DEFAULT NULL,
1962  `progress` varchar(10) COLLATE utf8_unicode_ci DEFAULT '0',
1963  `handeled_at` datetime DEFAULT NULL,
1964  `finished_at` datetime DEFAULT NULL,
1965  PRIMARY KEY (`id`)
1966) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1967
1968
1969DROP TABLE IF EXISTS `popular`;
1970CREATE TABLE `popular` (
1971  `id` int(11) NOT NULL AUTO_INCREMENT,
1972  `language_id` int(11) NOT NULL,
1973  `img` varchar(255) NOT NULL,
1974  `text` varchar(255) NOT NULL,
1975  `subtext` varchar(255) NOT NULL,
1976  `url` varchar(255) NOT NULL,
1977  PRIMARY KEY (`id`)
1978) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1979
1980
1981DROP TABLE IF EXISTS `prints`;
1982CREATE TABLE `prints` (
1983  `id` int(11) NOT NULL AUTO_INCREMENT,
1984  `cid` int(11) NOT NULL,
1985  `pattern_preview` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1986  `pattern_text_line_overrule_1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1987  `pattern_text_line_overrule_2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1988  `pattern_text_line_overrule_3` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1989  `active` tinyint(3) unsigned NOT NULL DEFAULT '0',
1990  `order_id` int(10) unsigned NOT NULL DEFAULT '0',
1991  PRIMARY KEY (`id`),
1992  UNIQUE KEY `print_category_id` (`cid`)
1993) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1994
1995
1996DROP TABLE IF EXISTS `prints_category_link`;
1997CREATE TABLE `prints_category_link` (
1998  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1999  `cid` int(10) unsigned NOT NULL,
2000  `print_category_id` int(10) unsigned NOT NULL,
2001  PRIMARY KEY (`id`),
2002  KEY `cid` (`cid`)
2003) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2004
2005
2006DROP TABLE IF EXISTS `print_categories`;
2007CREATE TABLE `print_categories` (
2008  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
2009  `system_name` varchar(255) NOT NULL,
2010  `active` tinyint(1) unsigned NOT NULL DEFAULT '0',
2011  `order_id` int(10) unsigned NOT NULL,
2012  PRIMARY KEY (`id`)
2013) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2014
2015
2016DROP TABLE IF EXISTS `print_colors`;
2017CREATE TABLE `print_colors` (
2018  `id` int(11) NOT NULL AUTO_INCREMENT,
2019  `cid` int(11) NOT NULL,
2020  `price` double NOT NULL DEFAULT '0',
2021  `active` tinyint(3) unsigned NOT NULL DEFAULT '1',
2022  `order_id` int(11) DEFAULT NULL,
2023  PRIMARY KEY (`id`),
2024  UNIQUE KEY `cid` (`cid`)
2025) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2026
2027
2028DROP TABLE IF EXISTS `print_sizes`;
2029CREATE TABLE `print_sizes` (
2030  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
2031  `cid` int(10) unsigned NOT NULL DEFAULT '0',
2032  `active` tinyint(1) unsigned NOT NULL DEFAULT '0',
2033  `order_id` int(10) unsigned NOT NULL DEFAULT '0',
2034  PRIMARY KEY (`id`)
2035) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2036
2037
2038DROP TABLE IF EXISTS `products`;
2039CREATE TABLE `products` (
2040  `id` int(11) NOT NULL AUTO_INCREMENT,
2041  `cid` int(10) unsigned NOT NULL DEFAULT '0',
2042  `product_color_id` int(11) NOT NULL,
2043  `product_size_id` int(11) NOT NULL,
2044  `product_type_id` int(11) NOT NULL,
2045  `price` float NOT NULL DEFAULT '0',
2046  `active` tinyint(1) NOT NULL DEFAULT '1',
2047  `sold` int(11) NOT NULL DEFAULT '0',
2048  `reserved` int(11) NOT NULL DEFAULT '0',
2049  `rejected` int(11) NOT NULL DEFAULT '0',
2050  `last_modified` datetime DEFAULT '0000-00-00 00:00:00',
2051  PRIMARY KEY (`id`),
2052  KEY `cid` (`cid`),
2053  KEY `product_color_id` (`product_color_id`),
2054  KEY `product_size_id` (`product_size_id`),
2055  KEY `product_type_id` (`product_type_id`)
2056) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2057
2058
2059DROP TABLE IF EXISTS `product_aggregate_ratings`;
2060CREATE TABLE `product_aggregate_ratings` (
2061  `id` int(11) NOT NULL AUTO_INCREMENT,
2062  `sku` int(11) NOT NULL,
2063  `rating` double NOT NULL DEFAULT '5',
2064  `total_number_of_ratings` int(11) NOT NULL DEFAULT '0',
2065  PRIMARY KEY (`id`),
2066  KEY `sku` (`sku`)
2067) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2068
2069
2070DROP TABLE IF EXISTS `product_colors`;
2071CREATE TABLE `product_colors` (
2072  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
2073  `cid` int(10) unsigned NOT NULL,
2074  `active` tinyint(1) unsigned NOT NULL DEFAULT '0',
2075  `order_id` int(11) NOT NULL,
2076  PRIMARY KEY (`id`),
2077  KEY `cid` (`cid`)
2078) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2079
2080
2081DROP TABLE IF EXISTS `product_finder_age_categories`;
2082CREATE TABLE `product_finder_age_categories` (
2083  `id` int(11) NOT NULL AUTO_INCREMENT,
2084  `system_name` varchar(255) NOT NULL,
2085  PRIMARY KEY (`id`)
2086) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2087
2088
2089DROP TABLE IF EXISTS `product_finder_age_categories_translations`;
2090CREATE TABLE `product_finder_age_categories_translations` (
2091  `id` int(11) NOT NULL AUTO_INCREMENT,
2092  `category_id` int(11) NOT NULL,
2093  `language_id` int(11) NOT NULL,
2094  `translation` varchar(255) NOT NULL,
2095  PRIMARY KEY (`id`)
2096) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2097
2098
2099DROP TABLE IF EXISTS `product_finder_price_categories`;
2100CREATE TABLE `product_finder_price_categories` (
2101  `id` int(11) NOT NULL AUTO_INCREMENT,
2102  `system_name` varchar(255) NOT NULL,
2103  PRIMARY KEY (`id`)
2104) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2105
2106
2107DROP TABLE IF EXISTS `product_finder_price_categories_translations`;
2108CREATE TABLE `product_finder_price_categories_translations` (
2109  `id` int(11) NOT NULL AUTO_INCREMENT,
2110  `category_id` int(11) NOT NULL,
2111  `language_id` int(11) NOT NULL,
2112  `translation` varchar(255) NOT NULL,
2113  PRIMARY KEY (`id`)
2114) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2115
2116
2117DROP TABLE IF EXISTS `product_finder_product_settings`;
2118CREATE TABLE `product_finder_product_settings` (
2119  `id` int(11) NOT NULL AUTO_INCREMENT,
2120  `product_id` int(11) NOT NULL,
2121  `gender_boy` int(11) NOT NULL,
2122  `gender_girl` int(11) NOT NULL,
2123  `default_size` int(11) NOT NULL,
2124  `default_color_general` int(11) NOT NULL,
2125  `default_color_boy` int(11) NOT NULL,
2126  `default_color_girl` int(11) NOT NULL,
2127  `default_print_color_white` int(11) NOT NULL,
2128  `default_print_color_rest` int(11) NOT NULL,
2129  `default_font_general` int(11) NOT NULL,
2130  `default_font_boy` int(11) NOT NULL,
2131  `default_font_girl` int(11) NOT NULL,
2132  `default_print_type` varchar(255) NOT NULL,
2133  `default_print_general` int(11) NOT NULL,
2134  `default_print_boy` int(11) NOT NULL,
2135  `default_print_girl` int(11) NOT NULL,
2136  `default_redirect_text` int(11) NOT NULL,
2137  `default_redirect_text_illustration` int(11) NOT NULL,
2138  PRIMARY KEY (`id`)
2139) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2140
2141
2142DROP TABLE IF EXISTS `product_finder_product_settings_age_categories`;
2143CREATE TABLE `product_finder_product_settings_age_categories` (
2144  `id` int(11) NOT NULL AUTO_INCREMENT,
2145  `product_id` int(11) NOT NULL,
2146  `product_finder_age_category_id` int(11) NOT NULL,
2147  `product_size_id` int(11) NOT NULL DEFAULT '0' COMMENT 'If this value > 0, this size should be shown in the product finder',
2148  `text` int(11) NOT NULL DEFAULT '0',
2149  `text_illustration` int(11) NOT NULL DEFAULT '0',
2150  PRIMARY KEY (`id`)
2151) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2152
2153
2154DROP TABLE IF EXISTS `product_finder_product_settings_price_categories`;
2155CREATE TABLE `product_finder_product_settings_price_categories` (
2156  `id` int(11) NOT NULL AUTO_INCREMENT,
2157  `product_id` int(11) NOT NULL,
2158  `product_finder_price_category_id` int(11) NOT NULL,
2159  `text` tinyint(4) NOT NULL DEFAULT '0',
2160  `text_illustration` tinyint(4) NOT NULL DEFAULT '0',
2161  `product_size_id` int(11) NOT NULL DEFAULT '0' COMMENT 'If this value > 0, this size should be shown in the product finder',
2162  PRIMARY KEY (`id`)
2163) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2164
2165
2166DROP TABLE IF EXISTS `product_finder_product_settings_price_categories_ages`;
2167CREATE TABLE `product_finder_product_settings_price_categories_ages` (
2168  `id` int(11) NOT NULL AUTO_INCREMENT,
2169  `product_id` int(11) NOT NULL,
2170  `product_finder_product_settings_price_category_id` int(11) NOT NULL,
2171  `product_finder_product_settings_age_category_id` int(11) NOT NULL,
2172  `text` int(11) NOT NULL DEFAULT '0',
2173  `text_illustration` int(11) NOT NULL DEFAULT '0',
2174  `product_size_id` int(11) NOT NULL,
2175  PRIMARY KEY (`id`)
2176) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2177
2178
2179DROP TABLE IF EXISTS `product_finder_product_settings_sections`;
2180CREATE TABLE `product_finder_product_settings_sections` (
2181  `id` int(11) NOT NULL AUTO_INCREMENT,
2182  `product_id` int(11) NOT NULL,
2183  `product_finder_section_id` int(11) NOT NULL,
2184  PRIMARY KEY (`id`)
2185) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2186
2187
2188DROP TABLE IF EXISTS `product_finder_sections`;
2189CREATE TABLE `product_finder_sections` (
2190  `id` int(11) NOT NULL AUTO_INCREMENT,
2191  `system_name` varchar(255) NOT NULL,
2192  PRIMARY KEY (`id`)
2193) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2194
2195
2196DROP TABLE IF EXISTS `product_finder_section_translations`;
2197CREATE TABLE `product_finder_section_translations` (
2198  `id` int(11) NOT NULL AUTO_INCREMENT,
2199  `section_id` int(11) NOT NULL,
2200  `language_id` int(11) NOT NULL,
2201  `translation` varchar(255) NOT NULL,
2202  PRIMARY KEY (`id`)
2203) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2204
2205
2206DROP TABLE IF EXISTS `product_groups`;
2207CREATE TABLE `product_groups` (
2208  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
2209  `parent_id` int(11) unsigned NOT NULL,
2210  `system_name` varchar(255) NOT NULL,
2211  `active` tinyint(1) unsigned NOT NULL,
2212  `order_id` int(10) unsigned NOT NULL,
2213  PRIMARY KEY (`id`)
2214) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2215
2216
2217DROP TABLE IF EXISTS `product_jumps`;
2218CREATE TABLE `product_jumps` (
2219  `id` int(11) NOT NULL AUTO_INCREMENT,
2220  `name` varchar(255) NOT NULL,
2221  `type_id` int(11) NOT NULL,
2222  `uuid` varchar(50) NOT NULL,
2223  PRIMARY KEY (`id`)
2224) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2225
2226
2227DROP TABLE IF EXISTS `product_jumps_v5`;
2228CREATE TABLE `product_jumps_v5` (
2229  `id` int(11) NOT NULL AUTO_INCREMENT,
2230  `name` varchar(255) NOT NULL,
2231  `type_id` int(11) NOT NULL,
2232  `uuid` varchar(50) NOT NULL,
2233  `last_modified` datetime DEFAULT '0000-00-00 00:00:00',
2234  PRIMARY KEY (`id`)
2235) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2236
2237
2238DROP TABLE IF EXISTS `product_print_side_options`;
2239CREATE TABLE `product_print_side_options` (
2240  `id` int(11) NOT NULL AUTO_INCREMENT,
2241  `product_type_id` int(11) NOT NULL,
2242  `print_side_id` int(11) NOT NULL,
2243  `max_chars` int(11) NOT NULL,
2244  `number_of_lines` tinyint(4) NOT NULL DEFAULT '3',
2245  `hide_text_slides` tinyint(4) NOT NULL DEFAULT '0',
2246  `hide_image_slides` tinyint(4) NOT NULL DEFAULT '0',
2247  PRIMARY KEY (`id`)
2248) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2249
2250
2251DROP TABLE IF EXISTS `product_reviews`;
2252CREATE TABLE `product_reviews` (
2253  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
2254  `identifier` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
2255  `product_reviews_product_id` int(10) unsigned NOT NULL,
2256  `product_reviews_consumer_id` int(10) unsigned NOT NULL,
2257  `date` datetime NOT NULL,
2258  `stars` tinyint(4) NOT NULL,
2259  `content` text COLLATE utf8_unicode_ci NOT NULL,
2260  PRIMARY KEY (`id`),
2261  KEY `identifier` (`identifier`),
2262  KEY `product_reviews_product_id` (`product_reviews_product_id`),
2263  KEY `product_reviews_consumer_id` (`product_reviews_consumer_id`)
2264) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2265
2266
2267DROP TABLE IF EXISTS `product_reviews_consumers`;
2268CREATE TABLE `product_reviews_consumers` (
2269  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
2270  `identifier` varchar(255) NOT NULL,
2271  `email` varchar(255) NOT NULL,
2272  `name` varchar(255) NOT NULL,
2273  PRIMARY KEY (`id`),
2274  KEY `identifier` (`identifier`)
2275) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2276
2277
2278DROP TABLE IF EXISTS `product_reviews_products`;
2279CREATE TABLE `product_reviews_products` (
2280  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
2281  `identifier` varchar(255) NOT NULL,
2282  `sku` int(11) NOT NULL,
2283  `brand` varchar(255) NOT NULL DEFAULT 'simply colors',
2284  `name` varchar(255) NOT NULL,
2285  `url` varchar(255) DEFAULT NULL,
2286  `image` varchar(255) DEFAULT NULL,
2287  PRIMARY KEY (`id`),
2288  KEY `identifier` (`identifier`),
2289  KEY `sku` (`sku`)
2290) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2291
2292
2293DROP TABLE IF EXISTS `product_sets`;
2294CREATE TABLE `product_sets` (
2295  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2296  `set_id` int(10) NOT NULL,
2297  `product_type_id` int(10) NOT NULL,
2298  `system_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
2299  `description` int(11) NOT NULL,
2300  `active` tinyint(1) unsigned NOT NULL,
2301  PRIMARY KEY (`id`),
2302  UNIQUE KEY `set_id` (`set_id`,`product_type_id`)
2303) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2304
2305
2306DROP TABLE IF EXISTS `product_sets_jump`;
2307CREATE TABLE `product_sets_jump` (
2308  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2309  `product_1` int(10) NOT NULL,
2310  `product_2` int(10) NOT NULL,
2311  `system_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
2312  `active` tinyint(1) unsigned NOT NULL,
2313  PRIMARY KEY (`id`)
2314) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2315
2316
2317DROP TABLE IF EXISTS `product_sides`;
2318CREATE TABLE `product_sides` (
2319  `id` int(11) NOT NULL AUTO_INCREMENT,
2320  `product_type_id` int(11) NOT NULL,
2321  `side_id` int(11) NOT NULL,
2322  PRIMARY KEY (`id`),
2323  UNIQUE KEY `product_type_id` (`product_type_id`,`side_id`)
2324) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2325
2326
2327DROP TABLE IF EXISTS `product_sizes`;
2328CREATE TABLE `product_sizes` (
2329  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
2330  `cid` int(10) unsigned NOT NULL,
2331  `active` tinyint(1) unsigned NOT NULL,
2332  `order_id` int(10) unsigned NOT NULL,
2333  PRIMARY KEY (`id`),
2334  KEY `cid` (`cid`)
2335) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2336
2337
2338DROP TABLE IF EXISTS `product_size_groups`;
2339CREATE TABLE `product_size_groups` (
2340  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
2341  `cid` int(10) unsigned NOT NULL DEFAULT '0',
2342  `active` tinyint(1) unsigned NOT NULL DEFAULT '0',
2343  PRIMARY KEY (`id`)
2344) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2345
2346
2347DROP TABLE IF EXISTS `product_states`;
2348CREATE TABLE `product_states` (
2349  `id` int(11) NOT NULL AUTO_INCREMENT,
2350  `uuid` varchar(50) NOT NULL,
2351  `date` datetime NOT NULL,
2352  `order_amount` int(2) unsigned NOT NULL,
2353  `type_id` int(11) NOT NULL,
2354  `color_id` int(11) NOT NULL,
2355  `size_id` int(11) NOT NULL,
2356  `is_promo` tinyint(1) NOT NULL DEFAULT '0',
2357  `discount_type` int(10) unsigned DEFAULT NULL,
2358  `discount_amount` varchar(20) DEFAULT NULL,
2359  `groupId` int(12) DEFAULT NULL,
2360  `setUuid` varchar(255) DEFAULT NULL,
2361  PRIMARY KEY (`id`),
2362  KEY `uuid` (`uuid`),
2363  KEY `type_id` (`type_id`,`uuid`),
2364  KEY `setUuid` (`setUuid`)
2365) ENGINE=MyISAM DEFAULT CHARSET=latin1;
2366
2367
2368DROP TABLE IF EXISTS `product_state_sides`;
2369CREATE TABLE `product_state_sides` (
2370  `id` int(11) NOT NULL AUTO_INCREMENT,
2371  `product_state_id` int(11) NOT NULL,
2372  `side_id` int(11) NOT NULL,
2373  `print_type` varchar(30) NOT NULL,
2374  `is_selected` tinyint(1) NOT NULL DEFAULT '0',
2375  `illustrationCategory` varchar(255) NOT NULL,
2376  PRIMARY KEY (`id`)
2377) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2378
2379
2380DROP TABLE IF EXISTS `product_state_side_printlines`;
2381CREATE TABLE `product_state_side_printlines` (
2382  `id` int(11) NOT NULL AUTO_INCREMENT,
2383  `product_state_side_id` int(11) NOT NULL,
2384  `color_id` int(11) NOT NULL,
2385  `font_id` int(11) NOT NULL,
2386  `height` float(5,2) NOT NULL,
2387  `width` float(5,2) NOT NULL,
2388  `illustration_id` int(11) NOT NULL,
2389  `image_color_type` varchar(20) DEFAULT NULL COMMENT 'possible types: NULL, monochrome, fullcolor',
2390  `size` float(5,2) NOT NULL,
2391  `type` varchar(20) NOT NULL,
2392  `value` varchar(100) CHARACTER SET utf8 NOT NULL,
2393  `pictureName` varchar(255) NOT NULL,
2394  `cutout_type` varchar(255) NOT NULL,
2395  PRIMARY KEY (`id`),
2396  KEY `product_state_side_id` (`product_state_side_id`)
2397) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2398
2399
2400DROP TABLE IF EXISTS `product_types`;
2401CREATE TABLE `product_types` (
2402  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
2403  `cid` int(10) unsigned NOT NULL DEFAULT '0',
2404  `active` tinyint(3) unsigned NOT NULL DEFAULT '0',
2405  `upsell` int(11) NOT NULL DEFAULT '0',
2406  `product_finder` int(11) NOT NULL DEFAULT '0',
2407  `product_finder_sort` int(11) NOT NULL DEFAULT '1',
2408  `productFinder` int(11) NOT NULL DEFAULT '0',
2409  `productFinderSort` int(11) NOT NULL DEFAULT '1',
2410  `canonical_tag` varchar(255) DEFAULT NULL,
2411  `is_parcel` tinyint(3) NOT NULL DEFAULT '0',
2412  `google_category` varchar(200) DEFAULT '',
2413  `long_delivery_time` tinyint(1) DEFAULT '0',
2414  PRIMARY KEY (`id`),
2415  UNIQUE KEY `cid` (`cid`)
2416) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2417
2418
2419DROP TABLE IF EXISTS `product_types_upsell_redirects`;
2420CREATE TABLE `product_types_upsell_redirects` (
2421  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
2422  `product_type_id` int(11) NOT NULL,
2423  `tag_id` int(11) NOT NULL,
2424  `override_title` varchar(255) DEFAULT NULL,
2425  `override_image` varchar(255) DEFAULT NULL,
2426  PRIMARY KEY (`id`),
2427  KEY `product_type_id` (`product_type_id`),
2428  KEY `tag_id` (`tag_id`)
2429) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2430
2431
2432DROP TABLE IF EXISTS `product_type_options`;
2433CREATE TABLE `product_type_options` (
2434  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
2435  `product_type_id` int(10) unsigned NOT NULL,
2436  `type` enum('print_color','font','illustration') NOT NULL,
2437  `type_id` int(10) unsigned NOT NULL,
2438  PRIMARY KEY (`id`),
2439  KEY `product_type_id` (`product_type_id`),
2440  KEY `type` (`type`)
2441) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2442
2443
2444DROP TABLE IF EXISTS `product_view_side_options`;
2445CREATE TABLE `product_view_side_options` (
2446  `id` int(11) NOT NULL AUTO_INCREMENT,
2447  `product_type_id` int(11) NOT NULL,
2448  `print_side_id` int(11) NOT NULL,
2449  `print_x` int(11) NOT NULL,
2450  `print_y` int(11) NOT NULL,
2451  `print_width` int(11) NOT NULL,
2452  `print_height` int(11) NOT NULL,
2453  `rotation` int(11) NOT NULL,
2454  `align_horizontal` varchar(255) NOT NULL,
2455  `align_vertical` varchar(255) NOT NULL,
2456  `print_area_border` tinyint(4) NOT NULL DEFAULT '1',
2457  PRIMARY KEY (`id`)
2458) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2459
2460
2461DROP TABLE IF EXISTS `promotion_products`;
2462CREATE TABLE `promotion_products` (
2463  `id` int(11) NOT NULL AUTO_INCREMENT,
2464  `promotion_product_type_id` int(10) unsigned NOT NULL DEFAULT '0',
2465  `product_color_id` int(11) NOT NULL,
2466  `product_size_id` int(11) NOT NULL,
2467  `product_type_id` int(11) NOT NULL,
2468  `price` float NOT NULL DEFAULT '0',
2469  `active` tinyint(1) NOT NULL DEFAULT '1',
2470  `purchase_costs` float NOT NULL DEFAULT '0',
2471  `sold` int(11) NOT NULL DEFAULT '0',
2472  `reserved` int(11) NOT NULL DEFAULT '0',
2473  `rejected` int(11) NOT NULL DEFAULT '0',
2474  PRIMARY KEY (`id`)
2475) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2476
2477
2478DROP TABLE IF EXISTS `promotion_product_types`;
2479CREATE TABLE `promotion_product_types` (
2480  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
2481  `system_name` varchar(128) NOT NULL,
2482  `product_type_id` int(10) unsigned NOT NULL,
2483  `active` tinyint(1) unsigned NOT NULL DEFAULT '0',
2484  PRIMARY KEY (`id`)
2485) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2486
2487
2488DROP TABLE IF EXISTS `promo_gallery`;
2489CREATE TABLE `promo_gallery` (
2490  `id` int(11) NOT NULL AUTO_INCREMENT,
2491  `product_type_id` int(11) NOT NULL,
2492  `product_color_id` int(11) NOT NULL,
2493  `active` tinyint(1) NOT NULL DEFAULT '1',
2494  PRIMARY KEY (`id`),
2495  KEY `product_type_id` (`product_type_id`,`product_color_id`)
2496) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2497
2498
2499DROP TABLE IF EXISTS `promo_product_images`;
2500CREATE TABLE `promo_product_images` (
2501  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
2502  `gallery_id` int(10) unsigned NOT NULL,
2503  `product_size_id` int(10) unsigned NOT NULL,
2504  PRIMARY KEY (`id`)
2505) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2506
2507
2508DROP TABLE IF EXISTS `qlog`;
2509CREATE TABLE `qlog` (
2510  `id` int(11) NOT NULL AUTO_INCREMENT,
2511  `time` double NOT NULL,
2512  `query` text NOT NULL,
2513  PRIMARY KEY (`id`)
2514) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2515
2516
2517DROP TABLE IF EXISTS `resellers`;
2518CREATE TABLE `resellers` (
2519  `id` int(11) NOT NULL AUTO_INCREMENT,
2520  `system_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
2521  `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
2522  `leadsource_id` int(11) NOT NULL,
2523  `active` tinyint(1) NOT NULL DEFAULT '1',
2524  `old_id` int(11) DEFAULT NULL,
2525  `old_leadsource_id` int(11) DEFAULT NULL,
2526  PRIMARY KEY (`id`),
2527  KEY `lead_source_id` (`leadsource_id`)
2528) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2529
2530
2531DROP TABLE IF EXISTS `reseller_clicks`;
2532CREATE TABLE `reseller_clicks` (
2533  `id` int(11) NOT NULL AUTO_INCREMENT,
2534  `reseller_id` int(11) NOT NULL,
2535  `date` datetime NOT NULL,
2536  `ip_address` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
2537  `old_id` int(11) DEFAULT NULL,
2538  `old_reseller_id` int(11) DEFAULT NULL,
2539  PRIMARY KEY (`id`),
2540  KEY `reseller_id` (`reseller_id`)
2541) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2542
2543
2544DROP TABLE IF EXISTS `saved_products`;
2545CREATE TABLE `saved_products` (
2546  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2547  `uuid` char(36) COLLATE utf8_unicode_ci NOT NULL,
2548  `json` longtext COLLATE utf8_unicode_ci NOT NULL,
2549  `date` datetime NOT NULL,
2550  PRIMARY KEY (`id`),
2551  UNIQUE KEY `uuid` (`uuid`)
2552) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2553
2554
2555DROP TABLE IF EXISTS `saved_product_sets`;
2556CREATE TABLE `saved_product_sets` (
2557  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2558  `uuid` char(36) COLLATE utf8_unicode_ci NOT NULL,
2559  `json` longtext COLLATE utf8_unicode_ci NOT NULL,
2560  `date` datetime NOT NULL,
2561  PRIMARY KEY (`id`)
2562) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2563
2564
2565DROP TABLE IF EXISTS `search_index`;
2566CREATE TABLE `search_index` (
2567  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
2568  `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
2569  `force_search_index` tinyint(3) unsigned NOT NULL DEFAULT '0',
2570  PRIMARY KEY (`id`)
2571) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2572
2573
2574DROP TABLE IF EXISTS `shipping_costs`;
2575CREATE TABLE `shipping_costs` (
2576  `id` int(11) NOT NULL AUTO_INCREMENT,
2577  `country_id` int(11) NOT NULL,
2578  `region_id` int(11) NOT NULL DEFAULT '0',
2579  `express_shipping` tinyint(1) unsigned NOT NULL DEFAULT '0',
2580  `costs_1` float unsigned NOT NULL DEFAULT '0',
2581  `costs_2` float unsigned NOT NULL DEFAULT '0',
2582  `costs_3` float unsigned NOT NULL DEFAULT '0',
2583  `costs_4` float unsigned NOT NULL DEFAULT '0',
2584  `costs_5` float unsigned NOT NULL DEFAULT '0',
2585  `costs_6` float unsigned NOT NULL DEFAULT '0',
2586  `costs_7` float unsigned NOT NULL DEFAULT '0',
2587  `costs_8` float unsigned NOT NULL DEFAULT '0',
2588  `costs_9` float unsigned NOT NULL DEFAULT '0',
2589  `giftservice_cost` float unsigned NOT NULL DEFAULT '0',
2590  `vat` float NOT NULL DEFAULT '-1',
2591  PRIMARY KEY (`id`),
2592  KEY `country_id` (`country_id`,`region_id`)
2593) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2594
2595
2596DROP TABLE IF EXISTS `shipping_cost_configs`;
2597CREATE TABLE `shipping_cost_configs` (
2598  `id` int(11) NOT NULL AUTO_INCREMENT,
2599  `type` enum('items','product_total') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'product_total',
2600  `amount_1` float NOT NULL DEFAULT '0',
2601  `amount_2` float NOT NULL DEFAULT '0',
2602  `amount_3` float NOT NULL DEFAULT '0',
2603  `amount_int_1` float unsigned NOT NULL DEFAULT '0',
2604  `amount_int_2` float unsigned NOT NULL DEFAULT '0',
2605  `products_int_1` float unsigned NOT NULL DEFAULT '0',
2606  `products_int_2` float unsigned NOT NULL DEFAULT '0',
2607  PRIMARY KEY (`id`)
2608) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2609
2610
2611DROP TABLE IF EXISTS `shipping_log`;
2612CREATE TABLE `shipping_log` (
2613  `id` int(10) NOT NULL AUTO_INCREMENT,
2614  `shipping_provider_id` smallint(5) NOT NULL,
2615  `process_date` int(10) NOT NULL,
2616  `xml` blob NOT NULL,
2617  PRIMARY KEY (`id`)
2618) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2619
2620
2621DROP TABLE IF EXISTS `shipping_methods`;
2622CREATE TABLE `shipping_methods` (
2623  `id` int(11) NOT NULL AUTO_INCREMENT,
2624  `system_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
2625  `costs` double NOT NULL DEFAULT '0',
2626  `order_id` int(11) DEFAULT NULL,
2627  `active` tinyint(1) NOT NULL DEFAULT '1',
2628  `express_shipping` tinyint(1) unsigned NOT NULL DEFAULT '0',
2629  PRIMARY KEY (`id`)
2630) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2631
2632
2633DROP TABLE IF EXISTS `shop_reviews`;
2634CREATE TABLE `shop_reviews` (
2635  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
2636  `identifier` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
2637  `date` datetime NOT NULL,
2638  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
2639  `content` text COLLATE utf8_unicode_ci NOT NULL,
2640  `score` tinyint(4) NOT NULL,
2641  `reviewed_by` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
2642  `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
2643  PRIMARY KEY (`id`),
2644  KEY `identifier` (`identifier`),
2645  KEY `score` (`score`)
2646) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2647
2648
2649DROP TABLE IF EXISTS `shop_reviews_aggregate`;
2650CREATE TABLE `shop_reviews_aggregate` (
2651  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
2652  `handle` varchar(255) NOT NULL,
2653  `rating` decimal(2,1) NOT NULL,
2654  `highest_rating` int(11) NOT NULL,
2655  `count` int(11) NOT NULL,
2656  PRIMARY KEY (`id`)
2657) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2658
2659
2660DROP TABLE IF EXISTS `site_options`;
2661CREATE TABLE `site_options` (
2662  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
2663  `section` enum('general') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'general',
2664  `option_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
2665  `option_value` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
2666  PRIMARY KEY (`id`),
2667  KEY `option_name` (`option_name`)
2668) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2669
2670
2671DROP TABLE IF EXISTS `state_products`;
2672CREATE TABLE `state_products` (
2673  `uuid` varchar(50) NOT NULL,
2674  `data` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
2675  PRIMARY KEY (`uuid`)
2676) ENGINE=MyISAM DEFAULT CHARSET=latin1;
2677
2678
2679DROP TABLE IF EXISTS `stats_prints_sold`;
2680CREATE TABLE `stats_prints_sold` (
2681  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
2682  `product_type_id` int(10) unsigned NOT NULL,
2683  `product_size_id` int(10) unsigned NOT NULL,
2684  `print_id` int(10) unsigned NOT NULL,
2685  `sold` int(10) unsigned NOT NULL DEFAULT '0',
2686  PRIMARY KEY (`id`),
2687  KEY `product_id` (`product_type_id`),
2688  KEY `print_id` (`print_id`),
2689  KEY `product_size_id` (`product_size_id`)
2690) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2691
2692
2693DROP TABLE IF EXISTS `stock_log`;
2694CREATE TABLE `stock_log` (
2695  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
2696  `user_id` int(11) NOT NULL,
2697  `product_id` int(11) NOT NULL,
2698  `amount` int(11) NOT NULL,
2699  `log_date` datetime DEFAULT NULL,
2700  PRIMARY KEY (`id`)
2701) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2702
2703
2704DROP TABLE IF EXISTS `stock_pages`;
2705CREATE TABLE `stock_pages` (
2706  `id` int(11) NOT NULL AUTO_INCREMENT,
2707  `system_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
2708  PRIMARY KEY (`id`)
2709) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2710
2711
2712DROP TABLE IF EXISTS `stock_pages_products`;
2713CREATE TABLE `stock_pages_products` (
2714  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
2715  `sort` int(10) NOT NULL DEFAULT '-1',
2716  `stock_page_id` int(10) unsigned NOT NULL,
2717  `product_id` int(10) unsigned NOT NULL,
2718  `tag_id` int(11) NOT NULL DEFAULT '0',
2719  `print_price` varchar(255) COLLATE utf8_unicode_ci DEFAULT '6.95',
2720  `stock_page_discount` int(3) DEFAULT '50',
2721  PRIMARY KEY (`id`),
2722  KEY `product_id` (`product_id`),
2723  KEY `stock_page_id` (`stock_page_id`)
2724) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2725
2726
2727DROP TABLE IF EXISTS `stock_pages_translations`;
2728CREATE TABLE `stock_pages_translations` (
2729  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
2730  `stock_page_id` int(10) unsigned NOT NULL,
2731  `language_id` int(10) unsigned NOT NULL,
2732  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
2733  `content` text COLLATE utf8_unicode_ci,
2734  PRIMARY KEY (`id`),
2735  KEY `stock_page_id` (`stock_page_id`),
2736  KEY `language_id` (`language_id`)
2737) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2738
2739
2740DROP TABLE IF EXISTS `stock_subscription_addresses`;
2741CREATE TABLE `stock_subscription_addresses` (
2742  `id` int(11) NOT NULL AUTO_INCREMENT,
2743  `product_type_id` int(11) NOT NULL,
2744  `product_size_id` int(11) NOT NULL,
2745  `email_address` varchar(255) NOT NULL,
2746  `date` datetime NOT NULL,
2747  PRIMARY KEY (`id`)
2748) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2749
2750
2751DROP TABLE IF EXISTS `stock_subscription_products_types`;
2752CREATE TABLE `stock_subscription_products_types` (
2753  `id` int(11) NOT NULL AUTO_INCREMENT,
2754  `product_type_id` int(11) NOT NULL,
2755  `text` text NOT NULL,
2756  PRIMARY KEY (`id`)
2757) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2758
2759
2760DROP TABLE IF EXISTS `subscriptions_types`;
2761CREATE TABLE `subscriptions_types` (
2762  `id` int(11) NOT NULL AUTO_INCREMENT,
2763  `system_name` varchar(45) NOT NULL,
2764  PRIMARY KEY (`id`)
2765) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2766
2767
2768DROP TABLE IF EXISTS `tags`;
2769CREATE TABLE `tags` (
2770  `id` int(10) NOT NULL AUTO_INCREMENT,
2771  `type_id` int(10) DEFAULT NULL,
2772  `tag` varchar(255) NOT NULL,
2773  `content_id` varchar(10) DEFAULT NULL,
2774  `content` varchar(255) DEFAULT NULL,
2775  `active` tinyint(4) NOT NULL DEFAULT '1',
2776  PRIMARY KEY (`id`),
2777  UNIQUE KEY `tag` (`tag`),
2778  KEY `contentId` (`content_id`)
2779) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2780
2781
2782DROP TABLE IF EXISTS `tnt`;
2783CREATE TABLE `tnt` (
2784  `id` int(10) NOT NULL AUTO_INCREMENT,
2785  `datum` int(10) NOT NULL,
2786  `aantal_orders` int(10) NOT NULL,
2787  `ftp_upload` int(10) NOT NULL,
2788  PRIMARY KEY (`id`)
2789) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
2790
2791
2792DROP TABLE IF EXISTS `translations`;
2793CREATE TABLE `translations` (
2794  `id` int(11) NOT NULL AUTO_INCREMENT,
2795  `translation_item_id` int(11) NOT NULL,
2796  `language_id` int(11) NOT NULL,
2797  `translation` longtext COLLATE utf8_unicode_ci,
2798  PRIMARY KEY (`id`),
2799  KEY `translation_item_id` (`translation_item_id`,`language_id`)
2800) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2801
2802
2803DROP TABLE IF EXISTS `translation_groups`;
2804CREATE TABLE `translation_groups` (
2805  `id` int(11) NOT NULL AUTO_INCREMENT,
2806  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
2807  PRIMARY KEY (`id`)
2808) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2809
2810
2811DROP TABLE IF EXISTS `translation_items`;
2812CREATE TABLE `translation_items` (
2813  `id` int(11) NOT NULL AUTO_INCREMENT,
2814  `translation_group_id` int(11) NOT NULL,
2815  `item` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
2816  PRIMARY KEY (`id`),
2817  KEY `translation_group_id` (`translation_group_id`),
2818  KEY `item` (`item`)
2819) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2820
2821
2822DROP TABLE IF EXISTS `translation_models`;
2823CREATE TABLE `translation_models` (
2824  `classname` varchar(255) NOT NULL,
2825  `property` varchar(255) NOT NULL,
2826  `translation_group_id` int(10) NOT NULL,
2827  PRIMARY KEY (`classname`,`property`),
2828  KEY `classname` (`classname`,`property`,`translation_group_id`)
2829) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2830
2831
2832-- 2018-09-17 14:51:44