drop
foreign key FK_iff1ayhb1hrp5jhea3vvikuni;
- alter table VNF_RES_CUSTOM_TO_VF_MODULE_CUSTOM
- drop
- foreign key FK_6tdyg2ib5eguh4k2qgofh4fj7;
-
drop table if exists ALLOTTED_RESOURCE;
drop table if exists ALLOTTED_RESOURCE_CUSTOMIZATION;
TOSCA_NODE_TYPE varchar(255),
SUBCATEGORY varchar(255),
DESCRIPTION varchar(255),
- CREATION_TIMESTAMP datetime not null,
+ CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
primary key (MODEL_UUID)
);
NF_NAMING_CODE varchar(255),
MIN_INSTANCES integer,
MAX_INSTANCES integer,
- CREATION_TIMESTAMP datetime not null,
+ CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
primary key (MODEL_CUSTOMIZATION_UUID)
);
VERSION varchar(20) not null,
DESCRIPTION varchar(1200),
BODY longtext not null,
- CREATION_TIMESTAMP datetime not null,
+ CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
ARTIFACT_CHECKSUM varchar(200) default 'MANUAL RECORD',
primary key (ARTIFACT_UUID)
);
DESCRIPTION varchar(255),
NAME varchar(255),
VERSION varchar(255),
- BODY varchar(255),
- CREATION_TIMESTAMP datetime not null,
+ BODY longtext,
+ CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
ARTIFACT_CHECKSUM varchar(255),
primary key (ARTIFACT_UUID)
);
BODY longtext not null,
TIMEOUT_MINUTES integer,
DESCRIPTION varchar(1200),
- CREATION_TIMESTAMP datetime not null,
+ CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
ARTIFACT_CHECKSUM varchar(200) default 'MANUAL RECORD' not null,
primary key (ARTIFACT_UUID)
);
MODEL_VERSION varchar(20),
MODEL_CUSTOMIZATION_ID varchar(40),
MODEL_CUSTOMIZATION_NAME varchar(40),
- CREATION_TIMESTAMP datetime not null,
+ CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
primary key (id)
);
ORCHESTRATION_URI varchar(256) not null,
MODEL_PARAM_XSD varchar(2048),
RECIPE_TIMEOUT integer,
- CREATION_TIMESTAMP datetime not null,
+ CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
primary key (id)
);
ORCHESTRATION_URI varchar(256) not null,
NETWORK_PARAM_XSD varchar(2048),
RECIPE_TIMEOUT integer,
- CREATION_TIMESTAMP datetime not null,
+ CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
primary key (id)
);
create table NETWORK_RESOURCE (
MODEL_UUID varchar(200) not null,
MODEL_NAME varchar(200) not null,
- MODEL_INVARIANT_UUID varchar(20),
+ MODEL_INVARIANT_UUID varchar(200),
MODEL_VERSION varchar(20),
TOSCA_NODE_TYPE varchar(200),
NEUTRON_NETWORK_TYPE varchar(20),
HEAT_TEMPLATE_ARTIFACT_UUID varchar(200) not null,
AIC_VERSION_MIN varchar(20) default 2.5 not null,
AIC_VERSION_MAX varchar(20) default 2.5,
- CREATION_TIMESTAMP datetime not null,
+ CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
primary key (MODEL_UUID)
);
NETWORK_TYPE varchar(255),
NETWORK_SCOPE varchar(255),
NETWORK_ROLE varchar(255),
- CREATION_TIMESTAMP datetime not null,
+ CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
primary key (MODEL_CUSTOMIZATION_UUID)
);
MODEL_VERSION varchar(20) not null,
DESCRIPTION varchar(1200),
TOSCA_CSAR_ARTIFACT_UUID varchar(200),
- CREATION_TIMESTAMP datetime not null,
+ CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
MODEL_INVARIANT_UUID varchar(200) default 'MANUAL_RECORD' not null,
SERVICE_TYPE varchar(20),
SERVICE_ROLE varchar(20),
SERVICE_MODEL_UUID varchar(200) not null,
ACTION varchar(40) not null,
ORCHESTRATION_URI varchar(256) not null,
- CREATION_TIMESTAMP datetime not null,
+ CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
VERSION_STR varchar(20),
DESCRIPTION varchar(1200),
SERVICE_PARAM_XSD varchar(2048),
create table SERVICE_TO_ALLOTTED_RESOURCES (
SERVICE_MODEL_UUID varchar(200) not null,
AR_MODEL_CUSTOMIZATION_UUID varchar(200) not null,
- CREATION_TIMESTAMP datetime not null,
+ CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
primary key (SERVICE_MODEL_UUID, AR_MODEL_CUSTOMIZATION_UUID)
);
create table SERVICE_TO_NETWORKS (
SERVICE_MODEL_UUID varchar(200) not null,
NETWORK_MODEL_CUSTOMIZATION_UUID varchar(200) not null,
- CREATION_TIMESTAMP datetime not null,
+ CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
primary key (SERVICE_MODEL_UUID, NETWORK_MODEL_CUSTOMIZATION_UUID)
);
create table SERVICE_TO_RESOURCE_CUSTOMIZATIONS (
MODEL_TYPE varchar(20) not null,
RESOURCE_MODEL_CUSTOMIZATION_UUID varchar(200) not null,
- CREATION_TIMESTAMP datetime not null,
+ CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
SERVICE_MODEL_UUID varchar(200) not null,
primary key (MODEL_TYPE, RESOURCE_MODEL_CUSTOMIZATION_UUID)
);
ARTIFACT_CHECKSUM varchar(200) not null,
URL varchar(200) not null,
DESCRIPTION varchar(1200),
- CREATION_TIMESTAMP datetime not null,
+ CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
primary key (ARTIFACT_UUID)
);
IS_BASE integer not null,
HEAT_TEMPLATE_ARTIFACT_UUID varchar(200) not null,
VOL_HEAT_TEMPLATE_ARTIFACT_UUID varchar(200),
- CREATION_TIMESTAMP datetime not null,
+ CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
primary key (MODEL_UUID)
);
MODEL_CUSTOMIZATION_UUID varchar(200) not null,
VF_MODULE_MODEL_UUID varchar(200) not null,
VOL_ENVIRONMENT_ARTIFACT_UUID varchar(200),
- CREATION_TIMESTAMP datetime not null,
+ CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
HEAT_ENVIRONMENT_ARTIFACT_UUID varchar(200),
MIN_INSTANCES integer,
MAX_INSTANCES integer,
COMPONENT_TYPE varchar(20) not null,
HEAT_TEMPLATE_ID integer,
HEAT_ENVIRONMENT_ID integer,
- CREATION_TIMESTAMP datetime not null,
+ CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
primary key (VNF_ID, COMPONENT_TYPE)
);
ORCHESTRATION_URI varchar(256) not null,
VNF_COMPONENT_PARAM_XSD varchar(2048),
RECIPE_TIMEOUT integer,
- CREATION_TIMESTAMP datetime,
+ CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
primary key (id)
);
ORCHESTRATION_URI varchar(256) not null,
VNF_PARAM_XSD varchar(2048),
RECIPE_TIMEOUT integer,
- CREATION_TIMESTAMP datetime,
+ CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
primary key (id)
);
AIC_VERSION_MIN varchar(20),
AIC_VERSION_MAX varchar(20),
HEAT_TEMPLATE_ARTIFACT_UUID varchar(200),
- CREATION_TIMESTAMP datetime not null,
+ CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
primary key (MODEL_UUID)
);
NF_ROLE varchar(200),
NF_NAMING_CODE varchar(200),
VNF_RESOURCE_MODEL_UUID varchar(200) not null,
- CREATION_TIMESTAMP datetime not null,
+ CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
primary key (MODEL_CUSTOMIZATION_UUID)
);
create table VNF_RES_CUSTOM_TO_VF_MODULE_CUSTOM (
VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID varchar(200) not null,
VF_MODULE_CUST_MODEL_CUSTOMIZATION_UUID varchar(200) not null,
- CREATION_TIMESTAMP datetime not null,
- VNF_RESOURCE_MODEL_UUID varchar(200) not null,
+ CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
primary key (VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID, VF_MODULE_CUST_MODEL_CUSTOMIZATION_UUID)
);
add constraint FK_iff1ayhb1hrp5jhea3vvikuni
foreign key (VNF_RESOURCE_MODEL_UUID)
references VNF_RESOURCE (MODEL_UUID);
-
- alter table VNF_RES_CUSTOM_TO_VF_MODULE_CUSTOM
- add constraint FK_6tdyg2ib5eguh4k2qgofh4fj7
- foreign key (VNF_RESOURCE_MODEL_UUID)
- references VNF_RESOURCE_CUSTOMIZATION (MODEL_CUSTOMIZATION_UUID);