SQLite format 3 @ .zq
� �
� � R � � 11�Ctablethird_party_loginsthird_party_loginsCREATE TABLE third_party_logins (
id INTEGER PRIMARY KEY AUTOINCREMENT,
user_id INTEGER,
site_name VARCHAR(100),
site_id VARCHAR(255),
token VARCHAR(64),
expire_time DATETIME,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP
)�[ �tableuser_logsuser_logsCREATE TABLE user_logs (
id INTEGER PRIMARY KEY AUTOINCREMENT,
user_id INTEGER,
action VARCHAR(50),
ip VARCHAR(45),
user_agent TEXT,
log_time DATETIME DEFAULT CURRENT_TIMESTAMP,
details TEXT
)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�H�otableusersusersCREATE TABLE users (
id INTEGER PRIMARY KEY AUTOINCREMENT,
email VARCHAR(255) UNIQUE NOT NULL,
password VARCHAR(255) NOT NULL,
nickname VARCHAR(100) DEFAULT '',
status INTEGER DEFAULT 1, -- 1正常 0禁用
is_admin INTEGER DEFAULT 0,
register_ip VARCHAR(45) DEFAULT '',
last_login_ip VARCHAR(45) DEFAULT '',
register_time DATETIME DEFAULT CURRENT_TIMESTAMP,
last_login_time DATETIME,
login_count INTEGER DEFAULT 0,
token VARCHAR(64) DEFAULT '',
token_expire DATETIME
))= indexsqlite_autoindex_users_1users
s s �
/�+ %
3
admin@example.com$2y$10$m//8x/Hjsg8idsP3ra5blOL.ZsqxEs28w5qFaw/oHvXq3G/XNNGMS超级管理员192.168.1.212026-01-27 13:46:34
� � / admin@example.com
� � users