Added regids table and some sample reqid data

2 files changed, 58 insertions, 0 deletions

diff --git a/testing/hosts/default/etc/pts/data.sql b/testing/hosts/default/etc/pts/data.sql
index 35fd65753..a6ea8f83e 100644
--- a/testing/hosts/default/etc/pts/data.sql
+++ b/testing/hosts/default/etc/pts/data.sql
@@ -844,3 +844,52 @@ 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/testing/hosts/default/etc/pts/tables.sql b/testing/hosts/default/etc/pts/tables.sql
index 4cc959e09..85db3188a 100644
--- a/testing/hosts/default/etc/pts/tables.sql
+++ b/testing/hosts/default/etc/pts/tables.sql
@@ -232,3 +232,12 @@ 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
+);