25 lines
812 B
SQL
25 lines
812 B
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');
|
|
|
|
|
|
|