dive4elements/river: flys-backend/doc/schema/postgresql.sql history

age	author	description
2013-03-15	Tom Gottfried	SCHEMA CHANGE: removed bad triggers and foreign keys from schema
2013-03-14	Tom Gottfried	trigger sequence of time_interval IDs in DB as it is not used by hibernate only anymore
2013-03-14	Tom Gottfried	trigger sequence of range IDs in DB as it is not used by hibernate only anymore
2013-03-08	Tom Gottfried	corrected constraints on table gauges
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
2013-01-05	Sascha L. Teichmann	!!! FLYS backend schema change !!! Add column bfg_id column to discharge_tables.
2012-12-06	Sascha L. Teichmann	Added view for selecting ranges in wsts.
2012-09-22	Sascha L. Teichmann	Backend: Added 'official_number' column to rivers table to model the 'Bundeswasserstrassen Identnummer'.
2012-09-12	Sascha L. Teichmann	FLYS backend: Fixed postgresql scheme.
2012-07-18	Felix Wolfsteller	Adjusted official lines views schemata to include wst column pos.
2012-07-11	Sascha L. Teichmann	Backend: Added DB indices for fasten access to cross section points.
2012-06-29	Sascha L. Teichmann	Backend: Added views to access the 'Amtlichen Linien'.
2012-01-02	Sascha L. Teichmann	Removed "NOT NULL" constraint from gauges.range_id because there are gauges which dont have a Gueltigkeitsbereich.
2011-12-19	Sascha L. Teichmann	Added support for official gauge numbers.

Mercurial > dive4elements > river