Mercurial > gemma

comparison schema/gemma.sql @ 1194:7db850de0952

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added a signer who makes the final decison on an import. Generate a log entry when the final decison is made.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Sun, 18 Nov 2018 18:29:25 +0100
parents 58acc343b1b6
children 9f7dc950ffd2
comparison
equal deleted inserted replaced
1193:58acc343b1b6 1194:7db850de0952
525 state waterway.import_state NOT NULL DEFAULT 'queued', 525 state waterway.import_state NOT NULL DEFAULT 'queued',
526 enqueued timestamp NOT NULL DEFAULT now(), 526 enqueued timestamp NOT NULL DEFAULT now(),
527 kind varchar NOT NULL, 527 kind varchar NOT NULL,
528 username varchar NOT NULL 528 username varchar NOT NULL
529 REFERENCES internal.user_profiles(username) 529 REFERENCES internal.user_profiles(username)
530 ON DELETE CASCADE ON UPDATE CASCADE, 530 ON DELETE CASCADE
531 ON UPDATE CASCADE,
532 signer varchar
533 REFERENCES internal.user_profiles(username)
534 ON DELETE SET NULL
535 ON UPDATE CASCADE,
531 data TEXT 536 data TEXT
532 ); 537 );
533 538
534 CREATE INDEX enqueued_idx ON waterway.imports(enqueued, state); 539 CREATE INDEX enqueued_idx ON waterway.imports(enqueued, state);
535 540
572 LANGUAGE plpgsql; 577 LANGUAGE plpgsql;
573 578
574 CREATE TRIGGER delete_import AFTER DELETE ON waterway.track_imports 579 CREATE TRIGGER delete_import AFTER DELETE ON waterway.track_imports
575 FOR EACH ROW EXECUTE PROCEDURE waterway.del_import(); 580 FOR EACH ROW EXECUTE PROCEDURE waterway.del_import();
576 581
577
578
579 COMMIT; 582 COMMIT;