log flys-backend/doc/schema/oracle.sql @ 5503:b660090b417d

age author description
Fri, 15 Mar 2013 16:43:00 +0100 Tom Gottfried SCHEMA CHANGE: removed bad triggers and foreign keys from schema
Thu, 14 Mar 2013 13:39:54 +0100 Tom Gottfried trigger sequence of time_interval IDs in DB as it is not used by hibernate only anymore
Thu, 14 Mar 2013 13:32:02 +0100 Tom Gottfried trigger sequence of range IDs in DB as it is not used by hibernate only anymore
Mon, 11 Mar 2013 18:17:12 +0100 Tom Gottfried SCHEMA CHANGE: analogue r5201. Here for Oracle
Fri, 08 Mar 2013 16:51:55 +0100 Tom Gottfried corrected constraints on table gauges
Fri, 08 Mar 2013 15:16:00 +0100 Andre Heinecke SCHEME CHANGE: Add measurement_station to oracle table and rename comment column
Fri, 01 Mar 2013 13:28:45 +0100 Tom Gottfried added missing constraints in schema (mostly for Oracle)
Wed, 27 Feb 2013 12:39:59 +0100 Andre Heinecke Add on delete cascade to the constraints that also cascade on postgres dami
Sat, 05 Jan 2013 15:05:51 +0100 Sascha L. Teichmann !!! FLYS backend schema change !!! Add column bfg_id column to discharge_tables.
Thu, 06 Dec 2012 17:30:09 +0100 Sascha L. Teichmann Added view for selecting ranges in wsts.
Sat, 22 Sep 2012 13:45:51 +0000 Sascha L. Teichmann Backend: Added 'official_number' column to rivers table to model the 'Bundeswasserstrassen Identnummer'.
Wed, 18 Jul 2012 09:24:51 +0000 Felix Wolfsteller Adjusted official lines views schemata to include wst column pos.
Wed, 11 Jul 2012 10:37:03 +0000 Sascha L. Teichmann Backend: Added DB indices for fasten access to cross section points.
Wed, 11 Jul 2012 08:09:32 +0000 Sascha L. Teichmann Partial fix for flys/issue697: Increased the decimal places of Ws, Qs and Kms to 5.
Fri, 29 Jun 2012 11:24:50 +0000 Sascha L. Teichmann Backend: Added views to access the 'Amtlichen Linien'.
Fri, 27 Apr 2012 07:18:45 +0000 Ingo Weinzierl Made SQL instructions upper case.
Mon, 19 Dec 2011 11:21:25 +0000 Sascha L. Teichmann Added support for official gauge numbers.
Fri, 18 Nov 2011 15:53:07 +0000 Sascha L. Teichmann Fixed flys/issue415: Increased precision of a and b in ranges.
Wed, 19 Oct 2011 09:46:19 +0000 Bjoern Schilberg Added missing views (wst_value_table,wst_w_values,wst_q_values).
Tue, 18 Oct 2011 10:25:00 +0000 Bjoern Schilberg Removed all CREATE OR REPLACE TRIGGER statements.
Mon, 17 Oct 2011 12:10:12 +0000 Bjoern Schilberg Adjusted NUMBER format for units, positions and cross_section_points tables.
Tue, 11 Oct 2011 07:29:53 +0000 Bjoern Schilberg Fixed errors.
Mon, 10 Oct 2011 16:20:17 +0000 Bjoern Schilberg Adjust oracle schema [I382]
Thu, 15 Sep 2011 11:16:59 +0000 Bjoern Schilberg Added inital oracle schema.

http://dive4elements.wald.intevation.org