File: session-create-postgresql.sql

package info (click to toggle)
libapache2-mod-rivet 3.2.2-1
  • links: PTS
  • area: main
  • in suites: bookworm
  • size: 6,296 kB
  • sloc: xml: 8,554; tcl: 7,568; ansic: 7,094; sh: 5,017; makefile: 195; sql: 91; lisp: 78
file content (26 lines) | stat: -rw-r--r-- 597 bytes parent folder | download | duplicates (4) 
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
 
--
-- Define SQL tables for session management code (Postgresql)
--
-- $Id$
--
--

create table rivet_session(
    ip_address		    inet,
    session_start_time	timestamp,
    session_update_time	timestamp,
    session_id		    varchar,

    UNIQUE( session_id )
);

create table rivet_session_cache(
    session_id		    varchar REFERENCES rivet_session(session_id) ON DELETE CASCADE,
    package_		    varchar,
    key_                varchar,
    data                varchar,

    UNIQUE( session_id, package_, key_ )
);
create index rivet_session_cache_idx ON rivet_session_cache( session_id );