SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for hlc_admin
-- ----------------------------
DROP TABLE IF EXISTS `hlc_admin`;
CREATE TABLE `admin` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`hierarchy_id` int(10) UNSIGNED NOT NULL DEFAULT 1 COMMENT '层级ID',
`pid` int(10) UNSIGNED NOT NULL COMMENT '父级id',
`name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '用户名',
`pwd` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '密码',
`role_id` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '角色id',
`tel` char(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '电话',
`email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '邮箱',
`balance` decimal(12, 2) NOT NULL DEFAULT 0.00 COMMENT '账户余额',
`promo_code` char(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '推广码',
`status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '管理员登录状态：1、在线，2、离线；',
`create_time` datetime(0) NOT NULL COMMENT '创建时间',
`delete_time` datetime(0) NULL DEFAULT NULL COMMENT '删除时间 （null：未删除）',
PRIMARY KEY (`id`) USING BTREE,
