Code Review
/
holmes
/
rule-management.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
review
|
tree
raw
|
inline
| side by side
Allocate Rule
[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
cbd3c59
..
feaacd6
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
@@
-13,22
+13,19
@@
-- See the License for the specific language governing permissions and
-- limitations under the License.
--
-- See the License for the specific language governing permissions and
-- limitations under the License.
--
-/******************drop old database and user***************************/
-\c postgres;
-
-DROP DATABASE IF EXISTS holmes;
-
-DROP ROLE IF EXISTS holmes;
+\c postgres
/******************CREATE NEW DATABASE AND USER***************************/
/******************CREATE NEW DATABASE AND USER***************************/
-CREATE DATABASE
holmes
;
+CREATE DATABASE
DBNAME
;
-CREATE ROLE
holmes with PASSWORD 'holmespwd
' LOGIN;
+CREATE ROLE
DBUSER with PASSWORD 'DBPWD
' LOGIN;
\encoding UTF8;
/******************DELETE OLD TABLE AND CREATE NEW***************************/
\encoding UTF8;
/******************DELETE OLD TABLE AND CREATE NEW***************************/
-\c holmes;
+\c DBNAME;
+
+DROP TABLE IF EXISTS APLUS_RULE;
CREATE TABLE APLUS_RULE (
RID VARCHAR(30) NOT NULL,
CREATE TABLE APLUS_RULE (
RID VARCHAR(30) NOT NULL,
@@
-46,6
+43,7
@@
CREATE TABLE APLUS_RULE (
PARAMS VARCHAR(4000) NULL,
CONTENT VARCHAR(4000) NOT NULL,
VENDOR VARCHAR(100) NOT NULL,
PARAMS VARCHAR(4000) NULL,
CONTENT VARCHAR(4000) NOT NULL,
VENDOR VARCHAR(100) NOT NULL,
+ ENGINEINSTANCE VARCHAR(100) NOT NULL,
PACKAGE VARCHAR(255) NULL,
PRIMARY KEY (RID),
UNIQUE (NAME)
PACKAGE VARCHAR(255) NULL,
PRIMARY KEY (RID),
UNIQUE (NAME)
@@
-58,5
+56,5
@@
CREATE INDEX IDX_APLUS_RULE_TEMPLATEID ON APLUS_RULE (TEMPLATEID);
CREATE INDEX IDX_APLUS_RULE_ENGINEID ON APLUS_RULE (ENGINEID);
CREATE INDEX IDX_APLUS_RULE_ENGINETYPE ON APLUS_RULE (ENGINETYPE);
CREATE INDEX IDX_APLUS_RULE_ENGINEID ON APLUS_RULE (ENGINEID);
CREATE INDEX IDX_APLUS_RULE_ENGINETYPE ON APLUS_RULE (ENGINETYPE);
-GRANT ALL PRIVILEGES ON APLUS_RULE TO
holmes
;
+GRANT ALL PRIVILEGES ON APLUS_RULE TO
DBUSER
;