CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE MEMORY TABLE CUI_TERMS(CUI BIGINT,RINDEX INTEGER,TCOUNT INTEGER,TEXT VARCHAR(255),RWORD VARCHAR(48))
CREATE INDEX IDX_CUI_TERMS ON CUI_TERMS(RWORD)
CREATE MEMORY TABLE TUI(CUI BIGINT,TUI INTEGER)
CREATE INDEX IDX_TUI ON TUI(CUI)
CREATE MEMORY TABLE SNOMEDCT(CUI BIGINT,SNOMEDCT BIGINT)
CREATE INDEX IDX_SNOMEDCT ON SNOMEDCT(CUI)
CREATE MEMORY TABLE RXNORM(CUI BIGINT,RXNORM BIGINT)
CREATE INDEX IDX_RXNORM ON RXNORM(CUI)
CREATE MEMORY TABLE ICD9CM(CUI BIGINT,ICD9CM VARCHAR(48))
CREATE INDEX IDX_ICD9CM ON ICD9CM(CUI)
CREATE MEMORY TABLE ICD10PCS(CUI BIGINT,ICD10PCS VARCHAR(48))
CREATE INDEX IDX_ICD10PCS ON ICD10PCS(CUI)
CREATE MEMORY TABLE PREFTERM(CUI BIGINT,PREFTERM VARCHAR(255))
CREATE INDEX IDX_PREFTERM ON PREFTERM(CUI)
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 10