java web sql_javaweb.sql

/*

Navicat Premium Data Transfer

Source Server : 127.0.0.1

Source Server Type : MySQL

Source Server Version : 100140

Source Host : localhost:3306

Source Schema : test

Target Server Type : MySQL

Target Server Version : 100140

File Encoding : 65001

Date: 08/12/2019 21:19:17

*/

SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------

-- Table structure for authorities

-- ----------------------------

DROP TABLE IF EXISTS `authorities`;

CREATE TABLE `authorities` (

`username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,

`authority` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,

UNIQUE INDEX `ix_auth_username`(`username`, `authority`) USING BTREE,

CONSTRAINT `fk_authorities_users` FOREIGN KEY (`username`) REFERENCES `users` (`username`) ON DELETE RESTRICT ON UPDATE RESTRICT

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------

-- Records of authorities

-- ----------------------------

INSERT INTO `authorities` VALUES ('admin', 'ROLE_ADMIN');

INSERT INTO `authorities` VALUES ('admin', 'ROLE_USER');

INSERT INTO `authorities` VALUES ('user', 'ROLE_USER');

-- ----------------------------

-- Table structure for persistent_logins

-- ----------------------------

DROP TABLE IF EXISTS `persistent_logins`;

CREATE TABLE `persistent_logins` (

`username` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,

`series` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,

`token` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,

`last_used` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0),

PRIMARY KEY (`series`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------

-- Records of persistent_logins

-- ----------------------------

INSERT INTO `persistent_logins` VALUES ('admin', 'C0nd3jXhjBhUPcPJIpmw+w==', '65cw7S8dpc1kaCXoqYif3w==', '2019-12-08 11:45:13');

-- ----------------------------

-- Table structure for users

-- ----------------------------

DROP TABLE IF EXISTS `users`;

CREATE TABLE `users` (

`username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,

`password` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,

`enabled` tinyint(1) NOT NULL,

PRIMARY KEY (`username`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------

-- Records of users

-- ----------------------------

INSERT INTO `users` VALUES ('admin', '$2a$10$IomwcIliRa8fP6J0e45gPuFXeGqIwIhAAf/WbXWR4Icv5Tfqb0iwS', 1);

INSERT INTO `users` VALUES ('user', '$2a$10$N6malX2YiEJw.XInHPTq1ejsbyAUCLEBH8q9TvHo0P2sARlvnQPsO', 1);

SET FOREIGN_KEY_CHECKS = 1;

一键复制

编辑

Web IDE

原始数据

按行查看

历史