/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. 

  2. 

  3. CREATE TABLE session_base
    4. 

  4. (
    5. 

  5. 	session_id text NOT NULL PRIMARY KEY,
    6. 

  6. 	last_active timestamp with time zone NOT NULL
    7. 

  7. );
    8. 

  8. 

  9. CREATE TABLE session_data
    10. 

  10. (
    11. 

  11. 	session_id text NOT NULL,
    12. 

  12. 	key text,
    13. 

  13. 	value text,
    14. 

  14. 	PRIMARY KEY (session_id, key)
    15. 

  15. );
    16. 

  16. 

  17. commit;
    18.