mirror of
https://github.com/semaphoreui/semaphore.git
synced 2024-11-23 20:35:24 +01:00
5 lines
182 B
SQL
5 lines
182 B
SQL
ALTER TABLE project__user ADD `role` varchar(50) NOT NULL DEFAULT 'manager';
|
|
|
|
UPDATE project__user SET `role` = 'owner' WHERE `admin`;
|
|
|
|
ALTER TABLE project__user DROP COLUMN `admin`; |