diff options
Diffstat (limited to 'src/libimcv/imv/data.sql')
-rw-r--r-- | src/libimcv/imv/data.sql | 345 |
1 files changed, 225 insertions, 120 deletions
diff --git a/src/libimcv/imv/data.sql b/src/libimcv/imv/data.sql index 7f3bae813..b45cad487 100644 --- a/src/libimcv/imv/data.sql +++ b/src/libimcv/imv/data.sql @@ -216,6 +216,96 @@ INSERT INTO products ( /* 36 */ 'Ubuntu 14.04 x86_64' ); +INSERT INTO products ( /* 37 */ + name +) VALUES ( + 'Debian 7.3 i686' +); + +INSERT INTO products ( /* 38 */ + name +) VALUES ( + 'Debian 7.3 x86_64' +); + +INSERT INTO products ( /* 39 */ + name +) VALUES ( + 'Debian 7.4 i686' +); + +INSERT INTO products ( /* 40 */ + name +) VALUES ( + 'Debian 7.4 x86_64' +); + +INSERT INTO products ( /* 41 */ + name +) VALUES ( + 'Debian 7.5 i686' +); + +INSERT INTO products ( /* 42 */ + name +) VALUES ( + 'Debian 7.5 x86_64' +); + +INSERT INTO products ( /* 43 */ + name +) VALUES ( + 'Debian 7.0 armv6l' +); + +INSERT INTO products ( /* 44 */ + name +) VALUES ( + 'Debian 7.1 armv6l' +); + +INSERT INTO products ( /* 45 */ + name +) VALUES ( + 'Debian 7.2 armv6l' +); + +INSERT INTO products ( /* 46 */ + name +) VALUES ( + 'Debian 7.3 armv6l' +); + +INSERT INTO products ( /* 47 */ + name +) VALUES ( + 'Debian 7.4 armv6l' +); + +INSERT INTO products ( /* 48 */ + name +) VALUES ( + 'Debian 7.5 armv6l' +); + +INSERT INTO products ( /* 49 */ + name +) VALUES ( + 'Android 4.3' +); + +INSERT INTO products ( /* 50 */ + name +) VALUES ( + 'Android 4.4.3' +); + +INSERT INTO products ( /* 51 */ + name +) VALUES ( + 'Android 4.4.4' +); + /* Directories */ INSERT INTO directories ( /* 1 */ @@ -345,12 +435,6 @@ INSERT INTO files ( /* 6 */ INSERT INTO algorithms ( id, name ) VALUES ( - 65536, 'SHA1-IMA' -); - -INSERT INTO algorithms ( - id, name -) VALUES ( 32768, 'SHA1' ); @@ -531,27 +615,27 @@ INSERT INTO versions ( /* Components */ INSERT INTO components ( - vendor_id, name, qualifier + vendor_id, name, qualifier, label ) VALUES ( - 36906, 1, 33 /* ITA TGRUB */ + 36906, 1, 33, 'G' /* ITA TGRUB */ ); INSERT INTO components ( - vendor_id, name, qualifier + vendor_id, name, qualifier, label ) VALUES ( - 36906, 2, 33 /* ITA TBOOT */ + 36906, 2, 33, 'T' /* ITA TBOOT */ ); INSERT INTO components ( - vendor_id, name, qualifier + vendor_id, name, qualifier, label ) VALUES ( - 36906, 3, 33 /* ITA IMA - Trusted Platform */ + 36906, 3, 33, 'B' /* ITA IMA - Trusted Platform */ ); INSERT INTO components ( - vendor_id, name, qualifier + vendor_id, name, qualifier, label ) VALUES ( - 36906, 3, 34 /* ITA IMA - Operating System */ + 36906, 3, 34, 'I' /* ITA IMA - Operating System */ ); /* Groups */ @@ -634,6 +718,12 @@ INSERT INTO groups ( /* 13 */ 'TPM BIOS/IMA' ); +INSERT INTO groups ( /* 14 */ + name, parent +) VALUES ( + 'Debian armv6l', 2 +); + /* Default Product Groups */ INSERT INTO groups_product_defaults ( @@ -669,6 +759,24 @@ INSERT INTO groups_product_defaults ( INSERT INTO groups_product_defaults ( group_id, product_id ) VALUES ( + 4, 37 +); + +INSERT INTO groups_product_defaults ( + group_id, product_id +) VALUES ( + 4, 39 +); + +INSERT INTO groups_product_defaults ( + group_id, product_id +) VALUES ( + 4, 41 +); + +INSERT INTO groups_product_defaults ( + group_id, product_id +) VALUES ( 5, 2 ); @@ -699,6 +807,24 @@ INSERT INTO groups_product_defaults ( INSERT INTO groups_product_defaults ( group_id, product_id ) VALUES ( + 5, 38 +); + +INSERT INTO groups_product_defaults ( + group_id, product_id +) VALUES ( + 5, 40 +); + +INSERT INTO groups_product_defaults ( + group_id, product_id +) VALUES ( + 5, 42 +); + +INSERT INTO groups_product_defaults ( + group_id, product_id +) VALUES ( 6, 9 ); @@ -846,6 +972,60 @@ INSERT INTO groups_product_defaults ( 3, 34 ); +INSERT INTO groups_product_defaults ( + group_id, product_id +) VALUES ( + 3, 49 +); + +INSERT INTO groups_product_defaults ( + group_id, product_id +) VALUES ( + 3, 50 +); + +INSERT INTO groups_product_defaults ( + group_id, product_id +) VALUES ( + 3, 51 +); + +INSERT INTO groups_product_defaults ( + group_id, product_id +) VALUES ( + 14, 43 +); + +INSERT INTO groups_product_defaults ( + group_id, product_id +) VALUES ( + 14, 44 +); + +INSERT INTO groups_product_defaults ( + group_id, product_id +) VALUES ( + 14, 45 +); + +INSERT INTO groups_product_defaults ( + group_id, product_id +) VALUES ( + 14, 46 +); + +INSERT INTO groups_product_defaults ( + group_id, product_id +) VALUES ( + 14, 47 +); + +INSERT INTO groups_product_defaults ( + group_id, product_id +) VALUES ( + 14, 48 +); + /* Policies */ INSERT INTO policies ( /* 1 */ @@ -1078,139 +1258,64 @@ INSERT INTO enforcements ( /* 17 */ 21, 13, 60 ); -/* regids */ +/* swid_entities */ -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.1998-12.org.openssl' -); - -INSERT INTO regids ( /* 8 */ - name -) VALUES ( - 'regid.1998-01.org.samba' -); - -INSERT INTO regids ( /* 9 */ - name -) VALUES ( - 'regid.2002-08.org.sqlite' -); - -INSERT INTO regids ( /* 10 */ - name -) VALUES ( - 'regid.2004-03.org.strongswan' -); - -/* Tags */ - -INSERT INTO tags ( - regid, unique_sw_id -) VALUES ( - 2, 'Windows-8-Pro' -); - -INSERT INTO tags ( - regid, unique_sw_id -) VALUES ( - 5, 'apache-2-2-22-13' -); - -INSERT INTO tags ( - regid, unique_sw_id +INSERT INTO "swid_entities" ( /* 1 */ + "name", "regid" ) VALUES ( - 5, 'bind-9-8-4-dfsg' + 'strongSwan Project', 'regid.2004-03.org.strongswan' ); -INSERT INTO tags ( - regid, unique_sw_id +INSERT INTO swid_entities ( /* 2 */ + "name", "regid" ) VALUES ( - 5, 'libsqlite-3-7-13-1' + 'Adobe Systems Inc.', 'regid.1986-12.com.adobe' ); -INSERT INTO tags ( - regid, unique_sw_id +INSERT INTO swid_entities ( /* 3 */ + "name", "regid" ) VALUES ( - 5, 'libssl-1-0-1e-2' + 'Microsoft Corporation', 'regid.1991-06.com.microsoft' ); -INSERT INTO tags ( - regid, unique_sw_id +INSERT INTO swid_entities ( /* 4 */ + "name", "regid" ) VALUES ( - 5, 'libssl-dev-1-0-1e-2' + 'Ubuntu Project', 'regid.2004-05.com.ubuntu' ); -INSERT INTO tags ( - regid, unique_sw_id +INSERT INTO swid_entities ( /* 5 */ + "name", "regid" ) VALUES ( - 5, 'libssl-doc-1-0-1e-2' + 'Apache Software Foundation', 'regid.1995-04.org.apache' ); -INSERT INTO tags ( - regid, unique_sw_id +INSERT INTO swid_entities ( /* 6 */ + "name", "regid" ) VALUES ( - 5, 'openssl-1-0-1e-2' + 'Debian Project', 'regid.1999-03.org.debian' ); -INSERT INTO tags ( - regid, unique_sw_id +INSERT INTO swid_entities ( /* 7 */ + "name", "regid" ) VALUES ( - 5, 'smbclient-3-6-6-6' + 'Internet Systems Consortium', 'regid.1994-04.org.isc' ); -INSERT INTO tags ( - regid, unique_sw_id +INSERT INTO swid_entities ( /* 8 */ + "name", "regid" ) VALUES ( - 5, 'sqlite-3-7-13-1' + 'OpenSSL Project', 'regid.1998-12.org.openssl' ); -INSERT INTO tags ( - regid, unique_sw_id +INSERT INTO swid_entities ( /* 9 */ + "name", "regid" ) VALUES ( - 10, 'strongSwan-5-1-1' + 'Samba Project', 'regid.1998-01.org.samba' ); -INSERT INTO tags ( - regid, unique_sw_id +INSERT INTO swid_entities ( /* 10 */ + "name", "regid" ) VALUES ( - 10, 'strongSwan-5-1-2' + 'SQLite Project', 'regid.2002-08.org.sqlite' ); - |