景龙 / xingqiu · 文件

转到一个项目
thinkcmf5.sql 176.3 KB
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 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 584 585 586 587 588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 659 660 661 662 663 664 665 666 667 668 669 670 671 672 673 674 675 676 677 678 679 680 681 682 683 684 685 686 687 688 689 690 691 692 693 694 695 696 697 698 699 700 701 702 703 704 705 706 707 708 709 710 711 712 713 714 715 716 717 718 719 720 721 722 723 724 725 726 727 728 729 730 731 732 733 734 735 736 737 738 739 740 741 742 743 744 745 746 747 748 749 750 751 752 753 754 755 756 757 758 759 760 761 762 763 764 765 766 767 768 769 770 771 772 773 774 775 776 777 778 779 780 781 782 783 784 785 786 787 788 789 790 791 792 793 794 795 796 797 798 799 800 801 802 803 804 805 806 807 808 809 810 811 812 813 814 815 816 817 818 819 820 821 822 823 824 825 826 827 828 829 830 831 832 833 834 835 836 837 838 839 840 841 842 843 844 845 846 847 848 849 850 851 852 853 854 855 856 857 858 859 860 861 862 863 864 865 866 867 868 869 870 871 872 873 874 875 876 877 878 879 880 881 882 883 884 885 886 887 888 889 890 891 892 893 894 895 896 897 898 899 900 901 902 903 904 905 906 907 908 909 910 911 912 913 914 915 916 917 918 919 920 921 922 923 924 925 926 927 928 929 930 931 932 933 934 935 936 937 938 939 940 941 942 943 944 945 946 947 948 949 950 951 952 953 954 955 956 957 958 959 960 961 962 963 964 965 966 967 968 969 970 971 972 973 974 975 976 977 978 979 980 981 982 983 984 985 986 987 988 989 990 991 992 993 994 995 996 997 998 999 1000 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020 1021 1022 1023 1024 1025 1026 1027 1028 1029 1030 1031 1032 1033 1034 1035 1036 1037 1038 1039 1040 1041 1042 1043 1044 1045 1046 1047 1048 1049 1050 1051 1052 1053 1054 1055 1056 1057 1058 1059 1060 1061 1062 1063 1064 1065 1066 1067 1068 1069 1070 1071 1072 1073 1074 1075 1076 1077 1078 1079 1080 1081 1082 1083 1084 1085 1086 1087 1088 1089 1090 1091 1092 1093 1094 1095 1096 1097 1098 1099 1100 1101 1102 1103 1104 1105 1106 1107 1108 1109 1110 1111 1112 1113 1114 1115 1116 1117 1118 1119 1120 1121 1122 1123 1124 1125 1126 1127 1128 1129 1130 1131 1132 1133 1134 1135 1136 1137 1138 1139 1140 1141 1142 1143 1144 1145 1146 1147 1148 1149 1150 1151 1152 1153 1154 1155 1156 1157 1158 1159 1160 1161 1162 1163 1164 1165 1166 1167 1168 1169 1170 1171 1172 1173 1174 1175 1176 1177 1178 1179 1180 1181 1182 1183 1184 1185 1186 1187 1188 1189 1190 1191 1192 1193 1194 1195 1196 1197 1198 1199 1200 1201 1202 1203 1204 1205 1206 1207 1208 1209 1210 1211 1212 1213 1214 1215 1216 1217 1218 1219 1220 1221 1222 1223 1224 1225 1226 1227 1228 1229 1230 1231 1232 1233 1234 1235 1236 1237 1238 1239 1240 1241 1242 1243 1244 1245 1246 1247 1248 1249 1250 1251 1252 1253 1254 1255 1256 1257 1258 1259 1260 1261 1262 1263 1264 1265 1266 1267 1268 1269 1270 1271 1272 1273 1274 1275 1276 1277 1278 1279 1280 1281 1282 1283 1284 1285 1286 1287 1288 1289 1290 1291 1292 1293 1294 1295 1296 1297 1298 1299 1300 1301 1302 1303 1304 1305 1306 1307 1308 1309 1310 1311 1312 1313 1314 1315 1316 1317 1318 1319 1320 1321 1322 1323 1324 1325 1326 1327 1328 1329 1330 1331 1332 1333 1334 1335 1336 1337 1338 1339 1340 1341 1342 1343 1344 1345 1346 1347 1348 1349 1350 1351 1352 1353 1354 1355 1356 1357 1358 1359 1360 1361 1362 1363 1364 1365 1366 1367 1368 1369 1370 1371 1372 1373 1374 1375 1376 1377 1378 1379 1380 1381 1382 1383 1384 1385 1386 1387 1388 1389 1390 1391 1392 1393 1394 1395 1396 1397 1398 1399 1400 1401 1402 1403 1404 1405 1406 1407 1408 1409 1410 1411 1412 1413 1414 1415 1416 1417 1418 1419 1420 1421 1422 1423 1424 1425 1426 1427 1428 1429 1430 1431 1432 1433 1434 1435 1436 1437 1438 1439 1440 1441 1442 1443 1444 1445 1446 1447 1448 1449 1450 1451 1452 1453 1454 1455 1456 1457 1458 1459 1460 1461 1462 1463 1464 1465 1466 1467 1468 1469 1470 1471 1472 1473 1474 1475 1476 1477 1478 1479 1480 1481 1482 1483 1484 1485 1486 1487 1488 1489 1490 1491 1492 1493 1494 1495 1496 1497 1498 1499 1500 1501 1502 1503 1504 1505 1506 1507 1508 1509 1510 1511 1512 1513 1514 1515 1516 1517 1518 1519 1520 1521 1522 1523 1524 1525 1526 1527 1528 1529 1530 1531 1532 1533 1534 1535 1536 1537 1538 1539 1540 1541 1542 1543 1544 1545 1546 1547 1548 1549 1550 1551 1552 1553 1554 1555 1556 1557 1558 1559 1560 1561 1562 1563 1564 1565 1566 1567 1568 1569 1570 1571 1572 1573 1574 1575 1576 1577 1578 1579 1580 1581 1582 1583 1584 1585 1586 1587 1588 1589 1590 1591 1592 1593 1594 1595 1596 1597 1598 1599 1600 1601 1602 1603 1604 1605 1606 1607 1608 1609 1610 1611 1612 1613 1614 1615 1616 1617 1618 1619 1620 1621 1622 1623 1624 1625 1626 1627 1628 1629 1630 1631 1632 1633 1634 1635 1636 1637 1638 1639 1640 1641 1642 1643 1644 1645 1646 1647 1648 1649 1650 1651 1652 1653 1654 1655 1656 1657 1658 1659 1660 1661 1662 1663 1664 1665 1666 1667 1668 1669 1670 1671 1672 1673 1674 1675 1676 1677 1678 1679 1680 1681 1682 1683 1684 1685 1686 1687 1688 1689 1690 1691 1692 1693 1694 1695 1696 1697 1698 1699 1700 1701 1702 1703 1704 1705 1706 1707 1708 1709 1710 1711 1712 1713 1714 1715 1716 1717 1718 1719 1720 1721 1722 1723 1724 1725 1726 1727 1728 1729 1730 1731 1732 1733 1734 1735 1736 1737 1738 1739 1740 1741 1742 1743 1744 1745 1746 1747 1748 1749 1750 1751 1752 1753 1754 1755 1756 1757 1758 1759 1760 1761 1762 1763 1764 1765 1766 1767 1768 1769 1770 1771 1772 1773 1774 1775 1776 1777 1778 1779 1780 1781 1782 1783 1784 1785 1786 1787 1788 1789 1790 1791 1792 1793 1794 1795 1796 1797 1798 1799 1800 1801 1802 1803 1804 1805 1806 1807 1808 1809 1810 1811 1812 1813 1814 1815 1816 1817 1818 1819 1820 1821 1822 1823 1824 1825 1826 1827 1828 1829 1830 1831 1832 1833 1834 1835 1836 1837 1838 1839 1840 1841 1842 1843 1844 1845 1846 1847 1848 1849 1850 1851 1852 1853 1854 1855 1856 1857 1858 1859 1860 1861 1862 1863 1864 1865 1866 1867 1868 1869 1870 1871 1872 1873 1874 1875 1876 1877 1878 1879 1880 1881 1882 1883 1884 1885 1886 1887 1888 1889 1890 1891 1892 1893 1894 1895 1896 1897 1898 1899 1900 1901 1902 1903 1904 1905 1906 1907 1908 1909 1910 1911 1912 1913 1914 1915 1916 1917 1918 1919 1920 1921 1922 1923 1924 1925 1926 1927 1928 1929 1930 1931 1932 1933 1934 1935 1936 1937 1938 1939 1940 1941 1942 1943 1944 1945 1946 1947 1948 1949 1950 1951 1952 1953 1954 1955 1956 1957 1958 1959 1960 1961 1962 1963 1964 1965 1966 1967 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 2047 2048 2049 2050 2051 2052 2053 2054 2055 2056 2057 2058 2059 2060 2061 2062 2063 2064 2065 2066 2067 2068 2069 2070 2071 2072 2073 2074 2075 2076 2077 2078 2079 2080 2081 2082 2083 2084 2085 2086 2087 2088 2089 2090 2091 2092 2093 2094 2095 2096 2097 2098 2099 2100 2101 2102 2103 2104 2105 2106 2107 2108 2109 
-- phpMyAdmin SQL Dump
-- version 4.6.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: 2019-04-30 10:28:28
-- 服务器版本： 5.7.14
-- PHP Version: 7.0.10

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `thinkcmf5`
--

-- --------------------------------------------------------

--
-- 表的结构 `cmf_about_us`
--

CREATE TABLE `cmf_about_us` (
  `id` int(10) UNSIGNED NOT NULL COMMENT '主键id',
  `name` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '名称',
  `excerpt` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '简介',
  `thumbnail` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '图片',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '内容'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='关于我们表';

--
-- 转存表中的数据 `cmf_about_us`
--

INSERT INTO `cmf_about_us` (`id`, `name`, `excerpt`, `thumbnail`, `content`) VALUES
(1, '测试', '测试测试', 'admin/20190430/2f066709f648fb4da422fd1c6109699d.jpg', '<p>测试测试测试测试测试测试测试测试</p>'),
(2, '测试1', '测试1测试1测试1', 'admin/20190430/695a781bb13e4af9e4460854c7dab175.jpg', '<p>测试1测试1测试1测试1</p>'),
(3, '11', '111', '', '<p>11111111111111<br/></p>'),
(4, '佛挡杀佛', '发的所发生的', '', '<p>发送到发送到发的是</p>');

-- --------------------------------------------------------

--
-- 表的结构 `cmf_admin_menu`
--

CREATE TABLE `cmf_admin_menu` (
  `id` int(10) UNSIGNED NOT NULL,
  `parent_id` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '父菜单id',
  `type` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '菜单类型;1:有界面可访问菜单,2:无界面可访问菜单,0:只作为菜单',
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '状态;1:显示,0:不显示',
  `list_order` float NOT NULL DEFAULT '10000' COMMENT '排序',
  `app` varchar(40) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '应用名',
  `controller` varchar(30) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '控制器名',
  `action` varchar(30) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '操作名称',
  `param` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '额外参数',
  `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '菜单名称',
  `icon` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '菜单图标',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '备注'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='后台菜单表';

--
-- 转存表中的数据 `cmf_admin_menu`
--

INSERT INTO `cmf_admin_menu` (`id`, `parent_id`, `type`, `status`, `list_order`, `app`, `controller`, `action`, `param`, `name`, `icon`, `remark`) VALUES
(1, 0, 0, 1, 20, 'admin', 'Plugin', 'default', '', '插件中心', 'cloud', '插件中心'),
(2, 1, 1, 1, 10000, 'admin', 'Hook', 'index', '', '钩子管理', '', '钩子管理'),
(3, 2, 1, 0, 10000, 'admin', 'Hook', 'plugins', '', '钩子插件管理', '', '钩子插件管理'),
(4, 2, 2, 0, 10000, 'admin', 'Hook', 'pluginListOrder', '', '钩子插件排序', '', '钩子插件排序'),
(5, 2, 1, 0, 10000, 'admin', 'Hook', 'sync', '', '同步钩子', '', '同步钩子'),
(6, 0, 0, 1, 0, 'admin', 'Setting', 'default', '', '设置', 'cogs', '系统设置入口'),
(7, 6, 1, 1, 50, 'admin', 'Link', 'index', '', '友情链接', '', '友情链接管理'),
(8, 7, 1, 0, 10000, 'admin', 'Link', 'add', '', '添加友情链接', '', '添加友情链接'),
(9, 7, 2, 0, 10000, 'admin', 'Link', 'addPost', '', '添加友情链接提交保存', '', '添加友情链接提交保存'),
(10, 7, 1, 0, 10000, 'admin', 'Link', 'edit', '', '编辑友情链接', '', '编辑友情链接'),
(11, 7, 2, 0, 10000, 'admin', 'Link', 'editPost', '', '编辑友情链接提交保存', '', '编辑友情链接提交保存'),
(12, 7, 2, 0, 10000, 'admin', 'Link', 'delete', '', '删除友情链接', '', '删除友情链接'),
(13, 7, 2, 0, 10000, 'admin', 'Link', 'listOrder', '', '友情链接排序', '', '友情链接排序'),
(14, 7, 2, 0, 10000, 'admin', 'Link', 'toggle', '', '友情链接显示隐藏', '', '友情链接显示隐藏'),
(15, 6, 1, 1, 10, 'admin', 'Mailer', 'index', '', '邮箱配置', '', '邮箱配置'),
(16, 15, 2, 0, 10000, 'admin', 'Mailer', 'indexPost', '', '邮箱配置提交保存', '', '邮箱配置提交保存'),
(17, 15, 1, 0, 10000, 'admin', 'Mailer', 'template', '', '邮件模板', '', '邮件模板'),
(18, 15, 2, 0, 10000, 'admin', 'Mailer', 'templatePost', '', '邮件模板提交', '', '邮件模板提交'),
(19, 15, 1, 0, 10000, 'admin', 'Mailer', 'test', '', '邮件发送测试', '', '邮件发送测试'),
(20, 6, 1, 0, 10000, 'admin', 'Menu', 'index', '', '后台菜单', '', '后台菜单管理'),
(21, 20, 1, 0, 10000, 'admin', 'Menu', 'lists', '', '所有菜单', '', '后台所有菜单列表'),
(22, 20, 1, 0, 10000, 'admin', 'Menu', 'add', '', '后台菜单添加', '', '后台菜单添加'),
(23, 20, 2, 0, 10000, 'admin', 'Menu', 'addPost', '', '后台菜单添加提交保存', '', '后台菜单添加提交保存'),
(24, 20, 1, 0, 10000, 'admin', 'Menu', 'edit', '', '后台菜单编辑', '', '后台菜单编辑'),
(25, 20, 2, 0, 10000, 'admin', 'Menu', 'editPost', '', '后台菜单编辑提交保存', '', '后台菜单编辑提交保存'),
(26, 20, 2, 0, 10000, 'admin', 'Menu', 'delete', '', '后台菜单删除', '', '后台菜单删除'),
(27, 20, 2, 0, 10000, 'admin', 'Menu', 'listOrder', '', '后台菜单排序', '', '后台菜单排序'),
(28, 20, 1, 0, 10000, 'admin', 'Menu', 'getActions', '', '导入新后台菜单', '', '导入新后台菜单'),
(29, 6, 1, 1, 30, 'admin', 'Nav', 'index', '', '导航管理', '', '导航管理'),
(30, 29, 1, 0, 10000, 'admin', 'Nav', 'add', '', '添加导航', '', '添加导航'),
(31, 29, 2, 0, 10000, 'admin', 'Nav', 'addPost', '', '添加导航提交保存', '', '添加导航提交保存'),
(32, 29, 1, 0, 10000, 'admin', 'Nav', 'edit', '', '编辑导航', '', '编辑导航'),
(33, 29, 2, 0, 10000, 'admin', 'Nav', 'editPost', '', '编辑导航提交保存', '', '编辑导航提交保存'),
(34, 29, 2, 0, 10000, 'admin', 'Nav', 'delete', '', '删除导航', '', '删除导航'),
(35, 29, 1, 0, 10000, 'admin', 'NavMenu', 'index', '', '导航菜单', '', '导航菜单'),
(36, 35, 1, 0, 10000, 'admin', 'NavMenu', 'add', '', '添加导航菜单', '', '添加导航菜单'),
(37, 35, 2, 0, 10000, 'admin', 'NavMenu', 'addPost', '', '添加导航菜单提交保存', '', '添加导航菜单提交保存'),
(38, 35, 1, 0, 10000, 'admin', 'NavMenu', 'edit', '', '编辑导航菜单', '', '编辑导航菜单'),
(39, 35, 2, 0, 10000, 'admin', 'NavMenu', 'editPost', '', '编辑导航菜单提交保存', '', '编辑导航菜单提交保存'),
(40, 35, 2, 0, 10000, 'admin', 'NavMenu', 'delete', '', '删除导航菜单', '', '删除导航菜单'),
(41, 35, 2, 0, 10000, 'admin', 'NavMenu', 'listOrder', '', '导航菜单排序', '', '导航菜单排序'),
(42, 1, 1, 1, 10000, 'admin', 'Plugin', 'index', '', '插件列表', '', '插件列表'),
(43, 42, 2, 0, 10000, 'admin', 'Plugin', 'toggle', '', '插件启用禁用', '', '插件启用禁用'),
(44, 42, 1, 0, 10000, 'admin', 'Plugin', 'setting', '', '插件设置', '', '插件设置'),
(45, 42, 2, 0, 10000, 'admin', 'Plugin', 'settingPost', '', '插件设置提交', '', '插件设置提交'),
(46, 42, 2, 0, 10000, 'admin', 'Plugin', 'install', '', '插件安装', '', '插件安装'),
(47, 42, 2, 0, 10000, 'admin', 'Plugin', 'update', '', '插件更新', '', '插件更新'),
(48, 42, 2, 0, 10000, 'admin', 'Plugin', 'uninstall', '', '卸载插件', '', '卸载插件'),
(49, 110, 0, 1, 10000, 'admin', 'User', 'default', '', '管理组', '', '管理组'),
(50, 49, 1, 1, 10000, 'admin', 'Rbac', 'index', '', '角色管理', '', '角色管理'),
(51, 50, 1, 0, 10000, 'admin', 'Rbac', 'roleAdd', '', '添加角色', '', '添加角色'),
(52, 50, 2, 0, 10000, 'admin', 'Rbac', 'roleAddPost', '', '添加角色提交', '', '添加角色提交'),
(53, 50, 1, 0, 10000, 'admin', 'Rbac', 'roleEdit', '', '编辑角色', '', '编辑角色'),
(54, 50, 2, 0, 10000, 'admin', 'Rbac', 'roleEditPost', '', '编辑角色提交', '', '编辑角色提交'),
(55, 50, 2, 0, 10000, 'admin', 'Rbac', 'roleDelete', '', '删除角色', '', '删除角色'),
(56, 50, 1, 0, 10000, 'admin', 'Rbac', 'authorize', '', '设置角色权限', '', '设置角色权限'),
(57, 50, 2, 0, 10000, 'admin', 'Rbac', 'authorizePost', '', '角色授权提交', '', '角色授权提交'),
(58, 0, 1, 0, 10000, 'admin', 'RecycleBin', 'index', '', '回收站', '', '回收站'),
(59, 58, 2, 0, 10000, 'admin', 'RecycleBin', 'restore', '', '回收站还原', '', '回收站还原'),
(60, 58, 2, 0, 10000, 'admin', 'RecycleBin', 'delete', '', '回收站彻底删除', '', '回收站彻底删除'),
(61, 6, 1, 1, 10000, 'admin', 'Route', 'index', '', 'URL美化', '', 'URL规则管理'),
(62, 61, 1, 0, 10000, 'admin', 'Route', 'add', '', '添加路由规则', '', '添加路由规则'),
(63, 61, 2, 0, 10000, 'admin', 'Route', 'addPost', '', '添加路由规则提交', '', '添加路由规则提交'),
(64, 61, 1, 0, 10000, 'admin', 'Route', 'edit', '', '路由规则编辑', '', '路由规则编辑'),
(65, 61, 2, 0, 10000, 'admin', 'Route', 'editPost', '', '路由规则编辑提交', '', '路由规则编辑提交'),
(66, 61, 2, 0, 10000, 'admin', 'Route', 'delete', '', '路由规则删除', '', '路由规则删除'),
(67, 61, 2, 0, 10000, 'admin', 'Route', 'ban', '', '路由规则禁用', '', '路由规则禁用'),
(68, 61, 2, 0, 10000, 'admin', 'Route', 'open', '', '路由规则启用', '', '路由规则启用'),
(69, 61, 2, 0, 10000, 'admin', 'Route', 'listOrder', '', '路由规则排序', '', '路由规则排序'),
(70, 61, 1, 0, 10000, 'admin', 'Route', 'select', '', '选择URL', '', '选择URL'),
(71, 6, 1, 1, 0, 'admin', 'Setting', 'site', '', '网站信息', '', '网站信息'),
(72, 71, 2, 0, 10000, 'admin', 'Setting', 'sitePost', '', '网站信息设置提交', '', '网站信息设置提交'),
(73, 6, 1, 0, 10000, 'admin', 'Setting', 'password', '', '密码修改', '', '密码修改'),
(74, 73, 2, 0, 10000, 'admin', 'Setting', 'passwordPost', '', '密码修改提交', '', '密码修改提交'),
(75, 6, 1, 1, 10000, 'admin', 'Setting', 'upload', '', '上传设置', '', '上传设置'),
(76, 75, 2, 0, 10000, 'admin', 'Setting', 'uploadPost', '', '上传设置提交', '', '上传设置提交'),
(77, 6, 1, 0, 10000, 'admin', 'Setting', 'clearCache', '', '清除缓存', '', '清除缓存'),
(78, 6, 1, 1, 40, 'admin', 'Slide', 'index', '', '幻灯片管理', '', '幻灯片管理'),
(79, 78, 1, 0, 10000, 'admin', 'Slide', 'add', '', '添加幻灯片', '', '添加幻灯片'),
(80, 78, 2, 0, 10000, 'admin', 'Slide', 'addPost', '', '添加幻灯片提交', '', '添加幻灯片提交'),
(81, 78, 1, 0, 10000, 'admin', 'Slide', 'edit', '', '编辑幻灯片', '', '编辑幻灯片'),
(82, 78, 2, 0, 10000, 'admin', 'Slide', 'editPost', '', '编辑幻灯片提交', '', '编辑幻灯片提交'),
(83, 78, 2, 0, 10000, 'admin', 'Slide', 'delete', '', '删除幻灯片', '', '删除幻灯片'),
(84, 78, 1, 0, 10000, 'admin', 'SlideItem', 'index', '', '幻灯片页面列表', '', '幻灯片页面列表'),
(85, 84, 1, 0, 10000, 'admin', 'SlideItem', 'add', '', '幻灯片页面添加', '', '幻灯片页面添加'),
(86, 84, 2, 0, 10000, 'admin', 'SlideItem', 'addPost', '', '幻灯片页面添加提交', '', '幻灯片页面添加提交'),
(87, 84, 1, 0, 10000, 'admin', 'SlideItem', 'edit', '', '幻灯片页面编辑', '', '幻灯片页面编辑'),
(88, 84, 2, 0, 10000, 'admin', 'SlideItem', 'editPost', '', '幻灯片页面编辑提交', '', '幻灯片页面编辑提交'),
(89, 84, 2, 0, 10000, 'admin', 'SlideItem', 'delete', '', '幻灯片页面删除', '', '幻灯片页面删除'),
(90, 84, 2, 0, 10000, 'admin', 'SlideItem', 'ban', '', '幻灯片页面隐藏', '', '幻灯片页面隐藏'),
(91, 84, 2, 0, 10000, 'admin', 'SlideItem', 'cancelBan', '', '幻灯片页面显示', '', '幻灯片页面显示'),
(92, 84, 2, 0, 10000, 'admin', 'SlideItem', 'listOrder', '', '幻灯片页面排序', '', '幻灯片页面排序'),
(93, 6, 1, 1, 10000, 'admin', 'Storage', 'index', '', '文件存储', '', '文件存储'),
(94, 93, 2, 0, 10000, 'admin', 'Storage', 'settingPost', '', '文件存储设置提交', '', '文件存储设置提交'),
(95, 6, 1, 1, 20, 'admin', 'Theme', 'index', '', '模板管理', '', '模板管理'),
(96, 95, 1, 0, 10000, 'admin', 'Theme', 'install', '', '安装模板', '', '安装模板'),
(97, 95, 2, 0, 10000, 'admin', 'Theme', 'uninstall', '', '卸载模板', '', '卸载模板'),
(98, 95, 2, 0, 10000, 'admin', 'Theme', 'installTheme', '', '模板安装', '', '模板安装'),
(99, 95, 2, 0, 10000, 'admin', 'Theme', 'update', '', '模板更新', '', '模板更新'),
(100, 95, 2, 0, 10000, 'admin', 'Theme', 'active', '', '启用模板', '', '启用模板'),
(101, 95, 1, 0, 10000, 'admin', 'Theme', 'files', '', '模板文件列表', '', '启用模板'),
(102, 95, 1, 0, 10000, 'admin', 'Theme', 'fileSetting', '', '模板文件设置', '', '模板文件设置'),
(103, 95, 1, 0, 10000, 'admin', 'Theme', 'fileArrayData', '', '模板文件数组数据列表', '', '模板文件数组数据列表'),
(104, 95, 2, 0, 10000, 'admin', 'Theme', 'fileArrayDataEdit', '', '模板文件数组数据添加编辑', '', '模板文件数组数据添加编辑'),
(105, 95, 2, 0, 10000, 'admin', 'Theme', 'fileArrayDataEditPost', '', '模板文件数组数据添加编辑提交保存', '', '模板文件数组数据添加编辑提交保存'),
(106, 95, 2, 0, 10000, 'admin', 'Theme', 'fileArrayDataDelete', '', '模板文件数组数据删除', '', '模板文件数组数据删除'),
(107, 95, 2, 0, 10000, 'admin', 'Theme', 'settingPost', '', '模板文件编辑提交保存', '', '模板文件编辑提交保存'),
(108, 95, 1, 0, 10000, 'admin', 'Theme', 'dataSource', '', '模板文件设置数据源', '', '模板文件设置数据源'),
(109, 95, 1, 0, 10000, 'admin', 'Theme', 'design', '', '模板设计', '', '模板设计'),
(110, 0, 0, 1, 10, 'user', 'AdminIndex', 'default', '', '用户管理', 'group', '用户管理'),
(111, 49, 1, 1, 10000, 'admin', 'User', 'index', '', '管理员', '', '管理员管理'),
(112, 111, 1, 0, 10000, 'admin', 'User', 'add', '', '管理员添加', '', '管理员添加'),
(113, 111, 2, 0, 10000, 'admin', 'User', 'addPost', '', '管理员添加提交', '', '管理员添加提交'),
(114, 111, 1, 0, 10000, 'admin', 'User', 'edit', '', '管理员编辑', '', '管理员编辑'),
(115, 111, 2, 0, 10000, 'admin', 'User', 'editPost', '', '管理员编辑提交', '', '管理员编辑提交'),
(116, 111, 1, 0, 10000, 'admin', 'User', 'userInfo', '', '个人信息', '', '管理员个人信息修改'),
(117, 111, 2, 0, 10000, 'admin', 'User', 'userInfoPost', '', '管理员个人信息修改提交', '', '管理员个人信息修改提交'),
(118, 111, 2, 0, 10000, 'admin', 'User', 'delete', '', '管理员删除', '', '管理员删除'),
(119, 111, 2, 0, 10000, 'admin', 'User', 'ban', '', '停用管理员', '', '停用管理员'),
(120, 111, 2, 0, 10000, 'admin', 'User', 'cancelBan', '', '启用管理员', '', '启用管理员'),
(121, 0, 0, 1, 30, 'portal', 'AdminIndex', 'default', '', '门户管理', 'th', '门户管理'),
(122, 121, 1, 1, 10000, 'portal', 'AdminArticle', 'index', '', '文章管理', '', '文章列表'),
(123, 122, 1, 0, 10000, 'portal', 'AdminArticle', 'add', '', '添加文章', '', '添加文章'),
(124, 122, 2, 0, 10000, 'portal', 'AdminArticle', 'addPost', '', '添加文章提交', '', '添加文章提交'),
(125, 122, 1, 0, 10000, 'portal', 'AdminArticle', 'edit', '', '编辑文章', '', '编辑文章'),
(126, 122, 2, 0, 10000, 'portal', 'AdminArticle', 'editPost', '', '编辑文章提交', '', '编辑文章提交'),
(127, 122, 2, 0, 10000, 'portal', 'AdminArticle', 'delete', '', '文章删除', '', '文章删除'),
(128, 122, 2, 0, 10000, 'portal', 'AdminArticle', 'publish', '', '文章发布', '', '文章发布'),
(129, 122, 2, 0, 10000, 'portal', 'AdminArticle', 'top', '', '文章置顶', '', '文章置顶'),
(130, 122, 2, 0, 10000, 'portal', 'AdminArticle', 'recommend', '', '文章推荐', '', '文章推荐'),
(131, 122, 2, 0, 10000, 'portal', 'AdminArticle', 'listOrder', '', '文章排序', '', '文章排序'),
(132, 121, 1, 1, 10000, 'portal', 'AdminCategory', 'index', '', '分类管理', '', '文章分类列表'),
(133, 132, 1, 0, 10000, 'portal', 'AdminCategory', 'add', '', '添加文章分类', '', '添加文章分类'),
(134, 132, 2, 0, 10000, 'portal', 'AdminCategory', 'addPost', '', '添加文章分类提交', '', '添加文章分类提交'),
(135, 132, 1, 0, 10000, 'portal', 'AdminCategory', 'edit', '', '编辑文章分类', '', '编辑文章分类'),
(136, 132, 2, 0, 10000, 'portal', 'AdminCategory', 'editPost', '', '编辑文章分类提交', '', '编辑文章分类提交'),
(137, 132, 1, 0, 10000, 'portal', 'AdminCategory', 'select', '', '文章分类选择对话框', '', '文章分类选择对话框'),
(138, 132, 2, 0, 10000, 'portal', 'AdminCategory', 'listOrder', '', '文章分类排序', '', '文章分类排序'),
(139, 132, 2, 0, 10000, 'portal', 'AdminCategory', 'delete', '', '删除文章分类', '', '删除文章分类'),
(140, 121, 1, 0, 10000, 'portal', 'AdminPage', 'index', '', '页面管理', '', '页面管理'),
(141, 140, 1, 0, 10000, 'portal', 'AdminPage', 'add', '', '添加页面', '', '添加页面'),
(142, 140, 2, 0, 10000, 'portal', 'AdminPage', 'addPost', '', '添加页面提交', '', '添加页面提交'),
(143, 140, 1, 0, 10000, 'portal', 'AdminPage', 'edit', '', '编辑页面', '', '编辑页面'),
(144, 140, 2, 0, 10000, 'portal', 'AdminPage', 'editPost', '', '编辑页面提交', '', '编辑页面提交'),
(145, 140, 2, 0, 10000, 'portal', 'AdminPage', 'delete', '', '删除页面', '', '删除页面'),
(146, 121, 1, 0, 10000, 'portal', 'AdminTag', 'index', '', '文章标签', '', '文章标签'),
(147, 146, 1, 0, 10000, 'portal', 'AdminTag', 'add', '', '添加文章标签', '', '添加文章标签'),
(148, 146, 2, 0, 10000, 'portal', 'AdminTag', 'addPost', '', '添加文章标签提交', '', '添加文章标签提交'),
(149, 146, 2, 0, 10000, 'portal', 'AdminTag', 'upStatus', '', '更新标签状态', '', '更新标签状态'),
(150, 146, 2, 0, 10000, 'portal', 'AdminTag', 'delete', '', '删除文章标签', '', '删除文章标签'),
(151, 0, 1, 0, 10000, 'user', 'AdminAsset', 'index', '', '资源管理', 'file', '资源管理列表'),
(152, 151, 2, 0, 10000, 'user', 'AdminAsset', 'delete', '', '删除文件', '', '删除文件'),
(153, 110, 0, 1, 10000, 'user', 'AdminIndex', 'default1', '', '用户组', '', '用户组'),
(154, 153, 1, 1, 10000, 'user', 'AdminIndex', 'index', '', '本站用户', '', '本站用户'),
(155, 154, 2, 0, 10000, 'user', 'AdminIndex', 'ban', '', '本站用户拉黑', '', '本站用户拉黑'),
(156, 154, 2, 0, 10000, 'user', 'AdminIndex', 'cancelBan', '', '本站用户启用', '', '本站用户启用'),
(157, 153, 1, 1, 10000, 'user', 'AdminOauth', 'index', '', '第三方用户', '', '第三方用户'),
(158, 157, 2, 0, 10000, 'user', 'AdminOauth', 'delete', '', '删除第三方用户绑定', '', '删除第三方用户绑定'),
(159, 6, 1, 1, 10000, 'user', 'AdminUserAction', 'index', '', '用户操作管理', '', '用户操作管理'),
(160, 159, 1, 0, 10000, 'user', 'AdminUserAction', 'edit', '', '编辑用户操作', '', '编辑用户操作'),
(161, 159, 2, 0, 10000, 'user', 'AdminUserAction', 'editPost', '', '编辑用户操作提交', '', '编辑用户操作提交'),
(162, 159, 1, 0, 10000, 'user', 'AdminUserAction', 'sync', '', '同步用户操作', '', '同步用户操作'),
(163, 121, 1, 1, 10000, 'portal', 'AdminCityCategory', 'index', '', '城市分类', '', ''),
(164, 0, 1, 1, 10000, 'portal', 'AdminStar', 'default', '', '星球奇境', 'th', ''),
(165, 164, 1, 1, 10000, 'portal', 'AdminStarStory', 'index', '', '星球故事', '', ''),
(166, 164, 1, 1, 10000, 'portal', 'AdminStarScenery', 'index', '', '网红美景', '', ''),
(167, 164, 1, 1, 10000, 'portal', 'AdminStarFood', 'index', '', '异域珍馐', '', ''),
(168, 164, 1, 1, 10000, 'portal', 'AdminStarHotel', 'index', '', '良宿美寝', '', ''),
(169, 164, 1, 1, 10000, 'portal', 'AdminStarEcology', 'index', '', '活力生态', '', ''),
(170, 164, 1, 1, 10000, 'portal', 'AdminStarTrip', 'index', '', '便利出行', '', ''),
(171, 0, 1, 1, 10000, 'portal', 'AdminRegion', 'default', '', '星域秀场', 'th', ''),
(172, 171, 1, 1, 10000, 'portal', 'AdminRegionVideo', 'index', '', '星球影院', '', ''),
(173, 171, 1, 1, 10000, 'portal', 'AdminRegionStar', 'index', '', '明星访谈', '', ''),
(175, 171, 1, 1, 10000, 'portal', 'AdminRegionGallery', 'index', '', '星球画廊', '', ''),
(176, 171, 1, 1, 10000, 'portal', 'AdminRegionNews', 'index', '', '独角快报', '', ''),
(177, 171, 1, 1, 10000, 'portal', 'AdminRegionNote', 'index', '', '独角日志', '', ''),
(178, 171, 1, 1, 10000, 'portal', 'AdminRegionFuture', 'index', '', '童趣未来', '', ''),
(179, 0, 1, 1, 10000, 'portal', 'AdminEnjoy', 'default', '', '星享体验', 'th', ''),
(180, 179, 1, 1, 10000, 'portal', 'AdminEnjoyOwn', 'index', '', '亲临现场', '', ''),
(181, 179, 1, 1, 10000, 'portal', 'AdminEnjoyRoam', 'index', '', '市井漫游', '', ''),
(182, 179, 1, 1, 10000, 'portal', 'AdminEnjoyFeast', 'index', '', '视听盛宴', '', ''),
(183, 179, 1, 1, 10000, 'portal', 'AdminEnjoySky', 'index', '', '户外天堂', '', ''),
(184, 0, 1, 1, 10000, 'portal', 'AdminScout', 'default', '', '星探推荐', 'th', ''),
(185, 184, 1, 1, 10000, 'portal', 'AdminScoutTravel', 'index', '', '旅游路线', '', ''),
(186, 184, 1, 1, 10000, 'portal', 'AdminScoutScenery', 'index', '', '地道风物', '', ''),
(187, 184, 1, 1, 10000, 'portal', 'AdminScoutDesign', 'index', '', '创意设计', '', ''),
(188, 184, 1, 1, 10000, 'portal', 'AdminScoutLike', 'index', '', '悦己悦人', '', ''),
(189, 0, 1, 1, 10000, 'portal', 'AdminExe', 'default', '', '星际活动', 'th', ''),
(190, 189, 1, 1, 10000, 'portal', 'AdminActive', 'index', '', '星际活动', '', ''),
(191, 6, 1, 1, 10000, 'admin', 'Cooperation', 'index', '', '合作伙伴', '', ''),
(192, 6, 1, 1, 10000, 'admin', 'Focus', 'index', '', '关注我们', '', ''),
(195, 6, 1, 1, 10000, 'admin', 'AboutUs', 'index', '', '关于我们', '', '');

-- --------------------------------------------------------

--
-- 表的结构 `cmf_asset`
--

CREATE TABLE `cmf_asset` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户id',
  `file_size` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '文件大小,单位B',
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '上传时间',
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '状态;1:可用,0:不可用',
  `download_times` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '下载次数',
  `file_key` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '文件惟一码',
  `filename` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '文件名',
  `file_path` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '文件路径,相对于upload目录,可以为url',
  `file_md5` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '文件md5值',
  `file_sha1` varchar(40) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `suffix` varchar(10) NOT NULL DEFAULT '' COMMENT '文件后缀名,不包括点',
  `more` text COMMENT '其它详细信息,JSON格式'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='资源表';

--
-- 转存表中的数据 `cmf_asset`
--

INSERT INTO `cmf_asset` (`id`, `user_id`, `file_size`, `create_time`, `status`, `download_times`, `file_key`, `filename`, `file_path`, `file_md5`, `file_sha1`, `suffix`, `more`) VALUES
(1, 1, 190193, 1556365714, 1, 0, 'f51c9f3438158d14f0f310ea2107b3068e14c83ac5881d8698ba02c50dae2cb8', '微信图片_20190425111105.png', 'portal/20190427/bfa75e4bf971d5866ffb7c49b31ef0a6.png', 'f51c9f3438158d14f0f310ea2107b306', 'aecc43f61921021c2b9a546cce672404d4d79871', 'png', NULL),
(2, 1, 535255, 1556365722, 1, 0, 'dfea61b7475ead0612642a4c4e8fc5324606be63b3d8276ae1c2d61a84ed9ec6', '微信图片_20190425110825.png', 'portal/20190427/aacfb30e2dd0a501a4c39278107374bf.png', 'dfea61b7475ead0612642a4c4e8fc532', '4ed243a285cd1d63e9b84b185644c1d169889d90', 'png', NULL),
(3, 1, 5442074, 1556365741, 1, 0, 'fea072319a52fa5e882cfa7b535d6d55df374d282efa1644724b3f6cbdd47705', '01茅屋为秋风所破歌.mp3', 'portal/20190427/9717bb01f748538eacdd3dec2e7dcd87.mp3', 'fea072319a52fa5e882cfa7b535d6d55', 'c46b517e0448235b4a5ea8f03f33e9f238554e88', 'mp3', NULL),
(4, 1, 215335, 1556366119, 1, 0, 'aa16e774c5e5242ff68313fa4745eb5f16ffc628917212bfffce72f88d6122c8', '微信图片_20190425111059.png', 'portal/20190427/7bb21072beef1c4bf2550eb935235b42.png', 'aa16e774c5e5242ff68313fa4745eb5f', 'beade1372ad117cb712335cb963e37dcb5e8e697', 'png', NULL),
(5, 1, 614809, 1556447076, 1, 0, 'b1e35acc1d9e3507397dcfe7a29c60436df3fb695a2d25293e9ae52366cac301', '微信图片_20190425111114.png', 'portal/20190428/1997922c27fa9bc8e6b263f807aa55e4.png', 'b1e35acc1d9e3507397dcfe7a29c6043', 'ca3805c9640d3b8ae524c75ad7175393f7fda848', 'png', NULL),
(6, 1, 102924, 1556501023, 1, 0, 'd1157584e407e824d6e672b492d9082b8e36a854569cc45d1e9df205e5beb290', 'timg (3).jpg', 'portal/20190429/757903cfcd72efd2a1ee5147ffa30967.jpg', 'd1157584e407e824d6e672b492d9082b', '968f395c50e789a0af2b915158fb246db96012fa', 'jpg', NULL),
(7, 1, 383910, 1556501078, 1, 0, '5879757873e6cdc06d477d9e99e08a0b5463a1d6bc5c793be4b7f204332768e3', '微信图片_20190425110755.png', 'portal/20190429/b6c9f9ee9dbf3a2801e8b5f803a18599.png', '5879757873e6cdc06d477d9e99e08a0b', '2e02e14783a31ec76a70b641bd97d918df2eef8e', 'png', NULL),
(8, 1, 158479, 1556502348, 1, 0, 'a950482df14952aef65798aac9c579d09e647bea1b351df4aa65b9f5e1dea54a', '微信图片_20190425145816.png', 'portal/20190429/fb06758a3957629cca7f3de215c0c0a1.png', 'a950482df14952aef65798aac9c579d0', 'e15e84b04b0e03274e6d0ea37b7fc7bdde8f7614', 'png', NULL),
(9, 1, 405335, 1556503901, 1, 0, 'd5215e7bd957c2f3346da53f6768173eac59ae5333eac92b78dbdde9ca20253c', '微信图片_20190425111119.png', 'portal/20190429/8d8a1805c37888ec709264f399903ab3.png', 'd5215e7bd957c2f3346da53f6768173e', '17cee4fb0899a3f6dd83718b9faa4ec543695ac8', 'png', NULL),
(10, 1, 157169, 1556503910, 1, 0, 'dad7224e83a3744c95eb1ba836fb3b7ffe58696c491ebc465277916bc71fcbc1', '微信图片_20190425145821.png', 'portal/20190429/ca713bb61ec2d5bf635cf3b9049f116a.png', 'dad7224e83a3744c95eb1ba836fb3b7f', '0435b9bef38f431061620cff7cc9bc2c0bcbd9f5', 'png', NULL),
(11, 1, 405335, 1556504407, 1, 0, 'd5215e7bd957c2f3346da53f6768173eac59ae5333eac92b78dbdde9ca20253c', '微信图片_20190425111119.png', 'default/20190429/44db02bc8a4daeb5d071c4db10f7b8ec.png', 'd5215e7bd957c2f3346da53f6768173e', '17cee4fb0899a3f6dd83718b9faa4ec543695ac8', 'png', NULL),
(12, 1, 158479, 1556504426, 1, 0, 'a950482df14952aef65798aac9c579d09e647bea1b351df4aa65b9f5e1dea54a', '微信图片_20190425145816.png', 'portal/20190429/fb8f8a74672780a7a8c140fc82719482.png', 'a950482df14952aef65798aac9c579d0', 'e15e84b04b0e03274e6d0ea37b7fc7bdde8f7614', 'png', NULL),
(13, 1, 405335, 1556504900, 1, 0, 'd5215e7bd957c2f3346da53f6768173eac59ae5333eac92b78dbdde9ca20253c', '微信图片_20190425111119.png', 'default/20190429/25e3fbcc3286d28d126279ba95e15a92.png', 'd5215e7bd957c2f3346da53f6768173e', '17cee4fb0899a3f6dd83718b9faa4ec543695ac8', 'png', NULL),
(14, 1, 158479, 1556504908, 1, 0, 'a950482df14952aef65798aac9c579d09e647bea1b351df4aa65b9f5e1dea54a', '微信图片_20190425145816.png', 'portal/20190429/b15b225f006041d70c7ef3065f3bce3a.png', 'a950482df14952aef65798aac9c579d0', 'e15e84b04b0e03274e6d0ea37b7fc7bdde8f7614', 'png', NULL),
(15, 1, 1421034, 1556507740, 1, 0, '93e5590948aa5c9d04fd9981f1e3a2f4d29367b0db6b4186481b8bf6feec3148', '1654347538280bd59888a3b24a474179.mp4', 'portal/20190429/7ede6d84c6641e06fb20490060bf5925.mp4', '93e5590948aa5c9d04fd9981f1e3a2f4', '23884266176f4465f16868224d6c5d0b8a5fb24c', 'mp4', NULL),
(16, 1, 88645, 1556516304, 1, 0, '9b84d97542f916cb4d7855f402449c1205f59d9b093efba4851972a8eaf419ab', '5fdf8db1cb134954d3dd657a584e9258d0094ae9.jpg', 'portal/20190429/ee5ba6a7a6cb518989f688e82e22010f.jpg', '9b84d97542f916cb4d7855f402449c12', 'fb89ce27672eccae75688143ced11098b1ce8c2a', 'jpg', NULL),
(17, 1, 88645, 1556516335, 1, 0, '9b84d97542f916cb4d7855f402449c1205f59d9b093efba4851972a8eaf419ab', '5fdf8db1cb134954d3dd657a584e9258d0094ae9.jpg', 'portal/20190429/839b481bc425d51808c3f92fd4cf70b6.jpg', '9b84d97542f916cb4d7855f402449c12', 'fb89ce27672eccae75688143ced11098b1ce8c2a', 'jpg', NULL),
(18, 1, 88645, 1556516604, 1, 0, '9b84d97542f916cb4d7855f402449c1205f59d9b093efba4851972a8eaf419ab', '5fdf8db1cb134954d3dd657a584e9258d0094ae9.jpg', 'portal/20190429/6c4ccc38498e75cad0f02d9c64391099.jpg', '9b84d97542f916cb4d7855f402449c12', 'fb89ce27672eccae75688143ced11098b1ce8c2a', 'jpg', NULL),
(19, 1, 1479, 1556516744, 1, 0, '1a5e50b8f9d2916b9bd17e448e5e891fbc9ca5082fc681c0f557854a3bf04cb9', 'rencai@2x.png', 'portal/20190429/22f24f0d60df0f26cf3930f76c9ea17f.png', '1a5e50b8f9d2916b9bd17e448e5e891f', '3fd0264bdd986ecb63ea13cc7682c8b8f6c29fd2', 'png', NULL),
(20, 1, 2162805, 1556518306, 1, 0, 'e8eec8fd867ff5a3947c2722652dbe4007934a2181fae871a12a70a14f981350', 'mm.png', 'portal/20190429/db20ef6b18d6cfa5319edb8a94e48945.png', 'e8eec8fd867ff5a3947c2722652dbe40', '3d2e354b66d8325ff7f75f884cd6848cf9bdedd6', 'png', NULL),
(21, 1, 26513, 1556523781, 1, 0, 'e3f6007fcb0659107bcf30965aa75c583d9315dabeaf0c47c47c7eee2375a83e', 'pcbanner.jpg', 'portal/20190429/125f4f22caa84f24de12df628acc3fd2.jpg', 'e3f6007fcb0659107bcf30965aa75c58', 'cb2df8773c3111767c519edd519dbfee6b8fe3e4', 'jpg', NULL),
(22, 1, 80990, 1556523798, 1, 0, 'aa8b6129d14c4cdff834102204a31c38973c74034bf1b2811e65c5b4d18ecd74', 'kecheng@2x.png', 'default/20190429/fecb2418a023e2bf4fd84be58d2dde9e.png', 'aa8b6129d14c4cdff834102204a31c38', '19a69aa25ea8eb51e28caf48a089b0c227153f04', 'png', NULL),
(23, 1, 501838, 1556523813, 1, 0, '1b96dc4e78484647ea98ff4339f0d618da52823637ef85dd45581d3a3092105e', 'gongsitu@2x.png', 'portal/20190429/3121a98b17fdf1fb02ab5f21b8e1929f.png', '1b96dc4e78484647ea98ff4339f0d618', 'd2a2215eb4519bcf44ef0567930ed109627289a3', 'png', NULL),
(24, 1, 1479, 1556524863, 1, 0, '1a5e50b8f9d2916b9bd17e448e5e891fbc9ca5082fc681c0f557854a3bf04cb9', 'rencai@2x.png', 'portal/20190429/1945736e057830f4233cd8d65b62e57b.png', '1a5e50b8f9d2916b9bd17e448e5e891f', '3fd0264bdd986ecb63ea13cc7682c8b8f6c29fd2', 'png', NULL),
(25, 1, 2121, 1556526262, 1, 0, '73b55b3905ee410b8ae75f768ad5db7701151331e4ca09b0c2ab9237a8098faa', 'nengli@2x.png', 'portal/20190429/5951663d83c8d0893d72a6693e4471f7.png', '73b55b3905ee410b8ae75f768ad5db77', 'e47adf0f4658ece52137ffb18cbbc10071321686', 'png', NULL),
(26, 1, 153001, 1556528353, 1, 0, '1deffd306532df8337855de92e91a5c83ece1f83627ba5ad8cf39f6d188cc4ad', 'rencai2@2x.png', 'portal/20190429/c59476d9dc9bb77720c056fa58e94f98.png', '1deffd306532df8337855de92e91a5c8', '3e19e316f2ebd301af2561de0aef94762f8642d1', 'png', NULL),
(27, 1, 22963, 1556528735, 1, 0, '3a4a3fe1f51a3e8f53d96c5dc6b88a062781a8f8fe37cb4bf286c74f1ff659cf', 'c2.png', 'portal/20190429/3ba0bebeae9b35b66646fed6c431c219.png', '3a4a3fe1f51a3e8f53d96c5dc6b88a06', '17cb036a662b177e688b96bb5480b2c9e2b63d4a', 'png', NULL),
(28, 1, 80990, 1556529353, 1, 0, 'aa8b6129d14c4cdff834102204a31c38973c74034bf1b2811e65c5b4d18ecd74', 'kecheng@2x.png', 'portal/20190429/a1b641715a64787a3e72505a729db5e9.png', 'aa8b6129d14c4cdff834102204a31c38', '19a69aa25ea8eb51e28caf48a089b0c227153f04', 'png', NULL),
(29, 1, 26513, 1556532565, 1, 0, 'e3f6007fcb0659107bcf30965aa75c583d9315dabeaf0c47c47c7eee2375a83e', 'pcbanner.jpg', 'portal/20190429/08f408325e3667db34e36457211771fb.jpg', 'e3f6007fcb0659107bcf30965aa75c58', 'cb2df8773c3111767c519edd519dbfee6b8fe3e4', 'jpg', NULL),
(30, 1, 153001, 1556533969, 1, 0, '1deffd306532df8337855de92e91a5c83ece1f83627ba5ad8cf39f6d188cc4ad', 'rencai2@2x.png', 'portal/20190429/8a67cbf7545fdc3133aa9862b65547dc.png', '1deffd306532df8337855de92e91a5c8', '3e19e316f2ebd301af2561de0aef94762f8642d1', 'png', NULL),
(31, 1, 21750, 1556535739, 1, 0, '4648971ac95f73ad6d00af8afbc3ad924a5c72f154fc62912575e672ba2593e8', 'c3.png', 'portal/20190429/f11665cb022a20b3248590e2b8584b78.png', '4648971ac95f73ad6d00af8afbc3ad92', 'ac33481f9163eba68765e82cc6fdbf3bba18ae63', 'png', NULL),
(32, 1, 21750, 1556535793, 1, 0, '4648971ac95f73ad6d00af8afbc3ad924a5c72f154fc62912575e672ba2593e8', 'c3.png', 'portal/20190429/0376add8d72767e0d842af5ec8fbf881.png', '4648971ac95f73ad6d00af8afbc3ad92', 'ac33481f9163eba68765e82cc6fdbf3bba18ae63', 'png', NULL),
(33, 1, 103847, 1556536784, 1, 0, 'b894f749a4e1b8c63af5976661dd52173b22e9ea9d559e7479e45ae3909f5baa', 'y1.png', 'portal/20190429/8aca39c323e0db4acce237da57325b93.png', 'b894f749a4e1b8c63af5976661dd5217', 'eb24ee2a3e6042c5dcbd835df6625171b4960dd7', 'png', NULL),
(34, 1, 14066, 1556592151, 1, 0, 'eb547f4d119cd97b2b0cf2b4f9410bf730cde6e86ccaa842724a099981630f2b', 'oppo.png', 'admin/20190430/a82eb4743f729a149bb9329a37ca1973.png', 'eb547f4d119cd97b2b0cf2b4f9410bf7', '667e4b7d1db186fe638fba558cbb05b199bd3d43', 'png', NULL),
(35, 1, 26513, 1556593168, 1, 0, 'e3f6007fcb0659107bcf30965aa75c583d9315dabeaf0c47c47c7eee2375a83e', 'pcbanner.jpg', 'default/20190430/9cec09b639c89b0544dbe445969b2ae0.jpg', 'e3f6007fcb0659107bcf30965aa75c58', 'cb2df8773c3111767c519edd519dbfee6b8fe3e4', 'jpg', NULL),
(36, 1, 7744, 1556593568, 1, 0, '98c3075c7d301f855507eefffa47b85a3f438f501ab1cd1d1fb2dabe570bd2b6', '微信图片_20190430104214.png', 'admin/20190430/aa004752d3e6d2fb55c559f18090a7e3.png', '98c3075c7d301f855507eefffa47b85a', 'fc116e990440d0d3088090ecb6fe825853f5a596', 'png', NULL),
(37, 1, 457808, 1556594618, 1, 0, '74cf9cbb633386b889f15a9797169b7d994902c92dfa1f0c11c65ab21b6be11c', 'a5.jpg', 'admin/20190430/1d6665f998c24235cc6adef70bb63795.jpg', '74cf9cbb633386b889f15a9797169b7d', '681341dea81de5249e934e4bb03da50857f09ca5', 'jpg', NULL),
(38, 1, 457808, 1556594789, 1, 0, '74cf9cbb633386b889f15a9797169b7d994902c92dfa1f0c11c65ab21b6be11c', 'a5.jpg', 'admin/20190430/4f2778cd732002266a1aa3895ed3a00d.jpg', '74cf9cbb633386b889f15a9797169b7d', '681341dea81de5249e934e4bb03da50857f09ca5', 'jpg', NULL),
(39, 1, 457808, 1556594884, 1, 0, '74cf9cbb633386b889f15a9797169b7d994902c92dfa1f0c11c65ab21b6be11c', 'a5.jpg', 'admin/20190430/e34213bde9b47854292fa7468549ef18.jpg', '74cf9cbb633386b889f15a9797169b7d', '681341dea81de5249e934e4bb03da50857f09ca5', 'jpg', NULL),
(40, 1, 36921, 1556594985, 1, 0, 'f9c15e0bef1fbea58d3f05f56af56fb6a6170a62caa988cbf1de2bd25376976b', 'a2.jpg', 'admin/20190430/7d3def651f91e7f676c4c32a6ac712e8.jpg', 'f9c15e0bef1fbea58d3f05f56af56fb6', '5072b8d2a29b0b24f58028c1ecea1959a3e77b45', 'jpg', NULL),
(41, 1, 797018, 1556595150, 1, 0, 'f83722a3b92f961d8bb6037ec81c14d8f4a1f7f7bd8b2b0e6bd03a723da7f85d', 'tea3.jpg', 'admin/20190430/0f25e2c19570e59e2fa5651bb84268fa.jpg', 'f83722a3b92f961d8bb6037ec81c14d8', '18274455ee0f64142740e06a32810d7969951f78', 'jpg', NULL),
(42, 1, 129578, 1556595457, 1, 0, '4e98e7e8bb1fa28db4f7a49df3159938e331599e67f1a69c6170579fa3765d72', 'a4.jpg', 'admin/20190430/74c98638c39540f268a3a649e6c822f3.jpg', '4e98e7e8bb1fa28db4f7a49df3159938', '85d28c1609e3bbe5abd87bf70495c25ab78940d7', 'jpg', NULL),
(43, 1, 7562, 1556595561, 1, 0, '18f4164b5da523acdd43039ee176e89468a93feed0ce90f8db0381644fc9c99e', '微信图片_20190430113851.png', 'admin/20190430/d11bf322301209bb347478436cd9bc08.png', '18f4164b5da523acdd43039ee176e894', '05e3b25e7d69169cb0d843d51fa298d16d755c0a', 'png', NULL),
(44, 1, 7744, 1556595581, 1, 0, '98c3075c7d301f855507eefffa47b85a3f438f501ab1cd1d1fb2dabe570bd2b6', '微信图片_20190430104214.png', 'admin/20190430/e6d82bb5040ca725f461d405879f4cac.png', '98c3075c7d301f855507eefffa47b85a', 'fc116e990440d0d3088090ecb6fe825853f5a596', 'png', NULL),
(45, 1, 5464, 1556595604, 1, 0, '293e8fff829a2e7db14ec918eb7b7454c7ebb19701c36c0efd72ff4096790efa', '微信图片_20190430113902.png', 'admin/20190430/490e3c651320e449cc8afa485e54d0bc.png', '293e8fff829a2e7db14ec918eb7b7454', '6054588bae7760fbf03fc180bef998133270f9fb', 'png', NULL),
(46, 1, 7744, 1556595786, 1, 0, '98c3075c7d301f855507eefffa47b85a3f438f501ab1cd1d1fb2dabe570bd2b6', '微信图片_20190430104214.png', 'admin/20190430/6d9ed35a9e99d335b53fb6652e589e16.png', '98c3075c7d301f855507eefffa47b85a', 'fc116e990440d0d3088090ecb6fe825853f5a596', 'png', NULL),
(47, 1, 7616, 1556595795, 1, 0, '70a68f86b8fb00be76c3778f742a9e46dfa2f657d5725b11f1009fd88963107c', '微信图片_20190430113857.png', 'admin/20190430/cf9555ce6ac28f663d83077b72b0e6c5.png', '70a68f86b8fb00be76c3778f742a9e46', '964fd106f93f464dd17e1c4f631713bfd10ee11e', 'png', NULL),
(48, 1, 30607, 1556600934, 1, 0, 'fdc08551bf488fde878a029bedf93b787ce898493276d7d792483a72d1d70099', '微信图片_20190430130835.png', 'admin/20190430/3b75d67d5e30844a4fc43490298a4e54.png', 'fdc08551bf488fde878a029bedf93b78', '336f45dc7dd0c8ead63a367b78e85998d9a1245f', 'png', NULL),
(49, 1, 29383, 1556600979, 1, 0, '531e2d36709dec060f9baa02b1cc3871c3c5a56083e603093c8007da39f4d0a2', '微信图片_20190430130829.png', 'admin/20190430/d3a981a8bcc19af3158907d83bab1f09.png', '531e2d36709dec060f9baa02b1cc3871', '6eeba520793d2e9101f367a01b6751e3fab628b0', 'png', NULL),
(50, 1, 29383, 1556601093, 1, 0, '531e2d36709dec060f9baa02b1cc3871c3c5a56083e603093c8007da39f4d0a2', '微信图片_20190430130829.png', 'admin/20190430/aa19ba4d1f2b695ce4454ef199c0bfc1.png', '531e2d36709dec060f9baa02b1cc3871', '6eeba520793d2e9101f367a01b6751e3fab628b0', 'png', NULL),
(51, 1, 31577, 1556604778, 1, 0, 'dc9c2aa14c64b51f44f008477d512955fd64840520162f1b7f9e07046f04b2d9', 'left.jpg', 'default/20190430/d464793e9406c8849bc2b9576dfee4ad.jpg', 'dc9c2aa14c64b51f44f008477d512955', 'c6dddc6398dae0cfd8dc9549a0befb0f93edf920', 'jpg', NULL),
(52, 1, 88645, 1556604798, 1, 0, '9b84d97542f916cb4d7855f402449c1205f59d9b093efba4851972a8eaf419ab', '5fdf8db1cb134954d3dd657a584e9258d0094ae9.jpg', 'admin/20190430/a11d0ff5bf0c338e00e4ab8fde29feef.jpg', '9b84d97542f916cb4d7855f402449c12', 'fb89ce27672eccae75688143ced11098b1ce8c2a', 'jpg', NULL),
(53, 1, 31577, 1556604867, 1, 0, 'dc9c2aa14c64b51f44f008477d512955fd64840520162f1b7f9e07046f04b2d9', 'left.jpg', 'admin/20190430/aac1557ccb9b16514c12f9695c48dd24.jpg', 'dc9c2aa14c64b51f44f008477d512955', 'c6dddc6398dae0cfd8dc9549a0befb0f93edf920', 'jpg', NULL),
(54, 1, 31577, 1556604913, 1, 0, 'dc9c2aa14c64b51f44f008477d512955fd64840520162f1b7f9e07046f04b2d9', 'left.jpg', 'admin/20190430/f7f29c840a80b5ebf6d7ec5051fd24cf.jpg', 'dc9c2aa14c64b51f44f008477d512955', 'c6dddc6398dae0cfd8dc9549a0befb0f93edf920', 'jpg', NULL),
(55, 1, 36921, 1556605355, 1, 0, 'f9c15e0bef1fbea58d3f05f56af56fb6a6170a62caa988cbf1de2bd25376976b', 'a2.jpg', 'admin/20190430/173f268c974336b8dd7805c9828e9ccb.jpg', 'f9c15e0bef1fbea58d3f05f56af56fb6', '5072b8d2a29b0b24f58028c1ecea1959a3e77b45', 'jpg', NULL),
(56, 1, 269103, 1556605367, 1, 0, '8e17442bd500a4842d456a95ec0228263b93560d4290575f67b46e07baafef8c', 'promis.jpg', 'default/20190430/c4e88ce0d60e7bd7f3f03dce31704183.jpg', '8e17442bd500a4842d456a95ec022826', '1275dbee421aad916fb0983e68d0f5e64c0acee6', 'jpg', NULL),
(57, 1, 36921, 1556606146, 1, 0, 'f9c15e0bef1fbea58d3f05f56af56fb6a6170a62caa988cbf1de2bd25376976b', 'a2.jpg', 'admin/20190430/a66cb851732881592d626c5f9139d7b7.jpg', 'f9c15e0bef1fbea58d3f05f56af56fb6', '5072b8d2a29b0b24f58028c1ecea1959a3e77b45', 'jpg', NULL),
(58, 1, 36921, 1556611426, 1, 0, 'f9c15e0bef1fbea58d3f05f56af56fb6a6170a62caa988cbf1de2bd25376976b', 'a2.jpg', 'admin/20190430/ad1c917e7c808f85429570958804a48a.jpg', 'f9c15e0bef1fbea58d3f05f56af56fb6', '5072b8d2a29b0b24f58028c1ecea1959a3e77b45', 'jpg', NULL),
(59, 1, 36921, 1556617869, 1, 0, 'f9c15e0bef1fbea58d3f05f56af56fb6a6170a62caa988cbf1de2bd25376976b', 'a2.jpg', 'admin/20190430/769413f7efc131f2f0ad0177bb77e9c1.jpg', 'f9c15e0bef1fbea58d3f05f56af56fb6', '5072b8d2a29b0b24f58028c1ecea1959a3e77b45', 'jpg', NULL),
(60, 1, 31577, 1556617980, 1, 0, 'dc9c2aa14c64b51f44f008477d512955fd64840520162f1b7f9e07046f04b2d9', 'left.jpg', 'admin/20190430/e6d946dd74c2830cfb4607cd972e2071.jpg', 'dc9c2aa14c64b51f44f008477d512955', 'c6dddc6398dae0cfd8dc9549a0befb0f93edf920', 'jpg', NULL),
(61, 1, 53652, 1556618302, 1, 0, '40ed0ef24d880f7a7908e2c2f361d99c4b98fe74d6fc5044d26515ddc8355117', 'a6.jpg', 'admin/20190430/2f066709f648fb4da422fd1c6109699d.jpg', '40ed0ef24d880f7a7908e2c2f361d99c', '890f60a8de5efd0018452b3746aa8433aa76e2f2', 'jpg', NULL),
(62, 1, 457808, 1556618540, 1, 0, '74cf9cbb633386b889f15a9797169b7d994902c92dfa1f0c11c65ab21b6be11c', 'a5.jpg', 'admin/20190430/398259a359c0f6017db1dc8da6ee21f2.jpg', '74cf9cbb633386b889f15a9797169b7d', '681341dea81de5249e934e4bb03da50857f09ca5', 'jpg', NULL),
(63, 1, 129578, 1556618598, 1, 0, '4e98e7e8bb1fa28db4f7a49df3159938e331599e67f1a69c6170579fa3765d72', 'a4.jpg', 'admin/20190430/695a781bb13e4af9e4460854c7dab175.jpg', '4e98e7e8bb1fa28db4f7a49df3159938', '85d28c1609e3bbe5abd87bf70495c25ab78940d7', 'jpg', NULL);

-- --------------------------------------------------------

--
-- 表的结构 `cmf_auth_access`
--

CREATE TABLE `cmf_auth_access` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `role_id` int(10) UNSIGNED NOT NULL COMMENT '角色',
  `rule_name` varchar(100) NOT NULL DEFAULT '' COMMENT '规则唯一英文标识,全小写',
  `type` varchar(30) NOT NULL DEFAULT '' COMMENT '权限规则分类,请加应用前缀,如admin_'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='权限授权表';

-- --------------------------------------------------------

--
-- 表的结构 `cmf_auth_rule`
--

CREATE TABLE `cmf_auth_rule` (
  `id` int(10) UNSIGNED NOT NULL COMMENT '规则id,自增主键',
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '是否有效(0:无效,1:有效)',
  `app` varchar(40) NOT NULL DEFAULT '' COMMENT '规则所属app',
  `type` varchar(30) NOT NULL DEFAULT '' COMMENT '权限规则分类，请加应用前缀,如admin_',
  `name` varchar(100) NOT NULL DEFAULT '' COMMENT '规则唯一英文标识,全小写',
  `param` varchar(100) NOT NULL DEFAULT '' COMMENT '额外url参数',
  `title` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '规则描述',
  `condition` varchar(200) NOT NULL DEFAULT '' COMMENT '规则附加条件'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='权限规则表';

--
-- 转存表中的数据 `cmf_auth_rule`
--

INSERT INTO `cmf_auth_rule` (`id`, `status`, `app`, `type`, `name`, `param`, `title`, `condition`) VALUES
(1, 1, 'admin', 'admin_url', 'admin/Hook/index', '', '钩子管理', ''),
(2, 1, 'admin', 'admin_url', 'admin/Hook/plugins', '', '钩子插件管理', ''),
(3, 1, 'admin', 'admin_url', 'admin/Hook/pluginListOrder', '', '钩子插件排序', ''),
(4, 1, 'admin', 'admin_url', 'admin/Hook/sync', '', '同步钩子', ''),
(5, 1, 'admin', 'admin_url', 'admin/Link/index', '', '友情链接', ''),
(6, 1, 'admin', 'admin_url', 'admin/Link/add', '', '添加友情链接', ''),
(7, 1, 'admin', 'admin_url', 'admin/Link/addPost', '', '添加友情链接提交保存', ''),
(8, 1, 'admin', 'admin_url', 'admin/Link/edit', '', '编辑友情链接', ''),
(9, 1, 'admin', 'admin_url', 'admin/Link/editPost', '', '编辑友情链接提交保存', ''),
(10, 1, 'admin', 'admin_url', 'admin/Link/delete', '', '删除友情链接', ''),
(11, 1, 'admin', 'admin_url', 'admin/Link/listOrder', '', '友情链接排序', ''),
(12, 1, 'admin', 'admin_url', 'admin/Link/toggle', '', '友情链接显示隐藏', ''),
(13, 1, 'admin', 'admin_url', 'admin/Mailer/index', '', '邮箱配置', ''),
(14, 1, 'admin', 'admin_url', 'admin/Mailer/indexPost', '', '邮箱配置提交保存', ''),
(15, 1, 'admin', 'admin_url', 'admin/Mailer/template', '', '邮件模板', ''),
(16, 1, 'admin', 'admin_url', 'admin/Mailer/templatePost', '', '邮件模板提交', ''),
(17, 1, 'admin', 'admin_url', 'admin/Mailer/test', '', '邮件发送测试', ''),
(18, 1, 'admin', 'admin_url', 'admin/Menu/index', '', '后台菜单', ''),
(19, 1, 'admin', 'admin_url', 'admin/Menu/lists', '', '所有菜单', ''),
(20, 1, 'admin', 'admin_url', 'admin/Menu/add', '', '后台菜单添加', ''),
(21, 1, 'admin', 'admin_url', 'admin/Menu/addPost', '', '后台菜单添加提交保存', ''),
(22, 1, 'admin', 'admin_url', 'admin/Menu/edit', '', '后台菜单编辑', ''),
(23, 1, 'admin', 'admin_url', 'admin/Menu/editPost', '', '后台菜单编辑提交保存', ''),
(24, 1, 'admin', 'admin_url', 'admin/Menu/delete', '', '后台菜单删除', ''),
(25, 1, 'admin', 'admin_url', 'admin/Menu/listOrder', '', '后台菜单排序', ''),
(26, 1, 'admin', 'admin_url', 'admin/Menu/getActions', '', '导入新后台菜单', ''),
(27, 1, 'admin', 'admin_url', 'admin/Nav/index', '', '导航管理', ''),
(28, 1, 'admin', 'admin_url', 'admin/Nav/add', '', '添加导航', ''),
(29, 1, 'admin', 'admin_url', 'admin/Nav/addPost', '', '添加导航提交保存', ''),
(30, 1, 'admin', 'admin_url', 'admin/Nav/edit', '', '编辑导航', ''),
(31, 1, 'admin', 'admin_url', 'admin/Nav/editPost', '', '编辑导航提交保存', ''),
(32, 1, 'admin', 'admin_url', 'admin/Nav/delete', '', '删除导航', ''),
(33, 1, 'admin', 'admin_url', 'admin/NavMenu/index', '', '导航菜单', ''),
(34, 1, 'admin', 'admin_url', 'admin/NavMenu/add', '', '添加导航菜单', ''),
(35, 1, 'admin', 'admin_url', 'admin/NavMenu/addPost', '', '添加导航菜单提交保存', ''),
(36, 1, 'admin', 'admin_url', 'admin/NavMenu/edit', '', '编辑导航菜单', ''),
(37, 1, 'admin', 'admin_url', 'admin/NavMenu/editPost', '', '编辑导航菜单提交保存', ''),
(38, 1, 'admin', 'admin_url', 'admin/NavMenu/delete', '', '删除导航菜单', ''),
(39, 1, 'admin', 'admin_url', 'admin/NavMenu/listOrder', '', '导航菜单排序', ''),
(40, 1, 'admin', 'admin_url', 'admin/Plugin/default', '', '插件中心', ''),
(41, 1, 'admin', 'admin_url', 'admin/Plugin/index', '', '插件列表', ''),
(42, 1, 'admin', 'admin_url', 'admin/Plugin/toggle', '', '插件启用禁用', ''),
(43, 1, 'admin', 'admin_url', 'admin/Plugin/setting', '', '插件设置', ''),
(44, 1, 'admin', 'admin_url', 'admin/Plugin/settingPost', '', '插件设置提交', ''),
(45, 1, 'admin', 'admin_url', 'admin/Plugin/install', '', '插件安装', ''),
(46, 1, 'admin', 'admin_url', 'admin/Plugin/update', '', '插件更新', ''),
(47, 1, 'admin', 'admin_url', 'admin/Plugin/uninstall', '', '卸载插件', ''),
(48, 1, 'admin', 'admin_url', 'admin/Rbac/index', '', '角色管理', ''),
(49, 1, 'admin', 'admin_url', 'admin/Rbac/roleAdd', '', '添加角色', ''),
(50, 1, 'admin', 'admin_url', 'admin/Rbac/roleAddPost', '', '添加角色提交', ''),
(51, 1, 'admin', 'admin_url', 'admin/Rbac/roleEdit', '', '编辑角色', ''),
(52, 1, 'admin', 'admin_url', 'admin/Rbac/roleEditPost', '', '编辑角色提交', ''),
(53, 1, 'admin', 'admin_url', 'admin/Rbac/roleDelete', '', '删除角色', ''),
(54, 1, 'admin', 'admin_url', 'admin/Rbac/authorize', '', '设置角色权限', ''),
(55, 1, 'admin', 'admin_url', 'admin/Rbac/authorizePost', '', '角色授权提交', ''),
(56, 1, 'admin', 'admin_url', 'admin/RecycleBin/index', '', '回收站', ''),
(57, 1, 'admin', 'admin_url', 'admin/RecycleBin/restore', '', '回收站还原', ''),
(58, 1, 'admin', 'admin_url', 'admin/RecycleBin/delete', '', '回收站彻底删除', ''),
(59, 1, 'admin', 'admin_url', 'admin/Route/index', '', 'URL美化', ''),
(60, 1, 'admin', 'admin_url', 'admin/Route/add', '', '添加路由规则', ''),
(61, 1, 'admin', 'admin_url', 'admin/Route/addPost', '', '添加路由规则提交', ''),
(62, 1, 'admin', 'admin_url', 'admin/Route/edit', '', '路由规则编辑', ''),
(63, 1, 'admin', 'admin_url', 'admin/Route/editPost', '', '路由规则编辑提交', ''),
(64, 1, 'admin', 'admin_url', 'admin/Route/delete', '', '路由规则删除', ''),
(65, 1, 'admin', 'admin_url', 'admin/Route/ban', '', '路由规则禁用', ''),
(66, 1, 'admin', 'admin_url', 'admin/Route/open', '', '路由规则启用', ''),
(67, 1, 'admin', 'admin_url', 'admin/Route/listOrder', '', '路由规则排序', ''),
(68, 1, 'admin', 'admin_url', 'admin/Route/select', '', '选择URL', ''),
(69, 1, 'admin', 'admin_url', 'admin/Setting/default', '', '设置', ''),
(70, 1, 'admin', 'admin_url', 'admin/Setting/site', '', '网站信息', ''),
(71, 1, 'admin', 'admin_url', 'admin/Setting/sitePost', '', '网站信息设置提交', ''),
(72, 1, 'admin', 'admin_url', 'admin/Setting/password', '', '密码修改', ''),
(73, 1, 'admin', 'admin_url', 'admin/Setting/passwordPost', '', '密码修改提交', ''),
(74, 1, 'admin', 'admin_url', 'admin/Setting/upload', '', '上传设置', ''),
(75, 1, 'admin', 'admin_url', 'admin/Setting/uploadPost', '', '上传设置提交', ''),
(76, 1, 'admin', 'admin_url', 'admin/Setting/clearCache', '', '清除缓存', ''),
(77, 1, 'admin', 'admin_url', 'admin/Slide/index', '', '幻灯片管理', ''),
(78, 1, 'admin', 'admin_url', 'admin/Slide/add', '', '添加幻灯片', ''),
(79, 1, 'admin', 'admin_url', 'admin/Slide/addPost', '', '添加幻灯片提交', ''),
(80, 1, 'admin', 'admin_url', 'admin/Slide/edit', '', '编辑幻灯片', ''),
(81, 1, 'admin', 'admin_url', 'admin/Slide/editPost', '', '编辑幻灯片提交', ''),
(82, 1, 'admin', 'admin_url', 'admin/Slide/delete', '', '删除幻灯片', ''),
(83, 1, 'admin', 'admin_url', 'admin/SlideItem/index', '', '幻灯片页面列表', ''),
(84, 1, 'admin', 'admin_url', 'admin/SlideItem/add', '', '幻灯片页面添加', ''),
(85, 1, 'admin', 'admin_url', 'admin/SlideItem/addPost', '', '幻灯片页面添加提交', ''),
(86, 1, 'admin', 'admin_url', 'admin/SlideItem/edit', '', '幻灯片页面编辑', ''),
(87, 1, 'admin', 'admin_url', 'admin/SlideItem/editPost', '', '幻灯片页面编辑提交', ''),
(88, 1, 'admin', 'admin_url', 'admin/SlideItem/delete', '', '幻灯片页面删除', ''),
(89, 1, 'admin', 'admin_url', 'admin/SlideItem/ban', '', '幻灯片页面隐藏', ''),
(90, 1, 'admin', 'admin_url', 'admin/SlideItem/cancelBan', '', '幻灯片页面显示', ''),
(91, 1, 'admin', 'admin_url', 'admin/SlideItem/listOrder', '', '幻灯片页面排序', ''),
(92, 1, 'admin', 'admin_url', 'admin/Storage/index', '', '文件存储', ''),
(93, 1, 'admin', 'admin_url', 'admin/Storage/settingPost', '', '文件存储设置提交', ''),
(94, 1, 'admin', 'admin_url', 'admin/Theme/index', '', '模板管理', ''),
(95, 1, 'admin', 'admin_url', 'admin/Theme/install', '', '安装模板', ''),
(96, 1, 'admin', 'admin_url', 'admin/Theme/uninstall', '', '卸载模板', ''),
(97, 1, 'admin', 'admin_url', 'admin/Theme/installTheme', '', '模板安装', ''),
(98, 1, 'admin', 'admin_url', 'admin/Theme/update', '', '模板更新', ''),
(99, 1, 'admin', 'admin_url', 'admin/Theme/active', '', '启用模板', ''),
(100, 1, 'admin', 'admin_url', 'admin/Theme/files', '', '模板文件列表', ''),
(101, 1, 'admin', 'admin_url', 'admin/Theme/fileSetting', '', '模板文件设置', ''),
(102, 1, 'admin', 'admin_url', 'admin/Theme/fileArrayData', '', '模板文件数组数据列表', ''),
(103, 1, 'admin', 'admin_url', 'admin/Theme/fileArrayDataEdit', '', '模板文件数组数据添加编辑', ''),
(104, 1, 'admin', 'admin_url', 'admin/Theme/fileArrayDataEditPost', '', '模板文件数组数据添加编辑提交保存', ''),
(105, 1, 'admin', 'admin_url', 'admin/Theme/fileArrayDataDelete', '', '模板文件数组数据删除', ''),
(106, 1, 'admin', 'admin_url', 'admin/Theme/settingPost', '', '模板文件编辑提交保存', ''),
(107, 1, 'admin', 'admin_url', 'admin/Theme/dataSource', '', '模板文件设置数据源', ''),
(108, 1, 'admin', 'admin_url', 'admin/Theme/design', '', '模板设计', ''),
(109, 1, 'admin', 'admin_url', 'admin/User/default', '', '管理组', ''),
(110, 1, 'admin', 'admin_url', 'admin/User/index', '', '管理员', ''),
(111, 1, 'admin', 'admin_url', 'admin/User/add', '', '管理员添加', ''),
(112, 1, 'admin', 'admin_url', 'admin/User/addPost', '', '管理员添加提交', ''),
(113, 1, 'admin', 'admin_url', 'admin/User/edit', '', '管理员编辑', ''),
(114, 1, 'admin', 'admin_url', 'admin/User/editPost', '', '管理员编辑提交', ''),
(115, 1, 'admin', 'admin_url', 'admin/User/userInfo', '', '个人信息', ''),
(116, 1, 'admin', 'admin_url', 'admin/User/userInfoPost', '', '管理员个人信息修改提交', ''),
(117, 1, 'admin', 'admin_url', 'admin/User/delete', '', '管理员删除', ''),
(118, 1, 'admin', 'admin_url', 'admin/User/ban', '', '停用管理员', ''),
(119, 1, 'admin', 'admin_url', 'admin/User/cancelBan', '', '启用管理员', ''),
(120, 1, 'portal', 'admin_url', 'portal/AdminArticle/index', '', '文章管理', ''),
(121, 1, 'portal', 'admin_url', 'portal/AdminArticle/add', '', '添加文章', ''),
(122, 1, 'portal', 'admin_url', 'portal/AdminArticle/addPost', '', '添加文章提交', ''),
(123, 1, 'portal', 'admin_url', 'portal/AdminArticle/edit', '', '编辑文章', ''),
(124, 1, 'portal', 'admin_url', 'portal/AdminArticle/editPost', '', '编辑文章提交', ''),
(125, 1, 'portal', 'admin_url', 'portal/AdminArticle/delete', '', '文章删除', ''),
(126, 1, 'portal', 'admin_url', 'portal/AdminArticle/publish', '', '文章发布', ''),
(127, 1, 'portal', 'admin_url', 'portal/AdminArticle/top', '', '文章置顶', ''),
(128, 1, 'portal', 'admin_url', 'portal/AdminArticle/recommend', '', '文章推荐', ''),
(129, 1, 'portal', 'admin_url', 'portal/AdminArticle/listOrder', '', '文章排序', ''),
(130, 1, 'portal', 'admin_url', 'portal/AdminCategory/index', '', '分类管理', ''),
(131, 1, 'portal', 'admin_url', 'portal/AdminCategory/add', '', '添加文章分类', ''),
(132, 1, 'portal', 'admin_url', 'portal/AdminCategory/addPost', '', '添加文章分类提交', ''),
(133, 1, 'portal', 'admin_url', 'portal/AdminCategory/edit', '', '编辑文章分类', ''),
(134, 1, 'portal', 'admin_url', 'portal/AdminCategory/editPost', '', '编辑文章分类提交', ''),
(135, 1, 'portal', 'admin_url', 'portal/AdminCategory/select', '', '文章分类选择对话框', ''),
(136, 1, 'portal', 'admin_url', 'portal/AdminCategory/listOrder', '', '文章分类排序', ''),
(137, 1, 'portal', 'admin_url', 'portal/AdminCategory/delete', '', '删除文章分类', ''),
(138, 1, 'portal', 'admin_url', 'portal/AdminIndex/default', '', '门户管理', ''),
(139, 1, 'portal', 'admin_url', 'portal/AdminPage/index', '', '页面管理', ''),
(140, 1, 'portal', 'admin_url', 'portal/AdminPage/add', '', '添加页面', ''),
(141, 1, 'portal', 'admin_url', 'portal/AdminPage/addPost', '', '添加页面提交', ''),
(142, 1, 'portal', 'admin_url', 'portal/AdminPage/edit', '', '编辑页面', ''),
(143, 1, 'portal', 'admin_url', 'portal/AdminPage/editPost', '', '编辑页面提交', ''),
(144, 1, 'portal', 'admin_url', 'portal/AdminPage/delete', '', '删除页面', ''),
(145, 1, 'portal', 'admin_url', 'portal/AdminTag/index', '', '文章标签', ''),
(146, 1, 'portal', 'admin_url', 'portal/AdminTag/add', '', '添加文章标签', ''),
(147, 1, 'portal', 'admin_url', 'portal/AdminTag/addPost', '', '添加文章标签提交', ''),
(148, 1, 'portal', 'admin_url', 'portal/AdminTag/upStatus', '', '更新标签状态', ''),
(149, 1, 'portal', 'admin_url', 'portal/AdminTag/delete', '', '删除文章标签', ''),
(150, 1, 'user', 'admin_url', 'user/AdminAsset/index', '', '资源管理', ''),
(151, 1, 'user', 'admin_url', 'user/AdminAsset/delete', '', '删除文件', ''),
(152, 1, 'user', 'admin_url', 'user/AdminIndex/default', '', '用户管理', ''),
(153, 1, 'user', 'admin_url', 'user/AdminIndex/default1', '', '用户组', ''),
(154, 1, 'user', 'admin_url', 'user/AdminIndex/index', '', '本站用户', ''),
(155, 1, 'user', 'admin_url', 'user/AdminIndex/ban', '', '本站用户拉黑', ''),
(156, 1, 'user', 'admin_url', 'user/AdminIndex/cancelBan', '', '本站用户启用', ''),
(157, 1, 'user', 'admin_url', 'user/AdminOauth/index', '', '第三方用户', ''),
(158, 1, 'user', 'admin_url', 'user/AdminOauth/delete', '', '删除第三方用户绑定', ''),
(159, 1, 'user', 'admin_url', 'user/AdminUserAction/index', '', '用户操作管理', ''),
(160, 1, 'user', 'admin_url', 'user/AdminUserAction/edit', '', '编辑用户操作', ''),
(161, 1, 'user', 'admin_url', 'user/AdminUserAction/editPost', '', '编辑用户操作提交', ''),
(162, 1, 'user', 'admin_url', 'user/AdminUserAction/sync', '', '同步用户操作', ''),
(163, 1, 'portal', 'admin_url', 'portal/AdminCityCategory/index', '', '城市分类', ''),
(164, 1, 'portal', 'admin_url', 'portal/AdminStar/default', '', '星球奇境', ''),
(165, 1, 'portal', 'admin_url', 'portal/AdminStarStory/index', '', '星球故事', ''),
(166, 1, 'portal', 'admin_url', 'portal/AdminStarScenery/index', '', '网红美景', ''),
(167, 1, 'portal', 'admin_url', 'portal/AdminStarFood/index', '', '异域珍馐', ''),
(168, 1, 'portal', 'admin_url', 'portal/AdminStarHotel/index', '', '良宿美寝', ''),
(169, 1, 'portal', 'admin_url', 'portal/AdminStarEcology/index', '', '活力生态', ''),
(170, 1, 'portal', 'admin_url', 'portal/AdminStarTrip/index', '', '便利出行', ''),
(171, 1, 'portal', 'admin_url', 'portal/AdminRegion/default', '', '星域秀场', ''),
(172, 1, 'portal', 'admin_url', 'portal/AdminRegionVideo/index', '', '星球影院', ''),
(173, 1, 'portal', 'admin_url', 'portal/AdminRegionStar/index', '', '明星访谈', ''),
(174, 1, 'portal', 'admin_url', 'portal/AdminRegionStory/index', '', '星球故事', ''),
(175, 1, 'portal', 'admin_url', 'portal/AdminRegionGallery/index', '', '星球画廊', ''),
(176, 1, 'portal', 'admin_url', 'portal/AdminRegionNews/index', '', '独角快报', ''),
(177, 1, 'portal', 'admin_url', 'portal/AdminRegionNote/index', '', '独角日志', ''),
(178, 1, 'portal', 'admin_url', 'portal/AdminRegionFuture/index', '', '童趣未来', ''),
(179, 1, 'portal', 'admin_url', 'portal/AdminEnjoy/default', '', '星享体验', ''),
(180, 1, 'portal', 'admin_url', 'portal/AdminEnjoyOwn/index', '', '亲临现场', ''),
(181, 1, 'portal', 'admin_url', 'portal/AdminEnjoyRoam/index', '', '市井漫游', ''),
(182, 1, 'portal', 'admin_url', 'portal/AdminEnjoyFeast/index', '', '视听盛宴', ''),
(183, 1, 'portal', 'admin_url', 'portal/AdminEnjoySky/index', '', '户外天堂', ''),
(184, 1, 'portal', 'admin_url', 'portal/AdminScout/default', '', '星探推荐', ''),
(185, 1, 'portal', 'admin_url', 'portal/AdminScoutTravel/index', '', '旅游路线', ''),
(186, 1, 'portal', 'admin_url', 'portal/AdminScoutScenery/index', '', '地道风物', ''),
(187, 1, 'portal', 'admin_url', 'portal/AdminScoutDesign/index', '', '创意设计', ''),
(188, 1, 'portal', 'admin_url', 'portal/AdminScoutLike/index', '', '悦己悦人', ''),
(189, 1, 'portal', 'admin_url', 'portal/AdminExe/default', '', '星际活动', ''),
(190, 1, 'portal', 'admin_url', 'portal/AdminActive/index', '', '星际活动', ''),
(191, 1, 'admin', 'admin_url', 'admin/Cooperation/index', '', '合作伙伴', ''),
(192, 1, 'admin', 'admin_url', 'admin/Focus/index', '', '关注我们', ''),
(193, 1, 'portal', 'admin_url', 'portal/AdminAbout/default', '', '关于我们', ''),
(194, 1, 'portal', 'admin_url', 'portal/AdminAboutUs/edit', '', '关于我们', ''),
(195, 1, 'admin', 'admin_url', 'admin/AboutUs/index', '', '关于我们', '');

-- --------------------------------------------------------

--
-- 表的结构 `cmf_city_category`
--

CREATE TABLE `cmf_city_category` (
  `id` int(10) UNSIGNED NOT NULL COMMENT '主键id',
  `pid` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '分类id',
  `name` varchar(10) CHARACTER SET utf8 NOT NULL COMMENT '分类名称',
  `create_time` int(10) UNSIGNED NOT NULL COMMENT '创建时间',
  `update_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '更新时间',
  `delete_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '删除时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='城市分类表';

--
-- 转存表中的数据 `cmf_city_category`
--

INSERT INTO `cmf_city_category` (`id`, `pid`, `name`, `create_time`, `update_time`, `delete_time`) VALUES
(1, 0, '亚洲', 1554885456, 1554894018, 0),
(2, 0, '欧洲', 1554888943, 0, 0),
(3, 0, '非洲', 1554888954, 0, 0),
(4, 0, '大洋洲', 1554888963, 0, 0),
(5, 0, '北美洲', 1554888979, 0, 0),
(6, 0, '南美洲', 1554888989, 0, 0),
(7, 3, '纳米比亚', 1554889030, 0, 0),
(8, 3, '卢旺达', 1554889071, 0, 0),
(9, 3, '坦桑尼亚', 1554889101, 0, 0),
(15, 3, '塞舌尔', 1554890144, 0, 0),
(16, 3, '留尼旺', 1554890157, 0, 0),
(17, 5, '巴哈马', 1554893498, 0, 0),
(18, 2, '英国', 1554893532, 0, 0),
(19, 1, '中国', 1554893623, 1555638684, 0),
(20, 0, '太平洋', 1554943202, 0, 0),
(22, 20, '太平洋', 1554944669, 1556344450, 0),
(23, 20, '太平洋2', 1556344530, 1556344540, 0);

-- --------------------------------------------------------

--
-- 表的结构 `cmf_comment`
--

CREATE TABLE `cmf_comment` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `parent_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '被回复的评论id',
  `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '发表评论的用户id',
  `to_user_id` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '被评论的用户id',
  `object_id` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '评论内容 id',
  `like_count` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '点赞数',
  `dislike_count` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '不喜欢数',
  `floor` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '楼层数',
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '评论时间',
  `delete_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '删除时间',
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '状态,1:已审核,0:未审核',
  `type` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '评论类型；1实名评论',
  `table_name` varchar(64) NOT NULL DEFAULT '' COMMENT '评论内容所在表，不带表前缀',
  `full_name` varchar(50) NOT NULL DEFAULT '' COMMENT '评论者昵称',
  `email` varchar(255) NOT NULL DEFAULT '' COMMENT '评论者邮箱',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT '层级关系',
  `url` text COMMENT '原文地址',
  `content` text CHARACTER SET utf8mb4 COMMENT '评论内容',
  `more` text CHARACTER SET utf8mb4 COMMENT '扩展属性'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='评论表';

-- --------------------------------------------------------

--
-- 表的结构 `cmf_cooperation`
--

CREATE TABLE `cmf_cooperation` (
  `id` int(10) UNSIGNED NOT NULL COMMENT '主键id',
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '状态默认1；0：隐藏；1：显示',
  `name` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '合作伙伴名称',
  `image` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '合作伙伴图片',
  `weigh` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '权重'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='合作伙伴表';

--
-- 转存表中的数据 `cmf_cooperation`
--

INSERT INTO `cmf_cooperation` (`id`, `status`, `name`, `image`, `weigh`) VALUES
(1, 1, '关于独角星球', 'admin/20190430/a11d0ff5bf0c338e00e4ab8fde29feef.jpg', 0),
(3, 1, '阿里巴巴', 'admin/20190430/d11bf322301209bb347478436cd9bc08.png', 0),
(4, 1, '新浪微博', 'admin/20190430/490e3c651320e449cc8afa485e54d0bc.png', 0);

-- --------------------------------------------------------

--
-- 表的结构 `cmf_focus`
--

CREATE TABLE `cmf_focus` (
  `id` int(10) UNSIGNED NOT NULL COMMENT '主键id',
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '状态默认1；0：隐藏；1：显示',
  `name` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '关注我们名称',
  `image` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '关注我们图片',
  `weigh` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '权重'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='关注我们表';

--
-- 转存表中的数据 `cmf_focus`
--

INSERT INTO `cmf_focus` (`id`, `status`, `name`, `image`, `weigh`) VALUES
(3, 1, '官方微信', 'admin/20190430/3b75d67d5e30844a4fc43490298a4e54.png', 10),
(4, 1, '官方微博', 'admin/20190430/d3a981a8bcc19af3158907d83bab1f09.png', 0),
(6, 1, '官方微宝', 'admin/20190430/aa19ba4d1f2b695ce4454ef199c0bfc1.png', 0);

-- --------------------------------------------------------

--
-- 表的结构 `cmf_hook`
--

CREATE TABLE `cmf_hook` (
  `id` int(10) UNSIGNED NOT NULL,
  `type` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '钩子类型(1:系统钩子;2:应用钩子;3:模板钩子;4:后台模板钩子)',
  `once` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '是否只允许一个插件运行(0:多个;1:一个)',
  `name` varchar(50) NOT NULL DEFAULT '' COMMENT '钩子名称',
  `hook` varchar(50) NOT NULL DEFAULT '' COMMENT '钩子',
  `app` varchar(15) NOT NULL DEFAULT '' COMMENT '应用名(只有应用钩子才用)',
  `description` varchar(255) NOT NULL DEFAULT '' COMMENT '描述'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统钩子表';

--
-- 转存表中的数据 `cmf_hook`
--

INSERT INTO `cmf_hook` (`id`, `type`, `once`, `name`, `hook`, `app`, `description`) VALUES
(1, 1, 0, '应用初始化', 'app_init', 'cmf', '应用初始化'),
(2, 1, 0, '应用开始', 'app_begin', 'cmf', '应用开始'),
(3, 1, 0, '模块初始化', 'module_init', 'cmf', '模块初始化'),
(4, 1, 0, '控制器开始', 'action_begin', 'cmf', '控制器开始'),
(5, 1, 0, '视图输出过滤', 'view_filter', 'cmf', '视图输出过滤'),
(6, 1, 0, '应用结束', 'app_end', 'cmf', '应用结束'),
(7, 1, 0, '日志write方法', 'log_write', 'cmf', '日志write方法'),
(8, 1, 0, '输出结束', 'response_end', 'cmf', '输出结束'),
(9, 1, 0, '后台控制器初始化', 'admin_init', 'cmf', '后台控制器初始化'),
(10, 1, 0, '前台控制器初始化', 'home_init', 'cmf', '前台控制器初始化'),
(11, 1, 1, '发送手机验证码', 'send_mobile_verification_code', 'cmf', '发送手机验证码'),
(12, 3, 0, '模板 body标签开始', 'body_start', '', '模板 body标签开始'),
(13, 3, 0, '模板 head标签结束前', 'before_head_end', '', '模板 head标签结束前'),
(14, 3, 0, '模板底部开始', 'footer_start', '', '模板底部开始'),
(15, 3, 0, '模板底部开始之前', 'before_footer', '', '模板底部开始之前'),
(16, 3, 0, '模板底部结束之前', 'before_footer_end', '', '模板底部结束之前'),
(17, 3, 0, '模板 body 标签结束之前', 'before_body_end', '', '模板 body 标签结束之前'),
(18, 3, 0, '模板左边栏开始', 'left_sidebar_start', '', '模板左边栏开始'),
(19, 3, 0, '模板左边栏结束之前', 'before_left_sidebar_end', '', '模板左边栏结束之前'),
(20, 3, 0, '模板右边栏开始', 'right_sidebar_start', '', '模板右边栏开始'),
(21, 3, 0, '模板右边栏结束之前', 'before_right_sidebar_end', '', '模板右边栏结束之前'),
(22, 3, 1, '评论区', 'comment', '', '评论区'),
(23, 3, 1, '留言区', 'guestbook', '', '留言区'),
(24, 2, 0, '后台首页仪表盘', 'admin_dashboard', 'admin', '后台首页仪表盘'),
(25, 4, 0, '后台模板 head标签结束前', 'admin_before_head_end', '', '后台模板 head标签结束前'),
(26, 4, 0, '后台模板 body 标签结束之前', 'admin_before_body_end', '', '后台模板 body 标签结束之前'),
(27, 2, 0, '后台登录页面', 'admin_login', 'admin', '后台登录页面'),
(28, 1, 1, '前台模板切换', 'switch_theme', 'cmf', '前台模板切换'),
(29, 3, 0, '主要内容之后', 'after_content', '', '主要内容之后'),
(30, 2, 0, '文章显示之前', 'portal_before_assign_article', 'portal', '文章显示之前'),
(31, 2, 0, '后台文章保存之后', 'portal_admin_after_save_article', 'portal', '后台文章保存之后'),
(32, 2, 1, '获取上传界面', 'fetch_upload_view', 'user', '获取上传界面'),
(33, 3, 0, '主要内容之前', 'before_content', 'cmf', '主要内容之前'),
(34, 1, 0, '日志写入完成', 'log_write_done', 'cmf', '日志写入完成'),
(35, 1, 1, '后台模板切换', 'switch_admin_theme', 'cmf', '后台模板切换'),
(36, 1, 1, '验证码图片', 'captcha_image', 'cmf', '验证码图片'),
(37, 2, 1, '后台模板设计界面', 'admin_theme_design_view', 'admin', '后台模板设计界面'),
(38, 2, 1, '后台设置网站信息界面', 'admin_setting_site_view', 'admin', '后台设置网站信息界面'),
(39, 2, 1, '后台清除缓存界面', 'admin_setting_clear_cache_view', 'admin', '后台清除缓存界面'),
(40, 2, 1, '后台导航管理界面', 'admin_nav_index_view', 'admin', '后台导航管理界面'),
(41, 2, 1, '后台友情链接管理界面', 'admin_link_index_view', 'admin', '后台友情链接管理界面'),
(42, 2, 1, '后台幻灯片管理界面', 'admin_slide_index_view', 'admin', '后台幻灯片管理界面'),
(43, 2, 1, '后台管理员列表界面', 'admin_user_index_view', 'admin', '后台管理员列表界面'),
(44, 2, 1, '后台角色管理界面', 'admin_rbac_index_view', 'admin', '后台角色管理界面'),
(45, 2, 1, '门户后台文章管理列表界面', 'portal_admin_article_index_view', 'portal', '门户后台文章管理列表界面'),
(46, 2, 1, '门户后台文章分类管理列表界面', 'portal_admin_category_index_view', 'portal', '门户后台文章分类管理列表界面'),
(47, 2, 1, '门户后台页面管理列表界面', 'portal_admin_page_index_view', 'portal', '门户后台页面管理列表界面'),
(48, 2, 1, '门户后台文章标签管理列表界面', 'portal_admin_tag_index_view', 'portal', '门户后台文章标签管理列表界面'),
(49, 2, 1, '用户管理本站用户列表界面', 'user_admin_index_view', 'user', '用户管理本站用户列表界面'),
(50, 2, 1, '资源管理列表界面', 'user_admin_asset_index_view', 'user', '资源管理列表界面'),
(51, 2, 1, '用户管理第三方用户列表界面', 'user_admin_oauth_index_view', 'user', '用户管理第三方用户列表界面'),
(52, 2, 1, '后台首页界面', 'admin_index_index_view', 'admin', '后台首页界面'),
(53, 2, 1, '后台回收站界面', 'admin_recycle_bin_index_view', 'admin', '后台回收站界面'),
(54, 2, 1, '后台菜单管理界面', 'admin_menu_index_view', 'admin', '后台菜单管理界面'),
(55, 2, 1, '后台自定义登录是否开启钩子', 'admin_custom_login_open', 'admin', '后台自定义登录是否开启钩子'),
(56, 4, 0, '门户后台文章添加编辑界面右侧栏', 'portal_admin_article_edit_view_right_sidebar', 'portal', '门户后台文章添加编辑界面右侧栏'),
(57, 4, 0, '门户后台文章添加编辑界面主要内容', 'portal_admin_article_edit_view_main', 'portal', '门户后台文章添加编辑界面主要内容'),
(58, 2, 1, '门户后台文章添加界面', 'portal_admin_article_add_view', 'portal', '门户后台文章添加界面'),
(59, 2, 1, '门户后台文章编辑界面', 'portal_admin_article_edit_view', 'portal', '门户后台文章编辑界面'),
(60, 2, 1, '门户后台文章分类添加界面', 'portal_admin_category_add_view', 'portal', '门户后台文章分类添加界面'),
(61, 2, 1, '门户后台文章分类编辑界面', 'portal_admin_category_edit_view', 'portal', '门户后台文章分类编辑界面'),
(62, 2, 1, '门户后台页面添加界面', 'portal_admin_page_add_view', 'portal', '门户后台页面添加界面'),
(63, 2, 1, '门户后台页面编辑界面', 'portal_admin_page_edit_view', 'portal', '门户后台页面编辑界面'),
(64, 2, 1, '后台幻灯片页面列表界面', 'admin_slide_item_index_view', 'admin', '后台幻灯片页面列表界面'),
(65, 2, 1, '后台幻灯片页面添加界面', 'admin_slide_item_add_view', 'admin', '后台幻灯片页面添加界面'),
(66, 2, 1, '后台幻灯片页面编辑界面', 'admin_slide_item_edit_view', 'admin', '后台幻灯片页面编辑界面'),
(67, 2, 1, '后台管理员添加界面', 'admin_user_add_view', 'admin', '后台管理员添加界面'),
(68, 2, 1, '后台管理员编辑界面', 'admin_user_edit_view', 'admin', '后台管理员编辑界面'),
(69, 2, 1, '后台角色添加界面', 'admin_rbac_role_add_view', 'admin', '后台角色添加界面'),
(70, 2, 1, '后台角色编辑界面', 'admin_rbac_role_edit_view', 'admin', '后台角色编辑界面'),
(71, 2, 1, '后台角色授权界面', 'admin_rbac_authorize_view', 'admin', '后台角色授权界面'),
(72, 1, 0, '应用调度', 'app_dispatch', 'cmf', '应用调度');

-- --------------------------------------------------------

--
-- 表的结构 `cmf_hook_plugin`
--

CREATE TABLE `cmf_hook_plugin` (
  `id` int(10) UNSIGNED NOT NULL,
  `list_order` float NOT NULL DEFAULT '10000' COMMENT '排序',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态(0:禁用,1:启用)',
  `hook` varchar(50) NOT NULL DEFAULT '' COMMENT '钩子名',
  `plugin` varchar(50) NOT NULL DEFAULT '' COMMENT '插件'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统钩子插件表';

--
-- 转存表中的数据 `cmf_hook_plugin`
--

INSERT INTO `cmf_hook_plugin` (`id`, `list_order`, `status`, `hook`, `plugin`) VALUES
(1, 10000, 1, 'fetch_upload_view', 'Qiniu'),
(2, 10000, 1, 'switch_theme', 'TcSwitchTheme');

-- --------------------------------------------------------

--
-- 表的结构 `cmf_link`
--

CREATE TABLE `cmf_link` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '状态;1:显示;0:不显示',
  `rating` int(11) NOT NULL DEFAULT '0' COMMENT '友情链接评级',
  `list_order` float NOT NULL DEFAULT '10000' COMMENT '排序',
  `description` varchar(255) NOT NULL DEFAULT '' COMMENT '友情链接描述',
  `url` varchar(255) NOT NULL DEFAULT '' COMMENT '友情链接地址',
  `name` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '友情链接名称',
  `image` varchar(100) NOT NULL DEFAULT '' COMMENT '友情链接图标',
  `target` varchar(10) NOT NULL DEFAULT '' COMMENT '友情链接打开方式',
  `rel` varchar(50) NOT NULL DEFAULT '' COMMENT '链接与网站的关系'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='友情链接表';

--
-- 转存表中的数据 `cmf_link`
--

INSERT INTO `cmf_link` (`id`, `status`, `rating`, `list_order`, `description`, `url`, `name`, `image`, `target`, `rel`) VALUES
(2, 1, 0, 10000, '', 'https://www.baidu.com', '旅游网', '', '', ''),
(3, 1, 0, 10000, '', 'https://www.baidu.com', '途牛网', '', '', '');

-- --------------------------------------------------------

--
-- 表的结构 `cmf_mobile_code`
--

CREATE TABLE `cmf_mobile_code` (
  `id` int(11) NOT NULL,
  `mobile` varchar(255) NOT NULL COMMENT '手机号',
  `mobile_code` varchar(255) NOT NULL COMMENT '验证码',
  `expire_time` int(11) NOT NULL COMMENT '过期时间',
  `is_use` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否已用(0未使用，1已使用)',
  `count` int(11) NOT NULL DEFAULT '0' COMMENT '发送次数',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  `create_date` varchar(255) NOT NULL COMMENT '创建日期'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='手机验证码表' ROW_FORMAT=DYNAMIC;

--
-- 转存表中的数据 `cmf_mobile_code`
--

INSERT INTO `cmf_mobile_code` (`id`, `mobile`, `mobile_code`, `expire_time`, `is_use`, `count`, `create_time`, `create_date`) VALUES
(2, '13752011725', '933367', 1555573191, 0, 2, 1555556228, '2019-04-18'),
(15, '13752011725', '176849', 1556005143, 1, 1, 1555996080, '2019-04-23');

-- --------------------------------------------------------

--
-- 表的结构 `cmf_nav`
--

CREATE TABLE `cmf_nav` (
  `id` int(10) UNSIGNED NOT NULL,
  `is_main` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '是否为主导航;1:是;0:不是',
  `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '导航位置名称',
  `remark` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '备注'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='前台导航位置表';

--
-- 转存表中的数据 `cmf_nav`
--

INSERT INTO `cmf_nav` (`id`, `is_main`, `name`, `remark`) VALUES
(1, 1, '主导航', '主导航'),
(2, 0, '底部导航', '');

-- --------------------------------------------------------

--
-- 表的结构 `cmf_nav_menu`
--

CREATE TABLE `cmf_nav_menu` (
  `id` int(11) NOT NULL,
  `nav_id` int(11) NOT NULL COMMENT '导航 id',
  `parent_id` int(11) NOT NULL COMMENT '父 id',
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '状态;1:显示;0:隐藏',
  `list_order` float NOT NULL DEFAULT '10000' COMMENT '排序',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '菜单名称',
  `target` varchar(10) NOT NULL DEFAULT '' COMMENT '打开方式',
  `href` varchar(100) NOT NULL DEFAULT '' COMMENT '链接',
  `icon` varchar(20) NOT NULL DEFAULT '' COMMENT '图标',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT '层级关系'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='前台导航菜单表';

--
-- 转存表中的数据 `cmf_nav_menu`
--

INSERT INTO `cmf_nav_menu` (`id`, `nav_id`, `parent_id`, `status`, `list_order`, `name`, `target`, `href`, `icon`, `path`) VALUES
(1, 1, 0, 1, 0, '首页', '', 'home', '', '0-1');

-- --------------------------------------------------------

--
-- 表的结构 `cmf_option`
--

CREATE TABLE `cmf_option` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `autoload` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '是否自动加载;1:自动加载;0:不自动加载',
  `option_name` varchar(64) NOT NULL DEFAULT '' COMMENT '配置名',
  `option_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '配置值'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='全站配置表' ROW_FORMAT=COMPACT;

--
-- 转存表中的数据 `cmf_option`
--

INSERT INTO `cmf_option` (`id`, `autoload`, `option_name`, `option_value`) VALUES
(1, 1, 'site_info', '{"site_name":"ThinkCMF\\u5185\\u5bb9\\u7ba1\\u7406\\u6846\\u67b6","site_seo_title":"ThinkCMF\\u5185\\u5bb9\\u7ba1\\u7406\\u6846\\u67b6","site_seo_keywords":"ThinkCMF,php,\\u5185\\u5bb9\\u7ba1\\u7406\\u6846\\u67b6,cmf,cms,\\u7b80\\u7ea6\\u98ce, simplewind,framework","site_seo_description":"ThinkCMF\\u662f\\u7b80\\u7ea6\\u98ce\\u7f51\\u7edc\\u79d1\\u6280\\u53d1\\u5e03\\u7684\\u4e00\\u6b3e\\u7528\\u4e8e\\u5feb\\u901f\\u5f00\\u53d1\\u7684\\u5185\\u5bb9\\u7ba1\\u7406\\u6846\\u67b6","site_icp":"","site_gwa":"","site_admin_email":"","site_analytics":""}'),
(2, 1, 'storage', '{"storages":{"Qiniu":{"name":"\\u4e03\\u725b\\u4e91\\u5b58\\u50a8","driver":"\\\\plugins\\\\qiniu\\\\lib\\\\Qiniu"}},"type":"Qiniu"}'),
(3, 1, 'cmf_settings', '{"open_registration":"0","banned_usernames":""}'),
(4, 1, 'cdn_settings', '{"cdn_static_root":""}'),
(5, 1, 'admin_settings', '{"admin_password":"","admin_theme":"admin_simpleboot3","admin_style":"flatadmin"}');

-- --------------------------------------------------------

--
-- 表的结构 `cmf_plugin`
--

CREATE TABLE `cmf_plugin` (
  `id` int(11) UNSIGNED NOT NULL COMMENT '自增id',
  `type` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '插件类型;1:网站;8:微信',
  `has_admin` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '是否有后台管理,0:没有;1:有',
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '状态;1:开启;0:禁用',
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '插件安装时间',
  `name` varchar(50) NOT NULL DEFAULT '' COMMENT '插件标识名,英文字母(惟一)',
  `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '插件名称',
  `demo_url` varchar(50) NOT NULL DEFAULT '' COMMENT '演示地址，带协议',
  `hooks` varchar(255) NOT NULL DEFAULT '' COMMENT '实现的钩子;以“,”分隔',
  `author` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '插件作者',
  `author_url` varchar(50) NOT NULL DEFAULT '' COMMENT '作者网站链接',
  `version` varchar(20) NOT NULL DEFAULT '' COMMENT '插件版本号',
  `description` varchar(255) NOT NULL COMMENT '插件描述',
  `config` text COMMENT '插件配置'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='插件表';

--
-- 转存表中的数据 `cmf_plugin`
--

INSERT INTO `cmf_plugin` (`id`, `type`, `has_admin`, `status`, `create_time`, `name`, `title`, `demo_url`, `hooks`, `author`, `author_url`, `version`, `description`, `config`) VALUES
(1, 1, 0, 1, 0, 'Qiniu', '七牛云存储', '', '', 'ThinkCMF', '', '1.0.1', 'ThinkCMF七牛专享优惠码:507670e8', '{"accessKey":"UjVH2DxMRL57-Lx4-JFaELCh7icERqJ1NxWf6smj","secretKey":"LndHno2saLxcR1vRQWQmkGvLyhfT9zoSPGBi_HKC","protocol":"http","domain":"pq5d4o050.bkt.clouddn.com","bucket":"dujiaoxingqiu","zone":"z0","style_separator":"!"}'),
(2, 1, 0, 1, 0, 'TcSwitchTheme', '手机端模板控制', 'http://www.songzhenjiang.cn', '', 'Tangchao', 'http://www.songzhenjiang.cn', '1.0', '手机端模板控制', '{"wapthems":"simpleboot3_mobile"}');

-- --------------------------------------------------------

--
-- 表的结构 `cmf_portal_category`
--

CREATE TABLE `cmf_portal_category` (
  `id` bigint(20) UNSIGNED NOT NULL COMMENT '分类id',
  `parent_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '分类父id',
  `post_count` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '分类文章数',
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '状态,1:发布,0:不发布',
  `delete_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '删除时间',
  `list_order` float NOT NULL DEFAULT '10000' COMMENT '排序',
  `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '分类名称',
  `description` varchar(255) NOT NULL DEFAULT '' COMMENT '分类描述',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT '分类层级关系路径',
  `seo_title` varchar(100) NOT NULL DEFAULT '',
  `seo_keywords` varchar(255) NOT NULL DEFAULT '',
  `seo_description` varchar(255) NOT NULL DEFAULT '',
  `list_tpl` varchar(50) NOT NULL DEFAULT '' COMMENT '分类列表模板',
  `one_tpl` varchar(50) NOT NULL DEFAULT '' COMMENT '分类文章页模板',
  `more` text COMMENT '扩展属性'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='portal应用 文章分类表';

--
-- 转存表中的数据 `cmf_portal_category`
--

INSERT INTO `cmf_portal_category` (`id`, `parent_id`, `post_count`, `status`, `delete_time`, `list_order`, `name`, `description`, `path`, `seo_title`, `seo_keywords`, `seo_description`, `list_tpl`, `one_tpl`, `more`) VALUES
(1, 0, 0, 1, 0, 10000, '星球奇境', '', '0-1', '', '', '', 'list', 'article', '{"thumbnail":"portal\\/20190410\\/0f6c4ad49c99ee91bb707a697ea4f7cc.jpg"}'),
(2, 0, 0, 1, 0, 10000, '星域秀场', '', '0-2', '', '', '', 'list', 'article', '{"thumbnail":"portal\\/20190410\\/0f6c4ad49c99ee91bb707a697ea4f7cc.jpg"}'),
(3, 0, 0, 1, 0, 10000, '星享体验', '', '0-3', '', '', '', 'list', 'article', '{"thumbnail":""}'),
(4, 0, 0, 1, 0, 10000, '星探推荐', '', '0-4', '', '', '', 'list', 'article', '{"thumbnail":""}'),
(5, 0, 0, 1, 0, 10000, '星际活动', '', '0-5', '', '', '', 'list', 'article', '{"thumbnail":""}'),
(6, 1, 0, 1, 0, 10000, '星球故事', '', '0-1-6', '', '', '', 'list', 'article', '{"thumbnail":""}'),
(7, 1, 0, 1, 0, 10000, '网红美景', '', '0-1-7', '', '', '', 'list', 'article', '{"thumbnail":""}'),
(8, 1, 0, 1, 0, 10000, '异域珍馐', '', '0-1-8', '', '', '', 'list', 'article', '{"thumbnail":""}'),
(9, 1, 0, 1, 0, 10000, '良宿美寝', '', '0-1-9', '', '', '', 'list', 'article', '{"thumbnail":""}'),
(10, 1, 0, 1, 0, 10000, '活力生态', '', '0-1-10', '', '', '', 'list', 'article', '{"thumbnail":""}'),
(11, 1, 0, 1, 0, 10000, '便利出行', '', '0-1-11', '', '', '', 'list', 'article', '{"thumbnail":""}'),
(12, 2, 0, 1, 0, 10000, '明星访谈', '', '0-2-12', '', '', '', 'list', 'article', '{"thumbnail":""}'),
(13, 2, 0, 0, 0, 10000, '星球故事', '', '0-2-13', '', '', '', 'list', 'article', '{"thumbnail":""}'),
(14, 0, 0, 1, 1554874259, 10000, '星球画廊', '', '0-14', '', '', '', 'list', 'article', '{"thumbnail":""}'),
(15, 2, 0, 1, 0, 10000, '星域画廊', '', '0-2-15', '', '', '', 'list', 'article', '{"thumbnail":""}'),
(16, 2, 0, 1, 0, 10000, '独角快报', '', '0-2-16', '', '', '', 'list', 'article', '{"thumbnail":""}'),
(17, 2, 0, 1, 0, 10000, '独角日志', '', '0-2-17', '', '', '', 'list', 'article', '{"thumbnail":""}'),
(18, 2, 0, 1, 0, 10000, '童趣未来', '', '0-2-18', '', '', '', 'list', 'article', '{"thumbnail":""}'),
(19, 3, 0, 1, 0, 10000, '亲临现场', '', '0-3-19', '', '', '', 'list', 'article', '{"thumbnail":""}'),
(20, 3, 0, 1, 0, 10000, '市井漫游', '', '0-3-20', '', '', '', 'list', 'article', '{"thumbnail":""}'),
(21, 3, 0, 1, 0, 10000, '视听盛宴', '', '0-3-21', '', '', '', 'list', 'article', '{"thumbnail":""}'),
(22, 3, 0, 1, 0, 10000, '户外天堂', '', '0-3-22', '', '', '', 'list', 'article', '{"thumbnail":""}'),
(23, 4, 0, 1, 0, 10000, '旅游路线', '', '0-4-23', '', '', '', 'list', 'article', '{"thumbnail":""}'),
(24, 4, 0, 1, 0, 10000, '地道风物', '', '0-4-24', '', '', '', 'list', 'article', '{"thumbnail":""}'),
(25, 4, 0, 1, 0, 10000, '创意设计', '', '0-4-25', '', '', '', 'list', 'article', '{"thumbnail":""}'),
(26, 4, 0, 1, 0, 10000, '悦己悦人', '', '0-4-26', '', '', '', 'list', 'article', '{"thumbnail":""}'),
(27, 5, 0, 1, 0, 10000, '星际活动', '', '0-5-27', '', '', '', 'list', 'article', '{"thumbnail":""}'),
(28, 0, 0, 1, 0, 10000, '关于我们', '', '0-28', '', '', '', 'list', 'article', '{"thumbnail":""}'),
(29, 28, 0, 1, 0, 10000, '关于我们', '', '0-28-29', '', '', '', 'list', 'article', '{"thumbnail":""}'),
(30, 0, 0, 1, 0, 10000, '关注我们', '', '0-30', '', '', '', 'list', 'article', '{"thumbnail":""}'),
(31, 30, 0, 1, 0, 10000, '关注我们', '', '0-30-31', '', '', '', 'list', 'article', '{"thumbnail":""}'),
(32, 0, 0, 1, 0, 10000, '合作伙伴', '', '0-32', '', '', '', 'list', 'article', '{"thumbnail":""}'),
(33, 32, 0, 1, 0, 10000, '合作伙伴', '', '0-32-33', '', '', '', 'list', 'article', '{"thumbnail":""}'),
(34, 0, 0, 1, 0, 10000, '友情链接', '', '0-34', '', '', '', 'list', 'article', '{"thumbnail":""}'),
(35, 34, 0, 1, 0, 10000, '友情链接', '', '0-34-35', '', '', '', 'list', 'article', '{"thumbnail":""}'),
(36, 0, 0, 1, 0, 10000, '测试2', '', '0-36', '', '', '', 'list', 'article', '{"thumbnail":""}'),
(37, 36, 0, 1, 0, 10000, '测试', '', '0-36-37', '', '', '', 'list', 'article', NULL),
(38, 37, 0, 1, 1556337428, 10000, 'ceshid', '', '0-36-37-38', '', '', '', '', '', '{"thumbnail":""}'),
(39, 2, 0, 1, 0, 11000, '星球影院', '', '0-2-39', '', '', '', '', '', '{"thumbnail":""}');

-- --------------------------------------------------------

--
-- 表的结构 `cmf_portal_category_post`
--

CREATE TABLE `cmf_portal_category_post` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `post_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '文章id',
  `category_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '分类id',
  `list_order` float NOT NULL DEFAULT '10000' COMMENT '排序',
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '状态,1:发布;0:不发布'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='portal应用 分类文章对应表';

--
-- 转存表中的数据 `cmf_portal_category_post`
--

INSERT INTO `cmf_portal_category_post` (`id`, `post_id`, `category_id`, `list_order`, `status`) VALUES
(20, 1, 19, 10000, 1),
(21, 2, 19, 10000, 1),
(22, 3, 19, 10000, 1),
(23, 4, 21, 10000, 1),
(24, 5, 20, 10000, 1),
(25, 6, 7, 10000, 1),
(26, 7, 2, 10000, 1),
(27, 8, 39, 10000, 1),
(28, 9, 12, 10000, 1),
(29, 10, 15, 10000, 1),
(30, 11, 24, 10000, 1),
(31, 12, 27, 10000, 1),
(32, 13, 29, 10000, 1),
(33, 14, 31, 10000, 1),
(34, 15, 35, 10000, 1),
(35, 16, 35, 10000, 1),
(36, 17, 6, 10000, 1),
(37, 18, 6, 10000, 1),
(38, 19, 6, 10000, 1),
(39, 20, 6, 10000, 1),
(40, 21, 8, 10000, 1),
(41, 22, 9, 10000, 1),
(42, 23, 7, 10000, 1),
(43, 24, 10, 10000, 1),
(44, 25, 11, 10000, 1),
(45, 26, 39, 10000, 1),
(46, 27, 39, 10000, 1),
(47, 28, 12, 10000, 1),
(48, 29, 15, 10000, 1),
(49, 30, 16, 10000, 1),
(50, 31, 17, 10000, 1),
(51, 32, 18, 10000, 1),
(52, 33, 19, 10000, 1),
(53, 34, 20, 10000, 1),
(54, 35, 22, 10000, 1),
(55, 36, 23, 10000, 1),
(56, 37, 24, 10000, 1),
(57, 38, 25, 10000, 1),
(58, 39, 26, 10000, 1),
(59, 40, 27, 10000, 1),
(60, 41, 19, 10000, 1);

-- --------------------------------------------------------

--
-- 表的结构 `cmf_portal_post`
--

CREATE TABLE `cmf_portal_post` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `parent_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '父级id',
  `city_id` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '城市分类id',
  `post_type` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '类型,1:文章;2:页面',
  `post_format` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '内容格式;1:html;2:md',
  `user_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '发表者用户id',
  `post_status` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '状态;1:已发布;0:未发布;',
  `tel` varchar(11) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '电话（良宿美寝）',
  `url` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '网址（良宿美寝）',
  `address` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '地址（良宿美寝）',
  `framing` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '取景地方（星域秀场）',
  `release_time` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '上映时间（星域秀场）',
  `full_name` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '姓名（明星访谈）',
  `position` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '职称（明星访谈）',
  `trade` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '行业（明星访谈）',
  `month` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '月份（星享体验）',
  `notice` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '预定须知（旅游路线）',
  `place` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '出发地点（旅游路线）',
  `project` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '包含项目（旅游路线）',
  `price` float(10,2) DEFAULT '0.00',
  `pay_url` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '支付外链（旅游路线）',
  `active_url` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '活动外链（星际活动）',
  `friend_url` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '友情链接',
  `comment_status` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '评论状态;1:允许;0:不允许',
  `is_top` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '是否置顶;1:置顶;0:不置顶',
  `recommended` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '是否推荐;1:推荐;0:不推荐',
  `post_hits` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '查看数',
  `weigh` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '权重',
  `post_favorites` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '收藏数',
  `post_like` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '点赞数',
  `comment_count` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '评论数',
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '更新时间',
  `published_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '发布时间',
  `delete_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '删除时间',
  `post_title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'post标题',
  `post_keywords` varchar(150) NOT NULL DEFAULT '' COMMENT 'seo keywords',
  `post_excerpt` varchar(500) NOT NULL DEFAULT '' COMMENT 'post摘要',
  `post_source` varchar(150) NOT NULL DEFAULT '' COMMENT '转载文章的来源',
  `thumbnail` varchar(100) NOT NULL DEFAULT '' COMMENT '缩略图',
  `post_content` text COMMENT '文章内容',
  `post_content_filtered` text COMMENT '处理过的文章内容',
  `more` text COMMENT '扩展属性,如缩略图;格式为json'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='portal应用 文章表' ROW_FORMAT=COMPACT;

--
-- 转存表中的数据 `cmf_portal_post`
--

INSERT INTO `cmf_portal_post` (`id`, `parent_id`, `city_id`, `post_type`, `post_format`, `user_id`, `post_status`, `tel`, `url`, `address`, `framing`, `release_time`, `full_name`, `position`, `trade`, `month`, `notice`, `place`, `project`, `price`, `pay_url`, `active_url`, `friend_url`, `comment_status`, `is_top`, `recommended`, `post_hits`, `weigh`, `post_favorites`, `post_like`, `comment_count`, `create_time`, `update_time`, `published_time`, `delete_time`, `post_title`, `post_keywords`, `post_excerpt`, `post_source`, `thumbnail`, `post_content`, `post_content_filtered`, `more`) VALUES
(1, 0, 18, 1, 1, 1, 0, '', '', '', '', '', '', '', '', 1, '', '', '', 0.00, '', '', '', 1, 0, 0, 0, 12, 0, 0, 0, 1556161339, 1556528396, 1556160720, 0, '时尚潮人最喜爱的度假地点', '', '慕尼黑啤酒节(The Munich Oktoberfest)又称“十月节”（Oktoberfest），起源于1810年10月12日，因在这个节日期间主要的饮料是啤酒，所以人们习惯性地称其为啤酒节。每年九月末到十月初在德国的慕尼黑举行，持续两周，到十月的第一个星期天为止，是慕尼黑一年中最盛大的活动。', '', 'http://pq5d4o050.bkt.clouddn.com/portal/20190425/fef2c7b742ae0f4b87922d551dd3c75b.png', '\n<p>从1810年到2014年为止，慕尼黑啤酒节有204年的历史。其间因第一次世界大战停办5年；第二次世界大战停办7年。自1946年以来节日规模越办越大，从而真正成了一个盛大的民间节日。</p>\n<p><a class="lemma-anchor para-title" style="color: rgb(19, 110, 194); position: absolute; top: -50px;" href></a><a class="lemma-anchor " style="color: rgb(19, 110, 194); position: absolute; top: -50px;" href></a><a class="lemma-anchor " style="color: rgb(19, 110, 194); position: absolute; top: -50px;" href></a><a class="lemma-anchor " style="color: rgb(19, 110, 194); position: absolute; top: -50px;" href></a></p>\n<h3 class="title-text" style="margin: 0px; padding: 0px; font-size: 18px; font-weight: 400;">诞生起源</h3>\n<p>1810年10月12日，<a target="_blank" href="https://baike.baidu.com/item/%E5%B7%B4%E4%BC%90%E5%88%A9%E4%BA%9A" style="color: rgb(19, 110, 194); text-decoration-line: none;">巴伐利亚</a>的王储<a target="_blank" href="https://baike.baidu.com/item/%E8%B7%AF%E5%BE%B7%E7%BB%B4%E5%B8%8C" style="color: rgb(19, 110, 194); text-decoration-line: none;">路德维希</a>与<a target="_blank" href="https://baike.baidu.com/item/%E8%90%A8%E5%85%8B%E6%A3%AE" style="color: rgb(19, 110, 194); text-decoration-line: none;">萨克森</a>王国的特蕾泽·夏洛特·露易丝公</p>\n<p><a class="image-link" href="https://baike.baidu.com/pic/%E6%85%95%E5%B0%BC%E9%BB%91%E5%95%A4%E9%85%92%E8%8A%82/1006782/0/7748553682001dafa2cc2b06?fr=lemma&ct=single" target="_blank" title="啤酒节华丽夜景" style="color: rgb(19, 110, 194); text-decoration-line: none; display: block; width: 220px; height: 127px;"><img class="" src="https://gss2.bdstatic.com/-fo3dSag_xI4khGkpoWK1HF6hhy/baike/s%3D220/sign=8e433b88513d26972ad30f5f65fab24f/e850352ac65c10387decc880b2119313b17e89e5.jpg" alt="啤酒节华丽夜景" style="border: 0px; display: block; margin: 0px auto; width: 220px; height: 127px;"></a><span class="description" style="display: block; color: rgb(85, 85, 85); font-size: 12px; text-indent: 0px; font-family: 宋体; overflow-wrap: break-word; word-break: break-all; line-height: 15px; padding: 8px 7px; min-height: 12px; border-top: 1px solid rgb(224, 224, 224);">啤酒节华丽夜景</span></p>\n<p>主举行盛大的婚礼。王储的父亲<a target="_blank" href="https://baike.baidu.com/item/%E7%BA%A6%E7%91%9F%E5%A4%AB" style="color: rgb(19, 110, 194); text-decoration-line: none;">约瑟夫</a>决定为他儿子的婚礼举行为期两天的庆祝活动。为了表示国王对其臣民的恩典，在这两天的活动中，在慕尼黑有4个地方向全体平民免费供应饭菜和饮料。王国的骑兵卫队还在慕尼黑西南的一个大草坪上举行赛马活动和射击比赛，以示助兴。为了纪念这个节日，参赛的官兵请求国王用新娘特蕾泽的名字来命名这个草坪，从那时起这个草坪就叫“特蕾泽”草地。<span class="sup--normal" style="font-size: 12px; line-height: 0; position: relative; vertical-align: baseline; top: -0.5em; margin-left: 2px; color: rgb(51, 102, 204); cursor: pointer; padding: 0px 2px;"> [4]</span><a class="sup-anchor" style="color: rgb(19, 110, 194); position: relative; top: -50px; font-size: 0px; line-height: 0;" href> </a> 由于<a target="_blank" href="https://baike.baidu.com/item/%E5%BA%86%E5%85%B8" style="color: rgb(19, 110, 194); text-decoration-line: none;">庆典</a>给人们留下了深刻的印象，所以人们建议1811年再搞一次全民性的活动。以后就每年举办一次。这就是十月节的起源。</p>\n<p><a class="lemma-anchor para-title" style="color: rgb(19, 110, 194); position: absolute; top: -50px;" href></a><a class="lemma-anchor " style="color: rgb(19, 110, 194); position: absolute; top: -50px;" href></a><a class="lemma-anchor " style="color: rgb(19, 110, 194); position: absolute; top: -50px;" href></a><a class="lemma-anchor " style="color: rgb(19, 110, 194); position: absolute; top: -50px;" href></a></p>\n<h3 class="title-text" style="margin: 0px; padding: 0px; font-size: 18px; font-weight: 400;">早期变迁</h3>\n<p>1813年，因<a target="_blank" href="https://baike.baidu.com/item/%E6%8B%BF%E7%A0%B4%E4%BB%91" style="color: rgb(19, 110, 194); text-decoration-line: none;">拿破仑</a>入侵，十月节第一次被迫取消，外患平息后，十月节得以恢复，</p>\n<p><a class="image-link" href="https://baike.baidu.com/pic/%E6%85%95%E5%B0%BC%E9%BB%91%E5%95%A4%E9%85%92%E8%8A%82/1006782/0/f9dcd100baa1cd11cb09b80cb412c8fcc3ce2d5b?fr=lemma&ct=single" target="_blank" title="慕尼黑啤酒节" style="color: rgb(19, 110, 194); text-decoration-line: none; display: block; width: 220px; height: 149px;"><img class="" src="https://gss1.bdstatic.com/9vo3dSag_xI4khGkpoWK1HF6hhy/baike/s%3D220/sign=35d66bf2fd1f3a295ec8d2cca924bce3/f9dcd100baa1cd11cb09b80cb412c8fcc3ce2d5b.jpg" alt="慕尼黑啤酒节" style="border: 0px; display: block; margin: 0px auto; width: 220px; height: 149px;"></a><span class="description" style="display: block; color: rgb(85, 85, 85); font-size: 12px; text-indent: 0px; font-family: 宋体; overflow-wrap: break-word; word-break: break-all; line-height: 15px; padding: 8px 7px; min-height: 12px; border-top: 1px solid rgb(224, 224, 224);">慕尼黑啤酒节</span></p>\n<p>规模也不断扩大，除了赛马比赛以外还加入了攀岩，保龄球，秋千等项目。</p>\n<p>1818年十月节的会场上架设了第一架<a target="_blank" href="https://baike.baidu.com/item/%E6%97%8B%E8%BD%AC%E6%9C%A8%E9%A9%AC" style="color: rgb(19, 110, 194); text-decoration-line: none;">旋转木马</a>。除此以外也增添了其他供下层市民娱乐的项目，比如抽奖摊就就吸引了不少人参与，奖品多是陶瓷器，银器，首饰等。</p>\n<p>1819年开始慕尼黑市政府接管了十月节，十月节成为了每年一度的固定传统。1850年一座高20米的巴伐利亚神像亮相在特雷西娅草坪上，3年之后一座罗马众神庙也落成在巴伐利亚神像下。之后几年十月节数次被迫取消，如1854年和1873年的霍乱，1866年的<a target="_blank" href="https://baike.baidu.com/item/%E6%99%AE%E5%A5%A5%E6%88%98%E4%BA%89" style="color: rgb(19, 110, 194); text-decoration-line: none;">普奥战争</a>，1870年的普法战争。<span class="sup--normal" style="font-size: 12px; line-height: 0; position: relative; vertical-align: baseline; top: -0.5em; margin-left: 2px; color: rgb(51, 102, 204); cursor: pointer; padding: 0px 2px;"> [5]</span><a class="sup-anchor" style="color: rgb(19, 110, 194); position: relative; top: -50px; font-size: 0px; line-height: 0;" href> </a></p>\n<p><a class="lemma-anchor para-title" style="color: rgb(19, 110, 194); position: absolute; top: -50px;" href></a><a class="lemma-anchor " style="color: rgb(19, 110, 194); position: absolute; top: -50px;" href></a><a class="lemma-anchor " style="color: rgb(19, 110, 194); position: absolute; top: -50px;" href></a><a class="lemma-anchor " style="color: rgb(19, 110, 194); position: absolute; top: -50px;" href></a></p>\n<h3 class="title-text" style="margin: 0px; padding: 0px; font-size: 18px; font-weight: 400;">固定成型</h3>\n<p>19世纪末慕尼黑十月节逐渐发展成为了一个世界知名民俗节日。十月节的时间也逐渐延长，并且改到了</p>\n<p><a class="image-link" href="https://baike.baidu.com/pic/%E6%85%95%E5%B0%BC%E9%BB%91%E5%95%A4%E9%85%92%E8%8A%82/1006782/0/fc5e5f342de6d674241f140c?fr=lemma&ct=single" target="_blank" title="慕尼黑啤酒节" style="color: rgb(19, 110, 194); text-decoration-line: none; display: block; width: 220px; height: 146px;"><img class="" src="https://gss2.bdstatic.com/9fo3dSag_xI4khGkpoWK1HF6hhy/baike/s%3D220/sign=e36e548dd0a20cf44290f9dd46084b0c/5fdf8db1cb134954b3cf3b6e564e9258d0094ae3.jpg" alt="慕尼黑啤酒节" style="border: 0px; display: block; margin: 0px auto; width: 220px; height: 146px;"></a><span class="description" style="display: block; color: rgb(85, 85, 85); font-size: 12px; text-indent: 0px; font-family: 宋体; overflow-wrap: break-word; word-break: break-all; line-height: 15px; padding: 8px 7px; min-height: 12px; border-top: 1px solid rgb(224, 224, 224);">慕尼黑啤酒节</span></p>\n<p>阳光明媚，天气相对暖和的九月，“十月节”变成了仅有最后的一个周末在十月的节日。</p>\n<p>1880年起市政府颁发了十月节上销售啤酒的许可，1881年第一家啤酒酿造商落户十月节，是夜，400余家摊位灯火通明，照亮了整个夜空。为了增加座位，并加入乐队演奏，啤酒商们将小型啤酒屋改建成了大型啤酒帐篷，越来越多的马戏团和游乐场经营商前来为啤酒节助兴。</p>\n<p>1910年是啤酒节100周岁的华诞，当年人们总共喝掉了120万升啤酒。当时最大的啤酒帐篷中同时接待了一万两千多人。<span class="sup--normal" style="font-size: 12px; line-height: 0; position: relative; vertical-align: baseline; top: -0.5em; margin-left: 2px; color: rgb(51, 102, 204); cursor: pointer; padding: 0px 2px;"> [5]</span><a class="sup-anchor" style="color: rgb(19, 110, 194); position: relative; top: -50px; font-size: 0px; line-height: 0;" href> </a></p>\n<p><a class="lemma-anchor para-title" style="color: rgb(19, 110, 194); position: absolute; top: -50px;" href></a><a class="lemma-anchor " style="color: rgb(19, 110, 194); position: absolute; top: -50px;" href></a><a class="lemma-anchor " style="color: rgb(19, 110, 194); position: absolute; top: -50px;" href></a><a class="lemma-anchor " style="color: rgb(19, 110, 194); position: absolute; top: -50px;" href></a></p>\n<h3 class="title-text" style="margin: 0px; padding: 0px; font-size: 18px; font-weight: 400;">大战中断</h3>\n<p>1914到1918年间啤酒节因为第一次世界大战被迫中断，战后经济尚未完全复苏，因此1919年和1920年仅举办了一次规模较小的“秋季啤酒节”，1923年到1924年世界范围内的通货膨胀导致啤酒节再次被取消。1939年到1945年第二次世界大战期间，也没能举办啤酒节，同样战后的1946年至1948年间，也仅举办了规模较小的“秋季啤酒节”。至此，啤酒节从创立以来总共中断了24次。<span class="sup--normal" style="font-size: 12px; line-height: 0; position: relative; vertical-align: baseline; top: -0.5em; margin-left: 2px; color: rgb(51, 102, 204); cursor: pointer; padding: 0px 2px;"> [5]</span><a class="sup-anchor" style="color: rgb(19, 110, 194); position: relative; top: -50px; font-size: 0px; line-height: 0;" href> </a></p>\n<p><a class="lemma-anchor para-title" style="color: rgb(19, 110, 194); position: absolute; top: -50px;" href></a><a class="lemma-anchor " style="color: rgb(19, 110, 194); position: absolute; top: -50px;" href></a><a class="lemma-anchor " style="color: rgb(19, 110, 194); position: absolute; top: -50px;" href></a><a class="lemma-anchor " style="color: rgb(19, 110, 194); position: absolute; top: -50px;" href></a></p>\n<h3 class="title-text" style="margin: 0px; padding: 0px; font-size: 18px; font-weight: 400;">战后重启</h3>\n<p>1950年<a target="_blank" href="https://baike.baidu.com/item/%E6%85%95%E5%B0%BC%E9%BB%91%E5%B8%82" style="color: rgb(19, 110, 194); text-decoration-line: none;">慕尼黑市</a>长托马斯·维门尔用木槌敲开第一罐新酿啤酒桶，宣布啤酒节开幕，从此这种特别的开幕方式成为了啤酒节的传统。战后啤酒节上的赛马比赛被取消，仅在1960年啤酒节150周年庆典的时候重新举办过一次。</p>\n<p>啤酒节历史上悲剧性的一幕发生在1980年9月26日。那天啤酒节场地的入口处发生了一次爆炸，导致13人丧命，200余人受伤，其中68人伤势严重。这次恐怖袭击是德国历史上最严重的袭击事件。<span class="sup--normal" style="font-size: 12px; line-height: 0; position: relative; vertical-align: baseline; top: -0.5em; margin-left: 2px; color: rgb(51, 102, 204); cursor: pointer; padding: 0px 2px;"> [5]</span><a class="sup-anchor" style="color: rgb(19, 110, 194); position: relative; top: -50px; font-size: 0px; line-height: 0;" href> </a></p>\n<p>2016年9月17日，第183届慕尼黑啤酒节在雨中开幕。<span class="sup--normal" style="font-size: 12px; line-height: 0; position: relative; vertical-align: baseline; top: -0.5em; margin-left: 2px; color: rgb(51, 102, 204); cursor: pointer; padding: 0px 2px;"> [2]</span><a class="sup-anchor" style="color: rgb(19, 110, 194); position: relative; top: -50px; font-size: 0px; line-height: 0;" href> </a></p>\n', NULL, '{"thumbnail":"http:\\/\\/pq5d4o050.bkt.clouddn.com\\/portal\\/20190425\\/fef2c7b742ae0f4b87922d551dd3c75b.png","photos":[{"url":"http:\\/\\/pq5d4o050.bkt.clouddn.com\\/portal\\/20190425\\/618bac313a2712628ba59d89fe52e0ae.jpg","name":"timg.jpg"},{"url":"http:\\/\\/pq5d4o050.bkt.clouddn.com\\/portal\\/20190425\\/18cbe1e918cebb92a8f08dc4c47dbd48.jpg","name":"timg (4).jpg"}]}'),
(2, 0, 18, 1, 1, 1, 0, '', '', '', '', '', '', '', '', 1, '', '', '', 0.00, '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 1556162202, 1556175916, 1556161440, 0, '时尚潮人最喜爱的度假地点', '', '慕尼黑啤酒节(The Munich Oktoberfest)又称“十月节”（Oktoberfest），起源于1810年10月12日，因在这个节日期间主要的饮料是啤酒，所以人们习惯性地称其为啤酒节。每年九月末到十月初在德国的慕尼黑举行，持续两周，到十月的第一个星期天为止，是慕尼黑一年中最盛大的活动。', '', 'http://pq5d4o050.bkt.clouddn.com/portal/20190425/11fccbc30577762c8d06467b9255358e.png', '\n<h3 class="title-text" style="margin: 0px; padding: 0px; font-size: 18px; font-weight: 400;">开幕仪式</h3>\n<p>每逢十月节开幕那天，要举行盛大的开幕式和由各大啤酒厂组织的五彩缤纷的游行。开幕式在一个临时搭起的大帐篷里由慕尼黑市市长主持。中午12时，在12响礼炮声和音乐声中，市长用一柄木槌把黄铜龙头敲进一个大啤酒桶内，然后拧开龙头，把啤酒放出来，盛在特制的大啤酒杯中。市长饮下这第一杯，著名的十月节便正式开始了。<span class="sup--normal" style="font-size: 12px; line-height: 0; position: relative; vertical-align: baseline; top: -0.5em; margin-left: 2px; color: rgb(51, 102, 204); cursor: pointer; padding: 0px 2px;"> [6]</span><a class="sup-anchor" style="color: rgb(19, 110, 194); position: relative; top: -50px; font-size: 0px; line-height: 0;" href> </a></p>\n<p><a class="lemma-anchor para-title" style="color: rgb(19, 110, 194); position: absolute; top: -50px;" href></a><a class="lemma-anchor " style="color: rgb(19, 110, 194); position: absolute; top: -50px;" href></a><a class="lemma-anchor " style="color: rgb(19, 110, 194); position: absolute; top: -50px;" href></a><a class="lemma-anchor " style="color: rgb(19, 110, 194); position: absolute; top: -50px;" href></a></p>\n<h3 class="title-text" style="margin: 0px; padding: 0px; font-size: 18px; font-weight: 400;">盛装巡游</h3>\n<p>每年啤酒节的第一个周日，来自全德国各个州的人们穿上富有特色的民族服装</p>\n<p><a class="image-link" href="https://baike.baidu.com/pic/%E6%85%95%E5%B0%BC%E9%BB%91%E5%95%A4%E9%85%92%E8%8A%82/1006782/0/f703738da97739124915b14cf5198618367ae2e8?fr=lemma&ct=single" target="_blank" title="盛装游行" style="color: rgb(19, 110, 194); text-decoration-line: none; display: block; width: 220px; height: 124px;"><img class="" src="https://gss2.bdstatic.com/9fo3dSag_xI4khGkpoWK1HF6hhy/baike/s%3D220/sign=5760dcd95cda81cb4ae684cf6266d0a4/f703738da97739124915b14cf5198618367ae2e8.jpg" alt="盛装游行" style="border: 0px; display: block; margin: 0px auto; width: 220px; height: 124px;"></a><span class="description" style="display: block; color: rgb(85, 85, 85); font-size: 12px; text-indent: 0px; font-family: 宋体; overflow-wrap: break-word; word-break: break-all; line-height: 15px; padding: 8px 7px; min-height: 12px; border-top: 1px solid rgb(224, 224, 224);">盛装游行</span></p>\n<p>，演奏音乐，浩浩荡荡的穿过慕尼黑的市中心，最后来到啤酒节的现场Theresienwiese。</p>\n<p>人们把自己打扮成古代衣着考究的贵族公爵，身披绫罗绸缎的王妃贵妇，驾着鲜花装扮的古典马车，也有不少人很朴实的穿着农民过节穿的衣服。参加的人从老到少，有家庭妇女，中学生，连幼儿园小朋友都有。扮演的人物也是丰富多彩，有<a target="_blank" href="https://baike.baidu.com/item/%E9%98%BF%E5%B0%94%E5%8D%91%E6%96%AF%E5%B1%B1" style="color: rgb(19, 110, 194); text-decoration-line: none;">阿尔卑斯山</a>下的牧童，莱茵河畔的磨房主，到科隆教堂的修女，北德<a target="_blank" href="https://baike.baidu.com/item/%E6%99%AE%E9%B2%81%E5%A3%AB" style="color: rgb(19, 110, 194); text-decoration-line: none;">普鲁士</a>的老翁。<span class="sup--normal" style="font-size: 12px; line-height: 0; position: relative; vertical-align: baseline; top: -0.5em; margin-left: 2px; color: rgb(51, 102, 204); cursor: pointer; padding: 0px 2px;"> [6]</span><a class="sup-anchor" style="color: rgb(19, 110, 194); position: relative; top: -50px; font-size: 0px; line-height: 0;" href> </a></p>\n<p><a class="lemma-anchor para-title" style="color: rgb(19, 110, 194); position: absolute; top: -50px;" href></a><a class="lemma-anchor " style="color: rgb(19, 110, 194); position: absolute; top: -50px;" href></a><a class="lemma-anchor " style="color: rgb(19, 110, 194); position: absolute; top: -50px;" href></a><a class="lemma-anchor " style="color: rgb(19, 110, 194); position: absolute; top: -50px;" href></a></p>\n<h3 class="title-text" style="margin: 0px; padding: 0px; font-size: 18px; font-weight: 400;">啤酒帐篷</h3>\n<p><a class="image-link" href="https://baike.baidu.com/pic/%E6%85%95%E5%B0%BC%E9%BB%91%E5%95%A4%E9%85%92%E8%8A%82/1006782/0/9f2f070828381f308dcf1352a2014c086f06f073?fr=lemma&ct=single" target="_blank" title="" style="color: rgb(19, 110, 194); text-decoration-line: none; display: block; width: 220px; height: 146px;"><img class="" src="https://gss0.bdstatic.com/-4o3dSag_xI4khGkpoWK1HF6hhy/baike/s%3D220/sign=264c72f8c395d143de76e32143f28296/9f2f070828381f308dcf1352a2014c086f06f073.jpg" alt="" style="border: 0px; display: block; margin: 0px auto; width: 220px; height: 146px;"></a></p>\n<p>为了招徕本国顾客和接待来慕尼黑旅游的外国客人，慕尼黑的八大啤酒厂在节前就在特蕾泽大广场上搭起巨大的啤酒大篷，德语里称“Bierzelten”，比一般的帐篷装修更大也更豪华。每个帐篷里放有长条木桌和板凳，大篷的一端还有一个临时舞台，由民间乐队演奏欢乐的民间乐曲。帐篷一般可容纳三四千人，最大的有7000个座位。</p>\n<p>每一个啤酒棚一般都只提供一个酿酒厂的啤酒，为了突出自己的与众不同，每个啤酒厂都把自己的那个啤酒棚修建的富有特色而舒适气派。啤酒棚外部的装修标新立异，但内部大多都是一个格局，可以坐二十人的长条木桌椅排排摆开，会场中心是被鲜花和灯光装扮一新的高高的表演舞台，棚顶装饰着巨幅的绸缎和编织的花环，有的啤酒棚还设两层，楼上便是"雅座"。各帐篷里都由身穿巴伐利亚民族服装的女服务员给顾客送酒。<span class="sup--normal" style="font-size: 12px; line-height: 0; position: relative; vertical-align: baseline; top: -0.5em; margin-left: 2px; color: rgb(51, 102, 204); cursor: pointer; padding: 0px 2px;"> [6]</span><a class="sup-anchor" style="color: rgb(19, 110, 194); position: relative; top: -50px; font-size: 0px; line-height: 0;" href> </a></p>\n<p><a class="lemma-anchor para-title" style="color: rgb(19, 110, 194); position: absolute; top: -50px;" href></a><a class="lemma-anchor " style="color: rgb(19, 110, 194); position: absolute; top: -50px;" href></a><a class="lemma-anchor " style="color: rgb(19, 110, 194); position: absolute; top: -50px;" href></a><a class="lemma-anchor " style="color: rgb(19, 110, 194); position: absolute; top: -50px;" href></a></p>\n<h3 class="title-text" style="margin: 0px; padding: 0px; font-size: 18px; font-weight: 400;">游乐项目</h3>\n<p><a target="_blank" href="https://baike.baidu.com/item/%E6%B8%B8%E4%B9%90%E5%9C%BA" style="color: rgb(19, 110, 194); text-decoration-line: none;">游乐场</a>里还有很多适合家庭娱乐的项目，像大转轮，旋转木马等等老少皆宜的传统娱乐。大会组织者每</p>\n<p><a class="image-link" href="https://baike.baidu.com/pic/%E6%85%95%E5%B0%BC%E9%BB%91%E5%95%A4%E9%85%92%E8%8A%82/1006782/0/42166d224f4a20a46ab4075390529822730ed0ff?fr=lemma&ct=single" target="_blank" title="慕尼黑啤酒节坐飞轮游乐的人们" style="color: rgb(19, 110, 194); text-decoration-line: none; display: block; width: 220px; height: 146px;"><img class="" src="https://gss0.bdstatic.com/-4o3dSag_xI4khGkpoWK1HF6hhy/baike/s%3D220/sign=1585bdbfb051f819f5250448eab54a76/42166d224f4a20a46ab4075390529822730ed0ff.jpg" alt="慕尼黑啤酒节坐飞轮游乐的人们" style="border: 0px; display: block; margin: 0px auto; width: 220px; height: 146px;"></a><span class="description" style="display: block; color: rgb(85, 85, 85); font-size: 12px; text-indent: 0px; font-family: 宋体; overflow-wrap: break-word; word-break: break-all; line-height: 15px; padding: 8px 7px; min-height: 12px; border-top: 1px solid rgb(224, 224, 224);">慕尼黑啤酒节坐飞轮游乐的人们</span></p>\n<p>年都要安排一些新鲜的节目或游乐项目，例如聘请外国的艺术团体演出，还有耍蛇、驯兽等节目。</p>\n<p>另外，各种游乐设施之间也举办许多有意义的展览会，如现代电器展览、优良小麦展览等。还点缀了小马戏团，杂耍铺，魔术表演等等，无数各具特色的小店把整个游乐场装点得生动活泼，游客可在这里买到纪念品，巴伐利亚的特色小点心，或是参与游戏，还可以赢得各种可爱的玩具。<span class="sup--normal" style="font-size: 12px; line-height: 0; position: relative; vertical-align: baseline; top: -0.5em; margin-left: 2px; color: rgb(51, 102, 204); cursor: pointer; padding: 0px 2px;"> [6]</span><a class="sup-anchor" style="color: rgb(19, 110, 194); position: relative; top: -50px; font-size: 0px; line-height: 0;" href> </a></p>\n<p><a class="lemma-anchor para-title" style="color: rgb(19, 110, 194); position: absolute; top: -50px;" href></a><a class="lemma-anchor " style="color: rgb(19, 110, 194); position: absolute; top: -50px;" href></a><a class="lemma-anchor " style="color: rgb(19, 110, 194); position: absolute; top: -50px;" href></a><a class="lemma-anchor " style="color: rgb(19, 110, 194); position: absolute; top: -50px;" href></a></p>\n<h3 class="title-text" style="margin: 0px; padding: 0px; font-size: 18px; font-weight: 400;">特色餐饮</h3>\n<p>为了啤酒节活动专门酿制的一种啤酒叫做“Wiesenbier”，比一般的啤酒颜色更深，酒劲儿也更大，上酒的时候用的是一种叫做“Maß”的容量为一升的大酒杯，现场搭建起容纳三千到一万人的大帐篷，只有慕尼黑当地的酒商才被允许在里边提供这种酒。酒客们也消耗掉大量的食物，大多是传统的家常小吃如香肠、烤小鸡、泡菜和烤牛尾等。</p>\n<p><br></p>\n', NULL, '{"audio":"","video":"","thumbnail":"http:\\/\\/pq5d4o050.bkt.clouddn.com\\/portal\\/20190425\\/11fccbc30577762c8d06467b9255358e.png","template":"","photos":[{"url":"http:\\/\\/pq5d4o050.bkt.clouddn.com\\/portal\\/20190425\\/8187e3515e7bd9ee9a7dcad33b5e89a2.png","name":"微信图片_20190425110755.png"},{"url":"http:\\/\\/pq5d4o050.bkt.clouddn.com\\/portal\\/20190425\\/16a8eab46cd65fcaae6927243651abc5.png","name":"微信图片_20190425110825.png"},{"url":"http:\\/\\/pq5d4o050.bkt.clouddn.com\\/Fr6t4Tcq0RfLcSM1y5Y-N9y16OaX.png","name":"微信图片_20190425111059.png"}]}'),
(3, 0, 18, 1, 1, 1, 0, '', '', '', '', '', '', '', '', 2, '', '', '', 0.00, '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 1556163559, 1556175940, 1556163480, 0, '令人神往的德黑德湖', '', '令人神往的德黑德湖令人神往的德黑德湖令人神往的德黑德湖令人神往的德黑德湖', '', 'http://pq5d4o050.bkt.clouddn.com/portal/20190425/b428d788d96bb211c11f9bd6c1e3aab3.png', '<p>令人神往的德黑德湖令人神往的德黑德湖令人神往的德黑德湖令人神往的德黑德湖令人神往的德黑德湖令人神往的德黑德湖令人神往的德黑德湖令人神往的德黑德湖令人神往的德黑德湖令人神往的德黑德湖令人神往的德黑德湖令人神往的德黑德湖令人神往的德黑德湖令人神往的德黑德湖令人神往的德黑德湖令人神往的德黑德湖令人神往的德黑德湖令人神往的德黑德湖令人神往的德黑德湖令人神往的德黑德湖令人神往的德黑德湖令人神往的德黑德湖令人神往的德黑德湖令人神往的德黑德湖令人神往的德黑德湖</p>', NULL, '{"audio":"","video":"","thumbnail":"http:\\/\\/pq5d4o050.bkt.clouddn.com\\/portal\\/20190425\\/b428d788d96bb211c11f9bd6c1e3aab3.png","template":"","photos":[{"url":"http:\\/\\/pq5d4o050.bkt.clouddn.com\\/FqoLKJ19WTN6Nyn09TcVoqDl5dr2.png","name":"微信图片_20190425111109.png"}]}'),
(4, 0, 18, 1, 1, 1, 0, '', '', '', '', '', '', '', '', 3, '', '', '', 0.00, '', '', '', 1, 0, 0, 0, 12, 0, 0, 0, 1556164035, 1556614995, 1556163960, 0, '令人神往的德黑德湖23', '', 'http://pq5d4o050.bkt.clouddn.comhttp://pq5d4o050.bkt.clouddn.comhttp://pq5d4o050.bkt.clouddn.comhttp://pq5d4o050.bkt.clouddn.com', '', 'http://pq5d4o050.bkt.clouddn.com/portal/20190425/a1657790ea822826bc5da9d14aab99aa.png', '<p><img src="default/20190425/99aa5deae7f4037bd72efc5c41607374.png" title="微信图片_20190425111119.png" alt="微信图片_20190425111119.png"></p>', NULL, '{"thumbnail":"http:\\/\\/pq5d4o050.bkt.clouddn.com\\/portal\\/20190425\\/a1657790ea822826bc5da9d14aab99aa.png"}'),
(5, 0, 18, 1, 1, 1, 0, '', '', '', '', '', '', '', '', 1, '', '', '', 0.00, '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 1556164529, 1556614981, 1556164440, 0, '令人神往的德黑德湖2', '', '11111111111111', '', 'http://pq5d4o050.bkt.clouddn.com/portal/20190425/17301a971e79bd2ca72f3d6ff9cbaf46.png', '<p>111111111111</p>', NULL, '{"thumbnail":"http:\\/\\/pq5d4o050.bkt.clouddn.com\\/portal\\/20190425\\/17301a971e79bd2ca72f3d6ff9cbaf46.png","photos":[{"url":"http:\\/\\/pq5d4o050.bkt.clouddn.com\\/portal\\/20190425\\/05eb1990d1a14196ccda854be5b06bd1.png","name":"微信图片_20190425111114.png"},{"url":"http:\\/\\/pq5d4o050.bkt.clouddn.com\\/portal\\/20190425\\/d46c0778c5a815362bde7b24cd3c86f5.jpg","name":"timg (1).jpg"}]}'),
(6, 0, 18, 1, 1, 1, 0, '', '', '', '', '', '', '', '', 0, '', '', '', 0.00, '', '', '', 1, 0, 0, 0, 10, 0, 0, 0, 1556175593, 1556448746, 1556175300, 0, '婚礼蜜月', '', '婚礼蜜月婚礼蜜月婚礼蜜月婚礼蜜月', '', 'http://pq5d4o050.bkt.clouddn.com/portal/20190425/abf4f6a8c53c54ffa26349bf1076c2cf.png', '<p>婚礼蜜月婚礼蜜月婚礼蜜月婚礼蜜月婚礼蜜月婚礼蜜月婚礼蜜月婚礼蜜月婚礼蜜月婚礼蜜月</p>', NULL, '{"thumbnail":"http:\\/\\/pq5d4o050.bkt.clouddn.com\\/portal\\/20190425\\/abf4f6a8c53c54ffa26349bf1076c2cf.png","photos":[{"url":"http:\\/\\/pq5d4o050.bkt.clouddn.com\\/portal\\/20190425\\/39b06f8b02d02ab40fc34f4585355d41.png","name":"微信图片_20190425145816.png"}]}'),
(7, 0, 18, 1, 1, 1, 0, '', '', '', '', '', '', '', '', 0, '', '', '', 0.00, '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 1556182116, 1556185061, 1556182020, 0, '水墨之道', '', '', '', 'http://pq5d4o050.bkt.clouddn.com/portal/20190425/dc3ce256ba59e7c4e562bfa2880cc14b.png', NULL, NULL, '{"audio":"","video":"http:\\/\\/pq5d4o050.bkt.clouddn.com\\/portal\\/20190425\\/828b2d328045e03ef788b40d68198aa0.mp4","thumbnail":"http:\\/\\/pq5d4o050.bkt.clouddn.com\\/portal\\/20190425\\/dc3ce256ba59e7c4e562bfa2880cc14b.png","template":""}'),
(8, 0, 18, 1, 1, 1, 0, '', '', '', '加州德黑德湖', '2019-04-19', '', '', '', 0, '', '', '', 0.00, '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 1556182182, 1556185345, 1556182080, 0, '水墨视频', '', '', '', 'http://pq5d4o050.bkt.clouddn.com/portal/20190425/1eaeda9f6b97e7fd827d618c55832e77.png', NULL, NULL, '{"audio":"","video":"http:\\/\\/pq5d4o050.bkt.clouddn.com\\/portal\\/20190425\\/828b2d328045e03ef788b40d68198aa0.mp4","thumbnail":"http:\\/\\/pq5d4o050.bkt.clouddn.com\\/portal\\/20190425\\/1eaeda9f6b97e7fd827d618c55832e77.png","template":""}'),
(9, 0, 0, 1, 1, 1, 0, '', '', '', '', '', '胡歌', '国际巨星', '慈善家', 0, '', '', '', 0.00, '', '', '', 1, 0, 0, 0, 10, 0, 0, 0, 1556188106, 1556516624, 1556188020, 0, '明星访谈', '', '明星访谈明星访谈明星访谈明星访谈', '', 'portal/20190429/6c4ccc38498e75cad0f02d9c64391099.jpg', '<p>明星访谈明星访谈明星访谈明星访谈明星访谈明星访谈明星访谈明星访谈明星访谈</p>', NULL, '{"thumbnail":"portal\\/20190429\\/6c4ccc38498e75cad0f02d9c64391099.jpg"}'),
(10, 0, 0, 1, 1, 1, 0, '', '', '', '', '', '', '', '', 0, '', '', '', 0.00, '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 1556189470, 1556189506, 1556189400, 0, '星域画廊', '', '明星访谈明星访谈明星访谈明星访谈明星访谈', '', 'http://pq5d4o050.bkt.clouddn.com/portal/20190425/7d20099f59a3da3f988357afe26719be.png', '<p>明星访谈明星访谈明星访谈明星访谈明星访谈明星访谈</p>', NULL, '{"audio":"","video":"","thumbnail":"http:\\/\\/pq5d4o050.bkt.clouddn.com\\/portal\\/20190425\\/7d20099f59a3da3f988357afe26719be.png","template":"","photos":[{"url":"http:\\/\\/pq5d4o050.bkt.clouddn.com\\/portal\\/20190425\\/6f7f86453aafd1ef747ccbac5fdd6ac0.png","name":"微信图片_20190425145816.png"}]}'),
(11, 0, 0, 1, 1, 1, 0, '', '', '', '', '', '', '', '', 0, '', '', '', 100.05, 'https://www.baidu.com', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 1556189981, 1556533916, 1556189700, 0, '星探推荐-地道风物', '', '星探推荐-地道风物星探推荐-地道风物星探推荐-地道风物星探推荐-地道风物星探推荐-地道风物', '', 'http://pq5d4o050.bkt.clouddn.com/portal/20190425/234be5441d05af17abbc0cf98ff7c9f7.png', '<p>星探推荐-地道风物星探推荐-地道风物星探推荐-地道风物星探推荐-地道风物星探推荐-地道风物</p>', NULL, '{"thumbnail":"http:\\/\\/pq5d4o050.bkt.clouddn.com\\/portal\\/20190425\\/234be5441d05af17abbc0cf98ff7c9f7.png","photos":[{"url":"http:\\/\\/pq5d4o050.bkt.clouddn.com\\/portal\\/20190425\\/7835cc0b35d0c1b50a15724de41e9c4d.png","name":"微信图片_20190425145830.png"}]}'),
(12, 0, 0, 1, 1, 1, 0, '', '', '', '', '', '', '', '', 0, '', '', '', 0.00, '', 'https://www.baidu.com', '', 1, 0, 0, 0, 10, 0, 0, 0, 1556190649, 1556536629, 1556189940, 0, '3月-4月川藏南线拼车-相约林芝桃花节', '', '3月-4月川藏南线拼车-相约林芝桃花节3月-4月川藏南线拼车-相约林芝桃花节3月-4月川藏南线拼车-相约林芝桃花节', '', 'http://pq5d4o050.bkt.clouddn.com/portal/20190425/cdd40de358dfa43cab73c218055f8430.png', '<p>3月-4月川藏南线拼车-相约林芝桃花节3月-4月川藏南线拼车-相约林芝桃花节3月-4月川藏南线拼车-相约林芝桃花节</p>', NULL, '{"thumbnail":"http:\\/\\/pq5d4o050.bkt.clouddn.com\\/portal\\/20190425\\/cdd40de358dfa43cab73c218055f8430.png","photos":[{"url":"http:\\/\\/pq5d4o050.bkt.clouddn.com\\/portal\\/20190425\\/86729d0ee4286191dd6f9e12bc69f76f.png","name":"微信图片_20190425111105.png"}]}'),
(13, 0, 0, 1, 1, 1, 0, '', '', '', '', '', '', '', '', 0, '', '', '', 0.00, '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 1556191515, 1556191515, 1556191394, 0, '关于我们-关于我们', '', '六大分会场2018年桃花节活动攻略一览回春了，又到了出门踏青的好节气，瑞士没有桃花，江南没有雪山，那就不得不和大家说一说西藏林芝那美丽的桃花了，只有林芝才能尽享桃花掩映下的雪山之景。就在我们不经意间，林芝的桃花儿已经开始陆陆续续绽放开来，每年进藏只是看桃花的人都是数不胜数，如果你从拉萨顺着尼洋河来到林芝，那你的感觉就好像不经意间闯进了一个西藏的江南，雪山、草地、灌木丛、桃花林的景观不断切换，仿若陶渊明笔下的世外桃源.....', '', 'http://pq5d4o050.bkt.clouddn.com/portal/20190425/aa8d23bdaa8ccad9581e6d65d3ee338d.png', '<p><span style="color: rgb(51, 51, 51); font-family: " hiragino sans gb neue helvetica stheiti yahei sans-serif font-size: text-align: justify background-color: rgb>六大分会场2018年桃花节活动攻略一览回春了，又到了出门踏青的好节气，瑞士没有桃花，江南没有雪山，那就不得不和大家说一说西藏林芝那美丽的桃花了，只有林芝才能尽享桃花掩映下的雪山之景。就在我们不经意间，林芝的桃花儿已经开始陆陆续续绽放开来，每年进藏只是看桃花的人都是数不胜数，如果你从拉萨顺着尼洋河来到林芝，那你的感觉就好像不经意间闯进了一个西藏的江南，雪山、草地、灌木丛、桃花林的景观不断切换，仿若陶渊明笔下的世外桃源.....</span><span style="color: rgb(51, 51, 51); font-family: " hiragino sans gb neue helvetica stheiti yahei sans-serif font-size: text-align: justify background-color: rgb>六大分会场2018年桃花节活动攻略一览回春了，又到了出门踏青的好节气，瑞士没有桃花，江南没有雪山，那就不得不和大家说一说西藏林芝那美丽的桃花了，只有林芝才能尽享桃花掩映下的雪山之景。就在我们不经意间，林芝的桃花儿已经开始陆陆续续绽放开来，每年进藏只是看桃花的人都是数不胜数，如果你从拉萨顺着尼洋河来到林芝，那你的感觉就好像不经意间闯进了一个西藏的江南，雪山、草地、灌木丛、桃花林的景观不断切换，仿若陶渊明笔下的世外桃源.....</span><span style="color: rgb(51, 51, 51); font-family: " hiragino sans gb neue helvetica stheiti yahei sans-serif font-size: text-align: justify background-color: rgb>六大分会场2018年桃花节活动攻略一览回春了，又到了出门踏青的好节气，瑞士没有桃花，江南没有雪山，那就不得不和大家说一说西藏林芝那美丽的桃花了，只有林芝才能尽享桃花掩映下的雪山之景。就在我们不经意间，林芝的桃花儿已经开始陆陆续续绽放开来，每年进藏只是看桃花的人都是数不胜数，如果你从拉萨顺着尼洋河来到林芝，那你的感觉就好像不经意间闯进了一个西藏的江南，雪山、草地、灌木丛、桃花林的景观不断切换，仿若陶渊明笔下的世外桃源.....</span></p>', NULL, '{"audio":"","video":"","thumbnail":"http:\\/\\/pq5d4o050.bkt.clouddn.com\\/portal\\/20190425\\/aa8d23bdaa8ccad9581e6d65d3ee338d.png","photos":[{"url":"http:\\/\\/pq5d4o050.bkt.clouddn.com\\/portal\\/20190425\\/778543f7bb70fcc5ee5fea25580d5f9b.png","name":"微信图片_20190425145830.png"}]}'),
(14, 0, 0, 1, 1, 1, 0, '', '', '', '', '', '', '', '', 0, '', '', '', 0.00, '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 1556192678, 1556192678, 1556191725, 0, '关注我们-关注我们', '', '', '', 'http://pq5d4o050.bkt.clouddn.com/portal/20190425/cfbf437f97075119f59682d57d5ae581.jpg', NULL, NULL, '{"audio":"","video":"","thumbnail":"http:\\/\\/pq5d4o050.bkt.clouddn.com\\/portal\\/20190425\\/cfbf437f97075119f59682d57d5ae581.jpg","photos":[{"url":"http:\\/\\/pq5d4o050.bkt.clouddn.com\\/portal\\/20190425\\/698c8d8aa10206004ee19af05dbaff89.png","name":"微信图片_20190425145821.png"}]}'),
(15, 0, 0, 1, 1, 1, 0, '', '', '', '', '', '', '', '', 0, '', '', '', 0.00, '', '', 'https://www.baidu.com', 1, 0, 0, 0, 0, 0, 0, 0, 1556245624, 1556245624, 1556245556, 0, '友情链接-友情链接', '', '', '', '', NULL, NULL, '{"audio":"","video":"","thumbnail":""}'),
(16, 0, 0, 1, 1, 1, 0, '', '', '', '', '', '', '', '', 0, '', '', '', 0.00, '', '', 'https://www.baidu.com', 1, 0, 0, 0, 0, 0, 0, 0, 1556330878, 1556345378, 1556330820, 0, '友情链接-友情链接', '', '', '', 'http://pq5d4o050.bkt.clouddn.com/Fq7MQ_YZIQIcK5pUbM5nJATU15hx.png', NULL, NULL, '{"audio":"","video":"","thumbnail":"http:\\/\\/pq5d4o050.bkt.clouddn.com\\/Fq7MQ_YZIQIcK5pUbM5nJATU15hx.png","template":""}'),
(17, 0, 18, 1, 1, 1, 0, '', '', '', '', '', '', '', '', 0, '', '', '', 0.00, '', '', '', 1, 0, 0, 0, 5, 0, 0, 0, 1556366121, 1556447703, 1556366040, 0, '英国星球故事', '', '英国星球故事英国星球故事', '', 'portal/20190427/7bb21072beef1c4bf2550eb935235b42.png', '<p>英国星球故事英国星球故事</p>', NULL, '{"audio":"portal\\/20190427\\/9717bb01f748538eacdd3dec2e7dcd87.mp3","thumbnail":"portal\\/20190427\\/7bb21072beef1c4bf2550eb935235b42.png","photos":[{"url":"portal\\/20190427\\/aacfb30e2dd0a501a4c39278107374bf.png","name":"微信图片_20190425110825.png"}]}'),
(18, 0, 18, 1, 1, 1, 0, '', '', '', '', '', '', '', '', 0, '', '', '', 0.00, '', '', '', 1, 0, 0, 0, 18, 0, 0, 0, 1556411498, 1556447786, 1556411400, 0, '城市星球故事', '', '1111', '', '', NULL, NULL, '{"audio":"","thumbnail":""}'),
(19, 0, 18, 1, 1, 1, 0, '', '', '', '', '', '', '', '', 0, '', '', '', 0.00, '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 1556411776, 1556411776, 1556411688, 0, '英国星球故事', '', '弱小的生物进化人何英俊，被逃命的外星生物寄生，体质得到了进化。\r\n在机械人势力的追杀中，以拳头杀出一条血路，驾驶星际飞船，开始了星辰大海的冒险。\r\n沉寂的双宝石星，\r\n拥有生命的植物型星际战舰，\r\n曾今是强者之剑的异型星球帕兰多，\r\n建造了几十年的天望号行星飞船，\r\n强大的机械人星际堡垒钛星，\r\n行星一样巨大的生命体。\r\n《星球故事》将带您进入一段奇妙而绚丽的旅程。', '', '', '<p>弱小的生物进化人何英俊，被逃命的外星生物寄生，体质得到了进化。<br>在机械人势力的追杀中，以拳头杀出一条血路，驾驶星际飞船，开始了星辰大海的冒险。<br>沉寂的双宝石星，<br>拥有生命的植物型星际战舰，<br>曾今是强者之剑的异型星球帕兰多，<br>建造了几十年的天望号行星飞船，<br>强大的机械人星际堡垒钛星，<br>行星一样巨大的生命体。<br>《星球故事》将带您进入一段奇妙而绚丽的旅程。</p>', NULL, '{"audio":"","thumbnail":""}'),
(20, 0, 19, 1, 1, 1, 0, '', '', '', '', '', '', '', '', 0, '', '', '', 0.00, '', '', '', 1, 0, 0, 0, 10, 0, 0, 0, 1556447078, 1556447286, 1556447040, 0, '令人神往的德黑德湖', '', '令人神往的德黑德湖', '', 'portal/20190428/1997922c27fa9bc8e6b263f807aa55e4.png', '<p>令人神往的德黑德湖</p>', NULL, '{"audio":"portal\\/20190427\\/9717bb01f748538eacdd3dec2e7dcd87.mp3","thumbnail":"portal\\/20190428\\/1997922c27fa9bc8e6b263f807aa55e4.png"}'),
(21, 0, 19, 1, 1, 1, 0, '', '', '', '', '', '', '', '', 0, '', '', '', 0.00, '', '', '', 1, 0, 0, 0, 10, 0, 0, 0, 1556501036, 1556501355, 1556500980, 0, '中国美食1', '', '中国美食1中国美食1中国美食1中国美食', '', 'portal/20190429/b6c9f9ee9dbf3a2801e8b5f803a18599.png', '<p>中国美食1中国美食1中国美食1中国美食1中国美食1中国美食1</p>', NULL, '{"thumbnail":"portal\\/20190429\\/b6c9f9ee9dbf3a2801e8b5f803a18599.png","photos":[{"url":"portal\\/20190429\\/757903cfcd72efd2a1ee5147ffa30967.jpg","name":"timg (3).jpg"}]}'),
(22, 0, 19, 1, 1, 1, 0, '13752011725', 'http://www.baidu.com', '天津市南开区卫津路', '', '', '', '', '', 0, '', '', '', 0.00, '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 1556502356, 1556502356, 1556502139, 0, '中国五星级酒店', '', '中国五星级酒店中国五星级酒店中国五星级酒店', '', 'portal/20190427/aacfb30e2dd0a501a4c39278107374bf.png', '<p>中国五星级酒店中国五星级酒店中国五星级酒店中国五星级酒店中国五星级酒店中国五星级酒店</p>', NULL, '{"thumbnail":"portal\\/20190427\\/aacfb30e2dd0a501a4c39278107374bf.png","photos":[{"url":"portal\\/20190429\\/fb06758a3957629cca7f3de215c0c0a1.png","name":"微信图片_20190425145816.png"}]}'),
(23, 0, 19, 1, 1, 1, 0, '', '', '', '', '', '', '', '', 0, '', '', '', 0.00, '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 1556503912, 1556504243, 1556503860, 0, '打造网红美景', '', '打造网红美景打造网红美景', '', 'portal/20190429/8d8a1805c37888ec709264f399903ab3.png', '<p>打造网红美景打造网红美景打造网红美景</p>', NULL, '{"thumbnail":"portal\\/20190429\\/8d8a1805c37888ec709264f399903ab3.png","photos":[{"url":"portal\\/20190429\\/ca713bb61ec2d5bf635cf3b9049f116a.png","name":"微信图片_20190425145821.png"}]}'),
(24, 0, 19, 1, 1, 1, 0, '', '', '', '', '', '', '', '', 0, '', '', '', 0.00, '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 1556504296, 1556504438, 1556504220, 0, '打造活力生态', '', '打造活力生态打造活力生态打造活力生态打造活力生态', '', 'portal/20190429/fb8f8a74672780a7a8c140fc82719482.png', '<p>打造活力生态打造活力生态打造活力生态打造活力生态<img src="default/20190429/44db02bc8a4daeb5d071c4db10f7b8ec.png" title="微信图片_20190425111119.png" alt="微信图片_20190425111119.png"></p>', NULL, '{"thumbnail":"portal\\/20190429\\/fb8f8a74672780a7a8c140fc82719482.png"}'),
(25, 0, 19, 1, 1, 1, 0, '', '', '', '', '', '', '', '', 0, '', '', '', 0.00, '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 1556504917, 1556504917, 1556504870, 0, '去中国走一走', '', '去中国走一走去中国走一走去中国走一走去中国走一走', '', 'portal/20190429/b15b225f006041d70c7ef3065f3bce3a.png', '\n<p>去中国走一走去中国走一走去中国走一走</p>\n<p><img src="default/20190429/25e3fbcc3286d28d126279ba95e15a92.png" title="微信图片_20190425111119.png" alt="微信图片_20190425111119.png"></p>\n', NULL, '{"thumbnail":"portal\\/20190429\\/b15b225f006041d70c7ef3065f3bce3a.png"}'),
(26, 0, 19, 1, 1, 1, 0, '', '', '', '美国加州，中国香港', '2019-10-19', '', '', '', 0, '', '', '', 0.00, '', '', '', 1, 0, 0, 0, 10, 0, 0, 0, 1556507975, 1556516534, 1556507700, 0, '李小龙传奇', '', '', '', '', NULL, NULL, '{"video":"portal\\/20190429\\/7ede6d84c6641e06fb20490060bf5925.mp4","thumbnail":""}'),
(27, 0, 19, 1, 1, 1, 0, '', '', '', '中国大陆', '2019-04-11', '', '', '', 0, '', '', '', 0.00, '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 1556509173, 1556509173, 1556509140, 0, '唐山大师兄', '', '', '', '', NULL, NULL, '{"video":"portal\\/20190429\\/7ede6d84c6641e06fb20490060bf5925.mp4","thumbnail":""}'),
(28, 0, 0, 1, 1, 1, 0, '', '', '', '', '', '古天乐', '国际巨星', '偏远山区慈善家', 0, '', '', '', 0.00, '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 1556516747, 1556517471, 1556516580, 0, '', '', '天乐1', '', 'portal/20190429/22f24f0d60df0f26cf3930f76c9ea17f.png', '<p>国际巨星国际巨星国际巨星国际巨星国际巨星</p>', NULL, '{"thumbnail":"portal\\/20190429\\/22f24f0d60df0f26cf3930f76c9ea17f.png"}'),
(29, 0, 0, 1, 1, 1, 0, '', '', '', '', '', '', '', '', 0, '', '', '', 0.00, '', '', '', 1, 0, 0, 0, 10, 0, 0, 0, 1556518315, 1556518333, 1556518260, 0, '', '', '', '', 'portal/20190429/db20ef6b18d6cfa5319edb8a94e48945.png', NULL, NULL, '{"thumbnail":"portal\\/20190429\\/db20ef6b18d6cfa5319edb8a94e48945.png"}'),
(30, 0, 0, 1, 1, 1, 0, '', '', '', '', '', '', '', '', 0, '', '', '', 0.00, '', '', '', 1, 0, 0, 0, 11, 0, 0, 0, 1556523821, 1556524263, 1556523720, 0, '快报快报', '', '快报快报快报快报快报快报快报快报', '', 'portal/20190429/125f4f22caa84f24de12df628acc3fd2.jpg', '\n<p>快报快报快报快报快报快报快报快报</p>\n<p><img src="default/20190429/fecb2418a023e2bf4fd84be58d2dde9e.png" title="kecheng@2x.png" alt="kecheng@2x.png"></p>\n', NULL, '{"thumbnail":"portal\\/20190429\\/125f4f22caa84f24de12df628acc3fd2.jpg","photos":[{"url":"portal\\/20190429\\/3121a98b17fdf1fb02ab5f21b8e1929f.png","name":"gongsitu@2x.png"}]}'),
(31, 0, 0, 1, 1, 1, 0, '', '', '', '', '', '', '', '', 0, '', '', '', 0.00, '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 1556524866, 1556524902, 1556524800, 0, '独角日志1', '', '独角日志独角日志', '', 'portal/20190429/1945736e057830f4233cd8d65b62e57b.png', '<p>独角日志独角日志独角日志</p>', NULL, '{"thumbnail":"portal\\/20190429\\/1945736e057830f4233cd8d65b62e57b.png"}'),
(32, 0, 0, 1, 1, 1, 0, '', '', '', '', '', '', '', '', 0, '', '', '', 0.00, '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 1556526265, 1556526335, 1556526180, 0, '童趣未来1', '', '童趣未来童趣未来童趣未来', '', 'portal/20190429/5951663d83c8d0893d72a6693e4471f7.png', '<p>童趣未来童趣未来</p>', NULL, '{"thumbnail":"portal\\/20190429\\/5951663d83c8d0893d72a6693e4471f7.png"}'),
(33, 0, 19, 1, 1, 1, 0, '', '', '', '', '', '', '', '', 4, '', '', '', 0.00, '', '', '', 1, 0, 0, 0, 10, 0, 0, 0, 1556528358, 1556615321, 1556528280, 0, '亲临现场呀', '', '亲临现场呀亲临现场呀亲临现场呀', '', 'portal/20190429/c59476d9dc9bb77720c056fa58e94f98.png', '<p>亲临现场呀亲临现场呀亲临现场呀</p>', NULL, '{"thumbnail":"portal\\/20190429\\/c59476d9dc9bb77720c056fa58e94f98.png"}'),
(34, 0, 8, 1, 1, 1, 0, '', '', '', '', '', '', '', '', 3, '', '', '', 0.00, '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 1556528737, 1556615423, 1556528640, 0, '市井漫游1', '', '市井漫游市井漫游市井漫游市井漫游', '', 'portal/20190429/3ba0bebeae9b35b66646fed6c431c219.png', '<p>市井漫游市井漫游市井漫游</p>', NULL, '{"thumbnail":"portal\\/20190429\\/3ba0bebeae9b35b66646fed6c431c219.png"}'),
(35, 0, 16, 1, 1, 1, 0, '', '', '', '', '', '', '', '', 3, '', '', '', 0.00, '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 1556529363, 1556615011, 1556529300, 0, '户外好风光', '', '户外好风光户外好风光', '', 'portal/20190429/a1b641715a64787a3e72505a729db5e9.png', '<p>户外好风光户外好风光</p>', NULL, '{"thumbnail":"portal\\/20190429\\/a1b641715a64787a3e72505a729db5e9.png"}'),
(36, 0, 0, 1, 1, 1, 0, '', '', '', '', '', '', '', '', 0, '提前预定', '富国岛机场', '游乐园', 100.25, 'https://www.baidu.com', '', '', 1, 0, 0, 0, 10, 0, 0, 0, 1556532567, 1556533480, 1556532240, 0, '新西兰自驾南岛深度游', '', '66666', '', 'portal/20190429/08f408325e3667db34e36457211771fb.jpg', '', NULL, '{"thumbnail":"portal\\/20190429\\/08f408325e3667db34e36457211771fb.jpg"}'),
(37, 0, 0, 1, 1, 1, 0, '', '', '', '', '', '', '', '', 0, '', '', '', 20.06, 'https://www.baidu.com', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 1556533971, 1556533971, 1556533934, 0, '星探推荐-地道风物1', '', '星探推荐11-地道风物星探推荐-地道风物星探推荐-地道风物星探推荐-地道风物1', '', 'portal/20190429/8a67cbf7545fdc3133aa9862b65547dc.png', NULL, NULL, '{"thumbnail":"portal\\/20190429\\/8a67cbf7545fdc3133aa9862b65547dc.png"}'),
(38, 0, 0, 1, 1, 1, 0, '', '', '', '', '', '', '', '', 0, '', '', '', 100.00, 'https://www.baidu.com', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 1556535742, 1556535742, 1556535701, 0, '创意设计1', '', '创意设计1创意设计1创意设计1创意设计1创意设计1创意设计1', '', 'portal/20190429/f11665cb022a20b3248590e2b8584b78.png', NULL, NULL, '{"thumbnail":"portal\\/20190429\\/f11665cb022a20b3248590e2b8584b78.png"}'),
(39, 0, 0, 1, 1, 1, 0, '', '', '', '', '', '', '', '', 0, '', '', '', 500.00, 'https://www.baidu.com', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 1556535801, 1556535801, 1556535764, 0, '悦己悦人', '', '悦己悦人悦己悦人悦己悦人悦己悦人悦己悦人', '', 'portal/20190429/0376add8d72767e0d842af5ec8fbf881.png', NULL, NULL, '{"thumbnail":"portal\\/20190429\\/0376add8d72767e0d842af5ec8fbf881.png"}'),
(40, 0, 0, 1, 1, 1, 0, '', '', '', '', '', '', '', '', 0, '', '', '', 0.00, '', 'https://www.baidu.com', '', 1, 0, 0, 0, 20, 0, 0, 0, 1556536801, 1556593182, 1556536740, 0, '星际活动', '', '星际活动星际活动星际活动星际活动星际活动', '', 'portal/20190429/8aca39c323e0db4acce237da57325b93.png', '\n<p>星际活动星际活动星际活动</p>\n<p><img src="default/20190430/9cec09b639c89b0544dbe445969b2ae0.jpg" title="pcbanner.jpg" alt="pcbanner.jpg"></p>\n', NULL, '{"thumbnail":"portal\\/20190429\\/8aca39c323e0db4acce237da57325b93.png"}'),
(41, 0, 19, 1, 1, 1, 0, '', '', '', '', '', '', '', '', 5, '', '', '', 0.00, '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 1556614263, 1556616351, 1556614200, 0, '1111', '', '11111', '', '', '<p>梵蒂冈梵蒂冈梵蒂冈</p>', NULL, '{"thumbnail":""}');

-- --------------------------------------------------------

--
-- 表的结构 `cmf_portal_tag`
--

CREATE TABLE `cmf_portal_tag` (
  `id` bigint(20) UNSIGNED NOT NULL COMMENT '分类id',
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '状态,1:发布,0:不发布',
  `recommended` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '是否推荐;1:推荐;0:不推荐',
  `post_count` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '标签文章数',
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '标签名称'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='portal应用 文章标签表';

-- --------------------------------------------------------

--
-- 表的结构 `cmf_portal_tag_post`
--

CREATE TABLE `cmf_portal_tag_post` (
  `id` bigint(20) NOT NULL,
  `tag_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '标签 id',
  `post_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '文章 id',
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '状态,1:发布;0:不发布'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='portal应用 标签文章对应表';

-- --------------------------------------------------------

--
-- 表的结构 `cmf_recycle_bin`
--

CREATE TABLE `cmf_recycle_bin` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `object_id` int(11) DEFAULT '0' COMMENT '删除内容 id',
  `create_time` int(10) UNSIGNED DEFAULT '0' COMMENT '创建时间',
  `table_name` varchar(60) DEFAULT '' COMMENT '删除内容所在表名',
  `name` varchar(255) DEFAULT '' COMMENT '删除内容名称',
  `user_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户id'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT=' 回收站';

--
-- 转存表中的数据 `cmf_recycle_bin`
--

INSERT INTO `cmf_recycle_bin` (`id`, `object_id`, `create_time`, `table_name`, `name`, `user_id`) VALUES
(1, 38, 1556337428, 'portal_category', 'ceshid', 0);

-- --------------------------------------------------------

--
-- 表的结构 `cmf_role`
--

CREATE TABLE `cmf_role` (
  `id` int(10) UNSIGNED NOT NULL,
  `parent_id` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '父角色ID',
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '状态;0:禁用;1:正常',
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '更新时间',
  `list_order` float NOT NULL DEFAULT '0' COMMENT '排序',
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '角色名称',
  `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色表';

--
-- 转存表中的数据 `cmf_role`
--

INSERT INTO `cmf_role` (`id`, `parent_id`, `status`, `create_time`, `update_time`, `list_order`, `name`, `remark`) VALUES
(1, 0, 1, 1329633709, 1329633709, 0, '超级管理员', '拥有网站最高管理员权限！'),
(2, 0, 1, 1329633709, 1329633709, 0, '普通管理员', '权限由最高管理员分配！');

-- --------------------------------------------------------

--
-- 表的结构 `cmf_role_user`
--

CREATE TABLE `cmf_role_user` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `role_id` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '角色 id',
  `user_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户id'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户角色对应表';

-- --------------------------------------------------------

--
-- 表的结构 `cmf_route`
--

CREATE TABLE `cmf_route` (
  `id` int(11) NOT NULL COMMENT '路由id',
  `list_order` float NOT NULL DEFAULT '10000' COMMENT '排序',
  `status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '状态;1:启用,0:不启用',
  `type` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'URL规则类型;1:用户自定义;2:别名添加',
  `full_url` varchar(255) NOT NULL DEFAULT '' COMMENT '完整url',
  `url` varchar(255) NOT NULL DEFAULT '' COMMENT '实际显示的url'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='url路由表';

-- --------------------------------------------------------

--
-- 表的结构 `cmf_slide`
--

CREATE TABLE `cmf_slide` (
  `id` int(11) NOT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '状态,1:显示,0不显示',
  `delete_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '删除时间',
  `name` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '幻灯片分类',
  `remark` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '分类备注'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='幻灯片表';

-- --------------------------------------------------------

--
-- 表的结构 `cmf_slide_item`
--

CREATE TABLE `cmf_slide_item` (
  `id` int(10) UNSIGNED NOT NULL,
  `slide_id` int(11) NOT NULL DEFAULT '0' COMMENT '幻灯片id',
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '状态,1:显示;0:隐藏',
  `list_order` float NOT NULL DEFAULT '10000' COMMENT '排序',
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '幻灯片名称',
  `image` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '幻灯片图片',
  `url` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '幻灯片链接',
  `target` varchar(10) NOT NULL DEFAULT '' COMMENT '友情链接打开方式',
  `description` varchar(255) CHARACTER SET utf8 NOT NULL COMMENT '幻灯片描述',
  `content` text CHARACTER SET utf8 COMMENT '幻灯片内容',
  `more` text COMMENT '扩展信息'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='幻灯片子项表';

-- --------------------------------------------------------

--
-- 表的结构 `cmf_theme`
--

CREATE TABLE `cmf_theme` (
  `id` int(11) NOT NULL,
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '安装时间',
  `update_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '最后升级时间',
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '模板状态,1:正在使用;0:未使用',
  `is_compiled` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '是否为已编译模板',
  `theme` varchar(20) NOT NULL DEFAULT '' COMMENT '主题目录名，用于主题的维一标识',
  `name` varchar(20) NOT NULL DEFAULT '' COMMENT '主题名称',
  `version` varchar(20) NOT NULL DEFAULT '' COMMENT '主题版本号',
  `demo_url` varchar(50) NOT NULL DEFAULT '' COMMENT '演示地址，带协议',
  `thumbnail` varchar(100) NOT NULL DEFAULT '' COMMENT '缩略图',
  `author` varchar(20) NOT NULL DEFAULT '' COMMENT '主题作者',
  `author_url` varchar(50) NOT NULL DEFAULT '' COMMENT '作者网站链接',
  `lang` varchar(10) NOT NULL DEFAULT '' COMMENT '支持语言',
  `keywords` varchar(50) NOT NULL DEFAULT '' COMMENT '主题关键字',
  `description` varchar(100) NOT NULL DEFAULT '' COMMENT '主题描述'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `cmf_theme`
--

INSERT INTO `cmf_theme` (`id`, `create_time`, `update_time`, `status`, `is_compiled`, `theme`, `name`, `version`, `demo_url`, `thumbnail`, `author`, `author_url`, `lang`, `keywords`, `description`) VALUES
(1, 0, 0, 0, 0, 'simpleboot3', 'simpleboot3', '1.0.2', 'http://demo.thinkcmf.com', '', 'ThinkCMF', 'http://www.thinkcmf.com', 'zh-cn', 'ThinkCMF模板', 'ThinkCMF默认模板'),
(2, 0, 0, 0, 0, 'simpleboot3_mobile', 'simpleboot3_mobile', '1.0.2', 'http://demo.bronet.cn', '', 'bronet', 'http://www.bronet.cn', 'zh-cn', 'bronet模板', 'bronet默认手机端模板');

-- --------------------------------------------------------

--
-- 表的结构 `cmf_theme_file`
--

CREATE TABLE `cmf_theme_file` (
  `id` int(11) NOT NULL,
  `is_public` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否公共的模板文件',
  `list_order` float NOT NULL DEFAULT '10000' COMMENT '排序',
  `theme` varchar(20) NOT NULL DEFAULT '' COMMENT '模板名称',
  `name` varchar(20) NOT NULL DEFAULT '' COMMENT '模板文件名',
  `action` varchar(50) NOT NULL DEFAULT '' COMMENT '操作',
  `file` varchar(50) NOT NULL DEFAULT '' COMMENT '模板文件，相对于模板根目录，如Portal/index.html',
  `description` varchar(100) NOT NULL DEFAULT '' COMMENT '模板文件描述',
  `more` text COMMENT '模板更多配置,用户自己后台设置的',
  `config_more` text COMMENT '模板更多配置,来源模板的配置文件',
  `draft_more` text COMMENT '模板更多配置,用户临时保存的配置'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `cmf_theme_file`
--

INSERT INTO `cmf_theme_file` (`id`, `is_public`, `list_order`, `theme`, `name`, `action`, `file`, `description`, `more`, `config_more`, `draft_more`) VALUES
(7, 1, 0, 'simpleboot3', '模板全局配置', 'public/Config', 'public/config', '模板全局配置文件', '{"vars":{"enable_mobile":{"title":"\\u624b\\u673a\\u6ce8\\u518c","value":1,"type":"select","options":{"1":"\\u5f00\\u542f","0":"\\u5173\\u95ed"},"tip":""}}}', '{"vars":{"enable_mobile":{"title":"\\u624b\\u673a\\u6ce8\\u518c","value":1,"type":"select","options":{"1":"\\u5f00\\u542f","0":"\\u5173\\u95ed"},"tip":""}}}', NULL),
(8, 1, 1, 'simpleboot3', '导航条', 'public/Nav', 'public/nav', '导航条模板文件', '{"vars":{"company_name":{"title":"\\u516c\\u53f8\\u540d\\u79f0","name":"company_name","value":"ThinkCMF","type":"text","tip":"","rule":[]}}}', '{"vars":{"company_name":{"title":"\\u516c\\u53f8\\u540d\\u79f0","name":"company_name","value":"ThinkCMF","type":"text","tip":"","rule":[]}}}', NULL);

-- --------------------------------------------------------

--
-- 表的结构 `cmf_third_party_user`
--

CREATE TABLE `cmf_third_party_user` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '本站用户id',
  `last_login_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '最后登录时间',
  `expire_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'access_token过期时间',
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '绑定时间',
  `login_times` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '登录次数',
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '状态;1:正常;0:禁用',
  `nickname` varchar(50) NOT NULL DEFAULT '' COMMENT '用户昵称',
  `third_party` varchar(20) NOT NULL DEFAULT '' COMMENT '第三方惟一码',
  `app_id` varchar(64) NOT NULL DEFAULT '' COMMENT '第三方应用 id',
  `last_login_ip` varchar(15) NOT NULL DEFAULT '' COMMENT '最后登录ip',
  `access_token` varchar(512) NOT NULL DEFAULT '' COMMENT '第三方授权码',
  `openid` varchar(40) NOT NULL DEFAULT '' COMMENT '第三方用户id',
  `union_id` varchar(64) NOT NULL DEFAULT '' COMMENT '第三方用户多个产品中的惟一 id,(如:微信平台)',
  `more` text COMMENT '扩展信息'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='第三方用户表';

-- --------------------------------------------------------

--
-- 表的结构 `cmf_user`
--

CREATE TABLE `cmf_user` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_type` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '用户类型;1:admin;2:会员',
  `sex` tinyint(2) NOT NULL DEFAULT '0' COMMENT '性别;0:保密,1:男,2:女',
  `birthday` int(11) NOT NULL DEFAULT '0' COMMENT '生日',
  `last_login_time` int(11) NOT NULL DEFAULT '0' COMMENT '最后登录时间',
  `score` int(11) NOT NULL DEFAULT '0' COMMENT '用户积分',
  `coin` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '金币',
  `balance` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '余额',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '注册时间',
  `user_status` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT '用户状态;0:禁用,1:正常,2:未验证',
  `user_login` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '用户名',
  `user_pass` varchar(64) NOT NULL DEFAULT '' COMMENT '登录密码;cmf_password加密',
  `user_nickname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '用户昵称',
  `user_email` varchar(100) NOT NULL DEFAULT '' COMMENT '用户登录邮箱',
  `user_url` varchar(100) NOT NULL DEFAULT '' COMMENT '用户个人网址',
  `avatar` varchar(255) NOT NULL DEFAULT '' COMMENT '用户头像',
  `signature` varchar(255) NOT NULL DEFAULT '' COMMENT '个性签名',
  `last_login_ip` varchar(15) NOT NULL DEFAULT '' COMMENT '最后登录ip',
  `user_activation_key` varchar(60) NOT NULL DEFAULT '' COMMENT '激活码',
  `mobile` varchar(20) NOT NULL DEFAULT '' COMMENT '中国手机不带国家代码，国际手机号格式为：国家代码-手机号',
  `more` text COMMENT '扩展属性'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户表';

--
-- 转存表中的数据 `cmf_user`
--

INSERT INTO `cmf_user` (`id`, `user_type`, `sex`, `birthday`, `last_login_time`, `score`, `coin`, `balance`, `create_time`, `user_status`, `user_login`, `user_pass`, `user_nickname`, `user_email`, `user_url`, `avatar`, `signature`, `last_login_ip`, `user_activation_key`, `mobile`, `more`) VALUES
(1, 1, 0, 0, 1556618268, 0, 0, '0.00', 1556334390, 1, 'admin', '###8af12cfcb8f7f5b03ebee9c9e73bd06b', 'admin', '1309572580@qq.com', '', '', '', '127.0.0.1', '', '', NULL);

-- --------------------------------------------------------

--
-- 表的结构 `cmf_user_action`
--

CREATE TABLE `cmf_user_action` (
  `id` int(11) NOT NULL,
  `score` int(11) NOT NULL DEFAULT '0' COMMENT '更改积分，可以为负',
  `coin` int(11) NOT NULL DEFAULT '0' COMMENT '更改金币，可以为负',
  `reward_number` int(11) NOT NULL DEFAULT '0' COMMENT '奖励次数',
  `cycle_type` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '周期类型;0:不限;1:按天;2:按小时;3:永久',
  `cycle_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '周期时间值',
  `name` varchar(50) NOT NULL DEFAULT '' COMMENT '用户操作名称',
  `action` varchar(50) NOT NULL DEFAULT '' COMMENT '用户操作名称',
  `app` varchar(50) NOT NULL DEFAULT '' COMMENT '操作所在应用名或插件名等',
  `url` text COMMENT '执行操作的url'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户操作表';

--
-- 转存表中的数据 `cmf_user_action`
--

INSERT INTO `cmf_user_action` (`id`, `score`, `coin`, `reward_number`, `cycle_type`, `cycle_time`, `name`, `action`, `app`, `url`) VALUES
(1, 1, 1, 1, 2, 1, '用户登录', 'login', 'user', '');

-- --------------------------------------------------------

--
-- 表的结构 `cmf_user_action_log`
--

CREATE TABLE `cmf_user_action_log` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户id',
  `count` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '访问次数',
  `last_visit_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '最后访问时间',
  `object` varchar(100) NOT NULL DEFAULT '' COMMENT '访问对象的id,格式:不带前缀的表名+id;如posts1表示xx_posts表里id为1的记录',
  `action` varchar(50) NOT NULL DEFAULT '' COMMENT '操作名称;格式:应用名+控制器+操作名,也可自己定义格式只要不发生冲突且惟一;',
  `ip` varchar(15) NOT NULL DEFAULT '' COMMENT '用户ip'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='访问记录表';

-- --------------------------------------------------------

--
-- 表的结构 `cmf_user_balance_log`
--

CREATE TABLE `cmf_user_balance_log` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '用户 id',
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '创建时间',
  `change` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '更改余额',
  `balance` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '更改后余额',
  `description` varchar(255) NOT NULL DEFAULT '' COMMENT '描述',
  `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户余额变更日志表';

-- --------------------------------------------------------

--
-- 表的结构 `cmf_user_favorite`
--

CREATE TABLE `cmf_user_favorite` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户 id',
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT '收藏内容的标题',
  `thumbnail` varchar(100) NOT NULL DEFAULT '' COMMENT '缩略图',
  `url` varchar(255) DEFAULT NULL COMMENT '收藏内容的原文地址，JSON格式',
  `description` text COMMENT '收藏内容的描述',
  `table_name` varchar(64) NOT NULL DEFAULT '' COMMENT '收藏实体以前所在表,不带前缀',
  `object_id` int(10) UNSIGNED DEFAULT '0' COMMENT '收藏内容原来的主键id',
  `create_time` int(10) UNSIGNED DEFAULT '0' COMMENT '收藏时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户收藏表';

-- --------------------------------------------------------

--
-- 表的结构 `cmf_user_like`
--

CREATE TABLE `cmf_user_like` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户 id',
  `object_id` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '内容原来的主键id',
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '创建时间',
  `table_name` varchar(64) NOT NULL DEFAULT '' COMMENT '内容以前所在表,不带前缀',
  `url` varchar(255) NOT NULL DEFAULT '' COMMENT '内容的原文地址，不带域名',
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT '内容的标题',
  `thumbnail` varchar(100) NOT NULL DEFAULT '' COMMENT '缩略图',
  `description` text COMMENT '内容的描述'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户点赞表';

-- --------------------------------------------------------

--
-- 表的结构 `cmf_user_login_attempt`
--

CREATE TABLE `cmf_user_login_attempt` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `login_attempts` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '尝试次数',
  `attempt_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '尝试登录时间',
  `locked_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '锁定时间',
  `ip` varchar(15) NOT NULL DEFAULT '' COMMENT '用户 ip',
  `account` varchar(100) NOT NULL DEFAULT '' COMMENT '用户账号,手机号,邮箱或用户名'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户登录尝试表' ROW_FORMAT=COMPACT;

-- --------------------------------------------------------

--
-- 表的结构 `cmf_user_score_log`
--

CREATE TABLE `cmf_user_score_log` (
  `id` int(11) NOT NULL,
  `user_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '用户 id',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `action` varchar(50) NOT NULL DEFAULT '' COMMENT '用户操作名称',
  `score` int(11) NOT NULL DEFAULT '0' COMMENT '更改积分，可以为负',
  `coin` int(11) NOT NULL DEFAULT '0' COMMENT '更改金币，可以为负'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户操作积分等奖励日志表';

-- --------------------------------------------------------

--
-- 表的结构 `cmf_user_token`
--

CREATE TABLE `cmf_user_token` (
  `id` bigint(20) NOT NULL,
  `user_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '用户id',
  `expire_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT ' 过期时间',
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '创建时间',
  `token` varchar(64) NOT NULL DEFAULT '' COMMENT 'token',
  `device_type` varchar(10) NOT NULL DEFAULT '' COMMENT '设备类型;mobile,android,iphone,ipad,web,pc,mac,wxapp'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户客户端登录 token 表';

--
-- 转存表中的数据 `cmf_user_token`
--

INSERT INTO `cmf_user_token` (`id`, `user_id`, `expire_time`, `create_time`, `token`, `device_type`) VALUES
(1, 1, 1571886440, 1556334440, 'becc74c7c8afcfa5b377da2d9f7010efd9e707f02a4bc28db63d9093d0c0bc3a', 'web');

-- --------------------------------------------------------

--
-- 表的结构 `cmf_verification_code`
--

CREATE TABLE `cmf_verification_code` (
  `id` bigint(20) UNSIGNED NOT NULL COMMENT '表id',
  `count` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '当天已经发送成功的次数',
  `send_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '最后发送成功时间',
  `expire_time` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '验证码过期时间',
  `code` varchar(8) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '最后发送成功的验证码',
  `account` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '手机号或者邮箱'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='手机邮箱数字验证码表';

--
-- Indexes for dumped tables
--

--
-- Indexes for table `cmf_about_us`
--
ALTER TABLE `cmf_about_us`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cmf_admin_menu`
--
ALTER TABLE `cmf_admin_menu`
  ADD PRIMARY KEY (`id`),
  ADD KEY `status` (`status`),
  ADD KEY `parent_id` (`parent_id`),
  ADD KEY `controller` (`controller`);

--
-- Indexes for table `cmf_asset`
--
ALTER TABLE `cmf_asset`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cmf_auth_access`
--
ALTER TABLE `cmf_auth_access`
  ADD PRIMARY KEY (`id`),
  ADD KEY `role_id` (`role_id`),
  ADD KEY `rule_name` (`rule_name`) USING BTREE;

--
-- Indexes for table `cmf_auth_rule`
--
ALTER TABLE `cmf_auth_rule`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`) USING BTREE,
  ADD KEY `module` (`app`,`status`,`type`);

--
-- Indexes for table `cmf_city_category`
--
ALTER TABLE `cmf_city_category`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cmf_comment`
--
ALTER TABLE `cmf_comment`
  ADD PRIMARY KEY (`id`),
  ADD KEY `table_id_status` (`table_name`,`object_id`,`status`),
  ADD KEY `object_id` (`object_id`) USING BTREE,
  ADD KEY `status` (`status`) USING BTREE,
  ADD KEY `parent_id` (`parent_id`) USING BTREE,
  ADD KEY `create_time` (`create_time`) USING BTREE;

--
-- Indexes for table `cmf_cooperation`
--
ALTER TABLE `cmf_cooperation`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cmf_focus`
--
ALTER TABLE `cmf_focus`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cmf_hook`
--
ALTER TABLE `cmf_hook`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cmf_hook_plugin`
--
ALTER TABLE `cmf_hook_plugin`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cmf_link`
--
ALTER TABLE `cmf_link`
  ADD PRIMARY KEY (`id`),
  ADD KEY `status` (`status`);

--
-- Indexes for table `cmf_mobile_code`
--
ALTER TABLE `cmf_mobile_code`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cmf_nav`
--
ALTER TABLE `cmf_nav`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cmf_nav_menu`
--
ALTER TABLE `cmf_nav_menu`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cmf_option`
--
ALTER TABLE `cmf_option`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `option_name` (`option_name`);

--
-- Indexes for table `cmf_plugin`
--
ALTER TABLE `cmf_plugin`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cmf_portal_category`
--
ALTER TABLE `cmf_portal_category`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cmf_portal_category_post`
--
ALTER TABLE `cmf_portal_category_post`
  ADD PRIMARY KEY (`id`),
  ADD KEY `term_taxonomy_id` (`category_id`);

--
-- Indexes for table `cmf_portal_post`
--
ALTER TABLE `cmf_portal_post`
  ADD PRIMARY KEY (`id`),
  ADD KEY `type_status_date` (`post_type`,`post_status`,`create_time`,`id`),
  ADD KEY `parent_id` (`parent_id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `create_time` (`create_time`) USING BTREE,
  ADD KEY `idx_post_title` (`post_title`);

--
-- Indexes for table `cmf_portal_tag`
--
ALTER TABLE `cmf_portal_tag`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cmf_portal_tag_post`
--
ALTER TABLE `cmf_portal_tag_post`
  ADD PRIMARY KEY (`id`),
  ADD KEY `post_id` (`post_id`);

--
-- Indexes for table `cmf_recycle_bin`
--
ALTER TABLE `cmf_recycle_bin`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cmf_role`
--
ALTER TABLE `cmf_role`
  ADD PRIMARY KEY (`id`),
  ADD KEY `parent_id` (`parent_id`),
  ADD KEY `status` (`status`);

--
-- Indexes for table `cmf_role_user`
--
ALTER TABLE `cmf_role_user`
  ADD PRIMARY KEY (`id`),
  ADD KEY `role_id` (`role_id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `cmf_route`
--
ALTER TABLE `cmf_route`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cmf_slide`
--
ALTER TABLE `cmf_slide`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cmf_slide_item`
--
ALTER TABLE `cmf_slide_item`
  ADD PRIMARY KEY (`id`),
  ADD KEY `slide_id` (`slide_id`);

--
-- Indexes for table `cmf_theme`
--
ALTER TABLE `cmf_theme`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cmf_theme_file`
--
ALTER TABLE `cmf_theme_file`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cmf_third_party_user`
--
ALTER TABLE `cmf_third_party_user`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cmf_user`
--
ALTER TABLE `cmf_user`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_login` (`user_login`),
  ADD KEY `user_nickname` (`user_nickname`);

--
-- Indexes for table `cmf_user_action`
--
ALTER TABLE `cmf_user_action`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cmf_user_action_log`
--
ALTER TABLE `cmf_user_action_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_object_action` (`user_id`,`object`,`action`),
  ADD KEY `user_object_action_ip` (`user_id`,`object`,`action`,`ip`);

--
-- Indexes for table `cmf_user_balance_log`
--
ALTER TABLE `cmf_user_balance_log`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cmf_user_favorite`
--
ALTER TABLE `cmf_user_favorite`
  ADD PRIMARY KEY (`id`),
  ADD KEY `uid` (`user_id`);

--
-- Indexes for table `cmf_user_like`
--
ALTER TABLE `cmf_user_like`
  ADD PRIMARY KEY (`id`),
  ADD KEY `uid` (`user_id`);

--
-- Indexes for table `cmf_user_login_attempt`
--
ALTER TABLE `cmf_user_login_attempt`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cmf_user_score_log`
--
ALTER TABLE `cmf_user_score_log`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cmf_user_token`
--
ALTER TABLE `cmf_user_token`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cmf_verification_code`
--
ALTER TABLE `cmf_verification_code`
  ADD PRIMARY KEY (`id`);

--
-- 在导出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `cmf_about_us`
--
ALTER TABLE `cmf_about_us`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键id', AUTO_INCREMENT=5;
--
-- 使用表AUTO_INCREMENT `cmf_admin_menu`
--
ALTER TABLE `cmf_admin_menu`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=196;
--
-- 使用表AUTO_INCREMENT `cmf_asset`
--
ALTER TABLE `cmf_asset`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=64;
--
-- 使用表AUTO_INCREMENT `cmf_auth_access`
--
ALTER TABLE `cmf_auth_access`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用表AUTO_INCREMENT `cmf_auth_rule`
--
ALTER TABLE `cmf_auth_rule`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '规则id,自增主键', AUTO_INCREMENT=196;
--
-- 使用表AUTO_INCREMENT `cmf_city_category`
--
ALTER TABLE `cmf_city_category`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键id', AUTO_INCREMENT=24;
--
-- 使用表AUTO_INCREMENT `cmf_comment`
--
ALTER TABLE `cmf_comment`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用表AUTO_INCREMENT `cmf_cooperation`
--
ALTER TABLE `cmf_cooperation`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键id', AUTO_INCREMENT=6;
--
-- 使用表AUTO_INCREMENT `cmf_focus`
--
ALTER TABLE `cmf_focus`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键id', AUTO_INCREMENT=7;
--
-- 使用表AUTO_INCREMENT `cmf_hook`
--
ALTER TABLE `cmf_hook`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=73;
--
-- 使用表AUTO_INCREMENT `cmf_hook_plugin`
--
ALTER TABLE `cmf_hook_plugin`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- 使用表AUTO_INCREMENT `cmf_link`
--
ALTER TABLE `cmf_link`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- 使用表AUTO_INCREMENT `cmf_mobile_code`
--
ALTER TABLE `cmf_mobile_code`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
--
-- 使用表AUTO_INCREMENT `cmf_nav`
--
ALTER TABLE `cmf_nav`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- 使用表AUTO_INCREMENT `cmf_nav_menu`
--
ALTER TABLE `cmf_nav_menu`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- 使用表AUTO_INCREMENT `cmf_option`
--
ALTER TABLE `cmf_option`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- 使用表AUTO_INCREMENT `cmf_plugin`
--
ALTER TABLE `cmf_plugin`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id', AUTO_INCREMENT=3;
--
-- 使用表AUTO_INCREMENT `cmf_portal_category`
--
ALTER TABLE `cmf_portal_category`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '分类id', AUTO_INCREMENT=40;
--
-- 使用表AUTO_INCREMENT `cmf_portal_category_post`
--
ALTER TABLE `cmf_portal_category_post`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=61;
--
-- 使用表AUTO_INCREMENT `cmf_portal_post`
--
ALTER TABLE `cmf_portal_post`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42;
--
-- 使用表AUTO_INCREMENT `cmf_portal_tag`
--
ALTER TABLE `cmf_portal_tag`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '分类id';
--
-- 使用表AUTO_INCREMENT `cmf_portal_tag_post`
--
ALTER TABLE `cmf_portal_tag_post`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- 使用表AUTO_INCREMENT `cmf_recycle_bin`
--
ALTER TABLE `cmf_recycle_bin`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- 使用表AUTO_INCREMENT `cmf_role`
--
ALTER TABLE `cmf_role`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- 使用表AUTO_INCREMENT `cmf_role_user`
--
ALTER TABLE `cmf_role_user`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用表AUTO_INCREMENT `cmf_route`
--
ALTER TABLE `cmf_route`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '路由id';
--
-- 使用表AUTO_INCREMENT `cmf_slide`
--
ALTER TABLE `cmf_slide`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- 使用表AUTO_INCREMENT `cmf_slide_item`
--
ALTER TABLE `cmf_slide_item`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用表AUTO_INCREMENT `cmf_theme`
--
ALTER TABLE `cmf_theme`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- 使用表AUTO_INCREMENT `cmf_theme_file`
--
ALTER TABLE `cmf_theme_file`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- 使用表AUTO_INCREMENT `cmf_third_party_user`
--
ALTER TABLE `cmf_third_party_user`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用表AUTO_INCREMENT `cmf_user`
--
ALTER TABLE `cmf_user`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- 使用表AUTO_INCREMENT `cmf_user_action`
--
ALTER TABLE `cmf_user_action`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- 使用表AUTO_INCREMENT `cmf_user_action_log`
--
ALTER TABLE `cmf_user_action_log`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用表AUTO_INCREMENT `cmf_user_balance_log`
--
ALTER TABLE `cmf_user_balance_log`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用表AUTO_INCREMENT `cmf_user_favorite`
--
ALTER TABLE `cmf_user_favorite`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用表AUTO_INCREMENT `cmf_user_like`
--
ALTER TABLE `cmf_user_like`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用表AUTO_INCREMENT `cmf_user_login_attempt`
--
ALTER TABLE `cmf_user_login_attempt`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- 使用表AUTO_INCREMENT `cmf_user_score_log`
--
ALTER TABLE `cmf_user_score_log`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- 使用表AUTO_INCREMENT `cmf_user_token`
--
ALTER TABLE `cmf_user_token`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- 使用表AUTO_INCREMENT `cmf_verification_code`
--
ALTER TABLE `cmf_verification_code`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '表id';
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;