1 ALTER TABLE DOC_GROUPS ADD COLUMN locked INT;
2 ALTER TABLE DOC_GROUPS ALTER COLUMN locked SET DEFAULT 0;
3 UPDATE DOC_GROUPS SET locked = 0;
4 ALTER TABLE DOC_GROUPS ADD COLUMN locked_by INT;
5 ALTER TABLE DOC_GROUPS ADD COLUMN lockdate INT;
6 ALTER TABLE DOC_GROUPS ALTER COLUMN lockdate SET DEFAULT 0;
7 ALTER TABLE DOC_GROUPS ADD FOREIGN KEY (locked_by) REFERENCES users ON DELETE CASCADE ON UPDATE CASCADE;