diff options
Diffstat (limited to 'sql/dawn.sql')
| -rw-r--r-- | sql/dawn.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 79d811e4..d6740c0d 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -342,7 +342,7 @@ ON cds FOR EACH ROW EXECUTE PROCEDURE update_attach(); CREATE TABLE repos ( - id int4 NOT NULL DEFAULT nextval('repos_temp_id_seq'::regclass), + id int4 NOT NULL DEFAULT nextval('repos_id_seq'::regclass), dealid varchar(28) NULL GENERATED ALWAYS AS ((('SCREPO'::text || id::text))) STORED, "fund" fund NOT NULL, lastupdate timestamptz NULL DEFAULT now(), @@ -369,8 +369,8 @@ CREATE TABLE repos ( daycount day_count NULL, ticket varchar NULL, open_repo bool NULL, - CONSTRAINT repos_temp_pkey PRIMARY KEY (id), - CONSTRAINT repos_temp_cp_code_fkey FOREIGN KEY (cp_code) REFERENCES public.counterparties(code) + CONSTRAINT repos_pkey PRIMARY KEY (id), + CONSTRAINT repos_cp_code_fkey FOREIGN KEY (cp_code) REFERENCES public.counterparties(code) ); |