amoraclecreate.sql revision 0a99555401a033704f1f171baab6db11fb5528f2
create table SCHEMANAME.sunwam_session
expiration_time number not null,
sessionstate number not null,
create index SCHEMANAME.sunwam_session_exp_time on SCHEMANAME.sunwam_session(expiration_time) tablespace TABLESPCNAME;
create index SCHEMANAME.sunwam_session_uuid on SCHEMANAME.sunwam_session(uuid) tablespace TABLESPCNAME;
create index SCHEMANAME.sunwam_session_sessionstate on SCHEMANAME.sunwam_session(sessionstate) tablespace TABLESPCNAME;
create table SCHEMANAME.sunwam_session_ext
blob_chunk_seq number not null,
expiration_time number not null,
create index SCHEMANAME.sunwam_session_ext_exp_time on SCHEMANAME.sunwam_session_ext(expiration_time) tablespace TABLESPCNAME;
exit;