Mercurial > gemma

comparison schema/gemma.sql @ 1392:0e1d89241cda

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Imports: An Import (e.g. a sounding result import) can now write a 'summary' of a successful import. This is done if the import switches to to state 'pending'.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 28 Nov 2018 09:52:34 +0100
parents ac6aa40005b4
children 1e19184472bf
comparison
equal deleted inserted replaced
1391:801ae5f4bc5b 1392:0e1d89241cda
545 ON UPDATE CASCADE, 545 ON UPDATE CASCADE,
546 signer varchar 546 signer varchar
547 REFERENCES internal.user_profiles(username) 547 REFERENCES internal.user_profiles(username)
548 ON DELETE SET NULL 548 ON DELETE SET NULL
549 ON UPDATE CASCADE, 549 ON UPDATE CASCADE,
550 data TEXT 550 data TEXT,
551 summary TEXT
551 ); 552 );
552 553
553 CREATE INDEX enqueued_idx ON waterway.imports(enqueued, state); 554 CREATE INDEX enqueued_idx ON waterway.imports(enqueued, state);
554 555
555 CREATE TYPE waterway.log_type AS ENUM ('info', 'warn', 'error'); 556 CREATE TYPE waterway.log_type AS ENUM ('info', 'warn', 'error');