From a4b5f0dba4038e319f65f5ba4376d6fc50b0a424 Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@163.com>
Date: 星期三, 28 二月 2024 16:06:08 +0800
Subject: [PATCH] #

---
 /dev/null |  219 ------------------------------------------------------
 1 files changed, 0 insertions(+), 219 deletions(-)

diff --git a/zy-asrs-wcs/version/asrs.sql b/zy-asrs-wcs/version/asrs.sql
deleted file mode 100644
index b360164..0000000
--- a/zy-asrs-wcs/version/asrs.sql
+++ /dev/null
@@ -1,219 +0,0 @@
-/*
-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:姝e父,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:姝e父,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:姝e父,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:姝e父,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:姝e父,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