diff options
| author | Andreas Steffen <andreas.steffen@strongswan.org> | 2013-09-02 11:59:42 +0200 |
|---|---|---|
| committer | Andreas Steffen <andreas.steffen@strongswan.org> | 2013-09-02 12:00:47 +0200 |
| commit | 86f00e6afff482cee601538a15883fc8cee23fd5 (patch) | |
| tree | 89006785ed2e8c4630751fbe62f999100e642d40 /testing | |
| parent | 6fc5cc003d03c11263d24c8c42bca5e6b73fed39 (diff) | |
| download | strongswan-86f00e6afff482cee601538a15883fc8cee23fd5.tar.bz2 strongswan-86f00e6afff482cee601538a15883fc8cee23fd5.tar.xz | |
Added regids table and some sample reqid data
Diffstat (limited to 'testing')
| -rw-r--r-- | testing/hosts/default/etc/pts/data.sql | 49 | ||||
| -rw-r--r-- | testing/hosts/default/etc/pts/tables.sql | 9 | ||||
| -rw-r--r-- | testing/tests/tnc/tnccs-20-pt-tls/hosts/alice/etc/pts/data.sql | 49 |
3 files changed, 107 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 +); diff --git a/testing/tests/tnc/tnccs-20-pt-tls/hosts/alice/etc/pts/data.sql b/testing/tests/tnc/tnccs-20-pt-tls/hosts/alice/etc/pts/data.sql index edae71d84..2049b9003 100644 --- a/testing/tests/tnc/tnccs-20-pt-tls/hosts/alice/etc/pts/data.sql +++ b/testing/tests/tnc/tnccs-20-pt-tls/hosts/alice/etc/pts/data.sql @@ -914,3 +914,52 @@ INSERT INTO enforcements ( 18, 10, 86400 ); +/* 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' +); |