INSERT INTO `jos_components` VALUES (178,'VirtueMart RE','option=com_virtuemart',0,0,'option=com_virtuemart','VirtueMart RE','com_virtuemart',0,'../administrator/components/com_virtuemart/favicon.ico',0,''); INSERT INTO `jos_components` VALUES (179,'virtuemart_version','',0,9999,'','','',0,'',0,'RELEASE=1.0.12.1\nDEV_STATUS=stable'); INSERT INTO `jos_mambots` VALUES (21,'RusVirtuemart поисковый плагин','virtuemart.searchbot','search',0,0,0,0,0,0,'0000-00-00 00:00:00',''); INSERT INTO `jos_modules` VALUES (34,'Ваша корзина','',1,'vm_basket',0,'0000-00-00 00:00:00',1,'mod_virtuemart_cart',0,0,1,'moduleclass_sfx=\nclass_sfx=',0,0); INSERT INTO `jos_modules` VALUES (35,'Товары Лучший выбор','',1,'vm_ftrprod',0,'0000-00-00 00:00:00',1,'mod_virtuemart_featureprod',0,0,0,'max_items=2\nshow_price=1\nshow_addtocart=1\ndisplay_style=vertical\nproducts_per_row=4\ncategory_id=\nmoduleclass_sfx=\nclass_sfx=',0,0); INSERT INTO `jos_modules` VALUES (36,'Последние поступления','',12,'left',0,'0000-00-00 00:00:00',0,'mod_virtuemart_latestprod',0,0,1,'',0,0); INSERT INTO `jos_modules` VALUES (37,'Модуль Производители','',13,'left',0,'0000-00-00 00:00:00',0,'mod_virtuemart_manufacturers',0,0,1,'',0,0); INSERT INTO `jos_modules` VALUES (38,'RusVirtueMart Десять лучших товаров','',1,'vm_topten',0,'0000-00-00 00:00:00',1,'mod_virtuemart_topten',0,0,0,'num_topsellers=10\nmoduleclass_sfx=\nclass_sfx=',0,0); INSERT INTO `jos_modules` VALUES (39,'Главный модуль RusVirtueMart','',14,'left',0,'0000-00-00 00:00:00',0,'mod_virtuemart',0,0,1,'',0,0); INSERT INTO `jos_modules` VALUES (40,'Модуль категорий товаров','',1,'vm_cat',0,'0000-00-00 00:00:00',1,'mod_product_categories',0,0,0,'menutype=links\njscook_type=menu\njscookMenu_style=ThemeOffice\nmenu_orientation=vbr\njscookTree_style=ThemeXP\nroot_label=Магазин\nmoduleclass_sfx=\nclass_sfx=',0,0); INSERT INTO `jos_modules` VALUES (41,'Меню магазина','',1,'vm_top',0,'0000-00-00 00:00:00',1,'mod_mainmenu',0,0,0,'class_sfx=\nmoduleclass_sfx=\nmenutype=vm_topmenu\nmenu_style=horiz_flat\nfull_active_id=0\ncache=0\nmenu_images=0\nmenu_images_align=0\nexpand_menu=0\nactivate_parent=0\nindent_image=0\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=\nspacer=\nend_spacer=',0,0); INSERT INTO `jos_modules` VALUES (42,'Авторизация','',1,'vm_auth',0,'0000-00-00 00:00:00',1,'mod_login',0,0,1,'moduleclass_sfx=\npretext=\nposttext=\nlogin=\nlogout=\nlogin_message=0\nlogout_message=0\ngreeting=1\nname=0',1,0); INSERT INTO `jos_modules` VALUES (43,'Поиск','',1,'vm_search',0,'0000-00-00 00:00:00',1,'mod_search',0,0,0,'moduleclass_sfx=\ncache=0\nset_itemid=\nwidth=20\ntext=\nbutton=\nbutton_pos=right\nbutton_text=',0,0); INSERT INTO `jos_modules_menu` VALUES (34,0); INSERT INTO `jos_modules_menu` VALUES (35,0); INSERT INTO `jos_modules_menu` VALUES (36,0); INSERT INTO `jos_modules_menu` VALUES (37,0); INSERT INTO `jos_modules_menu` VALUES (38,0); INSERT INTO `jos_modules_menu` VALUES (39,0); INSERT INTO `jos_modules_menu` VALUES (40,0); INSERT INTO `jos_modules_menu` VALUES (41,0); INSERT INTO `jos_modules_menu` VALUES (42,0); INSERT INTO `jos_modules_menu` VALUES (43,0); INSERT INTO `jos_menu` VALUES ('','vm_topmenu','О магазине','index.php?option=com_content&task=view&id=12','content_typed',1,0,12,0,1,0,'0000-00-00 00:00:00',0,0,0,0,''); INSERT INTO `jos_menu` VALUES ('','vm_topmenu','Оплата','index.php?option=com_content&task=view&id=13','content_typed',1,0,13,0,3,0,'0000-00-00 00:00:00',0,0,0,0,''); INSERT INTO `jos_menu` VALUES ('','vm_topmenu','Доставка','index.php?option=com_content&task=view&id=14','content_typed',1,0,14,0,4,0,'0000-00-00 00:00:00',0,0,0,0,''); INSERT INTO `jos_menu` VALUES ('','vm_topmenu','Контакты','index.php?option=com_content&task=view&id=15','content_typed',1,0,15,0,5,0,'0000-00-00 00:00:00',0,0,0,0,''); INSERT INTO `jos_menu` VALUES ('','vm_topmenu','Каталог','index.php?option=com_virtuemart','components',1,0,19,0,2,0,'0000-00-00 00:00:00',0,0,0,0,''); INSERT INTO jos_templates_menu (template, menuid, client_id) SELECT 'ru-center_ishop', id, '0' from jos_menu where `name` = 'Каталог' and `link` = 'index.php?option=com_virtuemart' and menutype = 'vm_topmenu'; INSERT INTO `jos_template_positions` VALUES ('','vm_basket','Корзина товаров VirtueMart'); INSERT INTO `jos_template_positions` VALUES ('','vm_search','Поиск'); INSERT INTO `jos_template_positions` VALUES ('','vm_cat','Список категорий товаров VirtueMart'); INSERT INTO `jos_template_positions` VALUES ('','vm_auth','Авторизация'); INSERT INTO `jos_template_positions` VALUES ('','vm_topten','Десять лучших товаров'); INSERT INTO `jos_template_positions` VALUES ('','vm_ftrprod','Спецпредложения'); INSERT INTO `jos_template_positions` VALUES ('','vm_top','Верхнее меню VirtueMart'); DROP TABLE IF EXISTS `jos_vm_affiliate`; CREATE TABLE `jos_vm_affiliate` ( `affiliate_id` int(11) NOT NULL auto_increment, `user_id` int(11) NOT NULL default '0', `active` char(1) NOT NULL default 'N', `rate` int(11) NOT NULL default '0', PRIMARY KEY (`affiliate_id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COMMENT='Используется для хранения запис'; -- -- Dumping data for table `jos_vm_affiliate` -- LOCK TABLES `jos_vm_affiliate` WRITE; /*!40000 ALTER TABLE `jos_vm_affiliate` DISABLE KEYS */; /*!40000 ALTER TABLE `jos_vm_affiliate` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jos_vm_affiliate_sale` -- DROP TABLE IF EXISTS `jos_vm_affiliate_sale`; CREATE TABLE `jos_vm_affiliate_sale` ( `order_id` int(11) NOT NULL default '0', `visit_id` varchar(32) NOT NULL default '', `affiliate_id` int(11) NOT NULL default '0', `rate` int(2) NOT NULL default '0', PRIMARY KEY (`order_id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COMMENT='Заказы по партнерке '; -- -- Dumping data for table `jos_vm_affiliate_sale` -- LOCK TABLES `jos_vm_affiliate_sale` WRITE; /*!40000 ALTER TABLE `jos_vm_affiliate_sale` DISABLE KEYS */; /*!40000 ALTER TABLE `jos_vm_affiliate_sale` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jos_vm_auth_user_vendor` -- DROP TABLE IF EXISTS `jos_vm_auth_user_vendor`; CREATE TABLE `jos_vm_auth_user_vendor` ( `user_id` int(11) default NULL, `vendor_id` int(11) default NULL, KEY `idx_auth_user_vendor_user_id` (`user_id`), KEY `idx_auth_user_vendor_vendor_id` (`vendor_id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COMMENT='Продавец-пользователь'; -- -- Dumping data for table `jos_vm_auth_user_vendor` -- LOCK TABLES `jos_vm_auth_user_vendor` WRITE; /*!40000 ALTER TABLE `jos_vm_auth_user_vendor` DISABLE KEYS */; INSERT INTO `jos_vm_auth_user_vendor` VALUES (62,1); /*!40000 ALTER TABLE `jos_vm_auth_user_vendor` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jos_vm_category` -- DROP TABLE IF EXISTS `jos_vm_category`; CREATE TABLE `jos_vm_category` ( `category_id` int(11) NOT NULL auto_increment, `vendor_id` int(11) NOT NULL default '0', `category_name` varchar(128) NOT NULL default '', `category_description` text, `category_thumb_image` varchar(255) default NULL, `category_full_image` varchar(255) default NULL, `category_publish` char(1) default NULL, `cdate` int(11) default NULL, `mdate` int(11) default NULL, `category_browsepage` varchar(255) NOT NULL default 'browse_1', `products_per_row` tinyint(2) NOT NULL default '1', `category_flypage` varchar(255) NOT NULL default '', `list_order` int(11) NOT NULL default '0', PRIMARY KEY (`category_id`), KEY `idx_category_vendor_id` (`vendor_id`), KEY `idx_category_name` (`category_name`) ) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=cp1251 COMMENT='Категории товаров хранятся здес'; -- -- Dumping data for table `jos_vm_category` -- LOCK TABLES `jos_vm_category` WRITE; /*!40000 ALTER TABLE `jos_vm_category` DISABLE KEYS */; INSERT INTO `jos_vm_category` VALUES (13,1,'Роликовые коньки','','','','Y',1196079357,1198059068,'browse_1',2,'shop.flypage',2); INSERT INTO `jos_vm_category` VALUES (14,1,'Велосипеды','','','','Y',1196079375,1198059075,'browse_1',2,'shop.flypage',3); INSERT INTO `jos_vm_category` VALUES (12,1,'Горные лыжи','','','','Y',1196079308,1198059061,'browse_1',2,'shop.flypage',1); /*!40000 ALTER TABLE `jos_vm_category` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jos_vm_category_xref` -- DROP TABLE IF EXISTS `jos_vm_category_xref`; CREATE TABLE `jos_vm_category_xref` ( `category_parent_id` int(11) NOT NULL default '0', `category_child_id` int(11) NOT NULL default '0', `category_list` int(11) default NULL, KEY `category_xref_category_parent_id` (`category_parent_id`), KEY `category_xref_category_child_id` (`category_child_id`), KEY `idx_category_xref_category_list` (`category_list`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COMMENT='Связи между категориями'; -- -- Dumping data for table `jos_vm_category_xref` -- LOCK TABLES `jos_vm_category_xref` WRITE; /*!40000 ALTER TABLE `jos_vm_category_xref` DISABLE KEYS */; INSERT INTO `jos_vm_category_xref` VALUES (0,14,NULL); INSERT INTO `jos_vm_category_xref` VALUES (0,13,NULL); INSERT INTO `jos_vm_category_xref` VALUES (0,12,NULL); /*!40000 ALTER TABLE `jos_vm_category_xref` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jos_vm_country` -- DROP TABLE IF EXISTS `jos_vm_country`; CREATE TABLE `jos_vm_country` ( `country_id` int(11) NOT NULL auto_increment, `zone_id` int(11) NOT NULL default '1', `country_name` varchar(64) default NULL, `country_3_code` char(3) default NULL, `country_2_code` char(2) default NULL, PRIMARY KEY (`country_id`), KEY `idx_country_name` (`country_name`) ) ENGINE=MyISAM AUTO_INCREMENT=240 DEFAULT CHARSET=cp1251 COMMENT='Список стран'; -- -- Dumping data for table `jos_vm_country` -- LOCK TABLES `jos_vm_country` WRITE; /*!40000 ALTER TABLE `jos_vm_country` DISABLE KEYS */; INSERT INTO `jos_vm_country` VALUES (1,1,'Афганистан','AFG','AF'); INSERT INTO `jos_vm_country` VALUES (2,1,'Албания','ALB','AL'); INSERT INTO `jos_vm_country` VALUES (3,1,'Алжир','DZA','DZ'); INSERT INTO `jos_vm_country` VALUES (4,1,'Американская саомя','ASM','AS'); INSERT INTO `jos_vm_country` VALUES (5,1,'Андорра','AND','AD'); INSERT INTO `jos_vm_country` VALUES (6,1,'Ангола','AGO','AO'); INSERT INTO `jos_vm_country` VALUES (7,1,'Ангилья','AIA','AI'); INSERT INTO `jos_vm_country` VALUES (8,1,'Антарктида','ATA','AQ'); INSERT INTO `jos_vm_country` VALUES (9,1,'Антигуа и Барбуда','ATG','AG'); INSERT INTO `jos_vm_country` VALUES (10,1,'Аргентина','ARG','AR'); INSERT INTO `jos_vm_country` VALUES (11,1,'Армения','ARM','AM'); INSERT INTO `jos_vm_country` VALUES (12,1,'Аруба','ABW','AW'); INSERT INTO `jos_vm_country` VALUES (13,1,'Австралия','AUS','AU'); INSERT INTO `jos_vm_country` VALUES (14,1,'Австрия','AUT','AT'); INSERT INTO `jos_vm_country` VALUES (15,1,'Азербайджан','AZE','AZ'); INSERT INTO `jos_vm_country` VALUES (16,1,'Багамы','BHS','BS'); INSERT INTO `jos_vm_country` VALUES (17,1,'Бахрейн','BHR','BH'); INSERT INTO `jos_vm_country` VALUES (18,1,'Бангладеш','BGD','BD'); INSERT INTO `jos_vm_country` VALUES (19,1,'Барбадос','BRB','BB'); INSERT INTO `jos_vm_country` VALUES (20,1,'Беларусь','BLR','BY'); INSERT INTO `jos_vm_country` VALUES (21,1,'Бельгия','BEL','BE'); INSERT INTO `jos_vm_country` VALUES (22,1,'Белиз','BLZ','BZ'); INSERT INTO `jos_vm_country` VALUES (23,1,'Бенин','BEN','BJ'); INSERT INTO `jos_vm_country` VALUES (24,1,'Бермуды','BMU','BM'); INSERT INTO `jos_vm_country` VALUES (25,1,'Бутан','BTN','BT'); INSERT INTO `jos_vm_country` VALUES (26,1,'Боливия','BOL','BO'); INSERT INTO `jos_vm_country` VALUES (27,1,'Босния и Герцеговина','BIH','BA'); INSERT INTO `jos_vm_country` VALUES (28,1,'Ботсвана','BWA','BW'); INSERT INTO `jos_vm_country` VALUES (29,1,'Остров бувет','BVT','BV'); INSERT INTO `jos_vm_country` VALUES (30,1,'Бразилия','BRA','BR'); INSERT INTO `jos_vm_country` VALUES (31,1,'Британские острова в Тихом океане','IOT','IO'); INSERT INTO `jos_vm_country` VALUES (32,1,'Остров Бруней','BRN','BN'); INSERT INTO `jos_vm_country` VALUES (33,1,'Болгария','BGR','BG'); INSERT INTO `jos_vm_country` VALUES (34,1,'Буркино фасо','BFA','BF'); INSERT INTO `jos_vm_country` VALUES (35,1,'Бурунди','BDI','BI'); INSERT INTO `jos_vm_country` VALUES (36,1,'Камбоджа','KHM','KH'); INSERT INTO `jos_vm_country` VALUES (37,1,'Камерун','CMR','CM'); INSERT INTO `jos_vm_country` VALUES (38,1,'Канада','CAN','CA'); INSERT INTO `jos_vm_country` VALUES (39,1,'Капе верде','CPV','CV'); INSERT INTO `jos_vm_country` VALUES (40,1,'Каймановы острова','CYM','KY'); INSERT INTO `jos_vm_country` VALUES (41,1,'Центральная африканская республика','CAF','CF'); INSERT INTO `jos_vm_country` VALUES (42,1,'Республика Чад','TCD','TD'); INSERT INTO `jos_vm_country` VALUES (43,1,'Чили','CHL','CL'); INSERT INTO `jos_vm_country` VALUES (44,1,'Китай','CHN','CN'); INSERT INTO `jos_vm_country` VALUES (45,1,'Остров Рождества','CXR','CX'); INSERT INTO `jos_vm_country` VALUES (46,1,'Острова Кокоса','CCK','CC'); INSERT INTO `jos_vm_country` VALUES (47,1,'Колумбия','COL','CO'); INSERT INTO `jos_vm_country` VALUES (48,1,'Коморос','COM','KM'); INSERT INTO `jos_vm_country` VALUES (49,1,'Конго','COG','CG'); INSERT INTO `jos_vm_country` VALUES (50,1,'Острова Кука','COK','CK'); INSERT INTO `jos_vm_country` VALUES (51,1,'Коста Рика','CRI','CR'); INSERT INTO `jos_vm_country` VALUES (52,1,'Кот-де-Вуар','CIV','CI'); INSERT INTO `jos_vm_country` VALUES (53,1,'Хорватия','HRV','HR'); INSERT INTO `jos_vm_country` VALUES (54,1,'Куба','CUB','CU'); INSERT INTO `jos_vm_country` VALUES (55,1,'Кипр','CYP','CY'); INSERT INTO `jos_vm_country` VALUES (56,1,'Чехия','CZE','CZ'); INSERT INTO `jos_vm_country` VALUES (57,1,'Дания','DNK','DK'); INSERT INTO `jos_vm_country` VALUES (58,1,'Джибути','DJI','DJ'); INSERT INTO `jos_vm_country` VALUES (59,1,'Доминика','DMA','DM'); INSERT INTO `jos_vm_country` VALUES (60,1,'Доминиканская реп.','DOM','DO'); INSERT INTO `jos_vm_country` VALUES (61,1,'Вост. Тимор','TMP','TP'); INSERT INTO `jos_vm_country` VALUES (62,1,'Эквадор','ECU','EC'); INSERT INTO `jos_vm_country` VALUES (63,1,'Египет','EGY','EG'); INSERT INTO `jos_vm_country` VALUES (64,1,'Сальвадор','SLV','SV'); INSERT INTO `jos_vm_country` VALUES (65,1,'Экватор. Гвинея','GNQ','GQ'); INSERT INTO `jos_vm_country` VALUES (66,1,'Эритрея','ERI','ER'); INSERT INTO `jos_vm_country` VALUES (67,1,'Эстония','EST','EE'); INSERT INTO `jos_vm_country` VALUES (68,1,'Эфиопия','ETH','ET'); INSERT INTO `jos_vm_country` VALUES (69,1,'Фолклендские острова','FLK','FK'); INSERT INTO `jos_vm_country` VALUES (70,1,'Острова Фаро','FRO','FO'); INSERT INTO `jos_vm_country` VALUES (71,1,'Фиджи','FJI','FJ'); INSERT INTO `jos_vm_country` VALUES (72,1,'Финляндия','FIN','FI'); INSERT INTO `jos_vm_country` VALUES (73,1,'Франция','FRA','FR'); INSERT INTO `jos_vm_country` VALUES (74,1,'Франция, метрополия','FXX','FX'); INSERT INTO `jos_vm_country` VALUES (75,1,'Франц. Гайана','GUF','GF'); INSERT INTO `jos_vm_country` VALUES (76,1,'Франц. Полинезия','PYF','PF'); INSERT INTO `jos_vm_country` VALUES (77,1,'Франц. Южн. Территории','ATF','TF'); INSERT INTO `jos_vm_country` VALUES (78,1,'Габон','GAB','GA'); INSERT INTO `jos_vm_country` VALUES (79,1,'Гамбия','GMB','GM'); INSERT INTO `jos_vm_country` VALUES (80,1,'Грузия','GEO','GE'); INSERT INTO `jos_vm_country` VALUES (81,1,'Германия','DEU','DE'); INSERT INTO `jos_vm_country` VALUES (82,1,'Гана','GHA','GH'); INSERT INTO `jos_vm_country` VALUES (83,1,'Гибралтар','GIB','GI'); INSERT INTO `jos_vm_country` VALUES (84,1,'Греция','GRC','GR'); INSERT INTO `jos_vm_country` VALUES (85,1,'Гренландия','GRL','GL'); INSERT INTO `jos_vm_country` VALUES (86,1,'Гренада','GRD','GD'); INSERT INTO `jos_vm_country` VALUES (87,1,'Гваделупа','GLP','GP'); INSERT INTO `jos_vm_country` VALUES (88,1,'Гуам','GUM','GU'); INSERT INTO `jos_vm_country` VALUES (89,1,'Гватемала','GTM','GT'); INSERT INTO `jos_vm_country` VALUES (90,1,'Гвинея','GIN','GN'); INSERT INTO `jos_vm_country` VALUES (91,1,'Гвинея-биссау','GNB','GW'); INSERT INTO `jos_vm_country` VALUES (92,1,'Гайана','GUY','GY'); INSERT INTO `jos_vm_country` VALUES (93,1,'Гаити','HTI','HT'); INSERT INTO `jos_vm_country` VALUES (94,1,'Острова Хеад и Макдональд','HMD','HM'); INSERT INTO `jos_vm_country` VALUES (95,1,'Гондурас','HND','HN'); INSERT INTO `jos_vm_country` VALUES (96,1,'Гонконг','HKG','HK'); INSERT INTO `jos_vm_country` VALUES (97,1,'Венгрия','HUN','HU'); INSERT INTO `jos_vm_country` VALUES (98,1,'Исландия','ISL','IS'); INSERT INTO `jos_vm_country` VALUES (99,1,'Индия','IND','IN'); INSERT INTO `jos_vm_country` VALUES (100,1,'Индонезия','IDN','ID'); INSERT INTO `jos_vm_country` VALUES (101,1,'Иран','IRN','IR'); INSERT INTO `jos_vm_country` VALUES (102,1,'Ирак','IRQ','IQ'); INSERT INTO `jos_vm_country` VALUES (103,1,'Ирландия','IRL','IE'); INSERT INTO `jos_vm_country` VALUES (104,1,'Израиль','ISR','IL'); INSERT INTO `jos_vm_country` VALUES (105,1,'Италия','ITA','IT'); INSERT INTO `jos_vm_country` VALUES (106,1,'Ямайка','JAM','JM'); INSERT INTO `jos_vm_country` VALUES (107,1,'Япония','JPN','JP'); INSERT INTO `jos_vm_country` VALUES (108,1,'Иордан','JOR','JO'); INSERT INTO `jos_vm_country` VALUES (109,1,'Казахстан','KAZ','KZ'); INSERT INTO `jos_vm_country` VALUES (110,1,'Кения','KEN','KE'); INSERT INTO `jos_vm_country` VALUES (111,1,'Кирибати','KIR','KI'); INSERT INTO `jos_vm_country` VALUES (112,1,'Демокр. реп. Корея','PRK','KP'); INSERT INTO `jos_vm_country` VALUES (113,1,'Корея','KOR','KR'); INSERT INTO `jos_vm_country` VALUES (114,1,'Кувейт','KWT','KW'); INSERT INTO `jos_vm_country` VALUES (115,1,'Киргизстан','KGZ','KG'); INSERT INTO `jos_vm_country` VALUES (116,1,'Демокр. реп. Лаос','LAO','LA'); INSERT INTO `jos_vm_country` VALUES (117,1,'Латвия','LVA','LV'); INSERT INTO `jos_vm_country` VALUES (118,1,'Лебанон','LBN','LB'); INSERT INTO `jos_vm_country` VALUES (119,1,'Лесото','LSO','LS'); INSERT INTO `jos_vm_country` VALUES (120,1,'Либерия','LBR','LR'); INSERT INTO `jos_vm_country` VALUES (121,1,'Ливийсякая араб. Джамахирия','LBY','LY'); INSERT INTO `jos_vm_country` VALUES (122,1,'Лихтенштейн','LIE','LI'); INSERT INTO `jos_vm_country` VALUES (123,1,'Литва','LTU','LT'); INSERT INTO `jos_vm_country` VALUES (124,1,'Люксембург','LUX','LU'); INSERT INTO `jos_vm_country` VALUES (125,1,'Маккау','MAC','MO'); INSERT INTO `jos_vm_country` VALUES (126,1,'Македония','MKD','MK'); INSERT INTO `jos_vm_country` VALUES (127,1,'Мадагаскар','MDG','MG'); INSERT INTO `jos_vm_country` VALUES (128,1,'Малави','MWI','MW'); INSERT INTO `jos_vm_country` VALUES (129,1,'Малайзия','MYS','MY'); INSERT INTO `jos_vm_country` VALUES (130,1,'Мальдивы','MDV','MV'); INSERT INTO `jos_vm_country` VALUES (131,1,'Мали','MLI','ML'); INSERT INTO `jos_vm_country` VALUES (132,1,'Мальта','MLT','MT'); INSERT INTO `jos_vm_country` VALUES (133,1,'Острова Маршал','MHL','MH'); INSERT INTO `jos_vm_country` VALUES (134,1,'Мартиника','MTQ','MQ'); INSERT INTO `jos_vm_country` VALUES (135,1,'Мавритания','MRT','MR'); INSERT INTO `jos_vm_country` VALUES (136,1,'Мауритос','MUS','MU'); INSERT INTO `jos_vm_country` VALUES (137,1,'Майёт','MYT','YT'); INSERT INTO `jos_vm_country` VALUES (138,1,'Мексика','MEX','MX'); INSERT INTO `jos_vm_country` VALUES (139,1,'Микронезия','FSM','FM'); INSERT INTO `jos_vm_country` VALUES (140,1,'Молдова','MDA','MD'); INSERT INTO `jos_vm_country` VALUES (141,1,'Монако','MCO','MC'); INSERT INTO `jos_vm_country` VALUES (142,1,'Монголия','MNG','MN'); INSERT INTO `jos_vm_country` VALUES (143,1,'Монсерат','MSR','MS'); INSERT INTO `jos_vm_country` VALUES (144,1,'Морокко','MAR','MA'); INSERT INTO `jos_vm_country` VALUES (145,1,'Мозамбик','MOZ','MZ'); INSERT INTO `jos_vm_country` VALUES (146,1,'Мянмар','MMR','MM'); INSERT INTO `jos_vm_country` VALUES (147,1,'Намибия','NAM','NA'); INSERT INTO `jos_vm_country` VALUES (148,1,'Науру','NRU','NR'); INSERT INTO `jos_vm_country` VALUES (149,1,'Непал','NPL','NP'); INSERT INTO `jos_vm_country` VALUES (150,1,'Недерланды','NLD','NL'); INSERT INTO `jos_vm_country` VALUES (151,1,'Голландские высоты','ANT','AN'); INSERT INTO `jos_vm_country` VALUES (152,1,'Нов. каледония','NCL','NC'); INSERT INTO `jos_vm_country` VALUES (153,1,'Нов. Зеладния','NZL','NZ'); INSERT INTO `jos_vm_country` VALUES (154,1,'Никарагуа','NIC','NI'); INSERT INTO `jos_vm_country` VALUES (155,1,'Нигер','NER','NE'); INSERT INTO `jos_vm_country` VALUES (156,1,'Нигерия','NGA','NG'); INSERT INTO `jos_vm_country` VALUES (157,1,'Ниу','NIU','NU'); INSERT INTO `jos_vm_country` VALUES (158,1,'Остров Норфолк','NFK','NF'); INSERT INTO `jos_vm_country` VALUES (159,1,'Сев. острова Мариана','MNP','MP'); INSERT INTO `jos_vm_country` VALUES (160,1,'Норвегия','NOR','NO'); INSERT INTO `jos_vm_country` VALUES (161,1,'Оман','OMN','OM'); INSERT INTO `jos_vm_country` VALUES (162,1,'Пакистан','PAK','PK'); INSERT INTO `jos_vm_country` VALUES (163,1,'Палау','PLW','PW'); INSERT INTO `jos_vm_country` VALUES (164,1,'Панама','PAN','PA'); INSERT INTO `jos_vm_country` VALUES (165,1,'Папуа, новая гвинея','PNG','PG'); INSERT INTO `jos_vm_country` VALUES (166,1,'Парагвай','PRY','PY'); INSERT INTO `jos_vm_country` VALUES (167,1,'Перу','PER','PE'); INSERT INTO `jos_vm_country` VALUES (168,1,'Филипинны','PHL','PH'); INSERT INTO `jos_vm_country` VALUES (169,1,'Питкаин','PCN','PN'); INSERT INTO `jos_vm_country` VALUES (170,1,'Польша','POL','PL'); INSERT INTO `jos_vm_country` VALUES (171,1,'Португалия','PRT','PT'); INSERT INTO `jos_vm_country` VALUES (172,1,'Пуерто Рико','PRI','PR'); INSERT INTO `jos_vm_country` VALUES (173,1,'Катар','QAT','QA'); INSERT INTO `jos_vm_country` VALUES (174,1,'Реюнион','REU','RE'); INSERT INTO `jos_vm_country` VALUES (175,1,'Румыния','ROM','RO'); INSERT INTO `jos_vm_country` VALUES (176,1,'Российская Федерация','RUS','RU'); INSERT INTO `jos_vm_country` VALUES (177,1,'Руанда','RWA','RW'); INSERT INTO `jos_vm_country` VALUES (178,1,'Св. Китс и Невис','KNA','KN'); INSERT INTO `jos_vm_country` VALUES (179,1,'Св. Лючия','LCA','LC'); INSERT INTO `jos_vm_country` VALUES (180,1,'Св. Винсент и Гренады','VCT','VC'); INSERT INTO `jos_vm_country` VALUES (181,1,'Самоа','WSM','WS'); INSERT INTO `jos_vm_country` VALUES (182,1,'Сан Марино','SMR','SM'); INSERT INTO `jos_vm_country` VALUES (183,1,'Св. Том и принцип','STP','ST'); INSERT INTO `jos_vm_country` VALUES (184,1,'Саудовская Аравия','SAU','SA'); INSERT INTO `jos_vm_country` VALUES (185,1,'Сенегал','SEN','SN'); INSERT INTO `jos_vm_country` VALUES (186,1,'Сейшелы','SYC','SC'); INSERT INTO `jos_vm_country` VALUES (187,1,'Сьерра Леоне','SLE','SL'); INSERT INTO `jos_vm_country` VALUES (188,1,'Сингапур','SGP','SG'); INSERT INTO `jos_vm_country` VALUES (189,1,'Словакия','SVK','SK'); INSERT INTO `jos_vm_country` VALUES (190,1,'Словения','SVN','SI'); INSERT INTO `jos_vm_country` VALUES (191,1,'Острова Соломона','SLB','SB'); INSERT INTO `jos_vm_country` VALUES (192,1,'Сомали','SOM','SO'); INSERT INTO `jos_vm_country` VALUES (193,1,'Южная Африка','ZAF','ZA'); INSERT INTO `jos_vm_country` VALUES (194,1,'Южные Сендвич. острова','SGS','GS'); INSERT INTO `jos_vm_country` VALUES (195,1,'Испания','ESP','ES'); INSERT INTO `jos_vm_country` VALUES (196,1,'Шри Ланка','LKA','LK'); INSERT INTO `jos_vm_country` VALUES (197,1,'Св. Елена','SHN','SH'); INSERT INTO `jos_vm_country` VALUES (198,1,'Св. Пьер и Микелон','SPM','PM'); INSERT INTO `jos_vm_country` VALUES (199,1,'Судан','SDN','SD'); INSERT INTO `jos_vm_country` VALUES (200,1,'Суринам','SUR','SR'); INSERT INTO `jos_vm_country` VALUES (201,1,'Свалбард и Ян Майен Острова','SJM','SJ'); INSERT INTO `jos_vm_country` VALUES (202,1,'Свазиленд','SWZ','SZ'); INSERT INTO `jos_vm_country` VALUES (203,1,'Швеция','SWE','SE'); INSERT INTO `jos_vm_country` VALUES (204,1,'Швейцария','CHE','CH'); INSERT INTO `jos_vm_country` VALUES (205,1,'Сирия','SYR','SY'); INSERT INTO `jos_vm_country` VALUES (206,1,'Тайвань','TWN','TW'); INSERT INTO `jos_vm_country` VALUES (207,1,'Таджикистан','TJK','TJ'); INSERT INTO `jos_vm_country` VALUES (208,1,'Танзания','TZA','TZ'); INSERT INTO `jos_vm_country` VALUES (209,1,'Тайланд','THA','TH'); INSERT INTO `jos_vm_country` VALUES (210,1,'Того','TGO','TG'); INSERT INTO `jos_vm_country` VALUES (211,1,'Токелау','TKL','TK'); INSERT INTO `jos_vm_country` VALUES (212,1,'Тонга','TON','TO'); INSERT INTO `jos_vm_country` VALUES (213,1,'Тринидад и Тобаго','TTO','TT'); INSERT INTO `jos_vm_country` VALUES (214,1,'Тунис','TUN','TN'); INSERT INTO `jos_vm_country` VALUES (215,1,'Турция','TUR','TR'); INSERT INTO `jos_vm_country` VALUES (216,1,'Туркменестан','TKM','TM'); INSERT INTO `jos_vm_country` VALUES (217,1,'Тркс и Кайкос острова','TCA','TC'); INSERT INTO `jos_vm_country` VALUES (218,1,'Тувалу','TUV','TV'); INSERT INTO `jos_vm_country` VALUES (219,1,'Уганда','UGA','UG'); INSERT INTO `jos_vm_country` VALUES (220,1,'Украина','UKR','UA'); INSERT INTO `jos_vm_country` VALUES (221,1,'ОАЭ','ARE','AE'); INSERT INTO `jos_vm_country` VALUES (222,1,'Великобритания','GBR','GB'); INSERT INTO `jos_vm_country` VALUES (223,1,'США','USA','US'); INSERT INTO `jos_vm_country` VALUES (224,1,'Соед. Штаты Оутландс островов','UMI','UM'); INSERT INTO `jos_vm_country` VALUES (225,1,'Уругвай','URY','UY'); INSERT INTO `jos_vm_country` VALUES (226,1,'Узбекистан','UZB','UZ'); INSERT INTO `jos_vm_country` VALUES (227,1,'Ванату','VUT','VU'); INSERT INTO `jos_vm_country` VALUES (228,1,'Ватикан','VAT','VA'); INSERT INTO `jos_vm_country` VALUES (229,1,'Венесуела','VEN','VE'); INSERT INTO `jos_vm_country` VALUES (230,1,'Вьетнам','VNM','VN'); INSERT INTO `jos_vm_country` VALUES (231,1,'Вирджинские о-ва (Англия)','VGB','VG'); INSERT INTO `jos_vm_country` VALUES (232,1,'Вирджинские о-ва (США)','VIR','VI'); INSERT INTO `jos_vm_country` VALUES (233,1,'Уэльс','WLF','WF'); INSERT INTO `jos_vm_country` VALUES (234,1,'Зап. Сахара','ESH','EH'); INSERT INTO `jos_vm_country` VALUES (235,1,'Йемен','YEM','YE'); INSERT INTO `jos_vm_country` VALUES (236,1,'Югославия','YUG','YU'); INSERT INTO `jos_vm_country` VALUES (237,1,'Заир','ZAR','ZR'); INSERT INTO `jos_vm_country` VALUES (238,1,'Замбия','ZMB','ZM'); INSERT INTO `jos_vm_country` VALUES (239,1,'Зимбабве','ZWE','ZW'); /*!40000 ALTER TABLE `jos_vm_country` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jos_vm_coupons` -- DROP TABLE IF EXISTS `jos_vm_coupons`; CREATE TABLE `jos_vm_coupons` ( `coupon_id` int(16) NOT NULL auto_increment, `coupon_code` varchar(32) NOT NULL default '', `percent_or_total` enum('percent','total') NOT NULL default 'percent', `coupon_type` enum('gift','permanent') NOT NULL default 'gift', `coupon_value` decimal(12,2) NOT NULL default '0.00', PRIMARY KEY (`coupon_id`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=cp1251 COMMENT='Для храния кодов купонов'; -- -- Dumping data for table `jos_vm_coupons` -- LOCK TABLES `jos_vm_coupons` WRITE; /*!40000 ALTER TABLE `jos_vm_coupons` DISABLE KEYS */; INSERT INTO `jos_vm_coupons` VALUES (1,'test1','','','6.00'); INSERT INTO `jos_vm_coupons` VALUES (2,'test2','','','15.00'); INSERT INTO `jos_vm_coupons` VALUES (3,'test3','','','4.00'); INSERT INTO `jos_vm_coupons` VALUES (4,'test4','','','15.00'); INSERT INTO `jos_vm_coupons` VALUES (5,'11','total','gift','300.00'); /*!40000 ALTER TABLE `jos_vm_coupons` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jos_vm_creditcard` -- DROP TABLE IF EXISTS `jos_vm_creditcard`; CREATE TABLE `jos_vm_creditcard` ( `creditcard_id` int(11) NOT NULL auto_increment, `vendor_id` int(11) NOT NULL default '0', `creditcard_name` varchar(70) NOT NULL default '', `creditcard_code` varchar(30) NOT NULL default '', PRIMARY KEY (`creditcard_id`) ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=cp1251 COMMENT='Для хранения типов кредитных кар'; -- -- Dumping data for table `jos_vm_creditcard` -- LOCK TABLES `jos_vm_creditcard` WRITE; /*!40000 ALTER TABLE `jos_vm_creditcard` DISABLE KEYS */; /*!40000 ALTER TABLE `jos_vm_creditcard` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jos_vm_csv` -- DROP TABLE IF EXISTS `jos_vm_csv`; CREATE TABLE `jos_vm_csv` ( `field_id` int(11) NOT NULL auto_increment, `field_name` varchar(128) NOT NULL default '', `field_default_value` text, `field_ordering` int(3) NOT NULL default '0', `field_required` char(1) default 'N', PRIMARY KEY (`field_id`) ) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=cp1251 COMMENT='Поля для CSV импорта экспорта'; -- -- Dumping data for table `jos_vm_csv` -- LOCK TABLES `jos_vm_csv` WRITE; /*!40000 ALTER TABLE `jos_vm_csv` DISABLE KEYS */; INSERT INTO `jos_vm_csv` VALUES (1,'product_sku','',1,'Y'); INSERT INTO `jos_vm_csv` VALUES (2,'product_s_desc','',5,'N'); INSERT INTO `jos_vm_csv` VALUES (3,'product_desc','',6,'N'); INSERT INTO `jos_vm_csv` VALUES (4,'product_thumb_image','',7,'N'); INSERT INTO `jos_vm_csv` VALUES (5,'product_full_image','',8,'N'); INSERT INTO `jos_vm_csv` VALUES (6,'product_weight','',9,'N'); INSERT INTO `jos_vm_csv` VALUES (7,'product_weight_uom','KG',10,'N'); INSERT INTO `jos_vm_csv` VALUES (8,'product_length','',11,'N'); INSERT INTO `jos_vm_csv` VALUES (9,'product_width','',12,'N'); INSERT INTO `jos_vm_csv` VALUES (10,'product_height','',13,'N'); INSERT INTO `jos_vm_csv` VALUES (11,'product_lwh_uom','',14,'N'); INSERT INTO `jos_vm_csv` VALUES (12,'product_in_stock','0',15,'N'); INSERT INTO `jos_vm_csv` VALUES (13,'product_available_date','',16,'N'); INSERT INTO `jos_vm_csv` VALUES (14,'product_discount_id','',17,'N'); INSERT INTO `jos_vm_csv` VALUES (15,'product_name','',2,'Y'); INSERT INTO `jos_vm_csv` VALUES (16,'product_price','',4,'N'); INSERT INTO `jos_vm_csv` VALUES (17,'category_path','',3,'Y'); INSERT INTO `jos_vm_csv` VALUES (18,'manufacturer_id','',18,'N'); INSERT INTO `jos_vm_csv` VALUES (19,'product_tax_id','',19,'N'); INSERT INTO `jos_vm_csv` VALUES (20,'product_sales','',20,'N'); INSERT INTO `jos_vm_csv` VALUES (21,'product_parent_sku','0',21,'N'); INSERT INTO `jos_vm_csv` VALUES (22,'attribute','',22,'N'); INSERT INTO `jos_vm_csv` VALUES (23,'custom_attribute','',23,'N'); INSERT INTO `jos_vm_csv` VALUES (24,'attributes','',24,'N'); INSERT INTO `jos_vm_csv` VALUES (25,'attribute_values','',25,'N'); INSERT INTO `jos_vm_csv` VALUES (26,'product_discount','',26,'N'); /*!40000 ALTER TABLE `jos_vm_csv` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jos_vm_currency` -- DROP TABLE IF EXISTS `jos_vm_currency`; CREATE TABLE `jos_vm_currency` ( `currency_id` int(11) NOT NULL auto_increment, `currency_name` varchar(64) default NULL, `currency_code` char(3) default NULL, PRIMARY KEY (`currency_id`), KEY `idx_currency_name` (`currency_name`) ) ENGINE=MyISAM AUTO_INCREMENT=158 DEFAULT CHARSET=cp1251 COMMENT='Валюты'; -- -- Dumping data for table `jos_vm_currency` -- LOCK TABLES `jos_vm_currency` WRITE; /*!40000 ALTER TABLE `jos_vm_currency` DISABLE KEYS */; INSERT INTO `jos_vm_currency` VALUES (1,'Andorran Peseta','ADP'); INSERT INTO `jos_vm_currency` VALUES (2,'ОАЭ дихрам','AED'); INSERT INTO `jos_vm_currency` VALUES (3,'Афганистан. афгани','AFA'); INSERT INTO `jos_vm_currency` VALUES (4,'Албанск. лек','ALL'); INSERT INTO `jos_vm_currency` VALUES (5,'Гульден Голландских высот','ANG'); INSERT INTO `jos_vm_currency` VALUES (6,'Ангольская кванца','AOK'); INSERT INTO `jos_vm_currency` VALUES (7,'Аргентинск. пессо','ARA'); INSERT INTO `jos_vm_currency` VALUES (9,'Австралл. доллар','AUD'); INSERT INTO `jos_vm_currency` VALUES (10,'Аруб. флоран','AWG'); INSERT INTO `jos_vm_currency` VALUES (11,'Барбадос. доллар','BBD'); INSERT INTO `jos_vm_currency` VALUES (12,'Бангладеш. така','BDT'); INSERT INTO `jos_vm_currency` VALUES (14,'Болгарск. лев','BGL'); INSERT INTO `jos_vm_currency` VALUES (15,'Бахрейн. динар','BHD'); INSERT INTO `jos_vm_currency` VALUES (16,'Бурунди франк','BIF'); INSERT INTO `jos_vm_currency` VALUES (17,'Бермуд. доллар','BMD'); INSERT INTO `jos_vm_currency` VALUES (18,'Брунейск. доллар','BND'); INSERT INTO `jos_vm_currency` VALUES (19,'Боливийск. боливиано','BOB'); INSERT INTO `jos_vm_currency` VALUES (20,'Бразильск. реал','BRL'); INSERT INTO `jos_vm_currency` VALUES (21,'Багамск. доллар','BSD'); INSERT INTO `jos_vm_currency` VALUES (22,'Бутан нгултрум','BTN'); INSERT INTO `jos_vm_currency` VALUES (23,'Бирма кайят','BUK'); INSERT INTO `jos_vm_currency` VALUES (24,'Ботсванск. була','BWP'); INSERT INTO `jos_vm_currency` VALUES (25,'Белизск. доллар','BZD'); INSERT INTO `jos_vm_currency` VALUES (26,'Канадск. доллар','CAD'); INSERT INTO `jos_vm_currency` VALUES (27,'Швейц. франк','CHF'); INSERT INTO `jos_vm_currency` VALUES (28,'Чилийск. фоменто','CLF'); INSERT INTO `jos_vm_currency` VALUES (29,'Чилийск. пессо','CLP'); INSERT INTO `jos_vm_currency` VALUES (30,'Кит. йены','CNY'); INSERT INTO `jos_vm_currency` VALUES (31,'Колумбийск. пессо','COP'); INSERT INTO `jos_vm_currency` VALUES (32,'Коста Рико колон','CRC'); INSERT INTO `jos_vm_currency` VALUES (33,'Чешск. крона','CZK'); INSERT INTO `jos_vm_currency` VALUES (34,'Кубинск. пессо','CUP'); INSERT INTO `jos_vm_currency` VALUES (35,'Капе Верде эскудо','CVE'); INSERT INTO `jos_vm_currency` VALUES (36,'Кипрск. фунт','CYP'); INSERT INTO `jos_vm_currency` VALUES (40,'Датск. крона','DKK'); INSERT INTO `jos_vm_currency` VALUES (41,'Доминиканск. пессо','DOP'); INSERT INTO `jos_vm_currency` VALUES (42,'Алжирский динар','DZD'); INSERT INTO `jos_vm_currency` VALUES (43,'Эквадор сукре','ECS'); INSERT INTO `jos_vm_currency` VALUES (44,'Египетск. фунт','EGP'); INSERT INTO `jos_vm_currency` VALUES (46,'Эфиопск. бирр','ETB'); INSERT INTO `jos_vm_currency` VALUES (47,'Евро','EUR'); INSERT INTO `jos_vm_currency` VALUES (49,'Фиджи доллар','FJD'); INSERT INTO `jos_vm_currency` VALUES (50,'Фалклендск. фунт','FKP'); INSERT INTO `jos_vm_currency` VALUES (52,'Британск. фунт','GBP'); INSERT INTO `jos_vm_currency` VALUES (53,'Ганайнск. кеди','GHC'); INSERT INTO `jos_vm_currency` VALUES (54,'Гибралтарск. фунт','GIP'); INSERT INTO `jos_vm_currency` VALUES (55,'Гамбианск. галези','GMD'); INSERT INTO `jos_vm_currency` VALUES (56,'Гвинейск. франк','GNF'); INSERT INTO `jos_vm_currency` VALUES (58,'Гватемалск. кетзал','GTQ'); INSERT INTO `jos_vm_currency` VALUES (59,'Гвинейск. пессо','GWP'); INSERT INTO `jos_vm_currency` VALUES (60,'Гайанск. доллар','GYD'); INSERT INTO `jos_vm_currency` VALUES (61,'Гон-конгск. доллар','HKD'); INSERT INTO `jos_vm_currency` VALUES (62,'Гондуран Гемпира','HNL'); INSERT INTO `jos_vm_currency` VALUES (63,'Гаитянск. джорде','HTG'); INSERT INTO `jos_vm_currency` VALUES (64,'Венгерск. форинт','HUF'); INSERT INTO `jos_vm_currency` VALUES (65,'Индонезиск. рупия','IDR'); INSERT INTO `jos_vm_currency` VALUES (66,'Ирландск фунт','IEP'); INSERT INTO `jos_vm_currency` VALUES (67,'Израильск. шекель','ILS'); INSERT INTO `jos_vm_currency` VALUES (68,'Индийск. рупия','INR'); INSERT INTO `jos_vm_currency` VALUES (69,'Иракск. динар','IQD'); INSERT INTO `jos_vm_currency` VALUES (70,'Иранск. риал','IRR'); INSERT INTO `jos_vm_currency` VALUES (73,'Ямайск. доллар','JMD'); INSERT INTO `jos_vm_currency` VALUES (74,'Иорданск. динар','JOD'); INSERT INTO `jos_vm_currency` VALUES (75,'Японск. йена','JPY'); INSERT INTO `jos_vm_currency` VALUES (76,'Кенийск. шиллинг','KES'); INSERT INTO `jos_vm_currency` VALUES (77,'Кампучийск. риал','KHR'); INSERT INTO `jos_vm_currency` VALUES (78,'Коморосск. франк','KMF'); INSERT INTO `jos_vm_currency` VALUES (79,'Сев. корейск. вон','KPW'); INSERT INTO `jos_vm_currency` VALUES (80,'Южн. корейск. вон','KRW'); INSERT INTO `jos_vm_currency` VALUES (81,'Кувейтск динар','KWD'); INSERT INTO `jos_vm_currency` VALUES (82,'Кайманск. доллар','KYD'); INSERT INTO `jos_vm_currency` VALUES (83,'Лаоск. кип','LAK'); INSERT INTO `jos_vm_currency` VALUES (84,'Лебанезск. фунт','LBP'); INSERT INTO `jos_vm_currency` VALUES (85,'Шри-Ланка рупия','LKR'); INSERT INTO `jos_vm_currency` VALUES (86,'Либерийск доллар','LRD'); INSERT INTO `jos_vm_currency` VALUES (87,'Лессото лоти','LSL'); INSERT INTO `jos_vm_currency` VALUES (89,'Либийск динар','LYD'); INSERT INTO `jos_vm_currency` VALUES (90,'Морокканск. дихрам','MAD'); INSERT INTO `jos_vm_currency` VALUES (91,'Малагазск. франк','MGF'); INSERT INTO `jos_vm_currency` VALUES (92,'Монгольск. тугрик','MNT'); INSERT INTO `jos_vm_currency` VALUES (93,'Макайск. птака','MOP'); INSERT INTO `jos_vm_currency` VALUES (94,'Мавританск огуйя','MRO'); INSERT INTO `jos_vm_currency` VALUES (95,'Мальтеска лира','MTL'); INSERT INTO `jos_vm_currency` VALUES (96,'Мауритус рупия','MUR'); INSERT INTO `jos_vm_currency` VALUES (97,'Мальдив руфия','MVR'); INSERT INTO `jos_vm_currency` VALUES (98,'Малави квача','MWK'); INSERT INTO `jos_vm_currency` VALUES (99,'Мексиканск. пессо','MXP'); INSERT INTO `jos_vm_currency` VALUES (100,'Малазийск риггат','MYR'); INSERT INTO `jos_vm_currency` VALUES (101,'Мозамбикск. метикал','MZM'); INSERT INTO `jos_vm_currency` VALUES (102,'Нигерийск. найра','NGN'); INSERT INTO `jos_vm_currency` VALUES (103,'Никарагуаск. корбода','NIC'); INSERT INTO `jos_vm_currency` VALUES (105,'Норвежск. крона','NOK'); INSERT INTO `jos_vm_currency` VALUES (106,'Непал рупия','NPR'); INSERT INTO `jos_vm_currency` VALUES (107,'Нов. Зеландск. доллар','NZD'); INSERT INTO `jos_vm_currency` VALUES (108,'Омани риал','OMR'); INSERT INTO `jos_vm_currency` VALUES (109,'Панамск. балбоа','PAB'); INSERT INTO `jos_vm_currency` VALUES (110,'Перу инти','PEI'); INSERT INTO `jos_vm_currency` VALUES (111,'Папуа Нов. Гвинея кина','PGK'); INSERT INTO `jos_vm_currency` VALUES (112,'Филлипинск. пессо','PHP'); INSERT INTO `jos_vm_currency` VALUES (113,'Пакистанск. рупия','PKR'); INSERT INTO `jos_vm_currency` VALUES (114,'Пользский злотый','PLZ'); INSERT INTO `jos_vm_currency` VALUES (116,'Парагвайск гарани','PYG'); INSERT INTO `jos_vm_currency` VALUES (117,'Катарск. риал','QAR'); INSERT INTO `jos_vm_currency` VALUES (118,'Румынск. лей','ROL'); INSERT INTO `jos_vm_currency` VALUES (119,'Руанда франк','RWF'); INSERT INTO `jos_vm_currency` VALUES (120,'Сауд. Аравийск. риал','SAR'); INSERT INTO `jos_vm_currency` VALUES (121,'Соломон. о-ва доллар','SBD'); INSERT INTO `jos_vm_currency` VALUES (122,'Сейшелл рупия','SCR'); INSERT INTO `jos_vm_currency` VALUES (123,'Суданск. фунт','SDP'); INSERT INTO `jos_vm_currency` VALUES (124,'Шведск. крона','SEK'); INSERT INTO `jos_vm_currency` VALUES (125,'Сингапурск. доллар','SGD'); INSERT INTO `jos_vm_currency` VALUES (126,'Св. Елена фунт','SHP'); INSERT INTO `jos_vm_currency` VALUES (127,'Сьерра Леоне леон','SLL'); INSERT INTO `jos_vm_currency` VALUES (128,'Сомали шиллинг','SOS'); INSERT INTO `jos_vm_currency` VALUES (129,'Суринам гульден','SRG'); INSERT INTO `jos_vm_currency` VALUES (130,'Св. Том и принцип добра','STD'); INSERT INTO `jos_vm_currency` VALUES (131,'Российский рубль','RUB'); INSERT INTO `jos_vm_currency` VALUES (132,'Сальвадорск. колон','SVC'); INSERT INTO `jos_vm_currency` VALUES (133,'Сирийск. потмд','SYP'); INSERT INTO `jos_vm_currency` VALUES (134,'Свазилендск. лилангени','SZL'); INSERT INTO `jos_vm_currency` VALUES (135,'Тайский бат','THB'); INSERT INTO `jos_vm_currency` VALUES (136,'Тунисск. динар','TND'); INSERT INTO `jos_vm_currency` VALUES (137,'Тонга панга','TOP'); INSERT INTO `jos_vm_currency` VALUES (138,'Вост. Тимор эскудо','TPE'); INSERT INTO `jos_vm_currency` VALUES (139,'Турецкая лира','TRL'); INSERT INTO `jos_vm_currency` VALUES (140,'Тринидад и Тобаго доллар','TTD'); INSERT INTO `jos_vm_currency` VALUES (141,'Тайваньски доллар','TWD'); INSERT INTO `jos_vm_currency` VALUES (142,'Танзинийск. шиллинг','TZS'); INSERT INTO `jos_vm_currency` VALUES (143,'Угадна шиллинг','UGS'); INSERT INTO `jos_vm_currency` VALUES (144,'США доллар','USD'); INSERT INTO `jos_vm_currency` VALUES (145,'Уругвайск. пессо','UYP'); INSERT INTO `jos_vm_currency` VALUES (146,'Венесуельск. боливар','VEB'); INSERT INTO `jos_vm_currency` VALUES (147,'Вьетнамск. донг','VND'); INSERT INTO `jos_vm_currency` VALUES (148,'Ванату вату','VUV'); INSERT INTO `jos_vm_currency` VALUES (149,'Самоа тала','WST'); INSERT INTO `jos_vm_currency` VALUES (150,'Демокр. Йемен динар','YDD'); INSERT INTO `jos_vm_currency` VALUES (151,'Йеменск. риал','YER'); INSERT INTO `jos_vm_currency` VALUES (152,'Югославск. динар','YUD'); INSERT INTO `jos_vm_currency` VALUES (153,'Юж. Африка ренд','ZAR'); INSERT INTO `jos_vm_currency` VALUES (154,'Замбийск. квача','ZMK'); INSERT INTO `jos_vm_currency` VALUES (155,'Заирск. заир','ZRZ'); INSERT INTO `jos_vm_currency` VALUES (156,'Зимбабвск. доллар','ZWD'); INSERT INTO `jos_vm_currency` VALUES (157,'Словакск. крона','SKK'); /*!40000 ALTER TABLE `jos_vm_currency` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jos_vm_function` -- DROP TABLE IF EXISTS `jos_vm_function`; CREATE TABLE `jos_vm_function` ( `function_id` int(11) NOT NULL auto_increment, `module_id` int(11) default NULL, `function_name` varchar(32) default NULL, `function_class` varchar(32) default NULL, `function_method` varchar(32) default NULL, `function_description` text, `function_perms` varchar(255) default NULL, PRIMARY KEY (`function_id`), KEY `idx_function_module_id` (`module_id`), KEY `idx_function_name` (`function_name`) ) ENGINE=MyISAM AUTO_INCREMENT=171 DEFAULT CHARSET=cp1251 COMMENT='Зарегистрированные функции'; -- -- Dumping data for table `jos_vm_function` -- LOCK TABLES `jos_vm_function` WRITE; /*!40000 ALTER TABLE `jos_vm_function` DISABLE KEYS */; INSERT INTO `jos_vm_function` VALUES (1,1,'userAdd','ps_user','add','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (2,1,'userDelete','ps_user','delete','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (3,1,'userUpdate','ps_user','update','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (4,1,'adminPasswdUpdate','ps_user','update_admin_passwd','Изменяет пароль администратора','admin'); INSERT INTO `jos_vm_function` VALUES (31,2,'productAdd','ps_product','add','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (6,1,'functionAdd','ps_function','add','','admin'); INSERT INTO `jos_vm_function` VALUES (7,1,'functionUpdate','ps_function','update','','admin'); INSERT INTO `jos_vm_function` VALUES (8,1,'functionDelete','ps_function','delete','','admin'); INSERT INTO `jos_vm_function` VALUES (9,1,'userLogout','ps_user','logout','','none'); INSERT INTO `jos_vm_function` VALUES (10,1,'userAddressAdd','ps_user_address','add','','admin,storeadmin,shopper,demo'); INSERT INTO `jos_vm_function` VALUES (11,1,'userAddressUpdate','ps_user_address','update','','admin,storeadmin,shopper'); INSERT INTO `jos_vm_function` VALUES (12,1,'userAddressDelete','ps_user_address','delete','','admin,storeadmin,shopper'); INSERT INTO `jos_vm_function` VALUES (13,1,'moduleAdd','ps_module','add','','admin'); INSERT INTO `jos_vm_function` VALUES (14,1,'moduleUpdate','ps_module','update','','admin'); INSERT INTO `jos_vm_function` VALUES (15,1,'moduleDelete','ps_module','delete','','admin'); INSERT INTO `jos_vm_function` VALUES (16,1,'userLogin','ps_user','login','','none'); INSERT INTO `jos_vm_function` VALUES (17,3,'vendorAdd','ps_vendor','add','','admin'); INSERT INTO `jos_vm_function` VALUES (18,3,'vendorUpdate','ps_vendor','update','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (19,3,'vendorDelete','ps_vendor','delete','','admin'); INSERT INTO `jos_vm_function` VALUES (20,3,'vendorCategoryAdd','ps_vendor_category','add','','admin'); INSERT INTO `jos_vm_function` VALUES (21,3,'vendorCategoryUpdate','ps_vendor_category','update','','admin'); INSERT INTO `jos_vm_function` VALUES (22,3,'vendorCategoryDelete','ps_vendor_category','delete','','admin'); INSERT INTO `jos_vm_function` VALUES (23,4,'shopperAdd','ps_shopper','add','','none'); INSERT INTO `jos_vm_function` VALUES (24,4,'shopperDelete','ps_shopper','delete','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (25,4,'shopperUpdate','ps_shopper','update','','admin,storeadmin,shopper'); INSERT INTO `jos_vm_function` VALUES (26,4,'shopperGroupAdd','ps_shopper_group','add','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (27,4,'shopperGroupUpdate','ps_shopper_group','update','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (28,4,'shopperGroupDelete','ps_shopper_group','delete','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (29,5,'orderSearch','ps_order','find','','admin,storeadmin,demo'); INSERT INTO `jos_vm_function` VALUES (30,5,'orderStatusSet','ps_order','order_status_update','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (32,2,'productDelete','ps_product','delete','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (33,2,'productUpdate','ps_product','update','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (34,2,'productCategoryAdd','ps_product_category','add','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (35,2,'productCategoryUpdate','ps_product_category','update','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (36,2,'productCategoryDelete','ps_product_category','delete','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (37,2,'productPriceAdd','ps_product_price','add','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (38,2,'productPriceUpdate','ps_product_price','update','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (39,2,'productPriceDelete','ps_product_price','delete','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (40,2,'productAttributeAdd','ps_product_attribute','add','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (41,2,'productAttributeUpdate','ps_product_attribute','update','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (42,2,'productAttributeDelete','ps_product_attribute','delete','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (43,7,'cartAdd','ps_cart','add','','none'); INSERT INTO `jos_vm_function` VALUES (44,7,'cartUpdate','ps_cart','update','','none'); INSERT INTO `jos_vm_function` VALUES (45,7,'cartDelete','ps_cart','delete','','none'); INSERT INTO `jos_vm_function` VALUES (46,10,'checkoutComplete','ps_checkout','add','','shopper,storeadmin,admin'); INSERT INTO `jos_vm_function` VALUES (47,1,'setLanguage','ps_module','set_language','','none'); INSERT INTO `jos_vm_function` VALUES (48,8,'paymentMethodUpdate','ps_payment_method','update','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (49,8,'paymentMethodAdd','ps_payment_method','add','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (50,8,'paymentMethodDelete','ps_payment_method','delete','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (51,5,'orderDelete','ps_order','delete','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (52,11,'addTaxRate','ps_tax','add','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (53,11,'updateTaxRate','ps_tax','update','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (54,11,'deleteTaxRate','ps_tax','delete','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (55,10,'checkoutValidateST','ps_checkout','validate_shipto','','none'); INSERT INTO `jos_vm_function` VALUES (59,5,'orderStatusUpdate','ps_order_status','update','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (60,5,'orderStatusAdd','ps_order_status','add','','storeadmin,admin'); INSERT INTO `jos_vm_function` VALUES (61,5,'orderStatusDelete','ps_order_status','delete','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (62,1,'currencyAdd','ps_currency','add','add a currency','storeadmin,admin'); INSERT INTO `jos_vm_function` VALUES (63,1,'currencyUpdate','ps_currency','update',' update a currency','storeadmin,admin'); INSERT INTO `jos_vm_function` VALUES (64,1,'currencyDelete','ps_currency','delete','delete a currency','storeadmin,admin'); INSERT INTO `jos_vm_function` VALUES (65,1,'countryAdd','ps_country','add','Add a country ','storeadmin,admin'); INSERT INTO `jos_vm_function` VALUES (66,1,'countryUpdate','ps_country','update','Изменить запись о стране','storeadmin,admin'); INSERT INTO `jos_vm_function` VALUES (67,1,'countryDelete','ps_country','delete','Удаляет запись о старне','storeadmin,admin'); INSERT INTO `jos_vm_function` VALUES (68,2,'product_csv','ps_csv','upload_csv','','admin'); INSERT INTO `jos_vm_function` VALUES (110,7,'waitingListAdd','zw_waiting_list','add','','none'); INSERT INTO `jos_vm_function` VALUES (111,13,'addzone','ps_zone','add','Добавление зоны','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (112,13,'updatezone','ps_zone','update','Изменение зоны','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (113,13,'deletezone','ps_zone','delete','Удаление зоны','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (114,13,'zoneassign','ps_zone','assign','Добавление страны к зоне','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (115,1,'writeConfig','ps_config','writeconfig','Записывает конфигурацию virtuemart.cfg.php','admin'); INSERT INTO `jos_vm_function` VALUES (116,14,'carrierAdd','ps_shipping','add','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (117,14,'carrierDelete','ps_shipping','delete','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (118,14,'carrierUpdate','ps_shipping','update','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (119,14,'rateAdd','ps_shipping','rate_add','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (120,14,'rateUpdate','ps_shipping','rate_update','','admin,shopadmin'); INSERT INTO `jos_vm_function` VALUES (121,14,'rateDelete','ps_shipping','rate_delete','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (122,10,'checkoutProcess','ps_checkout','process','','shopper,storeadmin,admin,demo'); INSERT INTO `jos_vm_function` VALUES (123,5,'downloadRequest','ps_order','download_request','This checks if the download request is valid and sends the file to the browser as file download if the request was successful, otherwise echoes an error','admin,storeadmin,shopper'); INSERT INTO `jos_vm_function` VALUES (124,15,'affiliateAdd','ps_affiliate','add','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (125,15,'affiliateUpdate','ps_affiliate','update','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (126,15,'affiliateDelete','ps_affiliate','delete','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (127,15,'affiliateEmail','ps_affiliate','email','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (128,16,'manufacturerAdd','ps_manufacturer','add','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (129,16,'manufacturerUpdate','ps_manufacturer','update','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (130,16,'manufacturerDelete','ps_manufacturer','delete','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (131,16,'manufacturercategoryAdd','ps_manufacturer_category','add','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (132,16,'manufacturercategoryUpdate','ps_manufacturer_category','update','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (133,16,'manufacturercategoryDelete','ps_manufacturer_category','delete','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (134,7,'addReview','ps_reviews','process_review','This lets the user add a review and rating to a product.','admin,storeadmin,shopper,demo'); INSERT INTO `jos_vm_function` VALUES (135,7,'productReviewDelete','ps_reviews','delete_review','This deletes a review and from a product.','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (136,8,'creditcardAdd','ps_creditcard','add','Adds a Credit Card entry.','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (137,8,'creditcardUpdate','ps_creditcard','update','Updates a Credit Card entry.','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (138,8,'creditcardDelete','ps_creditcard','delete','Deletes a Credit Card entry.','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (139,2,'changePublishState','vmAbstractObject.class','handlePublishState','Changes the publish field, so that a record can be published or unpublished easily.','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (140,2,'export_csv','ps_csv','export_csv','This function exports all relevant product data to CSV.','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (141,2,'reorder','ps_product_category','reorder','Changes the list order of a category.','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (142,2,'discountAdd','ps_product_discount','add','Adds a discount.','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (143,2,'discountUpdate','ps_product_discount','update','Updates a discount.','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (144,2,'discountDelete','ps_product_discount','delete','Deletes a discount.','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (145,8,'shippingmethodSave','ps_shipping_method','save','','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (146,2,'uploadProductFile','ps_product_files','add','Uploads and Adds a Product Image/File.','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (147,2,'updateProductFile','ps_product_files','update','Updates a Product Image/File.','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (148,2,'deleteProductFile','ps_product_files','delete','Deletes a Product Image/File.','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (149,18,'couponAdd','ps_coupon','add_coupon_code','Adds a Coupon.','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (150,18,'couponUpdate','ps_coupon','update_coupon','Updates a Coupon.','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (151,18,'couponDelete','ps_coupon','remove_coupon_code','Deletes a Coupon.','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (152,18,'couponProcess','ps_coupon','process_coupon_code','Processes a Coupon.','admin,storeadmin,shopper,demo'); INSERT INTO `jos_vm_function` VALUES (153,2,'ProductTypeAdd','ps_product_type','add','Function add a Product Type and create new table product_type_.','admin'); INSERT INTO `jos_vm_function` VALUES (154,2,'ProductTypeUpdate','ps_product_type','update','Update a Product Type.','admin'); INSERT INTO `jos_vm_function` VALUES (155,2,'ProductTypeDelete','ps_product_type','delete','Delete a Product Type and drop table product_type_.','admin'); INSERT INTO `jos_vm_function` VALUES (156,2,'ProductTypeReorder','ps_product_type','reorder','Changes the list order of a Product Type.','admin'); INSERT INTO `jos_vm_function` VALUES (157,2,'ProductTypeAddParam','ps_product_type_parameter','add_parameter','Function add a Parameter into a Product Type and create new column in table product_type_.','admin'); INSERT INTO `jos_vm_function` VALUES (158,2,'ProductTypeUpdateParam','ps_product_type_parameter','update_parameter','Function update a Parameter in a Product Type and a column in table product_type_.','admin'); INSERT INTO `jos_vm_function` VALUES (159,2,'ProductTypeDeleteParam','ps_product_type_parameter','delete_parameter','Function delete a Parameter from a Product Type and drop a column in table product_type_.','admin'); INSERT INTO `jos_vm_function` VALUES (160,2,'ProductTypeReorderParam','ps_product_type_parameter','reorder_parameter','Changes the list order of a Parameter.','admin'); INSERT INTO `jos_vm_function` VALUES (161,2,'productProductTypeAdd','ps_product_product_type','add','Add a Product into a Product Type.','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (162,2,'productProductTypeDelete','ps_product_product_type','delete','Delete a Product from a Product Type.','admin,storeadmin'); INSERT INTO `jos_vm_function` VALUES (163,1,'stateAdd','ps_country','addState','Add a State ','storeadmin,admin'); INSERT INTO `jos_vm_function` VALUES (164,1,'stateUpdate','ps_country','updateState','Update a state record','storeadmin,admin'); INSERT INTO `jos_vm_function` VALUES (165,1,'stateDelete','ps_country','deleteState','Delete a state record','storeadmin,admin'); INSERT INTO `jos_vm_function` VALUES (166,2,'csvFieldAdd','ps_csv','add','Add a CSV Field ','storeadmin,admin'); INSERT INTO `jos_vm_function` VALUES (167,2,'csvFieldUpdate','ps_csv','update','Update a CSV Field','storeadmin,admin'); INSERT INTO `jos_vm_function` VALUES (168,2,'csvFieldDelete','ps_csv','delete','Delete a CSV Field','storeadmin,admin'); INSERT INTO `jos_vm_function` VALUES (170,20,'export_yml','ps_csv','export_yml','Экспорт в Яндекс','none'); /*!40000 ALTER TABLE `jos_vm_function` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jos_vm_manufacturer` -- DROP TABLE IF EXISTS `jos_vm_manufacturer`; CREATE TABLE `jos_vm_manufacturer` ( `manufacturer_id` int(11) NOT NULL auto_increment, `mf_name` varchar(64) default NULL, `mf_email` varchar(255) default NULL, `mf_desc` text, `mf_category_id` int(11) default NULL, `mf_url` varchar(255) NOT NULL default '', PRIMARY KEY (`manufacturer_id`) ) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=cp1251 COMMENT='Производители товаров'; -- -- Dumping data for table `jos_vm_manufacturer` -- LOCK TABLES `jos_vm_manufacturer` WRITE; /*!40000 ALTER TABLE `jos_vm_manufacturer` DISABLE KEYS */; INSERT INTO `jos_vm_manufacturer` VALUES (5,'Atomic','','',1,''); INSERT INTO `jos_vm_manufacturer` VALUES (6,'Rossignol','','',1,''); INSERT INTO `jos_vm_manufacturer` VALUES (7,'Iron Horse','','',1,''); INSERT INTO `jos_vm_manufacturer` VALUES (8,'Cannondale','','',1,''); INSERT INTO `jos_vm_manufacturer` VALUES (9,'Panther','','',1,''); INSERT INTO `jos_vm_manufacturer` VALUES (10,'Rosec','','',1,''); INSERT INTO `jos_vm_manufacturer` VALUES (11,'Fila','','',1,''); /*!40000 ALTER TABLE `jos_vm_manufacturer` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jos_vm_manufacturer_category` -- DROP TABLE IF EXISTS `jos_vm_manufacturer_category`; CREATE TABLE `jos_vm_manufacturer_category` ( `mf_category_id` int(11) NOT NULL auto_increment, `mf_category_name` varchar(64) default NULL, `mf_category_desc` text, PRIMARY KEY (`mf_category_id`), KEY `idx_manufacturer_category_category_name` (`mf_category_name`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=cp1251 COMMENT='Категории производителей'; -- -- Dumping data for table `jos_vm_manufacturer_category` -- LOCK TABLES `jos_vm_manufacturer_category` WRITE; /*!40000 ALTER TABLE `jos_vm_manufacturer_category` DISABLE KEYS */; INSERT INTO `jos_vm_manufacturer_category` VALUES (1,'-по умолчанию-','Категория производителей по умолчанию'); /*!40000 ALTER TABLE `jos_vm_manufacturer_category` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jos_vm_module` -- DROP TABLE IF EXISTS `jos_vm_module`; CREATE TABLE `jos_vm_module` ( `module_id` int(11) NOT NULL auto_increment, `module_name` varchar(255) default NULL, `module_description` text, `module_perms` varchar(255) default NULL, `module_publish` char(1) default NULL, `list_order` int(11) default NULL, PRIMARY KEY (`module_id`), KEY `idx_module_name` (`module_name`), KEY `idx_module_list_order` (`list_order`) ) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=cp1251 COMMENT='Модули виртумарта'; -- -- Dumping data for table `jos_vm_module` -- LOCK TABLES `jos_vm_module` WRITE; /*!40000 ALTER TABLE `jos_vm_module` DISABLE KEYS */; INSERT INTO `jos_vm_module` VALUES (1,'admin','

ТОЛЬКО ДЛЯ АДМИНИСТРАТОРОВ

\r\n\r\n

могут пользовать следующим:

\r\n
    \r\n\r\n
  1. Создание пользователей
    2. \r\n
  2. Создание модулей
    3. \r\n
  3. Создание функций
    4. \r\n
\r\n','admin','Y',1); INSERT INTO `jos_vm_module` VALUES (2,'product','

Здесь вы можете управлять вашим онлайн каталогом товаров. Администратор каталога может дать права вам на создание категорий товара, создание новых товаров, редактирования свойств товара, и позиций товара для каждого значения свойства .

','storeadmin,admin','Y',4); INSERT INTO `jos_vm_module` VALUES (3,'vendor','

ТОЛЬКО ДЛЯ АДМИНИСТРАТОРОВ

\r\n

Здесь вы можете управлять продавцами в Виртумарте.

','admin','Y',6); INSERT INTO `jos_vm_module` VALUES (4,'shopper','

Управление клиентами в вашем магазине. Позволяет создавать группы клиентов. Группы клиентов могут быть использованы когда настравивается стоимость товара. Это позволяет создавать различные цены для различных типов пользователей. Для примера вы можете группы могут быть \'Обычные\' и \'Превилигированные\' group.

','admin,storeadmin','Y',4); INSERT INTO `jos_vm_module` VALUES (5,'order','

Посмотреть Заказ и Изменить статус заказа.

','admin,storeadmin','Y',5); INSERT INTO `jos_vm_module` VALUES (6,'msgs','Модуль незащищен и используется для показа системных сообщений пользователям. Если происходит ошибка или предупреждение мы должны видеть их без авторизации.','none','N',99); INSERT INTO `jos_vm_module` VALUES (7,'shop','Это модуль магазина \"3456.ru\" . Этот демо магазин включен в дистрибутив русского виртумарта.','none','Y',99); INSERT INTO `jos_vm_module` VALUES (8,'store','','storeadmin,admin','Y',2); INSERT INTO `jos_vm_module` VALUES (9,'account','Этот модуль позволяет клиентом обновлять свой профиль и просмотра предыдущих заказов.','shopper,storeadmin,admin,demoshopper,storeadmin,admin,demo','y',99); INSERT INTO `jos_vm_module` VALUES (10,'checkout','','none','N',99); INSERT INTO `jos_vm_module` VALUES (11,'tax','Модуль доставки, позволяет устанавливать стоимость доставки в различные регионы и страны. Ставка устанавливается в десятичной форме. Для примера, 2 процента будет 0.02.','admin,storeadmin','Y',8); INSERT INTO `jos_vm_module` VALUES (12,'reportbasic','Основной модуль отчетов, позволяет вам делать отчеты по всем заказам.','admin,storeadmin','Y',7); INSERT INTO `jos_vm_module` VALUES (13,'zone','Это модуль доставки по зонам. Здесь вы можете управлять стоимостью вашей доставки в различные зоны.','admin,storeadmin','N',9); INSERT INTO `jos_vm_module` VALUES (14,'shipping','

Доставка

Этот модуль вычисляет стоимость достаки для покупателя.
Создайте несущие для зон доставки и весовых групп.

','admin,storeadmin','Y',10); INSERT INTO `jos_vm_module` VALUES (15,'affiliate','управление партнерскими программами для вашего магазина.','storeadmin,admin','N',99); INSERT INTO `jos_vm_module` VALUES (16,'manufacturer','Управление производителями в вашем магазине.','storeadmin,admin','Y',12); INSERT INTO `jos_vm_module` VALUES (17,'help','Модуль помощи','admin,storeadmin','Y',13); INSERT INTO `jos_vm_module` VALUES (18,'coupon','Управление купонами','admin,storeadmin','Y',11); INSERT INTO `jos_vm_module` VALUES (20,'export_yml','Экспорт в яндекс','admin,storeadmin','N',99); /*!40000 ALTER TABLE `jos_vm_module` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jos_vm_order_history` -- DROP TABLE IF EXISTS `jos_vm_order_history`; CREATE TABLE `jos_vm_order_history` ( `order_status_history_id` int(11) NOT NULL auto_increment, `order_id` int(11) NOT NULL default '0', `order_status_code` char(1) NOT NULL default '0', `date_added` datetime NOT NULL default '0000-00-00 00:00:00', `customer_notified` int(1) default '0', `comments` text, PRIMARY KEY (`order_status_history_id`) ) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=cp1251 COMMENT='История'; -- -- Dumping data for table `jos_vm_order_history` -- LOCK TABLES `jos_vm_order_history` WRITE; /*!40000 ALTER TABLE `jos_vm_order_history` DISABLE KEYS */; INSERT INTO `jos_vm_order_history` VALUES (1,1,'P','2007-11-13 13:11:16',1,''); INSERT INTO `jos_vm_order_history` VALUES (2,2,'P','2007-11-19 18:33:58',1,''); INSERT INTO `jos_vm_order_history` VALUES (3,3,'P','2007-11-19 18:34:49',1,''); INSERT INTO `jos_vm_order_history` VALUES (4,4,'P','2007-11-19 18:42:24',1,''); INSERT INTO `jos_vm_order_history` VALUES (5,5,'P','2007-11-20 08:14:52',1,''); INSERT INTO `jos_vm_order_history` VALUES (6,6,'P','2007-11-22 14:05:19',1,''); INSERT INTO `jos_vm_order_history` VALUES (7,7,'P','2007-11-22 14:06:42',1,''); INSERT INTO `jos_vm_order_history` VALUES (8,7,'R','2007-11-22 14:15:41',0,''); INSERT INTO `jos_vm_order_history` VALUES (9,7,'S','2007-11-22 14:16:42',1,''); INSERT INTO `jos_vm_order_history` VALUES (10,8,'P','2007-11-22 14:21:56',1,''); INSERT INTO `jos_vm_order_history` VALUES (11,9,'P','2007-11-22 14:29:17',1,''); INSERT INTO `jos_vm_order_history` VALUES (12,9,'S','2007-11-22 14:29:44',1,''); INSERT INTO `jos_vm_order_history` VALUES (13,10,'P','2007-11-22 14:38:11',1,''); INSERT INTO `jos_vm_order_history` VALUES (14,10,'S','2007-11-22 14:38:29',1,''); INSERT INTO `jos_vm_order_history` VALUES (15,11,'P','2007-11-27 17:23:19',1,''); /*!40000 ALTER TABLE `jos_vm_order_history` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jos_vm_order_item` -- DROP TABLE IF EXISTS `jos_vm_order_item`; CREATE TABLE `jos_vm_order_item` ( `order_item_id` int(11) NOT NULL auto_increment, `order_id` int(11) default NULL, `user_info_id` varchar(32) default NULL, `vendor_id` int(11) default NULL, `product_id` int(11) default NULL, `order_item_sku` varchar(64) NOT NULL default '', `order_item_name` varchar(64) NOT NULL default '', `product_quantity` int(11) default NULL, `product_item_price` decimal(15,5) default NULL, `product_final_price` decimal(12,2) NOT NULL default '0.00', `order_item_currency` varchar(16) default NULL, `order_status` char(1) default NULL, `cdate` int(11) default NULL, `mdate` int(11) default NULL, `product_attribute` text, PRIMARY KEY (`order_item_id`), KEY `idx_order_item_order_id` (`order_id`), KEY `idx_order_item_user_info_id` (`user_info_id`), KEY `idx_order_item_vendor_id` (`vendor_id`) ) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=cp1251 COMMENT='Хранит все позиции которые являю'; -- -- Dumping data for table `jos_vm_order_item` -- LOCK TABLES `jos_vm_order_item` WRITE; /*!40000 ALTER TABLE `jos_vm_order_item` DISABLE KEYS */; INSERT INTO `jos_vm_order_item` VALUES (1,1,'b32b0a58029cac587c37ad50cbdc9aea',1,11,'Mirta Soia 3 Franc',' Диван-кровать София 3х местный',1,'18000.00000','19485.00','RUB','P',1194948676,1194948676,''); INSERT INTO `jos_vm_order_item` VALUES (2,2,'',1,1,'v-3','Диван Виктория 3',1,'9000.00000','9000.00','RUB','P',1195486438,1195486438,'obivka :red'); INSERT INTO `jos_vm_order_item` VALUES (3,3,'',1,15,'Viktoria 1','Диван-книжка Виктория 1',1,'6000.00000','6000.00','RUB','P',1195486489,1195486489,''); INSERT INTO `jos_vm_order_item` VALUES (4,4,'',1,15,'Viktoria 1','Диван-книжка Виктория 1',1,'6000.00000','6000.00','RUB','P',1195486944,1195486944,''); INSERT INTO `jos_vm_order_item` VALUES (5,5,'',1,8,'Viktoria 5 kr-k','Кресло-кровать Виктория 5',1,'4500.00000','4500.00','RUB','P',1195535692,1195535692,''); INSERT INTO `jos_vm_order_item` VALUES (6,6,'',1,16,'123456','фото1',1,'100.00000','100.00','RUB','P',1195729519,1195729519,''); INSERT INTO `jos_vm_order_item` VALUES (7,7,'b32b0a58029cac587c37ad50cbdc9aea',1,16,'123456','фото1',1,'100.00000','108.25','RUB','S',1195729602,1195730202,''); INSERT INTO `jos_vm_order_item` VALUES (8,8,'b32b0a58029cac587c37ad50cbdc9aea',1,16,'123456','фото1',2,'0.00000','0.00','RUB','P',1195730516,1195730516,''); INSERT INTO `jos_vm_order_item` VALUES (9,8,'b32b0a58029cac587c37ad50cbdc9aea',1,15,'Viktoria 1','Диван-книжка Виктория 1',1,'6000.00000','6495.00','RUB','P',1195730516,1195730516,''); INSERT INTO `jos_vm_order_item` VALUES (10,9,'b32b0a58029cac587c37ad50cbdc9aea',1,16,'123456','фото1',1,'100.00000','108.25','RUB','S',1195730957,1195730984,''); INSERT INTO `jos_vm_order_item` VALUES (11,10,'b32b0a58029cac587c37ad50cbdc9aea',1,16,'123456','фото1',1,'100.00000','108.25','RUB','S',1195731491,1195731509,''); INSERT INTO `jos_vm_order_item` VALUES (12,11,'',1,27,'333','Rosec Chn',1,'1753.00000','1753.00','RUB','P',1196173399,1196173399,''); INSERT INTO `jos_vm_order_item` VALUES (13,11,'',0,18,'112','Atomic Bluemoon',1000,'14900.00000','14900.00','RUB','P',1196173399,1196173399,''); /*!40000 ALTER TABLE `jos_vm_order_item` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jos_vm_order_payment` -- DROP TABLE IF EXISTS `jos_vm_order_payment`; CREATE TABLE `jos_vm_order_payment` ( `order_id` int(11) NOT NULL default '0', `payment_method_id` int(11) default NULL, `order_payment_code` varchar(30) NOT NULL default '', `order_payment_number` blob, `order_payment_expire` int(11) default NULL, `order_payment_name` varchar(255) default NULL, `order_payment_log` text, `order_payment_trans_id` text NOT NULL, KEY `idx_order_payment_order_id` (`order_id`), KEY `idx_order_payment_method_id` (`payment_method_id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COMMENT='Способы оплаты которые были выбр'; -- -- Dumping data for table `jos_vm_order_payment` -- LOCK TABLES `jos_vm_order_payment` WRITE; /*!40000 ALTER TABLE `jos_vm_order_payment` DISABLE KEYS */; INSERT INTO `jos_vm_order_payment` VALUES (1,25,'','',943995600,'','',''); INSERT INTO `jos_vm_order_payment` VALUES (7,25,'','',943995600,'','',''); INSERT INTO `jos_vm_order_payment` VALUES (8,2,'','',943995600,'','Информация для оплаты получена и сохранена для дальнейшей обработки.
',''); INSERT INTO `jos_vm_order_payment` VALUES (9,2,'','',943995600,'','Информация для оплаты получена и сохранена для дальнейшей обработки.
',''); INSERT INTO `jos_vm_order_payment` VALUES (10,2,'','',943995600,'','Информация для оплаты получена и сохранена для дальнейшей обработки.
',''); /*!40000 ALTER TABLE `jos_vm_order_payment` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jos_vm_order_status` -- DROP TABLE IF EXISTS `jos_vm_order_status`; CREATE TABLE `jos_vm_order_status` ( `order_status_id` int(11) NOT NULL auto_increment, `order_status_code` char(1) NOT NULL default '', `order_status_name` varchar(64) default NULL, `list_order` int(11) default NULL, `vendor_id` int(11) default NULL, PRIMARY KEY (`order_status_id`), KEY `idx_order_status_list_order` (`list_order`), KEY `idx_order_status_vendor_id` (`vendor_id`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=cp1251 COMMENT='Все доступные способы заказа'; -- -- Dumping data for table `jos_vm_order_status` -- LOCK TABLES `jos_vm_order_status` WRITE; /*!40000 ALTER TABLE `jos_vm_order_status` DISABLE KEYS */; INSERT INTO `jos_vm_order_status` VALUES (1,'P','Ожидание',1,1); INSERT INTO `jos_vm_order_status` VALUES (2,'C','Подтверждено',2,1); INSERT INTO `jos_vm_order_status` VALUES (3,'X','Отменено',3,1); INSERT INTO `jos_vm_order_status` VALUES (4,'R','Оплачено',4,1); INSERT INTO `jos_vm_order_status` VALUES (5,'S','Доставлено',5,1); /*!40000 ALTER TABLE `jos_vm_order_status` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jos_vm_order_user_info` -- DROP TABLE IF EXISTS `jos_vm_order_user_info`; CREATE TABLE `jos_vm_order_user_info` ( `order_info_id` int(11) NOT NULL auto_increment, `order_id` int(11) NOT NULL default '0', `user_id` int(11) NOT NULL default '0', `address_type` char(2) default NULL, `address_type_name` varchar(32) default NULL, `company` varchar(64) default NULL, `title` varchar(32) default NULL, `last_name` varchar(32) default NULL, `first_name` varchar(32) default NULL, `middle_name` varchar(32) default NULL, `phone_1` varchar(32) default NULL, `phone_2` varchar(32) default NULL, `fax` varchar(32) default NULL, `address_1` varchar(64) NOT NULL default '', `address_2` varchar(64) default NULL, `city` varchar(32) NOT NULL default '', `state` varchar(32) NOT NULL default '', `country` varchar(32) NOT NULL default 'US', `zip` varchar(32) NOT NULL default '', `user_email` varchar(255) default NULL, `extra_field_1` varchar(255) default NULL, `extra_field_2` varchar(255) default NULL, `extra_field_3` varchar(255) default NULL, `extra_field_4` char(1) default NULL, `extra_field_5` char(1) default NULL, `bank_account_nr` varchar(32) NOT NULL default '', `bank_name` varchar(32) NOT NULL default '', `bank_sort_code` varchar(16) NOT NULL default '', `bank_iban` varchar(64) NOT NULL default '', `bank_account_holder` varchar(48) NOT NULL default '', `bank_account_type` enum('Checking','Business Checking','Savings') NOT NULL default 'Checking', PRIMARY KEY (`order_info_id`), KEY `idx_order_info_order_id` (`order_id`) ) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=cp1251 COMMENT='Хранит информацию ОплатитьВ и До'; -- -- Dumping data for table `jos_vm_order_user_info` -- LOCK TABLES `jos_vm_order_user_info` WRITE; /*!40000 ALTER TABLE `jos_vm_order_user_info` DISABLE KEYS */; INSERT INTO `jos_vm_order_user_info` VALUES (1,1,62,'BT',NULL,'Конко-ко','Г-жа','Главная','Администратор','нет','322-22-33','','','1-2-3','','Вешки','80','RUS','113326','kalinova@nicmail.ru','','','','','','','','','','','Checking'); INSERT INTO `jos_vm_order_user_info` VALUES (2,2,0,'BT','-default-','','','','Васечкин','','1111111','','','Москва','','','','','','elenika@bk.ru','','','','','','','','','','',''); INSERT INTO `jos_vm_order_user_info` VALUES (3,3,0,'BT','-default-','','','','fsdf','','1111111','','','варпва','','','','','','elenika@bk.ru','','','','','','','','','','',''); INSERT INTO `jos_vm_order_user_info` VALUES (4,4,0,'BT','-default-','','','','ertwe4t','','1111111','','','Москва, Молодежная 100','','','','','','elenika@bk.ru','','','','','','','','','','',''); INSERT INTO `jos_vm_order_user_info` VALUES (5,5,0,'BT','-default-','','','','Хома','','7776655','','','Зеленая долина третий холм слева','','','','','','bronton@yandex.ru','','','','','','','','','','',''); INSERT INTO `jos_vm_order_user_info` VALUES (6,6,0,'BT','-default-','','','','hgkj','','1234567','','','Москва? 100','','','','','','kalinova@nicmail.ru','','','','','','','','','','',''); INSERT INTO `jos_vm_order_user_info` VALUES (7,7,62,'BT',NULL,'Конко-ко','Г-жа','Главная','Администратор','нет','322-22-33','','','1-2-3','','Вешки','80','RUS','113326','kalinova@nicmail.ru','','','','','','','','','','','Checking'); INSERT INTO `jos_vm_order_user_info` VALUES (8,8,62,'BT',NULL,'Конко-ко','Г-жа','Главная','Администратор','нет','322-22-33','','','1-2-3','','Вешки','80','RUS','113326','kalinova@nicmail.ru','','','','','','','','','','','Checking'); INSERT INTO `jos_vm_order_user_info` VALUES (9,9,62,'BT',NULL,'Конко-ко','Г-жа','Главная','Администратор','нет','322-22-33','','','1-2-3','','Вешки','80','RUS','113326','kalinova@nicmail.ru','','','','','','','','','','','Checking'); INSERT INTO `jos_vm_order_user_info` VALUES (10,10,62,'BT',NULL,'Конко-ко','Г-жа','Главная','Администратор','нет','322-22-33','','','1-2-3','','Вешки','80','RUS','113326','kalinova@nicmail.ru','','','','','','','','','','','Checking'); INSERT INTO `jos_vm_order_user_info` VALUES (11,11,0,'BT','-default-','','','','gkjh','','1234567','','','москва,100','','','','','','','','','','','','','','','','',''); /*!40000 ALTER TABLE `jos_vm_order_user_info` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jos_vm_orders` -- DROP TABLE IF EXISTS `jos_vm_orders`; CREATE TABLE `jos_vm_orders` ( `order_id` int(11) NOT NULL auto_increment, `user_id` int(11) NOT NULL default '0', `vendor_id` int(11) NOT NULL default '0', `order_number` varchar(32) default NULL, `user_info_id` varchar(32) default NULL, `order_total` decimal(15,2) NOT NULL default '0.00', `order_subtotal` decimal(15,5) default NULL, `order_tax` decimal(10,2) default NULL, `order_tax_details` text NOT NULL, `order_shipping` decimal(10,2) default NULL, `order_shipping_tax` decimal(10,2) default NULL, `coupon_discount` decimal(12,2) NOT NULL default '0.00', `order_discount` decimal(12,2) NOT NULL default '0.00', `order_currency` varchar(16) default NULL, `order_status` char(1) default NULL, `cdate` int(11) default NULL, `mdate` int(11) default NULL, `ship_method_id` varchar(255) default NULL, `customer_note` text NOT NULL, `ip_address` varchar(15) NOT NULL default '', PRIMARY KEY (`order_id`), KEY `idx_orders_user_id` (`user_id`), KEY `idx_orders_vendor_id` (`vendor_id`), KEY `idx_orders_order_number` (`order_number`), KEY `idx_orders_user_info_id` (`user_info_id`), KEY `idx_orders_ship_method_id` (`ship_method_id`) ) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=cp1251 COMMENT='Используется для хранения заказ?'; -- -- Dumping data for table `jos_vm_orders` -- LOCK TABLES `jos_vm_orders` WRITE; /*!40000 ALTER TABLE `jos_vm_orders` DISABLE KEYS */; INSERT INTO `jos_vm_orders` VALUES (1,62,1,'187efcea109703baab1b547d56e25db1','b32b0a58029cac587c37ad50cbdc9aea','21045.97','18000.00000','1485.00','a:1:{s:6:\"0.0825\";d:118.964999999999918145476840436458587646484375;}','1442.00','118.97','0.00','0.00','RUB','P',1194948676,1194948676,'flex|STD|Стандартная доставка больше 25.00|1560.965','','194.226.46.202'); INSERT INTO `jos_vm_orders` VALUES (2,0,1,'7d7be614be59461dc7031a9fc4b3222c','','9000.46','9000.46189','0.00','','0.00','0.00','0.00','0.00','RUB','P',1195486438,1195486438,'','','194.226.46.208'); INSERT INTO `jos_vm_orders` VALUES (3,0,1,'05ae46069b466c27f825916489b252c8','','6000.00','6000.00000','0.00','','0.00','0.00','0.00','0.00','RUB','P',1195486489,1195486489,'','','194.226.46.208'); INSERT INTO `jos_vm_orders` VALUES (4,0,1,'e735399508d9d4405ef53411d3d8c26a','','6000.00','6000.00000','0.00','N;','0.00','0.00','0.00','0.00','RUB','P',1195486944,1195486944,'','','194.226.46.208'); INSERT INTO `jos_vm_orders` VALUES (5,0,1,'463a4be3bf3303701c3bd630e61b1259','','4499.77','4499.76905','0.00','N;','0.00','0.00','0.00','0.00','RUB','P',1195535692,1195535692,'','Покупка без регистрации','194.226.46.202'); INSERT INTO `jos_vm_orders` VALUES (6,0,1,'d850ab719a469c399649be2c448770bf','','99.77','99.76905','0.00','N;','0.00','0.00','0.00','0.00','RUB','P',1195729519,1195729519,'','','194.226.46.208'); INSERT INTO `jos_vm_orders` VALUES (7,62,1,'0c73cfeebb0e2d9765180d99181d4478','b32b0a58029cac587c37ad50cbdc9aea','118.82','99.76905','8.25','a:1:{s:6:\"0.0825\";d:0.8234757505773675489990637288428843021392822265625;}','9.98','0.82','0.00','0.00','RUB','S',1195729602,1195730202,'flex|STD|Стандартная доставка больше 25.00|10.805','','194.226.46.208'); INSERT INTO `jos_vm_orders` VALUES (8,62,1,'a85d03a23807382ac8a2778c59ed2982','b32b0a58029cac587c37ad50cbdc9aea','7018.77','6000.00000','495.15','a:1:{s:6:\"0.0825\";d:39.7649999999999863575794734060764312744140625;}','482.00','39.77','0.00','-2.00','RUB','P',1195730516,1195730516,'flex|STD|Стандартная доставка больше 25.00|521.765','','194.226.46.208'); INSERT INTO `jos_vm_orders` VALUES (9,62,1,'6cb06cd4aa00aa213a0965b3b927bae4','b32b0a58029cac587c37ad50cbdc9aea','120.82','99.76905','8.40','a:1:{s:6:\"0.0825\";d:0.8234757505773675489990637288428843021392822265625;}','9.98','0.82','0.00','-2.00','RUB','S',1195730957,1195730984,'flex|STD|Стандартная доставка больше 25.00|10.805','','194.226.46.208'); INSERT INTO `jos_vm_orders` VALUES (10,62,1,'68b4ff45a97f3936219af5f8597293b1','b32b0a58029cac587c37ad50cbdc9aea','120.82','99.76905','8.40','a:1:{s:6:\"0.0825\";d:0.8234757505773675489990637288428843021392822265625;}','9.98','0.82','0.00','-2.00','RUB','S',1195731491,1195731509,'flex|STD|Стандартная доставка больше 25.00|10.805','','194.226.46.208'); INSERT INTO `jos_vm_orders` VALUES (11,0,1,'b35d94d1393bd2e5699e417a7ada5364','','14901522.40','14901522.40184','0.00','N;','0.00','0.00','0.00','0.00','RUB','P',1196173399,1196173399,'','','194.226.46.208'); /*!40000 ALTER TABLE `jos_vm_orders` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jos_vm_payment_method` -- DROP TABLE IF EXISTS `jos_vm_payment_method`; CREATE TABLE `jos_vm_payment_method` ( `payment_method_id` int(11) NOT NULL auto_increment, `vendor_id` int(11) default NULL, `payment_method_name` varchar(255) default NULL, `payment_class` varchar(50) NOT NULL default '', `shopper_group_id` int(11) default NULL, `payment_method_discount` decimal(12,2) default NULL, `list_order` int(11) default NULL, `payment_method_code` varchar(8) default NULL, `enable_processor` char(1) default NULL, `is_creditcard` tinyint(1) NOT NULL default '0', `payment_enabled` char(1) NOT NULL default 'N', `accepted_creditcards` varchar(128) NOT NULL default '', `payment_extrainfo` text NOT NULL, `payment_passkey` blob NOT NULL, PRIMARY KEY (`payment_method_id`), KEY `idx_payment_method_vendor_id` (`vendor_id`), KEY `idx_payment_method_name` (`payment_method_name`), KEY `idx_payment_method_list_order` (`list_order`), KEY `idx_payment_method_shopper_group_id` (`shopper_group_id`) ) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=cp1251 COMMENT='Методы оплаты для вашего магазин'; -- -- Dumping data for table `jos_vm_payment_method` -- LOCK TABLES `jos_vm_payment_method` WRITE; /*!40000 ALTER TABLE `jos_vm_payment_method` DISABLE KEYS */; INSERT INTO `jos_vm_payment_method` VALUES (1,1,'Оплата при заказе','',6,'0.00',4,'PO','N',0,'Y','','',''); INSERT INTO `jos_vm_payment_method` VALUES (2,1,'Оплата при получении','',5,'-2.00',5,'COD','N',0,'Y','','',''); INSERT INTO `jos_vm_payment_method` VALUES (3,1,'Оплата по кредитной карте','ps_authorize',5,'0.00',0,'AN','Y',0,'Y','1,2,6,7,','',''); INSERT INTO `jos_vm_payment_method` VALUES (4,1,'Оплата через PayPal','ps_paypal',5,'0.00',0,'PP','P',0,'Y','','',''); INSERT INTO `jos_vm_payment_method` VALUES (5,1,'PayMate','ps_paymate',5,'0.00',0,'PM','P',0,'N','',' \n
\n

\n \n \"Pay\n
click here to pay your account\n

\n
',''); INSERT INTO `jos_vm_payment_method` VALUES (6,1,'WorldPay','ps_worldpay',5,'0.00',0,'WP','P',0,'N','','
\n \n \" />\n f(\"order_id\") ?>\" />\n f(\"order_total\") ?>\" />\n \" />\n \n email?>\" />\n address_1?> address_2?> city?> state?>\" />\n title?>first_name?>. middle_name?>last_name?>\" />\n country?>\"/>\n zip?>\" />\n phone_1?>\">\n \n
\n \n
',''); INSERT INTO `jos_vm_payment_method` VALUES (7,1,'2Checkout','ps_twocheckout',5,'0.00',0,'2CO','P',0,'N','','f(\"user_info_id\").\"\'\";\n $dbbt = new ps_DB;\n $dbbt->setQuery($q);\n $dbbt->query();\n $dbbt->next_record();\n // Get ship_to information\n if( $db->f(\"user_info_id\") != $dbbt->f(\"user_info_id\")) {\n $q2 = \"SELECT * FROM #__vm_user_info WHERE user_info_id=\'\".$db->f(\"user_info_id\").\"\'\";\n $dbst = new ps_DB;\n $dbst->setQuery($q2);\n $dbst->query();\n $dbst->next_record();\n }\n else {\n $dbst = $dbbt;\n }\n\n //Authnet vars to send\n $formdata = array (\n \'x_login\' => TWOCO_LOGIN,\n \'x_email_merchant\' => ((TWOCO_MERCHANT_EMAIL == \'True\') ? \'TRUE\' : \'FALSE\'),\n\n // Customer Name and Billing Address\n \'x_first_name\' => $dbbt->f(\"first_name\"),\n \'x_last_name\' => $dbbt->f(\"last_name\"),\n \'x_company\' => $dbbt->f(\"company\"),\n \'x_address\' => $dbbt->f(\"address_1\"),\n \'x_city\' => $dbbt->f(\"city\"),\n \'x_state\' => $dbbt->f(\"state\"),\n \'x_zip\' => $dbbt->f(\"zip\"),\n \'x_country\' => $dbbt->f(\"country\"),\n \'x_phone\' => $dbbt->f(\"phone_1\"),\n \'x_fax\' => $dbbt->f(\"fax\"),\n \'x_email\' => $dbbt->f(\"email\"),\n\n // Customer Shipping Address\n \'x_ship_to_first_name\' => $dbst->f(\"first_name\"),\n \'x_ship_to_last_name\' => $dbst->f(\"last_name\"),\n \'x_ship_to_company\' => $dbst->f(\"company\"),\n \'x_ship_to_address\' => $dbst->f(\"address_1\"),\n \'x_ship_to_city\' => $dbst->f(\"city\"),\n \'x_ship_to_state\' => $dbst->f(\"state\"),\n \'x_ship_to_zip\' => $dbst->f(\"zip\"),\n \'x_ship_to_country\' => $dbst->f(\"country\"),\n\n \'x_invoice_num\' => $db->f(\"order_number\"),\n \'x_receipt_link_url\' => SECUREURL.\"2checkout_notify.php\"\n );\n\n if( TWOCO_TESTMODE == \"Y\" )\n $formdata[\'demo\'] = \"Y\";\n\n $version = \"2\";\n $url = \"https://www2.2checkout.com/2co/buyer/purchase\";\n $formdata[\'x_amount\'] = number_format($db->f(\"order_total\"), 2, \'.\', \'\');\n\n //build the post string\n $poststring = \'\';\n foreach($formdata AS $key => $val){\n $poststring .= \"\n \";\n }\n\n ?>\n
\" method=\"post\" target=\"_blank\">\n \n

Click on the Image below to pay...

\n \n
',''); INSERT INTO `jos_vm_payment_method` VALUES (8,1,'Оплата по NoChex','ps_nochex',5,'0.00',0,'NOCHEX','P',0,'N','','
\n \" />\n f(\"order_total\"))?>\" />\n p(\"order_id\") ?>\" />\n \" />\n f(\"order_id\") ?>\" />\n \n
',''); INSERT INTO `jos_vm_payment_method` VALUES (9,1,'Оплата по кредитной карте (PayMeNow)','ps_paymenow',5,'0.00',0,'PN','Y',0,'N','1,2,3,','',''); INSERT INTO `jos_vm_payment_method` VALUES (10,1,'Оплата по eWay','ps_eway',5,'0.00',0,'EW','Y',0,'N','','',''); INSERT INTO `jos_vm_payment_method` VALUES (11,1,'Оплата по eCheck.net','ps_echeck',5,'0.00',0,'ECK','B',0,'N','','',''); INSERT INTO `jos_vm_payment_method` VALUES (12,1,'Оплата по кредитной карте (eProcessingNetwork)','ps_epn',5,'0.00',0,'EPN','Y',0,'N','1,2,3,','',''); INSERT INTO `jos_vm_payment_method` VALUES (13,1,'Оплата по iKobo','',5,'0.00',0,'IK','P',0,'N','','
\n Щелкните по картинке ниже чтобы оплатить Pay with iKobo\n \n \n p(\"order_id\") ?>>\n f(\"order_total\"))?>\" />\n first_name?>\" />\n last_name?>\" />\n address_1?> address_2?>\" />\n city?>\" />\n state?>\" />\n zip?>\" />\n phone_1?>\" />\n email?>\" />\n
>',''); INSERT INTO `jos_vm_payment_method` VALUES (14,1,'Оплата по iTransact','',5,'0.00',0,'ITR','P',0,'N','','f(\"order_total\");$first_name = $user->first_name;$last_name = $user->last_name;$address = $user->address_1;$city = $user->city;$state = $user->state;$zip = $user->zip;$country = $user->country;$email = $user->email;$phone = $user->phone_1;$home_page = $mosConfig_live_site.\"/index.php\";$ret_addr = $mosConfig_live_site.\"/index.php\";$cc_payment_image = $mosConfig_live_site.\"/components/com_virtuemart/shop_image/ps_image/cc_payment.jpg\";\n ?>\n
\n \" />\n \" />\n \" />\n \" />\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\n \n \" />\n \n \" />\n \" />\n \" />\n \" />\n \" />\n \" />\n \" />\n \" />\n \" />\n \" />\n

\" />

\n
',''); INSERT INTO `jos_vm_payment_method` VALUES (17,1,'RUS yandex-деньги','ps_yandex',5,'0.00',0,'YNX','P',0,'Y','','\n
\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n',''); INSERT INTO `jos_vm_payment_method` VALUES (19,1,'RUS rupay','ps_rupay',5,'0.00',0,'RPY','P',0,'Y','',' f(\"payment_class\").\".php\" );\r\n\r\n$rupay = new ps_rupay();\r\n\r\nswitch($task) {\r\n case \"send\":\r\n $method = mosGetParam($_REQUEST, \"method\");\r\n $amount = mosGetParam($_REQUEST, \"amount\");\r\n $currency = mosGetParam($_REQUEST, \"currency\");\r\n $order_id = intval(mosGetParam($_REQUEST, \"order_id\"));\r\n $customer_note = mosGetParam($_REQUEST, \"customer_note\", \"\");\r\n if( !$result = $rupay->get_payment_properties( $order_id, $method, $currency, $amount ) )\r\n echo $VM_LANG->PHPSHOP_RUPAY_ERROR_GET_PAYMENT_PROPERTIES;\r\n else\r\n echo $result;\r\n break;\r\n\r\n case \"check\":\r\n if( !$result = $rupay->check_payment_status( ) )\r\n echo $VM_LANG->PHPSHOP_RUPAY_ERROR_CHECK_PAYMENT_STATUS;\r\n else\r\n echo $result;\r\n break;\r\n\r\n case \"show\":\r\n default:\r\n $order_id = intval(mosGetParam($vars, \"order_id\"));\r\n if( !$result = $rupay->get_payment_methods( $order_id, $_SESSION[\"vendor_currency\"], round( $db->f(\"order_subtotal\")+$tax_total-$discount_total, 2)) ) {\r\n echo $VM_LANG->PHPSHOP_RUPAY_ERROR_GET_PAYMENT_METHODS;\r\n }\r\n else {\r\n echo $result;\r\n }\r\n break;\r\n}\r\n\r\n?>',''); INSERT INTO `jos_vm_payment_method` VALUES (22,1,'RUS webmoney','ps_webmoney',5,'0.00',0,'WBM','P',0,'Y','','',''); INSERT INTO `jos_vm_payment_method` VALUES (23,1,'Оплата по Dankort / PBS','ps_pbs',5,'0.00',0,'PBS','P',0,'N','','',''); INSERT INTO `jos_vm_payment_method` VALUES (24,1,'Оплата по PayFlow Pro','ps_pfp',5,'0.00',0,'PFP','Y',0,'N','1,2,6,7,','',''); INSERT INTO `jos_vm_payment_method` VALUES (25,1,'Квитанция Сбербанка','ps_kvit',5,'0.00',0,'kvit','P',0,'Y','',' \r\n \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
\r\n
Квитанция:
\r\n 		\r\n \r\n \r\n \r\n \r\n
\r\n
\r\n
; margin: auto;\\\" align=center>\r\n\r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
Извещение
\r\n  
\r\n Кассир		 \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
Форма № ПД-4
(наименование получателя платежа)
\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
ИНН:   р/с
(ИНН получателя платежа)   (номер счета получателя платежа)
\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
в  БИК  
(наименование банка получателя платежа)
\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
Номер кор./сч. банка получателя платежа  
\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
Платеж № f(\\\"order_id\\\"))?>    
(наименование платежа)   (номер лицевого счета (код) плательщика)
\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
Ф.И.О. плательщика    \r\n
\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
Адрес плательщика    \r\n
\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
Сумма платежа f(\\\"order_total\\\"))?> руб.   Сумма платы за услуги  _____ руб. ____ коп.
\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
Итого  _______ руб. ____ коп. г.
\r\n \r\n \r\n \r\n \r\n \r\n \r\n
С условиями приема указанной в платежном документе суммы, в т.ч. с суммой взимаемой платы за услуги банка, ознакомлен и согласен.
\r\n \r\n \r\n \r\n \r\n \r\n \r\n
Подпись плательщика _____________________
 
\r\n Квитанция
\r\n  
\r\n Кассир		 \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
 
(наименование получателя платежа)
\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
ИНН:   р/с
(ИНН получателя платежа)   (номер счета получателя платежа)
\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
в  БИК  
(наименование банка получателя платежа)
Номер кор./сч. банка получателя платежа  
\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
Платеж № f(\\\"order_id\\\"))?>    
(наименование платежа)   (номер лицевого счета (код) плательщика)
\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
Ф.И.О. плательщика    \r\n
\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
Адрес плательщика    \r\n
\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
Сумма платежа f(\\\"order_total\\\"))?> руб.   Сумма платы за услуги  _____ руб. ____ коп.
\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
Итого  _______ руб. ____ коп. г.
\r\n \r\n \r\n \r\n \r\n \r\n \r\n
С условиями приема указанной в платежном документе суммы, в т.ч. с суммой взимаемой платы за услуги банка, ознакомлен и согласен.
\r\n \r\n \r\n \r\n \r\n \r\n \r\n
Подпись плательщика _____________________
\r\n\r\n
\r\n
\r\n

Примечания:\r\n Это стандартная форма для платежа через банк (Сбербанк). Иногда на квитанции требуется написать фамилию, адрес плательщика, другую дополнительную информацию. Всё это можно сделать непосредственно в банке при оплате.

\r\n
',''); /*!40000 ALTER TABLE `jos_vm_payment_method` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jos_vm_product` -- DROP TABLE IF EXISTS `jos_vm_product`; CREATE TABLE `jos_vm_product` ( `product_id` int(11) NOT NULL auto_increment, `vendor_id` int(11) NOT NULL default '0', `product_parent_id` int(11) NOT NULL default '0', `product_sku` varchar(64) NOT NULL default '', `product_s_desc` varchar(255) default NULL, `product_desc` text, `product_thumb_image` varchar(255) default NULL, `product_full_image` varchar(255) default NULL, `product_publish` char(1) default NULL, `product_weight` decimal(10,4) default NULL, `product_weight_uom` varchar(32) default 'pounds.', `product_length` decimal(10,4) default NULL, `product_width` decimal(10,4) default NULL, `product_height` decimal(10,4) default NULL, `product_lwh_uom` varchar(32) default 'inches', `product_url` varchar(255) default NULL, `product_in_stock` int(11) unsigned default NULL, `product_available_date` int(11) default NULL, `product_availability` varchar(56) NOT NULL default '', `product_special` char(1) default NULL, `product_discount_id` int(11) default NULL, `ship_code_id` int(11) default NULL, `cdate` int(11) default NULL, `mdate` int(11) default NULL, `product_name` varchar(64) default NULL, `product_sales` int(11) NOT NULL default '0', `attribute` text, `custom_attribute` text NOT NULL, `product_tax_id` tinyint(2) NOT NULL default '0', `product_unit` varchar(32) default NULL, `product_packaging` int(11) default NULL, PRIMARY KEY (`product_id`), KEY `idx_product_vendor_id` (`vendor_id`), KEY `idx_product_product_parent_id` (`product_parent_id`), KEY `idx_product_sku` (`product_sku`), KEY `idx_product_ship_code_id` (`ship_code_id`), KEY `idx_product_name` (`product_name`) ) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=cp1251 COMMENT='Все товары хранятся здесь'; -- -- Dumping data for table `jos_vm_product` -- LOCK TABLES `jos_vm_product` WRITE; /*!40000 ALTER TABLE `jos_vm_product` DISABLE KEYS */; INSERT INTO `jos_vm_product` VALUES (18,1,0,'112','Характеристики: Горные лыжи Atomic Bluemoon\r\nгеометрия (мм/см) 115 х 72 х 100 / 169\r\nрадиус (м/см) 16,5 / 169\r\nростовки 148 / 155 / 162 / 169 / 176 \r\n','

\r\n