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         SERVICE_NAME varchar(256),
  97         OPERATION_TYPE varchar(256),
  98         USER_ID varchar(256),
  99         RESULT varchar(256),
 100         OPERATION_CONTENT varchar(256),
 101         PROGRESS varchar(256),
 102         REASON varchar(256),
 103         OPERATE_AT datetime default CURRENT_TIMESTAMP,
 104         FINISHED_AT datetime,
 105         primary key (SERVICE_ID, OPERATION_ID)
 106     );
 107
 108     create table RESOURCE_OPERATION_STATUS (
 109         SERVICE_ID varchar(255) not null,
 110         OPERATION_ID varchar(256) not null,
 111         RESOURCE_TEMPLATE_UUID varchar(255) not null,
 112         OPER_TYPE varchar(256),
 113         RESOURCE_INSTANCE_ID varchar(256),
 114         JOB_ID varchar(256),
 115         STATUS varchar(256),
 116         PROGRESS varchar(256),
 117         ERROR_CODE varchar(256),
 118         STATUS_DESCRIPOTION varchar(256),
 119         primary key (SERVICE_ID, OPERATION_ID, RESOURCE_TEMPLATE_UUID)
 120     );
 121
 122     create table SITE_STATUS (
 123         SITE_NAME varchar(255) not null,
 124         STATUS bit,
 125         CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
 126         primary key (SITE_NAME)
 127     );
 128
 129     create table WATCHDOG_DISTRIBUTIONID_STATUS (
 130         DISTRIBUTION_ID varchar(45) not null,
 131         DISTRIBUTION_ID_STATUS varchar(45),
 132         CREATE_TIME datetime,
 133         MODIFY_TIME datetime,
 134         primary key (DISTRIBUTION_ID)
 135     );
 136
 137     create table WATCHDOG_PER_COMPONENT_DISTRIBUTION_STATUS (
 138         DISTRIBUTION_ID varchar(45) not null,
 139         COMPONENT_NAME varchar(45) not null,
 140         COMPONENT_DISTRIBUTION_STATUS varchar(45),
 141         CREATE_TIME datetime,
 142         MODIFY_TIME datetime,
 143         primary key (DISTRIBUTION_ID, COMPONENT_NAME)
 144     );
 145
 146     create table WATCHDOG_SERVICE_MOD_VER_ID_LOOKUP (
 147         DISTRIBUTION_ID varchar(45) not null,
 148         SERVICE_MODEL_VERSION_ID varchar(45) not null,
 149         CREATE_TIME datetime,
 150         primary key (DISTRIBUTION_ID, SERVICE_MODEL_VERSION_ID)
 151     );
 152
 153     alter table INFRA_ACTIVE_REQUESTS
 154         add constraint UK_bhu6w8p7wvur4pin0gjw2d5ak  unique (CLIENT_REQUEST_ID);