Mercurial > gemma

comparison schema/gemma.sql @ 2999:b3c3c5b5b7c1

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Bottleneck import: Import riverbed materials, too.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 10 Apr 2019 16:44:30 +0200
parents 23ff7f6c543b
children 92818da6133d
comparison
equal deleted inserted replaced
2998:adc8e9ccf706 2999:b3c3c5b5b7c1
545 ) 545 )
546 CREATE TRIGGER bottleneck_date_info BEFORE UPDATE ON bottlenecks 546 CREATE TRIGGER bottleneck_date_info BEFORE UPDATE ON bottlenecks
547 FOR EACH ROW EXECUTE PROCEDURE update_date_info() 547 FOR EACH ROW EXECUTE PROCEDURE update_date_info()
548 548
549 CREATE TABLE bottlenecks_riverbed_materials ( 549 CREATE TABLE bottlenecks_riverbed_materials (
550 bottleneck_id int NOT NULL REFERENCES bottlenecks(id), 550 bottleneck_id int NOT NULL REFERENCES bottlenecks(id)
551 ON DELETE CASCADE,
551 riverbed varchar NOT NULL REFERENCES riverbed_materials, 552 riverbed varchar NOT NULL REFERENCES riverbed_materials,
552 -- XXX: should be 'natsur' according to IENC Encoding Guide M.4.3 553 -- XXX: should be 'natsur' according to IENC Encoding Guide M.4.3
553 PRIMARY KEY (bottleneck_id, riverbed) 554 PRIMARY KEY (bottleneck_id, riverbed)
554 ) 555 )
555 556