| | |
| | | create table sys_soft ( |
| | | soft_id bigint(20) not null auto_increment comment '软件ID', |
| | | name varchar(200) not null comment '名称', |
| | | type char(1) default '0' comment '类型(0-应用软件,1-数据库,2-中间件,3-操作系统)', |
| | | type char(1) default '0' comment '类型(0-应用软件,1-数据库,2-中间件,3-操作系统,4-Docker容器)', |
| | | lic varchar(500) comment '许可', |
| | | descr varchar(500) comment '描述', |
| | | args varchar(8000) comment '参数', |
| | |
| | | ) engine=innodb auto_increment=1 comment = '软件表'; |
| | | select * from sys_soft order by soft_id; |
| | | |
| | | insert into sys_soft (name, type, args) values ('se-mysql', 4, 'se-mysql'); |
| | | insert into sys_soft (name, type, args) values ('se-redis', 4, 'se-redis'); |
| | | insert into sys_soft (name, type, args) values ('se-system', 4, 'se-system'); |
| | | insert into sys_soft (name, type, args) values ('se-wgcloud', 4, 'se-wgcloud'); |
| | | |
| | | -- ---------------------------- |
| | | -- 02、硬件表 |