onap on kubernetes source files

[oom.git] / kubernetes / config / docker / init / src / config / mso / mariadb / docker-entrypoint-initdb.d / db-sql-scripts / main-schemas / MySQL-Requests-schema.sql

diff --git a/kubernetes/config/docker/init/src/config/mso/mariadb/docker-entrypoint-initdb.d/db-sql-scripts/main-schemas/MySQL-Requests-schema.sql b/kubernetes/config/docker/init/src/config/mso/mariadb/docker-entrypoint-initdb.d/db-sql-scripts/main-schemas/MySQL-Requests-schema.sql
new file mode 100755 (executable)
index 0000000..93da621
--- /dev/null
+++ b/kubernetes/config/docker/init/src/config/mso/mariadb/docker-entrypoint-initdb.d/db-sql-scripts/main-schemas/MySQL-Requests-schema.sql
@@ -0,0 +1,57 @@
+
+    drop table if exists INFRA_ACTIVE_REQUESTS;
+
+    drop table if exists SITE_STATUS;
+
+    create table INFRA_ACTIVE_REQUESTS (
+        REQUEST_ID varchar(45) not null,
+        CLIENT_REQUEST_ID varchar(45),
+        ACTION varchar(45) not null,
+        REQUEST_STATUS varchar(20),
+        STATUS_MESSAGE varchar(2000),
+        PROGRESS bigint,
+        START_TIME datetime,
+        END_TIME datetime,
+        SOURCE varchar(45),
+        VNF_ID varchar(45),
+        VNF_NAME varchar(80),
+        VNF_TYPE varchar(200),
+        SERVICE_TYPE varchar(45),
+        AIC_NODE_CLLI varchar(11),
+        TENANT_ID varchar(45),
+        PROV_STATUS varchar(20),
+        VNF_PARAMS longtext,
+        VNF_OUTPUTS longtext,
+        REQUEST_BODY longtext,
+        RESPONSE_BODY longtext,
+        LAST_MODIFIED_BY varchar(50),
+        MODIFY_TIME datetime,
+        REQUEST_TYPE varchar(20),
+        VOLUME_GROUP_ID varchar(45),
+        VOLUME_GROUP_NAME varchar(45),
+        VF_MODULE_ID varchar(45),
+        VF_MODULE_NAME varchar(200),
+        VF_MODULE_MODEL_NAME varchar(200),
+        AAI_SERVICE_ID varchar(50),
+        AIC_CLOUD_REGION varchar(11),
+        CALLBACK_URL varchar(200),
+        CORRELATOR varchar(80),
+        SERVICE_INSTANCE_ID varchar(45),
+        SERVICE_INSTANCE_NAME varchar(80),
+        REQUEST_SCOPE varchar(20),
+        REQUEST_ACTION varchar(45) not null,
+        NETWORK_ID varchar(45),
+        NETWORK_NAME varchar(80),
+        NETWORK_TYPE varchar(80),
+        primary key (REQUEST_ID)
+    );
+
+    create table SITE_STATUS (
+        SITE_NAME varchar(255) not null,
+        STATUS bit,
+        CREATION_TIMESTAMP datetime,
+        primary key (SITE_NAME)
+    );
+
+    alter table INFRA_ACTIVE_REQUESTS 
+        add constraint UK_bhu6w8p7wvur4pin0gjw2d5ak  unique (CLIENT_REQUEST_ID);