/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50726
Source Host           : localhost:3306
Source Database       : csharp_god

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

Date: 2022-07-05 09:54:41
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `categories`
-- ----------------------------
DROP TABLE IF EXISTS `categories`;
CREATE TABLE `categories` (
  `Id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `CateName` varchar(200) DEFAULT NULL,
  `CreateUser` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records of categories
-- ----------------------------
INSERT INTO `categories` VALUES ('1', '服装', 'admin');
INSERT INTO `categories` VALUES ('2', '电子', 'admin');
INSERT INTO `categories` VALUES ('3', '美妆', 'admin');
INSERT INTO `categories` VALUES ('4', '家居', 'admin');
INSERT INTO `categories` VALUES ('5', '宠物类1', 'admin');

-- ----------------------------
-- Table structure for `powergroup`
-- ----------------------------
DROP TABLE IF EXISTS `powergroup`;
CREATE TABLE `powergroup` (
  `Id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `GroupName` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records of powergroup
-- ----------------------------
INSERT INTO `powergroup` VALUES ('1', '产品功能组');
INSERT INTO `powergroup` VALUES ('2', '仓库功能组');
INSERT INTO `powergroup` VALUES ('5', '系统管理组');

-- ----------------------------
-- Table structure for `powers`
-- ----------------------------
DROP TABLE IF EXISTS `powers`;
CREATE TABLE `powers` (
  `Id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `Node` varchar(50) DEFAULT NULL,
  `Remark` varchar(100) DEFAULT NULL,
  `PowerGroupId` int(11) DEFAULT '0',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=gb2312 COMMENT='权限列表';

-- ----------------------------
-- Records of powers
-- ----------------------------
INSERT INTO `powers` VALUES ('19', 'UserList', '用户列表', '5');
INSERT INTO `powers` VALUES ('20', 'RolePower', '角色权限列表查看', '5');
INSERT INTO `powers` VALUES ('21', 'AddUser', '添加用户', '5');
INSERT INTO `powers` VALUES ('22', 'UpdateUser', '修改用户', '5');
INSERT INTO `powers` VALUES ('24', 'UpdateUserPower', '修改用户权限', '5');
INSERT INTO `powers` VALUES ('25', 'UpdateUserRole', '修改用户角色', '5');
INSERT INTO `powers` VALUES ('26', 'RoleNewAdd', '新增角色', '5');
INSERT INTO `powers` VALUES ('27', 'CheckRoles', '查看角色列表', '5');
INSERT INTO `powers` VALUES ('28', 'RoleUpdate', '更新角色', '5');
INSERT INTO `powers` VALUES ('29', 'UpdateRolePower', '更新角色权限', '5');
INSERT INTO `powers` VALUES ('30', 'CheckPower', '查看权限列表', '5');
INSERT INTO `powers` VALUES ('31', 'AddPowerGroup', '添加权限分组', '5');
INSERT INTO `powers` VALUES ('32', 'AddPower', '添加权限', '5');
INSERT INTO `powers` VALUES ('33', 'UpdatePowerGroup', '修改权限分组', '5');
INSERT INTO `powers` VALUES ('34', 'ProductCateCheck', '产品分类查看', '1');
INSERT INTO `powers` VALUES ('35', 'ProductCheck', '产品查看', '1');
INSERT INTO `powers` VALUES ('36', 'SupplierCheck', '供应商查看', '1');
INSERT INTO `powers` VALUES ('37', 'CateAdd', '产品分类添加', '1');
INSERT INTO `powers` VALUES ('38', 'CateUpdate', '产品分类修改', '1');
INSERT INTO `powers` VALUES ('39', 'ProductAdd', '产品添加', '1');
INSERT INTO `powers` VALUES ('40', 'ProductUpdate', '产品修改', '1');
INSERT INTO `powers` VALUES ('41', 'ProductDelete', '产品删除', '1');
INSERT INTO `powers` VALUES ('42', 'ProductAddbBatch', '产品批量导入', '1');

-- ----------------------------
-- Table structure for `products`
-- ----------------------------
DROP TABLE IF EXISTS `products`;
CREATE TABLE `products` (
  `Id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ProductName` varchar(255) DEFAULT NULL,
  `ProductSn` varchar(100) DEFAULT NULL,
  `SupplierId` int(11) DEFAULT '0',
  `ProductStatus` int(4) DEFAULT '0' COMMENT '0-草稿，1-正常，2-冻结',
  `CreateTime` datetime DEFAULT NULL,
  `CateId` int(11) DEFAULT '0',
  `MainSku` varchar(50) DEFAULT NULL,
  `Weight` decimal(10,2) DEFAULT NULL,
  `PurchasePrice` decimal(10,2) DEFAULT NULL,
  `ProductThumbImage` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `ProductSn` (`ProductSn`),
  KEY `ProductName` (`ProductName`),
  KEY `CreateTime` (`CreateTime`),
  KEY `MainSku` (`MainSku`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records of products
-- ----------------------------
INSERT INTO `products` VALUES ('1', '测试服装', 'test01', '0', '1', '2022-07-03 02:52:51', '1', 'test', '100.00', '20.00', 'ProductImages\\20220703\\202207030252505249215.jpeg');
INSERT INTO `products` VALUES ('2', '唐朝服装', 'SKU01A1', '2', '1', '2022-07-03 04:55:46', '1', 'SKU01', '200.00', '150.88', '');
INSERT INTO `products` VALUES ('3', 'TEST1111', 'test99', '0', '1', '2022-07-04 12:09:44', '1', 'test', '200.00', '300.00', 'ProductImages\\20220704\\202207041209428581469.jpg');

-- ----------------------------
-- Table structure for `rolepower`
-- ----------------------------
DROP TABLE IF EXISTS `rolepower`;
CREATE TABLE `rolepower` (
  `Id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `RoleId` int(11) DEFAULT NULL,
  `PowerId` int(11) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=gb2312 COMMENT='角色权限表';

-- ----------------------------
-- Records of rolepower
-- ----------------------------
INSERT INTO `rolepower` VALUES ('13', '2', '19');
INSERT INTO `rolepower` VALUES ('14', '2', '21');
INSERT INTO `rolepower` VALUES ('15', '2', '22');
INSERT INTO `rolepower` VALUES ('16', '2', '33');

-- ----------------------------
-- Table structure for `roles`
-- ----------------------------
DROP TABLE IF EXISTS `roles`;
CREATE TABLE `roles` (
  `Id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `RoleName` varchar(50) DEFAULT NULL,
  `Remark` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records of roles
-- ----------------------------
INSERT INTO `roles` VALUES ('1', '超级管理员', '超级管理员');
INSERT INTO `roles` VALUES ('2', '总经理', '总经理');
INSERT INTO `roles` VALUES ('3', '副总经理', '副总经理');
INSERT INTO `roles` VALUES ('4', '产品经理', '产品经理');
INSERT INTO `roles` VALUES ('5', '仓库经理', '仓库经理');
INSERT INTO `roles` VALUES ('6', '产品主管', '产品主管');
INSERT INTO `roles` VALUES ('7', '仓库主管', '仓库主管');
INSERT INTO `roles` VALUES ('8', '产品组长', '产品组长');
INSERT INTO `roles` VALUES ('9', '仓库组长', '仓库组长');
INSERT INTO `roles` VALUES ('10', '产品员工', '产品员工');
INSERT INTO `roles` VALUES ('11', '仓库员工', '仓库员工');
INSERT INTO `roles` VALUES ('12', 'test789', 'test789');
INSERT INTO `roles` VALUES ('13', '测试第三方', '测试第三方');
INSERT INTO `roles` VALUES ('14', 'test00', 'test00');
INSERT INTO `roles` VALUES ('15', 'sdafsf', 'sdafsf');
INSERT INTO `roles` VALUES ('16', 'sdfasdf', 'sdfasdf');
INSERT INTO `roles` VALUES ('17', 'test8888', 'test8888');

-- ----------------------------
-- Table structure for `supplier`
-- ----------------------------
DROP TABLE IF EXISTS `supplier`;
CREATE TABLE `supplier` (
  `Id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `SupplierName` varchar(255) DEFAULT NULL,
  `Telphone` varchar(20) DEFAULT NULL,
  `Phone` varchar(50) DEFAULT NULL,
  `Country` varchar(50) DEFAULT NULL,
  `Province` varchar(50) DEFAULT NULL,
  `City` varchar(50) DEFAULT NULL,
  `Area` varchar(50) DEFAULT NULL,
  `Address` varchar(250) DEFAULT NULL,
  `CreateTime` datetime DEFAULT NULL,
  `SupplierStatus` int(4) DEFAULT '0' COMMENT '0-未使用，1-正常使用，2-异常',
  `CreateUser` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `SupplierName` (`SupplierName`),
  KEY `Telphone` (`Telphone`),
  KEY `Phone` (`Phone`),
  KEY `CreateTime` (`CreateTime`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records of supplier
-- ----------------------------
INSERT INTO `supplier` VALUES ('2', '唐朝时代服装SB有限公司', '1000000000', '99999', '火星国', '火星省', '火星市', '火星县', '火星村委火星村火星组火星号', '2022-07-05 09:48:45', '1', 'admin');

-- ----------------------------
-- Table structure for `userrolepower`
-- ----------------------------
DROP TABLE IF EXISTS `userrolepower`;
CREATE TABLE `userrolepower` (
  `Id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `PowerId` int(11) DEFAULT NULL,
  `UserId` int(11) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=gb2312 COMMENT='用户角色权限表';

-- ----------------------------
-- Records of userrolepower
-- ----------------------------
INSERT INTO `userrolepower` VALUES ('31', '25', '5');
INSERT INTO `userrolepower` VALUES ('76', '34', '2');
INSERT INTO `userrolepower` VALUES ('77', '36', '2');
INSERT INTO `userrolepower` VALUES ('78', '19', '2');
INSERT INTO `userrolepower` VALUES ('79', '20', '2');
INSERT INTO `userrolepower` VALUES ('80', '22', '2');
INSERT INTO `userrolepower` VALUES ('81', '24', '2');
INSERT INTO `userrolepower` VALUES ('82', '27', '2');
INSERT INTO `userrolepower` VALUES ('83', '28', '2');
INSERT INTO `userrolepower` VALUES ('84', '30', '2');
INSERT INTO `userrolepower` VALUES ('85', '31', '2');
INSERT INTO `userrolepower` VALUES ('86', '33', '2');

-- ----------------------------
-- Table structure for `userroles`
-- ----------------------------
DROP TABLE IF EXISTS `userroles`;
CREATE TABLE `userroles` (
  `Id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `UserId` int(11) DEFAULT NULL,
  `RoleId` int(11) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records of userroles
-- ----------------------------
INSERT INTO `userroles` VALUES ('2', '4', '3');
INSERT INTO `userroles` VALUES ('9', '2', '2');
INSERT INTO `userroles` VALUES ('12', '5', '5');
INSERT INTO `userroles` VALUES ('13', '5', '6');

-- ----------------------------
-- Table structure for `users`
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `Id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Name` varchar(50) DEFAULT NULL COMMENT '用户名',
  `Status` tinyint(1) DEFAULT '1' COMMENT '1-启用，0，冻结',
  `Password` varchar(100) DEFAULT NULL COMMENT '密码',
  `CreateTime` datetime DEFAULT NULL COMMENT '创建时间',
  `Sex` tinyint(4) DEFAULT '0' COMMENT '0-男，1-女',
  `Salt` varchar(10) DEFAULT NULL,
  `Department` varchar(50) DEFAULT NULL,
  `Deadline` date DEFAULT NULL COMMENT '截止日期',
  `IsSuperManager` tinyint(1) DEFAULT '0' COMMENT '是否为超级管理员，0-否，1-是',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES ('1', 'admin', '1', 'BC9B5718AFDFFE85FB13555347969FF5', '2022-06-23 11:53:20', '1', 'abcd', '超级管理员', null, '1');
INSERT INTO `users` VALUES ('2', 'lin3615', '1', 'BC9B5718AFDFFE85FB13555347969FF5', '2022-06-23 11:54:44', '1', 'abcd', '经理', null, '0');
INSERT INTO `users` VALUES ('3', 'admin1', '0', '1AC8DC1444250362004B743FA951951B', '2022-06-23 11:53:20', '0', 'abcd', '经理', null, '1');
INSERT INTO `users` VALUES ('4', 'lin36151', '1', '600AC4EE58D6C98CE6142B3B0D6B61FB', '2022-06-23 11:54:44', '0', 'abcd', '经理11', null, '0');
INSERT INTO `users` VALUES ('5', 'admin2', '1', '1AC8DC1444250362004B743FA951951B', '2022-06-23 11:53:20', '1', 'abcd', '超级管理员', null, '1');
INSERT INTO `users` VALUES ('6', 'lin36152', '1', 'BC9B5718AFDFFE85FB13555347969FF5', '2022-06-23 11:54:44', '1', 'abcd', '经理', null, '0');
INSERT INTO `users` VALUES ('7', 'admin3', '1', '1AC8DC1444250362004B743FA951951B', '2022-06-23 11:53:20', '1', 'abcd', '超级管理员', null, '1');
INSERT INTO `users` VALUES ('8', 'lin36153', '1', 'BC9B5718AFDFFE85FB13555347969FF5', '2022-06-23 11:54:44', '1', 'abcd', '经理', null, '0');
INSERT INTO `users` VALUES ('9', 'admin4', '1', '1AC8DC1444250362004B743FA951951B', '2022-06-23 11:53:20', '1', 'abcd', '超级管理员', null, '1');
INSERT INTO `users` VALUES ('10', 'lin36154', '1', 'BC9B5718AFDFFE85FB13555347969FF5', '2022-06-23 11:54:44', '1', 'abcd', '经理', null, '0');
INSERT INTO `users` VALUES ('11', 'admin5', '1', '1AC8DC1444250362004B743FA951951B', '2022-06-23 11:53:20', '1', 'abcd', '超级管理员', null, '1');
INSERT INTO `users` VALUES ('12', 'lin36155', '1', 'BC9B5718AFDFFE85FB13555347969FF5', '2022-06-23 11:54:44', '1', 'abcd', '经理', null, '0');
INSERT INTO `users` VALUES ('13', 'admin6', '1', '1AC8DC1444250362004B743FA951951B', '2022-06-23 11:53:20', '1', 'abcd', '超级管理员', null, '1');
INSERT INTO `users` VALUES ('14', 'lin36156', '1', 'BC9B5718AFDFFE85FB13555347969FF5', '2022-06-23 11:54:44', '1', 'abcd', '经理', null, '0');
INSERT INTO `users` VALUES ('15', 'admin7', '1', '1AC8DC1444250362004B743FA951951B', '2022-06-23 11:53:20', '1', 'abcd', '超级管理员', null, '1');
INSERT INTO `users` VALUES ('16', 'lin36157', '1', 'BC9B5718AFDFFE85FB13555347969FF5', '2022-06-23 11:54:44', '1', 'abcd', '经理', null, '0');
INSERT INTO `users` VALUES ('17', 'admin8', '1', '1AC8DC1444250362004B743FA951951B', '2022-06-23 11:53:20', '1', 'abcd', '超级管理员', null, '1');
INSERT INTO `users` VALUES ('18', 'lin36158', '1', 'BC9B5718AFDFFE85FB13555347969FF5', '2022-06-23 11:54:44', '1', 'abcd', '经理', null, '0');
INSERT INTO `users` VALUES ('19', 'admin9', '1', '1AC8DC1444250362004B743FA951951B', '2022-06-23 11:53:20', '1', 'abcd', '超级管理员', null, '1');
INSERT INTO `users` VALUES ('20', 'lin36159', '1', 'BC9B5718AFDFFE85FB13555347969FF5', '2022-06-23 11:54:44', '1', 'abcd', '经理', null, '0');
INSERT INTO `users` VALUES ('21', 'admina', '1', '1AC8DC1444250362004B743FA951951B', '2022-06-23 11:53:20', '1', 'abcd', '超级管理员', null, '1');
INSERT INTO `users` VALUES ('22', 'lin3615a', '1', 'BC9B5718AFDFFE85FB13555347969FF5', '2022-06-23 11:54:44', '1', 'abcd', '经理', null, '0');
INSERT INTO `users` VALUES ('23', 'adminb', '1', '1AC8DC1444250362004B743FA951951B', '2022-06-23 11:53:20', '1', 'abcd', '超级管理员', null, '1');
INSERT INTO `users` VALUES ('24', 'lin3615b', '1', 'BC9B5718AFDFFE85FB13555347969FF5', '2022-06-23 11:54:44', '1', 'abcd', '经理', null, '0');
INSERT INTO `users` VALUES ('25', 'adminc', '1', '1AC8DC1444250362004B743FA951951B', '2022-06-23 11:53:20', '1', 'abcd', '超级管理员', null, '1');
INSERT INTO `users` VALUES ('26', 'lin3615c', '1', 'BC9B5718AFDFFE85FB13555347969FF5', '2022-06-23 11:54:44', '1', 'abcd', '经理', null, '0');
INSERT INTO `users` VALUES ('27', 'admind', '1', '1AC8DC1444250362004B743FA951951B', '2022-06-23 11:53:20', '1', 'abcd', '超级管理员', null, '1');
INSERT INTO `users` VALUES ('28', 'lin3615d', '1', 'BC9B5718AFDFFE85FB13555347969FF5', '2022-06-23 11:54:44', '1', 'abcd', '经理', null, '0');
INSERT INTO `users` VALUES ('29', 'admine', '1', '1AC8DC1444250362004B743FA951951B', '2022-06-23 11:53:20', '1', 'abcd', '超级管理员', null, '1');
INSERT INTO `users` VALUES ('30', 'lin3615e', '1', 'BC9B5718AFDFFE85FB13555347969FF5', '2022-06-23 11:54:44', '1', 'abcd', '经理', null, '0');
INSERT INTO `users` VALUES ('31', 'adminf', '1', '1AC8DC1444250362004B743FA951951B', '2022-06-23 11:53:20', '1', 'abcd', '超级管理员', null, '1');
INSERT INTO `users` VALUES ('32', 'lin3615f', '1', 'BC9B5718AFDFFE85FB13555347969FF5', '2022-06-23 11:54:44', '1', 'abcd', '经理', null, '0');
INSERT INTO `users` VALUES ('33', 'test123', '1', '97893760066CAAE13AB73EF2A54F0335', '2022-06-27 14:35:32', '1', 'VVVV', '测试', null, '0');
INSERT INTO `users` VALUES ('34', 'testabc', '1', 'F3DA8C2DEAF957A7E9E0E60624A46EB8', '2022-06-27 14:37:42', '0', 'cccc', 'teset', null, '0');