Fix http.response schema #25

The schema currently laid out when the db is created looks something like

-- Table: http.responses

-- DROP TABLE IF EXISTS http.responses;

CREATE TABLE IF NOT EXISTS http.responses
(
    id integer NOT NULL DEFAULT nextval('http.responses_id_seq'::regclass),
    nct character varying(15) COLLATE pg_catalog."default",
    version smallint,
    url character varying(255) COLLATE pg_catalog."default",
    response_code smallint,
    response_date date,
    CONSTRAINT responses_pkey PRIMARY KEY (id)
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS http.responses
    OWNER to root;

GRANT SELECT ON TABLE http.responses TO history_reader;

GRANT INSERT, SELECT ON TABLE http.responses TO history_writer;

GRANT ALL ON TABLE http.responses TO root;

instead it should look like 020_HttpSchema.sql on commit 4a2b1ea2

Need to figure out why this isn't happening.

The schema currently laid out when the db is created looks something like ```sql -- Table: http.responses -- DROP TABLE IF EXISTS http.responses; CREATE TABLE IF NOT EXISTS http.responses ( id integer NOT NULL DEFAULT nextval('http.responses_id_seq'::regclass), nct character varying(15) COLLATE pg_catalog."default", version smallint, url character varying(255) COLLATE pg_catalog."default", response_code smallint, response_date date, CONSTRAINT responses_pkey PRIMARY KEY (id) ) TABLESPACE pg_default; ALTER TABLE IF EXISTS http.responses OWNER to root; GRANT SELECT ON TABLE http.responses TO history_reader; GRANT INSERT, SELECT ON TABLE http.responses TO history_writer; GRANT ALL ON TABLE http.responses TO root; ``` instead it should look like [020_HttpSchema.sql on commit 4a2b1ea2](https://gitea.kgjk.icu/Research/ClinicalTrialsDataProcessing/src/commit/4a2b1ea2ed56735ddbc2fc488a9a0fe0fa2b419f/AACT_downloader/ClinicalTrialHistory/docker-entrypoint-initdb.d/020_HttpSchema.sql) Need to figure out why this isn't happening.

Done in 5d2140accd where I changed the docker-compose to simplify the dependency chain.

Done in 5d2140accd6ec6847205f0dd7f8cc215a1682b39 where I changed the docker-compose to simplify the dependency chain.

Labels Milestones

Fix `http.response` schema #25

Labels Milestones

Fix http.response schema #25

Fix `http.response` schema #25