diff options
Diffstat (limited to 'schema.sql')
| -rw-r--r-- | schema.sql | 116 |
1 files changed, 116 insertions, 0 deletions
@@ -74,6 +74,78 @@ SET default_tablespace = ''; SET default_table_access_method = heap; -- +-- Name: dammar; Type: TABLE; Schema: postgis; Owner: webmap_import +-- + +CREATE TABLE postgis.dammar ( + ogc_fid bigint NOT NULL, + "DammID" uuid NOT NULL, + "LST_OBJID" character varying(32), + "Datum" date NOT NULL, + "DNamn" character varying(64), + "Status" smallint NOT NULL, + "Regleringstyp" smallint NOT NULL, + "Konstruktion" smallint NOT NULL, + "ByggAr" smallint, + "DammHojd" real, + "KronLangd" real, + "Fiskvag" smallint NOT NULL, + "FiskvagByggAr" smallint, + "Fiskavledare" smallint, + "Vandringshinder" boolean NOT NULL, + "HARO" integer NOT NULL, + "Vattendistrikt" character varying(10) NOT NULL, + inrapp_lst character varying(32) NOT NULL, + eu_cd character varying(32), + vf_typ character varying(1), + vy_eucd character varying(32), + vy_vf_typ character varying(1), + "DammanlID" character varying(64), + "Namn" character varying(64), + "Verksamhet" smallint, + "OmbyggAr" smallint, + "DG" real, + "SG" real, + "HojdSys" smallint, + "MY" double precision, + "RV" double precision, + "Kommentar" character varying(254), + "XX_Distance" double precision, + wkb_geometry postgis.geometry(Point,3006) +); + + +ALTER TABLE postgis.dammar OWNER TO webmap_import; + +-- +-- Name: TABLE dammar; Type: COMMENT; Schema: postgis; Owner: webmap_import +-- + +COMMENT ON TABLE postgis.dammar IS 'Dammar'; + + +-- +-- Name: dammar_ogc_fid_seq; Type: SEQUENCE; Schema: postgis; Owner: webmap_import +-- + +CREATE SEQUENCE postgis.dammar_ogc_fid_seq + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +ALTER TABLE postgis.dammar_ogc_fid_seq OWNER TO webmap_import; + +-- +-- Name: dammar_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: postgis; Owner: webmap_import +-- + +ALTER SEQUENCE postgis.dammar_ogc_fid_seq OWNED BY postgis.dammar.ogc_fid; + + +-- -- Name: gigafactories; Type: TABLE; Schema: postgis; Owner: webmap_import -- @@ -2684,6 +2756,13 @@ ALTER SEQUENCE postgis."vbk:vindkraftverk_ogc_fid_seq" OWNED BY postgis."vbk:vin -- +-- Name: dammar ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis.dammar ALTER COLUMN ogc_fid SET DEFAULT nextval('postgis.dammar_ogc_fid_seq'::regclass); + + +-- -- Name: gigafactories ogc_fid; Type: DEFAULT; Schema: postgis; Owner: webmap_import -- @@ -3048,6 +3127,22 @@ ALTER TABLE ONLY postgis."vbk:vindkraftverk" ALTER COLUMN ogc_fid SET DEFAULT ne -- +-- Name: dammar dammar_DammID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis.dammar + ADD CONSTRAINT "dammar_DammID_key" UNIQUE ("DammID"); + + +-- +-- Name: dammar dammar_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis.dammar + ADD CONSTRAINT dammar_pkey PRIMARY KEY (ogc_fid); + + +-- -- Name: gigafactories gigafactories_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- @@ -3928,6 +4023,13 @@ ALTER TABLE ONLY postgis."vbk:vindkraftverk" -- +-- Name: dammar_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import +-- + +CREATE INDEX dammar_wkb_geometry_geom_idx ON postgis.dammar USING gist (wkb_geometry); + + +-- -- Name: gigafactories_wkb_geometry_geom_idx; Type: INDEX; Schema: postgis; Owner: webmap_import -- @@ -4308,6 +4410,20 @@ GRANT USAGE ON SCHEMA postgis TO webmap_guest; -- +-- Name: TABLE dammar; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT ON TABLE postgis.dammar TO webmap_guest; + + +-- +-- Name: SEQUENCE dammar_ogc_fid_seq; Type: ACL; Schema: postgis; Owner: webmap_import +-- + +GRANT SELECT,USAGE ON SEQUENCE postgis.dammar_ogc_fid_seq TO webmap_guest; + + +-- -- Name: TABLE geography_columns; Type: ACL; Schema: postgis; Owner: postgres -- |