diff options
| author | Guilhem Moulin <guilhem@fripost.org> | 2025-04-22 17:43:53 +0200 |
|---|---|---|
| committer | Guilhem Moulin <guilhem@fripost.org> | 2025-04-23 12:09:58 +0200 |
| commit | 990978c7403ca58956c131dc7992ff113ea04ea6 (patch) | |
| tree | cbdd2319bcfa594a86b0cde4298334361a9defb4 /schema.sql | |
| parent | e5e8a6548ef156b785aae1b8a37fe71f26146061 (diff) | |
Skogsstyrelsen: Relax some constraints on the schema to reflect current GPKG files.
Diffstat (limited to 'schema.sql')
| -rw-r--r-- | schema.sql | 23 |
1 files changed, 5 insertions, 18 deletions
@@ -2301,13 +2301,10 @@ CREATE TABLE postgis."sks:AvverkAnm" ( "OBJECTID" integer NOT NULL, "Beteckn" character varying(12) NOT NULL, "ArendeAr" smallint NOT NULL, - "Avverktyp" character varying(254) NOT NULL, - "Andamal" character varying(62) NOT NULL, - "Skogstyp" character varying(254) NOT NULL, "Inkomdatum" date NOT NULL, "AnmaldHa" real NOT NULL, - "SkogsodlHa" real NOT NULL, - "NatforHa" real NOT NULL, + "SkogsodlHa" real, + "NatforHa" real, "ArendeStatus" character varying(254) NOT NULL, "AvvSasong" character varying(254) NOT NULL, "AvvHa" real, @@ -2358,11 +2355,9 @@ CREATE TABLE postgis."sks:UtfordAvverk" ( "Avverktyp" character varying(254) NOT NULL, "Skogstyp" character varying(254) NOT NULL, "AnmaldHa" real NOT NULL, - "SkogsodlHa" real NOT NULL, - "NatforHa" real NOT NULL, - "Avvdatum" date NOT NULL, - "KallaDatum" date, - "KallaAreal" character varying(62), + "NatforHa" real, + "Avvdatum" date, + "KallaDatum" character varying(62), "Forebild" character varying(62), "Efterbild" character varying(62), "ArealHa" real NOT NULL, @@ -3937,14 +3932,6 @@ ALTER TABLE ONLY postgis."sametinget:flyttled" -- --- Name: sks:AvverkAnm sks:AvverkAnm_Beteckn_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import --- - -ALTER TABLE ONLY postgis."sks:AvverkAnm" - ADD CONSTRAINT "sks:AvverkAnm_Beteckn_key" UNIQUE ("Beteckn"); - - --- -- Name: sks:AvverkAnm sks:AvverkAnm_OBJECTID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- |