diff options
Diffstat (limited to 'schema.sql')
-rw-r--r-- | schema.sql | 78 |
1 files changed, 78 insertions, 0 deletions
@@ -74,6 +74,48 @@ SET default_tablespace = ''; SET default_table_access_method = heap; -- +-- Name: gigafactories; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis.gigafactories ( + ogc_fid bigint NOT NULL, + "Name" character varying(254), + "Url" character varying(254), + wkb_geometry postgis.geometry(MultiPolygon,3006) +); + + +ALTER TABLE postgis.gigafactories OWNER TO webmap_import; + +-- +-- Name: TABLE gigafactories; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis.gigafactories IS 'Stora industrisatsningar'; + + +-- +-- Name: gigafactories_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis.gigafactories_ogc_fid_seq + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis.gigafactories_ogc_fid_seq OWNER TO webmap_import; + +-- +-- Name: gigafactories_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis.gigafactories_ogc_fid_seq OWNED BY postgis.gigafactories.ogc_fid; + + +-- -- Name: kommunyta; Type: TABLE; Schema: postgis; Owner: webmap_import -- @@ -2642,6 +2684,13 @@ ALTER SEQUENCE postgis."vbk:vindkraftverk_ogc_fid_seq" OWNED BY postgis."vbk:vin -- +-- Name: gigafactories ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis.gigafactories ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis.gigafactories_ogc_fid_seq'::regclass); + + +-- -- Name: kommunyta ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- @@ -2999,6 +3048,14 @@ ALTER TABLE ONLY postgis."vbk:vindkraftverk" ALTER COLUMN ogc_fid SET DEFAULT ne -- +-- Name: gigafactories gigafactories_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis.gigafactories + ADD CONSTRAINT gigafactories_pkey PRIMARY KEY (ogc_fid); + + +-- -- Name: kommunyta kommunyta_kommunkod_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- @@ -3871,6 +3928,13 @@ ALTER TABLE ONLY postgis."vbk:vindkraftverk" -- +-- Name: gigafactories_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX gigafactories_wkb_geometry_geom_idx ON postgis.gigafactories USING gist (wkb_geometry); + + +-- -- Name: kommunyta_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- @@ -4258,6 +4322,20 @@ GRANT SELECT ON TABLE postgis.geometry_columns TO webmap_guest; -- +-- Name: TABLE gigafactories; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis.gigafactories TO webmap_guest; + + +-- +-- Name: SEQUENCE gigafactories_ogc_fid_seq; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis.gigafactories_ogc_fid_seq TO webmap_guest; + + +-- -- Name: TABLE kommunyta; Type: ACL; Schema: postgis; Owner: webmap_import -- |