[大数据]BimServer数据库

/*
 Navicat Premium Data Transfer

 Source Server         : MySQL
 Source Server Type    : MySQL
 Source Server Version : 80026
 Source Host           : localhost:3306
 Source Schema         : bimserver

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

 Date: 12/12/2021 22:23:21
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for model
-- ----------------------------
DROP TABLE IF EXISTS `model`;
CREATE TABLE `model`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `size` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `author` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `create_time` datetime NULL DEFAULT NULL,
  `cover` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of model
-- ----------------------------
INSERT INTO `model` VALUES (1, '模型1', '0.05MB', '小吴', '2021-08-12 16:00:00', 'http://localhost:8080/files/c126727522f649aaa8442a7169f77b65');
INSERT INTO `model` VALUES (2, '模型2', '123.00', '123', '2021-08-01 16:00:00', 'http://localhost:8080/files/796dc552c7b648bfa34a686a9d3901af');
INSERT INTO `model` VALUES (3, '模型3', '0.03MB', 'xxx', '2021-07-31 16:00:00', 'http://localhost:8080/files/d6b0ba34ca2b4977ace3d3ada3720615_2f2f4e1df4ee4116bb2bd2a94f65b149_1615599695987_1615599697706.jpg');
INSERT INTO `model` VALUES (4, '房子', '11.00', '11', '2021-12-20 16:00:00', 'http://localhost:8080/files/f347770d83384b979f88d872747b03cc');
INSERT INTO `model` VALUES (5, '模型3', '33.00', '33', '2021-12-06 16:00:00', 'http://localhost:8080/files/69acabddab3f42ccb1e22e5cc1fa70a4');
INSERT INTO `model` VALUES (6, '模型5', '5.00', '5', '2021-12-29 16:00:00', 'http://localhost:8080/files/d248de286fef4354aa43e4a598224217');
INSERT INTO `model` VALUES (7, '模型6', '6.00', '6', '2021-12-22 16:00:00', 'http://localhost:8080/files/36fbd8e97c354de49f6232e72020d701');
INSERT INTO `model` VALUES (8, '模型18', '11.00', '111', '2021-12-21 16:00:00', 'http://localhost:8080/files/3fd5597f1b174bd69d216bee827400ad');
INSERT INTO `model` VALUES (9, '模型11', '11.00', '1', '2021-12-21 16:00:00', 'http://localhost:8080/files/f2ac0f7f8cda43dc8a423d9e95e76cc4');
INSERT INTO `model` VALUES (10, '555', '0.05MB', '5555', '2022-01-04 16:00:00', 'http://localhost:8080/files/ce9438a1fca146849e7706b2a4882f5b');
INSERT INTO `model` VALUES (11, '模型11', '0.03MB', '11', '2021-12-09 16:00:00', 'http://localhost:8080/files/c26e26700a7e4c379a0f28929dcf4ba0');
INSERT INTO `model` VALUES (12, '模型12', '0.07MB', '2222', '2021-12-27 16:00:00', 'http://localhost:8080/files/d3265ec26f3643edb004d9343fde855f');
INSERT INTO `model` VALUES (13, '22', '0.05MB', '222', '2021-12-14 16:00:00', 'http://localhost:8080/files/481322d8539a450cb4655cd460b62a47');
INSERT INTO `model` VALUES (14, '模型', '0.05MB', '贴图', '2021-12-09 16:00:00', 'http://localhost:8080/files/385389e150454d788323381bf6b8086a');
INSERT INTO `model` VALUES (15, 'tt推特', '0.05MB', '她她她', '2021-12-02 16:00:00', 'http://localhost:8080/files/385389e150454d788323381bf6b8086a');
INSERT INTO `model` VALUES (16, 'Java入门到入土', '1.25MB', 'java之父', '2021-08-12 16:00:00', 'http://localhost:8080/files/385389e150454d788323381bf6b8086a');
INSERT INTO `model` VALUES (17, 'Java入门到入土', '1.25MB', 'java之父', '2021-08-12 16:00:00', 'http://localhost:8080/files/385389e150454d788323381bf6b8086a');
INSERT INTO `model` VALUES (18, 'php', '3.6MB', 'xxx', '2021-07-31 16:00:00', 'http://localhost:8080/files/385389e150454d788323381bf6b8086a');
INSERT INTO `model` VALUES (19, '123', '2.5MB', '123', '2021-08-01 16:00:00', 'http://localhost:8080/files/385389e150454d788323381bf6b8086a');
INSERT INTO `model` VALUES (22, '模型1', '0.05MB', '11', '2021-12-10 16:00:00', 'http://localhost:8080/files/aba3798f375e4881af868795a5c2c2c0_5b2fe619975745049f706212b5afe3ca_1631580813305_1631580816496.jpg');
INSERT INTO `model` VALUES (24, 'sence', '0.01MB', 'test', '2021-12-10 16:00:00', 'http://localhost:8080/files/4adefbea5b6c4017bc58bac51c393db8_scene.gltf');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `phone` bigint NULL DEFAULT NULL,
  `age` int NULL DEFAULT NULL,
  `sex` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `role` int NULL DEFAULT NULL COMMENT '1.管理员，2.普通用户',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, '小白', '123456', 13567876566, 22, '男', '电子科技大学', 1);
INSERT INTO `user` VALUES (2, '小红', '123456', 14565677654, 22, '女', '电子科技大学', 2);

SET FOREIGN_KEY_CHECKS = 1;