|
| 1 | +/* |
| 2 | + Navicat Premium Data Transfer |
| 3 | +
|
| 4 | + Source Server : mysql_docker_mac |
| 5 | + Source Server Type : MySQL |
| 6 | + Source Server Version : 80200 (8.2.0) |
| 7 | + Source Host : localhost:13306 |
| 8 | + Source Schema : JavaSecLab |
| 9 | +
|
| 10 | + Target Server Type : MySQL |
| 11 | + Target Server Version : 80200 (8.2.0) |
| 12 | + File Encoding : 65001 |
| 13 | +
|
| 14 | + Date: 22/06/2024 17:35:45 |
| 15 | +*/ |
| 16 | +CREATE DATABASE IF NOT EXISTS JavaSecLab; |
| 17 | +USE JavaSecLab; |
| 18 | + |
| 19 | +SET NAMES utf8mb4; |
| 20 | +SET FOREIGN_KEY_CHECKS = 0; |
| 21 | + |
| 22 | +-- ---------------------------- |
| 23 | +-- Table structure for log |
| 24 | +-- ---------------------------- |
| 25 | +DROP TABLE IF EXISTS `log`; |
| 26 | +CREATE TABLE `log` ( |
| 27 | + `logId` varchar(255) COLLATE utf8mb4_general_ci NOT NULL COMMENT 'log_id', |
| 28 | + `username` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户名', |
| 29 | + `optionName` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户操作', |
| 30 | + `optionTerminal` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '操作终端', |
| 31 | + `optionIp` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Ip地址', |
| 32 | + `optionTime` date DEFAULT NULL COMMENT '创建时间', |
| 33 | + PRIMARY KEY (`logId`) |
| 34 | +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; |
| 35 | + |
| 36 | +-- ---------------------------- |
| 37 | +-- Records of log |
| 38 | +-- ---------------------------- |
| 39 | +BEGIN; |
| 40 | +COMMIT; |
| 41 | + |
| 42 | +-- ---------------------------- |
| 43 | +-- Table structure for user |
| 44 | +-- ---------------------------- |
| 45 | +DROP TABLE IF EXISTS `user`; |
| 46 | +CREATE TABLE `user` ( |
| 47 | + `username` varchar(255) COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户名', |
| 48 | + `password` varchar(255) COLLATE utf8mb4_general_ci NOT NULL COMMENT '密码', |
| 49 | + PRIMARY KEY (`username`) |
| 50 | +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; |
| 51 | + |
| 52 | +-- ---------------------------- |
| 53 | +-- Records of user |
| 54 | +-- ---------------------------- |
| 55 | +BEGIN; |
| 56 | +INSERT INTO `user` (`username`, `password`) VALUES ('admin', 'admin'); |
| 57 | +COMMIT; |
| 58 | + |
| 59 | +-- ---------------------------- |
| 60 | +-- Table structure for xss |
| 61 | +-- ---------------------------- |
| 62 | +DROP TABLE IF EXISTS `xss`; |
| 63 | +CREATE TABLE `xss` ( |
| 64 | + `id` int NOT NULL AUTO_INCREMENT COMMENT '主键id', |
| 65 | + `content` text COLLATE utf8mb4_general_ci NOT NULL COMMENT '插入内容', |
| 66 | + `date` varchar(255) COLLATE utf8mb4_general_ci NOT NULL COMMENT '插入时间', |
| 67 | + PRIMARY KEY (`id`) |
| 68 | +) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; |
| 69 | + |
| 70 | +-- ---------------------------- |
| 71 | +-- Records of xss |
| 72 | +-- ---------------------------- |
| 73 | +BEGIN; |
| 74 | +INSERT INTO `xss` (`id`, `content`, `date`) VALUES (34, '1', '2024-06-11 14:29:36'); |
| 75 | +COMMIT; |
| 76 | + |
| 77 | +SET FOREIGN_KEY_CHECKS = 1; |
0 commit comments