0a99555401a033704f1f171baab6db11fb5528f2Allan Fosterset autocommit on;
0a99555401a033704f1f171baab6db11fb5528f2Allan Fostercreate table sunwam_session (
0a99555401a033704f1f171baab6db11fb5528f2Allan Foster id varchar(100) not null primary key,
0a99555401a033704f1f171baab6db11fb5528f2Allan Foster blob_chunk varbinary(7800),
0a99555401a033704f1f171baab6db11fb5528f2Allan Foster blob_size integer not null,
0a99555401a033704f1f171baab6db11fb5528f2Allan Foster expiration_time double integer not null,
0a99555401a033704f1f171baab6db11fb5528f2Allan Foster uuid varchar(256) not null,
0a99555401a033704f1f171baab6db11fb5528f2Allan Foster sessionstate integer not null,
0a99555401a033704f1f171baab6db11fb5528f2Allan Foster version integer not null default 1
0a99555401a033704f1f171baab6db11fb5528f2Allan Foster );
0a99555401a033704f1f171baab6db11fb5528f2Allan Fostercreate index sunwam_session_id on sunwam_session(id);
0a99555401a033704f1f171baab6db11fb5528f2Allan Fostercreate index sunwam_session_exp_time on sunwam_session(expiration_time);
0a99555401a033704f1f171baab6db11fb5528f2Allan Fostercreate index sunwam_session_uuid on sunwam_session(uuid);
0a99555401a033704f1f171baab6db11fb5528f2Allan Fostercreate index sunwam_session_sessionstate on sunwam_session(sessionstate);
0a99555401a033704f1f171baab6db11fb5528f2Allan Foster
0a99555401a033704f1f171baab6db11fb5528f2Allan Fostercreate table sunwam_session_ext (
0a99555401a033704f1f171baab6db11fb5528f2Allan Foster id varchar(100) not null,
0a99555401a033704f1f171baab6db11fb5528f2Allan Foster blob_chunk_seq integer not null,
0a99555401a033704f1f171baab6db11fb5528f2Allan Foster blob_chunk varbinary(7800),
0a99555401a033704f1f171baab6db11fb5528f2Allan Foster expiration_time double integer not null,
0a99555401a033704f1f171baab6db11fb5528f2Allan Foster primary key(id,blob_chunk_seq)
0a99555401a033704f1f171baab6db11fb5528f2Allan Foster );
0a99555401a033704f1f171baab6db11fb5528f2Allan Fostercreate index sunwam_session_ext_id on sunwam_session_ext(id);
0a99555401a033704f1f171baab6db11fb5528f2Allan Fostercreate index sunwam_session_ext_exp_time on sunwam_session_ext(expiration_time);