[Mapbender-commits] r2705 - branches/2.5/resources/db/update

svn_mapbender at osgeo.org svn_mapbender at osgeo.org
Wed Jul 23 07:35:25 EDT 2008 

Author: astrid_emde
Date: 2008-07-23 07:35:25 -0400 (Wed, 23 Jul 2008)
New Revision: 2705

Modified:
   branches/2.5/resources/db/update/update_mysql_db.sql
Log:
sqls to update the mapbender db to mapbender 2.5


Modified: branches/2.5/resources/db/update/update_mysql_db.sql
===================================================================
--- branches/2.5/resources/db/update/update_mysql_db.sql	2008-07-23 09:43:44 UTC (rev 2704)
+++ branches/2.5/resources/db/update/update_mysql_db.sql	2008-07-23 11:35:25 UTC (rev 2705)
@@ -34,21 +34,23 @@
 ALTER table wfs add electronicmailaddress varchar(255);
 ALTER table wfs add wfs_mb_getcapabilities_doc text;
 ALTER table wfs add wfs_owner int(11);
-ALTER table wfs add wfs_timestamp int(11)
+ALTER table wfs add wfs_timestamp int(11);
 ALTER table wfs add country varchar(255);
 
-ALTER TABLE wfs ALTER COLUMN wfs_title SET NOT NULL;
-ALTER TABLE wfs ALTER COLUMN wfs_title SET DEFAULT ''::character varying;
 
-ALTER TABLE wfs ALTER COLUMN wfs_version SET NOT NULL;
-ALTER TABLE wfs ALTER COLUMN wfs_version SET DEFAULT ''::character varying;
+ALTER TABLE wfs MODIFY wfs_title varchar(255) NOT NULL;
+ALTER TABLE wfs ALTER COLUMN wfs_title SET DEFAULT '';
 
-ALTER TABLE wfs ALTER COLUMN wfs_getcapabilities SET NOT NULL;
-ALTER TABLE wfs ALTER COLUMN wfs_getcapabilities SET DEFAULT ''::character varying;
+ALTER TABLE wfs MODIFY wfs_version NOT NULL;
+ALTER TABLE wfs ALTER COLUMN wfs_version SET DEFAULT '';
 
+ALTER TABLE wfs MODIFY wfs_getcapabilities NOT NULL;
+ALTER TABLE wfs ALTER COLUMN wfs_getcapabilities SET DEFAULT '';
+
 alter table wfs_featuretype add column featuretype_searchable integer default 1;
 alter table wfs_featuretype add column featuretype_abstract character varying(50);
 
+
 -- grant root access to default wfs
 UPDATE wfs SET wfs_owner = 1;
 
@@ -56,17 +58,17 @@
 -- new table gui_wfs_conf
 --
 CREATE TABLE gui_wfs_conf (
-    fkey_gui_id character varying(50) DEFAULT ''::character varying NOT NULL,
+    fkey_gui_id character varying(50) DEFAULT '' NOT NULL,
     fkey_wfs_conf_id integer DEFAULT 0 NOT NULL
 );
 
-ALTER TABLE ONLY gui_wfs_conf
+ALTER TABLE gui_wfs_conf
     ADD CONSTRAINT pk_fkey_wfs_conf_id PRIMARY KEY (fkey_gui_id, fkey_wfs_conf_id);
    
-ALTER  TABLE ONLY gui_wfs_conf
+ALTER  TABLE gui_wfs_conf
     ADD CONSTRAINT gui_wfs_conf_ibfk_1 FOREIGN KEY (fkey_gui_id) REFERENCES gui(gui_id) ON UPDATE CASCADE ON DELETE CASCADE;
     
-ALTER TABLE ONLY gui_wfs_conf
+ALTER TABLE gui_wfs_conf
     ADD CONSTRAINT gui_wfs_conf_ibfk_2 FOREIGN KEY (fkey_wfs_conf_id) REFERENCES wfs_conf(wfs_conf_id) ON UPDATE CASCADE ON DELETE CASCADE;
 
 -- insert wfs confs into gui digitize
@@ -85,10 +87,10 @@
   fkey_keyword_id integer NOT NULL
 );
 
-ALTER TABLE ONLY wfs_featuretype_keyword
+ALTER TABLE wfs_featuretype_keyword
     ADD CONSTRAINT fkey_keyword_id_fkey_featuretype_id FOREIGN KEY (fkey_keyword_id) REFERENCES keyword(keyword_id) ON UPDATE CASCADE ON DELETE CASCADE;
 
-ALTER TABLE ONLY wfs_featuretype_keyword
+ALTER TABLE wfs_featuretype_keyword
     ADD CONSTRAINT fkey_featuretype_id_fkey_keyword_id FOREIGN KEY (fkey_featuretype_id) REFERENCES wfs_featuretype(featuretype_id) ON UPDATE CASCADE ON DELETE CASCADE;
 
 --
@@ -108,14 +110,14 @@
 --
 -- table wfs_conf_element: change in WFS configuration: access to geometries may now be restricted
 --
-ALTER TABLE wfs_conf_element ADD COLUMN f_auth_varname VARCHAR(50);
+--ALTER TABLE wfs_conf_element ADD COLUMN f_auth_varname VARCHAR(50);
 ALTER TABLE wfs_conf_element ADD COLUMN f_show_detail int4;
 ALTER TABLE wfs_conf_element ADD COLUMN f_operator VARCHAR(50);
 
 --
 -- table gui_element: new column for translation
 --
- ALTER TABLE gui_element ADD COLUMN e_title VARCHAR(255) NULL;
+-- ALTER TABLE gui_element ADD COLUMN e_title VARCHAR(255) NULL;
 INSERT INTO gui_element(fkey_gui_id, e_id, e_pos, e_public, e_comment, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url) VALUES('admin1','WFS',2,1,'edit wfs settings','a','','href = "../javascripts/mod_wfs_client.html" target="AdminFrame"',10,1005,250,20,NULL ,'font-family: Arial, Helvetica, sans-serif; font-size : 12px; text-decoration : none; color: #808080;','EDIT WFS','a','','','','AdminFrame','');
 
 
@@ -131,6 +133,7 @@
 -- 
 -- new table translation: new table for translations
 -- 
+
  CREATE TABLE translations
  (
    trs_id int(11) NOT NULL auto_increment,
@@ -139,6 +142,7 @@
    msgstr varchar(512),
    PRIMARY KEY (trs_id)
  );
+
  
  CREATE INDEX msgid_idx ON translations(msgid);
 
@@ -472,6 +476,7 @@
 -- 
 -- new SLD table
 --
+
 CREATE TABLE sld_user_layer (
     sld_user_layer_id int(11) NOT NULL auto_increment,
     fkey_mb_user_id int(11) NOT NULL default '0',
@@ -482,22 +487,26 @@
     PRIMARY KEY (sld_user_layer_id)
 ) TYPE=InnoDB;
 
+
+
 -- constraints for new table sld_user_layer
-ALTER TABLE sld_user_layer
-  ADD CONSTRAINT sld_user_layer_ibfk1 FOREIGN KEY (fkey_mb_user_id) REFERENCES mb_user (mb_user_id) ON DELETE CASCADE ON UPDATE CASCADE,
-  ADD CONSTRAINT sld_user_layer_ibfk2 FOREIGN KEY (fkey_layer_id) REFERENCES layer (layer_id) ON DELETE CASCADE ON UPDATE CASCADE,
-  ADD CONSTRAINT sld_user_layer_ibfk3 FOREIGN KEY (fkey_gui_id) REFERENCES gui (gui_id) ON DELETE CASCADE ON UPDATE CASCADE;
+ALTER TABLE sld_user_layer ADD CONSTRAINT sld_user_layer_ibfk1 FOREIGN KEY (fkey_mb_user_id) REFERENCES mb_user (mb_user_id) ON DELETE CASCADE ON UPDATE CASCADE;
+ALTER TABLE sld_user_layer ADD CONSTRAINT ADD CONSTRAINT sld_user_layer_ibfk2 FOREIGN KEY (fkey_layer_id) REFERENCES layer (layer_id) ON DELETE CASCADE ON UPDATE CASCADE;
+ALTER TABLE sld_user_layer ADD CONSTRAINT ADD CONSTRAINT sld_user_layer_ibfk3 FOREIGN KEY (fkey_gui_id) REFERENCES gui (gui_id) ON DELETE CASCADE ON UPDATE CASCADE;
 
 --
 -- add sld related columns
 --
+
 ALTER TABLE gui_wms ADD COLUMN gui_wms_sldurl varchar(255) NOT NULL default '';
 ALTER TABLE wms ADD COLUMN wms_supportsld boolean NULL;
 ALTER TABLE wms ADD COLUMN wms_userlayer boolean NULL;
 ALTER TABLE wms ADD COLUMN wms_userstyle boolean NULL;
 ALTER TABLE wms ADD COLUMN wms_remotewfs boolean NULL;
 
+
 --
 -- opacity handeling
 --
-ALTER TABLE gui_wms ADD COLUMN gui_wms_opacity INT DEFAULT 100;
\ No newline at end of file
+
+ALTER TABLE gui_wms ADD COLUMN gui_wms_opacity INT DEFAULT 100;

More information about the Mapbender_commits mailing list