diff options
author | Andreas Steffen <andreas.steffen@strongswan.org> | 2014-04-04 23:00:40 +0200 |
---|---|---|
committer | Andreas Steffen <andreas.steffen@strongswan.org> | 2014-04-15 09:21:05 +0200 |
commit | 4894bfa2279c861b863464418cad66c07bfa13e2 (patch) | |
tree | 1d6011275acc4f708264a517843f70e06b4c4d5e /src/libimcv/imv/tables.sql | |
parent | 0bd64fa5bf7495ea6329971abd4ed70a5828b8ef (diff) | |
download | strongswan-4894bfa2279c861b863464418cad66c07bfa13e2.tar.bz2 strongswan-4894bfa2279c861b863464418cad66c07bfa13e2.tar.xz |
Separated IMV session management from IMV policy database
Diffstat (limited to 'src/libimcv/imv/tables.sql')
-rw-r--r-- | src/libimcv/imv/tables.sql | 30 |
1 files changed, 2 insertions, 28 deletions
diff --git a/src/libimcv/imv/tables.sql b/src/libimcv/imv/tables.sql index a0f3a4e8d..45ae78cc9 100644 --- a/src/libimcv/imv/tables.sql +++ b/src/libimcv/imv/tables.sql @@ -42,27 +42,11 @@ CREATE TABLE file_hashes ( id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, file INTEGER NOT NULL REFERENCES files(id), product INTEGER NOT NULL REFERENCES products(id), - device INTEGER DEFAULT 0, - key INTEGER DEFAULT 0 REFERENCES keys(id), + device INTEGER DEFAULT 0 REFERENCES devices(id), algo INTEGER NOT NULL REFERENCES algorithms(id), hash BLOB NOT NULL ); -DROP TABLE IF EXISTS keys; -CREATE TABLE keys ( - id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - keyid BLOB NOT NULL, - owner TEXT NOT NULL -); -DROP INDEX IF EXISTS keys_keyid; -CREATE INDEX keys_keyid ON keys ( - keyid -); -DROP INDEX IF EXISTS keys_owner; -CREATE INDEX keys_owner ON keys ( - owner -); - DROP TABLE IF EXISTS groups; CREATE TABLE groups ( id INTEGER NOT NULL PRIMARY KEY, @@ -159,17 +143,6 @@ CREATE TABLE components ( qualifier INTEGER DEFAULT 0 ); - -DROP TABLE IF EXISTS key_component; -CREATE TABLE key_component ( - key INTEGER NOT NULL, - component INTEGER NOT NULL, - depth INTEGER DEFAULT 0, - seq_no INTEGER DEFAULT 0, - PRIMARY KEY (key, component) -); - - DROP TABLE IF EXISTS component_hashes; CREATE TABLE component_hashes ( component INTEGER NOT NULL, @@ -217,6 +190,7 @@ CREATE TABLE devices ( description TEXT DEFAULT '', value TEXT NOT NULL, product INTEGER REFERENCES products(id), + trusted INTEGER DEFAULT 0, created INTEGER ); DROP INDEX IF EXISTS devices_id; |