[Mapbender-commits] r5506 - trunk/mapbender/resources/db/pgsql/UTF-8/update

[svn_mapbender at osgeo.org]

Author: astrid_emde
Date: 2010-02-16 05:58:42 -0500 (Tue, 16 Feb 2010)
New Revision: 5506

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/metadata_pgsql_UTF-8.sql
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql
Log:
some rows where missing from the metadata sqls. also moved them to the metadata_pgsql_UTF-8.sql

Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/metadata_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/metadata_pgsql_UTF-8.sql	2010-02-16 10:47:04 UTC (rev 5505)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/metadata_pgsql_UTF-8.sql	2010-02-16 10:58:42 UTC (rev 5506)
@@ -1,3 +1,57 @@
+--Things to be done for merging with geoportal.rlp***
+--Adoption of the group table to allow contact information for groups
+alter table mb_group add column mb_group_title character varying(255) NOT NULL DEFAULT ''::character varying;
+alter table mb_group add column mb_group_ext_id bigint;
+alter table mb_group add column mb_group_address character varying(255) NOT NULL DEFAULT ''::character varying;
+alter table mb_group add column mb_group_postcode character varying(255) NOT NULL DEFAULT ''::character varying;
+alter table mb_group add column mb_group_city character varying(255) NOT NULL DEFAULT ''::character varying;
+alter table mb_group add column mb_group_stateorprovince character varying(255) NOT NULL DEFAULT ''::character varying;
+alter table mb_group add column mb_group_country character varying(255) NOT NULL DEFAULT ''::character varying;
+alter table mb_group add column mb_group_voicetelephone character varying(255) NOT NULL DEFAULT ''::character varying;
+alter table mb_group add column mb_group_facsimiletelephone character varying(255) NOT NULL DEFAULT ''::character varying;
+alter table mb_group add column mb_group_email character varying(255) NOT NULL DEFAULT ''::character varying;
+alter table mb_group add column mb_group_logo_path text NOT NULL DEFAULT ''::character varying;
+alter table mb_user_mb_group add column mb_user_mb_group_type integer;
+--Adoption for adminsitration of conformities in the mapbender database***
+--searchable
+ALTER TABLE layer ADD COLUMN layer_searchable integer;
+ALTER TABLE layer ALTER COLUMN layer_searchable SET STORAGE PLAIN;
+ALTER TABLE layer ALTER COLUMN layer_searchable SET DEFAULT 1;
+-- Column: featuretype_searchable
+
+-- ALTER TABLE wfs_featuretype DROP COLUMN featuretype_searchable;
+
+--ALTER TABLE wfs_featuretype ADD COLUMN featuretype_searchable integer;
+--ALTER TABLE wfs_featuretype ALTER COLUMN featuretype_searchable SET STORAGE PLAIN;
+--ALTER TABLE wfs_featuretype ALTER COLUMN featuretype_searchable SET DEFAULT 1;
+
+
+ALTER TABLE wfs_featuretype ADD COLUMN featuretype_searchable integer;
+
+
+-- Column: wms_timestamp_create
+
+-- ALTER TABLE wms DROP COLUMN wms_timestamp_create;
+ALTER TABLE wms ADD COLUMN wms_timestamp_create integer;
+ALTER TABLE wms ALTER COLUMN wms_timestamp_create SET STORAGE PLAIN;
+
+--network accessibility
+ALTER TABLE wms ADD COLUMN wms_network_access integer;
+ALTER TABLE wms ALTER COLUMN wms_network_access SET STORAGE PLAIN;
+
+
+-- Column: wfs_timestamp_create
+
+-- ALTER TABLE wfs DROP COLUMN wfs_timestamp_create;
+ALTER TABLE wfs ADD COLUMN wfs_timestamp_create integer;
+ALTER TABLE wfs ALTER COLUMN wfs_timestamp_create SET STORAGE PLAIN;
+
+--network accessibility
+ALTER TABLE wfs ADD COLUMN wfs_network_access integer;
+ALTER TABLE wfs ALTER COLUMN wfs_network_access SET STORAGE PLAIN;
+
+
+
 --table for inspire metadata add on fields - for layer and featuretypes
 -- Table: inspire_md_data
 

Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql	2010-02-16 10:47:04 UTC (rev 5505)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.6.1_to_2.7rc1_pgsql_UTF-8.sql	2010-02-16 10:58:42 UTC (rev 5506)
@@ -1177,55 +1177,5 @@
 INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('toolbox_jquery', 'jq_ui_effects', 'transfer', '1', '1 = effect active', 'php_var');
 
 INSERT INTO gui_mb_user (fkey_gui_id, fkey_mb_user_id, mb_user_type) VALUES ('toolbox_jquery', 1, 'owner');
---Things to be done for merging with geoportal.rlp***
---Adoption of the group table to allow contact information for groups
-alter table mb_group add column mb_group_title character varying(255) NOT NULL DEFAULT ''::character varying;
-alter table mb_group add column mb_group_ext_id bigint;
-alter table mb_group add column mb_group_address character varying(255) NOT NULL DEFAULT ''::character varying;
-alter table mb_group add column mb_group_postcode character varying(255) NOT NULL DEFAULT ''::character varying;
-alter table mb_group add column mb_group_city character varying(255) NOT NULL DEFAULT ''::character varying;
-alter table mb_group add column mb_group_stateorprovince character varying(255) NOT NULL DEFAULT ''::character varying;
-alter table mb_group add column mb_group_country character varying(255) NOT NULL DEFAULT ''::character varying;
-alter table mb_group add column mb_group_voicetelephone character varying(255) NOT NULL DEFAULT ''::character varying;
-alter table mb_group add column mb_group_facsimiletelephone character varying(255) NOT NULL DEFAULT ''::character varying;
-alter table mb_group add column mb_group_email character varying(255) NOT NULL DEFAULT ''::character varying;
-alter table mb_group add column mb_group_logo_path text NOT NULL DEFAULT ''::character varying;
-alter table mb_user_mb_group add column mb_user_mb_group_type integer;
---Adoption for adminsitration of conformities in the mapbender database***
---searchable
-ALTER TABLE layer ADD COLUMN layer_searchable integer;
-ALTER TABLE layer ALTER COLUMN layer_searchable SET STORAGE PLAIN;
-ALTER TABLE layer ALTER COLUMN layer_searchable SET DEFAULT 1;
--- Column: featuretype_searchable
 
--- ALTER TABLE wfs_featuretype DROP COLUMN featuretype_searchable;
 
---ALTER TABLE wfs_featuretype ADD COLUMN featuretype_searchable integer;
---ALTER TABLE wfs_featuretype ALTER COLUMN featuretype_searchable SET STORAGE PLAIN;
---ALTER TABLE wfs_featuretype ALTER COLUMN featuretype_searchable SET DEFAULT 1;
-
-
-ALTER TABLE wfs_featuretype ADD COLUMN featuretype_searchable integer;
-
-
--- Column: wms_timestamp_create
-
--- ALTER TABLE wms DROP COLUMN wms_timestamp_create;
-ALTER TABLE wms ADD COLUMN wms_timestamp_create integer;
-ALTER TABLE wms ALTER COLUMN wms_timestamp_create SET STORAGE PLAIN;
-
---network accessibility
-ALTER TABLE wms ADD COLUMN wms_network_access integer;
-ALTER TABLE wms ALTER COLUMN wms_network_access SET STORAGE PLAIN;
-
-
--- Column: wfs_timestamp_create
-
--- ALTER TABLE wfs DROP COLUMN wfs_timestamp_create;
-ALTER TABLE wfs ADD COLUMN wfs_timestamp_create integer;
-ALTER TABLE wfs ALTER COLUMN wfs_timestamp_create SET STORAGE PLAIN;
-
---network accessibility
-ALTER TABLE wfs ADD COLUMN wfs_network_access integer;
-ALTER TABLE wfs ALTER COLUMN wfs_network_access SET STORAGE PLAIN;
-