aboutsummaryrefslogtreecommitdiffstats
path: root/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'schema.sql')
-rw-r--r--schema.sql78
1 files changed, 78 insertions, 0 deletions
diff --git a/schema.sql b/schema.sql
index 78429a1..7208a34 100644
--- a/schema.sql
+++ b/schema.sql
@@ -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
--