/apps/wiki/sql/003_session.sql
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;