diff options
Diffstat (limited to 'schema.sql')
| -rw-r--r-- | schema.sql | 8 |
1 files changed, 5 insertions, 3 deletions
@@ -63,8 +63,6 @@ CREATE TEMPORARY TABLE IF NOT EXISTS object ( object_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, object_handle INTEGER NOT NULL UNIQUE CHECK (object_handle > 0 AND object_handle <= 0xFFFFFFFF), - hal_pkey_type INTEGER, - hal_pkey_ski BLOB, session_id INTEGER REFERENCES session ON DELETE CASCADE ON UPDATE CASCADE DEFERRABLE INITIALLY DEFERRED, @@ -79,6 +77,8 @@ CREATE TEMPORARY TABLE IF NOT EXISTS object ( CREATE TEMPORARY TABLE IF NOT EXISTS session_object ( session_object_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, + hal_pkey_type INTEGER, + hal_pkey_ski BLOB, object_id INTEGER NOT NULL UNIQUE REFERENCES object ON DELETE CASCADE ON UPDATE CASCADE @@ -94,7 +94,9 @@ CREATE TEMPORARY TABLE IF NOT EXISTS session_attribute ( ); CREATE TABLE IF NOT EXISTS token_object ( - token_object_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL + token_object_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, + hal_pkey_type INTEGER, + hal_pkey_ski BLOB ); CREATE TABLE IF NOT EXISTS token_attribute ( |