Mercurial > gemma

comparison schema/gemma.sql @ 1906:32c56e6c089a

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Stretch import: Added forgotten source file.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Fri, 18 Jan 2019 17:13:12 +0100
parents d72a1539ef3c
children f538d9a23329
comparison
equal deleted inserted replaced
1904:931b15be6d7f 1906:32c56e6c089a
362 staging_done boolean NOT NULL DEFAULT false, 362 staging_done boolean NOT NULL DEFAULT false,
363 UNIQUE(name, staging_done) 363 UNIQUE(name, staging_done)
364 ) 364 )
365 365
366 CREATE TABLE stretch_countries ( 366 CREATE TABLE stretch_countries (
367 stretches_id int NOT NULL REFERENCES stretches(id), 367 stretches_id int NOT NULL REFERENCES stretches(id)
368 ON DELETE CASCADE,
368 country_code char(2) NOT NULL REFERENCES countries(country_code), 369 country_code char(2) NOT NULL REFERENCES countries(country_code),
369 UNIQUE(stretches_id, country_code) 370 UNIQUE(stretches_id, country_code)
370 ) 371 )
371 372
372 CREATE TRIGGER sections_stretches_date_info 373 CREATE TRIGGER sections_stretches_date_info