salix/db/versions/10889-redMedeola/00-firstScript.sql

-- Place your SQL code here
CREATE TABLE IF NOT EXISTS `vn`.`mrwConfig` (
	`id` INT auto_increment NULL,
	`url` varchar(100) NULL,
	`user` varchar(100) NULL,
	`password` varchar(100) NULL,
	`franchiseCode` varchar(100) NULL,
	`subscriberCode` varchar(100) NULL,
	CONSTRAINT mrwConfig_pk PRIMARY KEY (id)
)
ENGINE=InnoDB 
DEFAULT CHARSET=utf8mb3
COLLATE=utf8mb3_unicode_ci;

ALTER TABLE `vn`.`packingSite` ADD `hasNewLabelMrwMethod` BOOL NULL;

INSERT INTO `salix`.`ACL` (`model`, `property`, `accessType`, `permission`, `principalType`, `principalId`) 
	VALUES('MrwConfig', 'cancelShipment', 'WRITE', 'ALLOW', 'ROLE', 'employee');

INSERT INTO `salix`.`ACL` (`model`,`property`,`accessType`,`permission`,`principalType`,`principalId`)
	VALUES ('MrwConfig','createShipment','WRITE','ALLOW','ROLE','employee');