前往新版Gitcode,体验更适合开发者的 AI 搜索 >>
set names utf8; drop database if exists n9e_ams; create database n9e_ams; use n9e_ams; CREATE TABLE `host` ( `id` int unsigned not null AUTO_INCREMENT, `sn` char(128) not null default '', `ip` char(15) not null, `ident` varchar(128) not null default '', `name` varchar(128) not null default '', `cpu` varchar(255) not null default '', `mem` varchar(255) not null default '', `disk` varchar(255) not null default '', `note` varchar(255) not null default 'different with resource note', `cate` varchar(32) not null comment 'host,vm,container,switch', `tenant` varchar(128) not null default '', `clock` bigint not null comment 'heartbeat timestamp', PRIMARY KEY (`id`), UNIQUE KEY (`ip`), UNIQUE KEY (`ident`), KEY (`sn`), KEY (`name`), KEY (`tenant`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8; /* 网络设备管理、机柜机架、配件耗材等相关的功能是商业版本才有的,表结构不要放到这里 */