From 1d6c74b931a1d45707a87a2193eae1ea64c60fc5 Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@163.com>
Date: 星期六, 27 一月 2024 16:46:57 +0800
Subject: [PATCH] #
---
zy-asrs-wcs/version/asrs.sql | 219 ++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 219 insertions(+), 0 deletions(-)
diff --git a/zy-asrs-wcs/version/asrs.sql b/zy-asrs-wcs/version/asrs.sql
new file mode 100644
index 0000000..b360164
--- /dev/null
+++ b/zy-asrs-wcs/version/asrs.sql
@@ -0,0 +1,219 @@
+/*
+SQLyog Ultimate v12.09 (64 bit)
+MySQL - 5.7.40-log : Database - asrs
+*********************************************************************
+*/
+
+/*!40101 SET NAMES utf8 */;
+
+/*!40101 SET SQL_MODE=''*/;
+
+/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
+/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
+/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
+/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
+CREATE DATABASE /*!32312 IF NOT EXISTS*/`asrs` /*!40100 DEFAULT CHARACTER SET latin1 */;
+
+USE `asrs`;
+
+/*Table structure for table `sys_dept` */
+
+DROP TABLE IF EXISTS `sys_dept`;
+
+CREATE TABLE `sys_dept` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
+ `name` varchar(255) NOT NULL COMMENT '鍚嶇О',
+ `parent_id` bigint(20) DEFAULT NULL COMMENT '涓婄骇閮ㄩ棬',
+ `parent_name` varchar(255) DEFAULT NULL COMMENT '涓婄骇閮ㄩ棬鍚�',
+ `path` varchar(255) DEFAULT NULL COMMENT '鍏宠仈璺緞',
+ `path_name` varchar(255) DEFAULT NULL COMMENT '鍏宠仈璺緞鍚�',
+ `full_name` varchar(255) DEFAULT NULL COMMENT '鍏ㄧО',
+ `brief` varchar(255) DEFAULT NULL COMMENT '绠�杩�',
+ `code` varchar(255) DEFAULT NULL COMMENT '鏍囪瘑',
+ `type` int(11) DEFAULT NULL COMMENT '绫诲瀷',
+ `leader` varchar(255) DEFAULT NULL COMMENT '璐熻矗浜�',
+ `count` int(11) DEFAULT NULL COMMENT '鏁伴噺',
+ `sort` int(11) DEFAULT NULL COMMENT '鎺掑簭',
+ `host_id` bigint(20) DEFAULT NULL COMMENT '鎵�灞炴満鏋刐sys_host]',
+ `status` int(11) DEFAULT '1' COMMENT '鐘舵�亄1:姝ｅ父,0:绂佺敤}',
+ `deleted` int(11) DEFAULT '0' COMMENT '鏄惁鍒犻櫎{1:鏄�,0:鍚',
+ `create_time` datetime DEFAULT NULL COMMENT '娣诲姞鏃堕棿',
+ `create_by` bigint(20) DEFAULT NULL COMMENT '娣诲姞浜哄憳[sys_user]',
+ `update_time` datetime DEFAULT NULL COMMENT '淇敼鏃堕棿',
+ `update_by` bigint(20) DEFAULT NULL COMMENT '淇敼浜哄憳[sys_user]',
+ `memo` varchar(255) DEFAULT NULL COMMENT '澶囨敞',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+/*Data for the table `sys_dept` */
+
+/*Table structure for table `sys_host` */
+
+DROP TABLE IF EXISTS `sys_host`;
+
+CREATE TABLE `sys_host` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
+ `name` varchar(255) NOT NULL COMMENT '鍚嶇О',
+ `status` int(11) DEFAULT '1' COMMENT '鐘舵�亄1:姝ｅ父,0:绂佺敤}',
+ `deleted` int(11) DEFAULT '0' COMMENT '鏄惁鍒犻櫎{1:鏄�,0:鍚',
+ `create_time` datetime DEFAULT NULL COMMENT '娣诲姞鏃堕棿',
+ `update_time` datetime DEFAULT NULL COMMENT '淇敼鏃堕棿',
+ `memo` varchar(255) DEFAULT NULL COMMENT '澶囨敞',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+/*Data for the table `sys_host` */
+
+/*Table structure for table `sys_menu` */
+
+DROP TABLE IF EXISTS `sys_menu`;
+
+CREATE TABLE `sys_menu` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
+ `name` varchar(255) NOT NULL COMMENT '鍚嶇О',
+ `parent_id` bigint(20) DEFAULT NULL COMMENT '涓婄骇鑿滃崟',
+ `parent_name` varchar(255) DEFAULT NULL COMMENT '涓婄骇鑿滃崟鍚�',
+ `path` varchar(255) DEFAULT NULL COMMENT '鍏宠仈璺緞',
+ `path_name` varchar(255) DEFAULT NULL COMMENT '鍏宠仈璺緞鍚�',
+ `route` varchar(255) DEFAULT NULL COMMENT '璺敱鍦板潃',
+ `brief` varchar(255) DEFAULT NULL COMMENT '绠�杩�',
+ `code` varchar(255) DEFAULT NULL COMMENT '鏍囪瘑',
+ `type` int(11) DEFAULT NULL COMMENT '绫诲瀷{0:鑿滃崟,1:鎸夐挳}',
+ `authority` varchar(255) DEFAULT NULL COMMENT '鏉冮檺鏍囪瘑',
+ `icon` varchar(255) DEFAULT NULL COMMENT '鑿滃崟鍥炬爣',
+ `sort` int(11) DEFAULT NULL COMMENT '鎺掑簭',
+ `meta` varchar(255) DEFAULT NULL COMMENT '鍏冧俊鎭�',
+ `host_id` bigint(20) DEFAULT NULL COMMENT '鎵�灞炴満鏋刐sys_host]',
+ `status` int(11) DEFAULT '1' COMMENT '鐘舵�亄1:姝ｅ父,0:绂佺敤}',
+ `deleted` int(11) DEFAULT '0' COMMENT '鏄惁鍒犻櫎{1:鏄�,0:鍚',
+ `create_time` datetime DEFAULT NULL COMMENT '娣诲姞鏃堕棿',
+ `create_by` bigint(20) DEFAULT NULL COMMENT '娣诲姞浜哄憳[sys_user]',
+ `update_time` datetime DEFAULT NULL COMMENT '淇敼鏃堕棿',
+ `update_by` bigint(20) DEFAULT NULL COMMENT '淇敼浜哄憳[sys_user]',
+ `memo` varchar(255) DEFAULT NULL COMMENT '澶囨敞',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+/*Data for the table `sys_menu` */
+
+/*Table structure for table `sys_operation_record` */
+
+DROP TABLE IF EXISTS `sys_operation_record`;
+
+CREATE TABLE `sys_operation_record` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
+ `namespace` varchar(255) DEFAULT NULL COMMENT '鍚嶇О绌洪棿',
+ `url` varchar(255) DEFAULT NULL COMMENT '鎺ュ彛鍦板潃',
+ `appkey` varchar(255) DEFAULT NULL COMMENT '骞冲彴瀵嗛挜',
+ `timestamp` varchar(255) DEFAULT NULL COMMENT '鏃堕棿鎴�',
+ `client_ip` varchar(255) DEFAULT NULL COMMENT '瀹㈡埛绔疘P',
+ `request` longtext COMMENT '璇锋眰鍐呭',
+ `response` longtext COMMENT '鍝嶅簲鍐呭',
+ `err` longtext COMMENT '寮傚父鍐呭',
+ `result` int(11) DEFAULT NULL COMMENT '缁撴灉{1:鎴愬姛,0:澶辫触}',
+ `host_id` bigint(20) DEFAULT NULL COMMENT '鎵�灞炴満鏋刐sys_host]',
+ `create_time` datetime DEFAULT NULL COMMENT '娣诲姞鏃堕棿',
+ `memo` varchar(255) DEFAULT NULL COMMENT '澶囨敞',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+/*Data for the table `sys_operation_record` */
+
+/*Table structure for table `sys_role` */
+
+DROP TABLE IF EXISTS `sys_role`;
+
+CREATE TABLE `sys_role` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
+ `name` varchar(255) NOT NULL COMMENT '鍚嶇О',
+ `code` varchar(255) DEFAULT NULL COMMENT '鏍囪瘑',
+ `host_id` bigint(20) DEFAULT NULL COMMENT '鎵�灞炴満鏋刐sys_host]',
+ `status` int(11) DEFAULT '1' COMMENT '鐘舵�亄1:姝ｅ父,0:绂佺敤}',
+ `deleted` int(11) DEFAULT '0' COMMENT '鏄惁鍒犻櫎{1:鏄�,0:鍚',
+ `create_time` datetime DEFAULT NULL COMMENT '娣诲姞鏃堕棿',
+ `update_time` datetime DEFAULT NULL COMMENT '淇敼鏃堕棿',
+ `memo` varchar(255) DEFAULT NULL COMMENT '澶囨敞',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+/*Data for the table `sys_role` */
+
+/*Table structure for table `sys_role_menu` */
+
+DROP TABLE IF EXISTS `sys_role_menu`;
+
+CREATE TABLE `sys_role_menu` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT,
+ `role_id` bigint(20) NOT NULL,
+ `meun_id` bigint(20) NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+/*Data for the table `sys_role_menu` */
+
+/*Table structure for table `sys_user` */
+
+DROP TABLE IF EXISTS `sys_user`;
+
+CREATE TABLE `sys_user` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
+ `username` varchar(255) NOT NULL COMMENT '璐﹀彿',
+ `password` varchar(255) DEFAULT NULL COMMENT '瀵嗙爜',
+ `nickname` varchar(255) DEFAULT NULL COMMENT '鏄电О',
+ `avatar` varchar(255) DEFAULT NULL COMMENT '澶村儚',
+ `code` varchar(255) DEFAULT NULL COMMENT '宸ュ彿',
+ `sex` int(11) DEFAULT '0' COMMENT '鎬у埆{0:鏈煡,1:鐢�,2:濂硙',
+ `phone` varchar(255) DEFAULT NULL COMMENT '鎵嬫満鍙�',
+ `email` varchar(255) DEFAULT NULL COMMENT '閭',
+ `email_verified` int(11) DEFAULT '0' COMMENT '閭楠岃瘉{0:鍚�,1:鏄瘆',
+ `dept_id` bigint(20) DEFAULT NULL COMMENT '鎵�灞為儴闂╗sys_dept]',
+ `real_name` varchar(255) DEFAULT NULL COMMENT '鐪熷疄濮撳悕',
+ `id_card` varchar(255) DEFAULT NULL COMMENT '韬唤璇佸彿',
+ `birthday` varchar(10) DEFAULT NULL COMMENT '鍑虹敓鏃ユ湡',
+ `introduction` varchar(255) DEFAULT NULL COMMENT '涓汉绠�浠�',
+ `host_id` bigint(20) DEFAULT NULL COMMENT '鎵�灞炴満鏋刐sys_host]',
+ `status` int(11) DEFAULT '1' COMMENT '鐘舵�亄1:姝ｅ父,0:绂佺敤}',
+ `deleted` int(11) DEFAULT '0' COMMENT '鏄惁鍒犻櫎{1:鏄�,0:鍚',
+ `create_time` datetime DEFAULT NULL COMMENT '娣诲姞鏃堕棿',
+ `create_by` bigint(20) DEFAULT NULL COMMENT '娣诲姞浜哄憳[sys_user]',
+ `update_time` datetime DEFAULT NULL COMMENT '淇敼鏃堕棿',
+ `update_by` bigint(20) DEFAULT NULL COMMENT '淇敼浜哄憳[sys_user]',
+ `memo` varchar(255) DEFAULT NULL COMMENT '澶囨敞',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+/*Data for the table `sys_user` */
+
+/*Table structure for table `sys_user_login` */
+
+DROP TABLE IF EXISTS `sys_user_login`;
+
+CREATE TABLE `sys_user_login` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
+ `user_id` bigint(20) NOT NULL COMMENT '鐢ㄦ埛[sys_user]',
+ `token` varchar(255) DEFAULT NULL COMMENT '瀵嗛挜',
+ `create_time` datetime DEFAULT NULL COMMENT '娣诲姞鏃堕棿',
+ `system` varchar(255) DEFAULT NULL COMMENT '鐧诲綍绯荤粺',
+ `memo` varchar(255) DEFAULT NULL COMMENT '澶囨敞',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+/*Data for the table `sys_user_login` */
+
+/*Table structure for table `sys_user_role` */
+
+DROP TABLE IF EXISTS `sys_user_role`;
+
+CREATE TABLE `sys_user_role` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT,
+ `user_id` bigint(20) NOT NULL,
+ `role_id` bigint(20) NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+/*Data for the table `sys_user_role` */
+
+/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
+/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
+/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
+/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--
Gitblit v1.9.1