-- H2 0.5/B --
-- H2 0.5/B --
-- H2 0.5/B --
TW h TW h ${ t (!#&KOFF,0,,E9'!#'KOFF,0,,E3%!# LOFF,0,,dE0# #(KOFF,0,,]0,1,2,3,4,5,6,7,8,9,10,11 )KOFF,0,,K0,1,2,3 x x f u C<
Z ( !
<CREATE INDEX PUBLIC.USERS_UNIQUEID ON PUBLIC.USERS(UNIQUEID)' !
6CREATE INDEX PUBLIC.USERS_EMAIL ON PUBLIC.USERS(EMAIL)& %
bALTER TABLE PUBLIC.USERS ADD CONSTRAINT PUBLIC.USERS_PK PRIMARY KEY(ID) INDEX PUBLIC.PRIMARY_KEY_4% !
;CREATE PRIMARY KEY PUBLIC.PRIMARY_KEY_4 ON PUBLIC.USERS(ID)#
CREATE CACHED TABLE PUBLIC.USERS(
ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_A95C7BEC_D88D_45AB_9544_8D06F2FE4AB5) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_A95C7BEC_D88D_45AB_9544_8D06F2FE4AB5,
FIRSTNAME VARCHAR(32),
LASTNAME VARCHAR(32),
EMAIL VARCHAR(48),
LOCALE VARCHAR(16),
TIMEZONE VARCHAR(32),
PASSWORD_PW VARCHAR(48),
PASSWORD_SLT VARCHAR(20),
TEXTAREA VARCHAR(2048),
UNIQUEID VARCHAR(32),
SUPERUSER BOOLEAN,
VALIDATED BOOLEAN
)$ #
iCREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_A95C7BEC_D88D_45AB_9544_8D06F2FE4AB5 START WITH 1 BELONGS_TO_TABLE" "
2CREATE USER IF NOT EXISTS "" SALT '' HASH '' ADMIN! &XSET CREATE_BUILD 147