/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50726
 Source Host           : localhost:3306
 Source Schema         : laytp

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

 Date: 15/11/2019 10:35:09
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for laytp_card
-- ----------------------------
DROP TABLE IF EXISTS `laytp_card`;
CREATE TABLE `laytp_card`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '卡ID',
  `cardnum` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '卡号',
  `cardpassword` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'e10adc3949ba59abbe56e057f20f883e' COMMENT '卡密码，默认：123456',
  `amount` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '卡余额',
  `status` smallint(1) NOT NULL DEFAULT 1 COMMENT '0-已注销/待激活，1-正常，2-已挂失，未补卡，4-已挂失，已补卡，8-预留',
  `linkcradnum` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关联卡号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '会员卡' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of laytp_card
-- ----------------------------
INSERT INTO `laytp_card` VALUES (1, '123456789012345', 'e10adc3949ba59abbe56e057f20f883e', '3', 1, NULL);
INSERT INTO `laytp_card` VALUES (2, '123456789012346', 'e10adc3949ba59abbe56e057f20f883e', '0', 1, NULL);

-- ----------------------------
-- Table structure for laytp_card_level
-- ----------------------------
DROP TABLE IF EXISTS `laytp_card_level`;
CREATE TABLE `laytp_card_level`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '卡级别ID',
  `level` smallint(1) NOT NULL COMMENT '卡级别，如：1-普通卡，2-铂金卡，3-黑金卡',
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '卡名称',
  `discount` decimal(3, 2) NOT NULL DEFAULT 1.00 COMMENT '折扣率',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '会员卡等级' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for laytp_cash
-- ----------------------------
DROP TABLE IF EXISTS `laytp_cash`;
CREATE TABLE `laytp_cash`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '记录ID',
  `cardnum` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '卡号',
  `amount` decimal(20, 2) NOT NULL COMMENT '提现金额',
  `time` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '提现时间',
  `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '提现方式 - 现金，转卡，支付宝，微信等',
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '提现账户实名',
  `account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '提现账户',
  `attach` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `worker` int(6) NOT NULL COMMENT '操作员',
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '处理状态',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '提现记录' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of laytp_cash
-- ----------------------------
INSERT INTO `laytp_cash` VALUES (2, '123456789012345', 1.00, '1573616136', '现金', NULL, NULL, NULL, 1, 0);

-- ----------------------------
-- Table structure for laytp_channel
-- ----------------------------
DROP TABLE IF EXISTS `laytp_channel`;
CREATE TABLE `laytp_channel`  (
  `id` int(6) NOT NULL AUTO_INCREMENT COMMENT '通道ID',
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '通道名称',
  `code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '通道代码（唯一）',
  `status` tinyint(1) NOT NULL COMMENT '通道状态',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '支付通道' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of laytp_channel
-- ----------------------------
INSERT INTO `laytp_channel` VALUES (1, '支付宝', 'alipay', 1);
INSERT INTO `laytp_channel` VALUES (2, '微信', 'weixin', 0);
INSERT INTO `laytp_channel` VALUES (3, '银联', 'bank', 0);
INSERT INTO `laytp_channel` VALUES (4, '云闪付', 'unionpay', 1);
INSERT INTO `laytp_channel` VALUES (5, '京东', 'jd', 1);

-- ----------------------------
-- Table structure for laytp_consumption
-- ----------------------------
DROP TABLE IF EXISTS `laytp_consumption`;
CREATE TABLE `laytp_consumption`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '记录ID',
  `cardnum` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '卡号',
  `amount` decimal(20, 2) NOT NULL COMMENT '消费金额',
  `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '现金' COMMENT '消费方式：余额，现金等',
  `time` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '消费时间',
  `ordernum` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '订单编号',
  `attach` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `worker` int(11) NOT NULL DEFAULT 0 COMMENT '操作员',
  PRIMARY KEY (`id`, `ordernum`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '消费记录' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of laytp_consumption
-- ----------------------------
INSERT INTO `laytp_consumption` VALUES (1, '123456789012345', 16.00, '现金', '1573616589', 'D0120191113133556231025', 'xx', 1);

-- ----------------------------
-- Table structure for laytp_menu
-- ----------------------------
DROP TABLE IF EXISTS `laytp_menu`;
CREATE TABLE `laytp_menu`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
  `parentid` int(11) NOT NULL DEFAULT 0 COMMENT '父级ID',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '菜单名称',
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '链接地址',
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图标名称',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '菜单' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for laytp_notice
-- ----------------------------
DROP TABLE IF EXISTS `laytp_notice`;
CREATE TABLE `laytp_notice`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '公告ID',
  `notice` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '公告内容',
  `worker` int(6) NOT NULL COMMENT '发布者ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '公告' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of laytp_notice
-- ----------------------------
INSERT INTO `laytp_notice` VALUES (1, 'fs', 1);

-- ----------------------------
-- Table structure for laytp_order_details
-- ----------------------------
DROP TABLE IF EXISTS `laytp_order_details`;
CREATE TABLE `laytp_order_details`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ordernum` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '订单号，D-收银台订单，N-网络订单，2-3位收银台编号/通道编号，支持多太收银机同时下单',
  `product` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商品详情',
  `price` decimal(10, 2) NOT NULL COMMENT '价格',
  `quantity` decimal(6, 0) NOT NULL COMMENT '数量',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '消费订单详情' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of laytp_order_details
-- ----------------------------
INSERT INTO `laytp_order_details` VALUES (1, 'D0120191113133556231025', '麻花', 5.50, 1);
INSERT INTO `laytp_order_details` VALUES (2, 'D0120191113133556231025', '瓜子', 3.50, 3);
INSERT INTO `laytp_order_details` VALUES (3, 'S0120191113133556231097', '抹布', 0.10, 1);

-- ----------------------------
-- Table structure for laytp_privilege
-- ----------------------------
DROP TABLE IF EXISTS `laytp_privilege`;
CREATE TABLE `laytp_privilege`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '权限ID',
  `model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'model权限',
  `view` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `contrl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '权限组' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for laytp_recharge
-- ----------------------------
DROP TABLE IF EXISTS `laytp_recharge`;
CREATE TABLE `laytp_recharge`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '记录ID',
  `cardnum` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '卡号',
  `ordernum` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '充值订单编号',
  `amount` decimal(20, 2) NOT NULL COMMENT '充值金额',
  `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '现金' COMMENT '充值方式',
  `time` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '充值时间',
  `attach` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `worker` int(11) NOT NULL DEFAULT 0 COMMENT '操作员',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '充值记录' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of laytp_recharge
-- ----------------------------
INSERT INTO `laytp_recharge` VALUES (1, '123456789012345', 'C20191113133556201223', 1.00, '现金', '1573616134', 'qq', 1);
INSERT INTO `laytp_recharge` VALUES (2, '123456789012345', 'C20191113133556201224', 1.00, '网络', '1573633675', NULL, 1);
INSERT INTO `laytp_recharge` VALUES (3, '123456789012346', 'C20191113133556201228', 1.00, '网络', '1573633676', NULL, 1);

-- ----------------------------
-- Table structure for laytp_role
-- ----------------------------
DROP TABLE IF EXISTS `laytp_role`;
CREATE TABLE `laytp_role`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '角色ID',
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色名',
  `privilege` int(11) NOT NULL COMMENT '权限ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for laytp_scores_consumption
-- ----------------------------
DROP TABLE IF EXISTS `laytp_scores_consumption`;
CREATE TABLE `laytp_scores_consumption`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '积分ID',
  `userid` int(11) NOT NULL COMMENT '会员ID',
  `scores` decimal(20, 2) NOT NULL COMMENT '消费积分变动情况',
  `type` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '+,-',
  `ordernum` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '订单编号',
  `attach` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '备注',
  `time` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '时间',
  `worker` int(6) NULL DEFAULT NULL COMMENT '操作员',
  PRIMARY KEY (`id`, `ordernum`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '消费积分' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of laytp_scores_consumption
-- ----------------------------
INSERT INTO `laytp_scores_consumption` VALUES (1, 1, 16.00, '+', 'D0120191113133556231025', '消费赠送', '1573616134', 1);
INSERT INTO `laytp_scores_consumption` VALUES (2, 1, -1.00, '-', 'S0120191113133556231097', '购物扣减', '1573616134', 1);

-- ----------------------------
-- Table structure for laytp_scores_simple
-- ----------------------------
DROP TABLE IF EXISTS `laytp_scores_simple`;
CREATE TABLE `laytp_scores_simple`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '积分ID',
  `userid` int(11) NOT NULL COMMENT '会员ID',
  `scores` decimal(20, 2) NOT NULL COMMENT '常规积分变动情况',
  `ordernum` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '现金/余额消费订单编号',
  `type` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '+,-',
  `time` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '时间',
  `attach` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '备注',
  `worker` int(6) NULL DEFAULT NULL COMMENT '操作员',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '常规积分' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of laytp_scores_simple
-- ----------------------------
INSERT INTO `laytp_scores_simple` VALUES (1, 1, 16.00, 'D0120191113133556231025', '+', '1573616134', '消费累积', 1);
INSERT INTO `laytp_scores_simple` VALUES (2, 1, -5.00, 'J00201912', '-', '1573616134', '结算扣减', 1);

-- ----------------------------
-- Table structure for laytp_user
-- ----------------------------
DROP TABLE IF EXISTS `laytp_user`;
CREATE TABLE `laytp_user`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '会员ID',
  `account` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '会员账号',
  `nickname` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '姓名',
  `phonenum` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '手机号',
  `telnum` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '电话',
  `idcardnum` varchar(18) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '身份证号',
  `birthday` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '生日',
  `sex` tinyint(1) NOT NULL DEFAULT 0 COMMENT '性别0-男，1-女',
  `country` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '国别',
  `prov` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '省份',
  `city` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '城市',
  `cardnum` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '会员卡号',
  `scores_simple` decimal(20, 2) NOT NULL DEFAULT 0.00 COMMENT '常规积分',
  `level` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '普通' COMMENT '普通，黄金，铂金，钻石，黑金',
  `scores_consumption` decimal(20, 2) NOT NULL DEFAULT 0.00 COMMENT '消费积分',
  `last_time` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '最后一次消费时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '会员表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of laytp_user
-- ----------------------------
INSERT INTO `laytp_user` VALUES (1, 'vancevol', '张三', '13800138000', '02800000000', NULL, NULL, 1, '86', '51', '06', '123456789012345', 9.00, '普通', 9.00, '1573616134');
INSERT INTO `laytp_user` VALUES (2, 'vance', '李四', '13312341234', '08380000000', NULL, NULL, 0, '86', '51', '06', '123456789012346', 5.00, '黄金', 5.00, '1573616134');
INSERT INTO `laytp_user` VALUES (3, 'van', '王五', '13312341234', '08380000000', NULL, NULL, 0, '86', '51', '06', '123456789012346', 5.00, '黄金', 5.00, '1573616134');

-- ----------------------------
-- Table structure for laytp_worker
-- ----------------------------
DROP TABLE IF EXISTS `laytp_worker`;
CREATE TABLE `laytp_worker`  (
  `id` int(6) NOT NULL AUTO_INCREMENT COMMENT '业务员ID',
  `user` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '账号',
  `pass` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密码（加密后）',
  `passstatus` tinyint(1) NOT NULL COMMENT '密码状态(是否初始化)',
  `role` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色/职位',
  `nickname` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '昵称/姓名',
  `sex` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0-男，1-女',
  `identity` char(18) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '510101190001012559' COMMENT '身份证号',
  `birthday` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '1900-01-01 00:00:00' COMMENT '生日',
  `saleslevel` smallint(1) NULL DEFAULT NULL COMMENT '业务水平',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '业务员状态0-离职，1-店员，2-组长，4-店长，8-区管',
  PRIMARY KEY (`id`, `user`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '操作员/员工' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of laytp_worker
-- ----------------------------
INSERT INTO `laytp_worker` VALUES (1, 'admin', '21232f297a57a5a743894a0e4a801fc3', 1, 'GM', '系统管理员', 0, '510603190001010012', '1900-01-01 00:00:00', 5, 8);
INSERT INTO `laytp_worker` VALUES (2, 'cs', '95cc64dd2825f9df13ec4ad683ecf339', 0, 'OP', '测试', 1, '510603190101012210', '2019-11-11 00:00:00', 1, 1);
INSERT INTO `laytp_worker` VALUES (3, 'cs2', '43c8ce94d81492e62c60092a3664a65f', 0, 'VW', '测试2', 0, '510123190101012022', '2019-11-11 00:00:00', 1, 1);

-- ----------------------------
-- View structure for 用户提现记录
-- ----------------------------
DROP VIEW IF EXISTS `用户提现记录`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `用户提现记录` AS select `game_extlog`.`_id` AS `number`,`game_extlog`.`_pid` AS `uid`,`game_extlog`.`_gold` AS `account`,`game_extlog`.`_flag` AS `status`,`game_extlog`.`_atime` AS `utime`,`game_extlog`.`_htime` AS `ctime`,`game_extlog`.`_card` AS `cardnum`,`game_extlog`.`_name` AS `uname`,`game_extlog`.`_bank` AS `bank`,`game_extlog`.`_poit` AS `point`,`game_extlog`.`_prov` AS `prov`,`game_extlog`.`_city` AS `city` from `game_extlog` where (`game_extlog`.`_pid` = '312563');

SET FOREIGN_KEY_CHECKS = 1;