-- Table structure for table `oxseohistory`
--

CREATE TABLE `oxseohistory` (
  `OXOBJECTID` char(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Object id',
  `OXIDENT` char(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Hashed url (md5)',
  `OXSHOPID` int(11) NOT NULL DEFAULT 1 COMMENT 'Shop id (oxshops)',
  `OXLANG` int(2) NOT NULL DEFAULT 0 COMMENT 'Language id',
  `OXHITS` bigint(20) NOT NULL DEFAULT 0 COMMENT 'Hits',
  `OXINSERT` timestamp NULL DEFAULT NULL COMMENT 'Creation time',
  `OXTIMESTAMP` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Timestamp',
  PRIMARY KEY (`OXIDENT`,`OXSHOPID`,`OXLANG`),
  KEY `search` (`OXOBJECTID`,`OXSHOPID`,`OXLANG`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Seo urls history. If url does not exists in oxseo, then checks here and redirects';

--
-- Dumping data for table `oxseohistory`
--


--
-- Table structure for table `oxseologs`
--

CREATE TABLE `oxseologs` (
  `OXSTDURL` text NOT NULL COMMENT 'Primary url, not seo encoded',
  `OXIDENT` char(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Hashed seo url',
  `OXSHOPID` int(11) NOT NULL DEFAULT 1 COMMENT 'Shop id (oxshops)',
  `OXLANG` int(11) NOT NULL COMMENT 'Language id',
  `OXTIMESTAMP` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Timestamp',
  PRIMARY KEY (`OXIDENT`,`OXSHOPID`,`OXLANG`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Seo logging. Logs bad requests';

--
-- Dumping data for table `oxseologs`
--


--
-- Table structure for table `oxshops`
--

CREATE TABLE `oxshops` (
  `OXID` int(11) NOT NULL DEFAULT 1 COMMENT 'Shop id',
  `OXPARENTID` int(11) NOT NULL DEFAULT 0 COMMENT 'Parent id',
  `OXACTIVE` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Active',
  `OXISINHERITED` int(11) NOT NULL DEFAULT 0 COMMENT 'Shop inherits all inheritable items (products, discounts etc) from it`s parent shop',
  `OXISMULTISHOP` int(11) NOT NULL DEFAULT 0 COMMENT 'Shop is multishop (loads all products from all shops)',
  `OXISSUPERSHOP` int(11) NOT NULL DEFAULT 0 COMMENT 'Shop is supershop (you can assign products to any shop)',
  `OXPRODUCTIVE` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Productive Mode (if 0, debug info displayed)',
  `OXDEFCURRENCY` varchar(32) NOT NULL DEFAULT '' COMMENT 'Default currency',
  `OXDEFLANGUAGE` int(11) NOT NULL DEFAULT 0 COMMENT 'Default language id',
  `OXNAME` varchar(255) NOT NULL DEFAULT '' COMMENT 'Shop name',
  `OXTITLEPREFIX` varchar(255) NOT NULL DEFAULT '' COMMENT 'Seo title prefix (multilanguage)',
  `OXTITLEPREFIX_1` varchar(255) NOT NULL DEFAULT '',
  `OXTITLEPREFIX_2` varchar(255) NOT NULL DEFAULT '',
  `OXTITLEPREFIX_3` varchar(255) NOT NULL DEFAULT '',
  `OXTITLESUFFIX` varchar(255) NOT NULL DEFAULT '' COMMENT 'Seo title suffix (multilanguage)',
  `OXTITLESUFFIX_1` varchar(255) NOT NULL DEFAULT '',
  `OXTITLESUFFIX_2` varchar(255) NOT NULL DEFAULT '',
  `OXTITLESUFFIX_3` varchar(255) NOT NULL DEFAULT '',
  `OXSTARTTITLE` varchar(255) NOT NULL DEFAULT '' COMMENT 'Start page title (multilanguage)',
  `OXSTARTTITLE_1` varchar(255) NOT NULL DEFAULT '',
  `OXSTARTTITLE_2` varchar(255) NOT NULL DEFAULT '',
  `OXSTARTTITLE_3` varchar(255) NOT NULL DEFAULT '',
  `OXINFOEMAIL` varchar(255) NOT NULL DEFAULT '' COMMENT 'Informational email address',
  `OXORDEREMAIL` varchar(255) NOT NULL DEFAULT '' COMMENT 'Order email address',
  `OXOWNEREMAIL` varchar(255) NOT NULL DEFAULT '' COMMENT 'Owner email address',
  `OXORDERSUBJECT` varchar(255) NOT NULL DEFAULT '' COMMENT 'Order email subject (multilanguage)',
  `OXREGISTERSUBJECT` varchar(255) NOT NULL DEFAULT '' COMMENT 'Registration email subject (multilanguage)',
  `OXFORGOTPWDSUBJECT` varchar(255) NOT NULL DEFAULT '' COMMENT 'Forgot password email subject (multilanguage)',
  `OXSENDEDNOWSUBJECT` varchar(255) NOT NULL DEFAULT '' COMMENT 'Order sent email subject (multilanguage)',
  `OXORDERSUBJECT_1` varchar(255) NOT NULL DEFAULT '',
  `OXREGISTERSUBJECT_1` varchar(255) NOT NULL DEFAULT '',
  `OXFORGOTPWDSUBJECT_1` varchar(255) NOT NULL DEFAULT '',
  `OXSENDEDNOWSUBJECT_1` varchar(255) NOT NULL DEFAULT '',
  `OXORDERSUBJECT_2` varchar(255) NOT NULL DEFAULT '',
  `OXREGISTERSUBJECT_2` varchar(255) NOT NULL DEFAULT '',
  `OXFORGOTPWDSUBJECT_2` varchar(255) NOT NULL DEFAULT '',
  `OXSENDEDNOWSUBJECT_2` varchar(255) NOT NULL DEFAULT '',
  `OXORDERSUBJECT_3` varchar(255) NOT NULL DEFAULT '',
  `OXREGISTERSUBJECT_3` varchar(255) NOT NULL DEFAULT '',
  `OXFORGOTPWDSUBJECT_3` varchar(255) NOT NULL DEFAULT '',
  `OXSENDEDNOWSUBJECT_3` varchar(255) NOT NULL DEFAULT '',
  `OXSMTP` varchar(255) NOT NULL DEFAULT '' COMMENT 'SMTP server',
  `OXSMTPUSER` varchar(128) NOT NULL DEFAULT '' COMMENT 'SMTP user',
  `OXSMTPPWD` varchar(128) NOT NULL DEFAULT '' COMMENT 'SMTP password',
  `OXCOMPANY` varchar(128) NOT NULL DEFAULT '' COMMENT 'Your company',
  `OXSTREET` varchar(255) NOT NULL DEFAULT '' COMMENT 'Street',
  `OXZIP` varchar(255) NOT NULL DEFAULT '' COMMENT 'ZIP code',
  `OXCITY` varchar(255) NOT NULL DEFAULT '' COMMENT 'City',
  `OXCOUNTRY` varchar(255) NOT NULL DEFAULT '' COMMENT 'Country',
  `OXBANKNAME` varchar(255) NOT NULL DEFAULT '' COMMENT 'Bank name',
  `OXBANKNUMBER` varchar(255) NOT NULL DEFAULT '' COMMENT 'Account Number',
  `OXBANKCODE` varchar(255) NOT NULL DEFAULT '' COMMENT 'Routing Number',
  `OXVATNUMBER` varchar(255) NOT NULL DEFAULT '' COMMENT 'Sales Tax ID',
  `OXTAXNUMBER` varchar(255) NOT NULL DEFAULT '' COMMENT 'Tax ID',
  `OXBICCODE` varchar(255) NOT NULL DEFAULT '' COMMENT 'Bank BIC',
  `OXIBANNUMBER` varchar(255) NOT NULL DEFAULT '' COMMENT 'Bank IBAN',
  `OXFNAME` varchar(255) NOT NULL DEFAULT '' COMMENT 'First name',
  `OXLNAME` varchar(255) NOT NULL DEFAULT '' COMMENT 'Last name',
  `OXTELEFON` varchar(255) NOT NULL DEFAULT '' COMMENT 'Phone number',
  `OXTELEFAX` varchar(255) NOT NULL DEFAULT '' COMMENT 'Fax number',
  `OXURL` varchar(255) NOT NULL DEFAULT '' COMMENT 'Shop url',
  `OXDEFCAT` char(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '' COMMENT 'Default category id',
  `OXHRBNR` varchar(64) NOT NULL DEFAULT '' COMMENT 'CBR',
  `OXCOURT` varchar(128) NOT NULL DEFAULT '' COMMENT 'District Court',
  `OXADBUTLERID` varchar(64) NOT NULL DEFAULT '' COMMENT 'Adbutler code (belboon.de) - deprecated',
  `OXAFFILINETID` varchar(64) NOT NULL DEFAULT '' COMMENT 'Affilinet code (webmasterplan.com) - deprecated',
  `OXSUPERCLICKSID` varchar(64) NOT NULL DEFAULT '' COMMENT 'Superclix code (superclix.de) - deprecated',
  `OXAFFILIWELTID` varchar(64) NOT NULL DEFAULT '' COMMENT 'Affiliwelt code (affiliwelt.net) - deprecated',
  `OXAFFILI24ID` varchar(64) NOT NULL DEFAULT '' COMMENT 'Affili24 code (affili24.com) - deprecated',
  `OXEDITION` char(2) NOT NULL COMMENT 'Shop Edition (CE,PE,EE (@deprecated since v6.0.0-RC.2 (2017-08-24))',
  `OXVERSION` char(16) NOT NULL COMMENT 'Shop Version (@deprecated since v6.0.0-RC.2 (2017-08-22))',
  `OXSEOACTIVE` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Seo active (multilanguage)',
  `OXSEOACTIVE_1` tinyint(1) NOT NULL DEFAULT 1,
  `OXSEOACTIVE_2` tinyint(1) NOT NULL DEFAULT 1,
  `OXSEOACTIVE_3` tinyint(1) NOT NULL DEFAULT 1,
  `OXTIMESTAMP` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Timestamp',
  `OXSERIAL` varchar(255) NOT NULL DEFAULT '' COMMENT 'Shop license number',
  PRIMARY KEY (`OXID`),
  KEY `OXACTIVE` (`OXACTIVE`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Shop config';

--
-- Dumping data for table `oxshops`
--

INSERT INTO `oxshops` VALUES
(1,0,1,0,0,1,0,'',0,'OXID eShop 6','OXID Surf- und Kiteshop','OXID Surf and Kite Shop','','','online kaufen','purchase online','','','Der Onlineshop für Wassersport und Sommerspass','Online Shop for water sports and summertime','','','info@myoxideshop.com','reply@myoxideshop.com','order@myoxideshop.com','Ihre Bestellung bei OXID eSales','Vielen Dank für Ihre Registrierung im OXID eShop','Ihr Passwort im OXID eShop','Ihre OXID eSales Bestellung wurde versandt','Your order at OXID eShop','Thank you for your registration at OXID eShop','Your OXID eShop password','Your OXID eSales Order has been shipped','','','','','','','','','','','','Your Company Name','2425 Maple Street','9041','Any City, CA','United States','Bank of America','1234567890','900 1234567','','','','','John','Doe','217-8918712','217-8918713','www.myoxideshop.com','','','','','','','','','EE','6.0.0',1,1,0,0,'2022-08-02 15:01:05','EF7FV-B9TA8-3R3SD-MZNU4-7NWM3-AN7AU');

--
-- Table structure for table `oxstates`
--

CREATE TABLE `oxstates` (
  `OXID` char(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '' COMMENT 'State id',
  `OXCOUNTRYID` char(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '' COMMENT 'Country id (oxcountry)',
  `OXTITLE` char(128) NOT NULL DEFAULT '' COMMENT 'Title (multilanguage)',
  `OXISOALPHA2` char(2) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '' COMMENT 'SEO short name',
  `OXTITLE_1` char(128) NOT NULL DEFAULT '',
  `OXTITLE_2` char(128) NOT NULL DEFAULT '',
  `OXTITLE_3` char(128) NOT NULL DEFAULT '',
  `OXTIMESTAMP` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Timestamp',
  PRIMARY KEY (`OXID`,`OXCOUNTRYID`),
  KEY `OXCOUNTRYID` (`OXCOUNTRYID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='US States list';

--
-- Dumping data for table `oxstates`
--

INSERT INTO `oxstates` VALUES
('AA','8f241f11096877ac0.98748826','Armed Forces Americas','AA','Armed Forces Americas','','','2016-07-19 14:38:19'),
('AB','8f241f11095649d18.02676059','Alberta','AB','Alberta','','','2016-07-19 14:38:19'),
('AE','8f241f11096877ac0.98748826','Armed Forces','AE','Armed Forces','','','2016-07-19 14:38:19'),
('AK','8f241f11096877ac0.98748826','Alaska','AK','Alaska','','','2016-07-19 14:38:19'),
('AL','8f241f11096877ac0.98748826','Alabama','AL','Alabama','','','2016-07-19 14:38:19'),
('AP','8f241f11096877ac0.98748826','Armed Forces Pacific','AP','Armed Forces Pacific','','','2016-07-19 14:38:19'),
('AR','8f241f11096877ac0.98748826','Arkansas','AR','Arkansas','','','2016-07-19 14:38:19'),
('AS','8f241f11096877ac0.98748826','Amerikanisch-Samoa','AS','American Samoa','','','2016-07-19 14:38:19'),
('AZ','8f241f11096877ac0.98748826','Arizona','AZ','Arizona','','','2016-07-19 14:38:19'),
('BC','8f241f11095649d18.02676059','Britisch-Kolumbien','BC','British Columbia','','','2016-07-19 14:38:19'),
('CA','8f241f11096877ac0.98748826','Kalifornien','CA','California','','','2016-07-19 14:38:19'),
('CO','8f241f11096877ac0.98748826','Colorado','CO','Colorado','','','2016-07-19 14:38:19'),
('CT','8f241f11096877ac0.98748826','Connecticut','CT','Connecticut','','','2016-07-19 14:38:19'),
('DC','8f241f11096877ac0.98748826','District of Columbia','DC','District of Columbia','','','2016-07-19 14:38:19'),
('DE','8f241f11096877ac0.98748826','Delaware','DE','Delaware','','','2016-07-19 14:38:19'),
('FL','8f241f11096877ac0.98748826','Florida','FL','Florida','','','2016-07-19 14:38:19'),
('FM','8f241f11096877ac0.98748826','Föderierten Staaten von Mikronesien','FM','Federated States of Micronesia','','','2016-07-19 14:38:19'),
('GA','8f241f11096877ac0.98748826','Georgia','GA','Georgia','','','2016-07-19 14:38:19'),
('GU','8f241f11096877ac0.98748826','Guam','GU','Guam','','','2016-07-19 14:38:19'),
('HI','8f241f11096877ac0.98748826','Hawaii','HI','Hawaii','','','2016-07-19 14:38:19'),
('IA','8f241f11096877ac0.98748826','Iowa','IA','Iowa','','','2016-07-19 14:38:19'),
('ID','8f241f11096877ac0.98748826','Idaho','ID','Idaho','','','2016-07-19 14:38:19'),
('IL','8f241f11096877ac0.98748826','Illinois','IL','Illinois','','','2016-07-19 14:38:19'),
('IN','8f241f11096877ac0.98748826','Indiana','IN','Indiana','','','2016-07-19 14:38:19'),
('KS','8f241f11096877ac0.98748826','Kansas','KS','Kansas','','','2016-07-19 14:38:19'),
('KY','8f241f11096877ac0.98748826','Kentucky','KY','Kentucky','','','2016-07-19 14:38:19'),
('LA','8f241f11096877ac0.98748826','Louisiana','LA','Louisiana','','','2016-07-19 14:38:19'),
('MA','8f241f11096877ac0.98748826','Massachusetts','MA','Massachusetts','','','2016-07-19 14:38:19'),
('MB','8f241f11095649d18.02676059','Manitoba','MB','Manitoba','','','2016-07-19 14:38:19'),
('MD','8f241f11096877ac0.98748826','Maryland','MD','Maryland','','','2016-07-19 14:38:19'),
('ME','8f241f11096877ac0.98748826','Maine','ME','Maine','','','2016-07-19 14:38:19'),
('MH','8f241f11096877ac0.98748826','Marshallinseln','MH','Marshall Islands','','','2016-07-19 14:38:19'),
('MI','8f241f11096877ac0.98748826','Michigan','MI','Michigan','','','2016-07-19 14:38:19'),
('MN','8f241f11096877ac0.98748826','Minnesota','MN','Minnesota','','','2016-07-19 14:38:19'),
('MO','8f241f11096877ac0.98748826','Missouri','MO','Missouri','','','2016-07-19 14:38:19'),
('MP','8f241f11096877ac0.98748826','Nördlichen Marianen','MP','Northern Mariana Islands','','','2016-07-19 14:38:19'),
('MS','8f241f11096877ac0.98748826','Mississippi','MS','Mississippi','','','2016-07-19 14:38:19'),
('MT','8f241f11096877ac0.98748826','Montana','MT','Montana','','','2016-07-19 14:38:19'),
('NB','8f241f11095649d18.02676059','Neubraunschweig','NB','New Brunswick','','','2016-07-19 14:38:19'),
('NC','8f241f11096877ac0.98748826','North Carolina','NC','North Carolina','','','2016-07-19 14:38:19'),
('ND','8f241f11096877ac0.98748826','North Dakota','ND','North Dakota','','','2016-07-19 14:38:19'),
('NE','8f241f11096877ac0.98748826','Nebraska','NE','Nebraska','','','2016-07-19 14:38:19'),
('NF','8f241f11095649d18.02676059','Neufundland und Labrador','NF','Newfoundland and Labrador','','','2016-07-19 14:38:19'),
('NH','8f241f11096877ac0.98748826','New Hampshire','NH','New Hampshire','','','2016-07-19 14:38:19'),
('NJ','8f241f11096877ac0.98748826','New Jersey','NJ','New Jersey','','','2016-07-19 14:38:19'),
('NM','8f241f11096877ac0.98748826','Neumexiko','NM','New Mexico','','','2016-07-19 14:38:19'),
('NS','8f241f11095649d18.02676059','Nova Scotia','NS','Nova Scotia','','','2016-07-19 14:38:19'),
('NT','8f241f11095649d18.02676059','Nordwest-Territorien','NT','Northwest Territories','','','2016-07-19 14:38:19'),
('NU','8f241f11095649d18.02676059','Nunavut','NU','Nunavut','','','2016-07-19 14:38:19'),
('NV','8f241f11096877ac0.98748826','Nevada','NV','Nevada','','','2016-07-19 14:38:19'),
('NY','8f241f11096877ac0.98748826','New York','NY','New York','','','2016-07-19 14:38:19'),
('OH','8f241f11096877ac0.98748826','Ohio','OH','Ohio','','','2016-07-19 14:38:19'),
('OK','8f241f11096877ac0.98748826','Oklahoma','OK','Oklahoma','','','2016-07-19 14:38:19'),
('ON','8f241f11095649d18.02676059','Ontario','ON','Ontario','','','2016-07-19 14:38:19'),
('OR','8f241f11096877ac0.98748826','Oregon','OR','Oregon','','','2016-07-19 14:38:19'),
('PA','8f241f11096877ac0.98748826','Pennsylvania','PA','Pennsylvania','','','2016-07-19 14:38:19'),
('PE','8f241f11095649d18.02676059','Prince Edward Island','PE','Prince Edward Island','','','2016-07-19 14:38:19'),
('PR','8f241f11096877ac0.98748826','Puerto Rico','PR','Puerto Rico','','','2016-07-19 14:38:19'),
('PW','8f241f11096877ac0.98748826','Palau','PW','Palau','','','2016-07-19 14:38:19'),
('QC','8f241f11095649d18.02676059','Quebec','QC','Quebec','','','2016-07-19 14:38:19'),
('RI','8f241f11096877ac0.98748826','Rhode Island','RI','Rhode Island','','','2016-07-19 14:38:19'),
('SC','8f241f11096877ac0.98748826','Südkarolina','SC','South Carolina','','','2016-07-19 14:38:19'),
('SD','8f241f11096877ac0.98748826','Süddakota','SD','South Dakota','','','2016-07-19 14:38:19'),
('SK','8f241f11095649d18.02676059','Saskatchewan','SK','Saskatchewan','','','2016-07-19 14:38:19'),
('TN','8f241f11096877ac0.98748826','Tennessee','TN','Tennessee','','','2016-07-19 14:38:19'),
('TX','8f241f11096877ac0.98748826','Texas','TX','Texas','','','2016-07-19 14:38:19'),
('UT','8f241f11096877ac0.98748826','Utah','UT','Utah','','','2016-07-19 14:38:19'),
('VA','8f241f11096877ac0.98748826','Virginia','VA','Virginia','','','2016-07-19 14:38:19'),
('VI','8f241f11096877ac0.98748826','Jungferninseln','VI','Virgin Islands','','','2016-07-19 14:38:19'),
('VT','8f241f11096877ac0.98748826','Vermont','VT','Vermont','','','2016-07-19 14:38:19'),
('WA','8f241f11096877ac0.98748826','Washington','WA','Washington','','','2016-07-19 14:38:19'),
('WI','8f241f11096877ac0.98748826','Wisconsin','WI','Wisconsin','','','2016-07-19 14:38:19'),
('WV','8f241f11096877ac0.98748826','West Virginia','WV','West Virginia','','','2016-07-19 14:38:19'),
('WY','8f241f11096877ac0.98748826','Wyoming','WY','Wyoming','','','2016-07-19 14:38:19'),
('YK','8f241f11095649d18.02676059','Yukon','YK','Yukon','','','2016-07-19 14:38:19');

--
-- Table structure for table `oxtplblocks`
--

CREATE TABLE `oxtplblocks` (
  `OXID` char(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Block id',
  `OXACTIVE` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Is active',
  `OXSHOPID` int(11) NOT NULL DEFAULT 1 COMMENT 'Shop id (oxshops)',
  `OXTHEME` char(128) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Shop theme id',
  `OXTEMPLATE` char(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Template filename (with rel. path), where block is located',
  `OXBLOCKNAME` char(128) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Block name',
  `OXPOS` int(11) NOT NULL COMMENT 'Sorting',
  `OXFILE` char(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Module template filename, where block replacement is located',
  `OXMODULE` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Module, which uses this template',
  `OXTIMESTAMP` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Timestamp',
  PRIMARY KEY (`OXID`),
  KEY `oxtheme` (`OXTHEME`),
  KEY `search` (`OXACTIVE`,`OXSHOPID`,`OXTEMPLATE`,`OXPOS`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Module template blocks';

--
-- Dumping data for table `oxtplblocks`
--


--
-- Table structure for table `oxuser`
--

CREATE TABLE `oxuser` (
  `OXID` char(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'User id',
  `OXACTIVE` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Is active',
  `OXRIGHTS` char(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '' COMMENT 'User rights: user, malladmin',
  `OXSHOPID` int(11) NOT NULL DEFAULT 1 COMMENT 'Shop id (oxshops)',
  `OXUSERNAME` varchar(255) NOT NULL DEFAULT '' COMMENT 'Username',
  `OXPASSWORD` varchar(128) NOT NULL DEFAULT '' COMMENT 'Hashed password',
  `OXPASSSALT` char(128) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Password salt',
  `OXCUSTNR` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Customer number',
  `OXUSTID` varchar(255) NOT NULL DEFAULT '' COMMENT 'VAT ID No.',
  `OXUSTIDSTATUS` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'User VAT id status: 1 - valid, 0 - invalid',
  `OXCOMPANY` varchar(255) NOT NULL DEFAULT '' COMMENT 'Company',
  `OXFNAME` varchar(255) NOT NULL DEFAULT '' COMMENT 'First name',
  `OXLNAME` varchar(255) NOT NULL DEFAULT '' COMMENT 'Last name',
  `OXSTREET` varchar(255) NOT NULL DEFAULT '' COMMENT 'Street',
  `OXSTREETNR` varchar(16) NOT NULL DEFAULT '' COMMENT 'House number',
  `OXADDINFO` varchar(255) NOT NULL DEFAULT '' COMMENT 'Additional info',
  `OXCITY` varchar(255) NOT NULL DEFAULT '' COMMENT 'City',
  `OXCOUNTRYID` char(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '' COMMENT 'Country id (oxcountry)',
  `OXSTATEID` varchar(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '' COMMENT 'State id (oxstates)',
  `OXZIP` varchar(16) NOT NULL DEFAULT '' COMMENT 'ZIP code',
  `OXFON` varchar(128) NOT NULL DEFAULT '' COMMENT 'Phone number',
  `OXFAX` varchar(128) NOT NULL DEFAULT '' COMMENT 'Fax number',
  `OXSAL` varchar(128) NOT NULL DEFAULT '' COMMENT 'User title (Mr/Mrs)',
  `OXBONI` int(11) NOT NULL DEFAULT 0 COMMENT 'Credit points',
  `OXCREATE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Creation time',
  `OXREGISTER` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Registration time',
  `OXPRIVFON` varchar(64) NOT NULL DEFAULT '' COMMENT 'Personal phone number',
  `OXMOBFON` varchar(64) NOT NULL DEFAULT '' COMMENT 'Mobile phone number',
  `OXBIRTHDATE` date NOT NULL DEFAULT '0000-00-00' COMMENT 'Birthday date',
  `OXURL` varchar(255) NOT NULL DEFAULT '' COMMENT 'Url',
  `OXWRONGLOGINS` int(11) NOT NULL DEFAULT 0 COMMENT 'Wrong logins count',
  `OXUPDATEKEY` varchar(32) NOT NULL DEFAULT '' COMMENT 'Update key',
  `OXUPDATEEXP` int(11) NOT NULL DEFAULT 0 COMMENT 'Update key expiration time',
  `OXPOINTS` double NOT NULL DEFAULT 0 COMMENT 'User points (for registration, invitation, etc)',
  `OXTIMESTAMP` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Timestamp',
  PRIMARY KEY (`OXID`),
  UNIQUE KEY `OXUSERNAME` (`OXUSERNAME`,`OXSHOPID`),
  KEY `OXPASSWORD` (`OXPASSWORD`),
  KEY `OXCUSTNR` (`OXCUSTNR`),
  KEY `OXACTIVE` (`OXACTIVE`),
  KEY `OXLNAME` (`OXLNAME`),
  KEY `OXUPDATEEXP` (`OXUPDATEEXP`),
  KEY `OXRIGHTS` (`OXRIGHTS`),
  KEY `OXSHOPID` (`OXSHOPID`,`OXUSERNAME`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 COMMENT='Shop administrators and users';

--
-- Dumping data for table `oxuser`
--

INSERT INTO `oxuser` VALUES
('36944b76cc9604c53.04579642',1,'malladmin',1,'management@management.com','b62aa2de00c0734673cfaab7d555e9a5','6D616E6167656D656E74',2,'',0,'','Max','Manager','Testalleee','11','','Freiburg','a7c40f631fc920687.20179984','','56565','0145654','','Herr',0,'2006-07-14 12:07:05','2006-07-14 12:07:05','','','1955-11-11','',0,'',0,0,'2016-07-19 14:38:26'),
('36944b76d203d4a35.41417835',1,'malladmin',1,'redaktion@redaktion.net','85c567807b567050bd7ba0662a9e1a4c','726564616B74696F6E',3,'',0,'','Lisa','Leser','Testalleee','33','','Freiburg','a7c40f631fc920687.20179984','','78787','','','Frau',0,'2006-07-14 12:08:32','2006-07-14 12:08:32','','','0000-00-00','',0,'',0,0,'2016-07-19 14:38:26'),
('36944b76d6e583fe2.12734046',1,'malladmin',1,'bild@house.com','c8cb226f7c4274a1adef263971d9baea','62696C64',4,'',0,'','Theresa','Bild','','','','Freiburg','a7c40f631fc920687.20179984','','98989','','','Frau',0,'2006-07-14 12:09:50','2006-07-14 12:09:50','','','0000-00-00','',0,'',0,0,'2016-07-19 14:38:26'),
('36944b76dae9ef333.88219217',1,'malladmin',1,'buchhaltung@buchhaltung.de','4f7f33dca14c0985bd5d71559fedc910','6275636868616C74756E67',5,'',0,'','Franz','Zahlendreher','','','','Freiburg','a7c40f631fc920687.20179984','','66565','','','Herr',0,'2006-07-14 12:10:54','2006-07-14 12:10:54','','','0000-00-00','',0,'',0,0,'2016-07-19 14:38:26'),
('36944b76e717de855.40215733',1,'malladmin',1,'produkt@shop.com','00e0eef84eed43f32600bd63cdfc305e','70726F64756B74',6,'',0,'','Peter','Produktmanager','','','','','a7c40f631fc920687.20179984','','','','','Herr',0,'2006-07-14 12:14:09','2006-07-14 12:14:09','','','0000-00-00','',0,'',0,0,'2016-07-19 14:38:26'),
('5f4ce945151120f52e45005943b1698a',1,'malladmin',1,'klaus.quintern@violution.net','5ea0751ac73136805044d87ebf083dccce6d2457628651b1c9560f08fff04d2b88e6f81234396fe8a9da604e11ab4dc18d904b4b4b05d02479361817d8705277','5f4ce945151120f52e45005943b1698a',8,'',0,'','','','','','','','','','','','','',0,'0000-00-00 00:00:00','0000-00-00 00:00:00','','','0000-00-00','',0,'',0,0,'2022-08-02 14:59:15'),
('e7af1c3b786fd02906ccd75698f4e6b9',1,'user',1,'info@oxid-esales.com','08e4b8e9f77d78d92fe17bf276783d5f','6537613339316161636532363266356338616564303034326163326235316266',7,'',1,'','Marc','Muster','Hauptstr.','13','','Freiburg','a7c40f631fc920687.20179984','','79098','','','MR',1000,'2011-02-01 08:41:25','2011-02-01 08:41:25','','','0000-00-00','',0,'',0,0,'2016-07-19 14:38:26');

--
-- Table structure for table `oxuserbasketitems`
--

CREATE TABLE `oxuserbasketitems` (
  `OXID` char(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Item id',
  `OXBASKETID` char(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '' COMMENT 'Basket id (oxuserbaskets)',
  `OXARTID` char(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '' COMMENT 'Article id (oxarticles)',
  `OXAMOUNT` char(32) NOT NULL DEFAULT '' COMMENT 'Amount',
  `OXSELLIST` varchar(255) NOT NULL DEFAULT '' COMMENT 'Selection list',
  `OXPERSPARAM` text NOT NULL COMMENT 'Serialized persistent parameters',
  `OXTIMESTAMP` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Timestamp',
  PRIMARY KEY (`OXID`),
  KEY `OXBASKETID` (`OXBASKETID`),
  KEY `OXARTID` (`OXARTID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='User basket items';

--
-- Dumping data for table `oxuserbasketitems`
--


--
-- Table structure for table `oxuserbaskets`
--

CREATE TABLE `oxuserbaskets` (
  `OXID` char(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Basket id',
  `OXUSERID` char(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '' COMMENT 'User id (oxuser)',
  `OXTITLE` varchar(255) NOT NULL DEFAULT '' COMMENT 'Basket title',
  `OXTIMESTAMP` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Timestamp',
  `OXPUBLIC` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Is public',
  `OXUPDATE` int(11) NOT NULL DEFAULT 0 COMMENT 'Update timestamp',
  PRIMARY KEY (`OXID`),
  KEY `OXUPDATE` (`OXUPDATE`),
  KEY `OXTITLE` (`OXTITLE`),
  KEY `OXUSERID` (`OXUSERID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Active User baskets';

--
-- Dumping data for table `oxuserbaskets`
--


--
-- Table structure for table `oxuserpayments`
--

CREATE TABLE `oxuserpayments` (
  `OXID` char(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Payment id',
  `OXUSERID` char(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '' COMMENT 'User id (oxusers)',
  `OXPAYMENTSID` char(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '' COMMENT 'Payment id (oxpayments)',
  `OXVALUE` text NOT NULL COMMENT 'DYN payment values array as string',
  `OXTIMESTAMP` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Timestamp',
  PRIMARY KEY (`OXID`),
  KEY `OXUSERID` (`OXUSERID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='User payments';

--
-- Dumping data for table `oxuserpayments`
--


--
-- Temporary table structure for view `oxv_oxactions`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxactions`*/;
/*!50001 CREATE VIEW `oxv_oxactions` AS SELECT
 1 AS `OXID`,
  1 AS `OXSHOPID`,
  1 AS `OXTYPE`,
  1 AS `OXTITLE`,
  1 AS `OXTITLE_1`,
  1 AS `OXTITLE_2`,
  1 AS `OXTITLE_3`,
  1 AS `OXLONGDESC`,
  1 AS `OXLONGDESC_1`,
  1 AS `OXLONGDESC_2`,
  1 AS `OXLONGDESC_3`,
  1 AS `OXACTIVE`,
  1 AS `OXACTIVEFROM`,
  1 AS `OXACTIVETO`,
  1 AS `OXPIC`,
  1 AS `OXPIC_1`,
  1 AS `OXPIC_2`,
  1 AS `OXPIC_3`,
  1 AS `OXLINK`,
  1 AS `OXLINK_1`,
  1 AS `OXLINK_2`,
  1 AS `OXLINK_3`,
  1 AS `OXSORT`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxactions_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxactions_de`*/;
/*!50001 CREATE VIEW `oxv_oxactions_de` AS SELECT
 1 AS `OXID`,
  1 AS `OXSHOPID`,
  1 AS `OXTYPE`,
  1 AS `OXTITLE`,
  1 AS `OXLONGDESC`,
  1 AS `OXACTIVE`,
  1 AS `OXACTIVEFROM`,
  1 AS `OXACTIVETO`,
  1 AS `OXPIC`,
  1 AS `OXLINK`,
  1 AS `OXSORT`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxactions_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxactions_en`*/;
/*!50001 CREATE VIEW `oxv_oxactions_en` AS SELECT
 1 AS `OXID`,
  1 AS `OXSHOPID`,
  1 AS `OXTYPE`,
  1 AS `OXTITLE`,
  1 AS `OXLONGDESC`,
  1 AS `OXACTIVE`,
  1 AS `OXACTIVEFROM`,
  1 AS `OXACTIVETO`,
  1 AS `OXPIC`,
  1 AS `OXLINK`,
  1 AS `OXSORT`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxartextends`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxartextends`*/;
/*!50001 CREATE VIEW `oxv_oxartextends` AS SELECT
 1 AS `OXID`,
  1 AS `OXLONGDESC`,
  1 AS `OXLONGDESC_1`,
  1 AS `OXLONGDESC_2`,
  1 AS `OXLONGDESC_3`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxartextends_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxartextends_de`*/;
/*!50001 CREATE VIEW `oxv_oxartextends_de` AS SELECT
 1 AS `OXID`,
  1 AS `OXLONGDESC`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxartextends_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxartextends_en`*/;
/*!50001 CREATE VIEW `oxv_oxartextends_en` AS SELECT
 1 AS `OXID`,
  1 AS `OXLONGDESC`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxarticles`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxarticles`*/;
/*!50001 CREATE VIEW `oxv_oxarticles` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXPARENTID`,
  1 AS `OXACTIVE`,
  1 AS `OXHIDDEN`,
  1 AS `OXACTIVEFROM`,
  1 AS `OXACTIVETO`,
  1 AS `OXARTNUM`,
  1 AS `OXEAN`,
  1 AS `OXDISTEAN`,
  1 AS `OXMPN`,
  1 AS `OXTITLE`,
  1 AS `OXSHORTDESC`,
  1 AS `OXPRICE`,
  1 AS `OXBLFIXEDPRICE`,
  1 AS `OXPRICEA`,
  1 AS `OXPRICEB`,
  1 AS `OXPRICEC`,
  1 AS `OXBPRICE`,
  1 AS `OXTPRICE`,
  1 AS `OXUNITNAME`,
  1 AS `OXUNITQUANTITY`,
  1 AS `OXEXTURL`,
  1 AS `OXURLDESC`,
  1 AS `OXURLIMG`,
  1 AS `OXVAT`,
  1 AS `OXTHUMB`,
  1 AS `OXICON`,
  1 AS `OXPIC1`,
  1 AS `OXPIC2`,
  1 AS `OXPIC3`,
  1 AS `OXPIC4`,
  1 AS `OXPIC5`,
  1 AS `OXPIC6`,
  1 AS `OXPIC7`,
  1 AS `OXPIC8`,
  1 AS `OXPIC9`,
  1 AS `OXPIC10`,
  1 AS `OXPIC11`,
  1 AS `OXPIC12`,
  1 AS `OXWEIGHT`,
  1 AS `OXSTOCK`,
  1 AS `OXSTOCKFLAG`,
  1 AS `OXSTOCKTEXT`,
  1 AS `OXNOSTOCKTEXT`,
  1 AS `OXDELIVERY`,
  1 AS `OXINSERT`,
  1 AS `OXTIMESTAMP`,
  1 AS `OXLENGTH`,
  1 AS `OXWIDTH`,
  1 AS `OXHEIGHT`,
  1 AS `OXFILE`,
  1 AS `OXSEARCHKEYS`,
  1 AS `OXTEMPLATE`,
  1 AS `OXQUESTIONEMAIL`,
  1 AS `OXISSEARCH`,
  1 AS `OXISCONFIGURABLE`,
  1 AS `OXVARNAME`,
  1 AS `OXVARSTOCK`,
  1 AS `OXVARCOUNT`,
  1 AS `OXVARSELECT`,
  1 AS `OXVARMINPRICE`,
  1 AS `OXVARMAXPRICE`,
  1 AS `OXVARNAME_1`,
  1 AS `OXVARSELECT_1`,
  1 AS `OXVARNAME_2`,
  1 AS `OXVARSELECT_2`,
  1 AS `OXVARNAME_3`,
  1 AS `OXVARSELECT_3`,
  1 AS `OXTITLE_1`,
  1 AS `OXSHORTDESC_1`,
  1 AS `OXURLDESC_1`,
  1 AS `OXSEARCHKEYS_1`,
  1 AS `OXTITLE_2`,
  1 AS `OXSHORTDESC_2`,
  1 AS `OXURLDESC_2`,
  1 AS `OXSEARCHKEYS_2`,
  1 AS `OXTITLE_3`,
  1 AS `OXSHORTDESC_3`,
  1 AS `OXURLDESC_3`,
  1 AS `OXSEARCHKEYS_3`,
  1 AS `OXBUNDLEID`,
  1 AS `OXFOLDER`,
  1 AS `OXSUBCLASS`,
  1 AS `OXSTOCKTEXT_1`,
  1 AS `OXSTOCKTEXT_2`,
  1 AS `OXSTOCKTEXT_3`,
  1 AS `OXNOSTOCKTEXT_1`,
  1 AS `OXNOSTOCKTEXT_2`,
  1 AS `OXNOSTOCKTEXT_3`,
  1 AS `OXSORT`,
  1 AS `OXSOLDAMOUNT`,
  1 AS `OXNONMATERIAL`,
  1 AS `OXFREESHIPPING`,
  1 AS `OXREMINDACTIVE`,
  1 AS `OXREMINDAMOUNT`,
  1 AS `OXAMITEMID`,
  1 AS `OXAMTASKID`,
  1 AS `OXVENDORID`,
  1 AS `OXMANUFACTURERID`,
  1 AS `OXSKIPDISCOUNTS`,
  1 AS `OXORDERINFO`,
  1 AS `OXPIXIEXPORT`,
  1 AS `OXPIXIEXPORTED`,
  1 AS `OXVPE`,
  1 AS `OXRATING`,
  1 AS `OXRATINGCNT`,
  1 AS `OXMINDELTIME`,
  1 AS `OXMAXDELTIME`,
  1 AS `OXDELTIMEUNIT`,
  1 AS `OXUPDATEPRICE`,
  1 AS `OXUPDATEPRICEA`,
  1 AS `OXUPDATEPRICEB`,
  1 AS `OXUPDATEPRICEC`,
  1 AS `OXUPDATEPRICETIME`,
  1 AS `OXISDOWNLOADABLE`,
  1 AS `OXSHOWCUSTOMAGREEMENT` */;

--
-- Temporary table structure for view `oxv_oxarticles_1`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxarticles_1`*/;
/*!50001 CREATE VIEW `oxv_oxarticles_1` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXPARENTID`,
  1 AS `OXACTIVE`,
  1 AS `OXHIDDEN`,
  1 AS `OXACTIVEFROM`,
  1 AS `OXACTIVETO`,
  1 AS `OXARTNUM`,
  1 AS `OXEAN`,
  1 AS `OXDISTEAN`,
  1 AS `OXMPN`,
  1 AS `OXTITLE`,
  1 AS `OXSHORTDESC`,
  1 AS `OXPRICE`,
  1 AS `OXBLFIXEDPRICE`,
  1 AS `OXPRICEA`,
  1 AS `OXPRICEB`,
  1 AS `OXPRICEC`,
  1 AS `OXBPRICE`,
  1 AS `OXTPRICE`,
  1 AS `OXUNITNAME`,
  1 AS `OXUNITQUANTITY`,
  1 AS `OXEXTURL`,
  1 AS `OXURLDESC`,
  1 AS `OXURLIMG`,
  1 AS `OXVAT`,
  1 AS `OXTHUMB`,
  1 AS `OXICON`,
  1 AS `OXPIC1`,
  1 AS `OXPIC2`,
  1 AS `OXPIC3`,
  1 AS `OXPIC4`,
  1 AS `OXPIC5`,
  1 AS `OXPIC6`,
  1 AS `OXPIC7`,
  1 AS `OXPIC8`,
  1 AS `OXPIC9`,
  1 AS `OXPIC10`,
  1 AS `OXPIC11`,
  1 AS `OXPIC12`,
  1 AS `OXWEIGHT`,
  1 AS `OXSTOCK`,
  1 AS `OXSTOCKFLAG`,
  1 AS `OXSTOCKTEXT`,
  1 AS `OXNOSTOCKTEXT`,
  1 AS `OXDELIVERY`,
  1 AS `OXINSERT`,
  1 AS `OXTIMESTAMP`,
  1 AS `OXLENGTH`,
  1 AS `OXWIDTH`,
  1 AS `OXHEIGHT`,
  1 AS `OXFILE`,
  1 AS `OXSEARCHKEYS`,
  1 AS `OXTEMPLATE`,
  1 AS `OXQUESTIONEMAIL`,
  1 AS `OXISSEARCH`,
  1 AS `OXISCONFIGURABLE`,
  1 AS `OXVARNAME`,
  1 AS `OXVARSTOCK`,
  1 AS `OXVARCOUNT`,
  1 AS `OXVARSELECT`,
  1 AS `OXVARMINPRICE`,
  1 AS `OXVARMAXPRICE`,
  1 AS `OXVARNAME_1`,
  1 AS `OXVARSELECT_1`,
  1 AS `OXVARNAME_2`,
  1 AS `OXVARSELECT_2`,
  1 AS `OXVARNAME_3`,
  1 AS `OXVARSELECT_3`,
  1 AS `OXTITLE_1`,
  1 AS `OXSHORTDESC_1`,
  1 AS `OXURLDESC_1`,
  1 AS `OXSEARCHKEYS_1`,
  1 AS `OXTITLE_2`,
  1 AS `OXSHORTDESC_2`,
  1 AS `OXURLDESC_2`,
  1 AS `OXSEARCHKEYS_2`,
  1 AS `OXTITLE_3`,
  1 AS `OXSHORTDESC_3`,
  1 AS `OXURLDESC_3`,
  1 AS `OXSEARCHKEYS_3`,
  1 AS `OXBUNDLEID`,
  1 AS `OXFOLDER`,
  1 AS `OXSUBCLASS`,
  1 AS `OXSTOCKTEXT_1`,
  1 AS `OXSTOCKTEXT_2`,
  1 AS `OXSTOCKTEXT_3`,
  1 AS `OXNOSTOCKTEXT_1`,
  1 AS `OXNOSTOCKTEXT_2`,
  1 AS `OXNOSTOCKTEXT_3`,
  1 AS `OXSORT`,
  1 AS `OXSOLDAMOUNT`,
  1 AS `OXNONMATERIAL`,
  1 AS `OXFREESHIPPING`,
  1 AS `OXREMINDACTIVE`,
  1 AS `OXREMINDAMOUNT`,
  1 AS `OXAMITEMID`,
  1 AS `OXAMTASKID`,
  1 AS `OXVENDORID`,
  1 AS `OXMANUFACTURERID`,
  1 AS `OXSKIPDISCOUNTS`,
  1 AS `OXORDERINFO`,
  1 AS `OXPIXIEXPORT`,
  1 AS `OXPIXIEXPORTED`,
  1 AS `OXVPE`,
  1 AS `OXRATING`,
  1 AS `OXRATINGCNT`,
  1 AS `OXMINDELTIME`,
  1 AS `OXMAXDELTIME`,
  1 AS `OXDELTIMEUNIT`,
  1 AS `OXUPDATEPRICE`,
  1 AS `OXUPDATEPRICEA`,
  1 AS `OXUPDATEPRICEB`,
  1 AS `OXUPDATEPRICEC`,
  1 AS `OXUPDATEPRICETIME`,
  1 AS `OXISDOWNLOADABLE`,
  1 AS `OXSHOWCUSTOMAGREEMENT` */;

--
-- Temporary table structure for view `oxv_oxarticles_1_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxarticles_1_de`*/;
/*!50001 CREATE VIEW `oxv_oxarticles_1_de` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXPARENTID`,
  1 AS `OXACTIVE`,
  1 AS `OXHIDDEN`,
  1 AS `OXACTIVEFROM`,
  1 AS `OXACTIVETO`,
  1 AS `OXARTNUM`,
  1 AS `OXEAN`,
  1 AS `OXDISTEAN`,
  1 AS `OXMPN`,
  1 AS `OXTITLE`,
  1 AS `OXSHORTDESC`,
  1 AS `OXPRICE`,
  1 AS `OXBLFIXEDPRICE`,
  1 AS `OXPRICEA`,
  1 AS `OXPRICEB`,
  1 AS `OXPRICEC`,
  1 AS `OXBPRICE`,
  1 AS `OXTPRICE`,
  1 AS `OXUNITNAME`,
  1 AS `OXUNITQUANTITY`,
  1 AS `OXEXTURL`,
  1 AS `OXURLDESC`,
  1 AS `OXURLIMG`,
  1 AS `OXVAT`,
  1 AS `OXTHUMB`,
  1 AS `OXICON`,
  1 AS `OXPIC1`,
  1 AS `OXPIC2`,
  1 AS `OXPIC3`,
  1 AS `OXPIC4`,
  1 AS `OXPIC5`,
  1 AS `OXPIC6`,
  1 AS `OXPIC7`,
  1 AS `OXPIC8`,
  1 AS `OXPIC9`,
  1 AS `OXPIC10`,
  1 AS `OXPIC11`,
  1 AS `OXPIC12`,
  1 AS `OXWEIGHT`,
  1 AS `OXSTOCK`,
  1 AS `OXSTOCKFLAG`,
  1 AS `OXSTOCKTEXT`,
  1 AS `OXNOSTOCKTEXT`,
  1 AS `OXDELIVERY`,
  1 AS `OXINSERT`,
  1 AS `OXTIMESTAMP`,
  1 AS `OXLENGTH`,
  1 AS `OXWIDTH`,
  1 AS `OXHEIGHT`,
  1 AS `OXFILE`,
  1 AS `OXSEARCHKEYS`,
  1 AS `OXTEMPLATE`,
  1 AS `OXQUESTIONEMAIL`,
  1 AS `OXISSEARCH`,
  1 AS `OXISCONFIGURABLE`,
  1 AS `OXVARNAME`,
  1 AS `OXVARSTOCK`,
  1 AS `OXVARCOUNT`,
  1 AS `OXVARSELECT`,
  1 AS `OXVARMINPRICE`,
  1 AS `OXVARMAXPRICE`,
  1 AS `OXBUNDLEID`,
  1 AS `OXFOLDER`,
  1 AS `OXSUBCLASS`,
  1 AS `OXSORT`,
  1 AS `OXSOLDAMOUNT`,
  1 AS `OXNONMATERIAL`,
  1 AS `OXFREESHIPPING`,
  1 AS `OXREMINDACTIVE`,
  1 AS `OXREMINDAMOUNT`,
  1 AS `OXAMITEMID`,
  1 AS `OXAMTASKID`,
  1 AS `OXVENDORID`,
  1 AS `OXMANUFACTURERID`,
  1 AS `OXSKIPDISCOUNTS`,
  1 AS `OXORDERINFO`,
  1 AS `OXPIXIEXPORT`,
  1 AS `OXPIXIEXPORTED`,
  1 AS `OXVPE`,
  1 AS `OXRATING`,
  1 AS `OXRATINGCNT`,
  1 AS `OXMINDELTIME`,
  1 AS `OXMAXDELTIME`,
  1 AS `OXDELTIMEUNIT`,
  1 AS `OXUPDATEPRICE`,
  1 AS `OXUPDATEPRICEA`,
  1 AS `OXUPDATEPRICEB`,
  1 AS `OXUPDATEPRICEC`,
  1 AS `OXUPDATEPRICETIME`,
  1 AS `OXISDOWNLOADABLE`,
  1 AS `OXSHOWCUSTOMAGREEMENT` */;

--
-- Temporary table structure for view `oxv_oxarticles_1_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxarticles_1_en`*/;
/*!50001 CREATE VIEW `oxv_oxarticles_1_en` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXPARENTID`,
  1 AS `OXACTIVE`,
  1 AS `OXHIDDEN`,
  1 AS `OXACTIVEFROM`,
  1 AS `OXACTIVETO`,
  1 AS `OXARTNUM`,
  1 AS `OXEAN`,
  1 AS `OXDISTEAN`,
  1 AS `OXMPN`,
  1 AS `OXTITLE`,
  1 AS `OXSHORTDESC`,
  1 AS `OXPRICE`,
  1 AS `OXBLFIXEDPRICE`,
  1 AS `OXPRICEA`,
  1 AS `OXPRICEB`,
  1 AS `OXPRICEC`,
  1 AS `OXBPRICE`,
  1 AS `OXTPRICE`,
  1 AS `OXUNITNAME`,
  1 AS `OXUNITQUANTITY`,
  1 AS `OXEXTURL`,
  1 AS `OXURLDESC`,
  1 AS `OXURLIMG`,
  1 AS `OXVAT`,
  1 AS `OXTHUMB`,
  1 AS `OXICON`,
  1 AS `OXPIC1`,
  1 AS `OXPIC2`,
  1 AS `OXPIC3`,
  1 AS `OXPIC4`,
  1 AS `OXPIC5`,
  1 AS `OXPIC6`,
  1 AS `OXPIC7`,
  1 AS `OXPIC8`,
  1 AS `OXPIC9`,
  1 AS `OXPIC10`,
  1 AS `OXPIC11`,
  1 AS `OXPIC12`,
  1 AS `OXWEIGHT`,
  1 AS `OXSTOCK`,
  1 AS `OXSTOCKFLAG`,
  1 AS `OXSTOCKTEXT`,
  1 AS `OXNOSTOCKTEXT`,
  1 AS `OXDELIVERY`,
  1 AS `OXINSERT`,
  1 AS `OXTIMESTAMP`,
  1 AS `OXLENGTH`,
  1 AS `OXWIDTH`,
  1 AS `OXHEIGHT`,
  1 AS `OXFILE`,
  1 AS `OXSEARCHKEYS`,
  1 AS `OXTEMPLATE`,
  1 AS `OXQUESTIONEMAIL`,
  1 AS `OXISSEARCH`,
  1 AS `OXISCONFIGURABLE`,
  1 AS `OXVARNAME`,
  1 AS `OXVARSTOCK`,
  1 AS `OXVARCOUNT`,
  1 AS `OXVARSELECT`,
  1 AS `OXVARMINPRICE`,
  1 AS `OXVARMAXPRICE`,
  1 AS `OXBUNDLEID`,
  1 AS `OXFOLDER`,
  1 AS `OXSUBCLASS`,
  1 AS `OXSORT`,
  1 AS `OXSOLDAMOUNT`,
  1 AS `OXNONMATERIAL`,
  1 AS `OXFREESHIPPING`,
  1 AS `OXREMINDACTIVE`,
  1 AS `OXREMINDAMOUNT`,
  1 AS `OXAMITEMID`,
  1 AS `OXAMTASKID`,
  1 AS `OXVENDORID`,
  1 AS `OXMANUFACTURERID`,
  1 AS `OXSKIPDISCOUNTS`,
  1 AS `OXORDERINFO`,
  1 AS `OXPIXIEXPORT`,
  1 AS `OXPIXIEXPORTED`,
  1 AS `OXVPE`,
  1 AS `OXRATING`,
  1 AS `OXRATINGCNT`,
  1 AS `OXMINDELTIME`,
  1 AS `OXMAXDELTIME`,
  1 AS `OXDELTIMEUNIT`,
  1 AS `OXUPDATEPRICE`,
  1 AS `OXUPDATEPRICEA`,
  1 AS `OXUPDATEPRICEB`,
  1 AS `OXUPDATEPRICEC`,
  1 AS `OXUPDATEPRICETIME`,
  1 AS `OXISDOWNLOADABLE`,
  1 AS `OXSHOWCUSTOMAGREEMENT` */;

--
-- Temporary table structure for view `oxv_oxarticles_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxarticles_de`*/;
/*!50001 CREATE VIEW `oxv_oxarticles_de` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXPARENTID`,
  1 AS `OXACTIVE`,
  1 AS `OXHIDDEN`,
  1 AS `OXACTIVEFROM`,
  1 AS `OXACTIVETO`,
  1 AS `OXARTNUM`,
  1 AS `OXEAN`,
  1 AS `OXDISTEAN`,
  1 AS `OXMPN`,
  1 AS `OXTITLE`,
  1 AS `OXSHORTDESC`,
  1 AS `OXPRICE`,
  1 AS `OXBLFIXEDPRICE`,
  1 AS `OXPRICEA`,
  1 AS `OXPRICEB`,
  1 AS `OXPRICEC`,
  1 AS `OXBPRICE`,
  1 AS `OXTPRICE`,
  1 AS `OXUNITNAME`,
  1 AS `OXUNITQUANTITY`,
  1 AS `OXEXTURL`,
  1 AS `OXURLDESC`,
  1 AS `OXURLIMG`,
  1 AS `OXVAT`,
  1 AS `OXTHUMB`,
  1 AS `OXICON`,
  1 AS `OXPIC1`,
  1 AS `OXPIC2`,
  1 AS `OXPIC3`,
  1 AS `OXPIC4`,
  1 AS `OXPIC5`,
  1 AS `OXPIC6`,
  1 AS `OXPIC7`,
  1 AS `OXPIC8`,
  1 AS `OXPIC9`,
  1 AS `OXPIC10`,
  1 AS `OXPIC11`,
  1 AS `OXPIC12`,
  1 AS `OXWEIGHT`,
  1 AS `OXSTOCK`,
  1 AS `OXSTOCKFLAG`,
  1 AS `OXSTOCKTEXT`,
  1 AS `OXNOSTOCKTEXT`,
  1 AS `OXDELIVERY`,
  1 AS `OXINSERT`,
  1 AS `OXTIMESTAMP`,
  1 AS `OXLENGTH`,
  1 AS `OXWIDTH`,
  1 AS `OXHEIGHT`,
  1 AS `OXFILE`,
  1 AS `OXSEARCHKEYS`,
  1 AS `OXTEMPLATE`,
  1 AS `OXQUESTIONEMAIL`,
  1 AS `OXISSEARCH`,
  1 AS `OXISCONFIGURABLE`,
  1 AS `OXVARNAME`,
  1 AS `OXVARSTOCK`,
  1 AS `OXVARCOUNT`,
  1 AS `OXVARSELECT`,
  1 AS `OXVARMINPRICE`,
  1 AS `OXVARMAXPRICE`,
  1 AS `OXBUNDLEID`,
  1 AS `OXFOLDER`,
  1 AS `OXSUBCLASS`,
  1 AS `OXSORT`,
  1 AS `OXSOLDAMOUNT`,
  1 AS `OXNONMATERIAL`,
  1 AS `OXFREESHIPPING`,
  1 AS `OXREMINDACTIVE`,
  1 AS `OXREMINDAMOUNT`,
  1 AS `OXAMITEMID`,
  1 AS `OXAMTASKID`,
  1 AS `OXVENDORID`,
  1 AS `OXMANUFACTURERID`,
  1 AS `OXSKIPDISCOUNTS`,
  1 AS `OXORDERINFO`,
  1 AS `OXPIXIEXPORT`,
  1 AS `OXPIXIEXPORTED`,
  1 AS `OXVPE`,
  1 AS `OXRATING`,
  1 AS `OXRATINGCNT`,
  1 AS `OXMINDELTIME`,
  1 AS `OXMAXDELTIME`,
  1 AS `OXDELTIMEUNIT`,
  1 AS `OXUPDATEPRICE`,
  1 AS `OXUPDATEPRICEA`,
  1 AS `OXUPDATEPRICEB`,
  1 AS `OXUPDATEPRICEC`,
  1 AS `OXUPDATEPRICETIME`,
  1 AS `OXISDOWNLOADABLE`,
  1 AS `OXSHOWCUSTOMAGREEMENT` */;

--
-- Temporary table structure for view `oxv_oxarticles_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxarticles_en`*/;
/*!50001 CREATE VIEW `oxv_oxarticles_en` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXPARENTID`,
  1 AS `OXACTIVE`,
  1 AS `OXHIDDEN`,
  1 AS `OXACTIVEFROM`,
  1 AS `OXACTIVETO`,
  1 AS `OXARTNUM`,
  1 AS `OXEAN`,
  1 AS `OXDISTEAN`,
  1 AS `OXMPN`,
  1 AS `OXTITLE`,
  1 AS `OXSHORTDESC`,
  1 AS `OXPRICE`,
  1 AS `OXBLFIXEDPRICE`,
  1 AS `OXPRICEA`,
  1 AS `OXPRICEB`,
  1 AS `OXPRICEC`,
  1 AS `OXBPRICE`,
  1 AS `OXTPRICE`,
  1 AS `OXUNITNAME`,
  1 AS `OXUNITQUANTITY`,
  1 AS `OXEXTURL`,
  1 AS `OXURLDESC`,
  1 AS `OXURLIMG`,
  1 AS `OXVAT`,
  1 AS `OXTHUMB`,
  1 AS `OXICON`,
  1 AS `OXPIC1`,
  1 AS `OXPIC2`,
  1 AS `OXPIC3`,
  1 AS `OXPIC4`,
  1 AS `OXPIC5`,
  1 AS `OXPIC6`,
  1 AS `OXPIC7`,
  1 AS `OXPIC8`,
  1 AS `OXPIC9`,
  1 AS `OXPIC10`,
  1 AS `OXPIC11`,
  1 AS `OXPIC12`,
  1 AS `OXWEIGHT`,
  1 AS `OXSTOCK`,
  1 AS `OXSTOCKFLAG`,
  1 AS `OXSTOCKTEXT`,
  1 AS `OXNOSTOCKTEXT`,
  1 AS `OXDELIVERY`,
  1 AS `OXINSERT`,
  1 AS `OXTIMESTAMP`,
  1 AS `OXLENGTH`,
  1 AS `OXWIDTH`,
  1 AS `OXHEIGHT`,
  1 AS `OXFILE`,
  1 AS `OXSEARCHKEYS`,
  1 AS `OXTEMPLATE`,
  1 AS `OXQUESTIONEMAIL`,
  1 AS `OXISSEARCH`,
  1 AS `OXISCONFIGURABLE`,
  1 AS `OXVARNAME`,
  1 AS `OXVARSTOCK`,
  1 AS `OXVARCOUNT`,
  1 AS `OXVARSELECT`,
  1 AS `OXVARMINPRICE`,
  1 AS `OXVARMAXPRICE`,
  1 AS `OXBUNDLEID`,
  1 AS `OXFOLDER`,
  1 AS `OXSUBCLASS`,
  1 AS `OXSORT`,
  1 AS `OXSOLDAMOUNT`,
  1 AS `OXNONMATERIAL`,
  1 AS `OXFREESHIPPING`,
  1 AS `OXREMINDACTIVE`,
  1 AS `OXREMINDAMOUNT`,
  1 AS `OXAMITEMID`,
  1 AS `OXAMTASKID`,
  1 AS `OXVENDORID`,
  1 AS `OXMANUFACTURERID`,
  1 AS `OXSKIPDISCOUNTS`,
  1 AS `OXORDERINFO`,
  1 AS `OXPIXIEXPORT`,
  1 AS `OXPIXIEXPORTED`,
  1 AS `OXVPE`,
  1 AS `OXRATING`,
  1 AS `OXRATINGCNT`,
  1 AS `OXMINDELTIME`,
  1 AS `OXMAXDELTIME`,
  1 AS `OXDELTIMEUNIT`,
  1 AS `OXUPDATEPRICE`,
  1 AS `OXUPDATEPRICEA`,
  1 AS `OXUPDATEPRICEB`,
  1 AS `OXUPDATEPRICEC`,
  1 AS `OXUPDATEPRICETIME`,
  1 AS `OXISDOWNLOADABLE`,
  1 AS `OXSHOWCUSTOMAGREEMENT` */;

--
-- Temporary table structure for view `oxv_oxattribute`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxattribute`*/;
/*!50001 CREATE VIEW `oxv_oxattribute` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXTITLE`,
  1 AS `OXTITLE_1`,
  1 AS `OXTITLE_2`,
  1 AS `OXTITLE_3`,
  1 AS `OXPOS`,
  1 AS `OXTIMESTAMP`,
  1 AS `OXDISPLAYINBASKET` */;

--
-- Temporary table structure for view `oxv_oxattribute_1`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxattribute_1`*/;
/*!50001 CREATE VIEW `oxv_oxattribute_1` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXTITLE`,
  1 AS `OXTITLE_1`,
  1 AS `OXTITLE_2`,
  1 AS `OXTITLE_3`,
  1 AS `OXPOS`,
  1 AS `OXTIMESTAMP`,
  1 AS `OXDISPLAYINBASKET` */;

--
-- Temporary table structure for view `oxv_oxattribute_1_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxattribute_1_de`*/;
/*!50001 CREATE VIEW `oxv_oxattribute_1_de` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXTITLE`,
  1 AS `OXPOS`,
  1 AS `OXTIMESTAMP`,
  1 AS `OXDISPLAYINBASKET` */;

--
-- Temporary table structure for view `oxv_oxattribute_1_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxattribute_1_en`*/;
/*!50001 CREATE VIEW `oxv_oxattribute_1_en` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXTITLE`,
  1 AS `OXPOS`,
  1 AS `OXTIMESTAMP`,
  1 AS `OXDISPLAYINBASKET` */;

--
-- Temporary table structure for view `oxv_oxattribute_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxattribute_de`*/;
/*!50001 CREATE VIEW `oxv_oxattribute_de` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXTITLE`,
  1 AS `OXPOS`,
  1 AS `OXTIMESTAMP`,
  1 AS `OXDISPLAYINBASKET` */;

--
-- Temporary table structure for view `oxv_oxattribute_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxattribute_en`*/;
/*!50001 CREATE VIEW `oxv_oxattribute_en` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXTITLE`,
  1 AS `OXPOS`,
  1 AS `OXTIMESTAMP`,
  1 AS `OXDISPLAYINBASKET` */;

--
-- Temporary table structure for view `oxv_oxcategories`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxcategories`*/;
/*!50001 CREATE VIEW `oxv_oxcategories` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXPARENTID`,
  1 AS `OXLEFT`,
  1 AS `OXRIGHT`,
  1 AS `OXROOTID`,
  1 AS `OXSORT`,
  1 AS `OXACTIVE`,
  1 AS `OXHIDDEN`,
  1 AS `OXSHOPID`,
  1 AS `OXTITLE`,
  1 AS `OXDESC`,
  1 AS `OXLONGDESC`,
  1 AS `OXTHUMB`,
  1 AS `OXTHUMB_1`,
  1 AS `OXTHUMB_2`,
  1 AS `OXTHUMB_3`,
  1 AS `OXEXTLINK`,
  1 AS `OXTEMPLATE`,
  1 AS `OXDEFSORT`,
  1 AS `OXDEFSORTMODE`,
  1 AS `OXPRICEFROM`,
  1 AS `OXPRICETO`,
  1 AS `OXACTIVE_1`,
  1 AS `OXTITLE_1`,
  1 AS `OXDESC_1`,
  1 AS `OXLONGDESC_1`,
  1 AS `OXACTIVE_2`,
  1 AS `OXTITLE_2`,
  1 AS `OXDESC_2`,
  1 AS `OXLONGDESC_2`,
  1 AS `OXACTIVE_3`,
  1 AS `OXTITLE_3`,
  1 AS `OXDESC_3`,
  1 AS `OXLONGDESC_3`,
  1 AS `OXICON`,
  1 AS `OXPROMOICON`,
  1 AS `OXVAT`,
  1 AS `OXSKIPDISCOUNTS`,
  1 AS `OXSHOWSUFFIX`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxcategories_1`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxcategories_1`*/;
/*!50001 CREATE VIEW `oxv_oxcategories_1` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXPARENTID`,
  1 AS `OXLEFT`,
  1 AS `OXRIGHT`,
  1 AS `OXROOTID`,
  1 AS `OXSORT`,
  1 AS `OXACTIVE`,
  1 AS `OXHIDDEN`,
  1 AS `OXSHOPID`,
  1 AS `OXTITLE`,
  1 AS `OXDESC`,
  1 AS `OXLONGDESC`,
  1 AS `OXTHUMB`,
  1 AS `OXTHUMB_1`,
  1 AS `OXTHUMB_2`,
  1 AS `OXTHUMB_3`,
  1 AS `OXEXTLINK`,
  1 AS `OXTEMPLATE`,
  1 AS `OXDEFSORT`,
  1 AS `OXDEFSORTMODE`,
  1 AS `OXPRICEFROM`,
  1 AS `OXPRICETO`,
  1 AS `OXACTIVE_1`,
  1 AS `OXTITLE_1`,
  1 AS `OXDESC_1`,
  1 AS `OXLONGDESC_1`,
  1 AS `OXACTIVE_2`,
  1 AS `OXTITLE_2`,
  1 AS `OXDESC_2`,
  1 AS `OXLONGDESC_2`,
  1 AS `OXACTIVE_3`,
  1 AS `OXTITLE_3`,
  1 AS `OXDESC_3`,
  1 AS `OXLONGDESC_3`,
  1 AS `OXICON`,
  1 AS `OXPROMOICON`,
  1 AS `OXVAT`,
  1 AS `OXSKIPDISCOUNTS`,
  1 AS `OXSHOWSUFFIX`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxcategories_1_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxcategories_1_de`*/;
/*!50001 CREATE VIEW `oxv_oxcategories_1_de` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXPARENTID`,
  1 AS `OXLEFT`,
  1 AS `OXRIGHT`,
  1 AS `OXROOTID`,
  1 AS `OXSORT`,
  1 AS `OXACTIVE`,
  1 AS `OXHIDDEN`,
  1 AS `OXSHOPID`,
  1 AS `OXTITLE`,
  1 AS `OXDESC`,
  1 AS `OXLONGDESC`,
  1 AS `OXTHUMB`,
  1 AS `OXEXTLINK`,
  1 AS `OXTEMPLATE`,
  1 AS `OXDEFSORT`,
  1 AS `OXDEFSORTMODE`,
  1 AS `OXPRICEFROM`,
  1 AS `OXPRICETO`,
  1 AS `OXICON`,
  1 AS `OXPROMOICON`,
  1 AS `OXVAT`,
  1 AS `OXSKIPDISCOUNTS`,
  1 AS `OXSHOWSUFFIX`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxcategories_1_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxcategories_1_en`*/;
/*!50001 CREATE VIEW `oxv_oxcategories_1_en` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXPARENTID`,
  1 AS `OXLEFT`,
  1 AS `OXRIGHT`,
  1 AS `OXROOTID`,
  1 AS `OXSORT`,
  1 AS `OXACTIVE`,
  1 AS `OXHIDDEN`,
  1 AS `OXSHOPID`,
  1 AS `OXTITLE`,
  1 AS `OXDESC`,
  1 AS `OXLONGDESC`,
  1 AS `OXTHUMB`,
  1 AS `OXEXTLINK`,
  1 AS `OXTEMPLATE`,
  1 AS `OXDEFSORT`,
  1 AS `OXDEFSORTMODE`,
  1 AS `OXPRICEFROM`,
  1 AS `OXPRICETO`,
  1 AS `OXICON`,
  1 AS `OXPROMOICON`,
  1 AS `OXVAT`,
  1 AS `OXSKIPDISCOUNTS`,
  1 AS `OXSHOWSUFFIX`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxcategories_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxcategories_de`*/;
/*!50001 CREATE VIEW `oxv_oxcategories_de` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXPARENTID`,
  1 AS `OXLEFT`,
  1 AS `OXRIGHT`,
  1 AS `OXROOTID`,
  1 AS `OXSORT`,
  1 AS `OXACTIVE`,
  1 AS `OXHIDDEN`,
  1 AS `OXSHOPID`,
  1 AS `OXTITLE`,
  1 AS `OXDESC`,
  1 AS `OXLONGDESC`,
  1 AS `OXTHUMB`,
  1 AS `OXEXTLINK`,
  1 AS `OXTEMPLATE`,
  1 AS `OXDEFSORT`,
  1 AS `OXDEFSORTMODE`,
  1 AS `OXPRICEFROM`,
  1 AS `OXPRICETO`,
  1 AS `OXICON`,
  1 AS `OXPROMOICON`,
  1 AS `OXVAT`,
  1 AS `OXSKIPDISCOUNTS`,
  1 AS `OXSHOWSUFFIX`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxcategories_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxcategories_en`*/;
/*!50001 CREATE VIEW `oxv_oxcategories_en` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXPARENTID`,
  1 AS `OXLEFT`,
  1 AS `OXRIGHT`,
  1 AS `OXROOTID`,
  1 AS `OXSORT`,
  1 AS `OXACTIVE`,
  1 AS `OXHIDDEN`,
  1 AS `OXSHOPID`,
  1 AS `OXTITLE`,
  1 AS `OXDESC`,
  1 AS `OXLONGDESC`,
  1 AS `OXTHUMB`,
  1 AS `OXEXTLINK`,
  1 AS `OXTEMPLATE`,
  1 AS `OXDEFSORT`,
  1 AS `OXDEFSORTMODE`,
  1 AS `OXPRICEFROM`,
  1 AS `OXPRICETO`,
  1 AS `OXICON`,
  1 AS `OXPROMOICON`,
  1 AS `OXVAT`,
  1 AS `OXSKIPDISCOUNTS`,
  1 AS `OXSHOWSUFFIX`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxcontents`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxcontents`*/;
/*!50001 CREATE VIEW `oxv_oxcontents` AS SELECT
 1 AS `OXID`,
  1 AS `OXLOADID`,
  1 AS `OXSHOPID`,
  1 AS `OXSNIPPET`,
  1 AS `OXTYPE`,
  1 AS `OXACTIVE`,
  1 AS `OXACTIVE_1`,
  1 AS `OXPOSITION`,
  1 AS `OXTITLE`,
  1 AS `OXCONTENT`,
  1 AS `OXTITLE_1`,
  1 AS `OXCONTENT_1`,
  1 AS `OXACTIVE_2`,
  1 AS `OXTITLE_2`,
  1 AS `OXCONTENT_2`,
  1 AS `OXACTIVE_3`,
  1 AS `OXTITLE_3`,
  1 AS `OXCONTENT_3`,
  1 AS `OXCATID`,
  1 AS `OXFOLDER`,
  1 AS `OXTERMVERSION`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxcontents_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxcontents_de`*/;
/*!50001 CREATE VIEW `oxv_oxcontents_de` AS SELECT
 1 AS `OXID`,
  1 AS `OXLOADID`,
  1 AS `OXSHOPID`,
  1 AS `OXSNIPPET`,
  1 AS `OXTYPE`,
  1 AS `OXACTIVE`,
  1 AS `OXPOSITION`,
  1 AS `OXTITLE`,
  1 AS `OXCONTENT`,
  1 AS `OXCATID`,
  1 AS `OXFOLDER`,
  1 AS `OXTERMVERSION`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxcontents_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxcontents_en`*/;
/*!50001 CREATE VIEW `oxv_oxcontents_en` AS SELECT
 1 AS `OXID`,
  1 AS `OXLOADID`,
  1 AS `OXSHOPID`,
  1 AS `OXSNIPPET`,
  1 AS `OXTYPE`,
  1 AS `OXACTIVE`,
  1 AS `OXPOSITION`,
  1 AS `OXTITLE`,
  1 AS `OXCONTENT`,
  1 AS `OXCATID`,
  1 AS `OXFOLDER`,
  1 AS `OXTERMVERSION`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxcountry`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxcountry`*/;
/*!50001 CREATE VIEW `oxv_oxcountry` AS SELECT
 1 AS `OXID`,
  1 AS `OXACTIVE`,
  1 AS `OXTITLE`,
  1 AS `OXISOALPHA2`,
  1 AS `OXISOALPHA3`,
  1 AS `OXUNNUM3`,
  1 AS `OXVATINPREFIX`,
  1 AS `OXORDER`,
  1 AS `OXSHORTDESC`,
  1 AS `OXLONGDESC`,
  1 AS `OXTITLE_1`,
  1 AS `OXTITLE_2`,
  1 AS `OXTITLE_3`,
  1 AS `OXSHORTDESC_1`,
  1 AS `OXSHORTDESC_2`,
  1 AS `OXSHORTDESC_3`,
  1 AS `OXLONGDESC_1`,
  1 AS `OXLONGDESC_2`,
  1 AS `OXLONGDESC_3`,
  1 AS `OXVATSTATUS`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxcountry_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxcountry_de`*/;
/*!50001 CREATE VIEW `oxv_oxcountry_de` AS SELECT
 1 AS `OXID`,
  1 AS `OXACTIVE`,
  1 AS `OXTITLE`,
  1 AS `OXISOALPHA2`,
  1 AS `OXISOALPHA3`,
  1 AS `OXUNNUM3`,
  1 AS `OXVATINPREFIX`,
  1 AS `OXORDER`,
  1 AS `OXSHORTDESC`,
  1 AS `OXLONGDESC`,
  1 AS `OXVATSTATUS`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxcountry_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxcountry_en`*/;
/*!50001 CREATE VIEW `oxv_oxcountry_en` AS SELECT
 1 AS `OXID`,
  1 AS `OXACTIVE`,
  1 AS `OXTITLE`,
  1 AS `OXISOALPHA2`,
  1 AS `OXISOALPHA3`,
  1 AS `OXUNNUM3`,
  1 AS `OXVATINPREFIX`,
  1 AS `OXORDER`,
  1 AS `OXSHORTDESC`,
  1 AS `OXLONGDESC`,
  1 AS `OXVATSTATUS`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxdelivery`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxdelivery`*/;
/*!50001 CREATE VIEW `oxv_oxdelivery` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXACTIVEFROM`,
  1 AS `OXACTIVETO`,
  1 AS `OXTITLE`,
  1 AS `OXTITLE_1`,
  1 AS `OXTITLE_2`,
  1 AS `OXTITLE_3`,
  1 AS `OXADDSUMTYPE`,
  1 AS `OXADDSUM`,
  1 AS `OXDELTYPE`,
  1 AS `OXPARAM`,
  1 AS `OXPARAMEND`,
  1 AS `OXFIXED`,
  1 AS `OXSORT`,
  1 AS `OXFINALIZE`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxdelivery_1`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxdelivery_1`*/;
/*!50001 CREATE VIEW `oxv_oxdelivery_1` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXACTIVEFROM`,
  1 AS `OXACTIVETO`,
  1 AS `OXTITLE`,
  1 AS `OXTITLE_1`,
  1 AS `OXTITLE_2`,
  1 AS `OXTITLE_3`,
  1 AS `OXADDSUMTYPE`,
  1 AS `OXADDSUM`,
  1 AS `OXDELTYPE`,
  1 AS `OXPARAM`,
  1 AS `OXPARAMEND`,
  1 AS `OXFIXED`,
  1 AS `OXSORT`,
  1 AS `OXFINALIZE`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxdelivery_1_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxdelivery_1_de`*/;
/*!50001 CREATE VIEW `oxv_oxdelivery_1_de` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXACTIVEFROM`,
  1 AS `OXACTIVETO`,
  1 AS `OXTITLE`,
  1 AS `OXADDSUMTYPE`,
  1 AS `OXADDSUM`,
  1 AS `OXDELTYPE`,
  1 AS `OXPARAM`,
  1 AS `OXPARAMEND`,
  1 AS `OXFIXED`,
  1 AS `OXSORT`,
  1 AS `OXFINALIZE`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxdelivery_1_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxdelivery_1_en`*/;
/*!50001 CREATE VIEW `oxv_oxdelivery_1_en` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXACTIVEFROM`,
  1 AS `OXACTIVETO`,
  1 AS `OXTITLE`,
  1 AS `OXADDSUMTYPE`,
  1 AS `OXADDSUM`,
  1 AS `OXDELTYPE`,
  1 AS `OXPARAM`,
  1 AS `OXPARAMEND`,
  1 AS `OXFIXED`,
  1 AS `OXSORT`,
  1 AS `OXFINALIZE`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxdelivery_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxdelivery_de`*/;
/*!50001 CREATE VIEW `oxv_oxdelivery_de` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXACTIVEFROM`,
  1 AS `OXACTIVETO`,
  1 AS `OXTITLE`,
  1 AS `OXADDSUMTYPE`,
  1 AS `OXADDSUM`,
  1 AS `OXDELTYPE`,
  1 AS `OXPARAM`,
  1 AS `OXPARAMEND`,
  1 AS `OXFIXED`,
  1 AS `OXSORT`,
  1 AS `OXFINALIZE`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxdelivery_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxdelivery_en`*/;
/*!50001 CREATE VIEW `oxv_oxdelivery_en` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXACTIVEFROM`,
  1 AS `OXACTIVETO`,
  1 AS `OXTITLE`,
  1 AS `OXADDSUMTYPE`,
  1 AS `OXADDSUM`,
  1 AS `OXDELTYPE`,
  1 AS `OXPARAM`,
  1 AS `OXPARAMEND`,
  1 AS `OXFIXED`,
  1 AS `OXSORT`,
  1 AS `OXFINALIZE`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxdeliveryset`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxdeliveryset`*/;
/*!50001 CREATE VIEW `oxv_oxdeliveryset` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXACTIVEFROM`,
  1 AS `OXACTIVETO`,
  1 AS `OXTITLE`,
  1 AS `OXTITLE_1`,
  1 AS `OXTITLE_2`,
  1 AS `OXTITLE_3`,
  1 AS `OXPOS`,
  1 AS `OXTIMESTAMP`,
  1 AS `OXTRACKINGURL` */;

--
-- Temporary table structure for view `oxv_oxdeliveryset_1`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxdeliveryset_1`*/;
/*!50001 CREATE VIEW `oxv_oxdeliveryset_1` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXACTIVEFROM`,
  1 AS `OXACTIVETO`,
  1 AS `OXTITLE`,
  1 AS `OXTITLE_1`,
  1 AS `OXTITLE_2`,
  1 AS `OXTITLE_3`,
  1 AS `OXPOS`,
  1 AS `OXTIMESTAMP`,
  1 AS `OXTRACKINGURL` */;

--
-- Temporary table structure for view `oxv_oxdeliveryset_1_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxdeliveryset_1_de`*/;
/*!50001 CREATE VIEW `oxv_oxdeliveryset_1_de` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXACTIVEFROM`,
  1 AS `OXACTIVETO`,
  1 AS `OXTITLE`,
  1 AS `OXPOS`,
  1 AS `OXTIMESTAMP`,
  1 AS `OXTRACKINGURL` */;

--
-- Temporary table structure for view `oxv_oxdeliveryset_1_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxdeliveryset_1_en`*/;
/*!50001 CREATE VIEW `oxv_oxdeliveryset_1_en` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXACTIVEFROM`,
  1 AS `OXACTIVETO`,
  1 AS `OXTITLE`,
  1 AS `OXPOS`,
  1 AS `OXTIMESTAMP`,
  1 AS `OXTRACKINGURL` */;

--
-- Temporary table structure for view `oxv_oxdeliveryset_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxdeliveryset_de`*/;
/*!50001 CREATE VIEW `oxv_oxdeliveryset_de` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXACTIVEFROM`,
  1 AS `OXACTIVETO`,
  1 AS `OXTITLE`,
  1 AS `OXPOS`,
  1 AS `OXTIMESTAMP`,
  1 AS `OXTRACKINGURL` */;

--
-- Temporary table structure for view `oxv_oxdeliveryset_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxdeliveryset_en`*/;
/*!50001 CREATE VIEW `oxv_oxdeliveryset_en` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXACTIVEFROM`,
  1 AS `OXACTIVETO`,
  1 AS `OXTITLE`,
  1 AS `OXPOS`,
  1 AS `OXTIMESTAMP`,
  1 AS `OXTRACKINGURL` */;

--
-- Temporary table structure for view `oxv_oxdiscount`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxdiscount`*/;
/*!50001 CREATE VIEW `oxv_oxdiscount` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXACTIVEFROM`,
  1 AS `OXACTIVETO`,
  1 AS `OXTITLE`,
  1 AS `OXTITLE_1`,
  1 AS `OXTITLE_2`,
  1 AS `OXTITLE_3`,
  1 AS `OXAMOUNT`,
  1 AS `OXAMOUNTTO`,
  1 AS `OXPRICETO`,
  1 AS `OXPRICE`,
  1 AS `OXADDSUMTYPE`,
  1 AS `OXADDSUM`,
  1 AS `OXITMARTID`,
  1 AS `OXITMAMOUNT`,
  1 AS `OXITMMULTIPLE`,
  1 AS `OXSORT`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxdiscount_1`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxdiscount_1`*/;
/*!50001 CREATE VIEW `oxv_oxdiscount_1` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXACTIVEFROM`,
  1 AS `OXACTIVETO`,
  1 AS `OXTITLE`,
  1 AS `OXTITLE_1`,
  1 AS `OXTITLE_2`,
  1 AS `OXTITLE_3`,
  1 AS `OXAMOUNT`,
  1 AS `OXAMOUNTTO`,
  1 AS `OXPRICETO`,
  1 AS `OXPRICE`,
  1 AS `OXADDSUMTYPE`,
  1 AS `OXADDSUM`,
  1 AS `OXITMARTID`,
  1 AS `OXITMAMOUNT`,
  1 AS `OXITMMULTIPLE`,
  1 AS `OXSORT`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxdiscount_1_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxdiscount_1_de`*/;
/*!50001 CREATE VIEW `oxv_oxdiscount_1_de` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXACTIVEFROM`,
  1 AS `OXACTIVETO`,
  1 AS `OXTITLE`,
  1 AS `OXAMOUNT`,
  1 AS `OXAMOUNTTO`,
  1 AS `OXPRICETO`,
  1 AS `OXPRICE`,
  1 AS `OXADDSUMTYPE`,
  1 AS `OXADDSUM`,
  1 AS `OXITMARTID`,
  1 AS `OXITMAMOUNT`,
  1 AS `OXITMMULTIPLE`,
  1 AS `OXSORT`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxdiscount_1_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxdiscount_1_en`*/;
/*!50001 CREATE VIEW `oxv_oxdiscount_1_en` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXACTIVEFROM`,
  1 AS `OXACTIVETO`,
  1 AS `OXTITLE`,
  1 AS `OXAMOUNT`,
  1 AS `OXAMOUNTTO`,
  1 AS `OXPRICETO`,
  1 AS `OXPRICE`,
  1 AS `OXADDSUMTYPE`,
  1 AS `OXADDSUM`,
  1 AS `OXITMARTID`,
  1 AS `OXITMAMOUNT`,
  1 AS `OXITMMULTIPLE`,
  1 AS `OXSORT`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxdiscount_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxdiscount_de`*/;
/*!50001 CREATE VIEW `oxv_oxdiscount_de` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXACTIVEFROM`,
  1 AS `OXACTIVETO`,
  1 AS `OXTITLE`,
  1 AS `OXAMOUNT`,
  1 AS `OXAMOUNTTO`,
  1 AS `OXPRICETO`,
  1 AS `OXPRICE`,
  1 AS `OXADDSUMTYPE`,
  1 AS `OXADDSUM`,
  1 AS `OXITMARTID`,
  1 AS `OXITMAMOUNT`,
  1 AS `OXITMMULTIPLE`,
  1 AS `OXSORT`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxdiscount_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxdiscount_en`*/;
/*!50001 CREATE VIEW `oxv_oxdiscount_en` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXACTIVEFROM`,
  1 AS `OXACTIVETO`,
  1 AS `OXTITLE`,
  1 AS `OXAMOUNT`,
  1 AS `OXAMOUNTTO`,
  1 AS `OXPRICETO`,
  1 AS `OXPRICE`,
  1 AS `OXADDSUMTYPE`,
  1 AS `OXADDSUM`,
  1 AS `OXITMARTID`,
  1 AS `OXITMAMOUNT`,
  1 AS `OXITMMULTIPLE`,
  1 AS `OXSORT`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxfield2shop`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxfield2shop`*/;
/*!50001 CREATE VIEW `oxv_oxfield2shop` AS SELECT
 1 AS `OXID`,
  1 AS `OXARTID`,
  1 AS `OXSHOPID`,
  1 AS `OXPRICE`,
  1 AS `OXPRICEA`,
  1 AS `OXPRICEB`,
  1 AS `OXPRICEC`,
  1 AS `OXUPDATEPRICE`,
  1 AS `OXUPDATEPRICEA`,
  1 AS `OXUPDATEPRICEB`,
  1 AS `OXUPDATEPRICEC`,
  1 AS `OXUPDATEPRICETIME`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxfield2shop_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxfield2shop_de`*/;
/*!50001 CREATE VIEW `oxv_oxfield2shop_de` AS SELECT
 1 AS `OXID`,
  1 AS `OXARTID`,
  1 AS `OXSHOPID`,
  1 AS `OXPRICE`,
  1 AS `OXPRICEA`,
  1 AS `OXPRICEB`,
  1 AS `OXPRICEC`,
  1 AS `OXUPDATEPRICE`,
  1 AS `OXUPDATEPRICEA`,
  1 AS `OXUPDATEPRICEB`,
  1 AS `OXUPDATEPRICEC`,
  1 AS `OXUPDATEPRICETIME`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxfield2shop_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxfield2shop_en`*/;
/*!50001 CREATE VIEW `oxv_oxfield2shop_en` AS SELECT
 1 AS `OXID`,
  1 AS `OXARTID`,
  1 AS `OXSHOPID`,
  1 AS `OXPRICE`,
  1 AS `OXPRICEA`,
  1 AS `OXPRICEB`,
  1 AS `OXPRICEC`,
  1 AS `OXUPDATEPRICE`,
  1 AS `OXUPDATEPRICEA`,
  1 AS `OXUPDATEPRICEB`,
  1 AS `OXUPDATEPRICEC`,
  1 AS `OXUPDATEPRICETIME`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxgroups`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxgroups`*/;
/*!50001 CREATE VIEW `oxv_oxgroups` AS SELECT
 1 AS `OXID`,
  1 AS `OXRRID`,
  1 AS `OXACTIVE`,
  1 AS `OXTITLE`,
  1 AS `OXTITLE_1`,
  1 AS `OXTITLE_2`,
  1 AS `OXTITLE_3`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxgroups_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxgroups_de`*/;
/*!50001 CREATE VIEW `oxv_oxgroups_de` AS SELECT
 1 AS `OXID`,
  1 AS `OXRRID`,
  1 AS `OXACTIVE`,
  1 AS `OXTITLE`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxgroups_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxgroups_en`*/;
/*!50001 CREATE VIEW `oxv_oxgroups_en` AS SELECT
 1 AS `OXID`,
  1 AS `OXRRID`,
  1 AS `OXACTIVE`,
  1 AS `OXTITLE`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxlinks`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxlinks`*/;
/*!50001 CREATE VIEW `oxv_oxlinks` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXURL`,
  1 AS `OXURLDESC`,
  1 AS `OXURLDESC_1`,
  1 AS `OXURLDESC_2`,
  1 AS `OXURLDESC_3`,
  1 AS `OXINSERT`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxlinks_1`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxlinks_1`*/;
/*!50001 CREATE VIEW `oxv_oxlinks_1` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXURL`,
  1 AS `OXURLDESC`,
  1 AS `OXURLDESC_1`,
  1 AS `OXURLDESC_2`,
  1 AS `OXURLDESC_3`,
  1 AS `OXINSERT`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxlinks_1_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxlinks_1_de`*/;
/*!50001 CREATE VIEW `oxv_oxlinks_1_de` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXURL`,
  1 AS `OXURLDESC`,
  1 AS `OXINSERT`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxlinks_1_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxlinks_1_en`*/;
/*!50001 CREATE VIEW `oxv_oxlinks_1_en` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXURL`,
  1 AS `OXURLDESC`,
  1 AS `OXINSERT`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxlinks_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxlinks_de`*/;
/*!50001 CREATE VIEW `oxv_oxlinks_de` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXURL`,
  1 AS `OXURLDESC`,
  1 AS `OXINSERT`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxlinks_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxlinks_en`*/;
/*!50001 CREATE VIEW `oxv_oxlinks_en` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXURL`,
  1 AS `OXURLDESC`,
  1 AS `OXINSERT`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxmanufacturers`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxmanufacturers`*/;
/*!50001 CREATE VIEW `oxv_oxmanufacturers` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXICON`,
  1 AS `OXTITLE`,
  1 AS `OXSHORTDESC`,
  1 AS `OXTITLE_1`,
  1 AS `OXSHORTDESC_1`,
  1 AS `OXTITLE_2`,
  1 AS `OXSHORTDESC_2`,
  1 AS `OXTITLE_3`,
  1 AS `OXSHORTDESC_3`,
  1 AS `OXSHOWSUFFIX`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxmanufacturers_1`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxmanufacturers_1`*/;
/*!50001 CREATE VIEW `oxv_oxmanufacturers_1` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXICON`,
  1 AS `OXTITLE`,
  1 AS `OXSHORTDESC`,
  1 AS `OXTITLE_1`,
  1 AS `OXSHORTDESC_1`,
  1 AS `OXTITLE_2`,
  1 AS `OXSHORTDESC_2`,
  1 AS `OXTITLE_3`,
  1 AS `OXSHORTDESC_3`,
  1 AS `OXSHOWSUFFIX`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxmanufacturers_1_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxmanufacturers_1_de`*/;
/*!50001 CREATE VIEW `oxv_oxmanufacturers_1_de` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXICON`,
  1 AS `OXTITLE`,
  1 AS `OXSHORTDESC`,
  1 AS `OXSHOWSUFFIX`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxmanufacturers_1_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxmanufacturers_1_en`*/;
/*!50001 CREATE VIEW `oxv_oxmanufacturers_1_en` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXICON`,
  1 AS `OXTITLE`,
  1 AS `OXSHORTDESC`,
  1 AS `OXSHOWSUFFIX`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxmanufacturers_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxmanufacturers_de`*/;
/*!50001 CREATE VIEW `oxv_oxmanufacturers_de` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXICON`,
  1 AS `OXTITLE`,
  1 AS `OXSHORTDESC`,
  1 AS `OXSHOWSUFFIX`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxmanufacturers_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxmanufacturers_en`*/;
/*!50001 CREATE VIEW `oxv_oxmanufacturers_en` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXICON`,
  1 AS `OXTITLE`,
  1 AS `OXSHORTDESC`,
  1 AS `OXSHOWSUFFIX`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxmediaurls`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxmediaurls`*/;
/*!50001 CREATE VIEW `oxv_oxmediaurls` AS SELECT
 1 AS `OXID`,
  1 AS `OXOBJECTID`,
  1 AS `OXURL`,
  1 AS `OXDESC`,
  1 AS `OXDESC_1`,
  1 AS `OXDESC_2`,
  1 AS `OXDESC_3`,
  1 AS `OXISUPLOADED`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxmediaurls_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxmediaurls_de`*/;
/*!50001 CREATE VIEW `oxv_oxmediaurls_de` AS SELECT
 1 AS `OXID`,
  1 AS `OXOBJECTID`,
  1 AS `OXURL`,
  1 AS `OXDESC`,
  1 AS `OXISUPLOADED`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxmediaurls_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxmediaurls_en`*/;
/*!50001 CREATE VIEW `oxv_oxmediaurls_en` AS SELECT
 1 AS `OXID`,
  1 AS `OXOBJECTID`,
  1 AS `OXURL`,
  1 AS `OXDESC`,
  1 AS `OXISUPLOADED`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxobject2attribute`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxobject2attribute`*/;
/*!50001 CREATE VIEW `oxv_oxobject2attribute` AS SELECT
 1 AS `OXID`,
  1 AS `OXOBJECTID`,
  1 AS `OXATTRID`,
  1 AS `OXVALUE`,
  1 AS `OXPOS`,
  1 AS `OXVALUE_1`,
  1 AS `OXVALUE_2`,
  1 AS `OXVALUE_3`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxobject2attribute_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxobject2attribute_de`*/;
/*!50001 CREATE VIEW `oxv_oxobject2attribute_de` AS SELECT
 1 AS `OXID`,
  1 AS `OXOBJECTID`,
  1 AS `OXATTRID`,
  1 AS `OXVALUE`,
  1 AS `OXPOS`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxobject2attribute_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxobject2attribute_en`*/;
/*!50001 CREATE VIEW `oxv_oxobject2attribute_en` AS SELECT
 1 AS `OXID`,
  1 AS `OXOBJECTID`,
  1 AS `OXATTRID`,
  1 AS `OXVALUE`,
  1 AS `OXPOS`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxobject2category`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxobject2category`*/;
/*!50001 CREATE VIEW `oxv_oxobject2category` AS SELECT
 1 AS `OXID`,
  1 AS `OXSHOPID`,
  1 AS `OXOBJECTID`,
  1 AS `OXCATNID`,
  1 AS `OXPOS`,
  1 AS `OXTIME`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxobject2category_1`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxobject2category_1`*/;
/*!50001 CREATE VIEW `oxv_oxobject2category_1` AS SELECT
 1 AS `OXID`,
  1 AS `OXSHOPID`,
  1 AS `OXOBJECTID`,
  1 AS `OXCATNID`,
  1 AS `OXPOS`,
  1 AS `OXTIME`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxpayments`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxpayments`*/;
/*!50001 CREATE VIEW `oxv_oxpayments` AS SELECT
 1 AS `OXID`,
  1 AS `OXACTIVE`,
  1 AS `OXDESC`,
  1 AS `OXADDSUM`,
  1 AS `OXADDSUMTYPE`,
  1 AS `OXADDSUMRULES`,
  1 AS `OXFROMBONI`,
  1 AS `OXFROMAMOUNT`,
  1 AS `OXTOAMOUNT`,
  1 AS `OXVALDESC`,
  1 AS `OXCHECKED`,
  1 AS `OXDESC_1`,
  1 AS `OXVALDESC_1`,
  1 AS `OXDESC_2`,
  1 AS `OXVALDESC_2`,
  1 AS `OXDESC_3`,
  1 AS `OXVALDESC_3`,
  1 AS `OXLONGDESC`,
  1 AS `OXLONGDESC_1`,
  1 AS `OXLONGDESC_2`,
  1 AS `OXLONGDESC_3`,
  1 AS `OXSORT`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxpayments_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxpayments_de`*/;
/*!50001 CREATE VIEW `oxv_oxpayments_de` AS SELECT
 1 AS `OXID`,
  1 AS `OXACTIVE`,
  1 AS `OXDESC`,
  1 AS `OXADDSUM`,
  1 AS `OXADDSUMTYPE`,
  1 AS `OXADDSUMRULES`,
  1 AS `OXFROMBONI`,
  1 AS `OXFROMAMOUNT`,
  1 AS `OXTOAMOUNT`,
  1 AS `OXVALDESC`,
  1 AS `OXCHECKED`,
  1 AS `OXLONGDESC`,
  1 AS `OXSORT`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxpayments_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxpayments_en`*/;
/*!50001 CREATE VIEW `oxv_oxpayments_en` AS SELECT
 1 AS `OXID`,
  1 AS `OXACTIVE`,
  1 AS `OXDESC`,
  1 AS `OXADDSUM`,
  1 AS `OXADDSUMTYPE`,
  1 AS `OXADDSUMRULES`,
  1 AS `OXFROMBONI`,
  1 AS `OXFROMAMOUNT`,
  1 AS `OXTOAMOUNT`,
  1 AS `OXVALDESC`,
  1 AS `OXCHECKED`,
  1 AS `OXLONGDESC`,
  1 AS `OXSORT`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxselectlist`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxselectlist`*/;
/*!50001 CREATE VIEW `oxv_oxselectlist` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXTITLE`,
  1 AS `OXIDENT`,
  1 AS `OXVALDESC`,
  1 AS `OXTITLE_1`,
  1 AS `OXVALDESC_1`,
  1 AS `OXTITLE_2`,
  1 AS `OXVALDESC_2`,
  1 AS `OXTITLE_3`,
  1 AS `OXVALDESC_3`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxselectlist_1`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxselectlist_1`*/;
/*!50001 CREATE VIEW `oxv_oxselectlist_1` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXTITLE`,
  1 AS `OXIDENT`,
  1 AS `OXVALDESC`,
  1 AS `OXTITLE_1`,
  1 AS `OXVALDESC_1`,
  1 AS `OXTITLE_2`,
  1 AS `OXVALDESC_2`,
  1 AS `OXTITLE_3`,
  1 AS `OXVALDESC_3`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxselectlist_1_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxselectlist_1_de`*/;
/*!50001 CREATE VIEW `oxv_oxselectlist_1_de` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXTITLE`,
  1 AS `OXIDENT`,
  1 AS `OXVALDESC`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxselectlist_1_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxselectlist_1_en`*/;
/*!50001 CREATE VIEW `oxv_oxselectlist_1_en` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXTITLE`,
  1 AS `OXIDENT`,
  1 AS `OXVALDESC`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxselectlist_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxselectlist_de`*/;
/*!50001 CREATE VIEW `oxv_oxselectlist_de` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXTITLE`,
  1 AS `OXIDENT`,
  1 AS `OXVALDESC`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxselectlist_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxselectlist_en`*/;
/*!50001 CREATE VIEW `oxv_oxselectlist_en` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXTITLE`,
  1 AS `OXIDENT`,
  1 AS `OXVALDESC`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxshops`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxshops`*/;
/*!50001 CREATE VIEW `oxv_oxshops` AS SELECT
 1 AS `OXID`,
  1 AS `OXPARENTID`,
  1 AS `OXACTIVE`,
  1 AS `OXISINHERITED`,
  1 AS `OXISMULTISHOP`,
  1 AS `OXISSUPERSHOP`,
  1 AS `OXPRODUCTIVE`,
  1 AS `OXDEFCURRENCY`,
  1 AS `OXDEFLANGUAGE`,
  1 AS `OXNAME`,
  1 AS `OXTITLEPREFIX`,
  1 AS `OXTITLEPREFIX_1`,
  1 AS `OXTITLEPREFIX_2`,
  1 AS `OXTITLEPREFIX_3`,
  1 AS `OXTITLESUFFIX`,
  1 AS `OXTITLESUFFIX_1`,
  1 AS `OXTITLESUFFIX_2`,
  1 AS `OXTITLESUFFIX_3`,
  1 AS `OXSTARTTITLE`,
  1 AS `OXSTARTTITLE_1`,
  1 AS `OXSTARTTITLE_2`,
  1 AS `OXSTARTTITLE_3`,
  1 AS `OXINFOEMAIL`,
  1 AS `OXORDEREMAIL`,
  1 AS `OXOWNEREMAIL`,
  1 AS `OXORDERSUBJECT`,
  1 AS `OXREGISTERSUBJECT`,
  1 AS `OXFORGOTPWDSUBJECT`,
  1 AS `OXSENDEDNOWSUBJECT`,
  1 AS `OXORDERSUBJECT_1`,
  1 AS `OXREGISTERSUBJECT_1`,
  1 AS `OXFORGOTPWDSUBJECT_1`,
  1 AS `OXSENDEDNOWSUBJECT_1`,
  1 AS `OXORDERSUBJECT_2`,
  1 AS `OXREGISTERSUBJECT_2`,
  1 AS `OXFORGOTPWDSUBJECT_2`,
  1 AS `OXSENDEDNOWSUBJECT_2`,
  1 AS `OXORDERSUBJECT_3`,
  1 AS `OXREGISTERSUBJECT_3`,
  1 AS `OXFORGOTPWDSUBJECT_3`,
  1 AS `OXSENDEDNOWSUBJECT_3`,
  1 AS `OXSMTP`,
  1 AS `OXSMTPUSER`,
  1 AS `OXSMTPPWD`,
  1 AS `OXCOMPANY`,
  1 AS `OXSTREET`,
  1 AS `OXZIP`,
  1 AS `OXCITY`,
  1 AS `OXCOUNTRY`,
  1 AS `OXBANKNAME`,
  1 AS `OXBANKNUMBER`,
  1 AS `OXBANKCODE`,
  1 AS `OXVATNUMBER`,
  1 AS `OXTAXNUMBER`,
  1 AS `OXBICCODE`,
  1 AS `OXIBANNUMBER`,
  1 AS `OXFNAME`,
  1 AS `OXLNAME`,
  1 AS `OXTELEFON`,
  1 AS `OXTELEFAX`,
  1 AS `OXURL`,
  1 AS `OXDEFCAT`,
  1 AS `OXHRBNR`,
  1 AS `OXCOURT`,
  1 AS `OXADBUTLERID`,
  1 AS `OXAFFILINETID`,
  1 AS `OXSUPERCLICKSID`,
  1 AS `OXAFFILIWELTID`,
  1 AS `OXAFFILI24ID`,
  1 AS `OXEDITION`,
  1 AS `OXVERSION`,
  1 AS `OXSEOACTIVE`,
  1 AS `OXSEOACTIVE_1`,
  1 AS `OXSEOACTIVE_2`,
  1 AS `OXSEOACTIVE_3`,
  1 AS `OXTIMESTAMP`,
  1 AS `OXSERIAL` */;

--
-- Temporary table structure for view `oxv_oxshops_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxshops_de`*/;
/*!50001 CREATE VIEW `oxv_oxshops_de` AS SELECT
 1 AS `OXID`,
  1 AS `OXPARENTID`,
  1 AS `OXACTIVE`,
  1 AS `OXISINHERITED`,
  1 AS `OXISMULTISHOP`,
  1 AS `OXISSUPERSHOP`,
  1 AS `OXPRODUCTIVE`,
  1 AS `OXDEFCURRENCY`,
  1 AS `OXDEFLANGUAGE`,
  1 AS `OXNAME`,
  1 AS `OXTITLEPREFIX`,
  1 AS `OXTITLESUFFIX`,
  1 AS `OXSTARTTITLE`,
  1 AS `OXINFOEMAIL`,
  1 AS `OXORDEREMAIL`,
  1 AS `OXOWNEREMAIL`,
  1 AS `OXORDERSUBJECT`,
  1 AS `OXREGISTERSUBJECT`,
  1 AS `OXFORGOTPWDSUBJECT`,
  1 AS `OXSENDEDNOWSUBJECT`,
  1 AS `OXSMTP`,
  1 AS `OXSMTPUSER`,
  1 AS `OXSMTPPWD`,
  1 AS `OXCOMPANY`,
  1 AS `OXSTREET`,
  1 AS `OXZIP`,
  1 AS `OXCITY`,
  1 AS `OXCOUNTRY`,
  1 AS `OXBANKNAME`,
  1 AS `OXBANKNUMBER`,
  1 AS `OXBANKCODE`,
  1 AS `OXVATNUMBER`,
  1 AS `OXTAXNUMBER`,
  1 AS `OXBICCODE`,
  1 AS `OXIBANNUMBER`,
  1 AS `OXFNAME`,
  1 AS `OXLNAME`,
  1 AS `OXTELEFON`,
  1 AS `OXTELEFAX`,
  1 AS `OXURL`,
  1 AS `OXDEFCAT`,
  1 AS `OXHRBNR`,
  1 AS `OXCOURT`,
  1 AS `OXADBUTLERID`,
  1 AS `OXAFFILINETID`,
  1 AS `OXSUPERCLICKSID`,
  1 AS `OXAFFILIWELTID`,
  1 AS `OXAFFILI24ID`,
  1 AS `OXEDITION`,
  1 AS `OXVERSION`,
  1 AS `OXSEOACTIVE`,
  1 AS `OXTIMESTAMP`,
  1 AS `OXSERIAL` */;

--
-- Temporary table structure for view `oxv_oxshops_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxshops_en`*/;
/*!50001 CREATE VIEW `oxv_oxshops_en` AS SELECT
 1 AS `OXID`,
  1 AS `OXPARENTID`,
  1 AS `OXACTIVE`,
  1 AS `OXISINHERITED`,
  1 AS `OXISMULTISHOP`,
  1 AS `OXISSUPERSHOP`,
  1 AS `OXPRODUCTIVE`,
  1 AS `OXDEFCURRENCY`,
  1 AS `OXDEFLANGUAGE`,
  1 AS `OXNAME`,
  1 AS `OXTITLEPREFIX`,
  1 AS `OXTITLESUFFIX`,
  1 AS `OXSTARTTITLE`,
  1 AS `OXINFOEMAIL`,
  1 AS `OXORDEREMAIL`,
  1 AS `OXOWNEREMAIL`,
  1 AS `OXORDERSUBJECT`,
  1 AS `OXREGISTERSUBJECT`,
  1 AS `OXFORGOTPWDSUBJECT`,
  1 AS `OXSENDEDNOWSUBJECT`,
  1 AS `OXSMTP`,
  1 AS `OXSMTPUSER`,
  1 AS `OXSMTPPWD`,
  1 AS `OXCOMPANY`,
  1 AS `OXSTREET`,
  1 AS `OXZIP`,
  1 AS `OXCITY`,
  1 AS `OXCOUNTRY`,
  1 AS `OXBANKNAME`,
  1 AS `OXBANKNUMBER`,
  1 AS `OXBANKCODE`,
  1 AS `OXVATNUMBER`,
  1 AS `OXTAXNUMBER`,
  1 AS `OXBICCODE`,
  1 AS `OXIBANNUMBER`,
  1 AS `OXFNAME`,
  1 AS `OXLNAME`,
  1 AS `OXTELEFON`,
  1 AS `OXTELEFAX`,
  1 AS `OXURL`,
  1 AS `OXDEFCAT`,
  1 AS `OXHRBNR`,
  1 AS `OXCOURT`,
  1 AS `OXADBUTLERID`,
  1 AS `OXAFFILINETID`,
  1 AS `OXSUPERCLICKSID`,
  1 AS `OXAFFILIWELTID`,
  1 AS `OXAFFILI24ID`,
  1 AS `OXEDITION`,
  1 AS `OXVERSION`,
  1 AS `OXSEOACTIVE`,
  1 AS `OXTIMESTAMP`,
  1 AS `OXSERIAL` */;

--
-- Temporary table structure for view `oxv_oxstates`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxstates`*/;
/*!50001 CREATE VIEW `oxv_oxstates` AS SELECT
 1 AS `OXID`,
  1 AS `OXCOUNTRYID`,
  1 AS `OXTITLE`,
  1 AS `OXISOALPHA2`,
  1 AS `OXTITLE_1`,
  1 AS `OXTITLE_2`,
  1 AS `OXTITLE_3`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxstates_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxstates_de`*/;
/*!50001 CREATE VIEW `oxv_oxstates_de` AS SELECT
 1 AS `OXID`,
  1 AS `OXCOUNTRYID`,
  1 AS `OXTITLE`,
  1 AS `OXISOALPHA2`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxstates_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxstates_en`*/;
/*!50001 CREATE VIEW `oxv_oxstates_en` AS SELECT
 1 AS `OXID`,
  1 AS `OXCOUNTRYID`,
  1 AS `OXTITLE`,
  1 AS `OXISOALPHA2`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxvendor`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxvendor`*/;
/*!50001 CREATE VIEW `oxv_oxvendor` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXICON`,
  1 AS `OXTITLE`,
  1 AS `OXSHORTDESC`,
  1 AS `OXTITLE_1`,
  1 AS `OXSHORTDESC_1`,
  1 AS `OXTITLE_2`,
  1 AS `OXSHORTDESC_2`,
  1 AS `OXTITLE_3`,
  1 AS `OXSHORTDESC_3`,
  1 AS `OXSHOWSUFFIX`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxvendor_1`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxvendor_1`*/;
/*!50001 CREATE VIEW `oxv_oxvendor_1` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXICON`,
  1 AS `OXTITLE`,
  1 AS `OXSHORTDESC`,
  1 AS `OXTITLE_1`,
  1 AS `OXSHORTDESC_1`,
  1 AS `OXTITLE_2`,
  1 AS `OXSHORTDESC_2`,
  1 AS `OXTITLE_3`,
  1 AS `OXSHORTDESC_3`,
  1 AS `OXSHOWSUFFIX`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxvendor_1_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxvendor_1_de`*/;
/*!50001 CREATE VIEW `oxv_oxvendor_1_de` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXICON`,
  1 AS `OXTITLE`,
  1 AS `OXSHORTDESC`,
  1 AS `OXSHOWSUFFIX`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxvendor_1_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxvendor_1_en`*/;
/*!50001 CREATE VIEW `oxv_oxvendor_1_en` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXICON`,
  1 AS `OXTITLE`,
  1 AS `OXSHORTDESC`,
  1 AS `OXSHOWSUFFIX`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxvendor_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxvendor_de`*/;
/*!50001 CREATE VIEW `oxv_oxvendor_de` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXICON`,
  1 AS `OXTITLE`,
  1 AS `OXSHORTDESC`,
  1 AS `OXSHOWSUFFIX`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxvendor_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxvendor_en`*/;
/*!50001 CREATE VIEW `oxv_oxvendor_en` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXICON`,
  1 AS `OXTITLE`,
  1 AS `OXSHORTDESC`,
  1 AS `OXSHOWSUFFIX`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxvoucherseries`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxvoucherseries`*/;
/*!50001 CREATE VIEW `oxv_oxvoucherseries` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXSERIENR`,
  1 AS `OXSERIEDESCRIPTION`,
  1 AS `OXDISCOUNT`,
  1 AS `OXDISCOUNTTYPE`,
  1 AS `OXBEGINDATE`,
  1 AS `OXENDDATE`,
  1 AS `OXALLOWSAMESERIES`,
  1 AS `OXALLOWOTHERSERIES`,
  1 AS `OXALLOWUSEANOTHER`,
  1 AS `OXMINIMUMVALUE`,
  1 AS `OXCALCULATEONCE`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxvoucherseries_1`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxvoucherseries_1`*/;
/*!50001 CREATE VIEW `oxv_oxvoucherseries_1` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXSERIENR`,
  1 AS `OXSERIEDESCRIPTION`,
  1 AS `OXDISCOUNT`,
  1 AS `OXDISCOUNTTYPE`,
  1 AS `OXBEGINDATE`,
  1 AS `OXENDDATE`,
  1 AS `OXALLOWSAMESERIES`,
  1 AS `OXALLOWOTHERSERIES`,
  1 AS `OXALLOWUSEANOTHER`,
  1 AS `OXMINIMUMVALUE`,
  1 AS `OXCALCULATEONCE`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxwrapping`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxwrapping`*/;
/*!50001 CREATE VIEW `oxv_oxwrapping` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXACTIVE_1`,
  1 AS `OXACTIVE_2`,
  1 AS `OXACTIVE_3`,
  1 AS `OXTYPE`,
  1 AS `OXNAME`,
  1 AS `OXNAME_1`,
  1 AS `OXNAME_2`,
  1 AS `OXNAME_3`,
  1 AS `OXPIC`,
  1 AS `OXPRICE`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxwrapping_1`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxwrapping_1`*/;
/*!50001 CREATE VIEW `oxv_oxwrapping_1` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXACTIVE_1`,
  1 AS `OXACTIVE_2`,
  1 AS `OXACTIVE_3`,
  1 AS `OXTYPE`,
  1 AS `OXNAME`,
  1 AS `OXNAME_1`,
  1 AS `OXNAME_2`,
  1 AS `OXNAME_3`,
  1 AS `OXPIC`,
  1 AS `OXPRICE`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxwrapping_1_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxwrapping_1_de`*/;
/*!50001 CREATE VIEW `oxv_oxwrapping_1_de` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXTYPE`,
  1 AS `OXNAME`,
  1 AS `OXPIC`,
  1 AS `OXPRICE`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxwrapping_1_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxwrapping_1_en`*/;
/*!50001 CREATE VIEW `oxv_oxwrapping_1_en` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXTYPE`,
  1 AS `OXNAME`,
  1 AS `OXPIC`,
  1 AS `OXPRICE`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxwrapping_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxwrapping_de`*/;
/*!50001 CREATE VIEW `oxv_oxwrapping_de` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXTYPE`,
  1 AS `OXNAME`,
  1 AS `OXPIC`,
  1 AS `OXPRICE`,
  1 AS `OXTIMESTAMP` */;

--
-- Temporary table structure for view `oxv_oxwrapping_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxwrapping_en`*/;
/*!50001 CREATE VIEW `oxv_oxwrapping_en` AS SELECT
 1 AS `OXID`,
  1 AS `OXMAPID`,
  1 AS `OXSHOPID`,
  1 AS `OXACTIVE`,
  1 AS `OXTYPE`,
  1 AS `OXNAME`,
  1 AS `OXPIC`,
  1 AS `OXPRICE`,
  1 AS `OXTIMESTAMP` */;

--
-- Table structure for table `oxvendor`
--

CREATE TABLE `oxvendor` (
  `OXID` char(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Vendor id',
  `OXMAPID` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Integer mapping identifier',
  `OXSHOPID` int(11) NOT NULL DEFAULT 1 COMMENT 'Shop id (oxshops)',
  `OXACTIVE` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Active',
  `OXICON` varchar(128) NOT NULL DEFAULT '' COMMENT 'Icon filename',
  `OXTITLE` varchar(255) NOT NULL DEFAULT '' COMMENT 'Title (multilanguage)',
  `OXSHORTDESC` varchar(255) NOT NULL DEFAULT '' COMMENT 'Short description (multilanguage)',
  `OXTITLE_1` varchar(255) NOT NULL DEFAULT '',
  `OXSHORTDESC_1` varchar(255) NOT NULL DEFAULT '',
  `OXTITLE_2` varchar(255) NOT NULL DEFAULT '',
  `OXSHORTDESC_2` varchar(255) NOT NULL DEFAULT '',
  `OXTITLE_3` varchar(255) NOT NULL DEFAULT '',
  `OXSHORTDESC_3` varchar(255) NOT NULL DEFAULT '',
  `OXSHOWSUFFIX` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Show SEO Suffix in Category',
  `OXTIMESTAMP` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Timestamp',
  PRIMARY KEY (`OXID`),
  KEY `OXACTIVE` (`OXACTIVE`),
  KEY `OXMAPID` (`OXMAPID`),
  KEY `OXSHOPID` (`OXSHOPID`)
) ENGINE=InnoDB AUTO_INCREMENT=903 DEFAULT CHARSET=utf8mb3 COMMENT='Distributors list';

--
-- Dumping data for table `oxvendor`
--

INSERT INTO `oxvendor` VALUES
('a57c56e3ba710eafb2225e98f058d989',902,1,1,'','www.true-fashion.com','Ethical style outlet','www.true-fashion.com','Ethical style outlet','','','','',0,'2016-07-19 14:38:26');

--
-- Table structure for table `oxvendor2shop`
--

CREATE TABLE `oxvendor2shop` (
  `OXSHOPID` int(11) NOT NULL COMMENT 'Mapped shop id',
  `OXMAPOBJECTID` int(11) NOT NULL COMMENT 'Mapped object id',
  `OXTIMESTAMP` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Timestamp',
  UNIQUE KEY `OXMAPIDX` (`OXSHOPID`,`OXMAPOBJECTID`),
  KEY `OXMAPOBJECTID` (`OXMAPOBJECTID`),
  KEY `OXSHOPID` (`OXSHOPID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Mapping table for element subshop assignments';

--
-- Dumping data for table `oxvendor2shop`
--

INSERT INTO `oxvendor2shop` VALUES
(1,901,'2016-07-19 14:38:26'),
(1,902,'2016-07-19 14:38:26');

--
-- Table structure for table `oxvouchers`
--

CREATE TABLE `oxvouchers` (
  `OXDATEUSED` date DEFAULT NULL COMMENT 'Date, when coupon was used (set on order complete)',
  `OXORDERID` char(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '' COMMENT 'Order id (oxorder)',
  `OXUSERID` char(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '' COMMENT 'User id (oxuser)',
  `OXRESERVED` int(11) NOT NULL DEFAULT 0 COMMENT 'Time, when coupon is added to basket',
  `OXVOUCHERNR` varchar(255) NOT NULL DEFAULT '' COMMENT 'Coupon number',
  `OXVOUCHERSERIEID` char(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '' COMMENT 'Coupon Series id (oxvoucherseries)',
  `OXDISCOUNT` float(9,2) DEFAULT NULL COMMENT 'Discounted amount (if discount was used)',
  `OXID` char(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '' COMMENT 'Coupon id',
  `OXTIMESTAMP` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Timestamp',
  PRIMARY KEY (`OXID`),
  KEY `OXVOUCHERSERIEID` (`OXVOUCHERSERIEID`),
  KEY `OXORDERID` (`OXORDERID`),
  KEY `OXUSERID` (`OXUSERID`),
  KEY `OXVOUCHERNR` (`OXVOUCHERNR`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Generated coupons';

--
-- Dumping data for table `oxvouchers`
--


--
-- Table structure for table `oxvoucherseries`
--

CREATE TABLE `oxvoucherseries` (
  `OXID` char(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '' COMMENT 'Series id',
  `OXMAPID` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Integer mapping identifier',
  `OXSHOPID` int(11) NOT NULL DEFAULT 1 COMMENT 'Shop id (oxshops)',
  `OXSERIENR` varchar(255) NOT NULL DEFAULT '' COMMENT 'Series name',
  `OXSERIEDESCRIPTION` varchar(255) NOT NULL DEFAULT '' COMMENT 'Description',
  `OXDISCOUNT` float(9,2) NOT NULL DEFAULT 0.00 COMMENT 'Discount amount',
  `OXDISCOUNTTYPE` enum('percent','absolute') NOT NULL DEFAULT 'absolute' COMMENT 'Discount type (percent, absolute)',
  `OXBEGINDATE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Valid from',
  `OXENDDATE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Valid to',
  `OXALLOWSAMESERIES` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Coupons of this series can be used with single order',
  `OXALLOWOTHERSERIES` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Coupons of different series can be used with single order',
  `OXALLOWUSEANOTHER` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Coupons of this series can be used in multiple orders',
  `OXMINIMUMVALUE` float(9,2) NOT NULL DEFAULT 0.00 COMMENT 'Minimum Order Sum ',
  `OXCALCULATEONCE` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Calculate only once (valid only for product or category vouchers)',
  `OXTIMESTAMP` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Timestamp',
  PRIMARY KEY (`OXID`),
  KEY `OXSERIENR` (`OXSERIENR`),
  KEY `OXSHOPID` (`OXSHOPID`),
  KEY `OXMAPID` (`OXMAPID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Coupon series';

--
-- Dumping data for table `oxvoucherseries`
--


--
-- Table structure for table `oxvoucherseries2shop`
--

CREATE TABLE `oxvoucherseries2shop` (
  `OXSHOPID` int(11) NOT NULL COMMENT 'Mapped shop id',
  `OXMAPOBJECTID` int(11) NOT NULL COMMENT 'Mapped object id',
  `OXTIMESTAMP` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Timestamp',
  UNIQUE KEY `OXMAPIDX` (`OXSHOPID`,`OXMAPOBJECTID`),
  KEY `OXMAPOBJECTID` (`OXMAPOBJECTID`),
  KEY `OXSHOPID` (`OXSHOPID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Mapping table for element subshop assignments';

--
-- Dumping data for table `oxvoucherseries2shop`
--


--
-- Table structure for table `oxwrapping`
--

CREATE TABLE `oxwrapping` (
  `OXID` char(32) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL COMMENT 'Wrapping id',
  `OXMAPID` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Integer mapping identifier',
  `OXSHOPID` int(11) NOT NULL DEFAULT 1 COMMENT 'Shop id (oxshops)',
  `OXACTIVE` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Active (multilanguage)',
  `OXACTIVE_1` tinyint(1) NOT NULL DEFAULT 1,
  `OXACTIVE_2` tinyint(1) NOT NULL DEFAULT 1,
  `OXACTIVE_3` tinyint(1) NOT NULL DEFAULT 1,
  `OXTYPE` varchar(4) NOT NULL DEFAULT 'WRAP' COMMENT 'Wrapping type: WRAP,CARD',
  `OXNAME` varchar(128) NOT NULL DEFAULT '' COMMENT 'Name (multilanguage)',
  `OXNAME_1` varchar(128) NOT NULL DEFAULT '',
  `OXNAME_2` varchar(128) NOT NULL DEFAULT '',
  `OXNAME_3` varchar(128) NOT NULL DEFAULT '',
  `OXPIC` varchar(128) NOT NULL DEFAULT '' COMMENT 'Image filename',
  `OXPRICE` double NOT NULL DEFAULT 0 COMMENT 'Price',
  `OXTIMESTAMP` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Timestamp',
  PRIMARY KEY (`OXID`),
  KEY `OXMAPID` (`OXMAPID`),
  KEY `OXSHOPID` (`OXSHOPID`)
) ENGINE=InnoDB AUTO_INCREMENT=905 DEFAULT CHARSET=utf8mb3 COMMENT='Wrappings';

--
-- Dumping data for table `oxwrapping`
--

INSERT INTO `oxwrapping` VALUES
('81b40cf076351c229.14252649',902,1,1,1,0,1,'CARD','Die Bombe','The bomb','','','desaster_wp.gif',2.5,'2016-07-19 14:38:26'),
('81b40cf0cd383d3a9.70988998',903,1,1,1,0,1,'CARD','Haifisch','Shark','','','img_ecard_03_wp.jpg',3,'2016-07-19 14:38:26'),
('81b40cf210343d625.49755120',904,1,1,1,0,1,'WRAP','Gelbe Sterne','Yellow stars','','','img_geschenkpapier_1_gelb_wp.gif',2.95,'2016-07-19 14:38:26'),
('a6840cc0ec80b3991.74884864',901,1,1,1,0,1,'WRAP','Rote Sterne','Red stars','','','img_geschenkpapier_1_wp.gif',2.95,'2016-07-19 14:38:26');

--
-- Table structure for table `oxwrapping2shop`
--

CREATE TABLE `oxwrapping2shop` (
  `OXSHOPID` int(11) NOT NULL COMMENT 'Mapped shop id',
  `OXMAPOBJECTID` int(11) NOT NULL COMMENT 'Mapped object id',
  `OXTIMESTAMP` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Timestamp',
  UNIQUE KEY `OXMAPIDX` (`OXSHOPID`,`OXMAPOBJECTID`),
  KEY `OXMAPOBJECTID` (`OXMAPOBJECTID`),
  KEY `OXSHOPID` (`OXSHOPID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Mapping table for element subshop assignments';

--
-- Dumping data for table `oxwrapping2shop`
--

INSERT INTO `oxwrapping2shop` VALUES
(1,901,'2016-07-19 14:38:26'),
(1,902,'2016-07-19 14:38:26'),
(1,903,'2016-07-19 14:38:26'),
(1,904,'2016-07-19 14:38:26');

--
-- Final view structure for view `oxv_oxactions`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxactions`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxactions` AS select `oxactions`.`OXID` AS `OXID`,`oxactions`.`OXSHOPID` AS `OXSHOPID`,`oxactions`.`OXTYPE` AS `OXTYPE`,`oxactions`.`OXTITLE` AS `OXTITLE`,`oxactions`.`OXTITLE_1` AS `OXTITLE_1`,`oxactions`.`OXTITLE_2` AS `OXTITLE_2`,`oxactions`.`OXTITLE_3` AS `OXTITLE_3`,`oxactions`.`OXLONGDESC` AS `OXLONGDESC`,`oxactions`.`OXLONGDESC_1` AS `OXLONGDESC_1`,`oxactions`.`OXLONGDESC_2` AS `OXLONGDESC_2`,`oxactions`.`OXLONGDESC_3` AS `OXLONGDESC_3`,`oxactions`.`OXACTIVE` AS `OXACTIVE`,`oxactions`.`OXACTIVEFROM` AS `OXACTIVEFROM`,`oxactions`.`OXACTIVETO` AS `OXACTIVETO`,`oxactions`.`OXPIC` AS `OXPIC`,`oxactions`.`OXPIC_1` AS `OXPIC_1`,`oxactions`.`OXPIC_2` AS `OXPIC_2`,`oxactions`.`OXPIC_3` AS `OXPIC_3`,`oxactions`.`OXLINK` AS `OXLINK`,`oxactions`.`OXLINK_1` AS `OXLINK_1`,`oxactions`.`OXLINK_2` AS `OXLINK_2`,`oxactions`.`OXLINK_3` AS `OXLINK_3`,`oxactions`.`OXSORT` AS `OXSORT`,`oxactions`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxactions` */;

--
-- Final view structure for view `oxv_oxactions_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxactions_de`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxactions_de` AS select `oxactions`.`OXID` AS `OXID`,`oxactions`.`OXSHOPID` AS `OXSHOPID`,`oxactions`.`OXTYPE` AS `OXTYPE`,`oxactions`.`OXTITLE` AS `OXTITLE`,`oxactions`.`OXLONGDESC` AS `OXLONGDESC`,`oxactions`.`OXACTIVE` AS `OXACTIVE`,`oxactions`.`OXACTIVEFROM` AS `OXACTIVEFROM`,`oxactions`.`OXACTIVETO` AS `OXACTIVETO`,`oxactions`.`OXPIC` AS `OXPIC`,`oxactions`.`OXLINK` AS `OXLINK`,`oxactions`.`OXSORT` AS `OXSORT`,`oxactions`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxactions` */;

--
-- Final view structure for view `oxv_oxactions_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxactions_en`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxactions_en` AS select `oxactions`.`OXID` AS `OXID`,`oxactions`.`OXSHOPID` AS `OXSHOPID`,`oxactions`.`OXTYPE` AS `OXTYPE`,`oxactions`.`OXTITLE_1` AS `OXTITLE`,`oxactions`.`OXLONGDESC_1` AS `OXLONGDESC`,`oxactions`.`OXACTIVE` AS `OXACTIVE`,`oxactions`.`OXACTIVEFROM` AS `OXACTIVEFROM`,`oxactions`.`OXACTIVETO` AS `OXACTIVETO`,`oxactions`.`OXPIC_1` AS `OXPIC`,`oxactions`.`OXLINK_1` AS `OXLINK`,`oxactions`.`OXSORT` AS `OXSORT`,`oxactions`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxactions` */;

--
-- Final view structure for view `oxv_oxartextends`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxartextends`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxartextends` AS select `oxartextends`.`OXID` AS `OXID`,`oxartextends`.`OXLONGDESC` AS `OXLONGDESC`,`oxartextends`.`OXLONGDESC_1` AS `OXLONGDESC_1`,`oxartextends`.`OXLONGDESC_2` AS `OXLONGDESC_2`,`oxartextends`.`OXLONGDESC_3` AS `OXLONGDESC_3`,`oxartextends`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxartextends` */;

--
-- Final view structure for view `oxv_oxartextends_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxartextends_de`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxartextends_de` AS select `oxartextends`.`OXID` AS `OXID`,`oxartextends`.`OXLONGDESC` AS `OXLONGDESC`,`oxartextends`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxartextends` */;

--
-- Final view structure for view `oxv_oxartextends_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxartextends_en`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxartextends_en` AS select `oxartextends`.`OXID` AS `OXID`,`oxartextends`.`OXLONGDESC_1` AS `OXLONGDESC`,`oxartextends`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxartextends` */;

--
-- Final view structure for view `oxv_oxarticles`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxarticles`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxarticles` AS select `oxarticles`.`OXID` AS `OXID`,`oxarticles`.`OXMAPID` AS `OXMAPID`,`oxarticles`.`OXSHOPID` AS `OXSHOPID`,`oxarticles`.`OXPARENTID` AS `OXPARENTID`,`oxarticles`.`OXACTIVE` AS `OXACTIVE`,`oxarticles`.`OXHIDDEN` AS `OXHIDDEN`,`oxarticles`.`OXACTIVEFROM` AS `OXACTIVEFROM`,`oxarticles`.`OXACTIVETO` AS `OXACTIVETO`,`oxarticles`.`OXARTNUM` AS `OXARTNUM`,`oxarticles`.`OXEAN` AS `OXEAN`,`oxarticles`.`OXDISTEAN` AS `OXDISTEAN`,`oxarticles`.`OXMPN` AS `OXMPN`,`oxarticles`.`OXTITLE` AS `OXTITLE`,`oxarticles`.`OXSHORTDESC` AS `OXSHORTDESC`,`oxarticles`.`OXPRICE` AS `OXPRICE`,`oxarticles`.`OXBLFIXEDPRICE` AS `OXBLFIXEDPRICE`,`oxarticles`.`OXPRICEA` AS `OXPRICEA`,`oxarticles`.`OXPRICEB` AS `OXPRICEB`,`oxarticles`.`OXPRICEC` AS `OXPRICEC`,`oxarticles`.`OXBPRICE` AS `OXBPRICE`,`oxarticles`.`OXTPRICE` AS `OXTPRICE`,`oxarticles`.`OXUNITNAME` AS `OXUNITNAME`,`oxarticles`.`OXUNITQUANTITY` AS `OXUNITQUANTITY`,`oxarticles`.`OXEXTURL` AS `OXEXTURL`,`oxarticles`.`OXURLDESC` AS `OXURLDESC`,`oxarticles`.`OXURLIMG` AS `OXURLIMG`,`oxarticles`.`OXVAT` AS `OXVAT`,`oxarticles`.`OXTHUMB` AS `OXTHUMB`,`oxarticles`.`OXICON` AS `OXICON`,`oxarticles`.`OXPIC1` AS `OXPIC1`,`oxarticles`.`OXPIC2` AS `OXPIC2`,`oxarticles`.`OXPIC3` AS `OXPIC3`,`oxarticles`.`OXPIC4` AS `OXPIC4`,`oxarticles`.`OXPIC5` AS `OXPIC5`,`oxarticles`.`OXPIC6` AS `OXPIC6`,`oxarticles`.`OXPIC7` AS `OXPIC7`,`oxarticles`.`OXPIC8` AS `OXPIC8`,`oxarticles`.`OXPIC9` AS `OXPIC9`,`oxarticles`.`OXPIC10` AS `OXPIC10`,`oxarticles`.`OXPIC11` AS `OXPIC11`,`oxarticles`.`OXPIC12` AS `OXPIC12`,`oxarticles`.`OXWEIGHT` AS `OXWEIGHT`,`oxarticles`.`OXSTOCK` AS `OXSTOCK`,`oxarticles`.`OXSTOCKFLAG` AS `OXSTOCKFLAG`,`oxarticles`.`OXSTOCKTEXT` AS `OXSTOCKTEXT`,`oxarticles`.`OXNOSTOCKTEXT` AS `OXNOSTOCKTEXT`,`oxarticles`.`OXDELIVERY` AS `OXDELIVERY`,`oxarticles`.`OXINSERT` AS `OXINSERT`,`oxarticles`.`OXTIMESTAMP` AS `OXTIMESTAMP`,`oxarticles`.`OXLENGTH` AS `OXLENGTH`,`oxarticles`.`OXWIDTH` AS `OXWIDTH`,`oxarticles`.`OXHEIGHT` AS `OXHEIGHT`,`oxarticles`.`OXFILE` AS `OXFILE`,`oxarticles`.`OXSEARCHKEYS` AS `OXSEARCHKEYS`,`oxarticles`.`OXTEMPLATE` AS `OXTEMPLATE`,`oxarticles`.`OXQUESTIONEMAIL` AS `OXQUESTIONEMAIL`,`oxarticles`.`OXISSEARCH` AS `OXISSEARCH`,`oxarticles`.`OXISCONFIGURABLE` AS `OXISCONFIGURABLE`,`oxarticles`.`OXVARNAME` AS `OXVARNAME`,`oxarticles`.`OXVARSTOCK` AS `OXVARSTOCK`,`oxarticles`.`OXVARCOUNT` AS `OXVARCOUNT`,`oxarticles`.`OXVARSELECT` AS `OXVARSELECT`,`oxarticles`.`OXVARMINPRICE` AS `OXVARMINPRICE`,`oxarticles`.`OXVARMAXPRICE` AS `OXVARMAXPRICE`,`oxarticles`.`OXVARNAME_1` AS `OXVARNAME_1`,`oxarticles`.`OXVARSELECT_1` AS `OXVARSELECT_1`,`oxarticles`.`OXVARNAME_2` AS `OXVARNAME_2`,`oxarticles`.`OXVARSELECT_2` AS `OXVARSELECT_2`,`oxarticles`.`OXVARNAME_3` AS `OXVARNAME_3`,`oxarticles`.`OXVARSELECT_3` AS `OXVARSELECT_3`,`oxarticles`.`OXTITLE_1` AS `OXTITLE_1`,`oxarticles`.`OXSHORTDESC_1` AS `OXSHORTDESC_1`,`oxarticles`.`OXURLDESC_1` AS `OXURLDESC_1`,`oxarticles`.`OXSEARCHKEYS_1` AS `OXSEARCHKEYS_1`,`oxarticles`.`OXTITLE_2` AS `OXTITLE_2`,`oxarticles`.`OXSHORTDESC_2` AS `OXSHORTDESC_2`,`oxarticles`.`OXURLDESC_2` AS `OXURLDESC_2`,`oxarticles`.`OXSEARCHKEYS_2` AS `OXSEARCHKEYS_2`,`oxarticles`.`OXTITLE_3` AS `OXTITLE_3`,`oxarticles`.`OXSHORTDESC_3` AS `OXSHORTDESC_3`,`oxarticles`.`OXURLDESC_3` AS `OXURLDESC_3`,`oxarticles`.`OXSEARCHKEYS_3` AS `OXSEARCHKEYS_3`,`oxarticles`.`OXBUNDLEID` AS `OXBUNDLEID`,`oxarticles`.`OXFOLDER` AS `OXFOLDER`,`oxarticles`.`OXSUBCLASS` AS `OXSUBCLASS`,`oxarticles`.`OXSTOCKTEXT_1` AS `OXSTOCKTEXT_1`,`oxarticles`.`OXSTOCKTEXT_2` AS `OXSTOCKTEXT_2`,`oxarticles`.`OXSTOCKTEXT_3` AS `OXSTOCKTEXT_3`,`oxarticles`.`OXNOSTOCKTEXT_1` AS `OXNOSTOCKTEXT_1`,`oxarticles`.`OXNOSTOCKTEXT_2` AS `OXNOSTOCKTEXT_2`,`oxarticles`.`OXNOSTOCKTEXT_3` AS `OXNOSTOCKTEXT_3`,`oxarticles`.`OXSORT` AS `OXSORT`,`oxarticles`.`OXSOLDAMOUNT` AS `OXSOLDAMOUNT`,`oxarticles`.`OXNONMATERIAL` AS `OXNONMATERIAL`,`oxarticles`.`OXFREESHIPPING` AS `OXFREESHIPPING`,`oxarticles`.`OXREMINDACTIVE` AS `OXREMINDACTIVE`,`oxarticles`.`OXREMINDAMOUNT` AS `OXREMINDAMOUNT`,`oxarticles`.`OXAMITEMID` AS `OXAMITEMID`,`oxarticles`.`OXAMTASKID` AS `OXAMTASKID`,`oxarticles`.`OXVENDORID` AS `OXVENDORID`,`oxarticles`.`OXMANUFACTURERID` AS `OXMANUFACTURERID`,`oxarticles`.`OXSKIPDISCOUNTS` AS `OXSKIPDISCOUNTS`,`oxarticles`.`OXORDERINFO` AS `OXORDERINFO`,`oxarticles`.`OXPIXIEXPORT` AS `OXPIXIEXPORT`,`oxarticles`.`OXPIXIEXPORTED` AS `OXPIXIEXPORTED`,`oxarticles`.`OXVPE` AS `OXVPE`,`oxarticles`.`OXRATING` AS `OXRATING`,`oxarticles`.`OXRATINGCNT` AS `OXRATINGCNT`,`oxarticles`.`OXMINDELTIME` AS `OXMINDELTIME`,`oxarticles`.`OXMAXDELTIME` AS `OXMAXDELTIME`,`oxarticles`.`OXDELTIMEUNIT` AS `OXDELTIMEUNIT`,`oxarticles`.`OXUPDATEPRICE` AS `OXUPDATEPRICE`,`oxarticles`.`OXUPDATEPRICEA` AS `OXUPDATEPRICEA`,`oxarticles`.`OXUPDATEPRICEB` AS `OXUPDATEPRICEB`,`oxarticles`.`OXUPDATEPRICEC` AS `OXUPDATEPRICEC`,`oxarticles`.`OXUPDATEPRICETIME` AS `OXUPDATEPRICETIME`,`oxarticles`.`OXISDOWNLOADABLE` AS `OXISDOWNLOADABLE`,`oxarticles`.`OXSHOWCUSTOMAGREEMENT` AS `OXSHOWCUSTOMAGREEMENT` from `oxarticles` */;

--
-- Final view structure for view `oxv_oxarticles_1`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxarticles_1`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxarticles_1` AS select `oxarticles`.`OXID` AS `OXID`,`oxarticles`.`OXMAPID` AS `OXMAPID`,`oxarticles`.`OXSHOPID` AS `OXSHOPID`,`oxarticles`.`OXPARENTID` AS `OXPARENTID`,`oxarticles`.`OXACTIVE` AS `OXACTIVE`,`oxarticles`.`OXHIDDEN` AS `OXHIDDEN`,`oxarticles`.`OXACTIVEFROM` AS `OXACTIVEFROM`,`oxarticles`.`OXACTIVETO` AS `OXACTIVETO`,`oxarticles`.`OXARTNUM` AS `OXARTNUM`,`oxarticles`.`OXEAN` AS `OXEAN`,`oxarticles`.`OXDISTEAN` AS `OXDISTEAN`,`oxarticles`.`OXMPN` AS `OXMPN`,`oxarticles`.`OXTITLE` AS `OXTITLE`,`oxarticles`.`OXSHORTDESC` AS `OXSHORTDESC`,`oxarticles`.`OXPRICE` AS `OXPRICE`,`oxarticles`.`OXBLFIXEDPRICE` AS `OXBLFIXEDPRICE`,`oxarticles`.`OXPRICEA` AS `OXPRICEA`,`oxarticles`.`OXPRICEB` AS `OXPRICEB`,`oxarticles`.`OXPRICEC` AS `OXPRICEC`,`oxarticles`.`OXBPRICE` AS `OXBPRICE`,`oxarticles`.`OXTPRICE` AS `OXTPRICE`,`oxarticles`.`OXUNITNAME` AS `OXUNITNAME`,`oxarticles`.`OXUNITQUANTITY` AS `OXUNITQUANTITY`,`oxarticles`.`OXEXTURL` AS `OXEXTURL`,`oxarticles`.`OXURLDESC` AS `OXURLDESC`,`oxarticles`.`OXURLIMG` AS `OXURLIMG`,`oxarticles`.`OXVAT` AS `OXVAT`,`oxarticles`.`OXTHUMB` AS `OXTHUMB`,`oxarticles`.`OXICON` AS `OXICON`,`oxarticles`.`OXPIC1` AS `OXPIC1`,`oxarticles`.`OXPIC2` AS `OXPIC2`,`oxarticles`.`OXPIC3` AS `OXPIC3`,`oxarticles`.`OXPIC4` AS `OXPIC4`,`oxarticles`.`OXPIC5` AS `OXPIC5`,`oxarticles`.`OXPIC6` AS `OXPIC6`,`oxarticles`.`OXPIC7` AS `OXPIC7`,`oxarticles`.`OXPIC8` AS `OXPIC8`,`oxarticles`.`OXPIC9` AS `OXPIC9`,`oxarticles`.`OXPIC10` AS `OXPIC10`,`oxarticles`.`OXPIC11` AS `OXPIC11`,`oxarticles`.`OXPIC12` AS `OXPIC12`,`oxarticles`.`OXWEIGHT` AS `OXWEIGHT`,`oxarticles`.`OXSTOCK` AS `OXSTOCK`,`oxarticles`.`OXSTOCKFLAG` AS `OXSTOCKFLAG`,`oxarticles`.`OXSTOCKTEXT` AS `OXSTOCKTEXT`,`oxarticles`.`OXNOSTOCKTEXT` AS `OXNOSTOCKTEXT`,`oxarticles`.`OXDELIVERY` AS `OXDELIVERY`,`oxarticles`.`OXINSERT` AS `OXINSERT`,`oxarticles`.`OXTIMESTAMP` AS `OXTIMESTAMP`,`oxarticles`.`OXLENGTH` AS `OXLENGTH`,`oxarticles`.`OXWIDTH` AS `OXWIDTH`,`oxarticles`.`OXHEIGHT` AS `OXHEIGHT`,`oxarticles`.`OXFILE` AS `OXFILE`,`oxarticles`.`OXSEARCHKEYS` AS `OXSEARCHKEYS`,`oxarticles`.`OXTEMPLATE` AS `OXTEMPLATE`,`oxarticles`.`OXQUESTIONEMAIL` AS `OXQUESTIONEMAIL`,`oxarticles`.`OXISSEARCH` AS `OXISSEARCH`,`oxarticles`.`OXISCONFIGURABLE` AS `OXISCONFIGURABLE`,`oxarticles`.`OXVARNAME` AS `OXVARNAME`,`oxarticles`.`OXVARSTOCK` AS `OXVARSTOCK`,`oxarticles`.`OXVARCOUNT` AS `OXVARCOUNT`,`oxarticles`.`OXVARSELECT` AS `OXVARSELECT`,`oxarticles`.`OXVARMINPRICE` AS `OXVARMINPRICE`,`oxarticles`.`OXVARMAXPRICE` AS `OXVARMAXPRICE`,`oxarticles`.`OXVARNAME_1` AS `OXVARNAME_1`,`oxarticles`.`OXVARSELECT_1` AS `OXVARSELECT_1`,`oxarticles`.`OXVARNAME_2` AS `OXVARNAME_2`,`oxarticles`.`OXVARSELECT_2` AS `OXVARSELECT_2`,`oxarticles`.`OXVARNAME_3` AS `OXVARNAME_3`,`oxarticles`.`OXVARSELECT_3` AS `OXVARSELECT_3`,`oxarticles`.`OXTITLE_1` AS `OXTITLE_1`,`oxarticles`.`OXSHORTDESC_1` AS `OXSHORTDESC_1`,`oxarticles`.`OXURLDESC_1` AS `OXURLDESC_1`,`oxarticles`.`OXSEARCHKEYS_1` AS `OXSEARCHKEYS_1`,`oxarticles`.`OXTITLE_2` AS `OXTITLE_2`,`oxarticles`.`OXSHORTDESC_2` AS `OXSHORTDESC_2`,`oxarticles`.`OXURLDESC_2` AS `OXURLDESC_2`,`oxarticles`.`OXSEARCHKEYS_2` AS `OXSEARCHKEYS_2`,`oxarticles`.`OXTITLE_3` AS `OXTITLE_3`,`oxarticles`.`OXSHORTDESC_3` AS `OXSHORTDESC_3`,`oxarticles`.`OXURLDESC_3` AS `OXURLDESC_3`,`oxarticles`.`OXSEARCHKEYS_3` AS `OXSEARCHKEYS_3`,`oxarticles`.`OXBUNDLEID` AS `OXBUNDLEID`,`oxarticles`.`OXFOLDER` AS `OXFOLDER`,`oxarticles`.`OXSUBCLASS` AS `OXSUBCLASS`,`oxarticles`.`OXSTOCKTEXT_1` AS `OXSTOCKTEXT_1`,`oxarticles`.`OXSTOCKTEXT_2` AS `OXSTOCKTEXT_2`,`oxarticles`.`OXSTOCKTEXT_3` AS `OXSTOCKTEXT_3`,`oxarticles`.`OXNOSTOCKTEXT_1` AS `OXNOSTOCKTEXT_1`,`oxarticles`.`OXNOSTOCKTEXT_2` AS `OXNOSTOCKTEXT_2`,`oxarticles`.`OXNOSTOCKTEXT_3` AS `OXNOSTOCKTEXT_3`,`oxarticles`.`OXSORT` AS `OXSORT`,`oxarticles`.`OXSOLDAMOUNT` AS `OXSOLDAMOUNT`,`oxarticles`.`OXNONMATERIAL` AS `OXNONMATERIAL`,`oxarticles`.`OXFREESHIPPING` AS `OXFREESHIPPING`,`oxarticles`.`OXREMINDACTIVE` AS `OXREMINDACTIVE`,`oxarticles`.`OXREMINDAMOUNT` AS `OXREMINDAMOUNT`,`oxarticles`.`OXAMITEMID` AS `OXAMITEMID`,`oxarticles`.`OXAMTASKID` AS `OXAMTASKID`,`oxarticles`.`OXVENDORID` AS `OXVENDORID`,`oxarticles`.`OXMANUFACTURERID` AS `OXMANUFACTURERID`,`oxarticles`.`OXSKIPDISCOUNTS` AS `OXSKIPDISCOUNTS`,`oxarticles`.`OXORDERINFO` AS `OXORDERINFO`,`oxarticles`.`OXPIXIEXPORT` AS `OXPIXIEXPORT`,`oxarticles`.`OXPIXIEXPORTED` AS `OXPIXIEXPORTED`,`oxarticles`.`OXVPE` AS `OXVPE`,`oxarticles`.`OXRATING` AS `OXRATING`,`oxarticles`.`OXRATINGCNT` AS `OXRATINGCNT`,`oxarticles`.`OXMINDELTIME` AS `OXMINDELTIME`,`oxarticles`.`OXMAXDELTIME` AS `OXMAXDELTIME`,`oxarticles`.`OXDELTIMEUNIT` AS `OXDELTIMEUNIT`,`oxarticles`.`OXUPDATEPRICE` AS `OXUPDATEPRICE`,`oxarticles`.`OXUPDATEPRICEA` AS `OXUPDATEPRICEA`,`oxarticles`.`OXUPDATEPRICEB` AS `OXUPDATEPRICEB`,`oxarticles`.`OXUPDATEPRICEC` AS `OXUPDATEPRICEC`,`oxarticles`.`OXUPDATEPRICETIME` AS `OXUPDATEPRICETIME`,`oxarticles`.`OXISDOWNLOADABLE` AS `OXISDOWNLOADABLE`,`oxarticles`.`OXSHOWCUSTOMAGREEMENT` AS `OXSHOWCUSTOMAGREEMENT` from (`oxarticles` join `oxarticles2shop` `t2s` on(`t2s`.`OXMAPOBJECTID` = `oxarticles`.`OXMAPID`)) where `t2s`.`OXSHOPID` = 1 */;

--
-- Final view structure for view `oxv_oxarticles_1_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxarticles_1_de`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxarticles_1_de` AS select `oxarticles`.`OXID` AS `OXID`,`oxarticles`.`OXMAPID` AS `OXMAPID`,`oxarticles`.`OXSHOPID` AS `OXSHOPID`,`oxarticles`.`OXPARENTID` AS `OXPARENTID`,`oxarticles`.`OXACTIVE` AS `OXACTIVE`,`oxarticles`.`OXHIDDEN` AS `OXHIDDEN`,`oxarticles`.`OXACTIVEFROM` AS `OXACTIVEFROM`,`oxarticles`.`OXACTIVETO` AS `OXACTIVETO`,`oxarticles`.`OXARTNUM` AS `OXARTNUM`,`oxarticles`.`OXEAN` AS `OXEAN`,`oxarticles`.`OXDISTEAN` AS `OXDISTEAN`,`oxarticles`.`OXMPN` AS `OXMPN`,`oxarticles`.`OXTITLE` AS `OXTITLE`,`oxarticles`.`OXSHORTDESC` AS `OXSHORTDESC`,`oxarticles`.`OXPRICE` AS `OXPRICE`,`oxarticles`.`OXBLFIXEDPRICE` AS `OXBLFIXEDPRICE`,`oxarticles`.`OXPRICEA` AS `OXPRICEA`,`oxarticles`.`OXPRICEB` AS `OXPRICEB`,`oxarticles`.`OXPRICEC` AS `OXPRICEC`,`oxarticles`.`OXBPRICE` AS `OXBPRICE`,`oxarticles`.`OXTPRICE` AS `OXTPRICE`,`oxarticles`.`OXUNITNAME` AS `OXUNITNAME`,`oxarticles`.`OXUNITQUANTITY` AS `OXUNITQUANTITY`,`oxarticles`.`OXEXTURL` AS `OXEXTURL`,`oxarticles`.`OXURLDESC` AS `OXURLDESC`,`oxarticles`.`OXURLIMG` AS `OXURLIMG`,`oxarticles`.`OXVAT` AS `OXVAT`,`oxarticles`.`OXTHUMB` AS `OXTHUMB`,`oxarticles`.`OXICON` AS `OXICON`,`oxarticles`.`OXPIC1` AS `OXPIC1`,`oxarticles`.`OXPIC2` AS `OXPIC2`,`oxarticles`.`OXPIC3` AS `OXPIC3`,`oxarticles`.`OXPIC4` AS `OXPIC4`,`oxarticles`.`OXPIC5` AS `OXPIC5`,`oxarticles`.`OXPIC6` AS `OXPIC6`,`oxarticles`.`OXPIC7` AS `OXPIC7`,`oxarticles`.`OXPIC8` AS `OXPIC8`,`oxarticles`.`OXPIC9` AS `OXPIC9`,`oxarticles`.`OXPIC10` AS `OXPIC10`,`oxarticles`.`OXPIC11` AS `OXPIC11`,`oxarticles`.`OXPIC12` AS `OXPIC12`,`oxarticles`.`OXWEIGHT` AS `OXWEIGHT`,`oxarticles`.`OXSTOCK` AS `OXSTOCK`,`oxarticles`.`OXSTOCKFLAG` AS `OXSTOCKFLAG`,`oxarticles`.`OXSTOCKTEXT` AS `OXSTOCKTEXT`,`oxarticles`.`OXNOSTOCKTEXT` AS `OXNOSTOCKTEXT`,`oxarticles`.`OXDELIVERY` AS `OXDELIVERY`,`oxarticles`.`OXINSERT` AS `OXINSERT`,`oxarticles`.`OXTIMESTAMP` AS `OXTIMESTAMP`,`oxarticles`.`OXLENGTH` AS `OXLENGTH`,`oxarticles`.`OXWIDTH` AS `OXWIDTH`,`oxarticles`.`OXHEIGHT` AS `OXHEIGHT`,`oxarticles`.`OXFILE` AS `OXFILE`,`oxarticles`.`OXSEARCHKEYS` AS `OXSEARCHKEYS`,`oxarticles`.`OXTEMPLATE` AS `OXTEMPLATE`,`oxarticles`.`OXQUESTIONEMAIL` AS `OXQUESTIONEMAIL`,`oxarticles`.`OXISSEARCH` AS `OXISSEARCH`,`oxarticles`.`OXISCONFIGURABLE` AS `OXISCONFIGURABLE`,`oxarticles`.`OXVARNAME` AS `OXVARNAME`,`oxarticles`.`OXVARSTOCK` AS `OXVARSTOCK`,`oxarticles`.`OXVARCOUNT` AS `OXVARCOUNT`,`oxarticles`.`OXVARSELECT` AS `OXVARSELECT`,`oxarticles`.`OXVARMINPRICE` AS `OXVARMINPRICE`,`oxarticles`.`OXVARMAXPRICE` AS `OXVARMAXPRICE`,`oxarticles`.`OXBUNDLEID` AS `OXBUNDLEID`,`oxarticles`.`OXFOLDER` AS `OXFOLDER`,`oxarticles`.`OXSUBCLASS` AS `OXSUBCLASS`,`oxarticles`.`OXSORT` AS `OXSORT`,`oxarticles`.`OXSOLDAMOUNT` AS `OXSOLDAMOUNT`,`oxarticles`.`OXNONMATERIAL` AS `OXNONMATERIAL`,`oxarticles`.`OXFREESHIPPING` AS `OXFREESHIPPING`,`oxarticles`.`OXREMINDACTIVE` AS `OXREMINDACTIVE`,`oxarticles`.`OXREMINDAMOUNT` AS `OXREMINDAMOUNT`,`oxarticles`.`OXAMITEMID` AS `OXAMITEMID`,`oxarticles`.`OXAMTASKID` AS `OXAMTASKID`,`oxarticles`.`OXVENDORID` AS `OXVENDORID`,`oxarticles`.`OXMANUFACTURERID` AS `OXMANUFACTURERID`,`oxarticles`.`OXSKIPDISCOUNTS` AS `OXSKIPDISCOUNTS`,`oxarticles`.`OXORDERINFO` AS `OXORDERINFO`,`oxarticles`.`OXPIXIEXPORT` AS `OXPIXIEXPORT`,`oxarticles`.`OXPIXIEXPORTED` AS `OXPIXIEXPORTED`,`oxarticles`.`OXVPE` AS `OXVPE`,`oxarticles`.`OXRATING` AS `OXRATING`,`oxarticles`.`OXRATINGCNT` AS `OXRATINGCNT`,`oxarticles`.`OXMINDELTIME` AS `OXMINDELTIME`,`oxarticles`.`OXMAXDELTIME` AS `OXMAXDELTIME`,`oxarticles`.`OXDELTIMEUNIT` AS `OXDELTIMEUNIT`,`oxarticles`.`OXUPDATEPRICE` AS `OXUPDATEPRICE`,`oxarticles`.`OXUPDATEPRICEA` AS `OXUPDATEPRICEA`,`oxarticles`.`OXUPDATEPRICEB` AS `OXUPDATEPRICEB`,`oxarticles`.`OXUPDATEPRICEC` AS `OXUPDATEPRICEC`,`oxarticles`.`OXUPDATEPRICETIME` AS `OXUPDATEPRICETIME`,`oxarticles`.`OXISDOWNLOADABLE` AS `OXISDOWNLOADABLE`,`oxarticles`.`OXSHOWCUSTOMAGREEMENT` AS `OXSHOWCUSTOMAGREEMENT` from (`oxarticles` join `oxarticles2shop` `t2s` on(`t2s`.`OXMAPOBJECTID` = `oxarticles`.`OXMAPID`)) where `t2s`.`OXSHOPID` = 1 */;

--
-- Final view structure for view `oxv_oxarticles_1_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxarticles_1_en`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxarticles_1_en` AS select `oxarticles`.`OXID` AS `OXID`,`oxarticles`.`OXMAPID` AS `OXMAPID`,`oxarticles`.`OXSHOPID` AS `OXSHOPID`,`oxarticles`.`OXPARENTID` AS `OXPARENTID`,`oxarticles`.`OXACTIVE` AS `OXACTIVE`,`oxarticles`.`OXHIDDEN` AS `OXHIDDEN`,`oxarticles`.`OXACTIVEFROM` AS `OXACTIVEFROM`,`oxarticles`.`OXACTIVETO` AS `OXACTIVETO`,`oxarticles`.`OXARTNUM` AS `OXARTNUM`,`oxarticles`.`OXEAN` AS `OXEAN`,`oxarticles`.`OXDISTEAN` AS `OXDISTEAN`,`oxarticles`.`OXMPN` AS `OXMPN`,`oxarticles`.`OXTITLE_1` AS `OXTITLE`,`oxarticles`.`OXSHORTDESC_1` AS `OXSHORTDESC`,`oxarticles`.`OXPRICE` AS `OXPRICE`,`oxarticles`.`OXBLFIXEDPRICE` AS `OXBLFIXEDPRICE`,`oxarticles`.`OXPRICEA` AS `OXPRICEA`,`oxarticles`.`OXPRICEB` AS `OXPRICEB`,`oxarticles`.`OXPRICEC` AS `OXPRICEC`,`oxarticles`.`OXBPRICE` AS `OXBPRICE`,`oxarticles`.`OXTPRICE` AS `OXTPRICE`,`oxarticles`.`OXUNITNAME` AS `OXUNITNAME`,`oxarticles`.`OXUNITQUANTITY` AS `OXUNITQUANTITY`,`oxarticles`.`OXEXTURL` AS `OXEXTURL`,`oxarticles`.`OXURLDESC_1` AS `OXURLDESC`,`oxarticles`.`OXURLIMG` AS `OXURLIMG`,`oxarticles`.`OXVAT` AS `OXVAT`,`oxarticles`.`OXTHUMB` AS `OXTHUMB`,`oxarticles`.`OXICON` AS `OXICON`,`oxarticles`.`OXPIC1` AS `OXPIC1`,`oxarticles`.`OXPIC2` AS `OXPIC2`,`oxarticles`.`OXPIC3` AS `OXPIC3`,`oxarticles`.`OXPIC4` AS `OXPIC4`,`oxarticles`.`OXPIC5` AS `OXPIC5`,`oxarticles`.`OXPIC6` AS `OXPIC6`,`oxarticles`.`OXPIC7` AS `OXPIC7`,`oxarticles`.`OXPIC8` AS `OXPIC8`,`oxarticles`.`OXPIC9` AS `OXPIC9`,`oxarticles`.`OXPIC10` AS `OXPIC10`,`oxarticles`.`OXPIC11` AS `OXPIC11`,`oxarticles`.`OXPIC12` AS `OXPIC12`,`oxarticles`.`OXWEIGHT` AS `OXWEIGHT`,`oxarticles`.`OXSTOCK` AS `OXSTOCK`,`oxarticles`.`OXSTOCKFLAG` AS `OXSTOCKFLAG`,`oxarticles`.`OXSTOCKTEXT_1` AS `OXSTOCKTEXT`,`oxarticles`.`OXNOSTOCKTEXT_1` AS `OXNOSTOCKTEXT`,`oxarticles`.`OXDELIVERY` AS `OXDELIVERY`,`oxarticles`.`OXINSERT` AS `OXINSERT`,`oxarticles`.`OXTIMESTAMP` AS `OXTIMESTAMP`,`oxarticles`.`OXLENGTH` AS `OXLENGTH`,`oxarticles`.`OXWIDTH` AS `OXWIDTH`,`oxarticles`.`OXHEIGHT` AS `OXHEIGHT`,`oxarticles`.`OXFILE` AS `OXFILE`,`oxarticles`.`OXSEARCHKEYS_1` AS `OXSEARCHKEYS`,`oxarticles`.`OXTEMPLATE` AS `OXTEMPLATE`,`oxarticles`.`OXQUESTIONEMAIL` AS `OXQUESTIONEMAIL`,`oxarticles`.`OXISSEARCH` AS `OXISSEARCH`,`oxarticles`.`OXISCONFIGURABLE` AS `OXISCONFIGURABLE`,`oxarticles`.`OXVARNAME_1` AS `OXVARNAME`,`oxarticles`.`OXVARSTOCK` AS `OXVARSTOCK`,`oxarticles`.`OXVARCOUNT` AS `OXVARCOUNT`,`oxarticles`.`OXVARSELECT_1` AS `OXVARSELECT`,`oxarticles`.`OXVARMINPRICE` AS `OXVARMINPRICE`,`oxarticles`.`OXVARMAXPRICE` AS `OXVARMAXPRICE`,`oxarticles`.`OXBUNDLEID` AS `OXBUNDLEID`,`oxarticles`.`OXFOLDER` AS `OXFOLDER`,`oxarticles`.`OXSUBCLASS` AS `OXSUBCLASS`,`oxarticles`.`OXSORT` AS `OXSORT`,`oxarticles`.`OXSOLDAMOUNT` AS `OXSOLDAMOUNT`,`oxarticles`.`OXNONMATERIAL` AS `OXNONMATERIAL`,`oxarticles`.`OXFREESHIPPING` AS `OXFREESHIPPING`,`oxarticles`.`OXREMINDACTIVE` AS `OXREMINDACTIVE`,`oxarticles`.`OXREMINDAMOUNT` AS `OXREMINDAMOUNT`,`oxarticles`.`OXAMITEMID` AS `OXAMITEMID`,`oxarticles`.`OXAMTASKID` AS `OXAMTASKID`,`oxarticles`.`OXVENDORID` AS `OXVENDORID`,`oxarticles`.`OXMANUFACTURERID` AS `OXMANUFACTURERID`,`oxarticles`.`OXSKIPDISCOUNTS` AS `OXSKIPDISCOUNTS`,`oxarticles`.`OXORDERINFO` AS `OXORDERINFO`,`oxarticles`.`OXPIXIEXPORT` AS `OXPIXIEXPORT`,`oxarticles`.`OXPIXIEXPORTED` AS `OXPIXIEXPORTED`,`oxarticles`.`OXVPE` AS `OXVPE`,`oxarticles`.`OXRATING` AS `OXRATING`,`oxarticles`.`OXRATINGCNT` AS `OXRATINGCNT`,`oxarticles`.`OXMINDELTIME` AS `OXMINDELTIME`,`oxarticles`.`OXMAXDELTIME` AS `OXMAXDELTIME`,`oxarticles`.`OXDELTIMEUNIT` AS `OXDELTIMEUNIT`,`oxarticles`.`OXUPDATEPRICE` AS `OXUPDATEPRICE`,`oxarticles`.`OXUPDATEPRICEA` AS `OXUPDATEPRICEA`,`oxarticles`.`OXUPDATEPRICEB` AS `OXUPDATEPRICEB`,`oxarticles`.`OXUPDATEPRICEC` AS `OXUPDATEPRICEC`,`oxarticles`.`OXUPDATEPRICETIME` AS `OXUPDATEPRICETIME`,`oxarticles`.`OXISDOWNLOADABLE` AS `OXISDOWNLOADABLE`,`oxarticles`.`OXSHOWCUSTOMAGREEMENT` AS `OXSHOWCUSTOMAGREEMENT` from (`oxarticles` join `oxarticles2shop` `t2s` on(`t2s`.`OXMAPOBJECTID` = `oxarticles`.`OXMAPID`)) where `t2s`.`OXSHOPID` = 1 */;

--
-- Final view structure for view `oxv_oxarticles_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxarticles_de`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxarticles_de` AS select `oxarticles`.`OXID` AS `OXID`,`oxarticles`.`OXMAPID` AS `OXMAPID`,`oxarticles`.`OXSHOPID` AS `OXSHOPID`,`oxarticles`.`OXPARENTID` AS `OXPARENTID`,`oxarticles`.`OXACTIVE` AS `OXACTIVE`,`oxarticles`.`OXHIDDEN` AS `OXHIDDEN`,`oxarticles`.`OXACTIVEFROM` AS `OXACTIVEFROM`,`oxarticles`.`OXACTIVETO` AS `OXACTIVETO`,`oxarticles`.`OXARTNUM` AS `OXARTNUM`,`oxarticles`.`OXEAN` AS `OXEAN`,`oxarticles`.`OXDISTEAN` AS `OXDISTEAN`,`oxarticles`.`OXMPN` AS `OXMPN`,`oxarticles`.`OXTITLE` AS `OXTITLE`,`oxarticles`.`OXSHORTDESC` AS `OXSHORTDESC`,`oxarticles`.`OXPRICE` AS `OXPRICE`,`oxarticles`.`OXBLFIXEDPRICE` AS `OXBLFIXEDPRICE`,`oxarticles`.`OXPRICEA` AS `OXPRICEA`,`oxarticles`.`OXPRICEB` AS `OXPRICEB`,`oxarticles`.`OXPRICEC` AS `OXPRICEC`,`oxarticles`.`OXBPRICE` AS `OXBPRICE`,`oxarticles`.`OXTPRICE` AS `OXTPRICE`,`oxarticles`.`OXUNITNAME` AS `OXUNITNAME`,`oxarticles`.`OXUNITQUANTITY` AS `OXUNITQUANTITY`,`oxarticles`.`OXEXTURL` AS `OXEXTURL`,`oxarticles`.`OXURLDESC` AS `OXURLDESC`,`oxarticles`.`OXURLIMG` AS `OXURLIMG`,`oxarticles`.`OXVAT` AS `OXVAT`,`oxarticles`.`OXTHUMB` AS `OXTHUMB`,`oxarticles`.`OXICON` AS `OXICON`,`oxarticles`.`OXPIC1` AS `OXPIC1`,`oxarticles`.`OXPIC2` AS `OXPIC2`,`oxarticles`.`OXPIC3` AS `OXPIC3`,`oxarticles`.`OXPIC4` AS `OXPIC4`,`oxarticles`.`OXPIC5` AS `OXPIC5`,`oxarticles`.`OXPIC6` AS `OXPIC6`,`oxarticles`.`OXPIC7` AS `OXPIC7`,`oxarticles`.`OXPIC8` AS `OXPIC8`,`oxarticles`.`OXPIC9` AS `OXPIC9`,`oxarticles`.`OXPIC10` AS `OXPIC10`,`oxarticles`.`OXPIC11` AS `OXPIC11`,`oxarticles`.`OXPIC12` AS `OXPIC12`,`oxarticles`.`OXWEIGHT` AS `OXWEIGHT`,`oxarticles`.`OXSTOCK` AS `OXSTOCK`,`oxarticles`.`OXSTOCKFLAG` AS `OXSTOCKFLAG`,`oxarticles`.`OXSTOCKTEXT` AS `OXSTOCKTEXT`,`oxarticles`.`OXNOSTOCKTEXT` AS `OXNOSTOCKTEXT`,`oxarticles`.`OXDELIVERY` AS `OXDELIVERY`,`oxarticles`.`OXINSERT` AS `OXINSERT`,`oxarticles`.`OXTIMESTAMP` AS `OXTIMESTAMP`,`oxarticles`.`OXLENGTH` AS `OXLENGTH`,`oxarticles`.`OXWIDTH` AS `OXWIDTH`,`oxarticles`.`OXHEIGHT` AS `OXHEIGHT`,`oxarticles`.`OXFILE` AS `OXFILE`,`oxarticles`.`OXSEARCHKEYS` AS `OXSEARCHKEYS`,`oxarticles`.`OXTEMPLATE` AS `OXTEMPLATE`,`oxarticles`.`OXQUESTIONEMAIL` AS `OXQUESTIONEMAIL`,`oxarticles`.`OXISSEARCH` AS `OXISSEARCH`,`oxarticles`.`OXISCONFIGURABLE` AS `OXISCONFIGURABLE`,`oxarticles`.`OXVARNAME` AS `OXVARNAME`,`oxarticles`.`OXVARSTOCK` AS `OXVARSTOCK`,`oxarticles`.`OXVARCOUNT` AS `OXVARCOUNT`,`oxarticles`.`OXVARSELECT` AS `OXVARSELECT`,`oxarticles`.`OXVARMINPRICE` AS `OXVARMINPRICE`,`oxarticles`.`OXVARMAXPRICE` AS `OXVARMAXPRICE`,`oxarticles`.`OXBUNDLEID` AS `OXBUNDLEID`,`oxarticles`.`OXFOLDER` AS `OXFOLDER`,`oxarticles`.`OXSUBCLASS` AS `OXSUBCLASS`,`oxarticles`.`OXSORT` AS `OXSORT`,`oxarticles`.`OXSOLDAMOUNT` AS `OXSOLDAMOUNT`,`oxarticles`.`OXNONMATERIAL` AS `OXNONMATERIAL`,`oxarticles`.`OXFREESHIPPING` AS `OXFREESHIPPING`,`oxarticles`.`OXREMINDACTIVE` AS `OXREMINDACTIVE`,`oxarticles`.`OXREMINDAMOUNT` AS `OXREMINDAMOUNT`,`oxarticles`.`OXAMITEMID` AS `OXAMITEMID`,`oxarticles`.`OXAMTASKID` AS `OXAMTASKID`,`oxarticles`.`OXVENDORID` AS `OXVENDORID`,`oxarticles`.`OXMANUFACTURERID` AS `OXMANUFACTURERID`,`oxarticles`.`OXSKIPDISCOUNTS` AS `OXSKIPDISCOUNTS`,`oxarticles`.`OXORDERINFO` AS `OXORDERINFO`,`oxarticles`.`OXPIXIEXPORT` AS `OXPIXIEXPORT`,`oxarticles`.`OXPIXIEXPORTED` AS `OXPIXIEXPORTED`,`oxarticles`.`OXVPE` AS `OXVPE`,`oxarticles`.`OXRATING` AS `OXRATING`,`oxarticles`.`OXRATINGCNT` AS `OXRATINGCNT`,`oxarticles`.`OXMINDELTIME` AS `OXMINDELTIME`,`oxarticles`.`OXMAXDELTIME` AS `OXMAXDELTIME`,`oxarticles`.`OXDELTIMEUNIT` AS `OXDELTIMEUNIT`,`oxarticles`.`OXUPDATEPRICE` AS `OXUPDATEPRICE`,`oxarticles`.`OXUPDATEPRICEA` AS `OXUPDATEPRICEA`,`oxarticles`.`OXUPDATEPRICEB` AS `OXUPDATEPRICEB`,`oxarticles`.`OXUPDATEPRICEC` AS `OXUPDATEPRICEC`,`oxarticles`.`OXUPDATEPRICETIME` AS `OXUPDATEPRICETIME`,`oxarticles`.`OXISDOWNLOADABLE` AS `OXISDOWNLOADABLE`,`oxarticles`.`OXSHOWCUSTOMAGREEMENT` AS `OXSHOWCUSTOMAGREEMENT` from `oxarticles` */;

--
-- Final view structure for view `oxv_oxarticles_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxarticles_en`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxarticles_en` AS select `oxarticles`.`OXID` AS `OXID`,`oxarticles`.`OXMAPID` AS `OXMAPID`,`oxarticles`.`OXSHOPID` AS `OXSHOPID`,`oxarticles`.`OXPARENTID` AS `OXPARENTID`,`oxarticles`.`OXACTIVE` AS `OXACTIVE`,`oxarticles`.`OXHIDDEN` AS `OXHIDDEN`,`oxarticles`.`OXACTIVEFROM` AS `OXACTIVEFROM`,`oxarticles`.`OXACTIVETO` AS `OXACTIVETO`,`oxarticles`.`OXARTNUM` AS `OXARTNUM`,`oxarticles`.`OXEAN` AS `OXEAN`,`oxarticles`.`OXDISTEAN` AS `OXDISTEAN`,`oxarticles`.`OXMPN` AS `OXMPN`,`oxarticles`.`OXTITLE_1` AS `OXTITLE`,`oxarticles`.`OXSHORTDESC_1` AS `OXSHORTDESC`,`oxarticles`.`OXPRICE` AS `OXPRICE`,`oxarticles`.`OXBLFIXEDPRICE` AS `OXBLFIXEDPRICE`,`oxarticles`.`OXPRICEA` AS `OXPRICEA`,`oxarticles`.`OXPRICEB` AS `OXPRICEB`,`oxarticles`.`OXPRICEC` AS `OXPRICEC`,`oxarticles`.`OXBPRICE` AS `OXBPRICE`,`oxarticles`.`OXTPRICE` AS `OXTPRICE`,`oxarticles`.`OXUNITNAME` AS `OXUNITNAME`,`oxarticles`.`OXUNITQUANTITY` AS `OXUNITQUANTITY`,`oxarticles`.`OXEXTURL` AS `OXEXTURL`,`oxarticles`.`OXURLDESC_1` AS `OXURLDESC`,`oxarticles`.`OXURLIMG` AS `OXURLIMG`,`oxarticles`.`OXVAT` AS `OXVAT`,`oxarticles`.`OXTHUMB` AS `OXTHUMB`,`oxarticles`.`OXICON` AS `OXICON`,`oxarticles`.`OXPIC1` AS `OXPIC1`,`oxarticles`.`OXPIC2` AS `OXPIC2`,`oxarticles`.`OXPIC3` AS `OXPIC3`,`oxarticles`.`OXPIC4` AS `OXPIC4`,`oxarticles`.`OXPIC5` AS `OXPIC5`,`oxarticles`.`OXPIC6` AS `OXPIC6`,`oxarticles`.`OXPIC7` AS `OXPIC7`,`oxarticles`.`OXPIC8` AS `OXPIC8`,`oxarticles`.`OXPIC9` AS `OXPIC9`,`oxarticles`.`OXPIC10` AS `OXPIC10`,`oxarticles`.`OXPIC11` AS `OXPIC11`,`oxarticles`.`OXPIC12` AS `OXPIC12`,`oxarticles`.`OXWEIGHT` AS `OXWEIGHT`,`oxarticles`.`OXSTOCK` AS `OXSTOCK`,`oxarticles`.`OXSTOCKFLAG` AS `OXSTOCKFLAG`,`oxarticles`.`OXSTOCKTEXT_1` AS `OXSTOCKTEXT`,`oxarticles`.`OXNOSTOCKTEXT_1` AS `OXNOSTOCKTEXT`,`oxarticles`.`OXDELIVERY` AS `OXDELIVERY`,`oxarticles`.`OXINSERT` AS `OXINSERT`,`oxarticles`.`OXTIMESTAMP` AS `OXTIMESTAMP`,`oxarticles`.`OXLENGTH` AS `OXLENGTH`,`oxarticles`.`OXWIDTH` AS `OXWIDTH`,`oxarticles`.`OXHEIGHT` AS `OXHEIGHT`,`oxarticles`.`OXFILE` AS `OXFILE`,`oxarticles`.`OXSEARCHKEYS_1` AS `OXSEARCHKEYS`,`oxarticles`.`OXTEMPLATE` AS `OXTEMPLATE`,`oxarticles`.`OXQUESTIONEMAIL` AS `OXQUESTIONEMAIL`,`oxarticles`.`OXISSEARCH` AS `OXISSEARCH`,`oxarticles`.`OXISCONFIGURABLE` AS `OXISCONFIGURABLE`,`oxarticles`.`OXVARNAME_1` AS `OXVARNAME`,`oxarticles`.`OXVARSTOCK` AS `OXVARSTOCK`,`oxarticles`.`OXVARCOUNT` AS `OXVARCOUNT`,`oxarticles`.`OXVARSELECT_1` AS `OXVARSELECT`,`oxarticles`.`OXVARMINPRICE` AS `OXVARMINPRICE`,`oxarticles`.`OXVARMAXPRICE` AS `OXVARMAXPRICE`,`oxarticles`.`OXBUNDLEID` AS `OXBUNDLEID`,`oxarticles`.`OXFOLDER` AS `OXFOLDER`,`oxarticles`.`OXSUBCLASS` AS `OXSUBCLASS`,`oxarticles`.`OXSORT` AS `OXSORT`,`oxarticles`.`OXSOLDAMOUNT` AS `OXSOLDAMOUNT`,`oxarticles`.`OXNONMATERIAL` AS `OXNONMATERIAL`,`oxarticles`.`OXFREESHIPPING` AS `OXFREESHIPPING`,`oxarticles`.`OXREMINDACTIVE` AS `OXREMINDACTIVE`,`oxarticles`.`OXREMINDAMOUNT` AS `OXREMINDAMOUNT`,`oxarticles`.`OXAMITEMID` AS `OXAMITEMID`,`oxarticles`.`OXAMTASKID` AS `OXAMTASKID`,`oxarticles`.`OXVENDORID` AS `OXVENDORID`,`oxarticles`.`OXMANUFACTURERID` AS `OXMANUFACTURERID`,`oxarticles`.`OXSKIPDISCOUNTS` AS `OXSKIPDISCOUNTS`,`oxarticles`.`OXORDERINFO` AS `OXORDERINFO`,`oxarticles`.`OXPIXIEXPORT` AS `OXPIXIEXPORT`,`oxarticles`.`OXPIXIEXPORTED` AS `OXPIXIEXPORTED`,`oxarticles`.`OXVPE` AS `OXVPE`,`oxarticles`.`OXRATING` AS `OXRATING`,`oxarticles`.`OXRATINGCNT` AS `OXRATINGCNT`,`oxarticles`.`OXMINDELTIME` AS `OXMINDELTIME`,`oxarticles`.`OXMAXDELTIME` AS `OXMAXDELTIME`,`oxarticles`.`OXDELTIMEUNIT` AS `OXDELTIMEUNIT`,`oxarticles`.`OXUPDATEPRICE` AS `OXUPDATEPRICE`,`oxarticles`.`OXUPDATEPRICEA` AS `OXUPDATEPRICEA`,`oxarticles`.`OXUPDATEPRICEB` AS `OXUPDATEPRICEB`,`oxarticles`.`OXUPDATEPRICEC` AS `OXUPDATEPRICEC`,`oxarticles`.`OXUPDATEPRICETIME` AS `OXUPDATEPRICETIME`,`oxarticles`.`OXISDOWNLOADABLE` AS `OXISDOWNLOADABLE`,`oxarticles`.`OXSHOWCUSTOMAGREEMENT` AS `OXSHOWCUSTOMAGREEMENT` from `oxarticles` */;

--
-- Final view structure for view `oxv_oxattribute`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxattribute`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxattribute` AS select `oxattribute`.`OXID` AS `OXID`,`oxattribute`.`OXMAPID` AS `OXMAPID`,`oxattribute`.`OXSHOPID` AS `OXSHOPID`,`oxattribute`.`OXTITLE` AS `OXTITLE`,`oxattribute`.`OXTITLE_1` AS `OXTITLE_1`,`oxattribute`.`OXTITLE_2` AS `OXTITLE_2`,`oxattribute`.`OXTITLE_3` AS `OXTITLE_3`,`oxattribute`.`OXPOS` AS `OXPOS`,`oxattribute`.`OXTIMESTAMP` AS `OXTIMESTAMP`,`oxattribute`.`OXDISPLAYINBASKET` AS `OXDISPLAYINBASKET` from `oxattribute` */;

--
-- Final view structure for view `oxv_oxattribute_1`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxattribute_1`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxattribute_1` AS select `oxattribute`.`OXID` AS `OXID`,`oxattribute`.`OXMAPID` AS `OXMAPID`,`oxattribute`.`OXSHOPID` AS `OXSHOPID`,`oxattribute`.`OXTITLE` AS `OXTITLE`,`oxattribute`.`OXTITLE_1` AS `OXTITLE_1`,`oxattribute`.`OXTITLE_2` AS `OXTITLE_2`,`oxattribute`.`OXTITLE_3` AS `OXTITLE_3`,`oxattribute`.`OXPOS` AS `OXPOS`,`oxattribute`.`OXTIMESTAMP` AS `OXTIMESTAMP`,`oxattribute`.`OXDISPLAYINBASKET` AS `OXDISPLAYINBASKET` from (`oxattribute` join `oxattribute2shop` `t2s` on(`t2s`.`OXMAPOBJECTID` = `oxattribute`.`OXMAPID`)) where `t2s`.`OXSHOPID` = 1 */;

--
-- Final view structure for view `oxv_oxattribute_1_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxattribute_1_de`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxattribute_1_de` AS select `oxattribute`.`OXID` AS `OXID`,`oxattribute`.`OXMAPID` AS `OXMAPID`,`oxattribute`.`OXSHOPID` AS `OXSHOPID`,`oxattribute`.`OXTITLE` AS `OXTITLE`,`oxattribute`.`OXPOS` AS `OXPOS`,`oxattribute`.`OXTIMESTAMP` AS `OXTIMESTAMP`,`oxattribute`.`OXDISPLAYINBASKET` AS `OXDISPLAYINBASKET` from (`oxattribute` join `oxattribute2shop` `t2s` on(`t2s`.`OXMAPOBJECTID` = `oxattribute`.`OXMAPID`)) where `t2s`.`OXSHOPID` = 1 */;

--
-- Final view structure for view `oxv_oxattribute_1_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxattribute_1_en`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxattribute_1_en` AS select `oxattribute`.`OXID` AS `OXID`,`oxattribute`.`OXMAPID` AS `OXMAPID`,`oxattribute`.`OXSHOPID` AS `OXSHOPID`,`oxattribute`.`OXTITLE_1` AS `OXTITLE`,`oxattribute`.`OXPOS` AS `OXPOS`,`oxattribute`.`OXTIMESTAMP` AS `OXTIMESTAMP`,`oxattribute`.`OXDISPLAYINBASKET` AS `OXDISPLAYINBASKET` from (`oxattribute` join `oxattribute2shop` `t2s` on(`t2s`.`OXMAPOBJECTID` = `oxattribute`.`OXMAPID`)) where `t2s`.`OXSHOPID` = 1 */;

--
-- Final view structure for view `oxv_oxattribute_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxattribute_de`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxattribute_de` AS select `oxattribute`.`OXID` AS `OXID`,`oxattribute`.`OXMAPID` AS `OXMAPID`,`oxattribute`.`OXSHOPID` AS `OXSHOPID`,`oxattribute`.`OXTITLE` AS `OXTITLE`,`oxattribute`.`OXPOS` AS `OXPOS`,`oxattribute`.`OXTIMESTAMP` AS `OXTIMESTAMP`,`oxattribute`.`OXDISPLAYINBASKET` AS `OXDISPLAYINBASKET` from `oxattribute` */;

--
-- Final view structure for view `oxv_oxattribute_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxattribute_en`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxattribute_en` AS select `oxattribute`.`OXID` AS `OXID`,`oxattribute`.`OXMAPID` AS `OXMAPID`,`oxattribute`.`OXSHOPID` AS `OXSHOPID`,`oxattribute`.`OXTITLE_1` AS `OXTITLE`,`oxattribute`.`OXPOS` AS `OXPOS`,`oxattribute`.`OXTIMESTAMP` AS `OXTIMESTAMP`,`oxattribute`.`OXDISPLAYINBASKET` AS `OXDISPLAYINBASKET` from `oxattribute` */;

--
-- Final view structure for view `oxv_oxcategories`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxcategories`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxcategories` AS select `oxcategories`.`OXID` AS `OXID`,`oxcategories`.`OXMAPID` AS `OXMAPID`,`oxcategories`.`OXPARENTID` AS `OXPARENTID`,`oxcategories`.`OXLEFT` AS `OXLEFT`,`oxcategories`.`OXRIGHT` AS `OXRIGHT`,`oxcategories`.`OXROOTID` AS `OXROOTID`,`oxcategories`.`OXSORT` AS `OXSORT`,`oxcategories`.`OXACTIVE` AS `OXACTIVE`,`oxcategories`.`OXHIDDEN` AS `OXHIDDEN`,`oxcategories`.`OXSHOPID` AS `OXSHOPID`,`oxcategories`.`OXTITLE` AS `OXTITLE`,`oxcategories`.`OXDESC` AS `OXDESC`,`oxcategories`.`OXLONGDESC` AS `OXLONGDESC`,`oxcategories`.`OXTHUMB` AS `OXTHUMB`,`oxcategories`.`OXTHUMB_1` AS `OXTHUMB_1`,`oxcategories`.`OXTHUMB_2` AS `OXTHUMB_2`,`oxcategories`.`OXTHUMB_3` AS `OXTHUMB_3`,`oxcategories`.`OXEXTLINK` AS `OXEXTLINK`,`oxcategories`.`OXTEMPLATE` AS `OXTEMPLATE`,`oxcategories`.`OXDEFSORT` AS `OXDEFSORT`,`oxcategories`.`OXDEFSORTMODE` AS `OXDEFSORTMODE`,`oxcategories`.`OXPRICEFROM` AS `OXPRICEFROM`,`oxcategories`.`OXPRICETO` AS `OXPRICETO`,`oxcategories`.`OXACTIVE_1` AS `OXACTIVE_1`,`oxcategories`.`OXTITLE_1` AS `OXTITLE_1`,`oxcategories`.`OXDESC_1` AS `OXDESC_1`,`oxcategories`.`OXLONGDESC_1` AS `OXLONGDESC_1`,`oxcategories`.`OXACTIVE_2` AS `OXACTIVE_2`,`oxcategories`.`OXTITLE_2` AS `OXTITLE_2`,`oxcategories`.`OXDESC_2` AS `OXDESC_2`,`oxcategories`.`OXLONGDESC_2` AS `OXLONGDESC_2`,`oxcategories`.`OXACTIVE_3` AS `OXACTIVE_3`,`oxcategories`.`OXTITLE_3` AS `OXTITLE_3`,`oxcategories`.`OXDESC_3` AS `OXDESC_3`,`oxcategories`.`OXLONGDESC_3` AS `OXLONGDESC_3`,`oxcategories`.`OXICON` AS `OXICON`,`oxcategories`.`OXPROMOICON` AS `OXPROMOICON`,`oxcategories`.`OXVAT` AS `OXVAT`,`oxcategories`.`OXSKIPDISCOUNTS` AS `OXSKIPDISCOUNTS`,`oxcategories`.`OXSHOWSUFFIX` AS `OXSHOWSUFFIX`,`oxcategories`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxcategories` */;

--
-- Final view structure for view `oxv_oxcategories_1`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxcategories_1`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxcategories_1` AS select `oxcategories`.`OXID` AS `OXID`,`oxcategories`.`OXMAPID` AS `OXMAPID`,`oxcategories`.`OXPARENTID` AS `OXPARENTID`,`oxcategories`.`OXLEFT` AS `OXLEFT`,`oxcategories`.`OXRIGHT` AS `OXRIGHT`,`oxcategories`.`OXROOTID` AS `OXROOTID`,`oxcategories`.`OXSORT` AS `OXSORT`,`oxcategories`.`OXACTIVE` AS `OXACTIVE`,`oxcategories`.`OXHIDDEN` AS `OXHIDDEN`,`oxcategories`.`OXSHOPID` AS `OXSHOPID`,`oxcategories`.`OXTITLE` AS `OXTITLE`,`oxcategories`.`OXDESC` AS `OXDESC`,`oxcategories`.`OXLONGDESC` AS `OXLONGDESC`,`oxcategories`.`OXTHUMB` AS `OXTHUMB`,`oxcategories`.`OXTHUMB_1` AS `OXTHUMB_1`,`oxcategories`.`OXTHUMB_2` AS `OXTHUMB_2`,`oxcategories`.`OXTHUMB_3` AS `OXTHUMB_3`,`oxcategories`.`OXEXTLINK` AS `OXEXTLINK`,`oxcategories`.`OXTEMPLATE` AS `OXTEMPLATE`,`oxcategories`.`OXDEFSORT` AS `OXDEFSORT`,`oxcategories`.`OXDEFSORTMODE` AS `OXDEFSORTMODE`,`oxcategories`.`OXPRICEFROM` AS `OXPRICEFROM`,`oxcategories`.`OXPRICETO` AS `OXPRICETO`,`oxcategories`.`OXACTIVE_1` AS `OXACTIVE_1`,`oxcategories`.`OXTITLE_1` AS `OXTITLE_1`,`oxcategories`.`OXDESC_1` AS `OXDESC_1`,`oxcategories`.`OXLONGDESC_1` AS `OXLONGDESC_1`,`oxcategories`.`OXACTIVE_2` AS `OXACTIVE_2`,`oxcategories`.`OXTITLE_2` AS `OXTITLE_2`,`oxcategories`.`OXDESC_2` AS `OXDESC_2`,`oxcategories`.`OXLONGDESC_2` AS `OXLONGDESC_2`,`oxcategories`.`OXACTIVE_3` AS `OXACTIVE_3`,`oxcategories`.`OXTITLE_3` AS `OXTITLE_3`,`oxcategories`.`OXDESC_3` AS `OXDESC_3`,`oxcategories`.`OXLONGDESC_3` AS `OXLONGDESC_3`,`oxcategories`.`OXICON` AS `OXICON`,`oxcategories`.`OXPROMOICON` AS `OXPROMOICON`,`oxcategories`.`OXVAT` AS `OXVAT`,`oxcategories`.`OXSKIPDISCOUNTS` AS `OXSKIPDISCOUNTS`,`oxcategories`.`OXSHOWSUFFIX` AS `OXSHOWSUFFIX`,`oxcategories`.`OXTIMESTAMP` AS `OXTIMESTAMP` from (`oxcategories` join `oxcategories2shop` `t2s` on(`t2s`.`OXMAPOBJECTID` = `oxcategories`.`OXMAPID`)) where `t2s`.`OXSHOPID` = 1 */;

--
-- Final view structure for view `oxv_oxcategories_1_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxcategories_1_de`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxcategories_1_de` AS select `oxcategories`.`OXID` AS `OXID`,`oxcategories`.`OXMAPID` AS `OXMAPID`,`oxcategories`.`OXPARENTID` AS `OXPARENTID`,`oxcategories`.`OXLEFT` AS `OXLEFT`,`oxcategories`.`OXRIGHT` AS `OXRIGHT`,`oxcategories`.`OXROOTID` AS `OXROOTID`,`oxcategories`.`OXSORT` AS `OXSORT`,`oxcategories`.`OXACTIVE` AS `OXACTIVE`,`oxcategories`.`OXHIDDEN` AS `OXHIDDEN`,`oxcategories`.`OXSHOPID` AS `OXSHOPID`,`oxcategories`.`OXTITLE` AS `OXTITLE`,`oxcategories`.`OXDESC` AS `OXDESC`,`oxcategories`.`OXLONGDESC` AS `OXLONGDESC`,`oxcategories`.`OXTHUMB` AS `OXTHUMB`,`oxcategories`.`OXEXTLINK` AS `OXEXTLINK`,`oxcategories`.`OXTEMPLATE` AS `OXTEMPLATE`,`oxcategories`.`OXDEFSORT` AS `OXDEFSORT`,`oxcategories`.`OXDEFSORTMODE` AS `OXDEFSORTMODE`,`oxcategories`.`OXPRICEFROM` AS `OXPRICEFROM`,`oxcategories`.`OXPRICETO` AS `OXPRICETO`,`oxcategories`.`OXICON` AS `OXICON`,`oxcategories`.`OXPROMOICON` AS `OXPROMOICON`,`oxcategories`.`OXVAT` AS `OXVAT`,`oxcategories`.`OXSKIPDISCOUNTS` AS `OXSKIPDISCOUNTS`,`oxcategories`.`OXSHOWSUFFIX` AS `OXSHOWSUFFIX`,`oxcategories`.`OXTIMESTAMP` AS `OXTIMESTAMP` from (`oxcategories` join `oxcategories2shop` `t2s` on(`t2s`.`OXMAPOBJECTID` = `oxcategories`.`OXMAPID`)) where `t2s`.`OXSHOPID` = 1 */;

--
-- Final view structure for view `oxv_oxcategories_1_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxcategories_1_en`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxcategories_1_en` AS select `oxcategories`.`OXID` AS `OXID`,`oxcategories`.`OXMAPID` AS `OXMAPID`,`oxcategories`.`OXPARENTID` AS `OXPARENTID`,`oxcategories`.`OXLEFT` AS `OXLEFT`,`oxcategories`.`OXRIGHT` AS `OXRIGHT`,`oxcategories`.`OXROOTID` AS `OXROOTID`,`oxcategories`.`OXSORT` AS `OXSORT`,`oxcategories`.`OXACTIVE_1` AS `OXACTIVE`,`oxcategories`.`OXHIDDEN` AS `OXHIDDEN`,`oxcategories`.`OXSHOPID` AS `OXSHOPID`,`oxcategories`.`OXTITLE_1` AS `OXTITLE`,`oxcategories`.`OXDESC_1` AS `OXDESC`,`oxcategories`.`OXLONGDESC_1` AS `OXLONGDESC`,`oxcategories`.`OXTHUMB_1` AS `OXTHUMB`,`oxcategories`.`OXEXTLINK` AS `OXEXTLINK`,`oxcategories`.`OXTEMPLATE` AS `OXTEMPLATE`,`oxcategories`.`OXDEFSORT` AS `OXDEFSORT`,`oxcategories`.`OXDEFSORTMODE` AS `OXDEFSORTMODE`,`oxcategories`.`OXPRICEFROM` AS `OXPRICEFROM`,`oxcategories`.`OXPRICETO` AS `OXPRICETO`,`oxcategories`.`OXICON` AS `OXICON`,`oxcategories`.`OXPROMOICON` AS `OXPROMOICON`,`oxcategories`.`OXVAT` AS `OXVAT`,`oxcategories`.`OXSKIPDISCOUNTS` AS `OXSKIPDISCOUNTS`,`oxcategories`.`OXSHOWSUFFIX` AS `OXSHOWSUFFIX`,`oxcategories`.`OXTIMESTAMP` AS `OXTIMESTAMP` from (`oxcategories` join `oxcategories2shop` `t2s` on(`t2s`.`OXMAPOBJECTID` = `oxcategories`.`OXMAPID`)) where `t2s`.`OXSHOPID` = 1 */;

--
-- Final view structure for view `oxv_oxcategories_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxcategories_de`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxcategories_de` AS select `oxcategories`.`OXID` AS `OXID`,`oxcategories`.`OXMAPID` AS `OXMAPID`,`oxcategories`.`OXPARENTID` AS `OXPARENTID`,`oxcategories`.`OXLEFT` AS `OXLEFT`,`oxcategories`.`OXRIGHT` AS `OXRIGHT`,`oxcategories`.`OXROOTID` AS `OXROOTID`,`oxcategories`.`OXSORT` AS `OXSORT`,`oxcategories`.`OXACTIVE` AS `OXACTIVE`,`oxcategories`.`OXHIDDEN` AS `OXHIDDEN`,`oxcategories`.`OXSHOPID` AS `OXSHOPID`,`oxcategories`.`OXTITLE` AS `OXTITLE`,`oxcategories`.`OXDESC` AS `OXDESC`,`oxcategories`.`OXLONGDESC` AS `OXLONGDESC`,`oxcategories`.`OXTHUMB` AS `OXTHUMB`,`oxcategories`.`OXEXTLINK` AS `OXEXTLINK`,`oxcategories`.`OXTEMPLATE` AS `OXTEMPLATE`,`oxcategories`.`OXDEFSORT` AS `OXDEFSORT`,`oxcategories`.`OXDEFSORTMODE` AS `OXDEFSORTMODE`,`oxcategories`.`OXPRICEFROM` AS `OXPRICEFROM`,`oxcategories`.`OXPRICETO` AS `OXPRICETO`,`oxcategories`.`OXICON` AS `OXICON`,`oxcategories`.`OXPROMOICON` AS `OXPROMOICON`,`oxcategories`.`OXVAT` AS `OXVAT`,`oxcategories`.`OXSKIPDISCOUNTS` AS `OXSKIPDISCOUNTS`,`oxcategories`.`OXSHOWSUFFIX` AS `OXSHOWSUFFIX`,`oxcategories`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxcategories` */;

--
-- Final view structure for view `oxv_oxcategories_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxcategories_en`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxcategories_en` AS select `oxcategories`.`OXID` AS `OXID`,`oxcategories`.`OXMAPID` AS `OXMAPID`,`oxcategories`.`OXPARENTID` AS `OXPARENTID`,`oxcategories`.`OXLEFT` AS `OXLEFT`,`oxcategories`.`OXRIGHT` AS `OXRIGHT`,`oxcategories`.`OXROOTID` AS `OXROOTID`,`oxcategories`.`OXSORT` AS `OXSORT`,`oxcategories`.`OXACTIVE_1` AS `OXACTIVE`,`oxcategories`.`OXHIDDEN` AS `OXHIDDEN`,`oxcategories`.`OXSHOPID` AS `OXSHOPID`,`oxcategories`.`OXTITLE_1` AS `OXTITLE`,`oxcategories`.`OXDESC_1` AS `OXDESC`,`oxcategories`.`OXLONGDESC_1` AS `OXLONGDESC`,`oxcategories`.`OXTHUMB_1` AS `OXTHUMB`,`oxcategories`.`OXEXTLINK` AS `OXEXTLINK`,`oxcategories`.`OXTEMPLATE` AS `OXTEMPLATE`,`oxcategories`.`OXDEFSORT` AS `OXDEFSORT`,`oxcategories`.`OXDEFSORTMODE` AS `OXDEFSORTMODE`,`oxcategories`.`OXPRICEFROM` AS `OXPRICEFROM`,`oxcategories`.`OXPRICETO` AS `OXPRICETO`,`oxcategories`.`OXICON` AS `OXICON`,`oxcategories`.`OXPROMOICON` AS `OXPROMOICON`,`oxcategories`.`OXVAT` AS `OXVAT`,`oxcategories`.`OXSKIPDISCOUNTS` AS `OXSKIPDISCOUNTS`,`oxcategories`.`OXSHOWSUFFIX` AS `OXSHOWSUFFIX`,`oxcategories`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxcategories` */;

--
-- Final view structure for view `oxv_oxcontents`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxcontents`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxcontents` AS select `oxcontents`.`OXID` AS `OXID`,`oxcontents`.`OXLOADID` AS `OXLOADID`,`oxcontents`.`OXSHOPID` AS `OXSHOPID`,`oxcontents`.`OXSNIPPET` AS `OXSNIPPET`,`oxcontents`.`OXTYPE` AS `OXTYPE`,`oxcontents`.`OXACTIVE` AS `OXACTIVE`,`oxcontents`.`OXACTIVE_1` AS `OXACTIVE_1`,`oxcontents`.`OXPOSITION` AS `OXPOSITION`,`oxcontents`.`OXTITLE` AS `OXTITLE`,`oxcontents`.`OXCONTENT` AS `OXCONTENT`,`oxcontents`.`OXTITLE_1` AS `OXTITLE_1`,`oxcontents`.`OXCONTENT_1` AS `OXCONTENT_1`,`oxcontents`.`OXACTIVE_2` AS `OXACTIVE_2`,`oxcontents`.`OXTITLE_2` AS `OXTITLE_2`,`oxcontents`.`OXCONTENT_2` AS `OXCONTENT_2`,`oxcontents`.`OXACTIVE_3` AS `OXACTIVE_3`,`oxcontents`.`OXTITLE_3` AS `OXTITLE_3`,`oxcontents`.`OXCONTENT_3` AS `OXCONTENT_3`,`oxcontents`.`OXCATID` AS `OXCATID`,`oxcontents`.`OXFOLDER` AS `OXFOLDER`,`oxcontents`.`OXTERMVERSION` AS `OXTERMVERSION`,`oxcontents`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxcontents` */;

--
-- Final view structure for view `oxv_oxcontents_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxcontents_de`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxcontents_de` AS select `oxcontents`.`OXID` AS `OXID`,`oxcontents`.`OXLOADID` AS `OXLOADID`,`oxcontents`.`OXSHOPID` AS `OXSHOPID`,`oxcontents`.`OXSNIPPET` AS `OXSNIPPET`,`oxcontents`.`OXTYPE` AS `OXTYPE`,`oxcontents`.`OXACTIVE` AS `OXACTIVE`,`oxcontents`.`OXPOSITION` AS `OXPOSITION`,`oxcontents`.`OXTITLE` AS `OXTITLE`,`oxcontents`.`OXCONTENT` AS `OXCONTENT`,`oxcontents`.`OXCATID` AS `OXCATID`,`oxcontents`.`OXFOLDER` AS `OXFOLDER`,`oxcontents`.`OXTERMVERSION` AS `OXTERMVERSION`,`oxcontents`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxcontents` */;

--
-- Final view structure for view `oxv_oxcontents_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxcontents_en`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxcontents_en` AS select `oxcontents`.`OXID` AS `OXID`,`oxcontents`.`OXLOADID` AS `OXLOADID`,`oxcontents`.`OXSHOPID` AS `OXSHOPID`,`oxcontents`.`OXSNIPPET` AS `OXSNIPPET`,`oxcontents`.`OXTYPE` AS `OXTYPE`,`oxcontents`.`OXACTIVE_1` AS `OXACTIVE`,`oxcontents`.`OXPOSITION` AS `OXPOSITION`,`oxcontents`.`OXTITLE_1` AS `OXTITLE`,`oxcontents`.`OXCONTENT_1` AS `OXCONTENT`,`oxcontents`.`OXCATID` AS `OXCATID`,`oxcontents`.`OXFOLDER` AS `OXFOLDER`,`oxcontents`.`OXTERMVERSION` AS `OXTERMVERSION`,`oxcontents`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxcontents` */;

--
-- Final view structure for view `oxv_oxcountry`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxcountry`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxcountry` AS select `oxcountry`.`OXID` AS `OXID`,`oxcountry`.`OXACTIVE` AS `OXACTIVE`,`oxcountry`.`OXTITLE` AS `OXTITLE`,`oxcountry`.`OXISOALPHA2` AS `OXISOALPHA2`,`oxcountry`.`OXISOALPHA3` AS `OXISOALPHA3`,`oxcountry`.`OXUNNUM3` AS `OXUNNUM3`,`oxcountry`.`OXVATINPREFIX` AS `OXVATINPREFIX`,`oxcountry`.`OXORDER` AS `OXORDER`,`oxcountry`.`OXSHORTDESC` AS `OXSHORTDESC`,`oxcountry`.`OXLONGDESC` AS `OXLONGDESC`,`oxcountry`.`OXTITLE_1` AS `OXTITLE_1`,`oxcountry`.`OXTITLE_2` AS `OXTITLE_2`,`oxcountry`.`OXTITLE_3` AS `OXTITLE_3`,`oxcountry`.`OXSHORTDESC_1` AS `OXSHORTDESC_1`,`oxcountry`.`OXSHORTDESC_2` AS `OXSHORTDESC_2`,`oxcountry`.`OXSHORTDESC_3` AS `OXSHORTDESC_3`,`oxcountry`.`OXLONGDESC_1` AS `OXLONGDESC_1`,`oxcountry`.`OXLONGDESC_2` AS `OXLONGDESC_2`,`oxcountry`.`OXLONGDESC_3` AS `OXLONGDESC_3`,`oxcountry`.`OXVATSTATUS` AS `OXVATSTATUS`,`oxcountry`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxcountry` */;

--
-- Final view structure for view `oxv_oxcountry_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxcountry_de`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxcountry_de` AS select `oxcountry`.`OXID` AS `OXID`,`oxcountry`.`OXACTIVE` AS `OXACTIVE`,`oxcountry`.`OXTITLE` AS `OXTITLE`,`oxcountry`.`OXISOALPHA2` AS `OXISOALPHA2`,`oxcountry`.`OXISOALPHA3` AS `OXISOALPHA3`,`oxcountry`.`OXUNNUM3` AS `OXUNNUM3`,`oxcountry`.`OXVATINPREFIX` AS `OXVATINPREFIX`,`oxcountry`.`OXORDER` AS `OXORDER`,`oxcountry`.`OXSHORTDESC` AS `OXSHORTDESC`,`oxcountry`.`OXLONGDESC` AS `OXLONGDESC`,`oxcountry`.`OXVATSTATUS` AS `OXVATSTATUS`,`oxcountry`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxcountry` */;

--
-- Final view structure for view `oxv_oxcountry_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxcountry_en`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxcountry_en` AS select `oxcountry`.`OXID` AS `OXID`,`oxcountry`.`OXACTIVE` AS `OXACTIVE`,`oxcountry`.`OXTITLE_1` AS `OXTITLE`,`oxcountry`.`OXISOALPHA2` AS `OXISOALPHA2`,`oxcountry`.`OXISOALPHA3` AS `OXISOALPHA3`,`oxcountry`.`OXUNNUM3` AS `OXUNNUM3`,`oxcountry`.`OXVATINPREFIX` AS `OXVATINPREFIX`,`oxcountry`.`OXORDER` AS `OXORDER`,`oxcountry`.`OXSHORTDESC_1` AS `OXSHORTDESC`,`oxcountry`.`OXLONGDESC_1` AS `OXLONGDESC`,`oxcountry`.`OXVATSTATUS` AS `OXVATSTATUS`,`oxcountry`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxcountry` */;

--
-- Final view structure for view `oxv_oxdelivery`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxdelivery`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxdelivery` AS select `oxdelivery`.`OXID` AS `OXID`,`oxdelivery`.`OXMAPID` AS `OXMAPID`,`oxdelivery`.`OXSHOPID` AS `OXSHOPID`,`oxdelivery`.`OXACTIVE` AS `OXACTIVE`,`oxdelivery`.`OXACTIVEFROM` AS `OXACTIVEFROM`,`oxdelivery`.`OXACTIVETO` AS `OXACTIVETO`,`oxdelivery`.`OXTITLE` AS `OXTITLE`,`oxdelivery`.`OXTITLE_1` AS `OXTITLE_1`,`oxdelivery`.`OXTITLE_2` AS `OXTITLE_2`,`oxdelivery`.`OXTITLE_3` AS `OXTITLE_3`,`oxdelivery`.`OXADDSUMTYPE` AS `OXADDSUMTYPE`,`oxdelivery`.`OXADDSUM` AS `OXADDSUM`,`oxdelivery`.`OXDELTYPE` AS `OXDELTYPE`,`oxdelivery`.`OXPARAM` AS `OXPARAM`,`oxdelivery`.`OXPARAMEND` AS `OXPARAMEND`,`oxdelivery`.`OXFIXED` AS `OXFIXED`,`oxdelivery`.`OXSORT` AS `OXSORT`,`oxdelivery`.`OXFINALIZE` AS `OXFINALIZE`,`oxdelivery`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxdelivery` */;

--
-- Final view structure for view `oxv_oxdelivery_1`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxdelivery_1`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxdelivery_1` AS select `oxdelivery`.`OXID` AS `OXID`,`oxdelivery`.`OXMAPID` AS `OXMAPID`,`oxdelivery`.`OXSHOPID` AS `OXSHOPID`,`oxdelivery`.`OXACTIVE` AS `OXACTIVE`,`oxdelivery`.`OXACTIVEFROM` AS `OXACTIVEFROM`,`oxdelivery`.`OXACTIVETO` AS `OXACTIVETO`,`oxdelivery`.`OXTITLE` AS `OXTITLE`,`oxdelivery`.`OXTITLE_1` AS `OXTITLE_1`,`oxdelivery`.`OXTITLE_2` AS `OXTITLE_2`,`oxdelivery`.`OXTITLE_3` AS `OXTITLE_3`,`oxdelivery`.`OXADDSUMTYPE` AS `OXADDSUMTYPE`,`oxdelivery`.`OXADDSUM` AS `OXADDSUM`,`oxdelivery`.`OXDELTYPE` AS `OXDELTYPE`,`oxdelivery`.`OXPARAM` AS `OXPARAM`,`oxdelivery`.`OXPARAMEND` AS `OXPARAMEND`,`oxdelivery`.`OXFIXED` AS `OXFIXED`,`oxdelivery`.`OXSORT` AS `OXSORT`,`oxdelivery`.`OXFINALIZE` AS `OXFINALIZE`,`oxdelivery`.`OXTIMESTAMP` AS `OXTIMESTAMP` from (`oxdelivery` join `oxdelivery2shop` `t2s` on(`t2s`.`OXMAPOBJECTID` = `oxdelivery`.`OXMAPID`)) where `t2s`.`OXSHOPID` = 1 */;

--
-- Final view structure for view `oxv_oxdelivery_1_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxdelivery_1_de`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxdelivery_1_de` AS select `oxdelivery`.`OXID` AS `OXID`,`oxdelivery`.`OXMAPID` AS `OXMAPID`,`oxdelivery`.`OXSHOPID` AS `OXSHOPID`,`oxdelivery`.`OXACTIVE` AS `OXACTIVE`,`oxdelivery`.`OXACTIVEFROM` AS `OXACTIVEFROM`,`oxdelivery`.`OXACTIVETO` AS `OXACTIVETO`,`oxdelivery`.`OXTITLE` AS `OXTITLE`,`oxdelivery`.`OXADDSUMTYPE` AS `OXADDSUMTYPE`,`oxdelivery`.`OXADDSUM` AS `OXADDSUM`,`oxdelivery`.`OXDELTYPE` AS `OXDELTYPE`,`oxdelivery`.`OXPARAM` AS `OXPARAM`,`oxdelivery`.`OXPARAMEND` AS `OXPARAMEND`,`oxdelivery`.`OXFIXED` AS `OXFIXED`,`oxdelivery`.`OXSORT` AS `OXSORT`,`oxdelivery`.`OXFINALIZE` AS `OXFINALIZE`,`oxdelivery`.`OXTIMESTAMP` AS `OXTIMESTAMP` from (`oxdelivery` join `oxdelivery2shop` `t2s` on(`t2s`.`OXMAPOBJECTID` = `oxdelivery`.`OXMAPID`)) where `t2s`.`OXSHOPID` = 1 */;

--
-- Final view structure for view `oxv_oxdelivery_1_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxdelivery_1_en`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxdelivery_1_en` AS select `oxdelivery`.`OXID` AS `OXID`,`oxdelivery`.`OXMAPID` AS `OXMAPID`,`oxdelivery`.`OXSHOPID` AS `OXSHOPID`,`oxdelivery`.`OXACTIVE` AS `OXACTIVE`,`oxdelivery`.`OXACTIVEFROM` AS `OXACTIVEFROM`,`oxdelivery`.`OXACTIVETO` AS `OXACTIVETO`,`oxdelivery`.`OXTITLE_1` AS `OXTITLE`,`oxdelivery`.`OXADDSUMTYPE` AS `OXADDSUMTYPE`,`oxdelivery`.`OXADDSUM` AS `OXADDSUM`,`oxdelivery`.`OXDELTYPE` AS `OXDELTYPE`,`oxdelivery`.`OXPARAM` AS `OXPARAM`,`oxdelivery`.`OXPARAMEND` AS `OXPARAMEND`,`oxdelivery`.`OXFIXED` AS `OXFIXED`,`oxdelivery`.`OXSORT` AS `OXSORT`,`oxdelivery`.`OXFINALIZE` AS `OXFINALIZE`,`oxdelivery`.`OXTIMESTAMP` AS `OXTIMESTAMP` from (`oxdelivery` join `oxdelivery2shop` `t2s` on(`t2s`.`OXMAPOBJECTID` = `oxdelivery`.`OXMAPID`)) where `t2s`.`OXSHOPID` = 1 */;

--
-- Final view structure for view `oxv_oxdelivery_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxdelivery_de`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxdelivery_de` AS select `oxdelivery`.`OXID` AS `OXID`,`oxdelivery`.`OXMAPID` AS `OXMAPID`,`oxdelivery`.`OXSHOPID` AS `OXSHOPID`,`oxdelivery`.`OXACTIVE` AS `OXACTIVE`,`oxdelivery`.`OXACTIVEFROM` AS `OXACTIVEFROM`,`oxdelivery`.`OXACTIVETO` AS `OXACTIVETO`,`oxdelivery`.`OXTITLE` AS `OXTITLE`,`oxdelivery`.`OXADDSUMTYPE` AS `OXADDSUMTYPE`,`oxdelivery`.`OXADDSUM` AS `OXADDSUM`,`oxdelivery`.`OXDELTYPE` AS `OXDELTYPE`,`oxdelivery`.`OXPARAM` AS `OXPARAM`,`oxdelivery`.`OXPARAMEND` AS `OXPARAMEND`,`oxdelivery`.`OXFIXED` AS `OXFIXED`,`oxdelivery`.`OXSORT` AS `OXSORT`,`oxdelivery`.`OXFINALIZE` AS `OXFINALIZE`,`oxdelivery`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxdelivery` */;

--
-- Final view structure for view `oxv_oxdelivery_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxdelivery_en`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxdelivery_en` AS select `oxdelivery`.`OXID` AS `OXID`,`oxdelivery`.`OXMAPID` AS `OXMAPID`,`oxdelivery`.`OXSHOPID` AS `OXSHOPID`,`oxdelivery`.`OXACTIVE` AS `OXACTIVE`,`oxdelivery`.`OXACTIVEFROM` AS `OXACTIVEFROM`,`oxdelivery`.`OXACTIVETO` AS `OXACTIVETO`,`oxdelivery`.`OXTITLE_1` AS `OXTITLE`,`oxdelivery`.`OXADDSUMTYPE` AS `OXADDSUMTYPE`,`oxdelivery`.`OXADDSUM` AS `OXADDSUM`,`oxdelivery`.`OXDELTYPE` AS `OXDELTYPE`,`oxdelivery`.`OXPARAM` AS `OXPARAM`,`oxdelivery`.`OXPARAMEND` AS `OXPARAMEND`,`oxdelivery`.`OXFIXED` AS `OXFIXED`,`oxdelivery`.`OXSORT` AS `OXSORT`,`oxdelivery`.`OXFINALIZE` AS `OXFINALIZE`,`oxdelivery`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxdelivery` */;

--
-- Final view structure for view `oxv_oxdeliveryset`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxdeliveryset`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxdeliveryset` AS select `oxdeliveryset`.`OXID` AS `OXID`,`oxdeliveryset`.`OXMAPID` AS `OXMAPID`,`oxdeliveryset`.`OXSHOPID` AS `OXSHOPID`,`oxdeliveryset`.`OXACTIVE` AS `OXACTIVE`,`oxdeliveryset`.`OXACTIVEFROM` AS `OXACTIVEFROM`,`oxdeliveryset`.`OXACTIVETO` AS `OXACTIVETO`,`oxdeliveryset`.`OXTITLE` AS `OXTITLE`,`oxdeliveryset`.`OXTITLE_1` AS `OXTITLE_1`,`oxdeliveryset`.`OXTITLE_2` AS `OXTITLE_2`,`oxdeliveryset`.`OXTITLE_3` AS `OXTITLE_3`,`oxdeliveryset`.`OXPOS` AS `OXPOS`,`oxdeliveryset`.`OXTIMESTAMP` AS `OXTIMESTAMP`,`oxdeliveryset`.`OXTRACKINGURL` AS `OXTRACKINGURL` from `oxdeliveryset` */;

--
-- Final view structure for view `oxv_oxdeliveryset_1`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxdeliveryset_1`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxdeliveryset_1` AS select `oxdeliveryset`.`OXID` AS `OXID`,`oxdeliveryset`.`OXMAPID` AS `OXMAPID`,`oxdeliveryset`.`OXSHOPID` AS `OXSHOPID`,`oxdeliveryset`.`OXACTIVE` AS `OXACTIVE`,`oxdeliveryset`.`OXACTIVEFROM` AS `OXACTIVEFROM`,`oxdeliveryset`.`OXACTIVETO` AS `OXACTIVETO`,`oxdeliveryset`.`OXTITLE` AS `OXTITLE`,`oxdeliveryset`.`OXTITLE_1` AS `OXTITLE_1`,`oxdeliveryset`.`OXTITLE_2` AS `OXTITLE_2`,`oxdeliveryset`.`OXTITLE_3` AS `OXTITLE_3`,`oxdeliveryset`.`OXPOS` AS `OXPOS`,`oxdeliveryset`.`OXTIMESTAMP` AS `OXTIMESTAMP`,`oxdeliveryset`.`OXTRACKINGURL` AS `OXTRACKINGURL` from (`oxdeliveryset` join `oxdeliveryset2shop` `t2s` on(`t2s`.`OXMAPOBJECTID` = `oxdeliveryset`.`OXMAPID`)) where `t2s`.`OXSHOPID` = 1 */;

--
-- Final view structure for view `oxv_oxdeliveryset_1_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxdeliveryset_1_de`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxdeliveryset_1_de` AS select `oxdeliveryset`.`OXID` AS `OXID`,`oxdeliveryset`.`OXMAPID` AS `OXMAPID`,`oxdeliveryset`.`OXSHOPID` AS `OXSHOPID`,`oxdeliveryset`.`OXACTIVE` AS `OXACTIVE`,`oxdeliveryset`.`OXACTIVEFROM` AS `OXACTIVEFROM`,`oxdeliveryset`.`OXACTIVETO` AS `OXACTIVETO`,`oxdeliveryset`.`OXTITLE` AS `OXTITLE`,`oxdeliveryset`.`OXPOS` AS `OXPOS`,`oxdeliveryset`.`OXTIMESTAMP` AS `OXTIMESTAMP`,`oxdeliveryset`.`OXTRACKINGURL` AS `OXTRACKINGURL` from (`oxdeliveryset` join `oxdeliveryset2shop` `t2s` on(`t2s`.`OXMAPOBJECTID` = `oxdeliveryset`.`OXMAPID`)) where `t2s`.`OXSHOPID` = 1 */;

--
-- Final view structure for view `oxv_oxdeliveryset_1_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxdeliveryset_1_en`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxdeliveryset_1_en` AS select `oxdeliveryset`.`OXID` AS `OXID`,`oxdeliveryset`.`OXMAPID` AS `OXMAPID`,`oxdeliveryset`.`OXSHOPID` AS `OXSHOPID`,`oxdeliveryset`.`OXACTIVE` AS `OXACTIVE`,`oxdeliveryset`.`OXACTIVEFROM` AS `OXACTIVEFROM`,`oxdeliveryset`.`OXACTIVETO` AS `OXACTIVETO`,`oxdeliveryset`.`OXTITLE_1` AS `OXTITLE`,`oxdeliveryset`.`OXPOS` AS `OXPOS`,`oxdeliveryset`.`OXTIMESTAMP` AS `OXTIMESTAMP`,`oxdeliveryset`.`OXTRACKINGURL` AS `OXTRACKINGURL` from (`oxdeliveryset` join `oxdeliveryset2shop` `t2s` on(`t2s`.`OXMAPOBJECTID` = `oxdeliveryset`.`OXMAPID`)) where `t2s`.`OXSHOPID` = 1 */;

--
-- Final view structure for view `oxv_oxdeliveryset_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxdeliveryset_de`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxdeliveryset_de` AS select `oxdeliveryset`.`OXID` AS `OXID`,`oxdeliveryset`.`OXMAPID` AS `OXMAPID`,`oxdeliveryset`.`OXSHOPID` AS `OXSHOPID`,`oxdeliveryset`.`OXACTIVE` AS `OXACTIVE`,`oxdeliveryset`.`OXACTIVEFROM` AS `OXACTIVEFROM`,`oxdeliveryset`.`OXACTIVETO` AS `OXACTIVETO`,`oxdeliveryset`.`OXTITLE` AS `OXTITLE`,`oxdeliveryset`.`OXPOS` AS `OXPOS`,`oxdeliveryset`.`OXTIMESTAMP` AS `OXTIMESTAMP`,`oxdeliveryset`.`OXTRACKINGURL` AS `OXTRACKINGURL` from `oxdeliveryset` */;

--
-- Final view structure for view `oxv_oxdeliveryset_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxdeliveryset_en`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxdeliveryset_en` AS select `oxdeliveryset`.`OXID` AS `OXID`,`oxdeliveryset`.`OXMAPID` AS `OXMAPID`,`oxdeliveryset`.`OXSHOPID` AS `OXSHOPID`,`oxdeliveryset`.`OXACTIVE` AS `OXACTIVE`,`oxdeliveryset`.`OXACTIVEFROM` AS `OXACTIVEFROM`,`oxdeliveryset`.`OXACTIVETO` AS `OXACTIVETO`,`oxdeliveryset`.`OXTITLE_1` AS `OXTITLE`,`oxdeliveryset`.`OXPOS` AS `OXPOS`,`oxdeliveryset`.`OXTIMESTAMP` AS `OXTIMESTAMP`,`oxdeliveryset`.`OXTRACKINGURL` AS `OXTRACKINGURL` from `oxdeliveryset` */;

--
-- Final view structure for view `oxv_oxdiscount`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxdiscount`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxdiscount` AS select `oxdiscount`.`OXID` AS `OXID`,`oxdiscount`.`OXMAPID` AS `OXMAPID`,`oxdiscount`.`OXSHOPID` AS `OXSHOPID`,`oxdiscount`.`OXACTIVE` AS `OXACTIVE`,`oxdiscount`.`OXACTIVEFROM` AS `OXACTIVEFROM`,`oxdiscount`.`OXACTIVETO` AS `OXACTIVETO`,`oxdiscount`.`OXTITLE` AS `OXTITLE`,`oxdiscount`.`OXTITLE_1` AS `OXTITLE_1`,`oxdiscount`.`OXTITLE_2` AS `OXTITLE_2`,`oxdiscount`.`OXTITLE_3` AS `OXTITLE_3`,`oxdiscount`.`OXAMOUNT` AS `OXAMOUNT`,`oxdiscount`.`OXAMOUNTTO` AS `OXAMOUNTTO`,`oxdiscount`.`OXPRICETO` AS `OXPRICETO`,`oxdiscount`.`OXPRICE` AS `OXPRICE`,`oxdiscount`.`OXADDSUMTYPE` AS `OXADDSUMTYPE`,`oxdiscount`.`OXADDSUM` AS `OXADDSUM`,`oxdiscount`.`OXITMARTID` AS `OXITMARTID`,`oxdiscount`.`OXITMAMOUNT` AS `OXITMAMOUNT`,`oxdiscount`.`OXITMMULTIPLE` AS `OXITMMULTIPLE`,`oxdiscount`.`OXSORT` AS `OXSORT`,`oxdiscount`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxdiscount` */;

--
-- Final view structure for view `oxv_oxdiscount_1`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxdiscount_1`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxdiscount_1` AS select `oxdiscount`.`OXID` AS `OXID`,`oxdiscount`.`OXMAPID` AS `OXMAPID`,`oxdiscount`.`OXSHOPID` AS `OXSHOPID`,`oxdiscount`.`OXACTIVE` AS `OXACTIVE`,`oxdiscount`.`OXACTIVEFROM` AS `OXACTIVEFROM`,`oxdiscount`.`OXACTIVETO` AS `OXACTIVETO`,`oxdiscount`.`OXTITLE` AS `OXTITLE`,`oxdiscount`.`OXTITLE_1` AS `OXTITLE_1`,`oxdiscount`.`OXTITLE_2` AS `OXTITLE_2`,`oxdiscount`.`OXTITLE_3` AS `OXTITLE_3`,`oxdiscount`.`OXAMOUNT` AS `OXAMOUNT`,`oxdiscount`.`OXAMOUNTTO` AS `OXAMOUNTTO`,`oxdiscount`.`OXPRICETO` AS `OXPRICETO`,`oxdiscount`.`OXPRICE` AS `OXPRICE`,`oxdiscount`.`OXADDSUMTYPE` AS `OXADDSUMTYPE`,`oxdiscount`.`OXADDSUM` AS `OXADDSUM`,`oxdiscount`.`OXITMARTID` AS `OXITMARTID`,`oxdiscount`.`OXITMAMOUNT` AS `OXITMAMOUNT`,`oxdiscount`.`OXITMMULTIPLE` AS `OXITMMULTIPLE`,`oxdiscount`.`OXSORT` AS `OXSORT`,`oxdiscount`.`OXTIMESTAMP` AS `OXTIMESTAMP` from (`oxdiscount` join `oxdiscount2shop` `t2s` on(`t2s`.`OXMAPOBJECTID` = `oxdiscount`.`OXMAPID`)) where `t2s`.`OXSHOPID` = 1 */;

--
-- Final view structure for view `oxv_oxdiscount_1_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxdiscount_1_de`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxdiscount_1_de` AS select `oxdiscount`.`OXID` AS `OXID`,`oxdiscount`.`OXMAPID` AS `OXMAPID`,`oxdiscount`.`OXSHOPID` AS `OXSHOPID`,`oxdiscount`.`OXACTIVE` AS `OXACTIVE`,`oxdiscount`.`OXACTIVEFROM` AS `OXACTIVEFROM`,`oxdiscount`.`OXACTIVETO` AS `OXACTIVETO`,`oxdiscount`.`OXTITLE` AS `OXTITLE`,`oxdiscount`.`OXAMOUNT` AS `OXAMOUNT`,`oxdiscount`.`OXAMOUNTTO` AS `OXAMOUNTTO`,`oxdiscount`.`OXPRICETO` AS `OXPRICETO`,`oxdiscount`.`OXPRICE` AS `OXPRICE`,`oxdiscount`.`OXADDSUMTYPE` AS `OXADDSUMTYPE`,`oxdiscount`.`OXADDSUM` AS `OXADDSUM`,`oxdiscount`.`OXITMARTID` AS `OXITMARTID`,`oxdiscount`.`OXITMAMOUNT` AS `OXITMAMOUNT`,`oxdiscount`.`OXITMMULTIPLE` AS `OXITMMULTIPLE`,`oxdiscount`.`OXSORT` AS `OXSORT`,`oxdiscount`.`OXTIMESTAMP` AS `OXTIMESTAMP` from (`oxdiscount` join `oxdiscount2shop` `t2s` on(`t2s`.`OXMAPOBJECTID` = `oxdiscount`.`OXMAPID`)) where `t2s`.`OXSHOPID` = 1 */;

--
-- Final view structure for view `oxv_oxdiscount_1_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxdiscount_1_en`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxdiscount_1_en` AS select `oxdiscount`.`OXID` AS `OXID`,`oxdiscount`.`OXMAPID` AS `OXMAPID`,`oxdiscount`.`OXSHOPID` AS `OXSHOPID`,`oxdiscount`.`OXACTIVE` AS `OXACTIVE`,`oxdiscount`.`OXACTIVEFROM` AS `OXACTIVEFROM`,`oxdiscount`.`OXACTIVETO` AS `OXACTIVETO`,`oxdiscount`.`OXTITLE_1` AS `OXTITLE`,`oxdiscount`.`OXAMOUNT` AS `OXAMOUNT`,`oxdiscount`.`OXAMOUNTTO` AS `OXAMOUNTTO`,`oxdiscount`.`OXPRICETO` AS `OXPRICETO`,`oxdiscount`.`OXPRICE` AS `OXPRICE`,`oxdiscount`.`OXADDSUMTYPE` AS `OXADDSUMTYPE`,`oxdiscount`.`OXADDSUM` AS `OXADDSUM`,`oxdiscount`.`OXITMARTID` AS `OXITMARTID`,`oxdiscount`.`OXITMAMOUNT` AS `OXITMAMOUNT`,`oxdiscount`.`OXITMMULTIPLE` AS `OXITMMULTIPLE`,`oxdiscount`.`OXSORT` AS `OXSORT`,`oxdiscount`.`OXTIMESTAMP` AS `OXTIMESTAMP` from (`oxdiscount` join `oxdiscount2shop` `t2s` on(`t2s`.`OXMAPOBJECTID` = `oxdiscount`.`OXMAPID`)) where `t2s`.`OXSHOPID` = 1 */;

--
-- Final view structure for view `oxv_oxdiscount_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxdiscount_de`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxdiscount_de` AS select `oxdiscount`.`OXID` AS `OXID`,`oxdiscount`.`OXMAPID` AS `OXMAPID`,`oxdiscount`.`OXSHOPID` AS `OXSHOPID`,`oxdiscount`.`OXACTIVE` AS `OXACTIVE`,`oxdiscount`.`OXACTIVEFROM` AS `OXACTIVEFROM`,`oxdiscount`.`OXACTIVETO` AS `OXACTIVETO`,`oxdiscount`.`OXTITLE` AS `OXTITLE`,`oxdiscount`.`OXAMOUNT` AS `OXAMOUNT`,`oxdiscount`.`OXAMOUNTTO` AS `OXAMOUNTTO`,`oxdiscount`.`OXPRICETO` AS `OXPRICETO`,`oxdiscount`.`OXPRICE` AS `OXPRICE`,`oxdiscount`.`OXADDSUMTYPE` AS `OXADDSUMTYPE`,`oxdiscount`.`OXADDSUM` AS `OXADDSUM`,`oxdiscount`.`OXITMARTID` AS `OXITMARTID`,`oxdiscount`.`OXITMAMOUNT` AS `OXITMAMOUNT`,`oxdiscount`.`OXITMMULTIPLE` AS `OXITMMULTIPLE`,`oxdiscount`.`OXSORT` AS `OXSORT`,`oxdiscount`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxdiscount` */;

--
-- Final view structure for view `oxv_oxdiscount_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxdiscount_en`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxdiscount_en` AS select `oxdiscount`.`OXID` AS `OXID`,`oxdiscount`.`OXMAPID` AS `OXMAPID`,`oxdiscount`.`OXSHOPID` AS `OXSHOPID`,`oxdiscount`.`OXACTIVE` AS `OXACTIVE`,`oxdiscount`.`OXACTIVEFROM` AS `OXACTIVEFROM`,`oxdiscount`.`OXACTIVETO` AS `OXACTIVETO`,`oxdiscount`.`OXTITLE_1` AS `OXTITLE`,`oxdiscount`.`OXAMOUNT` AS `OXAMOUNT`,`oxdiscount`.`OXAMOUNTTO` AS `OXAMOUNTTO`,`oxdiscount`.`OXPRICETO` AS `OXPRICETO`,`oxdiscount`.`OXPRICE` AS `OXPRICE`,`oxdiscount`.`OXADDSUMTYPE` AS `OXADDSUMTYPE`,`oxdiscount`.`OXADDSUM` AS `OXADDSUM`,`oxdiscount`.`OXITMARTID` AS `OXITMARTID`,`oxdiscount`.`OXITMAMOUNT` AS `OXITMAMOUNT`,`oxdiscount`.`OXITMMULTIPLE` AS `OXITMMULTIPLE`,`oxdiscount`.`OXSORT` AS `OXSORT`,`oxdiscount`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxdiscount` */;

--
-- Final view structure for view `oxv_oxfield2shop`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxfield2shop`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxfield2shop` AS select `oxfield2shop`.`OXID` AS `OXID`,`oxfield2shop`.`OXARTID` AS `OXARTID`,`oxfield2shop`.`OXSHOPID` AS `OXSHOPID`,`oxfield2shop`.`OXPRICE` AS `OXPRICE`,`oxfield2shop`.`OXPRICEA` AS `OXPRICEA`,`oxfield2shop`.`OXPRICEB` AS `OXPRICEB`,`oxfield2shop`.`OXPRICEC` AS `OXPRICEC`,`oxfield2shop`.`OXUPDATEPRICE` AS `OXUPDATEPRICE`,`oxfield2shop`.`OXUPDATEPRICEA` AS `OXUPDATEPRICEA`,`oxfield2shop`.`OXUPDATEPRICEB` AS `OXUPDATEPRICEB`,`oxfield2shop`.`OXUPDATEPRICEC` AS `OXUPDATEPRICEC`,`oxfield2shop`.`OXUPDATEPRICETIME` AS `OXUPDATEPRICETIME`,`oxfield2shop`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxfield2shop` */;

--
-- Final view structure for view `oxv_oxfield2shop_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxfield2shop_de`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxfield2shop_de` AS select `oxfield2shop`.`OXID` AS `OXID`,`oxfield2shop`.`OXARTID` AS `OXARTID`,`oxfield2shop`.`OXSHOPID` AS `OXSHOPID`,`oxfield2shop`.`OXPRICE` AS `OXPRICE`,`oxfield2shop`.`OXPRICEA` AS `OXPRICEA`,`oxfield2shop`.`OXPRICEB` AS `OXPRICEB`,`oxfield2shop`.`OXPRICEC` AS `OXPRICEC`,`oxfield2shop`.`OXUPDATEPRICE` AS `OXUPDATEPRICE`,`oxfield2shop`.`OXUPDATEPRICEA` AS `OXUPDATEPRICEA`,`oxfield2shop`.`OXUPDATEPRICEB` AS `OXUPDATEPRICEB`,`oxfield2shop`.`OXUPDATEPRICEC` AS `OXUPDATEPRICEC`,`oxfield2shop`.`OXUPDATEPRICETIME` AS `OXUPDATEPRICETIME`,`oxfield2shop`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxfield2shop` */;

--
-- Final view structure for view `oxv_oxfield2shop_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxfield2shop_en`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxfield2shop_en` AS select `oxfield2shop`.`OXID` AS `OXID`,`oxfield2shop`.`OXARTID` AS `OXARTID`,`oxfield2shop`.`OXSHOPID` AS `OXSHOPID`,`oxfield2shop`.`OXPRICE` AS `OXPRICE`,`oxfield2shop`.`OXPRICEA` AS `OXPRICEA`,`oxfield2shop`.`OXPRICEB` AS `OXPRICEB`,`oxfield2shop`.`OXPRICEC` AS `OXPRICEC`,`oxfield2shop`.`OXUPDATEPRICE` AS `OXUPDATEPRICE`,`oxfield2shop`.`OXUPDATEPRICEA` AS `OXUPDATEPRICEA`,`oxfield2shop`.`OXUPDATEPRICEB` AS `OXUPDATEPRICEB`,`oxfield2shop`.`OXUPDATEPRICEC` AS `OXUPDATEPRICEC`,`oxfield2shop`.`OXUPDATEPRICETIME` AS `OXUPDATEPRICETIME`,`oxfield2shop`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxfield2shop` */;

--
-- Final view structure for view `oxv_oxgroups`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxgroups`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxgroups` AS select `oxgroups`.`OXID` AS `OXID`,`oxgroups`.`OXRRID` AS `OXRRID`,`oxgroups`.`OXACTIVE` AS `OXACTIVE`,`oxgroups`.`OXTITLE` AS `OXTITLE`,`oxgroups`.`OXTITLE_1` AS `OXTITLE_1`,`oxgroups`.`OXTITLE_2` AS `OXTITLE_2`,`oxgroups`.`OXTITLE_3` AS `OXTITLE_3`,`oxgroups`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxgroups` */;

--
-- Final view structure for view `oxv_oxgroups_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxgroups_de`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxgroups_de` AS select `oxgroups`.`OXID` AS `OXID`,`oxgroups`.`OXRRID` AS `OXRRID`,`oxgroups`.`OXACTIVE` AS `OXACTIVE`,`oxgroups`.`OXTITLE` AS `OXTITLE`,`oxgroups`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxgroups` */;

--
-- Final view structure for view `oxv_oxgroups_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxgroups_en`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxgroups_en` AS select `oxgroups`.`OXID` AS `OXID`,`oxgroups`.`OXRRID` AS `OXRRID`,`oxgroups`.`OXACTIVE` AS `OXACTIVE`,`oxgroups`.`OXTITLE_1` AS `OXTITLE`,`oxgroups`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxgroups` */;

--
-- Final view structure for view `oxv_oxlinks`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxlinks`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxlinks` AS select `oxlinks`.`OXID` AS `OXID`,`oxlinks`.`OXMAPID` AS `OXMAPID`,`oxlinks`.`OXSHOPID` AS `OXSHOPID`,`oxlinks`.`OXACTIVE` AS `OXACTIVE`,`oxlinks`.`OXURL` AS `OXURL`,`oxlinks`.`OXURLDESC` AS `OXURLDESC`,`oxlinks`.`OXURLDESC_1` AS `OXURLDESC_1`,`oxlinks`.`OXURLDESC_2` AS `OXURLDESC_2`,`oxlinks`.`OXURLDESC_3` AS `OXURLDESC_3`,`oxlinks`.`OXINSERT` AS `OXINSERT`,`oxlinks`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxlinks` */;

--
-- Final view structure for view `oxv_oxlinks_1`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxlinks_1`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxlinks_1` AS select `oxlinks`.`OXID` AS `OXID`,`oxlinks`.`OXMAPID` AS `OXMAPID`,`oxlinks`.`OXSHOPID` AS `OXSHOPID`,`oxlinks`.`OXACTIVE` AS `OXACTIVE`,`oxlinks`.`OXURL` AS `OXURL`,`oxlinks`.`OXURLDESC` AS `OXURLDESC`,`oxlinks`.`OXURLDESC_1` AS `OXURLDESC_1`,`oxlinks`.`OXURLDESC_2` AS `OXURLDESC_2`,`oxlinks`.`OXURLDESC_3` AS `OXURLDESC_3`,`oxlinks`.`OXINSERT` AS `OXINSERT`,`oxlinks`.`OXTIMESTAMP` AS `OXTIMESTAMP` from (`oxlinks` join `oxlinks2shop` `t2s` on(`t2s`.`OXMAPOBJECTID` = `oxlinks`.`OXMAPID`)) where `t2s`.`OXSHOPID` = 1 */;

--
-- Final view structure for view `oxv_oxlinks_1_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxlinks_1_de`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxlinks_1_de` AS select `oxlinks`.`OXID` AS `OXID`,`oxlinks`.`OXMAPID` AS `OXMAPID`,`oxlinks`.`OXSHOPID` AS `OXSHOPID`,`oxlinks`.`OXACTIVE` AS `OXACTIVE`,`oxlinks`.`OXURL` AS `OXURL`,`oxlinks`.`OXURLDESC` AS `OXURLDESC`,`oxlinks`.`OXINSERT` AS `OXINSERT`,`oxlinks`.`OXTIMESTAMP` AS `OXTIMESTAMP` from (`oxlinks` join `oxlinks2shop` `t2s` on(`t2s`.`OXMAPOBJECTID` = `oxlinks`.`OXMAPID`)) where `t2s`.`OXSHOPID` = 1 */;

--
-- Final view structure for view `oxv_oxlinks_1_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxlinks_1_en`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxlinks_1_en` AS select `oxlinks`.`OXID` AS `OXID`,`oxlinks`.`OXMAPID` AS `OXMAPID`,`oxlinks`.`OXSHOPID` AS `OXSHOPID`,`oxlinks`.`OXACTIVE` AS `OXACTIVE`,`oxlinks`.`OXURL` AS `OXURL`,`oxlinks`.`OXURLDESC_1` AS `OXURLDESC`,`oxlinks`.`OXINSERT` AS `OXINSERT`,`oxlinks`.`OXTIMESTAMP` AS `OXTIMESTAMP` from (`oxlinks` join `oxlinks2shop` `t2s` on(`t2s`.`OXMAPOBJECTID` = `oxlinks`.`OXMAPID`)) where `t2s`.`OXSHOPID` = 1 */;

--
-- Final view structure for view `oxv_oxlinks_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxlinks_de`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxlinks_de` AS select `oxlinks`.`OXID` AS `OXID`,`oxlinks`.`OXMAPID` AS `OXMAPID`,`oxlinks`.`OXSHOPID` AS `OXSHOPID`,`oxlinks`.`OXACTIVE` AS `OXACTIVE`,`oxlinks`.`OXURL` AS `OXURL`,`oxlinks`.`OXURLDESC` AS `OXURLDESC`,`oxlinks`.`OXINSERT` AS `OXINSERT`,`oxlinks`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxlinks` */;

--
-- Final view structure for view `oxv_oxlinks_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxlinks_en`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxlinks_en` AS select `oxlinks`.`OXID` AS `OXID`,`oxlinks`.`OXMAPID` AS `OXMAPID`,`oxlinks`.`OXSHOPID` AS `OXSHOPID`,`oxlinks`.`OXACTIVE` AS `OXACTIVE`,`oxlinks`.`OXURL` AS `OXURL`,`oxlinks`.`OXURLDESC_1` AS `OXURLDESC`,`oxlinks`.`OXINSERT` AS `OXINSERT`,`oxlinks`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxlinks` */;

--
-- Final view structure for view `oxv_oxmanufacturers`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxmanufacturers`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxmanufacturers` AS select `oxmanufacturers`.`OXID` AS `OXID`,`oxmanufacturers`.`OXMAPID` AS `OXMAPID`,`oxmanufacturers`.`OXSHOPID` AS `OXSHOPID`,`oxmanufacturers`.`OXACTIVE` AS `OXACTIVE`,`oxmanufacturers`.`OXICON` AS `OXICON`,`oxmanufacturers`.`OXTITLE` AS `OXTITLE`,`oxmanufacturers`.`OXSHORTDESC` AS `OXSHORTDESC`,`oxmanufacturers`.`OXTITLE_1` AS `OXTITLE_1`,`oxmanufacturers`.`OXSHORTDESC_1` AS `OXSHORTDESC_1`,`oxmanufacturers`.`OXTITLE_2` AS `OXTITLE_2`,`oxmanufacturers`.`OXSHORTDESC_2` AS `OXSHORTDESC_2`,`oxmanufacturers`.`OXTITLE_3` AS `OXTITLE_3`,`oxmanufacturers`.`OXSHORTDESC_3` AS `OXSHORTDESC_3`,`oxmanufacturers`.`OXSHOWSUFFIX` AS `OXSHOWSUFFIX`,`oxmanufacturers`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxmanufacturers` */;

--
-- Final view structure for view `oxv_oxmanufacturers_1`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxmanufacturers_1`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxmanufacturers_1` AS select `oxmanufacturers`.`OXID` AS `OXID`,`oxmanufacturers`.`OXMAPID` AS `OXMAPID`,`oxmanufacturers`.`OXSHOPID` AS `OXSHOPID`,`oxmanufacturers`.`OXACTIVE` AS `OXACTIVE`,`oxmanufacturers`.`OXICON` AS `OXICON`,`oxmanufacturers`.`OXTITLE` AS `OXTITLE`,`oxmanufacturers`.`OXSHORTDESC` AS `OXSHORTDESC`,`oxmanufacturers`.`OXTITLE_1` AS `OXTITLE_1`,`oxmanufacturers`.`OXSHORTDESC_1` AS `OXSHORTDESC_1`,`oxmanufacturers`.`OXTITLE_2` AS `OXTITLE_2`,`oxmanufacturers`.`OXSHORTDESC_2` AS `OXSHORTDESC_2`,`oxmanufacturers`.`OXTITLE_3` AS `OXTITLE_3`,`oxmanufacturers`.`OXSHORTDESC_3` AS `OXSHORTDESC_3`,`oxmanufacturers`.`OXSHOWSUFFIX` AS `OXSHOWSUFFIX`,`oxmanufacturers`.`OXTIMESTAMP` AS `OXTIMESTAMP` from (`oxmanufacturers` join `oxmanufacturers2shop` `t2s` on(`t2s`.`OXMAPOBJECTID` = `oxmanufacturers`.`OXMAPID`)) where `t2s`.`OXSHOPID` = 1 */;

--
-- Final view structure for view `oxv_oxmanufacturers_1_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxmanufacturers_1_de`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxmanufacturers_1_de` AS select `oxmanufacturers`.`OXID` AS `OXID`,`oxmanufacturers`.`OXMAPID` AS `OXMAPID`,`oxmanufacturers`.`OXSHOPID` AS `OXSHOPID`,`oxmanufacturers`.`OXACTIVE` AS `OXACTIVE`,`oxmanufacturers`.`OXICON` AS `OXICON`,`oxmanufacturers`.`OXTITLE` AS `OXTITLE`,`oxmanufacturers`.`OXSHORTDESC` AS `OXSHORTDESC`,`oxmanufacturers`.`OXSHOWSUFFIX` AS `OXSHOWSUFFIX`,`oxmanufacturers`.`OXTIMESTAMP` AS `OXTIMESTAMP` from (`oxmanufacturers` join `oxmanufacturers2shop` `t2s` on(`t2s`.`OXMAPOBJECTID` = `oxmanufacturers`.`OXMAPID`)) where `t2s`.`OXSHOPID` = 1 */;

--
-- Final view structure for view `oxv_oxmanufacturers_1_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxmanufacturers_1_en`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxmanufacturers_1_en` AS select `oxmanufacturers`.`OXID` AS `OXID`,`oxmanufacturers`.`OXMAPID` AS `OXMAPID`,`oxmanufacturers`.`OXSHOPID` AS `OXSHOPID`,`oxmanufacturers`.`OXACTIVE` AS `OXACTIVE`,`oxmanufacturers`.`OXICON` AS `OXICON`,`oxmanufacturers`.`OXTITLE_1` AS `OXTITLE`,`oxmanufacturers`.`OXSHORTDESC_1` AS `OXSHORTDESC`,`oxmanufacturers`.`OXSHOWSUFFIX` AS `OXSHOWSUFFIX`,`oxmanufacturers`.`OXTIMESTAMP` AS `OXTIMESTAMP` from (`oxmanufacturers` join `oxmanufacturers2shop` `t2s` on(`t2s`.`OXMAPOBJECTID` = `oxmanufacturers`.`OXMAPID`)) where `t2s`.`OXSHOPID` = 1 */;

--
-- Final view structure for view `oxv_oxmanufacturers_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxmanufacturers_de`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxmanufacturers_de` AS select `oxmanufacturers`.`OXID` AS `OXID`,`oxmanufacturers`.`OXMAPID` AS `OXMAPID`,`oxmanufacturers`.`OXSHOPID` AS `OXSHOPID`,`oxmanufacturers`.`OXACTIVE` AS `OXACTIVE`,`oxmanufacturers`.`OXICON` AS `OXICON`,`oxmanufacturers`.`OXTITLE` AS `OXTITLE`,`oxmanufacturers`.`OXSHORTDESC` AS `OXSHORTDESC`,`oxmanufacturers`.`OXSHOWSUFFIX` AS `OXSHOWSUFFIX`,`oxmanufacturers`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxmanufacturers` */;

--
-- Final view structure for view `oxv_oxmanufacturers_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxmanufacturers_en`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxmanufacturers_en` AS select `oxmanufacturers`.`OXID` AS `OXID`,`oxmanufacturers`.`OXMAPID` AS `OXMAPID`,`oxmanufacturers`.`OXSHOPID` AS `OXSHOPID`,`oxmanufacturers`.`OXACTIVE` AS `OXACTIVE`,`oxmanufacturers`.`OXICON` AS `OXICON`,`oxmanufacturers`.`OXTITLE_1` AS `OXTITLE`,`oxmanufacturers`.`OXSHORTDESC_1` AS `OXSHORTDESC`,`oxmanufacturers`.`OXSHOWSUFFIX` AS `OXSHOWSUFFIX`,`oxmanufacturers`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxmanufacturers` */;

--
-- Final view structure for view `oxv_oxmediaurls`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxmediaurls`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxmediaurls` AS select `oxmediaurls`.`OXID` AS `OXID`,`oxmediaurls`.`OXOBJECTID` AS `OXOBJECTID`,`oxmediaurls`.`OXURL` AS `OXURL`,`oxmediaurls`.`OXDESC` AS `OXDESC`,`oxmediaurls`.`OXDESC_1` AS `OXDESC_1`,`oxmediaurls`.`OXDESC_2` AS `OXDESC_2`,`oxmediaurls`.`OXDESC_3` AS `OXDESC_3`,`oxmediaurls`.`OXISUPLOADED` AS `OXISUPLOADED`,`oxmediaurls`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxmediaurls` */;

--
-- Final view structure for view `oxv_oxmediaurls_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxmediaurls_de`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxmediaurls_de` AS select `oxmediaurls`.`OXID` AS `OXID`,`oxmediaurls`.`OXOBJECTID` AS `OXOBJECTID`,`oxmediaurls`.`OXURL` AS `OXURL`,`oxmediaurls`.`OXDESC` AS `OXDESC`,`oxmediaurls`.`OXISUPLOADED` AS `OXISUPLOADED`,`oxmediaurls`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxmediaurls` */;

--
-- Final view structure for view `oxv_oxmediaurls_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxmediaurls_en`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxmediaurls_en` AS select `oxmediaurls`.`OXID` AS `OXID`,`oxmediaurls`.`OXOBJECTID` AS `OXOBJECTID`,`oxmediaurls`.`OXURL` AS `OXURL`,`oxmediaurls`.`OXDESC_1` AS `OXDESC`,`oxmediaurls`.`OXISUPLOADED` AS `OXISUPLOADED`,`oxmediaurls`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxmediaurls` */;

--
-- Final view structure for view `oxv_oxobject2attribute`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxobject2attribute`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxobject2attribute` AS select `oxobject2attribute`.`OXID` AS `OXID`,`oxobject2attribute`.`OXOBJECTID` AS `OXOBJECTID`,`oxobject2attribute`.`OXATTRID` AS `OXATTRID`,`oxobject2attribute`.`OXVALUE` AS `OXVALUE`,`oxobject2attribute`.`OXPOS` AS `OXPOS`,`oxobject2attribute`.`OXVALUE_1` AS `OXVALUE_1`,`oxobject2attribute`.`OXVALUE_2` AS `OXVALUE_2`,`oxobject2attribute`.`OXVALUE_3` AS `OXVALUE_3`,`oxobject2attribute`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxobject2attribute` */;

--
-- Final view structure for view `oxv_oxobject2attribute_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxobject2attribute_de`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxobject2attribute_de` AS select `oxobject2attribute`.`OXID` AS `OXID`,`oxobject2attribute`.`OXOBJECTID` AS `OXOBJECTID`,`oxobject2attribute`.`OXATTRID` AS `OXATTRID`,`oxobject2attribute`.`OXVALUE` AS `OXVALUE`,`oxobject2attribute`.`OXPOS` AS `OXPOS`,`oxobject2attribute`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxobject2attribute` */;

--
-- Final view structure for view `oxv_oxobject2attribute_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxobject2attribute_en`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxobject2attribute_en` AS select `oxobject2attribute`.`OXID` AS `OXID`,`oxobject2attribute`.`OXOBJECTID` AS `OXOBJECTID`,`oxobject2attribute`.`OXATTRID` AS `OXATTRID`,`oxobject2attribute`.`OXVALUE_1` AS `OXVALUE`,`oxobject2attribute`.`OXPOS` AS `OXPOS`,`oxobject2attribute`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxobject2attribute` */;

--
-- Final view structure for view `oxv_oxobject2category`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxobject2category`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxobject2category` AS select `oxobject2category`.`OXID` AS `OXID`,`oxobject2category`.`OXSHOPID` AS `OXSHOPID`,`oxobject2category`.`OXOBJECTID` AS `OXOBJECTID`,`oxobject2category`.`OXCATNID` AS `OXCATNID`,`oxobject2category`.`OXPOS` AS `OXPOS`,`oxobject2category`.`OXTIME` AS `OXTIME`,`oxobject2category`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxobject2category` */;

--
-- Final view structure for view `oxv_oxobject2category_1`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxobject2category_1`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxobject2category_1` AS select `oxobject2category`.`OXID` AS `OXID`,`oxobject2category`.`OXSHOPID` AS `OXSHOPID`,`oxobject2category`.`OXOBJECTID` AS `OXOBJECTID`,`oxobject2category`.`OXCATNID` AS `OXCATNID`,`oxobject2category`.`OXPOS` AS `OXPOS`,`oxobject2category`.`OXTIME` AS `OXTIME`,`oxobject2category`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxobject2category` where `oxobject2category`.`OXSHOPID` = 1 */;

--
-- Final view structure for view `oxv_oxpayments`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxpayments`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxpayments` AS select `oxpayments`.`OXID` AS `OXID`,`oxpayments`.`OXACTIVE` AS `OXACTIVE`,`oxpayments`.`OXDESC` AS `OXDESC`,`oxpayments`.`OXADDSUM` AS `OXADDSUM`,`oxpayments`.`OXADDSUMTYPE` AS `OXADDSUMTYPE`,`oxpayments`.`OXADDSUMRULES` AS `OXADDSUMRULES`,`oxpayments`.`OXFROMBONI` AS `OXFROMBONI`,`oxpayments`.`OXFROMAMOUNT` AS `OXFROMAMOUNT`,`oxpayments`.`OXTOAMOUNT` AS `OXTOAMOUNT`,`oxpayments`.`OXVALDESC` AS `OXVALDESC`,`oxpayments`.`OXCHECKED` AS `OXCHECKED`,`oxpayments`.`OXDESC_1` AS `OXDESC_1`,`oxpayments`.`OXVALDESC_1` AS `OXVALDESC_1`,`oxpayments`.`OXDESC_2` AS `OXDESC_2`,`oxpayments`.`OXVALDESC_2` AS `OXVALDESC_2`,`oxpayments`.`OXDESC_3` AS `OXDESC_3`,`oxpayments`.`OXVALDESC_3` AS `OXVALDESC_3`,`oxpayments`.`OXLONGDESC` AS `OXLONGDESC`,`oxpayments`.`OXLONGDESC_1` AS `OXLONGDESC_1`,`oxpayments`.`OXLONGDESC_2` AS `OXLONGDESC_2`,`oxpayments`.`OXLONGDESC_3` AS `OXLONGDESC_3`,`oxpayments`.`OXSORT` AS `OXSORT`,`oxpayments`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxpayments` */;

--
-- Final view structure for view `oxv_oxpayments_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxpayments_de`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxpayments_de` AS select `oxpayments`.`OXID` AS `OXID`,`oxpayments`.`OXACTIVE` AS `OXACTIVE`,`oxpayments`.`OXDESC` AS `OXDESC`,`oxpayments`.`OXADDSUM` AS `OXADDSUM`,`oxpayments`.`OXADDSUMTYPE` AS `OXADDSUMTYPE`,`oxpayments`.`OXADDSUMRULES` AS `OXADDSUMRULES`,`oxpayments`.`OXFROMBONI` AS `OXFROMBONI`,`oxpayments`.`OXFROMAMOUNT` AS `OXFROMAMOUNT`,`oxpayments`.`OXTOAMOUNT` AS `OXTOAMOUNT`,`oxpayments`.`OXVALDESC` AS `OXVALDESC`,`oxpayments`.`OXCHECKED` AS `OXCHECKED`,`oxpayments`.`OXLONGDESC` AS `OXLONGDESC`,`oxpayments`.`OXSORT` AS `OXSORT`,`oxpayments`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxpayments` */;

--
-- Final view structure for view `oxv_oxpayments_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxpayments_en`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxpayments_en` AS select `oxpayments`.`OXID` AS `OXID`,`oxpayments`.`OXACTIVE` AS `OXACTIVE`,`oxpayments`.`OXDESC_1` AS `OXDESC`,`oxpayments`.`OXADDSUM` AS `OXADDSUM`,`oxpayments`.`OXADDSUMTYPE` AS `OXADDSUMTYPE`,`oxpayments`.`OXADDSUMRULES` AS `OXADDSUMRULES`,`oxpayments`.`OXFROMBONI` AS `OXFROMBONI`,`oxpayments`.`OXFROMAMOUNT` AS `OXFROMAMOUNT`,`oxpayments`.`OXTOAMOUNT` AS `OXTOAMOUNT`,`oxpayments`.`OXVALDESC_1` AS `OXVALDESC`,`oxpayments`.`OXCHECKED` AS `OXCHECKED`,`oxpayments`.`OXLONGDESC_1` AS `OXLONGDESC`,`oxpayments`.`OXSORT` AS `OXSORT`,`oxpayments`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxpayments` */;

--
-- Final view structure for view `oxv_oxselectlist`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxselectlist`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxselectlist` AS select `oxselectlist`.`OXID` AS `OXID`,`oxselectlist`.`OXMAPID` AS `OXMAPID`,`oxselectlist`.`OXSHOPID` AS `OXSHOPID`,`oxselectlist`.`OXTITLE` AS `OXTITLE`,`oxselectlist`.`OXIDENT` AS `OXIDENT`,`oxselectlist`.`OXVALDESC` AS `OXVALDESC`,`oxselectlist`.`OXTITLE_1` AS `OXTITLE_1`,`oxselectlist`.`OXVALDESC_1` AS `OXVALDESC_1`,`oxselectlist`.`OXTITLE_2` AS `OXTITLE_2`,`oxselectlist`.`OXVALDESC_2` AS `OXVALDESC_2`,`oxselectlist`.`OXTITLE_3` AS `OXTITLE_3`,`oxselectlist`.`OXVALDESC_3` AS `OXVALDESC_3`,`oxselectlist`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxselectlist` */;

--
-- Final view structure for view `oxv_oxselectlist_1`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxselectlist_1`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxselectlist_1` AS select `oxselectlist`.`OXID` AS `OXID`,`oxselectlist`.`OXMAPID` AS `OXMAPID`,`oxselectlist`.`OXSHOPID` AS `OXSHOPID`,`oxselectlist`.`OXTITLE` AS `OXTITLE`,`oxselectlist`.`OXIDENT` AS `OXIDENT`,`oxselectlist`.`OXVALDESC` AS `OXVALDESC`,`oxselectlist`.`OXTITLE_1` AS `OXTITLE_1`,`oxselectlist`.`OXVALDESC_1` AS `OXVALDESC_1`,`oxselectlist`.`OXTITLE_2` AS `OXTITLE_2`,`oxselectlist`.`OXVALDESC_2` AS `OXVALDESC_2`,`oxselectlist`.`OXTITLE_3` AS `OXTITLE_3`,`oxselectlist`.`OXVALDESC_3` AS `OXVALDESC_3`,`oxselectlist`.`OXTIMESTAMP` AS `OXTIMESTAMP` from (`oxselectlist` join `oxselectlist2shop` `t2s` on(`t2s`.`OXMAPOBJECTID` = `oxselectlist`.`OXMAPID`)) where `t2s`.`OXSHOPID` = 1 */;

--
-- Final view structure for view `oxv_oxselectlist_1_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxselectlist_1_de`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxselectlist_1_de` AS select `oxselectlist`.`OXID` AS `OXID`,`oxselectlist`.`OXMAPID` AS `OXMAPID`,`oxselectlist`.`OXSHOPID` AS `OXSHOPID`,`oxselectlist`.`OXTITLE` AS `OXTITLE`,`oxselectlist`.`OXIDENT` AS `OXIDENT`,`oxselectlist`.`OXVALDESC` AS `OXVALDESC`,`oxselectlist`.`OXTIMESTAMP` AS `OXTIMESTAMP` from (`oxselectlist` join `oxselectlist2shop` `t2s` on(`t2s`.`OXMAPOBJECTID` = `oxselectlist`.`OXMAPID`)) where `t2s`.`OXSHOPID` = 1 */;

--
-- Final view structure for view `oxv_oxselectlist_1_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxselectlist_1_en`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxselectlist_1_en` AS select `oxselectlist`.`OXID` AS `OXID`,`oxselectlist`.`OXMAPID` AS `OXMAPID`,`oxselectlist`.`OXSHOPID` AS `OXSHOPID`,`oxselectlist`.`OXTITLE_1` AS `OXTITLE`,`oxselectlist`.`OXIDENT` AS `OXIDENT`,`oxselectlist`.`OXVALDESC_1` AS `OXVALDESC`,`oxselectlist`.`OXTIMESTAMP` AS `OXTIMESTAMP` from (`oxselectlist` join `oxselectlist2shop` `t2s` on(`t2s`.`OXMAPOBJECTID` = `oxselectlist`.`OXMAPID`)) where `t2s`.`OXSHOPID` = 1 */;

--
-- Final view structure for view `oxv_oxselectlist_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxselectlist_de`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxselectlist_de` AS select `oxselectlist`.`OXID` AS `OXID`,`oxselectlist`.`OXMAPID` AS `OXMAPID`,`oxselectlist`.`OXSHOPID` AS `OXSHOPID`,`oxselectlist`.`OXTITLE` AS `OXTITLE`,`oxselectlist`.`OXIDENT` AS `OXIDENT`,`oxselectlist`.`OXVALDESC` AS `OXVALDESC`,`oxselectlist`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxselectlist` */;

--
-- Final view structure for view `oxv_oxselectlist_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxselectlist_en`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxselectlist_en` AS select `oxselectlist`.`OXID` AS `OXID`,`oxselectlist`.`OXMAPID` AS `OXMAPID`,`oxselectlist`.`OXSHOPID` AS `OXSHOPID`,`oxselectlist`.`OXTITLE_1` AS `OXTITLE`,`oxselectlist`.`OXIDENT` AS `OXIDENT`,`oxselectlist`.`OXVALDESC_1` AS `OXVALDESC`,`oxselectlist`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxselectlist` */;

--
-- Final view structure for view `oxv_oxshops`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxshops`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxshops` AS select `oxshops`.`OXID` AS `OXID`,`oxshops`.`OXPARENTID` AS `OXPARENTID`,`oxshops`.`OXACTIVE` AS `OXACTIVE`,`oxshops`.`OXISINHERITED` AS `OXISINHERITED`,`oxshops`.`OXISMULTISHOP` AS `OXISMULTISHOP`,`oxshops`.`OXISSUPERSHOP` AS `OXISSUPERSHOP`,`oxshops`.`OXPRODUCTIVE` AS `OXPRODUCTIVE`,`oxshops`.`OXDEFCURRENCY` AS `OXDEFCURRENCY`,`oxshops`.`OXDEFLANGUAGE` AS `OXDEFLANGUAGE`,`oxshops`.`OXNAME` AS `OXNAME`,`oxshops`.`OXTITLEPREFIX` AS `OXTITLEPREFIX`,`oxshops`.`OXTITLEPREFIX_1` AS `OXTITLEPREFIX_1`,`oxshops`.`OXTITLEPREFIX_2` AS `OXTITLEPREFIX_2`,`oxshops`.`OXTITLEPREFIX_3` AS `OXTITLEPREFIX_3`,`oxshops`.`OXTITLESUFFIX` AS `OXTITLESUFFIX`,`oxshops`.`OXTITLESUFFIX_1` AS `OXTITLESUFFIX_1`,`oxshops`.`OXTITLESUFFIX_2` AS `OXTITLESUFFIX_2`,`oxshops`.`OXTITLESUFFIX_3` AS `OXTITLESUFFIX_3`,`oxshops`.`OXSTARTTITLE` AS `OXSTARTTITLE`,`oxshops`.`OXSTARTTITLE_1` AS `OXSTARTTITLE_1`,`oxshops`.`OXSTARTTITLE_2` AS `OXSTARTTITLE_2`,`oxshops`.`OXSTARTTITLE_3` AS `OXSTARTTITLE_3`,`oxshops`.`OXINFOEMAIL` AS `OXINFOEMAIL`,`oxshops`.`OXORDEREMAIL` AS `OXORDEREMAIL`,`oxshops`.`OXOWNEREMAIL` AS `OXOWNEREMAIL`,`oxshops`.`OXORDERSUBJECT` AS `OXORDERSUBJECT`,`oxshops`.`OXREGISTERSUBJECT` AS `OXREGISTERSUBJECT`,`oxshops`.`OXFORGOTPWDSUBJECT` AS `OXFORGOTPWDSUBJECT`,`oxshops`.`OXSENDEDNOWSUBJECT` AS `OXSENDEDNOWSUBJECT`,`oxshops`.`OXORDERSUBJECT_1` AS `OXORDERSUBJECT_1`,`oxshops`.`OXREGISTERSUBJECT_1` AS `OXREGISTERSUBJECT_1`,`oxshops`.`OXFORGOTPWDSUBJECT_1` AS `OXFORGOTPWDSUBJECT_1`,`oxshops`.`OXSENDEDNOWSUBJECT_1` AS `OXSENDEDNOWSUBJECT_1`,`oxshops`.`OXORDERSUBJECT_2` AS `OXORDERSUBJECT_2`,`oxshops`.`OXREGISTERSUBJECT_2` AS `OXREGISTERSUBJECT_2`,`oxshops`.`OXFORGOTPWDSUBJECT_2` AS `OXFORGOTPWDSUBJECT_2`,`oxshops`.`OXSENDEDNOWSUBJECT_2` AS `OXSENDEDNOWSUBJECT_2`,`oxshops`.`OXORDERSUBJECT_3` AS `OXORDERSUBJECT_3`,`oxshops`.`OXREGISTERSUBJECT_3` AS `OXREGISTERSUBJECT_3`,`oxshops`.`OXFORGOTPWDSUBJECT_3` AS `OXFORGOTPWDSUBJECT_3`,`oxshops`.`OXSENDEDNOWSUBJECT_3` AS `OXSENDEDNOWSUBJECT_3`,`oxshops`.`OXSMTP` AS `OXSMTP`,`oxshops`.`OXSMTPUSER` AS `OXSMTPUSER`,`oxshops`.`OXSMTPPWD` AS `OXSMTPPWD`,`oxshops`.`OXCOMPANY` AS `OXCOMPANY`,`oxshops`.`OXSTREET` AS `OXSTREET`,`oxshops`.`OXZIP` AS `OXZIP`,`oxshops`.`OXCITY` AS `OXCITY`,`oxshops`.`OXCOUNTRY` AS `OXCOUNTRY`,`oxshops`.`OXBANKNAME` AS `OXBANKNAME`,`oxshops`.`OXBANKNUMBER` AS `OXBANKNUMBER`,`oxshops`.`OXBANKCODE` AS `OXBANKCODE`,`oxshops`.`OXVATNUMBER` AS `OXVATNUMBER`,`oxshops`.`OXTAXNUMBER` AS `OXTAXNUMBER`,`oxshops`.`OXBICCODE` AS `OXBICCODE`,`oxshops`.`OXIBANNUMBER` AS `OXIBANNUMBER`,`oxshops`.`OXFNAME` AS `OXFNAME`,`oxshops`.`OXLNAME` AS `OXLNAME`,`oxshops`.`OXTELEFON` AS `OXTELEFON`,`oxshops`.`OXTELEFAX` AS `OXTELEFAX`,`oxshops`.`OXURL` AS `OXURL`,`oxshops`.`OXDEFCAT` AS `OXDEFCAT`,`oxshops`.`OXHRBNR` AS `OXHRBNR`,`oxshops`.`OXCOURT` AS `OXCOURT`,`oxshops`.`OXADBUTLERID` AS `OXADBUTLERID`,`oxshops`.`OXAFFILINETID` AS `OXAFFILINETID`,`oxshops`.`OXSUPERCLICKSID` AS `OXSUPERCLICKSID`,`oxshops`.`OXAFFILIWELTID` AS `OXAFFILIWELTID`,`oxshops`.`OXAFFILI24ID` AS `OXAFFILI24ID`,`oxshops`.`OXEDITION` AS `OXEDITION`,`oxshops`.`OXVERSION` AS `OXVERSION`,`oxshops`.`OXSEOACTIVE` AS `OXSEOACTIVE`,`oxshops`.`OXSEOACTIVE_1` AS `OXSEOACTIVE_1`,`oxshops`.`OXSEOACTIVE_2` AS `OXSEOACTIVE_2`,`oxshops`.`OXSEOACTIVE_3` AS `OXSEOACTIVE_3`,`oxshops`.`OXTIMESTAMP` AS `OXTIMESTAMP`,`oxshops`.`OXSERIAL` AS `OXSERIAL` from `oxshops` */;

--
-- Final view structure for view `oxv_oxshops_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxshops_de`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxshops_de` AS select `oxshops`.`OXID` AS `OXID`,`oxshops`.`OXPARENTID` AS `OXPARENTID`,`oxshops`.`OXACTIVE` AS `OXACTIVE`,`oxshops`.`OXISINHERITED` AS `OXISINHERITED`,`oxshops`.`OXISMULTISHOP` AS `OXISMULTISHOP`,`oxshops`.`OXISSUPERSHOP` AS `OXISSUPERSHOP`,`oxshops`.`OXPRODUCTIVE` AS `OXPRODUCTIVE`,`oxshops`.`OXDEFCURRENCY` AS `OXDEFCURRENCY`,`oxshops`.`OXDEFLANGUAGE` AS `OXDEFLANGUAGE`,`oxshops`.`OXNAME` AS `OXNAME`,`oxshops`.`OXTITLEPREFIX` AS `OXTITLEPREFIX`,`oxshops`.`OXTITLESUFFIX` AS `OXTITLESUFFIX`,`oxshops`.`OXSTARTTITLE` AS `OXSTARTTITLE`,`oxshops`.`OXINFOEMAIL` AS `OXINFOEMAIL`,`oxshops`.`OXORDEREMAIL` AS `OXORDEREMAIL`,`oxshops`.`OXOWNEREMAIL` AS `OXOWNEREMAIL`,`oxshops`.`OXORDERSUBJECT` AS `OXORDERSUBJECT`,`oxshops`.`OXREGISTERSUBJECT` AS `OXREGISTERSUBJECT`,`oxshops`.`OXFORGOTPWDSUBJECT` AS `OXFORGOTPWDSUBJECT`,`oxshops`.`OXSENDEDNOWSUBJECT` AS `OXSENDEDNOWSUBJECT`,`oxshops`.`OXSMTP` AS `OXSMTP`,`oxshops`.`OXSMTPUSER` AS `OXSMTPUSER`,`oxshops`.`OXSMTPPWD` AS `OXSMTPPWD`,`oxshops`.`OXCOMPANY` AS `OXCOMPANY`,`oxshops`.`OXSTREET` AS `OXSTREET`,`oxshops`.`OXZIP` AS `OXZIP`,`oxshops`.`OXCITY` AS `OXCITY`,`oxshops`.`OXCOUNTRY` AS `OXCOUNTRY`,`oxshops`.`OXBANKNAME` AS `OXBANKNAME`,`oxshops`.`OXBANKNUMBER` AS `OXBANKNUMBER`,`oxshops`.`OXBANKCODE` AS `OXBANKCODE`,`oxshops`.`OXVATNUMBER` AS `OXVATNUMBER`,`oxshops`.`OXTAXNUMBER` AS `OXTAXNUMBER`,`oxshops`.`OXBICCODE` AS `OXBICCODE`,`oxshops`.`OXIBANNUMBER` AS `OXIBANNUMBER`,`oxshops`.`OXFNAME` AS `OXFNAME`,`oxshops`.`OXLNAME` AS `OXLNAME`,`oxshops`.`OXTELEFON` AS `OXTELEFON`,`oxshops`.`OXTELEFAX` AS `OXTELEFAX`,`oxshops`.`OXURL` AS `OXURL`,`oxshops`.`OXDEFCAT` AS `OXDEFCAT`,`oxshops`.`OXHRBNR` AS `OXHRBNR`,`oxshops`.`OXCOURT` AS `OXCOURT`,`oxshops`.`OXADBUTLERID` AS `OXADBUTLERID`,`oxshops`.`OXAFFILINETID` AS `OXAFFILINETID`,`oxshops`.`OXSUPERCLICKSID` AS `OXSUPERCLICKSID`,`oxshops`.`OXAFFILIWELTID` AS `OXAFFILIWELTID`,`oxshops`.`OXAFFILI24ID` AS `OXAFFILI24ID`,`oxshops`.`OXEDITION` AS `OXEDITION`,`oxshops`.`OXVERSION` AS `OXVERSION`,`oxshops`.`OXSEOACTIVE` AS `OXSEOACTIVE`,`oxshops`.`OXTIMESTAMP` AS `OXTIMESTAMP`,`oxshops`.`OXSERIAL` AS `OXSERIAL` from `oxshops` */;

--
-- Final view structure for view `oxv_oxshops_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxshops_en`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxshops_en` AS select `oxshops`.`OXID` AS `OXID`,`oxshops`.`OXPARENTID` AS `OXPARENTID`,`oxshops`.`OXACTIVE` AS `OXACTIVE`,`oxshops`.`OXISINHERITED` AS `OXISINHERITED`,`oxshops`.`OXISMULTISHOP` AS `OXISMULTISHOP`,`oxshops`.`OXISSUPERSHOP` AS `OXISSUPERSHOP`,`oxshops`.`OXPRODUCTIVE` AS `OXPRODUCTIVE`,`oxshops`.`OXDEFCURRENCY` AS `OXDEFCURRENCY`,`oxshops`.`OXDEFLANGUAGE` AS `OXDEFLANGUAGE`,`oxshops`.`OXNAME` AS `OXNAME`,`oxshops`.`OXTITLEPREFIX_1` AS `OXTITLEPREFIX`,`oxshops`.`OXTITLESUFFIX_1` AS `OXTITLESUFFIX`,`oxshops`.`OXSTARTTITLE_1` AS `OXSTARTTITLE`,`oxshops`.`OXINFOEMAIL` AS `OXINFOEMAIL`,`oxshops`.`OXORDEREMAIL` AS `OXORDEREMAIL`,`oxshops`.`OXOWNEREMAIL` AS `OXOWNEREMAIL`,`oxshops`.`OXORDERSUBJECT_1` AS `OXORDERSUBJECT`,`oxshops`.`OXREGISTERSUBJECT_1` AS `OXREGISTERSUBJECT`,`oxshops`.`OXFORGOTPWDSUBJECT_1` AS `OXFORGOTPWDSUBJECT`,`oxshops`.`OXSENDEDNOWSUBJECT_1` AS `OXSENDEDNOWSUBJECT`,`oxshops`.`OXSMTP` AS `OXSMTP`,`oxshops`.`OXSMTPUSER` AS `OXSMTPUSER`,`oxshops`.`OXSMTPPWD` AS `OXSMTPPWD`,`oxshops`.`OXCOMPANY` AS `OXCOMPANY`,`oxshops`.`OXSTREET` AS `OXSTREET`,`oxshops`.`OXZIP` AS `OXZIP`,`oxshops`.`OXCITY` AS `OXCITY`,`oxshops`.`OXCOUNTRY` AS `OXCOUNTRY`,`oxshops`.`OXBANKNAME` AS `OXBANKNAME`,`oxshops`.`OXBANKNUMBER` AS `OXBANKNUMBER`,`oxshops`.`OXBANKCODE` AS `OXBANKCODE`,`oxshops`.`OXVATNUMBER` AS `OXVATNUMBER`,`oxshops`.`OXTAXNUMBER` AS `OXTAXNUMBER`,`oxshops`.`OXBICCODE` AS `OXBICCODE`,`oxshops`.`OXIBANNUMBER` AS `OXIBANNUMBER`,`oxshops`.`OXFNAME` AS `OXFNAME`,`oxshops`.`OXLNAME` AS `OXLNAME`,`oxshops`.`OXTELEFON` AS `OXTELEFON`,`oxshops`.`OXTELEFAX` AS `OXTELEFAX`,`oxshops`.`OXURL` AS `OXURL`,`oxshops`.`OXDEFCAT` AS `OXDEFCAT`,`oxshops`.`OXHRBNR` AS `OXHRBNR`,`oxshops`.`OXCOURT` AS `OXCOURT`,`oxshops`.`OXADBUTLERID` AS `OXADBUTLERID`,`oxshops`.`OXAFFILINETID` AS `OXAFFILINETID`,`oxshops`.`OXSUPERCLICKSID` AS `OXSUPERCLICKSID`,`oxshops`.`OXAFFILIWELTID` AS `OXAFFILIWELTID`,`oxshops`.`OXAFFILI24ID` AS `OXAFFILI24ID`,`oxshops`.`OXEDITION` AS `OXEDITION`,`oxshops`.`OXVERSION` AS `OXVERSION`,`oxshops`.`OXSEOACTIVE_1` AS `OXSEOACTIVE`,`oxshops`.`OXTIMESTAMP` AS `OXTIMESTAMP`,`oxshops`.`OXSERIAL` AS `OXSERIAL` from `oxshops` */;

--
-- Final view structure for view `oxv_oxstates`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxstates`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxstates` AS select `oxstates`.`OXID` AS `OXID`,`oxstates`.`OXCOUNTRYID` AS `OXCOUNTRYID`,`oxstates`.`OXTITLE` AS `OXTITLE`,`oxstates`.`OXISOALPHA2` AS `OXISOALPHA2`,`oxstates`.`OXTITLE_1` AS `OXTITLE_1`,`oxstates`.`OXTITLE_2` AS `OXTITLE_2`,`oxstates`.`OXTITLE_3` AS `OXTITLE_3`,`oxstates`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxstates` */;

--
-- Final view structure for view `oxv_oxstates_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxstates_de`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxstates_de` AS select `oxstates`.`OXID` AS `OXID`,`oxstates`.`OXCOUNTRYID` AS `OXCOUNTRYID`,`oxstates`.`OXTITLE` AS `OXTITLE`,`oxstates`.`OXISOALPHA2` AS `OXISOALPHA2`,`oxstates`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxstates` */;

--
-- Final view structure for view `oxv_oxstates_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxstates_en`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxstates_en` AS select `oxstates`.`OXID` AS `OXID`,`oxstates`.`OXCOUNTRYID` AS `OXCOUNTRYID`,`oxstates`.`OXTITLE_1` AS `OXTITLE`,`oxstates`.`OXISOALPHA2` AS `OXISOALPHA2`,`oxstates`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxstates` */;

--
-- Final view structure for view `oxv_oxvendor`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxvendor`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxvendor` AS select `oxvendor`.`OXID` AS `OXID`,`oxvendor`.`OXMAPID` AS `OXMAPID`,`oxvendor`.`OXSHOPID` AS `OXSHOPID`,`oxvendor`.`OXACTIVE` AS `OXACTIVE`,`oxvendor`.`OXICON` AS `OXICON`,`oxvendor`.`OXTITLE` AS `OXTITLE`,`oxvendor`.`OXSHORTDESC` AS `OXSHORTDESC`,`oxvendor`.`OXTITLE_1` AS `OXTITLE_1`,`oxvendor`.`OXSHORTDESC_1` AS `OXSHORTDESC_1`,`oxvendor`.`OXTITLE_2` AS `OXTITLE_2`,`oxvendor`.`OXSHORTDESC_2` AS `OXSHORTDESC_2`,`oxvendor`.`OXTITLE_3` AS `OXTITLE_3`,`oxvendor`.`OXSHORTDESC_3` AS `OXSHORTDESC_3`,`oxvendor`.`OXSHOWSUFFIX` AS `OXSHOWSUFFIX`,`oxvendor`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxvendor` */;

--
-- Final view structure for view `oxv_oxvendor_1`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxvendor_1`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxvendor_1` AS select `oxvendor`.`OXID` AS `OXID`,`oxvendor`.`OXMAPID` AS `OXMAPID`,`oxvendor`.`OXSHOPID` AS `OXSHOPID`,`oxvendor`.`OXACTIVE` AS `OXACTIVE`,`oxvendor`.`OXICON` AS `OXICON`,`oxvendor`.`OXTITLE` AS `OXTITLE`,`oxvendor`.`OXSHORTDESC` AS `OXSHORTDESC`,`oxvendor`.`OXTITLE_1` AS `OXTITLE_1`,`oxvendor`.`OXSHORTDESC_1` AS `OXSHORTDESC_1`,`oxvendor`.`OXTITLE_2` AS `OXTITLE_2`,`oxvendor`.`OXSHORTDESC_2` AS `OXSHORTDESC_2`,`oxvendor`.`OXTITLE_3` AS `OXTITLE_3`,`oxvendor`.`OXSHORTDESC_3` AS `OXSHORTDESC_3`,`oxvendor`.`OXSHOWSUFFIX` AS `OXSHOWSUFFIX`,`oxvendor`.`OXTIMESTAMP` AS `OXTIMESTAMP` from (`oxvendor` join `oxvendor2shop` `t2s` on(`t2s`.`OXMAPOBJECTID` = `oxvendor`.`OXMAPID`)) where `t2s`.`OXSHOPID` = 1 */;

--
-- Final view structure for view `oxv_oxvendor_1_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxvendor_1_de`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxvendor_1_de` AS select `oxvendor`.`OXID` AS `OXID`,`oxvendor`.`OXMAPID` AS `OXMAPID`,`oxvendor`.`OXSHOPID` AS `OXSHOPID`,`oxvendor`.`OXACTIVE` AS `OXACTIVE`,`oxvendor`.`OXICON` AS `OXICON`,`oxvendor`.`OXTITLE` AS `OXTITLE`,`oxvendor`.`OXSHORTDESC` AS `OXSHORTDESC`,`oxvendor`.`OXSHOWSUFFIX` AS `OXSHOWSUFFIX`,`oxvendor`.`OXTIMESTAMP` AS `OXTIMESTAMP` from (`oxvendor` join `oxvendor2shop` `t2s` on(`t2s`.`OXMAPOBJECTID` = `oxvendor`.`OXMAPID`)) where `t2s`.`OXSHOPID` = 1 */;

--
-- Final view structure for view `oxv_oxvendor_1_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxvendor_1_en`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxvendor_1_en` AS select `oxvendor`.`OXID` AS `OXID`,`oxvendor`.`OXMAPID` AS `OXMAPID`,`oxvendor`.`OXSHOPID` AS `OXSHOPID`,`oxvendor`.`OXACTIVE` AS `OXACTIVE`,`oxvendor`.`OXICON` AS `OXICON`,`oxvendor`.`OXTITLE_1` AS `OXTITLE`,`oxvendor`.`OXSHORTDESC_1` AS `OXSHORTDESC`,`oxvendor`.`OXSHOWSUFFIX` AS `OXSHOWSUFFIX`,`oxvendor`.`OXTIMESTAMP` AS `OXTIMESTAMP` from (`oxvendor` join `oxvendor2shop` `t2s` on(`t2s`.`OXMAPOBJECTID` = `oxvendor`.`OXMAPID`)) where `t2s`.`OXSHOPID` = 1 */;

--
-- Final view structure for view `oxv_oxvendor_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxvendor_de`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxvendor_de` AS select `oxvendor`.`OXID` AS `OXID`,`oxvendor`.`OXMAPID` AS `OXMAPID`,`oxvendor`.`OXSHOPID` AS `OXSHOPID`,`oxvendor`.`OXACTIVE` AS `OXACTIVE`,`oxvendor`.`OXICON` AS `OXICON`,`oxvendor`.`OXTITLE` AS `OXTITLE`,`oxvendor`.`OXSHORTDESC` AS `OXSHORTDESC`,`oxvendor`.`OXSHOWSUFFIX` AS `OXSHOWSUFFIX`,`oxvendor`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxvendor` */;

--
-- Final view structure for view `oxv_oxvendor_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxvendor_en`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxvendor_en` AS select `oxvendor`.`OXID` AS `OXID`,`oxvendor`.`OXMAPID` AS `OXMAPID`,`oxvendor`.`OXSHOPID` AS `OXSHOPID`,`oxvendor`.`OXACTIVE` AS `OXACTIVE`,`oxvendor`.`OXICON` AS `OXICON`,`oxvendor`.`OXTITLE_1` AS `OXTITLE`,`oxvendor`.`OXSHORTDESC_1` AS `OXSHORTDESC`,`oxvendor`.`OXSHOWSUFFIX` AS `OXSHOWSUFFIX`,`oxvendor`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxvendor` */;

--
-- Final view structure for view `oxv_oxvoucherseries`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxvoucherseries`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxvoucherseries` AS select `oxvoucherseries`.`OXID` AS `OXID`,`oxvoucherseries`.`OXMAPID` AS `OXMAPID`,`oxvoucherseries`.`OXSHOPID` AS `OXSHOPID`,`oxvoucherseries`.`OXSERIENR` AS `OXSERIENR`,`oxvoucherseries`.`OXSERIEDESCRIPTION` AS `OXSERIEDESCRIPTION`,`oxvoucherseries`.`OXDISCOUNT` AS `OXDISCOUNT`,`oxvoucherseries`.`OXDISCOUNTTYPE` AS `OXDISCOUNTTYPE`,`oxvoucherseries`.`OXBEGINDATE` AS `OXBEGINDATE`,`oxvoucherseries`.`OXENDDATE` AS `OXENDDATE`,`oxvoucherseries`.`OXALLOWSAMESERIES` AS `OXALLOWSAMESERIES`,`oxvoucherseries`.`OXALLOWOTHERSERIES` AS `OXALLOWOTHERSERIES`,`oxvoucherseries`.`OXALLOWUSEANOTHER` AS `OXALLOWUSEANOTHER`,`oxvoucherseries`.`OXMINIMUMVALUE` AS `OXMINIMUMVALUE`,`oxvoucherseries`.`OXCALCULATEONCE` AS `OXCALCULATEONCE`,`oxvoucherseries`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxvoucherseries` */;

--
-- Final view structure for view `oxv_oxvoucherseries_1`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxvoucherseries_1`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxvoucherseries_1` AS select `oxvoucherseries`.`OXID` AS `OXID`,`oxvoucherseries`.`OXMAPID` AS `OXMAPID`,`oxvoucherseries`.`OXSHOPID` AS `OXSHOPID`,`oxvoucherseries`.`OXSERIENR` AS `OXSERIENR`,`oxvoucherseries`.`OXSERIEDESCRIPTION` AS `OXSERIEDESCRIPTION`,`oxvoucherseries`.`OXDISCOUNT` AS `OXDISCOUNT`,`oxvoucherseries`.`OXDISCOUNTTYPE` AS `OXDISCOUNTTYPE`,`oxvoucherseries`.`OXBEGINDATE` AS `OXBEGINDATE`,`oxvoucherseries`.`OXENDDATE` AS `OXENDDATE`,`oxvoucherseries`.`OXALLOWSAMESERIES` AS `OXALLOWSAMESERIES`,`oxvoucherseries`.`OXALLOWOTHERSERIES` AS `OXALLOWOTHERSERIES`,`oxvoucherseries`.`OXALLOWUSEANOTHER` AS `OXALLOWUSEANOTHER`,`oxvoucherseries`.`OXMINIMUMVALUE` AS `OXMINIMUMVALUE`,`oxvoucherseries`.`OXCALCULATEONCE` AS `OXCALCULATEONCE`,`oxvoucherseries`.`OXTIMESTAMP` AS `OXTIMESTAMP` from (`oxvoucherseries` join `oxvoucherseries2shop` `t2s` on(`t2s`.`OXMAPOBJECTID` = `oxvoucherseries`.`OXMAPID`)) where `t2s`.`OXSHOPID` = 1 */;

--
-- Final view structure for view `oxv_oxwrapping`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxwrapping`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxwrapping` AS select `oxwrapping`.`OXID` AS `OXID`,`oxwrapping`.`OXMAPID` AS `OXMAPID`,`oxwrapping`.`OXSHOPID` AS `OXSHOPID`,`oxwrapping`.`OXACTIVE` AS `OXACTIVE`,`oxwrapping`.`OXACTIVE_1` AS `OXACTIVE_1`,`oxwrapping`.`OXACTIVE_2` AS `OXACTIVE_2`,`oxwrapping`.`OXACTIVE_3` AS `OXACTIVE_3`,`oxwrapping`.`OXTYPE` AS `OXTYPE`,`oxwrapping`.`OXNAME` AS `OXNAME`,`oxwrapping`.`OXNAME_1` AS `OXNAME_1`,`oxwrapping`.`OXNAME_2` AS `OXNAME_2`,`oxwrapping`.`OXNAME_3` AS `OXNAME_3`,`oxwrapping`.`OXPIC` AS `OXPIC`,`oxwrapping`.`OXPRICE` AS `OXPRICE`,`oxwrapping`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxwrapping` */;

--
-- Final view structure for view `oxv_oxwrapping_1`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxwrapping_1`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxwrapping_1` AS select `oxwrapping`.`OXID` AS `OXID`,`oxwrapping`.`OXMAPID` AS `OXMAPID`,`oxwrapping`.`OXSHOPID` AS `OXSHOPID`,`oxwrapping`.`OXACTIVE` AS `OXACTIVE`,`oxwrapping`.`OXACTIVE_1` AS `OXACTIVE_1`,`oxwrapping`.`OXACTIVE_2` AS `OXACTIVE_2`,`oxwrapping`.`OXACTIVE_3` AS `OXACTIVE_3`,`oxwrapping`.`OXTYPE` AS `OXTYPE`,`oxwrapping`.`OXNAME` AS `OXNAME`,`oxwrapping`.`OXNAME_1` AS `OXNAME_1`,`oxwrapping`.`OXNAME_2` AS `OXNAME_2`,`oxwrapping`.`OXNAME_3` AS `OXNAME_3`,`oxwrapping`.`OXPIC` AS `OXPIC`,`oxwrapping`.`OXPRICE` AS `OXPRICE`,`oxwrapping`.`OXTIMESTAMP` AS `OXTIMESTAMP` from (`oxwrapping` join `oxwrapping2shop` `t2s` on(`t2s`.`OXMAPOBJECTID` = `oxwrapping`.`OXMAPID`)) where `t2s`.`OXSHOPID` = 1 */;

--
-- Final view structure for view `oxv_oxwrapping_1_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxwrapping_1_de`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxwrapping_1_de` AS select `oxwrapping`.`OXID` AS `OXID`,`oxwrapping`.`OXMAPID` AS `OXMAPID`,`oxwrapping`.`OXSHOPID` AS `OXSHOPID`,`oxwrapping`.`OXACTIVE` AS `OXACTIVE`,`oxwrapping`.`OXTYPE` AS `OXTYPE`,`oxwrapping`.`OXNAME` AS `OXNAME`,`oxwrapping`.`OXPIC` AS `OXPIC`,`oxwrapping`.`OXPRICE` AS `OXPRICE`,`oxwrapping`.`OXTIMESTAMP` AS `OXTIMESTAMP` from (`oxwrapping` join `oxwrapping2shop` `t2s` on(`t2s`.`OXMAPOBJECTID` = `oxwrapping`.`OXMAPID`)) where `t2s`.`OXSHOPID` = 1 */;

--
-- Final view structure for view `oxv_oxwrapping_1_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxwrapping_1_en`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxwrapping_1_en` AS select `oxwrapping`.`OXID` AS `OXID`,`oxwrapping`.`OXMAPID` AS `OXMAPID`,`oxwrapping`.`OXSHOPID` AS `OXSHOPID`,`oxwrapping`.`OXACTIVE_1` AS `OXACTIVE`,`oxwrapping`.`OXTYPE` AS `OXTYPE`,`oxwrapping`.`OXNAME_1` AS `OXNAME`,`oxwrapping`.`OXPIC` AS `OXPIC`,`oxwrapping`.`OXPRICE` AS `OXPRICE`,`oxwrapping`.`OXTIMESTAMP` AS `OXTIMESTAMP` from (`oxwrapping` join `oxwrapping2shop` `t2s` on(`t2s`.`OXMAPOBJECTID` = `oxwrapping`.`OXMAPID`)) where `t2s`.`OXSHOPID` = 1 */;

--
-- Final view structure for view `oxv_oxwrapping_de`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxwrapping_de`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxwrapping_de` AS select `oxwrapping`.`OXID` AS `OXID`,`oxwrapping`.`OXMAPID` AS `OXMAPID`,`oxwrapping`.`OXSHOPID` AS `OXSHOPID`,`oxwrapping`.`OXACTIVE` AS `OXACTIVE`,`oxwrapping`.`OXTYPE` AS `OXTYPE`,`oxwrapping`.`OXNAME` AS `OXNAME`,`oxwrapping`.`OXPIC` AS `OXPIC`,`oxwrapping`.`OXPRICE` AS `OXPRICE`,`oxwrapping`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxwrapping` */;

--
-- Final view structure for view `oxv_oxwrapping_en`
--

/*!50001 DROP VIEW IF EXISTS `oxv_oxwrapping_en`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY INVOKER */
/*!50001 VIEW `oxv_oxwrapping_en` AS select `oxwrapping`.`OXID` AS `OXID`,`oxwrapping`.`OXMAPID` AS `OXMAPID`,`oxwrapping`.`OXSHOPID` AS `OXSHOPID`,`oxwrapping`.`OXACTIVE_1` AS `OXACTIVE`,`oxwrapping`.`OXTYPE` AS `OXTYPE`,`oxwrapping`.`OXNAME_1` AS `OXNAME`,`oxwrapping`.`OXPIC` AS `OXPIC`,`oxwrapping`.`OXPRICE` AS `OXPRICE`,`oxwrapping`.`OXTIMESTAMP` AS `OXTIMESTAMP` from `oxwrapping` */;


