创建虚拟机带宽和安全组数据库表sql文件

以下是创建虚拟机带宽和安全组数据库表的SQL文件：

1. 创建虚拟机带宽表：

CREATE TABLE `virtual_machine_bandwidth` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `vm_id` int(11) NOT NULL,
  `bandwidth` int(11) NOT NULL,
  `create_time` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_vm_id` (`vm_id`),
  CONSTRAINT `fk_vm_id` FOREIGN KEY (`vm_id`) REFERENCES `virtual_machine` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

2. 创建安全组表：

CREATE TABLE `security_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `create_time` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

3. 创建安全组规则表：

CREATE TABLE `security_group_rule` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `security_group_id` int(11) NOT NULL,
  `direction` enum('inbound','outbound') NOT NULL,
  `protocol` varchar(255) NOT NULL,
  `port_range` varchar(255) NOT NULL,
  `source_ip_range` varchar(255) DEFAULT NULL,
  `target_ip_range` varchar(255) DEFAULT NULL,
  `create_time` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_sg_id` (`security_group_id`),
  CONSTRAINT `fk_sg_id` FOREIGN KEY (`security_group_id`) REFERENCES `security_group` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;