Schema

CREATE BUFFERPOOL bp_32k PAGESIZE 32 K;

CREATE TABLESPACE ts_sessio_dat

PAGESIZE 32 K

BUFFERPOOL bp_32k;

CREATE TABLESPACE ts_sessio_idx;

CREATE TABLESPACE ts_sessio_lob

PAGESIZE 32 K

BUFFERPOOL bp_32k

FILE SYSTEM CACHING;

CREATE SEQUENCE sessions.id

CYCLE

CACHE 2000;

CREATE TABLE sessions.sessio

(

id INTEGER NOT NULL,

session_id VARCHAR(60) NOT NULL,

principal_name VARCHAR(120),

max_inactive_seconds INTEGER,

created_timestamp TIMESTAMP NOT NULL,

last_access_timestamp TIMESTAMP,

deleted_timestamp TIMESTAMP,

is_deleted BOOLEAN NOT NULL DEFAULT FALSE

)

ORGANIZE BY ROW

IN ts_sessio_dat INDEX IN ts_sessio_idx;

ALTER TABLE sessions.sessio

VOLATILE;

CREATE UNIQUE INDEX sessions.sessio_pk ON sessions.sessio(id RANDOM);

CREATE UNIQUE INDEX sessions.sessio_ix01 ON sessions.sessio(session_id RANDOM) INCLUDE (id, is_deleted);

ALTER TABLE sessions.sessio

ADD CONSTRAINT sessio_pk PRIMARY KEY (id);

ALTER TABLE sessions.sessio

ADD CONSTRAINT sessio_uk1 UNIQUE (session_id);

CREATE TABLE sessions.sesprp

(

id INTEGER NOT NULL,

property_id VARCHAR(200) NOT NULL,

object BLOB(2097152) INLINE LENGTH 32000

)

ORGANIZE BY ROW

IN ts_sessio_dat INDEX IN ts_sessio_idx LONG IN ts_sessio_lob;

ALTER TABLE sessions.sesprp

VOLATILE;

CREATE UNIQUE INDEX sessions.sesprp_pk ON sessions.sesprp(id, property_id)

CLUSTER;

ALTER TABLE sessions.sesprp

ADD CONSTRAINT sesprp_pk PRIMARY KEY (id, property_id);