36 lines
1.1 KiB
SQL
36 lines
1.1 KiB
SQL
|
-- +goose Up
|
||
|
|
-- +goose StatementBegin
|
||
|
|
CREATE TABLE public.access_groups (
|
||
|
|
id bigint GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
|
||
|
|
name text NOT NULL UNIQUE,
|
||
|
|
description text NOT NULL DEFAULT '',
|
||
|
|
library_ids integer[],
|
||
|
|
max_playback_quality text NOT NULL DEFAULT '',
|
||
|
|
download_allowed boolean NOT NULL DEFAULT true,
|
||
|
|
download_transcode_allowed boolean NOT NULL DEFAULT true,
|
||
|
|
max_streams integer NOT NULL DEFAULT 0,
|
||
|
|
max_transcodes integer NOT NULL DEFAULT 0,
|
||
|
|
allowed_permissions text[],
|
||
|
|
requests_allowed boolean NOT NULL DEFAULT true,
|
||
|
|
created_at timestamp with time zone NOT NULL DEFAULT now(),
|
||
|
|
updated_at timestamp with time zone NOT NULL DEFAULT now()
|
||
|
|
);
|
||
|
|
|
||
|
|
ALTER TABLE public.users
|
||
|
|
ADD COLUMN access_group_id bigint
|
||
|
|
REFERENCES public.access_groups(id) ON DELETE SET NULL;
|
||
|
|
|
||
|
|
CREATE INDEX idx_users_access_group_id
|
||
|
|
ON public.users(access_group_id);
|
||
|
|
-- +goose StatementEnd
|
||
|
|
|
||
|
|
-- +goose Down
|
||
|
|
-- +goose StatementBegin
|
||
|
|
DROP INDEX IF EXISTS public.idx_users_access_group_id;
|
||
|
|
|
||
|
|
ALTER TABLE public.users
|
||
|
|
DROP COLUMN IF EXISTS access_group_id;
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS public.access_groups;
|
||
|
|
-- +goose StatementEnd
|