DROP TABLE IF EXISTS travel_route
;
CREATE TABLE travel_route
(
id
varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
route_name
varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
route_describe
varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
route_status
int(2) NOT NULL DEFAULT 0,
route_address
varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
collect_number
int(32) NOT NULL DEFAULT 0,
create_date
datetime NULL DEFAULT NULL,
update_date
datetime NULL DEFAULT NULL,
PRIMARY KEY (id
) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
– Records of travel_route
INSERT INTO travel_route
VALUES (‘10’, ‘台湾高雄旅游路线’, ‘D1捷运美丽岛站光之穹顶(0.5小时) → 驳二艺术特区(2小时) → 打狗鉄道故事馆(1小时) → 西子湾风景区(1小时) → 打狗英国领事馆(1小时) → 真爱码头(0.5小时) → 高雄爱河(0.5小时) → 高雄六合夜市(2小时)’, 0, ‘台湾高雄旅’, 0, ‘2020-03-19 09:37:40’, NULL);
INSERT INTO travel_route
VALUES (‘11’, ‘澳门旅游路线’, ‘D1大三巴牌坊(1小时以下) → 恋爱巷(1小时以下) → 疯堂斜巷(1小时以下) → 澳门渔人码头(3小时以上)’, 0, ‘澳门’, 0, ‘2020-03-19 09:37:47’, NULL);
INSERT INTO travel_route
VALUES (‘15’, ‘河北北戴河旅游路线:’, ‘\r\nD1老虎石海上公园(4小时) → 碧螺塔酒吧公园(3小时)\r\n\r\nD2鸽子窝公园(2小时) → 奥林匹克大道公园(1小时) → 秦皇岛北戴河怪楼奇园景区(1小时) → 北戴河海滨浴场(2小时)’, 0, ‘河北北戴河’, 0, ‘2020-03-19 09:38:05’, NULL);
– Table structure for travel_strategy
DROP TABLE IF EXISTS travel_strategy
;
CREATE TABLE travel_strategy
(
id
varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ‘旅游攻略strategy’,
user_id
varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
strategy_describe
varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
strategy_status
int(255) NULL DEFAULT NULL COMMENT ‘0是审核通过,1是未审核,2是审核未通过’,
create_date
datetime NULL DEFAULT NULL,
title
varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
error_message
varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (id
) USING BTREE,
INDEX user_id
(user_id
) USING BTREE,
CONSTRAINT travel_strategy_ibfk_1
FOREIGN KEY (user_id
) REFERENCES user
(id
) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
– Records of travel_strategy
INSERT INTO travel_strategy
VALUES (‘bd2cbc4285774cc3898e1130032f5b16’, ‘0bc85e2aa9ac44fbb6cb415271bb5014’, ‘1、南普陀请香与别处不同:小木屋可免费请一支清香(不可多取),功德随意投入,一元二元不拘,不投也无妨; 2、烧香的地方在天王殿外,香烛不可带进寺院里面;如随身带有香烛的,可以寄放在天王殿门口的义工处,出来时取; 旅行攻略8: 鼓浪屿攻略 至于游玩鼓浪屿的线路,建议走经典线路:龙头路+八卦楼+菽庄花园’, 0, ‘2019-06-22 03:17:54’, ‘test’, NULL);
INSERT INTO travel_strategy
VALUES (‘d9b05e29c91942f9859a9621286421a0’, ‘123123123’, ‘东方明珠塔的陈列馆还是非常值得一逛哦,特别是对于上海宁,这里是上海城市历史发展陈列馆 里面很多的历史场景,也许还都是你爷爷奶奶外公外婆辈的呢呢,所以也很值得带长辈来玩 就是可能会走比较累。 登塔时间: 如果想看白天的上海那就下午去,最好1点-3点。如果要看太阳西落及夜景,那就5点再去(必然会排队)去之前我查过很多攻略,都说登塔排队拍了好几个小时,我下午3点去的(本来定的2点,但买喜茶耽误到3点了)排队15分钟。’, 2, ‘2019-06-22 02:17:18’, ‘上海东方明珠攻略’, ‘攻略写的不够详细’);
– Table structure for user
DROP TABLE IF EXISTS user
;
CREATE TABLE user
(
id
varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
username
varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
password
varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
name
varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (id
) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
– Records of user
INSERT INTO user
VALUES (‘0bc85e2aa9ac44fbb6cb415271bb5014’, ‘qwe’, ‘1234’, ‘老杜’);
INSERT INTO user
VALUES (‘123123123’, ‘user’, ‘123456’, ‘老杨’);
– Table structure for user_attractions
DROP TABLE IF EXISTS user_attractions
;
CREATE TABLE user_attractions
(
id
varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
user_id
varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
attractions_id
varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
user_attractions_describe
varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
create_date
datetime NULL DEFAULT NULL,
PRIMARY KEY (id
) USING BTREE,
INDEX attractions_id
(attractions_id
) USING BTREE,
INDEX user_id
(user_id
) USING BTREE,
CONSTRAINT user_attractions_ibfk_1
FOREIGN KEY (attractions_id
) REFERENCES attractions
(id
) ON DELETE NO ACTION ON UPDATE RESTRICT,
CONSTRAINT user_attractions_ibfk_2
FOREIGN KEY (user_id
) REFERENCES user
(id
) ON DELETE NO ACTION ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
– Records of user_attractions
INSERT INTO user_attractions
VALUES (‘3b753a46dccb427c85aa2a1583fbe37a’, ‘123123123’, ‘1’, NULL, ‘2020-02-19 12:22:21’);
– Table structure for user_hotel
DROP TABLE IF EXISTS user_hotel
;
CREATE TABLE user_hotel
(
id
varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
user_id
varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’,
hotel_id
varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ‘’,
user_hotel_describe
varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
create_date
datetime NULL DEFAULT NULL,
PRIMARY KEY (id
) USING BTREE,
INDEX user_hotel_ibfk_1
(user_id
) USING BTREE,
INDEX user_hotel_ibfk_2
(hotel_id
) USING BTREE,
CONSTRAINT user_hotel_ibfk_1
FOREIGN KEY (user_id
) REFERENCES user
(id
) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT user_hotel_ibfk_2
FOREIGN KEY (hotel_id
) REFERENCES hotel
(id
) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
– Records of user_hotel
INSERT INTO user_hotel
VALUES (‘8aac034f162d4154b9606927c304377c’, ‘123123123’, ‘29’, NULL, ‘2020-02-19 12:22:04’);
– Table structure for user_route
DROP TABLE IF EXISTS user_route
;
CREATE TABLE user_route
(
id
varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
user_id
varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
route_id
varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
create_date
datetime NULL DEFAULT NULL,
PRIMARY KEY (id
) USING BTREE,
INDEX user_id
(user_id
) USING BTREE,
INDEX route_id
(route_id
) USING BTREE,
CONSTRAINT user_route_ibfk_1
FOREIGN KEY (user_id
) REFERENCES user
(id
) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT user_route_ibfk_2
FOREIGN KEY (route_id
) REFERENCES travel_route
(id
) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
– Records of user_route
INSERT INTO user_route
VALUES (‘ae51c1397b3b4782a028c1119e4413c7’, ‘123123123’, ‘15’, ‘2020-02-19 12:07:27’);
自我介绍一下,小编13年上海交大毕业,曾经在小公司待过,也去过华为、OPPO等大厂,18年进入阿里一直到现在。
深知大多数Java工程师,想要提升技能,往往是自己摸索成长或者是报班学习,但对于培训机构动则几千的学费,着实压力不小。自己不成体系的自学效果低效又漫长,而且极易碰到天花板技术停滞不前!
因此收集整理了一份《2024年Java开发全套学习资料》,初衷也很简单,就是希望能够帮助到想自学提升又不知道该从何学起的朋友,同时减轻大家的负担。
既有适合小白学习的零基础资料,也有适合3年以上经验的小伙伴深入学习提升的进阶课程,基本涵盖了95%以上Java开发知识点,真正体系化!
由于文件比较大,这里只是将部分目录大纲截图出来,每个节点里面都包含大厂面经、学习笔记、源码讲义、实战项目、讲解视频,并且后续会持续更新
如果你觉得这些内容对你有帮助,可以添加V获取:vip1024b (备注Java)
最后
这份文档从构建一个键值数据库的关键架构入手,不仅带你建立起全局观,还帮你迅速抓住核心主线。除此之外,还会具体讲解数据结构、线程模型、网络框架、持久化、主从同步和切片集群等,帮你搞懂底层原理。相信这对于所有层次的Redis使用者都是一份非常完美的教程了。
整理不易,觉得有帮助的朋友可以帮忙点赞分享支持一下小编~
你的支持,我的动力;祝各位前程似锦,offer不断!!!
一个人可以走的很快,但一群人才能走的更远。不论你是正从事IT行业的老鸟或是对IT行业感兴趣的新人,都欢迎扫码加入我们的的圈子(技术交流、学习资源、职场吐槽、大厂内推、面试辅导),让我们一起学习成长!
核心主线。除此之外,还会具体讲解数据结构、线程模型、网络框架、持久化、主从同步和切片集群等,帮你搞懂底层原理。相信这对于所有层次的Redis使用者都是一份非常完美的教程了。
[外链图片转存中…(img-lqmlz0ua-1712717376481)]
整理不易,觉得有帮助的朋友可以帮忙点赞分享支持一下小编~
你的支持,我的动力;祝各位前程似锦,offer不断!!!
一个人可以走的很快,但一群人才能走的更远。不论你是正从事IT行业的老鸟或是对IT行业感兴趣的新人,都欢迎扫码加入我们的的圈子(技术交流、学习资源、职场吐槽、大厂内推、面试辅导),让我们一起学习成长!
[外链图片转存中…(img-PmnFbPEC-1712717376482)]