diff options
Diffstat (limited to 'src/libimcv/imv/tables.sql')
| -rw-r--r-- | src/libimcv/imv/tables.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/src/libimcv/imv/tables.sql b/src/libimcv/imv/tables.sql index 4cc959e09..6b8522dc5 100644 --- a/src/libimcv/imv/tables.sql +++ b/src/libimcv/imv/tables.sql @@ -232,3 +232,14 @@ CREATE TABLE identities ( UNIQUE (type, value) ); +DROP TABLE IF EXISTS regids; +CREATE TABLE regids ( + id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + name TEXT NOT NULL +); +DROP INDEX IF EXISTS regids_name; +CREATE INDEX regids_name ON regids ( + name +); + + |