插件开发

蜻蜓是一个安全工具平台，会将工具的结果保存到工具表中，同时会将通用字段抽出来放到一个资源表中；当A工具需要调用B工具时候，需要从资源表中获取数据； 下面是场景的字段表

状态控制

CREATE TABLE `control` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ability_id` int(11) DEFAULT NULL,
  `ability_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `start_time` datetime DEFAULT NULL,
  `end_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `un_name` (`ability_name`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

目标表

CREATE TABLE `target` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `url` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `status` int(11) DEFAULT '1' COMMENT '状态 0 未启用  1 正常 ',
  `user_id` int(11) DEFAULT '0' COMMENT '用户ID',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `code_url` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `keywords` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `ip` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `usce_id` int(11) NOT NULL COMMENT '用户场景ID',
  `scan_status` int(4) NOT NULL DEFAULT '1' COMMENT '1 扫描中 2已完成',
  `progress` int(4) NOT NULL DEFAULT '0' COMMENT '扫描进度',
  `star` int(11) DEFAULT NULL,
  `node_id` int(11) DEFAULT '0',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `un_url` (`user_id`,`usce_id`,`url`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=29970 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

URL表

CREATE TABLE `urls` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tid` int(11) DEFAULT '0',
  `url` varchar(1024) COLLATE utf8mb4_bin DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `method` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `hash` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `un_hash` (`hash`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=54937 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

端口表

CREATE TABLE `ports` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tid` int(11) DEFAULT '0',
  `port` int(11) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `type` varchar(20) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `service_name` varchar(30) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `un_hash` (`tid`,`port`,`type`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8212 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

子域名

CREATE TABLE `target_subdomain` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `status` int(11) DEFAULT '1' COMMENT '状态 0 未启用  1 正常 ',
  `user_id` int(11) DEFAULT '0' COMMENT '用户ID',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `name` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `tid` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `un_url` (`subdomain`,`user_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=31509 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

指纹

CREATE TABLE `target_feature` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `status` int(11) DEFAULT '1' COMMENT '状态 0 未启用  1 正常 ',
  `user_id` int(11) DEFAULT '0' COMMENT '用户ID',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `name` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `version` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `tid` int(11) DEFAULT NULL,
  `ext` varchar(5000) COLLATE utf8mb4_bin DEFAULT NULL,
  `plugin_id` int(11) DEFAULT NULL COMMENT '插件ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=811 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

漏洞表

CREATE TABLE `bugs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tid` int(11) DEFAULT NULL,
  `detail` text COLLATE utf8mb4_bin,
  `check_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '审核状态',
  `hazard_level` tinyint(1) NOT NULL DEFAULT '0' COMMENT '危险等级',
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `tool_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '工具名称',
  `vul_type` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '缺陷类型',
  `url` varchar(512) COLLATE utf8mb4_bin DEFAULT '',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `un_bug` (`tid`,`vul_type`) USING HASH
) ENGINE=InnoDB AUTO_INCREMENT=1656 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

数据管理

CREATE TABLE `down_action` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `table` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `action` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `where` varchar(512) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `data` varchar(1024) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `status` int(11) NOT NULL DEFAULT '0' COMMENT '执行状态 0 未执行 1 已执行',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `remark` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `usce_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2760 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;