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         REQUESTOR_ID varchar(80),
  47         primary key (REQUEST_ID)
  48     );
  49
  50     create table SITE_STATUS (
  51         SITE_NAME varchar(255) not null,
  52         STATUS bit,
  53         CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
  54         primary key (SITE_NAME)
  55     );
  56         create table OPERATION_STATUS (
  57         SERVICE_ID varchar(255) not null,
  58         OPERATION_ID varchar(255) not null,
  59                 SERVICE_NAME varchar(255),
  60                 OPERATION_TYPE varchar(255),
  61                 USER_ID varchar(255),
  62                 RESULT varchar(255),
  63                 OPERATION_CONTENT varchar(255),
  64                 PROGRESS varchar(255),
  65                 REASON varchar(255),
  66         OPERATE_AT datetime,
  67                 FINISHED_AT datetime,
  68         primary key (SERVICE_ID,OPERATION_ID)
  69     );
  70         create table RESOURCE_OPERATION_STATUS (
  71         SERVICE_ID varchar(255) not null,
  72         OPERATION_ID varchar(255) not null,
  73         RESOURCE_TEMPLATE_UUID varchar(255) not null,
  74                 OPER_TYPE varchar(255),
  75                 RESOURCE_INSTANCE_ID varchar(255),
  76                 JOB_ID varchar(255),
  77                 STATUS varchar(255),
  78                 PROGRESS varchar(255),
  79                 ERROR_CODE varchar(255) ,
  80                 STATUS_DESCRIPOTION varchar(255) ,
  81         primary key (SERVICE_ID,OPERATION_ID,RESOURCE_TEMPLATE_UUID)
  82     );
  83     alter table INFRA_ACTIVE_REQUESTS
  84         add constraint UK_bhu6w8p7wvur4pin0gjw2d5ak  unique (CLIENT_REQUEST_ID);