Alter statements from Owl 2.1.x to Owl 2.2.0

--Table changes between 2.1 -> 2.2.0

ALTER TABLE public.agent
    ALTER COLUMN executor_memory TYPE CHARACTER VARYING(10) COLLATE pg_catalog."default";
 
ALTER TABLE public.agent
    ALTER COLUMN executor_memory SET DEFAULT '6g';

ALTER TABLE public.agent
    ADD COLUMN driver_memory character varying(10) COLLATE pg_catalog."default" DEFAULT '4g';

ALTER TABLE public.agent
    ADD COLUMN num_cores Integer DEFAULT NULL;




ALTER TABLE public.connections
    ADD COLUMN use_pwd_mgr integer DEFAULT 0;

ALTER TABLE public.connections
    ADD COLUMN is_kerb integer DEFAULT 0;

ALTER TABLE public.connections
    ADD COLUMN keytab character varying COLLATE pg_catalog."default";
    
ALTER TABLE public.connections
    ADD COLUMN principal character varying COLLATE pg_catalog."default";



ALTER TABLE public.dataset_schema
    ADD COLUMN is_pii integer DEFAULT 0;

ALTER TABLE public.dataset_schema
    ADD COLUMN is_mnpi integer DEFAULT 0;



ALTER TABLE public.dataset_scoring
    ALTER COLUMN rule_total_score SET DEFAULT 0;

ALTER TABLE public.dataset_scoring
    ALTER COLUMN validate_src_total_score SET DEFAULT 0;

ALTER TABLE public.dataset_scoring
    ALTER COLUMN dupe_total_score SET DEFAULT 0;

ALTER TABLE public.dataset_scoring
    ALTER COLUMN fpg_total_score SET DEFAULT 0;

ALTER TABLE public.dataset_scoring
    ALTER COLUMN outlier_total_score SET DEFAULT 0;

ALTER TABLE public.dataset_scoring
    ALTER COLUMN schema_total_score SET DEFAULT 0;

ALTER TABLE public.dataset_scoring
    ALTER COLUMN record_total_score SET DEFAULT 0;

ALTER TABLE public.dataset_scoring
    ALTER COLUMN datashape_total_score SET DEFAULT 0;


ALTER TABLE public.owl_check_history
    ADD COLUMN owl_check_json character varying COLLATE pg_catalog."default";


CREATE INDEX idx_ds_run_key_nm
    ON public.data_preview USING btree
    (dataset COLLATE pg_catalog."default", run_id, row_key COLLATE pg_catalog."default", field_nm COLLATE pg_catalog."default")
    INCLUDE(dataset, run_id, row_key, field_nm)
    TABLESPACE pg_default;

ALTER TABLE public.owl_catalog
    ADD COLUMN semantic integer DEFAULT 0;