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