[Mapbender-commits] r3026 - in branches/2.5/resources/db: mysql/iso
mysql/utf8 postgresql/iso postgresql/utf8 update
svn_mapbender at osgeo.org
svn_mapbender at osgeo.org
Mon Sep 29 05:27:35 EDT 2008
Author: christoph
Date: 2008-09-29 05:27:33 -0400 (Mon, 29 Sep 2008)
New Revision: 3026
Added:
branches/2.5/resources/db/update/update_2.5_stable_mysql.sql
branches/2.5/resources/db/update/update_2.5_stable_pgsql.sql
Modified:
branches/2.5/resources/db/mysql/iso/mysql_data.sql
branches/2.5/resources/db/mysql/utf8/mysql_data.sql
branches/2.5/resources/db/postgresql/iso/pgsql_data.sql
branches/2.5/resources/db/postgresql/utf8/pgsql_data.sql
Log:
http://trac.osgeo.org/mapbender/ticket/298
Modified: branches/2.5/resources/db/mysql/iso/mysql_data.sql
===================================================================
--- branches/2.5/resources/db/mysql/iso/mysql_data.sql 2008-09-29 09:22:14 UTC (rev 3025)
+++ branches/2.5/resources/db/mysql/iso/mysql_data.sql 2008-09-29 09:27:33 UTC (rev 3026)
@@ -1,9 +1,9 @@
--
-- mysql iso data dump
--
--- Mapbender 2.5.0 RC6
+-- Mapbender 2.5.0
--
--- 2008/08/15
+-- 2008/09/29
--
@@ -2554,22 +2554,7 @@
INSERT INTO gui_mb_user (fkey_gui_id, fkey_mb_user_id, mb_user_type) VALUES ('admin_de_services', 1, 'owner');
---
--- Data for Name: gui_treegde; Type: TABLE DATA; Schema: public; Owner: admin
---
-INSERT INTO gui_treegde (fkey_gui_id, fkey_layer_id, id, lft, rgt, my_layer_title, layer, wms_id) VALUES ('admin1', '', 4, 1, 4, 'new', '', '');
-INSERT INTO gui_treegde (fkey_gui_id, fkey_layer_id, id, lft, rgt, my_layer_title, layer, wms_id) VALUES ('admin1', '', 5, 2, 3, 'new', '', '');
-INSERT INTO gui_treegde (fkey_gui_id, fkey_layer_id, id, lft, rgt, my_layer_title, layer, wms_id) VALUES ('gui', '', 11, 1, 4, 'Verkehr', '', '');
-INSERT INTO gui_treegde (fkey_gui_id, fkey_layer_id, id, lft, rgt, my_layer_title, layer, wms_id) VALUES ('gui', '15348', 12, 2, 3, 'Strassen', 'Strassen', '118');
-INSERT INTO gui_treegde (fkey_gui_id, fkey_layer_id, id, lft, rgt, my_layer_title, layer, wms_id) VALUES ('gui1', '', 11, 1, 4, 'new', '', '');
-INSERT INTO gui_treegde (fkey_gui_id, fkey_layer_id, id, lft, rgt, my_layer_title, layer, wms_id) VALUES ('gui1', '', 12, 2, 3, 'new', '', '');
-INSERT INTO gui_treegde (fkey_gui_id, fkey_layer_id, id, lft, rgt, my_layer_title, layer, wms_id) VALUES ('wms_africa', NULL, 98, 1, 4, 'new', '', NULL);
-INSERT INTO gui_treegde (fkey_gui_id, fkey_layer_id, id, lft, rgt, my_layer_title, layer, wms_id) VALUES ('wms_africa', NULL, 99, 2, 3, 'new', '', NULL);
-INSERT INTO gui_treegde (fkey_gui_id, fkey_layer_id, id, lft, rgt, my_layer_title, layer, wms_id) VALUES ('gui2', '', 11, 1, 4, 'Verkehr', '', '');
-INSERT INTO gui_treegde (fkey_gui_id, fkey_layer_id, id, lft, rgt, my_layer_title, layer, wms_id) VALUES ('gui2', '15348', 12, 2, 3, 'Strassen', 'Strassen', '118');
-
-
--
-- Data for Name: gui_wfs; Type: TABLE DATA; Schema: public; Owner: admin
--
Modified: branches/2.5/resources/db/mysql/utf8/mysql_data.sql
===================================================================
--- branches/2.5/resources/db/mysql/utf8/mysql_data.sql 2008-09-29 09:22:14 UTC (rev 3025)
+++ branches/2.5/resources/db/mysql/utf8/mysql_data.sql 2008-09-29 09:27:33 UTC (rev 3026)
@@ -1,9 +1,9 @@
--
-- mysql utf8 data dump
--
--- Mapbender 2.5.0 RC6
+-- Mapbender 2.5.0
--
--- 2008/08/15
+-- 2008/09/29
--
@@ -2554,22 +2554,7 @@
INSERT INTO gui_mb_user (fkey_gui_id, fkey_mb_user_id, mb_user_type) VALUES ('admin_de_services', 1, 'owner');
---
--- Data for Name: gui_treegde; Type: TABLE DATA; Schema: public; Owner: admin
---
-INSERT INTO gui_treegde (fkey_gui_id, fkey_layer_id, id, lft, rgt, my_layer_title, layer, wms_id) VALUES ('admin1', '', 4, 1, 4, 'new', '', '');
-INSERT INTO gui_treegde (fkey_gui_id, fkey_layer_id, id, lft, rgt, my_layer_title, layer, wms_id) VALUES ('admin1', '', 5, 2, 3, 'new', '', '');
-INSERT INTO gui_treegde (fkey_gui_id, fkey_layer_id, id, lft, rgt, my_layer_title, layer, wms_id) VALUES ('gui', '', 11, 1, 4, 'Verkehr', '', '');
-INSERT INTO gui_treegde (fkey_gui_id, fkey_layer_id, id, lft, rgt, my_layer_title, layer, wms_id) VALUES ('gui', '15348', 12, 2, 3, 'Strassen', 'Strassen', '118');
-INSERT INTO gui_treegde (fkey_gui_id, fkey_layer_id, id, lft, rgt, my_layer_title, layer, wms_id) VALUES ('gui1', '', 11, 1, 4, 'new', '', '');
-INSERT INTO gui_treegde (fkey_gui_id, fkey_layer_id, id, lft, rgt, my_layer_title, layer, wms_id) VALUES ('gui1', '', 12, 2, 3, 'new', '', '');
-INSERT INTO gui_treegde (fkey_gui_id, fkey_layer_id, id, lft, rgt, my_layer_title, layer, wms_id) VALUES ('wms_africa', NULL, 98, 1, 4, 'new', '', NULL);
-INSERT INTO gui_treegde (fkey_gui_id, fkey_layer_id, id, lft, rgt, my_layer_title, layer, wms_id) VALUES ('wms_africa', NULL, 99, 2, 3, 'new', '', NULL);
-INSERT INTO gui_treegde (fkey_gui_id, fkey_layer_id, id, lft, rgt, my_layer_title, layer, wms_id) VALUES ('gui2', '', 11, 1, 4, 'Verkehr', '', '');
-INSERT INTO gui_treegde (fkey_gui_id, fkey_layer_id, id, lft, rgt, my_layer_title, layer, wms_id) VALUES ('gui2', '15348', 12, 2, 3, 'Strassen', 'Strassen', '118');
-
-
--
-- Data for Name: gui_wfs; Type: TABLE DATA; Schema: public; Owner: admin
--
Modified: branches/2.5/resources/db/postgresql/iso/pgsql_data.sql
===================================================================
--- branches/2.5/resources/db/postgresql/iso/pgsql_data.sql 2008-09-29 09:22:14 UTC (rev 3025)
+++ branches/2.5/resources/db/postgresql/iso/pgsql_data.sql 2008-09-29 09:27:33 UTC (rev 3026)
@@ -1,9 +1,9 @@
--
-- postgresql iso data dump
--
--- Mapbender 2.5.0 RC6
+-- Mapbender 2.5.0
--
--- 2008/08/15
+-- 2008/09/29
--
@@ -2554,22 +2554,7 @@
INSERT INTO gui_mb_user (fkey_gui_id, fkey_mb_user_id, mb_user_type) VALUES ('admin_de_services', 1, 'owner');
---
--- Data for Name: gui_treegde; Type: TABLE DATA; Schema: public; Owner: admin
---
-INSERT INTO gui_treegde (fkey_gui_id, fkey_layer_id, id, lft, rgt, my_layer_title, layer, wms_id) VALUES ('admin1', '', 4, 1, 4, 'new', '', '');
-INSERT INTO gui_treegde (fkey_gui_id, fkey_layer_id, id, lft, rgt, my_layer_title, layer, wms_id) VALUES ('admin1', '', 5, 2, 3, 'new', '', '');
-INSERT INTO gui_treegde (fkey_gui_id, fkey_layer_id, id, lft, rgt, my_layer_title, layer, wms_id) VALUES ('gui', '', 11, 1, 4, 'Verkehr', '', '');
-INSERT INTO gui_treegde (fkey_gui_id, fkey_layer_id, id, lft, rgt, my_layer_title, layer, wms_id) VALUES ('gui', '15348', 12, 2, 3, 'Strassen', 'Strassen', '118');
-INSERT INTO gui_treegde (fkey_gui_id, fkey_layer_id, id, lft, rgt, my_layer_title, layer, wms_id) VALUES ('gui1', '', 11, 1, 4, 'new', '', '');
-INSERT INTO gui_treegde (fkey_gui_id, fkey_layer_id, id, lft, rgt, my_layer_title, layer, wms_id) VALUES ('gui1', '', 12, 2, 3, 'new', '', '');
-INSERT INTO gui_treegde (fkey_gui_id, fkey_layer_id, id, lft, rgt, my_layer_title, layer, wms_id) VALUES ('wms_africa', NULL, 98, 1, 4, 'new', '', NULL);
-INSERT INTO gui_treegde (fkey_gui_id, fkey_layer_id, id, lft, rgt, my_layer_title, layer, wms_id) VALUES ('wms_africa', NULL, 99, 2, 3, 'new', '', NULL);
-INSERT INTO gui_treegde (fkey_gui_id, fkey_layer_id, id, lft, rgt, my_layer_title, layer, wms_id) VALUES ('gui2', '', 11, 1, 4, 'Verkehr', '', '');
-INSERT INTO gui_treegde (fkey_gui_id, fkey_layer_id, id, lft, rgt, my_layer_title, layer, wms_id) VALUES ('gui2', '15348', 12, 2, 3, 'Strassen', 'Strassen', '118');
-
-
--
-- Data for Name: gui_wfs; Type: TABLE DATA; Schema: public; Owner: admin
--
Modified: branches/2.5/resources/db/postgresql/utf8/pgsql_data.sql
===================================================================
--- branches/2.5/resources/db/postgresql/utf8/pgsql_data.sql 2008-09-29 09:22:14 UTC (rev 3025)
+++ branches/2.5/resources/db/postgresql/utf8/pgsql_data.sql 2008-09-29 09:27:33 UTC (rev 3026)
@@ -1,9 +1,9 @@
--
-- postgresql utf8 data dump
--
--- Mapbender 2.5.0 RC6
+-- Mapbender 2.5.0
--
--- 2008/08/15
+-- 2008/09/29
--
@@ -2555,22 +2555,6 @@
--
--- Data for Name: gui_treegde; Type: TABLE DATA; Schema: public; Owner: admin
---
-
-INSERT INTO gui_treegde (fkey_gui_id, fkey_layer_id, id, lft, rgt, my_layer_title, layer, wms_id) VALUES ('admin1', '', 4, 1, 4, 'new', '', '');
-INSERT INTO gui_treegde (fkey_gui_id, fkey_layer_id, id, lft, rgt, my_layer_title, layer, wms_id) VALUES ('admin1', '', 5, 2, 3, 'new', '', '');
-INSERT INTO gui_treegde (fkey_gui_id, fkey_layer_id, id, lft, rgt, my_layer_title, layer, wms_id) VALUES ('gui', '', 11, 1, 4, 'Verkehr', '', '');
-INSERT INTO gui_treegde (fkey_gui_id, fkey_layer_id, id, lft, rgt, my_layer_title, layer, wms_id) VALUES ('gui', '15348', 12, 2, 3, 'Strassen', 'Strassen', '118');
-INSERT INTO gui_treegde (fkey_gui_id, fkey_layer_id, id, lft, rgt, my_layer_title, layer, wms_id) VALUES ('gui1', '', 11, 1, 4, 'new', '', '');
-INSERT INTO gui_treegde (fkey_gui_id, fkey_layer_id, id, lft, rgt, my_layer_title, layer, wms_id) VALUES ('gui1', '', 12, 2, 3, 'new', '', '');
-INSERT INTO gui_treegde (fkey_gui_id, fkey_layer_id, id, lft, rgt, my_layer_title, layer, wms_id) VALUES ('wms_africa', NULL, 98, 1, 4, 'new', '', NULL);
-INSERT INTO gui_treegde (fkey_gui_id, fkey_layer_id, id, lft, rgt, my_layer_title, layer, wms_id) VALUES ('wms_africa', NULL, 99, 2, 3, 'new', '', NULL);
-INSERT INTO gui_treegde (fkey_gui_id, fkey_layer_id, id, lft, rgt, my_layer_title, layer, wms_id) VALUES ('gui2', '', 11, 1, 4, 'Verkehr', '', '');
-INSERT INTO gui_treegde (fkey_gui_id, fkey_layer_id, id, lft, rgt, my_layer_title, layer, wms_id) VALUES ('gui2', '15348', 12, 2, 3, 'Strassen', 'Strassen', '118');
-
-
---
-- Data for Name: gui_wfs; Type: TABLE DATA; Schema: public; Owner: admin
--
Added: branches/2.5/resources/db/update/update_2.5_stable_mysql.sql
===================================================================
--- branches/2.5/resources/db/update/update_2.5_stable_mysql.sql (rev 0)
+++ branches/2.5/resources/db/update/update_2.5_stable_mysql.sql 2008-09-29 09:27:33 UTC (rev 3026)
@@ -0,0 +1 @@
+DELETE FROM gui_treegde WHERE fkey_gui_id IN ('gui', 'gui1', 'admin1', 'gui2', 'wms_africa');
\ No newline at end of file
Added: branches/2.5/resources/db/update/update_2.5_stable_pgsql.sql
===================================================================
--- branches/2.5/resources/db/update/update_2.5_stable_pgsql.sql (rev 0)
+++ branches/2.5/resources/db/update/update_2.5_stable_pgsql.sql 2008-09-29 09:27:33 UTC (rev 3026)
@@ -0,0 +1 @@
+DELETE FROM gui_treegde WHERE fkey_gui_id IN ('gui', 'gui1', 'admin1', 'gui2', 'wms_africa');
\ No newline at end of file
More information about the Mapbender_commits
mailing list