· 7 years ago · Nov 15, 2018, 12:56 PM
1CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_categories` (
2`category_id` int(11) NOT NULL auto_increment,
3`category_image` varchar(255),
4`category_parent_id` int(11) NOT NULL,
5`category_publish` tinyint(1) unsigned NOT NULL default '1',
6`category_template` varchar(64),
7`ordering` int(3) NOT NULL,
8`category_add_date` datetime,
9`products_page` int(8) NOT NULL default '12',
10`products_row` int(3) NOT NULL default '3',
11`access` int(3) NOT NULL default '1',
12PRIMARY KEY (`category_id`),
13KEY `sort_add_date` (`category_add_date`)
14) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
15
16CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_countries` (
17`country_id` int(11) NOT NULL auto_increment,
18`country_publish` tinyint(4) NOT NULL,
19`ordering` smallint(6) NOT NULL,
20`country_code` varchar(5) NOT NULL,
21`country_code_2` varchar(5) NOT NULL,
22`name_en-GB` varchar(255) NOT NULL,
23`name_de-DE` varchar(255) NOT NULL,
24PRIMARY KEY (`country_id`)
25) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
26
27CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_currencies` (
28`currency_id` int(11) NOT NULL auto_increment,
29`currency_name` varchar(64) NOT NULL,
30`currency_code` varchar(20) NOT NULL,
31`currency_code_iso` VARCHAR(3) NOT NULL,
32`currency_code_num` VARCHAR(3) NOT NULL,
33`currency_ordering` int(11) NOT NULL,
34`currency_value` DECIMAL(14,6) NOT NULL,
35`currency_publish` tinyint(1) NOT NULL,
36PRIMARY KEY (`currency_id`)
37) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
38
39CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_delivery_times` (
40`id` int(11) NOT NULL auto_increment,
41`days` DECIMAL(8,2) NOT NULL,
42PRIMARY KEY (`id`)
43) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
44
45CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_products`(
46`product_id` int(11) NOT NULL auto_increment,
47`parent_id` int(11) NOT NULL,
48`product_ean` varchar(32) NOT NULL,
49`manufacturer_code` varchar(32) NOT NULL,
50`product_quantity` DECIMAL(12,2) NOT NULL,
51`unlimited` TINYINT(1) NOT NULL,
52`product_availability` varchar(1) NOT NULL,
53`product_date_added` datetime NOT NULL default '0000-00-00 00:00:00',
54`date_modify` datetime NOT NULL default '0000-00-00 00:00:00',
55`product_publish` tinyint(1) NOT NULL,
56`product_tax_id` tinyint(3) NOT NULL,
57`currency_id` int(4) NOT NULL,
58`product_template` varchar(64) NOT NULL default "default",
59`product_url` varchar(128) NOT NULL,
60`product_old_price` DECIMAL(14,4) NOT NULL,
61`product_buy_price` DECIMAL(14,4) NOT NULL,
62`product_price` DECIMAL(18,6) NOT NULL,
63`min_price` DECIMAL(18,6) NOT NULL,
64`different_prices` TINYINT(1) NOT NULL,
65`product_weight` DECIMAL(14,4) NOT NULL,
66`image` varchar(255) NOT NULL,
67`product_manufacturer_id` int(11) NOT NULL,
68`product_is_add_price` TINYINT(1) NOT NULL,
69`add_price_unit_id` int(3) NOT NULL,
70`average_rating` float(4,2) NOT NULL,
71`reviews_count` int(11) NOT NULL,
72`delivery_times_id` int(4) NOT NULL,
73`hits` int(11) NOT NULL,
74`weight_volume_units` DECIMAL(14,4) NOT NULL,
75`basic_price_unit_id` int(3) NOT NULL,
76`label_id` int(11) NOT NULL,
77`vendor_id` int(11) NOT NULL,
78`access` int(3) NOT NULL default '1',
79PRIMARY KEY (`product_id`),
80KEY `product_manufacturer_id` (`product_manufacturer_id`)
81) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
82
83CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_products_images` (
84`image_id` int(11) NOT NULL auto_increment,
85`product_id` int(11) NOT NULL,
86`image_name` varchar(255) NOT NULL,
87`name` varchar(255) NOT NULL,
88`ordering` TINYINT(4) NOT NULL,
89PRIMARY KEY (`image_id`)
90) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
91
92CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_products_prices` (
93`price_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
94`product_id` INT NOT NULL,
95`discount` DECIMAL(16,6) NOT NULL,
96`product_quantity_start` INT NOT NULL,
97`product_quantity_finish` INT NOT NULL
98) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
99
100CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_products_relations` (
101`id` int(11) NOT NULL auto_increment PRIMARY KEY,
102`product_id` int(11) NOT NULL,
103`product_related_id` int(11) NOT NULL
104) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
105
106CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_products_to_categories` (
107`product_id` int(11) NOT NULL,
108`category_id` int(11) NOT NULL,
109`product_ordering` int(11) NOT NULL,
110PRIMARY KEY (`product_id`,`category_id`),
111KEY `category_id` (`category_id`),
112KEY `product_id` (`product_id`)
113) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
114
115CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_products_videos` (
116`video_id` int(11) NOT NULL auto_increment,
117`product_id` int(11) NOT NULL,
118`video_name` varchar(255) NOT NULL,
119`video_code` text NOT NULL,
120`video_preview` VARCHAR( 255 ) NOT NULL,
121PRIMARY KEY (`video_id`)
122) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
123
124CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_products_reviews` (
125`review_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
126`product_id` INT NOT NULL,
127`user_id` INT NOT NULL,
128`user_name` VARCHAR( 255 ) NOT NULL,
129`user_email` VARCHAR( 255 ) NOT NULL,
130`time` DATETIME NOT NULL,
131`review` TEXT NOT NULL,
132`mark` INT NOT NULL,
133`publish` TINYINT(1) NOT NULL,
134`ip` VARCHAR(20) NOT NULL
135) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
136
137CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_products_files` (
138`id` int(11) NOT NULL auto_increment,
139`product_id` int(11) NOT NULL,
140`demo` varchar(255) NOT NULL,
141`demo_descr` varchar(255) NOT NULL,
142`file` varchar(255) NOT NULL,
143`file_descr` varchar(255) NOT NULL,
144`ordering` int(11) NOT NULL,
145PRIMARY KEY (`id`),
146KEY `product_id` (`product_id`)
147) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
148
149CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_taxes` (
150`tax_id` int(11) NOT NULL auto_increment,
151`tax_name` varchar(50) NOT NULL,
152`tax_value` DECIMAL(12,2) NOT NULL,
153PRIMARY KEY (`tax_id`)
154) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
155
156CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_config` (
157`id` int(11) NOT NULL auto_increment,
158`count_products_to_page` int(4) NOT NULL,
159`count_products_to_row` int(2) NOT NULL,
160`count_category_to_row` int(2) NOT NULL,
161`image_category_width` int(4) NOT NULL,
162`image_category_height` int(4) NOT NULL,
163`image_product_width` int(4) NOT NULL,
164`image_product_height` int(4) NOT NULL,
165`image_product_full_width` int(4) NOT NULL,
166`image_product_full_height` int(4) NOT NULL,
167`image_product_original_width` int(4) NOT NULL,
168`image_product_original_height` int(4) NOT NULL,
169`video_product_width` int(4) NOT NULL,
170`video_product_height` int(4) NOT NULL,
171`adminLanguage` varchar(8) NOT NULL,
172`defaultLanguage` varchar(8) NOT NULL,
173`mainCurrency` int(4) NOT NULL,
174`decimal_count` TINYINT( 1 ) NOT NULL ,
175`decimal_symbol` VARCHAR( 5 ) NOT NULL ,
176`thousand_separator` VARCHAR( 5 ) NOT NULL ,
177`currency_format` TINYINT( 1 ) NOT NULL,
178`use_rabatt_code` TINYINT( 1 ) NOT NULL,
179`enable_wishlist` TINYINT( 1 ) NOT NULL,
180`default_status_order` TINYINT( 1 ) NOT NULL,
181`store_address_format` VARCHAR(32) NOT NULL,
182`store_date_format` VARCHAR(32) NOT NULL,
183`contact_email` VARCHAR(128) NOT NULL,
184`allow_reviews_prod` TINYINT( 1 ) NOT NULL ,
185`allow_reviews_only_registered` TINYINT( 1 ) NOT NULL,
186`allow_reviews_manuf` TINYINT( 1 ) NOT NULL,
187`max_mark` INT NOT NULL,
188`summ_null_shipping` DECIMAL(12,2) NOT NULL,
189`without_shipping` TINYINT( 1 ) NOT NULL,
190`without_payment` TINYINT( 1 ) NOT NULL,
191`pdf_parameters` VARCHAR(32) NOT NULL,
192`next_order_number` int(11) NOT NULL default '1',
193`shop_user_guest` TINYINT( 1 ) NOT NULL,
194`hide_product_not_avaible_stock` TINYINT( 1 ) NOT NULL,
195`show_buy_in_category` TINYINT( 1 ) NOT NULL,
196`user_as_catalog` TINYINT( 1 ) NOT NULL,
197`show_tax_in_product` TINYINT( 1 ) NOT NULL,
198`show_tax_product_in_cart` TINYINT( 1 ) NOT NULL,
199`show_plus_shipping_in_product` TINYINT( 1 ) NOT NULL,
200`hide_buy_not_avaible_stock` TINYINT( 1 ) NOT NULL,
201`show_sort_product` TINYINT( 1 ) NOT NULL,
202`show_count_select_products` TINYINT( 1 ) NOT NULL,
203`order_send_pdf_client` TINYINT( 1 ) NOT NULL,
204`order_send_pdf_admin` TINYINT( 1 ) NOT NULL,
205`show_delivery_time` TINYINT( 1 ) NOT NULL,
206`securitykey` VARCHAR( 128 ) NOT NULL,
207`demo_type` TINYINT( 1 ) NOT NULL,
208`product_show_manufacturer_logo` TINYINT( 1 ) NOT NULL,
209`product_show_manufacturer` TINYINT( 1 ) NOT NULL,
210`product_show_weight` TINYINT( 1 ) NOT NULL,
211`max_count_order_one_product` int(11) NOT NULL,
212`min_count_order_one_product` int(11) NOT NULL,
213`min_price_order` int(11) NOT NULL,
214`max_price_order` int(11) NOT NULL,
215`hide_tax` TINYINT(1) NOT NULL,
216`licensekod` text NOT NULL,
217`product_attribut_first_value_empty` TINYINT(1) NOT NULL,
218`show_hits` TINYINT(1) NOT NULL,
219`show_registerform_in_logintemplate` TINYINT(1) NOT NULL,
220`admin_show_product_basic_price` TINYINT(1) NOT NULL,
221`admin_show_attributes` TINYINT(1) NOT NULL,
222`admin_show_delivery_time` TINYINT(1) NOT NULL,
223`admin_show_languages` TINYINT(1) NOT NULL,
224`use_different_templates_cat_prod` TINYINT(1) NOT NULL,
225`admin_show_product_video` TINYINT(1) NOT NULL,
226`admin_show_product_related` TINYINT(1) NOT NULL,
227`admin_show_product_files` TINYINT(1) NOT NULL,
228`admin_show_product_bay_price` TINYINT(1) NOT NULL,
229`admin_show_product_labels` TINYINT(1) NOT NULL,
230`sorting_country_in_alphabet` TINYINT(1) NOT NULL,
231`hide_text_product_not_available` TINYINT(1) NOT NULL,
232`show_weight_order` TINYINT(1) NOT NULL,
233`discount_use_full_sum` TINYINT(1) NOT NULL,
234`show_cart_all_step_checkout` TINYINT(1) NOT NULL,
235`use_plugin_content` TINYINT(1) NOT NULL,
236`display_price_admin` TINYINT(1) NOT NULL,
237`display_price_front` TINYINT(1) NOT NULL,
238`product_list_show_weight` TINYINT(1) NOT NULL,
239`product_list_show_manufacturer` TINYINT(1) NOT NULL,
240`use_extend_tax_rule` TINYINT(4) NOT NULL,
241`use_extend_display_price_rule` TINYINT(4) NOT NULL,
242`fields_register` text NOT NULL,
243`template` VARCHAR(128) NOT NULL,
244`show_product_code` TINYINT(1) NOT NULL,
245`show_product_code_in_cart` TINYINT(1) NOT NULL,
246`savelog` TINYINT(1) NOT NULL,
247`savelogpaymentdata` TINYINT(1) NOT NULL,
248`product_list_show_min_price` TINYINT(1) NOT NULL,
249`product_count_related_in_row` TINYINT(4) NOT NULL,
250`category_sorting` TINYINT(1) NOT NULL default '1',
251`product_sorting` TINYINT(1) NOT NULL default '1',
252`product_sorting_direction` TINYINT(1) NOT NULL,
253`show_product_list_filters` TINYINT(1) NOT NULL,
254`admin_show_product_extra_field` TINYINT(1) NOT NULL,
255`product_list_display_extra_fields` TEXT NOT NULL,
256`filter_display_extra_fields` TEXT NOT NULL,
257`product_hide_extra_fields` TEXT NOT NULL,
258`cart_display_extra_fields` TEXT NOT NULL,
259`default_country` int(11) NOT NULL,
260`show_return_policy_in_email_order` TINYINT(1) NOT NULL,
261`client_allow_cancel_order` TINYINT(1) NOT NULL,
262`admin_show_vendors` TINYINT(1) NOT NULL,
263`vendor_order_message_type` TINYINT(1) NOT NULL,
264`admin_not_send_email_order_vendor_order` TINYINT(1) NOT NULL,
265`not_redirect_in_cart_after_buy` TINYINT(1) NOT NULL,
266`product_show_vendor` TINYINT(1) NOT NULL,
267`product_show_vendor_detail` TINYINT(1) NOT NULL,
268`product_list_show_vendor` TINYINT(1) NOT NULL,
269`admin_show_freeattributes` TINYINT(1) NOT NULL,
270`product_show_button_back` TINYINT(1) NOT NULL,
271`calcule_tax_after_discount` TINYINT(1) NOT NULL,
272`product_list_show_product_code` TINYINT(1) NOT NULL,
273`radio_attr_value_vertical` TINYINT(1) NOT NULL,
274`attr_display_addprice` TINYINT(1) NOT NULL,
275`use_ssl` TINYINT(1) NOT NULL,
276`product_list_show_price_description` TINYINT(1) NOT NULL,
277`display_button_print` TINYINT(1) NOT NULL,
278`hide_shipping_step` TINYINT(1) NOT NULL,
279`hide_payment_step` TINYINT(1) NOT NULL,
280`image_resize_type` TINYINT(1) NOT NULL,
281`use_extend_attribute_data` TINYINT(1) NOT NULL,
282`product_list_show_price_default` TINYINT(1) NOT NULL,
283`product_list_show_qty_stock` TINYINT(1) NOT NULL,
284`product_show_qty_stock` TINYINT(1) NOT NULL,
285`displayprice` TINYINT(1) NOT NULL,
286`use_decimal_qty` TINYINT(1) NOT NULL,
287`ext_tax_rule_for` TINYINT(1) NOT NULL,
288`display_reviews_without_confirm` TINYINT(1) NOT NULL,
289`manufacturer_sorting` TINYINT(1) NOT NULL,
290`admin_show_units` TINYINT(1) NOT NULL,
291`main_unit_weight` TINYINT(3) NOT NULL,
292`create_alias_product_category_auto` TINYINT(1) NOT NULL,
293`delivery_order_depends_delivery_product` TINYINT(1) NOT NULL,
294`show_delivery_time_step5` TINYINT(1) NOT NULL,
295`other_config` TEXT NOT NULL,
296`shop_mode` TINYINT(1) NOT NULL,
297PRIMARY KEY (`id`)
298) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
299
300CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_manufacturers` (
301`manufacturer_id` INT NOT NULL auto_increment,
302`manufacturer_url` VARCHAR( 255 ) NOT NULL ,
303`manufacturer_logo` VARCHAR( 255 ) NOT NULL ,
304`manufacturer_publish` TINYINT(1) NOT NULL,
305`products_page` int(11) NOT NULL,
306`products_row` int(11) NOT NULL,
307`ordering` int(6) NOT NULL,
308 PRIMARY KEY (`manufacturer_id`)
309) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
310
311CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_coupons` (
312`coupon_id` int(11) NOT NULL auto_increment,
313`coupon_type` tinyint(4) NOT NULL COMMENT 'value_or_percent',
314`coupon_code` varchar(100) NOT NULL,
315`coupon_value` DECIMAL(12,2) NOT NULL default '0.00',
316`tax_id` int(11) NOT NULL,
317`used` int(11) NOT NULL,
318`for_user_id` int(11) NOT NULL,
319`coupon_start_date` date NOT NULL default '0000-00-00',
320`coupon_expire_date` date NOT NULL default '0000-00-00',
321`finished_after_used` int(11) NOT NULL,
322`coupon_publish` tinyint(4) NOT NULL,
323PRIMARY KEY (`coupon_id`)
324) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
325
326CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_users` (
327`user_id` INT NOT NULL ,
328`usergroup_id` INT NOT NULL,
329`payment_id` INT NOT NULL,
330`shipping_id` INT NOT NULL,
331`u_name` VARCHAR(150) NOT NULL,
332`number` VARCHAR(32) NOT NULL,
333`title` tinyint(1) NOT NULL,
334`f_name` VARCHAR( 255 ) NOT NULL,
335`l_name` VARCHAR( 255 ) NOT NULL,
336`m_name` VARCHAR( 255 ) NOT NULL,
337`firma_name` VARCHAR( 100 ) NOT NULL,
338`client_type` tinyint(1) NOT NULL,
339`firma_code` VARCHAR( 100 ) NOT NULL,
340`tax_number` VARCHAR( 100 ) NOT NULL,
341`email` VARCHAR( 255 ) NOT NULL,
342`birthday` DATE NOT NULL,
343`street` VARCHAR( 255 ) NOT NULL,
344`street_nr` VARCHAR( 16 ) NOT NULL,
345`home` VARCHAR( 20 ) NOT NULL,
346`apartment` VARCHAR( 20 ) NOT NULL,
347`zip` VARCHAR( 20 ) NOT NULL,
348`city` VARCHAR( 100 ) NOT NULL,
349`state` VARCHAR( 100 ) NOT NULL,
350`country` int(11) default NULL,
351`phone` VARCHAR(24) NOT NULL,
352`mobil_phone` VARCHAR(24) NOT NULL,
353`fax` VARCHAR(24) NOT NULL,
354`ext_field_1` VARCHAR(255) NOT NULL,
355`ext_field_2` VARCHAR(255) NOT NULL,
356`ext_field_3` VARCHAR(255) NOT NULL,
357`delivery_adress` TINYINT ( 1 ) NOT NULL,
358`d_title` tinyint(1) NOT NULL,
359`d_f_name` VARCHAR(255) NOT NULL,
360`d_l_name` VARCHAR(255) NOT NULL,
361`d_m_name` VARCHAR(255) NOT NULL,
362`d_firma_name` VARCHAR(100) NOT NULL,
363`d_email` VARCHAR(255) NOT NULL,
364`d_birthday` DATE NOT NULL,
365`d_street` VARCHAR(255) NOT NULL,
366`d_street_nr` VARCHAR(16) NOT NULL,
367`d_home` VARCHAR(20) NOT NULL,
368`d_apartment` VARCHAR(20) NOT NULL,
369`d_zip` VARCHAR(20) NOT NULL,
370`d_city` VARCHAR(100) NOT NULL,
371`d_state` VARCHAR(100) NOT NULL,
372`d_country` int(11) NOT NULL,
373`d_phone` VARCHAR(24) NOT NULL,
374`d_mobil_phone` VARCHAR(24) NOT NULL,
375`d_fax` VARCHAR(24) NOT NULL,
376`d_ext_field_1` VARCHAR(255) NOT NULL,
377`d_ext_field_2` VARCHAR(255) NOT NULL,
378`d_ext_field_3` VARCHAR(255) NOT NULL,
379`lang` VARCHAR(5) NOT NULL,
380UNIQUE KEY `user_id` (`user_id`),
381KEY `u_name` (`u_name`),
382KEY `usergroup_id` (`usergroup_id`)
383) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
384
385CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_payment_method` (
386`payment_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
387`payment_code` VARCHAR(32) NOT NULL ,
388`payment_class` VARCHAR(100) NOT NULL,
389`scriptname` VARCHAR(100) NOT NULL,
390`payment_publish` TINYINT(1) NOT NULL,
391`payment_ordering` INT NOT NULL,
392`payment_params` TEXT NOT NULL,
393`payment_type` TINYINT(4) NOT NULL,
394`price` DECIMAL(12,2) NOT NULL,
395`price_type` TINYINT(1) NOT NULL,
396`tax_id` int(11) NOT NULL,
397`image` VARCHAR(255) NOT NULL,
398`show_descr_in_email` TINYINT(1) NOT NULL,
399`show_bank_in_order` TINYINT(1) NOT NULL DEFAULT '1',
400`order_description` TEXT NOT NULL,
401`name_en-GB` VARCHAR(100) NOT NULL,
402`description_en-GB` TEXT NOT NULL,
403`name_de-DE` VARCHAR(100) NOT NULL,
404`description_de-DE` TEXT NOT NULL
405) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
406
407CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_usergroups` (
408`usergroup_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
409`usergroup_name` VARCHAR( 64 ) NOT NULL ,
410`usergroup_discount` DECIMAL(12,2) NOT NULL,
411`usergroup_description` TEXT NOT NULL ,
412`usergroup_is_default` TINYINT(1) NOT NULL,
413`name_en-GB` varchar(255) NOT NULL,
414`name_de-DE` varchar(255) NOT NULL
415) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
416
417CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_shipping_method` (
418`shipping_id` int(11) NOT NULL auto_increment,
419`alias` varchar(100) NOT NULL,
420`name_en-GB` varchar(100) NOT NULL,
421`description_en-GB` text NOT NULL,
422`name_de-DE` varchar(100) NOT NULL,
423`description_de-DE` text NOT NULL,
424`published` tinyint(1) NOT NULL,
425`payments` varchar(255) NOT NULL,
426`image` VARCHAR(255) NOT NULL,
427`ordering` int(6) NOT NULL,
428`params` LONGTEXT NOT NULL,
429PRIMARY KEY (`shipping_id`)
430) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
431
432CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_shipping_ext_calc`(
433`id` int(11) NOT NULL auto_increment,
434`name` varchar(100) NOT NULL,
435`alias` varchar(100) NOT NULL,
436`description` text NOT NULL,
437`params` LONGTEXT NOT NULL,
438`shipping_method` text NOT NULL,
439`published` tinyint(1) NOT NULL,
440`ordering` int(6) NOT NULL,
441PRIMARY KEY (`id`)
442) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
443
444CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_shipping_method_price` (
445`sh_pr_method_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
446`shipping_method_id` INT NOT NULL,
447`shipping_tax_id` int(11) NOT NULL,
448`shipping_stand_price` DECIMAL(14,4) NOT NULL,
449`package_tax_id` int(11) NOT NULL,
450`package_stand_price` DECIMAL(14,4) NOT NULL,
451`delivery_times_id` int(11) NOT NULL,
452`params` LONGTEXT NOT NULL
453) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
454
455CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_shipping_method_price_weight` (
456`sh_pr_weight_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
457`sh_pr_method_id` INT NOT NULL ,
458`shipping_price` DECIMAL(12,2) NOT NULL ,
459`shipping_weight_from` DECIMAL(14,4) NOT NULL ,
460`shipping_weight_to` DECIMAL(14,4) NOT NULL ,
461`shipping_package_price` DECIMAL(14,4) NOT NULL ,
462INDEX ( `sh_pr_method_id` )
463) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
464
465CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_shipping_method_price_countries` (
466`sh_method_country_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
467`country_id` INT NOT NULL ,
468`sh_pr_method_id` INT NOT NULL ,
469INDEX ( `country_id`) , INDEX( `sh_pr_method_id` )
470) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
471
472CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_order_history` (
473`order_history_id` int(11) NOT NULL auto_increment,
474`order_id` int(11) NOT NULL,
475`order_status_id` tinyint(1) NOT NULL,
476`status_date_added` datetime NOT NULL,
477`customer_notify` int(1),
478`comments` text,
479PRIMARY KEY (`order_history_id`)
480) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
481
482CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_order_item`(
483`order_item_id` int(11) NOT NULL auto_increment,
484`order_id` int(11) NOT NULL,
485`product_id` int(11) NOT NULL,
486`category_id` int(11) NOT NULL,
487`product_ean` int(11) NOT NULL,
488`manufacturer_code` varchar(32) NOT NULL,
489`product_name` varchar(255) NOT NULL,
490`product_quantity` DECIMAL(12,2) NOT NULL,
491`product_item_price` DECIMAL(14,2) NOT NULL,
492`product_tax` DECIMAL(14,2) NOT NULL,
493`product_attributes` text NOT NULL,
494`product_freeattributes` text NOT NULL,
495`attributes` text NOT NULL,
496`freeattributes` text NOT NULL,
497`extra_fields` TEXT NOT NULL,
498`files` text NOT NULL,
499`weight` DECIMAL(14,2) NOT NULL,
500`thumb_image` varchar(255) NOT NULL,
501`manufacturer` varchar(255) NOT NULL,
502`delivery_times_id` int(4) NOT NULL,
503`vendor_id` int(11) NOT NULL,
504`basicprice` DECIMAL(12,2) NOT NULL,
505`basicpriceunit` varchar(255) NOT NULL,
506`params` text NOT NULL,
507PRIMARY KEY (`order_item_id`)
508) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
509
510CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_order_status` (
511`status_id` int(11) NOT NULL auto_increment,
512`status_code` char(1) NOT NULL,
513`name_en-GB` varchar(100) NOT NULL,
514`name_de-DE` varchar(100) NOT NULL,
515PRIMARY KEY (`status_id`)
516) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
517
518CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_orders`(
519`order_id` int(11) NOT NULL auto_increment,
520`order_number` VARCHAR(50) NOT NULL,
521`user_id` int(11) NOT NULL,
522`order_total` DECIMAL(14,2) NOT NULL,
523`order_subtotal` DECIMAL(14,2) NOT NULL,
524`order_tax` DECIMAL(14,2) NOT NULL,
525`order_tax_ext` text NOT NULL,
526`order_shipping` DECIMAL(14,2) NOT NULL,
527`order_payment` DECIMAL(14,2) NOT NULL,
528`order_discount` DECIMAL(14,2) NOT NULL,
529`shipping_tax` DECIMAL(12,2) NOT NULL,
530`shipping_tax_ext` text NOT NULL,
531`payment_tax` DECIMAL(12,2) NOT NULL,
532`payment_tax_ext` text NOT NULL,
533`order_package` DECIMAL(12,2) NOT NULL,
534`package_tax_ext` text NOT NULL,
535`currency_code` VARCHAR( 20 ) NOT NULL,
536`currency_code_iso` VARCHAR( 3 ) NOT NULL,
537`currency_exchange` DECIMAL(14,6) NOT NULL,
538`order_status` tinyint(4) NOT NULL,
539`order_created` tinyint(1) NOT NULL,
540`order_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
541`invoice_date` DATETIME NOT NULL,
542`order_m_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
543`shipping_method_id` int(11) NOT NULL,
544`delivery_times_id` int(11) NOT NULL,
545`payment_method_id` int(11) NOT NULL,
546`payment_params` text NOT NULL,
547`payment_params_data` text NOT NULL,
548`shipping_params` text NOT NULL,
549`shipping_params_data` text NOT NULL,
550`delivery_time` VARCHAR(100) NOT NULL,
551`delivery_date` DATETIME NOT NULL,
552`coupon_id` int(11) NOT NULL,
553`coupon_free_discount` decimal(14,4) NOT NULL,
554`ip_address` varchar(64) NOT NULL,
555`order_add_info` text NOT NULL,
556`title` tinyint(1) NOT NULL ,
557`f_name` varchar(255) NOT NULL,
558`l_name` varchar(255) NOT NULL,
559`m_name` varchar(255) NOT NULL,
560`firma_name` varchar(255) NOT NULL,
561`client_type` tinyint(1) NOT NULL,
562`client_type_name` VARCHAR(100) NOT NULL,
563`firma_code` VARCHAR( 100 ) NOT NULL,
564`tax_number` VARCHAR( 100 ) NOT NULL,
565`email` varchar(255) NOT NULL ,
566`birthday` DATE NOT NULL,
567`street` varchar(100) NOT NULL,
568`street_nr` varchar(16) NOT NULL,
569`home` VARCHAR( 20 ) NOT NULL,
570`apartment` VARCHAR( 20 ) NOT NULL,
571`zip` varchar(20) NOT NULL,
572`city` varchar(100) NOT NULL,
573`state` varchar(100) NOT NULL,
574`country` int(11) NOT NULL,
575`phone` varchar(24) NOT NULL,
576`mobil_phone` VARCHAR(24) NOT NULL,
577`fax` varchar(24) NOT NULL,
578`ext_field_1` VARCHAR(255) NOT NULL,
579`ext_field_2` VARCHAR(255) NOT NULL,
580`ext_field_3` VARCHAR(255) NOT NULL,
581`d_title` tinyint(1) NOT NULL,
582`d_f_name` varchar(255) NOT NULL,
583`d_l_name` varchar(255) NOT NULL,
584`d_m_name` varchar(255) NOT NULL,
585`d_firma_name` varchar(255) NOT NULL,
586`d_email` varchar(255) NOT NULL,
587`d_birthday` DATE NOT NULL,
588`d_street` varchar(100) NOT NULL,
589`d_street_nr` varchar(16) NOT NULL,
590`d_home` VARCHAR( 20 ) NOT NULL,
591`d_apartment` VARCHAR( 20 ) NOT NULL,
592`d_zip` varchar(20) NOT NULL,
593`d_city` varchar(100) NOT NULL,
594`d_state` varchar(100) NOT NULL,
595`d_country` int(11) NOT NULL,
596`d_phone` varchar(24) NOT NULL,
597`d_mobil_phone` VARCHAR(24) NOT NULL,
598`d_fax` varchar(24) NOT NULL,
599`d_ext_field_1` VARCHAR(255) NOT NULL,
600`d_ext_field_2` VARCHAR(255) NOT NULL,
601`d_ext_field_3` VARCHAR(255) NOT NULL,
602`pdf_file` VARCHAR( 50 ) NOT NULL,
603`order_hash` varchar(32) NOT NULL,
604`file_hash` varchar(64) NOT NULL,
605`file_stat_downloads` text NOT NULL,
606`order_custom_info` text NOT NULL,
607`display_price` tinyint(1) NOT NULL,
608`vendor_type` tinyint(1) NOT NULL,
609`vendor_id` int(11) NOT NULL,
610`lang` varchar(16) NOT NULL,
611`transaction` TEXT NOT NULL,
612`product_stock_removed` tinyint(1) NOT NULL,
613PRIMARY KEY (`order_id`)
614) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
615
616CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_attr` (
617`attr_id` int(11) NOT NULL auto_increment,
618`attr_ordering` int(11) NOT NULL,
619`attr_type` TINYINT( 1 ) NOT NULL,
620`independent` TINYINT( 1 ) NOT NULL,
621`allcats` tinyint(1) NOT NULL default '1',
622`cats` text NOT NULL,
623`group` tinyint(4) NOT NULL,
624PRIMARY KEY (`attr_id`),
625KEY `group` (`group`)
626) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
627
628CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_attr_values` (
629`value_id` int(11) NOT NULL auto_increment,
630`attr_id` int(11) NOT NULL,
631`value_ordering` int(11) NOT NULL,
632`image` VARCHAR( 255 ) NOT NULL,
633PRIMARY KEY (`value_id`)
634) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
635
636CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_attr_groups`(
637`id` int(11) NOT NULL AUTO_INCREMENT,
638`ordering` int(6) NOT NULL,
639PRIMARY KEY (`id`)
640) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
641
642CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_products_attr` (
643`product_attr_id` int(11) NOT NULL auto_increment,
644`product_id` int(11) NOT NULL,
645`buy_price` DECIMAL(12,2) NOT NULL,
646`price` DECIMAL(14,2) NOT NULL,
647`old_price` DECIMAL(14,2) NOT NULL,
648`count` DECIMAL(14,4) NOT NULL,
649`ean` int(11) NOT NULL,
650`manufacturer_code` varchar(32) NOT NULL,
651`weight` DECIMAL(12,2) NOT NULL,
652`weight_volume_units` DECIMAL(14,2) NOT NULL,
653`ext_attribute_product_id` int(11) NOT NULL,
654PRIMARY KEY (`product_attr_id`)
655) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
656
657CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_products_attr2`(
658`id` int(11) NOT NULL auto_increment,
659`product_id` int(11) NOT NULL,
660`attr_id` int(11) NOT NULL,
661`attr_value_id` int(11) NOT NULL,
662`price_mod` char(1) NOT NULL,
663`addprice` decimal(14,4) NOT NULL,
664PRIMARY KEY (`id`)
665) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
666
667CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_cart_temp` (
668`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
669`id_cookie` VARCHAR( 255 ) NOT NULL ,
670`cart` TEXT NOT NULL,
671`type_cart` varchar(32) NOT NULL
672) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
673
674CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_languages` (
675`id` int(11) NOT NULL auto_increment,
676`language` varchar(32) default NULL,
677`name` varchar(255) NOT NULL,
678`publish` int(11) NOT NULL,
679`ordering` int(11) NOT NULL,
680PRIMARY KEY (`id`)
681) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
682
683CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_import_export` (
684`id` int(11) NOT NULL auto_increment,
685`name` varchar(255) NOT NULL,
686`alias` varchar(255) NOT NULL,
687`description` text NOT NULL,
688`params` text NOT NULL,
689`endstart` int(11) NOT NULL,
690`steptime` int(11) NOT NULL,
691PRIMARY KEY (`id`)
692) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
693
694CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_unit` (
695`id` int(11) NOT NULL auto_increment,
696`qty` int(11) NOT NULL default 1,
697`name_de-DE` varchar(255) NOT NULL,
698`name_en-GB` varchar(255) NOT NULL,
699PRIMARY KEY (`id`)
700) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
701
702CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_product_labels` (
703`id` int(11) NOT NULL auto_increment,
704`name` varchar(255) NOT NULL,
705`name_en-GB` VARCHAR(255) NOT NULL,
706`name_de-DE` VARCHAR(255) NOT NULL,
707`image` varchar(255) NOT NULL,
708PRIMARY KEY (`id`)
709) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
710
711CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_taxes_ext` (
712`id` int(11) NOT NULL auto_increment,
713`tax_id` int(11) NOT NULL,
714`zones` text NOT NULL,
715`tax` DECIMAL(12,2) NOT NULL,
716`firma_tax` DECIMAL(12,2) NOT NULL,
717PRIMARY KEY (`id`)
718) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
719
720CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_config_display_prices` (
721`id` int(11) NOT NULL auto_increment,
722`zones` text NOT NULL,
723`display_price` tinyint(1) NOT NULL,
724`display_price_firma` tinyint(1) NOT NULL,
725PRIMARY KEY (`id`)
726) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
727
728CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_products_extra_fields` (
729`id` int(11) NOT NULL auto_increment,
730`allcats` tinyint(1) NOT NULL,
731`cats` text NOT NULL,
732`type` TINYINT(1) NOT NULL,
733`multilist` tinyint(1) NOT NULL,
734`group` TINYINT(4) NOT NULL,
735`ordering` int(6) NOT NULL,
736PRIMARY KEY (`id`),
737KEY `group` (`group`)
738) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
739
740CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_products_extra_field_values` (
741`id` int(11) NOT NULL auto_increment,
742`field_id` int(11) NOT NULL,
743`ordering` int(6) NOT NULL,
744PRIMARY KEY (`id`)
745) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
746
747CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_products_extra_field_groups` (
748`id` int(11) NOT NULL auto_increment,
749`ordering` int(6) NOT NULL,
750PRIMARY KEY (`id`)
751) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
752
753CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_vendors`(
754`id` int(11) NOT NULL auto_increment,
755`shop_name` varchar(255) NOT NULL,
756`company_name` varchar(255) NOT NULL,
757`url` varchar(255) NOT NULL,
758`logo` varchar(255) NOT NULL,
759`adress` varchar(255) NOT NULL,
760`city` varchar(100) NOT NULL,
761`zip` varchar(20) NOT NULL,
762`state` varchar(100) NOT NULL,
763`country` int(11) NOT NULL,
764`f_name` varchar(255) NOT NULL,
765`l_name` varchar(255) NOT NULL,
766`middlename` varchar(255) NOT NULL,
767`phone` varchar(24) NOT NULL,
768`fax` varchar(24) NOT NULL,
769`email` varchar(255) NOT NULL,
770`benef_bank_info` varchar(64) NOT NULL,
771`benef_bic` varchar(64) NOT NULL,
772`benef_conto` varchar(64) NOT NULL,
773`benef_payee` varchar(64) NOT NULL,
774`benef_iban` varchar(64) NOT NULL,
775`benef_bic_bic` varchar(64) NOT NULL,
776`benef_swift` varchar(64) NOT NULL,
777`interm_name` varchar(64) NOT NULL,
778`interm_swift` varchar(64) NOT NULL,
779`identification_number` varchar(64) NOT NULL,
780`tax_number` varchar(64) NOT NULL,
781`additional_information` text NOT NULL,
782`user_id` int(11) NOT NULL,
783`main` TINYINT(1) NOT NULL,
784`publish` TINYINT(1) NOT NULL,
785 PRIMARY KEY (`id`)
786) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
787
788CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_addons` (
789`id` int(11) NOT NULL auto_increment,
790`alias` varchar(255) NOT NULL,
791`name` varchar(255) NOT NULL,
792`key` text NOT NULL,
793`usekey` tinyint(1) NOT NULL,
794`version` varchar(255) NOT NULL,
795`uninstall` varchar(255) NOT NULL,
796`params` longtext NOT NULL,
797PRIMARY KEY (`id`)
798) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
799
800CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_free_attr` (
801`id` INT NOT NULL AUTO_INCREMENT,
802`ordering` INT NOT NULL,
803`required` TINYINT(1) NOT NULL,
804`type` TINYINT(3) NOT NULL,
805PRIMARY KEY ( `id` )
806) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
807
808CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_products_free_attr` (
809`id` INT NOT NULL AUTO_INCREMENT,
810`product_id` INT NOT NULL,
811`attr_id` INT NOT NULL,
812PRIMARY KEY (`id`),
813KEY `product_id` (`product_id`),
814KEY `attr_id` (`attr_id`)
815) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
816
817CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_config_seo` (
818`id` INT NOT NULL AUTO_INCREMENT ,
819`alias` VARCHAR( 64 ) NOT NULL ,
820`ordering` INT NOT NULL,
821PRIMARY KEY ( `id` )
822) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
823
824CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_config_statictext` (
825`id` INT NOT NULL AUTO_INCREMENT,
826`alias` VARCHAR( 64 ) NOT NULL,
827`use_for_return_policy` int NOT NULL,
828PRIMARY KEY ( `id` )
829) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
830
831CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_products_option` (
832`id` int(11) NOT NULL AUTO_INCREMENT,
833`product_id` int(11) NOT NULL,
834`key` varchar(64) NOT NULL,
835`value` text NOT NULL,
836PRIMARY KEY (`id`),
837UNIQUE KEY `prodkey` (`product_id`,`key`)
838) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
839
840CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_payment_trx` (
841`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
842`order_id` INT NOT NULL,
843`transaction` VARCHAR( 255 ) NOT NULL,
844`rescode` INT NOT NULL,
845`status_id` INT NOT NULL,
846`date` datetime NOT NULL
847) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
848
849CREATE TABLE IF NOT EXISTS `zb9l1_jshopping_payment_trx_data` (
850`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
851`trx_id` INT NOT NULL ,
852`order_id` INT NOT NULL ,
853`key` VARCHAR( 255 ) NOT NULL ,
854`value` TEXT NOT NULL
855) /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;
856
857ALTER TABLE `zb9l1_jshopping_addons` ADD INDEX(`alias`);
858ALTER TABLE `zb9l1_jshopping_addons` ADD INDEX(`name`);
859
860ALTER TABLE `zb9l1_jshopping_attr` ADD INDEX(`attr_ordering`);
861ALTER TABLE `zb9l1_jshopping_attr` ADD INDEX(`attr_type`);
862ALTER TABLE `zb9l1_jshopping_attr` ADD INDEX(`independent`);
863ALTER TABLE `zb9l1_jshopping_attr` ADD INDEX(`allcats`);
864
865ALTER TABLE `zb9l1_jshopping_attr_values` ADD INDEX(`attr_id`);
866ALTER TABLE `zb9l1_jshopping_attr_values` ADD INDEX(`value_ordering`);
867
868ALTER TABLE `zb9l1_jshopping_cart_temp` ADD INDEX(`id_cookie`);
869ALTER TABLE `zb9l1_jshopping_cart_temp` ADD INDEX(`type_cart`);
870
871ALTER TABLE `zb9l1_jshopping_categories` ADD INDEX(`category_parent_id`);
872ALTER TABLE `zb9l1_jshopping_categories` ADD INDEX(`category_publish`);
873ALTER TABLE `zb9l1_jshopping_categories` ADD INDEX(`category_template`);
874ALTER TABLE `zb9l1_jshopping_categories` ADD INDEX(`ordering`);
875ALTER TABLE `zb9l1_jshopping_categories` ADD INDEX(`category_add_date`);
876ALTER TABLE `zb9l1_jshopping_categories` ADD INDEX(`products_page`);
877ALTER TABLE `zb9l1_jshopping_categories` ADD INDEX(`products_row`);
878ALTER TABLE `zb9l1_jshopping_categories` ADD INDEX(`access`);
879ALTER TABLE `zb9l1_jshopping_categories` ADD INDEX(`category_publish`, `access`);
880
881ALTER TABLE `zb9l1_jshopping_config_display_prices` ADD INDEX(`display_price`);
882ALTER TABLE `zb9l1_jshopping_config_display_prices` ADD INDEX(`display_price_firma`);
883
884ALTER TABLE `zb9l1_jshopping_config_seo` ADD INDEX(`alias`);
885ALTER TABLE `zb9l1_jshopping_config_seo` ADD INDEX(`ordering`);
886
887ALTER TABLE `zb9l1_jshopping_config_statictext` ADD INDEX(`alias`);
888ALTER TABLE `zb9l1_jshopping_config_statictext` ADD INDEX(`use_for_return_policy`);
889
890ALTER TABLE `zb9l1_jshopping_countries` ADD INDEX(`country_publish`);
891ALTER TABLE `zb9l1_jshopping_countries` ADD INDEX(`ordering`);
892ALTER TABLE `zb9l1_jshopping_countries` ADD INDEX(`country_code`);
893ALTER TABLE `zb9l1_jshopping_countries` ADD INDEX(`country_code_2`);
894
895ALTER TABLE `zb9l1_jshopping_coupons` ADD INDEX(`coupon_type`);
896ALTER TABLE `zb9l1_jshopping_coupons` ADD INDEX(`coupon_code`);
897ALTER TABLE `zb9l1_jshopping_coupons` ADD INDEX(`tax_id`);
898ALTER TABLE `zb9l1_jshopping_coupons` ADD INDEX(`used`);
899ALTER TABLE `zb9l1_jshopping_coupons` ADD INDEX(`for_user_id`);
900ALTER TABLE `zb9l1_jshopping_coupons` ADD INDEX(`coupon_publish`);
901ALTER TABLE `zb9l1_jshopping_coupons` ADD INDEX(`coupon_start_date`);
902ALTER TABLE `zb9l1_jshopping_coupons` ADD INDEX(`coupon_expire_date`);
903ALTER TABLE `zb9l1_jshopping_coupons` ADD INDEX(`finished_after_used`);
904
905ALTER TABLE `zb9l1_jshopping_currencies` ADD INDEX(`currency_code_iso`);
906ALTER TABLE `zb9l1_jshopping_currencies` ADD INDEX(`currency_code_num`);
907ALTER TABLE `zb9l1_jshopping_currencies` ADD INDEX(`currency_ordering`);
908ALTER TABLE `zb9l1_jshopping_currencies` ADD INDEX(`currency_publish`);
909
910ALTER TABLE `zb9l1_jshopping_languages` ADD INDEX(`publish`);
911ALTER TABLE `zb9l1_jshopping_languages` ADD INDEX(`ordering`);
912
913ALTER TABLE `zb9l1_jshopping_manufacturers` ADD INDEX(`manufacturer_publish`);
914ALTER TABLE `zb9l1_jshopping_manufacturers` ADD INDEX(`products_page`);
915ALTER TABLE `zb9l1_jshopping_manufacturers` ADD INDEX(`products_row`);
916ALTER TABLE `zb9l1_jshopping_manufacturers` ADD INDEX(`ordering`);
917
918ALTER TABLE `zb9l1_jshopping_order_history` ADD INDEX(`order_id`);
919ALTER TABLE `zb9l1_jshopping_order_history` ADD INDEX(`order_status_id`);
920ALTER TABLE `zb9l1_jshopping_order_history` ADD INDEX(`status_date_added`);
921ALTER TABLE `zb9l1_jshopping_order_history` ADD INDEX(`customer_notify`);
922
923ALTER TABLE `zb9l1_jshopping_order_item` ADD INDEX(`order_id`);
924ALTER TABLE `zb9l1_jshopping_order_item` ADD INDEX(`product_id`);
925ALTER TABLE `zb9l1_jshopping_order_item` ADD INDEX(`delivery_times_id`);
926ALTER TABLE `zb9l1_jshopping_order_item` ADD INDEX(`vendor_id`);
927
928ALTER TABLE `zb9l1_jshopping_order_status` ADD INDEX(`status_code`);
929
930ALTER TABLE `zb9l1_jshopping_orders` ADD INDEX(`order_number`);
931ALTER TABLE `zb9l1_jshopping_orders` ADD INDEX(`user_id`);
932ALTER TABLE `zb9l1_jshopping_orders` ADD INDEX(`currency_code_iso`);
933ALTER TABLE `zb9l1_jshopping_orders` ADD INDEX(`order_status`);
934ALTER TABLE `zb9l1_jshopping_orders` ADD INDEX(`order_created`);
935ALTER TABLE `zb9l1_jshopping_orders` ADD INDEX(`shipping_method_id`);
936ALTER TABLE `zb9l1_jshopping_orders` ADD INDEX(`delivery_times_id`);
937ALTER TABLE `zb9l1_jshopping_orders` ADD INDEX(`payment_method_id`);
938ALTER TABLE `zb9l1_jshopping_orders` ADD INDEX(`coupon_id`);
939ALTER TABLE `zb9l1_jshopping_orders` ADD INDEX(`client_type`);
940ALTER TABLE `zb9l1_jshopping_orders` ADD INDEX(`country`);
941ALTER TABLE `zb9l1_jshopping_orders` ADD INDEX(`phone`);
942ALTER TABLE `zb9l1_jshopping_orders` ADD INDEX(`d_title`);
943ALTER TABLE `zb9l1_jshopping_orders` ADD INDEX(`d_country`);
944ALTER TABLE `zb9l1_jshopping_orders` ADD INDEX(`display_price`);
945ALTER TABLE `zb9l1_jshopping_orders` ADD INDEX(`vendor_type`);
946ALTER TABLE `zb9l1_jshopping_orders` ADD INDEX(`vendor_id`);
947ALTER TABLE `zb9l1_jshopping_orders` ADD INDEX(`lang`);
948
949ALTER TABLE `zb9l1_jshopping_payment_method` ADD INDEX(`payment_code`);
950ALTER TABLE `zb9l1_jshopping_payment_method` ADD INDEX(`payment_publish`);
951ALTER TABLE `zb9l1_jshopping_payment_method` ADD INDEX(`payment_ordering`);
952ALTER TABLE `zb9l1_jshopping_payment_method` ADD INDEX(`payment_type`);
953ALTER TABLE `zb9l1_jshopping_payment_method` ADD INDEX(`price_type`);
954ALTER TABLE `zb9l1_jshopping_payment_method` ADD INDEX(`tax_id`);
955
956ALTER TABLE `zb9l1_jshopping_payment_trx` ADD INDEX(`order_id`);
957ALTER TABLE `zb9l1_jshopping_payment_trx` ADD INDEX(`transaction`);
958ALTER TABLE `zb9l1_jshopping_payment_trx` ADD INDEX(`rescode`);
959ALTER TABLE `zb9l1_jshopping_payment_trx` ADD INDEX(`status_id`);
960
961ALTER TABLE `zb9l1_jshopping_payment_trx_data` ADD INDEX(`trx_id`);
962ALTER TABLE `zb9l1_jshopping_payment_trx_data` ADD INDEX(`order_id`);
963ALTER TABLE `zb9l1_jshopping_payment_trx_data` ADD INDEX(`key`);
964
965ALTER TABLE `zb9l1_jshopping_products` ADD INDEX(`parent_id`);
966ALTER TABLE `zb9l1_jshopping_products` ADD INDEX(`product_ean`);
967ALTER TABLE `zb9l1_jshopping_products` ADD INDEX(`unlimited`);
968ALTER TABLE `zb9l1_jshopping_products` ADD INDEX(`product_publish`);
969ALTER TABLE `zb9l1_jshopping_products` ADD INDEX(`product_tax_id`);
970ALTER TABLE `zb9l1_jshopping_products` ADD INDEX(`currency_id`);
971ALTER TABLE `zb9l1_jshopping_products` ADD INDEX(`product_price`);
972ALTER TABLE `zb9l1_jshopping_products` ADD INDEX(`min_price`);
973ALTER TABLE `zb9l1_jshopping_products` ADD INDEX(`add_price_unit_id`);
974ALTER TABLE `zb9l1_jshopping_products` ADD INDEX(`average_rating`);
975ALTER TABLE `zb9l1_jshopping_products` ADD INDEX(`reviews_count`);
976ALTER TABLE `zb9l1_jshopping_products` ADD INDEX(`delivery_times_id`);
977ALTER TABLE `zb9l1_jshopping_products` ADD INDEX(`hits`);
978ALTER TABLE `zb9l1_jshopping_products` ADD INDEX(`basic_price_unit_id`);
979ALTER TABLE `zb9l1_jshopping_products` ADD INDEX(`label_id`);
980ALTER TABLE `zb9l1_jshopping_products` ADD INDEX(`vendor_id`);
981ALTER TABLE `zb9l1_jshopping_products` ADD INDEX(`access`);
982
983ALTER TABLE `zb9l1_jshopping_products_attr` ADD INDEX(`product_id`);
984ALTER TABLE `zb9l1_jshopping_products_attr` ADD INDEX(`ext_attribute_product_id`);
985
986ALTER TABLE `zb9l1_jshopping_products_attr2` ADD INDEX(`product_id`);
987ALTER TABLE `zb9l1_jshopping_products_attr2` ADD INDEX(`attr_id`);
988ALTER TABLE `zb9l1_jshopping_products_attr2` ADD INDEX(`attr_value_id`);
989ALTER TABLE `zb9l1_jshopping_products_attr2` ADD INDEX(`price_mod`);
990
991ALTER TABLE `zb9l1_jshopping_products_extra_field_groups` ADD INDEX(`ordering`);
992
993ALTER TABLE `zb9l1_jshopping_products_extra_field_values` ADD INDEX(`field_id`);
994ALTER TABLE `zb9l1_jshopping_products_extra_field_values` ADD INDEX(`ordering`);
995
996ALTER TABLE `zb9l1_jshopping_products_extra_fields` ADD INDEX(`allcats`);
997ALTER TABLE `zb9l1_jshopping_products_extra_fields` ADD INDEX(`type`);
998ALTER TABLE `zb9l1_jshopping_products_extra_fields` ADD INDEX(`multilist`);
999ALTER TABLE `zb9l1_jshopping_products_extra_fields` ADD INDEX(`group`);
1000ALTER TABLE `zb9l1_jshopping_products_extra_fields` ADD INDEX(`ordering`);
1001
1002ALTER TABLE `zb9l1_jshopping_products_files` ADD INDEX(`ordering`);
1003
1004ALTER TABLE `zb9l1_jshopping_products_images` ADD INDEX(`product_id`);
1005ALTER TABLE `zb9l1_jshopping_products_images` ADD INDEX(`ordering`);
1006
1007ALTER TABLE `zb9l1_jshopping_products_option` ADD INDEX(`product_id`);
1008
1009ALTER TABLE `zb9l1_jshopping_products_prices` ADD INDEX(`product_id`);
1010ALTER TABLE `zb9l1_jshopping_products_prices` ADD INDEX(`product_quantity_start`);
1011ALTER TABLE `zb9l1_jshopping_products_prices` ADD INDEX(`product_quantity_finish`);
1012
1013ALTER TABLE `zb9l1_jshopping_products_relations` ADD INDEX(`product_id`, `product_related_id`);
1014ALTER TABLE `zb9l1_jshopping_products_relations` ADD INDEX(`product_id`);
1015ALTER TABLE `zb9l1_jshopping_products_relations` ADD INDEX(`product_related_id`);
1016
1017ALTER TABLE `zb9l1_jshopping_products_reviews` ADD INDEX(`product_id`);
1018ALTER TABLE `zb9l1_jshopping_products_reviews` ADD INDEX(`user_id`);
1019ALTER TABLE `zb9l1_jshopping_products_reviews` ADD INDEX(`user_email`);
1020ALTER TABLE `zb9l1_jshopping_products_reviews` ADD INDEX(`mark`);
1021ALTER TABLE `zb9l1_jshopping_products_reviews` ADD INDEX(`publish`);
1022ALTER TABLE `zb9l1_jshopping_products_reviews` ADD INDEX(`ip`);
1023
1024ALTER TABLE `zb9l1_jshopping_products_to_categories` ADD INDEX(`product_id`, `category_id`, `product_ordering`);
1025ALTER TABLE `zb9l1_jshopping_products_to_categories` ADD INDEX(`product_ordering`);
1026
1027ALTER TABLE `zb9l1_jshopping_products_videos` ADD INDEX(`video_id`, `product_id`);
1028ALTER TABLE `zb9l1_jshopping_products_videos` ADD INDEX(`product_id`);
1029
1030ALTER TABLE `zb9l1_jshopping_shipping_ext_calc` ADD INDEX(`alias`);
1031ALTER TABLE `zb9l1_jshopping_shipping_ext_calc` ADD INDEX(`published`);
1032ALTER TABLE `zb9l1_jshopping_shipping_ext_calc` ADD INDEX(`ordering`);
1033
1034ALTER TABLE `zb9l1_jshopping_shipping_method` ADD INDEX(`alias`);
1035ALTER TABLE `zb9l1_jshopping_shipping_method` ADD INDEX(`published`);
1036ALTER TABLE `zb9l1_jshopping_shipping_method` ADD INDEX(`ordering`);
1037
1038ALTER TABLE `zb9l1_jshopping_shipping_method_price` ADD INDEX(`shipping_method_id`);
1039ALTER TABLE `zb9l1_jshopping_shipping_method_price` ADD INDEX(`shipping_tax_id`);
1040ALTER TABLE `zb9l1_jshopping_shipping_method_price` ADD INDEX(`package_tax_id`);
1041ALTER TABLE `zb9l1_jshopping_shipping_method_price` ADD INDEX(`delivery_times_id`);
1042
1043ALTER TABLE `zb9l1_jshopping_shipping_method_price_countries` ADD INDEX(`sh_method_country_id`, `country_id`, `sh_pr_method_id`);
1044ALTER TABLE `zb9l1_jshopping_shipping_method_price_countries` ADD INDEX(`country_id`, `sh_pr_method_id`);
1045ALTER TABLE `zb9l1_jshopping_shipping_method_price_countries` ADD INDEX(`sh_method_country_id`, `country_id`);
1046
1047ALTER TABLE `zb9l1_jshopping_shipping_method_price_weight` ADD INDEX( `sh_pr_weight_id`, `sh_pr_method_id`);
1048
1049ALTER TABLE `zb9l1_jshopping_taxes_ext` ADD INDEX(`tax_id`);
1050
1051ALTER TABLE `zb9l1_jshopping_unit` ADD INDEX(`qty`);
1052
1053ALTER TABLE `zb9l1_jshopping_usergroups` ADD INDEX(`usergroup_name`);
1054ALTER TABLE `zb9l1_jshopping_usergroups` ADD INDEX(`usergroup_is_default`);
1055
1056ALTER TABLE `zb9l1_jshopping_users` ADD INDEX(`usergroup_id`);
1057ALTER TABLE `zb9l1_jshopping_users` ADD INDEX(`payment_id`);
1058ALTER TABLE `zb9l1_jshopping_users` ADD INDEX(`shipping_id`);
1059ALTER TABLE `zb9l1_jshopping_users` ADD INDEX(`client_type`);
1060ALTER TABLE `zb9l1_jshopping_users` ADD INDEX(`email`);
1061
1062ALTER TABLE `zb9l1_jshopping_vendors` ADD INDEX(`country`);
1063ALTER TABLE `zb9l1_jshopping_vendors` ADD INDEX(`user_id`);
1064ALTER TABLE `zb9l1_jshopping_vendors` ADD INDEX(`email`);
1065ALTER TABLE `zb9l1_jshopping_vendors` ADD INDEX(`main`);
1066ALTER TABLE `zb9l1_jshopping_vendors` ADD INDEX(`publish`);
1067
1068INSERT INTO `zb9l1_jshopping_countries` (`country_id`, `country_publish`, `ordering`, `country_code`, `country_code_2`, `name_en-GB`, `name_de-DE`) VALUES
1069(1, 1, 1, 'AFG', 'AF', 'Afghanistan', 'Afghanistan'),
1070(2, 1, 2, 'ALB', 'AL', 'Albania', 'Albanien'),
1071(3, 1, 3, 'DZA', 'DZ', 'Algeria', 'Algerien'),
1072(4, 1, 4, 'ASM', 'AS', 'American Samoa', 'Amerikanisch-Samoa'),
1073(5, 1, 5, 'AND', 'AD', 'Andorra', 'Andorra'),
1074(6, 1, 6, 'AGO', 'AO', 'Angola', 'Angola'),
1075(7, 1, 7, 'AIA', 'AI', 'Anguilla', 'Anguilla'),
1076(8, 1, 8, 'ATA', 'AQ', 'Antarctica', 'Antarktis'),
1077(9, 1, 9, 'ATG', 'AG', 'Antigua and Barbuda', 'Antigua und Barbuda'),
1078(10, 1, 10, 'ARG', 'AR', 'Argentina', 'Argentinien'),
1079(11, 1, 11, 'ARM', 'AM', 'Armenia', 'Armenien'),
1080(12, 1, 12, 'ABW', 'AW', 'Aruba', 'Aruba'),
1081(13, 1, 13, 'AUS', 'AU', 'Australia', 'Australien'),
1082(14, 1, 14, 'AUT', 'AT', 'Austria', 'Österreich'),
1083(15, 1, 15, 'AZE', 'AZ', 'Azerbaijan', 'Aserbaidschan'),
1084(16, 1, 16, 'BHS', 'BS', 'Bahamas', 'Bahamas'),
1085(17, 1, 17, 'BHR', 'BH', 'Bahrain', 'Bahrain'),
1086(18, 1, 18, 'BGD', 'BD', 'Bangladesh', 'Bangladesch'),
1087(19, 1, 19, 'BRB', 'BB', 'Barbados', 'Barbados'),
1088(20, 1, 20, 'BLR', 'BY', 'Belarus', 'Weissrussland'),
1089(21, 1, 21, 'BEL', 'BE', 'Belgium', 'Belgien'),
1090(22, 1, 22, 'BLZ', 'BZ', 'Belize', 'Belize'),
1091(23, 1, 23, 'BEN', 'BJ', 'Benin', 'Benin'),
1092(24, 1, 24, 'BMU', 'BM', 'Bermuda', 'Bermuda'),
1093(25, 1, 25, 'BTN', 'BT', 'Bhutan', 'Bhutan'),
1094(26, 1, 26, 'BOL', 'BO', 'Bolivia', 'Bolivien'),
1095(27, 1, 27, 'BIH', 'BA', 'Bosnia and Herzegowina', 'Bosnien und Herzegowina'),
1096(28, 1, 28, 'BWA', 'BW', 'Botswana', 'Botsuana'),
1097(29, 1, 29, 'BVT', 'BV', 'Bouvet Island', 'Bouvetinsel'),
1098(30, 1, 30, 'BRA', 'BR', 'Brazil', 'Brasilien'),
1099(31, 1, 31, 'IOT', 'IO', 'British Indian Ocean Territory', 'Britisches Territorium im Indischen Ozean'),
1100(32, 1, 32, 'BRN', 'BN', 'Brunei Darussalam', 'Brunei'),
1101(33, 1, 33, 'BGR', 'BG', 'Bulgaria', 'Bulgarien'),
1102(34, 1, 34, 'BFA', 'BF', 'Burkina Faso', 'Burkina Faso'),
1103(35, 1, 35, 'BDI', 'BI', 'Burundi', 'Burundi'),
1104(36, 1, 36, 'KHM', 'KH', 'Cambodia', 'Kambodscha'),
1105(37, 1, 37, 'CMR', 'CM', 'Cameroon', 'Kamerun'),
1106(38, 1, 38, 'CAN', 'CA', 'Canada', 'Kanada'),
1107(39, 1, 39, 'CPV', 'CV', 'Cape Verde', 'Kap Verde'),
1108(40, 1, 40, 'CYM', 'KY', 'Cayman Islands', 'Cayman-Inseln'),
1109(41, 1, 41, 'CAF', 'CF', 'Central African Republic', 'Zentralafrikanische Republik'),
1110(42, 1, 42, 'TCD', 'TD', 'Chad', 'Tschad'),
1111(43, 1, 43, 'CHL', 'CL', 'Chile', 'Chile'),
1112(44, 1, 44, 'CHN', 'CN', 'China', 'China'),
1113(45, 1, 45, 'CXR', 'CX', 'Christmas Island', 'Christmas Island'),
1114(46, 1, 46, 'CCK', 'CC', 'Cocos (Keeling) Islands', 'Kokosinseln (Keeling)'),
1115(47, 1, 47, 'COL', 'CO', 'Colombia', 'Kolumbien'),
1116(48, 1, 48, 'COM', 'KM', 'Comoros', 'Komoren'),
1117(49, 1, 49, 'COG', 'CG', 'Congo', 'Kongo, Republik'),
1118(50, 1, 50, 'COK', 'CK', 'Cook Islands', 'Cookinseln'),
1119(51, 1, 51, 'CRI', 'CR', 'Costa Rica', 'Costa Rica'),
1120(52, 1, 52, 'CIV', 'CI', 'Cote D''Ivoire', 'Elfenbeinküste'),
1121(53, 1, 53, 'HRV', 'HR', 'Croatia', 'Kroatien'),
1122(54, 1, 54, 'CUB', 'CU', 'Cuba', 'Kuba'),
1123(55, 1, 55, 'CYP', 'CY', 'Cyprus', 'Zypern'),
1124(56, 1, 56, 'CZE', 'CZ', 'Czech Republic', 'Tschechien'),
1125(57, 1, 57, 'DNK', 'DK', 'Denmark', 'Dänemark'),
1126(58, 1, 58, 'DJI', 'DJ', 'Djibouti', 'Dschibuti'),
1127(59, 1, 59, 'DMA', 'DM', 'Dominica', 'Dominica'),
1128(60, 1, 60, 'DOM', 'DO', 'Dominican Republic', 'Dominikanische Republik'),
1129(61, 1, 61, 'TMP', 'TL', 'East Timor', 'Osttimor'),
1130(62, 1, 62, 'ECU', 'EC', 'Ecuador', 'Ecuador'),
1131(63, 1, 63, 'EGY', 'EG', 'Egypt', 'Ägypten'),
1132(64, 1, 64, 'SLV', 'SV', 'El Salvador', 'El Salvador'),
1133(65, 1, 65, 'GNQ', 'GQ', 'Equatorial Guinea', 'Äquatorial-Guinea'),
1134(66, 1, 66, 'ERI', 'ER', 'Eritrea', 'Eritrea'),
1135(67, 1, 67, 'EST', 'EE', 'Estonia', 'Estland'),
1136(68, 1, 68, 'ETH', 'ET', 'Ethiopia', 'Äthiopien'),
1137(69, 1, 69, 'FLK', 'FK', 'Falkland Islands (Malvinas)', 'Falklandinseln'),
1138(70, 1, 70, 'FRO', 'FO', 'Faroe Islands', 'Färöer'),
1139(71, 1, 71, 'FJI', 'FJ', 'Fiji', 'Fidschi'),
1140(72, 1, 72, 'FIN', 'FI', 'Finland', 'Finnland'),
1141(73, 1, 73, 'FRA', 'FR', 'France', 'Frankreich'),
1142(74, 1, 74, 'FXX', 'FX', 'France Metropolitan', 'Frankreich, Metropolitan'),
1143(75, 1, 75, 'GUF', 'GF', 'French Guiana', 'Französisch-Guyana'),
1144(76, 1, 76, 'PYF', 'PF', 'French Polynesia', 'Franz. Polynesien'),
1145(77, 1, 77, 'ATF', 'TF', 'French Southern Territories', 'Französiche Süd- und Antarktisgebiete'),
1146(78, 1, 78, 'GAB', 'GA', 'Gabon', 'Gabun'),
1147(79, 1, 79, 'GMB', 'GM', 'Gambia', 'Gambia'),
1148(80, 1, 80, 'GEO', 'GE', 'Georgia', 'Georgien'),
1149(81, 1, 81, 'DEU', 'DE', 'Germany', 'Deutschland'),
1150(82, 1, 82, 'GHA', 'GH', 'Ghana', 'Ghana'),
1151(83, 1, 83, 'GIB', 'GI', 'Gibraltar', 'Gibraltar'),
1152(84, 1, 84, 'GRC', 'GR', 'Greece', 'Griechenland'),
1153(85, 1, 85, 'GRL', 'GL', 'Greenland', 'Grönland'),
1154(86, 1, 86, 'GRD', 'GD', 'Grenada', 'Grenada'),
1155(87, 1, 87, 'GLP', 'GP', 'Guadeloupe', 'Guadeloupe'),
1156(88, 1, 88, 'GUM', 'GU', 'Guam', 'Guam'),
1157(89, 1, 89, 'GTM', 'GT', 'Guatemala', 'Guatemala'),
1158(90, 1, 90, 'GIN', 'GN', 'Guinea', 'Guinea'),
1159(91, 1, 91, 'GNB', 'GW', 'Guinea-bissau', 'Guinea-Bissau'),
1160(92, 1, 92, 'GUY', 'GY', 'Guyana', 'Guyana'),
1161(93, 1, 93, 'HTI', 'HT', 'Haiti', 'Haiti'),
1162(94, 1, 94, 'HMD', 'HM', 'Heard and Mc Donald Islands', 'Heard und McDonaldinseln'),
1163(95, 1, 95, 'HND', 'HN', 'Honduras', 'Honduras'),
1164(96, 1, 96, 'HKG', 'HK', 'Hong Kong', 'Hong Kong'),
1165(97, 1, 97, 'HUN', 'HU', 'Hungary', 'Ungarn'),
1166(98, 1, 98, 'ISL', 'IS', 'Iceland', 'Island'),
1167(99, 1, 99, 'IND', 'IN', 'India', 'Indien'),
1168(100, 1, 100, 'IDN', 'ID', 'Indonesia', 'Indonesien'),
1169(101, 1, 101, 'IRN', 'IR', 'Iran (Islamic Republic of)', 'Iran'),
1170(102, 1, 102, 'IRQ', 'IQ', 'Iraq', 'Irak'),
1171(103, 1, 103, 'IRL', 'IE', 'Ireland', 'Irland'),
1172(104, 1, 104, 'ISR', 'IL', 'Israel', 'Israel'),
1173(105, 1, 105, 'ITA', 'IT', 'Italy', 'Italien'),
1174(106, 1, 106, 'JAM', 'JM', 'Jamaica', 'Jamaika'),
1175(107, 1, 107, 'JPN', 'JP', 'Japan', 'Japan'),
1176(108, 1, 108, 'JOR', 'JO', 'Jordan', 'Jordanien'),
1177(109, 1, 109, 'KAZ', 'KZ', 'Kazakhstan', 'Kasachstan'),
1178(110, 1, 110, 'KEN', 'KE', 'Kenya', 'Kenia'),
1179(111, 1, 111, 'KIR', 'KI', 'Kiribati', 'Kiribati'),
1180(112, 1, 112, 'PRK', 'KP', 'Korea Democratic People''s Republic of', 'Korea Demokratische Volksrepublik'),
1181(113, 1, 113, 'KOR', 'KR', 'Korea Republic of', 'Korea'),
1182(114, 1, 114, 'KWT', 'KW', 'Kuwait', 'Kuwait'),
1183(115, 1, 115, 'KGZ', 'KG', 'Kyrgyzstan', 'Kirgistan'),
1184(116, 1, 116, 'LAO', 'LA', 'Lao People''s Democratic Republic', 'Laos'),
1185(117, 1, 117, 'LVA', 'LV', 'Latvia', 'Lettland'),
1186(118, 1, 118, 'LBN', 'LB', 'Lebanon', 'Libanon'),
1187(119, 1, 119, 'LSO', 'LS', 'Lesotho', 'Lesotho'),
1188(120, 1, 120, 'LBR', 'LR', 'Liberia', 'Liberia'),
1189(121, 1, 121, 'LBY', 'LY', 'Libyan Arab Jamahiriya', 'Libyen'),
1190(122, 1, 122, 'LIE', 'LI', 'Liechtenstein', 'Liechtenstein'),
1191(123, 1, 123, 'LTU', 'LT', 'Lithuania', 'Litauen'),
1192(124, 1, 124, 'LUX', 'LU', 'Luxembourg', 'Luxemburg'),
1193(125, 1, 125, 'MAC', 'MO', 'Macau', 'Makao'),
1194(126, 1, 126, 'MKD', 'MK', 'Macedonia The Former Yugoslav Republic of', 'Mazedonien'),
1195(127, 1, 127, 'MDG', 'MG', 'Madagascar', 'Madagaskar'),
1196(128, 1, 128, 'MWI', 'MW', 'Malawi', 'Malawi'),
1197(129, 1, 129, 'MYS', 'MY', 'Malaysia', 'Malaysia'),
1198(130, 1, 130, 'MDV', 'MV', 'Maldives', 'Malediven'),
1199(131, 1, 131, 'MLI', 'ML', 'Mali', 'Mali'),
1200(132, 1, 132, 'MLT', 'MT', 'Malta', 'Malta'),
1201(133, 1, 133, 'MHL', 'MH', 'Marshall Islands', 'Marshallinseln'),
1202(134, 1, 134, 'MTQ', 'MQ', 'Martinique', 'Martinique'),
1203(135, 1, 135, 'MRT', 'MR', 'Mauritania', 'Mauretanien'),
1204(136, 1, 136, 'MUS', 'MU', 'Mauritius', 'Mauritius'),
1205(137, 1, 137, 'MYT', 'YT', 'Mayotte', 'Mayott'),
1206(138, 1, 138, 'MEX', 'MX', 'Mexico', 'Mexiko'),
1207(139, 1, 139, 'FSM', 'FM', 'Micronesia Federated States of', 'Mikronesien'),
1208(140, 1, 140, 'MDA', 'MD', 'Moldova Republic of', 'Moldawien'),
1209(141, 1, 141, 'MCO', 'MC', 'Monaco', 'Monaco'),
1210(142, 1, 142, 'MNG', 'MN', 'Mongolia', 'Mongolei'),
1211(143, 1, 143, 'MSR', 'MS', 'Montserrat', 'Montserrat'),
1212(144, 1, 144, 'MAR', 'MA', 'Morocco', 'Marokko'),
1213(145, 1, 145, 'MOZ', 'MZ', 'Mozambique', 'Mosambik'),
1214(146, 1, 146, 'MMR', 'MM', 'Myanmar', 'Myanmar'),
1215(147, 1, 147, 'NAM', 'NA', 'Namibia', 'Namibia'),
1216(148, 1, 148, 'NRU', 'NR', 'Nauru', 'Nauru'),
1217(149, 1, 149, 'NPL', 'NP', 'Nepal', 'Nepal'),
1218(150, 1, 150, 'NLD', 'NL', 'Netherlands', 'Niederlande'),
1219(151, 1, 151, 'ANT', 'AN', 'Netherlands Antilles', 'Niederländisch-Antillen'),
1220(152, 1, 152, 'NCL', 'NC', 'New Caledonia', 'Neukaledonien'),
1221(153, 1, 153, 'NZL', 'NZ', 'New Zealand', 'Neuseeland'),
1222(154, 1, 154, 'NIC', 'NI', 'Nicaragua', 'Nicaragua'),
1223(155, 1, 155, 'NER', 'NE', 'Niger', 'Niger'),
1224(156, 1, 156, 'NGA', 'NG', 'Nigeria', 'Nigeria'),
1225(157, 1, 157, 'NIU', 'NU', 'Niue', 'Niue'),
1226(158, 1, 158, 'NFK', 'NF', 'Norfolk Island', 'Norfolkinsel'),
1227(159, 1, 159, 'MNP', 'MP', 'Northern Mariana Islands', 'Nördliche Marianen'),
1228(160, 1, 160, 'NOR', 'NO', 'Norway', 'Norwegen'),
1229(161, 1, 161, 'OMN', 'OM', 'Oman', 'Oman'),
1230(162, 1, 162, 'PAK', 'PK', 'Pakistan', 'Pakistan'),
1231(163, 1, 163, 'PLW', 'PW', 'Palau', 'Palau'),
1232(164, 1, 164, 'PAN', 'PA', 'Panama', 'Panama'),
1233(165, 1, 165, 'PNG', 'PG', 'Papua New Guinea', 'Papua-Neuguinea'),
1234(166, 1, 166, 'PRY', 'PY', 'Paraguay', 'Paraguay'),
1235(167, 1, 167, 'PER', 'PE', 'Peru', 'Peru'),
1236(168, 1, 168, 'PHL', 'PH', 'Philippines', 'Philippinen'),
1237(169, 1, 169, 'PCN', 'PN', 'Pitcairn', 'Pitcairn'),
1238(170, 1, 170, 'POL', 'PL', 'Poland', 'Polen'),
1239(171, 1, 171, 'PRT', 'PT', 'Portugal', 'Portugal'),
1240(172, 1, 172, 'PRI', 'PR', 'Puerto Rico', 'Puerto Rico'),
1241(173, 1, 173, 'QAT', 'QA', 'Qatar', 'Katar'),
1242(174, 1, 174, 'REU', 'RE', 'Reunion', 'Reunion'),
1243(175, 1, 175, 'ROM', 'RO', 'Romania', 'Rumänien'),
1244(176, 1, 176, 'RUS', 'RU', 'Russian Federation', 'Russische Föderation'),
1245(177, 1, 177, 'RWA', 'RW', 'Rwanda', 'Ruanda'),
1246(178, 1, 178, 'KNA', 'KN', 'Saint Kitts and Nevis', 'St. Kitts und Nevis'),
1247(179, 1, 179, 'LCA', 'LC', 'Saint Lucia', 'St. Lucia'),
1248(180, 1, 180, 'VCT', 'VC', 'Saint Vincent and the Grenadines', 'St. Vincent und die Grenadinen'),
1249(181, 1, 181, 'WSM', 'WS', 'Samoa', 'Samoa'),
1250(182, 1, 182, 'SMR', 'SM', 'San Marino', 'San Marino'),
1251(183, 1, 183, 'STP', 'ST', 'Sao Tome and Principe', 'Sao Tomé und PrÃncipe'),
1252(184, 1, 184, 'SAU', 'SA', 'Saudi Arabia', 'Saudi-Arabien'),
1253(185, 1, 185, 'SEN', 'SN', 'Senegal', 'Senegal'),
1254(186, 1, 186, 'SYC', 'SC', 'Seychelles', 'Seychellen'),
1255(187, 1, 187, 'SLE', 'SL', 'Sierra Leone', 'Sierra Leone'),
1256(188, 1, 188, 'SGP', 'SG', 'Singapore', 'Singapur'),
1257(189, 1, 189, 'SVK', 'SK', 'Slovakia (Slovak Republic)', 'Slowakei'),
1258(190, 1, 190, 'SVN', 'SI', 'Slovenia', 'Slowenien'),
1259(191, 1, 191, 'SLB', 'SB', 'Solomon Islands', 'Salomonen'),
1260(192, 1, 192, 'SOM', 'SO', 'Somalia', 'Somalia'),
1261(193, 1, 193, 'ZAF', 'ZA', 'South Africa', 'Republik Südafrika'),
1262(194, 1, 194, 'SGS', 'GS', 'South Georgia and the South Sandwich Islands', 'Südgeorgien und die Südlichen Sandwichinseln'),
1263(195, 1, 195, 'ESP', 'ES', 'Spain', 'Spanien'),
1264(196, 1, 196, 'LKA', 'LK', 'Sri Lanka', 'Sri Lanka'),
1265(197, 1, 197, 'SHN', 'SH', 'St. Helena', 'St. Helena'),
1266(198, 1, 198, 'SPM', 'PM', 'St. Pierre and Miquelon', 'St. Pierre und Miquelon'),
1267(199, 1, 199, 'SDN', 'SD', 'Sudan', 'Sudan'),
1268(200, 1, 200, 'SUR', 'SR', 'Suriname', 'Suriname'),
1269(201, 1, 201, 'SJM', 'SJ', 'Svalbard and Jan Mayen Islands', 'Svalbard und Jan Mayen'),
1270(202, 1, 202, 'SWZ', 'SZ', 'Swaziland', 'Swasiland'),
1271(203, 1, 203, 'SWE', 'SE', 'Sweden', 'Schweden'),
1272(204, 1, 204, 'CHE', 'CH', 'Switzerland', 'Schweiz'),
1273(205, 1, 205, 'SYR', 'SY', 'Syrian Arab Republic', 'Syrien'),
1274(206, 1, 206, 'TWN', 'TW', 'Taiwan', 'Taiwan'),
1275(207, 1, 207, 'TJK', 'TJ', 'Tajikistan', 'Tadschikistan'),
1276(208, 1, 208, 'TZA', 'TZ', 'Tanzania United Republic of', 'Tansania'),
1277(209, 1, 209, 'THA', 'TH', 'Thailand', 'Thailand'),
1278(210, 1, 210, 'TGO', 'TG', 'Togo', 'Togo'),
1279(211, 1, 211, 'TKL', 'TK', 'Tokelau', 'Tokelau'),
1280(212, 1, 212, 'TON', 'TO', 'Tonga', 'Tonga'),
1281(213, 1, 213, 'TTO', 'TT', 'Trinidad and Tobago', 'Trinidad und Tobago'),
1282(214, 1, 214, 'TUN', 'TN', 'Tunisia', 'Tunesien'),
1283(215, 1, 215, 'TUR', 'TR', 'Turkey', 'Türkei'),
1284(216, 1, 216, 'TKM', 'TM', 'Turkmenistan', 'Turkmenistan'),
1285(217, 1, 217, 'TCA', 'TC', 'Turks and Caicos Islands', 'Turks- und Caicosinseln'),
1286(218, 1, 218, 'TUV', 'TV', 'Tuvalu', 'Tuvalu'),
1287(219, 1, 219, 'UGA', 'UG', 'Uganda', 'Uganda'),
1288(220, 1, 220, 'UKR', 'UA', 'Ukraine', 'Ukraine'),
1289(221, 1, 221, 'ARE', 'AE', 'United Arab Emirates', 'Vereinigte Arabische Emirate'),
1290(222, 1, 222, 'GBR', 'GB', 'United Kingdom', 'Vereinigtes Königreich'),
1291(223, 1, 223, 'USA', 'US', 'United States', 'USA'),
1292(224, 1, 224, 'UMI', 'UM', 'United States Minor Outlying Islands', 'United States Minor Outlying Islands'),
1293(225, 1, 225, 'URY', 'UY', 'Uruguay', 'Uruguay'),
1294(226, 1, 226, 'UZB', 'UZ', 'Uzbekistan', 'Usbekistan'),
1295(227, 1, 227, 'VUT', 'VU', 'Vanuatu', 'Vanuatu'),
1296(228, 1, 228, 'VAT', 'VA', 'Vatican City State (Holy See)', 'Vatikanstadt'),
1297(229, 1, 229, 'VEN', 'VE', 'Venezuela', 'Venezuela'),
1298(230, 1, 230, 'VNM', 'VN', 'Viet Nam', 'Vietnam'),
1299(231, 1, 231, 'VGB', 'VG', 'Virgin Islands (British)', 'Britische Jungferninseln'),
1300(232, 1, 232, 'VIR', 'VI', 'Virgin Islands (U.S.)', 'Vereinigte Staaten von Amerika'),
1301(233, 1, 233, 'WLF', 'WF', 'Wallis and Futuna Islands', 'Wallis und Futuna'),
1302(234, 1, 234, 'ESH', 'EH', 'Western Sahara', 'Westsahara'),
1303(235, 1, 235, 'YEM', 'YE', 'Yemen', 'Jemen'),
1304(236, 1, 236, 'YUG', 'YU', 'Yugoslavia', 'Yugoslavia'),
1305(237, 1, 237, 'ZAR', 'ZR', 'Zaire', 'Zaire'),
1306(238, 1, 238, 'ZMB', 'ZM', 'Zambia', 'Sambia'),
1307(239, 1, 239, 'ZWE', 'ZW', 'Zimbabwe', 'Simbabwe');
1308
1309INSERT INTO `zb9l1_jshopping_unit` (`id`, `qty`, `name_de-DE`, `name_en-GB`) values(1, 1, 'Kg', 'Kg'),(2, 1, 'Liter', 'Liter'),(3, 1, 'St.', 'pcs.');
1310
1311INSERT INTO `zb9l1_jshopping_product_labels` (`id`, `name`, `name_de-DE`, `name_en-GB`, `image`) VALUES(1, 'New', 'New', 'New', 'new.png'), (2, 'Sale', 'Sale', 'Sale', 'sale.png');
1312
1313INSERT INTO `zb9l1_jshopping_import_export` (`id`, `name`, `alias`, `description`, `params`, `endstart`, `steptime`) VALUES
1314(1, 'Simple Export', 'simpleexport', 'Simple Export in CSV iso-8859-1', 'filename=export', 0, 1), (2, 'Simple Import', 'simpleimport', 'Simple Import in CSV iso-8859-1', '', 0, 0);
1315
1316INSERT INTO `zb9l1_jshopping_config` (`id`, `count_products_to_page`, `count_products_to_row`, `count_category_to_row`, `image_category_width`, `image_category_height`, `image_product_width`, `image_product_height`, `image_product_full_width`, `image_product_full_height`, `video_product_width`, `video_product_height`, `mainCurrency`, `decimal_count`, `decimal_symbol`, `thousand_separator`, `currency_format`, `use_rabatt_code`, `enable_wishlist`, `default_status_order`,
1317`store_address_format`, `store_date_format`, `contact_email`,
1318`allow_reviews_prod`, `allow_reviews_only_registered`, `allow_reviews_manuf`,`max_mark` , `summ_null_shipping`, `without_shipping`, `pdf_parameters`, `show_buy_in_category`, `hide_buy_not_avaible_stock`, `show_sort_product`, `show_count_select_products`, `order_send_pdf_client`,
1319`admin_show_attributes`, `admin_show_delivery_time`, `admin_show_languages`, `use_different_templates_cat_prod`, `admin_show_product_video`, `admin_show_product_related`, `admin_show_product_files`, `admin_show_product_bay_price`, `admin_show_product_labels`,`show_product_code`,`product_count_related_in_row`, `next_order_number`, `sorting_country_in_alphabet`, `main_unit_weight`,
1320`savelog`,`savelogpaymentdata`,
1321`fields_register`)
1322VALUES (1, 12, 3, 1, 160, 0, 100, 0, 200, 0, 320, 240, '1', 2, '.', '', 2, 1, 1, 1,
1323'%storename %address %city %zip', '%d.%m.%Y', 'test@test.com',
1324'1', '1', '0', '10', '-1', 0, '208:65:208:30', 1, 1, 1, 1, 1,
13251, 1, 1, 0, 1, 1, 1, 0, 1, 1, 3, 1, 1, 1,
13261, 1,
1327'a:3:{s:8:"register";a:15:{s:5:"title";a:2:{s:7:"display";s:1:"1";s:7:"require";s:1:"1";}s:6:"l_name";a:2:{s:7:"display";s:1:"1";s:7:"require";s:1:"1";}s:10:"firma_name";a:1:{s:7:"display";s:1:"1";}s:6:"street";a:2:{s:7:"display";s:1:"1";s:7:"require";s:1:"1";}s:3:"zip";a:2:{s:7:"display";s:1:"1";s:7:"require";s:1:"1";}s:4:"city";a:2:{s:7:"display";s:1:"1";s:7:"require";s:1:"1";}s:5:"state";a:1:{s:7:"display";s:1:"1";}s:7:"country";a:2:{s:7:"display";s:1:"1";s:7:"require";s:1:"1";}s:5:"phone";a:2:{s:7:"display";s:1:"1";s:7:"require";s:1:"1";}s:3:"fax";a:1:{s:7:"display";s:1:"1";}s:6:"f_name";a:2:{s:7:"require";i:1;s:7:"display";i:1;}s:5:"email";a:2:{s:7:"require";i:1;s:7:"display";i:1;}s:6:"u_name";a:2:{s:7:"require";i:1;s:7:"display";i:1;}s:8:"password";a:2:{s:7:"require";i:1;s:7:"display";i:1;}s:10:"password_2";a:2:{s:7:"require";i:1;s:7:"display";i:1;}}s:7:"address";a:22:{s:5:"title";a:2:{s:7:"display";s:1:"1";s:7:"require";s:1:"1";}s:6:"l_name";a:2:{s:7:"display";s:1:"1";s:7:"require";s:1:"1";}s:10:"firma_name";a:1:{s:7:"display";s:1:"1";}s:6:"street";a:2:{s:7:"display";s:1:"1";s:7:"require";s:1:"1";}s:3:"zip";a:2:{s:7:"display";s:1:"1";s:7:"require";s:1:"1";}s:4:"city";a:2:{s:7:"display";s:1:"1";s:7:"require";s:1:"1";}s:5:"state";a:1:{s:7:"display";s:1:"1";}s:7:"country";a:2:{s:7:"display";s:1:"1";s:7:"require";s:1:"1";}s:5:"phone";a:2:{s:7:"display";s:1:"1";s:7:"require";s:1:"1";}s:3:"fax";a:1:{s:7:"display";s:1:"1";}s:7:"d_title";a:2:{s:7:"display";s:1:"1";s:7:"require";s:1:"1";}s:8:"d_f_name";a:2:{s:7:"display";s:1:"1";s:7:"require";s:1:"1";}s:8:"d_l_name";a:2:{s:7:"display";s:1:"1";s:7:"require";s:1:"1";}s:12:"d_firma_name";a:1:{s:7:"display";s:1:"1";}s:8:"d_street";a:2:{s:7:"display";s:1:"1";s:7:"require";s:1:"1";}s:5:"d_zip";a:2:{s:7:"display";s:1:"1";s:7:"require";s:1:"1";}s:6:"d_city";a:2:{s:7:"display";s:1:"1";s:7:"require";s:1:"1";}s:7:"d_state";a:1:{s:7:"display";s:1:"1";}s:9:"d_country";a:2:{s:7:"display";s:1:"1";s:7:"require";s:1:"1";}s:7:"d_phone";a:2:{s:7:"display";s:1:"1";s:7:"require";s:1:"1";}s:6:"f_name";a:2:{s:7:"require";i:1;s:7:"display";i:1;}s:5:"email";a:2:{s:7:"require";i:1;s:7:"display";i:1;}}s:11:"editaccount";a:22:{s:5:"title";a:2:{s:7:"display";s:1:"1";s:7:"require";s:1:"1";}s:6:"l_name";a:2:{s:7:"display";s:1:"1";s:7:"require";s:1:"1";}s:10:"firma_name";a:1:{s:7:"display";s:1:"1";}s:6:"street";a:2:{s:7:"display";s:1:"1";s:7:"require";s:1:"1";}s:3:"zip";a:2:{s:7:"display";s:1:"1";s:7:"require";s:1:"1";}s:4:"city";a:2:{s:7:"display";s:1:"1";s:7:"require";s:1:"1";}s:5:"state";a:1:{s:7:"display";s:1:"1";}s:7:"country";a:2:{s:7:"display";s:1:"1";s:7:"require";s:1:"1";}s:5:"phone";a:2:{s:7:"display";s:1:"1";s:7:"require";s:1:"1";}s:3:"fax";a:1:{s:7:"display";s:1:"1";}s:7:"d_title";a:2:{s:7:"display";s:1:"1";s:7:"require";s:1:"1";}s:8:"d_f_name";a:2:{s:7:"display";s:1:"1";s:7:"require";s:1:"1";}s:8:"d_l_name";a:2:{s:7:"display";s:1:"1";s:7:"require";s:1:"1";}s:12:"d_firma_name";a:1:{s:7:"display";s:1:"1";}s:8:"d_street";a:2:{s:7:"display";s:1:"1";s:7:"require";s:1:"1";}s:5:"d_zip";a:2:{s:7:"display";s:1:"1";s:7:"require";s:1:"1";}s:6:"d_city";a:2:{s:7:"display";s:1:"1";s:7:"require";s:1:"1";}s:7:"d_state";a:1:{s:7:"display";s:1:"1";}s:9:"d_country";a:2:{s:7:"display";s:1:"1";s:7:"require";s:1:"1";}s:7:"d_phone";a:2:{s:7:"display";s:1:"1";s:7:"require";s:1:"1";}s:6:"f_name";a:2:{s:7:"require";i:1;s:7:"display";i:1;}s:5:"email";a:2:{s:7:"require";i:1;s:7:"display";i:1;}}}');
1328
1329INSERT INTO `zb9l1_jshopping_currencies` ( `currency_id` , `currency_name` , `currency_code`, `currency_code_iso`, `currency_code_num` , `currency_ordering` , `currency_publish` , `currency_value` ) VALUES ( NULL , 'Euro', 'EUR', 'EUR', '978', '1', '1', '1.00');
1330
1331INSERT INTO `zb9l1_jshopping_order_status` (`status_id`, `status_code`, `name_en-GB`, `name_de-DE`) VALUES (1, 'P', 'Pending', 'Offen'),(2, 'C', 'Confirmed', 'Bestätigt'),(3, 'X', 'Cancelled', 'Abgebrochen'),(4, 'R', 'Refunded', 'Gutschrift'),(5, 'S', 'Shipped', 'Gesendet'),(6, 'O', 'Paid', 'Bezahlt'),(7, 'F', 'Complete', 'Abgeschlossen');
1332
1333 INSERT INTO `zb9l1_jshopping_payment_method` (`payment_id`, `name_en-GB`, `name_de-DE`, `description_en-GB`, `description_de-DE`, `payment_code`, `payment_class`, `scriptname`, `payment_publish`, `payment_ordering`, `payment_params`, `payment_type`, `tax_id`, `price`, `show_descr_in_email`) VALUES
1334(1, 'Cash on delivery', 'Nachnahme', '', '', 'bank', 'pm_bank', '', 1, 1, '', 1, 1, 4.00, 0),
1335(2, 'Advance payment', 'Vorauskasse', '', '', 'PO', 'pm_purchase_order', '', 1, 2, '', 1, 1, 0, 1),
1336(3, 'Paypal', 'Paypal', '', '', 'paypal', 'pm_paypal', 'pm_paypal', 1, 3, 'testmode=1\n email_received=test@testing.com\n transaction_end_status=6\n transaction_pending_status=1\n transaction_failed_status=3\n checkdatareturn=0', 2, 1, 0, 0),
1337(4, 'Debit', 'Lastschrift', 'Please insert your bankdata.', 'Bitte tragen Sie hier Ihre Bankdaten fГјr den Abbuchungsauftrag ein.', 'debit', 'pm_debit', 'pm_debit', 1, 4, '', 1, 1, 0, 0),
1338(5, 'Sofortueberweisung','Sofortueberweisung', '', '', 'ST','pm_sofortueberweisung', 'pm_sofortueberweisung', 0, 5, 'user_id=00000\nproject_id=00000\nproject_password=00000\ntransaction_end_status=6\ntransaction_pending_status=1\ntransaction_failed_status=3\n', 2, 1, 0, 0);
1339
1340INSERT INTO `zb9l1_jshopping_shipping_method` ( `shipping_id` , `name_en-GB` , `name_de-DE` , `published` , `ordering`) VALUES (1 , 'Standard', 'Standardversand', '1', '1'),(2 , 'Express', 'Express', '1', '2');
1341
1342INSERT INTO `zb9l1_jshopping_taxes` ( `tax_id` , `tax_name` , `tax_value` ) VALUES (1, 'Normal', '19%');
1343
1344INSERT INTO `zb9l1_jshopping_shipping_method_price` VALUES (1, 1, 1, 10.00, 1, 0, 0, ''),(2, 2, 1, 25.00, 1, 0, 0, '');
1345
1346INSERT INTO `zb9l1_jshopping_shipping_method_price_countries` VALUES (1, 239, 1), (2, 238, 1), (3, 237, 1), (4, 236, 1), (5, 235, 1), (6, 234, 1), (7, 233, 1), (8, 232, 1), (9, 231, 1), (10, 230, 1), (11, 229, 1), (12, 228, 1), (13, 227, 1), (14, 226, 1), (15, 225, 1), (16, 224, 1), (17, 223, 1), (18, 222, 1), (19, 221, 1), (20, 220, 1), (21, 219, 1), (22, 218, 1), (23, 217, 1), (24, 216, 1), (25, 215, 1), (26, 214, 1), (27, 213, 1), (28, 212, 1), (29, 211, 1), (30, 210, 1), (31, 209, 1), (32, 208, 1), (33, 207, 1), (34, 206, 1), (35, 205, 1), (36, 204, 1), (37, 203, 1), (38, 202, 1), (39, 201, 1), (40, 200, 1), (41, 199, 1), (42, 198, 1), (43, 197, 1), (44, 196, 1), (45, 195, 1), (46, 194, 1), (47, 193, 1), (48, 192, 1), (49, 191, 1), (50, 190, 1), (51, 189, 1), (52, 188, 1), (53, 187, 1), (54, 186, 1), (55, 185, 1), (56, 184, 1), (57, 183, 1), (58, 182, 1), (59, 181, 1), (60, 180, 1), (61, 179, 1), (62, 178, 1), (63, 177, 1), (64, 176, 1), (65, 175, 1), (66, 174, 1), (67, 173, 1), (68, 172, 1), (69, 171, 1), (70, 170, 1), (71, 169, 1), (72, 168, 1), (73, 167, 1), (74, 166, 1), (75, 165, 1), (76, 164, 1), (77, 163, 1), (78, 162, 1), (79, 161, 1), (80, 160, 1), (81, 159, 1), (82, 158, 1), (83, 157, 1), (84, 156, 1), (85, 155, 1), (86, 154, 1), (87, 153, 1), (88, 152, 1), (89, 151, 1), (90, 150, 1), (91, 149, 1), (92, 148, 1), (93, 147, 1), (94, 146, 1), (95, 145, 1), (96, 144, 1), (97, 143, 1), (98, 142, 1), (99, 141, 1), (100, 140, 1), (101, 139, 1), (102, 138, 1), (103, 137, 1), (104, 136, 1), (105, 135, 1), (106, 134, 1), (107, 133, 1), (108, 132, 1), (109, 131, 1), (110, 130, 1), (111, 129, 1), (112, 128, 1), (113, 127, 1), (114, 126, 1), (115, 125, 1), (116, 124, 1), (117, 123, 1), (118, 122, 1), (119, 121, 1), (120, 120, 1), (121, 119, 1), (122, 118, 1), (123, 117, 1), (124, 116, 1), (125, 115, 1), (126, 114, 1), (127, 113, 1), (128, 112, 1), (129, 111, 1), (130, 110, 1), (131, 109, 1), (132, 108, 1), (133, 107, 1), (134, 106, 1), (135, 105, 1), (136, 104, 1), (137, 103, 1), (138, 102, 1), (139, 101, 1), (140, 100, 1), (141, 99, 1), (142, 98, 1), (143, 97, 1), (144, 96, 1), (145, 95, 1), (146, 94, 1), (147, 93, 1), (148, 92, 1), (149, 91, 1), (150, 90, 1), (151, 89, 1), (152, 88, 1), (153, 87, 1), (154, 86, 1), (155, 85, 1), (156, 84, 1), (157, 83, 1), (158, 82, 1), (159, 81, 1), (160, 80, 1), (161, 79, 1), (162, 78, 1), (163, 77, 1), (164, 76, 1), (165, 75, 1), (166, 74, 1), (167, 73, 1), (168, 72, 1), (169, 71, 1), (170, 70, 1), (171, 69, 1), (172, 68, 1), (173, 67, 1), (174, 66, 1), (175, 65, 1), (176, 64, 1), (177, 63, 1), (178, 62, 1), (179, 61, 1), (180, 60, 1), (181, 59, 1), (182, 58, 1), (183, 57, 1), (184, 56, 1), (185, 55, 1), (186, 54, 1), (187, 53, 1), (188, 52, 1), (189, 51, 1), (190, 50, 1), (191, 49, 1), (192, 48, 1), (193, 47, 1), (194, 46, 1), (195, 45, 1), (196, 44, 1), (197, 43, 1), (198, 42, 1), (199, 41, 1), (200, 40, 1), (201, 39, 1), (202, 38, 1), (203, 37, 1), (204, 36, 1), (205, 35, 1), (206, 34, 1), (207, 33, 1), (208, 32, 1), (209, 31, 1), (210, 30, 1), (211, 29, 1), (212, 28, 1), (213, 27, 1), (214, 26, 1), (215, 25, 1), (216, 24, 1), (217, 23, 1), (218, 22, 1), (219, 21, 1), (220, 20, 1), (221, 19, 1), (222, 18, 1), (223, 17, 1), (224, 16, 1), (225, 15, 1), (226, 14, 1), (227, 13, 1), (228, 12, 1), (229, 11, 1), (230, 10, 1), (231, 9, 1), (232, 8, 1), (233, 7, 1), (234, 6, 1), (235, 5, 1), (236, 4, 1), (237, 3, 1), (238, 2, 1), (239, 1, 1), (240, 239, 2), (241, 238, 2), (242, 237, 2), (243, 236, 2), (244, 235, 2), (245, 234, 2), (246, 233, 2), (247, 232, 2), (248, 231, 2), (249, 230, 2), (250, 229, 2), (251, 228, 2), (252, 227, 2), (253, 226, 2), (254, 225, 2), (255, 224, 2), (256, 223, 2), (257, 222, 2), (258, 221, 2), (259, 220, 2), (260, 219, 2), (261, 218, 2), (262, 217, 2), (263, 216, 2), (264, 215, 2), (265, 214, 2), (266, 213, 2), (267, 212, 2), (268, 211, 2), (269, 210, 2), (270, 209, 2), (271, 208, 2), (272, 207, 2), (273, 206, 2), (274, 205, 2), (275, 204, 2), (276, 203, 2), (277, 202, 2), (278, 201, 2), (279, 200, 2), (280, 199, 2), (281, 198, 2), (282, 197, 2), (283, 196, 2), (284, 195, 2), (285, 194, 2), (286, 193, 2), (287, 192, 2), (288, 191, 2), (289, 190, 2), (290, 189, 2), (291, 188, 2), (292, 187, 2), (293, 186, 2), (294, 185, 2), (295, 184, 2), (296, 183, 2), (297, 182, 2), (298, 181, 2), (299, 180, 2), (300, 179, 2), (301, 178, 2), (302, 177, 2), (303, 176, 2), (304, 175, 2), (305, 174, 2), (306, 173, 2), (307, 172, 2), (308, 171, 2), (309, 170, 2), (310, 169, 2), (311, 168, 2), (312, 167, 2), (313, 166, 2), (314, 165, 2), (315, 164, 2), (316, 163, 2), (317, 162, 2), (318, 161, 2), (319, 160, 2), (320, 159, 2), (321, 158, 2), (322, 157, 2), (323, 156, 2), (324, 155, 2), (325, 154, 2), (326, 153, 2), (327, 152, 2), (328, 151, 2), (329, 150, 2), (330, 149, 2), (331, 148, 2), (332, 147, 2), (333, 146, 2), (334, 145, 2), (335, 144, 2), (336, 143, 2), (337, 142, 2), (338, 141, 2), (339, 140, 2), (340, 139, 2), (341, 138, 2), (342, 137, 2), (343, 136, 2), (344, 135, 2), (345, 134, 2), (346, 133, 2), (347, 132, 2), (348, 131, 2), (349, 130, 2), (350, 129, 2), (351, 128, 2), (352, 127, 2), (353, 126, 2), (354, 125, 2), (355, 124, 2), (356, 123, 2), (357, 122, 2), (358, 121, 2), (359, 120, 2), (360, 119, 2), (361, 118, 2), (362, 117, 2), (363, 116, 2), (364, 115, 2), (365, 114, 2), (366, 113, 2), (367, 112, 2), (368, 111, 2), (369, 110, 2), (370, 109, 2), (371, 108, 2), (372, 107, 2), (373, 106, 2), (374, 105, 2), (375, 104, 2), (376, 103, 2), (377, 102, 2), (378, 101, 2), (379, 100, 2), (380, 99, 2), (381, 98, 2), (382, 97, 2), (383, 96, 2), (384, 95, 2), (385, 94, 2), (386, 93, 2), (387, 92, 2), (388, 91, 2), (389, 90, 2), (390, 89, 2), (391, 88, 2), (392, 87, 2), (393, 86, 2), (394, 85, 2), (395, 84, 2), (396, 83, 2), (397, 82, 2), (398, 81, 2), (399, 80, 2), (400, 79, 2), (401, 78, 2), (402, 77, 2), (403, 76, 2), (404, 75, 2), (405, 74, 2), (406, 73, 2), (407, 72, 2), (408, 71, 2), (409, 70, 2), (410, 69, 2), (411, 68, 2), (412, 67, 2), (413, 66, 2), (414, 65, 2), (415, 64, 2), (416, 63, 2), (417, 62, 2), (418, 61, 2), (419, 60, 2), (420, 59, 2), (421, 58, 2), (422, 57, 2), (423, 56, 2), (424, 55, 2), (425, 54, 2), (426, 53, 2), (427, 52, 2), (428, 51, 2), (429, 50, 2), (430, 49, 2), (431, 48, 2), (432, 47, 2), (433, 46, 2), (434, 45, 2), (435, 44, 2), (436, 43, 2), (437, 42, 2), (438, 41, 2), (439, 40, 2), (440, 39, 2), (441, 38, 2), (442, 37, 2), (443, 36, 2), (444, 35, 2), (445, 34, 2), (446, 33, 2), (447, 32, 2), (448, 31, 2), (449, 30, 2), (450, 29, 2), (451, 28, 2), (452, 27, 2), (453, 26, 2), (454, 25, 2), (455, 24, 2), (456, 23, 2), (457, 22, 2), (458, 21, 2), (459, 20, 2), (460, 19, 2), (461, 18, 2), (462, 17, 2), (463, 16, 2), (464, 15, 2), (465, 14, 2), (466, 13, 2), (467, 12, 2), (468, 11, 2), (469, 10, 2), (470, 9, 2), (471, 8, 2), (472, 7, 2), (473, 6, 2), (474, 5, 2), (475, 4, 2), (476, 3, 2), (477, 2, 2), (478, 1, 2);
1347
1348INSERT INTO `zb9l1_jshopping_shipping_ext_calc` (`id`, `name`, `alias`, `description`, `params`, `shipping_method`, `published`, `ordering`) VALUES (1, 'StandartWeight', 'sm_standart_weight', 'StandartWeight', '', '', 1, 1);
1349
1350INSERT INTO `zb9l1_jshopping_usergroups` VALUES (1 , 'Default', '0.00', 'Default', 1, 'Default', 'Default');
1351
1352INSERT INTO `zb9l1_jshopping_config_seo` (`alias`, `ordering`) VALUES ('category', 10),('manufacturers', 20), ('cart', 30), ('wishlist', 40), ('login', 50), ('register', 60), ('editaccount', 70), ('myorders', 80), ('myaccount', 90), ('search', 100), ('search-result', 110), ('myorder-detail', 120), ('vendors', 130),('content-agb', 140),('content-return_policy', 150),('content-shipping', 160),('content-privacy_statement',161),('checkout-address', 170),('checkout-payment', 180),('checkout-shipping', 190),('checkout-preview', 200),('lastproducts', 210),('randomproducts', 220),('bestsellerproducts', 230),('labelproducts', 240),('topratingproducts', 250),('tophitsproducts', 260),('all-products', 270);
1353
1354INSERT INTO `zb9l1_jshopping_config_statictext` (`alias`) VALUES ('home'),('manufacturer'),('agb'),('return_policy'),('order_email_descr'),('order_email_descr_end'),('order_finish_descr'),('shipping'),('privacy_statement'),('cart'),('order_email_descr_manually');
1355
1356INSERT INTO `zb9l1_jshopping_vendors` (`id`, `shop_name`, `company_name`, `url`, `logo`, `adress`, `city`, `zip`, `state`, `country`, `f_name`, `l_name`, `middlename`, `phone`, `fax`, `email`, `benef_bank_info`, `benef_bic`, `benef_conto`, `benef_payee`, `benef_iban`, `benef_swift`, `interm_name`, `interm_swift`, `identification_number`, `tax_number`, `additional_information`, `user_id`, `main`, `publish`) VALUES
1357(1, 'Shop name', 'Company', '', '', 'Address', 'City', 'Postal Code ', 'State', 81, 'First name ', 'Last name', '', '00000000', '00000000', 'email@email.com', 'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test', '', '', 'Additional information', 0, 1, 1);