Extended the Length of Some DB Fields

[holmes/rule-management.git] / rulemgt-standalone / src / main / assembly / dbscripts / postgresql / onap-holmes_rulemgt-createobj.sql

diff --git a/rulemgt-standalone/src/main/assembly/dbscripts/postgresql/onap-holmes_rulemgt-createobj.sql b/rulemgt-standalone/src/main/assembly/dbscripts/postgresql/onap-holmes_rulemgt-createobj.sql
index 87dd3a7..090734c 100644 (file)
--- a/rulemgt-standalone/src/main/assembly/dbscripts/postgresql/onap-holmes_rulemgt-createobj.sql
+++ b/rulemgt-standalone/src/main/assembly/dbscripts/postgresql/onap-holmes_rulemgt-createobj.sql
@@ -41,8 +41,9 @@ CREATE TABLE APLUS_RULE (
   UPDATOR VARCHAR(20)  NULL,
   UPDATETIME TIMESTAMP NULL,
   PARAMS VARCHAR(4000) NULL,
-  CONTENT VARCHAR(4000) NOT NULL,
+  CONTENT VARCHAR(20000) NOT NULL,
   VENDOR VARCHAR(100)  NOT NULL,
+  ENGINEINSTANCE VARCHAR(100) NOT NULL,
   PACKAGE VARCHAR(255) NULL,
   PRIMARY KEY (RID),
   UNIQUE (NAME)