ALTER TABLE tblconfig ADD COLUMN shopOrders INT(1) DEFAULT 1 NULL AFTER `internationalOrders`;
ALTER TABLE tblstyle ADD COLUMN IF NOT EXISTS enforceLesser INT(1) DEFAULT 0 NULL AFTER navbarPosition;
ALTER TABLE `tblmessages` ADD COLUMN IF NOT EXISTS `direction` VARCHAR(1) NULL AFTER `id`;
ALTER TABLE `tblpaymentgateway` ADD COLUMN IF NOT EXISTS `authiStoreName` VARCHAR(255) NULL AFTER `threeDEnabled`, ADD COLUMN IF NOT EXISTS `authiSharedSecret` VARCHAR(255) NULL AFTER `authiStoreName`;
ALTER TABLE `tblconfig` ADD COLUMN `systemType` VARCHAR(1) DEFAULT '0' NULL AFTER `shopOrders`;
ALTER TABLE `tblpaymentgateway` ADD COLUMN IF NOT EXISTS `payaSubMerchantId` VARCHAR(255) NULL AFTER `authiSharedSecret`, ADD COLUMN IF NOT EXISTS `payaProductType` VARCHAR(200) NULL AFTER `payaSubMerchantId`;
ALTER TABLE `tblorder` ADD COLUMN IF NOT EXISTS `deviceCapabilities` VARCHAR(10) NULL AFTER `orderGiftFuneral`, ADD COLUMN IF NOT EXISTS `deviceScreenRes` TEXT NULL AFTER `deviceCapabilities`;
ALTER TABLE `tblorder` ADD COLUMN IF NOT EXISTS `deviceTimeZone` VARCHAR(20) NULL AFTER `deviceScreenRes`;
ALTER TABLE `tblpaymentgateway` ADD COLUMN IF NOT EXISTS `merchantCategoryCode` VARCHAR(10) DEFAULT '5193' NULL AFTER `payaProductType`;
ALTER TABLE `tblconfig` ADD COLUMN IF NOT EXISTS `showDelDate` VARCHAR(1) DEFAULT '1' NULL AFTER `systemType`;
CREATE TABLE IF NOT EXISTS `tblsinglepayment` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`paymentId` int(11) DEFAULT NULL,
`customerName` varchar(255) DEFAULT NULL,
`customerEmail` varchar(255) DEFAULT NULL,
`addressId` int(11) DEFAULT NULL,
`paymentTitle` varchar(255) DEFAULT NULL,
`paymentDescription` text DEFAULT NULL,
`paymentTotal` bigint(20) DEFAULT NULL,
`paymentVat` bigint(20) DEFAULT NULL,
`paymentPreVat` bigint(20) DEFAULT NULL,
`paymentType` varchar(25) DEFAULT NULL,
`dateCreated` date DEFAULT NULL,
`dateDue` date DEFAULT NULL,
`paymentDate` date DEFAULT NULL,
`paymentStatus` varchar(15) DEFAULT NULL,
`emailContent` text DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
ALTER TABLE `tblevent` ADD COLUMN IF NOT EXISTS `paymentId` INT(11) NULL AFTER `userAgent`;
CREATE TABLE `tblportalpages` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `title` VARCHAR(255), `textspace1` TEXT, `status` VARCHAR(10), `creationDate` DATETIME, `editedDate` TIMESTAMP, `editor` VARCHAR(20), PRIMARY KEY (`id`) ) CHARSET=utf8mb4;
ALTER TABLE `tblportalpages` ADD COLUMN IF NOT EXISTS `parent_id` INT(10) NULL AFTER `editor`, ADD COLUMN `toplevel_id` INT(10) NULL AFTER `parent_id`, ADD COLUMN `pageposition_id` INT(10) NULL AFTER `toplevel_id`, ADD COLUMN IF NOT EXISTS `pageOrder` INT(4) NULL AFTER `pageposition_id`;
ALTER TABLE `tblmessages` ADD COLUMN IF NOT EXISTS `senderIp` VARCHAR(30) NULL AFTER `replyMessage`;
ALTER TABLE `tblmessages` ADD COLUMN IF NOT EXISTS `timestamp` TIMESTAMP DEFAULT NOW() NULL AFTER `senderIp`;
ALTER TABLE `tblconfig` ADD COLUMN IF NOT EXISTS `customAdminData` TEXT NULL AFTER `showDelDate`;
//6.5.9a
ALTER TABLE `tblsinglepayment` CHANGE `paymentTotal` `paymentTotal` DECIMAL(10,2) NULL, CHANGE `paymentVat` `paymentVat` DECIMAL(10,2) NULL, CHANGE `paymentPreVat` `paymentPreVat` DECIMAL(10,2) NULL;
ALTER TABLE `tblpaymentgateway` ADD COLUMN IF NOT EXISTS `paymentSenseToken` TEXT NULL AFTER `merchantCategoryCode`;