Mercurial > gemma

comparison schema/gemma.sql @ 2042:d29ac997eb34 unify_imports

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
This breaks this branch!!!! Starting to remove the old persistent layer for configured imports.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Fri, 25 Jan 2019 16:07:09 +0100
parents 59055c8301df
children 62312bc16bf1
comparison
equal deleted inserted replaced
2041:d61ca2b3fc12 2042:d29ac997eb34
628 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, 628 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
629 username varchar NOT NULL 629 username varchar NOT NULL
630 REFERENCES internal.user_profiles(username) 630 REFERENCES internal.user_profiles(username)
631 ON DELETE CASCADE 631 ON DELETE CASCADE
632 ON UPDATE CASCADE, 632 ON UPDATE CASCADE,
633 kind varchar NOT NULL, 633 kind varchar NOT NULL
634 send_email boolean NOT NULL DEFAULT false,
635 cron varchar,
636 url varchar
637 ) 634 )
638 635
639 CREATE TABLE import_configuration_attributes ( 636 CREATE TABLE import_configuration_attributes (
640 import_configuration_id int NOT NULL 637 import_configuration_id int NOT NULL
641 REFERENCES import_configuration(id) 638 REFERENCES import_configuration(id)