buyao-server/buyao-parent/doc/sys_config.sql

/*
Navicat MySQL Data Transfer

Source Server         : 不要_测试环境
Source Server Version : 50731
Source Host           : 47.112.148.113:3306
Source Database       : buyao

Target Server Type    : MYSQL
Target Server Version : 50731
File Encoding         : 65001

Date: 2020-12-30 11:34:26
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for sys_config
-- ----------------------------
DROP TABLE IF EXISTS `sys_config`;
CREATE TABLE `sys_config` (
  `config_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '账户编号',
  `module` varchar(32) NOT NULL COMMENT '模块名称',
  `key` varchar(32) NOT NULL COMMENT '配置key',
  `value` varchar(1024) DEFAULT NULL COMMENT '配置value',
  `desc` varchar(64) NOT NULL COMMENT '配置说明',
  `os` varchar(32) DEFAULT NULL COMMENT '匹配客户端系统',
  `market` varchar(32) DEFAULT NULL COMMENT '匹配渠道',
  `client` varchar(32) DEFAULT NULL COMMENT '匹配客户端类型',
  `app_version` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '匹配APP版本号',
  `account_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '匹配账户编号',
  `priority` int(11) NOT NULL DEFAULT '0' COMMENT '优先级',
  `state` tinyint(4) NOT NULL COMMENT '配置状态, 见ConfigStateEnum',
  `admin_id` bigint(20) unsigned NOT NULL COMMENT '管理员编号',
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`config_id`)
) ENGINE=InnoDB AUTO_INCREMENT=100001 DEFAULT CHARSET=utf8mb4 COMMENT='系统配置表';

-- ----------------------------
-- Records of sys_config
-- ----------------------------
SET FOREIGN_KEY_CHECKS=1;