652 lines
44 KiB
SQL
652 lines
44 KiB
SQL
/*
|
||
Navicat MySQL Data Transfer
|
||
|
||
Source Server : ifish_test
|
||
Source Server Version : 50630
|
||
Source Host : 139.196.24.156:3306
|
||
Source Database : cwhelp
|
||
|
||
Target Server Type : MYSQL
|
||
Target Server Version : 50630
|
||
File Encoding : 65001
|
||
|
||
Date: 2019-08-16 00:09:39
|
||
*/
|
||
|
||
SET FOREIGN_KEY_CHECKS=0;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for bss_dept
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `bss_dept`;
|
||
CREATE TABLE `bss_dept` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '部门名称',
|
||
`description` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '描述',
|
||
`platform_id` bigint(20) DEFAULT NULL COMMENT '平台ID',
|
||
`create_date` datetime DEFAULT NULL COMMENT '创建时间',
|
||
`update_date` datetime DEFAULT NULL COMMENT '更新时间',
|
||
`create_by` bigint(20) DEFAULT NULL COMMENT '创建用户',
|
||
`update_by` bigint(20) DEFAULT NULL COMMENT '更新用户',
|
||
`status` tinyint(4) DEFAULT NULL COMMENT '状态（1:正常,2:冻结,3:删除）',
|
||
`remark` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '备注',
|
||
PRIMARY KEY (`id`),
|
||
KEY `bss_dept_ibfk_1` (`create_by`),
|
||
KEY `bss_dept_ibfk_2` (`update_by`),
|
||
KEY `bss_dept_ibfk_3` (`platform_id`),
|
||
CONSTRAINT `bss_dept_ibfk_1` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`id`),
|
||
CONSTRAINT `bss_dept_ibfk_2` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`id`),
|
||
CONSTRAINT `bss_dept_ibfk_3` FOREIGN KEY (`platform_id`) REFERENCES `bss_platform` (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
||
-- ----------------------------
|
||
-- Records of bss_dept
|
||
-- ----------------------------
|
||
INSERT INTO `bss_dept` VALUES ('1', '系统部', '系统部', '2', '2019-07-30 00:14:36', '2019-07-30 18:18:08', '1', '1', '1', '系统部');
|
||
INSERT INTO `bss_dept` VALUES ('2', '业务部', '业务部', '1', '2019-08-01 23:36:41', '2019-08-01 23:36:41', '1', '1', '1', '业务部');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for bss_employee
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `bss_employee`;
|
||
CREATE TABLE `bss_employee` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`name` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '员工名称',
|
||
`dept_id` bigint(20) DEFAULT NULL COMMENT '部门ID',
|
||
`position` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '职位',
|
||
`phone_num` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '手机号码',
|
||
`card` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '身份证号码',
|
||
`email` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '邮箱',
|
||
`sex` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '性别',
|
||
`education` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '学历',
|
||
`create_date` datetime DEFAULT NULL COMMENT '创建时间',
|
||
`update_date` datetime DEFAULT NULL COMMENT '更新时间',
|
||
`create_by` bigint(20) DEFAULT NULL COMMENT '创建用户',
|
||
`update_by` bigint(20) DEFAULT NULL COMMENT '更新用户',
|
||
`status` tinyint(4) DEFAULT NULL COMMENT '状态（1:正常,2:冻结,3:删除）',
|
||
`remark` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '备注',
|
||
PRIMARY KEY (`id`),
|
||
KEY `bss_employee_ibfk_1` (`dept_id`),
|
||
KEY `bss_employee_ibfk_2` (`create_by`),
|
||
KEY `bss_employee_ibfk_3` (`update_by`),
|
||
CONSTRAINT `bss_employee_ibfk_1` FOREIGN KEY (`dept_id`) REFERENCES `bss_dept` (`id`),
|
||
CONSTRAINT `bss_employee_ibfk_2` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`id`),
|
||
CONSTRAINT `bss_employee_ibfk_3` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
||
-- ----------------------------
|
||
-- Records of bss_employee
|
||
-- ----------------------------
|
||
INSERT INTO `bss_employee` VALUES ('1', '易焱', '2', '业务员', '18521303582', '430621199508207711', 'thelongcode@163.com', '1', '4', '2019-08-01 23:47:29', '2019-08-01 23:52:02', '1', '1', '1', '');
|
||
INSERT INTO `bss_employee` VALUES ('2', '易焱1', '1', '系统管理员', '18521303581', '430621199508207711', 'thelongcode@163.com', '1', '5', '2019-08-02 01:06:28', '2019-08-02 01:06:28', '8', '8', '1', '');
|
||
INSERT INTO `bss_employee` VALUES ('3', '测试用户', '2', '业务员', '13721775488', '430621198401224475', '535709395@qq.com', '1', '5', '2019-08-05 20:49:29', '2019-08-05 20:49:29', '1', '1', '1', '');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for bss_enterprise
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `bss_enterprise`;
|
||
CREATE TABLE `bss_enterprise` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '名称',
|
||
`name` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
||
`credit_code` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '统一社会信用代码',
|
||
`platform_id` bigint(20) DEFAULT NULL COMMENT '所属平台',
|
||
`location` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '所在地',
|
||
`industry` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '行业',
|
||
`vat_type` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '增值税种类(1:小规模纳税人 2:一般纳税人)',
|
||
`accounting_standards` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '会计准则(1:小企业会计准则 2:企业会计准则 3:民间非营利组织会计制度)',
|
||
`create_date` datetime DEFAULT NULL COMMENT '创建时间',
|
||
`update_date` datetime DEFAULT NULL COMMENT '更新时间',
|
||
`create_by` bigint(20) DEFAULT NULL COMMENT '创建用户',
|
||
`update_by` bigint(20) DEFAULT NULL COMMENT '更新用户',
|
||
`status` tinyint(4) DEFAULT NULL COMMENT '状态（1:正常,2:冻结,3:删除）',
|
||
`remark` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '备注',
|
||
PRIMARY KEY (`id`),
|
||
KEY `bss_enterprise__ibfk_1` (`platform_id`),
|
||
KEY `bss_enterprise__ibfk_2` (`create_by`),
|
||
KEY `bss_enterprise__ibfk_3` (`update_by`),
|
||
CONSTRAINT `bss_enterprise__ibfk_1` FOREIGN KEY (`platform_id`) REFERENCES `bss_platform` (`id`),
|
||
CONSTRAINT `bss_enterprise__ibfk_2` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`id`),
|
||
CONSTRAINT `bss_enterprise__ibfk_3` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
||
-- ----------------------------
|
||
-- Records of bss_enterprise
|
||
-- ----------------------------
|
||
INSERT INTO `bss_enterprise` VALUES ('1', '爱鱼奇科技有限公司', '224877755446', '1', '上海市', '智能硬件', '2', '1', '2019-08-06 23:03:22', '2019-08-06 23:05:21', '1', '1', '1', '');
|
||
INSERT INTO `bss_enterprise` VALUES ('2', '爱鱼奇科技有限公司1', '22487775544645', '1', '上海市', '智能硬件', '1', '2', '2019-08-06 23:22:53', '2019-08-06 23:22:53', '1', '1', '3', '');
|
||
INSERT INTO `bss_enterprise` VALUES ('3', '爱鱼奇科技有限公司', '224877755446', '1', '上海市', '智能硬件', '1', '1', '2019-08-06 23:30:50', '2019-08-06 23:30:50', '1', '1', '3', '');
|
||
INSERT INTO `bss_enterprise` VALUES ('4', '爱鱼奇科技有限公司1', '2248777554463', '1', '上海市', '智能硬件', '2', '1', '2019-08-06 23:33:36', '2019-08-06 23:36:26', '1', '1', '1', '');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for bss_goods
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `bss_goods`;
|
||
CREATE TABLE `bss_goods` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`name` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '货物名称',
|
||
`code` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '货物代码',
|
||
`num` int(11) DEFAULT NULL COMMENT '数量',
|
||
`detail_amount` decimal(10,2) DEFAULT NULL COMMENT '细节金额',
|
||
`tax_amount` decimal(10,2) DEFAULT NULL COMMENT '税额',
|
||
`tax_rate` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '税率',
|
||
`unit` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '单位',
|
||
`unit_price` decimal(10,2) DEFAULT NULL COMMENT '单价',
|
||
`specification` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '规格型号',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
||
-- ----------------------------
|
||
-- Records of bss_goods
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for bss_platform
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `bss_platform`;
|
||
CREATE TABLE `bss_platform` (
|
||
`id` bigint(10) NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`name` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '名称',
|
||
`contact` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '联系人',
|
||
`contact_tel` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '联系电话',
|
||
`contact_card` varchar(18) CHARACTER SET utf8 DEFAULT NULL COMMENT '联系人证件号码',
|
||
`email` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '邮箱',
|
||
`type` int(10) DEFAULT NULL COMMENT '类型(1:自营 2:代理 3:个人 4:公司)',
|
||
`create_date` datetime DEFAULT NULL COMMENT '创建时间',
|
||
`update_date` datetime DEFAULT NULL COMMENT '更新时间',
|
||
`create_by` bigint(20) DEFAULT NULL COMMENT '创建用户',
|
||
`update_by` bigint(20) DEFAULT NULL COMMENT '更新用户',
|
||
`status` tinyint(4) DEFAULT NULL COMMENT '状态（1:正常,2:冻结,3:删除）',
|
||
`remark` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '备注',
|
||
PRIMARY KEY (`id`),
|
||
KEY `FKb3pkx0wbo6o8i8lj0gxr37v1s` (`create_by`) USING BTREE,
|
||
KEY `FKb3pkx0wbo6o8i8lj0gxr37v2n` (`update_by`) USING BTREE,
|
||
CONSTRAINT `bss_platform_ibfk_1` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`id`),
|
||
CONSTRAINT `bss_platform_ibfk_2` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='平台';
|
||
|
||
-- ----------------------------
|
||
-- Records of bss_platform
|
||
-- ----------------------------
|
||
INSERT INTO `bss_platform` VALUES ('1', '财务帮', '易焱', '18521303581', '430621199508207711', 'thelongcode@163.com', '1', '2019-07-28 22:13:21', '2019-07-29 00:03:40', '1', '1', '1', '');
|
||
INSERT INTO `bss_platform` VALUES ('2', '易焱工作室', '易焱', '18521303583', '430621199508207713', 'thelongcode1@163.com', '4', '2019-07-29 00:09:57', '2019-08-06 23:42:40', '1', '1', '1', '');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for bss_taxinfo
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `bss_taxinfo`;
|
||
CREATE TABLE `bss_taxinfo` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`tax_no` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '纳税人识别号',
|
||
`account` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '开户行及账号',
|
||
`address_phone` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '地址、电话',
|
||
`name` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '名称',
|
||
`remark` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '备注',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
||
-- ----------------------------
|
||
-- Records of bss_taxinfo
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for bss_vat_invoice
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `bss_vat_invoice`;
|
||
CREATE TABLE `bss_vat_invoice` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`invoice_code` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '发票代码',
|
||
`invoice_no` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '发票号码',
|
||
`invoice_date` date DEFAULT NULL COMMENT '发票日期',
|
||
`check_code` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '校验码',
|
||
`machine_no` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '机器编码',
|
||
`invoice_money` decimal(10,0) DEFAULT NULL COMMENT '发票金额',
|
||
`tax_amount` decimal(10,0) DEFAULT NULL COMMENT '税额',
|
||
`total_amount` decimal(10,0) DEFAULT NULL COMMENT '总金额',
|
||
`total_amount_cn` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '总金额(大写)',
|
||
`remark` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '备注',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
||
|
||
-- ----------------------------
|
||
-- Records of bss_vat_invoice
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for sys_action_log
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `sys_action_log`;
|
||
CREATE TABLE `sys_action_log` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`name` varchar(255) DEFAULT NULL COMMENT '日志名称',
|
||
`type` tinyint(4) DEFAULT NULL COMMENT '日志类型',
|
||
`ipaddr` varchar(255) DEFAULT NULL COMMENT '操作IP地址',
|
||
`clazz` varchar(255) DEFAULT NULL COMMENT '产生日志的类',
|
||
`method` varchar(255) DEFAULT NULL COMMENT '产生日志的方法',
|
||
`model` varchar(255) DEFAULT NULL COMMENT '产生日志的表',
|
||
`record_id` bigint(20) DEFAULT NULL COMMENT '产生日志的数据id',
|
||
`message` text COMMENT '日志消息',
|
||
`create_date` datetime DEFAULT NULL COMMENT '记录时间',
|
||
`oper_name` varchar(255) DEFAULT NULL COMMENT '产生日志的用户昵称',
|
||
`oper_by` bigint(20) DEFAULT NULL COMMENT '产生日志的用户',
|
||
PRIMARY KEY (`id`),
|
||
KEY `FK32gm4dja0jetx58r9dc2uljiu` (`oper_by`) USING BTREE,
|
||
CONSTRAINT `sys_action_log_ibfk_1` FOREIGN KEY (`oper_by`) REFERENCES `sys_user` (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=1421 DEFAULT CHARSET=utf8;
|
||
|
||
-- ----------------------------
|
||
-- Records of sys_action_log
|
||
-- ----------------------------
|
||
INSERT INTO `sys_action_log` VALUES ('1420', '用户登录', '2', '0:0:0:0:0:0:0:1', 'com.cwhelp.admin.system.controller.LoginController', 'login', null, null, '后台登录成功', '2019-08-13 17:25:06', '超级管理员', '1');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for sys_dept
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `sys_dept`;
|
||
CREATE TABLE `sys_dept` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`title` varchar(255) DEFAULT NULL COMMENT '部门名称',
|
||
`pid` bigint(20) DEFAULT NULL COMMENT '父级ID',
|
||
`pids` varchar(255) DEFAULT NULL COMMENT '所有父级编号',
|
||
`sort` int(11) DEFAULT NULL COMMENT '排序',
|
||
`remark` varchar(255) DEFAULT NULL COMMENT '备注',
|
||
`create_date` datetime DEFAULT NULL COMMENT '创建时间',
|
||
`update_date` datetime DEFAULT NULL COMMENT '更新时间',
|
||
`create_by` bigint(20) DEFAULT NULL COMMENT '创建用户',
|
||
`update_by` bigint(20) DEFAULT NULL COMMENT '更新用户',
|
||
`status` tinyint(4) DEFAULT NULL COMMENT '状态（1:正常,2:冻结,3:删除）',
|
||
PRIMARY KEY (`id`),
|
||
KEY `FKifwd1h4ciusl3nnxrpfpv316u` (`create_by`) USING BTREE,
|
||
KEY `FK83g45s1cjqqfpifhulqhv807m` (`update_by`) USING BTREE,
|
||
CONSTRAINT `sys_dept_ibfk_1` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`id`),
|
||
CONSTRAINT `sys_dept_ibfk_2` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
|
||
|
||
-- ----------------------------
|
||
-- Records of sys_dept
|
||
-- ----------------------------
|
||
INSERT INTO `sys_dept` VALUES ('1', '财务帮', '1', '[0]', '1', '', '2018-12-02 17:41:23', '2019-07-28 22:24:30', '1', '1', '1');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for sys_dict
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `sys_dict`;
|
||
CREATE TABLE `sys_dict` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`title` varchar(255) DEFAULT NULL COMMENT '字典名称',
|
||
`name` varchar(255) DEFAULT NULL COMMENT '字典键名',
|
||
`type` tinyint(4) DEFAULT NULL COMMENT '字典类型',
|
||
`value` text COMMENT '字典键值',
|
||
`remark` varchar(255) DEFAULT NULL COMMENT '备注',
|
||
`create_date` datetime DEFAULT NULL COMMENT '创建时间',
|
||
`update_date` datetime DEFAULT NULL COMMENT '更新时间',
|
||
`create_by` bigint(20) DEFAULT NULL COMMENT '创建用户',
|
||
`update_by` bigint(20) DEFAULT NULL COMMENT '更新用户',
|
||
`status` tinyint(4) DEFAULT NULL COMMENT '状态（1:正常,2:冻结,3:删除）',
|
||
PRIMARY KEY (`id`),
|
||
KEY `FKag4shuprf2tjot9i1mhh37kk6` (`create_by`) USING BTREE,
|
||
KEY `FKoyng5jlifhsme0gc1lwiub0lr` (`update_by`) USING BTREE,
|
||
CONSTRAINT `sys_dict_ibfk_1` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`id`),
|
||
CONSTRAINT `sys_dict_ibfk_2` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;
|
||
|
||
-- ----------------------------
|
||
-- Records of sys_dict
|
||
-- ----------------------------
|
||
INSERT INTO `sys_dict` VALUES ('1', '数据状态', 'DATA_STATUS', '2', '1:正常,2:冻结,3:删除', '', '2018-10-05 16:03:11', '2018-10-05 16:11:41', '1', '1', '1');
|
||
INSERT INTO `sys_dict` VALUES ('2', '字典类型', 'DICT_TYPE', '2', '2:键值对', '', '2018-10-05 20:08:55', '2019-01-17 23:39:23', '1', '1', '1');
|
||
INSERT INTO `sys_dict` VALUES ('3', '用户性别', 'USER_SEX', '2', '1:男,2:女', '', '2018-10-05 20:12:32', '2019-07-28 22:06:57', '1', '1', '1');
|
||
INSERT INTO `sys_dict` VALUES ('4', '菜单类型', 'MENU_TYPE', '2', '1:一级菜单,2:子级菜单,3:不是菜单', '', '2018-10-05 20:24:57', '2018-10-13 13:56:05', '1', '1', '1');
|
||
INSERT INTO `sys_dict` VALUES ('5', '搜索栏状态', 'SEARCH_STATUS', '2', '1:正常,2:冻结', '', '2018-10-05 20:25:45', '2019-02-26 00:34:34', '1', '1', '1');
|
||
INSERT INTO `sys_dict` VALUES ('6', '日志类型', 'LOG_TYPE', '2', '1:业务,2:登录,3:系统', '', '2018-10-05 20:28:47', '2019-02-26 00:31:43', '1', '1', '1');
|
||
INSERT INTO `sys_dict` VALUES ('11', '平台类型', 'BSS_PLATFORM_TYPE', '2', '1:自营,2:代理,3:个人,4:公司', '', '2019-07-29 00:07:58', '2019-07-29 00:07:58', '1', '1', '1');
|
||
INSERT INTO `sys_dict` VALUES ('12', '业务部门类型', 'BSS_DEPT_TYPE', '2', '1:行政部,2:财务部,3:市场部,4:采购部,5:研发部,6:人力资源部,7:企管部,8:技术部,9:后勤部,10:销售部,11:其它', '', '2019-07-29 21:36:59', '2019-07-29 21:36:59', '1', '1', '1');
|
||
INSERT INTO `sys_dict` VALUES ('13', '用户类型', 'USER_TYPE', '2', '1:平台账号,2:普通账号', '', '2019-07-31 20:23:57', '2019-07-31 20:23:57', '1', '1', '1');
|
||
INSERT INTO `sys_dict` VALUES ('14', '员工状态', 'EMPLOYEE_TYPE', '2', '1:在职,2:离职', '', '2019-07-31 23:23:20', '2019-07-31 23:23:20', '1', '1', '1');
|
||
INSERT INTO `sys_dict` VALUES ('15', '学历', 'EDUCATION', '2', '1:初中及以下,2:高中,3:大专,4:本科,5:研究生,6:博士', '', '2019-07-31 23:25:09', '2019-07-31 23:25:09', '1', '1', '1');
|
||
INSERT INTO `sys_dict` VALUES ('16', '角色类型', 'ROLE_TYPE', '2', '1:平台,2:普通', '', '2019-08-04 21:32:47', '2019-08-04 21:32:47', '1', '1', '1');
|
||
INSERT INTO `sys_dict` VALUES ('17', '增值税种类', 'VAT_TYPE', '2', '1:小规模纳税人,2:一般纳税人', '', '2019-08-06 20:46:22', '2019-08-06 20:47:31', '1', '1', '1');
|
||
INSERT INTO `sys_dict` VALUES ('18', '会计准则', 'ACCOUNTING_STANDARDS', '2', '1:小企业会计准则,2:企业会计准则,3:民间非营利组织会计制度', '', '2019-08-06 20:47:21', '2019-08-06 20:47:21', '1', '1', '1');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for sys_file
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `sys_file`;
|
||
CREATE TABLE `sys_file` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`name` varchar(255) DEFAULT NULL COMMENT '文件名',
|
||
`path` varchar(255) DEFAULT NULL COMMENT '文件路径',
|
||
`mime` varchar(255) DEFAULT NULL COMMENT 'MIME文件类型',
|
||
`size` bigint(20) DEFAULT NULL COMMENT '文件大小',
|
||
`md5` varchar(255) DEFAULT NULL COMMENT 'MD5值',
|
||
`sha1` varchar(255) DEFAULT NULL COMMENT 'SHA1值',
|
||
`create_by` bigint(20) DEFAULT NULL COMMENT '上传者',
|
||
`create_date` datetime DEFAULT NULL COMMENT '创建时间',
|
||
PRIMARY KEY (`id`),
|
||
KEY `FKkkles8yp0a156p4247cc22ovn` (`create_by`) USING BTREE,
|
||
CONSTRAINT `sys_file_ibfk_1` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
|
||
|
||
-- ----------------------------
|
||
-- Records of sys_file
|
||
-- ----------------------------
|
||
INSERT INTO `sys_file` VALUES ('2', 'c3b2a31dca404ad0bf96bb10719bf689.jpg', '/upload/picture/20190726/c3b2a31dca404ad0bf96bb10719bf689.jpg', 'image/jpeg', '28481', 'd66845460db278aebea5177a61acd55', '1f11ebf41da73951a7c884404f8ac42c012830c3', '1', '2019-07-26 21:24:49');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for sys_menu
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `sys_menu`;
|
||
CREATE TABLE `sys_menu` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`title` varchar(255) DEFAULT NULL COMMENT '菜单名称',
|
||
`pid` bigint(20) DEFAULT NULL COMMENT '父级编号',
|
||
`pids` varchar(255) DEFAULT NULL COMMENT '所有父级编号',
|
||
`url` varchar(255) DEFAULT NULL COMMENT 'URL地址',
|
||
`perms` varchar(255) DEFAULT NULL COMMENT '权限标识',
|
||
`icon` varchar(255) DEFAULT NULL COMMENT '图标',
|
||
`type` tinyint(4) DEFAULT NULL COMMENT '类型（1:一级菜单,2:子级菜单,3:不是菜单）',
|
||
`sort` int(11) DEFAULT NULL COMMENT '排序',
|
||
`remark` varchar(255) DEFAULT NULL COMMENT '备注',
|
||
`create_date` datetime DEFAULT NULL COMMENT '创建时间',
|
||
`update_date` datetime DEFAULT NULL COMMENT '更新时间',
|
||
`create_by` bigint(20) DEFAULT NULL COMMENT '创建用户',
|
||
`update_by` bigint(20) DEFAULT NULL COMMENT '更新用户',
|
||
`status` tinyint(4) DEFAULT NULL COMMENT '状态（1:正常,2:冻结,3:删除）',
|
||
PRIMARY KEY (`id`),
|
||
KEY `FKoxg2hi96yr9pf2m0stjomr3we` (`create_by`) USING BTREE,
|
||
KEY `FKsiko0qcr8ddamvrxf1tk4opgc` (`update_by`) USING BTREE,
|
||
CONSTRAINT `sys_menu_ibfk_1` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`id`),
|
||
CONSTRAINT `sys_menu_ibfk_2` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=180 DEFAULT CHARSET=utf8;
|
||
|
||
-- ----------------------------
|
||
-- Records of sys_menu
|
||
-- ----------------------------
|
||
INSERT INTO `sys_menu` VALUES ('1', '菜单管理', '2', '[0],[2]', '/system/menu/index', 'system:menu:index', '', '2', '3', '', '2018-09-29 00:02:10', '2019-02-24 16:10:40', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('2', '系统管理', '0', '[0]', '#', '#', 'fa fa-cog', '1', '3', '', '2018-09-29 00:05:50', '2019-07-28 23:58:27', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('3', '添加', '1', '[0],[2],[1]', '/system/menu/add', 'system:menu:add', '', '3', '1', '', '2018-09-29 00:06:57', '2019-02-24 16:12:59', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('4', '角色管理', '2', '[0],[2]', '/system/role/index', 'system:role:index', '', '2', '2', '', '2018-09-29 00:08:14', '2019-02-24 16:10:34', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('5', '添加', '4', '[0],[2],[4]', '/system/role/add', 'system:role:add', '', '3', '1', '', '2018-09-29 00:09:04', '2019-02-24 16:12:04', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('6', '主页', '0', '[0]', '/index', 'index', 'layui-icon layui-icon-home', '1', '1', '', '2018-09-29 00:09:56', '2019-02-27 21:34:56', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('7', '用户管理', '2', '[0],[2]', '/system/user/index', 'system:user:index', '', '2', '1', '', '2018-09-29 00:43:50', '2019-04-05 17:43:25', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('8', '编辑', '1', '[0],[2],[1]', '/system/menu/edit', 'system:menu:edit', '', '3', '2', '', '2018-09-29 00:57:33', '2019-02-24 16:13:05', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('9', '详细', '1', '[0],[2],[1]', '/system/menu/detail', 'system:menu:detail', '', '3', '3', '', '2018-09-29 01:03:00', '2019-02-24 16:13:12', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('10', '修改状态', '1', '[0],[2],[1]', '/system/menu/status', 'system:menu:status', '', '3', '4', '', '2018-09-29 01:03:43', '2019-02-24 16:13:21', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('11', '编辑', '4', '[0],[2],[4]', '/system/role/edit', 'system:role:edit', '', '3', '2', '', '2018-09-29 01:06:13', '2019-02-24 16:12:10', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('12', '授权', '4', '[0],[2],[4]', '/system/role/auth', 'system:role:auth', '', '3', '3', '', '2018-09-29 01:06:57', '2019-02-24 16:12:17', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('13', '详细', '4', '[0],[2],[4]', '/system/role/detail', 'system:role:detail', '', '3', '4', '', '2018-09-29 01:08:00', '2019-02-24 16:12:24', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('14', '修改状态', '4', '[0],[2],[4]', '/system/role/status', 'system:role:status', '', '3', '5', '', '2018-09-29 01:08:22', '2019-02-24 16:12:43', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('15', '编辑', '7', '[0],[2],[7]', '/system/user/edit', 'system:user:edit', '', '3', '2', '', '2018-09-29 21:17:17', '2019-02-24 16:11:03', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('16', '添加', '7', '[0],[2],[7]', '/system/user/add', 'system:user:add', '', '3', '1', '', '2018-09-29 21:17:58', '2019-02-24 16:10:28', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('17', '修改密码', '7', '[0],[2],[7]', '/system/user/pwd', 'system:user:pwd', '', '3', '3', '', '2018-09-29 21:19:40', '2019-02-24 16:11:11', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('18', '权限分配', '7', '[0],[2],[7]', '/system/user/role', 'system:user:role', '', '3', '4', '', '2018-09-29 21:20:35', '2019-02-24 16:11:18', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('19', '详细', '7', '[0],[2],[7]', '/system/user/detail', 'system:user:detail', '', '3', '5', '', '2018-09-29 21:21:00', '2019-02-24 16:11:26', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('20', '修改状态', '7', '[0],[2],[7]', '/system/user/status', 'system:user:status', '', '3', '6', '', '2018-09-29 21:21:18', '2019-02-24 16:11:35', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('21', '字典管理', '2', '[0],[2]', '/system/dict/index', 'system:dict:index', '', '2', '5', '', '2018-10-05 00:55:52', '2019-02-24 16:14:24', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('22', '字典添加', '21', '[0],[2],[21]', '/system/dict/add', 'system:dict:add', '', '3', '1', '', '2018-10-05 00:56:26', '2019-02-24 16:14:10', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('23', '字典编辑', '21', '[0],[2],[21]', '/system/dict/edit', 'system:dict:edit', '', '3', '2', '', '2018-10-05 00:57:08', '2019-02-24 16:14:34', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('24', '字典详细', '21', '[0],[2],[21]', '/system/dict/detail', 'system:dict:detail', '', '3', '3', '', '2018-10-05 00:57:42', '2019-02-24 16:14:41', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('25', '修改状态', '21', '[0],[2],[21]', '/system/dict/status', 'system:dict:status', '', '3', '4', '', '2018-10-05 00:58:27', '2019-02-24 16:14:49', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('26', '行为日志', '30', '[0],[2]', '/system/actionLog/index', 'system:actionLog:index', '', '2', '4', '', '2018-10-14 16:52:01', '2019-07-28 22:32:45', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('27', '日志详细', '26', '[0],[2],[26]', '/system/actionLog/detail', 'system:actionLog:detail', '', '3', '1', '', '2018-10-14 21:07:11', '2019-02-27 21:34:15', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('28', '日志删除', '26', '[0],[2],[26]', '/system/actionLog/delete', 'system:actionLog:delete', '', '3', '2', '', '2018-10-14 21:08:17', '2019-02-27 21:34:15', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('30', '开发中心', '0', '[0]', '#', '#', 'fa fa-gavel', '1', '4', '', '2018-10-19 16:38:23', '2019-07-28 23:58:27', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('31', '代码生成', '30', '[0],[30]', '/dev/code', '#', '', '2', '1', '', '2018-10-19 16:39:04', '2019-03-13 17:43:58', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('125', '表单构建', '30', '[0],[30]', '/dev/build', '#', '', '2', '2', '', '2018-11-25 16:12:23', '2019-02-24 16:16:40', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('136', '部门管理', '2', '[0],[2]', '/system/dept/index', 'system:dept:index', '', '2', '4', '', '2018-12-02 16:33:23', '2019-02-24 16:10:50', '1', '1', '3');
|
||
INSERT INTO `sys_menu` VALUES ('137', '添加', '136', '[0],[2],[136]', '/system/dept/add', 'system:dept:add', '', '3', '1', '', '2018-12-02 16:33:23', '2019-02-24 16:13:34', '1', '1', '3');
|
||
INSERT INTO `sys_menu` VALUES ('138', '编辑', '136', '[0],[2],[136]', '/system/dept/edit', 'system:dept:edit', '', '3', '2', '', '2018-12-02 16:33:23', '2019-02-24 16:13:42', '1', '1', '3');
|
||
INSERT INTO `sys_menu` VALUES ('139', '详细', '136', '[0],[2],[136]', '/system/dept/detail', 'system:dept:detail', '', '3', '3', '', '2018-12-02 16:33:23', '2019-02-24 16:13:49', '1', '1', '3');
|
||
INSERT INTO `sys_menu` VALUES ('140', '改变状态', '136', '[0],[2],[136]', '/system/dept/status', 'system:dept:status', '', '3', '4', '', '2018-12-02 16:33:23', '2019-02-24 16:13:57', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('146', '数据接口', '30', '[0],[30]', '/dev/swagger', '#', '', '2', '3', '', '2018-12-09 21:11:11', '2019-02-24 23:38:18', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('159', '平台信息', '164', '[0]', '/bss/platform/index', 'bss:platform:index', 'fa fa-television', '1', '1', '', '2019-07-28 23:30:18', '2019-07-29 00:02:07', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('160', '添加', '159', '[0],[159]', '/bss/platform/add', 'bss:platform:add', '', '3', '1', '', '2019-07-28 23:30:18', '2019-07-29 00:02:20', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('161', '编辑', '159', '[0],[159]', '/bss/platform/edit', 'bss:platform:edit', '', '3', '2', '', '2019-07-28 23:30:18', '2019-07-29 00:02:29', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('162', '详细', '159', '[0],[159]', '/bss/platform/detail', 'bss:platform:detail', '', '3', '3', '', '2019-07-28 23:30:18', '2019-07-29 00:02:41', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('163', '修改状态', '159', '[0],[159]', '/bss/platform/status', 'bss:platform:status', '', '3', '4', '', '2019-07-28 23:30:18', '2019-07-29 00:02:50', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('164', '财务帮', '0', '[0]', '#', 'bss', 'fa fa-bars', '1', '2', '', '2019-07-28 23:58:27', '2019-07-28 23:58:27', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('165', '业务部门', '164', '[0]', '/bss/dept/index', 'bss:dept:index', 'fa fa-television', '1', '2', '', '2019-07-29 22:01:41', '2019-07-29 22:40:19', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('166', '添加', '165', '[0],[165]', '/bss/dept/add', 'bss:dept:add', '', '3', '1', '', '2019-07-29 22:01:41', '2019-07-29 22:40:32', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('167', '编辑', '165', '[0],[165]', '/bss/dept/edit', 'bss:dept:edit', '', '3', '2', '', '2019-07-29 22:01:41', '2019-07-29 22:40:43', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('168', '详细', '165', '[0],[165]', '/bss/dept/detail', 'bss:dept:detail', '', '3', '3', '', '2019-07-29 22:01:41', '2019-07-29 22:40:56', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('169', '修改状态', '165', '[0],[165]', '/bss/dept/status', 'bss:dept:status', '', '3', '4', '', '2019-07-29 22:01:41', '2019-07-29 22:41:06', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('170', '员工', '164', '[0]', '/bss/employee/index', 'bss:employee:index', '', '1', '3', '', '2019-07-31 23:35:49', '2019-07-31 23:56:28', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('171', '添加', '170', '[0],[170]', '/bss/employee/add', 'bss:employee:add', '', '3', '1', '', '2019-07-31 23:35:49', '2019-07-31 23:56:40', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('172', '编辑', '170', '[0],[170]', '/bss/employee/edit', 'bss:employee:edit', '', '3', '2', '', '2019-07-31 23:35:49', '2019-07-31 23:56:48', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('173', '详细', '170', '[0],[170]', '/bss/employee/detail', 'bss:employee:detail', '', '3', '3', '', '2019-07-31 23:35:49', '2019-07-31 23:57:00', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('174', '修改状态', '170', '[0],[170]', '/bss/employee/status', 'bss:employee:status', '', '3', '4', '', '2019-07-31 23:35:49', '2019-07-31 23:57:18', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('175', '账套信息', '164', '[0]', '/bss/enterprise/index', 'bss:enterprise:index', '', '1', '4', '', '2019-08-06 21:15:16', '2019-08-06 21:27:16', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('176', '添加', '175', '[0],[175]', '/bss/enterprise/add', 'bss:enterprise:add', null, '3', '1', null, '2019-08-06 21:15:16', '2019-08-06 21:15:16', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('177', '编辑', '175', '[0],[175]', '/bss/enterprise/edit', 'bss:enterprise:edit', null, '3', '1', null, '2019-08-06 21:15:16', '2019-08-06 21:15:16', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('178', '详细', '175', '[0],[175]', '/bss/enterprise/detail', 'bss:enterprise:detail', null, '3', '1', null, '2019-08-06 21:15:16', '2019-08-06 21:15:16', '1', '1', '1');
|
||
INSERT INTO `sys_menu` VALUES ('179', '修改状态', '175', '[0],[175]', '/bss/enterprise/status', 'bss:enterprise:status', null, '3', '1', null, '2019-08-06 21:15:16', '2019-08-06 21:15:16', '1', '1', '1');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for sys_role
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `sys_role`;
|
||
CREATE TABLE `sys_role` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`title` varchar(255) DEFAULT NULL COMMENT '角色名称（中文名）',
|
||
`name` varchar(255) DEFAULT NULL COMMENT '标识名称',
|
||
`type` varchar(255) DEFAULT NULL COMMENT '类型(1:平台 2:普通)',
|
||
`remark` varchar(255) DEFAULT NULL COMMENT '备注',
|
||
`create_date` datetime DEFAULT NULL COMMENT '创建时间',
|
||
`update_date` datetime DEFAULT NULL COMMENT '更新时间',
|
||
`create_by` bigint(20) DEFAULT NULL COMMENT '创建用户',
|
||
`update_by` bigint(20) DEFAULT NULL COMMENT '更新用户',
|
||
`status` tinyint(4) DEFAULT NULL COMMENT '状态（1:正常,2:冻结,3:删除）',
|
||
PRIMARY KEY (`id`),
|
||
KEY `FKdkwvv0rm6j3d5l6hwsy2dplol` (`create_by`) USING BTREE,
|
||
KEY `FKrouqqi3f2bgc5o83wdstlh6q4` (`update_by`) USING BTREE,
|
||
CONSTRAINT `sys_role_ibfk_1` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`id`),
|
||
CONSTRAINT `sys_role_ibfk_2` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;
|
||
|
||
-- ----------------------------
|
||
-- Records of sys_role
|
||
-- ----------------------------
|
||
INSERT INTO `sys_role` VALUES ('1', '超级管理员', 'admin', '1', '', '2018-09-29 00:12:40', '2019-08-01 00:49:32', '1', '1', '1');
|
||
INSERT INTO `sys_role` VALUES ('16', '业务管理', 'business_admin', '2', '业务管理人员角色', '2019-07-28 17:25:46', '2019-08-05 21:02:46', '1', '1', '1');
|
||
INSERT INTO `sys_role` VALUES ('17', '业务通用', 'business_common', '2', '业务通用人员角色', '2019-07-28 17:26:40', '2019-08-05 21:02:37', '1', '1', '1');
|
||
INSERT INTO `sys_role` VALUES ('18', '账套管理员', 'zt_admin', '2', '', '2019-08-04 22:03:36', '2019-08-07 00:05:33', '1', '1', '1');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for sys_role_menu
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `sys_role_menu`;
|
||
CREATE TABLE `sys_role_menu` (
|
||
`role_id` bigint(20) NOT NULL,
|
||
`menu_id` bigint(20) NOT NULL,
|
||
PRIMARY KEY (`role_id`,`menu_id`),
|
||
KEY `FKf3mud4qoc7ayew8nml4plkevo` (`menu_id`) USING BTREE,
|
||
CONSTRAINT `sys_role_menu_ibfk_1` FOREIGN KEY (`menu_id`) REFERENCES `sys_menu` (`id`),
|
||
CONSTRAINT `sys_role_menu_ibfk_2` FOREIGN KEY (`role_id`) REFERENCES `sys_role` (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
|
||
-- ----------------------------
|
||
-- Records of sys_role_menu
|
||
-- ----------------------------
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '1');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '2');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '3');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '4');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '5');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '6');
|
||
INSERT INTO `sys_role_menu` VALUES ('16', '6');
|
||
INSERT INTO `sys_role_menu` VALUES ('17', '6');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '7');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '8');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '9');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '10');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '11');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '12');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '13');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '14');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '15');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '16');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '17');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '18');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '19');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '20');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '21');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '22');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '23');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '24');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '25');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '26');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '27');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '28');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '30');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '31');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '125');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '140');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '146');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '159');
|
||
INSERT INTO `sys_role_menu` VALUES ('18', '159');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '160');
|
||
INSERT INTO `sys_role_menu` VALUES ('18', '160');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '161');
|
||
INSERT INTO `sys_role_menu` VALUES ('18', '161');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '162');
|
||
INSERT INTO `sys_role_menu` VALUES ('18', '162');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '163');
|
||
INSERT INTO `sys_role_menu` VALUES ('18', '163');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '164');
|
||
INSERT INTO `sys_role_menu` VALUES ('16', '164');
|
||
INSERT INTO `sys_role_menu` VALUES ('17', '164');
|
||
INSERT INTO `sys_role_menu` VALUES ('18', '164');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '165');
|
||
INSERT INTO `sys_role_menu` VALUES ('16', '165');
|
||
INSERT INTO `sys_role_menu` VALUES ('18', '165');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '166');
|
||
INSERT INTO `sys_role_menu` VALUES ('16', '166');
|
||
INSERT INTO `sys_role_menu` VALUES ('18', '166');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '167');
|
||
INSERT INTO `sys_role_menu` VALUES ('16', '167');
|
||
INSERT INTO `sys_role_menu` VALUES ('18', '167');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '168');
|
||
INSERT INTO `sys_role_menu` VALUES ('16', '168');
|
||
INSERT INTO `sys_role_menu` VALUES ('18', '168');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '169');
|
||
INSERT INTO `sys_role_menu` VALUES ('16', '169');
|
||
INSERT INTO `sys_role_menu` VALUES ('18', '169');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '170');
|
||
INSERT INTO `sys_role_menu` VALUES ('16', '170');
|
||
INSERT INTO `sys_role_menu` VALUES ('17', '170');
|
||
INSERT INTO `sys_role_menu` VALUES ('18', '170');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '171');
|
||
INSERT INTO `sys_role_menu` VALUES ('16', '171');
|
||
INSERT INTO `sys_role_menu` VALUES ('17', '171');
|
||
INSERT INTO `sys_role_menu` VALUES ('18', '171');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '172');
|
||
INSERT INTO `sys_role_menu` VALUES ('16', '172');
|
||
INSERT INTO `sys_role_menu` VALUES ('17', '172');
|
||
INSERT INTO `sys_role_menu` VALUES ('18', '172');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '173');
|
||
INSERT INTO `sys_role_menu` VALUES ('16', '173');
|
||
INSERT INTO `sys_role_menu` VALUES ('17', '173');
|
||
INSERT INTO `sys_role_menu` VALUES ('18', '173');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '174');
|
||
INSERT INTO `sys_role_menu` VALUES ('16', '174');
|
||
INSERT INTO `sys_role_menu` VALUES ('17', '174');
|
||
INSERT INTO `sys_role_menu` VALUES ('18', '174');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '175');
|
||
INSERT INTO `sys_role_menu` VALUES ('18', '175');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '176');
|
||
INSERT INTO `sys_role_menu` VALUES ('18', '176');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '177');
|
||
INSERT INTO `sys_role_menu` VALUES ('18', '177');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '178');
|
||
INSERT INTO `sys_role_menu` VALUES ('18', '178');
|
||
INSERT INTO `sys_role_menu` VALUES ('1', '179');
|
||
INSERT INTO `sys_role_menu` VALUES ('18', '179');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for sys_user
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `sys_user`;
|
||
CREATE TABLE `sys_user` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`username` varchar(255) DEFAULT NULL COMMENT '用户名',
|
||
`nickname` varchar(255) DEFAULT NULL COMMENT '用户昵称',
|
||
`password` varchar(255) DEFAULT NULL COMMENT '密码',
|
||
`salt` varchar(255) DEFAULT NULL COMMENT '密码盐',
|
||
`bss_platform_id` bigint(20) DEFAULT NULL COMMENT '平台ID',
|
||
`dept_id` bigint(20) DEFAULT NULL COMMENT '部门ID',
|
||
`picture` varchar(255) DEFAULT NULL COMMENT '头像',
|
||
`sex` varchar(255) DEFAULT NULL COMMENT '性别（1:男,2:女）',
|
||
`type` varchar(255) DEFAULT NULL COMMENT '类型(1:平台账号 2:普通账号)',
|
||
`email` varchar(255) DEFAULT NULL COMMENT '邮箱',
|
||
`phone` varchar(255) DEFAULT NULL COMMENT '电话号码',
|
||
`remark` varchar(255) DEFAULT NULL COMMENT '备注',
|
||
`create_date` datetime DEFAULT NULL COMMENT '创建时间',
|
||
`update_date` datetime DEFAULT NULL COMMENT '更新时间',
|
||
`status` tinyint(4) DEFAULT NULL COMMENT '状态（1:正常,2:冻结,3:删除）',
|
||
PRIMARY KEY (`id`),
|
||
KEY `FKb3pkx0wbo6o8i8lj0gxr37v1n` (`dept_id`) USING BTREE,
|
||
KEY `sys_user_ibfk_2` (`bss_platform_id`),
|
||
CONSTRAINT `sys_user_ibfk_1` FOREIGN KEY (`dept_id`) REFERENCES `sys_dept` (`id`),
|
||
CONSTRAINT `sys_user_ibfk_2` FOREIGN KEY (`bss_platform_id`) REFERENCES `bss_platform` (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
|
||
|
||
-- ----------------------------
|
||
-- Records of sys_user
|
||
-- ----------------------------
|
||
INSERT INTO `sys_user` VALUES ('1', 'admin', '超级管理员', '3dd0affe1e514fa059d00bf63134fe48d45acd3f350aaed83b0b54ef05579092', '3ABR79', '1', '1', '/upload/picture/20190726/c3b2a31dca404ad0bf96bb10719bf689.jpg', '1', '1', 'thelongcode@163.com', '18521303581', '', '2018-08-09 23:00:03', '2019-08-07 00:23:14', '1');
|
||
INSERT INTO `sys_user` VALUES ('8', 'yiyan', '易焱', 'b97b7e057a8af725a2c13f9abb0c84c47d34a948947d5564e308a315030f5a85', '6wHos0', '2', '1', null, '1', '1', 'thelongcode@163.com', '18501773036', '12345', '2019-07-28 18:02:41', '2019-08-06 20:22:37', '1');
|
||
INSERT INTO `sys_user` VALUES ('9', 'thelongcode@163.com', 'thelongcode@163.com', '238a8f6b94a8299d1689c070278c3282a9e3a0f9cc0ef574605d0b96344eb631', 'n2LAmG', '2', '1', null, '1', '1', 'thelongcode@163.com', '18501773037', '', '2019-07-31 20:30:39', '2019-08-05 00:59:42', '1');
|
||
INSERT INTO `sys_user` VALUES ('10', '18521303582', '18521303582', '3190a8cb7f834b457174d1b880c4ef4ae4cc1fdd324d02366a8cc9544c2f9a6e', 'WHW0Nx', '1', '1', null, '1', '2', 'thelongcode2@163.com', '18521303582', '', '2019-08-05 01:38:13', '2019-08-05 20:17:42', '1');
|
||
INSERT INTO `sys_user` VALUES ('11', '13721775488', '测试用户', '90534664c6a36ae97c4db6159c5c7ee5ad3fa9bc962e5318a4036d00b04beeaa', 'yeMy24', '1', '1', null, '1', '2', '535709395@qq.com', '13721775488', '系统生成', '2019-08-05 20:50:49', '2019-08-05 21:03:05', '1');
|
||
INSERT INTO `sys_user` VALUES ('12', '18521303581', '易焱1', 'b12fe138c157f7b1b5ff466086541dc089c28b4e702c9a4d6c548241a6c7110e', 'yn7XLD', '2', '1', null, '1', '2', 'thelongcode@163.com', '18521303581', '系统生成', '2019-08-06 20:22:17', '2019-08-06 20:22:20', '1');
|
||
|
||
-- ----------------------------
|
||
-- Table structure for sys_user_role
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `sys_user_role`;
|
||
CREATE TABLE `sys_user_role` (
|
||
`user_id` bigint(20) NOT NULL,
|
||
`role_id` bigint(20) NOT NULL,
|
||
PRIMARY KEY (`user_id`,`role_id`),
|
||
KEY `FKhh52n8vd4ny9ff4x9fb8v65qx` (`role_id`) USING BTREE,
|
||
CONSTRAINT `sys_user_role_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `sys_user` (`id`),
|
||
CONSTRAINT `sys_user_role_ibfk_2` FOREIGN KEY (`role_id`) REFERENCES `sys_role` (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
|
||
-- ----------------------------
|
||
-- Records of sys_user_role
|
||
-- ----------------------------
|
||
INSERT INTO `sys_user_role` VALUES ('1', '1');
|
||
INSERT INTO `sys_user_role` VALUES ('8', '16');
|
||
INSERT INTO `sys_user_role` VALUES ('10', '16');
|
||
INSERT INTO `sys_user_role` VALUES ('11', '16');
|
||
INSERT INTO `sys_user_role` VALUES ('12', '16');
|
||
INSERT INTO `sys_user_role` VALUES ('8', '17');
|
||
INSERT INTO `sys_user_role` VALUES ('10', '17');
|
||
INSERT INTO `sys_user_role` VALUES ('12', '17');
|
||
INSERT INTO `sys_user_role` VALUES ('8', '18');
|
||
INSERT INTO `sys_user_role` VALUES ('10', '18');
|
||
INSERT INTO `sys_user_role` VALUES ('12', '18');
|
||
|
||
|
||
-- ----------------------------
|
||
-- Table structure for sys_class_item
|
||
-- ----------------------------
|
||
CREATE TABLE `sys_class_item` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
||
`create_date` datetime DEFAULT NULL,
|
||
`item_name` varchar(255) DEFAULT NULL,
|
||
`item_type` smallint(6) DEFAULT NULL,
|
||
`remark` varchar(255) DEFAULT NULL,
|
||
`status` tinyint(4) DEFAULT NULL,
|
||
`create_by` bigint(20) DEFAULT NULL,
|
||
PRIMARY KEY (`id`),
|
||
KEY `FKscjv9528cflikft0lwnwcujv0` (`create_by`),
|
||
CONSTRAINT `FKscjv9528cflikft0lwnwcujv0` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
|
||
|
||
|
||
-- ----------------------------
|
||
-- Records of sys_class_item
|
||
-- ----------------------------
|
||
INSERT INTO `sys_user_role` VALUES (1, '2019-12-11 21:12:20','食品支出',1,'',1,1);
|
||
INSERT INTO `sys_user_role` VALUES (2, '2019-12-11 21:12:20','食品收入',1,'',1,1); |