PageRenderTime 48ms CodeModel.GetById 44ms app.highlight 2ms RepoModel.GetById 1ms app.codeStats 0ms

/framework/core/session/init.sql

http://zoop.googlecode.com/
SQL | 17 lines | 14 code | 3 blank | 0 comment | 0 complexity | b8d22892b4bcebee92b9aa07faf0f673 MD5 | raw file
 1begin;
 2
 3CREATE TABLE session_base
 4(
 5	session_id text NOT NULL PRIMARY KEY,
 6	last_active timestamp with time zone NOT NULL
 7);
 8
 9CREATE TABLE session_data
10(
11	session_id text NOT NULL,
12	key text,
13	value text,
14	PRIMARY KEY (session_id, key)
15);
16
17commit;