/usr/lib/tcltk/rivet2.2/packages/session/session-create-sqlite.sql is in libapache2-mod-rivet 2.2.4-1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | CREATE TABLE rivet_session (
ip_address varchar(16) default NULL,
session_start_time varchar(24) default NULL,
session_update_time varchar(24) default NULL,
session_id varchar(64) NOT NULL default '',
PRIMARY KEY (session_id)
);
CREATE TABLE rivet_session_cache (
session_id varchar(128) default NULL PRIMARY KEY ON CONFLICT FAIL,
package_ varchar(64) default NULL,
key_ varchar(128) default NULL,
data varchar(255) default NULL,
-- KEY rivet_session_cache_idx (session_id),
CONSTRAINT session_cleanup FOREIGN KEY (session_id) REFERENCES rivet_session(session_id) ON DELETE CASCADE
);
CREATE UNIQUE INDEX rvt_sess_cache_idx ON rivet_session_cache ( session_id, package_, key_ );
|