SET WRITE_DELAY 0;
SET CLUSTER '';
SET DEFAULT_TABLE_TYPE 0;
SET DEFAULT_LOCK_TIMEOUT 2000;
SET CACHE_SIZE 16384;
CREATE USER IF NOT EXISTS SA SALT 'f8752c85c729c186' HASH '883ecfdc106537ace2e018d70b96f50779fcc98fad6150910f3890ac568d9292' ADMIN;
DROP TABLE IF EXISTS PUBLIC.USERTABLE;

CREATE CACHED TABLE PUBLIC.USERTABLE(
    ID BIGINT NOT NULL,
    NAME VARCHAR(50),
    AGE INTEGER,
    BIRTH TIMESTAMP
);
-- 0 = SELECT COUNT(*) FROM PUBLIC.USERTABLE;
CREATE INDEX PUBLIC.IDX_USERTABLE ON PUBLIC.USERTABLE(ID);