log backend/doc/schema/oracle.sql @ 8418:536a1c0c8a81

age author description
Wed, 15 Oct 2014 14:58:46 +0200 Tom Gottfried SCHEMA CHANGE: There is no boolean data type in oracle, and therefore it's no good idea to use it in postgresql.
Fri, 07 Feb 2014 10:54:03 +0100 Tom Gottfried Schema correction following yesterday's brain failure.
Thu, 06 Feb 2014 15:04:29 +0100 Tom Gottfried SCHEMA CHANGE: renamed uuid-column to avoid collision with data type.
Thu, 06 Feb 2014 13:22:10 +0100 Tom Gottfried SCHEMA CHANGE: Add UUIDs to rivers.
Fri, 13 Sep 2013 18:29:01 +0200 Tom Gottfried Schema change: increase precision of gauges.station to be able to hold nearby gauges. double-precision
Thu, 12 Sep 2013 21:12:59 +0200 Tom Gottfried SCHEMA CHANGE: a < b now enforced on ranges. double-precision
Mon, 19 Aug 2013 17:29:52 +0200 Tom Gottfried Undo misguided schema change from r5207 double-precision
Wed, 31 Jul 2013 14:29:12 +0200 Tom Gottfried Schema change: Store station of cross section lines with higher precision to avoid duplicates due to rounding. double-precision
Tue, 23 Jul 2013 18:05:11 +0200 Tom Gottfried Schema change: droped NOT NULL constraint from attributes.value because empty string is silently converted to NULL in Oracle but needed here. double-precision
Mon, 22 Jul 2013 18:06:23 +0200 Tom Gottfried Schema changes: fixed typos, syntax errors and missing or obsolete statements in Oracle schema double-precision
Fri, 28 Jun 2013 16:58:46 +0200 Tom Gottfried Schema change: add new field 'source' to wst_columns, currently only for official lines double-precision
Tue, 18 Jun 2013 17:28:27 +0200 Sascha L. Teichmann Backend: Fixed Oracle scheme for official lines.
Wed, 12 Jun 2013 16:36:34 +0200 Sascha L. Teichmann Backend: Modified schema for a better model of official lines.
Tue, 04 Jun 2013 10:27:54 +0200 Felix Wolfsteller Remove stray semicolon from sql schema.
Fri, 31 May 2013 17:24:22 +0200 Tom Gottfried Schema change: remove UNIQUE-constraint which allows importing cross sections only from PRF

http://dive4elements.wald.intevation.org