From d45aacaf71afbd352909f02876b86e62744fcae8 Mon Sep 17 00:00:00 2001 From: "Rishi.Chail" Date: Thu, 21 Jan 2021 17:18:17 +0000 Subject: Remove Module Table Issue-ID: CPS-185 Signed-off-by: Rishi.Chail Change-Id: Id93b3ec4dec27184bc46767146d9801063f54916 --- cps-ri/src/main/resources/schema.sql | 14 +------------- 1 file changed, 1 insertion(+), 13 deletions(-) diff --git a/cps-ri/src/main/resources/schema.sql b/cps-ri/src/main/resources/schema.sql index d37d932aa..2735ca489 100755 --- a/cps-ri/src/main/resources/schema.sql +++ b/cps-ri/src/main/resources/schema.sql @@ -42,17 +42,6 @@ CREATE TABLE IF NOT EXISTS SCHEMA_SET_YANG_RESOURCES CONSTRAINT SCHEMA_SET_RESOURCE FOREIGN KEY (SCHEMA_SET_ID) REFERENCES SCHEMA_SET(ID) ON DELETE CASCADE ); -CREATE TABLE IF NOT EXISTS MODULE -( - ID SERIAL PRIMARY KEY, - NAMESPACE TEXT NOT NULL, - REVISION TEXT NOT NULL, - MODULE_CONTENT TEXT NOT NULL, - DATASPACE_ID BIGINT NOT NULL, - UNIQUE (DATASPACE_ID, NAMESPACE, REVISION), - CONSTRAINT MODULE_DATASPACE FOREIGN KEY (DATASPACE_ID) REFERENCES DATASPACE (id) ON UPDATE CASCADE ON DELETE CASCADE -); - CREATE TABLE IF NOT EXISTS ANCHOR ( ID BIGSERIAL PRIMARY KEY, @@ -93,5 +82,4 @@ CREATE INDEX IF NOT EXISTS "FKI_SCHEMA_NODE_ID_TO_ID" ON FRAGMENT USING CREATE INDEX IF NOT EXISTS "FKI_RELATION_TYPE_ID_FK" ON RELATION USING BTREE(RELATION_TYPE_ID); CREATE INDEX IF NOT EXISTS "FKI_RELATIONS_FROM_ID_FK" ON RELATION USING BTREE(FROM_FRAGMENT_ID); CREATE INDEX IF NOT EXISTS "FKI_RELATIONS_TO_ID_FK" ON RELATION USING BTREE(TO_FRAGMENT_ID); -CREATE INDEX IF NOT EXISTS "PERF_MODULE_MODULE_CONTENT" ON MODULE USING BTREE(MODULE_CONTENT); -CREATE UNIQUE INDEX IF NOT EXISTS "UQ_FRAGMENT_XPATH"ON FRAGMENT USING btree(xpath COLLATE pg_catalog."default" text_pattern_ops, dataspace_id); +CREATE UNIQUE INDEX IF NOT EXISTS "UQ_FRAGMENT_XPATH"ON FRAGMENT USING btree(xpath COLLATE pg_catalog."default" text_pattern_ops, dataspace_id); \ No newline at end of file -- cgit 1.2.3-korg