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 Cj�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用户注册成功