ngds/sql/2020_07/AR_DEC_ROLE.sql

/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50721
 Source Host           : localhost:3306
 Source Schema         : aikang_online

 Target Server Type    : MySQL
 Target Server Version : 50721
 File Encoding         : 65001

 Date: 21/07/2020 14:39:58
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for AR_DEC_ROLE
-- ----------------------------
DROP TABLE IF EXISTS `AR_DEC_ROLE`;
CREATE TABLE `AR_DEC_ROLE` (
  `ID` varchar(32) COLLATE utf8mb4_bin NOT NULL,
  `ROLE_NAME` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '名称',
  `FW_BONUS_PERCENT` decimal(16,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '推荐奖比例',
  `SORT` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `CREATED_AT` int(10) NOT NULL COMMENT '创建时间',
  `UPDATED_AT` int(10) NOT NULL COMMENT '更新时间',
  `UPDATER` varchar(16) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '更新人',
  `ADM_NAME` varchar(16) COLLATE utf8mb4_bin NOT NULL COMMENT '创建人',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `ROLE_NAME` (`ROLE_NAME`),
  KEY `SORT` (`SORT`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of AR_DEC_ROLE
-- ----------------------------
BEGIN;
INSERT INTO `AR_DEC_ROLE` VALUES ('16B96B8D910E44EA86C89CC80F6BC76C', '一级报单中心', 0.00, 1, 1534749214, 1571380490, 'ADMINZ', 'ADMIN');
INSERT INTO `AR_DEC_ROLE` VALUES ('466CB7E1F32349C196B88ECBDE51C059', '二级报单中心', 0.00, 2, 1534749202, 1571380500, 'ADMINZ', 'ADMIN');
INSERT INTO `AR_DEC_ROLE` VALUES ('810916A06B304162902408A6B9E5D177', '三级报单中心', 0.00, 3, 1534749236, 1571380696, 'ADMINZ', 'ADMIN');
INSERT INTO `AR_DEC_ROLE` VALUES ('85B65542FCC341FAAFFAD0FA625CF9B8', '四级报单中心', 0.00, 4, 1534749225, 1571380719, 'ADMINZ', 'ADMIN');
INSERT INTO `AR_DEC_ROLE` VALUES ('8976C62F40064D8AB357BE07C8A3CA8F', '五级报单中心', 0.00, 5, 1534748970, 1571380687, 'ADMINZ', 'ADMIN');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;