CREATE SCHEMA SIM
SET SCHEMA = SIM
CREATE TABLE CIMOM_INFO (ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1) PRIMARY KEY,CIMOM_TYPE INTEGER, DETAILS VARCHAR(30),URL VARCHAR(100),INTOP_NS VARCHAR(30),USERID VARCHAR(30),PWDID VARCHAR(30))
CREATE TABLE NS_INFO (ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1) PRIMARY KEY,CIMOM_INFO_ID	INTEGER,	NAMESPACE	VARCHAR(30),CONSTRAINT	FK2 FOREIGN KEY (CIMOM_INFO_ID) REFERENCES CIMOM_INFO (ID) ON DELETE CASCADE)
CREATE TABLE CIM_CLASS (ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1) PRIMARY KEY,NS_INFO_ID	INTEGER,	CLASS_NAME	VARCHAR(100),CONSTRAINT	FK3 FOREIGN KEY (NS_INFO_ID) REFERENCES NS_INFO (ID) ON DELETE CASCADE)
CREATE TABLE CIM_DATA (ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1) PRIMARY KEY,CIM_CLASS_ID	INTEGER,	CIM_OP		BLOB(3K),	CIM_INST		BLOB(10K),CONSTRAINT	FK4 FOREIGN KEY (CIM_CLASS_ID) REFERENCES CIM_CLASS (ID) ON DELETE CASCADE)
