/framework/core/session/init.sql

http://zoop.googlecode.com/ · SQL · 17 lines · 14 code · 3 blank · 0 comment · 0 complexity · b8d22892b4bcebee92b9aa07faf0f673 MD5 · raw file

  1. begin;
  2. CREATE TABLE session_base
  3. (
  4. session_id text NOT NULL PRIMARY KEY,
  5. last_active timestamp with time zone NOT NULL
  6. );
  7. CREATE TABLE session_data
  8. (
  9. session_id text NOT NULL,
  10. key text,
  11. value text,
  12. PRIMARY KEY (session_id, key)
  13. );
  14. commit;