INSERT INTO systemsettings (type, value, description, active, created, createdById, updated, updatedById)
VALUES ('roles_show_margin', '', 'Role IDs that enable showing margin on order/invoice page', '1', UTC_TIMESTAMP, '10', UTC_TIMESTAMP, '10');

ALTER TABLE `payment` ADD COLUMN `syncedWithXero`  TINYINT(1) NOT NULL DEFAULT '0' AFTER `cardNumber`;
ALTER TABLE `payment` ADD INDEX(`syncedWithXero`);

ALTER TABLE `creditnote` ADD COLUMN `xeroId`  varchar(50) NOT NULL DEFAULT '' AFTER `syncedWithXero`;
ALTER TABLE `creditnote` ADD INDEX(`xeroId`);
