Mercurial > gemma
comparison schema/gemma.sql @ 1194:7db850de0952
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; |