File: session-create-sqlite.sql

package info (click to toggle)
libapache2-mod-rivet 2.3.3-1
  • links: PTS
  • area: main
  • in suites: stretch
  • size: 5,156 kB
  • ctags: 1,093
  • sloc: xml: 7,696; tcl: 6,939; ansic: 5,682; sh: 4,862; makefile: 199; sql: 91; lisp: 78
file content (17 lines) | stat: -rw-r--r-- 787 bytes parent folder | download | duplicates (4) 
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_ );