diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/serenitasdb.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql index e69f239f..f740c30b 100644 --- a/sql/serenitasdb.sql +++ b/sql/serenitasdb.sql @@ -36,8 +36,10 @@ CREATE TABLE index_version( lastdate date DEFAULT 'infinity',
redindexcode text,
description text,
- PRIMARY KEY(BasketID)
+ PRIMARY KEY(BasketID),
+ UNIQUE (index, series, version)
);
+
CREATE TYPE INDEXFAMILY AS ENUM('ITRAXX-Asian', 'LCDXNA', 'MCDXNA',
'ITRAXX-SOVX', 'ITRAXX-SDI', 'ITRAXX-L', 'CDX', 'ITRAXX-European');
|