114 lines
1.7 KiB
SQL
114 lines
1.7 KiB
SQL
|
|
-- ./hostdev.xlsx
|
|
|
|
|
|
|
|
|
|
|
|
drop table if exists hostdev;
|
|
CREATE TABLE hostdev
|
|
(
|
|
|
|
`id` VARCHAR(32) comment 'id',
|
|
`name` VARCHAR(400) comment '主机名称',
|
|
`description` VARCHAR(500) comment '描述',
|
|
`ownerid` VARCHAR(32) comment '属主id',
|
|
`hostname` VARCHAR(400) comment '域名',
|
|
`local_ip` VARCHAR(100) comment '内网地址',
|
|
`external_ip` VARCHAR(100) comment '外网地址',
|
|
`port` int comment '端口',
|
|
`user` VARCHAR(400) comment '用户',
|
|
`passwd` VARCHAR(400) comment '用户密码',
|
|
`jumperid` VARCHAR(32) comment '跳板id'
|
|
|
|
|
|
,primary key(id)
|
|
|
|
|
|
)
|
|
engine=innodb
|
|
default charset=utf8
|
|
comment '主机设备'
|
|
;
|
|
|
|
|
|
-- ./jumper.xlsx
|
|
|
|
|
|
|
|
|
|
|
|
drop table if exists jumper;
|
|
CREATE TABLE jumper
|
|
(
|
|
|
|
`id` VARCHAR(32) comment 'id',
|
|
`name` VARCHAR(400) comment '跳板名称',
|
|
`ownerid` VARCHAR(32) comment '属主id'
|
|
|
|
|
|
,primary key(id)
|
|
|
|
|
|
)
|
|
engine=innodb
|
|
default charset=utf8
|
|
comment '跳板'
|
|
;
|
|
|
|
|
|
-- ./xterm.xlsx
|
|
|
|
|
|
|
|
|
|
|
|
drop table if exists xterm;
|
|
CREATE TABLE xterm
|
|
(
|
|
|
|
`id` VARCHAR(32) comment 'id',
|
|
`name` VARCHAR(400) comment '终端名称',
|
|
`description` VARCHAR(500) comment '描述',
|
|
`ownerid` VARCHAR(32) comment '属主id',
|
|
`hostid` VARCHAR(400) comment '主机id',
|
|
`cmd` VARCHAR(4000) comment '命令'
|
|
|
|
|
|
,primary key(id)
|
|
|
|
|
|
)
|
|
engine=innodb
|
|
default charset=utf8
|
|
comment '终端'
|
|
;
|
|
|
|
|
|
-- ./jumperhost.xlsx
|
|
|
|
|
|
|
|
|
|
|
|
drop table if exists jumperhost;
|
|
CREATE TABLE jumperhost
|
|
(
|
|
|
|
`id` VARCHAR(32) comment 'id',
|
|
`stepno` int comment '跳步顺序',
|
|
`jumperid` VARCHAR(400) comment '跳板id',
|
|
`hostid` VARCHAR(500) comment '主机id'
|
|
|
|
|
|
,primary key(id)
|
|
|
|
|
|
)
|
|
engine=innodb
|
|
default charset=utf8
|
|
comment '跳板主机'
|
|
;
|
|
|
|
|