-
Notifications
You must be signed in to change notification settings - Fork 0
/
VBlog.sql
139 lines (124 loc) · 77.5 KB
/
VBlog.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
/*
Navicat Premium Data Transfer
Source Server : 服务器连接
Source Server Type : MySQL
Source Server Version : 100314
Source Host : xxx.xx.xx.xx:3306
Source Schema : artificial_intelligence
Target Server Type : MySQL
Target Server Version : 100314
File Encoding : 65001
Date: 01/06/2020 11:49:55
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
`admin_id` int(11) NOT NULL AUTO_INCREMENT,
`account` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
`admin_name` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
`password` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
`head_url` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
`profile` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
PRIMARY KEY (`admin_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES (1, 'admin', '管理员', 'admin', 'asserts/images/2590B9A2D30548CD875692D1AFAF3A38232.jpg', '这个人很懒，什么也没留下。。。');
INSERT INTO `admin` VALUES (2, 'xtm', '熊天民', 'admin', 'asserts/images/53AA1B7EC464408B843E4506AC6E36B3default_head.jpg', '暂无');
INSERT INTO `admin` VALUES (3, 'user1', 'user1', 'admin', 'asserts/images/35FF0BF328DF4C5487CE47D1AABAD779timg.jpg', '这个人很懒，什么也没留下。。。');
INSERT INTO `admin` VALUES (4, 'user2', 'user2', 'admin', 'asserts/images/46C3492901F8449591CBFED8CB6C21CAtimg.jpg', '这个人很懒，什么也没留下。。。');
-- ----------------------------
-- Table structure for article
-- ----------------------------
DROP TABLE IF EXISTS `article`;
CREATE TABLE `article` (
`article_id` int(11) NOT NULL AUTO_INCREMENT,
`author_id` int(5) NOT NULL,
`article_content` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`create_time` datetime(0) NOT NULL DEFAULT current_timestamp(),
`article_title` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`article_click` int(5) NOT NULL DEFAULT 0,
PRIMARY KEY (`article_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 35 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of article
-- ----------------------------
INSERT INTO `article` VALUES (14, 1, '<p><a target=\"_blank\" href=\"https://baike.baidu.com/item/%E6%95%B0%E6%8D%AE%E5%BA%93%E7%AE%A1%E7%90%86%E7%B3%BB%E7%BB%9F\">数据库管理系统</a><span>（英语：Database Management System，简称DBMS）是为管理</span><a target=\"_blank\" href=\"https://baike.baidu.com/item/%E6%95%B0%E6%8D%AE%E5%BA%93\">数据库</a><span>而设计的电脑</span><a target=\"_blank\" href=\"https://baike.baidu.com/item/%E8%BD%AF%E4%BB%B6\">软件</a><span>系统，一般具有存储、截取、安全保障、备份等基础功能。数据库管理系统可以依据它所支持的</span><a target=\"_blank\" href=\"https://baike.baidu.com/item/%E6%95%B0%E6%8D%AE%E5%BA%93%E6%A8%A1%E5%9E%8B\">数据库模型</a><span>来作分类，例如关系式、</span><a target=\"_blank\" href=\"https://baike.baidu.com/item/XML\">XML</a><span>；或依据所支持的计算机类型来作分类，例如服务器群集、移动电话；或依据所用查询语言来作分类，例如</span><a target=\"_blank\" href=\"https://baike.baidu.com/item/SQL\">SQL</a><span>、</span><a target=\"_blank\" href=\"https://baike.baidu.com/item/XQuery\">XQuery</a><span>；或依据性能冲量重点来作分类，例如最大规模、最高运行速度；亦或其他的分类方式。不论使用哪种分类方式，一些</span><a target=\"_blank\" href=\"https://baike.baidu.com/item/DBMS/1239170\" data-lemmaid=\"1239170\">DBMS</a><span>能够跨类别，例如，同时支持多种查询语言。</span><span class=\"sup--normal\" data-sup=\"1\" data-ctrmap=\":1,\"> [1]</span><a class=\"sup-anchor\" name=\"ref_[1]_1088\"> </a></p>', '2019-06-27 13:00:11', '数据库管理系统', 54);
INSERT INTO `article` VALUES (15, 1, '<div class=\"para\" label-module=\"para\"><img src=\"http://img.t.sinajs.cn/t4/appstyle/expression/ext/normal/40/pcmoren_tian_org.png\" alt=\"[舔屏]\" data-w-e=\"1\"><b>结构化查询语言</b>(Structured Query Language)简称SQL(发音：/ˈes kjuː ˈel/ \"S-Q-L\")，是一种特殊目的的编程语言，是一种数据库查询和<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E7%A8%8B%E5%BA%8F%E8%AE%BE%E8%AE%A1%E8%AF%AD%E8%A8%80/2317999\" data-lemmaid=\"2317999\">程序设计语言</a>，用于存取数据以及查询、更新和管理<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E5%85%B3%E7%B3%BB%E6%95%B0%E6%8D%AE%E5%BA%93%E7%B3%BB%E7%BB%9F\">关系数据库系统</a>；同时也是<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E6%95%B0%E6%8D%AE%E5%BA%93%E8%84%9A%E6%9C%AC%E6%96%87%E4%BB%B6/644744\" data-lemmaid=\"644744\">数据库脚本文件</a>的扩展名。</div><div class=\"para\" label-module=\"para\">结构化查询语言是高级的非过程化编程语言，允许用户在高层<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E6%95%B0%E6%8D%AE%E7%BB%93%E6%9E%84/1450\" data-lemmaid=\"1450\">数据结构</a>上工作。它不要求用户指定对数据的存放方法，也不需要用户了解具体的数据存放方式，所以具有完全不同底层结构的不同<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E6%95%B0%E6%8D%AE%E5%BA%93%E7%B3%BB%E7%BB%9F/215176\" data-lemmaid=\"215176\">数据库系统</a>, 可以使用相同的结构化查询语言作为数据输入与管理的接口。结构化查询语言语句可以嵌套，这使它具有极大的灵活性和强大的功能。</div><p style=\"text-align: left;\">1986年10月，美国国家标准协会对SQL进行规范后，以此作为关系式数据库管理系统的标准语言（ANSI X3. 135-1986），1987年得到国际标准组织的支持下成为国际标准。不过各种通行的数据库系统在其实践过程中都对SQL规范作了某些编改和扩充。<i><b><u>所以，实际上不同数据库系统之间的SQL不能完全相互通用。</u></b></i></p><p><br></p>', '2019-06-27 13:01:21', '结构化查询语言', 50);
INSERT INTO `article` VALUES (16, 1, '<p><span>layui（谐音：类UI) 是一款采用自身模块规范编写的前端 UI 框架，遵循原生 HTML/CSS/JS 的书写与组织形式，门槛极低，拿来即用。其外在极简，却又不失饱满的内在，体积轻盈，组件丰盈，从核心代码到 API 的每一处细节都经过精心雕琢，非常适合界面的快速开发。layui 首个版本发布于2016年金秋，她区别于那些基于 MVVM 底层的 UI 框架，却并非逆道而行，而是信奉返璞归真之道。准确地说，她更多是为服务端程序员量身定做，你无需涉足各种前端工具的复杂配置，只需面对浏览器本身，让一切你所需要的元素与交互，从这里信手拈来。</span></p><p><img src=\"data:image/jpeg;base64,/9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAMCAgMCAgMDAwMEAwMEBQgFBQQEBQoHBwYIDAoMDAsKCwsNDhIQDQ4RDgsLEBYQERMUFRUVDA8XGBYUGBIUFRT/2wBDAQMEBAUEBQkFBQkUDQsNFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBT/wAARCAC4AM0DASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD9UKKKKACiiigArP17XrDwzpVxqWp3KWlnAu55H/QAdyegA5NaFfH/AO0L8Sm8ZeKX0uzm3aPpjmNAp+WWXo7++Puj2BI615GZ5hHLqHtN5PRLz/yXU8/HYtYOlz7t7I0viD+0zrWuzS2vh0HRtPzgTYBuJB6k9E+g5968g1DVr7VpjLfXtxeSnkvcSs7H8SaqUV+UYnG4jFy5q02/y+S2PgK2JrYiXNUlf8vuCiiiuI5gooooAKKKKACiiigAo6UUUAdD4d+IPiPwnMsml6zd2wU58rzC0Z+qHKn8q+jPhP8AtGWviy5h0nxBHFp2qSEJFcR8Qzt2HP3GP5H24FfKVAODXr4LNMTgZJwlePZ7f8D5HoYXHVsLJOLuuz2/4B+jFFeU/s9/EpvG/hY2F/N5msaaBHIzH5pYv4H9zxg+4B716tX63hsRDF0Y1qez/q3yP0GhWjiKaqw2YUUUV0m4UUUUAFFFFABRRUV1cxWVtLcTyLFBEhkkkc4CqBkk+wFJu2rDY84+PfxF/wCEE8HPDay7NW1INBb7T80a4+eT8AcD3YelfGddf8VPHkvxD8Y3epkstmp8m0ib+CIE449Tyx9zXIV+Q5vj/r+Jcov3I6L/AD+f5WPzvMcX9artr4Vov8/mFFFFeGeWFFFFABRRRQAUV1ugfCbxd4nsVvdN0K5ntWGUlcrGrj1XeRuH0zWDreg6j4bv3stUsp7C6UZMU6FTj1HqPccVvKhVhBVJQaT62dvyNZUqkYqcotJ9bFCiiisDIKKKKACiiigDpvhz41uPAHi2y1eDc0aNsuIgf9bEfvL/AFHuBX3Vp2oW+rWFve2kqz2txGssUi9GUjIP5V+d9fSn7LnxF+0W83hK+l/eRBp7Eseq9Xj/AAPzD2LelfZcO4/2NV4Wo/dlt6/8H8z6TJsX7OfsJvSW3r/wfzPoSiiiv0k+0CiiigAooooAK8H/AGn/AIi/2XpMXhaylxdXqiS7KnlIc8L9WI/Ie9ex+KfEdp4R8P32r3zbba0jLkA8seiqPckgD618IeJ/EV34s1++1e+ffc3chkb0UdlHsBgD2FfJ8QY/6tQ+rwfvT/Bdfv2+88DN8X7Gl7GL96X5f8Hb7zLooor8wPhgoop8EElzNHDDG0ssjBUjQZZieAAB1NPcBlFfS3wu/ZmtY7RNQ8YRme4kAZNNSQqsY/6aMpyW9gcD37bfxD/Zv8P6polxN4dtDpeqxIXiSORmjmIH3CGJxnoCMc9c19HHIMbKj7ayXW3X+vI9qOUYmVL2ll6dT5Ortfg34ZtvFvxI0bTr1BJZl2lljPR1RC+0+xKgH2NcURg4PWvTv2b/APkrel/9cp//AEU1eVgIRqYulCSunJfmefhIqeIpxls2vzPslEWNQqgKqjAAGABXl37Rvhe01z4cXt9JGv23TNs8EuOQCwDrn0IPT1Ar1KuI+Nv/ACSrxJ/17f8Asy1+u4+EZ4SrGS05X+R+h4uKlh6ia6P8j4eoor0f4I/CxPiZ4guBeSPFpViqvcGI4dyxO1Ae2cMSfQe9fjeHoVMTVjRpK8mfnFGlOvNU4LVnnFFfad9+z94FvdONouii1O3C3EEziVT65JOfxyK+Z/il8JNU+GWoDzv9M0qZiLe+RcA/7Lj+Fvbv2749bHZNisDD2k7Sj1a6ev8Amd+Ky2vhY88tV5dDhKKKK8E8oKvaHrN34d1ez1Oxk8q7tZVljb3B6H1B6EehqjRVRk4tSi9UNNxd0ffngrxZa+N/DFhrNocR3CZePOTG44ZD9Dn+fetyvk/9mn4i/wDCOeJG8P3ku3T9UYeUWPEdx0H/AH0ML9QtfWFfseV45Y/DRqfaWj9f+Dufo+BxSxdFT67P1/4O4UUUV6x6AUUVx3xX8exfDzwdd6llTev+5tI2/ilI4OPQcsfp71lVqwoU5VajskrszqVI0oOc3ojw39p74i/2vrEfheylzaWDeZdFTw82OF/4CD+ZPpXhVSXFxLd3Es88jSzSsXeRzksxOSSfUmo6/F8bip42vKvPr+C6I/NcTXliasqsuv5dAooorhOUK+qv2fvg0nhqyh8R6zBnWLhN1vBIv/Hqh74/vkfkOOua8u/Z2+HK+MvFh1G9i36VpZWVlYfLLL/AnuBgsfoAetfX9fd8PZYpf7ZWX+H/AD/y+8+qyfBKX+01F6f5/wCQVzvjvxvp3gHw9canqEqqVUiCDPzTyY4RR/P0HNN8f+O9P+HnhybVb87iPkgt1OGmkI4UfzJ7AGvirxr431Xx7rcuparOZHORHCvEcKdlQdh+p6mvdzfN4ZfH2cNaj/Dzf6Lr6Hq5hmEcJHkjrN/h5swpZDNI8jfeYlj9TXpn7N//ACVvS/8ArlP/AOimrzGvTv2b/wDkrel/9cp//RTV+c5d/vtH/EvzPjMH/vNP1R9lVxHxt/5JV4k/69v/AGZa7euI+Nv/ACSrxJ/17f8Asy1+u43/AHWr/hl+TP0PE/wJ+j/Jnw9XtX7Mnj2w8La9qGlalMttFqgj8meQ4USpuwpPbcGPJ7geteK0V+OYTEzwdeNeG6PzjD15YarGrHdH6MVR1zQ7HxHpVzpuo26XVncLskjcdfcehHUHsa+ePgF8cZbe5tvDHiG4MsEhEdleytkxnoI3PdT0B7dOmMfStfruDxlHMaHPDbZp9PJ/1qfoeGxNPGUuaPzX6Hw38Vvhrd/DTxI1m5abT58yWd0R/rE9D/tL0P4HvXF190fFTwDB8RPCF1pzKovUBms5T/BKBxz6HofY+wr4buLeW0uJYJkaKaJijowwVYHBB/GvzbOcu+oV/c+CWq8u6+X5HxeZYP6pV934Xt/l/XQjooor588gcjtE6ujFHU5VlOCD6ivtv4M/EJfiH4Mt7qVwdTtcW94vfeBw+PRhz9cjtXxFXffBX4ht8PfGcE8zkaXd4t7xewUnh/qp5+m4d6+gyXH/AFHErmfuS0f6P5fketlmL+q1lzP3ZaP9H/XQ+2qKRHWRQykMrDIIOQRS1+tn6EFfGPx5+Iv/AAnnjGSO1l36Tp26C2wflc5+eT8SOPYCvdv2iPiL/wAId4SOm2cu3VdVDRIVPMUXR39ic7R9Se1fH9fAcSY+7WDpvzl+i/V/I+SzrF3thoPzf6L9fuCiiivgz5QKKK3fAmiDxH400TTGXdHc3kSSD/Y3Dd/47mtIQdSahHdtL7yoxc5KK3Z9h/Bfwgvgz4eaXatHsu7hPtdzkc+Y4BwfoNq/8BruKOlcT8Z/EzeFPhtrN5E5S5ki+zQkdQ0h25HuASfwr9r/AHeBw2nwwj+S/X9T9N9zC0PKK/JHzB8cPiG/j7xnOYJd2k2Ja3tFB+VgD80n/AiPyC155RRX4xXrzxNWVao9W7n5rVqyrVHUnuwr079m/wD5K3pf/XKf/wBFNXmNenfs3/8AJW9L/wCuU/8A6KaunLf99o/4l+Zvgv8Aeafqj7KriPjb/wAkq8Sf9e3/ALMtdvXEfG3/AJJV4k/69v8A2Za/Xsb/ALrV/wAMvyZ+h4n+BP0f5M+HqKKK/ED8wDpX2X8AfiG3jrwasN3IZNV00rBcMxyZFx8kh+oBB91J718aV6j+zj4mbQPiXaWzOVttSRrSQZ43Y3IfruAH/AjXv5JjHhcZFX92ej+ez+T/ADPWyvEOhiIrpLR/p+J9j18hftL+EF8O+Pv7Qgj2WurR/aOBx5o4kH/oLfVq+va8X/ap0Rb/AMBWmoBcy2F4uW9EcFT/AOPbPyr7zPcOq+Bm+sdV8t/wPq81oqrhZPrHX+vkfJ9FFFfkh+fBRRRQB9Z/s1/EX/hJvDJ0K8l3ajpSgRljzJb9FP8AwH7v02+tey18C+BvF114G8UWOs2mS1u/7yPOBLGeGQ/UZ+hwe1fd2java6/pVpqVlKJrS6jWWNx3BGefQ+or9TyDH/WsP7Gb9+Gnquj/AE+4+8ynF/WKPs5P3o/l0/yPib4v+KpfF/xC1e8Zy0EUzW1uOyxISox9eW+rGuMqS53/AGmXzP8AWbzuz655qOvzKtUlWqyqT3bbPh6s3UnKct2wooorEzCvR/2eLZbn4uaJuGRGJpMe4hfH64rzivSf2drgQfFzRQxwJFnT8fJcj+Vehl9vrlG/8y/M68Hb6zTv3X5n2fXh37WV60XgvSLUHAmv9599sbf/ABVe414X+1pas/hDRrkD5Y74xn/gUbH/ANlr9Szm/wDZ9a3b9Ufd5lf6pUt2/VHy3RRRX46fnIV6d+zf/wAlb0v/AK5T/wDopq8xrq/hZ4si8EePdJ1e4BNrDIUm2jJCOpRjjvgNnHtXdgakaWKpTm7JSV/vOrCzUK8JS2TR921xHxt/5JV4k/69v/ZlrsLC/ttUs4buznjubWZQ8c0TBlYeoIryT9pPx3Y6L4LudBSZJNU1LavkqctHEGDF2HYHGB659jX63mFWFPB1JyenK/xWn3n6Di6kYYecm9LP8UfJNFFFfix+aBWt4RvW03xXot2h2vBewyA/Rwaya0vDNo1/4k0m2QZaa7ijA9y4H9a1pXVSNt7r80XC/Ord1+aP0GrgvjvbLd/CbxCjDO2JJB9VkRv6V3tcH8dbgWvwm8ROxwDCifi0ir/Wv2nHW+q1b/yy/Jn6ZirewqX7P8mfEdFFFfiJ+YBRRRQAV9G/s0/EaDTfDup6RqdwUhtZlktiecB925R7Arn/AIEa+cq0tH+2fvvsu7tuxn3x/WvSy/FzwWIVWGu+nc7cHiJYasqkTofjD4Vl8IfEPV7NkKwTTNdW57GJyWGPocr9VNcZX2D+0P8ADr/hMvCJ1G0i3arpYaVAo5ki6unv03D6Ed6+Pq6c4wTwWKlFfDLVfPp8n+htmOGeGrtdHqv68gooorxDzAro/hzrI8PeO9B1B22RQ3kZkY9kLYb/AMdJrnKK0pzdOcZx3TT+53LhJwkpLpqfoxXAfHbw43iX4YaxFEpee2UXcYAycxnLf+O7h+NaHwm8WL408AaTqJcPciIQXHPIlT5Wz9cBvowrrnRZFKsAykYIIyCK/a5KGOwzS+GcfzX9fcfpjUcVQstpL80fnRRXa/F3wDJ8PfGd3YqhGnzEz2b9jET93Pqpyp+me9cVX4tWpToVJUqis07H5pUpypTdOe6CiiisTM0tM8TaxokTxadq19YRv95LW5eMN9QpFUZ55bqZ5ppHmlc7mkkYszH1JPWo6Ktzk0ot6IpybVm9AoooqCQr0f8AZ+8ON4h+KGlsV3QWGb2U46bPu/8Aj5SvOK+uf2bfh+/hTwk+rXkZTUNW2yBWHKQj7g9iclvxX0r3MmwjxeMhp7sdX8tvvdj1Mtw7xGJj2Wr+X/BPX68d/ak1oaf8OorEN+8v7tE2+qLlyfzC/nXsVfJf7UHi1db8cQ6TC4a30mLY2Dx5r4Z/yAQfUGv0HPMQqGBn3lovnv8Ahc+uzSsqWFl3en3/APAPG6KKK/Ij89CiiigAr6N/Zp+HMGpeHNS1fVLcvDdzLHbA8ZCbtzD2JbH/AAE14h4G8I3XjnxTY6Na5DTv+8kxkRRjlnP0H5nA7193aNpFroOlWmnWUQhtLWNYo0HZQMfifU19jw7gPb1Xiai92Oi82/8AJfmfR5PhPa1HWmtF+f8AwC5Xxl8efh1/wgfjGSW1i2aRqO6e2wPlRs/PH+BOR7EV9m1x/wAVvAUXxD8HXem4UXifvrSRv4JQOOfQ8qfY+1fXZxgPr+GcYr346r/L5/nY+hzHCfWqDS+Jar/L5nwvRUlzbS2dxLBPG0U0TlHjcYKsDggj1BqOvyFq2jPzvYKKKKQHs/7NHxDXw14lk0G9lCWGqsPKZjgRzjhf++h8v1C19Y1+dCsUYMpIYHII6ivr34EfGCPx1pSaTqcwXX7VMEscfakH8Y/2h/EPx78ff8O5kuX6lVev2f8AL9V8z63J8arfVqj9P8v8jqfil8N7P4l+HHsZisF7CTJaXWMmN8dD/snoR9D1Ar4q8ReHNQ8KavcaZqls1reQnDI3QjswPcHsRX6DVyvj/wCGui/EbThbapARPGD5F3FgSxH2PceoPH869XN8nWPXtaWlRfc/Xz7P7zvzHLli/wB5T0mvx/rufCNFeneOv2ffFHg+SSW2tzrenDkXFmpLgf7Uf3h+GR715k6NG5VlKspwQRgg1+aV8NWw0uStFxfn/Wp8TVo1KEuWpGzEooormMQorW8PeFNY8V3Qt9I0241CXOD5KEqv+83RR7kivoL4a/sww2EkWoeLJEu5Vwy6bCcxg/8ATRv4v90ce5Feng8uxOOlalHTu9vv/wArndhsFWxTtTjp36HHfAf4Ky+Lb2HXtZgKaHA26GKQf8fbg+n9wHqe/T1x9YgAAADAFNiiSCJI40WONAFVEGAoHQAdhUOoahbaVYz3l5OltawIZJJZDhVUdSa/VMBgKWW0eSO+7ff/AICPu8JhKeCp8sfmzC+Ivja28AeE73V5yrSIuy3hY/62U/dX+p9ga+E7++n1O+uLy5kMtzcSNLLI3VmY5J/M13fxm+KU3xK8Q5hLRaNaEpaQtwW9ZGHqcfgMD1z57X53neYrHV+Wm/cjt5vq/wDLy9T4/M8Z9aq8sPhjt5+YUUUV84eMFFFd98Ffh43xC8ZwQTITpdni4vG7FQeE+rHj6bj2rehRniKsaVNaydjWlTlWmqcN2e7fs2fDr/hGPDJ128i26lqqhkDDmO36qP8AgX3j7bfSvZKRVVFCqAqgYAAwAKWv2nCYaGEoRoQ2X4vq/mfpeHoxw9KNKOyCiiius6D5d/ae+HX9k6xF4ososWl8wjuwo4SbHDfRgPzB9a8Jr9BPFHhy08W+H77SL5N1tdRlGPdT1DD3BwR7ivg/xR4du/CWv32kXybbm0kMbHsw6hh7EYI9jX5hxBgPq1f6xBe7P8H1+/f7z4bN8J7Gr7WK92X5/wDB3+8y6KKK+TPACrGnajdaTfQXllPJbXUDB45omwykdwar0U02ndDTad0fWnwk/aDsPF0cOma9JHp2tcIsrHbDcn2PRWP93oe3oPZK/OevT/AH7QXiTwSkdrO41rTEwBb3bHeg9Ek6j6HIHYV91l3EfKlSxmv95fqv1X3H1ODznlShifv/AM/8z7JrG1vwXoPiQk6po9lfP/z0mgVnH0bGR+dcP4X/AGjfB3iFUS5u30W5PWO+XC59nGVx9cV6Np+rWOrw+bY3tvexf37eVZF/ME19nTr4bGR9yUZr5P8AB/5H0sKtDEx91qS+T/D/AIBxE37P/gCd9zeHkB/2LmdR+QcVd074LeCNLcNB4bs3I6faA03/AKGTXa0ULBYWLuqUb/4V/kCwtBO6pr7l/kRWtpBYwLDbQx28K8LHEoVR9AKlrmte+JXhbwwrHUtdsoHXrEsokk/74XLfpXkPjL9q62hR4PDOnNPJ0F5fDag91QHJ/Ej6VjiMxwmDX7ya9Fq/uX/AMq2Mw+HXvyXotX9yPbvEvinS/CGlyahq95HZWqfxOeWP91R1Y+wr5I+L3xrv/iRcGztg9hoMbZS2J+aYjo0mP0XoPc81xXibxbq/jHUTe6xfS30/O3eflQeiqOFHsBWRX5/meeVManSpLlh+L9fLy+8+Rx2aTxS9nT92P4v1/wAgooor5c8MKKKKAHRxtK6oil3YgKqjJJ9BX258Gvh8vw88GW9rKgGp3OJ7xx13kcJn0UcfXJ714V+zR8Ov+Ej8Rt4gvYt2n6Ww8kMOJLjqP++RhvqVr6vr9D4bwHJF4yotXpH06v57eh9hkuE5YvEzWr0Xp1YUUUV9wfUBRRRQAV4R+0/8Ov7V0iLxTZRZurFRHdhRy8OeG/4CT+R9q93qO5tory2lt541lglQxyRuMhlIwQR6EVxY3CwxtCVCfX8H0Zy4mhHE0pUpdfz6H510V1/xV8By/Dzxjd6YQzWbfvrSVv44ieOfUcqfcVyFfi9WlOhUlSqKzTsz81qU5UpuE1qgooorEzCiiigAp8U0kDh4naNx0ZDgimUUwNePxhr0K7Y9b1GNemFu5AP51WvNd1LUV23WoXVyPSaZn/mao0VbqTas5P73/mW5yas2/vYUUUVmQFFFFABRRRQAVe0PRrvxFrFnpljH5t3dSrFGvuT1PoB1J9BVGvpT9lz4dfZ7abxbfRYkmDQWIYdE6PJ+J+Uewb1r0svwcsdiI0Vtu/Jdf8vU7cHhniqyprbr6HtHgrwna+CPDFho1mMx2yYaTGDI55Zz9Tk/pW5RRX7NCEacVCCsloj9JjFQioxWiCiiirKCiiigAooooA8z+PXw6/4Tvwc81rFv1bTQ09ttHzSLj54/xAyPdRXxnX6MV8gftC/DV/Bvil9Us4duj6m5kUqPlimPLp7Z+8PYkDpXwfEmX3SxlNeUv0f6P5HymdYS9sTBeT/R/p9x5NRRRXwB8kFFFFABRRRQAUUUUAFFFFABRRRQAUUUAZOByaAOm+HPgq48f+LbLSIdyxu2+4lUf6qIfeb+g9yK+6tO0+30qwt7K0iWC1t41iijXoqgYArzH9nz4at4H8LG/v4fL1jUgJJFYfNDF/Ansecn3IHavVq/Vsiy/wCp4f2k1789X5Lov1Z99lWE+rUeeS96X5dEFFFFfSntBRRRQAUUUUAFFFFABVDXdCsPEulXGm6nbJd2c67Xif8AQg9QR1BHIooqZRUk4yV0xNKSs9j5g+IP7MutaHPLc+HSdZ0/ORASBcRj0xwH+o59q8h1DRdQ0mYxX1jc2co4KXELIR+BFFFfnuc5Ph8LD29G6u9uny6nx+ZZdRoR9rT08uhV2N/dP5UbG/un8qKK+L5T5vlDY390/lRsb+6fyooo5Q5Q2N/dP5UbG/un8qKKOUOUNjf3T+VGxv7p/KiijlDlDY390/lR5bH+E/lRRT5Q5TofDvw78S+K5lj0zRru4DHHmmMpEPq7YUfnX0Z8J/2dLTwjcQ6tr8kWparGQ8UCDMEDdjz95h69B6Hg0UV+kZTk2GhCGJn70nrrsvl/mfZ5fltCMY1pavz2R7TRRRX159EFFFFABRRRQB//2Q==\" style=\"max-width: 100%;\"></p><p><br></p>', '2019-06-27 13:11:00', 'layer', 10);
INSERT INTO `article` VALUES (17, 1, '<p>如果JPA提示Executing an update/delete query，那是一定是因为Service层没有加@Transactional和再方法加@Modifying吧。</p><p><br></p><p>异常场景</p><p>spring-boot2+jpa执行新增修改删除操作时：</p><p><br></p><p>public interface UserRepository extends JpaRepository<User , Integer>{</p><p><br></p><p> @Modifying</p><p> @Query(value=\"update User c set c.state = ?1,c.lastupdatetime = ?2 where c.user_no= ?3\")</p><p> void updateUser(int state,Date nowDate,String user_no);</p><p><br></p><p>}</p><p>异常： Executing an update/delete query</p><p><br></p><p>解决方案</p><p>因为jpa要求，’没有事务支持，不能执行更新和删除操作’。</p><p><br></p><p>所以反过来讲，就是在Service层或者Repository层上必须加@Transactional，来代表这是一个事务级别的操作，增删改查除了查都是事务级别的，就当这是一个规范也是ok的。</p><p>--------------------- </p>', '2019-06-27 13:12:11', 'JPA事务问题Executing an update/delete query', 35);
INSERT INTO `article` VALUES (18, 3, '<p>使用springboog+jpa框架，因为业务需求不能使用封装好的save（）方法，故需要在jpa容器里使用@Query注解写sql完成</p><p><br></p><p>起初，直接@Query(value=\"insert into 对象名(字段名) values (?1)\")插入，但是一直报错unexpected token: VALUES</p><p><br></p><p>即sql语句有误，各种改，没用，后来网上查，大多数说法是jpa的jpql不支持insert into ，不经意看到一篇文章里，写的语句后面有一些不一样，试之，完美解决，所以记录下来： @Query(value = \"sql语句\",nativeQuery = true)</p><p><br></p><p>这里先要认识并加入一个注解 @Modifying：</p><p><br></p><p>jpa容器中使用，当使用@Query写jpql时，如果是删除或修改操作，需要加入此注解进行修饰. 以通知 SpringData， 这是一个 UPDATE 或 DELETE 操作 ；默认情况下，是只读，所以查询不需要</p><p><br></p>', '2019-06-27 13:12:54', 'jpa原生sql@Query操作增删改查', 12);
INSERT INTO `article` VALUES (19, 3, '<div class=\"para\" label-module=\"para\">在1970年代初，由<a target=\"_blank\" href=\"https://baike.baidu.com/item/IBM\">IBM</a>公司San Jose,California研究实验室的<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E5%9F%83%E5%BE%B7%E5%8A%A0%C2%B7%E7%A7%91%E5%BE%B7\">埃德加·科德</a>发表将数据组成表格的应用原则（Codd\'s Relational Algebra）。1974年，同一实验室的D.D.Chamberlin和R.F. Boyce对Codd\'s Relational Algebra在研制关系数据库管理系统System R中，研制出一套规范语言-SEQUEL（Structured English QUEry Language），并在1976年11月的IBM Journal of R&D上公布新版本的SQL（叫SEQUEL/2）。1980年改名为SQL。</div><div class=\"para\" label-module=\"para\">1979年ORACLE公司首先提供商用的SQL，IBM公司在DB2和SQL/DS数据库系统中也实现了SQL。</div><div class=\"para\" label-module=\"para\">1986年10月，美国ANSI采用SQL作为关系数据库管理系统的标准语言（ANSI X3. 135-1986），后为国际标准化组织（ISO）采纳为国际标准。</div><div class=\"para\" label-module=\"para\">1989年，美国ANSI采纳在ANSI X3.135-1989报告中定义的关系数据库管理系统的SQL标准语言，称为ANSI SQL 89，该标准替代ANSI X3.135-1986版本。该标准为下列组织所采纳：</div><div class=\"para\" label-module=\"para\">国际标准化组织（ISO），为ISO 9075-1989报告“Database Language SQL With Integrity Enhancement”</div><div class=\"para\" label-module=\"para\">美国联邦政府，发布在The Federal Information Processing Standard Publication(FIPS PUB)127</div><p><div class=\"anchor-list\"><a name=\"4\" class=\"lemma-anchor para-title\"></a><a name=\"sub595350_4\" class=\"lemma-anchor \"></a><a name=\"数据类型\" class=\"lemma-anchor \"></a></div><div class=\"para-title level-2\" label-module=\"para-title\"></div></p><div class=\"para\" label-module=\"para\" style=\"text-align: start;\">目前（21世纪初期）主要的关系数据库管理系统支持某些形式的SQL，大部分数据库打算遵守ANSI SQL89标准。</div>', '2019-06-27 13:13:35', '数据库发展历史', 44);
INSERT INTO `article` VALUES (21, 2, '<div class=\"para\" label-module=\"para\"><b>桂林电子科技大学</b>（Guilin University Of Electronic Technology），<span class=\"sup--normal\" data-sup=\"1\" data-ctrmap=\":1,\"> [1]</span><a class=\"sup-anchor\" name=\"ref_[1]_40784\"> </a> 简称“<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E6%A1%82%E7%94%B5/7353159\" data-lemmaid=\"7353159\">桂电</a>”，坐落在世界著名的风景游览城市——<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E6%A1%82%E6%9E%97%E5%B8%82/10989247\" data-lemmaid=\"10989247\">桂林市</a>，由<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E5%B7%A5%E4%B8%9A%E5%92%8C%E4%BF%A1%E6%81%AF%E5%8C%96%E9%83%A8/835197\" data-lemmaid=\"835197\">工业和信息化部</a>、<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E5%9B%BD%E5%AE%B6%E5%9B%BD%E9%98%B2%E7%A7%91%E6%8A%80%E5%B7%A5%E4%B8%9A%E5%B1%80/4696487\" data-lemmaid=\"4696487\">国家国防科技工业局</a>与<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E5%B9%BF%E8%A5%BF%E5%A3%AE%E6%97%8F%E8%87%AA%E6%B2%BB%E5%8C%BA%E4%BA%BA%E6%B0%91%E6%94%BF%E5%BA%9C/8633217\" data-lemmaid=\"8633217\">广西壮族自治区人民政府</a>共建，<span class=\"sup--normal\" data-sup=\"2-3\" data-ctrmap=\":2,:3,\"> [2-3]</span><a class=\"sup-anchor\" name=\"ref_[2-3]_40784\"> </a> 首批<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E6%96%B0%E5%B7%A5%E7%A7%91%E7%A0%94%E7%A9%B6%E4%B8%8E%E5%AE%9E%E8%B7%B5%E9%A1%B9%E7%9B%AE/22833448\" data-lemmaid=\"22833448\">新工科研究与实践项目</a>、<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E4%B8%AD%E8%A5%BF%E9%83%A8%E9%AB%98%E6%A0%A1%E5%9F%BA%E7%A1%80%E8%83%BD%E5%8A%9B%E5%BB%BA%E8%AE%BE%E5%B7%A5%E7%A8%8B/6590386\" data-lemmaid=\"6590386\">中西部高校基础能力建设工程</a>重点建设高校，<span class=\"sup--normal\" data-sup=\"4\" data-ctrmap=\":4,\"> [4]</span><a class=\"sup-anchor\" name=\"ref_[4]_40784\"> </a> 入选教育部<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E5%8D%93%E8%B6%8A%E5%B7%A5%E7%A8%8B%E5%B8%88%E6%95%99%E8%82%B2%E5%9F%B9%E5%85%BB%E8%AE%A1%E5%88%92\">卓越工程师教育培养计划</a>、<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E6%B5%B7%E5%A4%96%E9%AB%98%E5%B1%82%E6%AC%A1%E4%BA%BA%E6%89%8D%E5%BC%95%E8%BF%9B%E8%AE%A1%E5%88%92/10102618\" data-lemmaid=\"10102618\">海外高层次人才引进计划</a>、<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E5%9B%BD%E5%AE%B6%E5%A4%A7%E5%AD%A6%E7%94%9F%E5%88%9B%E6%96%B0%E6%80%A7%E5%AE%9E%E9%AA%8C%E8%AE%A1%E5%88%92/5326077\" data-lemmaid=\"5326077\">国家大学生创新性实验计划</a>、<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E5%85%A8%E5%9B%BD%E6%B7%B1%E5%8C%96%E5%88%9B%E6%96%B0%E5%88%9B%E4%B8%9A%E6%95%99%E8%82%B2%E6%94%B9%E9%9D%A9%E7%A4%BA%E8%8C%83%E9%AB%98%E6%A0%A1/22051296\" data-lemmaid=\"22051296\">全国深化创新创业教育改革示范高校</a>、<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E5%9B%BD%E5%AE%B6%E5%A4%A7%E5%AD%A6%E7%94%9F%E6%96%87%E5%8C%96%E7%B4%A0%E8%B4%A8%E6%95%99%E8%82%B2%E5%9F%BA%E5%9C%B0/2680904\" data-lemmaid=\"2680904\">国家大学生文化素质教育基地</a>，<span class=\"sup--normal\" data-sup=\"5-6\" data-ctrmap=\":5,:6,\"> [5-6]</span><a class=\"sup-anchor\" name=\"ref_[5-6]_40784\"> </a> <a target=\"_blank\" href=\"https://baike.baidu.com/item//8962344\" data-lemmaid=\"8962344\"></a>是“<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E5%9B%BD%E5%AE%B6%E7%BA%A7%E7%89%B9%E8%89%B2%E4%B8%93%E4%B8%9A/3490017\" data-lemmaid=\"3490017\">国家级特色专业</a>”实施高校、首批高等学校科技成果转化和技术转移基地、国家<a target=\"_blank\" href=\"https://baike.baidu.com/item/973%E8%AE%A1%E5%88%92\">973计划</a>、<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E5%B9%BF%E8%A5%BF%E4%B8%80%E6%B5%81%E5%AD%A6%E7%A7%91%E5%BB%BA%E8%AE%BE%E9%AB%98%E6%A0%A1/22760440\" data-lemmaid=\"22760440\">广西一流学科建设高校</a>、有<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E5%9B%BD%E5%AE%B6%E5%A4%A7%E5%AD%A6%E7%A7%91%E6%8A%80%E5%9B%AD/9149021\" data-lemmaid=\"9149021\">国家大学科技园</a>，<span class=\"sup--normal\" data-sup=\"7-8\" data-ctrmap=\":7,:8,\"> [7-8]</span><a class=\"sup-anchor\" name=\"ref_[7-8]_40784\"> </a> 具有<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E8%87%AA%E4%B8%BB%E6%8B%9B%E7%94%9F/3901599\" data-lemmaid=\"3901599\">自主招生</a>资格，是<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E6%80%BB%E8%A3%85%E5%A4%87%E9%83%A8/1866411\" data-lemmaid=\"1866411\">总装备部</a>通信装备预研项目定向发布的30所高校之一和<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E5%8C%97%E6%96%97/12640773\" data-lemmaid=\"12640773\">北斗</a>ICD授权的高校之一。<span class=\"sup--normal\" data-sup=\"9\" data-ctrmap=\":9,\"> [9]</span><a class=\"sup-anchor\" name=\"ref_[9]_40784\"> </a></div><div class=\"para\" label-module=\"para\">学校始建于1960年，1980年经国务院批准成立<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E6%A1%82%E6%9E%97%E7%94%B5%E5%AD%90%E5%B7%A5%E4%B8%9A%E5%AD%A6%E9%99%A2/609178\" data-lemmaid=\"609178\">桂林电子工业学院</a>，2006年更名为桂林电子科技大学。学校先后隶属于<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E7%AC%AC%E5%9B%9B%E6%9C%BA%E6%A2%B0%E5%B7%A5%E4%B8%9A%E9%83%A8/19374517\" data-lemmaid=\"19374517\">第四机械工业部</a>、<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E7%94%B5%E5%AD%90%E5%B7%A5%E4%B8%9A%E9%83%A8/2124987\" data-lemmaid=\"2124987\">电子工业部</a>、<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E6%9C%BA%E6%A2%B0%E7%94%B5%E5%AD%90%E5%B7%A5%E4%B8%9A%E9%83%A8/22480638\" data-lemmaid=\"22480638\">机械电子工业部</a>、中国电子工业总公司、<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E4%BF%A1%E6%81%AF%E4%BA%A7%E4%B8%9A%E9%83%A8/2212317\" data-lemmaid=\"2212317\">信息产业部</a>。2000年管理体制转为中央与地方共建、以地方管理为主。2008年、2018年先后成为<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E5%B7%A5%E4%B8%9A%E5%92%8C%E4%BF%A1%E6%81%AF%E5%8C%96%E9%83%A8/835197\" data-lemmaid=\"835197\">工业和信息化部</a>与广西共建高校、<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E5%9B%BD%E5%AE%B6%E5%9B%BD%E9%98%B2%E7%A7%91%E6%8A%80%E5%B7%A5%E4%B8%9A%E5%B1%80/4696487\" data-lemmaid=\"4696487\">国家国防科技工业局</a>与广西共建高校。<span class=\"sup--normal\" data-sup=\"3\" data-ctrmap=\":3,:10,\"> [3]</span><a class=\"sup-anchor\" name=\"ref_[3]_40784\"> </a> <span class=\"sup--normal\" data-sup=\"10\" data-ctrmap=\":3,:10,\">[10]</span><a class=\"sup-anchor\" name=\"ref_[10]_40784\"> </a></div><div class=\"para\" label-module=\"para\">截至2018年9月，学校有金鸡岭校区、六合路校区、花江校区、北海校区，校园总面积4153亩；设有19个教学学院；有博士后科研流动站1个，一级学科<a target=\"_blank\" href=\"https://baike.baidu.com/item//1163652\" data-lemmaid=\"1163652\"></a>博士点4个，一级学科硕士点18个，硕士专业学位授权类别7个，本科专业65个；有教职工2900余人，全日制在校学生40600余人。<span class=\"sup--normal\" data-sup=\"10\" data-ctrmap=\":10,\"> [10]</span><a class=\"sup-anchor\" name=\"ref_[10]_40784\"> </a></div>', '2019-06-27 16:44:56', '桂林电子科技大学', 88);
INSERT INTO `article` VALUES (34, 1, '<p>测试内容</p><p>测试图片</p><p><img src=\"data:image/jpeg;base64,/9j/4AAQSkZJRgABAQEASABIAAD/2wBDAAwICQoJBwwKCQoNDAwOER0TERAQESMZGxUdKiUsKyklKCguNEI4LjE/MigoOk46P0RHSktKLTdRV1FIVkJJSkf/2wBDAQwNDREPESITEyJHMCgwR0dHR0dHR0dHR0dHR0dHR0dHR0dHR0dHR0dHR0dHR0dHR0dHR0dHR0dHR0dHR0dHR0f/wAARCAL7A+IDASIAAhEBAxEB/8QAGwABAAEFAQAAAAAAAAAAAAAAAAYBAgMFBwT/xABFEAEAAQIBBQwIBAUDBQEBAQAAAQIDBAURNHKxBhITITEzNlNzdJKyFBZRVXGBkdEVNUGTF1JUoaIiMmEHI0JiwSThZP/EABkBAQADAQEAAAAAAAAAAAAAAAABBAUCA//EACERAQACAgMBAQADAQAAAAAAAAABMQIEERNRMgMSISJB/9oADAMBAAIRAxEAPwDoYAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACscvzUVjl+YI/c5yrWnatXXOcq1p2rWVNtqKgAEgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAJCA1WIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAKxy/NRWOX5gj9znKtadq1dc5yrWnatZU22oqAASAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAkIDVYgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAArHL81FY5fmCP3Ocq1p2rV1znKtadq1lTbaioABIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACQgNViAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACscvzUVjl+YI/c5yrWnatXXOcq1p2rWVNtqKgAEgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAJCA1WIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAKxy/NRWOX5gj9znKtadq1dc5yrWnatZU22oqAASAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAkIDVYgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAArHL81FY5fmCP3Ocq1p2rV1znKtadq1lTbaioABIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACQgNViAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACscvzUVjl+YI/c5yrWnatXXOcq1p2rWVNtqKgAEgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAJCA1WIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAKxy/NRWOX5gj9znKtadq1dc5yrWnatZU22oqAASAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAkIDVYgAAAAAAAAAAAACy/ftYbD3L9+5TbtW6ZqrqqnNFMRyzILqqqaKaqq6opppjPMzOaIj2zP6IvlTd7kfBVTbw3CY65HFPA5ooidaeX5RKGbqt1WJy5fqs2Zqs4Cmf8ATaz5przf+Vftn2RyR8eNHpEJzc/6lYmap4LJdmKf0316qZ/tELf4lY33Zhv3akIATf8AiVjfdmG/dqP4lY33Zhv3akIATf8AiVjfdmG/dqP4lY33Zhv3akIATf8AiVjfdmG/dqP4lY33Zhv3akIATf8AiVjfdmG/dqP4lY33Zhv3akIATf8AiVjfdmG/dqP4lY33Zhv3akIATf8AiVjfdmG/dqP4lY33Zhv3akI+UnykE3/iVjfdmG/dqP4lY33Zhv3akI+UnykE3/iVjfdmG/dqP4lY33Zhv3akI5AE3/iVjfdmG/dqP4lY33Zhv3akIATf+JWN92Yb92o/iVjfdmG/dqQgBN/4lY33Zhv3aj+JWN92Yb92pCAE3/iVjfdmG/dqP4lY33Zhv3akIATf+JWN92Yb92pWj/qVit9HCZLsTT+u9vVRP94lBwHUsmbv8kYuqLeLpu4GueLPczVUeKOT5wlNuui5bpuW6qa6Koz01UzExMe2JjlcE/VvdzO6bF5BxMUxNV3BVT/3LEzxR7Zp9k/2n9faDsAw4PFWMbhLeKwtyLlm7TFVNUfrE7J/SY9rMJAAAAAAAAAAAAFY5fmorHL8wR+5zlWtO1auuc5VrTtWsqbbUVAAJAAAAAAAAAAAVooquVxRRGeqqeKI/UtEzx/cqREzVEUxMzM5oiIzzLYWMkYm7G+rzWo9k8c/2bTJ+T6MLRvqoiq7McdX/wAj/h7v0W8Pwjj/AEo/pszzxi1FOQaP1xFU/CmIV/ArfX1/SG2Hr04ePDv/AE9an8Ct9fX9IPwK319f0htg6cPDv/T1qfwK319f0g/ArfX1/SG2Dpw8O/8AT1qfwK319f0g/ArfX1/SG2Dpw8O/9PWp/ArfX1/SD8Ct9fX9IbYOnDw7/wBPWp/ArfX1/SD8Ct9fX9IbYOnDw7/09an8Ct9fX9IPwK319f0htg6cPDv/AE9an8Ct9fX9IPwK319f0htg6cPDv/T1qfwK319f0g/ArfX1/SG2Dpw8O/8AT1qfwK319f0g/ArfX1/SG2Dpw8O/9PWp/ArfX1/SD8Ct9fX9IbYOnDw7/wBPWp/ArfX1/SD8Ct9fX9IbYOnDw7/09an8Ct9fX9IPwK319f0htg6cPDv/AE9an8Ct9fX9IUqyDR+mIqj40xLbh04eJ7/09R2/kjE2o31Ga7Hsjin+7XzExVMVRMTE5piYzTCZS8OUMn0YqnfRmpuxHFV/8n/h45/hHHOL2/PannjJGxWuiq3XVRXGaqmeOPYoq8cL0Tz/AHAAJAAAAAAAAAASEBqsQAAAAAAAAAAAAQT/AKm5WqoosZIs1ZoriLt7NPLGfNTT9YmflCduO7tb9V/ddj5mc+8uRbj/AIimmI+4NIAIAAAAAAAAAAHixMXZvTMRVMcWbNnzPaA1u9u/y1/3N7d/lr/u2QHLW727/LX/AHN7d/lr/u2QHLw4em7F6mZiuIz8efPmzPcAPLXi5puzEUxNMTmnPPHL0xMTETH6xnYq8NbqrmqYmJmeOInilmjkAAAAAAAAAABO/wDplleqnEXskXqpmiuJu2c88lUf7oj4xx/KXQnFty1+cNunydcpnN/+immf+YqnNP8AaXac2biEgAAAAAAAAAAACscvzUVjl+YI/c5yrWnatXXOcq1p2rWVNtqKgAEgAAAAAAAAADcZBw2ffYiqM/8A40//AFp0nyXRFGT7MR+tMTPz43t+GMTkrbOUxhx69gC+zQAAAAAAAAAB5b0XJuTmiqY/TM9QDxb257Kv7m9ueyr+72gPFvbnsq/ub257Kv7vaA8lqLkXIzxVEfrneqVVAeeMRM18dMREzmz/AKrrl6aK97TGf2zK6LNEVb6In4Z+JWu1TXOec+f/AIkF1FUV0RV7VykRFMZo4ohUAAAAAAAAGky9hoje4imP/Wr/AONOk+U6IryfeiY5KZn6caMKP74xGXLS1spnDif+ADwWQAAAAAAAAAEhAarEAAAAAAAAAAAAJcX3V9K8p95qdolxfdX0ryn3moGqAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAPdkL8/yf3q35odwnln4uH5C/P8n96t+aHcJ5Z+IlQAAAAAAAAAAABWOX5qKxy/MEfuc5VrTtWrrnOVa07VrKm21FQACQAAAAAAAAABKsBoFjs42IqlWA0Cx2cbFnXuVPbqHpAXFAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAB5sfoF/s52IqlWP0C/2c7EVU9i4X9T5kAVlwAAAAAAAAABIQGqxAAAAAAAAAAAACXF91fSvKfeanaJcX3V9K8p95qBqZmI45mM3tY/SLOfnKV17ma9Wdj24S3bnCWpm3RMzRGeZphMRyh4PSLPWUnpFnrKW04K31dHhg4K31dHhhPA1fpFnrKT0iz1lLacFb6ujwwcFb6ujwwcDV+kWespPSLPWUtpwVvq6PDBwVvq6PDBwNX6RZ6yk9Is9ZS2nBW+ro8MHBW+ro8MHA1fpFnrKT0iz1lLacFb6ujwwcFb6ujwwcDV+kWespPSLPWUtpwVvq6PDBwVvq6PDBwNX6RZ6yk9Is9ZS2nBW+ro8MHBW+ro8MHA1fpFnrKT0iz1lLacFb6ujwwcFb6ujwwcDV+kWespPSLPWUtpwVvq6PDBwVvq6PDBwNX6RZ6yk9Is9ZS2nBW+ro8MHBW+ro8MHA1fpFnrKT0iz1lLacFb6ujwwcFb6ujwwcDV+kWespPSLPWUtpwVvq6PDBwVvq6PDBwNX6RZ6yk9Is9ZS2nBW+ro8MHBW+ro8MHA1fpFnrKT0iz1lLacFb6ujwwcFb6ujwwcDVxiLOfnKWXPnjPE54l6sTbtxhbsxbojNROaYpj2PDZ5i3qwiY4GyyF+f5P71b80O4Tyz8XD8hfn+T+9W/NDuE8s/FCVAAAAAAAAAAAAFY5fmorHL8wR+5zlWtO1auuc5VrTtWsqbbUVAAJAAAAAAAAAAEqwGgWOzjYiqVYDQLHZxsWde5U9uoZbldNq3VXcqimmmJmqqZzREf8y0M7udy8TmnLWH+Wf7Pbuq6J5W7le8kuH4S3RODszNFMzNEcc0x7F2I5UHY/Xvct75w3+X2PXvct75w3+X2ch4O31dHhg4O31dHhhPCOXXvXvct75w3+X2PXvct75w3+X2ch4O31dHhg4O31dHhg4OXXvXvct75w3+X2PXvct75w3+X2ch4O31dHhg4O31dHhg4OXXvXvct75w3+X2PXvct75w3+X2ch4O31dHhg4O31dHhg4OXXvXvct75w3+X2PXvct75w3+X2ch4O31dHhg4O31dHhg4OXXvXvct75w3+X2PXvct75w3+X2ch4O31dHhg4O31dHhg4OXXvXvct75w3+X2PXvct75w3+X2ch4O31dHhg4O31dHhg4OXXvXvct75w3+X2PXvct75w3+X2ch4O31dHhg4O31dHhg4OXXvXvct75w3+X2PXvct75w3+X2ch4O31dHhg4O31dHhg4OXXvXvct75w3+X2PXvct75w3+X2ch4O31dHhg4O31dHhg4OXXvXvct75w3+X2PXvct75w3+X2ch4O31dHhg4O31dHhg4OXXvXvct75w3+X2PXvct75w3+X2ch4O31dHhg4O31dHhg4OXXvXvct75w3+X2PXvct75w3+X2ch4O31dHhg4O31dHhg4OXXvXvct75w3+X2PXvct75w3+X2ch4O31dHhg4O31dHhg4OXXfXrcvM8WWcP8999m+tXKL1mi7aqiu3XTFVNVM54qieOJcAxNuiMNdmKKYmKJzTFMex2ncX0MyR3O35YRMENlj9Av8AZzsRVKsoaBf7OdiKqWxcNDU+ZAFZcAAAAAAAAAASEBqsQAAAAAAAAAAAAlxfdX0ryn3mp2iXF91fSvKfeagae9zNerOx78HoVnUjY8F7ma9Wdj34PQrOpGxONoZQHQAAAAAAAAAAAAAAAAAAAAAAAAAAxYrRbupOxr7PMW9WGwxWi3dSdjX2eYt6sIkhsshfn+T+9W/NDuE8s/Fw/IX5/k/vVvzQ7hPLPxcpUAAAAAAAAAAAAVjl+aiscvzBH7nOVa07Vq65zlWtO1aypttRUAAkAAAAAAAAAASrAaBY7ONiKpVgNAsdnGxZ17lT26h491XRPK3cr3klxDB6FZ7ONjt+6ronlbuV7yS4hg9Cs9nGxdxtnyzAOgAAAAAAAAAAAAAAAAAAAAAAAAABjxOi3dSdjs+4voXkjudvyw4xidFu6k7HZ9xfQvJHc7flhEkNllDQL/ZzsRVKsoaBf7OdiKqOxcNDU+ZAFZcAAAAAAAAAASEBqsQAAAAAAAAAAAAlxfdX0ryn3mp2iXF91fSvKfeagae9zNerOx78HoVnUjY8F7ma9Wdj34PQrOpGxONoZQHQAAAAAAAAAAAAAAAAAAAAAAAAAAxYrRbupOxr7PMW9WGwxWi3dSdjX2eYt6sIkhsshfn+T+9W/NDuE8s/Fw/IX5/k/vVvzQ7hPLPxcpUAAAAAAAAAAAAVjl+aiscvzBH7nOVa07Vq65zlWtO1aypttRUAAkAAAAAAAAAASrAaBY7ONiKpVgNAsdnGxZ17lT26h491XRPK3cr3klxDB6FZ7ONjt+6ronlbuV7yS4hg9Cs9nGxdxtnyzAOgAAAAAAAAAAAAAAAAAAAAAAAAABjxOi3dSdjs+4voXkjudvyw4xidFu6k7HZ9xfQvJHc7flhEkNllDQL/AGc7EVSrKGgX+znYiqjsXDQ1PmQBWXAAAAAAAAAAEhAarEAAAAAAAAAAAAJcX3V9K8p95qdolxfdX0ryn3moGnvczXqzse/B6FZ1I2PBe5mvVnY9+D0KzqRsTjaGUB0AAAAAAAAAAAAAAAAAAAAAAAAAAMWK0W7qTsa+zzFvVhsMVot3UnY19nmLerCJIbLIX5/k/vVvzQ7hPLPxcPyF+f5P71b80O4Tyz8XKVAAAAAAAAAAAAFY5fmorHL8wR+5zlWtO1auuc5VrTtWsqbbUVAAJAAAAAAAAAAEqwGgWOzjYiqVYDQLHZxsWde5U9uoePdV0Tyt3K95JcQwehWezjY7fuq6J5W7le8kuIYPQrPZxsXcbZ8swDoAAAAAAAAAAAAAAAAAAAAAAAAAAY8Tot3UnY7PuL6F5I7nb8sOMYnRbupOx2fcX0LyR3O35YRJDZZQ0C/2c7EVSrKGgX+znYiqjsXDQ1PmQBWXAAAAAAAAAAEhAarEAAAAAAAAAAAAJcX3V9K8p95qdolxfdX0ryn3moGnvczXqzse/B6FZ1I2PBe5mvVnY9+D0KzqRsTjaGUB0AAAAAAAAAAAAAAAAAAAAAAAAAAMWK0W7qTsa+zzFvVhsMVot3UnY19nmLerCJIbLIX5/k/vVvzQ7hPLPxcPyF+f5P71b80O4Tyz8XKVAAAAAAAAAAAAFY5fmorHL8wR+5zlWtO1auuc5VrTtWsqbbUVAAJAAAAAAAAAAEqwGgWOzjYiqVYDQLHZxsWde5U9uoePdV0Tyt3K95JcQwehWezjY7fuq6J5W7le8kuIYPQrPZxsXcbZ8swDoAAAAAAAAAAAAAAAAAAAAAAAAAAY8Tot3UnY7PuL6F5I7nb8sOMYnRbupOx2fcX0LyR3O35YRJDZZQ0C/wBnOxFUqyhoF/s52Iqo7Fw0NT5kAVlwAAAAAAAAABIQGqxAAAAAAAAAAAACXF91fSvKfeanaJcX3V9K8p95qBp73M16s7HvwehWdSNjwXuZr1Z2Pfg9Cs6kbE42hlAdAAAAAAAAAAAAAAAAAAAAAAAAAADFitFu6k7Gvs8xb1YbDFaLd1J2NfZ5i3qwiSGyyF+f5P71b80O4Tyz8XD8hfn+T+9W/NDuE8s/FylQAAAAAAAAAAABWOX5qKxy/MEfuc5VrTtWrrnOVa07VrKm21FQACQAAAAAAAAABKsBoFjs42IqlWA0Cx2cbFnXuVPbqHj3VdE8rdyveSXEMHoVns42O37quieVu5XvJLiGD0Kz2cbF3G2fLMA6AAAAAAAAAAAAAAAAAAAAAAAAAAGPE6Ld1J2Oz7i+heSO52/LDjGJ0W7qTsdn3F9C8kdzt+WESQ2WUNAv9nOxFUqyhoF/s52Iqo7Fw0NT5kAVlwAAAAAAAAABIQGqxAAAAAAAAAAAACXF91fSvKfeanaJcX3V9K8p95qBp73M16s7HvwehWdSNjwXuZr1Z2Pfg9Cs6kbE42hlAdAAAAAAAAAAAAAAAAAAAAAAAAAADFitFu6k7Gvs8xb1YbDFaLd1J2NfZ5i3qwiSGyyF+f5P71b80O4Tyz8XD8hfn+T+9W/NDuE8s/FylQAAAAAAAAAAABWOX5qKxy/MEfuc5VrTtWrrnOVa07VrKm21FQACQAAAAAAAAABKsBoFjs42IqlWA0Cx2cbFnXuVPbqHj3VdE8rdyveSXEMHoVns42O37quieVu5XvJLiGD0Kz2cbF3G2fLMA6AAAAAAAAAAAAAAAAAAAAAAAAAAGPE6Ld1J2Oz7i+heSO52/LDjGJ0W7qTsdn3F9C8kdzt+WESQ2WUNAv8AZzsRVKsoaBf7OdiKqOxcNDU+ZAFZcAAAAAAAAAASEBqsQAAAAAAAAAAAAlxfdX0ryn3mp2iXF91fSvKfeagae9zNerOx78HoVnUjY8F7ma9Wdj34PQrOpGxONoZQHQAAAAAAAAAAAAAAAAAAAAAAAAAAxYrRbupOxr7PMW9WGwxWi3dSdjX2eYt6sIkhsshfn+T+9W/NDuE8s/Fw/IX5/k/vVvzQ7hPLPxcpUAAAAAAAAAAAAVjl+aiscvzBH7nOVa07Vq65zlWtO1aypttRUAAkAAAAAAAAAASrAaBY7ONiKpVgNAsdnGxZ17lT26h491XRPK3cr3klxDB6FZ7ONjt+6ronlbuV7yS4hg9Cs9nGxdxtnyzAOgAAAAAAAAAAAAAAAAAAAAAAAAABjxOi3dSdjs+4voXkjudvyw4xidFu6k7HZ9xfQvJHc7flhEkNllDQL/ZzsRVKsoaBf7OdiKqOxcNDU+ZAFZcAAAAAAAAAASEBqsQAAAAAAAAAAAAlxfdX0ryn3mp2iXF91fSvKfeagae9zNerOx78HoVnUjY8F7ma9Wdj34PQrOpGxONoZQHQAAAAAAAAAAAAAAAAAAAAAAAAAAxYrRbupOxr7PMW9WGwxWi3dSdjX2eYt6sIkhsshfn+T+9W/NDuE8s/Fw/IX5/k/vVvzQ7hPLPxcpUAAAAAAAAAAAAVjl+aiscvzBH7nOVa07Vq65zlWtO1aypttRUAAkAAAAAAAAAASrAaBY7ONiKpVgNAsdnGxZ17lT26h491XRPK3cr3klxDB6FZ7ONjt+6ronlbuV7yS4hg9Cs9nGxdxtnyzAOgAAAAAAAAAAAAAAAAAAAAAAAAABjxOi3dSdjs+4voXkjudvyw4xidFu6k7HZ9xfQvJHc7flhEkNllDQL/AGc7EVSrKGgX+znYiqjsXDQ1PmQBWXAAAAAAAAAAEhAarEAAAAAAAAAAAAJcX3V9K8p95qdolxfdX0ryn3moGnvczXqzse/B6FZ1I2PBe5mvVnY9+D0KzqRsTjaGUB0AAAAAAAAAAAAAAAAAAAAAAAAAAMWK0W7qTsa+zzFvVhsMVot3UnY19nmLerCJIbLIX5/k/vVvzQ7hPLPxcPyF+f5P71b80O4Tyz8XKVAAAAAAAAAAAAFY5fmorHL8wR+5zlWtO1auuc5VrTtWsqbbUVAAJAAAAAAAAAAEqwGgWOzjYiqVYDQLHZxsWde5U9uoePdV0Tyt3K95JcQwehWezjY7fuq6J5W7le8kuIYPQrPZxsXcbZ8swDoAAAAAAAAAAAAAAAAAAAAAAAAAAY8Tot3UnY7PuL6F5I7nb8sOMYnRbupOx2fcX0LyR3O35YRJDZZQ0C/2c7EVSrKGgX+znYiqjsXDQ1PmQBWXAAAAAAAAAAEhAarEAAAAAAAAAAAAJcX3V9K8p95qdolxfdX0ryn3moGnvczXqzse/B6FZ1I2PBe5mvVnY9+D0KzqRsTjaGUB0AAAAAAAAAAAAAAAAAAAAAAAAAAMWK0W7qTsa+zzFvVhsMVot3UnY19nmLerCJIbLIX5/k/vVvzQ7hPLPxcPyF+f5P71b80O4Tyz8XKVAAAAAAAAAAAAFY5fmorHL8wR+5zlWtO1auuc5VrTtWsqbbUVAAJAAAAAAAAAAEqwGgWOzjYiqVYDQLHZxsWde5U9uoePdV0Tyt3K95JcQwehWezjY7fuq6J5W7le8kuIYPQrPZxsXcbZ8swDoAAAAAAAAAAAAAAAAAAAAAAAAAAY8Tot3UnY7PuL6F5I7nb8sOMYnRbupOx2fcX0LyR3O35YRJDZZQ0C/wBnOxFUqyhoF/s52Iqo7Fw0NT5kAVlwAAAAAAAAABIQGqxAAAAAAAAAAAACXF91fSvKfeanaJcX3V9K8p95qBp73M16s7HvwehWdSNjwXuZr1Z2Pfg9Cs6kbE42hlAdAAAAAAAAAAAAAAAAAAAAAAAAAADFitFu6k7Gvs8xb1YbDFaLd1J2NfZ5i3qwiSGyyF+f5P71b80O4Tyz8XD8hfn+T+9W/NDuE8s/FylQAAAAAAAAAAABWOX5qKxy/MEfuc5VrTtWrrnOVa07VrKm21FQACQAAAAAAAAABKsBoFjs42IqlWA0Cx2cbFnXuVPbqHj3VdE8rdyveSXEMHoVns42O37quieVu5XvJLiGD0Kz2cbF3G2fLMA6AAAAAAAAAAAAAAAAAAAAAAAAAAGPE6Ld1J2Oz7i+heSO52/LDjGJ0W7qTsdn3F9C8kdzt+WESQ2WUNAv9nOxFUqyhoF/s52Iqo7Fw0NT5kAVlwAAAAAAAAABIQGqxAAAAAAAAAAAACXF91fSvKfeanaJcX3V9K8p95qBp73M16s7HvwehWdSNjwXuZr1Z2Pfg9Cs6kbE42hlAdAAAAAAAAAAAAAAAAAAAAAAAAAADFitFu6k7Gvs8xb1YbDFaLd1J2NfZ5i3qwiSGyyF+f5P71b80O4Tyz8XD8hfn+T+9W/NDuE8s/FylQAAAAAAAAAAABWOX5qKxy/MEfuc5VrTtWrrnOVa07VrKm21FQACQAAAAAAAAABKsBoFjs42IqlWA0Cx2cbFnXuVPbqHj3VdE8rdyveSXEMHoVns42O37quieVu5XvJLiGD0Kz2cbF3G2fLMA6AAAAAAAAAAAAAAAAAAAAAAAAAAGPE6Ld1J2Oz7i+heSO52/LDjGJ0W7qTsdn3F9C8kdzt+WESQ2WUNAv8AZzsRVKsoaBf7OdiKqOxcNDU+ZAFZcAAAAAAAAAASEBqsQAAAAAAAAAAAAlxfdX0ryn3mp2iXF91fSvKfeagae9zNerOx78HoVnUjY8F7ma9Wdj34PQrOpGxONoZQHQAAAAAAAAAAAAAAAAAAAAAAAAAAxYrRbupOxr7PMW9WGwxWi3dSdjX2eYt6sIkhsshfn+T+9W/NDuE8s/Fw/IX5/k/vVvzQ7hPLPxcpUAAAAAAAAAAAAVjl+aiscvzBH7nOVa07Vq65zlWtO1aypttRUAAkAAAAAAAAAASrAaBY7ONiKpVgNAsdnGxZ17lT26h491XRPK3cr3klxDB6FZ7ONjt+6ronlbuV7yS4hg9Cs9nGxdxtnyzAOgAAAAAAAAAAAAAAAAAAAAAAAAABjxOi3dSdjs+4voXkjudvyw4xidFu6k7HZ9xfQvJHc7flhEkNllDQL/ZzsRVKsoaBf7OdiKqOxcNDU+ZAFZcAAAAAAAAAASEBqsQAAAAAAAAAAAAlxfdX0ryn3mp2iXF91fSvKfeagae9zNerOx78HoVnUjY8F7ma9Wdj34PQrOpGxONoZQHQAAAAAAAAAAAAAAAAAAAAAAAAAAxYrRbupOxr7PMW9WGwxWi3dSdjX2eYt6sIkhsshfn+T+9W/NDuE8s/Fw/IX5/k/vVvzQ7hPLPxcpUAAAAAAAAAAAAVjl+aiscvzBH7nOVa07Vq65zlWtO1aypttRUAAkAAAAAAAAAASrAaBY7ONiKpVgNAsdnGxZ17lT26h491XRPK3cr3klxDB6FZ7ONjt+6ronlbuV7yS4hg9Cs9nGxdxtnyzAOgAAAAAAAAAAAAAAAAAAAAAAAAABjxOi3dSdjs+4voXkjudvyw4xidFu6k7HZ9xfQvJHc7flhEkNllDQL/AGc7EVSrKGgX+znYiqjsXDQ1PmQBWXAAAAAAAAAAEhAarEAAAAAAAAAAAAJcX3V9K8p95qdolxfdX0ryn3moGnvczXqzse/B6FZ1I2PBe5mvVnY9+D0KzqRsTjaGUB0AAAAAAAAAAAAAAAAAAAAAAAAAAMWK0W7qTsa+zzFvVhsMVot3UnY19nmLerCJIbLIX5/k/vVvzQ7hPLPxcPyF+f5P71b80O4Tyz8XKVAAAAAAAAAAAAFY5fmorHL8wR+5zlWtO1auuc5VrTtWsqbbUVAAJAAAAAAAAAAEqwGgWOzjYiqVYDQLHZxsWde5U9uoePdV0Tyt3K95JcQwehWezjY7fuq6J5W7le8kuIYPQrPZxsXcbZ8swDoAAAAAAAAAAAAAAAAAAAAAAAAAAY8Tot3UnY7PuL6F5I7nb8sOMYnRbupOx2fcX0LyR3O35YRJDZZQ0C/2c7EVSrKGgX+znYiqjsXDQ1PmQBWXAAAAAAAAAAEhAarEAAAAAAAAAAAAJcX3V9K8p95qdolxfdX0ryn3moGnvczXqzse/B6FZ1I2PBe5mvVnY9+D0KzqRsTjaGUB0AAAAAAAAAAAAAAAAAAAAAAAAAAMWK0W7qTsa+zzFvVhsMVot3UnY19nmLerCJIbLIX5/k/vVvzQ7hPLPxcPyF+f5P71b80O4Tyz8XKVAAAAAAAAAAAAFY5fmorHL8wR+5zlWtO1auuc5VrTtWsqbbUVAAJAAAAAAAAAAEqwGgWOzjYiqVYDQLHZxsWde5U9uoePdV0Tyt3K95JcQwehWezjY7fuq6J5W7le8kuIYPQrPZxsXcbZ8swDoAAAAAAAAAAAAAAAAAAAAAAAAAAY8Tot3UnY7PuL6F5I7nb8sOMYnRbupOx2fcX0LyR3O35YRJDZZQ0C/wBnOxFUqyhoF/s52Iqo7Fw0NT5kAVlwAAAAAAAAABIQGqxAAAAAAAAAAAACXF91fSvKfeanaJcX3V9K8p95qBp73M16s7HvwehWdSNjwXuZr1Z2Pfg9Cs6kbE42hlAdAAAAAAAAAAAAAAAAAAAAAAAAAADFitFu6k7Gvs8xb1YbDFaLd1J2NfZ5i3qwiSGyyF+f5P71b80O4Tyz8XD8hfn+T+9W/NDuE8s/FylQAAAAAAAAAAABWOX5qKxy/MEfuc5VrTtWrrnOVa07VrKm21FQACQAAAAAAAAABKsBoFjs42IqlWA0Cx2cbFnXuVPbqHj3VdE8rdyveSXEMHoVns42O37quieVu5XvJLiGD0Kz2cbF3G2fLMA6AAAAAAAAAAAAAAAAAAAAAAAAAAGPE6Ld1J2Oz7i+heSO52/LDjGJ0W7qTsdn3F9C8kdzt+WESQ2WUNAv9nOxFUqyhoF/s52Iqo7Fw0NT5kAVlwAAAAAAAAABIQGqxAAAAAAAAAAAACXF91fSvKfeanaJcX3V9K8p95qBp73M16s7HvwehWdSNjwXuZr1Z2Pfg9Cs6kbE42hlAdAAAAAAAAAAAAAAAAAAAAAAAAAADFitFu6k7Gvs8xb1YbDFaLd1J2NfZ5i3qwiSGyyF+f5P71b80O4Tyz8XD8hfn+T+9W/NDuE8s/FylQAAAAAAAAAAABWOX5qKxy/MEfuc5VrTtWrrnOVa07VrKm21FQACQAAAAAAAAABKsBoFjs42IqlWA0Cx2cbFnXuVPbqHj3VdE8rdyveSXEMHoVns42O37quieVu5XvJLiGD0Kz2cbF3G2fLMA6AAAAAAAAAAAAAAAAAAAAAAAAAAGPE6Ld1J2Oz7i+heSO52/LDjGJ0W7qTsdn3F9C8kdzt+WESQ2WUNAv8AZzsRVKsoaBf7OdiKqOxcNDU+ZAFZcAAAAAAAAAASEBqsQAAAAAAAAAAAAlxfdX0ryn3mp2iXF91fSvKfeagae9zNerOx78HoVnUjY8F7ma9Wdj34PQrOpGxONoZQHQAAAAAAAAAAAAAAAAAAAAAAAAAAxYrRbupOxr7PMW9WGwxWi3dSdjX2eYt6sIkhsshfn+T+9W/NDuE8s/Fw/IX5/k/vVvzQ7hPLPxcpUAAAAAAAAAAAAVjl+aiscvzBH7nOVa07Vq65zlWtO1aypttRUAAkAAAAAAAAAASrAaBY7ONiKpVgNAsdnGxZ17lT26h491XRPK3cr3klxDB6FZ7ONjt+6ronlbuV7yS4hg9Cs9nGxdxtnyzAOgAAAAAAAAAAAAAAAAAAAAAAAAABjxOi3dSdjs+4voXkjudvyw4xidFu6k7HZ9xfQvJHc7flhEkNllDQL/ZzsRVKsoaBf7OdiKqOxcNDU+ZAFZcAAAAAAAAAASEBqsQAAAAAAAAAAAAlxfdX0ryn3mp2iXF91fSvKfeagae9zNerOx78HoVnUjY8F7ma9Wdj34PQrOpGxONoZQHQAAAAAAAAAAAAAAAAAAAAAAAAAAxYrRbupOxr7PMW9WGwxWi3dSdjX2eYt6sIkhsshfn+T+9W/NDuE8s/Fw/IX5/k/vVvzQ7hPLPxcpUAAAAAAAAAAAAVjl+aiscvzBH7nOVa07Vq65zlWtO1aypttRUAAkAAAAAAAAAASrAaBY7ONiKpVgNAsdnGxZ17lT26h491XRPK3cr3klxDB6FZ7ONjt+6ronlbuV7yS4hg9Cs9nGxdxtnyzAOgAAAAAAAAAAAAAAAAAAAAAAAAABjxOi3dSdjs+4voXkjudvyw4xidFu6k7HZ9xfQvJHc7flhEkNllDQL/AGc7EVSrKGgX+znYiqjsXDQ1PmQBWXAAAAAAAAAAEhAarEAAAAAAAAAAAAJcX3V9K8p95qdolxfdX0ryn3moGnvczXqzse/B6FZ1I2PBe5mvVnY9+D0KzqRsTjaGUB0AAAAAAAAAAAAAAAAAAAAAAAAAAMWK0W7qTsa+zzFvVhsMVot3UnY19nmLerCJIbLIX5/k/vVvzQ7hPLPxcPyF+f5P71b80O4Tyz8XKVAAAAAAAAAAAAFY5fmorHL8wR+5zlWtO1auuc5VrTtWsqbbUVAAJAAAAAAAAAAEqwGgWOzjYiqVYDQLHZxsWde5U9uoePdV0Tyt3K95JcQwehWezjY7fuq6J5W7le8kuIYPQrPZxsXcbZ8swDoAAAAAAAAAAAAAAAAAAAAAAAAAAY8Tot3UnY7PuL6F5I7nb8sOMYnRbupOx2fcX0LyR3O35YRJDZZQ0C/2c7EVSrKGgX+znYiqjsXDQ1PmQBWXAAAAAAAAAAEhAarEAAAAAAAAAAAAJcX3V9K8p95qdolxfdX0ryn3moGnvczXqzse/B6FZ1I2PBe5mvVnY9+D0KzqRsTjaGUB0AAAAAAAAAAAAAAAAAAAAAAAAAAMWK0W7qTsa+zzFvVhsMVot3UnY19nmLerCJIbLIX5/k/vVvzQ7hPLPxcPyF+f5P71b80O4Tyz8XKVAAAAAAAAAAAAFY5fmorHL8wR+5zlWtO1auuc5VrTtWsqbbUVAAJAAAAAAAAAAEqwGgWOzjYiqVYDQLHZxsWde5U9uoePdV0Tyt3K95JcQwehWezjY7fuq6J5W7le8kuIYPQrPZxsXcbZ8swDoAAAAAAAAAAAAAAAAAAAAAAAAAAY8Tot3UnY7PuL6F5I7nb8sOMYnRbupOx2fcX0LyR3O35YRJDZZQ0C/wBnOxFUqyhoF/s52Iqo7Fw0NT5kAVlwAAAAAAAAABIQGqxAAAAAAAAAAAACXF91fSvKfeanaJcX3V9K8p95qBp73M16s7HvwehWdSNjwXuZr1Z2Pfg9Cs6kbE42hlAdAAAAAAAAAAAAAAAAAAAAAAAAAADFitFu6k7Gvs8xb1YbDFaLd1J2NfZ5i3qwiSGyyF+f5P71b80O4Tyz8XD8hfn+T+9W/NDuE8s/FylQAAAAAAAAAAABWOX5qKxy/MEfuc5VrTtWrrnOVa07VrKm21FQACQAAAAAAAAABKsBoFjs42IqlWA0Cx2cbFnXuVPbqHj3VdE8rdyveSXEMHoVns42O37quieVu5XvJLiGD0Kz2cbF3G2fLMA6AAAAAAAAAAAAAAAAAAAAAAAAAAGPE6Ld1J2Oz7i+heSO52/LDjGJ0W7qTsdn3F9C8kdzt+WESQ2WUNAv9nOxFUqyhoF/s52Iqo7Fw0NT5kAVlwAAAAAAAAABIQGqxAAAAAAAAAAAACXF91fSvKfeanaJcX3V9K8p95qBp73M16s7HvwehWdSNjwXuZr1Z2Pfg9Cs6kbE42hlAdAAAAAAAAAAAAAAAAAAAAAAAAAADFitFu6k7Gvs8xb1YbDFaLd1J2NfZ5i3qwiSGyyF+f5P71b80O4Tyz8XD8hfn+T+9W/NDuE8s/FylQAAAAAAAAAAABWOX5qKxy/MEfuc5VrTtWrrnOVa07VrKm21FQACQAAAAAAAAABKsBoFjs42IqlWA0Cx2cbFnXuVPbqHj3VdE8rdyveSXEMHoVns42O37quieVu5XvJLiGD0Kz2cbF3G2fLMA6AAAAAAAAAAAAAAAAAAAAAAAAAAGPE6Ld1J2Oz7i+heSO52/LDjGJ0W7qTsdn3F9C8kdzt+WESQ2WUNAv8AZzsRVKsoaBf7OdiKqOxcNDU+ZAFZcAAAAAAAAAASEBqsQAAAAAAAAAAAAlxfdX0ryn3mp2iXF91fSvKfeagae9zNerOx78HoVnUjY8F7ma9Wdj34PQrOpGxONoZQHQAAAAAAAAAAAAAAAAAAAAAAAAAAxYrRbupOxr7PMW9WGwxWi3dSdjX2eYt6sIkhsshfn+T+9W/NDuE8s/Fw/IX5/k/vVvzQ7hPLPxcpUAAAAAAAAAAAAVjl+aiscvzBH7nOVa07Vq65zlWtO1aypttRUAAkAAAAAAAAAASrAaBY7ONiKpVgNAsdnGxZ17lT26h491XRPK3cr3klxDB6FZ7ONjt+6ronlbuV7yS4hg9Cs9nGxdxtnyzAOgAAAAAAAAAAAAAAAAAAAAAAAAABjxOi3dSdjs+4voXkjudvyw4xidFu6k7HZ9xfQvJHc7flhEkNllDQL/ZzsRVKsoaBf7OdiKqOxcNDU+ZAFZcAAAAAAAAAASEBqsQAAAAAAAAAAAAlxfdX0ryn3mp2iXF91fSvKfeagae9zNerOx78HoVnUjY8F7ma9Wdj2YS7bjCWom5RExRETE1QmLQ9As4W11tHig4W11tHih0LxZwtrraPFBwtrraPFALxZwtrraPFBwtrraPFALxZwtrraPFBwtrraPFALxZwtrraPFBwtrraPFALxZwtrraPFBwtrraPFALxZwtrraPFBwtrraPFALxZwtrraPFBwtrraPFALxZwtrraPFBwtrraPFALxZwtrraPFBwtrraPFALxZwtrraPFBwtrraPFALxZwtrraPFBwtrraPFALxZwtrraPFBwtrraPFALxZwtrraPFBwtrraPFALcVot3UnY19nmLerD3Ym7bnDXIi5RMzROaIqj2PDZ5i3qw5khsshfn+T+9W/NDuE8s/Fw/IX5/k/vVvzQ7hPLPxQlQAAAAAAAAAAABWOX5qKxy/MEfuc5VrTtWrrnOVa07VrKm21FQACQAAAAAAAAABKsBoFjs42IqlWA0Cx2cbFnXuVPbqHj3VdE8rdyveSXEMHoVns42O37quieVo/8A8V7yS4dhLluMHZiblETFEZ4mqPYuwz5egW8Lb6yjxQcLb6yjxQ6Fwt4W31lHig4W31lHigFwt4W31lHig4W31lHigFwt4W31lHig4W31lHigFwt4W31lHig4W31lHigFwt4W31lHig4W31lHigFwt4W31lHig4W31lHigFwt4W31lHig4W31lHigFwt4W31lHig4W31lHigFwt4W31lHig4W31lHigFwt4W31lHig4W31lHigFwt4W31lHig4W31lHigFwt4W31lHig4W31lHigFwt4W31lHig4W31lHigFuJ0W7qTsdn3F9C8kdzt+WHFcRctzhrsRcomZpnNEVR7HatxfQzJHc7flhzJDZZQ0C/wBnOxFUqyhoF/s52IqpbFw0NT5kAVlwAAAAAAAAABIQGqxAAAAAAAAAAAACXF91fSvKfeanaJcX3V9K8p95qBqZ44zTDH6PZ6un6MoIY/R7XV0/Q9HtdXT9GQBj9HtdXT9D0e11dP0ZAGP0e11dP0PR7XV0/RkmYjlmI+Mqb+n+an6wCz0e11dP0PR7XV0/RkAY/R7XV0/Q9HtdXT9GQBj9HtdXT9D0e11dP0Vu3abVOerjmeKIj9XnnGzn5uPqDP6Pa6un6Ho9rq6fowemz1cfU9Nnq4+oM/o9rq6foej2urp+jB6bPVx9T02erj6gz+j2urp+h6Pa6un6MHps9XH1Z7N6m9TM0xmmOWJ/QD0e11dP0PR7XV0/RkAY/R7XV0/Q9HtdXT9GQBj9HtdXT9D0e11dP0ZOLj/SFM8TGeJz/wDMAs9HtdXT9D0e11dP0ZAGP0e11dP0PR7XV0/RkAY/R7Wfm6foviIiM0RmiFQHuyF+f5P71b80O4Tyz8XD8hfn+T+9W/NDuE8s/ESoAAAAAAAAAAAArHL81FY5fmCP3Ocq1p2rV1znKtadq1lTbaioABIAAAAAAAAAAlWA0Cx2cbEVSrAaBY7ONizr3Knt1DLXRTcoqouUxVRVGaYmM8TH/LRzuJ3MTOeci4TwzH/1IBcUEf8AUjcv7lwvhn7nqRuX9y4Xwz90gAR/1I3L+5cL4Z+56kbl/cuF8M/dIAEf9SNy/uXC+GfuepG5f3LhfDP3b6ZiOWY+pvo5M8fUGh9SNy/uXC+GfuepG5f3LhfDP3SABH/Ujcv7lwvhn7nqRuX9y4Xwz90gAR/1I3L+5cL4Z+56kbl/cuF8M/dvblyLcZ55f0hh9Jn+T+4NR6kbl/cuF8M/c9SNy/uXC+Gfu3HpP/p/c9J/9P7g0/qRuX9y4Xwz9z1I3L+5cL4Z+7cek/8Ap/c9J/8AT+4NP6kbl/cuF8M/c9SNy/uXC+Gfu2/pM/yf3ZrdyLkcX6coNF6kbl/cuF8M/c9SNy/uXC+GfukACP8AqRuX9y4Xwz9z1I3L+5cL4Z+6QAI/6kbl/cuF8M/c9SNy/uXC+Gfu38zERnzqgj/qRuX9y4Xwz9z1I3L+5cL4Z+6QAI/6kbl/cuF8M/c9SNy/uXC+GfukACPepO5iOOMi4Xwz928tW6LNqm3appooopiKaYjNERHJGZlAebH6Bf7OdiKpVj9Av9nOxFVPYuF/U+ZAFZcAAAAAAAAAASEBqsQAAAAAAAAAAAAlxfdXxbq8qZ/6mr/47Q5Ju/wlWF3WYmqYzUYiKb1M+3PGaf7xII6AIAAD9QBhpom7TFVVVU8cxyRxcfwW3LcU8nHnpq/SPZ8GXgrc55miM88atNuimc9NMR/yCtPFEfCFQAAB48dn39PLmzTteZsb1qm7Tmq4s3JMfowehT1kfQS8o9XoU9ZH0PQp6yPoDyj1ehT1kfQ9CnrI+gPK9GBz8LVy/wC3/wCrvQpz85H0Z7NmmzGamZmZ5ZkQyAAAAxX7XCRmm5NP/GfilSmiKLeabtUTEcsVcX0Zaqaav91MTm9sZ1ODtxOeKKc/wgFbczVbpmqM0zETKoAAAAA92Q4mcv5Ozf1NvzQ7hPLPxcc3F4ScZurwNMRnptXOGq/4imM+3NHzdiEgAAAAAAAAAAACscvzUVjl+YI/c5yrWnatXXOcq1p2rWVNtqKgAEgAAAAAAAAACVZP0GxqRsRVJMj3IuZOt8fHR/pn5LGvP+uFPaif4xL3gLqgAAKTyTKqgMcUb6mJmqZnN7I+yk0xFWbl5P0j2r+Do5N7CsU008dMRALgAAAeXFf74+DC9ty3FyM08U/pLD6Nx/7v7AwD0ejf+/8AY9G/9/7A849Ho3/v/Y9G/wDf+wPOzYX/AHz8F3o3/v8A2ZbduLcZo45/WQXgAAAw3be/n/fm/wCP0Vq/0054rmZ/5nOvmmmeOYiSKaY497EfIFwAAAAAPNj9Av6k7EVSTK9yLeTrntq/0x80bUtif9RC/qxP8ZkAV1wAAAAAAAAABIQGqxAAAAAAAAAAAABF932Q6sq5KpxWGomrE4TPVFMRnmuif90R/wAxmzx8J9qUZzPEfqDgX6e0dD3WbiYxN2vHZFimm5VM1XMNniIqn9ZonkiZ/WOT2ZuRz+/Yu4e9VZxFqu1dpnNNFdM0zHykQsAAAAAAAAAAAAAAAAAAAAAAAAAAAAM6+1buXrtNqzbquXKpzRTRE1TM/wDERxp1uV3D1U3beNy5TTG9mKreFmc+ef0mv9Pl9fYDY/8ATvIdWBwFeUcTRNN/FREW6ZjNNNvlif8AiZnj+EQl6meFRIAAAAAAAAAAAArHL81FY5fmCP3Ocq1p2rV1znKtadq1lTbaioABIAAAAAAAAAA2GRsXFi/Nquc1FyY+ET//AH7NeTMfq6xynGeXGeMZ4/xlMho8n5XimmLWKqnNHFFyf/rc0V0V0RVRVFUTyTE52hhnGUf0ys/zywniWQB24AAAAAAAAAAAAAAAAAAAAAAAAAAUJWV100UzVXVERHLMy02UMrxXE2sLPFyTc+zjPOMY/t3h+eWc8Qw5ZxcX78WqJ/0W5n4TP/8APu15EwM/LL+U8tXDGMMeIAHLsAAAAAAAAABIQGqxAAAAAAAAAAAzACyqJmOJirprnPml6FcwPDVbuzM5pebGZNtY6jeYzD2r8RyRcpirN8J5YbbNBxewEUr3F5Irqz+hTT/xTdqiNq31IyR/SV/vVfdLeL2HF7ARL1IyR/SV/vVfc9SMkf0lf71X3S3i9hxewES9SMkf0lf71X3PUjJH9JX+9V90t4vYcXsBEvUjJH9JX+9V9z1IyR/SV/vVfdLeL2HF7ARL1IyR/SV/vVfc9SMkf0lf71X3S3i9hxewES9SMkf0lf71X3PUjJH9JX+9V90t4vYcXsBEvUjJH9JX+9V9z1IyR/SV/vVfdLeL2HF7ARL1IyR/SV/vVfc9SMkf0lf71X3S3i9hxewES9SMkf0lf71X3PUjJH9JX+9V90t4vYcXsBEvUjJH9JX+9V9z1IyR/SV/vVfdLeL2HF7ARL1IyR/SV/vVfc9SMkf0lf71X3S3i9hxewES9SMkf0lf71X3PUjJH9JX+9V90t4vYcXsBEvUjJH9JX+9V9z1IyR/SV/vVfdLeL2HF7ARL1IyR/SV/vVfdWjcVkemrP6FNX/FV2qY2pZxew4vYDUYHJdjAUzTg8NasRPFPB0xEz8Z5Ze6mi5HLL05oVzAxUxPFnXxnzKgAAAAAAAAAAAACscvzUVjl+YI/c5yrWnatXXOcq1p2rWVNtqKgAEgAAAAAAAAAKTEsdUVTySyhyjh5pouZ+KV1qvFWJmbN2uj25p5fkz5oOL2JjKYpE4xNslOVsqUxEcPn/5miPsr+MZV66nwQxcXsOL2O+zL1x1YeMv4xlXrqfBB+MZV66nwQxcXsOL2HZl6jqw8ZfxjKvXU+CD8Yyr11Pghi4vYcXsOzL06sPGX8Yyr11Pgg/GMq9dT4IYuL2HF7Dsy9OrDxl/GMq9dT4IPxjKvXU+CGLi9hxew7MvTqw8ZfxjKvXU+CD8Yyr11Pghi4vYcXsOzL06sPGX8Yyr11Pgg/GMq9dT4IYuL2HF7Dsy9OrDxl/GMq9dT4IPxjKvXU+CGLi9hxew7MvTqw8ZfxjKvXU+CD8Yyr11Pghi4vYcXsOzL06sPGX8Yyr11Pgg/GMq9dT4IYuL2HF7Dsy9OrDxl/GMq9dT4IPxjKvXU+CGLi9hxew7MvTqw8ZfxjKvXU+CD8Yyr11Pghi4vYcXsOzL06sPGX8Yyr11Pgg/GMq9dT4IYuL2HF7Dsy9OrDxl/GMq9dT4IUqytlSqM3D5vhRGfYx8XsOL2HZl6nqw8YLtzFX6s967XXm/mnij5KU01xyy9HF7DNDicpm3cYxFMdMVREZ86+IlURykgASAAAAAAAAAAkIDVYgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAArHL81FY5fmCP3Ocq1p2rV1znKtadq1lTbaioABIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACQgNViAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACscvzUVjl+YI/c5yrWnatXXOcq1p2rWVNtqKgAEgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAJCA1WIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAKxy/NRWOX5gj9znKtadq1dc5yrWnatZU22oqAASAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAkIDVYgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAArHL81FY5fmCP3Ocq1p2rV1znKtadq1lTbaioABIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACQgNViAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAKxygZv+JM0+z+y6Giy9ujvZIxN21awdi/Fq1ariK8RVRXeruVV0027dNNFU1VTNuf1jlz8URMwG83tXsn6G9q/ln6NHg90t+5ftTi8JhsPhqr9Vi7dm/cpqs1U2arueqm5aomI3tMTnzxHH+vG2FOVr9dua7GSsTiIiuad7artxXRG9pmOEprqp3k1RVninjnezE1RTM72A9m9q/ln6G9q/ln6MeIxuIs2bNdvJWMxFVynPVRbqsxVanNE5qpqriJnjmP9MzHFPHyZ/Pk3LFzKODpxVrJOOos3LHD2qrlVmOFiYiaaYiLk5pmJ4t9ERH6zAPZvav5Z+hvav5Z+jXU5dxFWLuYWnIOUpvW6KblVO/w/FTVNUUzzv6zRV+v6Nphbty/h6blzD3cNVVy2rs0zVTy8s0zMcf/ABM/85uQFm9q/ln6G9q/ln6PQA8+9q/ln6G9q/ln6PQtu3KbVqu5XFU00UzVMUUzVVMZs85qYiZmfZERM/pEAw72r+Wfob2r+WfovwmJtYzCWcVhq9/Zv0U3LdWaY31NURMTmmImM8ZuKYzr67lu3XbpruU01XKppoiqYiapiJnNETyzmiZzR+kTP6Aw72r+Wfob2r+Wfo9Dz4zG2MFTaqxNVVNN27RZpmLdVUb+qc1MTMROaJmYjPOaOOIz8cAb2r+Wfob2r+Wfo9C2Llub1VqLlM3KaYqqoiY30RMzETMcsRM01RE/rmn2SDDvav5Z+hvav5Z+j0APPvav5Z+hFNWeP9M/R6AEZrsXprqzWq/90/8AjPtU4C91Vfhl7cflbBZPuXKcXXcomizVfqmLNdUbyJimqrPTTMTmmqM8RxxE580RxvVauU3bVNymKoiumKoiqmaZiJjPGeJiJifbExEx+qlP4/8AWhH7zTUcDe6qvwycDe6qvwy2eLxdnB2ouX6qoiqqKaaaKKq6qpzTOammmJmqc0TMxETmiJz8UTMeavLeTqKaKpv1TFVO+qmm1XMWoiZiZuTETwcRMVRM15s001RObezmjpT3y8vA3uqr8MnA3uqr8MvfdyngbNWMprxFOfBWou4mIiauDpmKpiZiInjmKZnNHHmzTm44z4oyzg+CquVRiqM1UUxTXg71NVczEzEUUzTE1TERMzFMTmiJmc0cZ0nfLy8Be6qvwycBe6qvwyzXd0WTLU0767eq31NNX/bwt2ve76qaKYq3tM72rfU1U72c054mM36Ml3LeT7NV6Lt6qmmzTXNVfBV7yd5EzVFNebe1VRFNWemmZmN7VxcU5p6TveXgb3VV+GTgb3VV+GXqjLOD4Kq5VGKozVRTFNeDvU1VzMTMRRTNMTVMREzMUxOaImZzRxstOU8FXVhaacRTv8XVVTZoniqqmmJmqN7MZ4mnNMTExxTxTmmYhHSd8vBwN7qq/DJwN7qq/DL328pYO5jPRqLlU3N9NMVTbqiiqqOWmmuY3tVUZpz0xMzG9qzxxTmsjK+ArwNONtX+GsV11W7dVqiq5NyqmZiYpppiZqzb2qc8RMZomeSM50nfLx8De6qvwycDe6qvwy99WU8DRhrOIrxFNNu/dps299niarlVW9ijezGeKonPExMRMZpzxGac2CnL2TasVVh+GuU1U8JNVddi5TbiLczFc7+aYpzUzxTOfNnmIz55g6Tvl5+BvdVX4ZU4G71Vfhl64y1gJtVV7+9TVTVEcFVhrlN2rPnzb23NMV1RO9qnPETGamqf/Gc2G7l3J8VxRRViLtU0RXNNnC3bk0xM1U5qoppneznpqiYnNMTTMTETB0kfuw8Hcjloqj5Spvao5aZj5PTicdhLOJnDXcRbouxZqv1U1Tm3tumYiapnkiM88s5s+ac3JObz2MZYxe+4GbkVU8c0XLdVuqI4+Pe1RE5uKYic3HmnNOfk4n8+P7ekfpzPCmaY5YzKLq+Va85esAAkAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABIQJarEBTPPtW76eFzZ+LNILxSZnPHGVTMQCo89N2vh97vuL2Zv8Ahmqmc4LhSZlSJnPyguAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAVjlUVjlBdCJ7oYs1Zex1FdrF3btWT8PTbos8PNE57l6J38W6K6ZjNxxFdNUTxxmmJlLIXwCE5PpwtzE5Et4azlXJ+InE3ad7ewtyxRbjgL0RMW5ibEVzxTO9jjnfTvYzzBlDBZFs7hcpX8fYwc36KsfZw1/Fb2q5NUXb00001156pqz55jjmZnPPLnlOYVBH8q4LJ9qmnAZNiq1juCmMNg8LirtiimJmqYuV0W66YiiKs81VZs88kTNU0xNmQsBg8k4ixk+/iMTRi7O+ow1N3HXZov2oiYpmmiat7VMUR/qpimN7VEzERTNMzIwGkuYS3jN0+OormqiujB4Wq3domIrt17/ERFVMzExnzTMfrExMxMTEzE7bCekeiWfTOC9I4OnheCz7zf5o329z8ebPnzZ+PNmzsoCNU5Jyvey7i6L2OxlvJldNyLVVu/mrpmaZmJz554s9+7Ef6YzcBbnPOaM/ktZL3SYjI1+rFYy/Yyjdu0RRFu7/AKLdFzPNc73fzOeib9yIzVRn4C3MRxRnmADwZHjF2sn4ajHUXZxFyiq9iKpriqm3cqmKptxOeZzRNUxTEZ4imnNM8mfQ5Ov3bm6nKn4fdxOKowuLmb1PpsXKJomxH/apoqrne18NnmJmKYje1U76IiaUtAQ/JGAy1gsi0YCnDYy1RGDw2+pqxNNUxcormm/RRVv5mma7cU7zNMU08ueic723sm42vCZJxN+3ib97AYuu9wFGJzXOCqiumiiZmqKaq6YqtxVNVXHFNf8Aqq3076RgNDi7GOjLN69ib121gI31Vy96TwdunDcFMTRmiqJpuRcz17+IiYp/84/2tDkyjKGU9x9i5as47GWb/odU0+m01XJrouRVfuU1zcz0xMU00xTFUTFUT/pp45meAIviMLl65gqbNFOJpqs14m3Zq9Ipz77f/wD57tc77PXbpozxVTVnqqmc80VTxtlRgbmH3WXsfTZv3beLw1u1NdN7/Ramia5maqKqojjz0xG9ic077Pm30zO2AaTIVnKuFouzj6b92ZptU1U1Xaa9/ezzF27RnqzU25iaZinPTmimrNREzmm7dDhsXieCps0465h95cprowOIizepuTvd5XFU1UxMUxFcTEzMTNVMzTObi3ICNYfD5VsZfvYmjC5QmxXlDNMXMXTXROHqtTEzTRVcmKYi7EVcURVFM5ojNnpiSgCE7ssk43K2JopwWGuTVbweJpt34m3vaa697G9mJqif9VNNdMzmmImuJ5YmY2XAZR9YeF31z0fhM++4X/t8Dwebg95n/wB/Cf6t9vf9vFvv/FuJ/wB0/GVHhysxDW5VrxdWBw9zCYG5XemuJmI4ObmHiaaomqmKqopmqImaeWYjfTOaqImJ1eJyfiasLjLWEyZetUZQwMYWmmu5bmbFcTdz13Z38zMTN2Kpmmaqp/1TMZ+WTBEpmGmv4W/icrZUou4GqvDYjA27FNVd2mmi7McJNVOemZrpiYuRGfe8WaqfZn8lGEx9GIs4q1g8Z6Nhr1NynC4jE03b9VXB3aKqqaqq6ozTwlvNE1x/tqnNnn/VJA5Rw0ljJ+Kixk+m5azURlC9ir9uaomKaKpu10RVGfNM01VW+TPEVRniZiIliqw17F38VYxeRbnBVcNRZpm7bosRFW+ia5mmqa99XnnPVFOenfTERx1TVIA5OEbowmPoxFnFWsHjPRsNepuU4XEYmm7fqq4O7RVVTVVXVGaeEt5omuP9tU5s8/6slvCY2z+Ff/ju173KF/FXt7XR/wBmi5wuaKs9UZ5jhYzxTvo/01ZpnizyAOThoMJk7FUZYt11Ye5TweKvXq703ImzVRVv97FFvfTva439GereUzOavPVO+nfZMBGNtZGvUXcmYmK68TfmqzTfoouTRcuV1xNFVNWaJjfxE56qc2arNM5oid2HJEIpjci5T/DMPewsUziLN3fU4euiK6oonEU3Y/1b+mJrzU0b6aqqt9NHFVEzNVW5vZP9LyrjfS7XCYS9gqLFOer+aq5wlMZpz054m3nmM2fNTxzmbIOZOEUwmAyt6bayri7GLu3LdVrfYe7csTd/0271NW9mje0TTE3qc2+mJ4qs+b/TE0uZLxlq1Xds4PEUY6/wtVq/axe9ps1VXblyiLtG+imqKZuRnzRXEzvozTERvpYx1onKUxijd7AY/Dbo6cZhuDv2btF6a99TFMxVVFvexVVvuSeDppiaaJmIp44mZ3y/AWrsY3FYmvD3sPReiiIov101176JrmZiYqqzUZqoiKYnNExVmiM+edzc/V563lllPHD3wxjnl56+Vaur5VqusxQAJAAAAAAA9gAAAAAEAAAAAAAAAAAAAAAAAAAAAAAAAAAP/9k=\" style=\"max-width:100%;\"><br></p>', '2019-08-31 17:11:31', '测试标题', 0);
-- ----------------------------
-- Table structure for image
-- ----------------------------
DROP TABLE IF EXISTS `image`;
CREATE TABLE `image` (
`image_id` int(11) NOT NULL AUTO_INCREMENT,
`url` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`add_time` datetime(0) NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`image_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of image
-- ----------------------------
INSERT INTO `image` VALUES (1, 'asserts/images/FB3C35591C0749A79FD4424676E7933Fimg-1b2e5a44214b2abc63b78cc083512604.jpg', '2020-03-27 10:13:44');
INSERT INTO `image` VALUES (2, 'asserts/images/966A0CEDB1BE425093ADCC838716F9FFimg-00e4af0d1659466dc4ba29d16d28916d.jpg', '2020-03-25 15:32:36');
INSERT INTO `image` VALUES (3, 'asserts/images/3934CFAD4CA24E479C28A3CE988E50B4img-1b2682600e96a370fd0c204e10c920f6.jpg', '2020-03-25 15:32:47');
INSERT INTO `image` VALUES (4, 'asserts/images/15F0F0075650415E96ED28346E1D0DCAimg-1b2e5a44214b2abc63b78cc083512604.jpg', '2020-03-25 15:32:58');
INSERT INTO `image` VALUES (5, 'asserts/images/4F492BABEB71428AABC7EF3DD6FC51CCimg-8e50cc5f55c9f01891cbb2ce14c95761.jpg', '2020-03-25 15:33:17');
-- ----------------------------
-- Table structure for message
-- ----------------------------
DROP TABLE IF EXISTS `message`;
CREATE TABLE `message` (
`message_id` int(11) NOT NULL AUTO_INCREMENT,
`contact` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
`message_content` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
`stranger_name` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
`log_time` datetime(0) NULL DEFAULT current_timestamp(),
`read_status` bit(1) NULL DEFAULT NULL,
`admin_id` int(5) NULL DEFAULT NULL,
PRIMARY KEY (`message_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of message
-- ----------------------------
INSERT INTO `message` VALUES (1, '10086', '加油', '霍元甲', '2019-06-27 14:23:42', b'1', 1);
INSERT INTO `message` VALUES (3, '18377165724', '有待提高', '企鹅', '2019-06-26 14:50:33', b'1', 1);
INSERT INTO `message` VALUES (4, '008611', '内容需要更新了！', '陌生人', '2019-06-19 14:51:16', b'1', 1);
INSERT INTO `message` VALUES (5, 'asdf', 'asdf', 'qq', '2019-08-19 14:22:59', b'0', 1);
INSERT INTO `message` VALUES (6, '8786546', '需要改进', '风色幻想', '2019-06-18 16:42:13', b'1', 1);
-- ----------------------------
-- Table structure for news
-- ----------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
`news_id` int(11) NOT NULL AUTO_INCREMENT,
`author_id` int(5) NULL DEFAULT NULL,
`news_content` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL,
`create_time` datetime(0) NULL DEFAULT current_timestamp(),
`news_title` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
`news_click` int(5) NULL DEFAULT 0,
PRIMARY KEY (`news_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 37 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of news
-- ----------------------------
INSERT INTO `news` VALUES (14, 1, '<p><a target=\"_blank\" href=\"https://baike.baidu.com/item/%E6%95%B0%E6%8D%AE%E5%BA%93%E7%AE%A1%E7%90%86%E7%B3%BB%E7%BB%9F\">数据库管理系统</a><span>（英语：Database Management System，简称DBMS）是为管理</span><a target=\"_blank\" href=\"https://baike.baidu.com/item/%E6%95%B0%E6%8D%AE%E5%BA%93\">数据库</a><span>而设计的电脑</span><a target=\"_blank\" href=\"https://baike.baidu.com/item/%E8%BD%AF%E4%BB%B6\">软件</a><span>系统，一般具有存储、截取、安全保障、备份等基础功能。数据库管理系统可以依据它所支持的</span><a target=\"_blank\" href=\"https://baike.baidu.com/item/%E6%95%B0%E6%8D%AE%E5%BA%93%E6%A8%A1%E5%9E%8B\">数据库模型</a><span>来作分类，例如关系式、</span><a target=\"_blank\" href=\"https://baike.baidu.com/item/XML\">XML</a><span>；或依据所支持的计算机类型来作分类，例如服务器群集、移动电话；或依据所用查询语言来作分类，例如</span><a target=\"_blank\" href=\"https://baike.baidu.com/item/SQL\">SQL</a><span>、</span><a target=\"_blank\" href=\"https://baike.baidu.com/item/XQuery\">XQuery</a><span>；或依据性能冲量重点来作分类，例如最大规模、最高运行速度；亦或其他的分类方式。不论使用哪种分类方式，一些</span><a target=\"_blank\" href=\"https://baike.baidu.com/item/DBMS/1239170\" data-lemmaid=\"1239170\">DBMS</a><span>能够跨类别，例如，同时支持多种查询语言。</span><span class=\"sup--normal\" data-sup=\"1\" data-ctrmap=\":1,\"> [1]</span><a class=\"sup-anchor\" name=\"ref_[1]_1088\"> </a></p>', '2019-06-27 13:00:11', '数据库管理系统', 11);
INSERT INTO `news` VALUES (15, 1, '<div class=\"para\" label-module=\"para\"><img src=\"http://img.t.sinajs.cn/t35/style/images/common/face/ext/normal/7a/shenshou_thumb.gif\" alt=\"[草泥马]\" data-w-e=\"1\"><b>结构化查询语言</b>(Structured Query Language)简称SQL(发音：/ˈes kjuː ˈel/ \"S-Q-L\")，是一种特殊目的的编程语言，是一种数据库查询和<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E7%A8%8B%E5%BA%8F%E8%AE%BE%E8%AE%A1%E8%AF%AD%E8%A8%80/2317999\" data-lemmaid=\"2317999\">程序设计语言</a>，用于存取数据以及查询、更新和管理<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E5%85%B3%E7%B3%BB%E6%95%B0%E6%8D%AE%E5%BA%93%E7%B3%BB%E7%BB%9F\">关系数据库系统</a>；同时也是<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E6%95%B0%E6%8D%AE%E5%BA%93%E8%84%9A%E6%9C%AC%E6%96%87%E4%BB%B6/644744\" data-lemmaid=\"644744\">数据库脚本文件</a>的扩展名。</div><div class=\"para\" label-module=\"para\">结构化查询语言是高级的非过程化编程语言，允许用户在高层<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E6%95%B0%E6%8D%AE%E7%BB%93%E6%9E%84/1450\" data-lemmaid=\"1450\">数据结构</a>上工作。它不要求用户指定对数据的存放方法，也不需要用户了解具体的数据存放方式，所以具有完全不同底层结构的不同<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E6%95%B0%E6%8D%AE%E5%BA%93%E7%B3%BB%E7%BB%9F/215176\" data-lemmaid=\"215176\">数据库系统</a>, 可以使用相同的结构化查询语言作为数据输入与管理的接口。结构化查询语言语句可以嵌套，这使它具有极大的灵活性和强大的功能。</div><p style=\"text-align: left;\">1986年10月，美国国家标准协会对SQL进行规范后，以此作为关系式数据库管理系统的标准语言（ANSI X3. 135-1986），1987年得到国际标准组织的支持下成为国际标准。不过各种通行的数据库系统在其实践过程中都对SQL规范作了某些编改和扩充。<i><b><u>所以，实际上不同数据库系统之间的SQL不能完全相互通用。</u></b></i></p><p><br></p>', '2019-06-27 13:01:21', '结构化查询语言', 25);
INSERT INTO `news` VALUES (16, 1, '<p><span>layui（谐音：类UI) 是一款采用自身模块规范编写的前端 UI 框架，遵循原生 HTML/CSS/JS 的书写与组织形式，门槛极低，拿来即用。其外在极简，却又不失饱满的内在，体积轻盈，组件丰盈，从核心代码到 API 的每一处细节都经过精心雕琢，非常适合界面的快速开发。layui 首个版本发布于2016年金秋，她区别于那些基于 MVVM 底层的 UI 框架，却并非逆道而行，而是信奉返璞归真之道。准确地说，她更多是为服务端程序员量身定做，你无需涉足各种前端工具的复杂配置，只需面对浏览器本身，让一切你所需要的元素与交互，从这里信手拈来。</span></p>', '2019-06-27 13:11:00', 'layer', 10);
INSERT INTO `news` VALUES (17, 1, '<p>如果JPA提示Executing an update/delete query，那是一定是因为Service层没有加@Transactional和再方法加@Modifying吧。</p><p><br></p><p>异常场景</p><p>spring-boot2+jpa执行新增修改删除操作时：</p><p><br></p><p>public interface UserRepository extends JpaRepository<User , Integer>{</p><p><br></p><p> @Modifying</p><p> @Query(value=\"update User c set c.state = ?1,c.lastupdatetime = ?2 where c.user_no= ?3\")</p><p> void updateUser(int state,Date nowDate,String user_no);</p><p><br></p><p>}</p><p>异常： Executing an update/delete query</p><p><br></p><p>解决方案</p><p>因为jpa要求，’没有事务支持，不能执行更新和删除操作’。</p><p><br></p><p>所以反过来讲，就是在Service层或者Repository层上必须加@Transactional，来代表这是一个事务级别的操作，增删改查除了查都是事务级别的，就当这是一个规范也是ok的。</p><p>--------------------- </p>', '2019-06-27 13:12:11', 'JPA事务问题Executing an update/delete query', 35);
INSERT INTO `news` VALUES (18, 3, '<p>使用springboog+jpa框架，因为业务需求不能使用封装好的save（）方法，故需要在jpa容器里使用@Query注解写sql完成</p><p><br></p><p>起初，直接@Query(value=\"insert into 对象名(字段名) values (?1)\")插入，但是一直报错unexpected token: VALUES</p><p><br></p><p>即sql语句有误，各种改，没用，后来网上查，大多数说法是jpa的jpql不支持insert into ，不经意看到一篇文章里，写的语句后面有一些不一样，试之，完美解决，所以记录下来： @Query(value = \"sql语句\",nativeQuery = true)</p><p><br></p><p>这里先要认识并加入一个注解 @Modifying：</p><p><br></p><p>jpa容器中使用，当使用@Query写jpql时，如果是删除或修改操作，需要加入此注解进行修饰. 以通知 SpringData， 这是一个 UPDATE 或 DELETE 操作 ；默认情况下，是只读，所以查询不需要</p><p><br></p>', '2019-06-27 13:12:54', 'jpa原生sql@Query操作增删改查', 100);
INSERT INTO `news` VALUES (19, 3, '<div class=\"para\" label-module=\"para\">在1970年代初，由<a target=\"_blank\" href=\"https://baike.baidu.com/item/IBM\">IBM</a>公司San Jose,California研究实验室的<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E5%9F%83%E5%BE%B7%E5%8A%A0%C2%B7%E7%A7%91%E5%BE%B7\">埃德加·科德</a>发表将数据组成表格的应用原则（Codd\'s Relational Algebra）。1974年，同一实验室的D.D.Chamberlin和R.F. Boyce对Codd\'s Relational Algebra在研制关系数据库管理系统System R中，研制出一套规范语言-SEQUEL（Structured English QUEry Language），并在1976年11月的IBM Journal of R&D上公布新版本的SQL（叫SEQUEL/2）。1980年改名为SQL。</div><div class=\"para\" label-module=\"para\">1979年ORACLE公司首先提供商用的SQL，IBM公司在DB2和SQL/DS数据库系统中也实现了SQL。</div><div class=\"para\" label-module=\"para\">1986年10月，美国ANSI采用SQL作为关系数据库管理系统的标准语言（ANSI X3. 135-1986），后为国际标准化组织（ISO）采纳为国际标准。</div><div class=\"para\" label-module=\"para\">1989年，美国ANSI采纳在ANSI X3.135-1989报告中定义的关系数据库管理系统的SQL标准语言，称为ANSI SQL 89，该标准替代ANSI X3.135-1986版本。该标准为下列组织所采纳：</div><div class=\"para\" label-module=\"para\">国际标准化组织（ISO），为ISO 9075-1989报告“Database Language SQL With Integrity Enhancement”</div><div class=\"para\" label-module=\"para\">美国联邦政府，发布在The Federal Information Processing Standard Publication(FIPS PUB)127</div><p><div class=\"anchor-list\"><a name=\"4\" class=\"lemma-anchor para-title\"></a><a name=\"sub595350_4\" class=\"lemma-anchor \"></a><a name=\"数据类型\" class=\"lemma-anchor \"></a></div><div class=\"para-title level-2\" label-module=\"para-title\"></div></p><div class=\"para\" label-module=\"para\" style=\"text-align: start;\">目前（21世纪初期）主要的关系数据库管理系统支持某些形式的SQL，大部分数据库打算遵守ANSI SQL89标准。</div>', '2019-06-27 13:13:35', '数据库发展历史', 44);
INSERT INTO `news` VALUES (21, 2, '<div class=\"para\" label-module=\"para\"><b>桂林电子科技大学</b>（Guilin University Of Electronic Technology），<span class=\"sup--normal\" data-sup=\"1\" data-ctrmap=\":1,\"> [1]</span><a class=\"sup-anchor\" name=\"ref_[1]_40784\"> </a> 简称“<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E6%A1%82%E7%94%B5/7353159\" data-lemmaid=\"7353159\">桂电</a>”，坐落在世界著名的风景游览城市——<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E6%A1%82%E6%9E%97%E5%B8%82/10989247\" data-lemmaid=\"10989247\">桂林市</a>，由<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E5%B7%A5%E4%B8%9A%E5%92%8C%E4%BF%A1%E6%81%AF%E5%8C%96%E9%83%A8/835197\" data-lemmaid=\"835197\">工业和信息化部</a>、<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E5%9B%BD%E5%AE%B6%E5%9B%BD%E9%98%B2%E7%A7%91%E6%8A%80%E5%B7%A5%E4%B8%9A%E5%B1%80/4696487\" data-lemmaid=\"4696487\">国家国防科技工业局</a>与<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E5%B9%BF%E8%A5%BF%E5%A3%AE%E6%97%8F%E8%87%AA%E6%B2%BB%E5%8C%BA%E4%BA%BA%E6%B0%91%E6%94%BF%E5%BA%9C/8633217\" data-lemmaid=\"8633217\">广西壮族自治区人民政府</a>共建，<span class=\"sup--normal\" data-sup=\"2-3\" data-ctrmap=\":2,:3,\"> [2-3]</span><a class=\"sup-anchor\" name=\"ref_[2-3]_40784\"> </a> 首批<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E6%96%B0%E5%B7%A5%E7%A7%91%E7%A0%94%E7%A9%B6%E4%B8%8E%E5%AE%9E%E8%B7%B5%E9%A1%B9%E7%9B%AE/22833448\" data-lemmaid=\"22833448\">新工科研究与实践项目</a>、<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E4%B8%AD%E8%A5%BF%E9%83%A8%E9%AB%98%E6%A0%A1%E5%9F%BA%E7%A1%80%E8%83%BD%E5%8A%9B%E5%BB%BA%E8%AE%BE%E5%B7%A5%E7%A8%8B/6590386\" data-lemmaid=\"6590386\">中西部高校基础能力建设工程</a>重点建设高校，<span class=\"sup--normal\" data-sup=\"4\" data-ctrmap=\":4,\"> [4]</span><a class=\"sup-anchor\" name=\"ref_[4]_40784\"> </a> 入选教育部<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E5%8D%93%E8%B6%8A%E5%B7%A5%E7%A8%8B%E5%B8%88%E6%95%99%E8%82%B2%E5%9F%B9%E5%85%BB%E8%AE%A1%E5%88%92\">卓越工程师教育培养计划</a>、<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E6%B5%B7%E5%A4%96%E9%AB%98%E5%B1%82%E6%AC%A1%E4%BA%BA%E6%89%8D%E5%BC%95%E8%BF%9B%E8%AE%A1%E5%88%92/10102618\" data-lemmaid=\"10102618\">海外高层次人才引进计划</a>、<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E5%9B%BD%E5%AE%B6%E5%A4%A7%E5%AD%A6%E7%94%9F%E5%88%9B%E6%96%B0%E6%80%A7%E5%AE%9E%E9%AA%8C%E8%AE%A1%E5%88%92/5326077\" data-lemmaid=\"5326077\">国家大学生创新性实验计划</a>、<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E5%85%A8%E5%9B%BD%E6%B7%B1%E5%8C%96%E5%88%9B%E6%96%B0%E5%88%9B%E4%B8%9A%E6%95%99%E8%82%B2%E6%94%B9%E9%9D%A9%E7%A4%BA%E8%8C%83%E9%AB%98%E6%A0%A1/22051296\" data-lemmaid=\"22051296\">全国深化创新创业教育改革示范高校</a>、<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E5%9B%BD%E5%AE%B6%E5%A4%A7%E5%AD%A6%E7%94%9F%E6%96%87%E5%8C%96%E7%B4%A0%E8%B4%A8%E6%95%99%E8%82%B2%E5%9F%BA%E5%9C%B0/2680904\" data-lemmaid=\"2680904\">国家大学生文化素质教育基地</a>，<span class=\"sup--normal\" data-sup=\"5-6\" data-ctrmap=\":5,:6,\"> [5-6]</span><a class=\"sup-anchor\" name=\"ref_[5-6]_40784\"> </a> <a target=\"_blank\" href=\"https://baike.baidu.com/item//8962344\" data-lemmaid=\"8962344\"></a>是“<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E5%9B%BD%E5%AE%B6%E7%BA%A7%E7%89%B9%E8%89%B2%E4%B8%93%E4%B8%9A/3490017\" data-lemmaid=\"3490017\">国家级特色专业</a>”实施高校、首批高等学校科技成果转化和技术转移基地、国家<a target=\"_blank\" href=\"https://baike.baidu.com/item/973%E8%AE%A1%E5%88%92\">973计划</a>、<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E5%B9%BF%E8%A5%BF%E4%B8%80%E6%B5%81%E5%AD%A6%E7%A7%91%E5%BB%BA%E8%AE%BE%E9%AB%98%E6%A0%A1/22760440\" data-lemmaid=\"22760440\">广西一流学科建设高校</a>、有<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E5%9B%BD%E5%AE%B6%E5%A4%A7%E5%AD%A6%E7%A7%91%E6%8A%80%E5%9B%AD/9149021\" data-lemmaid=\"9149021\">国家大学科技园</a>，<span class=\"sup--normal\" data-sup=\"7-8\" data-ctrmap=\":7,:8,\"> [7-8]</span><a class=\"sup-anchor\" name=\"ref_[7-8]_40784\"> </a> 具有<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E8%87%AA%E4%B8%BB%E6%8B%9B%E7%94%9F/3901599\" data-lemmaid=\"3901599\">自主招生</a>资格，是<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E6%80%BB%E8%A3%85%E5%A4%87%E9%83%A8/1866411\" data-lemmaid=\"1866411\">总装备部</a>通信装备预研项目定向发布的30所高校之一和<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E5%8C%97%E6%96%97/12640773\" data-lemmaid=\"12640773\">北斗</a>ICD授权的高校之一。<span class=\"sup--normal\" data-sup=\"9\" data-ctrmap=\":9,\"> [9]</span><a class=\"sup-anchor\" name=\"ref_[9]_40784\"> </a></div><div class=\"para\" label-module=\"para\">学校始建于1960年，1980年经国务院批准成立<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E6%A1%82%E6%9E%97%E7%94%B5%E5%AD%90%E5%B7%A5%E4%B8%9A%E5%AD%A6%E9%99%A2/609178\" data-lemmaid=\"609178\">桂林电子工业学院</a>，2006年更名为桂林电子科技大学。学校先后隶属于<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E7%AC%AC%E5%9B%9B%E6%9C%BA%E6%A2%B0%E5%B7%A5%E4%B8%9A%E9%83%A8/19374517\" data-lemmaid=\"19374517\">第四机械工业部</a>、<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E7%94%B5%E5%AD%90%E5%B7%A5%E4%B8%9A%E9%83%A8/2124987\" data-lemmaid=\"2124987\">电子工业部</a>、<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E6%9C%BA%E6%A2%B0%E7%94%B5%E5%AD%90%E5%B7%A5%E4%B8%9A%E9%83%A8/22480638\" data-lemmaid=\"22480638\">机械电子工业部</a>、中国电子工业总公司、<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E4%BF%A1%E6%81%AF%E4%BA%A7%E4%B8%9A%E9%83%A8/2212317\" data-lemmaid=\"2212317\">信息产业部</a>。2000年管理体制转为中央与地方共建、以地方管理为主。2008年、2018年先后成为<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E5%B7%A5%E4%B8%9A%E5%92%8C%E4%BF%A1%E6%81%AF%E5%8C%96%E9%83%A8/835197\" data-lemmaid=\"835197\">工业和信息化部</a>与广西共建高校、<a target=\"_blank\" href=\"https://baike.baidu.com/item/%E5%9B%BD%E5%AE%B6%E5%9B%BD%E9%98%B2%E7%A7%91%E6%8A%80%E5%B7%A5%E4%B8%9A%E5%B1%80/4696487\" data-lemmaid=\"4696487\">国家国防科技工业局</a>与广西共建高校。<span class=\"sup--normal\" data-sup=\"3\" data-ctrmap=\":3,:10,\"> [3]</span><a class=\"sup-anchor\" name=\"ref_[3]_40784\"> </a> <span class=\"sup--normal\" data-sup=\"10\" data-ctrmap=\":3,:10,\">[10]</span><a class=\"sup-anchor\" name=\"ref_[10]_40784\"> </a></div><div class=\"para\" label-module=\"para\">截至2018年9月，学校有金鸡岭校区、六合路校区、花江校区、北海校区，校园总面积4153亩；设有19个教学学院；有博士后科研流动站1个，一级学科<a target=\"_blank\" href=\"https://baike.baidu.com/item//1163652\" data-lemmaid=\"1163652\"></a>博士点4个，一级学科硕士点18个，硕士专业学位授权类别7个，本科专业65个；有教职工2900余人，全日制在校学生40600余人。<span class=\"sup--normal\" data-sup=\"10\" data-ctrmap=\":10,\"> [10]</span><a class=\"sup-anchor\" name=\"ref_[10]_40784\"> </a></div>', '2019-06-27 16:44:56', '桂林电子科技大学', 88);
INSERT INTO `news` VALUES (25, 4, '<p>最近开发公司项目后台 通常查询数据都要关联很多表 有的时候表之间的关联关系没有写清楚就会出现重复数据 本来想自己写几个SQL说明SQL的链接关系 搜索的时候发现维基百科上面将的非常的清晰 直接粘贴拿来学习。</p><p><a title=\"SQL\" href=\"http://zh.wikipedia.org/wiki/SQL\">SQL</a> 的连接(<code>JOIN</code>)语句将数据库中的两个或多个表组合起来.<sup id=\"cite_ref-1\" class=\"reference\"><a href=\"http://zh.wikipedia.org/zh-cn/%E8%BF%9E%E6%8E%A5_%28SQL%29#cite_note-1\">[1]</a></sup> 由\"连接\"生成的集合, 可以被保存为表, 或者当成表来使用. <code>JOIN</code> 语句的含义是把两张表的属性通过它们的值组合在一起. 基于 ANSI 标准的 SQL 列出了五种 <code>JOIN</code> 方式: 内连接(<code>INNER</code>), 全外连接(<code>FULL OUTER</code>), 左外连接(<code>LEFT OUTER</code>), 右外连接(<code>RIGHT OUTER</code>)和交叉连接(<code>CROSS</code>). 在特定的情况下, 一张表(基本表, 视图, 或连接表)可以和自身进行连接, 成为自连接(<em>self-join</em>).</p><p>程序员用 <code>JOIN</code> <a class=\"mw-redirect\" title=\"谓词\" href=\"http://zh.wikipedia.org/wiki/%E8%B0%93%E8%AF%8D\">谓词</a>表示要得到\"连接\"后的集合. 如果evaluated predicate为真, 组合后的记录就会按照预期的方式生成, 如一个记录集, 或者一张临时表.</p>', '2019-06-29 15:21:39', '测试标题1', 14);
INSERT INTO `news` VALUES (26, 4, '<div><p><strong>AND 和 OR 运算符用于基于一个以上的条件对记录进行过滤。</strong></p></div><div><h2>AND 和 OR 运算符</h2><p>AND 和 OR 可在 WHERE 子语句中把两个或多个条件结合起来。</p><p>如果第一个条件和第二个条件都成立，则 AND 运算符显示一条记录。</p><p>如果第一个条件和第二个条件中只要有一个成立，则 OR 运算符显示一条记录。</p></div>', '2019-06-29 15:21:58', 'SQL AND & OR 运算符', 87);
SET FOREIGN_KEY_CHECKS = 1;