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:姝ｅ父,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