--- a/flys-backend/doc/schema/postgresql-spatial.sql	Tue Mar 06 07:45:30 2012 +0000
+++ b/flys-backend/doc/schema/postgresql-spatial.sql	Tue Mar 06 11:54:41 2012 +0000
@@ -123,4 +123,34 @@
 ALTER TABLE hws ALTER COLUMN id SET DEFAULT NEXTVAL('HWS_ID_SEQ');
 
 
+--Hydrologie/UeSG
+CREATE SEQUENCE FLOODMAPS_ID_SEQ;
+CREATE TABLE floodmaps (
+    id         int PRIMARY KEY NOT NULL,
+    river_id   int REFERENCES rivers(id),
+    kind       int NOT NULL,
+    diff       NUMERIC,
+    count      int,
+    area       NUMERIC,
+    perimeter  NUMERIC
+);
+ALTER TABLE floodmaps ALTER COLUMN id SET DEFAULT NEXTVAL('FLOODMAPS_ID_SEQ');
+
+
+CREATE SEQUENCE POLYGONS_SEQ;
+CREATE TABLE polygons (
+    id int PRIMARY KEY NOT NULL
+);
+SELECT AddGeometryColumn('polygons', 'geom', 31466, 'POLYGON', 2);
+ALTER TABLE polygons ALTER COLUMN id SET DEFAULT NEXTVAL('POLYGONS_SEQ');
+
+
+CREATE SEQUENCE FLOODMAP_GEOMS_SEQ;
+CREATE TABLE floodmap_geoms (
+    id           int PRIMARY KEY NOT NULL,
+    floodmaps_id int NOT NULL REFERENCES floodmaps(id),
+    polygons_id  int NOT NULL REFERENCES polygons(id)
+);
+ALTER TABLE floodmap_geoms ALTER COLUMN id SET DEFAULT NEXTVAL('FLOODMAP_GEOMS_SEQ');
+
 END;