You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
89 lines
164 KiB
89 lines
164 KiB
3 years ago
|
/*
|
||
|
|
SQLyog v10.2
|
||
|
|
MySQL - 8.0.22 : Database - demo
|
||
|
|
*********************************************************************
|
||
|
|
*/
|
||
|
|
|
||
|
|
|
||
|
|
/*!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*/`demo` /*!40100 DEFAULT CHARACTER SET utf8 */ /*!80016 DEFAULT ENCRYPTION='N' */;
|
||
|
|
|
||
|
|
USE `demo`;
|
||
|
|
|
||
|
|
/*Table structure for table `sys_user` */
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `sys_user`;
|
||
|
|
|
||
|
|
CREATE TABLE `sys_user` (
|
||
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
||
|
|
`sid` varchar(64) NOT NULL COMMENT 'sid',
|
||
|
|
`lockVersion` int NOT NULL DEFAULT '0' COMMENT '记录版本，锁',
|
||
|
|
`createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录创建时间',
|
||
|
|
`modifyTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录最后修改时间',
|
||
|
|
`isEnable` int NOT NULL DEFAULT '1' COMMENT '记录是否可用，1:可用，0:不可用',
|
||
|
|
`state` int DEFAULT '1' COMMENT '隐藏本部门:隐藏本部门开启后，本部门将不会显示在公司通讯录中',
|
||
|
|
`isDelete` int DEFAULT NULL COMMENT '记录是否被删除，0:未删除，1:已经删除',
|
||
|
|
`remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
|
||
|
|
`createBySid` varchar(64) DEFAULT NULL COMMENT '创建者',
|
||
|
|
`updateBySid` varchar(64) DEFAULT NULL COMMENT '更新者',
|
||
|
|
`userName` varchar(64) DEFAULT NULL COMMENT '登录名，登录名不能相同',
|
||
|
|
`password` varchar(50) DEFAULT NULL COMMENT '密码（加密或签名后）',
|
||
|
|
`pwdDayslimit` varchar(11) DEFAULT NULL COMMENT '密码修改时限',
|
||
|
|
`pwdModifyTime` datetime DEFAULT NULL COMMENT '最后一次密码修改时间',
|
||
|
|
`onlineState` int DEFAULT NULL COMMENT '在线状态（0为离线、1为在线）',
|
||
|
|
`token` varchar(255) DEFAULT NULL COMMENT '用户登录时随机生成身份验证字符串',
|
||
|
|
`isAdmin` varchar(1) DEFAULT NULL COMMENT '是否是管理员：1管理员，2一般用户，0是超级管理员,3尚无单位人员',
|
||
|
|
`appId` varchar(100) DEFAULT NULL COMMENT '手机登录唯一标识，手机与用户绑定字段',
|
||
|
|
`staffSid` varchar(36) DEFAULT NULL COMMENT '关联的人员sid',
|
||
|
|
`mobile` varchar(11) DEFAULT NULL COMMENT '手机号',
|
||
|
|
`userType` int DEFAULT NULL COMMENT '用户类型:1员工、2客户、3供应商',
|
||
|
|
`headImage` varchar(255) DEFAULT NULL COMMENT '用户头像',
|
||
|
|
PRIMARY KEY (`id`),
|
||
|
|
KEY `staffsid_index` (`staffSid`)
|
||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8 COMMENT='用户表';
|
||
|
|
|
||
|
|
/*Data for the table `sys_user` */
|
||
|
|
|
||
|
|
insert into `sys_user`(`id`,`sid`,`lockVersion`,`createTime`,`modifyTime`,`isEnable`,`state`,`isDelete`,`remarks`,`createBySid`,`updateBySid`,`userName`,`password`,`pwdDayslimit`,`pwdModifyTime`,`onlineState`,`token`,`isAdmin`,`appId`,`staffSid`,`mobile`,`userType`,`headImage`) values (19,'0d8d8119-d476-47ce-89c2-075cd809dda6',43,'2021-09-07 09:44:10','2021-10-08 13:48:29',1,1,0,NULL,NULL,NULL,'15097329653','435d6b71ca083adda32844da3a452bd9',NULL,NULL,NULL,NULL,'1',NULL,'0251fb5d-b110-4a5c-94b8-9accc24779ec','15097329653',2,'http://120.46.131.15:8111/upload/appImage/headImage.jpg'),(23,'427a2fb0-60c5-409f-bea4-4eb441041ae6',1,'2021-09-11 09:16:27','2021-09-13 09:49:50',1,1,0,NULL,NULL,NULL,'13028639395','c4fd31684f3c9bec8202553f2d4c433d',NULL,NULL,NULL,'AppeyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c2VyTm8iOiIyMyIsImlzcyI6IldCSyIsImV4cCI6MTYzMjcyMjE1OH0.y26IzegfIxPziATEUGqnxtJ89isECXkeWZXZ0jSDdXQ','1',NULL,'e73f6e2c-1bda-4a4d-8390-ac7a2bf25854','13028639395',1,NULL),(24,'271caa91-15cf-11ec-867b-fa163e0cb33c',3,'2021-09-15 10:47:16','2021-10-08 13:48:52',1,1,0,NULL,NULL,NULL,'15027758181','a5c9311ca0ca04dd80ad5b790dc43ac6',NULL,NULL,NULL,'AppeyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c2VyTm8iOiIyNCIsImlzcyI6IldCSyIsImV4cCI6MTYzMjg3ODUwMH0.LQp0S3_Bq-zqUhb0V-sLJTY-2ewP71gBPQym3GGmwGA','1','866370035001056','84ad9481-15cf-11ec-867b-fa163e0cb33c','15027758181',1,'http://120.46.131.15:8111/upload/20210925/1632580467510007417639925698805.jpeg'),(25,'54d80b14-1847-11ec-9205-6479f0dd0373',1,'2021-09-18 14:12:58','2021-09-18 14:13:00',1,1,0,NULL,NULL,NULL,'11111111111','8ee032c2f0b2db72c45ac82007c8dac3',NULL,NULL,NULL,'AppeyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c2VyTm8iOiIyNSIsImlzcyI6IldCSyIsImV4cCI6MTYzNTA0NzI5NH0.GAS_wMLV1Ie5Bkv1H3WprREaLMd8-sGHQywy3c_4KJg','1','CD91A73825FE473F795D2682D2B3CED34E75B51F','986c55c6-1847-11ec-9205-6479f0dd0373','11111111111',1,'http://120.46.131.15:8111/upload/20211016/163436154792209708264777054085.jpg'),(26,'4d074bf5-1c11-11ec-867b-fa163e0cb33c',4,'2021-09-23 09:56:01','2021-10-08 11:49:18',1,1,0,NULL,NULL,NULL,'13521535236','06c0b20d3c277ef9e0efc01c4b882496',NULL,NULL,NULL,'AppeyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c2VyTm8iOiIyNiIsImlzcyI6IldCSyIsImV4cCI6MTYzNDM3NzMxM30.GcUFL4ghYuOdza56MbBqXKmKF1Yuv0_UaZHeoyKhxFc','1','B42E81D5CB700F38BF18BFA559A76B12B82DBF11','697cc954-1c11-11ec-867b-fa163e0cb33c','13521535236',1,'http://120.46.131.15:8111/upload/20210925/1632550340701047756407535704326.jpg'),(29,'884714de-1e8e-11ec-867b-fa163e0cb33c',1,'2021-09-26 13:57:33','2021-09-26 13:57:35',1,1,0,NULL,NULL,NULL,'17778266271','06c0b20d3c277ef9e0efc01c4b882496',NULL,NULL,NULL,'AppeyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c2VyTm8iOiIyOSIsImlzcyI6IldCSyIsImV4cCI6MTYzNTA2MTM3OH0.KPpNPLlfO65WDYiuwDMdVw4FZUUsAxBDnrL7bH97iIc','1','A4B5F71CEA1D1E139B8F310CB792DC8A37E99139','9d60cfa5-1e8f-11ec-867b-fa163e0cb33c','17778266271',1,'http://120.46.131.15:8111/upload/20211016/16343699056380434548451588893.png'),(30,'2af18381-c043-4af5-82b1-22a77982fa84',7,'2021-09-28 13:41:24','2021-10-08 14:08:35',1,1,0,NULL,NULL,NULL,'15832538126','4d6017ba7a372b0725344ee5837f04ad',NULL,NULL,NULL,NULL,'1',NULL,'c71a2cb6-21fe-48a6-879a-38f2a994787b','15832538126',2,'http://120.46.131.15:8111/upload/appImage/headImage.jpg'),(38,'9ff6a706-8028-4ee2-bb54-e4106aa38821',0,'2021-10-19 08:50:52','2021-10-19 08:50:52',1,1,0,NULL,NULL,NULL,'13623307393','8ee032c2f0b2db72c45ac82007c8dac3',NULL,NULL,NULL,NULL,NULL,NULL,'c18e8645-314d-4810-83f0-1beda7c7a259','13623307393',2,'http://120.46.131.15:8111/upload/appImage/headImage.jpg'),(39,'5818cd7a-070e-4e65-9426-be5b5488b9cd',0,'2021-10-19 09:39:58','2021-10-19 09:39:58',1,1,0,NULL,NULL,NULL,'13733217919','d0871a120f629163bc09101acffaa8d9',NULL,NULL,NULL,NULL,NULL,NULL,'74fe4e97-23d6-47d5-bce4-87d8bae23fee','13733217919',2,'http://120.46.131.15:8111/upload/appImage/headImage.jpg'),(40,'16969f23-231c-4037-be41-4445c81d3ba4',0,'2021-10-25 08:41:23','2021-10-25 08:41:23',1,1,0,NULL,NULL,NULL,'15831219661','3e8a8c2c724ea73265563e3da38c8e6f',NULL,NULL,NULL,NULL,'1',NULL,'1a2d5fe1-b948-422c-bbac-34630e8b7
|
||
|
|
|
||
|
|
/*Table structure for table `system_log` */
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `system_log`;
|
||
|
|
|
||
|
|
CREATE TABLE `system_log` (
|
||
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
||
|
|
`sid` varchar(64) NOT NULL,
|
||
|
|
`lockVersion` int DEFAULT NULL,
|
||
|
|
`createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
||
|
|
`modifyTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
||
|
|
`isEnable` int DEFAULT '1',
|
||
|
|
`state` int DEFAULT '1',
|
||
|
|
`isDelete` int DEFAULT '0',
|
||
|
|
`remarks` varchar(255) DEFAULT NULL,
|
||
|
|
`createBySid` varchar(64) DEFAULT NULL,
|
||
|
|
`updateBySid` varchar(64) DEFAULT NULL,
|
||
|
|
`eventName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '事件名称或类别',
|
||
|
|
`eventContent` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '事件内容',
|
||
|
|
`eventUrl` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '事件url',
|
||
|
|
`userSid` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户sid',
|
||
|
|
`userName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户名',
|
||
|
|
`userIp` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户iP',
|
||
|
|
PRIMARY KEY (`id`)
|
||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=810 DEFAULT CHARSET=utf8 COMMENT='系统日志表';
|
||
|
|
|
||
|
|
/*Data for the table `system_log` */
|
||
|
|
|
||
|
|
insert into `system_log`(`id`,`sid`,`lockVersion`,`createTime`,`modifyTime`,`isEnable`,`state`,`isDelete`,`remarks`,`createBySid`,`updateBySid`,`eventName`,`eventContent`,`eventUrl`,`userSid`,`userName`,`userIp`) values (1,'808c914b-d079-430f-ac19-4480e2f2e003',0,'2021-08-26 17:24:57','2021-08-26 17:24:58',1,1,0,NULL,NULL,NULL,'用户模块-用户列表',NULL,NULL,'15097329653',NULL,'0.0.0.0'),(2,'bc778929-3a59-44e7-b259-e3bf7053ba1a',0,'2021-08-26 21:40:43','2021-08-26 21:40:44',1,1,0,NULL,NULL,NULL,'系统管理-日志列表',NULL,NULL,'15097329653',NULL,'0.0.0.0'),(3,'fe2aab71-52e3-4527-bc58-753e829c3792',0,'2021-08-26 21:40:46','2021-08-26 21:40:47',1,1,0,NULL,NULL,NULL,'系统管理-日志列表',NULL,NULL,'15097329653',NULL,'0.0.0.0'),(4,'3ae79a44-4a03-496b-a5cb-b0cd81b54bb3',0,'2021-08-26 21:40:53','2021-08-26 21:40:53',1,1,0,NULL,NULL,NULL,'系统管理-日志列表',NULL,NULL,'15097329653',NULL,'0.0.0.0'),(5,'1b8ef73e-562c-4aa5-82b2-1626bafd1eb7',0,'2021-08-27 14:13:06','2021-08-27 14:13:06',1,1,0,NULL,NULL,NULL,'0.0.0.0',NULL,NULL,NULL,'123456','0.0.0.0'),(6,'44195544-b006-440b-aa8f-a2b067b08911',0,'2021-08-27 15:19:03','2021-08-27 15:19:03',1,1,0,NULL,NULL,NULL,'0.0.0.0',NULL,NULL,NULL,'123456','0.0.0.0'),(7,'cbda9a2e-82b8-43aa-be0a-adbaa7345300',0,'2021-08-30 15:15:34','2021-08-30 15:15:34',1,1,0,NULL,NULL,NULL,'人员岗位保存','','/portal/v1/sysstaffpost/save','0b4d1362-b3a1-4487-9046-a5ed56bd8f59','15097329653','0.0.0.0'),(8,'47c10577-8a98-4ce6-9e2a-99055d2f26cc',0,'2021-08-30 15:17:12','2021-08-30 15:17:12',1,1,0,NULL,NULL,NULL,'人员岗位保存','','/portal/v1/sysstaffpost/save','0b4d1362-b3a1-4487-9046-a5ed56bd8f59','15097329653','0.0.0.0'),(9,'ea00ee6a-0359-4b0d-9301-2f4c4ab53253',0,'2021-08-30 15:17:38','2021-08-30 15:17:38',1,1,0,NULL,NULL,NULL,'人员岗位保存','','/portal/v1/sysstaffpost/save','0b4d1362-b3a1-4487-9046-a5ed56bd8f59','15097329653','0.0.0.0'),(10,'89c60d12-f951-4609-8d08-04ac1b30bcc2',0,'2021-08-30 15:22:08','2021-08-30 15:22:08',1,1,0,NULL,NULL,NULL,'人员岗位保存','','/portal/v1/sysstaffpost/save','0b4d1362-b3a1-4487-9046-a5ed56bd8f59','15097329653','0.0.0.0'),(11,'389177b1-61b1-4f9e-b721-d5f77505723d',0,'2021-08-30 15:32:53','2021-08-30 15:32:53',1,1,0,NULL,NULL,NULL,'人员岗位保存','','/portal/v1/sysstaffpost/save','0b4d1362-b3a1-4487-9046-a5ed56bd8f59','15097329653','0.0.0.0'),(12,'c4f3ce1e-99f8-4322-b259-5333ddc3c3ed',0,'2021-08-30 15:34:44','2021-08-30 15:34:44',1,1,0,NULL,NULL,NULL,'人员岗位保存','','/portal/v1/sysstaffpost/save','0b4d1362-b3a1-4487-9046-a5ed56bd8f59','15097329653','0.0.0.0'),(13,'7c243aea-2cb0-40f8-ab3b-2bcaa80a6c65',0,'2021-08-30 15:35:24','2021-08-30 15:35:24',1,1,0,NULL,NULL,NULL,'人员岗位保存','','/portal/v1/sysstaffpost/save','0b4d1362-b3a1-4487-9046-a5ed56bd8f59','15097329653','0.0.0.0'),(14,'dde547c1-36e1-48cc-bf74-3304b88a9b68',0,'2021-08-30 15:36:10','2021-08-30 15:36:10',1,1,0,NULL,NULL,NULL,'人员岗位保存','','/portal/v1/sysstaffpost/save','0b4d1362-b3a1-4487-9046-a5ed56bd8f59','15097329653','0.0.0.0'),(15,'866690b9-6510-4b3d-ba5a-c305537be429',0,'2021-08-30 15:39:34','2021-08-30 15:39:34',1,1,0,NULL,NULL,NULL,'人员岗位保存','','/portal/v1/sysstaffpost/save','0b4d1362-b3a1-4487-9046-a5ed56bd8f59','15097329653','0.0.0.0'),(16,'a33e3a26-9b13-4ad0-abf5-76a444209e9b',0,'2021-08-30 15:52:39','2021-08-30 15:52:39',1,1,0,NULL,NULL,NULL,'人员岗位保存','','/portal/v1/sysstaffpost/save','0b4d1362-b3a1-4487-9046-a5ed56bd8f59','15097329653','0.0.0.0'),(17,'5e828615-5e6b-429e-8d4f-d9295680071c',0,'2021-08-30 16:04:05','2021-08-30 16:04:05',1,1,0,NULL,NULL,NULL,'人员岗位保存','','/portal/v1/sysstaffpost/save','0b4d1362-b3a1-4487-9046-a5ed56bd8f59','15097329653','0.0.0.0'),(18,'12a8f464-8805-4c19-bdb4-d99277d7dc13',0,'2021-08-30 16:04:09','2021-08-30 16:04:09',1,1,0,NULL,NULL,NULL,'人员岗位保存','','/portal/v1/sysstaffpost/save','0b4d1362-b3a1-4487-9046-a5ed56bd8f59','15097329653','0.0.0.0'),(19,'317260a0-ec2f-45d5-88e3-90c7d0681174',0,'2021-08-30 16:06:02','2021-08-30 16:06:02',1,1,0,NULL,NULL,NULL,'��
|
||
|
|
|
||
|
|
/*!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 */;
|