aboutsummaryrefslogtreecommitdiffstats
path: root/sql/serenitasdb.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/serenitasdb.sql')
-rw-r--r--sql/serenitasdb.sql14
1 files changed, 7 insertions, 7 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql
index f5867554..4fdd41ce 100644
--- a/sql/serenitasdb.sql
+++ b/sql/serenitasdb.sql
@@ -1234,11 +1234,11 @@ CREATE TABLE dtcc_corrections(
dissemination_id bigint,
correction bytea)
-CREATE TABLE public.markit_quote_details (
- id serial4 NOT NULL,
- quotedate timestamptz NULL,
- quote_source varchar(4) NULL,
- msg_id int8 NULL,
- CONSTRAINT markit_quote_details_msg_id_key UNIQUE (msg_id),
- CONSTRAINT markit_quote_details_pkey PRIMARY KEY (id)
+CREATE TABLE markit_quote_details (
+ id serial primary key,
+ quotetime timestamptz NULL,
+ quote_source varchar(4) NULL,
+ msg_id int8 NULL,
+ sender text NULL,
+ CONSTRAINT markit_quote_details_unique UNIQUE (msg_id)
); \ No newline at end of file