0a99555401a033704f1f171baab6db11fb5528f2Allan Fostercreate table SCHEMANAME.sunwam_session
0a99555401a033704f1f171baab6db11fb5528f2Allan Foster (id varchar2(100) not null primary key,
0a99555401a033704f1f171baab6db11fb5528f2Allan Foster blob_chunk LONG RAW,
0a99555401a033704f1f171baab6db11fb5528f2Allan Foster blob_size number not null,
0a99555401a033704f1f171baab6db11fb5528f2Allan Foster expiration_time number not null,
0a99555401a033704f1f171baab6db11fb5528f2Allan Foster uuid varchar2(256) not null,
0a99555401a033704f1f171baab6db11fb5528f2Allan Foster sessionstate number not null,
0a99555401a033704f1f171baab6db11fb5528f2Allan Foster version number default 1 not null
0a99555401a033704f1f171baab6db11fb5528f2Allan Foster) tablespace TABLESPCNAME;
0a99555401a033704f1f171baab6db11fb5528f2Allan Foster
0a99555401a033704f1f171baab6db11fb5528f2Allan Fostercreate index SCHEMANAME.sunwam_session_exp_time on SCHEMANAME.sunwam_session(expiration_time) tablespace TABLESPCNAME;
0a99555401a033704f1f171baab6db11fb5528f2Allan Fostercreate index SCHEMANAME.sunwam_session_uuid on SCHEMANAME.sunwam_session(uuid) tablespace TABLESPCNAME;
0a99555401a033704f1f171baab6db11fb5528f2Allan Fostercreate index SCHEMANAME.sunwam_session_sessionstate on SCHEMANAME.sunwam_session(sessionstate) tablespace TABLESPCNAME;
0a99555401a033704f1f171baab6db11fb5528f2Allan Foster
0a99555401a033704f1f171baab6db11fb5528f2Allan Fostercreate table SCHEMANAME.sunwam_session_ext
0a99555401a033704f1f171baab6db11fb5528f2Allan Foster (id varchar2(100) not null,
0a99555401a033704f1f171baab6db11fb5528f2Allan Foster blob_chunk_seq number not null,
0a99555401a033704f1f171baab6db11fb5528f2Allan Foster blob_chunk LONG RAW,
0a99555401a033704f1f171baab6db11fb5528f2Allan Foster expiration_time number not null,
0a99555401a033704f1f171baab6db11fb5528f2Allan Foster primary key(id,blob_chunk_seq)
0a99555401a033704f1f171baab6db11fb5528f2Allan Foster) tablespace TABLESPCNAME;
0a99555401a033704f1f171baab6db11fb5528f2Allan Foster
0a99555401a033704f1f171baab6db11fb5528f2Allan Fostercreate index SCHEMANAME.sunwam_session_ext_exp_time on SCHEMANAME.sunwam_session_ext(expiration_time) tablespace TABLESPCNAME;
0a99555401a033704f1f171baab6db11fb5528f2Allan Foster
0a99555401a033704f1f171baab6db11fb5528f2Allan Fosterexit;