| 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
|
| Thu, 23 May 2013 17:32:20 +0200 |
Tom Gottfried |
Schema change: view for WSTs which deales with multiple ranges matching station (issues 1315 and 1296)
|
| Thu, 16 May 2013 16:14:28 +0200 |
Tom Gottfried |
Schema change: Add missing constraints to cross sections in Oracle, cosmetics
|
| Mon, 13 May 2013 18:21:55 +0200 |
Tom Gottfried |
backout 6009:6ea171b6d8d2 because this was only really valid for fixations
|
| Mon, 13 May 2013 17:48:32 +0200 |
Tom Gottfried |
Schema change because WST-columns without time interval are useless
|
| Wed, 08 May 2013 13:16:29 +0200 |
Tom Gottfried |
Schema change: leave it up to AFT whether time intervals are unique per gauge but do not accept duplicate bfg_id per gauge
|
| Tue, 07 May 2013 18:19:57 +0200 |
Tom Gottfried |
Schema change: named_main_values.name is not unique, as we can have the same name for different types
|
| Fri, 03 May 2013 13:15:28 +0200 |
Tom Gottfried |
Schema change: increased precision of discharge_table_values.q to allow unique import of higher precision values
|
| Fri, 03 May 2013 10:31:34 +0200 |
Tom Gottfried |
Schema change: make gauges.official_number unique per river as we can have multiple identical gauges for different representations of the same river. Comments and TODOs
|
| Fri, 03 May 2013 07:47:15 +0200 |
Tom Gottfried |
Schema change: remove UNIQUE-constraint from rivers.official number as we have different representations of the same river (e.g. for sommer and winter)
|
| Tue, 30 Apr 2013 12:53:10 +0200 |
Tom Gottfried |
Schema change: add constraint to discharge tables
|
| Thu, 25 Apr 2013 15:23:37 +0200 |
Sascha L. Teichmann |
Rename modules to more fitting names.
base
flys-backend/doc/schema/oracle.sql@0f65d3fc30c0
|
