volumes/mariadb/docker-entrypoint-initdb.d/db-sql-scripts/main-schemas/MySQL-Requests-schema.sql

   1
   2     drop table if exists ACTIVATE_OPERATIONAL_ENV_PER_DISTRIBUTIONID_STATUS;
   3
   4     drop table if exists ACTIVATE_OPERATIONAL_ENV_SERVICE_MODEL_DISTRIBUTION_STATUS;
   5
   6     drop table if exists INFRA_ACTIVE_REQUESTS;
   7
   8     drop table if exists OPERATION_STATUS;
   9
  10     drop table if exists RESOURCE_OPERATION_STATUS;
  11
  12     drop table if exists SITE_STATUS;
  13
  14     drop table if exists WATCHDOG_DISTRIBUTIONID_STATUS;
  15
  16     drop table if exists WATCHDOG_PER_COMPONENT_DISTRIBUTION_STATUS;
  17
  18     drop table if exists WATCHDOG_SERVICE_MOD_VER_ID_LOOKUP;
  19
  20     create table ACTIVATE_OPERATIONAL_ENV_PER_DISTRIBUTIONID_STATUS (
  21         DISTRIBUTION_ID varchar(45) not null,
  22         OPERATIONAL_ENV_ID varchar(45),
  23         SERVICE_MODEL_VERSION_ID varchar(45),
  24         DISTRIBUTION_ID_STATUS varchar(45),
  25         DISTRIBUTION_ID_ERROR_REASON varchar(250),
  26         REQUEST_ID varchar(45),
  27         CREATE_TIME datetime,
  28         MODIFY_TIME datetime,
  29         primary key (DISTRIBUTION_ID)
  30     );
  31
  32     create table ACTIVATE_OPERATIONAL_ENV_SERVICE_MODEL_DISTRIBUTION_STATUS (
  33         OPERATIONAL_ENV_ID varchar(45) not null,
  34         SERVICE_MODEL_VERSION_ID varchar(45) not null,
  35         REQUEST_ID varchar(45) not null,
  36         SERVICE_MOD_VER_FINAL_DISTR_STATUS varchar(45),
  37         RECOVERY_ACTION varchar(30),
  38         RETRY_COUNT_LEFT integer,
  39         WORKLOAD_CONTEXT varchar(80),
  40         CREATE_TIME datetime,
  41         MODIFY_TIME datetime,
  42         primary key (OPERATIONAL_ENV_ID, SERVICE_MODEL_VERSION_ID, REQUEST_ID)
  43     );
  44
  45     create table INFRA_ACTIVE_REQUESTS (
  46         REQUEST_ID varchar(45) not null,
  47         CLIENT_REQUEST_ID varchar(45),
  48         ACTION varchar(45) not null,
  49         REQUEST_STATUS varchar(20),
  50         STATUS_MESSAGE varchar(2000),
  51         PROGRESS bigint,
  52         START_TIME datetime,
  53         END_TIME datetime,
  54         SOURCE varchar(45),
  55         VNF_ID varchar(45),
  56         VNF_NAME varchar(80),
  57         VNF_TYPE varchar(200),
  58         SERVICE_TYPE varchar(45),
  59         AIC_NODE_CLLI varchar(11),
  60         TENANT_ID varchar(45),
  61         PROV_STATUS varchar(20),
  62         VNF_PARAMS longtext,
  63         VNF_OUTPUTS longtext,
  64         REQUEST_BODY longtext,
  65         RESPONSE_BODY longtext,
  66         LAST_MODIFIED_BY varchar(50),
  67         MODIFY_TIME datetime,
  68         REQUEST_TYPE varchar(20),
  69         VOLUME_GROUP_ID varchar(45),
  70         VOLUME_GROUP_NAME varchar(45),
  71         VF_MODULE_ID varchar(45),
  72         VF_MODULE_NAME varchar(200),
  73         VF_MODULE_MODEL_NAME varchar(200),
  74         AAI_SERVICE_ID varchar(50),
  75         AIC_CLOUD_REGION varchar(200),
  76         CALLBACK_URL varchar(200),
  77         CORRELATOR varchar(80),
  78         SERVICE_INSTANCE_ID varchar(45),
  79         SERVICE_INSTANCE_NAME varchar(80),
  80         REQUEST_SCOPE varchar(45),
  81         REQUEST_ACTION varchar(45) not null,
  82         NETWORK_ID varchar(45),
  83         NETWORK_NAME varchar(80),
  84         NETWORK_TYPE varchar(80),
  85         REQUESTOR_ID varchar(80),
  86         CONFIGURATION_ID varchar(45),
  87         CONFIGURATION_NAME varchar(200),
  88         OPERATIONAL_ENV_ID varchar(45),
  89         OPERATIONAL_ENV_NAME varchar(200),
  90         primary key (REQUEST_ID)
  91     );
  92
  93     create table OPERATION_STATUS (
  94         SERVICE_ID varchar(255) not null,
  95         OPERATION_ID varchar(256) not null,
  96         OPERATION_TYPE varchar(256),
  97         USER_ID varchar(256),
  98         RESULT varchar(256),
  99         OPERATION_CONTENT varchar(256),
 100         PROGRESS varchar(256),
 101         REASON varchar(256),
 102         OPERATE_AT datetime default CURRENT_TIMESTAMP,
 103         FINISHED_AT datetime,
 104         primary key (SERVICE_ID, OPERATION_ID)
 105     );
 106
 107     create table RESOURCE_OPERATION_STATUS (
 108         SERVICE_ID varchar(255) not null,
 109         OPERATION_ID varchar(256) not null,
 110         RESOURCE_TEMPLATE_UUID varchar(255) not null,
 111         OPER_TYPE varchar(256),
 112         RESOURCE_INSTANCE_ID varchar(256),
 113         JOB_ID varchar(256),
 114         STATUS varchar(256),
 115         PROGRESS varchar(256),
 116         ERROR_CODE varchar(256),
 117         STATUS_DESCRIPOTION varchar(256),
 118         primary key (SERVICE_ID, OPERATION_ID, RESOURCE_TEMPLATE_UUID)
 119     );
 120
 121     create table SITE_STATUS (
 122         SITE_NAME varchar(255) not null,
 123         STATUS bit,
 124         CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
 125         primary key (SITE_NAME)
 126     );
 127
 128     create table WATCHDOG_DISTRIBUTIONID_STATUS (
 129         DISTRIBUTION_ID varchar(45) not null,
 130         DISTRIBUTION_ID_STATUS varchar(45),
 131         CREATE_TIME datetime,
 132         MODIFY_TIME datetime,
 133         primary key (DISTRIBUTION_ID)
 134     );
 135
 136     create table WATCHDOG_PER_COMPONENT_DISTRIBUTION_STATUS (
 137         DISTRIBUTION_ID varchar(45) not null,
 138         COMPONENT_NAME varchar(45) not null,
 139         COMPONENT_DISTRIBUTION_STATUS varchar(45),
 140         CREATE_TIME datetime,
 141         MODIFY_TIME datetime,
 142         primary key (DISTRIBUTION_ID, COMPONENT_NAME)
 143     );
 144
 145     create table WATCHDOG_SERVICE_MOD_VER_ID_LOOKUP (
 146         DISTRIBUTION_ID varchar(45) not null,
 147         SERVICE_MODEL_VERSION_ID varchar(45) not null,
 148         CREATE_TIME datetime,
 149         primary key (DISTRIBUTION_ID, SERVICE_MODEL_VERSION_ID)
 150     );
 151
 152     alter table INFRA_ACTIVE_REQUESTS
 153         add constraint UK_bhu6w8p7wvur4pin0gjw2d5ak  unique (CLIENT_REQUEST_ID);