--- a/flys-backend/doc/schema/postgresql-spatial.sql	Thu Sep 01 10:03:58 2011 +0000
+++ b/flys-backend/doc/schema/postgresql-spatial.sql	Fri Sep 02 13:49:46 2011 +0000
@@ -1,49 +1,58 @@
 BEGIN;
 
 -- Geodaesie/Flussachse+km/achse
+CREATE SEQUENCE RIVER_AXES_ID_SEQ;
 CREATE TABLE river_axes (
-    id       SERIAL PRIMARY KEY NOT NULL,
+    id       int PRIMARY KEY NOT NULL,
     river_id int REFERENCES rivers(id),
     kind     int             NOT NULL DEFAULT 0
 );
 SELECT AddGeometryColumn('river_axes', 'geom', 31466, 'LINESTRING', 2);
+ALTER TABLE river_axes ALTER COLUMN id SET DEFAULT NEXTVAL('RIVER_AXES_ID_SEQ');
 
 
 -- Geodaesie/Querprofile/*
+CREATE SEQUENCE CROSS_SECTION_TRACKS_ID_SEQ;
 CREATE TABLE cross_section_tracks (
-    id       SERIAL PRIMARY KEY NOT NULL,
+    id       int PRIMARY KEY NOT NULL,
     river_id int REFERENCES rivers(id),
     km       NUMERIC NOT NULL,
     z        NUMERIC NOT NULL DEFAULT 0
 );
 SELECT AddGeometryColumn('cross_section_tracks', 'geom', 31466, 'LINESTRING', 2);
+ALTER TABLE cross_section_tracks ALTER COLUMN id SET DEFAULT NEXTVAL('CROSS_SECTION_TRACKS_ID_SEQ');
 
 
 -- Geodaesie/Linien/rohre-und-spreen
+CREATE SEQUENCE LINES_ID_SEQ;
 CREATE TABLE lines (
-    id       SERIAL PRIMARY KEY NOT NULL,
+    id       int PRIMARY KEY NOT NULL,
     river_id int REFERENCES rivers(id),
     kind     int             NOT NULL DEFAULT 0,
     z        NUMERIC DEFAULT 0
 );
 SELECT AddGeometryColumn('lines', 'geom', 31466, 'LINESTRING', 4);
+ALTER TABLE lines ALTER COLUMN id SET DEFAULT NEXTVAL('LINES_ID_SEQ');
 -- 'kind':
 -- 0: ROHR1
 -- 1: DAMM
 
 
 -- Geodaesie/Bauwerke/Wehre.shp
+CREATE SEQUENCE BUILDINGS_ID_SEQ;
 CREATE TABLE buildings (
-    id       SERIAL PRIMARY KEY NOT NULL,
+    id       int PRIMARY KEY NOT NULL,
     river_id int REFERENCES rivers(id),
     name     VARCHAR(50)
 );
 SELECT AddGeometryColumn('buildings', 'geom', 31466, 'LINESTRING', 2);
+ALTER TABLE buildings ALTER COLUMN id SET DEFAULT NEXTVAL('BUILDINGS_ID_SEQ');
 
 
 -- Geodaesie/Festpunkte/Festpunkte.shp
+CREATE SEQUENCE FIXPOINTS_ID_SEQ;
 CREATE TABLE fixpoints (
-    id       SERIAL PRIMARY KEY NOT NULL,
+    id       int PRIMARY KEY NOT NULL,
     river_id int REFERENCES rivers(id),
     x        int,
     y        int,
@@ -51,20 +60,24 @@
     HPGP     VARCHAR(2)
 );
 SELECT AddGeometryColumn('fixpoints', 'geom', 31466, 'POINT', 2);
+ALTER TABLE fixpoints ALTER COLUMN id SET DEFAULT NEXTVAL('FIXPOINTS_ID_SEQ');
 
 
 -- Hydrologie/Hydr. Grenzen/talaue.shp
+CREATE SEQUENCE FLOODPLAIN_ID_SEQ;
 CREATE TABLE floodplain (
-    id       SERIAL PRIMARY KEY NOT NULL,
+    id       int PRIMARY KEY NOT NULL,
     river_id int REFERENCES rivers(id)
 );
 SELECT AddGeometryColumn('floodplain', 'geom', 31466, 'MULTIPOLYGON', 2);
+ALTER TABLE floodplain ALTER COLUMN id SET DEFAULT NEXTVAL('FLOODPLAIN_ID_SEQ');
 
 
 -- Geodaesie/Hoehenmodelle/*
 -- XXX DGM in englisch DEM, um dies zu vereinheitlichen
-CREATE TABLE dgm (
-    id       SERIAL PRIMARY KEY NOT NULL,
+CREATE SEQUENCE DEM_ID_SEQ;
+CREATE TABLE dem (
+    id       int PRIMARY KEY NOT NULL,
     river_id int REFERENCES rivers(id),
     -- XXX Should we use the ranges table instead?
     lower    NUMERIC,
@@ -72,6 +85,7 @@
     path     VARCHAR(256),
     UNIQUE (river_id, lower, upper)
 );
+ALTER TABLE dem ALTER COLUMN id SET DEFAULT NEXTVAL('DEM_ID_SEQ');
 
 
 -- TODO