o 3Ypj3@s6ddlmZmZddlZdejdejddfddZdS))datetime timedeltaNconncurreturnc Cs|d|d|d|d|d|d|d|d|d |d |d |d |d |ddd|D}d|vrX|d|d|d|ddd|D}d|vry|d|d|d|d|d|d|d|dd d|D}|rd!|vr|d"|dd#d|D}d$D]\}}|r||vr|||dd%d|D}q|d&|d'|d(|d)|d*|d+|d,|d-|d.|d/|d0|d1|d2|d3|d4|d5d6d|D}d7|vrFd8|vrF|d9|rad:|vra|d;|d5dNz CREATE TABLE IF NOT EXISTS checkin_records ( id INTEGER PRIMARY KEY AUTOINCREMENT, user_id INTEGER NOT NULL, checkin_date TEXT NOT NULL, content TEXT NOT NULL ); z CREATE TABLE IF NOT EXISTS user_assets ( user_id TEXT PRIMARY KEY, points INTEGER DEFAULT 0 ); z CREATE TABLE IF NOT EXISTS user_titles ( user_id TEXT NOT NULL, title_id INTEGER NOT NULL, unlocked_at TEXT NOT NULL, PRIMARY KEY (user_id, title_id) ); z CREATE TABLE IF NOT EXISTS user_title_state ( user_id TEXT PRIMARY KEY, equipped_title INTEGER ); a CREATE TABLE IF NOT EXISTS user_equipped_titles ( user_id TEXT NOT NULL, slot INTEGER NOT NULL, title_id INTEGER NOT NULL, PRIMARY KEY (user_id, slot), UNIQUE (user_id, title_id) ); a. CREATE TABLE IF NOT EXISTS group_daily_message_stats ( stat_date TEXT NOT NULL, group_id INTEGER NOT NULL, user_id INTEGER NOT NULL, message_count INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (stat_date, group_id, user_id) ); z CREATE TABLE IF NOT EXISTS user_total_message_count ( user_id INTEGER PRIMARY KEY, message_count INTEGER NOT NULL DEFAULT 0 ); z CREATE TABLE IF NOT EXISTS user_lottery_daily_stats ( stat_date TEXT NOT NULL, user_id INTEGER NOT NULL, draw_count INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (stat_date, user_id) ); z CREATE TABLE IF NOT EXISTS user_remedy_usage ( year INTEGER NOT NULL, user_id INTEGER NOT NULL, used_count INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (year, user_id) ); z CREATE TABLE IF NOT EXISTS user_lottery_stats ( user_id INTEGER PRIMARY KEY, total_spent INTEGER NOT NULL DEFAULT 0 ); z CREATE TABLE IF NOT EXISTS user_weekly_streak_reward_claims ( user_id INTEGER NOT NULL, week_start TEXT NOT NULL, claimed_at TEXT NOT NULL, PRIMARY KEY (user_id, week_start) ); aL CREATE TABLE IF NOT EXISTS user_attendance_reward_claims ( user_id INTEGER NOT NULL, reward_type TEXT NOT NULL, period_key TEXT NOT NULL, points INTEGER NOT NULL, claimed_at TEXT NOT NULL, PRIMARY KEY (user_id, reward_type, period_key) ); a CREATE TABLE IF NOT EXISTS user_lottery_profile ( user_id INTEGER PRIMARY KEY, draw_count INTEGER NOT NULL DEFAULT 0, duplicate_count INTEGER NOT NULL DEFAULT 0, zero_streak INTEGER NOT NULL DEFAULT 0, max_zero_streak INTEGER NOT NULL DEFAULT 0, has_hit_ten INTEGER NOT NULL DEFAULT 0, total_zeros INTEGER NOT NULL DEFAULT 0 ); z'PRAGMA table_info(user_lottery_profile)cSg|]}|dqS.0rowr r */home/dore/onebot/Bot_Ero/core/db/_base.py ozinit_schema.. total_zeroszRALTER TABLE user_lottery_profile ADD COLUMN total_zeros INTEGER NOT NULL DEFAULT 0z CREATE TABLE IF NOT EXISTS shop_stock ( product_id TEXT PRIMARY KEY, stock INTEGER NOT NULL ); a CREATE TABLE IF NOT EXISTS shop_user_buffs ( user_id INTEGER PRIMARY KEY, extra_draw_pack_until TEXT, checkin_luck_remaining INTEGER NOT NULL DEFAULT 0, lottery_waiver_remaining INTEGER NOT NULL DEFAULT 0 ); z"PRAGMA table_info(checkin_records)cSrrr r r r rrr message_idz9ALTER TABLE checkin_records ADD COLUMN message_id INTEGERz INSERT OR IGNORE INTO user_equipped_titles (user_id, slot, title_id) SELECT user_id, 1, equipped_title FROM user_title_state WHERE equipped_title IS NOT NULL a  CREATE TABLE IF NOT EXISTS group_alarms ( id INTEGER PRIMARY KEY AUTOINCREMENT, group_id INTEGER NOT NULL, creator_user_id INTEGER NOT NULL, fire_at TEXT NOT NULL, content TEXT NOT NULL, created_at TEXT NOT NULL, fired INTEGER NOT NULL DEFAULT 0, is_private INTEGER NOT NULL DEFAULT 0, is_recurring INTEGER NOT NULL DEFAULT 0, repeat_y INTEGER NOT NULL DEFAULT 0, repeat_m INTEGER NOT NULL DEFAULT 0, repeat_d INTEGER NOT NULL DEFAULT 0, recur_kind INTEGER NOT NULL DEFAULT 0, recur_a INTEGER NOT NULL DEFAULT 0, recur_b INTEGER NOT NULL DEFAULT 0, recur_c INTEGER NOT NULL DEFAULT 0 ); zPCREATE INDEX IF NOT EXISTS idx_group_alarms_due ON group_alarms (fired, fire_at)z CREATE TABLE IF NOT EXISTS guestbook_entries ( id INTEGER PRIMARY KEY AUTOINCREMENT, author_user_id INTEGER NOT NULL, content TEXT NOT NULL, created_at TEXT NOT NULL ); a) CREATE TABLE IF NOT EXISTS guestbook_likes ( entry_id INTEGER NOT NULL, user_id INTEGER NOT NULL, created_at TEXT NOT NULL, PRIMARY KEY (entry_id, user_id), FOREIGN KEY (entry_id) REFERENCES guestbook_entries(id) ); z_CREATE INDEX IF NOT EXISTS idx_guestbook_entries_created ON guestbook_entries (created_at DESC)zPRAGMA table_info(group_alarms)cSrrr r r r rrr is_privatezIALTER TABLE group_alarms ADD COLUMN is_private INTEGER NOT NULL DEFAULT 0cSrrr r r r rrr)) is_recurringzKALTER TABLE group_alarms ADD COLUMN is_recurring INTEGER NOT NULL DEFAULT 0)repeat_yzGALTER TABLE group_alarms ADD COLUMN repeat_y INTEGER NOT NULL DEFAULT 0)repeat_mzGALTER TABLE group_alarms ADD COLUMN repeat_m INTEGER NOT NULL DEFAULT 0)repeat_dzGALTER TABLE group_alarms ADD COLUMN repeat_d INTEGER NOT NULL DEFAULT 0) recur_kindzIALTER TABLE group_alarms ADD COLUMN recur_kind INTEGER NOT NULL DEFAULT 0)recur_azFALTER TABLE group_alarms ADD COLUMN recur_a INTEGER NOT NULL DEFAULT 0)recur_bzFALTER TABLE group_alarms ADD COLUMN recur_b INTEGER NOT NULL DEFAULT 0)recur_czFALTER TABLE group_alarms ADD COLUMN recur_c INTEGER NOT NULL DEFAULT 0cSrrr r r r rrrz UPDATE group_alarms SET recur_kind = 1, recur_a = repeat_d, recur_b = 0, recur_c = 0 WHERE is_recurring = 1 AND recur_kind = 0 AND repeat_y = 0 AND repeat_m = 0 AND repeat_d > 0 z UPDATE group_alarms SET is_recurring = 0, recur_kind = 0, recur_a = 0, recur_b = 0, recur_c = 0 WHERE is_recurring = 1 AND recur_kind = 0 AND NOT (repeat_y = 0 AND repeat_m = 0 AND repeat_d > 0) a CREATE TABLE IF NOT EXISTS immortal_lottery_carry ( group_id INTEGER NOT NULL PRIMARY KEY, carry_4a INTEGER NOT NULL DEFAULT 0, carry_3a INTEGER NOT NULL DEFAULT 0, carry_2a INTEGER NOT NULL DEFAULT 0 ); aJ CREATE TABLE IF NOT EXISTS immortal_lottery_results ( group_id INTEGER NOT NULL, period_key TEXT NOT NULL, winning_digits TEXT NOT NULL, bet_total INTEGER NOT NULL DEFAULT 0, drawn_at TEXT NOT NULL, PRIMARY KEY (group_id, period_key) ); a CREATE TABLE IF NOT EXISTS immortal_lottery_bets ( id INTEGER PRIMARY KEY AUTOINCREMENT, group_id INTEGER NOT NULL, period_key TEXT NOT NULL, user_id INTEGER NOT NULL, digits TEXT NOT NULL, bet_bj_date TEXT NOT NULL, created_at TEXT NOT NULL, UNIQUE (group_id, user_id, bet_bj_date) ); zcCREATE INDEX IF NOT EXISTS idx_immortal_bets_period ON immortal_lottery_bets (group_id, period_key)a CREATE TABLE IF NOT EXISTS immortal_lottery_issue ( group_id INTEGER NOT NULL, period_key TEXT NOT NULL, issue_code TEXT NOT NULL, PRIMARY KEY (group_id, period_key), UNIQUE (issue_code) ); aV CREATE TABLE IF NOT EXISTS quest_progress ( user_id TEXT NOT NULL, quest_id INTEGER NOT NULL, week_key TEXT NOT NULL, progress INTEGER DEFAULT 0, completed INTEGER DEFAULT 0, claimed_at TEXT, PRIMARY KEY (user_id, quest_id, week_key) ); z CREATE TABLE IF NOT EXISTS quest_completion_stats ( user_id TEXT PRIMARY KEY, total_completions INTEGER DEFAULT 0 ); z CREATE TABLE IF NOT EXISTS quest_weekly_clears ( user_id TEXT NOT NULL, week_key TEXT NOT NULL, cleared_at TEXT NOT NULL, PRIMARY KEY (user_id, week_key) ); z CREATE TABLE IF NOT EXISTS group_plugin_config ( group_id INTEGER NOT NULL, plugin_name TEXT NOT NULL, PRIMARY KEY (group_id, plugin_name) ); a CREATE TABLE IF NOT EXISTS user_game_stats ( user_id TEXT PRIMARY KEY, total_games INTEGER DEFAULT 0, total_wins INTEGER DEFAULT 0, civilian_wins INTEGER DEFAULT 0, spy_wins INTEGER DEFAULT 0 ); z.DROP TABLE IF EXISTS group_chat_topic_messagesz&DROP TABLE IF EXISTS group_chat_topicsu CREATE TABLE IF NOT EXISTS activities ( id INTEGER PRIMARY KEY AUTOINCREMENT, group_id INTEGER NOT NULL, type TEXT NOT NULL, -- 'relay' | 'match' title TEXT NOT NULL, description TEXT, -- 活动描述（可选） status TEXT NOT NULL DEFAULT 'open', -- open | running | finished | cancelled created_by TEXT NOT NULL, signup_deadline TEXT, -- 报名截止时间（到点自动开始） deadline TEXT, -- 活动截止时间（到点强制结束归档） hours_per_user REAL, -- relay: 每人时限小时 created_at TEXT NOT NULL, finished_at TEXT ); zPRAGMA table_info(activities)cSrrr r r r rrBrtheme descriptionz9ALTER TABLE activities RENAME COLUMN theme TO descriptionsignup_deadlinez6ALTER TABLE activities ADD COLUMN signup_deadline TEXTcSrrr r r r rrHru CREATE TABLE IF NOT EXISTS activity_members ( activity_id INTEGER NOT NULL, user_id TEXT NOT NULL, nickname TEXT NOT NULL, seq INTEGER NOT NULL DEFAULT 0, -- relay 链序 / match 环序 next_user_id TEXT, -- match: 下家 status TEXT NOT NULL DEFAULT 'pending', -- pending|done|skipped|missed|left received_at TEXT, -- relay: 作品转交时刻（第一棒=开始通知时刻） submitted_at TEXT, content TEXT, images TEXT, -- JSON 数组 PRIMARY KEY (activity_id, user_id) ); )executefetchallcommit) rr_lp_cols_cols _alarm_cols _alarm_cols2colddl _act_colsr r r init_schemas                                          r))rrsqlite3 ConnectionCursorr)r r r rs