<feature>[conf]: add new tables DDL
DBImpact
1.new tables: HostNUMATopologyVO,HostAllocatedCPUVO,VmInstanceNUMAVO;
Resolves:
@@ -36,3 +36,39 @@ ALTER TABLE `zstack`.`SlbVmInstanceVO` DROP KEY `fkSlbVmInstanceVOSlbGroupVO`;
ALTER TABLE `zstack`.`SlbVmInstanceVO` MODIFY COLUMN `slbGroupUuid` varchar(32) DEFAULT NULL;
ALTER TABLE `zstack`.`SlbVmInstanceVO` ADD CONSTRAINT `fkSlbVmInstanceVOVmInstanceEO` FOREIGN KEY (`uuid`) REFERENCES `VmInstanceEO` (`uuid`) ON DELETE CASCADE;
ALTER TABLE `zstack`.`SlbVmInstanceVO` ADD CONSTRAINT `fkSlbVmInstanceVOSlbGroupVO` FOREIGN KEY (`slbGroupUuid`) REFERENCES `SlbGroupVO` (`uuid`) ON DELETE SET NULL;
+
+create table if not exists `zstack`.`HostAllocatedCPUVO` (
+ uuid varchar(32) null,
+ allocatedCPU TEXT not null,
+ constraint HostAllocatedCPUVO_pk
+ primary key (uuid),
+ constraint uuid
+ foreign key (uuid) references HostEO (uuid)
+);
+
+create table if not exists `zstack`.`VmInstanceNUMAVO` (
+ id bigint not null auto_increment,
+ uuid varchar(32) not null,
+ vNodeID int not null,
+ vNodeCPUs varchar(512) not null,
+ vNodeMemSize bigint not null,
+ vNodeDistance varchar(512) not null,
+ pNodeID int not null,
+ constraint VmInstanceNUMAVO_pk
+ primary key (id),
+ constraint VmInstanceNUMAVO_VmInstanceEO_uuid_fk
+ foreign key (uuid) references VmInstanceEO (uuid)
+);
+
+create table if not exists `zstack`.`HostNUMATopologyVO` (
+ id bigint not null auto_increment,
+ uuid varchar(32) not null,
+ nodeID int not null,
+ nodeCPUs varchar(512) not null,
+ nodeMemSize bigint not null,
+ nodeDistance varchar(512) not null,
+ constraint HostNumaTopologyVO_pk
+ primary key (id),
+ constraint HostNumaTopologyVO_HostEO_uuid_fk
+ foreign key (uuid) references HostEO (uuid)
+);
