X-Git-Url: https://git.strongswan.org/?p=strongswan.git;a=blobdiff_plain;f=src%2Flibpts%2Fplugins%2Fimv_attestation%2Ftables.sql;h=564914e786f8174f1df416f4a414a95aafd88964;hp=6a1df8e0cffd2e8dfb7a52c2e732814c91b36f8e;hb=86a6f698cbb86a72d7a0d3c60f38a1d00f5e9377;hpb=eeefca6b563d75d0f7d0fa66607afe0f62f4cd9f

diff --git a/src/libpts/plugins/imv_attestation/tables.sql b/src/libpts/plugins/imv_attestation/tables.sql
index 6a1df8e..564914e 100644
--- a/src/libpts/plugins/imv_attestation/tables.sql
+++ b/src/libpts/plugins/imv_attestation/tables.sql
@@ -39,7 +39,7 @@ CREATE TABLE product_component (
   product INTEGER NOT NULL,
   component INTEGER NOT NULL,
   depth INTEGER DEFAULT 0,
-  sequence INTEGER DEFAULT 0,
+  seq_no INTEGER DEFAULT 0,
   PRIMARY KEY (product, component)
 );
 
@@ -48,8 +48,18 @@ CREATE TABLE file_hashes (
   file INTEGER NOT NULL,
   directory INTEGER DEFAULT 0,
   product INTEGER NOT NULL,
-  component INTEGER DEFAULT 0,
   algo INTEGER NOT NULL,
   hash BLOB NOT NULL,
-  PRIMARY KEY(file, directory, product, component, algo)
+  PRIMARY KEY(file, directory, product, algo)
+);
+
+DROP TABLE IF EXISTS component_hashes;
+CREATE TABLE component_hashes (
+  component INTEGER NOT NULL,
+  product INTEGER NOT NULL,
+  seq_no INTEGER NOT NULL,
+  pcr INTEGER NOT NULL,
+  algo INTEGER NOT NULL,
+  hash BLOB NOT NULL,
+  PRIMARY KEY(component, product, seq_no, algo)
 );