SOURCE DOWNLOAD

木漏茶室源码下载中心

整站 PHP 源码:可浏览文件、复制路径、下载单文件或打包 ZIP。

发布版本 v6.25.232 升级后自动生成独立源码包,下载中心只发送这份冻结包 已排除 config.php / 用户数据 / 上传文件 / 升级备份
komorebi-forum 183 个节点 · PHP 8.3.37 · 完整源码 ZIP 1.31 MB
下载完整源码 ZIP 源码包大小:1.31 MB 安装教程 作者主页 免费开源 免费下载 ↓
COMMUNITY DEPLOYMENTS

已经跑起来的木漏茶室

从源码下载中心下载、完成安装并回传验证的站外站点。每个站点只计 1 次部署下载量;已记录站点会实时读取名称、版本、Logo 与在线状态,本机、内网和证书异常站点无法完成回传。

实时检测
2 个站点已部署

已展示全部 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]);
        }
    }
}
主题