Make CPS/NCMP upgradeable - cps

diff options

author	lukegleeson <luke.gleeson@est.tech>	2022-10-04 16:07:37 +0100
committer	lukegleeson <luke.gleeson@est.tech>	2022-10-05 16:19:03 +0100
commit	984d1f2d90fee958d545da6924c3628f87fac840 (patch)
tree	9f3c7cfc54d0e2fc54a56c8d93dcd0dae6d088f3 /cps-ri/src/main/resources/changelog/db/changes/16-insert-cm-handle-state-rollback.sql
parent	4bd450e1d48a24a1617906932c1de8d727bd7a40 (diff)

Make CPS/NCMP upgradeable

Liquibase step to add CM Handle Advised state to existing CM Handles Issue-ID: CPS-1312 Signed-off-by: lukegleeson <luke.gleeson@est.tech> Change-Id: I8077e66c64946f6ce092daa96ee40cd935fe0b72

Diffstat (limited to 'cps-ri/src/main/resources/changelog/db/changes/16-insert-cm-handle-state-rollback.sql')

-rw-r--r--

cps-ri/src/main/resources/changelog/db/changes/16-insert-cm-handle-state-rollback.sql

1 files changed, 4 insertions, 0 deletions

USE authz; // Create 'org' root NS INSERT INTO ns (name,description,parent,scope,type) VALUES('org','Root Namespace','.',1,1); INSERT INTO role(ns, name, perms, description) VALUES('org','admin',{'org.access|*|*'},'Org Admins'); INSERT INTO role(ns, name, perms, description) VALUES('org','owner',{'org.access|*|read,approve'},'Org Owners'); INSERT INTO perm(ns, type, instance, action, roles, description) VALUES ('org','access','*','read,approve',{'org.owner'},'Org Read Access'); INSERT INTO perm(ns, type, instance, action, roles, description) VALUES ('org','access','*','*',{'org.admin'},'Org Write Access'); // Create org.osaaf INSERT INTO ns (name,description,parent,scope,type) VALUES('org.osaaf','OSAAF Namespace','org',2,2); INSERT INTO role(ns, name, perms,description) VALUES('org.osaaf','admin',{'org.osaaf.access|*|*'},'OSAAF Admins'); INSERT INTO perm(ns, type, instance, action, roles,description) VALUES ('org.osaaf','access','*','*',{'org.osaaf.admin'},'OSAAF Write Access'); INSERT INTO role(ns, name, perms,description) VALUES('org.osaaf','owner',{'org.osaaf.access|*|read,approve'},'OSAAF Owners'); INSERT INTO perm(ns, type, instance, action, roles,description) VALUES ('org.osaaf','access','*','read,appove',{'org.osaaf.owner'},'OSAAF Read Access'); // Create org.osaaf.aaf INSERT INTO ns (name,description,parent,scope,type) VALUES('org.osaaf.aaf','Application Authorization Framework','org.osaaf',3,3); INSERT INTO role(ns, name, perms, description) VALUES('org.osaaf.aaf','admin',{'org.osaaf.aaf.access|*|*'},'AAF Admins'); INSERT INTO perm(ns, type, instance, action, roles, description) VALUES ('org.osaaf.aaf','access','*','*',{'org.osaaf.aaf.admin'},'AAF Write Access'); INSERT INTO perm(ns, type, instance, action, roles, description) VALUES ('org.osaaf.aaf','access','*','read,approve',{'org.osaaf.aaf.owner'},'AAF Read Access'); INSERT INTO role(ns, name, perms, description) VALUES('org.osaaf.aaf','owner',{'org.osaaf.aaf.access|*|read,approve'},'AAF Owners'); // OSAAF Root INSERT INTO user_role(user,role,expires,ns,rname) VALUES ('aaf@aaf.osaaf.org','org.admin','2018-10-31','org','admin'); INSERT INTO user_role(user,role,expires,ns,rname) VALUES ('aaf@aaf.osaaf.org','org.osaaf.aaf.admin','2018-10-31','org.osaaf.aaf','admin'); // ONAP Specific Entities // ONAP initial env Namespace INSERT INTO ns (name,description,parent,scope,type) VALUES('org.onap','ONAP','org',2,2); INSERT INTO ns (name,description,parent,scope,type) VALUES('org.onap.portal','ONAP Portal','org.onap.portal',3,3); INSERT INTO perm(ns, type, instance, action, roles, description) VALUES ('org.onap.portal','access','*','read',{ 'org.onap.portal.owner','org.onap.portal.designer','org.onap.portal.tester','org.onap.portal.ops','org.onap.portal.governor' },'Portal Read Access'); INSERT INTO role(ns, name, perms, description) VALUES('org.onap.portal','owner',{'org.onap.portal.access|*|read'},'Portal Owner'); INSERT INTO perm(ns, type, instance, action, roles, description) VALUES ('org.onap.portal','access','*','*',{'org.onap.portal.admin'},'Portal Write Access'); INSERT INTO role(ns, name, perms, description) VALUES('org.onap.portal','admin',{'org.onap.portal.access|*|*'},'Portal Admins'); // AAF Admin insert into cred (id,type,expires,cred,notes,ns,other) values('aaf_admin@people.osaaf.org',2,'2019-05-01',0xd993c5617486296f1b99d04de31633332b8ba1a550038e23860f9dbf0b2fcf95,'Initial ID','org.osaaf.people',53344); INSERT INTO user_role(user,role,expires,ns,rname) VALUES ('aaf_admin@people.osaaf.org','org.osaaf.aaf.admin','2018-10-31','org.osaaf.aaf','admin'); // A Deployer insert into cred (id,type,expires,cred,notes,ns,other) values('deployer@people.osaaf.org',2,'2019-05-01',0xd993c5617486296f1b99d04de31633332b8ba1a550038e23860f9dbf0b2fcf95,'Initial ID','org.osaaf.people',53344); INSERT INTO role(ns, name, perms, description) VALUES('org.osaaf.aaf','deploy',{},'ONAP Deployment Role'); INSERT INTO user_role(user,role,expires,ns,rname) VALUES ('deployer@people.osaaf.org','org.osaaf.aaf.deploy','2018-10-31','org.osaaf.aaf','deploy'); // DEMO ID (OPS) insert into cred (id,type,expires,cred,notes,ns,other) values('demo@people.osaaf.org',2,'2019-05-01',0xd993c5617486296f1b99d04de31633332b8ba1a550038e23860f9dbf0b2fcf95,'Initial ID','org.osaaf.people',53344); INSERT INTO user_role(user,role,expires,ns,rname) VALUES ('demo@people.osaaf.org','org.onap.portal.admin','2018-10-31','org.onap.portal','admin'); // ADMIN insert into cred (id,type,expires,cred,notes,ns,other) values('jh0003@people.osaaf.org',2,'2019-05-01',0xd993c5617486296f1b99d04de31633332b8ba1a550038e23860f9dbf0b2fcf95,'Initial ID','org.osaaf.people',53344); INSERT INTO user_role(user,role,expires,ns,rname) VALUES ('jh0003@people.osaaf.org','org.onap.portal.admin','2018-10-31','org.onap.portal','admin'); // DESIGNER INSERT INTO cred (id,type,expires,cred,notes,ns,other) values('cs0008@people.osaaf.org',2,'2019-05-01',0xd993c5617486296f1b99d04de31633332b8ba1a550038e23860f9dbf0b2fcf95,'Initial ID','org.osaaf.people',53344); INSERT INTO role(ns, name, perms, description) VALUES('org.onap.portal','designer',{'org.onap.portal.access|*|read'},'Portal Designer'); INSERT INTO user_role(user,role,expires,ns,rname) VALUES ('cs0008@people.osaaf.org','org.onap.portal.designer','2018-10-31','org.onap.portal','designer'); // TESTER INSERT INTO cred (id,type,expires,cred,notes,ns,other) values('jm0007@people.osaaf.org',2,'2019-05-01',0xd993c5617486296f1b99d04de31633332b8ba1a550038e23860f9dbf0b2fcf95,'Initial ID','org.osaaf.people',53344); INSERT INTO role(ns, name, perms, description) VALUES('org.onap.portal','tester',{'org.onap.portal.access|*|read'},'Portal Tester'); INSERT INTO user_role(user,role,expires,ns,rname) VALUES ('jm0007@people.osaaf.org','org.onap.portal.tester','2018-10-31','org.onap.portal','tester'); // OPS INSERT INTO cred (id,type,expires,cred,notes,ns,other) values('op0001@people.osaaf.org',2,'2019-05-01',0xd993c5617486296f1b99d04de31633332b8ba1a550038e23860f9dbf0b2fcf95,'Initial ID','org.osaaf.people',53344); INSERT INTO role(ns, name, perms, description) VALUES('org.onap.portal','ops',{'org.onap.portal.access|*|read'},'Portal Operations'); INSERT INTO user_role(user,role,expires,ns,rname) VALUES ('op0001@people.osaaf.org','org.onap.portal.ops','2018-10-31','org.onap.portal','ops'); // GOVERNOR INSERT INTO cred (id,type,expires,cred,notes,ns,other) values('gv0001@people.osaaf.org',2,'2019-05-01',0xd993c5617486296f1b99d04de31633332b8ba1a550038e23860f9dbf0b2fcf95,'Initial ID','org.osaaf.people',53344); INSERT INTO role(ns, name, perms, description) VALUES('org.onap.portal','governor',{'org.onap.portal.access|*|read'},'Portal Governor'); INSERT INTO user_role(user,role,expires,ns,rname) VALUES ('gv0001@people.osaaf.org','org.onap.portal.governor','2018-10-31','org.onap.portal','governor');


context:
space:
mode: