SiamProjectManage/database.sql at master · xuanyanwow/SiamProjectManage · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50725
 Source Host           : localhost:3306
 Source Schema         : siamprojectmanage

 Target Server Type    : MySQL
 Target Server Version : 50725
 File Encoding         : 65001

 Date: 25/11/2019 18:16:22
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for siam_abnormals
-- ----------------------------
DROP TABLE IF EXISTS `siam_abnormals`;
CREATE TABLE `siam_abnormals`  (
  `ab_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `project_id` int(11) NOT NULL COMMENT '所属项目id',
  `ab_class` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `ab_date` date NOT NULL COMMENT '日期 用来索引统计数量',
  `ab_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '数据 如get post head cookie等',
  `ab_file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '异常文件',
  `ab_line` int(10) NOT NULL COMMENT '异常所在文件行数',
  `ab_stack` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'call stack',
  `ab_fileresources` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '文件资源 如果有的话',
  `ab_message` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '异常消息',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`ab_id`) USING BTREE,
  INDEX `时间`(`create_time`, `update_time`) USING BTREE,
  INDEX `项目`(`project_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for siam_api_log
-- ----------------------------
DROP TABLE IF EXISTS `siam_api_log`;
CREATE TABLE `siam_api_log`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `project_id` int(11) NOT NULL COMMENT '所属项目id',
  `api_full` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'api路径 = api类目.\"/\".api方法',
  `api_category` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'api类目',
  `api_method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'api方法',
  `api_param` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT 'api参数',
  `api_response` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT 'api响应',
  `is_success` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '成功|失败 1|0',
  `consume_time` int(10) NOT NULL COMMENT '消耗时间 单位ms',
  `user_from` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户来源，可以填入ip、城市名、调用账号等类型',
  `user_identify` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户标识，比如可以用订单号，结合来源，就可以定位请求',
  `create_date` int(10) NOT NULL COMMENT '记录日期  YYYYddmm',
  `create_time` datetime(0) NOT NULL COMMENT '记录时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `用户搜索`(`user_from`, `user_identify`) USING BTREE,
  INDEX `日期`(`create_date`, `create_time`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 75 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for siam_logs
-- ----------------------------
DROP TABLE IF EXISTS `siam_logs`;
CREATE TABLE `siam_logs`  (
  `id` int(11) NOT NULL,
  `project_id` int(11) NOT NULL,
  `log_category` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '日志分类',
  `log_point` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '日志点',
  `log_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '日志标识单号',
  `log_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '日志内容',
  `log_from` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '日志来源',
  `create_at` datetime(0) NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `sn`(`project_id`, `log_sn`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '日志表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for siam_projects
-- ----------------------------
DROP TABLE IF EXISTS `siam_projects`;
CREATE TABLE `siam_projects`  (
  `project_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `project_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `create_time` datetime(0) NULL DEFAULT NULL,
  `update_time` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`project_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;