SET @@session.sql_mode = '';


### oxactions table
UPDATE `oxactions` SET `OXACTIV` = '0' WHERE `OXACTIV` = '';
ALTER TABLE `oxactions` CHANGE `OXACTIV` `OXACTIVE` tinyint(1) NOT NULL DEFAULT '1';
ALTER TABLE `oxactions` CHANGE `OXACTIVFROM` `OXACTIVEFROM` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE `oxactions` CHANGE `OXACTIVTO` `OXACTIVETO` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
UPDATE `oxactions` SET `OXACTIVEFROM` = '0000-00-00 00:00:00' WHERE `OXACTIVEFROM` IS NULL;
UPDATE `oxactions` SET `OXACTIVETO` = '0000-00-00 00:00:00' WHERE `OXACTIVETO` IS NULL;

### oxactions2article table
ALTER TABLE `oxactions2article` ADD INDEX `OXMAINIDX` (`OXSHOPID`,`OXACTIONID`,`OXSORT`);
ALTER TABLE `oxactions2article` DROP KEY `OXSORT`;

### admin log table
ALTER TABLE `oxadminlog` MODIFY COLUMN `OXDATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP;

### oxarticles table
UPDATE `oxarticles` SET `OXACTIV` = '0' WHERE `OXACTIV` = '';
ALTER TABLE `oxarticles` CHANGE `OXACTIV` `OXACTIVE` tinyint(1) NOT NULL DEFAULT '1';
ALTER TABLE `oxarticles` CHANGE `OXACTIVFROM` `OXACTIVEFROM` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE `oxarticles` CHANGE `OXACTIVTO` `OXACTIVETO` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE `oxarticles` CHANGE `OXTIMESTAMP` `OXTIMESTAMP` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP;
ALTER TABLE `oxarticles` MODIFY COLUMN `OXVAT` float DEFAULT NULL;
ALTER TABLE `oxarticles` ADD INDEX `OXACTIVE` (`OXACTIVE`);
ALTER TABLE `oxarticles` ADD INDEX `OXACTIVEFROM` (`OXACTIVEFROM`);
ALTER TABLE `oxarticles` ADD INDEX `OXACTIVETO` (`OXACTIVETO`);
ALTER TABLE `oxarticles` DROP KEY `OXACTIV`;
ALTER TABLE `oxarticles` DROP KEY `OXACTIVFROM`;
ALTER TABLE `oxarticles` DROP KEY `OXACTIVTO`;
UPDATE `oxarticles` SET `OXPARENTID` = '' WHERE `OXPARENTID` IS NULL;
UPDATE `oxarticles` SET `OXVAT` = NULL WHERE `OXVAT` = 0;
ALTER TABLE `oxarticles` ADD `OXVARMINPRICE` double NOT NULL DEFAULT '0' AFTER `OXVARSELECT` ;

# changing enum into tinyint
UPDATE `oxarticles` SET `OXBLFIXEDPRICE` = '0' WHERE `OXBLFIXEDPRICE` = '';
ALTER TABLE `oxarticles` MODIFY COLUMN `OXBLFIXEDPRICE` tinyint(1) NOT NULL DEFAULT '0';
UPDATE `oxarticles` SET `OXBLFIXEDPRICE` = 0 WHERE `OXBLFIXEDPRICE` <= 1;
UPDATE `oxarticles` SET `OXBLFIXEDPRICE` = 1 WHERE `OXBLFIXEDPRICE` > 1;

UPDATE `oxarticles` SET `OXSTOCKFLAG` = '0' WHERE `OXSTOCKFLAG` = '';
ALTER TABLE `oxarticles` MODIFY COLUMN `OXSTOCKFLAG` tinyint(1) NOT NULL DEFAULT '1';

UPDATE `oxarticles` SET `OXISSEARCH` = '0' WHERE `OXISSEARCH` = '';
ALTER TABLE `oxarticles` MODIFY COLUMN `OXISSEARCH` tinyint(1) NOT NULL DEFAULT '1';
UPDATE `oxarticles` SET `OXISSEARCH` = 0 WHERE `OXISSEARCH` > 1;

ALTER TABLE `oxarticles` ADD COLUMN `OXDISTEAN` varchar(13)  NOT NULL default '' AFTER `OXARTNUM`;
ALTER TABLE `oxarticles` ADD COLUMN `OXEAN` varchar(13)  NOT NULL default '' AFTER `OXARTNUM`;

ALTER TABLE `oxarticles` ADD COLUMN `OXRATINGCNT` int(11) NOT NULL default '0' AFTER `OXVENDORID`;
ALTER TABLE `oxarticles` ADD COLUMN `OXRATING` double NOT NULL default '0' AFTER `OXVENDORID`;
ALTER TABLE `oxarticles` ADD COLUMN `OXSKIPDISCOUNTS` tinyint(1) NOT NULL default '0' AFTER `OXVENDORID` ;

### renaming oxbasketitems table
RENAME TABLE `oxbasketitems` TO `oxuserbasketitems`;

### renaming oxbasket table
RENAME TABLE `oxbasket` TO `oxuserbaskets`;
ALTER TABLE `oxuserbaskets` MODIFY COLUMN `OXPUBLIC` tinyint(1) NOT NULL DEFAULT '1';


### oxcategories table
UPDATE `oxcategories` SET `OXACTIV` = '0' WHERE `OXACTIV` = '';
ALTER TABLE `oxcategories` CHANGE `OXACTIV` `OXACTIVE` tinyint(1) NOT NULL DEFAULT '1';
ALTER TABLE `oxcategories` CHANGE `OXORDER` `OXSORT` INT( 11 ) NOT NULL DEFAULT '9999';
ALTER TABLE `oxcategories` DROP INDEX `OXORDER` , ADD INDEX `OXSORT` ( `OXSORT` );
UPDATE `oxcategories` SET `OXACTIVE` = 0 WHERE `OXACTIVE` > 1;

UPDATE `oxcategories` SET `OXACTIV_1` = '0' WHERE `OXACTIV_1` = '';
UPDATE `oxcategories` SET `OXACTIV_2` = '0' WHERE `OXACTIV_2` = '';
UPDATE `oxcategories` SET `OXACTIV_3` = '0' WHERE `OXACTIV_3` = '';
ALTER TABLE `oxcategories` CHANGE `OXACTIV_1` `OXACTIVE_1` tinyint(1) NOT NULL DEFAULT '0';
ALTER TABLE `oxcategories` CHANGE `OXACTIV_2` `OXACTIVE_2` tinyint(1) NOT NULL DEFAULT '0';
ALTER TABLE `oxcategories` CHANGE `OXACTIV_3` `OXACTIVE_3` tinyint(1) NOT NULL DEFAULT '0';
ALTER TABLE `oxcategories` ADD COLUMN `OXVAT` float AFTER `OXICON`;
ALTER TABLE `oxcategories` ADD INDEX `OXVAT` ( `OXVAT` );
ALTER TABLE `oxcategories` DROP COLUMN `OXTYPE`;
ALTER TABLE `oxcategories` DROP COLUMN `OXNROFARTICLES`;

# changing enum into tinyint
UPDATE `oxcategories` SET `OXHIDDEN` = '0' WHERE `OXHIDDEN` = '';
ALTER TABLE `oxcategories` MODIFY COLUMN `OXHIDDEN` tinyint(1) NOT NULL DEFAULT '0';
UPDATE `oxcategories` SET `OXHIDDEN` = 0 WHERE `OXHIDDEN` <= 1;
UPDATE `oxcategories` SET `OXHIDDEN` = 1 WHERE `OXHIDDEN` > 1;

UPDATE `oxcategories` SET `OXDEFSORTMODE` = '0' WHERE `OXDEFSORTMODE` = '';
ALTER TABLE `oxcategories` MODIFY COLUMN `OXDEFSORTMODE` tinyint(1) NOT NULL DEFAULT '0';
UPDATE `oxcategories` SET `OXDEFSORTMODE` = 0 WHERE `OXDEFSORTMODE` <= 1;
UPDATE `oxcategories` SET `OXDEFSORTMODE` = 1 WHERE `OXDEFSORTMODE` > 1;
ALTER TABLE `oxcategories` ADD COLUMN `OXSKIPDISCOUNTS` tinyint(1) NOT NULL default '0' AFTER `OXVAT` ;
ALTER TABLE `oxcategories` ADD `OXSHOWSUFFIX` TINYINT( 1 ) NOT NULL DEFAULT '1';


### oxcontents table
UPDATE `oxcontents` SET `OXACTIV` = '0' WHERE `OXACTIV` = '';
ALTER TABLE `oxcontents` CHANGE `OXACTIV` `OXACTIVE` tinyint(1) NOT NULL DEFAULT '1';
UPDATE `oxcontents` SET `OXACTIVE` = 0 WHERE `OXACTIVE` > 1;

UPDATE `oxcontents` SET `OXACTIV_1` = '0' WHERE `OXACTIV_1` = '';
ALTER TABLE `oxcontents` CHANGE `OXACTIV_1` `OXACTIVE_1` tinyint(1) NOT NULL DEFAULT '1';
UPDATE `oxcontents` SET `OXACTIVE_1` = 0 WHERE `OXACTIVE_1` > 1;

UPDATE `oxcontents` SET `OXACTIV_2` = '0' WHERE `OXACTIV_2` = '';
ALTER TABLE `oxcontents` CHANGE `OXACTIV_2` `OXACTIVE_2` tinyint(1) NOT NULL DEFAULT '1';
UPDATE `oxcontents` SET `OXACTIVE_2` = 0 WHERE `OXACTIVE_2` > 1;

UPDATE `oxcontents` SET `OXACTIV_3` = '0' WHERE `OXACTIV_3` = '';
ALTER TABLE `oxcontents` CHANGE `OXACTIV_3` `OXACTIVE_3` tinyint(1) NOT NULL DEFAULT '1';
UPDATE `oxcontents` SET `OXACTIVE_3` = 0 WHERE `OXACTIVE_3` > 1;
ALTER TABLE `oxcontents` ADD INDEX `cat_search` (`OXTYPE`,`OXSHOPID`,`OXSNIPPET`,`OXCATID`);

# changing enum into tinyint
UPDATE `oxcontents` SET `OXSNIPPET` = '0' WHERE `OXSNIPPET` = '';
ALTER TABLE `oxcontents` MODIFY COLUMN `OXSNIPPET` tinyint(1) NOT NULL DEFAULT '1';
UPDATE `oxcontents` SET `OXSNIPPET` = 0 WHERE `OXSNIPPET` <= 1;
UPDATE `oxcontents` SET `OXSNIPPET` = 1 WHERE `OXSNIPPET` > 1;

UPDATE `oxcontents` SET `OXTYPE` = 0 WHERE `OXTYPE` = '';
ALTER TABLE `oxcontents` MODIFY COLUMN `OXTYPE` tinyint(1) NOT NULL DEFAULT '0';
UPDATE `oxcontents` SET `OXTYPE` = `OXTYPE` - 1;

INSERT INTO `oxcontents` (`OXID`, `OXLOADID`, `OXSHOPID`, `OXSNIPPET`, `OXTYPE`, `OXACTIVE`, `OXACTIVE_1`, `OXPOSITION`, `OXTITLE`, `OXCONTENT`, `OXTITLE_1`, `OXCONTENT_1`, `OXACTIVE_2`, `OXTITLE_2`, `OXCONTENT_2`, `OXACTIVE_3`, `OXTITLE_3`, `OXCONTENT_3`, `OXCATID`, `OXFOLDER`)  VALUES ('ce79015b6f6f07612270975889', 'oxstartmetadescription', 'oxbaseshop', '1', '0', '1', '1', '', 'META Description Startseite', 'Witzige und originelle Geschenke. Online Versand f�r Trend-Produkte, Lifestyle-Artikel und Accessoires. Geschenkideen f�r alle Anl�sse g�nstig online kaufen.', 'META Description Startseite', 'Funny and original presents. Online store for trendy products, lifestyle articles and accessories. Gift ideas for all occasions.', '1', '', '', '1', '', '', '', '');
INSERT INTO `oxcontents` (`OXID`, `OXLOADID`, `OXSHOPID`, `OXSNIPPET`, `OXTYPE`, `OXACTIVE`, `OXACTIVE_1`, `OXPOSITION`, `OXTITLE`, `OXCONTENT`, `OXTITLE_1`, `OXCONTENT_1`, `OXACTIVE_2`, `OXTITLE_2`, `OXCONTENT_2`, `OXACTIVE_3`, `OXTITLE_3`, `OXCONTENT_3`, `OXCATID`, `OXFOLDER`)  VALUES ('ce77743c334edf92b0cab924a7', 'oxstartmetakeywords', 'oxbaseshop', '1', '0', '1', '1', '', 'META Keywords Startseite', 'geschenk, geschenke, geschenkideen, geschenkeshop, trend-produkte, lifestyle-artikel, lifestyle, accessoires, geburtstagsgeschenke, hochzeitsgeschenke', 'META Keywords Startseite', 'gifts, gift, gift ideas, presents, birthday gifts, gift shop, wedding gifts, lifestyle products, accessories', '1', '', '', '1', '', '', '', '');
INSERT INTO `oxcontents` (`OXID`, `OXLOADID`, `OXSHOPID`, `OXSNIPPET`, `OXTYPE`, `OXACTIVE`, `OXACTIVE_1`, `OXPOSITION`, `OXTITLE`, `OXCONTENT`, `OXTITLE_1`, `OXCONTENT_1`, `OXACTIVE_2`, `OXTITLE_2`, `OXCONTENT_2`, `OXACTIVE_3`, `OXTITLE_3`, `OXCONTENT_3`, `OXCATID`, `OXFOLDER`)  VALUES ('8709e45f31a86909e9f999222e80b1d0', 'oxstdfooter', 'oxbaseshop', 1, 0, 1, 1, '', 'Standard Footer', '<div>OXID Geschenke Shop - Geschenkideen f�r alle Anl�sse g�nstig online kaufen</div>\r\n<div>Online Versand f�r Trend-Produkte, Lifestyle-Artikel und Accessoires</div>Witzige, originelle Geschenke bestellen<br>', 'Standard Footer', '<div>OXID Gift Shop - Buy gift ideas for all ocasions online</div>\r\n<div>Online store for trndy products, lifestyle articles and accessories</div>\r\n<div>Order funny and original presents online</div>', 1, '', '', 1, '', '', '8a142c3e4143562a5.46426637', '');
DELETE FROM `oxcontents` WHERE `OXLOADID`='oxabout';

### oxcountry table
UPDATE `oxcountry` SET `OXACTIV` = '0' WHERE `OXACTIV` = '';
ALTER TABLE `oxcountry` CHANGE `OXACTIV` `OXACTIVE` tinyint(1) NOT NULL DEFAULT '0';
UPDATE `oxcountry` SET `OXACTIVE` = 0 WHERE `OXACTIVE` > 1;
ALTER TABLE `oxcountry` DROP KEY `OXSHOPID`, ADD INDEX `OXSHOPID` (`OXSHOPID`,`OXACTIVE`);


### oxdelivery table
UPDATE `oxdelivery` SET `OXACTIV` = '0' WHERE `OXACTIV` = '';
ALTER TABLE `oxdelivery` CHANGE `OXACTIV` `OXACTIVE` tinyint(1) NOT NULL DEFAULT '0';
ALTER TABLE `oxdelivery` CHANGE `OXACTIVFROM` `OXACTIVEFROM` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE `oxdelivery` CHANGE `OXACTIVTO` `OXACTIVETO` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';

# changing enum into tinyint
UPDATE `oxdelivery` SET `OXFIXED` = 0 WHERE `OXFIXED` = '';
ALTER TABLE `oxdelivery` MODIFY COLUMN `OXFIXED` tinyint(1) NOT NULL DEFAULT '0';
UPDATE `oxdelivery` SET `OXFIXED` = `OXFIXED` - 1;

UPDATE `oxdelivery` SET `OXFINALIZE` = 0 WHERE `OXFINALIZE` = '';
ALTER TABLE `oxdelivery` MODIFY COLUMN `OXFINALIZE` tinyint(1) NOT NULL DEFAULT '0';
UPDATE `oxdelivery` SET `OXFINALIZE` = `OXFINALIZE` - 1;


### oxdeliveryset table
UPDATE `oxdeliveryset` SET `OXACTIV` = '0' WHERE `OXACTIV` = '';
ALTER TABLE `oxdeliveryset` CHANGE `OXACTIV` `OXACTIVE` tinyint(1) NOT NULL DEFAULT '0';
ALTER TABLE `oxdeliveryset` CHANGE `OXACTIVFROM` `OXACTIVEFROM` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE `oxdeliveryset` CHANGE `OXACTIVTO` `OXACTIVETO` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';


### oxdiscount table
UPDATE `oxdiscount` SET `OXACTIV` = '0' WHERE `OXACTIV` = '';
ALTER TABLE `oxdiscount` CHANGE `OXACTIV` `OXACTIVE` tinyint(1) NOT NULL DEFAULT '0';
ALTER TABLE `oxdiscount` CHANGE `OXACTIVFROM` `OXACTIVEFROM` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE `oxdiscount` CHANGE `OXACTIVTO` `OXACTIVETO` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE `oxdiscount` DROP COLUMN `OXCATNID`;
ALTER TABLE `oxdiscount` DROP COLUMN `OXARTNID`;
ALTER TABLE `oxdiscount` DROP COLUMN `OXUSERGROUPID`;
ALTER TABLE `oxdiscount` DROP COLUMN `OXUSERID`;
ALTER TABLE `oxdiscount` DROP INDEX `OXACTIV`, ADD INDEX `OXACTIVE` ( `OXACTIVE` );
ALTER TABLE `oxdiscount` DROP INDEX `OXACTIVFROM`, ADD INDEX `OXACTIVEFROM` ( `OXACTIVEFROM` );
ALTER TABLE `oxdiscount` DROP INDEX `OXACTIVTO`, ADD INDEX `OXACTIVETO` ( `OXACTIVETO` );
ALTER TABLE `oxdiscount` DROP KEY `OXTYPE`;
ALTER TABLE `oxdiscount` ADD COLUMN `OXITMMULTIPLE` int(1) NOT NULL default '0' AFTER `OXITMARTID`;
ALTER TABLE `oxdiscount` ADD COLUMN `OXITMAMOUNT` double NOT NULL default '1' AFTER `OXITMARTID`;


### oxgbentries table
UPDATE `oxgbentries` SET `OXACTIV` = 0 WHERE `OXACTIV` = '';
ALTER TABLE `oxgbentries` CHANGE `OXACTIV` `OXACTIVE` tinyint(1) NOT NULL DEFAULT '0';
UPDATE `oxgbentries` SET `OXACTIVE` = `OXACTIVE` - 1;

# changing enum into tinyint
UPDATE `oxgbentries` SET `OXVIEWED` = 0 WHERE `OXVIEWED` = '';
ALTER TABLE `oxgbentries` MODIFY COLUMN `OXVIEWED` tinyint(1) NOT NULL DEFAULT '0';
UPDATE `oxgbentries` SET `OXVIEWED` = `OXVIEWED` - 1;


### oxgroups table
UPDATE `oxgroups` SET `OXACTIV` = '0' WHERE `OXACTIV` = '';
ALTER TABLE `oxgroups` CHANGE `OXACTIV` `OXACTIVE` tinyint(1) NOT NULL DEFAULT '1';
ALTER TABLE `oxgroups` DROP INDEX `OXACTIV`, ADD INDEX `OXACTIVE` ( `OXACTIVE` );
UPDATE `oxgroups` SET `OXACTIVE` = 0 WHERE `OXACTIVE` > 1;


### oxlinks table
ALTER TABLE `oxlinks` CHANGE `OXACTIV` `OXACTIVE` tinyint(1) NOT NULL DEFAULT '0';
ALTER TABLE `oxlinks` DROP INDEX `OXACTIV`, ADD INDEX `OXACTIVE` ( `OXACTIVE` );


### oxartextends table
CREATE TABLE `oxartextends` (
  `OXID` char(32) NOT NULL,
  `OXLONGDESC` text NOT NULL,
  `OXLONGDESC_1` text NOT NULL,
  `OXLONGDESC_2` text NOT NULL,
  `OXLONGDESC_3` text NOT NULL,
  `OXTAGS` varchar(255) NOT NULL,
  `OXTAGS_1` varchar(255) NOT NULL,
  `OXTAGS_2` varchar(255) NOT NULL,
  `OXTAGS_3` varchar(255) NOT NULL,
  PRIMARY KEY  (`OXID`)
) TYPE=MyISAM;

# copying long descriptions
#if you have more than 4 languages, please add additional fields here
INSERT INTO `oxartextends` ( `OXID`, `OXLONGDESC`, `OXLONGDESC_1`, `OXLONGDESC_2`, `OXLONGDESC_3`, `OXTAGS`, `OXTAGS_1`, `OXTAGS_2`, `OXTAGS_3` )
SELECT `OXID`, `OXLONGDESC`, `OXLONGDESC_1`, `OXLONGDESC_2`, `OXLONGDESC_3`, `OXSEARCHKEYS`, `OXSEARCHKEYS_1`, `OXSEARCHKEYS_2`, `OXSEARCHKEYS_3` FROM `oxarticles`;

# dropping copied fields
ALTER TABLE `oxarticles` DROP COLUMN `OXLONGDESC`;
ALTER TABLE `oxarticles` DROP COLUMN `OXLONGDESC_1`;
ALTER TABLE `oxarticles` DROP COLUMN `OXLONGDESC_2`;
ALTER TABLE `oxarticles` DROP COLUMN `OXLONGDESC_3`;

#adding fulltext index for tags
ALTER TABLE `oxartextends` ADD FULLTEXT (`OXTAGS`);
ALTER TABLE `oxartextends` ADD FULLTEXT (`OXTAGS_1`);
ALTER TABLE `oxartextends` ADD FULLTEXT (`OXTAGS_2`);
ALTER TABLE `oxartextends` ADD FULLTEXT (`OXTAGS_3`);

### oxmodvouchers table
RENAME TABLE `oxmodvouchers` TO `oxvouchers`;
ALTER TABLE `oxvouchers` MODIFY COLUMN `OXSHOPID` char(32) NOT NULL default '' AFTER `OXUSERID`;
ALTER TABLE `oxvouchers` MODIFY COLUMN `OXVOUCHERNR` varchar(255);

ALTER TABLE `oxvouchers` MODIFY COLUMN `OXORDERID` char(32) NOT NULL default '';
ALTER TABLE `oxvouchers` MODIFY COLUMN `OXUSERID` char(32) NOT NULL default '';
ALTER TABLE `oxvouchers` MODIFY COLUMN `OXRESERVED` int(11) NOT NULL DEFAULT '0';
ALTER TABLE `oxvouchers` MODIFY COLUMN `OXVOUCHERNR` char(255) NOT NULL default '' AFTER `OXRESERVED`;
ALTER TABLE `oxvouchers` MODIFY COLUMN `OXVOUCHERSERIEID` char(32) NOT NULL default '' AFTER `OXVOUCHERNR`;
ALTER TABLE `oxvouchers` MODIFY COLUMN `OXDISCOUNT` float(9,2);

ALTER TABLE `oxvouchers` DROP COLUMN `OXSHOPID`;
ALTER TABLE `oxvouchers` DROP COLUMN `OXMINIMUMVALUE`;
ALTER TABLE `oxvouchers` DROP COLUMN `OXALLOWUSEANOTHER`;
ALTER TABLE `oxvouchers` DROP COLUMN `OXALLOWOTHERSERIES`;
ALTER TABLE `oxvouchers` DROP COLUMN `OXALLOWSAMESERIES`;
ALTER TABLE `oxvouchers` DROP COLUMN `OXENDDATE`;
ALTER TABLE `oxvouchers` DROP COLUMN `OXBEGINDATE`;
ALTER TABLE `oxvouchers` DROP COLUMN `OXRELEASEDATE`;
ALTER TABLE `oxvouchers` DROP COLUMN `OXSTARTDATE`;
ALTER TABLE `oxvouchers` DROP COLUMN `OXDISCOUNTTYPE`;

ALTER TABLE `oxvouchers` ADD INDEX `OXVOUCHERNR` (`OXVOUCHERNR`);


### oxmodvoucherseries table
RENAME TABLE `oxmodvoucherseries` TO `oxvoucherseries`;
ALTER TABLE `oxvoucherseries` MODIFY COLUMN `OXSHOPID` char(32) NOT NULL default '';
ALTER TABLE `oxvoucherseries` MODIFY COLUMN `OXSERIENR` varchar(255);
ALTER TABLE `oxvoucherseries` MODIFY COLUMN `OXSERIEDESCRIPTION` varchar(255);

ALTER TABLE `oxvoucherseries` MODIFY COLUMN `OXSERIENR` varchar(255) NOT NULL DEFAULT '';
ALTER TABLE `oxvoucherseries` MODIFY COLUMN `OXSERIEDESCRIPTION` varchar(255) NOT NULL DEFAULT '';
ALTER TABLE `oxvoucherseries` MODIFY COLUMN `OXDISCOUNT` float(9,2) NOT NULL DEFAULT '0.00';
ALTER TABLE `oxvoucherseries` MODIFY COLUMN `OXDISCOUNTTYPE` enum('percent','absolute') NOT NULL DEFAULT 'absolute';
ALTER TABLE `oxvoucherseries` MODIFY COLUMN `OXALLOWSAMESERIES` tinyint(1) NOT NULL DEFAULT '0';
ALTER TABLE `oxvoucherseries` MODIFY COLUMN `OXALLOWOTHERSERIES` tinyint(1) NOT NULL DEFAULT '0';
ALTER TABLE `oxvoucherseries` MODIFY COLUMN `OXALLOWUSEANOTHER` tinyint(1) NOT NULL DEFAULT '0';
UPDATE `oxvoucherseries` SET `OXALLOWSAMESERIES` = 0 WHERE `OXALLOWSAMESERIES` <= 1;
UPDATE `oxvoucherseries` SET `OXALLOWSAMESERIES` = 1 WHERE `OXALLOWSAMESERIES` > 1;
UPDATE `oxvoucherseries` SET `OXALLOWOTHERSERIES` = 0 WHERE `OXALLOWOTHERSERIES` <= 1;
UPDATE `oxvoucherseries` SET `OXALLOWOTHERSERIES` = 1 WHERE `OXALLOWOTHERSERIES` > 1;
UPDATE `oxvoucherseries` SET `OXALLOWUSEANOTHER` = 0 WHERE `OXALLOWUSEANOTHER` <= 1;
UPDATE `oxvoucherseries` SET `OXALLOWUSEANOTHER` = 1 WHERE `OXALLOWUSEANOTHER` > 1;
ALTER TABLE `oxvoucherseries` ADD INDEX `OXSHOPID` (`OXSHOPID`);


### news table
UPDATE `oxnews` SET `OXACTIV` = '0' WHERE `OXACTIV` = '';
ALTER TABLE `oxnews` CHANGE `OXACTIV` `OXACTIVE` tinyint(1) NOT NULL DEFAULT '1';
UPDATE `oxnews` SET `OXACTIVE` = 0 WHERE `OXACTIVE` > 1;

UPDATE `oxnews` SET `OXACTIV_1` = '0' WHERE `OXACTIV_1` = '';
UPDATE `oxnews` SET `OXACTIV_2` = '0' WHERE `OXACTIV_2` = '';
UPDATE `oxnews` SET `OXACTIV_3` = '0' WHERE `OXACTIV_3` = '';
ALTER TABLE `oxnews` CHANGE `OXACTIV_1` `OXACTIVE_1` tinyint(1) NOT NULL DEFAULT '0';
ALTER TABLE `oxnews` CHANGE `OXACTIV_2` `OXACTIVE_2` tinyint(1) NOT NULL DEFAULT '0';
ALTER TABLE `oxnews` CHANGE `OXACTIV_3` `OXACTIVE_3` tinyint(1) NOT NULL DEFAULT '0';
ALTER TABLE `oxnews` CHANGE `OXACTIVFROM` `OXACTIVEFROM` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE `oxnews` CHANGE `OXACTIVTO` `OXACTIVETO` datetime NOT NULL DEFAULT '0000-00-00 00:00:00';
ALTER TABLE `oxnews` DROP INDEX `OXACTIV`, ADD INDEX `OXACTIVE` ( `OXACTIVE` );
ALTER TABLE `oxnews` DROP INDEX `OXACTIVFROM`, ADD INDEX `OXACTIVEFROM` ( `OXACTIVEFROM` );
ALTER TABLE `oxnews` DROP INDEX `OXACTIVTO`, ADD INDEX `OXACTIVETO` ( `OXACTIVETO` );


### changing enum into tinyint
ALTER TABLE `oxnewssubscribed` MODIFY COLUMN `OXDBOPTIN` tinyint(1) NOT NULL DEFAULT '0';
UPDATE `oxnewssubscribed` SET `OXEMAILFAILED` = '0' WHERE `OXEMAILFAILED` = '';
ALTER TABLE `oxnewssubscribed` MODIFY COLUMN `OXEMAILFAILED` tinyint(1) NOT NULL DEFAULT '0';
UPDATE `oxnewssubscribed` SET `OXEMAILFAILED` = `OXEMAILFAILED` - 1;


### oxobject2category table
ALTER TABLE `oxobject2category` ADD INDEX `OXMAINIDX` (`OXCATNID`,`OXOBJECTID`);
ALTER TABLE `oxobject2category` DROP KEY `OXCATNID`;


### oxobject2discount table
ALTER TABLE `oxobject2discount` ADD INDEX `oxdiscidx` (`OXDISCOUNTID`,`OXTYPE`);

### oxorder table
ALTER TABLE `oxorder` ADD COLUMN `OXTOTALNETSUM` double NOT NULL DEFAULT '0' AFTER `OXPAYMENTTYPE`;
ALTER TABLE `oxorder` ADD COLUMN `OXTOTALBRUTSUM` double NOT NULL DEFAULT '0' AFTER `OXTOTALNETSUM`;
ALTER TABLE `oxorder` ADD COLUMN `OXTOTALORDERSUM` double NOT NULL DEFAULT '0' AFTER `OXTOTALBRUTSUM`;

# changing enum into tinyint
UPDATE `oxorder` SET `OXSTORNO` = '0' WHERE `OXSTORNO` = '';
ALTER TABLE `oxorder` MODIFY COLUMN `OXSTORNO` tinyint(1) NOT NULL DEFAULT '0';
UPDATE `oxorder` SET `OXSTORNO` = `OXSTORNO` - 1;
ALTER TABLE `oxorder` DROP COLUMN `OXBILLCOUNTRY`;
ALTER TABLE `oxorder` DROP COLUMN `OXDELCOUNTRY`;
ALTER TABLE `oxorder` DROP COLUMN `OXPHAPPROVED`;
ALTER TABLE `oxorder` DROP COLUMN `OXPHISPHORDER`;

### oxorderarticles table
ALTER TABLE `oxorderarticles` ADD COLUMN `OXVATPRICE` double NOT NULL DEFAULT '0' AFTER `OXBRUTPRICE`;
UPDATE `oxorderarticles` SET `OXVATPRICE`=`OXBRUTPRICE`-`OXNETPRICE`;
#---- ALTER TABLE `oxorderarticles` ADD COLUMN `OXBPRICE` double NOT NULL DEFAULT '0' AFTER `OXPRICE`;
ALTER TABLE `oxorderarticles` ADD COLUMN `OXNPRICE` double NOT NULL DEFAULT '0' AFTER `OXBPRICE`;
ALTER TABLE `oxorderarticles` MODIFY COLUMN `OXISSEARCH` tinyint(1) NOT NULL DEFAULT '1';

# changing enum into tinyint
UPDATE `oxorderarticles` SET `OXSTORNO` = '0' WHERE `OXSTORNO` = '';
ALTER TABLE `oxorderarticles` MODIFY COLUMN `OXSTORNO` tinyint(1) NOT NULL DEFAULT '0';
UPDATE `oxorderarticles` SET `OXSTORNO` = `OXSTORNO` - 1;
ALTER TABLE `oxorderarticles` DROP COLUMN `OXTOTALVAT`;
ALTER TABLE `oxorderarticles` DROP COLUMN `OXTPRICE`;

### oxpayments table
UPDATE `oxpayments` SET `OXACTIV` = '0' WHERE `OXACTIV` = '';
ALTER TABLE `oxpayments` CHANGE `OXACTIV` `OXACTIVE` tinyint(1) NOT NULL DEFAULT '1';
UPDATE `oxpayments` SET `OXACTIVE` = 0 WHERE `OXACTIVE` > 1;
ALTER TABLE `oxpayments` DROP COLUMN `OXACTIV_1`;
ALTER TABLE `oxpayments` DROP COLUMN `OXACTIV_2`;
ALTER TABLE `oxpayments` DROP COLUMN `OXACTIV_3`;
ALTER TABLE `oxpayments` DROP INDEX `OXACTIV`, ADD INDEX `OXACTIVE` ( `OXACTIVE` );

### changing enum into tinyint
UPDATE `oxpayments` SET `OXCHECKED` = '0' WHERE `OXCHECKED` = '';
ALTER TABLE `oxpayments` MODIFY COLUMN `OXCHECKED` tinyint(1) NOT NULL DEFAULT '0';
UPDATE `oxpayments` SET `OXCHECKED` = `OXCHECKED` - 1;


### oxprice2article table
ALTER TABLE `oxprice2article` MODIFY COLUMN `OXID` char(32) NOT NULL default '';
ALTER TABLE `oxprice2article` MODIFY COLUMN `OXSHOPID` char(32) NOT NULL default '';
ALTER TABLE `oxprice2article` MODIFY COLUMN `OXARTID` char(32) NOT NULL default '';
ALTER TABLE `oxprice2article` ADD INDEX `OXARTID` (`OXARTID`);


### oxremark table
ALTER TABLE `oxremark` DROP COLUMN `OXSHOPID`;


### oxreviews table
UPDATE `oxreviews` SET `OXACTIV` = '0' WHERE `OXACTIV` = '';
ALTER TABLE `oxreviews` CHANGE `OXACTIV` `OXACTIVE` tinyint(1) NOT NULL DEFAULT '0';
UPDATE `oxreviews` SET `OXACTIVE` = `OXACTIVE` - 1;

ALTER TABLE `oxreviews` ADD COLUMN `OXRATING` int(1) NOT NULL default '0';
ALTER TABLE `oxreviews` DROP INDEX `OXPARENTID`;
ALTER TABLE `oxreviews` CHANGE `OXPARENTID` `OXOBJECTID` CHAR( 32 ) NOT NULL;
ALTER TABLE `oxreviews` ADD `OXTYPE` ENUM( 'oxarticle', 'oxrecommlist' ) NOT NULL AFTER `OXOBJECTID`;
ALTER TABLE `oxreviews` ADD INDEX `oxobjectsearch` ( `OXTYPE` , `OXOBJECTID` );
UPDATE `oxreviews` SET `oxtype` = 'oxarticle';

### cleaning up session table
DELETE FROM `oxsessions`;


### introducing SEO
DROP TABLE IF EXISTS `oxseo`;

CREATE TABLE `oxseo` (
`OXOBJECTID` char(32) NOT NULL default '',
`OXIDENT`    char(32) NOT NULL default '',
`OXSHOPID` char(32) NOT NULL default '',
`OXLANG`     int(2) NOT NULL default 0,
`OXSTDURL`   TEXT NOT NULL,
`OXSEOURL`   TEXT NOT NULL,
`OXTYPE`     enum('static', 'oxarticle', 'oxcategory', 'oxvendor', 'oxcontent', 'dynamic') NOT NULL,
`OXFIXED`    TINYINT(1) NOT NULL default 0,
`OXKEYWORDS` TEXT NOT NULL,
`OXDESCRIPTION` TEXT NOT NULL,
`OXEXPIRED` tinyint(1) NOT NULL default '0',
`OXPARAMS` char(32) NOT NULL default '',
PRIMARY KEY (`OXIDENT`, `OXSHOPID`, `OXLANG`),
UNIQUE KEY search (`OXTYPE`, `OXOBJECTID`, `OXSHOPID`, `OXLANG`,`OXPARAMS`)
) TYPE=InnoDB;

INSERT INTO `oxseo` VALUES ('c855234180a3b4056b496120d229ea68', '023abc17c853f9bccc201c5afd549a92', 'oxbaseshop', 1, 'index.php?cl=account_wishlist', 'my-gift-registry/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('340d4f29f63cc0efc504915c0b94a44a', '0361774676321abf3204a44e167ffe40', 'oxbaseshop', 1, 'index.php?cl=help&amp;page=info&amp;tpl=security_info.tpl', 'help/data-protection/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('2e17757c0aaf8ed9ef2ba30317fa1faf', '0469752d03d80da379a679aaef4c0546', 'oxbaseshop', 1, 'index.php?cl=suggest', 'recommend/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('057ef382f23bdbb84991d049af2baba9', '063c82502d9dd528ce2cc40ceb76ade7', 'oxbaseshop', 1, 'index.php?cl=compare', 'my-product-comparison/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('23e2b46bdc9cd26023fd8020c5dff9a2', '0aaaa47d75da6581736b76eb4b4e62a3', 'oxbaseshop', 0, 'index.php?cl=help&amp;page=review', 'hilfe/bewertungen/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('41e797927a0b4318bc7fbc6c6702e194', '0f454924e8a9e54d99df911b3c8202ce', 'oxbaseshop', 1, 'index.php?cl=help&amp;page=account_order', 'help/order-history/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('41e797927a0b4318bc7fbc6c6702e194', '116b37d6d0aa3bc10d40c0972e46dc17', 'oxbaseshop', 0, 'index.php?cl=help&amp;page=account_order', 'hilfe/bestellhistorie/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('7bc8a506bbca225a2f95b6eac66020bf', '1368f5e45468ca1e1c7c84f174785c35', 'oxbaseshop', 1, 'index.php?cl=account_noticelist', 'my-wish-list/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('dda3486f1349724e085c363ae7d50785', '13fa69b27f1eb104d5664b68af4b2b13', 'oxbaseshop', 1, 'index.php?cl=help&amp;page=info&amp;tpl=impressum.tpl', 'help/about-us/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('dd1a86d489a8b312737f59ab2cac0eb4', '1701ec08c0928b603e5290078f8ab724', 'oxbaseshop', 1, 'index.php?cl=help&amp;page=details', 'help/product-details/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('1a583d63681ba48d989bdfd0bea8ade7', '192ce04536d8c1ea3d530825bc06bff9', 'oxbaseshop', 0, 'index.php?cl=help&amp;page=account_wishlist', 'hilfe/mein-wunschzettel/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('c855234180a3b4056b496120d229ea68', '1f30ae9b1c78b7dc89d3e5fe9eb0de59', 'oxbaseshop', 0, 'index.php?cl=account_wishlist', 'mein-wunschzettel/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('9ba8be21e759c0fb18ed36d2d12b34ad', '281a927fd36ff57e9d5cd21a6ad83145', 'oxbaseshop', 0, 'index.php?cl=help&amp;page=help', 'hilfe/hilfe/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('39e6808919a5c2cfea2c2733d9de60f8', '310a5b38352aecfde5a28d30ecaf2cb2', 'oxbaseshop', 0, 'index.php?cl=help&amp;page=compare', 'hilfe/mein-produktvergleich/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('1f28bd0d08f97dea49898ba2f5de8cb2', '34191c32cedbe8832d6aebb58b4555b3', 'oxbaseshop', 1, 'index.php?cl=info&amp;tpl=delivery_info.tpl', 'shipping-and-charges/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('4e0a1c1634b39b25dc36fd17e72046f0', '352dd404dd24e284e60006ce1da9a3ae', 'oxbaseshop', 0, 'index.php?cl=help&amp;page=vendorlist', 'hilfe/nach-hersteller/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('5b8e55f5ac0e8e720498dc4dab16c04a', '36152357000b7b33d50feadcd8838e05', 'oxbaseshop', 0, 'index.php?cl=info&amp;tpl=security_info.tpl', 'datenschutz/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('23e2b46bdc9cd26023fd8020c5dff9a2', '367a5b40fadd01331bb3a12e5cb0bef9', 'oxbaseshop', 1, 'index.php?cl=help&amp;page=review', 'help/product-review/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('e56acdd347b0516f68a0afdd811e2382', '3a41965fb36fb45df7f4f9a4377f6364', 'oxbaseshop', 1, 'index.php?cl=newsletter', 'newsletter/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('ab459c0dc911137e9cc024d9fba5a68b', '3bdd64bd8073d044d8fd60334ed9b725', 'oxbaseshop', 1, 'index.php?cl=start', 'home/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('be0df35ba37af88c6c09527f1e2d7180', '3c8229b33f16cfe0fc5db6c8177c18bb', 'oxbaseshop', 0, 'index.php?cl=help&amp;page=account_noticelist', 'hilfe/mein-merkzettel/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('b88b7ae13f9b7d571f9f4893a8d17c3f', '3ce579b1eb8d9b7387e93de042f0630e', 'oxbaseshop', 1, 'index.php?cl=help&amp;page=info&amp;tpl=customer_right_of_withdrawal.tpl', 'help/right-of-withdrawal/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('af8dad40e0bfb012be008efc3826fb54', '3e2a46c6550d9f8ec5a7f3216d023db2', 'oxbaseshop', 1, 'index.php?cl=info&amp;tpl=impressum.tpl', 'about-us/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('ab459c0dc911137e9cc024d9fba5a68b', '43e0a1f539e00dcfa1a6bc4d4fee4fc2', 'oxbaseshop', 0, 'index.php?cl=start', 'home/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('b88b7ae13f9b7d571f9f4893a8d17c3f', '44f621e49831ece86b22ea69dde82f2a', 'oxbaseshop', 0, 'index.php?cl=help&amp;page=info&amp;tpl=customer_right_of_withdrawal.tpl', 'hilfe/widerrufsrecht/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('d35db2901a428b971c0d7d53d64c4f77', '44fec8ed8396c63e0d958ae78996d1e4', 'oxbaseshop', 1, 'index.php?cl=help&amp;page=account', 'help/my-account/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('efaf9266cf7de3a8c84cea167285eb83', '4a70a4cd11d63fdce96fbe4ba8e714e6', 'oxbaseshop', 1, 'index.php?cnid=oxmore&amp;cl=alist', 'more/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('9ba8be21e759c0fb18ed36d2d12b34ad', '4ac8d6f8819076dd8fac958a264e04ff', 'oxbaseshop', 1, 'index.php?cl=help&amp;page=help', 'help/help/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('7ae7ab3bc27e81b92a56a54a7e02fdec', '4baf9bd95ca982018c1ec6527669aef7', 'oxbaseshop', 1, 'index.php?cl=help&amp;page=basket', 'help/cart/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('0a4d2f80aea0951a6ceef92a50b846cd', '4cbe8290a912fa8241167a13b5ac0b46', 'oxbaseshop', 0, 'index.php?cl=help&amp;page=info&amp;tpl=order_info.tpl', 'hilfe/wie-bestellen/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('efaf9266cf7de3a8c84cea167285eb83', '4d3d4d70b09b5d2bd992991361374c67', 'oxbaseshop', 0, 'index.php?cnid=oxmore&amp;cl=alist', 'mehr/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('18f64cbbc296a32fb84b3bbe31dfed09', '510fef34e5d9b86f6a77af949d15950e', 'oxbaseshop', 1, 'index.php?cl=account', 'my-account/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('ace1e168a1e8183a2aa79c2243171a29', '5668048844927ca2767140c219e04efc', 'oxbaseshop', 1, 'index.php?cl=account_user', 'my-address/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('63914909be6a4f61f7744b87876c20ee', '585f263995b6a8216d1d49c10bdea22f', 'oxbaseshop', 0, 'index.php?cl=help&amp;page=contact', 'hilfe/kontakt/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('0f8b225c4476bfb9f9f06072591caf0c', '5a0b0a570076f900c44f160a797832ef', 'oxbaseshop', 1, 'index.php?cl=help&amp;page=account_newsletter', 'help/newsletter-settings/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('0563ce7f6a400737ce0e1c2b2c733e49', '5cc081514a72b0ce3d7eec4fb1e6f1dd', 'oxbaseshop', 1, 'index.php?cl=forgotpwd', 'forgot-password/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('002a90a450bc0eba234f80b0b27636ff', '5e82443daf55ddc38b24aefe8ec0daa5', 'oxbaseshop', 1, 'index.php?cl=help&amp;page=newsletter', 'help/newsletter/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('6d9b5b3ee58bca1bd7be188f71e80ef2', '5eb126725ba500e6bbf1aecaa876dc48', 'oxbaseshop', 1, 'index.php?cl=review', 'product-review/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('8f44d31988a8962c87e3a0b7dda28ea2', '5f58b1965cb91c573ecd3d34c784c2e4', 'oxbaseshop', 0, 'index.php?cl=help&amp;page=account_user', 'hilfe/rechnungs-und-liefereinstellungen/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('7189adecf13cac2a3e0a085aa8c276d6', '6203915d115d00aacaa2a9ea3bc67cda', 'oxbaseshop', 1, 'index.php?cl=help&amp;page=register', 'help/open-account/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('6c3129355426de70051cc3c08a675bcd', '669be6da2be5edc1da4ece61b2dc72c2', 'oxbaseshop', 0, 'index.php?cl=help&amp;page=start', 'hilfe/home/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('8f44d31988a8962c87e3a0b7dda28ea2', '670524bc5a2b2334c83839396da5b10b', 'oxbaseshop', 1, 'index.php?cl=help&amp;page=account_user', 'help/billings-and-shipping-settings/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('be0df35ba37af88c6c09527f1e2d7180', '6a1a92c6e19cb0923edc299fd7d0c19b', 'oxbaseshop', 1, 'index.php?cl=help&amp;page=account_noticelist', 'help/my-wish-list/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('f560b18b547bca23752a154b45120980', '6b30b01fe01b80894efc0f29610e5215', 'oxbaseshop', 0, 'index.php?cl=account_password', 'mein-passwort/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('bde12a1bdd3b9c77bdc694a7de4c0dea', '6c3658516be12443e6778f253d9a6945', 'oxbaseshop', 0, 'index.php?cl=help&amp;page=alist', 'hilfe/kategorien/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('3819af3b86a45723369d4a926e62b910', '6c573bd394bfe2aae1a4dd9b0b65cef9', 'oxbaseshop', 0, 'index.php?cl=help&amp;page=info&amp;tpl=delivery_info.tpl', 'hilfe/versand-und-kosten/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('f560b18b547bca23752a154b45120980', '6c890ac1255a99f8d1eb46f1193843d6', 'oxbaseshop', 1, 'index.php?cl=account_password', 'my-password/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('4e0a1c1634b39b25dc36fd17e72046f0', '6d01ef2701d240d4b80250d176cc6ffa', 'oxbaseshop', 1, 'index.php?cl=help&amp;page=vendorlist', 'help/by-manufacturer/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('730781c5e392155012ef2f055eedce00', '74a7a5557c373f3a9b8268714abfd89c', 'oxbaseshop', 1, 'index.php?cl=help&amp;page=account_password', 'help/my-password/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('5b8e55f5ac0e8e720498dc4dab16c04a', '74e1551c34749343e6d17d302cea3f73', 'oxbaseshop', 1, 'index.php?cl=info&amp;tpl=security_info.tpl', 'data-protection/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('04abcb465a8d3a4441df4c480838d23d', '7685924d3f3fb7e9bda421c57f665af4', 'oxbaseshop', 1, 'index.php?cl=contact', 'contact/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('d12b7badee1037e7c1a5a7a245a14e11', '7c8aa72aa16b7d4a859b22d8b8328412', 'oxbaseshop', 0, 'index.php?cl=guestbook', 'gaestebuch/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('0f8b225c4476bfb9f9f06072591caf0c', '7ea6f0334b42ae9efcf7272cc6c5d8bd', 'oxbaseshop', 0, 'index.php?cl=help&amp;page=account_newsletter', 'hilfe/newslettereinstellungen/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('2e17757c0aaf8ed9ef2ba30317fa1faf', '82dd672d68d8f6c943f98ccdaecda691', 'oxbaseshop', 0, 'index.php?cl=suggest', 'empfehlen/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('6c3129355426de70051cc3c08a675bcd', '8480daf667f0c1fe8dd5c4dd66955e10', 'oxbaseshop', 1, 'index.php?cl=help&amp;page=start', 'help/home/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('d35db2901a428b971c0d7d53d64c4f77', '878b29f193adb05133109d82eb4d9a88', 'oxbaseshop', 0, 'index.php?cl=help&amp;page=account', 'hilfe/mein-konto/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('dd1a86d489a8b312737f59ab2cac0eb4', '878fb0ccc48bca3194436cc19c3200e1', 'oxbaseshop', 0, 'index.php?cl=help&amp;page=details', 'hilfe/produktdetails/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('18f64cbbc296a32fb84b3bbe31dfed09', '89c5e6bf1b5441599c4815281debe8df', 'oxbaseshop', 0, 'index.php?cl=account', 'mein-konto/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('7ae7ab3bc27e81b92a56a54a7e02fdec', '8db8366788784126550dfc537f794190', 'oxbaseshop', 0, 'index.php?cl=help&amp;page=basket', 'hilfe/warenkorb/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('dda3486f1349724e085c363ae7d50785', '9382a6c9f0c47028b6037adbfcf4138d', 'oxbaseshop', 0, 'index.php?cl=help&amp;page=info&amp;tpl=impressum.tpl', 'hilfe/impressum/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('343c043546b3d653647e75d2e246ce94', '9508bb0d70121d49e4d4554c5b1af81d', 'oxbaseshop', 0, 'index.php?cl=links', 'links/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('1f28bd0d08f97dea49898ba2f5de8cb2', '9876fe6d7ae54b3eb7c6085b26ad4980', 'oxbaseshop', 0, 'index.php?cl=info&amp;tpl=delivery_info.tpl', 'versand-und-kosten/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('39e6808919a5c2cfea2c2733d9de60f8', '9fc9811fd88eaf807b1036e07dbfa85c', 'oxbaseshop', 1, 'index.php?cl=help&amp;page=compare', 'help/my-product-comparison/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('610f7fc243c7409cb5448b30029431fe', '9ff5c21cbc84dbfe815013236e132baf', 'oxbaseshop', 1, 'index.php?cl=account_order', 'order-history/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('7189adecf13cac2a3e0a085aa8c276d6', 'a1322f6c88d2e16960433bbeb1c6c3da', 'oxbaseshop', 0, 'index.php?cl=help&amp;page=register', 'hilfe/konto-eroeffnen/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('98964bf04c7edae2d658c5f3b3233ca1', 'a1b330b85c6f51fd9b50b1eb19707d84', 'oxbaseshop', 1, 'index.php?cl=register', 'open-account/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('7bc8a506bbca225a2f95b6eac66020bf', 'a24b03f1a3f73c325a7647e6039e2359', 'oxbaseshop', 0, 'index.php?cl=account_noticelist', 'mein-merkzettel/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('71db5a32d74e4095f390ce401f158a14', 'a626f6f9942488da7ab0939c3585e58b', 'oxbaseshop', 0, 'index.php?cl=help&amp;page=guestbook', 'hilfe/gaestebuch/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('ace1e168a1e8183a2aa79c2243171a29', 'a7d5ab5a4e87693998c5aec066dda6e6', 'oxbaseshop', 0, 'index.php?cl=account_user', 'meine-adressen/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('0563ce7f6a400737ce0e1c2b2c733e49', 'a9afb500184c584fb5ab2ad9b4162e96', 'oxbaseshop', 0, 'index.php?cl=forgotpwd', 'passwort-vergessen/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('98964bf04c7edae2d658c5f3b3233ca1', 'acddcfef9c25bcae3b96eb00669541ff', 'oxbaseshop', 0, 'index.php?cl=register', 'konto-eroeffnen/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('6ba1f9c600305c7c92573cb6d1555797', 'af3d70b061ae02da3d6ce248c497dc32', 'oxbaseshop', 0, 'index.php?cl=help&amp;page=links', 'hilfe/links/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('002a90a450bc0eba234f80b0b27636ff', 'b61bd555494657d24f309799e30827ec', 'oxbaseshop', 0, 'index.php?cl=help&amp;page=newsletter', 'hilfe/newsletter/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('9c5ba516eb1e3313ed2eb2e4bb7759e3', 'b914c7bc2a782ad879f09eb654122cf3', 'oxbaseshop', 0, 'index.php?cl=info&amp;tpl=customer_right_of_withdrawal.tpl', 'widerrufsrecht/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('4e58f0c5e7a51ae60f857cc53734ef6e', 'c0e5670e15fe3235dd7fd9b6e343a074', 'oxbaseshop', 0, 'index.php?cl=info&amp;tpl=agb.tpl', 'agb/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('c69fce7ee6fe530a7afb651a296b3507', 'c1298d664559e5c887e3e18c7cda5133', 'oxbaseshop', 1, 'index.php?cl=info&amp;tpl=order_info.tpl', 'how-to-order/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('4e58f0c5e7a51ae60f857cc53734ef6e', 'c7f0defa518f67f01b85b8474f1a43ea', 'oxbaseshop', 1, 'index.php?cl=info&amp;tpl=agb.tpl', 'terms/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('6d9b5b3ee58bca1bd7be188f71e80ef2', 'cc28156a4f728c1b33e7e02fd846628e', 'oxbaseshop', 0, 'index.php?cl=review', 'bewertungen/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('af8dad40e0bfb012be008efc3826fb54', 'd3df023041bb144df4fd756a27d01d44', 'oxbaseshop', 0, 'index.php?cl=info&amp;tpl=impressum.tpl', 'impressum/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('12a669e9545e42567814a598de816691', 'd41f984132c321d4e06ad1f2a72d5882', 'oxbaseshop', 1, 'index.php?cl=help&amp;page=info&amp;tpl=agb.tpl', 'help/terms/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('bde12a1bdd3b9c77bdc694a7de4c0dea', 'd7abe1fb6fb1e9e6003b45844b0c0f09', 'oxbaseshop', 1, 'index.php?cl=help&amp;page=alist', 'help/categories/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('c4345f215c2f7b50549ca896b5c17f13', 'da3c1a52ac30056f0e020469a5d35d99', 'oxbaseshop', 0, 'index.php?cl=help&amp;page=forgotpwd', 'hilfe/passwort-vergessen/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('57cb6b2fafc870810cd48b8e1d28cf91', 'da6c5523f7c91d108cadb0be7757c27f', 'oxbaseshop', 1, 'index.php?cl=tags', 'tags/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('d12b7badee1037e7c1a5a7a245a14e11', 'ded4f3786c6f4d6d14e3034834ebdcaf', 'oxbaseshop', 1, 'index.php?cl=guestbook', 'guestbook/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('bc8df5696a42291e47f47478442ce2a8', 'e098f2c231bce2c60473c04f4cded5dd', 'oxbaseshop', 1, 'index.php?cl=help&amp;page=suggest', 'help/recommend/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('057ef382f23bdbb84991d049af2baba9', 'e0dd29a75947539da6b1924d31c9849f', 'oxbaseshop', 0, 'index.php?cl=compare', 'mein-produktvergleich/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('12a669e9545e42567814a598de816691', 'e1f3096e6be9f09d19a7b5416cf75ffd', 'oxbaseshop', 0, 'index.php?cl=help&amp;page=info&amp;tpl=agb.tpl', 'hilfe/agb/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('e56acdd347b0516f68a0afdd811e2382', 'e604233c5a2804d21ec0252a445e93d3', 'oxbaseshop', 0, 'index.php?cl=newsletter', 'newsletter/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('38efc02f0f6b6a6d54cfef1fcdb99d70', 'e6331d115f5323610c639ef2f0369f8a', 'oxbaseshop', 0, 'index.php?cl=basket', 'warenkorb/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('730781c5e392155012ef2f055eedce00', 'e6c20bf0d1d929f570f919f35a25bff1', 'oxbaseshop', 0, 'index.php?cl=help&amp;page=account_password', 'hilfe/mein-passwort/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('c4345f215c2f7b50549ca896b5c17f13', 'e7d3640dc365932ea39a5845017451f1', 'oxbaseshop', 1, 'index.php?cl=help&amp;page=forgotpwd', 'help/forgot-password/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('3819af3b86a45723369d4a926e62b910', 'e8cccc9bd869610593e416da1a066e19', 'oxbaseshop', 1, 'index.php?cl=help&amp;page=info&amp;tpl=delivery_info.tpl', 'help/shipping-and-charges/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('9c5ba516eb1e3313ed2eb2e4bb7759e3', 'e91d3f4809b713664045f30d900b789a', 'oxbaseshop', 1, 'index.php?cl=info&amp;tpl=customer_right_of_withdrawal.tpl', 'right-of-withdrawal/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('1a583d63681ba48d989bdfd0bea8ade7', 'e9c2c9ccc91911acd7e4e399c2c8838d', 'oxbaseshop', 1, 'index.php?cl=help&amp;page=account_wishlist', 'help/my-gift-registry/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('610f7fc243c7409cb5448b30029431fe', 'eb692d07ec8608d943db0a3bca29c4ce', 'oxbaseshop', 0, 'index.php?cl=account_order', 'bestellhistorie/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('38efc02f0f6b6a6d54cfef1fcdb99d70', 'ecaf0240f9f46bbee5ffc6dd73d0b7f0', 'oxbaseshop', 1, 'index.php?cl=basket', 'cart/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('bc8df5696a42291e47f47478442ce2a8', 'ed33aefc08d7a8b31ad3dcb61ba5d1b5', 'oxbaseshop', 0, 'index.php?cl=help&amp;page=suggest', 'hilfe/empfehlen/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('63914909be6a4f61f7744b87876c20ee', 'efbdcce791ae8fecc0a45ff7e1c92ca6', 'oxbaseshop', 1, 'index.php?cl=help&amp;page=contact', 'help/contact/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('57cb6b2fafc870810cd48b8e1d28cf91', 'f409502ee6998d6b48588958fde3cd6f', 'oxbaseshop', 0, 'index.php?cl=tags', 'tags/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('0a4d2f80aea0951a6ceef92a50b846cd', 'f460d530b15e5dfba1194eb4a32b87c5', 'oxbaseshop', 1, 'index.php?cl=help&amp;page=info&amp;tpl=order_info.tpl', 'help/how-to-order/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('343c043546b3d653647e75d2e246ce94', 'f80ace8f87e1d7f446ab1fa58f275f4c', 'oxbaseshop', 1, 'index.php?cl=links', 'links/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('71db5a32d74e4095f390ce401f158a14', 'f8e48035979bf62e5bbc15504f9d81fa', 'oxbaseshop', 1, 'index.php?cl=help&amp;page=guestbook', 'help/guestbook/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('04abcb465a8d3a4441df4c480838d23d', 'f9d1a02ab749dc360c4e21f21de1beaf', 'oxbaseshop', 0, 'index.php?cl=contact', 'kontakt/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('340d4f29f63cc0efc504915c0b94a44a', 'fda981a292e074f1b8ed3aa0937938b8', 'oxbaseshop', 0, 'index.php?cl=help&amp;page=info&amp;tpl=security_info.tpl', 'hilfe/datenschutz/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('6ba1f9c600305c7c92573cb6d1555797', 'ffd0f3c469cdb59bb32a4e647152dca7', 'oxbaseshop', 1, 'index.php?cl=help&amp;page=links', 'help/links/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('61c5d6965b480012aabb3a6701254b75', 'a4e5995182ade3cf039800c0ec2d512d', 'oxbaseshop', 0, 'index.php?cl=recommlist', 'Empfehlungslisten/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('61c5d6965b480012aabb3a6701254b75', '347333f119c147545287d02ff8954b8e', 'oxbaseshop', 1, 'index.php?cl=recommlist', 'Recomendation-Lists/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('f6bd7f77caae70afad276584caa6450a', '5d752e9e8302eeb21df24d1aee573234', 'oxbaseshop', 0, 'index.php?cl=wishlist', 'wunschzettel/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('f6bd7f77caae70afad276584caa6450a', 'b93b703d313e89662773cffaab750f1d', 'oxbaseshop', 1, 'index.php?cl=wishlist', 'gift-registry/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('9a545b8f4ebd5c1458b5aae08812b60f', 'f156d24d4a67d1a00e3423d7381ebfe8', 'oxbaseshop', 0, 'index.php?cl=help&amp;page=wishlist', 'hilfe/wunschzettel-oxid/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('9a545b8f4ebd5c1458b5aae08812b60f', 'c2d486a828d484a863b69e53078de31f', 'oxbaseshop', 1, 'index.php?cl=help&amp;page=wishlist', 'help/gift-registry/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('05c0f9a36dc4eaf3df528f0da18664d8', 'baa3b653a618696b06c70a6dda95ebde', 'oxbaseshop', 0, 'index.php?cl=account_recommlist', 'meine-lieblingslisten/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('05c0f9a36dc4eaf3df528f0da18664d8', '8e7ebaebb0a810576453082e1f8f2fa3', 'oxbaseshop', 1, 'index.php?cl=account_recommlist', 'my-listmania-list/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('a0ee4fb33f618ef2bef24e20d12d572f', '968c80a5b47daa4a4c7e5f1ac7c1925a', 'oxbaseshop', 0, 'index.php?cl=help&amp;page=account_recommlist', 'hilfe/meine-lieblingslisten/', 'static', 0, '', '', 0, '');
INSERT INTO `oxseo` VALUES ('a0ee4fb33f618ef2bef24e20d12d572f', 'dd78cb9b34d9cd30f8a848005c402ba6', 'oxbaseshop', 1, 'index.php?cl=help&amp;page=account_recommlist', 'help/my-listmania-list/', 'static', 0, '', '', 0, '');

# table oxseo for tracking old SEO urls
# created 2008-05-21

DROP TABLE IF EXISTS `oxseohistory`;

CREATE TABLE `oxseohistory` (
  `OXOBJECTID` char(32) NOT NULL,
  `OXIDENT` char(32) NOT NULL,
  `OXSHOPID` char(32) NOT NULL default '',
  `OXLANG` int(2) NOT NULL default '0',
  `OXHITS` bigint(20) NOT NULL default '0',
  `OXINSERT` timestamp NULL default NULL,
  `OXTIMESTAMP` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`OXIDENT`,`OXSHOPID`,`OXLANG`),
  KEY `search` (`OXOBJECTID`,`OXSHOPID`,`OXLANG`)
) ENGINE=InnoDB;

# table oxseolog for tracking untranslatable to SEO format non SEO urls
# created 2008-10-21

DROP TABLE IF EXISTS `oxseologs`;

CREATE TABLE IF NOT EXISTS `oxseologs` (
  `OXSTDURL` text NOT NULL,
  `OXIDENT` char(32) NOT NULL,
  `OXSHOPID` char(32) NOT NULL default '',
  `OXLANG` int(11) NOT NULL,
  `OXTIMESTAMP` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`OXIDENT`,`OXSHOPID`,`OXLANG`)
) ENGINE=InnoDB;

### shops table
UPDATE `oxshops` SET `OXACTIV` = '0' WHERE `OXACTIV` = '';
ALTER TABLE `oxshops` CHANGE `OXACTIV` `OXACTIVE` tinyint(1) NOT NULL DEFAULT '1';
UPDATE `oxshops` SET `OXACTIV_1` = '0' WHERE `OXACTIV_1` = '';

ALTER TABLE `oxshops` CHANGE `OXACTIV_1` `OXACTIVE_1` tinyint(1) NOT NULL DEFAULT '1';
UPDATE `oxshops` SET `OXACTIVE_1` = 0 WHERE `OXACTIVE_1` > 1;

UPDATE `oxshops` SET `OXACTIV_2` = '0' WHERE `OXACTIV_2` = '';
ALTER TABLE `oxshops` CHANGE `OXACTIV_2` `OXACTIVE_2` tinyint(1) NOT NULL DEFAULT '1';
UPDATE `oxshops` SET `OXACTIVE_2` = 0 WHERE `OXACTIVE_2` > 1;

UPDATE `oxshops` SET `OXACTIV_3` = '0' WHERE `OXACTIV_3` = '';
ALTER TABLE `oxshops` CHANGE `OXACTIV_3` `OXACTIVE_3` tinyint(1) NOT NULL DEFAULT '1';
UPDATE `oxshops` SET `OXACTIVE_3` = 0 WHERE `OXACTIVE_3` > 1;

ALTER TABLE `oxshops` ADD COLUMN `OXSEOACTIVE` tinyint(1) NOT NULL DEFAULT '1';
ALTER TABLE `oxshops` ADD COLUMN `OXSEOACTIVE_1` tinyint(1) NOT NULL DEFAULT '1';
ALTER TABLE `oxshops` ADD COLUMN `OXSEOACTIVE_2` tinyint(1) NOT NULL DEFAULT '1';
ALTER TABLE `oxshops` ADD COLUMN `OXSEOACTIVE_3` tinyint(1) NOT NULL DEFAULT '1';

ALTER TABLE `oxshops` DROP INDEX `OXACTIV`, ADD INDEX `OXACTIVE` ( `OXACTIVE` );
# moving Terms/About Us to contents table
INSERT INTO `oxcontents` ( `OXID`, `OXLOADID`, `OXSHOPID`, `OXSNIPPET`, `OXTYPE`, `OXACTIVE`, `OXTITLE`, `OXCONTENT`, `OXACTIVE_1`, `OXTITLE_1`, `OXCONTENT_1`, `OXACTIVE_2`, `OXTITLE_2`, `OXCONTENT_2`, `OXACTIVE_3`, `OXTITLE_3`, `OXCONTENT_3`, `OXCATID` )
SELECT MD5( CONCAT( `OXID`, `OXIMPRESSUM` ) ), 'oximpressum', `OXID`, '1', '0', '1', 'Impressum', `OXIMPRESSUM`, '1', 'About Us', `OXIMPRESSUM_1`, '1', 'About Us', `OXIMPRESSUM_2`, '1', 'About Us', `OXIMPRESSUM_3`, '8a142c3e4143562a5.46426637' FROM `oxshops`;

INSERT INTO `oxcontents` ( `OXID`, `OXLOADID`, `OXSHOPID`, `OXSNIPPET`, `OXTYPE`, `OXACTIVE`, `OXTITLE`, `OXCONTENT`, `OXACTIVE_1`, `OXTITLE_1`, `OXCONTENT_1`, `OXACTIVE_2`, `OXTITLE_2`, `OXCONTENT_2`, `OXACTIVE_3`, `OXTITLE_3`, `OXCONTENT_3`, `OXCATID` )
SELECT MD5( CONCAT( `OXID`, `OXAGB` ) ), 'oxagb', `OXID`, '1', '0', '1', 'AGB', `OXAGB`, '1', 'Terms', `OXAGB_1`, '1', 'Terms', `OXAGB_2`, '1', 'Terms', `OXAGB_3`, '8a142c3e4143562a5.46426637' FROM `oxshops`;

# dropping copied fields
ALTER TABLE `oxshops` DROP COLUMN `OXAGB`;
ALTER TABLE `oxshops` DROP COLUMN `OXAGB_1`;
ALTER TABLE `oxshops` DROP COLUMN `OXAGB_2`;
ALTER TABLE `oxshops` DROP COLUMN `OXAGB_3`;
ALTER TABLE `oxshops` DROP COLUMN `OXIMPRESSUM`;
ALTER TABLE `oxshops` DROP COLUMN `OXIMPRESSUM_1`;
ALTER TABLE `oxshops` DROP COLUMN `OXIMPRESSUM_2`;
ALTER TABLE `oxshops` DROP COLUMN `OXIMPRESSUM_3`;

# updating shop version
UPDATE `oxshops` SET `OXVERSION` = '4.0.0.0';


### oxuser table
UPDATE `oxuser` SET `OXACTIV` = '0' WHERE `OXACTIV` = '';
ALTER TABLE `oxuser` CHANGE `OXACTIV` `OXACTIVE` tinyint(1) NOT NULL DEFAULT '1';
UPDATE `oxuser` SET `OXACTIVE` = 0 WHERE `OXACTIVE` > 1;

ALTER TABLE `oxuser` DROP INDEX `OXACTIV`, ADD INDEX `OXACTIVE` ( `OXACTIVE` );

# changing enum into tinyint
UPDATE `oxuser` SET `OXDISABLEAUTOGRP` = '0' WHERE `OXDISABLEAUTOGRP` = '';
ALTER TABLE `oxuser` MODIFY COLUMN `OXDISABLEAUTOGRP` tinyint(1) NOT NULL DEFAULT '0';
UPDATE `oxuser` SET `OXDISABLEAUTOGRP` = `OXDISABLEAUTOGRP` - 1;
ALTER TABLE `oxuser` DROP COLUMN `OXCOUNTRY`;
ALTER TABLE `oxuser` DROP COLUMN `OXBUERGELLASTCHECK`;
ALTER TABLE `oxuser` DROP COLUMN `OXBUERGELTEXT`;
ALTER TABLE `oxuser` DROP COLUMN `OXBUERGELADRESSSTATUS`;
ALTER TABLE `oxuser` DROP COLUMN `OXBUERGELADRESSTEXT`;


# dropping vats from discount table and removing unneeded field
DELETE FROM `oxdiscount` WHERE `OXTYPE` = 'v';
ALTER TABLE `oxdiscount` DROP COLUMN `OXTYPE`;


### oxvendor table
UPDATE `oxvendor` SET `OXACTIV` = '0' WHERE `OXACTIV` = '';
ALTER TABLE `oxvendor` CHANGE `OXACTIV` `OXACTIVE` tinyint(1) NOT NULL DEFAULT '1';
UPDATE `oxvendor` SET `OXACTIVE` = 0 WHERE `OXACTIVE` > 1;

ALTER TABLE `oxvendor` DROP COLUMN `OXNROFARTICLES`;
ALTER TABLE `oxvendor` ADD `OXSHOWSUFFIX` TINYINT( 1 ) NOT NULL DEFAULT '1';


### oxwrapping table
UPDATE `oxwrapping` SET `OXACTIV` = '0' WHERE `OXACTIV` = '';
ALTER TABLE `oxwrapping` CHANGE `OXACTIV` `OXACTIVE` tinyint(1) NOT NULL DEFAULT '1';
UPDATE `oxwrapping` SET `OXACTIVE` = 0 WHERE `OXACTIVE` > 1;

UPDATE `oxwrapping` SET `OXACTIV_1` = '0' WHERE `OXACTIV_1` = '';
ALTER TABLE `oxwrapping` CHANGE `OXACTIV_1` `OXACTIVE_1` tinyint(1) NOT NULL DEFAULT '1';
UPDATE `oxwrapping` SET `OXACTIVE_1` = 0 WHERE `OXACTIVE_1` > 1;

UPDATE `oxwrapping` SET `OXACTIV_2` = '0' WHERE `OXACTIV_2` = '';
ALTER TABLE `oxwrapping` CHANGE `OXACTIV_2` `OXACTIVE_2` tinyint(1) NOT NULL DEFAULT '1';
UPDATE `oxwrapping` SET `OXACTIVE_2` = 0 WHERE `OXACTIVE_2` > 1;

UPDATE `oxwrapping` SET `OXACTIV_3` = '0' WHERE `OXACTIV_3` = '';
ALTER TABLE `oxwrapping` CHANGE `OXACTIV_3` `OXACTIVE_3` tinyint(1) NOT NULL DEFAULT '1';
UPDATE `oxwrapping` SET `OXACTIVE_3` = 0 WHERE `OXACTIVE_3` > 1;


### dropping not needed tables
DROP TABLE `oxobject2pricecount`;
DROP TABLE `oxobject2vatrule`;
DROP TABLE `oxpricecount`;
DROP TABLE `oxvatrule`;
DROP TABLE `oxsessions`;


### changing table types
ALTER TABLE `oxarticles` ENGINE = InnoDB;
ALTER TABLE `oxlogs` ENGINE = InnoDB;
ALTER TABLE `oxvouchers` ENGINE = InnoDB;
ALTER TABLE `oxvoucherseries` ENGINE = InnoDB;
ALTER TABLE `oxorder` ENGINE = InnoDB;
ALTER TABLE `oxorderarticles` ENGINE = InnoDB;
ALTER TABLE `oxstatistics` ENGINE = InnoDB;
ALTER TABLE `oxuserbasketitems` ENGINE = InnoDB;
ALTER TABLE `oxuserbaskets` ENGINE = InnoDB;
ALTER TABLE `oxuserpayments` ENGINE = InnoDB;

ALTER TABLE `oxobject2delivery` ADD INDEX `OXDELIVERYID` ( `OXDELIVERYID` , `OXTYPE` );

ALTER TABLE `oxarticles` CHANGE `OXPARENTID` `OXPARENTID` CHAR( 32 ) NOT NULL default '';

ALTER TABLE `oxarticles` DROP `OXAKTION`;
ALTER TABLE `oxorderarticles` DROP `OXAKTION`;


### oxcountry table
ALTER TABLE `oxcountry` ADD COLUMN `OXVATSTATUS` tinyint(1) NOT NULL DEFAULT '0';

# setting default VAT statuses
UPDATE `oxcountry` SET `OXVATSTATUS` = 1 WHERE `OXID` IN ( 'a7c40f631fc920687.20179984',  'a7c40f6320aeb2ec2.72885259', 'a7c40f6323c4bfb36.59919433',
'a7c40f63264309e05.58576680', 'a7c40f63272a57296.32117580', 'a7c40f632848c5217.53322339', 'a7c40f63293c19d65.37472814', 'a7c40f632a0804ab5.18804076',
'a7c40f632be4237c2.48517912', 'a7c40f632cdd63c52.64272623', 'a7c40f632e04633c9.47194042', 'a7c40f632f65bd8e2.84963272', 'a7c40f633038cd578.22975442',
'a7c40f633114e8fc6.25257477', '8f241f110955d3260.55487539', '8f241f110957b6896.52725150', '8f241f110957cb457.97820918', '8f241f110957e6ef8.56458418',
'8f241f110958b69e4.93886171', '8f241f11095b3e016.98213173', '8f241f11095cf2ea6.73925511', '8f241f11095d6ffa8.86593236', '8f241f11095e36eb3.69050509',
'8f241f1109624d3f8.50953605', '8f241f110962c3007.60363573', '8f241f1109647a265.29938154', '8f241f11096497149.85116254' );

# oxconfig updates and new values
UPDATE oxconfig SET OXVARTYPE = 'aarr' WHERE OXVARNAME = 'aLanguages';

REPLACE `oxconfig` (`OXID`, `OXSHOPID`, `OXVARNAME`, `OXVARTYPE`, `OXVARVALUE`) VALUES ('b0b4d221756c80afdad8904c0b91b877', 'oxbaseshop', 'iRssItemsCount', 'str', 0xb6c7);
REPLACE `oxconfig` (`OXID`, `OXSHOPID`, `OXVARNAME`, `OXVARTYPE`, `OXVARVALUE`) VALUES ('9fa5abe1bd51b6bbe97f95d8199660e5', 'oxbaseshop', 'aSeoReplaceChars', 'aarr', 0x4dba422a71495232a5777b11e101a218a65b6b8b54eb9139b44875f08d1f732c8b944cff73f2854633a67da52ac4258fecbd4331beae8950ab6d7a407e73fddcddc272e7bb6d190b8cb03718368f899425b48d2108358c2e40c08d0f808894c323ba6240f4d0b7fb5aa4bab1938cc98a9d2045789d6fc428547da6cb0d);
REPLACE `oxconfig` (`OXID`, `OXSHOPID`, `OXVARNAME`, `OXVARTYPE`, `OXVARVALUE`) VALUES ('8b831f739c5d16cf4571b14a76006568', 'oxbaseshop', 'aSEOReservedWords', 'arr', 0x4dba422a71e248f1c8d0aa4c153fcde9eec56a0fcc7c8947b718d1dff30f2db6d7a60c59398fb5e1aa5999cfde45071ab225fba4d72b3ba9c23a4b0adb75314b1e7a2de97adee42d81197c0b48d4621740313f9df1ad63f693b7c47aa031ed88093c0e12eb85a75de769ede4f57823a56c6576106fb7);
REPLACE `oxconfig` (`OXID`, `OXSHOPID`, `OXVARNAME`, `OXVARTYPE`, `OXVARVALUE`) VALUES ('cb6cdb441255938e1d311bb7104202b8', 'oxbaseshop', 'aRssSelected', 'arr', 0x4dbace2972e14bf2cbd3a91552540312fdb89dff9b147c0068096323a537f01e08d3c10e9db1838a83fe046c5136fbf8900f15f0c03307f5e788c7903ceca9e6a5341f11619d68ddd447f63664c6348ec0f55993b4d3923b7d4ce09603e84c4099a7505f62ab3810f0daa3);
DELETE FROM `oxconfig` WHERE OXVARNAME = 'iValidateEMail';
DELETE FROM `oxconfig` WHERE OXVARNAME = 'aRobots';
DELETE FROM `oxconfig` WHERE OXVARNAME = 'aNameServers';
DELETE FROM `oxconfig` WHERE OXVARNAME = 'aRobotsExcept';
DELETE FROM `oxconfig` WHERE OXVARNAME = 'blCheckOldSID';
DELETE FROM `oxconfig` WHERE OXVARNAME = 'bl_perfEnableCustomDBLayout';
DELETE FROM `oxconfig` WHERE OXVARNAME = 'blUseAntispam';
REPLACE `oxconfig` (`OXID`, `OXSHOPID`, `OXVARNAME`, `OXVARTYPE`, `OXVARVALUE`) VALUES ('46473ac9c01a70e0485f6e529a9d924b', 'oxbaseshop', 'bl_perfShowTopBasket', 'bool', 0x93ea1218);

### oxratings table
CREATE TABLE `oxratings` (
  `OXID` char(32) NOT NULL default '',
  `OXSHOPID` char(32) NOT NULL default '',
  `OXUSERID` char(32) NOT NULL default '',
  `OXTYPE` enum('oxarticle','oxrecommlist') NOT NULL,
  `OXOBJECTID` char(32) NOT NULL default '',
  `OXRATING` int(1) NOT NULL default '0',
  `OXTIMESTAMP` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`OXID`),
  KEY `oxobjectsearch` (`OXTYPE`,`OXOBJECTID`)
) TYPE=MyISAM;

### oxrecommlists table
CREATE TABLE `oxrecommlists` (
  `OXID` char(32) NOT NULL default '',
  `OXSHOPID` char(32) NOT NULL default '',
  `OXUSERID` char(32) NOT NULL default '',
  `OXAUTHOR` varchar(255) NOT NULL default '',
  `OXTITLE` varchar(255) NOT NULL default '',
  `OXDESC` text NOT NULL,
  PRIMARY KEY  (`OXID`)
) TYPE=MyISAM;

### oxobject2list table
CREATE TABLE `oxobject2list` (
  `OXID` char(32) NOT NULL default '',
  `OXOBJECTID` char(32) NOT NULL default '',
  `OXLISTID` char(32) NOT NULL default '',
  `OXDESC` text NOT NULL default '',
  PRIMARY KEY  (`OXID`),
  KEY `OXOBJECTID` (`OXOBJECTID`),
  KEY `OXLISTID` (`OXLISTID`)
) TYPE=MyISAM;


ALTER TABLE `oxshops` ADD `OXTITLESUFFIX` VARCHAR( 255 ) NOT NULL default '' AFTER `OXNAME` ;
ALTER TABLE `oxshops` ADD `OXTITLESUFFIX_1` VARCHAR( 255 ) NOT NULL default '' AFTER `OXTITLESUFFIX` ;
ALTER TABLE `oxshops` ADD `OXTITLESUFFIX_2` VARCHAR( 255 ) NOT NULL default '' AFTER `OXTITLESUFFIX_1` ;
ALTER TABLE `oxshops` ADD `OXTITLESUFFIX_3` VARCHAR( 255 ) NOT NULL default '' AFTER `OXTITLESUFFIX_2` ;

UPDATE `oxshops` SET `OXTITLESUFFIX` = 'Online kaufen', `OXTITLESUFFIX_1` = 'Buy online';

ALTER TABLE `oxshops` ADD `OXTITLEPREFIX` VARCHAR( 255 ) NOT NULL default '' AFTER `OXNAME` ;
ALTER TABLE `oxshops` ADD `OXTITLEPREFIX_1` VARCHAR( 255 ) NOT NULL default '' AFTER `OXTITLEPREFIX` ;
ALTER TABLE `oxshops` ADD `OXTITLEPREFIX_2` VARCHAR( 255 ) NOT NULL default '' AFTER `OXTITLEPREFIX_1` ;
ALTER TABLE `oxshops` ADD `OXTITLEPREFIX_3` VARCHAR( 255 ) NOT NULL default '' AFTER `OXTITLEPREFIX_2` ;

UPDATE `oxshops` SET `OXTITLEPREFIX` = OXNAME, `OXTITLEPREFIX_1` = OXNAME;

ALTER TABLE `oxshops` ADD `OXSTARTTITLE` VARCHAR( 255 ) NOT NULL default '' AFTER `OXTITLESUFFIX_3` ,
ADD `OXSTARTTITLE_1` VARCHAR( 255 ) NOT NULL default '' AFTER `OXSTARTTITLE` ,
ADD `OXSTARTTITLE_2` VARCHAR( 255 ) NOT NULL default '' AFTER `OXSTARTTITLE_1` ,
ADD `OXSTARTTITLE_3` VARCHAR( 255 ) NOT NULL default '' AFTER `OXSTARTTITLE_2` ;

UPDATE `oxshops` SET `OXSTARTTITLE` = 'Online kaufen', `OXSTARTTITLE_1` = 'Buy online';

CREATE TABLE `oxmediaurls` (
 `OXID` CHAR( 32 ) NOT NULL ,
 `OXOBJECTID` CHAR( 32 ) NOT NULL ,
 `OXURL` VARCHAR( 255 ) NOT NULL ,
 `OXDESC` VARCHAR( 255 ) NOT NULL ,
 `OXDESC_1` VARCHAR( 255 ) NOT NULL ,
 `OXDESC_2` VARCHAR( 255 ) NOT NULL ,
 `OXDESC_3` VARCHAR( 255 ) NOT NULL ,
 `OXISUPLOADED` int(1) NOT NULL default '0',
 PRIMARY KEY ( `OXID` ) ,
 INDEX ( `OXOBJECTID` )
) ENGINE = MYISAM ;





ALTER TABLE `oxrecommlists` ADD COLUMN `OXRATINGCNT` int(11) NOT NULL default '0';
ALTER TABLE `oxrecommlists` ADD COLUMN `OXRATING` double NOT NULL default '0';

ALTER TABLE `oxobject2list` ADD `OXTIMESTAMP` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ;

ALTER TABLE `oxshops` ADD COLUMN `OXPRODUCTIVE` tinyint(1) NOT NULL default '0' AFTER `OXACTIVE_3`;

### preliminary update oxvarminprice script
#UPDATE oxarticles SET oxarticles.oxvarminprice = oxarticles.oxprice;
### correct but slow update oxvarminprice script
#UPDATE oxarticles SET oxarticles.oxvarminprice = (select min(art.oxprice) as varminprice from (select * from oxarticles) as art where art.oxparentid = oxarticles.oxid or ( art.oxid = oxarticles.oxid and art.oxparentid = ''));

# in new version language config parameter is changed, so to make shop working
# this config option must be updated. After update user must update parameter
REPLACE `oxconfig` (`OXID`, `OXSHOPID`, `OXVARNAME`, `OXVARTYPE`, `OXVARVALUE`) VALUES ('8563fba1965a389e2.11728478', 'oxbaseshop', 'aLanguages', 'aarr', 0x4dba832f744c5786a371d9df3377ea87f0e2773dbaf685493e0b949a1c149111959424345b628f640a0d92ea6047ec118252e992);

ALTER TABLE `oxshops` ADD `OXEDITION` CHAR( 2 ) NOT NULL AFTER `OXAFFILI24ID` ;
UPDATE oxshops SET oxedition = 'PE';

ALTER TABLE `oxshops` DROP `OXSERIAL`;

#adding new config fields
INSERT INTO `oxconfig` VALUES ('fd770460540c32422b415a65fefb8f90', 'oxbaseshop', 'blLoadDynContents', 'bool', 0x7900fdf51e);
INSERT INTO `oxconfig` VALUES ('fd7a064bbb64466f8e6ba847902b2005', 'oxbaseshop', 'sShopCountry', 'str', '');