Remove controllerbluprints distribution.

Change-Id: I8c7269f97f2b32a0fe8689baaeddfe1e82e0d075
Issue-ID: CCSDK-1663
Signed-off-by: Brinda Santh <brindasanth@in.ibm.com>

9 files changed, 167 insertions, 39 deletions

diff --git a/ms/blueprintsprocessor/application/src/main/resources/sql/data.sql b/ms/blueprintsprocessor/application/src/main/resources/sql/data.sql
new file mode 100644
index 000000000..e69de29bb
--- /dev/null
+++ b/ms/blueprintsprocessor/application/src/main/resources/sql/data.sql
diff --git a/ms/blueprintsprocessor/application/src/main/resources/sql/schema-local.sql b/ms/blueprintsprocessor/application/src/main/resources/sql/schema-local.sql
new file mode 100644
index 000000000..ad048b017
--- /dev/null
+++ b/ms/blueprintsprocessor/application/src/main/resources/sql/schema-local.sql
@@ -0,0 +1,83 @@
+-- drop table sdnctl.MODEL_TYPE;
+-- drop table sdnctl.RESOURCE_DICTIONARY;
+-- drop table sdnctl.CONFIG_MODEL_CONTENT;
+-- drop table sdnctl.CONFIG_MODEL;
+
+-- -----------------------------------------------------
+-- table CONFIG_MODEL
+-- -----------------------------------------------------
+CREATE TABLE IF NOT EXISTS sdnctl.CONFIG_MODEL (
+  config_model_id 		INT(11) NOT NULL AUTO_INCREMENT,
+  service_uuid 			VARCHAR(50) NULL DEFAULT NULL,
+  distribution_id 		VARCHAR(50) NULL DEFAULT NULL,
+  service_name 			VARCHAR(255) NULL DEFAULT NULL,
+  service_description 		VARCHAR(255) NULL DEFAULT NULL,
+  resource_uuid 		VARCHAR(255) NULL DEFAULT NULL,
+  resource_instance_name 	VARCHAR(255) NULL DEFAULT NULL,
+  resource_name 		varchar(255) null default null,
+  resource_version 		varchar(50) null default null,
+  resource_type 		varchar(50) null default null,
+  artifact_uuid 		varchar(50) null default null,
+  artifact_type 		varchar(50) not null,
+  artifact_version 		varchar(25) not null,
+  artifact_description 		longtext null default null,
+  internal_version 		int(11) null default null,
+  creation_date 		datetime not null default current_timestamp,
+  artifact_name 		varchar(100) not null,
+  published 			varchar(1) not null,
+  updated_by 			varchar(100) not null,
+  tags 				longtext null default null,
+  primary key PK_CONFIG_MODEL (config_model_id),
+  UNIQUE KEY UK_CONFIG_MODEL (artifact_name , artifact_version)
+) ENGINE=InnoDB;
+
+
+-- -----------------------------------------------------
+-- table CONFIG_MODEL_CONTENT
+-- -----------------------------------------------------
+CREATE TABLE IF NOT EXISTS sdnctl.CONFIG_MODEL_CONTENT (
+  config_model_content_id 	INT(11) NOT NULL AUTO_INCREMENT, 
+  config_model_id 		INT NOT NULL,
+  name 				VARCHAR(100) NOT NULL,
+  content_type 			VARCHAR(50) NOT NULL,
+  description 			LONGTEXT NULL DEFAULT NULL,
+  updated_date 			DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
+  content 			LONGTEXT NULL DEFAULT NULL,
+  PRIMARY KEY PK_CONFIG_MODEL_CONTENT (config_model_content_id),
+  UNIQUE KEY UK_CONFIG_MODEL_CONTENT (config_model_id, name, content_type),
+  FOREIGN KEY FK_CONFIG_MODEL_CONTENT (config_model_id) REFERENCES sdnctl.CONFIG_MODEL(config_model_id) ON DELETE CASCADE
+) ENGINE=InnoDB;
+
+-- -----------------------------------------------------
+-- table MODEL_TYPE
+-- -----------------------------------------------------
+CREATE TABLE IF NOT EXISTS sdnctl.MODEL_TYPE (
+  model_name 		VARCHAR(100) NOT NULL,
+  derived_from 		VARCHAR(100) NOT NULL,
+  definition_type 	VARCHAR(100) NOT NULL,
+  definition 		LONGTEXT NOT NULL,
+  version 		VARCHAR(10) NOT NULL,
+  description 		LONGTEXT NOT NULL,
+  tags 			LONGTEXT NULL DEFAULT NULL,  
+  creation_date 	DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
+  updated_by 		VARCHAR(100) NOT NULL,
+  PRIMARY KEY PK_MODEL_TYPE (model_name),
+  INDEX IX_MODEL_TYPE (model_name)
+) ENGINE=InnoDB;
+
+
+-- -----------------------------------------------------
+-- table RESOURCE_DICTIONARY
+-- -----------------------------------------------------
+CREATE TABLE IF NOT EXISTS sdnctl.RESOURCE_DICTIONARY (
+  name 			VARCHAR(100) NOT NULL,
+  data_type 		VARCHAR(100) NOT NULL,
+  entry_schema 		VARCHAR(100) NULL DEFAULT NULL,
+  definition 		LONGTEXT NOT NULL,
+  description 		LONGTEXT NOT NULL,
+  tags 			LONGTEXT NOT NULL,  
+  creation_date 	DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
+  updated_by 		VARCHAR(100) NOT NULL,
+  primary key PK_RESOURCE_DICTIONARY (name),
+  INDEX IX_RESOURCE_DICTIONARY (name)
+) ENGINE=InnoDB;
\ No newline at end of file
diff --git a/ms/blueprintsprocessor/application/src/main/resources/sql/schema.sql b/ms/blueprintsprocessor/application/src/main/resources/sql/schema.sql
new file mode 100644
index 000000000..58564dce5
--- /dev/null
+++ b/ms/blueprintsprocessor/application/src/main/resources/sql/schema.sql
@@ -0,0 +1,78 @@
+-- -----------------------------------------------------
+-- table CONFIG_MODEL
+-- -----------------------------------------------------
+CREATE TABLE IF NOT EXISTS configurator.CONFIG_MODEL (
+  config_model_id 		INT(11) NOT NULL AUTO_INCREMENT,
+  service_uuid 			VARCHAR(50) NULL DEFAULT NULL,
+  distribution_id 		VARCHAR(50) NULL DEFAULT NULL,
+  service_name 			VARCHAR(255) NULL DEFAULT NULL,
+  service_description 		VARCHAR(255) NULL DEFAULT NULL,
+  resource_uuid 		VARCHAR(255) NULL DEFAULT NULL,
+  resource_instance_name 	VARCHAR(255) NULL DEFAULT NULL,
+  resource_name 		varchar(255) null default null,
+  resource_version 		varchar(50) null default null,
+  resource_type 		varchar(50) null default null,
+  artifact_uuid 		varchar(50) null default null,
+  artifact_type 		varchar(50) not null,
+  artifact_version 		varchar(25) not null,
+  artifact_description 		longtext null default null,
+  internal_version 		int(11) null default null,
+  creation_date 		datetime not null default current_timestamp,
+  artifact_name 		varchar(100) not null,
+  published 			varchar(1) not null,
+  updated_by 			varchar(100) not null,
+  tags 				longtext null default null,
+  primary key PK_CONFIG_MODEL (config_model_id),
+  UNIQUE KEY UK_CONFIG_MODEL (artifact_name , artifact_version)
+) ENGINE=InnoDB;
+
+
+-- -----------------------------------------------------
+-- table CONFIG_MODEL_CONTENT
+-- -----------------------------------------------------
+CREATE TABLE IF NOT EXISTS configurator.CONFIG_MODEL_CONTENT (
+  config_model_content_id 	INT(11) NOT NULL AUTO_INCREMENT, 
+  config_model_id 		INT NOT NULL,
+  name 				VARCHAR(100) NOT NULL,
+  content_type 			VARCHAR(50) NOT NULL,
+  description 			LONGTEXT NULL DEFAULT NULL,
+  updated_date 			DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
+  content 			LONGTEXT NULL DEFAULT NULL,
+  PRIMARY KEY PK_CONFIG_MODEL_CONTENT (config_model_content_id),
+  UNIQUE KEY UK_CONFIG_MODEL_CONTENT (config_model_id, name, content_type),
+  FOREIGN KEY FK_CONFIG_MODEL_CONTENT (config_model_id) REFERENCES configurator.CONFIG_MODEL(config_model_id) ON DELETE CASCADE
+) ENGINE=InnoDB;
+
+-- -----------------------------------------------------
+-- table MODEL_TYPE
+-- -----------------------------------------------------
+CREATE TABLE IF NOT EXISTS configurator.MODEL_TYPE (
+  model_name 		VARCHAR(100) NOT NULL,
+  derived_from 		VARCHAR(100) NOT NULL,
+  definition_type 	VARCHAR(100) NOT NULL,
+  definition 		LONGTEXT NOT NULL,
+  version 		VARCHAR(10) NOT NULL,
+  description 		LONGTEXT NOT NULL,
+  tags 			LONGTEXT NULL DEFAULT NULL,  
+  creation_date 	DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
+  updated_by 		VARCHAR(100) NOT NULL,
+  PRIMARY KEY PK_MODEL_TYPE (model_name),
+  INDEX IX_MODEL_TYPE (model_name)
+) ENGINE=InnoDB;
+
+
+-- -----------------------------------------------------
+-- table RESOURCE_DICTIONARY
+-- -----------------------------------------------------
+CREATE TABLE IF NOT EXISTS configurator.RESOURCE_DICTIONARY (
+  name 			VARCHAR(100) NOT NULL,
+  data_type 		VARCHAR(100) NOT NULL,
+  entry_schema 		VARCHAR(100) NULL DEFAULT NULL,
+  definition 		LONGTEXT NOT NULL,
+  description 		LONGTEXT NOT NULL,
+  tags 			LONGTEXT NOT NULL,  
+  creation_date 	DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
+  updated_by 		VARCHAR(100) NOT NULL,
+  primary key PK_RESOURCE_DICTIONARY (name),
+  INDEX IX_RESOURCE_DICTIONARY (name)
+) ENGINE=InnoDB;
diff --git a/ms/blueprintsprocessor/modules/inbounds/configs-api/pom.xml b/ms/blueprintsprocessor/modules/inbounds/configs-api/pom.xml
index 6d2596024..f34a1ec4b 100644
--- a/ms/blueprintsprocessor/modules/inbounds/configs-api/pom.xml
+++ b/ms/blueprintsprocessor/modules/inbounds/configs-api/pom.xml
@@ -43,10 +43,5 @@
             <groupId>org.onap.ccsdk.cds.controllerblueprints</groupId>
             <artifactId>blueprint-core</artifactId>
         </dependency>
-        <dependency>
-            <groupId>com.h2database</groupId>
-            <artifactId>h2</artifactId>
-            <scope>test</scope>
-        </dependency>
     </dependencies>
 </project>
diff --git a/ms/blueprintsprocessor/modules/inbounds/designer-api/pom.xml b/ms/blueprintsprocessor/modules/inbounds/designer-api/pom.xml
index 7c1576e95..8f6d32ee2 100644
--- a/ms/blueprintsprocessor/modules/inbounds/designer-api/pom.xml
+++ b/ms/blueprintsprocessor/modules/inbounds/designer-api/pom.xml
@@ -26,10 +26,4 @@
     <name>Blueprints Processor Designer API</name>
     <description>Blueprints Processor Designer API</description>
 
-    <dependencies>
-        <dependency>
-            <groupId>org.onap.ccsdk.cds.controllerblueprints</groupId>
-            <artifactId>service</artifactId>
-        </dependency>
-    </dependencies>
 </project>
diff --git a/ms/blueprintsprocessor/modules/inbounds/pom.xml b/ms/blueprintsprocessor/modules/inbounds/pom.xml
index a892f205f..8afecab3c 100644
--- a/ms/blueprintsprocessor/modules/inbounds/pom.xml
+++ b/ms/blueprintsprocessor/modules/inbounds/pom.xml
@@ -85,5 +85,11 @@
             <artifactId>reactor-test</artifactId>
             <scope>test</scope>
         </dependency>
+
+        <dependency>
+            <groupId>com.h2database</groupId>
+            <artifactId>h2</artifactId>
+            <scope>test</scope>
+        </dependency>
     </dependencies>
 </project>
diff --git a/ms/blueprintsprocessor/modules/inbounds/resource-api/pom.xml b/ms/blueprintsprocessor/modules/inbounds/resource-api/pom.xml
index e343a6f3b..cf8c61ac7 100644
--- a/ms/blueprintsprocessor/modules/inbounds/resource-api/pom.xml
+++ b/ms/blueprintsprocessor/modules/inbounds/resource-api/pom.xml
@@ -36,18 +36,5 @@
             <groupId>org.onap.ccsdk.cds.controllerblueprints</groupId>
             <artifactId>blueprint-core</artifactId>
         </dependency>
-        <!--dependency>
-            <groupId>org.onap.ccsdk.cds.controllerblueprints</groupId>
-            <artifactId>blueprint-validation</artifactId>
-        </dependency>
-        <dependency>
-            <groupId>org.onap.ccsdk.cds.controllerblueprints</groupId>
-            <artifactId>blueprint-scripts</artifactId>
-        </dependency-->
-        <dependency>
-            <groupId>com.h2database</groupId>
-            <artifactId>h2</artifactId>
-            <scope>test</scope>
-        </dependency>
     </dependencies>
 </project>
diff --git a/ms/blueprintsprocessor/modules/inbounds/selfservice-api/pom.xml b/ms/blueprintsprocessor/modules/inbounds/selfservice-api/pom.xml
index cfa2d6fea..2c241cc4f 100755
--- a/ms/blueprintsprocessor/modules/inbounds/selfservice-api/pom.xml
+++ b/ms/blueprintsprocessor/modules/inbounds/selfservice-api/pom.xml
@@ -55,11 +55,6 @@
             <groupId>io.grpc</groupId>
             <artifactId>grpc-testing</artifactId>
         </dependency>
-        <dependency>
-            <groupId>com.h2database</groupId>
-            <artifactId>h2</artifactId>
-            <scope>test</scope>
-        </dependency>
 
         <!-- For Message libraries -->
         <dependency>
diff --git a/ms/blueprintsprocessor/parent/pom.xml b/ms/blueprintsprocessor/parent/pom.xml
index a86ce6fc4..e79c497be 100755
--- a/ms/blueprintsprocessor/parent/pom.xml
+++ b/ms/blueprintsprocessor/parent/pom.xml
@@ -460,19 +460,9 @@
             </dependency>
             <dependency>
                 <groupId>org.onap.ccsdk.cds.controllerblueprints</groupId>
-                <artifactId>blueprint-scripts</artifactId>
-                <version>${project.version}</version>
-            </dependency>
-            <dependency>
-                <groupId>org.onap.ccsdk.cds.controllerblueprints</groupId>
                 <artifactId>blueprint-validation</artifactId>
                 <version>${project.version}</version>
             </dependency>
-            <dependency>
-                <groupId>org.onap.ccsdk.cds.controllerblueprints</groupId>
-                <artifactId>service</artifactId>
-                <version>${project.version}</version>
-            </dependency>
 
             <!-- Database -->
             <dependency>