From e10a849cd01c5b15e3123da1f6df845006322843 Mon Sep 17 00:00:00 2001
From: Even Rouault <even.rouault@spatialys.com>
Date: Thu, 11 Mar 2021 16:12:30 +0100
Subject: Database: fix NKG transformations

---
 data/sql/nkg.sql                     | 13 -------------
 data/sql/nkg_post_customizations.sql | 13 +++++++++++++
 2 files changed, 13 insertions(+), 13 deletions(-)
 create mode 100644 data/sql/nkg_post_customizations.sql

(limited to 'data/sql')

diff --git a/data/sql/nkg.sql b/data/sql/nkg.sql
index 56b46206..69a00603 100644
--- a/data/sql/nkg.sql
+++ b/data/sql/nkg.sql
@@ -2,19 +2,6 @@ INSERT INTO "metadata" VALUES('NKG.SOURCE', 'https://github.com/NordicGeodesy/No
 INSERT INTO "metadata" VALUES('NKG.VERSION', '1.0.0');
 INSERT INTO "metadata" VALUES('NKG.DATE', '2020-12-21');
 
--- Append NKG to authority references
-UPDATE
-   authority_to_authority_preference
-SET
-   allowed_authorities = allowed_authorities || ',NKG'
-WHERE
-   source_auth_name = 'EPSG' AND target_auth_name = 'EPSG';
-
-INSERT INTO "authority_to_authority_preference"
-    (source_auth_name,target_auth_name, allowed_authorities)
-VALUES
-    ('NKG', 'EPSG', 'NKG,PROJ,EPSG');
-
 -- extent for NKG2008 transformations
 INSERT INTO "extent" VALUES(
     'NKG','EXTENT_2008',            -- extend auth+code
diff --git a/data/sql/nkg_post_customizations.sql b/data/sql/nkg_post_customizations.sql
new file mode 100644
index 00000000..68bf0dbf
--- /dev/null
+++ b/data/sql/nkg_post_customizations.sql
@@ -0,0 +1,13 @@
+
+-- Append NKG to authority references
+UPDATE
+   authority_to_authority_preference
+SET
+   allowed_authorities = allowed_authorities || ',NKG'
+WHERE
+   source_auth_name = 'EPSG' AND target_auth_name = 'EPSG';
+
+INSERT INTO "authority_to_authority_preference"
+    (source_auth_name,target_auth_name, allowed_authorities)
+VALUES
+    ('NKG', 'EPSG', 'NKG,PROJ,EPSG');
-- 
cgit v1.2.3