Mercurial > gemma

comparison wamos.sql @ 47:a03ff9076969

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Delivered by interface for other uses than WAMOS.
author Tom Gottfried <tom@intevation.de>
date Mon, 07 May 2018 22:46:39 +0200
parents 9106e1510244
children 6185e4780017
comparison
equal deleted inserted replaced
46:9106e1510244 47:a03ff9076969
105 -- different model approach? 105 -- different model approach?
106 depth_reference char(3) NOT NULL REFERENCES depth_references, 106 depth_reference char(3) NOT NULL REFERENCES depth_references,
107 -- XXX: Also an attribut of sounding result? 107 -- XXX: Also an attribut of sounding result?
108 date_info timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 108 date_info timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
109 source_organization varchar NOT NULL, 109 source_organization varchar NOT NULL,
110 additional_data xml -- XXX: What is that really for? 110 -- additional_data xml -- Currently not relevant for WAMOS
111 ); 111 );
112 CREATE TRIGGER bottleneck_date_info BEFORE UPDATE ON bottlenecks 112 CREATE TRIGGER bottleneck_date_info BEFORE UPDATE ON bottlenecks
113 FOR EACH ROW EXECUTE PROCEDURE update_date_info(); 113 FOR EACH ROW EXECUTE PROCEDURE update_date_info();
114 114
115 CREATE TABLE bottlenecks_riverbed_materials ( 115 CREATE TABLE bottlenecks_riverbed_materials (