Mirror of https://github.com/roostorg/coop
github.com/roostorg/coop
1-- Add Google Content Safety API signal type and config table
2ALTER TYPE public.enum_signals_type ADD VALUE IF NOT EXISTS 'GOOGLE_CONTENT_SAFETY_API';
3
4CREATE TABLE signal_auth_service.google_content_safety_configs (
5 org_id character varying(255) NOT NULL,
6 created_at timestamp with time zone DEFAULT now() NOT NULL,
7 updated_at timestamp with time zone DEFAULT now() NOT NULL,
8 api_key character varying(255) NOT NULL
9);
10
11ALTER TABLE signal_auth_service.google_content_safety_configs OWNER TO CURRENT_USER;
12
13ALTER TABLE ONLY signal_auth_service.google_content_safety_configs
14 ADD CONSTRAINT google_content_safety_configs_pkey PRIMARY KEY (org_id);