JAVA学习,数据库建库文件

最新推荐文章于 2022-07-28 18:48:22 发布

lst0426

最新推荐文章于 2022-07-28 18:48:22 发布

阅读量411

点赞数

分类专栏： java

本文链接：https://blog.csdn.net/vv1025/article/details/118500583

版权

java 专栏收录该内容

28 篇文章 0 订阅

订阅专栏

db_lezijie_note.sql

/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50505
Source Host           : localhost:3306
Source Database       : db_lezijie_note

Target Server Type    : MYSQL
Target Server Version : 50505
File Encoding         : 65001

Date: 2021-07-06 21:44:19
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `tb_note`
-- ----------------------------
DROP TABLE IF EXISTS `tb_note`;
CREATE TABLE `tb_note` (
  `noteId` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键，自增',
  `title` varchar(50) NOT NULL COMMENT '标题',
  `content` text NOT NULL COMMENT '内容',
  `typeId` int(11) NOT NULL COMMENT '类型ID',
  `pubTime` datetime NOT NULL COMMENT '发布时间',
  `lon` float NOT NULL DEFAULT '0' COMMENT '经度',
  `lat` float NOT NULL DEFAULT '0' COMMENT '纬度',
  PRIMARY KEY (`noteId`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_note
-- ----------------------------
INSERT INTO `tb_note` VALUES ('1', '2021年7月6日三亚五日游', '<p><img src=\"/note/statics/ueditor/jsp/upload/image/20210706/1625578687092039020.png\" title=\"1625578687092039020.png\" alt=\"神.png\"/></p><p>天气很好啊!!!</p>', '1', '2021-07-06 13:11:12', '123.433', '41.8086');
INSERT INTO `tb_note` VALUES ('2', '学习内容', '<p>今天又学习了不少东西</p>', '2', '2021-07-06 13:11:45', '123.433', '41.8086');
INSERT INTO `tb_note` VALUES ('3', '打算出去', '<p>去城里玩玩</p>', '3', '2021-07-06 13:12:17', '123.433', '41.8086');
INSERT INTO `tb_note` VALUES ('4', '第一天', '<p>今天做面食</p>', '4', '2021-07-06 13:12:50', '123.433', '41.8086');
INSERT INTO `tb_note` VALUES ('5', '景色', '<p>这里真好!!</p>', '1', '2021-07-06 21:41:40', '123.433', '41.8086');

-- ----------------------------
-- Table structure for `tb_note_type`
-- ----------------------------
DROP TABLE IF EXISTS `tb_note_type`;
CREATE TABLE `tb_note_type` (
  `typeId` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键，自增',
  `typeName` varchar(50) NOT NULL COMMENT '类型名称',
  `userId` int(11) NOT NULL DEFAULT '0' COMMENT '用户ID',
  PRIMARY KEY (`typeId`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_note_type
-- ----------------------------
INSERT INTO `tb_note_type` VALUES ('1', '旅游', '1');
INSERT INTO `tb_note_type` VALUES ('2', '私人', '1');
INSERT INTO `tb_note_type` VALUES ('3', '日常', '1');
INSERT INTO `tb_note_type` VALUES ('4', '美食', '1');

-- ----------------------------
-- Table structure for `tb_user`
-- ----------------------------
DROP TABLE IF EXISTS `tb_user`;
CREATE TABLE `tb_user` (
  `userId` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键，自增',
  `uname` varchar(50) NOT NULL COMMENT '用户名称',
  `upwd` varchar(50) NOT NULL COMMENT '用户密码',
  `nick` varchar(50) DEFAULT NULL COMMENT '用户昵称',
  `head` varchar(100) DEFAULT NULL COMMENT '用户头像',
  `mood` varchar(500) DEFAULT NULL COMMENT '用户心情',
  PRIMARY KEY (`userId`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_user
-- ----------------------------
INSERT INTO `tb_user` VALUES ('1', 'admin', 'e10adc3949ba59abbe56e057f20f883e', 'admin22', '404.jpg', 'Hello');

第二版

/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 80020
 Source Host           : localhost:3306
 Source Schema         : db_lezijie_note

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

 Date: 25/12/2020 13:54:05
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for tb_note
-- ----------------------------
DROP TABLE IF EXISTS `tb_note`;
CREATE TABLE `tb_note` (
  `noteId` int NOT NULL AUTO_INCREMENT COMMENT '主键，自增',
  `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '标题',
  `content` text COMMENT '内容',
  `typeId` int DEFAULT NULL COMMENT '外键，从属tb_note_type',
  `pubTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '发布时间',
  `lon` float DEFAULT NULL COMMENT '经度',
  `lat` float DEFAULT NULL COMMENT '纬度',
  PRIMARY KEY (`noteId`),
  KEY `fk_note_ref_type` (`typeId`),
  CONSTRAINT `fk_note_ref_type` FOREIGN KEY (`typeId`) REFERENCES `tb_note_type` (`typeId`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_note
-- ----------------------------
BEGIN;
INSERT INTO `tb_note` VALUES (1, '上海一日游', '<p><strong>这是测试内容</strong></p>', 2, '2020-08-23 05:10:35', 121.395, 31.2536);
INSERT INTO `tb_note` VALUES (2, '第一次测试', '<p>测试</p>', 4, '2020-08-23 05:05:54', 121.395, 31.2536);
INSERT INTO `tb_note` VALUES (3, '今日工作安排', '<p>测试</p>', 1, '2020-09-23 05:05:51', 121.518, 31.0632);
INSERT INTO `tb_note` VALUES (4, '第二次测试', '<p>测试</p>', 1, '2020-09-23 05:05:50', 121.364, 31.0662);
INSERT INTO `tb_note` VALUES (5, '第三次测试', '<p>测试</p>', 1, '2020-09-23 05:05:47', 120.075, 30.2741);
INSERT INTO `tb_note` VALUES (6, '第四次测试', '<p>测试</p>', 1, '2020-10-23 05:02:21', 120.105, 30.1777);
INSERT INTO `tb_note` VALUES (7, '出行计划', '<p>出行计划</p>', 2, '2020-11-23 05:02:24', 119.989, 30.1587);
INSERT INTO `tb_note` VALUES (8, '测试001', '<p>测试001</p>', 4, '2020-11-23 05:02:26', 120.629, 28.0021);
INSERT INTO `tb_note` VALUES (9, '测试002', '<p>测试002</p>', 4, '2020-12-23 05:02:28', 120.753, 27.8908);
INSERT INTO `tb_note` VALUES (11, '重复', '<p>重复</p>', 3, '2020-12-25 02:22:49', 120.681, 28.0628);
INSERT INTO `tb_note` VALUES (12, '测试地址', '<p>测试</p>', 1, '2020-12-25 03:42:18', 121.488, 31.2492);
INSERT INTO `tb_note` VALUES (13, '测试003', '<p>测试003</p>', 1, '2020-12-25 03:45:32', 116.413, 39.9109);
INSERT INTO `tb_note` VALUES (14, '测试004', '<p>测试004</p>', 1, '2020-12-25 03:52:25', 121.488, 31.2492);
iNSERT INTO `tb_note` VALUES (15, '2021年7月6日三亚五日游', '<p><img src=\"/note/statics/ueditor/jsp/upload/image/20210706/1625578687092039020.png\" title=\"1625578687092039020.png\" alt=\"神.png\"/></p><p>天气很好啊!!!</p>', '1', '2021-07-06 13:11:12', '123.433', '41.8086');
INSERT INTO `tb_note` VALUES (16, '学习内容', '<p>今天又学习了不少东西</p>', '2', '2021-07-06 13:11:45', '123.433', '41.8086');
INSERT INTO `tb_note` VALUES (17, '打算出去', '<p>去城里玩玩</p>', '3', '2021-07-06 13:12:17', '123.433', '41.8086');
INSERT INTO `tb_note` VALUES (18, '第一天', '<p>今天做面食</p>', '4', '2021-07-06 13:12:50', '123.433', '41.8086');
INSERT INTO `tb_note` VALUES (19, '景色', '<p>这里真好!!</p>', '1', '2021-07-06 21:41:40', '123.433', '41.8086');
COMMIT;

-- ----------------------------
-- Table structure for tb_note_type
-- ----------------------------
DROP TABLE IF EXISTS `tb_note_type`;
CREATE TABLE `tb_note_type` (
  `typeId` int NOT NULL AUTO_INCREMENT COMMENT '主键，自动增长',
  `typeName` varchar(50) NOT NULL COMMENT '类别名，在同一个用户下唯一',
  `userId` int DEFAULT NULL COMMENT '从属用户',
  PRIMARY KEY (`typeId`),
  KEY `fk_type_ref_user` (`userId`),
  CONSTRAINT `fk_type_ref_user` FOREIGN KEY (`userId`) REFERENCES `tb_user` (`userId`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_note_type
-- ----------------------------
BEGIN;
INSERT INTO `tb_note_type` VALUES (1, '私人', 1);
INSERT INTO `tb_note_type` VALUES (2, '旅游', 1);
INSERT INTO `tb_note_type` VALUES (3, '美食', 1);
INSERT INTO `tb_note_type` VALUES (4, '测试', 1);
INSERT INTO `tb_note_type` VALUES (5, '旅游', 1);
INSERT INTO `tb_note_type` VALUES (6, '私人', 1);
INSERT INTO `tb_note_type` VALUES (7, '日常', 1);
INSERT INTO `tb_note_type` VALUES (8, '美食', 1);
COMMIT;

-- ----------------------------
-- Table structure for tb_user
-- ----------------------------
DROP TABLE IF EXISTS `tb_user`;
CREATE TABLE `tb_user` (
  `userId` int NOT NULL AUTO_INCREMENT COMMENT '主键，自动增长',
  `uname` varchar(50) NOT NULL COMMENT '用户名',
  `upwd` varchar(50) DEFAULT NULL COMMENT '密码',
  `nick` varchar(50) DEFAULT NULL COMMENT '昵称',
  `head` varchar(100) DEFAULT NULL COMMENT '头像',
  `mood` varchar(500) DEFAULT NULL COMMENT '心情',
  PRIMARY KEY (`userId`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_user
-- ----------------------------
BEGIN;
INSERT INTO `tb_user` VALUES (1, 'admin', 'e10adc3949ba59abbe56e057f20f883e', 'lisi', '404.jpg', 'Hello World');
INSERT INTO `tb_user` VALUES (2, 'zhangsan', 'e10adc3949ba59abbe56e057f20f883e', 'zhangsan', 'jay.jpg', 'Hello');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;

lst0426

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
打赏
0
评论
JAVA学习,数据库建库文件

db_lezijie_note.sql/*Navicat MySQL Data TransferSource Server : localhost_3306Source Server Version : 50505Source Host : localhost:3306Source Database : db_lezijie_noteTarget Server Type : MYSQLTarget Server Version :
复制链接

扫一扫