ngds/sql/2020_11/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: 26/11/2020 10:06:28
*/

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) NOT NULL,
  `ROLE_NAME` varchar(255) 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) DEFAULT NULL COMMENT '更新人',
  `ADM_NAME` varchar(16) NOT NULL COMMENT '创建人',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `ROLE_NAME` (`ROLE_NAME`),
  KEY `SORT` (`SORT`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of AR_DEC_ROLE
-- ----------------------------
BEGIN;
INSERT INTO `AR_DEC_ROLE` VALUES ('16B96B8D910E44EA86C89CC80F6BC76C', '一级报单中心', 1.00, 1, 1534749214, 1604996001, 'adminy', 'ADMIN');
INSERT INTO `AR_DEC_ROLE` VALUES ('466CB7E1F32349C196B88ECBDE51C059', '二级报单中心', 2.00, 2, 1534749202, 1604996010, 'adminy', 'ADMIN');
INSERT INTO `AR_DEC_ROLE` VALUES ('810916A06B304162902408A6B9E5D177', '三级报单中心', 3.00, 3, 1534749236, 1604996014, 'adminy', 'ADMIN');
INSERT INTO `AR_DEC_ROLE` VALUES ('85B65542FCC341FAAFFAD0FA625CF9B8', '四级报单中心', 4.00, 4, 1534749225, 1604996021, 'adminy', 'ADMIN');
INSERT INTO `AR_DEC_ROLE` VALUES ('8976C62F40064D8AB357BE07C8A3CA8F', '五级报单中心', 5.00, 5, 1534748970, 1604996030, 'adminy', 'ADMIN');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;