From e5d3578ffa6439562cfa1e5b107705c37a6367ae Mon Sep 17 00:00:00 2001 From: Guilhem Moulin Date: Fri, 18 Oct 2024 20:25:50 +0200 Subject: typofix --- schema.sql | 106 ++++++++++++++++++++++++++++++------------------------------- 1 file changed, 53 insertions(+), 53 deletions(-) (limited to 'schema.sql') diff --git a/schema.sql b/schema.sql index daa8ba2..c915ddd 100644 --- a/schema.sql +++ b/schema.sql @@ -1050,10 +1050,10 @@ ALTER SEQUENCE postgis."nvr:Nationalpark_ogc_fid_seq" OWNED BY postgis."nvr:Nati -- --- Name: nvr:Naturminne_polygon; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: nvr:Naturminne_punkt; Type: TABLE; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."nvr:Naturminne_polygon" ( +CREATE TABLE postgis."nvr:Naturminne_punkt" ( ogc_fid bigint NOT NULL, "NVRID" integer NOT NULL, "NAMN" character varying(62) NOT NULL, @@ -1065,31 +1065,28 @@ CREATE TABLE postgis."nvr:Naturminne_polygon" ( "SENGALLDAT" date, "IUCNKAT" character varying(254) NOT NULL, "FORVALTARE" character varying(62) NOT NULL, - "LAND_HA" double precision, - "VATTEN_HA" double precision, - "SKOG_HA" double precision, "GEOSTATUS" character varying(62) NOT NULL, "DIARIENR" character varying(62), "LAGRUM" character varying(64) NOT NULL, "BESLMYND" character varying(32) NOT NULL, - wkb_geometry postgis.geometry(MultiPolygon,3006) + wkb_geometry postgis.geometry(MultiPoint,3006) ); -ALTER TABLE postgis."nvr:Naturminne_polygon" OWNER TO webmap_import; +ALTER TABLE postgis."nvr:Naturminne_punkt" OWNER TO webmap_import; -- --- Name: TABLE "nvr:Naturminne_polygon"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: TABLE "nvr:Naturminne_punkt"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."nvr:Naturminne_polygon" IS 'Naturminne, yta'; +COMMENT ON TABLE postgis."nvr:Naturminne_punkt" IS 'Naturminne, punkt'; -- --- Name: nvr:Naturminne_polygon_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: nvr:Naturminne_punkt_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."nvr:Naturminne_polygon_ogc_fid_seq" +CREATE SEQUENCE postgis."nvr:Naturminne_punkt_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -1097,20 +1094,20 @@ CREATE SEQUENCE postgis."nvr:Naturminne_polygon_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvr:Naturminne_polygon_ogc_fid_seq" OWNER TO webmap_import; +ALTER TABLE postgis."nvr:Naturminne_punkt_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: nvr:Naturminne_polygon_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: nvr:Naturminne_punkt_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."nvr:Naturminne_polygon_ogc_fid_seq" OWNED BY postgis."nvr:Naturminne_polygon".ogc_fid; +ALTER SEQUENCE postgis."nvr:Naturminne_punkt_ogc_fid_seq" OWNED BY postgis."nvr:Naturminne_punkt".ogc_fid; -- --- Name: nvr:Naturminne_punkt; Type: TABLE; Schema: postgis; Owner: webmap_import +-- Name: nvr:Naturminne_yta; Type: TABLE; Schema: postgis; Owner: webmap_import -- -CREATE TABLE postgis."nvr:Naturminne_punkt" ( +CREATE TABLE postgis."nvr:Naturminne_yta" ( ogc_fid bigint NOT NULL, "NVRID" integer NOT NULL, "NAMN" character varying(62) NOT NULL, @@ -1122,28 +1119,31 @@ CREATE TABLE postgis."nvr:Naturminne_punkt" ( "SENGALLDAT" date, "IUCNKAT" character varying(254) NOT NULL, "FORVALTARE" character varying(62) NOT NULL, + "LAND_HA" double precision, + "VATTEN_HA" double precision, + "SKOG_HA" double precision, "GEOSTATUS" character varying(62) NOT NULL, "DIARIENR" character varying(62), "LAGRUM" character varying(64) NOT NULL, "BESLMYND" character varying(32) NOT NULL, - wkb_geometry postgis.geometry(MultiPoint,3006) + wkb_geometry postgis.geometry(MultiPolygon,3006) ); -ALTER TABLE postgis."nvr:Naturminne_punkt" OWNER TO webmap_import; +ALTER TABLE postgis."nvr:Naturminne_yta" OWNER TO webmap_import; -- --- Name: TABLE "nvr:Naturminne_punkt"; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- Name: TABLE "nvr:Naturminne_yta"; Type: COMMENT; Schema: postgis; Owner: webmap_import -- -COMMENT ON TABLE postgis."nvr:Naturminne_punkt" IS 'Naturminne, punkt'; +COMMENT ON TABLE postgis."nvr:Naturminne_yta" IS 'Naturminne, yta'; -- --- Name: nvr:Naturminne_punkt_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- Name: nvr:Naturminne_yta_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import -- -CREATE SEQUENCE postgis."nvr:Naturminne_punkt_ogc_fid_seq" +CREATE SEQUENCE postgis."nvr:Naturminne_yta_ogc_fid_seq" START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -1151,13 +1151,13 @@ CREATE SEQUENCE postgis."nvr:Naturminne_punkt_ogc_fid_seq" CACHE 1; -ALTER TABLE postgis."nvr:Naturminne_punkt_ogc_fid_seq" OWNER TO webmap_import; +ALTER TABLE postgis."nvr:Naturminne_yta_ogc_fid_seq" OWNER TO webmap_import; -- --- Name: nvr:Naturminne_punkt_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- Name: nvr:Naturminne_yta_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import -- -ALTER SEQUENCE postgis."nvr:Naturminne_punkt_ogc_fid_seq" OWNED BY postgis."nvr:Naturminne_punkt".ogc_fid; +ALTER SEQUENCE postgis."nvr:Naturminne_yta_ogc_fid_seq" OWNED BY postgis."nvr:Naturminne_yta".ogc_fid; -- @@ -2617,17 +2617,17 @@ ALTER TABLE ONLY postgis."nvr:Nationalpark" ALTER COLUMN ogc_fid SET DEFAULT nex -- --- Name: nvr:Naturminne_polygon ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- Name: nvr:Naturminne_punkt ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."nvr:Naturminne_polygon" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Naturminne_polygon_ogc_fid_seq"'::regclass); +ALTER TABLE ONLY postgis."nvr:Naturminne_punkt" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Naturminne_punkt_ogc_fid_seq"'::regclass); -- --- Name: nvr:Naturminne_punkt ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- Name: nvr:Naturminne_yta ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."nvr:Naturminne_punkt" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Naturminne_punkt_ogc_fid_seq"'::regclass); +ALTER TABLE ONLY postgis."nvr:Naturminne_yta" ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis."nvr:Naturminne_yta_ogc_fid_seq"'::regclass); -- @@ -3214,35 +3214,35 @@ ALTER TABLE ONLY postgis."nvr:Nationalpark" -- --- Name: nvr:Naturminne_polygon nvr:Naturminne_polygon_NVRID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: nvr:Naturminne_punkt nvr:Naturminne_punkt_NVRID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."nvr:Naturminne_polygon" - ADD CONSTRAINT "nvr:Naturminne_polygon_NVRID_key" UNIQUE ("NVRID"); +ALTER TABLE ONLY postgis."nvr:Naturminne_punkt" + ADD CONSTRAINT "nvr:Naturminne_punkt_NVRID_key" UNIQUE ("NVRID"); -- --- Name: nvr:Naturminne_polygon nvr:Naturminne_polygon_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: nvr:Naturminne_punkt nvr:Naturminne_punkt_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."nvr:Naturminne_polygon" - ADD CONSTRAINT "nvr:Naturminne_polygon_pkey" PRIMARY KEY (ogc_fid); +ALTER TABLE ONLY postgis."nvr:Naturminne_punkt" + ADD CONSTRAINT "nvr:Naturminne_punkt_pkey" PRIMARY KEY (ogc_fid); -- --- Name: nvr:Naturminne_punkt nvr:Naturminne_punkt_NVRID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: nvr:Naturminne_yta nvr:Naturminne_yta_NVRID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."nvr:Naturminne_punkt" - ADD CONSTRAINT "nvr:Naturminne_punkt_NVRID_key" UNIQUE ("NVRID"); +ALTER TABLE ONLY postgis."nvr:Naturminne_yta" + ADD CONSTRAINT "nvr:Naturminne_yta_NVRID_key" UNIQUE ("NVRID"); -- --- Name: nvr:Naturminne_punkt nvr:Naturminne_punkt_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- Name: nvr:Naturminne_yta nvr:Naturminne_yta_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -ALTER TABLE ONLY postgis."nvr:Naturminne_punkt" - ADD CONSTRAINT "nvr:Naturminne_punkt_pkey" PRIMARY KEY (ogc_fid); +ALTER TABLE ONLY postgis."nvr:Naturminne_yta" + ADD CONSTRAINT "nvr:Naturminne_yta_pkey" PRIMARY KEY (ogc_fid); -- @@ -3786,17 +3786,17 @@ CREATE INDEX "nvr:Nationalpark_wkb_geometry_geom_idx" ON postgis."nvr:Nationalpa -- --- Name: nvr:Naturminne_polygon_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: nvr:Naturminne_punkt_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- -CREATE INDEX "nvr:Naturminne_polygon_wkb_geometry_geom_idx" ON postgis."nvr:Naturminne_polygon" USING gist (wkb_geometry); +CREATE INDEX "nvr:Naturminne_punkt_wkb_geometry_geom_idx" ON postgis."nvr:Naturminne_punkt" USING gist (wkb_geometry); -- --- Name: nvr:Naturminne_punkt_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- Name: nvr:Naturminne_yta_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- -CREATE INDEX "nvr:Naturminne_punkt_wkb_geometry_geom_idx" ON postgis."nvr:Naturminne_punkt" USING gist (wkb_geometry); +CREATE INDEX "nvr:Naturminne_yta_wkb_geometry_geom_idx" ON postgis."nvr:Naturminne_yta" USING gist (wkb_geometry); -- @@ -4285,31 +4285,31 @@ GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Nationalpark_ogc_fid_seq" TO webmap_ -- --- Name: TABLE "nvr:Naturminne_polygon"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: TABLE "nvr:Naturminne_punkt"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT ON TABLE postgis."nvr:Naturminne_polygon" TO webmap_guest; +GRANT SELECT ON TABLE postgis."nvr:Naturminne_punkt" TO webmap_guest; -- --- Name: SEQUENCE "nvr:Naturminne_polygon_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "nvr:Naturminne_punkt_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Naturminne_polygon_ogc_fid_seq" TO webmap_guest; +GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Naturminne_punkt_ogc_fid_seq" TO webmap_guest; -- --- Name: TABLE "nvr:Naturminne_punkt"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: TABLE "nvr:Naturminne_yta"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT ON TABLE postgis."nvr:Naturminne_punkt" TO webmap_guest; +GRANT SELECT ON TABLE postgis."nvr:Naturminne_yta" TO webmap_guest; -- --- Name: SEQUENCE "nvr:Naturminne_punkt_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import +-- Name: SEQUENCE "nvr:Naturminne_yta_ogc_fid_seq"; Type: ACL; Schema: postgis; Owner: webmap_import -- -GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Naturminne_punkt_ogc_fid_seq" TO webmap_guest; +GRANT SELECT,USAGE ON SEQUENCE postgis."nvr:Naturminne_yta_ogc_fid_seq" TO webmap_guest; -- -- cgit v1.2.3