[Mapbender-commits] r3329 - branches/astroidex_25/resources/db/postgresql/utf8/update

[svn_mapbender at osgeo.org]

Author: astrid_emde
Date: 2008-12-15 19:07:11 -0500 (Mon, 15 Dec 2008)
New Revision: 3329

Modified:
   branches/astroidex_25/resources/db/postgresql/utf8/update/update_2.5_to_2.6_pgsql_UTF-8.sql
Log:
new tables for category handling 

Modified: branches/astroidex_25/resources/db/postgresql/utf8/update/update_2.5_to_2.6_pgsql_UTF-8.sql
===================================================================
--- branches/astroidex_25/resources/db/postgresql/utf8/update/update_2.5_to_2.6_pgsql_UTF-8.sql	2008-12-15 23:58:13 UTC (rev 3328)
+++ branches/astroidex_25/resources/db/postgresql/utf8/update/update_2.5_to_2.6_pgsql_UTF-8.sql	2008-12-16 00:07:11 UTC (rev 3329)
@@ -1 +1,21 @@
 -- new tables for category handling 
+CREATE TABLE public.gui_gui_category
+(
+  fkey_gui_id character varying(50),
+  fkey_gui_category_id integer
+);
+
+
+CREATE TABLE public.gui_category
+(
+  category_id serial,
+  category_name character varying(50),
+  category_description character varying(255),
+  CONSTRAINT pk_category_id PRIMARY KEY (category_id)
+);
+
+ALTER TABLE ONLY gui_gui_category
+    ADD CONSTRAINT gui_gui_category_ibfk_2 FOREIGN KEY (fkey_gui_id) REFERENCES gui(gui_id) ON UPDATE CASCADE ON DELETE CASCADE;
+
+ALTER TABLE ONLY gui_gui_category
+    ADD CONSTRAINT gui_gui_category_ibfk_1 FOREIGN KEY (fkey_gui_category_id) REFERENCES gui_category(category_id) ON UPDATE CASCADE ON DELETE CASCADE;