[Mapbender-commits] r1731 - in branches/mapbender_sld/resources/db: mysql postgresql

[svn_mapbender at osgeo.org]

Author: mschulz
Date: 2007-10-15 10:32:14 -0400 (Mon, 15 Oct 2007)
New Revision: 1731

Modified:
   branches/mapbender_sld/resources/db/mysql/mysql_schema.sql
   branches/mapbender_sld/resources/db/postgresql/pgsql_schema.sql
Log:
added fkey_gui_id, changed columns fkey_layer_id, fkey_mb_user_id

Modified: branches/mapbender_sld/resources/db/mysql/mysql_schema.sql
===================================================================
--- branches/mapbender_sld/resources/db/mysql/mysql_schema.sql	2007-10-15 14:30:05 UTC (rev 1730)
+++ branches/mapbender_sld/resources/db/mysql/mysql_schema.sql	2007-10-15 14:32:14 UTC (rev 1731)
@@ -338,12 +338,13 @@
 --
 
 CREATE TABLE sld_user_layer (
-    id int(11) NOT NULL auto_increment,
-    mb_user_id int(11) NOT NULL default '0',
-    layer_id int(11) NOT NULL default '0',
+    sld_user_layer_id int(11) NOT NULL auto_increment,
+    fkey_mb_user_id int(11) NOT NULL default '0',
+    fkey_layer_id int(11) NOT NULL default '0',
+    fkey_gui_id int(11) NOT NULL default '0',
     sld_xml longtext default NULL,
     use_sld int(4) default NULL,
-    PRIMARY KEY  (id)
+    PRIMARY KEY  (sld_user_layer_id)
 ) TYPE=InnoDB;
 
 -- --------------------------------------------------------

Modified: branches/mapbender_sld/resources/db/postgresql/pgsql_schema.sql
===================================================================
--- branches/mapbender_sld/resources/db/postgresql/pgsql_schema.sql	2007-10-15 14:30:05 UTC (rev 1730)
+++ branches/mapbender_sld/resources/db/postgresql/pgsql_schema.sql	2007-10-15 14:32:14 UTC (rev 1731)
@@ -361,11 +361,12 @@
 --
 
 CREATE TABLE sld_user_layer (
-    id serial NOT NULL,
-    mb_user_id integer NOT NULL,
-    layer_id integer NOT NULL,
+    sld_user_layer_id serial NOT NULL,
+    fkey_mb_user_id integer NOT NULL,
+    fkey_layer_id integer NOT NULL,
+    fkey_gui_id character varying,
     sld_xml text,
-    use_sld smallint
+    use_sld smallint,
 );
 
 
@@ -1094,5 +1095,5 @@
 
 ALTER TABLE mb_log ADD CONSTRAINT pk_mb_log PRIMARY KEY  (id); 
 
-ALTER TABLE sld_user_layer ADD CONSTRAINT pk_sld_user_layer PRIMARY KEY  (id);
+ALTER TABLE sld_user_layer ADD CONSTRAINT pk_sld_user_layer PRIMARY KEY  (sld_user_layer_id);