-- Table: public.data_source_resources

-- DROP TABLE public.data_source_resources;

CREATE TABLE public.data_source_resources
(
    id bigint NOT NULL DEFAULT nextval('data_source_resources_id_seq'::regclass),
    discriminator character varying(31) COLLATE pg_catalog."default" NOT NULL,
    protocol character varying(50) COLLATE pg_catalog."default" NOT NULL,
    host character varying(255) COLLATE pg_catalog."default" NOT NULL,
    port integer NOT NULL,
    username character varying(255) COLLATE pg_catalog."default",
    password character varying(255) COLLATE pg_catalog."default",
    path character varying(1024) COLLATE pg_catalog."default" NOT NULL,
    parameters character varying(1024) COLLATE pg_catalog."default",
    created_date timestamp without time zone NOT NULL,
    missing_values_str text COLLATE pg_catalog."default",
    date_format character varying(255) COLLATE pg_catalog."default",
    CONSTRAINT data_source_resources_pkey PRIMARY KEY (id)
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public.data_source_resources
    OWNER to c_application_rweb;

-- Index: idx_data_source_resources_discriminator

-- DROP INDEX public.idx_data_source_resources_discriminator;

CREATE INDEX idx_data_source_resources_discriminator
    ON public.data_source_resources USING btree
    (discriminator COLLATE pg_catalog."default")
    TABLESPACE pg_default;

-- Index: idx_data_source_resources_protocol

-- DROP INDEX public.idx_data_source_resources_protocol;

CREATE INDEX idx_data_source_resources_protocol
    ON public.data_source_resources USING btree
    (protocol COLLATE pg_catalog."default")
    TABLESPACE pg_default;

-- Table: public.data_base_settings

-- DROP TABLE public.data_base_settings;

CREATE TABLE public.data_base_settings
(
    id bigint NOT NULL,
    db_name character varying(255) COLLATE pg_catalog."default",
    db_type character varying(50) COLLATE pg_catalog."default" NOT NULL,
    maintenance_db character varying(255) COLLATE pg_catalog."default",
    query text COLLATE pg_catalog."default",
    schema character varying(255) COLLATE pg_catalog."default",
    table_name character varying(255) COLLATE pg_catalog."default",
    CONSTRAINT data_base_settings_pkey PRIMARY KEY (id),
    CONSTRAINT fk_data_base_settings_data_source_resource FOREIGN KEY (id)
        REFERENCES public.data_source_resources (id) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE CASCADE
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public.data_base_settings
    OWNER to c_application_rweb;

-- Index: idx_data_base_settings_db_type

-- DROP INDEX public.idx_data_base_settings_db_type;

CREATE INDEX idx_data_base_settings_db_type
    ON public.data_base_settings USING btree
    (db_type COLLATE pg_catalog."default")
    TABLESPACE pg_default;

-- Table: public.csv_settings

-- DROP TABLE public.csv_settings;

CREATE TABLE public.csv_settings
(
    id bigint NOT NULL,
    code_page character varying(255) COLLATE pg_catalog."default",
    column_delimiter character(1) COLLATE pg_catalog."default",
    first_row_is_header boolean,
    locale character varying(255) COLLATE pg_catalog."default",
    num_of_rows_in_csv bigint,
    num_rows_to_process bigint,
    CONSTRAINT csv_settings_pkey PRIMARY KEY (id),
    CONSTRAINT fk_csv_settings_data_source_resource FOREIGN KEY (id)
        REFERENCES public.data_source_resources (id) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE CASCADE
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public.csv_settings
    OWNER to c_application_rweb;