dbserver部署项目

/* Navicat Premium Data Transfer Source Server : 127.0.0.1 Source Server Type : MySQL Source Server Version : 80019 Source Host : localhost:3366 Source Schema : db_01 Target Server Type : MySQL Target Server Version : 80019 File Encoding : 65001 Date: 22/03/2022 19:32:22 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for admins -- ---------------------------- DROP TABLE IF EXISTS `admins`; CREATE TABLE `admins` ( `id` int(0) NOT NULL AUTO_INCREMENT, `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `createdAt` datetime(0) NOT NULL, `updatedAt` datetime(0) NOT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `id`(`id`) USING BTREE, UNIQUE INDEX `username`(`username`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of admins -- ---------------------------- INSERT INTO `admins` VALUES (1, 'admin', '654321', '2022-03-22 04:56:10', '2022-03-22 04:56:10'); INSERT INTO `admins` VALUES (2, 'admin2', '6543211', '2022-03-22 08:35:46', '2022-03-22 08:35:46'); INSERT INTO `admins` VALUES (3, 'admin3', '6543211', '2022-03-22 09:29:28', '2022-03-22 09:29:28'); -- ---------------------------- -- Table structure for users -- ---------------------------- DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `id` int(0) NOT NULL AUTO_INCREMENT, `realname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `user_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `bank_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `acc_balance` float NOT NULL, `avail_balance` float NOT NULL, `createdAt` datetime(0) NOT NULL, `updatedAt` datetime(0) NOT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `id`(`id`) USING BTREE, UNIQUE INDEX `username`(`username`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of users -- ---------------------------- INSERT INTO `users` VALUES (1, '测试1', 'test111', '987654', '冻结', '银行', 123456, 9000, '2022-03-22 04:39:28', '2022-03-22 08:02:19'); INSERT INTO `users` VALUES (3, '噶噶1', 'test15', '123456', '正常', '银行', 1232.24, 1.513, '2022-03-21 20:39:28', '2022-03-22 10:46:15'); INSERT INTO `users` VALUES (4, '测试10', 'test10', '987654', '冻结', '银行', 123456, 9000, '2022-03-22 09:18:46', '2022-03-22 09:18:46'); INSERT INTO `users` VALUES (5, '测试12', 'test12', '9876541', '冻结1', '银行1', 1234560, 90001, '2022-03-22 09:26:01', '2022-03-22 09:26:01'); INSERT INTO `users` VALUES (6, '测试13', 'test13', '9876541', '冻结1', '银行1', 1234560, 90001, '2022-03-22 09:29:12', '2022-03-22 09:29:12'); SET FOREIGN_KEY_CHECKS = 1;