/apps/wiki/sql/003_session.sql

 1begin;
 2
 3CREATE TABLE session_base
 4(
 5  session_id text NOT NULL,
 6  last_active timestamp with time zone NOT NULL,
 7  CONSTRAINT session_base_pkey PRIMARY KEY (session_id)
 8);
 9
10CREATE TABLE session_data
11(
12  session_id text NOT NULL references session_base,
13  "key" text NOT NULL,
14  "value" text,
15  CONSTRAINT session_data_pkey PRIMARY KEY (session_id, key)
16);
17
18commit;