基于springboot的博客项目

/* Navicat MySQL Data Transfer Source Server : k Source Server Version : 50720 Source Host : localhost:3306 Source Database : blog Target Server Type : MYSQL Target Server Version : 50720 File Encoding : 65001 Date: 2019-09-16 10:34:38 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `t_blog` -- ---------------------------- DROP TABLE IF EXISTS `t_blog`; CREATE TABLE `t_blog` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `appreciation` bit(1) NOT NULL, `commentabled` bit(1) NOT NULL, `content` longtext COLLATE utf8_bin, `create_time` datetime DEFAULT NULL, `description` varchar(255) COLLATE utf8_bin DEFAULT NULL, `first_picture` varchar(255) COLLATE utf8_bin DEFAULT NULL, `flag` varchar(255) COLLATE utf8_bin DEFAULT NULL, `published` bit(1) NOT NULL, `recommend` bit(1) NOT NULL, `share_statement` bit(1) NOT NULL, `title` varchar(255) COLLATE utf8_bin DEFAULT NULL, `update_time` datetime DEFAULT NULL, `views` int(11) DEFAULT NULL, `type_id` bigint(20) DEFAULT NULL, `user_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FK292449gwg5yf7ocdlmswv9w4j` (`type_id`), KEY `FK8ky5rrsxh01nkhctmo7d48p82` (`user_id`), CONSTRAINT `FK292449gwg5yf7ocdlmswv9w4j` FOREIGN KEY (`type_id`) REFERENCES `t_type` (`id`), CONSTRAINT `FK8ky5rrsxh01nkhctmo7d48p82` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of t_blog -- ---------------------------- INSERT INTO `t_blog` VALUES ('1', '
', '
', 0x20232020E69198E8A681EFBC9A0D0A0D0AE38080E380804A324545E698AFE4B880E5A597E8A784E88C83EFBC8CE8808C536572766C65742F4A7370E698AF4A324545E8A784E88C83E79A84E4B880E983A8E58886EFBC8CE698AF546F6D636174E79A84E4B8BBE8A681E5AE9EE78EB0E983A8E58886E38082E59CA8E69C80E5889DE79A84E5BA94E794A8E5AE9EE8B7B5E4B8ADEFBC8CE5BD93E794A8E688B7E59091E68C87E5AE9A536572766C6574E58F91E98081E8AFB7E6B182E697B6EFBC8C536572766C6574E588A9E794A8E8BE93E587BAE6B581E58AA8E68081E7949FE6889048544D4CE9A1B5E99DA2EFBC8CE8BF99E5AFBCE887B4536572766C6574E5BC80E58F91E69588E78E87E69E81E4B8BAE4BD8EE4B88BE380824A5350E68A80E69CAFE9809AE8BF87E5AE9EE78EB0E699AEE9809AE99D99E6808148544D4CE5928CE58AA8E68081E983A8E58886E6B7B7E59088E7BC96E7A081EFBC8CE4BDBFE5BE97E980BBE8BE91E58685E5AEB9E4B88EE5A496E8A782E79BB8E58886E7A6BBEFBC8CE5A4A7E5A4A7E7AE80E58C96E4BA86E8A1A8E7A4BAE5B182E79A84E5AE9EE78EB0EFBC8CE68F90E9AB98E4BA86E5BC80E58F91E69588E78E87E38082E69CACE69687E4BBA54A5350E79A84E69CACE8B4A8E698AF536572766C6574E4B8BAE4B8BBE7BABFEFBC8CE7BB93E590884A5350E8BDACE8AF91E5908EE68980E5BE97E79A84536572766C6574EFBC8CE8AFA6E7BB86E68EA2E8AEA8E4BA864A5350E79A84E58E9FE79086E38081E689A7E8A18CE8BF87E7A88BE38081E8849AE69CACE58583E7B4A0E38081E7BC96E8AF91E68C87E4BBA4E5928CE58AA8E4BD9CE68C87E4BBA4EFBC8CE5B9B6E7BB99E587BAE4BA864A5350E4BDBFE794A8E79A84E5B8B8E8A781E6B3A8E6848FE4BA8BE9A1B9E380820D0A2020E4B8802E204A3245452C20546F6D63617420E5928C20576562204170706C69636174696F6E0D0A31E380814A32454520E4B88E20546F6D6361740D0A0D0AE38080E380804A32454520E698AFE794B12053554E20E585ACE58FB8E5BC80E58F91E79A84E4B880E5A597E4BC81E4B89AE7BAA7E5BA94E794A8E8A784E88C83E38082E68980E8B093E8A784E88C832853706563696669636174696F6E29E68C87E79A84E698AFE4B880E7B3BBE58897E68EA5E58FA3EFBC8CE4B88DE58C85E590ABE585B7E4BD93E5AE9EE78EB0EFBC8CE68891E4BBACE58FAFE4BBA5E9809AE8BF87204A3245452053706563696669636174696F6E20415049732028E4BBA5204A324545203620E4B8BAE4BE8B2920E69DA5E4BA86E8A7A3E8AFA5E8A784E88C83E38082204A32454520E4B8BBE8A681E794B1E58D81E4B889E7A78DE6A0B8E5BF83E68A80E69CAFE8A784E88C83E7BB84E68890EFBC8CE8BF99E4BA9BE8A784E88C83E58C85E68BACEFBC9A0D0A0D0A4A44424320284A61766120446174616261736520436F6E6E656374697669747929EFBC9B0D0A4A4E444920284A617661204E616D6520616E64204469726563746F727920496E7465726661636529EFBC9B0D0A454A422028456E7465727072697365204A6176616265616E29EFBC9B0D0A524D49202852656D6F7465204D6574686F6420496E766F6B6529EFBC9B0D0A4A6176612049444C2028496E7465726661636520446566696E6974696F6E204C616E677561676529EFBC9B0D0A4A535020284A6176612053657276657220506167657329EFBC9B0D0A536572766C6574EFBC9B0D0A584D4C2028457874656E7369626C65204D61726B7570204C616E677561676529EFBC9B0D0A4A4D5320284A617661204D657373616765205365727669636529EFBC9B0D0A4A544120286A617661207472616E73616374696F6E2041726368697465637475726529EFBC9B0D0A4A545320286A617661207472616E73616374696F6E20536572766963652041504929EFBC9B0D0A4A6176614D61696CEFBC9B0D0A4A414620284A6176614265616E2041637469766174696F6E204672616D65576F726B292E0D0A0D0AE38080E38080E59FBAE4BA8E204A32454520E8A784E88C83EFBC8CE59084E4B8AAE585ACE58FB8E58FAFE4BBA5E6A0B9E68DAEE887AAE5B7B1E79A84E4BAA7E59381E5AE9EE78EB0E79BB8E5BA94E79A84E68EA5E58FA3EFBC8CE4BE8BE5A682EFBC8C4A424F535320E5928C20474C4153534649534820E5B0B1E698AFE5B8B8E8A781E79A84204A32454520E5AE9EE78EB0E38082E789B9E588ABE99C80E8A681E6B3A8E6848FE79A84E698AFEFBC8C20546F6D63617420E698AFE4B880E4B8AA20536572766C657420E5AEB9E599A8EFBC8CE5AE9EE78EB0E4BA86204A32454520E4B8ADE79A8420536572766C65742F4A535020E8A784E88C832028E4BD8DE4BA8E20546F6D63617420E79A84206C696220E79BAEE5BD95E4B88BE79A84206A73702D6170692E6A617220E5928C20736572766C65742D6170692E6A617229EFBC8CE68980E4BBA5204A737020E5928C20536572766C657420E58FAAE8A681E68C892053554E20E58F91E5B883E79A84E8A784E88C83E8BF9BE8A18CE5BC80E58F91E5928CE983A8E7BDB2E5B0B1E883BDE79BB4E68EA5E59CA820546F6D63617420E4B8ADE8BF90E8A18CE38082E4BD86E698AF20546F6D63617420E6B2A1E69C89E5AE9EE78EB020454A4220E7AD89E8A784E88C83EFBC8CE4B99FE5B0B1E698AFE8AFB4EFBC8C546F6D63617420E5B9B6E4B88DE698AFE4B880E4B8AA20454A4220E5AEB9E599A8EFBC8CE68980E4BBA520546F6D63617420E4B88DE698AFE4B880E4B8AAE5AE8CE695B4E79A84204A32454520E5AE9EE78EB0E38082E9809AE5B8B8EFBC8CE88BA5E4B880E4B8AA20574542E69C8DE58AA1E599A820E683B3E8A681E694AFE68C81204A324545EFBC8C20E982A3E4B988E5AE83E5BF85E9A1BBE8A681E5AE9EE78EB0E8BF99E4B8AAE8A784E88C83E380820D0A0D0AE38080E38080E680BBE79A84E69DA5E8AFB4EFBC8C4A32454520E698AFE4B880E5A597E8A784E88C83EFBC8CE8808C20546F6D63617420E5AE9EE78EB0E4BA86E585B6E4B8ADE79A84E4B880E983A8E58886E8A784E88C83EFBC9B536572766C65742F4A737020E698AF204A32454520E8A784E88C83E79A84E4B880E983A8E58886EFBC8CE698AF20546F6D63617420E79A84E4B8BBE8A681E5AE9EE78EB0E983A8E58886E380820D0A0D0A32E38081576562204170706C69636174696F6E0D0A0D0AE38080E38080E7ACA6E59088204A32454520E8A784E88C83E79A8420576562204170706C69636174696F6E20E5AE9EE99985E4B88AE698AFE4B880E4B8AAE79BAEE5BD95EFBC8CE5A682E4B88BE59BBEE68980E7A4BAE38082636C617373657320E5928C206C696220E4B8A4E4B8AAE69687E4BBB6E5A4B9E983BDE98082E794A8E4BA8EE4BF9DE5AD9820576562E5BA94E794A820E68980E99C80E79A844A617661E7B1BBE69687E4BBB6EFBC8CE58CBAE588ABE698AF20636C617373657320E4BF9DE5AD98E58D95E4B8AA202A2E636C61737320E69687E4BBB6EFBC9BE8808C206C696220E4BF9DE5AD98E68993E58C85E5908EE79A84206A617220E69687E4BBB6E380820D0A0D0AE38080E38080E38080E38080E38080E38080E38080E38080E38080E38080E38080E38080E380805B215B5D28687474703A2F2F7374617469632E7A7962756C756F2E636F6D2F5269636F3132332F3531643968796A34733363307765343679396174636A33632F7765622532306170702E706E67295D28687474703A2F2F7374617469632E7A7962756C756F2E636F6D2F5269636F3132332F3531643968796A34733363307765343679396174636A33632F7765622532306170702E706E6729E380800D0A0D0AE4BA8C2E204A535020E58E9FE790860D0A31E380814A535020E7AE80E4BB8B200D0AE38080E380804A535020284A617661205365727665722050616765732920E698AFE794B12053756E20E585ACE58FB8E580A1E5AFBCE38081E5A49AE5AEB6E585ACE58FB8E58F82E4B88EE4B880E8B5B7E5BBBAE7AB8BE79A84E4B880E7A78DE58AA8E68081E7BD91E9A1B5E68A80E69CAFE6A087E58786E380824A535020E69687E4BBB6EFBC882A2E6A7370EFBC89E5AE9EE99985E4B88AE698AFE59CA8E4BCA0E7BB9FE79A84E7BD91E9A1B548544D4CE69687E4BBB6EFBC882A2E68746DEFBC8C2A2E68746D6CEFBC89E4B8ADE68F92E585A54A617661E7A88BE5BA8FE6AEB5EFBC885363726970746C6574EFBC89E5928C204A5350E6A087E8AEB0EFBC88746167EFBC89E68980E5BDA2E68890E79A84E38082200D0A0D0AE38080E380804A535020E79A84E69CACE8B4A8E698AF20536572766C6574E38082E5BD93E794A8E688B7E59091E68C87E5AE