mirror of https://github.com/coder/coder.git
13 lines
452 B
SQL
13 lines
452 B
SQL
-- Add enum app_sharing_level
|
|
CREATE TYPE app_sharing_level AS ENUM (
|
|
-- only the workspace owner can access the app
|
|
'owner',
|
|
-- any authenticated user on the site can access the app
|
|
'authenticated',
|
|
-- any user can access the app even if they are not authenticated
|
|
'public'
|
|
);
|
|
|
|
-- Add sharing_level column to workspace_apps table
|
|
ALTER TABLE workspace_apps ADD COLUMN sharing_level app_sharing_level NOT NULL DEFAULT 'owner'::app_sharing_level;
|