diff options
Diffstat (limited to 'sql/dawn.sql')
| -rw-r--r-- | sql/dawn.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 3ae12fbc..f7c7da1b 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -2048,5 +2048,6 @@ create table id_mapping( trade_type text not null, serenitas_id int not null, globeop_id int not null, - full_globeop_id text GENERATED ALWAYS AS (trade_type||lpad(globeop_id::text, 6, '0')|| 'K00SCLMA') stored + full_globeop_id text GENERATED ALWAYS AS (trade_type||lpad(globeop_id::text, 6, '0')|| 'K00SCLMA') stored, + PRIMARY KEY (date, trade_type, serenitas_id) ); |