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� �& /�% %%33
wxs8412@gmail.com$2y$10$u0WDnSX59FSqo4jURAw9HeeD5enY0GUm4iqFhC4UIobwCL1nGXKm.无名的路192.168.1.21192.168.1.212026-01-27 13:43:352026-01-27 13:43:35�
/�+ %
3
admin@example.com$2y$10$pgs/WPn9JAu4R7Zp24XPcOiTCcqd6i3XSnr1qhG04Y1CYVBJTCVKy超级管理员74.7.243.2092026-01-27 01:24:48
� �� /wxs8412@gmail.com/ admin@example.com
� ��
user_logs users
C j�C � %�-31logout192.168.1.21Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:147.0) Gecko/20100101 Firefox/147.02026-01-27 13:48:38用户退出登录� %�-31login192.168.1.21Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:147.0) Gecko/20100101 Firefox/147.02026-01-27 13:43:35用户登录成功� %�-31register192.168.1.21Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:147.0) Gecko/20100101 Firefox/147.02026-01-27 13:43:35用户注册成功