log flys-backend/doc/schema/oracle-spatial.sql @ 5543:732a8bd44650

age author description
Wed, 03 Apr 2013 15:31:31 +0200 Andre Heinecke Fix syntax errors in oracle scheme
Thu, 28 Mar 2013 15:56:24 +0100 Andre Heinecke Cosmetic scheme change. Qualify the unknown name of sectie and sobek
Thu, 28 Mar 2013 15:31:34 +0100 Andre Heinecke Add not null and default for hydr_boundary classifiers
Thu, 28 Mar 2013 12:38:06 +0100 Andre Heinecke Minor scheme change. Update kind names to their UI representation.
Mon, 25 Mar 2013 17:51:33 +0100 Tom Gottfried SCHEMA CHANGE: add table for flood marks and missing DROPs for jetties
Mon, 25 Mar 2013 17:01:07 +0100 Andre Heinecke Add building_kinds to drop script and fix syntax of buildings table
Mon, 25 Mar 2013 10:12:42 +0100 Andre Heinecke Rename station to km to be in line with the rest
Fri, 22 Mar 2013 17:30:10 +0100 Andre Heinecke Scheme change: Building table is extended and got a lookup table for kind
Thu, 21 Mar 2013 09:30:46 +0100 Andre Heinecke Switch to 2D for fixpoints and river_axes
Wed, 20 Mar 2013 17:58:45 +0100 Andre Heinecke Jetties are two dimensional
Thu, 14 Mar 2013 18:04:36 +0100 Tom Gottfried removed unique constraint to allow one dem to be used by several rivers
Thu, 14 Mar 2013 12:16:58 +0100 Tom Gottfried added tables for jetties in spatial schema
Wed, 13 Mar 2013 18:39:28 +0100 Tom Gottfried SCHEMA CHANGE: lookup table for floodmaps and source-field added, Importer adapted to new directory names
Tue, 12 Mar 2013 19:43:11 +0100 Tom Gottfried fixed DEM-importer to work with Oracle (made by A. Heinecke)
Mon, 11 Mar 2013 11:43:44 +0100 Tom Gottfried add lookup tables for floodplain and cross section tracks
Fri, 08 Mar 2013 18:15:48 +0100 Andre Heinecke SCHEME CHANGE: dgm now uses time intervals and ranges
Fri, 08 Mar 2013 13:06:40 +0100 Tom Gottfried Oracle Schema: add missing constraint and allow 7-digit kms
Fri, 01 Mar 2013 20:52:31 +0100 Sascha L. Teichmann Fixed broken insert statements for axis_kinds.
Fri, 01 Mar 2013 13:28:45 +0100 Tom Gottfried added missing constraints in schema (mostly for Oracle)
Thu, 28 Feb 2013 18:04:19 +0100 Andre Heinecke Add kind_id to river_axes table and add AxisKind object to model
Thu, 28 Feb 2013 11:14:38 +0100 Andre Heinecke Fix oracle-spatial creation script and posgresql drop script dami
Thu, 28 Feb 2013 10:09:31 +0100 Andre Heinecke Fix import of hws_* on Oracle dami
Wed, 27 Feb 2013 19:44:08 +0100 Tom Gottfried sensible constraints for dem-table dami
Wed, 27 Feb 2013 15:26:47 +0100 Tom Gottfried removed unnecessary NOT NULL constraints from dem-table dami
Thu, 21 Feb 2013 12:36:30 +0100 Andre Heinecke Oracle Schema, add overlooked sectie and sobek fields dami
Wed, 20 Feb 2013 10:44:04 +0100 Andre Heinecke Fix some oracle syntax problems and move indicies to _idx.sql dami
Tue, 19 Feb 2013 19:24:36 +0100 Tom Gottfried SCHEMA CHANGE: removed catchements from schema and geo-importer (obsolete) dami
Tue, 19 Feb 2013 14:58:33 +0100 Andre Heinecke Sync Posgres and Oracle spatial schema dami
Tue, 19 Feb 2013 09:57:57 +0100 Tom Gottfried SCHEMA CHANGE: removed obsolete table 'lines' from spatial schema (now 'hws_lines') dami
Fri, 28 Sep 2012 08:37:08 +0000 Ingo Weinzierl Adapted the spatial schema for DEMs and the DgmSqlConverter.

http://dive4elements.wald.intevation.org