db_lezijie_note.sql
代码语言：javascript复制/*
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');第二版
代码语言：javascript复制/*
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;
