PageRenderTime 17ms CodeModel.GetById 12ms app.highlight 3ms RepoModel.GetById 1ms app.codeStats 0ms

/apps/wiki/sql/003_session.sql

http://zoop.googlecode.com/
SQL | 18 lines | 15 code | 3 blank | 0 comment | 0 complexity | 65a7292df2d560052d65f6c43ff2c8da MD5 | raw file
 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;