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

   1
   2     drop table if exists INFRA_ACTIVE_REQUESTS;
   3
   4     drop table if exists SITE_STATUS;
   5
   6     create table INFRA_ACTIVE_REQUESTS (
   7         REQUEST_ID varchar(45) not null,
   8         CLIENT_REQUEST_ID varchar(45),
   9         ACTION varchar(45) not null,
  10         REQUEST_STATUS varchar(20),
  11         STATUS_MESSAGE varchar(2000),
  12         PROGRESS bigint,
  13         START_TIME datetime,
  14         END_TIME datetime,
  15         SOURCE varchar(45),
  16         VNF_ID varchar(45),
  17         VNF_NAME varchar(80),
  18         VNF_TYPE varchar(200),
  19         SERVICE_TYPE varchar(45),
  20         AIC_NODE_CLLI varchar(11),
  21         TENANT_ID varchar(45),
  22         PROV_STATUS varchar(20),
  23         VNF_PARAMS longtext,
  24         VNF_OUTPUTS longtext,
  25         REQUEST_BODY longtext,
  26         RESPONSE_BODY longtext,
  27         LAST_MODIFIED_BY varchar(50),
  28         MODIFY_TIME datetime,
  29         REQUEST_TYPE varchar(20),
  30         VOLUME_GROUP_ID varchar(45),
  31         VOLUME_GROUP_NAME varchar(45),
  32         VF_MODULE_ID varchar(45),
  33         VF_MODULE_NAME varchar(200),
  34         VF_MODULE_MODEL_NAME varchar(200),
  35         AAI_SERVICE_ID varchar(50),
  36         AIC_CLOUD_REGION varchar(11),
  37         CALLBACK_URL varchar(200),
  38         CORRELATOR varchar(80),
  39         SERVICE_INSTANCE_ID varchar(45),
  40         SERVICE_INSTANCE_NAME varchar(80),
  41         REQUEST_SCOPE varchar(20),
  42         REQUEST_ACTION varchar(45) not null,
  43         NETWORK_ID varchar(45),
  44         NETWORK_NAME varchar(80),
  45         NETWORK_TYPE varchar(80),
  46         primary key (REQUEST_ID)
  47     );
  48
  49     create table SITE_STATUS (
  50         SITE_NAME varchar(255) not null,
  51         STATUS bit,
  52         CREATION_TIMESTAMP datetime,
  53         primary key (SITE_NAME)
  54     );
  55
  56     alter table INFRA_ACTIVE_REQUESTS
  57         add constraint UK_bhu6w8p7wvur4pin0gjw2d5ak  unique (CLIENT_REQUEST_ID);