diff options
Diffstat (limited to 'schema.sql')
| -rw-r--r-- | schema.sql | 45 |
1 files changed, 33 insertions, 12 deletions
@@ -2,8 +2,10 @@ -- PostgreSQL database dump -- --- Dumped from database version 17.5 (Debian 17.5-1) --- Dumped by pg_dump version 17.5 (Debian 17.5-1) +\restrict Bgzdbx4Rtx4vQfqXsTo49OzxtEB1IfCKRtQILnb5nJbZHUD1Sfo8KdPcqvthM16 + +-- Dumped from database version 17.8 (Debian 17.8-0+deb13u1) +-- Dumped by pg_dump version 17.8 (Debian 17.8-0+deb13u1) SET statement_timeout = 0; SET lock_timeout = 0; @@ -27,7 +29,9 @@ CREATE DATABASE webmap WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE_PROVID ALTER DATABASE webmap OWNER TO postgres; +\unrestrict Bgzdbx4Rtx4vQfqXsTo49OzxtEB1IfCKRtQILnb5nJbZHUD1Sfo8KdPcqvthM16 \connect webmap +\restrict Bgzdbx4Rtx4vQfqXsTo49OzxtEB1IfCKRtQILnb5nJbZHUD1Sfo8KdPcqvthM16 SET statement_timeout = 0; SET lock_timeout = 0; @@ -49,6 +53,29 @@ COMMENT ON DATABASE webmap IS 'Backend PostGIS database for KlimatanalysNorr too -- +-- Name: webmap; Type: DATABASE PROPERTIES; Schema: -; Owner: postgres +-- + +ALTER DATABASE webmap SET search_path TO 'public'; + + +\unrestrict Bgzdbx4Rtx4vQfqXsTo49OzxtEB1IfCKRtQILnb5nJbZHUD1Sfo8KdPcqvthM16 +\connect webmap +\restrict Bgzdbx4Rtx4vQfqXsTo49OzxtEB1IfCKRtQILnb5nJbZHUD1Sfo8KdPcqvthM16 + +SET statement_timeout = 0; +SET lock_timeout = 0; +SET idle_in_transaction_session_timeout = 0; +SET transaction_timeout = 0; +SET client_encoding = 'UTF8'; +SET standard_conforming_strings = on; +SELECT pg_catalog.set_config('search_path', '', false); +SET check_function_bodies = false; +SET xmloption = content; +SET client_min_messages = warning; +SET row_security = off; + +-- -- Name: postgis; Type: SCHEMA; Schema: -; Owner: postgres -- @@ -3933,12 +3960,12 @@ CREATE TABLE postgis."nvr:Naturreservat" ( "NAMN" character varying(128) NOT NULL, "SKYDDSTYP" character varying(32) NOT NULL, "BESLSTATUS" character varying(12) NOT NULL, - "URSBESLDAT" date NOT NULL, + "URSBESLDAT" date, "IKRAFTDATF" date, "URSGALLDAT" date, "SENGALLDAT" date, "IUCNKAT" character varying(254) NOT NULL, - "FORVALTARE" character varying(62) NOT NULL, + "FORVALTARE" character varying(62), "LAND_HA" double precision, "VATTEN_HA" double precision, "SKOG_HA" double precision, @@ -7569,14 +7596,6 @@ ALTER TABLE ONLY postgis."mrr:ut_metaller_industrimineral_ansokta" -- --- Name: mrr:ut_metaller_industrimineral_ansokta mrr:ut_metaller_industrimineral_ansokta_name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import --- - -ALTER TABLE ONLY postgis."mrr:ut_metaller_industrimineral_ansokta" - ADD CONSTRAINT "mrr:ut_metaller_industrimineral_ansokta_name_key" UNIQUE (name); - - --- -- Name: mrr:ut_metaller_industrimineral_ansokta mrr:ut_metaller_industrimineral_ansokta_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- @@ -9882,3 +9901,5 @@ GRANT SELECT,USAGE ON SEQUENCE public.layercache_ogc_fid_seq TO webmap_guest; -- PostgreSQL database dump complete -- +\unrestrict Bgzdbx4Rtx4vQfqXsTo49OzxtEB1IfCKRtQILnb5nJbZHUD1Sfo8KdPcqvthM16 + |