· 8 years ago · Aug 26, 2018, 11:34 AM
1-- Скрипт Ñгенерирован Devart dbForge Studio for MySQL, ВерÑÐ¸Ñ 4.50.315.1
2-- Дата: 04.01.2011 17:00:18
3-- ВерÑÐ¸Ñ Ñервера: 5.0.45-community-nt
4-- ВерÑÐ¸Ñ ÐºÐ»Ð¸ÐµÐ½Ñ‚Ð°: 4.1
5
6DROP TABLE IF EXISTS m2e_accounts;
7CREATE TABLE m2e_accounts(
8 id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
9 account VARCHAR(50) NOT NULL,
10 mode TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
11 token TEXT NOT NULL,
12 create_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
13 PRIMARY KEY (id),
14 INDEX account (account),
15 INDEX mode (mode)
16)
17ENGINE = INNODB
18AUTO_INCREMENT = 5
19AVG_ROW_LENGTH = 4096
20CHARACTER SET utf8
21COLLATE utf8_general_ci;
22
23DROP TABLE IF EXISTS m2e_calculated_shipping;
24CREATE TABLE m2e_calculated_shipping(
25 template_id INT(11) UNSIGNED NOT NULL,
26 measurement_system TINYINT(1) NOT NULL DEFAULT 1 COMMENT '1 - english, 2 - metric',
27 weight_lbs VARCHAR(500) NOT NULL,
28 weight_oz VARCHAR(500) NOT NULL,
29 package_size VARCHAR(500) NOT NULL,
30 width VARCHAR(500) NOT NULL,
31 height VARCHAR(500) NOT NULL,
32 depth VARCHAR(500) NOT NULL,
33 domestic_fee VARCHAR(500) NOT NULL,
34 international_fee VARCHAR(500) NOT NULL,
35 post_code VARCHAR(10) NOT NULL,
36 calculation_weght_mode INT(11) NOT NULL,
37 weight_attribute_lbs VARCHAR(100) NOT NULL,
38 weight_attribute_oz VARCHAR(100) NOT NULL,
39 package_size_mode INT(11) NOT NULL,
40 package_size_attribute VARCHAR(100) NOT NULL,
41 dimentions_mode INT(11) NOT NULL,
42 dimentions_attribute_width VARCHAR(100) NOT NULL,
43 dimentions_attribute_height VARCHAR(100) NOT NULL,
44 dimentions_attribute_depth VARCHAR(100) NOT NULL,
45 handling_feed_mode INT(11) NOT NULL,
46 handling_feed_attribute VARCHAR(100) NOT NULL,
47 inthandling_feed_mode INT(11) NOT NULL,
48 international_handling_fee VARCHAR(100) NOT NULL,
49 international_handling_fee_attribute VARCHAR(200) NOT NULL,
50 PRIMARY KEY (template_id)
51)
52ENGINE = INNODB
53AVG_ROW_LENGTH = 8192
54CHARACTER SET utf8
55COLLATE utf8_general_ci;
56
57DROP TABLE IF EXISTS m2e_categories;
58CREATE TABLE m2e_categories(
59 id INT(11) UNSIGNED NOT NULL,
60 marketplace_id SMALLINT(6) UNSIGNED NOT NULL,
61 parent_id INT(11) UNSIGNED NOT NULL DEFAULT 0,
62 title VARCHAR(100) NOT NULL,
63 PRIMARY KEY (id, marketplace_id),
64 INDEX marketplace_id (marketplace_id),
65 INDEX parent_id (parent_id),
66 INDEX title (title)
67)
68ENGINE = INNODB
69AVG_ROW_LENGTH = 45
70CHARACTER SET utf8
71COLLATE utf8_general_ci;
72
73DROP TABLE IF EXISTS m2e_config;
74CREATE TABLE m2e_config(
75 id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
76 `group` VARCHAR(100) DEFAULT NULL,
77 `key` VARCHAR(50) NOT NULL,
78 value VARCHAR(255) NOT NULL,
79 update_time DATETIME DEFAULT NULL,
80 create_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
81 PRIMARY KEY (id),
82 INDEX `group` (`group`),
83 INDEX `key` (`key`)
84)
85ENGINE = INNODB
86AUTO_INCREMENT = 78
87AVG_ROW_LENGTH = 234
88CHARACTER SET utf8
89COLLATE utf8_general_ci;
90
91DROP TABLE IF EXISTS m2e_descriptions_templates;
92CREATE TABLE m2e_descriptions_templates(
93 id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
94 title VARCHAR(255) NOT NULL,
95 content_text TEXT NOT NULL,
96 created_time DATETIME DEFAULT NULL,
97 update_time DATETIME DEFAULT NULL,
98 marketplace FLOAT NOT NULL DEFAULT -1,
99 ebayTemplate VARCHAR(100) NOT NULL,
100 editor_type INT(11) NOT NULL,
101 cut_titles TINYINT(1) NOT NULL,
102 mode INT(11) NOT NULL,
103 use_layout INT(11) NOT NULL,
104 product_name_mode INT(11) NOT NULL,
105 name_template TEXT NOT NULL,
106 attribute_set INT(11) NOT NULL,
107 subtitle_template VARCHAR(300) NOT NULL,
108 product_subtitle_mode INT(11) NOT NULL,
109 hit_counter VARCHAR(15) NOT NULL,
110 PRIMARY KEY (id)
111)
112ENGINE = INNODB
113AUTO_INCREMENT = 2
114AVG_ROW_LENGTH = 16384
115CHARACTER SET utf8
116COLLATE utf8_general_ci;
117
118DROP TABLE IF EXISTS m2e_ebay_items;
119CREATE TABLE m2e_ebay_items(
120 id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
121 item_id BIGINT(22) UNSIGNED NOT NULL,
122 product_id INT(11) UNSIGNED NOT NULL,
123 PRIMARY KEY (id),
124 INDEX item_id (item_id),
125 INDEX product_id (product_id)
126)
127ENGINE = INNODB
128AUTO_INCREMENT = 3
129AVG_ROW_LENGTH = 8192
130CHARACTER SET utf8
131COLLATE utf8_general_ci;
132
133DROP TABLE IF EXISTS m2e_ebay_layouts;
134CREATE TABLE m2e_ebay_layouts(
135 id INT(11) UNSIGNED NOT NULL,
136 marketplace_id INT(11) UNSIGNED NOT NULL,
137 group_id INT(11) UNSIGNED NOT NULL,
138 name VARCHAR(255) NOT NULL,
139 type VARCHAR(100) NOT NULL,
140 imageUrl TEXT NOT NULL,
141 INDEX group_id (group_id),
142 INDEX id (id),
143 INDEX marketplace_id (marketplace_id),
144 INDEX name (name),
145 INDEX type (type)
146)
147ENGINE = INNODB
148AVG_ROW_LENGTH = 147
149CHARACTER SET utf8
150COLLATE utf8_general_ci;
151
152DROP TABLE IF EXISTS m2e_item_specifics;
153CREATE TABLE m2e_item_specifics(
154 id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
155 template_id INT(11) UNSIGNED NOT NULL,
156 name VARCHAR(255) NOT NULL,
157 type TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
158 multi TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
159 `key` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
160 content VARCHAR(255) NOT NULL,
161 PRIMARY KEY (id),
162 INDEX `key` (`key`),
163 INDEX multi (multi),
164 INDEX name (name),
165 INDEX template_id (template_id),
166 INDEX type (type)
167)
168ENGINE = INNODB
169AUTO_INCREMENT = 86
170AVG_ROW_LENGTH = 3276
171CHARACTER SET utf8
172COLLATE utf8_general_ci;
173
174DROP TABLE IF EXISTS m2e_listing_item_shipping;
175CREATE TABLE m2e_listing_item_shipping(
176 id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
177 template_id INT(11) UNSIGNED NOT NULL,
178 cost_mode TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
179 cost_value VARCHAR(255) NOT NULL,
180 shipping_type TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
181 shipping_value VARCHAR(255) NOT NULL,
182 cost_additional_items VARCHAR(50) NOT NULL,
183 priority TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
184 locations TEXT NOT NULL,
185 PRIMARY KEY (id),
186 INDEX cost_mode (cost_mode),
187 INDEX priority (priority),
188 INDEX shipping_type (shipping_type),
189 INDEX template_id (template_id)
190)
191ENGINE = INNODB
192AUTO_INCREMENT = 47
193AVG_ROW_LENGTH = 2730
194CHARACTER SET utf8
195COLLATE utf8_general_ci;
196
197DROP TABLE IF EXISTS m2e_listings;
198CREATE TABLE m2e_listings(
199 id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
200 listing_template_id INT(11) UNSIGNED NOT NULL,
201 strategy_template_id INT(11) UNSIGNED NOT NULL,
202 name VARCHAR(255) NOT NULL,
203 store TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
204 synchronization TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
205 products_total_count INT(11) UNSIGNED NOT NULL DEFAULT 0,
206 products_listed_count INT(11) UNSIGNED NOT NULL DEFAULT 0,
207 products_inactive_count INT(11) UNSIGNED NOT NULL DEFAULT 0,
208 products_sold_count INT(11) UNSIGNED NOT NULL DEFAULT 0,
209 source_products TINYINT(2) UNSIGNED NOT NULL DEFAULT 1,
210 categories_add_action TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
211 categories_delete_action TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
212 strategy_start_type TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
213 strategy_start_through_metric TINYINT(2) UNSIGNED DEFAULT NULL,
214 strategy_start_through_value SMALLINT(6) UNSIGNED DEFAULT NULL,
215 strategy_start_date DATETIME DEFAULT NULL,
216 strategy_stop_type TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
217 strategy_stop_through_metric TINYINT(2) UNSIGNED DEFAULT NULL,
218 strategy_stop_throught_value SMALLINT(6) UNSIGNED DEFAULT NULL,
219 strategy_stop_date DATETIME DEFAULT NULL,
220 strategy_status TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
221 create_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
222 PRIMARY KEY (id),
223 INDEX categories_add_action (categories_add_action),
224 INDEX categories_delete_action (categories_delete_action),
225 INDEX listing_template_id (listing_template_id),
226 INDEX name (name),
227 INDEX src_products (source_products),
228 INDEX store (store),
229 INDEX synchronization (synchronization)
230)
231ENGINE = INNODB
232AUTO_INCREMENT = 436
233AVG_ROW_LENGTH = 106
234CHARACTER SET utf8
235COLLATE utf8_general_ci;
236
237DROP TABLE IF EXISTS m2e_listings_categories;
238CREATE TABLE m2e_listings_categories(
239 id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
240 listing_id INT(11) UNSIGNED NOT NULL,
241 category_id INT(11) UNSIGNED NOT NULL,
242 PRIMARY KEY (id),
243 INDEX category_id (category_id),
244 INDEX listing_id (listing_id)
245)
246ENGINE = INNODB
247AUTO_INCREMENT = 7
248AVG_ROW_LENGTH = 2730
249CHARACTER SET utf8
250COLLATE utf8_general_ci;
251
252DROP TABLE IF EXISTS m2e_listings_logs;
253CREATE TABLE m2e_listings_logs(
254 id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
255 listing_id INT(11) UNSIGNED NOT NULL,
256 product_id INT(11) UNSIGNED DEFAULT NULL,
257 listing_name VARCHAR(255) NOT NULL,
258 product_name VARCHAR(255) DEFAULT NULL,
259 creator VARCHAR(255) DEFAULT NULL,
260 `action` TINYINT(2) UNSIGNED NOT NULL DEFAULT 1,
261 type TINYINT(2) UNSIGNED NOT NULL DEFAULT 1,
262 priority TINYINT(2) UNSIGNED NOT NULL DEFAULT 3,
263 description TEXT DEFAULT NULL,
264 create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
265 PRIMARY KEY (id),
266 INDEX `action` (`action`),
267 INDEX creator (creator),
268 INDEX listing_id (listing_id),
269 INDEX listing_name (listing_name),
270 INDEX priority (priority),
271 INDEX product_id (product_id),
272 INDEX product_name (product_name),
273 INDEX type (type)
274)
275ENGINE = INNODB
276AUTO_INCREMENT = 5540
277AVG_ROW_LENGTH = 468
278CHARACTER SET utf8
279COLLATE utf8_general_ci;
280
281DROP TABLE IF EXISTS m2e_listings_products;
282CREATE TABLE m2e_listings_products(
283 id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
284 listing_id INT(11) UNSIGNED NOT NULL,
285 product_id INT(11) UNSIGNED NOT NULL,
286 ebay_items_id INT(11) UNSIGNED DEFAULT NULL,
287 ebay_start_price DECIMAL(12, 4) UNSIGNED NOT NULL,
288 ebay_reserve_price DECIMAL(12, 4) UNSIGNED DEFAULT NULL,
289 ebay_buyitnow_price DECIMAL(12, 4) UNSIGNED DEFAULT NULL,
290 ebay_qty INT(11) UNSIGNED NOT NULL,
291 ebay_qty_sold INT(11) UNSIGNED DEFAULT NULL,
292 ebay_bids SMALLINT(6) UNSIGNED DEFAULT NULL,
293 status TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
294 qty_sold_synchronize INT(11) UNSIGNED DEFAULT NULL,
295 update_time DATETIME DEFAULT NULL,
296 create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
297 PRIMARY KEY (id),
298 INDEX ebay_bids (ebay_bids),
299 INDEX ebay_buyitnow_price (ebay_buyitnow_price),
300 INDEX ebay_items_id (ebay_items_id),
301 INDEX ebay_qty (ebay_qty),
302 INDEX ebay_qty_sold (ebay_qty_sold),
303 INDEX ebay_reserve_price (ebay_reserve_price),
304 INDEX ebay_start_price (ebay_start_price),
305 INDEX listing_id (listing_id),
306 INDEX product_id (product_id),
307 INDEX qty_sold_synchronize (qty_sold_synchronize),
308 INDEX status (status)
309)
310ENGINE = INNODB
311AUTO_INCREMENT = 10980
312AVG_ROW_LENGTH = 143
313CHARACTER SET utf8
314COLLATE utf8_general_ci;
315
316DROP TABLE IF EXISTS m2e_listings_products_variations;
317CREATE TABLE m2e_listings_products_variations(
318 id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
319 listing_product_id INT(11) UNSIGNED NOT NULL,
320 ebay_price DECIMAL(12, 4) UNSIGNED NOT NULL,
321 ebay_qty INT(11) UNSIGNED NOT NULL,
322 ebay_qty_sold INT(11) UNSIGNED DEFAULT NULL,
323 status TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
324 qty_sold_synchronize INT(11) UNSIGNED DEFAULT NULL,
325 update_time DATETIME DEFAULT NULL,
326 create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
327 PRIMARY KEY (id),
328 INDEX ebay_price (ebay_price),
329 INDEX ebay_qty (ebay_qty),
330 INDEX ebay_qty_sold (ebay_qty_sold),
331 INDEX listing_product_id (listing_product_id),
332 INDEX qty_sold_synchronize (qty_sold_synchronize),
333 INDEX status (status)
334)
335ENGINE = INNODB
336AUTO_INCREMENT = 1
337CHARACTER SET utf8
338COLLATE utf8_general_ci;
339
340DROP TABLE IF EXISTS m2e_listings_products_variations_options;
341CREATE TABLE m2e_listings_products_variations_options(
342 id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
343 listing_product_variation_id INT(11) UNSIGNED NOT NULL,
344 product_id INT(11) UNSIGNED NOT NULL,
345 product_type TINYINT(2) UNSIGNED NOT NULL DEFAULT 1,
346 attribute VARCHAR(255) NOT NULL,
347 `option` VARCHAR(255) NOT NULL,
348 create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
349 PRIMARY KEY (id),
350 INDEX attribute (attribute),
351 INDEX listing_product_variation_id (listing_product_variation_id),
352 INDEX product_id (product_id),
353 INDEX product_type (product_type)
354)
355ENGINE = INNODB
356AUTO_INCREMENT = 1
357CHARACTER SET utf8
358COLLATE utf8_general_ci;
359
360DROP TABLE IF EXISTS m2e_listings_templates;
361CREATE TABLE m2e_listings_templates(
362 id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
363 title VARCHAR(255) NOT NULL,
364 created_at DATETIME NOT NULL,
365 updated_at DATETIME NOT NULL,
366 marketplace VARCHAR(20) NOT NULL,
367 currency VARCHAR(5) NOT NULL,
368 auction_type VARCHAR(200) NOT NULL,
369 category BIGINT(11) NOT NULL,
370 duration INT(11) NOT NULL,
371 duration_attr VARCHAR(100) NOT NULL,
372 adress VARCHAR(300) NOT NULL,
373 postal_code VARCHAR(15) NOT NULL,
374 pp_adress VARCHAR(50) NOT NULL,
375 marketplaceNumeric INT(11) NOT NULL,
376 refund VARCHAR(40) NOT NULL,
377 refund_accepted VARCHAR(40) NOT NULL,
378 refund_within VARCHAR(40) NOT NULL,
379 refund_shippingcost VARCHAR(40) NOT NULL,
380 refund_description VARCHAR(5000) NOT NULL,
381 dispatch_time INT(11) NOT NULL,
382 shop_category_id BIGINT(11) NOT NULL,
383 description TEXT NOT NULL,
384 ebay_description_layout VARCHAR(30) NOT NULL,
385 use_price_from VARCHAR(100) NOT NULL,
386 price_coeficient VARCHAR(50) NOT NULL,
387 use_reserve_from VARCHAR(100) NOT NULL,
388 reserve_coeficient VARCHAR(50) NOT NULL,
389 use_now_from VARCHAR(100) NOT NULL,
390 now_coeficient VARCHAR(50) NOT NULL,
391 name_template TEXT NOT NULL,
392 qty_template VARCHAR(100) NOT NULL,
393 shipping_text VARCHAR(200) NOT NULL,
394 account_id INT(11) NOT NULL,
395 image_type INT(11) NOT NULL,
396 editor_type INT(11) NOT NULL,
397 mode INT(11) NOT NULL,
398 use_layout INT(11) NOT NULL,
399 product_name_mode INT(11) NOT NULL,
400 buynow_price_mode INT(11) NOT NULL,
401 reserve_price_mode INT(11) NOT NULL,
402 start_price_mode INT(11) NOT NULL,
403 item_qty_mode INT(11) NOT NULL,
404 select_attributes_for_qty VARCHAR(500) NOT NULL,
405 sku_settings INT(11) NOT NULL,
406 international_shipping VARCHAR(50) NOT NULL,
407 international_shipping_cost VARCHAR(50) NOT NULL,
408 international_dispatch_time INT(11) NOT NULL,
409 use_local_shipping INT(11) NOT NULL,
410 use_international_shipping INT(11) NOT NULL,
411 ship_to_location TEXT NOT NULL,
412 `condition` VARCHAR(40) NOT NULL,
413 attribute_set INT(11) NOT NULL,
414 second_category BIGINT(11) NOT NULL,
415 main_category_attribute VARCHAR(200) NOT NULL,
416 secondary_category_attribute VARCHAR(200) NOT NULL,
417 category_selected_type INT(11) NOT NULL,
418 store_category_attribute VARCHAR(200) NOT NULL,
419 storecategory_selected_type INT(11) NOT NULL,
420 gallery_picture INT(11) NOT NULL,
421 listing_private INT(11) NOT NULL,
422 subtitle_template VARCHAR(300) NOT NULL,
423 product_subtitle_mode INT(11) NOT NULL,
424 description_template_id INT(11) NOT NULL,
425 modify_template INT(11) NOT NULL,
426 modify_pricetemplate INT(11) NOT NULL,
427 price_template_id INT(11) NOT NULL,
428 enhancement VARCHAR(300) NOT NULL,
429 product_image_attribute VARCHAR(300) NOT NULL,
430 country VARCHAR(50) NOT NULL,
431 product_picture INT(11) NOT NULL,
432 action_type_attribute VARCHAR(200) NOT NULL,
433 listingType INT(11) NOT NULL,
434 use_multivariation INT(11) NOT NULL,
435 variation_sku INT(11) NOT NULL,
436 variation_price_mode INT(11) NOT NULL,
437 variation_price_coeficient VARCHAR(20) NOT NULL,
438 variation_price_from VARCHAR(200) NOT NULL,
439 variation_qty_mode INT(11) NOT NULL,
440 variation_qty_template VARCHAR(200) NOT NULL,
441 attributes_for_variation_qty VARCHAR(200) NOT NULL,
442 configurable_attribute VARCHAR(300) NOT NULL,
443 gallery_images INT(11) NOT NULL,
444 use_int_calculated INT(11) NOT NULL,
445 use_domestic_calculated INT(11) NOT NULL,
446 use_multivariation_custom INT(11) NOT NULL,
447 use_multivariation_bundle INT(11) NOT NULL,
448 storecategory_selected_type2 INT(11) NOT NULL,
449 store_category_attribute2 VARCHAR(100) NOT NULL,
450 shop_category_id2 VARCHAR(20) NOT NULL,
451 item_condition_attr VARCHAR(200) NOT NULL,
452 local_addit_shipping TINYINT(1) NOT NULL DEFAULT 0,
453 int_addit_shipping TINYINT(1) NOT NULL DEFAULT 0,
454 get_it_fast TINYINT(1) NOT NULL DEFAULT 0,
455 measurement_system TINYINT(1) NOT NULL DEFAULT 1 COMMENT '1 - english, 2 - metric',
456 local_shipping_mode TINYINT(1) NOT NULL COMMENT '0 - flat, 1 - calculated',
457 international_shipping_mode TINYINT(1) NOT NULL,
458 item_specifics_attrset INT(11) NOT NULL,
459 PRIMARY KEY (id),
460 INDEX title (title)
461)
462ENGINE = INNODB
463AUTO_INCREMENT = 3
464AVG_ROW_LENGTH = 8192
465CHARACTER SET utf8
466COLLATE utf8_general_ci;
467
468DROP TABLE IF EXISTS m2e_marketplace;
469CREATE TABLE m2e_marketplace(
470 id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
471 site_id INT(11) UNSIGNED NOT NULL,
472 site_name VARCHAR(45) NOT NULL,
473 frontend_name VARCHAR(45) NOT NULL,
474 site_url VARCHAR(400) NOT NULL,
475 synchronize TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
476 PRIMARY KEY (id),
477 INDEX site_id (site_id),
478 INDEX synchronize (synchronize)
479)
480ENGINE = INNODB
481AUTO_INCREMENT = 23
482AVG_ROW_LENGTH = 744
483CHARACTER SET utf8
484COLLATE utf8_general_ci;
485
486DROP TABLE IF EXISTS m2e_payments_to_listings;
487CREATE TABLE m2e_payments_to_listings(
488 id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
489 listing_id INT(11) UNSIGNED NOT NULL,
490 payment_id VARCHAR(100) NOT NULL,
491 PRIMARY KEY (id),
492 INDEX payment_id (payment_id),
493 INDEX project_id (listing_id)
494)
495ENGINE = INNODB
496AUTO_INCREMENT = 20
497AVG_ROW_LENGTH = 8192
498CHARACTER SET utf8
499COLLATE utf8_general_ci;
500
501DROP TABLE IF EXISTS m2e_prices_templates;
502CREATE TABLE m2e_prices_templates(
503 id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
504 title VARCHAR(100) NOT NULL,
505 use_reserve_from VARCHAR(100) NOT NULL,
506 reserve_coeficient FLOAT UNSIGNED NOT NULL,
507 use_price_from VARCHAR(100) NOT NULL,
508 price_coeficient FLOAT UNSIGNED NOT NULL,
509 use_now_from VARCHAR(100) NOT NULL,
510 now_coeficient FLOAT UNSIGNED NOT NULL,
511 buynow_price_mode INT(11) UNSIGNED NOT NULL,
512 reserve_price_mode INT(11) UNSIGNED NOT NULL,
513 start_price_mode INT(11) UNSIGNED NOT NULL,
514 currency VARCHAR(100) NOT NULL,
515 attribute_set INT(11) UNSIGNED NOT NULL,
516 use_tax_table TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
517 use_immediate_payment TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
518 use_best_offer TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
519 best_b_attribute VARCHAR(100) NOT NULL,
520 accept_offer_mode TINYINT(1) UNSIGNED NOT NULL,
521 best_accp_input VARCHAR(100) NOT NULL,
522 best_acc_attribute VARCHAR(100) NOT NULL,
523 reject_offer_mode TINYINT(1) UNSIGNED NOT NULL,
524 best_regp_input VARCHAR(100) NOT NULL,
525 best_reg_attribute VARCHAR(100) NOT NULL,
526 created_at DATETIME NOT NULL,
527 updated_at DATETIME NOT NULL,
528 PRIMARY KEY (id),
529 INDEX attribute_set (attribute_set),
530 INDEX buynow_price_mode (buynow_price_mode),
531 INDEX reserve_price_mode (reserve_price_mode),
532 INDEX start_price_mode (start_price_mode),
533 INDEX title (title)
534)
535ENGINE = INNODB
536AUTO_INCREMENT = 2
537AVG_ROW_LENGTH = 16384
538CHARACTER SET utf8
539COLLATE utf8_general_ci;
540
541DROP TABLE IF EXISTS m2e_products_changes;
542CREATE TABLE m2e_products_changes(
543 id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
544 product_id INT(11) UNSIGNED NOT NULL,
545 `action` VARCHAR(10) NOT NULL,
546 attribute VARCHAR(20) DEFAULT NULL,
547 value_old VARCHAR(255) DEFAULT NULL,
548 value_new VARCHAR(255) DEFAULT NULL,
549 count_changes TINYINT(4) UNSIGNED DEFAULT NULL,
550 update_time DATETIME DEFAULT NULL,
551 create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
552 PRIMARY KEY (id),
553 INDEX `action` (`action`),
554 INDEX attribute (attribute),
555 INDEX count_changes (count_changes),
556 INDEX product_id (product_id)
557)
558ENGINE = INNODB
559AUTO_INCREMENT = 1
560CHARACTER SET utf8
561COLLATE utf8_general_ci;
562
563DROP TABLE IF EXISTS m2e_strategies_templates;
564CREATE TABLE m2e_strategies_templates(
565 id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
566 title VARCHAR(255) NOT NULL,
567 start_auto_list TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
568 stop_auto_stop TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
569 stop_item_out_off_stock TINYINT(2) UNSIGNED DEFAULT NULL,
570 stop_item_qty TINYINT(2) UNSIGNED DEFAULT NULL,
571 stop_item_qty_value INT(11) DEFAULT NULL,
572 stop_item_qty_value_max INT(11) DEFAULT NULL,
573 create_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
574 PRIMARY KEY (id),
575 INDEX name (title)
576)
577ENGINE = INNODB
578AUTO_INCREMENT = 2
579AVG_ROW_LENGTH = 16384
580CHARACTER SET utf8
581COLLATE utf8_general_ci;
582
583DROP TABLE IF EXISTS m2e_synchronizations_logs;
584CREATE TABLE m2e_synchronizations_logs(
585 id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
586 start_time DATETIME NOT NULL,
587 end_time DATETIME NOT NULL,
588 creator VARCHAR(255) DEFAULT NULL,
589 `action` TINYINT(2) UNSIGNED NOT NULL DEFAULT 1,
590 type TINYINT(2) UNSIGNED NOT NULL DEFAULT 1,
591 priority TINYINT(2) UNSIGNED NOT NULL DEFAULT 3,
592 description TEXT DEFAULT NULL,
593 create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
594 PRIMARY KEY (id),
595 INDEX `action` (`action`),
596 INDEX creator (creator),
597 INDEX end_time (end_time),
598 INDEX priority (priority),
599 INDEX start_time (start_time),
600 INDEX type (type)
601)
602ENGINE = INNODB
603AUTO_INCREMENT = 1
604CHARACTER SET utf8
605COLLATE utf8_general_ci;
606
607DROP TABLE IF EXISTS m2e_transactions_events;
608CREATE TABLE m2e_transactions_events(
609 id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
610 account_id INT(11) UNSIGNED NOT NULL,
611 account_mode TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
612 transaction_id BIGINT(20) UNSIGNED NOT NULL,
613 order_id INT(11) UNSIGNED DEFAULT NULL,
614 product_id INT(11) UNSIGNED NOT NULL,
615 currency_id VARCHAR(20) DEFAULT NULL,
616 qty_sold INT(11) UNSIGNED NOT NULL,
617 price FLOAT UNSIGNED NOT NULL,
618 update_time DATETIME NOT NULL,
619 shipping_title VARCHAR(100) DEFAULT NULL,
620 shipping_cost FLOAT DEFAULT NULL,
621 shipping_address TEXT DEFAULT NULL,
622 customer_name VARCHAR(255) NOT NULL,
623 checkout_status SMALLINT(6) NOT NULL,
624 payment_status SMALLINT(6) NOT NULL,
625 payment_error VARCHAR(255) DEFAULT NULL,
626 shipping_status SMALLINT(6) NOT NULL,
627 ebay_item_id BIGINT(20) NOT NULL,
628 ebay_item_title VARCHAR(255) NOT NULL,
629 variations TEXT DEFAULT NULL,
630 store_id INT(11) NOT NULL DEFAULT 0,
631 shipping_currency VARCHAR(20) DEFAULT NULL,
632 error_logs TEXT DEFAULT NULL,
633 payment_used VARCHAR(255) DEFAULT NULL,
634 PRIMARY KEY (id),
635 INDEX account_id (account_id),
636 INDEX account_mode (account_mode),
637 INDEX order_id (order_id),
638 INDEX product_id (product_id),
639 INDEX transaction_id (transaction_id)
640)
641ENGINE = INNODB
642AUTO_INCREMENT = 1
643CHARACTER SET utf8
644COLLATE utf8_general_ci;