Mercurial > gemma

comparison schema/gemma.sql @ 1168:930fdd8b474f

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Track successfull imports in a separate table to be able to remove them later.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 14 Nov 2018 12:23:10 +0100
parents dd4071019676
children c3955e3db074
comparison
equal deleted inserted replaced
1167:1ae93a0438df 1168:930fdd8b474f
537 time timestamp NOT NULL DEFAULT now(), 537 time timestamp NOT NULL DEFAULT now(),
538 kind waterway.log_type NOT NULL DEFAULT 'info', 538 kind waterway.log_type NOT NULL DEFAULT 'info',
539 msg TEXT NOT NULL 539 msg TEXT NOT NULL
540 ); 540 );
541 541
542 CREATE TABLE waterway.track_imports (
543 import_id int NOT NULL REFERENCES waterway.imports(id),
544 relation regclass NOT NULL,
545 key int NOT NULL,
546 UNIQUE (relation, key)
547 );
548
542 COMMIT; 549 COMMIT;