Semaphore/db/sql/migrations/v2.8.91.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`;
fix(migrations): manager is default role 2023-07-22 22:47:12 +02:00			ALTER TABLE project__user ADD `role` varchar(50) NOT NULL DEFAULT 'manager';
feat(be): add migration project__user.admin -> project_user.role 2023-07-07 23:15:30 +02:00
fix(be): update sql query 2023-07-07 23:37:41 +02:00			UPDATE project__user SET `role` = 'owner' WHERE `admin`;
feat(be): add migration project__user.admin -> project_user.role 2023-07-07 23:15:30 +02:00
			ALTER TABLE project__user DROP COLUMN `admin`;