木漏茶室源码下载中心
整站 PHP 源码:可浏览文件、复制路径、下载单文件或打包 ZIP。
发布版本 v6.25.232
升级后自动生成独立源码包,下载中心只发送这份冻结包
已排除 config.php / 用户数据 / 上传文件 / 升级备份
COMMUNITY DEPLOYMENTS
已经跑起来的木漏茶室
从源码下载中心下载、完成安装并回传验证的站外站点。每个站点只计 1 次部署下载量;已记录站点会实时读取名称、版本、Logo 与在线状态,本机、内网和证书异常站点无法完成回传。
实时检测
2
个站点已部署
木
木漏茶室
mlcs.xnn.lol · v6.25.232
访问 ↗
2026.11.21
在线
木
木漏茶室
mlcs.nbnb.mom · v6.25.232
访问 ↗
2026.11.20
在线
已展示全部 2 个站点。
inc/schema.php
30.3 KB · 发布包 v6.25.232
<?php
/**
* 数据库结构定义(MySQL / SQLite 通用)
* install.php 与后台修复工具共用
*/
function schema_statements($driver = 'mysql')
{
$ai = ($driver === 'sqlite')
? 'INTEGER PRIMARY KEY AUTOINCREMENT'
: 'INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY';
$tail = ($driver === 'sqlite') ? '' : ' ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci';
// MySQL / MariaDB 不允许 TEXT 列带默认值,SQLite 允许;按驱动生成。
$textDefault = ($driver === 'sqlite') ? "TEXT DEFAULT ''" : 'TEXT';
$tables = [];
$tables['settings'] = "CREATE TABLE IF NOT EXISTS {p}settings (
skey VARCHAR(64) NOT NULL PRIMARY KEY,
svalue TEXT
){$tail}";
$tables['users'] = "CREATE TABLE IF NOT EXISTS {p}users (
id {$ai},
username VARCHAR(32) NOT NULL UNIQUE,
password VARCHAR(255) NOT NULL,
nickname VARCHAR(64),
avatar VARCHAR(255) DEFAULT '',
profile_bg VARCHAR(255) DEFAULT '',
profile_bg_video VARCHAR(255) DEFAULT '',
profile_bg_blur INT DEFAULT 0,
profile_frame VARCHAR(24) DEFAULT '',
profile_visitor_count INT DEFAULT 0,
friend_reject_requests INT DEFAULT 0,
friend_reject_broadcast INT DEFAULT 0,
friend_reject_stranger_messages INT DEFAULT 0,
gender VARCHAR(16) DEFAULT 'secret',
email VARCHAR(128) DEFAULT '',
role VARCHAR(16) DEFAULT 'user',
status INT DEFAULT 1,
verified INT DEFAULT 0,
verify_type VARCHAR(32) DEFAULT '',
verify_info VARCHAR(255) DEFAULT '',
verify_status INT DEFAULT 0,
verify_reason VARCHAR(255) DEFAULT '',
verify_style VARCHAR(20) DEFAULT '',
verify_title VARCHAR(60) DEFAULT '',
last_login VARCHAR(20) DEFAULT '',
auth_token VARCHAR(64) DEFAULT '',
auth_token_device VARCHAR(64) DEFAULT '',
qq_openid VARCHAR(64) DEFAULT '',
qq_nickname VARCHAR(100) DEFAULT '',
last_ip VARCHAR(64) DEFAULT '',
last_ip_at VARCHAR(20) DEFAULT '',
province VARCHAR(32) DEFAULT '',
city VARCHAR(32) DEFAULT '',
district VARCHAR(64) DEFAULT '',
town VARCHAR(64) DEFAULT '',
village VARCHAR(64) DEFAULT '',
show_location INT DEFAULT 1,
show_ip INT DEFAULT 1,
comment_bubble VARCHAR(20) DEFAULT 'tea',
account_setup INT DEFAULT 0,
verify_paid INT DEFAULT 0,
verify_pending_type VARCHAR(32) DEFAULT '',
verify_pending_style VARCHAR(20) DEFAULT '',
verify_pending_title VARCHAR(60) DEFAULT '',
verify_pending_info VARCHAR(255) DEFAULT '',
nickname_changes INT DEFAULT 0,
avatar_changes INT DEFAULT 0,
can_rename_username INT DEFAULT 0,
is_official INT DEFAULT 0,
is_installer_admin INT DEFAULT 0,
avatar_free_limit INT DEFAULT 3,
avatar_unlimited INT DEFAULT 0,
avatar_change_cost INT DEFAULT 20,
username_free_limit INT DEFAULT 0,
username_unlimited INT DEFAULT 0,
username_change_cost INT DEFAULT 50,
account_protected INT DEFAULT 0,
feature_perms {$textDefault},
profile_week VARCHAR(10) DEFAULT '',
points INT DEFAULT 0,
exp INT DEFAULT 0,
streak INT DEFAULT 0,
last_checkin VARCHAR(20) DEFAULT '',
bio VARCHAR(255) DEFAULT '',
ban_until VARCHAR(20) DEFAULT '',
mute_until VARCHAR(20) DEFAULT '',
site_mute_until VARCHAR(20) DEFAULT '',
site_mute_reason VARCHAR(255) DEFAULT '',
plugin_access VARCHAR(20) DEFAULT 'all',
email_verified INT DEFAULT 0,
email_login_verify INT DEFAULT 0,
totp_secret VARCHAR(255) DEFAULT '',
totp_enabled INT DEFAULT 0,
totp_backup_codes TEXT,
login_fail_count INT DEFAULT 0,
login_locked_until VARCHAR(20) DEFAULT '',
initial_profile TEXT,
created_at VARCHAR(20) DEFAULT ''
){$tail}";
$tables['categories'] = "CREATE TABLE IF NOT EXISTS {p}categories (
id {$ai},
name VARCHAR(64) NOT NULL,
sort INT DEFAULT 0
){$tail}";
$tables['posts'] = "CREATE TABLE IF NOT EXISTS {p}posts (
id {$ai},
user_id INT DEFAULT 0,
cat_id INT DEFAULT 0,
title VARCHAR(200) NOT NULL,
content MEDIUMTEXT,
is_html INT DEFAULT 1,
password VARCHAR(100) DEFAULT '',
netdisk_link VARCHAR(255) DEFAULT '',
netdisk_name VARCHAR(120) DEFAULT '',
netdisk_size VARCHAR(40) DEFAULT '',
netdisk_code VARCHAR(40) DEFAULT '',
attach_visibility VARCHAR(16) DEFAULT 'public',
attach_points INT DEFAULT 0,
netdisk_visibility VARCHAR(16) DEFAULT 'public',
netdisk_points INT DEFAULT 0,
allow_save_media INT DEFAULT 1,
author_only INT DEFAULT 0,
ip VARCHAR(64) DEFAULT '',
views INT DEFAULT 0,
is_top INT DEFAULT 0,
top_at VARCHAR(20) DEFAULT '',
is_featured INT DEFAULT 0,
is_locked INT DEFAULT 0,
status INT DEFAULT 1,
created_at VARCHAR(20) DEFAULT '',
updated_at VARCHAR(20) DEFAULT '',
tags VARCHAR(255) DEFAULT '',
publish_at VARCHAR(20) DEFAULT ''
){$tail}";
$tables['comments'] = "CREATE TABLE IF NOT EXISTS {p}comments (
id {$ai},
post_id INT DEFAULT 0,
user_id INT DEFAULT 0,
parent_id INT DEFAULT 0,
content TEXT,
status INT DEFAULT 1,
created_at VARCHAR(20) DEFAULT ''
){$tail}";
$tables['likes'] = "CREATE TABLE IF NOT EXISTS {p}likes (
id {$ai},
post_id INT DEFAULT 0,
user_id INT DEFAULT 0,
created_at VARCHAR(20) DEFAULT '',
UNIQUE (post_id, user_id)
){$tail}";
$tables['favorites'] = "CREATE TABLE IF NOT EXISTS {p}favorites (
id {$ai},
post_id INT DEFAULT 0,
user_id INT DEFAULT 0,
created_at VARCHAR(20) DEFAULT '',
UNIQUE (post_id, user_id)
){$tail}";
$tables['reports'] = "CREATE TABLE IF NOT EXISTS {p}reports (
id {$ai},
target_type VARCHAR(16) DEFAULT 'post',
target_id INT DEFAULT 0,
user_id INT DEFAULT 0,
reason VARCHAR(255) DEFAULT '',
status INT DEFAULT 0,
created_at VARCHAR(20) DEFAULT ''
){$tail}";
$tables['avatar_reviews'] = "CREATE TABLE IF NOT EXISTS {p}avatar_reviews (
id {$ai},
user_id INT DEFAULT 0,
old_avatar VARCHAR(255) DEFAULT '',
new_avatar VARCHAR(255) DEFAULT '',
status INT DEFAULT 0,
reason VARCHAR(255) DEFAULT '',
reviewer_id INT DEFAULT 0,
reviewed_at VARCHAR(20) DEFAULT '',
auto_score INT DEFAULT 0,
cost INT DEFAULT 0,
created_at VARCHAR(20) DEFAULT ''
){$tail}";
$tables['card_bg_reviews'] = "CREATE TABLE IF NOT EXISTS {p}card_bg_reviews (
id {$ai},
user_id INT DEFAULT 0,
old_bg VARCHAR(255) DEFAULT '',
old_bg_video VARCHAR(255) DEFAULT '',
new_bg VARCHAR(255) DEFAULT '',
new_bg_video VARCHAR(255) DEFAULT '',
new_blur INT DEFAULT 0,
status INT DEFAULT 0,
reason VARCHAR(255) DEFAULT '',
reviewer_id INT DEFAULT 0,
reviewed_at VARCHAR(20) DEFAULT '',
created_at VARCHAR(20) DEFAULT ''
){$tail}";
$tables['announcements'] = "CREATE TABLE IF NOT EXISTS {p}announcements (
id {$ai},
title VARCHAR(160) DEFAULT '',
content TEXT,
kind VARCHAR(16) DEFAULT 'modal',
status INT DEFAULT 1,
start_at VARCHAR(20) DEFAULT '',
end_at VARCHAR(20) DEFAULT '',
speed INT DEFAULT 24,
show_every_visit INT DEFAULT 0,
allow_snooze INT DEFAULT 0,
show_every_refresh INT DEFAULT 0,
show_limit INT DEFAULT 0,
banner_loop INT DEFAULT 1,
banner_closable INT DEFAULT 1,
banner_width INT DEFAULT 100,
banner_bubble VARCHAR(20) DEFAULT 'tea',
banner_font VARCHAR(24) DEFAULT 'default',
banner_font_file VARCHAR(255) DEFAULT '',
banner_bg1 VARCHAR(16) DEFAULT '',
banner_bg2 VARCHAR(16) DEFAULT '',
banner_text VARCHAR(16) DEFAULT '',
author_id INT DEFAULT 0,
created_at VARCHAR(20) DEFAULT '',
updated_at VARCHAR(20) DEFAULT ''
){$tail}";
$tables['announcement_views'] = "CREATE TABLE IF NOT EXISTS {p}announcement_views (
id {$ai},
announcement_id INT DEFAULT 0,
user_id INT DEFAULT 0,
views INT DEFAULT 0,
last_at VARCHAR(20) DEFAULT '',
UNIQUE(announcement_id, user_id)
){$tail}";
$tables['notifications'] = "CREATE TABLE IF NOT EXISTS {p}notifications (
id {$ai},
user_id INT DEFAULT 0,
from_id INT DEFAULT 0,
type VARCHAR(32) DEFAULT 'system',
target_id INT DEFAULT 0,
content VARCHAR(255) DEFAULT '',
link VARCHAR(255) DEFAULT '',
payload TEXT,
is_read INT DEFAULT 0,
created_at VARCHAR(20) DEFAULT ''
){$tail}";
$tables['friend_requests'] = "CREATE TABLE IF NOT EXISTS {p}friend_requests (
id {$ai},
from_id INT DEFAULT 0,
to_id INT DEFAULT 0,
status VARCHAR(16) DEFAULT 'pending',
created_at VARCHAR(20) DEFAULT '',
UNIQUE(from_id, to_id)
){$tail}";
$tables['friends'] = "CREATE TABLE IF NOT EXISTS {p}friends (
id {$ai},
user_id INT DEFAULT 0,
friend_id INT DEFAULT 0,
remark VARCHAR(64) DEFAULT '',
created_at VARCHAR(20) DEFAULT '',
UNIQUE(user_id, friend_id)
){$tail}";
$tables['messages'] = "CREATE TABLE IF NOT EXISTS {p}messages (
id {$ai},
from_id INT DEFAULT 0,
to_id INT DEFAULT 0,
content TEXT,
type VARCHAR(12) DEFAULT 'text',
path VARCHAR(255) DEFAULT '',
is_read INT DEFAULT 0,
created_at VARCHAR(20) DEFAULT ''
){$tail}";
$tables['attachments'] = "CREATE TABLE IF NOT EXISTS {p}attachments (
id {$ai},
post_id INT DEFAULT 0,
user_id INT DEFAULT 0,
name VARCHAR(200) DEFAULT '',
path VARCHAR(255) DEFAULT '',
size INT DEFAULT 0,
lyrics TEXT,
cover_path VARCHAR(255) DEFAULT '',
matched_title VARCHAR(200) DEFAULT '',
matched_artist VARCHAR(200) DEFAULT '',
matched_at VARCHAR(20) DEFAULT '',
created_at VARCHAR(20) DEFAULT ''
){$tail}";
$tables['netdisk'] = "CREATE TABLE IF NOT EXISTS {p}netdisk (
id {$ai},
user_id INT DEFAULT 0,
name VARCHAR(200) DEFAULT '',
path VARCHAR(255) DEFAULT '',
size INT DEFAULT 0,
share_code VARCHAR(16) DEFAULT '',
bundle_code VARCHAR(16) DEFAULT '',
share_password VARCHAR(64) DEFAULT '',
is_public INT DEFAULT 0,
downloads INT DEFAULT 0,
lyrics TEXT,
cover_path VARCHAR(255) DEFAULT '',
matched_title VARCHAR(200) DEFAULT '',
matched_artist VARCHAR(200) DEFAULT '',
matched_at VARCHAR(20) DEFAULT '',
created_at VARCHAR(20) DEFAULT ''
){$tail}";
$tables['netdisk_folders'] = "CREATE TABLE IF NOT EXISTS {p}netdisk_folders (
id {$ai},
user_id INT DEFAULT 0,
name VARCHAR(120) DEFAULT '',
share_code VARCHAR(16) DEFAULT '',
share_password VARCHAR(64) DEFAULT '',
shared_at VARCHAR(20) DEFAULT '',
created_at VARCHAR(20) DEFAULT ''
){$tail}";
$tables['security_events'] = "CREATE TABLE IF NOT EXISTS {p}security_events (
id {$ai},
kind VARCHAR(32) DEFAULT '',
ip VARCHAR(64) DEFAULT '',
identifier VARCHAR(128) DEFAULT '',
fingerprint VARCHAR(64) DEFAULT '',
user_id INT DEFAULT 0,
created_at VARCHAR(20) DEFAULT ''
){$tail}";
$tables['guard_blocks'] = "CREATE TABLE IF NOT EXISTS {p}guard_blocks (
id {$ai},
ip VARCHAR(64) DEFAULT '',
reason VARCHAR(255) DEFAULT '',
until INT DEFAULT 0,
hits INT DEFAULT 0,
created_at VARCHAR(20) DEFAULT '',
updated_at VARCHAR(20) DEFAULT '',
UNIQUE(ip)
){$tail}";
$tables['guard_devices'] = "CREATE TABLE IF NOT EXISTS {p}guard_devices (
id {$ai},
fingerprint VARCHAR(64) DEFAULT '',
user_id INT DEFAULT 0,
ip VARCHAR(64) DEFAULT '',
ua VARCHAR(255) DEFAULT '',
first_at VARCHAR(20) DEFAULT '',
last_at VARCHAR(20) DEFAULT '',
visits INT DEFAULT 0,
note VARCHAR(120) DEFAULT '',
UNIQUE(fingerprint)
){$tail}";
$tables['guard_bans'] = "CREATE TABLE IF NOT EXISTS {p}guard_bans (
id {$ai},
ban_type VARCHAR(16) DEFAULT '',
ban_value VARCHAR(128) DEFAULT '',
ip_value VARCHAR(64) DEFAULT '',
reason VARCHAR(255) DEFAULT '',
created_by INT DEFAULT 0,
created_at VARCHAR(20) DEFAULT '',
hits INT DEFAULT 0,
last_hit_at VARCHAR(20) DEFAULT '',
UNIQUE(ban_type, ban_value)
){$tail}";
$tables['login_logs'] = "CREATE TABLE IF NOT EXISTS {p}login_logs (
id {$ai},
user_id INT DEFAULT 0,
username VARCHAR(64) DEFAULT '',
nickname VARCHAR(64) DEFAULT '',
ip VARCHAR(64) DEFAULT '',
ua VARCHAR(255) DEFAULT '',
result VARCHAR(16) DEFAULT '',
reason VARCHAR(255) DEFAULT '',
device_id VARCHAR(64) DEFAULT '',
device_code VARCHAR(32) DEFAULT '',
address VARCHAR(255) DEFAULT '',
created_at VARCHAR(20) DEFAULT ''
){$tail}";
$tables['audit_logs'] = "CREATE TABLE IF NOT EXISTS {p}audit_logs (
id {$ai},
actor_id INT DEFAULT 0,
action VARCHAR(64) DEFAULT '',
detail VARCHAR(255) DEFAULT '',
ip VARCHAR(64) DEFAULT '',
created_at VARCHAR(20) DEFAULT ''
){$tail}";
$tables['punishments'] = "CREATE TABLE IF NOT EXISTS {p}punishments (
id {$ai},
user_id INT DEFAULT 0,
type VARCHAR(20) DEFAULT '',
reason VARCHAR(255) DEFAULT '',
start_at VARCHAR(20) DEFAULT '',
end_at VARCHAR(20) DEFAULT '',
status VARCHAR(20) DEFAULT 'active',
created_by INT DEFAULT 0,
released_at VARCHAR(20) DEFAULT '',
created_at VARCHAR(20) DEFAULT ''
){$tail}";
$tables['blocked_users'] = "CREATE TABLE IF NOT EXISTS {p}blocked_users (
id {$ai},
blocker_id INT DEFAULT 0,
blocked_id INT DEFAULT 0,
created_at VARCHAR(20) DEFAULT '',
UNIQUE(blocker_id, blocked_id)
){$tail}";
$tables['profile_visits'] = "CREATE TABLE IF NOT EXISTS {p}profile_visits (
id {$ai},
profile_user_id INT DEFAULT 0,
visitor_id INT DEFAULT 0,
visits INT DEFAULT 1,
first_at VARCHAR(20) DEFAULT '',
last_at VARCHAR(20) DEFAULT '',
UNIQUE(profile_user_id, visitor_id)
){$tail}";
$tables['follows'] = "CREATE TABLE IF NOT EXISTS {p}follows (
id {$ai},
follower_id INT DEFAULT 0,
target_type VARCHAR(16) DEFAULT 'user',
target_id INT DEFAULT 0,
created_at VARCHAR(20) DEFAULT '',
UNIQUE(follower_id, target_type, target_id)
){$tail}";
$tables['drafts'] = "CREATE TABLE IF NOT EXISTS {p}drafts (
id {$ai},
user_id INT DEFAULT 0,
kind VARCHAR(16) DEFAULT 'post',
title VARCHAR(120) DEFAULT '',
content TEXT,
cat_id INT DEFAULT 0,
media_type VARCHAR(12) DEFAULT '',
media_path VARCHAR(255) DEFAULT '',
media_name VARCHAR(120) DEFAULT '',
extra TEXT,
updated_at VARCHAR(20) DEFAULT ''
){$tail}";
$tables['analytics_daily'] = "CREATE TABLE IF NOT EXISTS {p}analytics_daily (
day VARCHAR(10) NOT NULL PRIMARY KEY,
pv INT DEFAULT 0,
uv INT DEFAULT 0,
posts INT DEFAULT 0,
comments INT DEFAULT 0
){$tail}";
$tables['gallery'] = "CREATE TABLE IF NOT EXISTS {p}gallery (
id {$ai},
user_id INT DEFAULT 0,
path VARCHAR(255) DEFAULT '',
title VARCHAR(128) DEFAULT '',
size BIGINT DEFAULT 0,
is_public INT DEFAULT 1,
created_at VARCHAR(20) DEFAULT ''
){$tail}";
$tables['chat'] = "CREATE TABLE IF NOT EXISTS {p}chat (
id {$ai},
user_id INT DEFAULT 0,
type VARCHAR(16) DEFAULT 'text',
content TEXT,
path VARCHAR(255) DEFAULT '',
is_deleted INT DEFAULT 0,
created_at VARCHAR(20) DEFAULT ''
){$tail}";
$tables['chat_mutes'] = "CREATE TABLE IF NOT EXISTS {p}chat_mutes (
id {$ai},
user_id INT DEFAULT 0,
until VARCHAR(20) DEFAULT ''
){$tail}";
$tables['links'] = "CREATE TABLE IF NOT EXISTS {p}links (
id {$ai},
name VARCHAR(64) DEFAULT '',
url VARCHAR(255) DEFAULT '',
logo VARCHAR(255) DEFAULT '',
sort INT DEFAULT 0,
status INT DEFAULT 1
){$tail}";
$tables['carousel'] = "CREATE TABLE IF NOT EXISTS {p}carousel (
id {$ai},
title VARCHAR(128) DEFAULT '',
image VARCHAR(255) DEFAULT '',
link VARCHAR(255) DEFAULT '',
sort INT DEFAULT 0,
status INT DEFAULT 1,
created_at VARCHAR(20) DEFAULT ''
){$tail}";
$tables['plugins'] = "CREATE TABLE IF NOT EXISTS {p}plugins (
id {$ai},
slug VARCHAR(64) NOT NULL UNIQUE,
name VARCHAR(128) DEFAULT '',
version VARCHAR(32) DEFAULT '1.0',
description VARCHAR(255) DEFAULT '',
status INT DEFAULT 0,
created_at VARCHAR(20) DEFAULT ''
){$tail}";
$tables['extensions'] = "CREATE TABLE IF NOT EXISTS {p}extensions (
id {$ai},
slug VARCHAR(64) NOT NULL UNIQUE,
name VARCHAR(128) DEFAULT '',
description VARCHAR(255) DEFAULT '',
icon VARCHAR(255) DEFAULT '',
url VARCHAR(255) DEFAULT '',
is_builtin INT DEFAULT 1,
owner_id INT DEFAULT 0,
status INT DEFAULT 1,
sort INT DEFAULT 0,
created_at VARCHAR(20) DEFAULT ''
){$tail}";
$tables['user_ext_prefs'] = "CREATE TABLE IF NOT EXISTS {p}user_ext_prefs (
user_id INT NOT NULL,
extension_id INT NOT NULL,
sort INT DEFAULT 0,
hidden INT DEFAULT 0,
updated_at VARCHAR(20) DEFAULT '',
PRIMARY KEY (user_id, extension_id)
){$tail}";
$tables['moments'] = "CREATE TABLE IF NOT EXISTS {p}moments (
id {$ai},
user_id INT DEFAULT 0,
content TEXT,
media_type VARCHAR(12) DEFAULT '',
media_path VARCHAR(255) DEFAULT '',
media_name VARCHAR(120) DEFAULT '',
location VARCHAR(80) DEFAULT '',
status INT DEFAULT 1,
lyrics TEXT,
cover_path VARCHAR(255) DEFAULT '',
matched_title VARCHAR(200) DEFAULT '',
matched_artist VARCHAR(200) DEFAULT '',
matched_at VARCHAR(20) DEFAULT '',
created_at VARCHAR(20) DEFAULT ''
){$tail}";
$tables['moment_likes'] = "CREATE TABLE IF NOT EXISTS {p}moment_likes (
id {$ai},
moment_id INT DEFAULT 0,
user_id INT DEFAULT 0,
created_at VARCHAR(20) DEFAULT ''
){$tail}";
$tables['moment_comments'] = "CREATE TABLE IF NOT EXISTS {p}moment_comments (
id {$ai},
moment_id INT DEFAULT 0,
user_id INT DEFAULT 0,
parent_id INT DEFAULT 0,
content TEXT,
created_at VARCHAR(20) DEFAULT ''
){$tail}";
$tables['quotes'] = "CREATE TABLE IF NOT EXISTS {p}quotes (
id {$ai},
content VARCHAR(255) NOT NULL,
source VARCHAR(32) DEFAULT 'manual',
status INT DEFAULT 1,
sort INT DEFAULT 0,
created_at VARCHAR(20) DEFAULT ''
){$tail}";
$tables['post_views'] = "CREATE TABLE IF NOT EXISTS {p}post_views (
id {$ai},
post_id INT DEFAULT 0,
user_id INT DEFAULT 0,
created_at VARCHAR(20) DEFAULT '',
view_count INT DEFAULT 1,
last_viewed_at VARCHAR(20) DEFAULT '',
UNIQUE(post_id, user_id)
){$tail}";
$tables['post_unlocks'] = "CREATE TABLE IF NOT EXISTS {p}post_unlocks (
id {$ai},
post_id INT DEFAULT 0,
user_id INT DEFAULT 0,
kind VARCHAR(16) DEFAULT 'attach',
points INT DEFAULT 0,
created_at VARCHAR(20) DEFAULT '',
UNIQUE(post_id, user_id, kind)
){$tail}";
$tables['post_read_rewards'] = "CREATE TABLE IF NOT EXISTS {p}post_read_rewards (
id {$ai},
post_id INT DEFAULT 0,
user_id INT DEFAULT 0,
day VARCHAR(10) DEFAULT '',
reward INT DEFAULT 0,
created_at VARCHAR(20) DEFAULT '',
UNIQUE(post_id, user_id, day)
){$tail}";
$tables['chat_calls'] = "CREATE TABLE IF NOT EXISTS {p}chat_calls (
id {$ai},
host_id INT DEFAULT 0,
status VARCHAR(16) DEFAULT 'active',
created_at VARCHAR(20) DEFAULT '',
ended_at VARCHAR(20) DEFAULT ''
){$tail}";
$tables['chat_call_members'] = "CREATE TABLE IF NOT EXISTS {p}chat_call_members (
id {$ai},
call_id INT DEFAULT 0,
user_id INT DEFAULT 0,
status VARCHAR(16) DEFAULT 'joined',
joined_at VARCHAR(20) DEFAULT '',
UNIQUE(call_id, user_id)
){$tail}";
$tables['chat_signals'] = "CREATE TABLE IF NOT EXISTS {p}chat_signals (
id {$ai},
call_id INT DEFAULT 0,
from_id INT DEFAULT 0,
to_id INT DEFAULT 0,
kind VARCHAR(16) DEFAULT '',
payload TEXT,
created_at VARCHAR(20) DEFAULT ''
){$tail}";
$tables['transfers'] = "CREATE TABLE IF NOT EXISTS {p}transfers (
id {$ai},
from_id INT DEFAULT 0,
to_id INT DEFAULT 0,
amount INT DEFAULT 0,
note VARCHAR(120) DEFAULT '',
created_at VARCHAR(20) DEFAULT ''
){$tail}";
$tables['ip_locations'] = "CREATE TABLE IF NOT EXISTS {p}ip_locations (
ip VARCHAR(64) NOT NULL PRIMARY KEY,
region VARCHAR(64) DEFAULT '',
city VARCHAR(64) DEFAULT '',
district VARCHAR(64) DEFAULT '',
street VARCHAR(64) DEFAULT '',
addr VARCHAR(255) DEFAULT '',
updated_at VARCHAR(20) DEFAULT ''
){$tail}";
$tables['point_logs'] = "CREATE TABLE IF NOT EXISTS {p}point_logs (
id {$ai},
user_id INT DEFAULT 0,
action VARCHAR(32) DEFAULT '',
delta INT DEFAULT 0,
note VARCHAR(255) DEFAULT '',
ref_id INT DEFAULT 0,
created_at VARCHAR(20) DEFAULT ''
){$tail}";
$tables['plugin_purchases'] = "CREATE TABLE IF NOT EXISTS {p}plugin_purchases (
id {$ai},
user_id INT DEFAULT 0,
slug VARCHAR(40) DEFAULT '',
price INT DEFAULT 0,
created_at VARCHAR(20) DEFAULT ''
){$tail}";
$tables['profile_changes'] = "CREATE TABLE IF NOT EXISTS {p}profile_changes (
id {$ai},
user_id INT DEFAULT 0,
kind VARCHAR(16) DEFAULT '',
created_at VARCHAR(20) DEFAULT ''
){$tail}";
$tables['red_packets'] = "CREATE TABLE IF NOT EXISTS {p}red_packets (
id {$ai},
chat_id INT DEFAULT 0,
sender_id INT DEFAULT 0,
total INT DEFAULT 0,
remaining INT DEFAULT 0,
count INT DEFAULT 0,
remaining_count INT DEFAULT 0,
created_at VARCHAR(20) DEFAULT ''
){$tail}";
$tables['deleted_accounts'] = "CREATE TABLE IF NOT EXISTS {p}deleted_accounts (
id {$ai},
original_uid INT DEFAULT 0,
username VARCHAR(64) DEFAULT '',
nickname VARCHAR(64) DEFAULT '',
email VARCHAR(128) DEFAULT '',
role VARCHAR(16) DEFAULT 'user',
snapshot TEXT,
summary VARCHAR(255) DEFAULT '',
avatar_archive VARCHAR(255) DEFAULT '',
deleted_by INT DEFAULT 0,
created_at VARCHAR(20) DEFAULT '',
restored_at VARCHAR(20) DEFAULT '',
restored_uid INT DEFAULT 0
){$tail}";
$tables['email_codes'] = "CREATE TABLE IF NOT EXISTS {p}email_codes (
id {$ai},
user_id INT DEFAULT 0,
email VARCHAR(128) DEFAULT '',
code VARCHAR(12) DEFAULT '',
purpose VARCHAR(32) DEFAULT 'reset',
expires_at INT DEFAULT 0,
used INT DEFAULT 0
){$tail}";
return $tables;
}
/**
* 建表
*/
function schema_install($pdo, $driver, $prefix = '')
{
foreach (schema_statements($driver) as $sql) {
$sql = str_replace('{p}', $prefix, $sql);
$pdo->exec($sql);
}
}
/**
* 初始数据
*/
function schema_seed($pdo, $prefix, $adminUser, $adminPass, $siteName, $adminNickname = '')
{
$now = date('Y-m-d H:i:s');
$settings = [
'site_name' => $siteName ?: '木漏茶室',
'site_intro' => '一室茶香,半窗霜雪。',
'site_logo' => 'assets/img/logo.svg',
'site_favicon' => '',
'site_banner' => 'assets/img/banner.jpg',
'daily_quote' => '雪落无声,茶烟袅袅,且坐片刻。',
'quote_interval' => '10',
'quote_interval_sec' => '1',
'post_review_enabled' => '0',
'post_show_location' => '1',
'post_show_ip' => '1',
'post_ip_mask' => '1',
'post_ip_head' => '4',
'post_ip_tail' => '2',
'post_ip_stars' => '4',
'header_html' => '',
'sticky_html' => '',
'home_sticky_html' => '',
'home_footer_html' => '',
'site_global_html' => '',
'footer_text' => '© 木漏茶室 · 保留所有权利',
'maintenance' => '0',
'maintenance_text' => '茶室正在进行清扫,稍后再来。',
'maintenance_video' => '',
'smtp_enabled' => '0',
'smtp_host' => '',
'smtp_port' => '465',
'smtp_user' => '',
'smtp_pass' => '',
'smtp_secure' => 'ssl',
'smtp_from' => '',
'smtp_from_name' => '木漏茶室',
'ai_api_url' => '',
'ai_api_key' => '',
'ai_model' => 'gpt-4o-mini',
'register_open' => '1',
'profile_bg_review_enabled' => '0',
'theme_mode' => 'default',
'font_family' => 'default',
'verify_notice' => '认证申请会由管理员审核,通过后在昵称旁展示徽章。',
'verify_cost' => '200',
'points_checkin' => '3',
'points_checkin_min' => '1',
'points_checkin_max' => '5',
'superadmin_lock_state' => '0',
'superadmin_lock_hash' => '',
'points_post' => '5',
'points_comment' => '2',
'points_post_limit' => '5',
'points_comment_limit' => '10',
'points_over_action' => 'none',
'read_points_enable' => '1',
'read_points' => '1',
'read_points_limit' => '10',
'read_points_cap' => '10',
'points_like' => '1',
'points_like_limit' => '10',
'points_like_cap' => '10',
'points_fav' => '1',
'points_fav_limit' => '10',
'points_fav_cap' => '10',
'name_change_limit' => '3',
'level_names' => '["初雪","霜华","白鹭","神里流","霜见"]',
'transfer_min' => '1',
];
$stmt = $pdo->prepare("INSERT INTO {$prefix}settings (skey, svalue) VALUES (?, ?)");
foreach ($settings as $k => $v) {
// 已存在则跳过
$chk = $pdo->prepare("SELECT COUNT(*) FROM {$prefix}settings WHERE skey = ?");
$chk->execute([$k]);
if (!$chk->fetchColumn()) {
$stmt->execute([$k, $v]);
}
}
// 毒鸡汤初始句子
$quoteDefaults = [
'你并不是一无所有,你还有病。',
'只要我够努力,老板就能过上他想要的生活。',
'别抱怨自己累,看看别人,别人根本不在意你。',
'机会总是留给有准备的人,而你有准备也不一定有机会。',
'有些人出现在你的生命里,就是为了告诉你,你真好骗。',
'失败并不可怕,可怕的是你还相信这句话。',
'你以为有钱人很快乐吗?他们的快乐你根本想象不到。',
'生活不止眼前的苟且,还有读不懂的诗和到不了的远方。',
];
$q = $pdo->prepare("INSERT INTO {$prefix}quotes (content, source, status, created_at) VALUES (?,?,1,?)");
foreach ($quoteDefaults as $line) {
$q->execute([$line, 'default', $now]);
}
$cats = ['茶室闲谈', '神里流剑术', '提瓦特见闻', '资源分享', '站务公告'];
$c = $pdo->prepare("SELECT COUNT(*) FROM {$prefix}categories");
$c->execute();
if (!$c->fetchColumn()) {
$ins = $pdo->prepare("INSERT INTO {$prefix}categories (name, sort) VALUES (?, ?)");
foreach ($cats as $i => $n) {
$ins->execute([$n, $i]);
}
}
$u = $pdo->prepare("SELECT COUNT(*) FROM {$prefix}users");
$u->execute();
if (!$u->fetchColumn()) {
$ins = $pdo->prepare("INSERT INTO {$prefix}users (username, password, nickname, gender, role, status, points, exp, is_installer_admin, created_at) VALUES (?,?,?,?,?,?,?,?,?,?)");
$ins->execute([
$adminUser,
password_hash($adminPass, PASSWORD_DEFAULT),
($adminNickname !== '' ? $adminNickname : '茶室主人'),
'secret',
'superadmin',
1,
100,
100,
1,
$now,
]);
}
$builtin = [
['gallery', '图床', '上传图片并生成外链 / Markdown / HTML 代码', ''],
['netdisk', '网盘', '上传文件、分享提取码、在线预览与下载', ''],
['chat', '聊天大厅', '登录用户实时聊天,支持图片与文件', ''],
['links', '友情链接', '站点入口列表,管理员可维护', ''],
['source', '木漏茶室源码下载中心', '浏览、复制、下载本站源码', ''],
['world', '世界圈', '世界那么大,快来分享你的故事吧。', ''],
['friends', '好友', '添加好友、备注与实时聊天', ''],
['lanzou', '蓝奏云', '蓝奏云网盘入口,登录后管理文件', 'https://www.lanzou.com/'],
];
$e = $pdo->prepare("SELECT COUNT(*) FROM {$prefix}extensions");
$e->execute();
if (!$e->fetchColumn()) {
$ins = $pdo->prepare("INSERT INTO {$prefix}extensions (slug, name, description, url, is_builtin, status, created_at) VALUES (?,?,?,?,1,?,?)");
foreach ($builtin as $b) {
$ins->execute([$b[0], $b[1], $b[2], $b[3], 1, $now]);
}
}
}