zoneminder/db/zm_update-1.37.48.sql

5 lines
231 B
SQL

UPDATE Monitors SET ControlAddress='' WHERE ControlAddress='user:port@ip';
ALTER TABLE Users MODIFY `Monitors` enum('None','View','Edit','Create') NOT NULL default 'None';
UPDATE Users SET Monitors='Create' WHERE Monitors='Edit';