Thomas Kaul 73c0843d51
Feature/add permissions to access model (#2833)
* Add permissions to Access model

* Update changelog
2024-01-24 19:23:58 +01:00

6 lines
220 B
SQL

-- CreateEnum
CREATE TYPE "AccessPermission" AS ENUM ('READ', 'READ_RESTRICTED');
-- AlterTable
ALTER TABLE "Access" ADD COLUMN "permissions" "AccessPermission"[] DEFAULT ARRAY['READ_RESTRICTED']::"AccessPermission"[];