aboutsummaryrefslogtreecommitdiffstats
path: root/src
diff options
context:
space:
mode:
Diffstat (limited to 'src')
-rw-r--r--src/libimcv/imv/data.sql51
-rw-r--r--src/libimcv/imv/tables.sql11
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
+);
+
+