Mirror of https://github.com/roostorg/coop
github.com/roostorg/coop
1-- Add Zentropi signal type and config table
2ALTER TYPE public.enum_signals_type ADD VALUE IF NOT EXISTS 'ZENTROPI_LABELER';
3
4CREATE TABLE IF NOT EXISTS signal_auth_service.zentropi_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 labeler_versions JSONB DEFAULT '[]'
10);
11
12ALTER TABLE signal_auth_service.zentropi_configs OWNER TO CURRENT_USER;
13
14ALTER TABLE ONLY signal_auth_service.zentropi_configs
15 ADD CONSTRAINT zentropi_configs_pkey PRIMARY KEY (org_id);