Nullable oxid database columns to fix MariaDB 10.2 bug with two quotes insteat of empty value.

oxarticle.sql

ALTER TABLE
    `oxarticles`
        CHANGE `OXPARENTID` `OXPARENTID` char(32) character set utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT 'Parent article id',
        CHANGE `OXUNITNAME` `OXUNITNAME` varchar(32) NULL default '' COMMENT 'Unit name (kg,g,l,cm etc), used in setting price per quantity unit calculation',
        CHANGE `OXEXTURL` `OXEXTURL` varchar(255) NULL default '' COMMENT 'External URL to other information about the article',
        CHANGE `OXURLDESC` `OXURLDESC` varchar(255) NULL default '' COMMENT 'Text for external URL (multilanguage)',
        CHANGE `OXURLIMG` `OXURLIMG` varchar(128) NULL default '' COMMENT 'External URL image',
        CHANGE `OXTHUMB` `OXTHUMB` varchar(128) NULL default '' COMMENT 'Thumbnail filename',
        CHANGE `OXICON` `OXICON` varchar(128) NULL default '' COMMENT 'Icon filename',
        CHANGE `OXPIC1` `OXPIC1` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '1# Picture filename',
        CHANGE `OXPIC2` `OXPIC2` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '2# Picture filename',
        CHANGE `OXPIC3` `OXPIC3` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '3# Picture filename',
        CHANGE `OXPIC4` `OXPIC4` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '4# Picture filename',
        CHANGE `OXPIC5` `OXPIC5` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '5# Picture filename',
        CHANGE `OXPIC6` `OXPIC6` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '6# Picture filename',
        CHANGE `OXPIC7` `OXPIC7` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '7# Picture filename',
        CHANGE `OXPIC8` `OXPIC8` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '8# Picture filename',
        CHANGE `OXPIC9` `OXPIC9` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '9# Picture filename',
        CHANGE `OXPIC10` `OXPIC10` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '10# Picture filename',
        CHANGE `OXPIC11` `OXPIC11` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '11# Picture filename',
        CHANGE `OXPIC12` `OXPIC12` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '12# Picture filename',
        CHANGE `OXSTOCKTEXT` `OXSTOCKTEXT` varchar(255) NULL default '' COMMENT 'Message, which is shown if the article is in stock (multilanguage)',
        CHANGE `OXNOSTOCKTEXT` `OXNOSTOCKTEXT` varchar(255) NULL default '' COMMENT 'Message, which is shown if the article is off stock (multilanguage)',
        CHANGE `OXFILE` `OXFILE` varchar(128) NULL default '' COMMENT 'File, shown in article media list',
        CHANGE `OXTEMPLATE` `OXTEMPLATE` varchar(128) NULL default '' COMMENT 'Alternative template filename (if empty, default is used)',
        CHANGE `OXQUESTIONEMAIL` `OXQUESTIONEMAIL` varchar(255) NULL default '' COMMENT 'E-mail for question',
        CHANGE `OXVARNAME` `OXVARNAME` varchar(255) NULL default '' COMMENT 'Name of variants selection lists (different lists are separated by | ) (multilanguage)',
        CHANGE `OXVARSELECT` `OXVARSELECT` varchar(255) NULL default '' COMMENT 'Variant article selections (separated by | ) (multilanguage)',
        CHANGE `OXBUNDLEID` `OXBUNDLEID` varchar(32) character set utf8 COLLATE utf8_general_ci NULL default '' COMMENT 'Bundled article id',
        CHANGE `OXFOLDER` `OXFOLDER` varchar(32) NULL default '' COMMENT 'Folder',
        CHANGE `OXAMITEMID` `OXAMITEMID` varchar(32) character set utf8 COLLATE utf8_general_ci NULL default '',
        CHANGE `OXDELTIMEUNIT` `OXDELTIMEUNIT` varchar(255) character set utf8 COLLATE utf8_general_ci NULL default '' COMMENT 'Delivery time unit: DAY, WEEK, MONTH',
        CHANGE `OXPICATTRIBUTE` `OXPICATTRIBUTE` varchar(128) COLLATE 'utf8_general_ci' NULL DEFAULT '' COMMENT 'Attribute picture filename, used for preview in details page' AFTER `CIUSEFILTERINDETAILS`,
        CHANGE `OXPICATTRIBUTE_ICON` `OXPICATTRIBUTE_ICON` varchar(128) COLLATE 'utf8_general_ci' NULL DEFAULT '' COMMENT 'Attribut icon, used for attribute value list in details page' AFTER `OXPICATTRIBUTE`;

UPDATE `oxarticles` SET OXPARENTID = NULL WHERE OXPARENTID = "''";
UPDATE `oxarticles` SET OXUNITNAME = NULL WHERE OXUNITNAME = "''";
UPDATE `oxarticles` SET OXEXTURL = NULL WHERE OXEXTURL = "''";
UPDATE `oxarticles` SET OXURLDESC = NULL WHERE OXURLDESC = "''";
UPDATE `oxarticles` SET OXURLIMG = NULL WHERE OXURLIMG = "''";
UPDATE `oxarticles` SET OXTHUMB = NULL WHERE OXTHUMB = "''";
UPDATE `oxarticles` SET OXICON = NULL WHERE OXICON = "''";
UPDATE `oxarticles` SET OXPIC1 = NULL WHERE OXPIC1 = "''";
UPDATE `oxarticles` SET OXPIC2 = NULL WHERE OXPIC2 = "''";
UPDATE `oxarticles` SET OXPIC3 = NULL WHERE OXPIC3 = "''";
UPDATE `oxarticles` SET OXPIC4 = NULL WHERE OXPIC4 = "''";
UPDATE `oxarticles` SET OXPIC5 = NULL WHERE OXPIC5 = "''";
UPDATE `oxarticles` SET OXPIC6 = NULL WHERE OXPIC6 = "''";
UPDATE `oxarticles` SET OXPIC7 = NULL WHERE OXPIC7 = "''";
UPDATE `oxarticles` SET OXPIC8 = NULL WHERE OXPIC8 = "''";
UPDATE `oxarticles` SET OXPIC9 = NULL WHERE OXPIC9 = "''";
UPDATE `oxarticles` SET OXPIC10 = NULL WHERE OXPIC10 = "''";
UPDATE `oxarticles` SET OXPIC11 = NULL WHERE OXPIC11 = "''";
UPDATE `oxarticles` SET OXPIC12 = NULL WHERE OXPIC12 = "''";
UPDATE `oxarticles` SET OXSTOCKTEXT = NULL WHERE OXSTOCKTEXT = "''";
UPDATE `oxarticles` SET OXNOSTOCKTEXT = NULL WHERE OXNOSTOCKTEXT = "''";
UPDATE `oxarticles` SET OXFILE = NULL WHERE OXFILE = "''";
UPDATE `oxarticles` SET OXTEMPLATE = NULL WHERE OXTEMPLATE = "''";
UPDATE `oxarticles` SET OXQUESTIONEMAIL = NULL WHERE OXQUESTIONEMAIL = "''";
UPDATE `oxarticles` SET OXVARNAME = NULL WHERE OXVARNAME = "''";
UPDATE `oxarticles` SET OXVARSELECT = NULL WHERE OXVARSELECT = "''";
UPDATE `oxarticles` SET OXBUNDLEID = NULL WHERE OXBUNDLEID = "''";
UPDATE `oxarticles` SET OXFOLDER = NULL WHERE OXFOLDER = "''";
UPDATE `oxarticles` SET OXAMITEMID = NULL WHERE OXAMITEMID = "''";
UPDATE `oxarticles` SET OXDELTIMEUNIT = NULL WHERE OXDELTIMEUNIT = "''";
UPDATE `oxarticles` SET OXPICATTRIBUTE = NULL WHERE OXPICATTRIBUTE = "''";
UPDATE `oxarticles` SET OXPICATTRIBUTE_ICON = NULL WHERE OXPICATTRIBUTE_ICON = "''";

oxmanufacturers.sql

ALTER TABLE `oxmanufacturers`
CHANGE `OXICON` `OXICON` char(128) COLLATE 'utf8_general_ci' NULL DEFAULT '' COMMENT 'Icon filename' AFTER `OXACTIVE`,
CHANGE `OXSHORTDESC` `OXSHORTDESC` char(255) COLLATE 'utf8_general_ci' NULL DEFAULT '' COMMENT 'Short description (multilanguage)' AFTER `OXTITLE`,
CHANGE `OXTITLE_1` `OXTITLE_1` char(255) COLLATE 'utf8_general_ci' NULL DEFAULT '' AFTER `OXSHORTDESC`,
CHANGE `OXSHORTDESC_1` `OXSHORTDESC_1` char(255) COLLATE 'utf8_general_ci' NULL DEFAULT '' AFTER `OXTITLE_1`,
CHANGE `OXTITLE_2` `OXTITLE_2` char(255) COLLATE 'utf8_general_ci' NULL DEFAULT '' AFTER `OXSHORTDESC_1`,
CHANGE `OXSHORTDESC_2` `OXSHORTDESC_2` char(255) COLLATE 'utf8_general_ci' NULL DEFAULT '' AFTER `OXTITLE_2`,
CHANGE `OXTITLE_3` `OXTITLE_3` char(255) COLLATE 'utf8_general_ci' NULL DEFAULT '' AFTER `OXSHORTDESC_2`,
CHANGE `OXSHORTDESC_3` `OXSHORTDESC_3` char(255) COLLATE 'utf8_general_ci' NULL DEFAULT '' AFTER `OXTITLE_3`,
CHANGE `OXTIMESTAMP` `OXTIMESTAMP` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE CURRENT_TIMESTAMP COMMENT 'Timestamp' AFTER `OXSHOWSUFFIX`;

UPDATE oxmanufacturers SET OXICON = NULL WHERE OXICON = "''";
UPDATE oxmanufacturers SET OXSHORTDESC = NULL WHERE OXSHORTDESC = "''";
UPDATE oxmanufacturers SET OXTITLE_1 = NULL WHERE OXTITLE_1 = "''";
UPDATE oxmanufacturers SET OXSHORTDESC_1 = NULL WHERE OXSHORTDESC_1 = "''";
UPDATE oxmanufacturers SET OXTITLE_2 = NULL WHERE OXTITLE_2 = "''";
UPDATE oxmanufacturers SET OXSHORTDESC_2 = NULL WHERE OXSHORTDESC_2 = "''";
UPDATE oxmanufacturers SET OXTITLE_3 = NULL WHERE OXTITLE_3 = "''";
UPDATE oxmanufacturers SET OXSHORTDESC_3 = NULL WHERE OXSHORTDESC_3 = "''";
UPDATE oxmanufacturers SET OXTIMESTAMP = NULL WHERE OXTIMESTAMP = "''";

oxorders.sql

ALTER TABLE `oxorder`
CHANGE `OXDELCOMPANY` `OXDELCOMPANY` varchar(255) COLLATE 'utf8_general_ci' NULL DEFAULT '' COMMENT 'Shipping info: Company name' AFTER `OXBILLSAL`,
CHANGE `OXDELFNAME` `OXDELFNAME` varchar(255) COLLATE 'utf8_general_ci' NULL DEFAULT '' COMMENT 'Shipping info: First name' AFTER `OXDELCOMPANY`,
CHANGE `OXDELLNAME` `OXDELLNAME` varchar(255) COLLATE 'utf8_general_ci' NULL DEFAULT '' COMMENT 'Shipping info: Last name' AFTER `OXDELFNAME`,
CHANGE `OXDELSTREETNR` `OXDELSTREETNR` varchar(16) COLLATE 'utf8_general_ci' NULL DEFAULT '' COMMENT 'Shipping info: House number' AFTER `OXDELSTREET`,
CHANGE `OXDELADDINFO` `OXDELADDINFO` varchar(255) COLLATE 'utf8_general_ci' NULL DEFAULT '' COMMENT 'Shipping info: Additional info' AFTER `OXDELSTREETNR`,
CHANGE `OXDELCITY` `OXDELCITY` varchar(255) COLLATE 'utf8_general_ci' NULL DEFAULT '' COMMENT 'Shipping info: City' AFTER `OXDELADDINFO`,
CHANGE `OXDELCOUNTRYID` `OXDELCOUNTRYID` varchar(32) COLLATE 'utf8_general_ci' NULL DEFAULT '' COMMENT 'Shipping info: Country id (oxcountry)' AFTER `OXDELCITY`,
CHANGE `OXDELSTATEID` `OXDELSTATEID` varchar(32) COLLATE 'utf8_general_ci' NULL DEFAULT '' COMMENT 'Shipping info: US State id (oxstates)' AFTER `OXDELCOUNTRYID`,
CHANGE `OXDELZIP` `OXDELZIP` varchar(16) COLLATE 'utf8_general_ci' NULL DEFAULT '' COMMENT 'Shipping info: Zip code' AFTER `OXDELSTATEID`,
CHANGE `OXDELFON` `OXDELFON` varchar(128) COLLATE 'utf8_general_ci' NULL DEFAULT '' COMMENT 'Shipping info: Phone number' AFTER `OXDELZIP`,
CHANGE `OXDELFAX` `OXDELFAX` varchar(128) COLLATE 'utf8_general_ci' NULL DEFAULT '' COMMENT 'Shipping info: Fax number' AFTER `OXDELFON`,
CHANGE `OXDELSAL` `OXDELSAL` varchar(128) COLLATE 'utf8_general_ci' NULL DEFAULT '' COMMENT 'Shipping info: User title prefix (Mr/Mrs)' AFTER `OXDELFAX`,
CHANGE `OXCARDID` `OXCARDID` varchar(32) COLLATE 'utf8_general_ci' NULL DEFAULT '' COMMENT 'Gift card id (oxwrapping)' AFTER `OXGIFTCARDVAT`,
CHANGE `OXBILLNR` `OXBILLNR` varchar(128) COLLATE 'utf8_general_ci' NULL DEFAULT '' COMMENT 'Invoice No.' AFTER `OXEXPORT`,
CHANGE `OXTRACKCODE` `OXTRACKCODE` varchar(128) COLLATE 'utf8_general_ci' NULL DEFAULT '' COMMENT 'Tracking code' AFTER `OXBILLDATE`,
CHANGE `OXPAYID` `OXPAYID` varchar(64) COLLATE 'utf8_general_ci' NULL DEFAULT '' AFTER `OXTRANSID`,
CHANGE `OXXID` `OXXID` varchar(64) COLLATE 'utf8_general_ci' NULL DEFAULT '' AFTER `OXPAYID`,
CHANGE `OXIP` `OXIP` varchar(39) COLLATE 'utf8_general_ci' NULL DEFAULT '' COMMENT 'User ip address' AFTER `OXSTORNO`,
CHANGE `OXTIMESTAMP` `OXTIMESTAMP` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE CURRENT_TIMESTAMP COMMENT 'Timestamp' AFTER `OXDELTYPE`,
CHANGE `FCPOTXID` `FCPOTXID` varchar(32) COLLATE 'utf8_general_ci' NULL DEFAULT '' AFTER `OXTSPROTECTCOSTS`,
CHANGE `FCPOAUTHMODE` `FCPOAUTHMODE` varchar(32) COLLATE 'utf8_general_ci' NULL DEFAULT '' AFTER `FCPOREFNR`,
CHANGE `FCPOMODE` `FCPOMODE` varchar(8) COLLATE 'utf8_general_ci' NULL DEFAULT '' AFTER `FCPOAUTHMODE`,
CHANGE `FCPOWORKORDERID` `FCPOWORKORDERID` varchar(16) COLLATE 'utf8_general_ci' NULL DEFAULT '' AFTER `FCPOORDERNOTCHECKED`,
CHANGE `FCPOCLEARINGREFERENCE` `FCPOCLEARINGREFERENCE` varchar(32) COLLATE 'utf8_general_ci' NULL DEFAULT '' AFTER `FCPOWORKORDERID`,
CHANGE `FCPOPROFILEIDENT` `FCPOPROFILEIDENT` varchar(32) COLLATE 'utf8_general_ci' NULL DEFAULT '' AFTER `FCPOCLEARINGREFERENCE`;


UPDATE oxorder SET OXDELCOMPANY = NULL WHERE OXDELCOMPANY = "''";
UPDATE oxorder SET OXDELFNAME = NULL WHERE OXDELFNAME = "''";
UPDATE oxorder SET OXDELLNAME = NULL WHERE OXDELLNAME = "''";
UPDATE oxorder SET OXDELSTREET = NULL WHERE OXDELSTREET = "''";
UPDATE oxorder SET OXDELSTREETNR = NULL WHERE OXDELSTREETNR = "''";
UPDATE oxorder SET OXDELADDINFO = NULL WHERE OXDELADDINFO = "''";
UPDATE oxorder SET OXDELCITY = NULL WHERE OXDELCITY = "''";
UPDATE oxorder SET OXDELCOUNTRYID = NULL WHERE OXDELCOUNTRYID = "''";
UPDATE oxorder SET OXDELSTATEID = NULL WHERE OXDELSTATEID = "''";
UPDATE oxorder SET OXDELZIP = NULL WHERE OXDELZIP = "''";
UPDATE oxorder SET OXDELFON = NULL WHERE OXDELFON = "''";
UPDATE oxorder SET OXDELFAX = NULL WHERE OXDELFAX = "''";
UPDATE oxorder SET OXDELSAL = NULL WHERE OXDELSAL = "''";
UPDATE oxorder SET OXCARDID = NULL WHERE OXCARDID = "''";
UPDATE oxorder SET OXBILLNR = NULL WHERE OXBILLNR = "''";
UPDATE oxorder SET OXTRACKCODE = NULL WHERE OXTRACKCODE = "''";
UPDATE oxorder SET OXPAYID = NULL WHERE OXPAYID = "''";
UPDATE oxorder SET OXXID = NULL WHERE OXXID = "''";
UPDATE oxorder SET OXIP = NULL WHERE OXIP = "''";
UPDATE oxorder SET FCPOTXID = NULL WHERE FCPOTXID = "''";
UPDATE oxorder SET FCPOAUTHMODE = NULL WHERE FCPOAUTHMODE = "''";
UPDATE oxorder SET FCPOMODE = NULL WHERE FCPOMODE = "''";
UPDATE oxorder SET FCPOWORKORDERID = NULL WHERE FCPOWORKORDERID = "''";
UPDATE oxorder SET FCPOCLEARINGREFERENCE = NULL WHERE FCPOCLEARINGREFERENCE = "''";
UPDATE oxorder SET FCPOPROFILEIDENT = NULL WHERE FCPOPROFILEIDENT = "''";