salix/db/versions/11116-tealRuscus/00-firstScript.sql

8 lines
439 B
MySQL
Raw Permalink Normal View History

2024-06-25 11:30:46 +00:00
-- Place your SQL code here
USE vn;
2024-06-25 11:35:21 +00:00
INSERT INTO salix.ACL ( model, property, accessType, permission, principalType, principalId) VALUES('ItemShelvingLog', '*', 'READ', 'ALLOW', 'ROLE', 'production');
-- redmine regularitzar parking per a que no tinguen espais
ALTER TABLE parking DROP CONSTRAINT chkParkingCodeFormat;
ALTER TABLE parking
ADD CONSTRAINT chkParkingCodeFormat CHECK (CHAR_LENGTH(code) > 4 AND code REGEXP ('^[^ ]+-[^ ]+$'));