log
graph
tags
bookmarks
branches
changeset
browse
file
diff
comparison
annotate
file log
raw
help
Mercurial
>
dive4elements
>
river
log flys-backend/doc/schema/postgresql-minfo.sql @ 5613:
9e2a43bbe515
Find changesets by keywords (author, files, the commit message), revision number or hash, or
revset expression
.
less
more
|
(0)
tip
age
author
description
2013-03-28
Tom Gottfried
Schema change: add shore offset to sediment density values and be more rigid with input files in parser
2013-03-28
Tom Gottfried
Schema change: make sq_relation_value.qmax NOT NULL and more informative messages in parser
2013-03-27
Tom Gottfried
Schema Change: removed constraint that did not allow to have more than one measurement_type per station
2013-03-27
Tom Gottfried
backout r5460 to be compatible with r5471 and Oracle database
2013-03-27
Tom Gottfried
Schema Change: rename measurement_station.description to comment to fit rest of the code
2013-03-27
Tom Gottfried
Schema corrected: measurement_station.reference_gauge_station is not needed
2013-03-27
Tom Gottfried
Schema Change: use parameter instead of fraction in sq_relation_value
2013-03-27
Tom Gottfried
store name and km of reference gauges in measurement_stations too, as not all are in gauges
2013-03-27
Tom Gottfried
SCHEMA CHANGE: fixed constraints in MINFO and removed obsolete column
2013-03-26
Tom Gottfried
remove unit from sediment density and depths (always t/m3 respectively cm, otherwise a typo)
2013-03-26
Raimund Renkert
SCHEMA CHANGE! Renamed columns in sq_relation and sq_relation_value.
2013-03-25
Tom Gottfried
SCHEMA CHANGE: additional columns and FK constraint for SQ-relation
2013-03-15
Tom Gottfried
SCHEMA CHANGE: removed bad triggers and foreign keys from schema
2013-03-13
Tom Gottfried
SCHEMA CHANGE: lookup table for floodmaps and source-field added, Importer adapted to new directory names
2013-03-13
Tom Gottfried
additional values in lookup table for bed height types
2013-03-13
Sascha L. Teichmann
Use lookup table from bedd_height from database in importer.
2013-03-08
Andre Heinecke
SCHEME CHANGE: Add measurement_station to oracle table and rename comment column
2013-03-08
Tom Gottfried
SCHEMA CHANGE: removed Waterlevel and WaterleveDifferences, added lookup table for wst
2013-02-14
Tom Gottfried
SCHEMA CHANGE: added 'ON DELETE CASCADE' where necessary to delete complete rivers (only in Postgres-Schema so far)
dami
2012-11-14
Raimund Renkert
Added new column 'year' to sediment density values in postgresql and oracle
2012-10-22
Ingo Weinzierl
Adapted DB schema (added relation measurement_station); improved importer to read files from filesystem with measurement stations.
2012-09-27
Felix Wolfsteller
Towards fix for issue863 (gaps in bedheight data).
2012-09-11
Sascha L. Teichmann
FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync.
2012-04-27
Sascha L. Teichmann
Adjusted PostgreSQL port of MINFO schema to match Oracle one.
2012-04-13
Sascha L. Teichmann
Add MINFO schema for PostgreSQL
less
more
|
(0)
tip
http://dive4elements.wald.intevation.org