我要评论
数据库表搭建:
思路:管理通讯协议,通过相关配置文件输出相关指令集
例:实例使用cj-t188-2004《户用计量仪表数据传输技术条件》做案例配置
protocolgroup：通讯协议登记表
/*
navicat premium data transfer
source server : root
source server type : mysql
source server version : 80400 (8.4.0)
source host : localhost:3306
source schema : devopsos
target server type : mysql
target server version : 80400 (8.4.0)
file encoding : 65001
date: 12/06/2024 12:47:05
name: 马铃薯
*/
set names utf8mb4;
set foreign_key_checks = 0;
-- ----------------------------
-- table structure for protocolgroup
-- ----------------------------
drop table if exists `protocolgroup`;
create table `protocolgroup` (
`id` int not null auto_increment comment '自动编号',
`protocolencoding` varchar(20) character set gb2312 collate gb2312_chinese_ci null default null comment '自定义协议编码',
`protocolname` varchar(255) character set gb2312 collate gb2312_chinese_ci null default null comment '协议名称',
`source` varchar(255) character set gb2312 collate gb2312_chinese_ci null default null comment '协议来源',
`islocked` int not null comment '锁定',
`status` int not null comment '状态',
`isdeleted` int not null comment '删除',
`createdon` datetime(6) not null comment '创建时间',
`createdbyuserguid` char(36) character set ascii collate ascii_general_ci not null comment '创建者guid',
`createdbyusername` longtext character set utf8mb4 collate utf8mb4_0900_ai_ci null comment '创建者',
`modifiedon` datetime(6) null default null comment '修改时间',
`modifiedbyuserguid` char(36) character set ascii collate ascii_general_ci null default null comment '修改者guid',
`modifiedbyusername` longtext character set utf8mb4 collate utf8mb4_0900_ai_ci null comment '修改者',
`description` varchar(800) character set utf8mb4 collate utf8mb4_0900_ai_ci null default null comment '描述',
`isseed` int null default 0 comment '种子',
primary key (`id`) using btree
) engine = innodb auto_increment = 4 character set = gb2312 collate = gb2312_chinese_ci comment = '协议组' row_format = dynamic;
-- ----------------------------
-- records of protocolgroup
-- ----------------------------
insert into `protocolgroup` values (3, '100001', 'cj-t188-2004《户用计量仪表数据传输技术条件》', '协会', 0, 0, 0, '2024-06-11 10:31:13.000000', 'a1', '管理员', null, null, null, null, 0);
set foreign_key_checks = 1;
结果显示
发表评论