|
1101
by William Grant
Privileges (apart from admin) are now offering-local, not global. |
1 |
BEGIN; |
2 |
ALTER TABLE enrolment ADD COLUMN role TEXT NOT NULL CHECK (role IN |
|
3 |
('student', 'tutor', 'lecturer')) DEFAULT 'student'; |
|
4 |
ALTER TABLE login ADD COLUMN admin BOOLEAN NOT NULL DEFAULT false; |
|
5 |
UPDATE login SET admin = (rolenm = 'admin'); |
|
6 |
ALTER TABLE login DROP COLUMN rolenm; |
|
7 |
COMMIT; |