
CREATE TABLE `q4bx8_update_sites` (
  `update_site_id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `location` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `enabled` int DEFAULT '0',
  `last_check_timestamp` bigint DEFAULT '0',
  `extra_query` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  PRIMARY KEY (`update_site_id`)
) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Update Sites';

/*Data for the table `q4bx8_update_sites` */

insert  into `q4bx8_update_sites`(`update_site_id`,`name`,`type`,`location`,`enabled`,`last_check_timestamp`,`extra_query`) values 
(1,'Joomla! Core','collection','https://update.joomla.org/core/list.xml',0,1669906935,''),
(2,'Accredited Joomla! Translations','collection','https://update.joomla.org/language/translationlist_3.xml',1,1738351619,''),
(3,'Joomla! Update Component Update Site','extension','https://update.joomla.org/core/extensions/com_joomlaupdate.xml',1,1738351619,''),
(73,'Regular Labs - Advanced Module Manager','extension','https://download.regularlabs.com/updates.xml?e=advancedmodulemanager&type=.xml',0,1661978596,''),
(74,'WebInstaller Update Site','extension','https://appscdn.joomla.org/webapps/jedapps/webinstaller.xml',1,1738351619,''),
(75,'Regular Labs Library','extension','https://download.regularlabs.com/updates.xml?e=library&type=.xml',1,1738351620,''),
(76,'TCPDF Update Site','extension','http://virtuemart.net/releases/TCPDF/tcpdf.xml',1,1738351620,''),
(77,'VirtueMart Administrator Template Update Site','extension','http://virtuemart.net/releases/vm3/vmadmin.xml',1,1738351620,''),
(78,'JEM Update Site','extension','http://www.joomlaeventmanager.net/updatecheck/update_pkg_jem.xml',1,1738351620,''),
(80,'VirtueMart3 Update Site','extension','http://virtuemart.net/releases/vm3/virtuemart_update.xml',1,1738351620,''),
(81,'VirtueMart plg_vmpayment_standard Update Site','extension','http://virtuemart.net/releases/vm3/plg_vmpayment_standard_update.xml',1,1738351620,''),
(82,'VirtueMart plg_vmpayment_paypal Update Site','extension','http://virtuemart.net/releases/vm3/plg_vmpayment_paypal_update.xml',1,1738351620,''),
(83,'VirtueMart plg_vmpayment_sofort Update Site','extension','http://virtuemart.net/releases/vm3/plg_vmpayment_sofort_update.xml',1,1738351620,''),
(84,'VirtueMart3 plg_vmpayment_skrill Update Site','extension','http://virtuemart.net/releases/vm3/plg_vmpayment_skrill_update.xml',0,1700772197,''),
(85,'VirtueMart plg_vmpayment_heidelpay Update Site','extension','http://virtuemart.net/releases/vm3/plg_vmpayment_heidelpay_update.xml',1,1738351621,''),
(86,'VirtueMart plg_vmpayment_paybox Update Site','extension','http://virtuemart.net/releases/vm3/plg_vmpayment_paybox_update.xml',1,1738351621,''),
(87,'VirtueMart3 plg_vmpayment_tco Update Site','extension','http://virtuemart.net/releases/vm3/plg_vmpayment_tco_update.xml',1,1738351621,''),
(88,'VirtueMart plg_vmpayment_eway Update Site','extension','\n            http://virtuemart.net/releases/vm3/plg_vmpayment_eway_update.xml',1,1738351621,''),
(89,'VirtueMart plg_vmpayment_amazon Update Site','extension','http://virtuemart.net/releases/vm3/plg_vmpayment_amazon_update.xml',1,1738351621,''),
(90,'VirtueMart plg_system_amazon Update Site','extension','http://virtuemart.net/releases/vm3/plg_system_amazon_update.xml',1,1738351621,''),
(91,'VirtueMart plg_vmpayment_realex_hpp_api Update Site','extension','http://virtuemart.net/releases/vm3/plg_vmpayment_realex_hpp_api_update.xml',1,1738351621,''),
(92,'VirtueMart plg_vmuserfield_realex_hpp_api Update Site','extension','\n            http://virtuemart.net/releases/vm3/plg_vmuserfield_realex_hpp_api_update.xml',1,1738351621,''),
(93,'VirtueMart plg_vmpayment_authorizenet Update Site','extension','http://virtuemart.net/releases/vm3/plg_vmpayment_authorisenet_update.xml',0,1661978612,''),
(94,'VirtueMart plg_vmpayment_sofort_ideal Update Site','extension','http://virtuemart.net/releases/vm3/plg_vmpayment_sofort_ideal_update.xml',1,1738351621,''),
(95,'VirtueMart plg_vmpayment_klikandpay Update Site','extension','http://virtuemart.net/releases/vm3/plg_vmpayment_klikandpay_update.xml',1,1738351621,''),
(96,'VirtueMart3 plg_vmshipment_weight_countries Update Site','extension','http://virtuemart.net/releases/vm3/plg_vmshipment_weight_countries_update.xml',1,1738351621,''),
(97,'VirtueMart3 plg_vmcustom_textinput Update Site','extension','http://virtuemart.net/releases/vm3/plg_vmcustom_textinput_update.xml',0,1661978616,''),
(98,'VirtueMart3 plg_vmcustom_specification Update Site','extension','http://virtuemart.net/releases/vm3/plg_vmcustom_specification_update.xml',1,1738351622,''),
(99,'VirtueMart, ${PHING.COMPANY} - ${PHING.NAME.EXTSHORT} - Update Site','extension','http://virtuemart.net/releases/vm3/plg_vmcustom_download_simple_update.xml',1,1738351622,''),
(100,'VirtueMart3 plg_vmcalculation_avalara Update Site','extension','http://virtuemart.net/releases/vm3/plg_vmcalculation_avalara_update.xml',1,1738351622,''),
(101,'VirtueMart3 plg_search_virtuemart Update Site','extension','http://virtuemart.net/releases/vm3/plg_search_virtuemart_update.xml',1,1738351622,''),
(102,'VM Framework Loader during Plugin Updates','extension','http://virtuemart.net/releases/vm3/plg_system_vmLoaderPluginUpdate_update.xml',1,1738351622,''),
(103,'VirtueMart3 MOD_VMENU Update Site','extension','http://virtuemart.net/releases/vm3/mod_vmmenu_update.xml',1,1738351622,''),
(104,'VirtueMart3 mod_virtuemart_currencies Update Site','extension','http://virtuemart.net/releases/vm3/mod_virtuemart_currencies_update.xml',1,1738351622,''),
(105,'VirtueMart3 mod_virtuemart_product Update Site','extension','http://virtuemart.net/releases/vm3/mod_virtuemart_product_update.xml',1,1738351622,''),
(106,'VirtueMart3 mod_virtuemart_search Update Site','extension','http://virtuemart.net/releases/vm3/mod_virtuemart_search_update.xml',1,1738351622,''),
(107,'VirtueMart3 mod_virtuemart_manufacturer Update Site','extension','http://virtuemart.net/releases/vm3/mod_virtuemart_manufacturer_update.xml',0,0,''),
(108,'VirtueMart3 mod_virtuemart_cart Update Site','extension','http://virtuemart.net/releases/vm3/mod_virtuemart_cart_update.xml',1,1738351622,''),
(109,'VirtueMart3 mod_virtuemart_category Update Site','extension','http://virtuemart.net/releases/vm3/mod_virtuemart_category_update.xml',1,1738351622,''),
(110,'VirtueMart3 AIO Update Site','extension','http://virtuemart.net/releases/vm3/virtuemart_aio_update.xml',1,1738351623,''),
(111,'JEvents Addon Updates','extension','https://www.jevents.net/newupdates/jevents_package.xml',1,1738351623,''),
(112,'JEvents Addon Updates','collection','https://www.jevents.net/newupdates/jevents_addon_updates.xml',0,1700773390,'dlid=-dW5kcnVtc2RhbC5ubw=='),
(113,'FOF 4.x','extension','http://cdn.akeeba.com/updates/fof4_file.xml',1,1738351624,''),
(114,'Akeeba FEF','extension','http://cdn.akeeba.com/updates/fef.xml',1,1738351624,''),
(115,'Akeeba Backup Core','extension','https://cdn.akeeba.com/updates/pkgakeebacore.xml',1,1738351624,'');

/*Table structure for table `q4bx8_update_sites_extensions` */


CREATE TABLE `q4bx8_update_sites_extensions` (
  `update_site_id` int NOT NULL DEFAULT '0',
  `extension_id` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`update_site_id`,`extension_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Links extensions to update sites';

/*Data for the table `q4bx8_update_sites_extensions` */

insert  into `q4bx8_update_sites_extensions`(`update_site_id`,`extension_id`) values 
(1,700),
(2,802),
(2,10002),
(3,28),
(73,10024),
(73,10025),
(73,10047),
(74,10003),
(75,10023),
(75,10178),
(76,10098),
(77,10186),
(78,10066),
(80,10191),
(81,10069),
(82,10070),
(83,10071),
(84,10072),
(85,10075),
(86,10076),
(87,10077),
(88,10078),
(89,10180),
(90,10181),
(91,10079),
(92,10080),
(93,10081),
(94,10082),
(95,10083),
(96,10084),
(97,10085),
(98,10086),
(99,10189),
(100,10088),
(101,10193),
(102,10090),
(103,10091),
(104,10092),
(105,10093),
(106,10094),
(107,10095),
(108,10096),
(109,10097),
(110,10192),
(111,10110),
(112,10026),
(113,10194),
(114,10202),
(115,10201),
(116,10110);

/*Table structure for table `q4bx8_updates` */


CREATE TABLE `q4bx8_updates` (
  `update_id` int NOT NULL AUTO_INCREMENT,
  `update_site_id` int DEFAULT '0',
  `extension_id` int DEFAULT '0',
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `element` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `folder` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `client_id` tinyint DEFAULT '0',
  `version` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `detailsurl` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `infourl` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `extra_query` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  PRIMARY KEY (`update_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1339 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Available Updates';

/*Data for the table `q4bx8_updates` */

insert  into `q4bx8_updates`(`update_id`,`update_site_id`,`extension_id`,`name`,`description`,`element`,`type`,`folder`,`client_id`,`version`,`data`,`detailsurl`,`infourl`,`extra_query`) values 
(1239,2,0,'Afrikaans','','pkg_af-ZA','package','',0,'3.9.16.1','','https://update.joomla.org/language/details3/af-ZA_details.xml','',''),
(1240,2,0,'Albanian','','pkg_sq-AL','package','',0,'3.1.1.2','','https://update.joomla.org/language/details3/sq-AL_details.xml','',''),
(1241,2,0,'Arabic Unitag','','pkg_ar-AA','package','',0,'3.9.27.1','','https://update.joomla.org/language/details3/ar-AA_details.xml','',''),
(1242,2,0,'Armenian','','pkg_hy-AM','package','',0,'3.4.4.1','','https://update.joomla.org/language/details3/hy-AM_details.xml','',''),
(1243,2,0,'Basque','','pkg_eu-ES','package','',0,'3.9.24.1','','https://update.joomla.org/language/details3/eu-ES_details.xml','',''),
(1244,2,0,'Belarusian','','pkg_be-BY','package','',0,'3.2.1.2','','https://update.joomla.org/language/details3/be-BY_details.xml','',''),
(1245,2,0,'Bengali, Bangladesh','','pkg_bn-BD','package','',0,'3.8.10.1','','https://update.joomla.org/language/details3/bn-BD_details.xml','',''),
(1246,2,0,'Bosnian','','pkg_bs-BA','package','',0,'3.9.24.1','','https://update.joomla.org/language/details3/bs-BA_details.xml','',''),
(1247,2,0,'Bulgarian','','pkg_bg-BG','package','',0,'3.6.5.2','','https://update.joomla.org/language/details3/bg-BG_details.xml','',''),
(1248,2,0,'Catalan','','pkg_ca-ES','package','',0,'3.10.12.1','','https://update.joomla.org/language/details3/ca-ES_details.xml','',''),
(1249,2,0,'Chinese, Simplified','','pkg_zh-CN','package','',0,'3.10.6.1','','https://update.joomla.org/language/details3/zh-CN_details.xml','',''),
(1250,2,0,'Chinese, Traditional','','pkg_zh-TW','package','',0,'3.8.0.1','','https://update.joomla.org/language/details3/zh-TW_details.xml','',''),
(1251,2,0,'Croatian','','pkg_hr-HR','package','',0,'3.10.11.1','','https://update.joomla.org/language/details3/hr-HR_details.xml','',''),
(1252,2,0,'Czech','','pkg_cs-CZ','package','',0,'3.10.11.1','','https://update.joomla.org/language/details3/cs-CZ_details.xml','',''),
(1253,2,0,'Danish','','pkg_da-DK','package','',0,'3.10.10.1','','https://update.joomla.org/language/details3/da-DK_details.xml','',''),
(1254,2,0,'Dari Persian','','pkg_prs-AF','package','',0,'3.4.4.3','','https://update.joomla.org/language/details3/prs-AF_details.xml','',''),
(1255,2,0,'Dutch','','pkg_nl-NL','package','',0,'3.10.12.1','','https://update.joomla.org/language/details3/nl-NL_details.xml','',''),
(1256,2,0,'Dzongkha','','pkg_dz-BT','package','',0,'3.6.2.1','','https://update.joomla.org/language/details3/dz-BT_details.xml','',''),
(1257,2,0,'English, Australia','','pkg_en-AU','package','',0,'3.9.28.1','','https://update.joomla.org/language/details3/en-AU_details.xml','',''),
(1258,2,0,'English, Canada','','pkg_en-CA','package','',0,'3.9.28.1','','https://update.joomla.org/language/details3/en-CA_details.xml','',''),
(1259,2,0,'English, New Zealand','','pkg_en-NZ','package','',0,'3.9.28.1','','https://update.joomla.org/language/details3/en-NZ_details.xml','',''),
(1260,2,0,'English, USA','','pkg_en-US','package','',0,'3.9.28.1','','https://update.joomla.org/language/details3/en-US_details.xml','',''),
(1261,2,0,'Esperanto','','pkg_eo-XX','package','',0,'3.8.11.1','','https://update.joomla.org/language/details3/eo-XX_details.xml','',''),
(1262,2,0,'Estonian','','pkg_et-EE','package','',0,'3.9.21.1','','https://update.joomla.org/language/details3/et-EE_details.xml','',''),
(1263,2,0,'Finnish','','pkg_fi-FI','package','',0,'3.9.16.1','','https://update.joomla.org/language/details3/fi-FI_details.xml','',''),
(1264,2,0,'Flemish','','pkg_nl-BE','package','',0,'3.10.11.1','','https://update.joomla.org/language/details3/nl-BE_details.xml','',''),
(1265,2,0,'French','','pkg_fr-FR','package','',0,'3.10.12.1','','https://update.joomla.org/language/details3/fr-FR_details.xml','',''),
(1266,2,0,'French, Canada','','pkg_fr-CA','package','',0,'3.6.5.1','','https://update.joomla.org/language/details3/fr-CA_details.xml','',''),
(1267,2,0,'Galician','','pkg_gl-ES','package','',0,'3.3.1.2','','https://update.joomla.org/language/details3/gl-ES_details.xml','',''),
(1268,2,0,'Georgian','','pkg_ka-GE','package','',0,'3.10.12.1','','https://update.joomla.org/language/details3/ka-GE_details.xml','',''),
(1269,2,0,'German','','pkg_de-DE','package','',0,'3.10.12.1','','https://update.joomla.org/language/details3/de-DE_details.xml','',''),
(1270,2,0,'German, Austria','','pkg_de-AT','package','',0,'3.10.12.1','','https://update.joomla.org/language/details3/de-AT_details.xml','',''),
(1271,2,0,'German, Liechtenstein','','pkg_de-LI','package','',0,'3.10.12.1','','https://update.joomla.org/language/details3/de-LI_details.xml','',''),
(1272,2,0,'German, Luxembourg','','pkg_de-LU','package','',0,'3.10.12.1','','https://update.joomla.org/language/details3/de-LU_details.xml','',''),
(1273,2,0,'German, Switzerland','','pkg_de-CH','package','',0,'3.10.12.1','','https://update.joomla.org/language/details3/de-CH_details.xml','',''),
(1274,2,0,'Greek','','pkg_el-GR','package','',0,'3.10.11.1','','https://update.joomla.org/language/details3/el-GR_details.xml','',''),
(1275,2,0,'Hebrew','','pkg_he-IL','package','',0,'3.1.1.2','','https://update.joomla.org/language/details3/he-IL_details.xml','',''),
(1276,2,0,'Hindi, India','','pkg_hi-IN','package','',0,'3.3.6.2','','https://update.joomla.org/language/details3/hi-IN_details.xml','',''),
(1277,2,0,'Hungarian','','pkg_hu-HU','package','',0,'3.10.12.2','','https://update.joomla.org/language/details3/hu-HU_details.xml','',''),
(1278,2,0,'Indonesian, Bahasa Indonesia','','pkg_id-ID','package','',0,'3.6.2.1','','https://update.joomla.org/language/details3/id-ID_details.xml','',''),
(1279,2,0,'Irish','','pkg_ga-IE','package','',0,'3.10.12.1','','https://update.joomla.org/language/details3/ga-IE_details.xml','',''),
(1280,2,0,'Italian','','pkg_it-IT','package','',0,'3.10.12.1','','https://update.joomla.org/language/details3/it-IT_details.xml','',''),
(1281,2,0,'Japanese','','pkg_ja-JP','package','',0,'3.10.12.1','','https://update.joomla.org/language/details3/ja-JP_details.xml','',''),
(1282,2,0,'Kazakh','','pkg_kk-KZ','package','',0,'3.9.23.1','','https://update.joomla.org/language/details3/kk-KZ_details.xml','',''),
(1283,2,0,'Khmer','','pkg_km-KH','package','',0,'3.4.5.1','','https://update.joomla.org/language/details3/km-KH_details.xml','',''),
(1284,2,0,'Korean','','pkg_ko-KR','package','',0,'3.8.9.1','','https://update.joomla.org/language/details3/ko-KR_details.xml','',''),
(1285,2,0,'Latvian','','pkg_lv-LV','package','',0,'3.9.25.2','','https://update.joomla.org/language/details3/lv-LV_details.xml','',''),
(1286,2,0,'Lithuanian','','pkg_lt-LT','package','',0,'3.9.16.1','','https://update.joomla.org/language/details3/lt-LT_details.xml','',''),
(1287,2,0,'Macedonian','','pkg_mk-MK','package','',0,'3.6.5.1','','https://update.joomla.org/language/details3/mk-MK_details.xml','',''),
(1288,2,0,'Malay','','pkg_ms-MY','package','',0,'3.4.1.2','','https://update.joomla.org/language/details3/ms-MY_details.xml','',''),
(1289,2,0,'Montenegrin','','pkg_srp-ME','package','',0,'3.3.1.2','','https://update.joomla.org/language/details3/srp-ME_details.xml','',''),
(1290,2,0,'Norwegian Nynorsk','','pkg_nn-NO','package','',0,'3.4.2.1','','https://update.joomla.org/language/details3/nn-NO_details.xml','',''),
(1291,2,0,'Persian Farsi','','pkg_fa-IR','package','',0,'3.10.12.1','','https://update.joomla.org/language/details3/fa-IR_details.xml','',''),
(1292,2,0,'Polish','','pkg_pl-PL','package','',0,'3.10.10.1','','https://update.joomla.org/language/details3/pl-PL_details.xml','',''),
(1293,2,0,'Portuguese, Brazil','','pkg_pt-BR','package','',0,'3.9.21.1','','https://update.joomla.org/language/details3/pt-BR_details.xml','',''),
(1294,2,0,'Portuguese, Portugal','','pkg_pt-PT','package','',0,'3.10.12.3','','https://update.joomla.org/language/details3/pt-PT_details.xml','',''),
(1295,2,0,'Romanian','','pkg_ro-RO','package','',0,'3.10.12.1','','https://update.joomla.org/language/details3/ro-RO_details.xml','',''),
(1296,2,0,'Russian','','pkg_ru-RU','package','',0,'3.10.12.1','','https://update.joomla.org/language/details3/ru-RU_details.xml','',''),
(1297,2,0,'Serbian, Cyrillic','','pkg_sr-RS','package','',0,'3.10.2.1','','https://update.joomla.org/language/details3/sr-RS_details.xml','',''),
(1298,2,0,'Serbian, Latin','','pkg_sr-YU','package','',0,'3.10.2.1','','https://update.joomla.org/language/details3/sr-YU_details.xml','',''),
(1299,2,0,'Sinhala','','pkg_si-LK','package','',0,'3.3.1.2','','https://update.joomla.org/language/details3/si-LK_details.xml','',''),
(1300,2,0,'Slovak','','pkg_sk-SK','package','',0,'3.10.5.1','','https://update.joomla.org/language/details3/sk-SK_details.xml','',''),
(1301,2,0,'Slovenian','','pkg_sl-SI','package','',0,'3.10.12.1','','https://update.joomla.org/language/details3/sl-SI_details.xml','',''),
(1302,2,0,'Spanish','','pkg_es-ES','package','',0,'3.10.10.1','','https://update.joomla.org/language/details3/es-ES_details.xml','',''),
(1303,2,0,'Spanish, Colombia','','pkg_es-CO','package','',0,'3.9.15.1','','https://update.joomla.org/language/details3/es-CO_details.xml','',''),
(1304,2,0,'Swahili','','pkg_sw-KE','package','',0,'3.10.12.1','','https://update.joomla.org/language/details3/sw-KE_details.xml','',''),
(1305,2,0,'Swedish','','pkg_sv-SE','package','',0,'3.10.12.1','','https://update.joomla.org/language/details3/sv-SE_details.xml','',''),
(1306,2,0,'Syriac, East','','pkg_sy-IQ','package','',0,'3.4.5.1','','https://update.joomla.org/language/details3/sy-IQ_details.xml','',''),
(1307,2,0,'Tamil, India','','pkg_ta-IN','package','',0,'3.10.11.1','','https://update.joomla.org/language/details3/ta-IN_details.xml','',''),
(1308,2,0,'Thai','','pkg_th-TH','package','',0,'3.10.12.1','','https://update.joomla.org/language/details3/th-TH_details.xml','',''),
(1309,2,0,'Turkish','','pkg_tr-TR','package','',0,'3.9.28.1','','https://update.joomla.org/language/details3/tr-TR_details.xml','',''),
(1310,2,0,'Turkmen','','pkg_tk-TM','package','',0,'3.5.0.2','','https://update.joomla.org/language/details3/tk-TM_details.xml','',''),
(1311,2,0,'Ukrainian','','pkg_uk-UA','package','',0,'3.10.2.1','','https://update.joomla.org/language/details3/uk-UA_details.xml','',''),
(1312,2,0,'Uyghur','','pkg_ug-CN','package','',0,'3.7.5.2','','https://update.joomla.org/language/details3/ug-CN_details.xml','',''),
(1313,2,0,'Vietnamese','','pkg_vi-VN','package','',0,'3.2.1.2','','https://update.joomla.org/language/details3/vi-VN_details.xml','',''),
(1314,2,0,'Welsh','','pkg_cy-GB','package','',0,'3.10.12.1','','https://update.joomla.org/language/details3/cy-GB_details.xml','',''),
(1315,75,0,'Regular Labs - Regular Labs Library','','library','library','',0,'21.8.0','','https://download.regularlabs.com/updates.xml?e=library&type=.xml','',''),
(1316,77,0,'vmadmin','New administration template for VirtueMart. Enable the template in the virtuemart config on the first tab, section \"Advanced\".','','template','',1,'4.0.6','','http://virtuemart.net/releases/vm3/vmadmin.xml','https://virtuemart.net/news/508-paybox-with-new-3dsecure-v2',''),
(1317,78,10066,'JEM Package','Joomla! Event Manager Package','pkg_jem','package','',0,'2.3.6','','http://www.joomlaeventmanager.net/updatecheck/update_pkg_jem.xml','http://www.joomlaeventmanager.net/project/changelog-jem-2',''),
(1318,80,10191,'VirtueMart','VirtueMart Component','com_virtuemart','component','',1,'4.4.2','','http://virtuemart.net/releases/vm3/virtuemart_update.xml','https://virtuemart.net/news/latest-news/effective-and-sustainable-funding-with-a-virtuemart-membership',''),
(1319,81,10069,'VirtueMart - Payments, Standard','VirtueMart - Payments, Standard','standard','plugin','vmpayment',0,'4.0.2','','http://virtuemart.net/releases/vm3/plg_vmpayment_standard_update.xml','https://docs.virtuemart.net/tutorials/installation-migration-upgrade/226-update-single-plugin-delivered-by-aio.html',''),
(1320,82,10070,'VirtueMart - Payments, Paypal','VirtueMart - Payments, Paypal','paypal','plugin','vmpayment',0,'4.2.0','','http://virtuemart.net/releases/vm3/plg_vmpayment_paypal_update.xml','https://docs.virtuemart.net/tutorials/installation-migration-upgrade/226-update-single-plugin-delivered-by-aio.html',''),
(1321,83,10071,'VirtueMart - Payments, Sofort','VirtueMart - Payments, Sofort','sofort','plugin','vmpayment',0,'4.0.2','','http://virtuemart.net/releases/vm3/plg_vmpayment_sofort_update.xml','https://docs.virtuemart.net/tutorials/installation-migration-upgrade/226-update-single-plugin-delivered-by-aio.html',''),
(1322,86,10076,'VirtueMart - Payments, Paybox','VirtueMart - Payments, Paybox','paybox','plugin','vmpayment',0,'4.0.2','','http://virtuemart.net/releases/vm3/plg_vmpayment_paybox_update.xml','https://docs.virtuemart.net/tutorials/installation-migration-upgrade/226-update-single-plugin-delivered-by-aio.html',''),
(1323,89,10180,'VirtueMart - Payments, Amazon','VirtueMart - Payments, Amazon','amazon','plugin','vmpayment',0,'4.0.2','','http://virtuemart.net/releases/vm3/plg_vmpayment_amazon_update.xml','https://docs.virtuemart.net/tutorials/installation-migration-upgrade/226-update-single-plugin-delivered-by-aio.html',''),
(1324,95,10083,'VirtueMart - Payments, Klick and Pay','VirtueMart - Payments, Klick and Pay','klikandpay','plugin','vmpayment',0,'4.0.2','','http://virtuemart.net/releases/vm3/plg_vmpayment_klikandpay_update.xml','https://docs.virtuemart.net/tutorials/installation-migration-upgrade/226-update-single-plugin-delivered-by-aio.html',''),
(1325,96,0,'VirtueMart - Shipment, by Weight, country, zip,... ','VirtueMart - Shipment, Shipment, by Weight, country, zip,... ','standard','plugin','vmshipment',0,'4.0.2','','http://virtuemart.net/releases/vm3/plg_vmshipment_weight_countries_update.xml','https://docs.virtuemart.net/tutorials/installation-migration-upgrade/226-update-single-plugin-delivered-by-aio.html',''),
(1326,98,10086,'VirtueMart - Specification','VirtueMart - Specification, mainly an example how to use customfield plugins for specifications','specification','plugin','vmcustom',0,'4.0.2','','http://virtuemart.net/releases/vm3/plg_vmcustom_specification_update.xml','https://docs.virtuemart.net/tutorials/installation-migration-upgrade/226-update-single-plugin-delivered-by-aio.html',''),
(1327,99,0,'VirtueMart - Download Simple','VirtueMart - Download Simple by iStraxx','download_simple','plugin','vmcustom',0,'4.2.0','','http://virtuemart.net/releases/vm3/plg_vmcustom_download_simple_update.xml','https://docs.virtuemart.net/tutorials/installation-migration-upgrade/226-update-single-plugin-delivered-by-aio.html',''),
(1328,100,10088,'VirtueMart - Avatax','VirtueMart - Avatax, dynamic realtime tax calculation by Avalara','avalara','plugin','vmcalculation',0,'4.0.2','','http://virtuemart.net/releases/vm3/plg_vmcalculation_avalara_update.xml','https://docs.virtuemart.net/tutorials/installation-migration-upgrade/226-update-single-plugin-delivered-by-aio.html',''),
(1329,101,10193,'Search - VirtueMart','Search - VirtueMart','virtuemart','plugin','search',0,'4.0.2','','http://virtuemart.net/releases/vm3/plg_search_virtuemart_update.xml','https://docs.virtuemart.net/tutorials/installation-migration-upgrade/226-update-single-plugin-delivered-by-aio.html',''),
(1330,102,0,'VM Framework Loader during Plugin Updates','Makes sure the VirtueMart framework is loaded during automatic plugin updates using Joomla\'s plugin updater.','vmloaderpluginupdate','plugin','system',1,'4.0.2','','http://virtuemart.net/releases/vm3/plg_system_vmLoaderPluginUpdate_update.xml','https://docs.virtuemart.net/tutorials/installation-migration-upgrade/226-update-single-plugin-delivered-by-aio.html',''),
(1331,103,10091,'VirtueMart Admin module','VirtueMart Admin module','mod_vmmenu','module','',1,'4.0.2','','http://virtuemart.net/releases/vm3/mod_vmmenu_update.xml','https://docs.virtuemart.net/tutorials/installation-migration-upgrade/226-update-single-plugin-delivered-by-aio.html',''),
(1332,104,10092,'VirtueMart Currency module','VirtueMart Currency module','mod_virtuemart_currencies','module','',0,'4.0.2','','http://virtuemart.net/releases/vm3/mod_virtuemart_currencies_update.xml','https://docs.virtuemart.net/tutorials/installation-migration-upgrade/226-update-single-plugin-delivered-by-aio.html',''),
(1333,105,0,'VirtueMart Product module','VirtueMart Product module','mod_virtuemart_product','plugin','',0,'4.0.2','','http://virtuemart.net/releases/vm3/mod_virtuemart_product_update.xml','https://docs.virtuemart.net/tutorials/installation-migration-upgrade/226-update-single-plugin-delivered-by-aio.html',''),
(1334,106,10094,'VirtueMart Search module','VirtueMart Search module','mod_virtuemart_search','module','',0,'4.0.2','','http://virtuemart.net/releases/vm3/mod_virtuemart_search_update.xml','https://docs.virtuemart.net/tutorials/installation-migration-upgrade/226-update-single-plugin-delivered-by-aio.html',''),
(1335,108,10096,'VirtueMart Cart module','VirtueMart Cart module','mod_virtuemart_cart','module','',0,'4.0.2','','http://virtuemart.net/releases/vm3/mod_virtuemart_cart_update.xml','https://docs.virtuemart.net/tutorials/installation-migration-upgrade/226-update-single-plugin-delivered-by-aio.html',''),
(1336,109,10097,'VirtueMart Category module','VirtueMart Category module','mod_virtuemart_category','module','',0,'4.0.2','','http://virtuemart.net/releases/vm3/mod_virtuemart_category_update.xml','https://docs.virtuemart.net/tutorials/installation-migration-upgrade/226-update-single-plugin-delivered-by-aio.html',''),
(1337,110,10192,'VirtueMart AIO','VirtueMart AIO Component','com_virtuemart_allinone','component','',1,'4.2.4','','http://virtuemart.net/releases/vm3/virtuemart_aio_update.xml','http://virtuemart.net/news/latest-news/effective-and-sustainable-funding-with-a-virtuemart-membership',''),
(1338,115,0,'Akeeba Backup Core package','','pkg_akeeba','package','',0,'8.4.0','','https://cdn.akeeba.com/updates/pkgakeebacore.xml','https://www.akeeba.com/download/akeeba-backup/8-4-0.html','');

/*Table structure for table `q4bx8_user_keys` */


CREATE TABLE `q4bx8_user_keys` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `series` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `invalid` tinyint NOT NULL,
  `time` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `uastring` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `series` (`series`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `q4bx8_user_keys` */

/*Table structure for table `q4bx8_user_notes` */


CREATE TABLE `q4bx8_user_notes` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL DEFAULT '0',
  `catid` int unsigned NOT NULL DEFAULT '0',
  `subject` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `state` tinyint NOT NULL DEFAULT '0',
  `checked_out` int unsigned NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_user_id` int unsigned NOT NULL DEFAULT '0',
  `created_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_user_id` int unsigned NOT NULL,
  `modified_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `review_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `idx_user_id` (`user_id`),
  KEY `idx_category_id` (`catid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `q4bx8_user_notes` */

/*Table structure for table `q4bx8_user_profiles` */


CREATE TABLE `q4bx8_user_profiles` (
  `user_id` int NOT NULL,
  `profile_key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `profile_value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ordering` int NOT NULL DEFAULT '0',
  UNIQUE KEY `idx_user_id_profile_key` (`user_id`,`profile_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Simple user profile storage table';

/*Data for the table `q4bx8_user_profiles` */

/*Table structure for table `q4bx8_user_usergroup_map` */


CREATE TABLE `q4bx8_user_usergroup_map` (
  `user_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Foreign Key to #__users.id',
  `group_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Foreign Key to #__usergroups.id',
  PRIMARY KEY (`user_id`,`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `q4bx8_user_usergroup_map` */

insert  into `q4bx8_user_usergroup_map`(`user_id`,`group_id`) values 
(256,8);

/*Table structure for table `q4bx8_usergroups` */


CREATE TABLE `q4bx8_usergroups` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
  `parent_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Adjacency List Reference Id',
  `lft` int NOT NULL DEFAULT '0' COMMENT 'Nested set lft.',
  `rgt` int NOT NULL DEFAULT '0' COMMENT 'Nested set rgt.',
  `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_usergroup_parent_title_lookup` (`parent_id`,`title`),
  KEY `idx_usergroup_title_lookup` (`title`),
  KEY `idx_usergroup_adjacency_lookup` (`parent_id`),
  KEY `idx_usergroup_nested_set_lookup` (`lft`,`rgt`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `q4bx8_usergroups` */

insert  into `q4bx8_usergroups`(`id`,`parent_id`,`lft`,`rgt`,`title`) values 
(1,0,1,18,'Public'),
(2,1,8,15,'Registered'),
(3,2,9,14,'Author'),
(4,3,10,13,'Editor'),
(5,4,11,12,'Publisher'),
(6,1,4,7,'Manager'),
(7,6,5,6,'Administrator'),
(8,1,16,17,'Super Users'),
(9,1,2,3,'Guest');

/*Table structure for table `q4bx8_users` */


CREATE TABLE `q4bx8_users` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `username` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `block` tinyint NOT NULL DEFAULT '0',
  `sendEmail` tinyint DEFAULT '0',
  `registerDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `lastvisitDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `activation` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `params` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `lastResetTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Date of last password reset',
  `resetCount` int NOT NULL DEFAULT '0' COMMENT 'Count of password resets since lastResetTime',
  `otpKey` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Two factor authentication encrypted keys',
  `otep` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'One time emergency passwords',
  `requireReset` tinyint NOT NULL DEFAULT '0' COMMENT 'Require user to reset password on next login',
  `authProvider` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Name of used authentication plugin',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_username` (`username`),
  KEY `idx_name` (`name`(100)),
  KEY `idx_block` (`block`),
  KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=257 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `q4bx8_users` */

insert  into `q4bx8_users`(`id`,`name`,`username`,`email`,`password`,`block`,`sendEmail`,`registerDate`,`lastvisitDate`,`activation`,`params`,`lastResetTime`,`resetCount`,`otpKey`,`otep`,`requireReset`,`authProvider`) values 
(256,'Ole Hans Styrmo Fjellvang','root','post@undrumsdal.no','$2y$10$9Ater7TLBrtSk/ajuIGR7OUaXc71D9zlMcnQF91xOOcC5hfWe7R4O',0,1,'2017-06-21 20:27:52','2025-01-31 19:26:54','0','{}','0000-00-00 00:00:00',0,'','',0,'');

/*Table structure for table `q4bx8_utf8_conversion` */


CREATE TABLE `q4bx8_utf8_conversion` (
  `converted` tinyint NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `q4bx8_utf8_conversion` */

insert  into `q4bx8_utf8_conversion`(`converted`) values 
(5);

/*Table structure for table `q4bx8_viewlevels` */


CREATE TABLE `q4bx8_viewlevels` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
  `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `ordering` int NOT NULL DEFAULT '0',
  `rules` varchar(5120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'JSON encoded access control.',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_assetgroup_title_lookup` (`title`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `q4bx8_viewlevels` */

insert  into `q4bx8_viewlevels`(`id`,`title`,`ordering`,`rules`) values 
(1,'Public',0,'[1]'),
(2,'Registered',2,'[6,2,8]'),
(3,'Special',3,'[6,3,8]'),
(5,'Guest',1,'[9]'),
(6,'Super Users',4,'[8]');

/*Table structure for table `q4bx8_virtuemart_adminmenuentries` */


CREATE TABLE `q4bx8_virtuemart_adminmenuentries` (
  `id` tinyint unsigned NOT NULL AUTO_INCREMENT,
  `module_id` tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'THE ID OF THE VM MODULE, THIS ITEM IS ASSIGNED TO',
  `parent_id` tinyint unsigned NOT NULL DEFAULT '0',
  `name` char(64) NOT NULL DEFAULT '0',
  `link` char(64) NOT NULL DEFAULT '0',
  `depends` char(64) NOT NULL DEFAULT '' COMMENT 'Names of the Parameters, this Item depends on',
  `icon_class` char(96) DEFAULT NULL,
  `uikit_icon` char(96) DEFAULT NULL,
  `ordering` int NOT NULL DEFAULT '0',
  `published` tinyint(1) NOT NULL DEFAULT '1',
  `tooltip` char(128) DEFAULT NULL,
  `view` char(32) DEFAULT NULL,
  `task` char(32) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `module_id` (`module_id`),
  KEY `published` (`published`),
  KEY `ordering` (`ordering`)
) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Administration Menu Items';

/*Data for the table `q4bx8_virtuemart_adminmenuentries` */

insert  into `q4bx8_virtuemart_adminmenuentries`(`id`,`module_id`,`parent_id`,`name`,`link`,`depends`,`icon_class`,`uikit_icon`,`ordering`,`published`,`tooltip`,`view`,`task`) values 
(1,1,0,'COM_VIRTUEMART_CATEGORY_S','','','vmicon vmicon-16-folder_camera','category',1,1,'','category',''),
(2,1,0,'COM_VIRTUEMART_PRODUCT_S','','','vmicon vmicon-16-camera','product',2,1,'','product',''),
(3,1,0,'COM_VIRTUEMART_PRODUCT_CUSTOM_FIELD_S','','','vmicon vmicon-16-document_move','customfield',5,1,'','custom',''),
(4,1,0,'COM_VIRTUEMART_PRODUCT_INVENTORY','','','vmicon vmicon-16-price_watch','inventory',7,1,'','inventory',''),
(5,1,0,'COM_VIRTUEMART_CALC_S','','','vmicon vmicon-16-calculator','calculator',8,1,'','calc',''),
(6,1,0,'COM_VIRTUEMART_REVIEW_RATE_S','','','vmicon vmicon-16-comments','comments',9,1,'','ratings',''),
(7,2,0,'COM_VIRTUEMART_ORDER_S','','','vmicon vmicon-16-page_white_stack','cart',1,1,'','orders',''),
(8,2,0,'COM_VIRTUEMART_COUPON_S','','','vmicon vmicon-16-shopping','gift-box',10,1,'','coupon',''),
(9,2,0,'COM_VIRTUEMART_REPORT','','','vmicon vmicon-16-chart_bar','revenue',3,1,'','report',''),
(10,2,0,'COM_VIRTUEMART_USER_S','','','vmicon vmicon-16-user','user',4,1,'','user',''),
(11,2,0,'COM_VIRTUEMART_SHOPPERGROUP_S','','','vmicon vmicon-16-user-group','users',5,1,'','shoppergroup',''),
(12,3,0,'COM_VIRTUEMART_MANUFACTURER_S','','','vmicon vmicon-16-wrench_orange','manufacturer',1,1,'','manufacturer',''),
(13,3,0,'COM_VIRTUEMART_MANUFACTURER_CATEGORY_S','','','vmicon vmicon-16-folder_wrench','category',2,1,'','manufacturercategories',''),
(14,4,0,'COM_VIRTUEMART_STORE','','','vmicon vmicon-16-reseller_account_template','shop',1,1,'','user','editshop'),
(15,4,0,'COM_VIRTUEMART_MEDIA_S','','','vmicon vmicon-16-pictures','image',2,1,'','media',''),
(16,4,0,'COM_VIRTUEMART_SHIPMENTMETHOD_S','','','vmicon vmicon-16-lorry','shipment',3,1,'','shipmentmethod',''),
(17,4,0,'COM_VIRTUEMART_PAYMENTMETHOD_S','','','vmicon vmicon-16-creditcards','credit-card',4,1,'','paymentmethod',''),
(18,5,0,'COM_VIRTUEMART_CONFIGURATION','','','vmicon vmicon-16-config','cog',1,1,'','config',''),
(19,5,0,'COM_VIRTUEMART_USERFIELD_S','','','vmicon vmicon-16-participation_rate','id-card',2,1,'','userfields',''),
(20,5,0,'COM_VIRTUEMART_ORDERSTATUS_S','','','vmicon vmicon-16-document_editing','future',3,1,'','orderstatus',''),
(21,5,0,'COM_VIRTUEMART_CURRENCY_S','','','vmicon vmicon-16-coins','currencies',5,1,'','currency',''),
(22,5,0,'COM_VIRTUEMART_COUNTRY_S','','','vmicon vmicon-16-globe','world',6,1,'','country',''),
(23,11,0,'COM_VIRTUEMART_MIGRATION_UPDATE','','','vmicon vmicon-16-installer_box','lifesaver',0,1,'','updatesmigration',''),
(24,11,0,'COM_VIRTUEMART_ABOUT','','','vmicon vmicon-16-info','lifesaver',10,1,'','about',''),
(25,11,0,'COM_VIRTUEMART_HELP_TOPICS','http://docs.virtuemart.net/','','vmicon vmicon-16-help','lifesaver',5,1,'','',''),
(26,11,0,'COM_VIRTUEMART_COMMUNITY_FORUM','http://forum.virtuemart.net/','','vmicon vmicon-16-reseller_programm','lifesaver',7,1,'','',''),
(27,11,0,'COM_VIRTUEMART_STATISTIC_SUMMARY','','','vmicon vmicon-16-info','lifesaver',1,1,'','virtuemart',''),
(28,11,0,'COM_VIRTUEMART_LOG','','','vmicon vmicon-16-info','lifesaver',2,1,'','log',''),
(29,11,0,'COM_VIRTUEMART_SUPPORT','','','vmicon vmicon-16-help','lifesaver',3,1,'','support','');

/*Table structure for table `q4bx8_virtuemart_calc_categories` */


CREATE TABLE `q4bx8_virtuemart_calc_categories` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_calc_id` int unsigned NOT NULL DEFAULT '0',
  `virtuemart_category_id` int unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `virtuemart_calc_id` (`virtuemart_calc_id`,`virtuemart_category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*Data for the table `q4bx8_virtuemart_calc_categories` */

/*Table structure for table `q4bx8_virtuemart_calc_countries` */


CREATE TABLE `q4bx8_virtuemart_calc_countries` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_calc_id` int unsigned NOT NULL DEFAULT '0',
  `virtuemart_country_id` int unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `virtuemart_calc_id` (`virtuemart_calc_id`,`virtuemart_country_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*Data for the table `q4bx8_virtuemart_calc_countries` */

/*Table structure for table `q4bx8_virtuemart_calc_manufacturers` */


CREATE TABLE `q4bx8_virtuemart_calc_manufacturers` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_calc_id` int unsigned NOT NULL DEFAULT '0',
  `virtuemart_manufacturer_id` int unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `virtuemart_calc_id` (`virtuemart_calc_id`,`virtuemart_manufacturer_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*Data for the table `q4bx8_virtuemart_calc_manufacturers` */

/*Table structure for table `q4bx8_virtuemart_calc_shoppergroups` */


CREATE TABLE `q4bx8_virtuemart_calc_shoppergroups` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_calc_id` int unsigned NOT NULL DEFAULT '0',
  `virtuemart_shoppergroup_id` int unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `virtuemart_calc_id` (`virtuemart_calc_id`,`virtuemart_shoppergroup_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*Data for the table `q4bx8_virtuemart_calc_shoppergroups` */

/*Table structure for table `q4bx8_virtuemart_calc_states` */


CREATE TABLE `q4bx8_virtuemart_calc_states` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_calc_id` int unsigned NOT NULL DEFAULT '0',
  `virtuemart_state_id` int unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `virtuemart_calc_id` (`virtuemart_calc_id`,`virtuemart_state_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*Data for the table `q4bx8_virtuemart_calc_states` */

/*Table structure for table `q4bx8_virtuemart_calcs` */


CREATE TABLE `q4bx8_virtuemart_calcs` (
  `virtuemart_calc_id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_vendor_id` int unsigned NOT NULL DEFAULT '1' COMMENT 'BELONGS TO VENDOR',
  `calc_jplugin_id` int NOT NULL DEFAULT '0',
  `calc_name` varchar(64) NOT NULL DEFAULT '' COMMENT 'Name of the rule',
  `calc_descr` varchar(128) NOT NULL DEFAULT '' COMMENT 'Description',
  `calc_kind` varchar(16) NOT NULL DEFAULT '' COMMENT 'Discount/Tax/Margin/Commission',
  `calc_value_mathop` varchar(8) NOT NULL DEFAULT '' COMMENT 'the mathematical operation like (+,-,+%,-%)',
  `calc_value` decimal(10,4) NOT NULL DEFAULT '0.0000' COMMENT 'The Amount',
  `calc_currency` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'CURRENCY OF THE RULE',
  `calc_shopper_published` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Visible for Shoppers',
  `calc_vendor_published` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Visible for Vendors',
  `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'STARTDATE IF NOTHING IS SET = PERMANENT',
  `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'ENDDATE IF NOTHING IS SET = PERMANENT',
  `for_override` tinyint(1) NOT NULL DEFAULT '0',
  `has_categories` tinyint(1) DEFAULT NULL,
  `has_shoppergroups` tinyint(1) DEFAULT NULL,
  `has_manufacturers` tinyint(1) DEFAULT NULL,
  `has_countries` tinyint(1) DEFAULT NULL,
  `has_states` tinyint(1) DEFAULT NULL,
  `calc_params` varchar(15359) NOT NULL DEFAULT '',
  `ordering` int NOT NULL DEFAULT '0',
  `shared` tinyint(1) NOT NULL DEFAULT '0',
  `published` tinyint(1) NOT NULL DEFAULT '1',
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int NOT NULL DEFAULT '0',
  `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int NOT NULL DEFAULT '0',
  `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `locked_by` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`virtuemart_calc_id`),
  KEY `virtuemart_vendor_id` (`virtuemart_vendor_id`),
  KEY `published` (`published`),
  KEY `calc_kind` (`calc_kind`),
  KEY `shared` (`shared`),
  KEY `publish_up` (`publish_up`),
  KEY `publish_down` (`publish_down`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*Data for the table `q4bx8_virtuemart_calcs` */

/*Table structure for table `q4bx8_virtuemart_carts` */


CREATE TABLE `q4bx8_virtuemart_carts` (
  `virtuemart_cart_id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_user_id` int unsigned NOT NULL,
  `virtuemart_vendor_id` int unsigned NOT NULL,
  `cartData` varbinary(50000) DEFAULT NULL,
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int NOT NULL DEFAULT '0',
  `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`virtuemart_cart_id`),
  KEY `virtuemart_vendor_id` (`virtuemart_vendor_id`),
  KEY `virtuemart_user_id` (`virtuemart_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Used to store the cart';

/*Data for the table `q4bx8_virtuemart_carts` */

/*Table structure for table `q4bx8_virtuemart_categories` */


CREATE TABLE `q4bx8_virtuemart_categories` (
  `virtuemart_category_id` int unsigned NOT NULL AUTO_INCREMENT,
  `category_parent_id` int unsigned DEFAULT NULL,
  `virtuemart_vendor_id` int unsigned NOT NULL DEFAULT '1' COMMENT 'BELONGS TO VENDOR',
  `category_template` varchar(128) DEFAULT NULL,
  `category_layout` varchar(64) DEFAULT NULL,
  `category_product_layout` varchar(64) DEFAULT NULL,
  `products_per_row` varchar(1) NOT NULL DEFAULT '',
  `limit_list_step` varchar(32) DEFAULT NULL,
  `limit_list_initial` smallint unsigned DEFAULT NULL,
  `hits` int unsigned NOT NULL DEFAULT '0',
  `cat_params` varchar(15359) NOT NULL DEFAULT '',
  `metarobot` varchar(40) NOT NULL DEFAULT '',
  `metaauthor` varchar(64) NOT NULL DEFAULT '',
  `ordering` int NOT NULL DEFAULT '0',
  `shared` tinyint(1) NOT NULL DEFAULT '0',
  `published` tinyint(1) NOT NULL DEFAULT '1',
  `has_children` tinyint(1) DEFAULT NULL,
  `has_medias` tinyint(1) DEFAULT NULL,
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int NOT NULL DEFAULT '0',
  `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int NOT NULL DEFAULT '0',
  `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `locked_by` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`virtuemart_category_id`),
  KEY `virtuemart_vendor_id` (`virtuemart_vendor_id`),
  KEY `published` (`published`),
  KEY `shared` (`shared`),
  KEY `ordering` (`ordering`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Product Categories are stored here';

/*Data for the table `q4bx8_virtuemart_categories` */

/*Table structure for table `q4bx8_virtuemart_categories_nb_no` */


CREATE TABLE `q4bx8_virtuemart_categories_nb_no` (
  `virtuemart_category_id` int unsigned NOT NULL,
  `category_name` varchar(180) NOT NULL DEFAULT '',
  `category_description` varchar(19000) NOT NULL DEFAULT '',
  `metadesc` varchar(400) NOT NULL DEFAULT '',
  `metakey` varchar(400) NOT NULL DEFAULT '',
  `customtitle` varchar(255) NOT NULL DEFAULT '',
  `slug` varchar(192) NOT NULL DEFAULT '',
  PRIMARY KEY (`virtuemart_category_id`),
  UNIQUE KEY `slug` (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

/*Data for the table `q4bx8_virtuemart_categories_nb_no` */

/*Table structure for table `q4bx8_virtuemart_category_categories` */


CREATE TABLE `q4bx8_virtuemart_category_categories` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `category_parent_id` int unsigned NOT NULL DEFAULT '0',
  `category_child_id` int unsigned NOT NULL DEFAULT '0',
  `ordering` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `category_child_id` (`category_child_id`),
  UNIQUE KEY `category_parent_id` (`category_parent_id`,`category_child_id`),
  KEY `ordering` (`ordering`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Category child-parent relation list';

/*Data for the table `q4bx8_virtuemart_category_categories` */

/*Table structure for table `q4bx8_virtuemart_category_medias` */


CREATE TABLE `q4bx8_virtuemart_category_medias` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_category_id` int unsigned NOT NULL DEFAULT '0',
  `virtuemart_media_id` int unsigned NOT NULL DEFAULT '0',
  `ordering` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `virtuemart_category_id` (`virtuemart_category_id`,`virtuemart_media_id`),
  KEY `ordering` (`virtuemart_category_id`,`ordering`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*Data for the table `q4bx8_virtuemart_category_medias` */

/*Table structure for table `q4bx8_virtuemart_configs` */


CREATE TABLE `q4bx8_virtuemart_configs` (
  `virtuemart_config_id` tinyint unsigned NOT NULL AUTO_INCREMENT,
  `config` text,
  `created_on` datetime DEFAULT NULL,
  `created_by` int NOT NULL DEFAULT '0',
  `modified_on` datetime DEFAULT NULL,
  `modified_by` int NOT NULL DEFAULT '0',
  `locked_on` datetime DEFAULT NULL,
  `locked_by` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`virtuemart_config_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COMMENT='Holds configuration settings';

/*Data for the table `q4bx8_virtuemart_configs` */

insert  into `q4bx8_virtuemart_configs`(`virtuemart_config_id`,`config`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) values 
(1,'backendTemplate=\"1\"|useSSL=\"0\"|dangeroustools=0|debug_enable=\"none\"|vmdev=\"none\"|google_jquery=\"0\"|multix=\"none\"|usefancy=\"1\"|jchosen=\"1\"|enableEnglish=\"1\"|shop_is_offline=\"0\"|offline_message=\"Our Shop is currently down for maintenance. Please check back again soon.\"|use_as_catalog=\"0\"|currency_converter_module=\"convertECB.php\"|order_mail_html=\"1\"|useVendorEmail=\"0\"|pdf_button_enable=\"1\"|show_emailfriend=\"0\"|show_printicon=\"1\"|show_out_of_stock_products=\"1\"|ask_captcha=\"1\"|coupons_enable=\"1\"|show_uncat_products=\"0\"|show_uncat_child_products=\"0\"|show_unpub_cat_products=\"1\"|coupons_default_expire=\"1,M\"|weight_unit_default=\"KG\"|lwh_unit_default=\"M\"|list_limit=\"30\"|showReviewFor=\"all\"|reviewMode=\"bought\"|showRatingFor=\"all\"|ratingMode=\"bought\"|reviews_autopublish=\"1\"|reviews_minimum_comment_length=\"0\"|reviews_maximum_comment_length=\"2000\"|product_navigation=\"1\"|display_stock=\"1\"|vmtemplate=\"\"|category_template=\"0\"|showcategory=\"1\"|categorylayout=\"default\"|categories_per_row=\"3\"|productlayout=\"default\"|products_per_row=\"3\"|llimit_init_FE=\"24\"|vmlayout=\"default\"|show_store_desc=\"1\"|show_categories=\"1\"|featured_rows=\"1\"|topten=\"1\"|topten_rows=\"1\"|recent=\"1\"|recent_rows=\"1\"|latest=\"1\"|latest_rows=\"1\"|legacylayouts=\"0\"|assets_general_path=\"components\\/com_virtuemart\\/assets\\/\"|media_category_path=\"images\\/virtuemart\\/category\\/\"|media_product_path=\"images\\/virtuemart\\/product\\/\"|media_manufacturer_path=\"images\\/virtuemart\\/manufacturer\\/\"|media_vendor_path=\"images\\/virtuemart\\/vendor\\/\"|forSale_path_thumb=\"images\\/virtuemart\\/forSale\\/resized\\/\"|img_resize_enable=\"1\"|img_width=\"0\"|img_height=\"90\"|no_image_set=\"noimage_new.gif\"|no_image_found=\"warning.png\"|browse_orderby_field=\"pc.ordering,product_name\"|browse_cat_orderby_field=\"c.ordering,category_name\"|browse_orderby_fields=[\"product_name\",\"`p`.product_sku\",\"mf_name\",\"pc.ordering\"]|browse_search_fields=[\"product_name\",\"`p`.product_sku\",\"product_s_desc\",\"mf_name\"]|askprice=\"1\"|roundindig=\"1\"|show_prices=\"1\"|price_show_packaging_pricelabel=\"0\"|show_tax=\"1\"|basePrice=\"0\"|basePriceText=\"1\"|basePriceRounding=\"-1\"|variantModification=\"0\"|variantModificationText=\"1\"|variantModificationRounding=\"-1\"|basePriceVariant=\"1\"|basePriceVariantText=\"1\"|basePriceVariantRounding=\"-1\"|basePriceWithTax=\"0\"|basePriceWithTaxText=\"1\"|basePriceWithTaxRounding=\"-1\"|discountedPriceWithoutTax=\"1\"|discountedPriceWithoutTaxText=\"1\"|discountedPriceWithoutTaxRounding=\"-1\"|salesPriceWithDiscount=\"0\"|salesPriceWithDiscountText=\"1\"|salesPriceWithDiscountRounding=\"-1\"|salesPrice=\"1\"|salesPriceText=\"1\"|salesPriceRounding=\"-1\"|priceWithoutTax=\"1\"|priceWithoutTaxText=\"1\"|priceWithoutTaxRounding=\"-1\"|discountAmount=\"1\"|discountAmountText=\"1\"|discountAmountRounding=\"-1\"|taxAmount=\"1\"|taxAmountText=\"1\"|taxAmountRounding=\"-1\"|unitPrice=\"1\"|unitPriceText=\"1\"|unitPriceRounding=\"-1\"|addtocart_popup=\"1\"|check_stock=\"0\"|automatic_payment=\"0\"|automatic_shipment=\"0\"|oncheckout_opc=\"1\"|oncheckout_ajax=\"1\"|oncheckout_show_legal_info=\"1\"|oncheckout_show_register=\"1\"|oncheckout_show_steps=\"0\"|oncheckout_show_register_text=\"COM_VIRTUEMART_ONCHECKOUT_DEFAULT_TEXT_REGISTER\"|oncheckout_show_images=\"1\"|inv_os=[\"C\"]|email_os_s=[\"U\",\"C\",\"X\",\"R\",\"S\"]|email_os_v=[\"U\",\"C\",\"X\",\"R\"]|seo_disabled=\"0\"|seo_translate=\"0\"|seo_use_id=\"0\"|enable_content_plugin=\"0\"|reg_captcha=\"0\"|handle_404=\"1\"|member_access_number=\"\"|vmDefLang=\"\"|prodOnlyWLang=\"0\"|vm_lfbs=\"\"|ReInjectJLanguage=\"0\"|backendStyle=\"default-white-blue\"|debug_enable_methods=\"0\"|debug_enable_router=\"0\"|debug_Sql=\"0\"|revproxvar=\"\"|multixcart=\"0\"|optimisedProductSql=\"1\"|optimisedCalcSql=\"1\"|optimisedCatSql=\"1\"|invoiceInUserLang=\"0\"|debug_mail=\"0\"|addVendorEmail=\"\"|attach=\"\"|attach_os=[\"U\",\"C\",\"X\",\"R\"]|norm_units=\"KG,100G,M,SM,CUBM,L,100ML,P\"|pdf_icon=\"0\"|cp_rm=[\"C\"]|recommend_unauth=\"0\"|ask_question=\"0\"|asks_minimum_comment_length=\"50\"|asks_maximum_comment_length=\"2000\"|lstockmail=\"0\"|stockhandle_products=\"0\"|stockhandle=\"none\"|rised_availability=\"\"|image=\"\"|show_pcustoms=\"1\"|show_subcat_products=\"0\"|strictCustomfieldTags=\"1\"|show_uncat_parent_products=\"0\"|cat_productdetails=\"0\"|latest_products_days=\"7\"|latest_products_orderBy=\"created_on\"|reviews_languagefilter=\"0\"|vm_num_ratings_show=\"3\"|rr_os=[\"C\"]|showcategory_desc=\"1\"|showsearch=\"1\"|ProductGroupsSequence=\"featured, discontinued, latest, topten, recent\"|showproducts=\"1\"|omitLoaded=\"1\"|show_manufacturers=\"1\"|manufacturer_per_row=\"3\"|featured=\"1\"|omitLoaded_featured=\"1\"|discontinued=\"1\"|discontinued_rows=\"1\"|omitLoaded_discontinued=\"1\"|omitLoaded_topten=\"1\"|omitLoaded_recent=\"1\"|omitLoaded_latest=\"1\"|add_img_main=\"0\"|img_width_full=\"\"|img_height_full=\"\"|forSale_path=\"C:\\\\internett\\\\vmfiles\\\\\"|bootstrap=\"\"|categorytemplate=\"\"|cartlayout=\"default\"|productsublayout=\"\"|mediaLimit=\"20\"|llimit_init_BE=\"30\"|pagseq=\"\"|pagseq_1=\"\"|pagseq_2=\"\"|pagseq_3=\"\"|pagseq_4=\"\"|pagseq_5=\"\"|lazyLoad=\"1\"|useLayoutOverrides=\"1\"|css=\"1\"|jquery_framework=\"1\"|jquery=\"1\"|jprice=\"1\"|jsite=\"1\"|jdynupdate=\"1\"|ajax_category=\"0\"|homepage_categories_per_row=\"3\"|homepage_products_per_row=\"3\"|vm_prices_info_tax=\"0\"|vm_prices_info_delivery=\"0\"|rappenrundung=\"0\"|cVarswT=\"1\"|pricesbyCurrency=\"0\"|price_orderby=\"DESC\"|expertPrices=\"0\"|discountedPriceWithoutTaxTt=\"0\"|discountedPriceWithoutTaxTtText=\"0\"|discountedPriceWithoutTaxTtRounding=\"-1\"|priceWithoutTaxTt=\"0\"|priceWithoutTaxTtText=\"0\"|priceWithoutTaxTtRounding=\"-1\"|taxAmountTt=\"0\"|taxAmountTtText=\"0\"|taxAmountTtRounding=\"-1\"|salesPriceTt=\"0\"|salesPriceTtText=\"0\"|salesPriceTtRounding=\"-1\"|discountAmountTt=\"0\"|discountAmountTtText=\"0\"|discountAmountTtRounding=\"-1\"|popup_rel=\"1\"|radicalShipPaymentVat=\"1\"|agree_to_tos_onorder=\"1\"|oncheckout_change_shopper=\"1\"|del_date_type=\"m\"|oncheckout_only_registered=\"0\"|cartCookieExpire=\"0\"|ordertracking=\"guests\"|prd_brws_orderby_dir=\"ASC\"|cat_brws_orderby_dir=\"ASC\"|feed_latest_published=\"0\"|feed_latest_nb=\"5\"|feed_topten_published=\"0\"|feed_topten_nb=\"5\"|feed_featured_published=\"0\"|feed_featured_nb=\"5\"|feed_home_show_images=\"1\"|feed_home_show_prices=\"1\"|feed_home_show_description=\"0\"|feed_home_description_type=\"product_s_desc\"|feed_home_max_text_length=\"500\"|feed_cat_published=\"0\"|feed_cat_show_images=\"0\"|feed_cat_show_prices=\"0\"|feed_cat_show_description=\"0\"|feed_cat_description_type=\"product_s_desc\"|feed_cat_max_text_length=\"500\"|use_seo_suffix=\"1\"|seo_sufix=\"-detail\"|transliterateSlugs=\"0\"|seo_full=\"1\"|router_by_menu=\"0\"|sef_for_cart_links=\"1\"|UseCachegetChildCategoryList=\"1\"|useCacheVmGetCategoryRoute=\"1\"|UseCachegetOrderByList=\"1\"|task=\"apply\"|option=\"com_virtuemart\"|view=\"config\"|6fd505703dc05cbb7d9f678db7350d05=\"1\"|active_languages=[\"nb-NO\"]|sctime=1661978244.109137|vmlang=\"nb_no\"','2022-08-31 20:25:23',256,'2022-08-31 20:41:18',256,NULL,0);

/*Table structure for table `q4bx8_virtuemart_countries` */


CREATE TABLE `q4bx8_virtuemart_countries` (
  `virtuemart_country_id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_worldzone_id` tinyint(1) NOT NULL DEFAULT '1',
  `country_name` varchar(64) DEFAULT NULL,
  `country_3_code` char(3) DEFAULT NULL,
  `country_2_code` char(2) DEFAULT NULL,
  `ordering` int NOT NULL DEFAULT '0',
  `country_num_code` char(3) DEFAULT NULL,
  `published` tinyint(1) NOT NULL DEFAULT '1',
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int NOT NULL DEFAULT '0',
  `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int NOT NULL DEFAULT '0',
  `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `locked_by` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`virtuemart_country_id`),
  UNIQUE KEY `country_3_code` (`country_3_code`),
  UNIQUE KEY `country_2_code` (`country_2_code`),
  KEY `country_name` (`country_name`),
  KEY `ordering` (`ordering`),
  KEY `published` (`published`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Country records';

/*Data for the table `q4bx8_virtuemart_countries` */

/*Table structure for table `q4bx8_virtuemart_coupons` */


CREATE TABLE `q4bx8_virtuemart_coupons` (
  `virtuemart_coupon_id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_vendor_id` int unsigned NOT NULL,
  `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(15,5) NOT NULL DEFAULT '0.00000',
  `coupon_start_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `coupon_expiry_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `coupon_value_valid` decimal(15,5) NOT NULL DEFAULT '0.00000',
  `coupon_used` varchar(200) NOT NULL DEFAULT '',
  `coupon_value_max` decimal(15,5) NOT NULL DEFAULT '0.00000',
  `virtuemart_shoppergroup_ids` text NOT NULL,
  `virtuemart_shopper_ids` text NOT NULL,
  `virtuemart_product_ids` text NOT NULL,
  `virtuemart_category_ids` text NOT NULL,
  `virtuemart_coupon_max_attempt_per_user` tinyint NOT NULL,
  `published` tinyint(1) NOT NULL DEFAULT '1',
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int NOT NULL DEFAULT '0',
  `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int NOT NULL DEFAULT '0',
  `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `locked_by` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`virtuemart_coupon_id`),
  KEY `virtuemart_vendor_id` (`virtuemart_vendor_id`),
  KEY `coupon_code` (`coupon_code`),
  KEY `coupon_type` (`coupon_type`),
  KEY `published` (`published`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Used to store coupon codes';

/*Data for the table `q4bx8_virtuemart_coupons` */

/*Table structure for table `q4bx8_virtuemart_currencies` */


CREATE TABLE `q4bx8_virtuemart_currencies` (
  `virtuemart_currency_id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_vendor_id` int unsigned NOT NULL DEFAULT '1',
  `currency_name` varchar(64) DEFAULT NULL,
  `currency_code_2` char(2) DEFAULT NULL,
  `currency_code_3` char(3) DEFAULT NULL,
  `currency_numeric_code` int DEFAULT NULL,
  `currency_exchange_rate` decimal(12,5) DEFAULT NULL,
  `currency_symbol` varchar(8) DEFAULT NULL,
  `currency_decimal_place` varchar(8) DEFAULT NULL,
  `currency_decimal_symbol` varchar(8) DEFAULT NULL,
  `currency_thousands` varchar(8) DEFAULT NULL,
  `currency_positive_style` varchar(64) DEFAULT NULL,
  `currency_negative_style` varchar(64) DEFAULT NULL,
  `ordering` int NOT NULL DEFAULT '0',
  `shared` tinyint(1) NOT NULL DEFAULT '1',
  `published` tinyint(1) NOT NULL DEFAULT '1',
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int NOT NULL DEFAULT '0',
  `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int NOT NULL DEFAULT '0',
  `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `locked_by` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`virtuemart_currency_id`),
  UNIQUE KEY `currency_code_3` (`currency_code_3`),
  KEY `ordering` (`ordering`),
  KEY `currency_name` (`currency_name`),
  KEY `published` (`published`),
  KEY `shared` (`shared`),
  KEY `virtuemart_vendor_id` (`virtuemart_vendor_id`),
  KEY `currency_numeric_code` (`currency_numeric_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Used to store currencies';

/*Data for the table `q4bx8_virtuemart_currencies` */

/*Table structure for table `q4bx8_virtuemart_customs` */


CREATE TABLE `q4bx8_virtuemart_customs` (
  `virtuemart_custom_id` int unsigned NOT NULL AUTO_INCREMENT,
  `custom_parent_id` int unsigned NOT NULL DEFAULT '0',
  `virtuemart_vendor_id` int unsigned NOT NULL DEFAULT '1',
  `custom_jplugin_id` int NOT NULL DEFAULT '0',
  `custom_element` varchar(50) NOT NULL DEFAULT '',
  `admin_only` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1:Display in admin only',
  `custom_title` varchar(255) NOT NULL DEFAULT '' COMMENT 'field title',
  `show_title` tinyint(1) NOT NULL DEFAULT '1',
  `custom_tip` varchar(255) NOT NULL DEFAULT '' COMMENT 'tip',
  `custom_value` varchar(4095) DEFAULT NULL COMMENT 'default value',
  `custom_desc` varchar(4095) DEFAULT NULL COMMENT 'description or unit',
  `field_type` varchar(2) NOT NULL DEFAULT '0' COMMENT 'S:string,I:int,P:parent, B:bool,D:date,T:time,H:hidden',
  `is_list` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'list of values',
  `is_hidden` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1:hidden',
  `is_cart_attribute` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Add attributes to cart',
  `is_input` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Add input to cart',
  `searchable` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Available as search filter',
  `layout_pos` varchar(24) DEFAULT NULL COMMENT 'Layout Position',
  `custom_params` text NOT NULL,
  `virtuemart_shoppergroup_id` varchar(255) NOT NULL,
  `shared` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'valid for all vendors?',
  `published` tinyint(1) NOT NULL DEFAULT '1',
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int NOT NULL DEFAULT '0',
  `ordering` int NOT NULL DEFAULT '0',
  `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int NOT NULL DEFAULT '0',
  `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `locked_by` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`virtuemart_custom_id`),
  KEY `custom_parent_id` (`custom_parent_id`),
  KEY `virtuemart_vendor_id` (`virtuemart_vendor_id`),
  KEY `custom_element` (`custom_element`),
  KEY `field_type` (`field_type`),
  KEY `is_cart_attribute` (`is_cart_attribute`),
  KEY `is_input` (`is_input`),
  KEY `searchable` (`searchable`),
  KEY `shared` (`shared`),
  KEY `published` (`published`),
  KEY `ordering` (`ordering`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='custom fields definition';

/*Data for the table `q4bx8_virtuemart_customs` */

/*Table structure for table `q4bx8_virtuemart_invoices` */


CREATE TABLE `q4bx8_virtuemart_invoices` (
  `virtuemart_invoice_id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_vendor_id` int unsigned NOT NULL DEFAULT '1',
  `virtuemart_order_id` int unsigned DEFAULT NULL,
  `invoice_number` varchar(64) DEFAULT NULL,
  `order_status` char(2) DEFAULT NULL,
  `xhtml` text,
  `o_hash` varchar(33) DEFAULT NULL,
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int NOT NULL DEFAULT '0',
  `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int NOT NULL DEFAULT '0',
  `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `locked_by` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`virtuemart_invoice_id`),
  UNIQUE KEY `invoice_number` (`invoice_number`,`virtuemart_vendor_id`),
  KEY `virtuemart_order_id` (`virtuemart_order_id`),
  KEY `virtuemart_vendor_id` (`virtuemart_vendor_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='custom fields definition';

/*Data for the table `q4bx8_virtuemart_invoices` */

/*Table structure for table `q4bx8_virtuemart_manufacturer_medias` */


CREATE TABLE `q4bx8_virtuemart_manufacturer_medias` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_manufacturer_id` int unsigned NOT NULL DEFAULT '0',
  `virtuemart_media_id` int unsigned NOT NULL DEFAULT '0',
  `ordering` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `virtuemart_manufacturer_id` (`virtuemart_manufacturer_id`,`virtuemart_media_id`),
  KEY `ordering` (`ordering`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*Data for the table `q4bx8_virtuemart_manufacturer_medias` */

/*Table structure for table `q4bx8_virtuemart_manufacturercategories` */


CREATE TABLE `q4bx8_virtuemart_manufacturercategories` (
  `virtuemart_manufacturercategories_id` int unsigned NOT NULL AUTO_INCREMENT,
  `published` tinyint(1) NOT NULL DEFAULT '1',
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int NOT NULL DEFAULT '0',
  `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int NOT NULL DEFAULT '0',
  `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `locked_by` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`virtuemart_manufacturercategories_id`),
  KEY `published` (`published`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Manufacturers are assigned to these categories';

/*Data for the table `q4bx8_virtuemart_manufacturercategories` */

/*Table structure for table `q4bx8_virtuemart_manufacturercategories_nb_no` */


CREATE TABLE `q4bx8_virtuemart_manufacturercategories_nb_no` (
  `virtuemart_manufacturercategories_id` int unsigned NOT NULL,
  `mf_category_name` varchar(180) NOT NULL DEFAULT '',
  `mf_category_desc` varchar(19000) NOT NULL DEFAULT '',
  `slug` varchar(192) NOT NULL DEFAULT '',
  PRIMARY KEY (`virtuemart_manufacturercategories_id`),
  UNIQUE KEY `slug` (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

/*Data for the table `q4bx8_virtuemart_manufacturercategories_nb_no` */

/*Table structure for table `q4bx8_virtuemart_manufacturers` */


CREATE TABLE `q4bx8_virtuemart_manufacturers` (
  `virtuemart_manufacturer_id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_manufacturercategories_id` int DEFAULT NULL,
  `metarobot` varchar(400) DEFAULT NULL,
  `metaauthor` varchar(400) DEFAULT NULL,
  `hits` int unsigned NOT NULL DEFAULT '0',
  `published` tinyint(1) NOT NULL DEFAULT '1',
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int NOT NULL DEFAULT '0',
  `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int NOT NULL DEFAULT '0',
  `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `locked_by` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`virtuemart_manufacturer_id`),
  UNIQUE KEY `virtuemart_manufacturercategories_id` (`virtuemart_manufacturer_id`,`virtuemart_manufacturercategories_id`),
  KEY `published` (`published`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Manufacturers are those who deliver products';

/*Data for the table `q4bx8_virtuemart_manufacturers` */

/*Table structure for table `q4bx8_virtuemart_manufacturers_nb_no` */


CREATE TABLE `q4bx8_virtuemart_manufacturers_nb_no` (
  `virtuemart_manufacturer_id` int unsigned NOT NULL,
  `mf_name` varchar(180) NOT NULL DEFAULT '',
  `mf_email` varchar(255) NOT NULL DEFAULT '',
  `mf_desc` varchar(19000) NOT NULL DEFAULT '',
  `mf_url` varchar(255) NOT NULL DEFAULT '',
  `metadesc` varchar(400) NOT NULL DEFAULT '',
  `metakey` varchar(400) NOT NULL DEFAULT '',
  `customtitle` varchar(255) NOT NULL DEFAULT '',
  `slug` varchar(192) NOT NULL DEFAULT '',
  PRIMARY KEY (`virtuemart_manufacturer_id`),
  UNIQUE KEY `slug` (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

/*Data for the table `q4bx8_virtuemart_manufacturers_nb_no` */

/*Table structure for table `q4bx8_virtuemart_medias` */


CREATE TABLE `q4bx8_virtuemart_medias` (
  `virtuemart_media_id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_vendor_id` int unsigned NOT NULL DEFAULT '1',
  `file_title` varchar(126) NOT NULL DEFAULT '',
  `file_description` varchar(254) NOT NULL DEFAULT '',
  `file_meta` varchar(254) NOT NULL DEFAULT '',
  `file_class` varchar(64) NOT NULL DEFAULT '',
  `file_mimetype` varchar(64) NOT NULL DEFAULT '',
  `file_type` varchar(32) NOT NULL DEFAULT '',
  `file_url` varchar(900) NOT NULL DEFAULT '',
  `file_url_thumb` varchar(900) NOT NULL DEFAULT '',
  `file_is_product_image` tinyint(1) NOT NULL DEFAULT '0',
  `file_is_downloadable` tinyint(1) NOT NULL DEFAULT '0',
  `file_is_forSale` tinyint(1) NOT NULL DEFAULT '0',
  `file_params` varchar(12287) NOT NULL DEFAULT '',
  `file_lang` varchar(500) NOT NULL DEFAULT '',
  `shared` tinyint(1) NOT NULL DEFAULT '0',
  `published` tinyint(1) NOT NULL DEFAULT '1',
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int NOT NULL DEFAULT '0',
  `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int NOT NULL DEFAULT '0',
  `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `locked_by` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`virtuemart_media_id`),
  KEY `virtuemart_vendor_id` (`virtuemart_vendor_id`),
  KEY `published` (`published`),
  KEY `file_type` (`file_type`),
  KEY `shared` (`shared`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Additional Images and Files which are assigned to products';

/*Data for the table `q4bx8_virtuemart_medias` */

/*Table structure for table `q4bx8_virtuemart_migration_oldtonew_ids` */


CREATE TABLE `q4bx8_virtuemart_migration_oldtonew_ids` (
  `id` smallint unsigned NOT NULL AUTO_INCREMENT,
  `cats` longblob,
  `catsxref` blob,
  `manus` longblob,
  `mfcats` blob,
  `shoppergroups` longblob,
  `products` longblob,
  `products_start` int DEFAULT NULL,
  `orderstates` blob,
  `orders` longblob,
  `attributes` longblob,
  `relatedproducts` longblob,
  `orders_start` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='xref table for vm1 ids to vm2 ids';

/*Data for the table `q4bx8_virtuemart_migration_oldtonew_ids` */

/*Table structure for table `q4bx8_virtuemart_modules` */


CREATE TABLE `q4bx8_virtuemart_modules` (
  `module_id` int unsigned NOT NULL AUTO_INCREMENT,
  `module_name` char(255) DEFAULT NULL,
  `module_description` varchar(15359) DEFAULT NULL,
  `module_perms` char(255) DEFAULT NULL,
  `published` tinyint(1) NOT NULL DEFAULT '1',
  `is_admin` enum('0','1') NOT NULL DEFAULT '0',
  `ordering` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`module_id`),
  KEY `module_name` (`module_name`(250)),
  KEY `ordering` (`ordering`),
  KEY `published` (`published`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='VirtueMart Core Modules, not: Joomla modules';

/*Data for the table `q4bx8_virtuemart_modules` */

insert  into `q4bx8_virtuemart_modules`(`module_id`,`module_name`,`module_description`,`module_perms`,`published`,`is_admin`,`ordering`) values 
(1,'product','Here you can administer your online catalog of products.  Categories , Products (view=product), Attributes, Product Types, Product Files (view=media), Inventory, Calculation Rules, Customer Reviews  ','storeadmin,admin',1,'',1),
(2,'order','View Order and Update Order Status:    Orders , Coupons , Revenue Report ,Shopper , Shopper Groups ','admin,storeadmin',1,'',2),
(3,'manufacturer','Manage the manufacturers of products in your store.','storeadmin,admin',1,'',3),
(4,'store','Store Configuration: Store Information, Payment Methods , Shipment, Shipment Rates','storeadmin,admin',1,'',4),
(5,'configuration','Configuration: shop configuration , currencies (view=currency), Credit Card List, Countries, userfields, order status  ','admin,storeadmin',1,'0',5),
(6,'msgs','This module is unprotected an used for displaying system messages to users.  We need to have an area that does not require authorization when things go wrong.','none',0,'',99),
(7,'shop','This is the Washupito store module.  This is the demo store included with the VirtueMart distribution.','none',1,'',99),
(8,'store','Store Configuration: Store Information, Payment Methods , Shipment, Shipment Rates','storeadmin,admin',1,'',4),
(9,'account','This module allows shoppers to update their account information and view previously placed orders.','shopper,storeadmin,admin,demo',1,'',99),
(10,'checkout','','none',0,'',99),
(11,'tools','Tools','admin',1,'0',8),
(13,'zone','This is the zone-shipment module. Here you can manage your shipment costs according to Zones.','admin,storeadmin',0,'',11);

/*Table structure for table `q4bx8_virtuemart_order_calc_rules` */


CREATE TABLE `q4bx8_virtuemart_order_calc_rules` (
  `virtuemart_order_calc_rule_id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_calc_id` int unsigned DEFAULT NULL,
  `virtuemart_order_id` int unsigned DEFAULT NULL,
  `virtuemart_vendor_id` int unsigned NOT NULL DEFAULT '1',
  `virtuemart_order_item_id` int DEFAULT NULL,
  `calc_rule_name` varchar(64) NOT NULL DEFAULT '' COMMENT 'Name of the rule',
  `calc_kind` varchar(16) NOT NULL DEFAULT '' COMMENT 'Discount/Tax/Margin/Commission',
  `calc_mathop` varchar(16) NOT NULL DEFAULT '' COMMENT 'Discount/Tax/Margin/Commission',
  `calc_amount` decimal(15,5) NOT NULL DEFAULT '0.00000',
  `calc_result` decimal(15,5) NOT NULL DEFAULT '0.00000',
  `calc_value` decimal(15,5) NOT NULL DEFAULT '0.00000',
  `calc_currency` int DEFAULT NULL,
  `calc_params` varchar(15359) NOT NULL DEFAULT '',
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int NOT NULL DEFAULT '0',
  `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int NOT NULL DEFAULT '0',
  `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `locked_by` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`virtuemart_order_calc_rule_id`),
  KEY `virtuemart_calc_id` (`virtuemart_calc_id`),
  KEY `virtuemart_order_id` (`virtuemart_order_id`),
  KEY `virtuemart_vendor_id` (`virtuemart_vendor_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Stores all calculation rules which are part of an order';

/*Data for the table `q4bx8_virtuemart_order_calc_rules` */

/*Table structure for table `q4bx8_virtuemart_order_histories` */


CREATE TABLE `q4bx8_virtuemart_order_histories` (
  `virtuemart_order_history_id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_order_id` int unsigned NOT NULL DEFAULT '0',
  `order_status_code` char(1) NOT NULL DEFAULT '0',
  `customer_notified` tinyint(1) NOT NULL DEFAULT '0',
  `comments` varchar(15359) DEFAULT NULL,
  `paid` decimal(15,5) NOT NULL DEFAULT '0.00000',
  `o_hash` varchar(33) DEFAULT NULL,
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int NOT NULL DEFAULT '0',
  `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int NOT NULL DEFAULT '0',
  `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `locked_by` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`virtuemart_order_history_id`),
  KEY `virtuemart_order_id` (`virtuemart_order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Stores all actions and changes that occur to an order';

/*Data for the table `q4bx8_virtuemart_order_histories` */

/*Table structure for table `q4bx8_virtuemart_order_item_histories` */


CREATE TABLE `q4bx8_virtuemart_order_item_histories` (
  `virtuemart_order_item_history_id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_order_item_id` int unsigned NOT NULL,
  `virtuemart_order_id` int unsigned DEFAULT NULL,
  `virtuemart_vendor_id` int unsigned NOT NULL DEFAULT '1',
  `virtuemart_product_id` int DEFAULT NULL,
  `action` varchar(255) NOT NULL DEFAULT '',
  `order_item_sku` varchar(255) NOT NULL DEFAULT '',
  `order_item_name` varchar(4096) NOT NULL DEFAULT '',
  `product_quantity` int DEFAULT NULL,
  `product_item_price` decimal(15,5) DEFAULT NULL,
  `product_priceWithoutTax` decimal(15,5) DEFAULT NULL,
  `product_tax` decimal(15,5) DEFAULT NULL,
  `product_basePriceWithTax` decimal(15,5) DEFAULT NULL,
  `product_discountedPriceWithoutTax` decimal(15,5) DEFAULT NULL,
  `product_final_price` decimal(15,5) NOT NULL DEFAULT '0.00000',
  `product_subtotal_discount` decimal(15,5) NOT NULL DEFAULT '0.00000',
  `product_subtotal_with_tax` decimal(15,5) NOT NULL DEFAULT '0.00000',
  `order_item_currency` int DEFAULT NULL,
  `order_status` char(1) DEFAULT NULL,
  `product_attribute` mediumtext,
  `delivery_date` varchar(200) DEFAULT NULL,
  `paid` decimal(15,5) NOT NULL DEFAULT '0.00000',
  `oi_hash` varchar(33) DEFAULT NULL,
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int NOT NULL DEFAULT '0',
  `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int NOT NULL DEFAULT '0',
  `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `locked_by` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`virtuemart_order_item_history_id`),
  KEY `virtuemart_order_id` (`virtuemart_order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Stores all actions and changes that occur to an order item only';

/*Data for the table `q4bx8_virtuemart_order_item_histories` */

/*Table structure for table `q4bx8_virtuemart_order_items` */


CREATE TABLE `q4bx8_virtuemart_order_items` (
  `virtuemart_order_item_id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_order_id` int unsigned DEFAULT NULL,
  `virtuemart_vendor_id` int unsigned NOT NULL DEFAULT '1',
  `virtuemart_product_id` int DEFAULT NULL,
  `order_item_sku` varchar(255) NOT NULL DEFAULT '',
  `order_item_name` varchar(4096) NOT NULL DEFAULT '',
  `product_quantity` int DEFAULT NULL,
  `product_item_price` decimal(15,5) DEFAULT NULL,
  `product_priceWithoutTax` decimal(15,5) DEFAULT NULL,
  `product_tax` decimal(15,5) DEFAULT NULL,
  `product_basePriceWithTax` decimal(15,5) DEFAULT NULL,
  `product_discountedPriceWithoutTax` decimal(15,5) DEFAULT NULL,
  `product_final_price` decimal(15,5) NOT NULL DEFAULT '0.00000',
  `product_subtotal_discount` decimal(15,5) NOT NULL DEFAULT '0.00000',
  `product_subtotal_with_tax` decimal(15,5) NOT NULL DEFAULT '0.00000',
  `order_item_currency` int DEFAULT NULL,
  `order_status` char(1) DEFAULT NULL,
  `product_attribute` mediumtext,
  `delivery_date` varchar(200) DEFAULT NULL,
  `paid` decimal(15,5) NOT NULL DEFAULT '0.00000',
  `oi_hash` varchar(33) DEFAULT NULL,
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int NOT NULL DEFAULT '0',
  `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int NOT NULL DEFAULT '0',
  `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `locked_by` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`virtuemart_order_item_id`),
  KEY `virtuemart_product_id` (`virtuemart_product_id`),
  KEY `virtuemart_order_id` (`virtuemart_order_id`),
  KEY `virtuemart_vendor_id` (`virtuemart_vendor_id`),
  KEY `order_status` (`order_status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Stores all items (products) which are part of an order';

/*Data for the table `q4bx8_virtuemart_order_items` */

/*Table structure for table `q4bx8_virtuemart_order_userinfos` */


CREATE TABLE `q4bx8_virtuemart_order_userinfos` (
  `virtuemart_order_userinfo_id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_order_id` int unsigned NOT NULL DEFAULT '0',
  `virtuemart_user_id` int unsigned 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(96) DEFAULT NULL,
  `first_name` varchar(96) DEFAULT NULL,
  `middle_name` varchar(96) DEFAULT NULL,
  `phone_1` varchar(32) DEFAULT NULL,
  `phone_2` varchar(32) DEFAULT NULL,
  `fax` varchar(32) DEFAULT NULL,
  `address_1` varchar(96) NOT NULL DEFAULT '',
  `address_2` varchar(64) DEFAULT NULL,
  `city` varchar(96) NOT NULL DEFAULT '',
  `virtuemart_state_id` smallint unsigned NOT NULL DEFAULT '0',
  `virtuemart_country_id` smallint unsigned NOT NULL DEFAULT '0',
  `zip` varchar(32) NOT NULL DEFAULT '',
  `email` varchar(128) DEFAULT NULL,
  `agreed` tinyint(1) NOT NULL DEFAULT '0',
  `tos` tinyint(1) NOT NULL DEFAULT '0',
  `customer_note` varchar(5000) NOT NULL DEFAULT '',
  `created_on` datetime DEFAULT NULL,
  `created_by` int NOT NULL DEFAULT '0',
  `modified_on` datetime DEFAULT NULL,
  `modified_by` int NOT NULL DEFAULT '0',
  `locked_on` datetime DEFAULT NULL,
  `locked_by` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`virtuemart_order_userinfo_id`),
  KEY `virtuemart_order_id` (`virtuemart_order_id`),
  KEY `virtuemart_user_id` (`virtuemart_user_id`,`address_type`),
  KEY `address_type` (`address_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Stores the BillTo and ShipTo Information at order time';

/*Data for the table `q4bx8_virtuemart_order_userinfos` */

/*Table structure for table `q4bx8_virtuemart_orders` */


CREATE TABLE `q4bx8_virtuemart_orders` (
  `virtuemart_order_id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_user_id` int unsigned NOT NULL DEFAULT '0',
  `virtuemart_vendor_id` int unsigned NOT NULL DEFAULT '0',
  `order_note` varchar(5000) DEFAULT NULL,
  `order_number` varchar(64) DEFAULT NULL,
  `customer_number` varchar(32) DEFAULT NULL,
  `order_pass` varchar(34) DEFAULT NULL,
  `order_create_invoice_pass` varchar(32) DEFAULT NULL,
  `invoice_locked` tinyint(1) NOT NULL DEFAULT '0',
  `order_total` decimal(15,5) NOT NULL DEFAULT '0.00000',
  `order_salesPrice` decimal(15,5) NOT NULL DEFAULT '0.00000',
  `order_billTaxAmount` decimal(15,5) NOT NULL DEFAULT '0.00000',
  `order_billTax` varchar(400) DEFAULT NULL,
  `order_billDiscountAmount` decimal(15,5) NOT NULL DEFAULT '0.00000',
  `order_discountAmount` decimal(15,5) NOT NULL DEFAULT '0.00000',
  `order_subtotal` decimal(15,5) DEFAULT NULL,
  `order_tax` decimal(12,5) DEFAULT NULL,
  `order_shipment` decimal(12,5) DEFAULT NULL,
  `order_shipment_tax` decimal(10,5) DEFAULT NULL,
  `order_payment` decimal(12,2) DEFAULT NULL,
  `order_payment_tax` decimal(10,5) DEFAULT NULL,
  `coupon_discount` decimal(12,2) NOT NULL DEFAULT '0.00',
  `coupon_code` varchar(32) DEFAULT NULL,
  `order_discount` decimal(12,2) NOT NULL DEFAULT '0.00',
  `order_currency` smallint DEFAULT NULL,
  `order_status` char(1) DEFAULT NULL,
  `user_currency_id` smallint DEFAULT NULL,
  `user_currency_rate` decimal(12,6) NOT NULL DEFAULT '1.000000',
  `user_shoppergroups` varchar(30) DEFAULT NULL,
  `payment_currency_id` smallint DEFAULT NULL,
  `payment_currency_rate` decimal(12,6) NOT NULL DEFAULT '1.000000',
  `virtuemart_paymentmethod_id` int unsigned DEFAULT NULL,
  `virtuemart_shipmentmethod_id` int unsigned DEFAULT NULL,
  `delivery_date` varchar(200) DEFAULT NULL,
  `order_language` varchar(7) DEFAULT NULL,
  `ip_address` char(15) NOT NULL DEFAULT '',
  `STsameAsBT` tinyint(1) NOT NULL DEFAULT '0',
  `paid` decimal(15,5) NOT NULL DEFAULT '0.00000',
  `paid_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `o_hash` varchar(33) DEFAULT NULL,
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int NOT NULL DEFAULT '0',
  `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int NOT NULL DEFAULT '0',
  `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `locked_by` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`virtuemart_order_id`),
  KEY `virtuemart_user_id` (`virtuemart_user_id`),
  KEY `virtuemart_vendor_id` (`virtuemart_vendor_id`),
  KEY `order_number` (`order_number`),
  KEY `virtuemart_paymentmethod_id` (`virtuemart_paymentmethod_id`),
  KEY `virtuemart_shipmentmethod_id` (`virtuemart_shipmentmethod_id`),
  KEY `created_on` (`created_on`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Used to store all orders';

/*Data for the table `q4bx8_virtuemart_orders` */

/*Table structure for table `q4bx8_virtuemart_orderstates` */


CREATE TABLE `q4bx8_virtuemart_orderstates` (
  `virtuemart_orderstate_id` tinyint unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_vendor_id` int unsigned NOT NULL DEFAULT '1',
  `order_status_code` char(1) NOT NULL DEFAULT '',
  `order_status_name` varchar(64) DEFAULT NULL,
  `order_status_color` varchar(64) DEFAULT NULL,
  `order_status_description` varchar(12359) DEFAULT NULL,
  `order_stock_handle` char(1) NOT NULL DEFAULT 'A',
  `order_status_email_layout` varchar(128) DEFAULT '',
  `ordering` int NOT NULL DEFAULT '0',
  `published` tinyint(1) NOT NULL DEFAULT '1',
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int NOT NULL DEFAULT '0',
  `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int NOT NULL DEFAULT '0',
  `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `locked_by` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`virtuemart_orderstate_id`),
  KEY `ordering` (`ordering`),
  KEY `virtuemart_vendor_id` (`virtuemart_vendor_id`),
  KEY `published` (`published`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='All available order statuses';

/*Data for the table `q4bx8_virtuemart_orderstates` */

insert  into `q4bx8_virtuemart_orderstates`(`virtuemart_orderstate_id`,`virtuemart_vendor_id`,`order_status_code`,`order_status_name`,`order_status_color`,`order_status_description`,`order_stock_handle`,`order_status_email_layout`,`ordering`,`published`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) values 
(1,1,'P','COM_VIRTUEMART_ORDER_STATUS_PENDING',NULL,'','R','',1,1,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0),
(2,1,'U','COM_VIRTUEMART_ORDER_STATUS_CONFIRMED_BY_SHOPPER',NULL,'','R','',2,1,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0),
(3,1,'C','COM_VIRTUEMART_ORDER_STATUS_CONFIRMED',NULL,'','R','',3,1,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0),
(4,1,'X','COM_VIRTUEMART_ORDER_STATUS_CANCELLED',NULL,'','A','',4,1,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0),
(5,1,'R','COM_VIRTUEMART_ORDER_STATUS_REFUNDED',NULL,'','A','',5,1,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0),
(6,1,'S','COM_VIRTUEMART_ORDER_STATUS_SHIPPED',NULL,'','O','',6,1,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0),
(7,1,'F','COM_VIRTUEMART_ORDER_STATUS_COMPLETED',NULL,'','R','',7,1,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0),
(8,1,'D','COM_VIRTUEMART_ORDER_STATUS_DENIED',NULL,'','A','',8,1,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0);

/*Table structure for table `q4bx8_virtuemart_paymentmethod_shoppergroups` */


CREATE TABLE `q4bx8_virtuemart_paymentmethod_shoppergroups` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_paymentmethod_id` int unsigned NOT NULL DEFAULT '0',
  `virtuemart_shoppergroup_id` int unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `virtuemart_paymentmethod_id` (`virtuemart_paymentmethod_id`,`virtuemart_shoppergroup_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='xref table for paymentmethods to shoppergroup';

/*Data for the table `q4bx8_virtuemart_paymentmethod_shoppergroups` */

/*Table structure for table `q4bx8_virtuemart_paymentmethods` */


CREATE TABLE `q4bx8_virtuemart_paymentmethods` (
  `virtuemart_paymentmethod_id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_vendor_id` int unsigned NOT NULL DEFAULT '1',
  `payment_jplugin_id` int NOT NULL DEFAULT '0',
  `payment_element` varchar(50) NOT NULL DEFAULT '',
  `payment_params` text,
  `currency_id` int unsigned DEFAULT NULL,
  `shared` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'valide for all vendors?',
  `ordering` int NOT NULL DEFAULT '0',
  `published` tinyint(1) NOT NULL DEFAULT '1',
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int NOT NULL DEFAULT '0',
  `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int NOT NULL DEFAULT '0',
  `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `locked_by` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`virtuemart_paymentmethod_id`),
  KEY `payment_jplugin_id` (`payment_jplugin_id`),
  KEY `virtuemart_vendor_id` (`virtuemart_vendor_id`),
  KEY `payment_element` (`payment_element`,`virtuemart_vendor_id`),
  KEY `ordering` (`ordering`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='The payment methods of your store';

/*Data for the table `q4bx8_virtuemart_paymentmethods` */

/*Table structure for table `q4bx8_virtuemart_paymentmethods_nb_no` */


CREATE TABLE `q4bx8_virtuemart_paymentmethods_nb_no` (
  `virtuemart_paymentmethod_id` int unsigned NOT NULL,
  `payment_name` varchar(180) NOT NULL DEFAULT '',
  `payment_desc` varchar(19000) NOT NULL DEFAULT '',
  `slug` varchar(192) NOT NULL DEFAULT '',
  PRIMARY KEY (`virtuemart_paymentmethod_id`),
  UNIQUE KEY `slug` (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

/*Data for the table `q4bx8_virtuemart_paymentmethods_nb_no` */

/*Table structure for table `q4bx8_virtuemart_product_categories` */


CREATE TABLE `q4bx8_virtuemart_product_categories` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_product_id` int unsigned NOT NULL DEFAULT '0',
  `virtuemart_category_id` int unsigned NOT NULL DEFAULT '0',
  `ordering` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `virtuemart_product_id` (`virtuemart_product_id`,`virtuemart_category_id`),
  KEY `ordering` (`ordering`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Maps Products to Categories';

/*Data for the table `q4bx8_virtuemart_product_categories` */

/*Table structure for table `q4bx8_virtuemart_product_customfields` */


CREATE TABLE `q4bx8_virtuemart_product_customfields` (
  `virtuemart_customfield_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'FIELD ID',
  `virtuemart_product_id` int NOT NULL DEFAULT '0',
  `virtuemart_custom_id` int NOT NULL DEFAULT '1' COMMENT 'CUSTOM GROUP ID',
  `customfield_value` varchar(2500) DEFAULT NULL COMMENT 'field value',
  `customfield_price` decimal(15,6) DEFAULT NULL COMMENT 'price',
  `disabler` int unsigned NOT NULL DEFAULT '0',
  `override` int unsigned NOT NULL DEFAULT '0',
  `noninheritable` int unsigned NOT NULL DEFAULT '0',
  `customfield_params` text COMMENT 'Param for Plugins',
  `product_sku` varchar(64) DEFAULT NULL,
  `product_gtin` varchar(64) DEFAULT NULL,
  `product_mpn` varchar(64) DEFAULT NULL,
  `published` tinyint(1) NOT NULL DEFAULT '1',
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int unsigned NOT NULL DEFAULT '0',
  `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int unsigned NOT NULL DEFAULT '0',
  `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `locked_by` int unsigned NOT NULL DEFAULT '0',
  `ordering` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`virtuemart_customfield_id`),
  UNIQUE KEY `unique_custf_prd_value` (`virtuemart_customfield_id`,`virtuemart_product_id`,`virtuemart_custom_id`,`customfield_value`(50)),
  KEY `unique_cust_prd_value` (`virtuemart_custom_id`,`virtuemart_product_id`,`customfield_value`(50)),
  KEY `customfield_value` (`customfield_value`(50)),
  KEY `virtuemart_product_id` (`virtuemart_product_id`,`ordering`),
  KEY `virtuemart_custom_id` (`virtuemart_custom_id`),
  KEY `published` (`published`),
  KEY `ordering` (`ordering`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='custom fields';

/*Data for the table `q4bx8_virtuemart_product_customfields` */

/*Table structure for table `q4bx8_virtuemart_product_manufacturers` */


CREATE TABLE `q4bx8_virtuemart_product_manufacturers` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_product_id` int DEFAULT NULL,
  `virtuemart_manufacturer_id` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `virtuemart_product_id` (`virtuemart_product_id`,`virtuemart_manufacturer_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Maps a product to a manufacturer';

/*Data for the table `q4bx8_virtuemart_product_manufacturers` */

/*Table structure for table `q4bx8_virtuemart_product_medias` */


CREATE TABLE `q4bx8_virtuemart_product_medias` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_product_id` int unsigned NOT NULL DEFAULT '0',
  `virtuemart_media_id` int unsigned NOT NULL DEFAULT '0',
  `ordering` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `virtuemart_product_id` (`virtuemart_product_id`,`virtuemart_media_id`),
  KEY `ordering` (`virtuemart_product_id`,`ordering`),
  KEY `virtuemart_media_id` (`virtuemart_media_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*Data for the table `q4bx8_virtuemart_product_medias` */

/*Table structure for table `q4bx8_virtuemart_product_prices` */


CREATE TABLE `q4bx8_virtuemart_product_prices` (
  `virtuemart_product_price_id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_product_id` int unsigned NOT NULL DEFAULT '0',
  `virtuemart_shoppergroup_id` int unsigned NOT NULL DEFAULT '0',
  `product_price` decimal(15,6) DEFAULT NULL,
  `override` tinyint(1) DEFAULT NULL,
  `product_override_price` decimal(15,5) DEFAULT NULL,
  `product_tax_id` int DEFAULT NULL,
  `product_discount_id` int DEFAULT NULL,
  `product_currency` smallint DEFAULT NULL,
  `product_price_publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `product_price_publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `price_quantity_start` int unsigned NOT NULL DEFAULT '0',
  `price_quantity_end` int unsigned NOT NULL DEFAULT '0',
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int NOT NULL DEFAULT '0',
  `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int NOT NULL DEFAULT '0',
  `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `locked_by` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`virtuemart_product_price_id`),
  KEY `virtuemart_product_id` (`virtuemart_product_id`),
  KEY `product_price` (`product_price`),
  KEY `virtuemart_shoppergroup_id` (`virtuemart_shoppergroup_id`),
  KEY `product_price_publish_up` (`product_price_publish_up`),
  KEY `product_price_publish_down` (`product_price_publish_down`),
  KEY `price_quantity_start` (`price_quantity_start`),
  KEY `price_quantity_end` (`price_quantity_end`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Holds price records for a product';

/*Data for the table `q4bx8_virtuemart_product_prices` */

/*Table structure for table `q4bx8_virtuemart_product_shoppergroups` */


CREATE TABLE `q4bx8_virtuemart_product_shoppergroups` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_product_id` int unsigned NOT NULL DEFAULT '0',
  `virtuemart_shoppergroup_id` int unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `virtuemart_product_id` (`virtuemart_product_id`,`virtuemart_shoppergroup_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Maps Products to Categories';

/*Data for the table `q4bx8_virtuemart_product_shoppergroups` */

/*Table structure for table `q4bx8_virtuemart_products` */


CREATE TABLE `q4bx8_virtuemart_products` (
  `virtuemart_product_id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_vendor_id` int unsigned NOT NULL DEFAULT '1',
  `product_parent_id` int unsigned NOT NULL DEFAULT '0',
  `product_sku` varchar(255) DEFAULT NULL,
  `product_gtin` varchar(64) DEFAULT NULL,
  `product_mpn` varchar(64) DEFAULT NULL,
  `product_weight` decimal(10,4) DEFAULT NULL,
  `product_weight_uom` varchar(7) DEFAULT NULL,
  `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(7) DEFAULT NULL,
  `product_url` varchar(255) DEFAULT NULL,
  `product_in_stock` int NOT NULL DEFAULT '0',
  `product_ordered` int NOT NULL DEFAULT '0',
  `product_stockhandle` varchar(24) NOT NULL DEFAULT '0',
  `low_stock_notification` int unsigned NOT NULL DEFAULT '0',
  `product_available_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `product_availability` varchar(32) DEFAULT NULL,
  `product_special` tinyint(1) NOT NULL DEFAULT '0',
  `product_discontinued` tinyint(1) NOT NULL DEFAULT '0',
  `product_sales` int NOT NULL DEFAULT '0',
  `product_unit` varchar(8) DEFAULT NULL,
  `product_packaging` decimal(8,4) unsigned DEFAULT NULL,
  `product_params` varchar(255) NOT NULL,
  `product_canon_category_id` int DEFAULT NULL,
  `hits` int unsigned DEFAULT NULL,
  `intnotes` text,
  `metarobot` varchar(400) DEFAULT NULL,
  `metaauthor` varchar(400) DEFAULT NULL,
  `layout` varchar(16) DEFAULT NULL,
  `published` tinyint(1) NOT NULL DEFAULT '0',
  `pordering` int unsigned NOT NULL DEFAULT '0',
  `has_categories` tinyint(1) DEFAULT NULL,
  `has_manufacturers` tinyint(1) DEFAULT NULL,
  `has_medias` tinyint(1) DEFAULT NULL,
  `has_prices` tinyint(1) DEFAULT NULL,
  `has_shoppergroups` tinyint(1) DEFAULT NULL,
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int NOT NULL DEFAULT '0',
  `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int NOT NULL DEFAULT '0',
  `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `locked_by` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`virtuemart_product_id`),
  KEY `virtuemart_vendor_id` (`virtuemart_vendor_id`),
  KEY `product_parent_id` (`product_parent_id`),
  KEY `product_special` (`product_special`),
  KEY `product_discontinued` (`product_discontinued`),
  KEY `product_in_stock` (`product_in_stock`),
  KEY `product_ordered` (`product_ordered`),
  KEY `product_sku` (`product_sku`(250)),
  KEY `published` (`published`),
  KEY `pordering` (`pordering`),
  KEY `created_on` (`created_on`),
  KEY `modified_on` (`modified_on`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='All products are stored here.';

/*Data for the table `q4bx8_virtuemart_products` */

/*Table structure for table `q4bx8_virtuemart_products_nb_no` */


CREATE TABLE `q4bx8_virtuemart_products_nb_no` (
  `virtuemart_product_id` int unsigned NOT NULL,
  `product_s_desc` varchar(2000) NOT NULL DEFAULT '',
  `product_desc` text NOT NULL,
  `product_name` varchar(180) NOT NULL DEFAULT '',
  `metadesc` varchar(400) NOT NULL DEFAULT '',
  `metakey` varchar(400) NOT NULL DEFAULT '',
  `customtitle` varchar(255) NOT NULL DEFAULT '',
  `slug` varchar(192) NOT NULL DEFAULT '',
  PRIMARY KEY (`virtuemart_product_id`),
  UNIQUE KEY `slug` (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

/*Data for the table `q4bx8_virtuemart_products_nb_no` */

/*Table structure for table `q4bx8_virtuemart_rating_reviews` */


CREATE TABLE `q4bx8_virtuemart_rating_reviews` (
  `virtuemart_rating_review_id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_rating_vote_id` int unsigned DEFAULT NULL,
  `virtuemart_product_id` int unsigned NOT NULL DEFAULT '0',
  `comment` varchar(15359) DEFAULT NULL,
  `review_ok` tinyint(1) NOT NULL DEFAULT '0',
  `review_rates` int unsigned NOT NULL DEFAULT '0',
  `review_ratingcount` int unsigned NOT NULL DEFAULT '0',
  `review_rating` decimal(10,2) NOT NULL DEFAULT '0.00',
  `review_language` varchar(10) DEFAULT NULL,
  `review_editable` tinyint(1) NOT NULL DEFAULT '1',
  `lastip` char(50) NOT NULL DEFAULT '0',
  `published` tinyint(1) NOT NULL DEFAULT '1',
  `customer` varchar(128) NOT NULL DEFAULT '',
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int NOT NULL DEFAULT '0',
  `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int NOT NULL DEFAULT '0',
  `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `locked_by` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`virtuemart_rating_review_id`),
  KEY `virtuemart_rating_vote_id` (`virtuemart_rating_vote_id`),
  KEY `virtuemart_product_id` (`virtuemart_product_id`,`created_by`),
  KEY `created_on` (`created_on`),
  KEY `created_by` (`created_by`),
  KEY `published` (`published`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*Data for the table `q4bx8_virtuemart_rating_reviews` */

/*Table structure for table `q4bx8_virtuemart_rating_votes` */


CREATE TABLE `q4bx8_virtuemart_rating_votes` (
  `virtuemart_rating_vote_id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_product_id` int unsigned NOT NULL DEFAULT '0',
  `vote` int NOT NULL DEFAULT '0',
  `lastip` char(50) NOT NULL DEFAULT '0',
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int NOT NULL DEFAULT '0',
  `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`virtuemart_rating_vote_id`),
  KEY `virtuemart_product_id` (`virtuemart_product_id`,`created_by`),
  KEY `created_by` (`created_by`),
  KEY `created_on` (`created_on`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Stores all ratings for a product';

/*Data for the table `q4bx8_virtuemart_rating_votes` */

/*Table structure for table `q4bx8_virtuemart_ratings` */


CREATE TABLE `q4bx8_virtuemart_ratings` (
  `virtuemart_rating_id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_product_id` int unsigned NOT NULL DEFAULT '0',
  `rates` int NOT NULL DEFAULT '0',
  `ratingcount` int unsigned NOT NULL DEFAULT '0',
  `rating` decimal(10,1) NOT NULL DEFAULT '0.0',
  `published` tinyint(1) NOT NULL DEFAULT '1',
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int NOT NULL DEFAULT '0',
  `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`virtuemart_rating_id`),
  UNIQUE KEY `virtuemart_product_id` (`virtuemart_product_id`,`virtuemart_rating_id`),
  KEY `published` (`published`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Stores all ratings for a product';

/*Data for the table `q4bx8_virtuemart_ratings` */

/*Table structure for table `q4bx8_virtuemart_shipmentmethod_shoppergroups` */


CREATE TABLE `q4bx8_virtuemart_shipmentmethod_shoppergroups` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_shipmentmethod_id` int unsigned NOT NULL DEFAULT '0',
  `virtuemart_shoppergroup_id` int unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `virtuemart_shipmentmethod_id` (`virtuemart_shipmentmethod_id`,`virtuemart_shoppergroup_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='xref table for shipment to shoppergroup';

/*Data for the table `q4bx8_virtuemart_shipmentmethod_shoppergroups` */

/*Table structure for table `q4bx8_virtuemart_shipmentmethods` */


CREATE TABLE `q4bx8_virtuemart_shipmentmethods` (
  `virtuemart_shipmentmethod_id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_vendor_id` int unsigned NOT NULL DEFAULT '1',
  `shipment_jplugin_id` int NOT NULL DEFAULT '0',
  `shipment_element` varchar(50) NOT NULL DEFAULT '',
  `shipment_params` text,
  `currency_id` int unsigned DEFAULT NULL,
  `ordering` int NOT NULL DEFAULT '0',
  `shared` tinyint(1) NOT NULL DEFAULT '0',
  `published` tinyint(1) NOT NULL DEFAULT '1',
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int NOT NULL DEFAULT '0',
  `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int NOT NULL DEFAULT '0',
  `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `locked_by` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`virtuemart_shipmentmethod_id`),
  KEY `shipment_jplugin_id` (`shipment_jplugin_id`),
  KEY `shipment_element` (`shipment_element`,`virtuemart_vendor_id`),
  KEY `ordering` (`ordering`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Shipment created from the shipment plugins';

/*Data for the table `q4bx8_virtuemart_shipmentmethods` */

/*Table structure for table `q4bx8_virtuemart_shipmentmethods_nb_no` */


CREATE TABLE `q4bx8_virtuemart_shipmentmethods_nb_no` (
  `virtuemart_shipmentmethod_id` int unsigned NOT NULL,
  `shipment_name` varchar(180) NOT NULL DEFAULT '',
  `shipment_desc` varchar(19000) NOT NULL DEFAULT '',
  `slug` varchar(192) NOT NULL DEFAULT '',
  PRIMARY KEY (`virtuemart_shipmentmethod_id`),
  UNIQUE KEY `slug` (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

/*Data for the table `q4bx8_virtuemart_shipmentmethods_nb_no` */

/*Table structure for table `q4bx8_virtuemart_shoppergroups` */


CREATE TABLE `q4bx8_virtuemart_shoppergroups` (
  `virtuemart_shoppergroup_id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_vendor_id` int unsigned NOT NULL DEFAULT '1',
  `shopper_group_name` varchar(128) DEFAULT NULL,
  `shopper_group_desc` varchar(255) DEFAULT NULL,
  `custom_price_display` tinyint(1) NOT NULL DEFAULT '0',
  `price_display` blob NOT NULL,
  `default` tinyint(1) NOT NULL DEFAULT '0',
  `sgrp_additional` tinyint(1) NOT NULL DEFAULT '0',
  `ordering` int NOT NULL DEFAULT '0',
  `shared` tinyint(1) NOT NULL DEFAULT '0',
  `published` tinyint(1) NOT NULL DEFAULT '1',
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int NOT NULL DEFAULT '0',
  `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int NOT NULL DEFAULT '0',
  `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `locked_by` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`virtuemart_shoppergroup_id`),
  KEY `shopper_group_name` (`shopper_group_name`),
  KEY `ordering` (`ordering`),
  KEY `shared` (`shared`),
  KEY `published` (`published`),
  KEY `virtuemart_vendor_id` (`virtuemart_vendor_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Shopper Groups that users can be assigned to';

/*Data for the table `q4bx8_virtuemart_shoppergroups` */

insert  into `q4bx8_virtuemart_shoppergroups`(`virtuemart_shoppergroup_id`,`virtuemart_vendor_id`,`shopper_group_name`,`shopper_group_desc`,`custom_price_display`,`price_display`,`default`,`sgrp_additional`,`ordering`,`shared`,`published`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) values 
(1,1,'-default-','This is the default shopper group.',0,'',1,0,0,1,1,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0),
(2,1,'-anonymous-','Shopper group for anonymous shoppers',0,'',2,0,0,1,1,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0);

/*Table structure for table `q4bx8_virtuemart_states` */


CREATE TABLE `q4bx8_virtuemart_states` (
  `virtuemart_state_id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_vendor_id` int unsigned NOT NULL DEFAULT '1',
  `virtuemart_country_id` int unsigned NOT NULL DEFAULT '0',
  `virtuemart_worldzone_id` int unsigned NOT NULL DEFAULT '0',
  `state_name` varchar(64) DEFAULT NULL,
  `state_3_code` char(3) DEFAULT NULL,
  `state_2_code` char(2) DEFAULT NULL,
  `ordering` int NOT NULL DEFAULT '0',
  `shared` tinyint(1) NOT NULL DEFAULT '1',
  `published` tinyint(1) NOT NULL DEFAULT '1',
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int NOT NULL DEFAULT '0',
  `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int NOT NULL DEFAULT '0',
  `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `locked_by` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`virtuemart_state_id`),
  UNIQUE KEY `state_3_code` (`virtuemart_vendor_id`,`virtuemart_country_id`,`state_3_code`),
  UNIQUE KEY `state_2_code` (`virtuemart_vendor_id`,`virtuemart_country_id`,`state_2_code`),
  KEY `virtuemart_vendor_id` (`virtuemart_vendor_id`),
  KEY `virtuemart_country_id` (`virtuemart_country_id`),
  KEY `ordering` (`ordering`),
  KEY `shared` (`shared`),
  KEY `published` (`published`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='States that are assigned to a country';

/*Data for the table `q4bx8_virtuemart_states` */

/*Table structure for table `q4bx8_virtuemart_userfield_values` */


CREATE TABLE `q4bx8_virtuemart_userfield_values` (
  `virtuemart_userfield_value_id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_userfield_id` int unsigned NOT NULL DEFAULT '0',
  `fieldtitle` varchar(255) NOT NULL DEFAULT '',
  `fieldvalue` varchar(255) NOT NULL DEFAULT '',
  `sys` tinyint NOT NULL DEFAULT '0',
  `ordering` int NOT NULL DEFAULT '0',
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int NOT NULL DEFAULT '0',
  `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int NOT NULL DEFAULT '0',
  `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `locked_by` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`virtuemart_userfield_value_id`),
  KEY `virtuemart_userfield_id` (`virtuemart_userfield_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Holds the different values for dropdown and radio lists';

/*Data for the table `q4bx8_virtuemart_userfield_values` */

/*Table structure for table `q4bx8_virtuemart_userfields` */


CREATE TABLE `q4bx8_virtuemart_userfields` (
  `virtuemart_userfield_id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_vendor_id` int unsigned NOT NULL DEFAULT '1',
  `userfield_jplugin_id` int NOT NULL DEFAULT '0',
  `name` varchar(250) NOT NULL DEFAULT '',
  `title` varchar(255) NOT NULL DEFAULT '',
  `description` varchar(2048) DEFAULT NULL,
  `type` varchar(70) NOT NULL DEFAULT '',
  `maxlength` int DEFAULT NULL,
  `size` int DEFAULT NULL,
  `required` tinyint NOT NULL DEFAULT '0',
  `cols` int DEFAULT NULL,
  `rows` int DEFAULT NULL,
  `value` varchar(255) DEFAULT NULL,
  `default` varchar(255) DEFAULT NULL,
  `placeholder` varchar(255) DEFAULT NULL,
  `registration` tinyint(1) NOT NULL DEFAULT '0',
  `shipment` tinyint(1) NOT NULL DEFAULT '0',
  `account` tinyint(1) NOT NULL DEFAULT '1',
  `cart` tinyint(1) NOT NULL DEFAULT '0',
  `readonly` tinyint(1) NOT NULL DEFAULT '0',
  `calculated` tinyint(1) NOT NULL DEFAULT '0',
  `sys` tinyint NOT NULL DEFAULT '0',
  `userfield_params` text,
  `ordering` int NOT NULL DEFAULT '0',
  `shared` tinyint(1) NOT NULL DEFAULT '0',
  `published` tinyint(1) NOT NULL DEFAULT '1',
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int NOT NULL DEFAULT '0',
  `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int NOT NULL DEFAULT '0',
  `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `locked_by` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`virtuemart_userfield_id`),
  UNIQUE KEY `name` (`name`),
  KEY `virtuemart_vendor_id` (`virtuemart_vendor_id`),
  KEY `ordering` (`ordering`),
  KEY `shared` (`shared`),
  KEY `published` (`published`),
  KEY `account` (`account`),
  KEY `shipment` (`shipment`),
  KEY `cart` (`cart`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Holds the fields for the user information';

/*Data for the table `q4bx8_virtuemart_userfields` */

/*Table structure for table `q4bx8_virtuemart_userinfos` */


CREATE TABLE `q4bx8_virtuemart_userinfos` (
  `virtuemart_userinfo_id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_user_id` int unsigned NOT NULL DEFAULT '0',
  `address_type` char(2) NOT NULL DEFAULT '',
  `address_type_name` varchar(32) NOT NULL DEFAULT '',
  `company` varchar(64) DEFAULT NULL,
  `title` varchar(32) DEFAULT NULL,
  `last_name` varchar(96) DEFAULT NULL,
  `first_name` varchar(96) DEFAULT NULL,
  `middle_name` varchar(96) DEFAULT NULL,
  `phone_1` varchar(32) DEFAULT NULL,
  `phone_2` varchar(32) DEFAULT NULL,
  `fax` varchar(32) DEFAULT NULL,
  `address_1` varchar(96) NOT NULL DEFAULT '',
  `address_2` varchar(64) DEFAULT NULL,
  `city` varchar(96) NOT NULL DEFAULT '',
  `virtuemart_state_id` smallint unsigned NOT NULL DEFAULT '0',
  `virtuemart_country_id` smallint unsigned NOT NULL DEFAULT '0',
  `zip` varchar(32) NOT NULL DEFAULT '',
  `agreed` tinyint(1) NOT NULL DEFAULT '0',
  `tos` tinyint(1) NOT NULL DEFAULT '0',
  `customer_note` varchar(5000) NOT NULL DEFAULT '',
  `created_on` datetime DEFAULT NULL,
  `created_by` int NOT NULL DEFAULT '0',
  `modified_on` datetime DEFAULT NULL,
  `modified_by` int NOT NULL DEFAULT '0',
  `locked_on` datetime DEFAULT NULL,
  `locked_by` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`virtuemart_userinfo_id`),
  KEY `i_virtuemart_user_id` (`virtuemart_userinfo_id`,`virtuemart_user_id`),
  KEY `virtuemart_user_id` (`virtuemart_user_id`,`address_type`),
  KEY `address_type` (`address_type`),
  KEY `address_type_name` (`address_type_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Customer Information, BT = BillTo and ST = ShipTo';

/*Data for the table `q4bx8_virtuemart_userinfos` */

/*Table structure for table `q4bx8_virtuemart_vendor_medias` */


CREATE TABLE `q4bx8_virtuemart_vendor_medias` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_vendor_id` int unsigned NOT NULL DEFAULT '0',
  `virtuemart_media_id` int unsigned NOT NULL DEFAULT '0',
  `ordering` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `virtuemart_vendor_id` (`virtuemart_vendor_id`,`virtuemart_media_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*Data for the table `q4bx8_virtuemart_vendor_medias` */

/*Table structure for table `q4bx8_virtuemart_vendor_users` */


CREATE TABLE `q4bx8_virtuemart_vendor_users` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_vendor_user_id` int unsigned NOT NULL DEFAULT '0',
  `virtuemart_user_id` int unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `virtuemart_vendor_user_id` (`virtuemart_vendor_user_id`,`virtuemart_user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*Data for the table `q4bx8_virtuemart_vendor_users` */

/*Table structure for table `q4bx8_virtuemart_vendors` */


CREATE TABLE `q4bx8_virtuemart_vendors` (
  `virtuemart_vendor_id` int unsigned NOT NULL AUTO_INCREMENT,
  `vendor_name` varchar(64) DEFAULT NULL,
  `vendor_currency` int DEFAULT NULL,
  `vendor_accepted_currencies` varchar(1536) NOT NULL DEFAULT '',
  `vendor_params` varchar(14335) NOT NULL DEFAULT '',
  `metarobot` varchar(20) DEFAULT NULL,
  `metaauthor` varchar(64) DEFAULT NULL,
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int NOT NULL DEFAULT '0',
  `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int NOT NULL DEFAULT '0',
  `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `locked_by` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`virtuemart_vendor_id`),
  KEY `vendor_name` (`vendor_name`),
  KEY `vendor_currency` (`vendor_currency`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Vendors manage their products in your store';

/*Data for the table `q4bx8_virtuemart_vendors` */

/*Table structure for table `q4bx8_virtuemart_vendors_nb_no` */


CREATE TABLE `q4bx8_virtuemart_vendors_nb_no` (
  `virtuemart_vendor_id` int unsigned NOT NULL,
  `vendor_store_desc` text NOT NULL,
  `vendor_terms_of_service` mediumtext NOT NULL,
  `vendor_legal_info` text NOT NULL,
  `vendor_letter_css` text NOT NULL,
  `vendor_letter_header_html` varchar(8000) NOT NULL DEFAULT '<H1>{VM:VENDORNAME}</H1><P>{VM:VENDORADDRESS}</P>',
  `vendor_letter_footer_html` varchar(8000) NOT NULL DEFAULT '<P>{VM:VENDORLEGALINFO}<BR />PAGE {VM:PAGENUM}/{VM:PAGECOUNT}</P>',
  `vendor_store_name` varchar(180) NOT NULL DEFAULT '',
  `vendor_phone` varchar(26) NOT NULL DEFAULT '',
  `vendor_url` varchar(255) NOT NULL DEFAULT '',
  `metadesc` varchar(400) NOT NULL DEFAULT '',
  `metakey` varchar(400) NOT NULL DEFAULT '',
  `customtitle` varchar(255) NOT NULL DEFAULT '',
  `vendor_invoice_free1` varchar(255) NOT NULL DEFAULT '',
  `vendor_invoice_free2` varchar(255) NOT NULL DEFAULT '',
  `vendor_mail_free1` varchar(255) NOT NULL DEFAULT '',
  `vendor_mail_free2` varchar(255) NOT NULL DEFAULT '',
  `vendor_mail_css` varchar(255) NOT NULL DEFAULT '',
  `slug` varchar(192) NOT NULL DEFAULT '',
  PRIMARY KEY (`virtuemart_vendor_id`),
  UNIQUE KEY `slug` (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

/*Data for the table `q4bx8_virtuemart_vendors_nb_no` */

/*Table structure for table `q4bx8_virtuemart_vmuser_shoppergroups` */


CREATE TABLE `q4bx8_virtuemart_vmuser_shoppergroups` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_user_id` int unsigned NOT NULL DEFAULT '0',
  `virtuemart_shoppergroup_id` int unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `virtuemart_user_id` (`virtuemart_user_id`,`virtuemart_shoppergroup_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='xref table for users to shopper group';

/*Data for the table `q4bx8_virtuemart_vmuser_shoppergroups` */

/*Table structure for table `q4bx8_virtuemart_vmusers` */


CREATE TABLE `q4bx8_virtuemart_vmusers` (
  `virtuemart_user_id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_vendor_id` int unsigned NOT NULL DEFAULT '0',
  `user_is_vendor` tinyint(1) NOT NULL DEFAULT '0',
  `customer_number` varchar(32) DEFAULT NULL,
  `virtuemart_paymentmethod_id` int unsigned DEFAULT NULL,
  `virtuemart_shipmentmethod_id` int unsigned DEFAULT NULL,
  `agreed` tinyint(1) NOT NULL DEFAULT '0',
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int NOT NULL DEFAULT '0',
  `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int NOT NULL DEFAULT '0',
  `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `locked_by` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`virtuemart_user_id`),
  UNIQUE KEY `u_virtuemart_user_id` (`virtuemart_user_id`,`virtuemart_vendor_id`),
  KEY `virtuemart_vendor_id` (`virtuemart_vendor_id`),
  KEY `user_is_vendor` (`user_is_vendor`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Holds the unique user data';

/*Data for the table `q4bx8_virtuemart_vmusers` */

/*Table structure for table `q4bx8_virtuemart_waitingusers` */


CREATE TABLE `q4bx8_virtuemart_waitingusers` (
  `virtuemart_waitinguser_id` int unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_product_id` int unsigned NOT NULL DEFAULT '0',
  `virtuemart_user_id` int unsigned NOT NULL DEFAULT '0',
  `notify_email` varchar(150) NOT NULL DEFAULT '',
  `notified` tinyint(1) NOT NULL DEFAULT '0',
  `notify_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `ordering` int NOT NULL DEFAULT '0',
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int NOT NULL DEFAULT '0',
  `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int NOT NULL DEFAULT '0',
  `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `locked_by` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`virtuemart_waitinguser_id`),
  KEY `virtuemart_product_id` (`virtuemart_product_id`),
  KEY `notify_email` (`notify_email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Stores notifications, users waiting f. products out of stock';

/*Data for the table `q4bx8_virtuemart_waitingusers` */

/*Table structure for table `q4bx8_virtuemart_worldzones` */


CREATE TABLE `q4bx8_virtuemart_worldzones` (
  `virtuemart_worldzone_id` smallint unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_vendor_id` int unsigned DEFAULT NULL,
  `zone_name` varchar(255) DEFAULT NULL,
  `zone_cost` decimal(10,2) DEFAULT NULL,
  `zone_limit` decimal(10,2) DEFAULT NULL,
  `zone_description` varchar(14335) DEFAULT NULL,
  `zone_tax_rate` int unsigned NOT NULL DEFAULT '0',
  `ordering` int NOT NULL DEFAULT '0',
  `shared` tinyint(1) NOT NULL DEFAULT '0',
  `published` tinyint(1) NOT NULL DEFAULT '1',
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int NOT NULL DEFAULT '0',
  `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int NOT NULL DEFAULT '0',
  `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `locked_by` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`virtuemart_worldzone_id`),
  KEY `virtuemart_vendor_id` (`virtuemart_vendor_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='The Zones managed by the Zone Shipment Module';

/*Data for the table `q4bx8_virtuemart_worldzones` */

