384 lines
13 KiB
SQL
384 lines
13 KiB
SQL
/*
|
|
Navicat Premium Data Transfer
|
|
|
|
Source Server : localhost
|
|
Source Server Type : MySQL
|
|
Source Server Version : 80023
|
|
Source Host : localhost
|
|
Source Database : ferry
|
|
|
|
Target Server Type : MySQL
|
|
Target Server Version : 80023
|
|
File Encoding : utf-8
|
|
|
|
Date: 08/05/2021 15:07:42 PM
|
|
*/
|
|
|
|
SET NAMES utf8mb4;
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for `casbin_rule`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `casbin_rule`;
|
|
CREATE TABLE `casbin_rule` (
|
|
`p_type` varchar(100) DEFAULT NULL,
|
|
`v0` varchar(100) DEFAULT NULL,
|
|
`v1` varchar(100) DEFAULT NULL,
|
|
`v2` varchar(100) DEFAULT NULL,
|
|
`v3` varchar(100) DEFAULT NULL,
|
|
`v4` varchar(100) DEFAULT NULL,
|
|
`v5` varchar(100) DEFAULT NULL,
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
|
`create_time` timestamp NULL DEFAULT NULL,
|
|
`update_time` timestamp NULL DEFAULT NULL,
|
|
`delete_time` timestamp NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_casbin_rule_delete_time` (`delete_time`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for `p_process_classify`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `p_process_classify`;
|
|
CREATE TABLE `p_process_classify` (
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
|
`create_time` timestamp NULL DEFAULT NULL,
|
|
`update_time` timestamp NULL DEFAULT NULL,
|
|
`delete_time` timestamp NULL DEFAULT NULL,
|
|
`name` varchar(128) DEFAULT NULL,
|
|
`creator` int DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_p_process_classify_delete_time` (`delete_time`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for `p_process_info`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `p_process_info`;
|
|
CREATE TABLE `p_process_info` (
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
|
`create_time` timestamp NULL DEFAULT NULL,
|
|
`update_time` timestamp NULL DEFAULT NULL,
|
|
`delete_time` timestamp NULL DEFAULT NULL,
|
|
`name` varchar(128) DEFAULT NULL,
|
|
`icon` varchar(128) DEFAULT NULL,
|
|
`structure` json DEFAULT NULL,
|
|
`classify` int DEFAULT NULL,
|
|
`tpls` json DEFAULT NULL,
|
|
`task` json DEFAULT NULL,
|
|
`submit_count` int DEFAULT '0',
|
|
`creator` int DEFAULT NULL,
|
|
`notice` json DEFAULT NULL,
|
|
`remarks` varchar(1024) DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_p_process_info_delete_time` (`delete_time`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for `p_task_history`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `p_task_history`;
|
|
CREATE TABLE `p_task_history` (
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
|
`create_time` timestamp NULL DEFAULT NULL,
|
|
`update_time` timestamp NULL DEFAULT NULL,
|
|
`delete_time` timestamp NULL DEFAULT NULL,
|
|
`task` int DEFAULT NULL,
|
|
`name` varchar(256) DEFAULT NULL,
|
|
`task_type` int DEFAULT NULL,
|
|
`execution_time` varchar(128) DEFAULT NULL,
|
|
`result` longtext,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_p_task_history_delete_time` (`delete_time`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for `p_task_info`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `p_task_info`;
|
|
CREATE TABLE `p_task_info` (
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
|
`create_time` timestamp NULL DEFAULT NULL,
|
|
`update_time` timestamp NULL DEFAULT NULL,
|
|
`delete_time` timestamp NULL DEFAULT NULL,
|
|
`name` varchar(256) DEFAULT NULL,
|
|
`task_type` varchar(45) DEFAULT NULL,
|
|
`content` longtext,
|
|
`creator` int DEFAULT NULL,
|
|
`remarks` longtext,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_p_task_info_delete_time` (`delete_time`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for `p_tpl_info`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `p_tpl_info`;
|
|
CREATE TABLE `p_tpl_info` (
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
|
`create_time` timestamp NULL DEFAULT NULL,
|
|
`update_time` timestamp NULL DEFAULT NULL,
|
|
`delete_time` timestamp NULL DEFAULT NULL,
|
|
`name` varchar(128) DEFAULT NULL,
|
|
`form_structure` json DEFAULT NULL,
|
|
`creator` int DEFAULT NULL,
|
|
`remarks` longtext,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_p_tpl_info_delete_time` (`delete_time`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for `p_work_order_circulation_history`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `p_work_order_circulation_history`;
|
|
CREATE TABLE `p_work_order_circulation_history` (
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
|
`create_time` timestamp NULL DEFAULT NULL,
|
|
`update_time` timestamp NULL DEFAULT NULL,
|
|
`delete_time` timestamp NULL DEFAULT NULL,
|
|
`title` varchar(128) DEFAULT NULL,
|
|
`work_order` int DEFAULT NULL,
|
|
`state` varchar(128) DEFAULT NULL,
|
|
`source` varchar(128) DEFAULT NULL,
|
|
`target` varchar(128) DEFAULT NULL,
|
|
`circulation` varchar(128) DEFAULT NULL,
|
|
`status` int DEFAULT NULL,
|
|
`processor` varchar(45) DEFAULT NULL,
|
|
`processor_id` int DEFAULT NULL,
|
|
`cost_duration` int DEFAULT NULL,
|
|
`remarks` longtext,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_p_work_order_circulation_history_delete_time` (`delete_time`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for `p_work_order_info`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `p_work_order_info`;
|
|
CREATE TABLE `p_work_order_info` (
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
|
`create_time` timestamp NULL DEFAULT NULL,
|
|
`update_time` timestamp NULL DEFAULT NULL,
|
|
`delete_time` timestamp NULL DEFAULT NULL,
|
|
`title` varchar(128) DEFAULT NULL,
|
|
`priority` int DEFAULT NULL,
|
|
`process` int DEFAULT NULL,
|
|
`classify` int DEFAULT NULL,
|
|
`is_end` int DEFAULT '0',
|
|
`is_denied` int DEFAULT '0',
|
|
`state` json DEFAULT NULL,
|
|
`related_person` json DEFAULT NULL,
|
|
`creator` int DEFAULT NULL,
|
|
`urge_count` int DEFAULT '0',
|
|
`urge_last_time` int DEFAULT '0',
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_p_work_order_info_delete_time` (`delete_time`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for `p_work_order_tpl_data`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `p_work_order_tpl_data`;
|
|
CREATE TABLE `p_work_order_tpl_data` (
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
|
`create_time` timestamp NULL DEFAULT NULL,
|
|
`update_time` timestamp NULL DEFAULT NULL,
|
|
`delete_time` timestamp NULL DEFAULT NULL,
|
|
`work_order` int DEFAULT NULL,
|
|
`form_structure` json DEFAULT NULL,
|
|
`form_data` json DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_p_work_order_tpl_data_delete_time` (`delete_time`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for `sys_dept`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `sys_dept`;
|
|
CREATE TABLE `sys_dept` (
|
|
`dept_id` int NOT NULL AUTO_INCREMENT,
|
|
`parent_id` int DEFAULT NULL,
|
|
`dept_path` varchar(255) DEFAULT NULL,
|
|
`dept_name` varchar(128) DEFAULT NULL,
|
|
`sort` int DEFAULT NULL,
|
|
`leader` int DEFAULT NULL,
|
|
`phone` varchar(11) DEFAULT NULL,
|
|
`email` varchar(64) DEFAULT NULL,
|
|
`status` int DEFAULT NULL,
|
|
`create_by` varchar(64) DEFAULT NULL,
|
|
`update_by` varchar(64) DEFAULT NULL,
|
|
`create_time` timestamp NULL DEFAULT NULL,
|
|
`update_time` timestamp NULL DEFAULT NULL,
|
|
`delete_time` timestamp NULL DEFAULT NULL,
|
|
PRIMARY KEY (`dept_id`),
|
|
KEY `idx_sys_dept_delete_time` (`delete_time`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for `sys_loginlog`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `sys_loginlog`;
|
|
CREATE TABLE `sys_loginlog` (
|
|
`info_id` int NOT NULL AUTO_INCREMENT,
|
|
`username` varchar(128) DEFAULT NULL,
|
|
`status` int DEFAULT NULL,
|
|
`ipaddr` varchar(255) DEFAULT NULL,
|
|
`login_location` varchar(255) DEFAULT NULL,
|
|
`browser` varchar(255) DEFAULT NULL,
|
|
`os` varchar(255) DEFAULT NULL,
|
|
`platform` varchar(255) DEFAULT NULL,
|
|
`login_time` timestamp NULL DEFAULT NULL,
|
|
`create_by` varchar(128) DEFAULT NULL,
|
|
`update_by` varchar(128) DEFAULT NULL,
|
|
`remark` varchar(255) DEFAULT NULL,
|
|
`msg` varchar(255) DEFAULT NULL,
|
|
`create_time` timestamp NULL DEFAULT NULL,
|
|
`update_time` timestamp NULL DEFAULT NULL,
|
|
`delete_time` timestamp NULL DEFAULT NULL,
|
|
PRIMARY KEY (`info_id`),
|
|
KEY `idx_sys_loginlog_delete_time` (`delete_time`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for `sys_menu`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `sys_menu`;
|
|
CREATE TABLE `sys_menu` (
|
|
`menu_id` int NOT NULL AUTO_INCREMENT,
|
|
`menu_name` varchar(128) DEFAULT NULL,
|
|
`title` varchar(64) DEFAULT NULL,
|
|
`icon` varchar(128) DEFAULT NULL,
|
|
`path` varchar(128) DEFAULT NULL,
|
|
`paths` varchar(128) DEFAULT NULL,
|
|
`menu_type` varchar(1) DEFAULT NULL,
|
|
`action` varchar(16) DEFAULT NULL,
|
|
`permission` varchar(32) DEFAULT NULL,
|
|
`parent_id` int DEFAULT NULL,
|
|
`no_cache` char(1) DEFAULT NULL,
|
|
`breadcrumb` varchar(255) DEFAULT NULL,
|
|
`component` varchar(255) DEFAULT NULL,
|
|
`sort` int DEFAULT NULL,
|
|
`visible` char(1) DEFAULT NULL,
|
|
`create_by` varchar(128) DEFAULT NULL,
|
|
`update_by` varchar(128) DEFAULT NULL,
|
|
`is_frame` int DEFAULT '0',
|
|
`create_time` timestamp NULL DEFAULT NULL,
|
|
`update_time` timestamp NULL DEFAULT NULL,
|
|
`delete_time` timestamp NULL DEFAULT NULL,
|
|
PRIMARY KEY (`menu_id`),
|
|
KEY `idx_sys_menu_delete_time` (`delete_time`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for `sys_post`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `sys_post`;
|
|
CREATE TABLE `sys_post` (
|
|
`post_id` int NOT NULL AUTO_INCREMENT,
|
|
`post_name` varchar(128) DEFAULT NULL,
|
|
`post_code` varchar(128) DEFAULT NULL,
|
|
`sort` int DEFAULT NULL,
|
|
`status` int DEFAULT NULL,
|
|
`remark` varchar(255) DEFAULT NULL,
|
|
`create_by` varchar(128) DEFAULT NULL,
|
|
`update_by` varchar(128) DEFAULT NULL,
|
|
`create_time` timestamp NULL DEFAULT NULL,
|
|
`update_time` timestamp NULL DEFAULT NULL,
|
|
`delete_time` timestamp NULL DEFAULT NULL,
|
|
PRIMARY KEY (`post_id`),
|
|
KEY `idx_sys_post_delete_time` (`delete_time`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for `sys_role`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `sys_role`;
|
|
CREATE TABLE `sys_role` (
|
|
`role_id` int NOT NULL AUTO_INCREMENT,
|
|
`role_name` varchar(128) DEFAULT NULL,
|
|
`status` int DEFAULT NULL,
|
|
`role_key` varchar(128) DEFAULT NULL,
|
|
`role_sort` int DEFAULT NULL,
|
|
`flag` varchar(128) DEFAULT NULL,
|
|
`create_by` varchar(128) DEFAULT NULL,
|
|
`update_by` varchar(128) DEFAULT NULL,
|
|
`remark` varchar(255) DEFAULT NULL,
|
|
`admin` char(1) DEFAULT NULL,
|
|
`create_time` timestamp NULL DEFAULT NULL,
|
|
`update_time` timestamp NULL DEFAULT NULL,
|
|
`delete_time` timestamp NULL DEFAULT NULL,
|
|
PRIMARY KEY (`role_id`),
|
|
KEY `idx_sys_role_delete_time` (`delete_time`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for `sys_role_dept`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `sys_role_dept`;
|
|
CREATE TABLE `sys_role_dept` (
|
|
`role_id` int DEFAULT NULL,
|
|
`dept_id` int DEFAULT NULL,
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for `sys_role_menu`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `sys_role_menu`;
|
|
CREATE TABLE `sys_role_menu` (
|
|
`role_id` int DEFAULT NULL,
|
|
`menu_id` int DEFAULT NULL,
|
|
`role_name` varchar(128) DEFAULT NULL,
|
|
`create_by` varchar(128) DEFAULT NULL,
|
|
`update_by` varchar(128) DEFAULT NULL,
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for `sys_settings`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `sys_settings`;
|
|
CREATE TABLE `sys_settings` (
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
|
`create_time` timestamp NULL DEFAULT NULL,
|
|
`update_time` timestamp NULL DEFAULT NULL,
|
|
`delete_time` timestamp NULL DEFAULT NULL,
|
|
`classify` int DEFAULT NULL,
|
|
`content` json DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `idx_sys_settings_delete_time` (`delete_time`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for `sys_user`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `sys_user`;
|
|
CREATE TABLE `sys_user` (
|
|
`user_id` int NOT NULL AUTO_INCREMENT,
|
|
`nick_name` varchar(128) DEFAULT NULL,
|
|
`phone` varchar(11) DEFAULT NULL,
|
|
`role_id` int DEFAULT NULL,
|
|
`salt` varchar(255) DEFAULT NULL,
|
|
`avatar` varchar(255) DEFAULT NULL,
|
|
`sex` varchar(255) DEFAULT NULL,
|
|
`email` varchar(128) DEFAULT NULL,
|
|
`dept_id` int DEFAULT NULL,
|
|
`post_id` int DEFAULT NULL,
|
|
`create_by` varchar(128) DEFAULT NULL,
|
|
`update_by` varchar(128) DEFAULT NULL,
|
|
`remark` varchar(255) DEFAULT NULL,
|
|
`status` int DEFAULT NULL,
|
|
`create_time` timestamp NULL DEFAULT NULL,
|
|
`update_time` timestamp NULL DEFAULT NULL,
|
|
`delete_time` timestamp NULL DEFAULT NULL,
|
|
`username` varchar(64) DEFAULT NULL,
|
|
`password` varchar(128) DEFAULT NULL,
|
|
PRIMARY KEY (`user_id`),
|
|
KEY `idx_sys_user_delete_time` (`delete_time`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1;
|