Artifact 051fddcb1385e8c54dc70784b1b4b0bccd639265:

• File sessions.sql — part of check-in [d3abae2d97] at 2011-05-15 20:43:16 on branch trunk — Initial check in after moving from http://www.kiatoa.com/fossils/opensrc (user: matt, size: 178) [annotate] [blame] [check-ins using]

0000: 43 52 45 41 54 45 20 54 41 42 4c 45 20 73 65 73  CREATE TABLE ses
0010: 73 69 6f 6e 5f 76 61 72 73 20 28 69 64 20 69 6e  sion_vars (id in
0020: 74 65 67 65 72 20 70 72 69 6d 61 72 79 20 6b 65  teger primary ke
0030: 79 2c 20 20 73 65 73 73 69 6f 6e 5f 69 64 20 69  y,  session_id i
0040: 6e 74 65 67 65 72 2c 20 70 61 67 65 20 74 65 78  nteger, page tex
0050: 74 2c 20 6b 65 79 20 74 65 78 74 2c 20 76 61 6c  t, key text, val
0060: 75 65 20 74 65 78 74 29 3b 0a 0a 43 52 45 41 54  ue text);..CREAT
0070: 45 20 54 41 42 4c 45 20 73 65 73 73 69 6f 6e 73  E TABLE sessions
0080: 20 28 20 69 64 20 69 6e 74 65 67 65 72 20 70 72   ( id integer pr
0090: 69 6d 61 72 79 20 6b 65 79 2c 20 73 65 73 73 69  imary key, sessi
00a0: 6f 6e 5f 6b 65 79 20 74 65 78 74 29 3b 20 0a 09  on_key text); ..
00b0: 0a 0a                                            ..