diff options
Diffstat (limited to 'src/libimcv')
-rw-r--r-- | src/libimcv/imv/data.sql | 51 | ||||
-rw-r--r-- | src/libimcv/imv/tables.sql | 11 |
2 files changed, 62 insertions, 0 deletions
diff --git a/src/libimcv/imv/data.sql b/src/libimcv/imv/data.sql index 35fd65753..7b5995aa0 100644 --- a/src/libimcv/imv/data.sql +++ b/src/libimcv/imv/data.sql @@ -844,3 +844,54 @@ INSERT INTO enforcements ( 15, 9, 0 ); +/* regids */ + +INSERT INTO regids ( /* 1 */ + name +) VALUES ( + 'regid.1986-12.com.adobe' +); + +INSERT INTO regids ( /* 2 */ + name +) VALUES ( + 'regid.1991-06.com.microsoft' +); + +INSERT INTO regids ( /* 3 */ + name +) VALUES ( + 'regid.2004-05.com.ubuntu' +); + +INSERT INTO regids ( /* 4 */ + name +) VALUES ( + 'regid.1995-04.org.apache' +); + +INSERT INTO regids ( /* 5 */ + name +) VALUES ( + 'regid.1999-03.org.debian' +); + +INSERT INTO regids ( /* 6 */ + name +) VALUES ( + 'regid.1994-04.org.isc' +); + +INSERT INTO regids ( /* 7 */ + name +) VALUES ( + 'regid.2002-08.org.sqlite' +); + +INSERT INTO regids ( /* 8 */ + name +) VALUES ( + 'regid.2004-03.org.strongswan' +); + + 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 +); + + |