-- Table: ra2ce.layernames

-- DROP TABLE ra2ce.layernames;

CREATE TABLE ra2ce.layernames
(
    uid integer NOT NULL DEFAULT nextval('ra2ce.layernames_uid_seq'::regclass),
    name character varying(500) COLLATE pg_catalog."default"
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE ra2ce.layernames
    OWNER to oet_data;
COMMENT ON TABLE ra2ce.layernames
    IS 'Table with the names of the hazard layers that are chosen by the user, with uid that is later used to calculate the right category.';
	
COPY layernames(name) 
FROM 'C:\working-copies\ra2ce\data\layer_names.csv' DELIMITER ',';