Commit
This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.
- Loading branch information
1 parent
3358c82
commit 1b449ff
Showing
10 changed files
with
136 additions
and
94 deletions.
There are no files selected for viewing
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Original file line number | Diff line number | Diff line change |
---|---|---|
@@ -0,0 +1,10 @@ | ||
<?php | ||
// 友情链接 | ||
class FriendLinks { | ||
static function get() { | ||
$db = new db; | ||
$rs = $db->select('name, url, uid', 'friend_links', 'ORDER BY id ASC'); | ||
if (!$rs) return []; | ||
return $rs->fetchAll(db::num); | ||
} | ||
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Original file line number | Diff line number | Diff line change |
---|---|---|
@@ -1,12 +1 @@ | ||
{$FRIEND_LINKS=[ | ||
['二超博客', 'http://2cbk.com/'], | ||
['梦幻辰风', 'http://www.mhcf.net/'], | ||
['姬长信', 'http://blog.isoyu.com/'], | ||
['尘域', 'https://morz.org/'], | ||
['乐虎IDC', 'http://lehuidc.com/'], | ||
['聚合体资讯', 'http://www.aggregations.cn/'], | ||
['18IDC', 'https://q18idc.com/'], | ||
['美丽应用', 'http://mlapp.cn/'], | ||
['雨落泪尽', 'https://1000yun.cn/'], | ||
['中国卫国网', 'http://chineserise.org/'] | ||
]} | ||
{$FRIEND_LINKS = FriendLinks::get()} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Original file line number | Diff line number | Diff line change |
---|---|---|
@@ -0,0 +1,6 @@ | ||
-- 数据库升级语句 | ||
-- 请根据实际情况使用 | ||
|
||
-- 2018年3月11日 21:39:26 | ||
-- token添加了data字段 | ||
ALTER TABLE `hu60_token` ADD `data` BLOB NOT NULL DEFAULT '' AFTER `uid`; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Original file line number | Diff line number | Diff line change |
---|---|---|
@@ -0,0 +1,6 @@ | ||
-- 数据库升级语句 | ||
-- 请根据实际情况使用 | ||
|
||
-- 2018年12月18日 11:35 | ||
-- topic添加了essence字段 | ||
ALTER TABLE `hu60_bbs_topic_meta` ADD `essence` TINYINT(1) NOT NULL DEFAULT '0' AFTER `level`; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Original file line number | Diff line number | Diff line change |
---|---|---|
@@ -1,8 +1,11 @@ | ||
-- 用户关系表 | ||
-- 用于存储两位用户之间的关系 | ||
-- 数据库升级语句 | ||
-- 请根据实际情况使用 | ||
|
||
-- 2018-12-21 | ||
-- 新增用户关系表,用于存储两位用户之间的关系 | ||
CREATE TABLE `hu60_user_relationship` ( | ||
`relationship_id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT, | ||
`origin_uid` int(11) NOT NULL, | ||
`target_uid` int(11) NOT NULL, | ||
`type` tinyint NOT NULL COMMENT '关系类型' | ||
) ENGINE=MyISAM DEFAULT CHARSET=utf8; | ||
) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Original file line number | Diff line number | Diff line change |
---|---|---|
@@ -0,0 +1,17 @@ | ||
-- 数据库升级语句 | ||
-- 请根据实际情况使用 | ||
|
||
-- 2018年12月27日 20:32 | ||
-- 新增了 hu60_topic_favorites 表 | ||
CREATE TABLE `hu60_topic_favorites` ( | ||
`id` int(11) NOT NULL, | ||
`uid` int(11) NOT NULL, | ||
`topic_id` int(11) NOT NULL | ||
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4; | ||
|
||
ALTER TABLE `hu60_topic_favorites` | ||
ADD PRIMARY KEY (`id`), | ||
ADD UNIQUE KEY `unique_uid_and_topicId` (`uid`,`topic_id`); | ||
|
||
ALTER TABLE `hu60_topic_favorites` | ||
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Original file line number | Diff line number | Diff line change |
---|---|---|
@@ -1,38 +1,14 @@ | ||
-- phpMyAdmin SQL Dump | ||
-- version 4.6.6deb5 | ||
-- https://www.phpmyadmin.net/ | ||
-- | ||
-- Host: localhost:3306 | ||
-- Generation Time: 2019-07-03 14:10:49 | ||
-- 服务器版本: 10.3.13-MariaDB-1-log | ||
-- PHP Version: 7.3.3-1 | ||
-- 数据库升级语句 | ||
-- 请根据实际情况使用 | ||
|
||
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; | ||
SET time_zone = "+00:00"; | ||
|
||
-- | ||
-- Database: `hu60` | ||
-- | ||
|
||
-- -------------------------------------------------------- | ||
|
||
-- | ||
-- 表的结构 `hu60_userdata` | ||
-- | ||
-- 2019-07-03 | ||
-- 新增一个用于存储用户自定义插件设置的表 | ||
|
||
CREATE TABLE `hu60_userdata` ( | ||
`uid` int(11) NOT NULL, | ||
`key` varchar(255) NOT NULL, | ||
`value` mediumblob NOT NULL | ||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT; | ||
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT; | ||
|
||
-- | ||
-- Indexes for dumped tables | ||
-- | ||
|
||
-- | ||
-- Indexes for table `hu60_userdata` | ||
-- | ||
ALTER TABLE `hu60_userdata` | ||
ADD PRIMARY KEY (`uid`,`key`); | ||
|
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Original file line number | Diff line number | Diff line change |
---|---|---|
@@ -0,0 +1,22 @@ | ||
-- 数据库升级语句 | ||
-- 请根据实际情况使用 | ||
|
||
-- 2019-10-14 | ||
-- 新增一个用于友链的表 | ||
|
||
CREATE TABLE `hu60_friend_links` ( | ||
`id` int(11) NOT NULL, | ||
`name` varchar(255) NOT NULL, | ||
`url` varchar(255) NOT NULL, | ||
`uid` int(11) NOT NULL DEFAULT '0' | ||
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4; | ||
|
||
ALTER TABLE `hu60_friend_links` | ||
ADD PRIMARY KEY (`id`); | ||
|
||
ALTER TABLE `hu60_friend_links` | ||
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; | ||
|
||
-- 修改表的存储引擎为MyISAM | ||
ALTER TABLE `hu60_topic_favorites` ENGINE = MyISAM; | ||
ALTER TABLE `hu60_userdata` ENGINE = MyISAM; |
Oops, something went wrong.