File: session-create-oracle.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 (37 lines) | stat: -rw-r--r-- 882 bytes parent folder | download | duplicates (5) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
 
-- 
--  Session management database creation for Oracle
-- 
--  Arnulf 
--
CREATE TABLE rivet_session
    (ip_address                     VARCHAR2(23) DEFAULT NULL,
    session_start_time             DATE DEFAULT NULL,
    session_update_time            DATE DEFAULT NULL,
    session_id                     VARCHAR2(50) NOT NULL
    )
/

ALTER TABLE rivet_session ADD PRIMARY KEY (session_id)

/

CREATE TABLE rivet_session_cache
    (session_id                     VARCHAR2(50) DEFAULT NULL,
    package_                       VARCHAR2(100) DEFAULT NULL,
    key_                           VARCHAR2(50) DEFAULT NULL,
    data                           VARCHAR2(255) DEFAULT NULL
  )
/

CREATE UNIQUE INDEX riv_sess_cache_ix ON rivet_session_cache
  (
    session_id,
    package_,
    key_
  )
/

CREATE INDEX rivet_session_cache_idx ON rivet_session_cache
  (
    session_id
  )