aboutsummaryrefslogtreecommitdiff
path: root/src/stasis/stasis-0001.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/stasis/stasis-0001.sql')
-rw-r--r--src/stasis/stasis-0001.sql5
1 files changed, 4 insertions, 1 deletions
diff --git a/src/stasis/stasis-0001.sql b/src/stasis/stasis-0001.sql
index de2762a..e3c9c5c 100644
--- a/src/stasis/stasis-0001.sql
+++ b/src/stasis/stasis-0001.sql
@@ -1,6 +1,6 @@
1-- 1--
2-- This file is part of Anastasis 2-- This file is part of Anastasis
3-- Copyright (C) 2020, 2021 Anastasis SARL SA 3-- Copyright (C) 2020, 2021, 2022 Anastasis SARL SA
4-- 4--
5-- ANASTASIS is free software; you can redistribute it and/or modify it under the 5-- ANASTASIS is free software; you can redistribute it and/or modify it under the
6-- terms of the GNU General Public License as published by the Free Software 6-- terms of the GNU General Public License as published by the Free Software
@@ -140,6 +140,7 @@ CREATE TABLE IF NOT EXISTS anastasis_recoverydocument
140 account_sig BYTEA NOT NULL CHECK(LENGTH(account_sig)=64), 140 account_sig BYTEA NOT NULL CHECK(LENGTH(account_sig)=64),
141 recovery_data_hash BYTEA NOT NULL CHECK(length(recovery_data_hash)=64), 141 recovery_data_hash BYTEA NOT NULL CHECK(length(recovery_data_hash)=64),
142 recovery_data BYTEA NOT NULL, 142 recovery_data BYTEA NOT NULL,
143 recovery_meta_data BYTEA DEFAULT NULL,
143 PRIMARY KEY (user_id, version)); 144 PRIMARY KEY (user_id, version));
144COMMENT ON TABLE anastasis_recoverydocument 145COMMENT ON TABLE anastasis_recoverydocument
145 IS 'Stores a recovery document which contains the policy and the encrypted core secret'; 146 IS 'Stores a recovery document which contains the policy and the encrypted core secret';
@@ -153,6 +154,8 @@ COMMENT ON COLUMN anastasis_recoverydocument.recovery_data_hash
153 IS 'Hash of the recovery document to prevent unnecessary uploads'; 154 IS 'Hash of the recovery document to prevent unnecessary uploads';
154COMMENT ON COLUMN anastasis_recoverydocument.recovery_data 155COMMENT ON COLUMN anastasis_recoverydocument.recovery_data
155 IS 'Contains the encrypted policy and core secret'; 156 IS 'Contains the encrypted policy and core secret';
157COMMENT ON COLUMN anastasis_recoverydocument.recovery_meta_data
158 IS 'Contains an encrypted human-readable and sometimes user-generated description of the backup';
156 159
157 160
158CREATE TABLE IF NOT EXISTS anastasis_challengecode 161CREATE TABLE IF NOT EXISTS anastasis_challengecode