11 lines
621 B
SQL
11 lines
621 B
SQL
-- Place your SQL code here
|
|
ALTER TABLE vn.entry ADD IF NOT EXISTS lockerUserFk int(10) unsigned NULL;
|
|
ALTER TABLE vn.entry ADD IF NOT EXISTS locked DATETIME DEFAULT NOW() NULL;
|
|
ALTER TABLE vn.entry ADD CONSTRAINT entryAccountFk FOREIGN KEY IF NOT EXISTS (lockerUserFk) REFERENCES account.`user`(id);
|
|
|
|
ALTER TABLE vn.entry CHANGE isBlocked isBlocked__ tinyint(4) DEFAULT 0 NOT NULL COMMENT 'Deprecado 04/07/2023';
|
|
|
|
ALTER TABLE vn.entryConfig ADD IF NOT EXISTS maxLockTime int(10) unsigned NULL COMMENT 'Tiempo máximo que puede estar una entrada bloqueada en segundos';
|
|
|
|
UPDATE vn.entryConfig
|
|
SET maxLockTime = 300; |