Mercurial > gemma
comparison schema/gemma.sql @ 1975:d966f03ea819
Imports: Added the new state 'unchanged' which can be issued by the imports to indicate that the database is not modified by the particular imports.
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Wed, 23 Jan 2019 11:20:14 +0100 |
| parents | f7a35ba9f409 |
| children | f9f1babe52ae |
comparison
equal
deleted
inserted
replaced
| 1966:da6dc9b73f34 | 1975:d966f03ea819 |
|---|---|
| 627 | 627 |
| 628 -- | 628 -- |
| 629 -- Import queue and respective logging | 629 -- Import queue and respective logging |
| 630 -- | 630 -- |
| 631 CREATE TYPE waterway.import_state AS ENUM ( | 631 CREATE TYPE waterway.import_state AS ENUM ( |
| 632 'queued', 'running', 'failed', | 632 'queued', |
| 633 'pending', 'accepted', 'declined' | 633 'running', |
| 634 'failed', 'unchanged', 'pending', | |
| 635 'accepted', 'declined' | |
| 634 ); | 636 ); |
| 635 | 637 |
| 636 CREATE TABLE waterway.imports ( | 638 CREATE TABLE waterway.imports ( |
| 637 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, | 639 id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, |
| 638 state waterway.import_state NOT NULL DEFAULT 'queued', | 640 state waterway.import_state NOT NULL DEFAULT 'queued', |