[Mapbender-commits] r1020 - trunk/mapbender/resources/db/update

[svn_mapbender at osgeo.org]

Author: astrid_emde
Date: 2007-01-23 09:59:46 -0500 (Tue, 23 Jan 2007)
New Revision: 1020

Modified:
   trunk/mapbender/resources/db/update/update_postgresql_db.sql
Log:
new table layer_preview deleted postponed for the next version

table layer_epsg_tmp deleted postponed for the next version

Modified: trunk/mapbender/resources/db/update/update_postgresql_db.sql
===================================================================
--- trunk/mapbender/resources/db/update/update_postgresql_db.sql	2007-01-23 14:23:18 UTC (rev 1019)
+++ trunk/mapbender/resources/db/update/update_postgresql_db.sql	2007-01-23 14:59:46 UTC (rev 1020)
@@ -102,46 +102,3 @@
       ON UPDATE CASCADE ON DELETE CASCADE
 );
 
---
--- table layer_preview
---
-CREATE TABLE layer_preview (
-    fkey_layer_id integer NOT NULL,
-    layer_map_preview bytea,
-    layer_extent_preview bytea,
-    layer_legend_preview bytea
-);
-
-ALTER TABLE ONLY layer_preview
-    ADD CONSTRAINT layer_preview_fkey_layer_id_key UNIQUE (fkey_layer_id);
-
-ALTER TABLE ONLY layer_preview
-    ADD CONSTRAINT fkey_layer_id FOREIGN KEY (fkey_layer_id) REFERENCES layer(layer_id) ON UPDATE CASCADE ON DELETE CASCADE;
-
-
---
--- table layer_epsg - unique key for (fkey_layer_id, epsg)
---
-
--- 1. create temporary table with distinct entries
-CREATE TABLE layer_epsg_tmp AS SELECT DISTINCT * FROM layer_epsg
-
--- 2. check for ambiguous entries
-SELECT a.fkey_layer_id, a.epsg, a.minx, a.miny, a.maxx, a.maxy FROM layer_epsg_tmp AS a, (SELECT fkey_layer_id, epsg FROM layer_epsg_tmp GROUP BY fkey_layer_id, epsg HAVING count(*) > 1) AS b WHERE a.fkey_layer_id = b.fkey_layer_id AND a.epsg = b.epsg
-
--- 3. if there is a result: delete ambiguous entries manually, like
-DELETE FROM layer_epsg_tmp WHERE fkey_layer_id = <id> AND epsg = '<epsg>' AND minx = <minx> AND miny = <miny> AND maxx = <maxx> AND maxy = <maxy> 
-
--- 4. delete old data from layer_epsg
-DELETE FROM layer_epsg_tmp WHERE fkey_layer_id = <id> AND epsg = '<epsg>' AND minx = <minx> AND miny = <miny> AND maxx = <maxx> AND maxy = <maxy> 
-
--- 5. move new data to layer_epsg
-INSERT INTO layer_epsg SELECT * FROM layer_epsg_tmp
-
--- 6. add unique key
-INSERT INTO layer_epsg SELECT * FROM layer_epsg_tmp
-
--- 7. remove temporary table
-DROP TABLE layer_epsg_tmp
-
-