2097 lines
138 KiB
SQL
2097 lines
138 KiB
SQL
SET NAMES utf8mb4;
|
||
SET FOREIGN_KEY_CHECKS = 0;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ap_art_post
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ap_art_post`;
|
||
CREATE TABLE `ap_art_post` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`sectionid` int(11) NOT NULL COMMENT '|版块|,DB,ap_art_section',
|
||
`artstatus` int(11) NOT NULL COMMENT '|文章状态|,CATA,artstatus',
|
||
`artsort` int(11) NOT NULL COMMENT '|推荐排序|,CATA,artsort',
|
||
`name` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文章标题',
|
||
`source` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '来源',
|
||
`author` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '作者',
|
||
`studycnt` int(11) NOT NULL DEFAULT 0 COMMENT '精读数|',
|
||
`readcnt` int(11) NOT NULL COMMENT '阅读数|',
|
||
`avmp` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '音视频,AV',
|
||
`img` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '缩略图,IMG1',
|
||
`descs` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',摘要,BR',
|
||
`inputuser` int(11) NOT NULL COMMENT '撰写人,CATA,adminuser',
|
||
`audituser` int(11) NOT NULL DEFAULT 0 COMMENT '审核人,CATA,adminuser',
|
||
`pubtimes` bigint(20) NOT NULL DEFAULT 0 COMMENT '发布时间,DATE',
|
||
`content` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',内容,MD',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
INDEX `ossa`(`sectionid`, `artstatus`, `artsort`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '版块文章表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ap_art_post
|
||
-- ----------------------------
|
||
INSERT INTO `ap_art_post` VALUES (7, 1, 100, 40, 'AI决策调试', '', '', 13, 27, '', '/2025/0502/art/055507_3610.png', '', 10, 10, 1750889011, '[MD]帮助\n帮助\n帮助\n');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ap_art_section
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ap_art_section`;
|
||
CREATE TABLE `ap_art_section` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '|ID|',
|
||
`ngroup` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '分组名',
|
||
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '版块名称',
|
||
`auditcnt` int(11) NOT NULL DEFAULT 0 COMMENT '待审数|',
|
||
`artcnt` int(11) NOT NULL DEFAULT 0 COMMENT '文章数|',
|
||
`adminuser` int(11) NOT NULL COMMENT '责任人,CATA,adminuser',
|
||
`addtimes` bigint(20) NOT NULL COMMENT '创建时间,DATE',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '版块表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ap_art_section
|
||
-- ----------------------------
|
||
INSERT INTO `ap_art_section` VALUES (1, 'help', '帮助中心', 0, 1, 10, 1750888993);
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ap_art_vent
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ap_art_vent`;
|
||
CREATE TABLE `ap_art_vent` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`sectionid` int(11) NOT NULL COMMENT '|版块|,DB,ap_art_section',
|
||
`artid` int(11) NOT NULL COMMENT '|文章|,DB,ap_art_post',
|
||
`vuser` bigint(20) NOT NULL COMMENT '所属用户,DB,ap_user',
|
||
`content` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '内容,BR',
|
||
`pubtimes` bigint(20) NOT NULL DEFAULT 0 COMMENT '反馈时间,DATE',
|
||
`audituser` int(11) NOT NULL DEFAULT 0 COMMENT '阅读人,CATA,adminuser',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
INDEX `ossa`(`artid`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '文章反馈表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ap_art_vent
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ap_banner
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ap_banner`;
|
||
CREATE TABLE `ap_banner` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`groupcode` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '|组别代码|',
|
||
`img` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '轮播图,IMG1',
|
||
`url` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '链接',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 48 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '轮播图表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ap_banner
|
||
-- ----------------------------
|
||
INSERT INTO `ap_banner` VALUES (24, 'index', '/img/banner.webp', '');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ap_cash_bundle
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ap_cash_bundle`;
|
||
CREATE TABLE `ap_cash_bundle` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`chargemoney` int(11) NOT NULL COMMENT '充值金额|,CNY',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '充值套餐表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ap_cash_bundle
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ap_cash_ie
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ap_cash_ie`;
|
||
CREATE TABLE `ap_cash_ie` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`cashtype` int(11) NOT NULL COMMENT '收支分类,CATA,cashtype',
|
||
`vuser` bigint(20) NOT NULL COMMENT '所属用户,DB,ap_user',
|
||
`iemoney` int(11) NOT NULL COMMENT '金额|,CNY',
|
||
`addtimes` bigint(20) NOT NULL COMMENT '发生时间,DATE',
|
||
`name` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '摘要',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '收支记录' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ap_cash_ie
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ap_cash_in
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ap_cash_in`;
|
||
CREATE TABLE `ap_cash_in` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`vuser` bigint(20) NOT NULL COMMENT '所属用户,DB,ap_user',
|
||
`inmoney` int(11) NOT NULL COMMENT '充值金额|,CNY',
|
||
`addtimes` bigint(20) NOT NULL COMMENT '发生时间,DATE',
|
||
`name` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '支付流水号',
|
||
`paytimes` bigint(20) NOT NULL DEFAULT 0 COMMENT '支付时间,DATE',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '充值记录' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ap_cash_in
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ap_cash_oe
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ap_cash_oe`;
|
||
CREATE TABLE `ap_cash_oe` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`cashtype` int(11) NOT NULL COMMENT '收支分类,CATA,cashtype',
|
||
`vuser` bigint(20) NOT NULL COMMENT '所属用户,DB,ap_user',
|
||
`oemoney` int(11) NOT NULL COMMENT '金额|,CNY',
|
||
`addtimes` bigint(20) NOT NULL COMMENT '发生时间,DATE',
|
||
`name` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '摘要',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 154 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '收益记录' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ap_cash_oe
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ap_cash_out
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ap_cash_out`;
|
||
CREATE TABLE `ap_cash_out` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`cashstatus` int(11) NOT NULL COMMENT '|提现状态|,CATA,cashstatus',
|
||
`vuser` bigint(20) NOT NULL COMMENT '所属用户,DB,ap_user',
|
||
`cashtype` int(11) NOT NULL COMMENT '提现方式,BOOL,银行.微信',
|
||
`cashmoney` int(10) NOT NULL COMMENT '提现金额|,CNY',
|
||
`taxmoney` int(11) NOT NULL COMMENT '代缴个税|,CNY',
|
||
`addtimes` bigint(20) NOT NULL COMMENT '申请时间,DATE',
|
||
`cashtimes` bigint(20) NOT NULL DEFAULT 0 COMMENT '操作时间,DATE',
|
||
`cashno` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '支付编号',
|
||
`auditmsg` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '拒绝原因',
|
||
`bankaccount` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '账户名称',
|
||
`bankno` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '银行卡号',
|
||
`bankname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '开户银行',
|
||
`bankcode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '联行号',
|
||
`invfile` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '发票,DOWN',
|
||
`invcode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '发票号码',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '提现记录' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ap_cash_out
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ap_invoicedetail
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ap_invoicedetail`;
|
||
CREATE TABLE `ap_invoicedetail` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
|
||
`uptimes` bigint(20) NOT NULL COMMENT '更新时间,DATE',
|
||
`adminuser` int(11) NOT NULL DEFAULT 0 COMMENT '维护人,CATU,adminuser',
|
||
`memo` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '备注信息',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '发票类型表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ap_invoicedetail
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ap_invoicetitle
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ap_invoicetitle`;
|
||
CREATE TABLE `ap_invoicetitle` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`vuser` bigint(20) NOT NULL COMMENT '所属用户,DB,ap_user',
|
||
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
|
||
`taxnumber` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '税号',
|
||
`addr` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '单位地址',
|
||
`phone` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '电话号码',
|
||
`bankname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '银行名称',
|
||
`bankaccount` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '银行账号',
|
||
`uptimes` bigint(20) NOT NULL COMMENT '更新时间,DATE',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '发票抬头表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ap_invoicetitle
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ap_invoicing
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ap_invoicing`;
|
||
CREATE TABLE `ap_invoicing` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`auditstatus` int(11) NOT NULL DEFAULT 0 COMMENT '|审核状态|,CATA,auditstatus',
|
||
`vuser` bigint(20) NOT NULL COMMENT '所属用户,DB,ap_user',
|
||
`invoicetitleid` int(11) NOT NULL COMMENT ',所属抬头,DB,ap_invoicetitle',
|
||
`invoicedetailid` int(11) NOT NULL COMMENT '所属明细,DB,ap_invoicedetail',
|
||
`invoicemoney` int(11) NOT NULL COMMENT '开票金额|,CNY',
|
||
`invfile` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '发票,DOWN',
|
||
`invcode` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '发票号码',
|
||
`addtimes` bigint(20) NOT NULL COMMENT '申请时间,DATE',
|
||
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
|
||
`taxnumber` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '税号',
|
||
`addr` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '单位地址',
|
||
`phone` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '电话号码',
|
||
`bankname` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '银行名称',
|
||
`bankaccount` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '银行账号',
|
||
`audittimes` bigint(20) NOT NULL DEFAULT 0 COMMENT '操作时间,DATE',
|
||
`audituser` int(11) NOT NULL DEFAULT 0 COMMENT '操作人,CATU,adminuser',
|
||
`auditmsg` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '拒开原因',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '发票开票表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ap_invoicing
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ap_log
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ap_log`;
|
||
CREATE TABLE `ap_log` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`loguser` bigint(20) NOT NULL COMMENT '所属用户,DB,ap_user',
|
||
`readuser` int(11) NOT NULL COMMENT '审阅人,CATA,adminuser',
|
||
`types` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'LOG分类',
|
||
`addtimes` bigint(20) NOT NULL COMMENT '发生日期,DATE',
|
||
`ip` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'IP,IP',
|
||
`logs` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '详情',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 3432 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '应用日志表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ap_log
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ap_lug
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ap_lug`;
|
||
CREATE TABLE `ap_lug` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`isinout` int(11) NOT NULL COMMENT '|登录|,BOOL,登入.登出',
|
||
`loguser` bigint(20) NOT NULL COMMENT '所属用户,DB,ap_user',
|
||
`addtimes` bigint(20) NOT NULL COMMENT '发生日期,DATE',
|
||
`ip` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'IP,IP',
|
||
`model` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '设备指纹',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 3443 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '登录记录表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ap_lug
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ap_paper
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ap_paper`;
|
||
CREATE TABLE `ap_paper` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
|
||
`title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '显示标题',
|
||
`readcnt` int(11) NOT NULL DEFAULT 0 COMMENT '阅读数|',
|
||
`inputuser` int(11) NOT NULL COMMENT '撰写人,CATA,adminuser',
|
||
`uptimes` bigint(20) NOT NULL COMMENT '更新时间,DATE',
|
||
`content` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',内容,MD',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 24 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '独立文档表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ap_paper
|
||
-- ----------------------------
|
||
INSERT INTO `ap_paper` VALUES (1, '关于平台', '', 140, 10, 1750889405, '[MD]无标题通屏效果\n建议顶部图片留有60px的空间，躲避刘海屏');
|
||
INSERT INTO `ap_paper` VALUES (2, '软件帮助', '', 29, 10, 1750889540, '[MD]#大标题\n#c标题居中\n##小标题\n###小标题\n正文\n###小标题\n####四级标题\n正文\n####四级标题\n正文\n##小标题\n正文\n@c居中显示\n@r右侧显示\n反引号`强调`显示\n\n!/ud/2024/07/16/paper/1017421516.mp3\n');
|
||
INSERT INTO `ap_paper` VALUES (3, '用户协议', '用户协议', 33, 10, 1737970492, '[MD]用户协议xxx');
|
||
INSERT INTO `ap_paper` VALUES (4, '隐私协议', '', 0, 10, 1750889552, '[MD]');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ap_pnt_bundle
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ap_pnt_bundle`;
|
||
CREATE TABLE `ap_pnt_bundle` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`buypnt` int(11) NOT NULL COMMENT '金币|,INT',
|
||
`buymoney` int(11) NOT NULL COMMENT '金额|,CNY',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '金币套餐表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ap_pnt_bundle
|
||
-- ----------------------------
|
||
INSERT INTO `ap_pnt_bundle` VALUES (1, 1000, 200);
|
||
INSERT INTO `ap_pnt_bundle` VALUES (2, 8000, 1000);
|
||
INSERT INTO `ap_pnt_bundle` VALUES (3, 18000, 2000);
|
||
INSERT INTO `ap_pnt_bundle` VALUES (4, 100000, 10000);
|
||
INSERT INTO `ap_pnt_bundle` VALUES (5, 200000, 20000);
|
||
INSERT INTO `ap_pnt_bundle` VALUES (6, 500000, 50000);
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ap_pnt_buy
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ap_pnt_buy`;
|
||
CREATE TABLE `ap_pnt_buy` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`vuser` bigint(20) NOT NULL COMMENT '所属用户,DB,ap_user',
|
||
`name` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '支付流水',
|
||
`pnt` int(11) NOT NULL COMMENT '金币|,INT',
|
||
`buypntmoney` int(10) NOT NULL COMMENT '金额|,CNY',
|
||
`addtimes` bigint(20) NOT NULL COMMENT '提交时间,DATE',
|
||
`paytimes` bigint(20) NOT NULL DEFAULT 0 COMMENT '支付时间,DATE',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 64 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '金币购买记录' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ap_pnt_buy
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ap_pnt_record
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ap_pnt_record`;
|
||
CREATE TABLE `ap_pnt_record` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`vuser` bigint(20) NOT NULL COMMENT '所属用户,DB,ap_user',
|
||
`addtimes` bigint(20) NOT NULL COMMENT '发生时间,DATE',
|
||
`pnt` int(11) NOT NULL COMMENT '积分|,INT',
|
||
`fromid` int(11) NOT NULL DEFAULT 0,
|
||
`name` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '摘要',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 117 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '积分流水' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ap_pnt_record
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ap_pnt_track
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ap_pnt_track`;
|
||
CREATE TABLE `ap_pnt_track` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '|TrackID|',
|
||
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '埋点名称',
|
||
`point` int(11) NOT NULL COMMENT '可获金币|,INT,分',
|
||
`limh24` int(11) NOT NULL COMMENT '24小时上限|,INT,分',
|
||
`adminuser` int(11) NOT NULL COMMENT '操作人,CATA,adminuser',
|
||
`uptimes` bigint(20) NOT NULL COMMENT '更新时间,DATE',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '积分埋点表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ap_pnt_track
|
||
-- ----------------------------
|
||
INSERT INTO `ap_pnt_track` VALUES (1, '登录签到', 2, 2, 10, 1738132278);
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ap_tokapi
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ap_tokapi`;
|
||
CREATE TABLE `ap_tokapi` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '|appid|',
|
||
`apisecret` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',appkey',
|
||
`ips` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '白名单IP,BR',
|
||
`addtimes` bigint(20) NOT NULL COMMENT '创建时间,DATE',
|
||
`pubkey` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '|公钥证书|',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 215698 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'API授权管理' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ap_tokapi
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ap_transfer
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ap_transfer`;
|
||
CREATE TABLE `ap_transfer` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '|流水号|',
|
||
`orderstatus` int(11) NOT NULL COMMENT '|交易状态|,CATA,orderstatus',
|
||
`amount` bigint(20) NOT NULL COMMENT '金额|,CNY',
|
||
`addtimes` bigint(20) NOT NULL COMMENT '创建时间,DATE',
|
||
`uptimes` bigint(20) NOT NULL COMMENT '完成时间,DATE',
|
||
`apiid` int(11) NOT NULL COMMENT 'APIID',
|
||
`thirdno` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '调用方单号',
|
||
`notifyurl` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '回调地址',
|
||
`signature` varchar(600) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',签名',
|
||
`retimes` bigint(20) NOT NULL COMMENT '回调时间,DATE',
|
||
`nexttimes` bigint(20) NOT NULL COMMENT '下次回调时间,DATE',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
INDEX `mo`(`orderstatus`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 54390876 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '交易单' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ap_transfer
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ap_user
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ap_user`;
|
||
CREATE TABLE `ap_user` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '|会员编号|',
|
||
`icon` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '头像,IMG1',
|
||
`name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户昵称',
|
||
`mobile` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '手机号',
|
||
`userlevel` int(11) NOT NULL COMMENT '|用户等级|,CATA,userlevel',
|
||
`stpstatus` int(11) NOT NULL COMMENT '|账号状态|,CATA,stpstatus',
|
||
`mymoney` int(11) NOT NULL DEFAULT 0 COMMENT '可用余额|,CNY',
|
||
`mycashmoney` int(11) NOT NULL DEFAULT 0 COMMENT '可提现余额|,CNY',
|
||
`myinvmoney` int(11) NOT NULL COMMENT '待开票金额|,CNY',
|
||
`mybondmoney` int(11) NOT NULL DEFAULT 0 COMMENT '保证金|,CNY',
|
||
`mypnt` int(11) NOT NULL COMMENT '积分|,INT',
|
||
`certs` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '认证,CATS,certs',
|
||
`accounttimes` bigint(20) NOT NULL COMMENT '有效期至,DATE,Y-m-d',
|
||
`logintimes` bigint(20) NOT NULL COMMENT '登录时间,DATE',
|
||
`addtimes` bigint(20) NOT NULL COMMENT '注册日期,DATE,Y-m-d',
|
||
`upid` int(11) NOT NULL COMMENT '分享人,DB,ep_user',
|
||
`password` varchar(70) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT ',密码',
|
||
`trytime` int(11) NOT NULL DEFAULT 0 COMMENT ',密码重试次数',
|
||
`memo` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '备注',
|
||
`power` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT ',权限表',
|
||
`wxunionid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT ',微信UnionID',
|
||
`wxminaid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT ',小程序OpenID',
|
||
`wxminakey` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT ',小程序Key',
|
||
`sid` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT ',授权码',
|
||
`exptimes` bigint(20) NOT NULL COMMENT ',授权过期时间,DATE',
|
||
`ip` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '#登录IP,IP',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
INDEX `mobile`(`mobile`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 187 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '会员主表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ap_user
|
||
-- ----------------------------
|
||
INSERT INTO `ap_user` VALUES (100, '', '众产用户1', '1', 10, 10, 0, 15222, 0, 0, 1016, '', 1881085490, 1768651495, 1751086978, 0, 'd527d1bf5fe6a4361f230af48e36e1c4', 0, '', '', '', '', '', '', 1768688483, '');
|
||
-- ----------------------------
|
||
-- Table structure for ap_usr_buy_bundle
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ap_usr_buy_bundle`;
|
||
CREATE TABLE `ap_usr_buy_bundle` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '套餐说明',
|
||
`userlevel` int(11) NOT NULL COMMENT '对应等级,CATA,userlevel',
|
||
`days` int(11) NOT NULL COMMENT '天数|,INT',
|
||
`usermoney` int(11) NOT NULL COMMENT '金额|,CNY',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '会员套餐表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ap_usr_buy_bundle
|
||
-- ----------------------------
|
||
INSERT INTO `ap_usr_buy_bundle` VALUES (1, '30天', 10, 30, 880);
|
||
INSERT INTO `ap_usr_buy_bundle` VALUES (2, '全年', 10, 365, 6800);
|
||
INSERT INTO `ap_usr_buy_bundle` VALUES (3, '永久', 10, 36500, 68800);
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ap_usr_buy_user
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ap_usr_buy_user`;
|
||
CREATE TABLE `ap_usr_buy_user` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`vuser` bigint(20) NOT NULL COMMENT '所属用户,DB,ap_user',
|
||
`bundleid` int(11) NOT NULL COMMENT '所属套餐,DB,ap_usr_buy_bundle',
|
||
`userlevel` int(11) NOT NULL COMMENT '对应等级,CATA,userlevel',
|
||
`days` int(11) NOT NULL COMMENT '会员天数|,INT',
|
||
`buydaymoney` int(10) NOT NULL COMMENT '金额|,CNY',
|
||
`addtimes` bigint(20) NOT NULL COMMENT '提交时间,DATE',
|
||
`paytimes` bigint(20) NOT NULL DEFAULT 0 COMMENT '支付时间,DATE',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 78 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '会员购买记录' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ap_usr_buy_user
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ap_usr_capcode
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ap_usr_capcode`;
|
||
CREATE TABLE `ap_usr_capcode` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`vuser` bigint(20) NOT NULL COMMENT '所属用户,DB,ap_user',
|
||
`account` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '账号',
|
||
`code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '验证码',
|
||
`addtimes` bigint(20) NOT NULL COMMENT '生成时间,DATE',
|
||
`exptimes` bigint(20) NOT NULL COMMENT '到期时间,DATE',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户验证码表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ap_usr_capcode
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ap_usr_ext
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ap_usr_ext`;
|
||
CREATE TABLE `ap_usr_ext` (
|
||
`id` bigint(20) NOT NULL,
|
||
`truename` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '真实姓名',
|
||
`email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '电子信箱',
|
||
`wxno` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '微信号',
|
||
`idid` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '身份证号',
|
||
`cciy` bigint(20) NOT NULL DEFAULT 0 COMMENT '众识码,CCIY',
|
||
`appcid` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'APPpush',
|
||
`cashtype` int(11) NOT NULL DEFAULT 2 COMMENT '提现方式,BOOL,网银提现.微信提现',
|
||
`bankaccount` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '账户名称',
|
||
`bankno` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '银行卡号',
|
||
`bankname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '开户银行',
|
||
`bankcode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '联行号',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '会员副表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ap_usr_ext
|
||
-- ----------------------------
|
||
INSERT INTO `ap_usr_ext` VALUES (100, '', '', '', '', 0, '', 1, '', '', '', '');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ap_usr_invoicetitle
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ap_usr_invoicetitle`;
|
||
CREATE TABLE `ap_usr_invoicetitle` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`vuser` bigint(20) NOT NULL COMMENT '所属用户,DB,ap_user',
|
||
`name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
|
||
`taxnumber` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '税号',
|
||
`addr` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '单位地址',
|
||
`phone` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '电话号码',
|
||
`bankname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '银行名称',
|
||
`bankaccount` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '银行账号',
|
||
`uptimes` bigint(20) NOT NULL COMMENT '更新时间,DATE',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '发票抬头表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ap_usr_invoicetitle
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ap_usr_invoicing
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ap_usr_invoicing`;
|
||
CREATE TABLE `ap_usr_invoicing` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`vuser` bigint(20) NOT NULL COMMENT '所属用户,DB,ap_user',
|
||
`invoicemoney` int(11) NOT NULL COMMENT '开票金额|,CNY',
|
||
`invoicetitleid` int(11) NOT NULL COMMENT ',所属抬头,DB,ap_usr_invoicetitle',
|
||
`name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
|
||
`taxnumber` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',税号',
|
||
`addr` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',单位地址',
|
||
`phone` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',电话号码',
|
||
`bankname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',银行名称',
|
||
`bankaccount` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',银行账号',
|
||
`addtimes` bigint(20) NOT NULL COMMENT '申请时间,DATE',
|
||
`invtimes` bigint(20) NOT NULL DEFAULT 0 COMMENT '开票时间,DATE',
|
||
`invuser` int(11) NOT NULL DEFAULT 0 COMMENT '开票人,CATU,adminuser',
|
||
`invfile` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '发票,DOWN',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '发票开票表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ap_usr_invoicing
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ap_usr_problechat
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ap_usr_problechat`;
|
||
CREATE TABLE `ap_usr_problechat` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`problemid` int(11) NOT NULL,
|
||
`sendtype` int(11) NOT NULL COMMENT '发送人,TINT,1.用户,2.平台,3.AI客服',
|
||
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '答复内容',
|
||
`addtimes` bigint(20) NOT NULL COMMENT '发送时间,DATE',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 54 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '工单对话表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ap_usr_problechat
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ap_usr_problem
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ap_usr_problem`;
|
||
CREATE TABLE `ap_usr_problem` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`vuser` bigint(20) NOT NULL COMMENT '所属用户,DB,ap_user',
|
||
`contract` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '联系方式',
|
||
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '工单提问,BR',
|
||
`imgs` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '图片,IMG',
|
||
`addtimes` bigint(20) NOT NULL COMMENT '提交时间,DATE',
|
||
`replytimes` bigint(20) NOT NULL DEFAULT 0 COMMENT '回复时间,DATE',
|
||
`closetimes` bigint(20) NOT NULL DEFAULT 0 COMMENT '关闭时间,DATE',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '问题工单表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ap_usr_problem
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ap_usr_real_apply
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ap_usr_real_apply`;
|
||
CREATE TABLE `ap_usr_real_apply` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`auditstatus` int(11) NOT NULL COMMENT '|审核状态|,CATA,auditstatus',
|
||
`vuser` bigint(20) NOT NULL COMMENT '所属用户,DB,ap_user',
|
||
`name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '真实姓名',
|
||
`idid` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '身份证号',
|
||
`idcard1` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '身份证人像面,IMG1',
|
||
`idcard2` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '身份证国徽面,IMG1',
|
||
`addtimes` bigint(20) NOT NULL COMMENT '申请时间,DATE',
|
||
`audituser` int(11) NOT NULL DEFAULT 0 COMMENT '审核员,CATA,adminuser',
|
||
`audittimes` bigint(20) NOT NULL DEFAULT 0 COMMENT '审核时间,DATE',
|
||
`auditmsg` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '驳回原因',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '实名认证申请表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ap_usr_real_apply
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ap_usr_sendmail
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ap_usr_sendmail`;
|
||
CREATE TABLE `ap_usr_sendmail` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`vuser` int(11) NOT NULL COMMENT '所属用户,DB,ap_user',
|
||
`email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '邮件地址',
|
||
`chan` int(11) NOT NULL COMMENT '通道号',
|
||
`name` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '标题',
|
||
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',邮件内容',
|
||
`addtimes` bigint(20) NOT NULL COMMENT '添加时间,DATE',
|
||
`sendtimes` bigint(20) NOT NULL COMMENT '发送时间,DATE',
|
||
`donetimes` bigint(20) NOT NULL DEFAULT 0 COMMENT '完成时间,DATE',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '发送邮件' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ap_usr_sendmail
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ap_usr_sendsms
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ap_usr_sendsms`;
|
||
CREATE TABLE `ap_usr_sendsms` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`vuser` int(11) NOT NULL COMMENT '所属用户,DB,ap_user',
|
||
`mobile` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '手机号',
|
||
`chan` int(11) NOT NULL COMMENT '通道号',
|
||
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',JSON内容',
|
||
`addtimes` bigint(20) NOT NULL COMMENT '添加时间,DATE',
|
||
`sendtimes` bigint(20) NOT NULL COMMENT '发送时间,DATE',
|
||
`donetimes` bigint(20) NOT NULL DEFAULT 0 COMMENT '完成时间,DATE',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 138 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '发送短信' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ap_usr_sendsms
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ap_usr_shipaddr
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ap_usr_shipaddr`;
|
||
CREATE TABLE `ap_usr_shipaddr` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`vuser` bigint(20) NOT NULL COMMENT '所属用户,DB,ap_user',
|
||
`areacode` int(11) NOT NULL COMMENT '所在地区,CATM,ciy_arearpc|<code>?</code>',
|
||
`addr` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '详细地址',
|
||
`name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '收件人',
|
||
`phone` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '联系电话',
|
||
`uptimes` bigint(20) NOT NULL COMMENT '更新时间,DATE',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 70 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '收货地址表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ap_usr_shipaddr
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ap_usr_suggest
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ap_usr_suggest`;
|
||
CREATE TABLE `ap_usr_suggest` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`vuser` bigint(20) NOT NULL COMMENT '所属用户,DB,ap_user',
|
||
`contract` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '联系方式',
|
||
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '建议内容,BR',
|
||
`imgs` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '图片,IMG',
|
||
`addtimes` bigint(20) NOT NULL COMMENT '提交时间,DATE',
|
||
`replyuser` int(11) NOT NULL DEFAULT 0 COMMENT '答复人,CATA,adminuser',
|
||
`replytimes` bigint(20) NOT NULL DEFAULT 0 COMMENT '答复时间,DATE',
|
||
`replymsg` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '答复内容,BR',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '意见建议表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ap_usr_suggest
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for ciy_bankcode
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `ciy_bankcode`;
|
||
CREATE TABLE `ciy_bankcode` (
|
||
`id` bigint(20) NOT NULL COMMENT '联行号',
|
||
`bkcode` int(11) NOT NULL COMMENT '前三位银行码',
|
||
`name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '银行名称',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '中国联行号' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of ciy_bankcode
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for demo_normal
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `demo_normal`;
|
||
CREATE TABLE `demo_normal` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID,ENID',
|
||
`auditstatus` int(11) NOT NULL COMMENT '|审核状态|,CATA,auditstatus',
|
||
`audituser` int(11) NOT NULL DEFAULT 0 COMMENT '审核人,CATU,adminuser',
|
||
`audittimes` bigint(20) NOT NULL COMMENT '审核时间,DATE',
|
||
`auditmsg` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '审核理由',
|
||
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '默认标题',
|
||
`menuid` int(11) NOT NULL COMMENT '所属菜单,DB,zc_menu',
|
||
`filesize` int(11) NOT NULL COMMENT '文件大小|,FSIZE',
|
||
`metre` int(11) NOT NULL COMMENT '长度|,METRE',
|
||
`bankmoney` bigint(20) NOT NULL COMMENT '贷款金额|,WCNY',
|
||
`setdate` bigint(20) NOT NULL COMMENT '设置日期,DATE,Y-m-d',
|
||
`settimes` bigint(20) NOT NULL COMMENT '设置时间,DATE',
|
||
`dayclock` int(11) NOT NULL COMMENT '|营业时间|,TIME,H:i:s',
|
||
`downurl` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '|文档|,IMG',
|
||
`avar` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '头像,IMG1',
|
||
`isuse` int(11) NOT NULL COMMENT '|是否使用|,BOOL',
|
||
`isopen` int(11) NOT NULL COMMENT '|是否开启|,BOOL,开启.关闭',
|
||
`unit` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '库存单位,UNIT',
|
||
`sigstatus` int(11) NOT NULL COMMENT '|单选状态|,CATA,auditstatus',
|
||
`mauditstatus` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '多选状态,CATS,auditstatus|~',
|
||
`prodcata` int(11) NOT NULL COMMENT '组织结构,CATM,zc_depart',
|
||
`areacode` int(11) NOT NULL COMMENT '所在地区,CATM,ciy_arearpc|<code>?</code>',
|
||
`renzheng` int(11) NOT NULL COMMENT '认证情况,TBIN,re.nz.he.ng|<kbd>?</kbd>',
|
||
`ppint` int(11) NOT NULL COMMENT '|临时字典|,TINT,1:aaa.3:bbbb.5:cccc',
|
||
`npcyc` int(11) NOT NULL COMMENT '|执行周期|,CYC',
|
||
`runsec` int(11) NOT NULL COMMENT '执行用时|,SEC',
|
||
`acttm` int(11) NOT NULL COMMENT '活动期数|,INT,第?期',
|
||
`imgs` varchar(800) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '活动花絮,IMG,?50',
|
||
`ton` bigint(20) NOT NULL COMMENT '吨位|,TON',
|
||
`price` bigint(20) NOT NULL COMMENT '单价|,CNY',
|
||
`lat` int(11) NOT NULL COMMENT ',纬度',
|
||
`lng` int(11) NOT NULL COMMENT '|位置|,LOC,lat',
|
||
`pct` int(11) NOT NULL COMMENT '百分比|,PCT',
|
||
`url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '链接,URL,跳转',
|
||
`weightg` bigint(20) NOT NULL COMMENT '体重|,KG,1,KG|1000|吨',
|
||
`eartmpr` int(11) NOT NULL COMMENT '耳温|,TC,3',
|
||
`qian` bigint(20) NOT NULL COMMENT '中式钱|,LNY',
|
||
`meishi` bigint(20) NOT NULL COMMENT '美式钱|,SNY',
|
||
`weight` bigint(20) NOT NULL COMMENT '重量|,WGT,G.*KG.TON,1',
|
||
`height` bigint(20) NOT NULL COMMENT '长度|,LGH',
|
||
`skt` bigint(20) NOT NULL COMMENT '科学数|,BET,SKT,1000,1',
|
||
`idcard` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '身份证号,MSK,******#*',
|
||
`addtimes` bigint(20) NOT NULL COMMENT '添加时间,DATE',
|
||
`content` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',介绍,BR',
|
||
`md` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',富文本,MD',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 78 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '复杂功能表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of demo_normal
|
||
-- ----------------------------
|
||
INSERT INTO `demo_normal` VALUES (11, 100, 10, 1746396705, '', '区块同步', 0, 0, 0, 0, 0, 0, 0, '', '', 2, 2, '', 0, '', 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, '', 1746396698, '', '[MD]');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for doc_help
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `doc_help`;
|
||
CREATE TABLE `doc_help` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`upid` int(11) NOT NULL COMMENT ',上级',
|
||
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '标题',
|
||
`csort` int(11) NOT NULL DEFAULT 1 COMMENT '排序',
|
||
`isuse` int(11) NOT NULL DEFAULT 0 COMMENT '|公开|,BOOL',
|
||
`uptimes` bigint(20) NOT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 155 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '菜单表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of doc_help
|
||
-- ----------------------------
|
||
INSERT INTO `doc_help` VALUES (1, 0, '首页', 10, 1, 1751753699);
|
||
INSERT INTO `doc_help` VALUES (10, 0, '快速了解', 10, 1, 1757412998);
|
||
|
||
-- ----------------------------
|
||
-- Table structure for www_list_art
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `www_list_art`;
|
||
CREATE TABLE `www_list_art` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '|ID|',
|
||
`cateid` int(11) NOT NULL COMMENT '所属栏目,ID,www_list_cate',
|
||
`bshow` int(11) NOT NULL COMMENT '|显示|,BOOL',
|
||
`clickcnt` int(11) NOT NULL COMMENT '点击量|',
|
||
`icon` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '缩略图,IMG',
|
||
`name` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主标题',
|
||
`seotitle` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'SEO标题',
|
||
`keys` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关键词',
|
||
`descs` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',摘要,BR',
|
||
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',内容,MD',
|
||
`csort` int(11) NOT NULL COMMENT '|排序|',
|
||
`addtimes` bigint(20) NOT NULL COMMENT '添加时间,DATE',
|
||
`uptimes` bigint(20) NOT NULL COMMENT '更新时间,DATE',
|
||
`vadmin` int(11) NOT NULL COMMENT '创建人,CATA,adminuser',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 3043 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '网站列表通用库' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of www_list_art
|
||
-- ----------------------------
|
||
INSERT INTO `www_list_art` VALUES (434, 2, 1, 1001, '', '三星级农贸市场收费软件', '', '三星级农贸市场,三星级农贸市场收费软件,农贸市场', '很多人都知道，智慧农贸批发当下势头舒展，而软件作为农贸批发市场一般经营必不或缺的少部分，有着举足轻重的现象。市场方能通过网络上买卖称重数据，与网络上支出信息数据两', '<p>\n很多人都知道，智慧农贸批发当下势头舒展，而软件作为农贸批发市场一般经营必不或缺的少部分，有着举足轻重的现象。市场方能通过网络上买卖称重数据，与网络上支出信息数据两者比较，构成解析，为市场上运作决策做应当统计及保证；为经营户提供了多样化、多平台、多渠道的计量手段，有效果减少了客户换零钱、找零钱、跑机械等困扰。同如今消费群众提供了1个安心、安全、快捷的买东西场所。\n</p>\n<p>\n智慧农贸改造高星市场上精品化。在电脑部件、管理服务等角度提档更新，用心制作一批拥有示范引导效用的四星级及上面所说设计图市场。业态持续发展多方位。改进农贸市场谋划配置、琢磨以邻里重点方式为主新建或改建水产批发市场。进展网络上配送服务，采用互联网上下单、市场上发货、第三方配送的经营方式。\n</p>\n<p>\n智能化果蔬批发选择媒体发布系统的好的地方：1、起到的作用资讯公示的结果，方便客户晓得市场内包含商户、菜价、优惠这个项目、检查内容等数据。 2、内容统一整理至云端，操作市场上运营方登入平台后台查询网上经营现状，既有利于农批市场对外招商引导流量，对内传达提高行业里服务质量，争创星级水产批发市场。\n</p>\n<p>\n智能水产批发转型提升星级化。对乡村无星级网上及城区一星级及下面的农贸批发市场实行分批星级化改造，大幅提升三星级及以上水产批发市场在全市农批市场中的占比。对存在安全影响、规模小、功能差，不符合网上名称登记说明的市场，照章实施退出制度。\n</p>\n<p>\n<br />\n</p>', 1, 0, 0, 0);
|
||
INSERT INTO `www_list_art` VALUES (435, 2, 1, 1190, '', '智能养殖解决方案', '', '智能养殖解决方案,智能养殖,', '随着计算机互联网通信能力、二维码读取、无绳射频识别能力（RFID）、远红外识别器、全球明确软件等等资讯传输设备的发展，物联网技巧从不可触摸通向现世，融合人们消费，宽泛使', '<p><img src=\"/templets/images/yzhc1.jpg\" /> <img src=\"/templets/images/yzhc2.jpg\" /> <img src=\"/templets/images/yzhc3.jpg\" /> <img src=\"/templets/images/yzhc4.jpg\" /> <img src=\"/templets/images/yzhc5.jpg\" /> <img src=\"/templets/images/yzhc6.jpg\" /> <img src=\"/templets/images/yzhc7.jpg\" /> <img src=\"/templets/images/yzhc8.jpg\" /> <img src=\"/templets/images/yzhc9.jpg\" /> <img src=\"/templets/images/yzhc10.jpg\" /> <img src=\"/templets/images/yzhc11.jpg\" /> <img src=\"/templets/images/yzhc12.jpg\" /> <img src=\"/templets/images/yzhc13.jpg\" /> </p>\n<p>\n 随着计算机互联网通信能力、二维码读取、无绳射频识别能力（RFID）、远红外识别器、全球明确软件等等资讯传输设备的发展，物联网技巧从不可触摸通向现世，融合人们消费，宽泛使用在各产业，畜牧业也走进IoT聚焦时代。在促成农牧畜牧规模化、集成化、公开化、智能化、行业化、市场化、智能的进程中，不光一定要放牧康复技艺与工业化放牧的系统情况，也应该需要批量计算机信息使用软件研发。\n</p>\n<p>\n 于IoT技艺的引导下，普通的“后院养殖”刚好逐渐消亡。随便专一的专业养殖场，或者传统养殖个体经营户，都会先便捷便利的坚持智能化的养殖操作执行。物联网技艺甚或最好于一样的养殖范围中，制作着不同的的放牧管理模式，到最后提升牧场的产能与价值，成为一个超级给力的“饲养高手”。\n</p>\n<p>\n 奇博科学智能农牧管理系统在统计各类放牧全程的最宝贵经历的基础上做到网络与畜禽身份各类甄别电子耳标技艺相结合，遵守政府农业发展“整合资源、系统集成”的指导方针，重点是依据农牧业放牧标准化、人性化和质量安全体系建设说明，因此实现农牧业的品类、繁殖发育、饲料、豢养、检疫、组件、生长发育环境等创造生产、交易流程。凭据畜牧商品的生长的时候，个性化的付出饲料，达到细致饲养，降低成本。达到节省时间、增产增收的目标。\n</p>', 1, 0, 0, 0);
|
||
INSERT INTO `www_list_art` VALUES (436, 2, 1, 891, '', '纳服绩效系统软件', '', '纳服绩效系统软件,纳服绩效,', '18大以来，税务总局深层次履行施行政府涉及“严谨KPI维护”的品质，依靠国家对于“推进政府绩效总管”的部署，从前几年用税务KPI维护，从之前的版本到当下的新版本，连续订正、', '<p>\n 18大以来，税务总局深层次履行施行政府涉及“严谨KPI维护”的品质，依靠国家对于“推进政府绩效总管”的部署，从前几年用税务KPI维护，从之前的版本到当下的新版本，连续订正、不畏荆棘成正途，促使标准规范越来越改善、考评实行更加严实、操作体制越发确定、综合作用更明显。航天金税三期上线走进了其中之一新的信息化时代。\n</p>\n<p>\n 办税大厅是税务部门的服务，税务服务人员的显示则会代表了税务部门的名誉。办税员要养成优良的做事嗜好，每天上班前周全安排，每一笔业务认真查对，天天完工后认真清点，快速统计剖析，增加对细节的知名度，改错操作执行过失，为之后的作事积聚阅历。需要有稍强的生意技巧能力。纳税服务众多是杂事，小事，但做的有效果这些个琐细的、详细的、乏味的事件要较强的单子技巧能力，可以在第一个时候觉得详细上要调整的地方并且给出正确的的领会。\n</p>\n<p>\n 增强结论按照，对税务单位负责人进行订单调整、提拔、升级的时候，应以考核结论为关键依据，可缩小人为缘由与不确定根源。税务单位平时考察结论与季度奖励领取相关。级别区别，依照KPI数据来源设定KPI等级规则，就如这样就可以对考核效果坚持分等，例如优、良、差等 。这么多的税收机关一直有自己对等级划分的规范，在目标绩效管控模块中就可以活跃定义。上海奇博科技航天金税三期办税服务服务大厅绩效考察维护工具是有这考察结果采用的功能\n</p>', 1, 0, 0, 0);
|
||
INSERT INTO `www_list_art` VALUES (437, 2, 1, 1539, '', '税务绩效管理方案', '', '税务绩效管理方案,税务绩效管理,', '曾经政府举行专题会议，指引要快点建设按照增强增值税管理替重要目标的“金税工程”。大会赞同用人民银行清理中心网络建设交叉审视工具，同期标出防伪税控平台需先试点，后采', '<p>\n 曾经政府举行专题会议，指引要快点建设按照增强增值税管理替重要目标的“金税工程”。大会赞同用人民银行清理中心网络建设交叉审视工具，同期标出防伪税控平台需先试点，后采取。为团体实行此项工程项目，国家建立了国家税控工具搭建协调总管小组，下属“金税项目”做事部门，详细负责机构、调和平台建设办事。为航天金税三期上线指明了角度\n</p>\n<p>\n 华夏税务项目部门仰仗厉害的内容软件，达到对考核数据的自动收集、的时候掌控和业绩评价，使我国国家税收总局必定追查绩效指标的进行进度，保证各个部门和各个干部都了解自身办事的短板和追赶的目标，彰显了绩效管理持续校正的根本要义。强化能力支撑，没有停止的提升绩效管理工作质效。强化组织保障，业绩维护博取税务骨干广博帮助。机构保障是税务公司部门KPI维护不可或缺的组成部分。用在中国我国税收总局和各个省份税收部门设置KPI管理需求岗位，重复的提高业绩管控的专业化水准。\n</p>\n<p>\n 加强结论凭据，对税务机关负责人实行订单调整、选拔、晋级的时间，应该用考核结果替重要依据，可减少人为因素与不确切根源。税务机关平常考察结论与按季度分成发送挂钩。级数划分，遵照绩效数据来源要求绩效级别规则，如此便可以了对考察得分坚持分等，比如优、良、差等 。这些税务机关一直有自身对级数划分的准则，在目的业绩管理设备终端中绝对可以灵活设置。上海奇博科技航天金税三期税收服务服务大厅业绩考核维护工具便是具有这考核结果采取的功能\n</p>', 1, 0, 0, 0);
|
||
INSERT INTO `www_list_art` VALUES (438, 2, 1, 2039, '', '畜牧业智能养殖计步器', '', '畜牧业智能养殖计步器,畜牧业智能养殖,', '近年来，在中央对畜禽标准化规模畜牧等协助体制的展开下，我国畜牧业刚好身在由一般养殖向当今畜牧变革的重要年代。智能化放牧总管，就可以实现畜牧智能化，设计不同的的养殖', '<p><img src=\"/templets/images/yzhc1.jpg\" /> <img src=\"/templets/images/yzhc2.jpg\" /> <img src=\"/templets/images/yzhc3.jpg\" /> <img src=\"/templets/images/yzhc4.jpg\" /> <img src=\"/templets/images/yzhc5.jpg\" /> <img src=\"/templets/images/yzhc6.jpg\" /> <img src=\"/templets/images/yzhc7.jpg\" /> <img src=\"/templets/images/yzhc8.jpg\" /> <img src=\"/templets/images/yzhc9.jpg\" /> <img src=\"/templets/images/yzhc10.jpg\" /> <img src=\"/templets/images/yzhc11.jpg\" /> <img src=\"/templets/images/yzhc12.jpg\" /> <img src=\"/templets/images/yzhc13.jpg\" /> </p>\n<p>\n 近年来，在中央对畜禽标准化规模畜牧等协助体制的展开下，我国畜牧业刚好身在由一般养殖向当今畜牧变革的重要年代。智能化放牧总管，就可以实现畜牧智能化，设计不同的的养殖管理方式，提高养殖场的产量和价值，让养殖户快速已经是一个超级过得去的“养殖权威”。\n</p>\n<p>\n 农牧业是全体农牧业生产中规模化水准最厉害，能力、设备与成本消耗相比而言聚集的范围之一。在畜牧养殖领域管控生活中，智能放牧总管方案的应用就能实现畜牧场地信息化、智慧远程管理，充分发挥物联网技术在部件养殖生产中的结果，能确保养殖场地内环境适宜放牧畜禽生长发育，实现精细化的维护，为养殖牛羊的深了、好的、高效、自然、安全创造条件，帮客户提高效率、降低成本、提高获取。普遍的放牧方式相较于农民来说不只是有浪费时间，还不要保证羊群的舒服状况是活动情况，智能放牧绝对可以去掉这个难题。\n</p>\n<p>\n 奇博科技智能农牧管理系统其重点技术受到几个方面：一则是智能化穿设备的集成度；再者是对数据处理的AI算法。好的智能化家畜管理系统是要在一些这个运动牲口的此刻达成最准确的彩票预测。让AI跟畜牧养殖学更好用的连结，应该更新十分的的信息数据相关性，进而更进执行，进步准确率。集成智能化无绳射频传感RFID、无线通讯、智能控制系统和下载监控系统等专业技艺，对放牧空气、生长发育状态等实行全方面监控管控，实行认真归纳。\n</p>', 1, 0, 0, 0);
|
||
INSERT INTO `www_list_art` VALUES (439, 2, 1, 1229, '', '大型蔬菜批发市场管理系统', '', '大型蔬菜批发市场,大型蔬菜批发市场管理系统', '城市化进展提升极速，各类大楼拔地而起，科技发展更是蒸蒸日上。而水产批发市场却好像被忽视般，与“高大上”的城区不相符合，必定是落后，甚至于脏乱的。自然，现在各监控部', '<p>\n城市化进展提升极速，各类大楼拔地而起，科技发展更是蒸蒸日上。而水产批发市场却好像被忽视般，与“高大上”的城区不相符合，必定是落后，甚至于脏乱的。自然，现在各监控部门已经注意到这一点，在不同省份农贸市场监控部门参观了改造革新的设计图智能蔬菜批发市场后，也都就意味着智能化水产批发以后已往N多年的转型趋向和焦点新闻。\n</p>\n<p>\n智能化蔬菜批发应该需要用到食品安全追溯工具，普遍模块寻常包容：使用安心水产批发市场食品安全追溯系统，就能够溯源农批市场的客户信息、供求资讯、供应内容、菜品资讯以及检验资讯，让农贸市场感受保证更放心、更安心，让我国看管更快捷方便。顾客最好盘查到买菜品从批发、流通、再到网上的供应商源头信息或者供给日期等内容，源头溯源盘查。\n</p>\n<p>\n智慧水产批发选择媒体发布工具的好的地方：1、获得的效果信息公示的影响，操作购买者了解市场内涵概企业、菜价、优惠活动、检验信息等信息数据。 2、讯息统一聚集至云端，便利网上运营方登入系统后台看一下市场运作状况，既有利于农贸市场对外招商流量导入，对内推销提升网上服务质量，争创星级农贸市场。\n</p>\n<p>\n智能水产批发改革看管技术智慧化。加速推进水产批发市场智慧化改造，运用智能配件设备，展开蔬菜批发市场智能化化维护，因此实现智能付账、购买溯源、计量总管、报价监测等智能化总管和技术模式，为消费者提供便利化智能化化服务。 四周整顿有序化。农贸批发市场界线500米内，原则上不可以成立“临时疏导点”。水产批发市场地域200米内，不提倡设置与市场内运作水产、肉食类、蔬菜、豆制品、熟食等同种用品的运作部门。\n</p>\n<p>\n<br />\n</p>', 1, 0, 0, 0);
|
||
|
||
-- ----------------------------
|
||
-- Table structure for www_list_cate
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `www_list_cate`;
|
||
CREATE TABLE `www_list_cate` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '|ID|',
|
||
`total` int(11) NOT NULL COMMENT '数据量|',
|
||
`name` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主标题',
|
||
`seotitle` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'SEO标题',
|
||
`keys` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',关键词',
|
||
`descs` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',摘要',
|
||
`addtimes` bigint(20) NOT NULL COMMENT '添加时间,DATE',
|
||
`uptimes` bigint(20) NOT NULL COMMENT '更新时间,DATE',
|
||
`vadmin` int(11) NOT NULL COMMENT '创建人,CATA,adminuser',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '网站列表页库' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of www_list_cate
|
||
-- ----------------------------
|
||
INSERT INTO `www_list_cate` VALUES (1, 15, '动态', '动态', '', '', 1582856765, 1582854060, 103);
|
||
INSERT INTO `www_list_cate` VALUES (2, 1196, '文章资讯', '文章资讯-xx科技有限公司', '文章资讯', '文章资讯', 1594395880, 1594395778, 103);
|
||
|
||
-- ----------------------------
|
||
-- Table structure for www_seoword
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `www_seoword`;
|
||
CREATE TABLE `www_seoword` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关键词',
|
||
`url` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '链接',
|
||
`rank` int(11) NOT NULL COMMENT '|概率|',
|
||
`isuse` int(11) NOT NULL COMMENT '|有效|,BOOL',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `title`(`name`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 385 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '网站关键词库' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of www_seoword
|
||
-- ----------------------------
|
||
INSERT INTO `www_seoword` VALUES (271, '养殖代养', 'https://www.qiboc.cn/agro/1618.html', 50, 1);
|
||
INSERT INTO `www_seoword` VALUES (272, '养殖集团', 'https://www.qiboc.cn/agro/1619.html', 50, 1);
|
||
INSERT INTO `www_seoword` VALUES (275, '闲置计算机', 'https://www.qiboc.cn/agro/1619.html', 50, 1);
|
||
INSERT INTO `www_seoword` VALUES (276, '养殖合作社', 'https://www.qiboc.cn/agro/1617.html', 50, 1);
|
||
INSERT INTO `www_seoword` VALUES (277, '农村养殖合作', 'https://www.qiboc.cn/agro/1617.html', 50, 1);
|
||
INSERT INTO `www_seoword` VALUES (281, '智慧校园平台', 'http://www.qiboc.cn/campus/', 20, 1);
|
||
INSERT INTO `www_seoword` VALUES (282, '智慧校园管理系统平台', 'http://www.qiboc.cn/campus/', 20, 1);
|
||
|
||
-- ----------------------------
|
||
-- Table structure for www_single
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `www_single`;
|
||
CREATE TABLE `www_single` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '|ID|',
|
||
`name` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主标题',
|
||
`seotitle` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'SEO标题',
|
||
`keys` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关键词',
|
||
`descs` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',摘要,BR',
|
||
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',内容,MD',
|
||
`addtimes` bigint(20) NOT NULL COMMENT '添加时间,DATE',
|
||
`uptimes` bigint(20) NOT NULL COMMENT '更新时间,DATE',
|
||
`vadmin` int(11) NOT NULL COMMENT '创建人,CATA,adminuser',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '网站单页库' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of www_single
|
||
-- ----------------------------
|
||
INSERT INTO `www_single` VALUES (3, '分布式云计算', '云计算|分布式云计算', '分布式云计算', '分布式云计算攻克了分布式云平台计费结算难题，创建了“去中心化的计费结算模型”，云计算平台需求方和资源方之间的频繁结算不需要中心计费服务器，计费结算过程不依赖“账本”，可实现超大规模并行结算', '[MD]\r\n!https://qiboc.cn/templets/htmlimg/1-1.1.png\r\n#项目介绍\n将互联网上的海量闲置计算机通过P2PT健康组网技术和虚拟化技术，把海量计算机闲置的计算资源和网络资源有效利用起来，形成超大规模分布式的云计算平台。 该项目特点是几乎无需投入硬件服务器即可实现上成百上千万台计算机组网工作，投入成本极低。组网后的云平台，能够完成诸如互联网舆情监控、分布式编译、分布式3D渲染、大规模科学计算、证券分析等工作，按需支付算力。\r\n我们创新性的攻克了分布式云平台计费结算难题，借鉴了BitCoin比特币原理，创建了“去中心化的计费结算模型”，云计算平台需求方和资源方之间的频繁结算不需要中心计费服务器，计费结算过程不依赖“账本”，可实现超大规模并行结算，此创新为超大规模分布式云计算平台商用化扫清了道路。\r\n!https://qiboc.cn/templets/htmlimg/1-1.2.png\r\n#发展阶段\r\n本项目由公司孵化中心进行研发工作。目前主要为云爪平台提供大规模数据计算做底层业务支撑。\r\n作为PaaS平台，当前仅支持C#，未来我们将通过虚拟机技术支持多种开发工具，开发者可利用C++、C#、Java、Javascript、Perl、MatLab等编程语言接入，进行大规模并行计算商业逻辑的开发对接。\r\n当前资源性能：每万计算节点贡献约150TFLOPS计算能力，提供超过40Gbps宽带资源。\r\n#P2PT健康组网模型\r\n!https://qiboc.cn/templets/htmlimg/2-1.1.png\r\n!https://qiboc.cn/templets/htmlimg/2-1.2.png\r\n#去中心化计费结算模型\r\n!https://qiboc.cn/templets/htmlimg/2-1.3.png\r\n!https://qiboc.cn/templets/htmlimg/2-1.4.png', 1594319108, 1594319003, 103);
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_admin
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_admin`;
|
||
CREATE TABLE `zc_admin` (
|
||
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '|ID|',
|
||
`icon` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '头像,IMG1',
|
||
`name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '姓名',
|
||
`stpstatus` int(11) NOT NULL COMMENT '|状态|,CATA,stpstatus',
|
||
`mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '手机号,MSK,****',
|
||
`sex` int(11) NOT NULL COMMENT '|性别|,CATA,sex',
|
||
`departid` int(11) NOT NULL COMMENT '所属组织,CATM,zc_depart',
|
||
`roleid` int(11) NOT NULL COMMENT '岗位角色,DB,zc_role',
|
||
`logintimes` bigint(20) NOT NULL DEFAULT 0 COMMENT '活跃时间,DATE',
|
||
`addtimes` bigint(20) NOT NULL COMMENT '注册时间,DATE',
|
||
`password` varchar(70) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT ',密码',
|
||
`trytime` int(11) NOT NULL DEFAULT 0 COMMENT ',连续错误次数',
|
||
`power` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT ',权限表',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE INDEX `mobile`(`mobile`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '管理员用户表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_admin
|
||
-- ----------------------------
|
||
INSERT INTO `zc_admin` VALUES (10, '', '超级管理员', 10, '12345678901', 10, 34, 0, 1768723477, 1000000000, 'fa3046be160f84e79da4a5cf004e367997730a662598082f5181efdb8aa43dc9', 0, '.*.');
|
||
INSERT INTO `zc_admin` VALUES (18, '', '运营官', 10, '10000452346', 10, 34, 6, 1745062148, 1721153234, 'fa3046be160f84e79da4a5cf004e367997730a662598082f5181efdb8aa43dc9', 0, '.p3624.');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_ai_agent
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_ai_agent`;
|
||
CREATE TABLE `zc_ai_agent` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名称',
|
||
`aikey` int(11) NOT NULL COMMENT '执行模型,DB,zc_ai_key',
|
||
`aiprange` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',执行参量',
|
||
`funcids` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '数据函数,CATS,zc_ai_funcdata',
|
||
`sysprompt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',系统提示词',
|
||
`uptimes` bigint(20) NOT NULL DEFAULT 0 COMMENT '更新时间,DATE',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '决策智能体表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_ai_agent
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_ai_aigc
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_ai_aigc`;
|
||
CREATE TABLE `zc_ai_aigc` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名称',
|
||
`aikey` int(11) NOT NULL COMMENT '执行模型,DB,zc_ai_key',
|
||
`aiprange` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',执行参量',
|
||
`inputjson` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',预输入设置',
|
||
`funcids` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '数据函数,CATS,zc_ai_funcdata',
|
||
`uptimes` bigint(20) NOT NULL DEFAULT 0 COMMENT '更新时间,DATE',
|
||
`sysprompt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',系统提示词',
|
||
`roleprompt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',用户提示词',
|
||
`resulttxt` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',示例结果',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'AIGC生成表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_ai_aigc
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_ai_decdbg
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_ai_decdbg`;
|
||
CREATE TABLE `zc_ai_decdbg` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`decisionid` bigint(20) NOT NULL DEFAULT 0,
|
||
`version` int(11) NOT NULL DEFAULT 0 COMMENT '|版本|,INT',
|
||
`inputparam` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '输入数据',
|
||
`inputprompt` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',提示词',
|
||
`aichat` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',AI交互',
|
||
`resulttxt` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'AI结果',
|
||
`starttimes` int(11) NOT NULL DEFAULT 0 COMMENT '开始时间,DATE',
|
||
`reqsec` int(11) NOT NULL DEFAULT 0 COMMENT '执行时长|,SEC',
|
||
`decci` int(11) NOT NULL DEFAULT 0 COMMENT '置信度|,PCT',
|
||
`userfeedback` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '存在问题',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '决策调试表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_ai_decdbg
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_ai_dechistory
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_ai_dechistory`;
|
||
CREATE TABLE `zc_ai_dechistory` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`decisionid` bigint(20) NOT NULL DEFAULT 0,
|
||
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名称',
|
||
`aikey` int(11) NOT NULL COMMENT '执行模型,DB,zc_ai_key',
|
||
`aiprange` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',执行参量',
|
||
`version` int(11) NOT NULL DEFAULT 0 COMMENT '|版本|,INT',
|
||
`funcids` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '数据函数|,CATS,zc_ai_funcdata',
|
||
`sysprompt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',系统提示词',
|
||
`roleprompt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',用户提示词',
|
||
`aicalkey` int(11) NOT NULL COMMENT '检验模型,DB,zc_ai_key',
|
||
`aicalfunc` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '检验函数',
|
||
`aicalprange` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',检验参量',
|
||
`calprompt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',检验提示词',
|
||
`addtimes` bigint(20) NOT NULL DEFAULT 0 COMMENT '版本时间,DATE',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '决策设计表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_ai_dechistory
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_ai_decision
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_ai_decision`;
|
||
CREATE TABLE `zc_ai_decision` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '|DecisionID|',
|
||
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名称',
|
||
`aikey` int(11) NOT NULL COMMENT '执行算力源,DB,zc_ai_key',
|
||
`aiprange` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',执行参量',
|
||
`version` int(11) NOT NULL DEFAULT 0 COMMENT '|版本|,INT',
|
||
`funcids` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '数据函数|,CATS,zc_ai_funcdata',
|
||
`sysprompt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',系统提示词',
|
||
`roleprompt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',用户提示词',
|
||
`aicalkey` int(11) NOT NULL COMMENT '检验算力源,DB,zc_ai_key',
|
||
`aicalfunc` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '检验函数',
|
||
`aicalprange` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',检验参量',
|
||
`calprompt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',检验提示词',
|
||
`uptimes` bigint(20) NOT NULL DEFAULT 0 COMMENT '更新时间,DATE',
|
||
`memo` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',调试经验',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '决策设计表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_ai_decision
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_ai_funcdata
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_ai_funcdata`;
|
||
CREATE TABLE `zc_ai_funcdata` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名称',
|
||
`funcname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '函数名',
|
||
`descs` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '函数描述',
|
||
`uptimes` bigint(20) NOT NULL COMMENT '更新时间,DATE',
|
||
`funcparam` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',函数固定参数',
|
||
`paramjson` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',AI FUNC参数',
|
||
`defout` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',输出示例',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '函数数据表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_ai_funcdata
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_ai_key
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_ai_key`;
|
||
CREATE TABLE `zc_ai_key` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名称',
|
||
`model` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '模型',
|
||
`balance` int(11) NOT NULL DEFAULT 0 COMMENT '余额|,CNY',
|
||
`alarmbalce` int(11) NOT NULL COMMENT '#余额警戒线|,CNY',
|
||
`baseurl` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '基础地址',
|
||
`maxtoken` int(11) NOT NULL COMMENT '最大token数|',
|
||
`aicapacity` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '能力,CATS,aicapacity',
|
||
`aikey` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '#密钥,MSK,****##******##',
|
||
`memo` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '备注',
|
||
`uptimes` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间,DATE',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '算力源表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_ai_key
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_ai_knowcata
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_ai_knowcata`;
|
||
CREATE TABLE `zc_ai_knowcata` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '知识库名称',
|
||
`aiguide` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'AI引导描述',
|
||
`knowcnt` int(11) NOT NULL COMMENT '条数|',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '知识分类表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_ai_knowcata
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_ai_knowledge
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_ai_knowledge`;
|
||
CREATE TABLE `zc_ai_knowledge` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`cataid` bigint(20) NOT NULL DEFAULT 0 COMMENT ',所属分类,DB,zc_ai_knowcata',
|
||
`uptimes` bigint(20) NOT NULL COMMENT ',更新时间|,DATE',
|
||
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '知识内容,BR',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '浓缩知识表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_ai_knowledge
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_ai_task
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_ai_task`;
|
||
CREATE TABLE `zc_ai_task` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`aitaskstatus` int(11) NOT NULL DEFAULT 0 COMMENT '任务状态,CATA,autotaskstatus',
|
||
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '任务名称',
|
||
`aifunc` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务函数',
|
||
`aiparam` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',任务参数',
|
||
`autoci` int(11) NOT NULL COMMENT '主动置信度|,PCT',
|
||
`autofunc` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '执行函数',
|
||
`aicycle` int(11) NOT NULL DEFAULT 0 COMMENT '执行周期|,CYC',
|
||
`nexttimes` bigint(20) NOT NULL DEFAULT 0 COMMENT '下次时间,DATE',
|
||
`aitimes` int(11) NOT NULL DEFAULT 0 COMMENT ',开始时间,DATE',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '计划任务表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_ai_task
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_ai_tsk_run
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_ai_tsk_run`;
|
||
CREATE TABLE `zc_ai_tsk_run` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`aitaskid` bigint(20) NOT NULL DEFAULT 0 COMMENT '所属任务,DB,zc_ai_task',
|
||
`aidotype` int(11) NOT NULL COMMENT '状态,CATA,aidotype',
|
||
`confidence` int(11) NOT NULL COMMENT '置信度|,PCT',
|
||
`addtimes` bigint(20) NOT NULL DEFAULT 0 COMMENT '完成时间,DATE',
|
||
`runsec` int(11) NOT NULL DEFAULT 0 COMMENT '运行时长|,SEC',
|
||
`inputdata` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',输入数据',
|
||
`resultdata` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',结果数据',
|
||
`memo` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '优化建议',
|
||
`resultmodify` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',改后结果',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '执行记录表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_ai_tsk_run
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_autotask
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_autotask`;
|
||
CREATE TABLE `zc_autotask` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '|ID|',
|
||
`name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务名称',
|
||
`runfunc` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '入口函数',
|
||
`runparam` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '执行参数',
|
||
`nexttimes` bigint(20) UNSIGNED NOT NULL COMMENT '下次执行时间,DATE',
|
||
`runcycle` int(11) NOT NULL COMMENT '执行周期,CYC',
|
||
`autotaskstatus` int(11) NOT NULL COMMENT '|任务状态|,CATA,autotaskstatus',
|
||
`runtimes` bigint(20) NOT NULL DEFAULT 0 COMMENT ',开始执行时间,DATE',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '自动化任务表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_autotask
|
||
-- ----------------------------
|
||
INSERT INTO `zc_autotask` VALUES (1, '每日清理', 'base_dayclean', '', 1762627184, 86400, 20, 0);
|
||
INSERT INTO `zc_autotask` VALUES (2, '健康监测', 'base_srvstats', '', 1745058716, 60, 20, 0);
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_autotsk_log
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_autotsk_log`;
|
||
CREATE TABLE `zc_autotsk_log` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`autotaskid` int(11) NOT NULL COMMENT '所属任务,DB,zc_autotask',
|
||
`runtaskid` bigint(20) NOT NULL COMMENT '所属执行,DB,zc_autotsk_run',
|
||
`addtimes` bigint(20) NOT NULL COMMENT '发生时间,DATE',
|
||
`msg` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '执行记录',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
INDEX `runtaskid`(`runtaskid`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务Log表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_autotsk_log
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_autotsk_run
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_autotsk_run`;
|
||
CREATE TABLE `zc_autotsk_run` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`autotaskid` int(11) NOT NULL COMMENT '所属任务,DB,zc_autotask',
|
||
`addtimes` bigint(20) NOT NULL COMMENT '执行时间,DATE',
|
||
`runsec` int(11) NOT NULL DEFAULT 0 COMMENT '时长|,SEC',
|
||
`logcnt` int(11) NOT NULL DEFAULT 0 COMMENT 'LOG统计|',
|
||
`msg` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '任务简报',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
INDEX `autotaskid`(`autotaskid`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务执行记录表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_autotsk_run
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_cata
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_cata`;
|
||
CREATE TABLE `zc_cata` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`upid` int(11) NOT NULL COMMENT '上级,DB,zc_cata',
|
||
`csort` int(11) NOT NULL DEFAULT 10 COMMENT '排序',
|
||
`isuse` int(11) NOT NULL DEFAULT 1 COMMENT '|行为|,BOOL',
|
||
`cbid` int(11) NOT NULL DEFAULT 0 COMMENT '库,DB,zc_cata',
|
||
`codeid` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '值',
|
||
`name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
|
||
`clas` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '样式类',
|
||
`extdata` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '扩展值',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
INDEX `cbid`(`cbid`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 12001701 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '字典表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_cata
|
||
-- ----------------------------
|
||
INSERT INTO `zc_cata` VALUES (1, 0, 0, 1, 0, '', '固定字典', '', '');
|
||
INSERT INTO `zc_cata` VALUES (2, 0, 0, 1, 0, '', '灵活字典', '', '');
|
||
INSERT INTO `zc_cata` VALUES (10, 1, 0, 1, 0, 'sex', '性别', '', 'zc_admin');
|
||
INSERT INTO `zc_cata` VALUES (11, 1, 0, 1, 0, 'stpstatus', '账号状态', '', 'zc_admin');
|
||
INSERT INTO `zc_cata` VALUES (12, 1, 0, 1, 0, 'auditstatus', '审核状态', '', 'zc_urole');
|
||
INSERT INTO `zc_cata` VALUES (13, 1, 0, 1, 0, 'autotaskstatus', '任务状态', '', 'zc_autotask');
|
||
INSERT INTO `zc_cata` VALUES (14, 2, 0, 1, 0, 'targettype', '子系统', '', 'zc_debug_user\nzc_online');
|
||
INSERT INTO `zc_cata` VALUES (18, 1, 0, 1, 0, 'cashstatus', '提现状态', '', 'ap_cash_out');
|
||
INSERT INTO `zc_cata` VALUES (19, 2, 0, 1, 0, 'cashtype', '收支分类', '', 'ap_cash_ie,ap_cash_oe');
|
||
INSERT INTO `zc_cata` VALUES (21, 2, 0, 1, 0, 'userlevel', '用户等级', '', 'ap_user');
|
||
INSERT INTO `zc_cata` VALUES (22, 1, 0, 1, 0, 'artsort', '文章排序', '', 'ap_art_post');
|
||
INSERT INTO `zc_cata` VALUES (23, 1, 0, 1, 0, 'artstatus', '文章状态', '', 'ap_art_post');
|
||
INSERT INTO `zc_cata` VALUES (24, 2, 0, 1, 0, 'certs', '认证范围', '', 'ap_user');
|
||
INSERT INTO `zc_cata` VALUES (100, 2, 0, 1, 0, 'aicapacity', 'AI能力', '', 'zc_ai_key');
|
||
INSERT INTO `zc_cata` VALUES (101, 1, 0, 1, 0, 'aidotype', 'AI执行方式', '', 'zc_ai_tsk_run');
|
||
INSERT INTO `zc_cata` VALUES (102, 1, 10, 1, 0, 'education', '学历', '', '');
|
||
INSERT INTO `zc_cata` VALUES (103, 0, 10, 1, 0, 'orderstatus', '订单状态', '', '');
|
||
INSERT INTO `zc_cata` VALUES (1000, 0, 10, 1, 10, '10', '男', '', '');
|
||
INSERT INTO `zc_cata` VALUES (1001, 0, 20, 1, 10, '20', '女', '', '');
|
||
INSERT INTO `zc_cata` VALUES (1002, 0, 90, 1, 10, '90', '其他', '', '');
|
||
INSERT INTO `zc_cata` VALUES (1010, 0, 8, 1, 11, '8', '被禁用', 'dag', '');
|
||
INSERT INTO `zc_cata` VALUES (1011, 0, 9, 1, 11, '9', '登录保护', 'warn', '');
|
||
INSERT INTO `zc_cata` VALUES (1012, 0, 10, 1, 11, '10', '正常', 'succ', '');
|
||
INSERT INTO `zc_cata` VALUES (1020, 0, 10, 2, 12, '10', '草稿', 'def', '');
|
||
INSERT INTO `zc_cata` VALUES (1021, 0, 20, 1, 12, '20', '未审核', 'man', '');
|
||
INSERT INTO `zc_cata` VALUES (1022, 0, 50, 1, 12, '50', '审核中', 'warn', '');
|
||
INSERT INTO `zc_cata` VALUES (1023, 0, 90, 1, 12, '90', '驳回', 'dag', '');
|
||
INSERT INTO `zc_cata` VALUES (1024, 0, 95, 1, 12, '95', '撤回', 'def', '');
|
||
INSERT INTO `zc_cata` VALUES (1025, 0, 100, 1, 12, '100', '通过', 'succ', '');
|
||
INSERT INTO `zc_cata` VALUES (1030, 0, 20, 1, 13, '20', '等待执行', 'succ', '');
|
||
INSERT INTO `zc_cata` VALUES (1031, 0, 30, 1, 13, '30', '执行中', 'warn', '');
|
||
INSERT INTO `zc_cata` VALUES (1039, 0, 90, 1, 13, '90', '禁止执行', 'dag', '');
|
||
INSERT INTO `zc_cata` VALUES (1040, 0, 10, 1, 14, '10', '总控', '', '');
|
||
INSERT INTO `zc_cata` VALUES (1041, 0, 20, 1, 14, '20', 'SaaS PC端', '', '');
|
||
INSERT INTO `zc_cata` VALUES (1042, 0, 21, 1, 14, '21', 'SaaS 移动端', '', '');
|
||
INSERT INTO `zc_cata` VALUES (1150, 0, 10, 1, 18, '10', '申请中', 'def', '');
|
||
INSERT INTO `zc_cata` VALUES (1151, 0, 20, 1, 18, '20', '已通过', 'warn', '');
|
||
INSERT INTO `zc_cata` VALUES (1152, 0, 21, 2, 18, '21', '微信操作中', 'warn', '');
|
||
INSERT INTO `zc_cata` VALUES (1153, 0, 30, 1, 18, '30', '已传发票', 'man', '');
|
||
INSERT INTO `zc_cata` VALUES (1154, 0, 50, 1, 18, '50', '待打款', 'def', '');
|
||
INSERT INTO `zc_cata` VALUES (1155, 0, 90, 1, 18, '90', '已拒绝', 'dag', '');
|
||
INSERT INTO `zc_cata` VALUES (1156, 0, 100, 1, 18, '100', '已完成', 'succ', '');
|
||
INSERT INTO `zc_cata` VALUES (1200, 0, 10, 1, 19, '10', '充值', '', '');
|
||
INSERT INTO `zc_cata` VALUES (1201, 0, 11, 1, 19, '11', '提现', '', '');
|
||
INSERT INTO `zc_cata` VALUES (1210, 0, 20, 1, 19, '20', '推荐奖', '', '');
|
||
INSERT INTO `zc_cata` VALUES (1211, 0, 21, 1, 19, '21', '带新奖', '', '');
|
||
INSERT INTO `zc_cata` VALUES (1212, 0, 22, 1, 19, '22', '领导奖', '', '');
|
||
INSERT INTO `zc_cata` VALUES (1550, 0, 1, 1, 21, '10', 'LV.1', '', '');
|
||
INSERT INTO `zc_cata` VALUES (1551, 0, 2, 1, 21, '20', 'LV.2', '', '');
|
||
INSERT INTO `zc_cata` VALUES (1600, 0, 0, 1, 22, '10', '劣后', '', '');
|
||
INSERT INTO `zc_cata` VALUES (1601, 0, 0, 1, 22, '20', '正常', '', '');
|
||
INSERT INTO `zc_cata` VALUES (1602, 0, 0, 1, 22, '30', '置顶', '', '');
|
||
INSERT INTO `zc_cata` VALUES (1603, 0, 0, 1, 22, '40', '总置顶', '', '');
|
||
INSERT INTO `zc_cata` VALUES (1650, 0, 0, 1, 23, '10', '草稿', 'def', '');
|
||
INSERT INTO `zc_cata` VALUES (1651, 0, 0, 1, 23, '20', '待审核', 'warn', '');
|
||
INSERT INTO `zc_cata` VALUES (1652, 0, 0, 1, 23, '90', '驳回', 'dag', '');
|
||
INSERT INTO `zc_cata` VALUES (1653, 0, 0, 1, 23, '100', '发布', 'succ', '');
|
||
INSERT INTO `zc_cata` VALUES (1700, 0, 10, 1, 24, 'a', '实名认证', '', '');
|
||
INSERT INTO `zc_cata` VALUES (1701, 0, 20, 1, 24, 'b', '付费会员', '', '');
|
||
INSERT INTO `zc_cata` VALUES (10100, 0, 1, 1, 100, 'text', '文本', '', '');
|
||
INSERT INTO `zc_cata` VALUES (10101, 0, 2, 1, 100, 'json', 'JSON', '', '');
|
||
INSERT INTO `zc_cata` VALUES (10105, 0, 5, 1, 100, 'fcall', '函数', '', '');
|
||
INSERT INTO `zc_cata` VALUES (10110, 0, 10, 1, 100, 'image', '理解图像', '', '');
|
||
INSERT INTO `zc_cata` VALUES (10115, 0, 15, 1, 100, 'video', '理解视频', '', '');
|
||
INSERT INTO `zc_cata` VALUES (10120, 0, 20, 1, 100, '3dmodel', '理解三维', '', '');
|
||
INSERT INTO `zc_cata` VALUES (10150, 0, 0, 1, 101, '10', '等待介入', '', '');
|
||
INSERT INTO `zc_cata` VALUES (10151, 0, 0, 1, 101, '30', '专家研判', '', '');
|
||
INSERT INTO `zc_cata` VALUES (10152, 0, 0, 1, 101, '20', '专家建议', '', '');
|
||
INSERT INTO `zc_cata` VALUES (10154, 0, 0, 1, 101, '100', 'AI不执行', '', '');
|
||
INSERT INTO `zc_cata` VALUES (10155, 0, 0, 1, 101, '110', 'AI自主执行', '', '');
|
||
INSERT INTO `zc_cata` VALUES (10156, 0, 0, 1, 101, '150', '直接执行', '', '');
|
||
INSERT INTO `zc_cata` VALUES (10157, 0, 0, 1, 101, '160', '改后执行', '', '');
|
||
INSERT INTO `zc_cata` VALUES (10159, 0, 0, 1, 101, '190', '人类拒绝', '', '');
|
||
INSERT INTO `zc_cata` VALUES (10160, 0, 0, 1, 101, '200', 'AI执行已阅', '', '');
|
||
INSERT INTO `zc_cata` VALUES (10161, 0, 0, 1, 101, '210', 'AI执行问题', '', '');
|
||
INSERT INTO `zc_cata` VALUES (10200, 0, 10, 1, 102, '10', '小学', '', '');
|
||
INSERT INTO `zc_cata` VALUES (10201, 0, 10, 1, 102, '20', '初中', '', '');
|
||
INSERT INTO `zc_cata` VALUES (10202, 0, 10, 1, 102, '30', '高中', '', '');
|
||
INSERT INTO `zc_cata` VALUES (10203, 0, 10, 1, 102, '40', '大专', '', '');
|
||
INSERT INTO `zc_cata` VALUES (10204, 0, 10, 1, 102, '50', '本科', '', '');
|
||
INSERT INTO `zc_cata` VALUES (10205, 0, 10, 1, 102, '60', '硕士', '', '');
|
||
INSERT INTO `zc_cata` VALUES (10206, 0, 10, 1, 102, '70', '博士', '', '');
|
||
INSERT INTO `zc_cata` VALUES (10250, 0, 10, 1, 103, '10', '等待指令', '', '');
|
||
INSERT INTO `zc_cata` VALUES (10251, 0, 10, 1, 103, '20', '队列中', '', '');
|
||
INSERT INTO `zc_cata` VALUES (10252, 0, 10, 1, 103, '30', '转账中', '', '');
|
||
INSERT INTO `zc_cata` VALUES (10253, 0, 10, 1, 103, '100', '成功', '', '');
|
||
INSERT INTO `zc_cata` VALUES (10254, 0, 10, 1, 103, '90', '失败', '', '');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_cemap_bill
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_cemap_bill`;
|
||
CREATE TABLE `zc_cemap_bill` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`cpath` int(11) NOT NULL COMMENT '路径,CATM,zc_cemap_pbill',
|
||
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
|
||
`url` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '图片,IMG1',
|
||
`w` int(11) NOT NULL COMMENT '宽度,METRE',
|
||
`h` int(11) NOT NULL COMMENT '高度,METRE',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
INDEX `orgid`(`name`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 41 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '立牌资源表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_cemap_bill
|
||
-- ----------------------------
|
||
INSERT INTO `zc_cemap_bill` VALUES (31, 1, 'map1', '/bill/map1.png', 2000, 2700);
|
||
INSERT INTO `zc_cemap_bill` VALUES (32, 1, 'map2', '/bill/map2.png', 2000, 2700);
|
||
INSERT INTO `zc_cemap_bill` VALUES (33, 1, 'map3', '/bill/map3.png', 2000, 2700);
|
||
INSERT INTO `zc_cemap_bill` VALUES (34, 1, 'map9', '/bill/map9.png', 2000, 2700);
|
||
INSERT INTO `zc_cemap_bill` VALUES (35, 1, 'loc1', '/bill/loc1.png', 1000, 1238);
|
||
INSERT INTO `zc_cemap_bill` VALUES (36, 1, 'loc2', '/bill/loc2.png', 1000, 1238);
|
||
INSERT INTO `zc_cemap_bill` VALUES (37, 1, 'loc3', '/bill/loc3.png', 1000, 1238);
|
||
INSERT INTO `zc_cemap_bill` VALUES (38, 2, '液位计', '/bill/s1.png', 1000, 1000);
|
||
INSERT INTO `zc_cemap_bill` VALUES (39, 2, '摄像头', '/bill/s2.png', 1000, 1000);
|
||
INSERT INTO `zc_cemap_bill` VALUES (40, 2, '气象站', '/bill/s3.png', 1000, 1000);
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_cemap_data
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_cemap_data`;
|
||
CREATE TABLE `zc_cemap_data` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`tabname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
|
||
`tabid` bigint(20) NOT NULL,
|
||
`mapjson` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
|
||
`uptimes` bigint(20) NOT NULL,
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 40 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '地图数据表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_cemap_data
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_cemap_glb
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_cemap_glb`;
|
||
CREATE TABLE `zc_cemap_glb` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`cpath` int(11) NOT NULL COMMENT '路径,CATM,zc_cemap_pglb',
|
||
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
|
||
`url` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'GLB,DOWN',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
INDEX `orgid`(`name`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 42 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'GLB资源表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_cemap_glb
|
||
-- ----------------------------
|
||
INSERT INTO `zc_cemap_glb` VALUES (1, 6, '运输车', '/glb/s1.gltf');
|
||
INSERT INTO `zc_cemap_glb` VALUES (2, 200, '蹦床', '/glb/s2.gltf');
|
||
INSERT INTO `zc_cemap_glb` VALUES (3, 1, '造型1', '/glb/s3.gltf');
|
||
INSERT INTO `zc_cemap_glb` VALUES (4, 201, '球机摄像头', '/glb/s4.glb');
|
||
INSERT INTO `zc_cemap_glb` VALUES (5, 201, '枪机摄像头', '/glb/s5.glb');
|
||
INSERT INTO `zc_cemap_glb` VALUES (6, 1, '楼房', '/glb/s6.glb');
|
||
INSERT INTO `zc_cemap_glb` VALUES (7, 4, '羊驼', '/glb/s7.glb');
|
||
INSERT INTO `zc_cemap_glb` VALUES (8, 101, '正方形', '/glb/s8.glb');
|
||
INSERT INTO `zc_cemap_glb` VALUES (9, 1, '贴图房', '/glb/s9.glb');
|
||
INSERT INTO `zc_cemap_glb` VALUES (11, 3, '梧桐树', '/glb/s11.glb');
|
||
INSERT INTO `zc_cemap_glb` VALUES (12, 3, '花艺', '/glb/s12.glb');
|
||
INSERT INTO `zc_cemap_glb` VALUES (13, 1, '简易房', '/glb/s13.glb');
|
||
INSERT INTO `zc_cemap_glb` VALUES (14, 200, '龙门吊', '/glb/s14.glb');
|
||
INSERT INTO `zc_cemap_glb` VALUES (15, 200, '搅拌站', '/glb/s15.glb');
|
||
INSERT INTO `zc_cemap_glb` VALUES (16, 6, '砼车', '/glb/s16.glb');
|
||
INSERT INTO `zc_cemap_glb` VALUES (18, 1, '栅栏', '/glb/s18.glb');
|
||
INSERT INTO `zc_cemap_glb` VALUES (20, 1, '门房2', '/glb/s20.glb');
|
||
INSERT INTO `zc_cemap_glb` VALUES (21, 1, '门房', '/glb/s21.glb');
|
||
INSERT INTO `zc_cemap_glb` VALUES (22, 201, '下球摄像头', '/glb/s22.glb');
|
||
INSERT INTO `zc_cemap_glb` VALUES (23, 4, '山羊', '/glb/s23.glb');
|
||
INSERT INTO `zc_cemap_glb` VALUES (24, 200, '太阳能板', '/glb/s24.gltf');
|
||
INSERT INTO `zc_cemap_glb` VALUES (25, 1, '农具房', '/glb/s25.glb');
|
||
INSERT INTO `zc_cemap_glb` VALUES (26, 1, '养殖棚', '/glb/s26.glb');
|
||
INSERT INTO `zc_cemap_glb` VALUES (27, 1, '悬空地', '/glb/s27.glb');
|
||
INSERT INTO `zc_cemap_glb` VALUES (28, 1, '敞开房', '/glb/s28.glb');
|
||
INSERT INTO `zc_cemap_glb` VALUES (29, 5, '怪物', '/glb/s29.glb');
|
||
INSERT INTO `zc_cemap_glb` VALUES (30, 1, '宿舍房', '/glb/s30.glb');
|
||
INSERT INTO `zc_cemap_glb` VALUES (31, 1, '蓝顶房屋', '/glb/s31.glb');
|
||
INSERT INTO `zc_cemap_glb` VALUES (32, 200, '油罐', '/glb/s32.glb');
|
||
INSERT INTO `zc_cemap_glb` VALUES (33, 1, '大门头', '/glb/s33.glb');
|
||
INSERT INTO `zc_cemap_glb` VALUES (34, 1, '遮阳棚', '/glb/s34.glb');
|
||
INSERT INTO `zc_cemap_glb` VALUES (35, 1, '栅栏墙', '/glb/s35.glb');
|
||
INSERT INTO `zc_cemap_glb` VALUES (36, 200, '风电机', '/glb/s36.gltf');
|
||
INSERT INTO `zc_cemap_glb` VALUES (37, 6, '轿车', '/glb/s37.glb');
|
||
INSERT INTO `zc_cemap_glb` VALUES (38, 1, '水泥墙', '/glb/s38.glb');
|
||
INSERT INTO `zc_cemap_glb` VALUES (39, 1, '楼房顶', '/glb/s39.glb');
|
||
INSERT INTO `zc_cemap_glb` VALUES (41, 201, '锚钉', '/glb/s41.glb');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_cemap_pbill
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_cemap_pbill`;
|
||
CREATE TABLE `zc_cemap_pbill` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`upid` int(11) NOT NULL COMMENT ',上级',
|
||
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
|
||
`csort` int(11) NOT NULL DEFAULT 1 COMMENT '排序',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 47 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '立牌分类表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_cemap_pbill
|
||
-- ----------------------------
|
||
INSERT INTO `zc_cemap_pbill` VALUES (1, 0, '地标', 10);
|
||
INSERT INTO `zc_cemap_pbill` VALUES (2, 0, '设备', 10);
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_cemap_pglb
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_cemap_pglb`;
|
||
CREATE TABLE `zc_cemap_pglb` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`upid` int(11) NOT NULL COMMENT ',上级',
|
||
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
|
||
`csort` int(11) NOT NULL DEFAULT 1 COMMENT '排序',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 304 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'GLB分类表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_cemap_pglb
|
||
-- ----------------------------
|
||
INSERT INTO `zc_cemap_pglb` VALUES (1, 0, '建筑', 10);
|
||
INSERT INTO `zc_cemap_pglb` VALUES (2, 0, '设备', 10);
|
||
INSERT INTO `zc_cemap_pglb` VALUES (3, 0, '植物', 10);
|
||
INSERT INTO `zc_cemap_pglb` VALUES (4, 0, '动物', 10);
|
||
INSERT INTO `zc_cemap_pglb` VALUES (5, 0, '人物', 10);
|
||
INSERT INTO `zc_cemap_pglb` VALUES (6, 0, '车辆', 10);
|
||
INSERT INTO `zc_cemap_pglb` VALUES (200, 2, '大型', 10);
|
||
INSERT INTO `zc_cemap_pglb` VALUES (201, 2, '小型', 10);
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_config
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_config`;
|
||
CREATE TABLE `zc_config` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`types` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '参数代码',
|
||
`params` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '参数值',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '配置表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_config
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_debug_user
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_debug_user`;
|
||
CREATE TABLE `zc_debug_user` (
|
||
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`targettype` int(11) NOT NULL COMMENT '|子系统|,CATA,targettype',
|
||
`isuse` int(11) NOT NULL COMMENT '|开关|,BOOL',
|
||
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '显示名',
|
||
`user` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户名',
|
||
`pass` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密码,MSK,**',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '调试用户表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_debug_user
|
||
-- ----------------------------
|
||
INSERT INTO `zc_debug_user` VALUES (1, 10, 1, '超管', '12345678901', '123654');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_depart
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_depart`;
|
||
CREATE TABLE `zc_depart` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`upid` int(11) NOT NULL COMMENT ',上级',
|
||
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '组织名称',
|
||
`leaderuser` int(11) NOT NULL DEFAULT 0 COMMENT '|负责人|,CATA,adminuser',
|
||
`isuse` int(11) NOT NULL DEFAULT 0 COMMENT '|启用|,BOOL',
|
||
`csort` int(11) NOT NULL DEFAULT 1 COMMENT '排序',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 63 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '组织机构表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_depart
|
||
-- ----------------------------
|
||
INSERT INTO `zc_depart` VALUES (1, 0, '董事会', 10, 1, 10);
|
||
INSERT INTO `zc_depart` VALUES (32, 0, '技术中心', 18, 1, 10);
|
||
INSERT INTO `zc_depart` VALUES (34, 32, '技术部', 19, 1, 10);
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_dev_dbcode
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_dev_dbcode`;
|
||
CREATE TABLE `zc_dev_dbcode` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`dbcid` int(11) NOT NULL COMMENT '生成器,DB,zc_dev_dbsaas',
|
||
`tabl` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '表',
|
||
`pcjson` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'PC配置',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 88 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代码生成表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_dev_dbcode
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_dev_dbsaas
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_dev_dbsaas`;
|
||
CREATE TABLE `zc_dev_dbsaas` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
|
||
`schem` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '数据库',
|
||
`subpath` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '相对路径',
|
||
`verifyfunc` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '认证函数',
|
||
`codetable` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典表',
|
||
`saasfield` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'SaaS字段',
|
||
`saasusr` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'SaaS用户标识',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 79 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代码目录表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_dev_dbsaas
|
||
-- ----------------------------
|
||
INSERT INTO `zc_dev_dbsaas` VALUES (1, '总控-ap', 'c5_ciyon', 'admin\\ap', 'verifyfast', 'zc_cata', '', '');
|
||
INSERT INTO `zc_dev_dbsaas` VALUES (2, '总控-rigger', 'c5_ciyon', 'admin\\rigger', 'verifyfast', 'zc_cata', '', '');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_dev_note
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_dev_note`;
|
||
CREATE TABLE `zc_dev_note` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`typeid` int(11) NOT NULL,
|
||
`uptimes` bigint(20) NOT NULL COMMENT '更新时间,DATE',
|
||
`content` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',内容',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '开发文档表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_dev_note
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_funcslow
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_funcslow`;
|
||
CREATE TABLE `zc_funcslow` (
|
||
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`addtimes` bigint(20) NOT NULL COMMENT '|记录时间|,DATE',
|
||
`ms` bigint(20) NOT NULL COMMENT '用时|,INT,ms',
|
||
`uri` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '请求源',
|
||
`posts` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '参数',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 82 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '慢请求表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_funcslow
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_icon
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_icon`;
|
||
CREATE TABLE `zc_icon` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`icontarget` int(11) NOT NULL COMMENT '使用范围,CATA,icontarget',
|
||
`targetid` int(11) NOT NULL COMMENT '对应关系',
|
||
`icon` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '数据',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1033 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '图标表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_icon
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_log
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_log`;
|
||
CREATE TABLE `zc_log` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`loguser` int(11) NOT NULL COMMENT '操作人,CATA,adminuser',
|
||
`readuser` int(11) NOT NULL COMMENT '审阅人,CATA,adminuser',
|
||
`types` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'LOG分类',
|
||
`addtimes` bigint(20) NOT NULL COMMENT '发生日期,DATE',
|
||
`ip` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'IP,IP',
|
||
`logs` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '详情',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 222 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '总控日志表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_log
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_lug
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_lug`;
|
||
CREATE TABLE `zc_lug` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`isinout` int(11) NOT NULL COMMENT '|登录|,BOOL,登入.登出',
|
||
`loguser` int(11) NOT NULL COMMENT '用户,CATA,adminuser',
|
||
`addtimes` bigint(20) NOT NULL COMMENT '发生日期,DATE',
|
||
`ip` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'IP,IP',
|
||
`model` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '设备指纹',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 3434 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '登录日志表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_lug
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_menu
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_menu`;
|
||
CREATE TABLE `zc_menu` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`upid` int(11) NOT NULL COMMENT ',上级菜单',
|
||
`name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
|
||
`url` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '链接',
|
||
`pow` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '权限',
|
||
`csort` int(11) NOT NULL DEFAULT 10 COMMENT '排序',
|
||
`isuse` int(11) NOT NULL DEFAULT 1 COMMENT '|启用|,BOOL',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 20035 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '菜单表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_menu
|
||
-- ----------------------------
|
||
INSERT INTO `zc_menu` VALUES (10, 0, '平台业务', '', '', 110, 1);
|
||
INSERT INTO `zc_menu` VALUES (11, 0, 'SaaS业务A', '', '', 100, 1);
|
||
INSERT INTO `zc_menu` VALUES (12, 0, 'SaaS业务B', '', '', 100, 2);
|
||
INSERT INTO `zc_menu` VALUES (13, 0, 'SaaS业务C', '', '', 100, 2);
|
||
INSERT INTO `zc_menu` VALUES (60, 0, 'AI辅助决策', '', '', 50, 1);
|
||
INSERT INTO `zc_menu` VALUES (61, 0, '审批事项', '', '', 50, 2);
|
||
INSERT INTO `zc_menu` VALUES (62, 0, '产业官网', '', '', 50, 1);
|
||
INSERT INTO `zc_menu` VALUES (63, 0, 'AI私域', '', '', 50, 2);
|
||
INSERT INTO `zc_menu` VALUES (64, 0, 'AI自媒体', '', '', 50, 2);
|
||
INSERT INTO `zc_menu` VALUES (65, 0, '接入管理', '', '', 50, 2);
|
||
INSERT INTO `zc_menu` VALUES (66, 0, 'Web3D', '', '', 50, 1);
|
||
INSERT INTO `zc_menu` VALUES (80, 0, '组织管理', '', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (81, 0, '服务器监控', '', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (82, 0, '系统管理', '', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (99, 0, '*开发者', '', '', 1, 1);
|
||
INSERT INTO `zc_menu` VALUES (120, 1, '刷新缓存', 'restorage(true)', '', 1, 1);
|
||
INSERT INTO `zc_menu` VALUES (121, 1, '修改密码', 'rigger/chgpass.html', '', 1, 1);
|
||
INSERT INTO `zc_menu` VALUES (130, 2, 'SSH', 'setssh(true)', '', 1, 1);
|
||
INSERT INTO `zc_menu` VALUES (210, 60, '决策交互', 'aidecision/ai_agent.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (211, 60, 'AIGC写作', 'aidecision/ai_aigc.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (212, 60, '任务介入', 'aidecision/ai_task_run.html?liid=10', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (213, 60, '决策任务', 'aidecision/ai_task.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (215, 60, '决策单元', 'aidecision/ai_decision.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (216, 60, '数据函数', 'aidecision/ai_funcdata.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (220, 60, '浓缩知识', 'aidecision/ai_knowcata.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (225, 60, 'AI算力源', 'aidecision/ai_key.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (226, 60, '算力测试', 'aidecision/ai_test.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (229, 60, '帮助文档', 'aidecision/help.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (230, 61, '我发起的事项', '!MSGmattermain 草稿、流转中、已驳回、已完成、已归档', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (231, 61, '待审批事项', '!MSGmatternotice 需我审批、我已审批、同事已批', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (232, 61, '知会事项', '!MSGmattertell 待处理、处理中、已处理', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (233, 61, '我已批事项', '!MSGmatterapproval 非我审批[有代理人]', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (234, 61, '指派代理人', '!MSGmatteragent 指派中，已指派历史', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (250, 62, '用户线索', '', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (251, 62, '文章管理', '', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (252, 62, '文章生成', '', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (253, 62, '栏目管理', '', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (254, 62, '锚内关键词', '', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (255, 62, '单页管理', '', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (260, 251, '文章草稿', '', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (261, 251, '文章待发', '', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (262, 251, '已发文章', '', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (263, 251, '热门调优', '', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (270, 252, '关键词库', '', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (271, 252, '浓缩知识', '', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (272, 252, '文章模版', '', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (273, 252, 'SEO规划', '', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (300, 63, '私域平台账号', '!MSG添加企业微信、个人微信、QQ号等', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (301, 63, '线索客户', '!MSG导入手机号，自动分配平台账号，加人。加好后按标签策略，主动跟客户聊天。', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (302, 63, '线索待聊', '!MSG每次回复生成后，根据数字量，延迟1-几分钟。这期间可以人工介入。', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (303, 63, '标签智能体', '!MSGAI根据客户聊天数据，每隔n轮对话做一次标签调整。分组策略设置主动聊天天数。设置知识组、提示词模版。', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (304, 63, '意向客户', '!MSG人类接管回复。', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (305, 63, 'API推送设置', '!MSG将意向客户推送到第三方CRM中，或设置提醒。', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (330, 64, '自媒体平台账号', '!MSG添加小红书、抖音、tt、tg、fb。设置主动评论搜索间隔。设置AI性格，设置评论提示词模版/私信提示词模版。绑定知识组。引导私信或关注。视频/文章发布频率', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (335, 64, '主动评论', '', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (336, 64, '主动私信', '', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (338, 64, '自媒体成果', '!MSG搜集到的联系方式，自动推送到AI私域，进到线索客户', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (339, 64, '自主发布', '', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (340, 335, '搜索关注词', '!MSG关键词组设置。', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (341, 335, '它作评论记录', '!MSG自动评论记录', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (342, 335, '本作评论数据', '!MSG粉丝在本作下评论的数据', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (343, 335, '主动评论回复', '!MSG回评/回复自发文章的用户评论(选择性)，同时必须关注对方，且发私信', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (350, 336, '私信用户', '!MSG各平台账号的私信粉丝用户', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (351, 336, '私信干预记录', '!MSG人工给回复私信的发送记录', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (352, 336, '主动私信记录', '!MSG交流情况记录，关注的用户都主动发私信', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (370, 339, '待发布视频', '!MSG视频素材', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (371, 339, '待发布文章', '!MSG图文素材', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (379, 339, '发布记录', '!MSG各账号已发记录和关联的素材', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (400, 65, '区块链配置', '!MSG以太坊、EOS、智臻链等key设置', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (401, 65, '通用上链记录', '!MSG文件、文本手动上链记录', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (405, 65, '短信接口配置', '!MSG腾讯云、阿里云等短信接口配置', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (406, 65, '短信发送记录', '!MSG全站短信发送记录', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (410, 65, '微信公众号配置', '!MSG公众号appid绑定', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (411, 65, '公众号推送记录', '!MSG公众号提醒消息推送记录', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (415, 65, 'AI监控设备', '!MSG基于GB28181的摄像头主动注册发现，绑定识别模型', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (416, 65, '视觉声纹模型库', '!MSG绑定本地模型算法入口|通过AI容器透传，绑定远程内网模型|透传保护知识产权，支持AI模型合作和算力结算', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (417, 65, 'AI识别通用结果', '!MSG识别模型产生结果的视频摘录', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (420, 65, '物联网设备发现', '!MSG网关型/透传型物联网设备自动接入|特点是：非实时、小数据量、指令型、边端算力|环境传感器、环控、土壤、水质、运动、定位、机器人、自主车辆等', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (421, 65, '协议标准化转码器', '!MSG制定为每一类物联网设备标准数据结构，将各厂家自定的数据格式和不同的数据流工作模式转成标准数据流结构，通常是协议中转器', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (450, 66, '地编器演示', 'cemap/ceeditor.html?id=1&tab=demo', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (451, 66, '人工建模资源', 'cemap/glb.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (452, 66, '指示牌资源', 'cemap/bill.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (455, 66, '人工建模分类', 'cemap/pathglb.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (456, 66, '指示牌分类', 'cemap/pathbill.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (459, 66, '地图示例', '!WIN/admin/cemap/cemap.html?id=1&tab=demo', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (500, 80, '管理员管理', 'rigger/admin.html', 'a=新增|u=修改|d=删除|r=赋予角色|p=重置密码|e=导出', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (501, 80, '组织机构', 'rigger/depart.html', 'u=管理|d=删除', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (502, 80, '岗位角色', 'rigger/role.html', 'u=管理|d=删除', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (505, 80, '在线人员', 'rigger/online.html', 'o=强制下线|d=删除', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (550, 81, '健康指标', 'rigger/statsfunc.html', 'd=删除|e=导出', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (551, 81, '服务器详情', 'rigger/statssrv.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (552, 81, '数据库详情', 'rigger/statsdb.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (553, 81, '业务日志', 'rigger/logdb.html?liid=1', 's=审阅|d=删除', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (554, 81, '登录日志', 'rigger/luser.html', 'd=删除', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (555, 81, '程序日志', 'rigger/logfile.html', 'd=删除', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (556, 81, '慢请求记录', 'rigger/funcslow.html', 'd=删除|e=导出', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (600, 82, '配置管理', 'rigger/config.html', 'u=管理|d=删除', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (601, 82, '数据字典', 'rigger/cataindex.html', 'pi=库管理|pd=字典管理', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (602, 82, '自动化任务', 'rigger/autotask.html', 'u=管理|d=删除|l=记录管理|r=手动执行', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (603, 82, '表单设计器', '!MSGtabbase 字段设计tabfield', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (604, 82, '流程设计器', '!MSGmattertemplate 流程设置matterflow', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (610, 82, '数据计算', 'datasse/index.html', 'r=执行', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (621, 82, '总控API', 'rigger/tokapi.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (622, 82, '三方接入', 'rigger/tokthd.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (900, 99, '软件设置', '', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (901, 99, '示例代码', '', 'u=管理|n=使用', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (902, 99, '开发工具', '', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (903, 99, '开发管理', '', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (904, 99, '测试工具', '', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (910, 901, '前端组件', 'demo/front/', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (911, 901, '交互示例', 'demo/dyn/', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (912, 901, '功能示例', '', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (920, 902, '碎片试验代码', '!WIN/ajax/api/test1.t1', '', 10, 2);
|
||
INSERT INTO `zc_menu` VALUES (921, 902, '共享工具集', '!WINhttps://i.qiboc.cn/tool/', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (922, 902, '原型图演示', '', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (924, 902, 'AI规划', '!DAO/dev/ciyon/aiarch.html', '', 10, 2);
|
||
INSERT INTO `zc_menu` VALUES (925, 902, '代码生成器', 'develop/code_saas.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (926, 902, '生成文档', '!DAO/dev/ciyon/docgen.html', '', 10, 2);
|
||
INSERT INTO `zc_menu` VALUES (927, 902, 'AI多语言翻译', '!DAO/dev/ciyon/ailangtran.html', '', 10, 2);
|
||
INSERT INTO `zc_menu` VALUES (928, 902, '工具支持', '!DAO/dev/ciyon/tool.html', '', 10, 2);
|
||
INSERT INTO `zc_menu` VALUES (930, 903, '里程碑更新记录', '!DAO/dev/ciyon/landup.html', '', 10, 2);
|
||
INSERT INTO `zc_menu` VALUES (931, 903, '开发记录', '', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (940, 904, '测试用例', '!DAO/dev/ciyon/testcase.html', '', 10, 2);
|
||
INSERT INTO `zc_menu` VALUES (941, 904, '测试任务', '!DAO/dev/ciyon/testtask.html', '', 10, 2);
|
||
INSERT INTO `zc_menu` VALUES (942, 904, 'Bug处置', '!DAO/dev/ciyon/testbug.html', '', 10, 2);
|
||
INSERT INTO `zc_menu` VALUES (945, 904, 'Mocks接口', 'rigger/mock.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (980, 900, '总控菜单', 'rigger/menu.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (981, 900, 'SaaS菜单', '', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (990, 900, '调试登录', 'rigger/debug_user.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (991, 900, '扩展权限', 'rigger/power.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (992, 900, '通用事项管理', '!MSGmattercomm 未送审、未办结', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (1120, 912, '常规列表页', 'demo/normal.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (1121, 912, '块列表页', 'demo/ultable.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (1122, 912, '多层分类', 'demo/multicat.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (1123, 912, '行编辑表', 'demo/lineedit.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (1124, 912, '设置单页', 'demo/setpage.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (1125, 912, '安全功能页', 'demo/safeop.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (1126, 912, '分类列表页', 'demo/catlist.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (1129, 912, '数据大屏', '!WINdemo/bs/', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (1220, 922, 'PC端', '!PRDm4376,key=18679ba2c1fb8749727dae0ce6bde66cbbf00b7ce0', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (1221, 922, '移动端', '!PRDa4187,tag=me', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (1222, 922, '图表', '!PRDc836', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (1223, 922, '大屏', '!PRDc3125,key=18679ba589ab4e057e13b752ebc399a8f3f4ffeaf6', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (1224, 922, '菜单文字', '!MSG第一行|第二行', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (1300, 931, '产品规划', 'develop/note.html?typeid=10', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (1301, 931, '架构设计', 'develop/note.html?typeid=11', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (1302, 931, '开发计划', 'develop/note.html?typeid=12', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (10000, 10, '客服工作', '', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (10001, 10, '运营工作', '', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (10002, 10, '财务工作', '', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (10010, 10, '用户数据', '', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (10011, 10, 'API接口', 'ap/api.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (10100, 10000, '工单处理', 'ap/usr_problem.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (10101, 10000, '意见建议', 'ap/usr_suggest.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (10102, 10000, '用户实名认证', 'ap/usr_real_apply.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (10105, 10000, '用户服务', 'ap/user_service.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (10200, 10001, '提现审核', 'ap/cash_out_apply.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (10205, 10001, '金币购买记录', 'ap/pnt_buy.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (10206, 10001, '收支记录', 'ap/cash_ie.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (10207, 10001, '付费会员记录', 'ap/usr_buy_user.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (10208, 10001, '金币流水记录', 'ap/pnt_record.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (10220, 10001, '板块文章', 'ap/art_section.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (10221, 10001, '单页管理', 'ap/paper.html', 'u=管理|d=删除', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (10222, 10001, '广告图管理', 'ap/banner.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (10230, 10001, '金币奖励埋点', 'ap/pnt_track.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (10231, 10001, '付费会员定价', 'ap/usr_buy_bundle.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (10232, 10001, '金币购买定价', 'ap/pnt_bundle.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (10235, 10001, '订单示例', 'ap/transfer.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (10260, 10001, '业务日志', 'ap/logdb.html?liid=1', 's=审阅|d=删除', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (10261, 10001, '登录日志', 'ap/luser.html', 'd=删除', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (10262, 10001, '用户短信发送', 'ap/usr_sendsms.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (10263, 10001, '用户邮件发送', 'ap/usr_sendmail.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (10300, 10002, '提现支付', 'ap/cash_out_transfer.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (10301, 10002, '提现收票', 'ap/cash_out_inv.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (10302, 10002, '发票开票', 'ap/invoicing.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (10310, 10002, '付费会员流水', 'ap/usr_buy_user.html?liid=2', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (10311, 10002, '金币购买流水', 'ap/pnt_buy.html?liid=2', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (10312, 10002, '充值流水', 'ap/cash_in.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (10313, 10002, '发票明细维护', 'ap/invoicedetail.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (10400, 10010, '用户资料', 'ap/user.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (10401, 10010, '用户实名认证', 'ap/usr_real_apply.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (10402, 10010, '用户发票抬头', 'ap/invoicetitle.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (10403, 10010, '用户收件地址', 'ap/usr_shipaddr.html', '', 10, 1);
|
||
INSERT INTO `zc_menu` VALUES (10408, 10010, '验证码', 'ap/usr_capcode.html', '', 10, 1);
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_mnufav
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_mnufav`;
|
||
CREATE TABLE `zc_mnufav` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`favtarget` int(11) NOT NULL,
|
||
`user` int(11) NOT NULL COMMENT '|用户|,CATA,adminuser',
|
||
`menuid` int(11) NOT NULL,
|
||
`addtimes` bigint(20) NOT NULL COMMENT '添加时间,DATE',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '常用菜单表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_mnufav
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_mq
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_mq`;
|
||
CREATE TABLE `zc_mq` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`mqstatus` int(11) NOT NULL COMMENT '消息状态 //status=1为消息队列，status=2为处理中，status=3-9为一次次重试累加，status=90为失败',
|
||
`topic` int(11) NOT NULL COMMENT '消息分类',
|
||
`json` int(11) NOT NULL COMMENT '消息内容',
|
||
`nexttimes` bigint(20) NOT NULL COMMENT '下次处理时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '队列表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_mq
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_online
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_online`;
|
||
CREATE TABLE `zc_online` (
|
||
`id` bigint(11) NOT NULL AUTO_INCREMENT,
|
||
`user` int(11) NOT NULL COMMENT '用户,CATA,adminuser',
|
||
`targettype` int(11) NOT NULL COMMENT '|子系统|,CATA,targettype',
|
||
`usrchg` int(11) NOT NULL DEFAULT 0,
|
||
`sid` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',授权码',
|
||
`addtimes` bigint(20) NOT NULL COMMENT '登录时间,DATE',
|
||
`exptimes` bigint(20) NOT NULL COMMENT '到期时间,DATE',
|
||
`ip` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '登录IP,IP',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = MEMORY AUTO_INCREMENT = 30 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '管理员登录状态表' ROW_FORMAT = Fixed;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_online
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_power
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_power`;
|
||
CREATE TABLE `zc_power` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`groupname` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '分组名',
|
||
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '模块名称',
|
||
`scope` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '模块代码',
|
||
`powers` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '权限项',
|
||
`csort` int(11) NOT NULL DEFAULT 1 COMMENT '排序',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '扩展权限表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_power
|
||
-- ----------------------------
|
||
INSERT INTO `zc_power` VALUES (1, '系统组', '系统安全', 'safe', 'ssh=SSH开启|kr=手动扩容|nr=手动缩容', 9999);
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_role
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_role`;
|
||
CREATE TABLE `zc_role` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色名称',
|
||
`power` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色权限',
|
||
`memo` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色说明',
|
||
`uptimes` bigint(20) NOT NULL COMMENT '更新时间,DATE',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 35 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_role
|
||
-- ----------------------------
|
||
INSERT INTO `zc_role` VALUES (6, '运营官', '.p10101.p10105.p10221u.p10221d.', '', 1746484812);
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_stats
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_stats`;
|
||
CREATE TABLE `zc_stats` (
|
||
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`addtimes` bigint(20) NOT NULL COMMENT '|记录时间|,DATE',
|
||
`func_succ` bigint(20) NOT NULL COMMENT '成功数|',
|
||
`func_fail` bigint(20) NOT NULL COMMENT '失败数|',
|
||
`func_commit` bigint(20) NOT NULL COMMENT '提交数|',
|
||
`func_rollback` bigint(20) NOT NULL COMMENT '回滚数|',
|
||
`func_runms` bigint(20) NOT NULL COMMENT '平均用时|,INT,ms',
|
||
`disk_sysfree` bigint(20) NOT NULL COMMENT '磁盘系统剩余空间|,FSIZE',
|
||
`disk_datafree` bigint(20) NOT NULL COMMENT '磁盘数据剩余空间|,FSIZE',
|
||
`disk_ioms` bigint(20) NOT NULL COMMENT '磁盘IO响应|,INT,ms',
|
||
`cpu_free` int(11) NOT NULL COMMENT 'CPU空闲占比|,PCT',
|
||
`cpu_db` int(11) NOT NULL COMMENT 'CPU数据库占比|,PCT',
|
||
`cpu_web` int(11) NOT NULL COMMENT 'CPU应用占比|,PCT',
|
||
`cpu_oth` int(11) NOT NULL COMMENT 'CPU其他占比|,PCT',
|
||
`mem_free` int(11) NOT NULL COMMENT '空闲内存|,FSIZE',
|
||
`mem_db` int(11) NOT NULL COMMENT '数据库内存占比|,PCT',
|
||
`mem_web` int(11) NOT NULL COMMENT '应用内存占比|,PCT',
|
||
`mem_oth` int(11) NOT NULL COMMENT '其他内存占比|,PCT',
|
||
`net_tcp` bigint(20) NOT NULL COMMENT '网络连接数|',
|
||
`net_ioms` bigint(20) NOT NULL COMMENT '网络响应|,INT,ms',
|
||
`db_query` bigint(20) NOT NULL COMMENT '数据库查询数|',
|
||
`db_commit` bigint(20) NOT NULL COMMENT '数据库提交数|',
|
||
`db_rollback` bigint(20) NOT NULL COMMENT '数据库回滚数|',
|
||
`db_keyhit` int(11) NOT NULL COMMENT '索引命中率|,PCT',
|
||
`db_dbhit` int(11) NOT NULL COMMENT '缓存命中率|,PCT',
|
||
`db_tmptable` int(11) NOT NULL COMMENT '临时表占比|,PCT',
|
||
`db_lock` int(11) NOT NULL COMMENT '当前锁数量|',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统健康表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_stats
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_tokapi
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_tokapi`;
|
||
CREATE TABLE `zc_tokapi` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '|appid|',
|
||
`vuser` int(11) NOT NULL COMMENT '用户,CATA,adminuser',
|
||
`apisecret` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',appkey',
|
||
`ips` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '白名单IP,BR',
|
||
`addtimes` bigint(20) NOT NULL COMMENT '创建时间,DATE',
|
||
`uptimes` bigint(20) NOT NULL COMMENT '活跃时间,DATE',
|
||
`pubkey` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '|证书|',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 215699 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'API接口授权' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_tokapi
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_tokthd
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_tokthd`;
|
||
CREATE TABLE `zc_tokthd` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '三方平台名称',
|
||
`cfgtoken` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ConfigData',
|
||
`accesstoken` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'AccessData',
|
||
`exptimes` bigint(20) NOT NULL COMMENT '过期时间,DATE',
|
||
`memo` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '快捷备注',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'API三方平台' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_tokthd
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_ymock
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_ymock`;
|
||
CREATE TABLE `zc_ymock` (
|
||
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称备注',
|
||
`upath` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '类路径',
|
||
`ufunc` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '函数名',
|
||
`mockjson` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',mock数据',
|
||
`lastrequest` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT ',请求快照',
|
||
`lasttimes` bigint(20) NOT NULL DEFAULT 0 COMMENT '请求时间,DATE',
|
||
`addtimes` bigint(20) NOT NULL COMMENT '建立时间,DATE',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'Mock表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_ymock
|
||
-- ----------------------------
|
||
INSERT INTO `zc_ymock` VALUES (6, '', '', '/admin/rigger/mock.testmock', '{\"code\":1,\"data\":12344321}', '/admin/rigger/mock.testmock<br/>', 1768534144, 1722713211);
|
||
|
||
-- ----------------------------
|
||
-- Table structure for zc_zmem_var
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `zc_zmem_var`;
|
||
CREATE TABLE `zc_zmem_var` (
|
||
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
`types` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '变量名',
|
||
`params` bigint(20) NOT NULL COMMENT '数值',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = MEMORY AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '变量表' ROW_FORMAT = Fixed;
|
||
|
||
-- ----------------------------
|
||
-- Records of zc_zmem_var
|
||
-- ----------------------------
|
||
|
||
SET FOREIGN_KEY_CHECKS = 1;
|