SQLite format 3 @ .zq
H
tablenewsnewsCREATE TABLE news (
id INTEGER PRIMARY KEY AUTOINCREMENT,
title TEXT NOT NULL,
content TEXT NOT NULL,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
updated_at DATETIME DEFAULT CURRENT_TIMESTAMP
)8''/tableannouncementsannouncementsCREATE TABLE announcements (
id INTEGER PRIMARY KEY AUTOINCREMENT,
title TEXT NOT NULL,
content TEXT NOT NULL,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
updated_at DATETIME DEFAULT CURRENT_TIMESTAMP
)=QtablepersonspersonsCREATE TABLE persons (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
birth_name TEXT,
birth_date DATE,
birth_place TEXT,
death_date DATE,
spouse_info TEXT,
bio TEXT,
gender TEXT DEFAULT '男',
notes TEXT,
parent_id INTEGER DEFAULT 0,
sort_order INTEGER DEFAULT 1,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
updated_at DATETIME DEFAULT CURRENT_TIMESTAMP
)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)p?tableusersusersCREATE TABLE users (
id INTEGER PRIMARY KEY AUTOINCREMENT,
username TEXT UNIQUE NOT NULL,
password TEXT NOT NULL,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP
))= indexsqlite_autoindex_users_1users
Z 3admin$2y$10$qPaC8sS8tblEwsStr7HC2eLSRvZ8BycL0pGxZuB9omgeBXV6FxcRi2025-09-08 08:32:44
admin
news' announcements users
[ [ " =G33欢迎使用家谱系统欢迎使用吴氏家谱系统！本系统支持创建、编辑和浏览家族树状结构。2025-09-08 08:32:452025-09-08 08:32:45
{ { 133系统上线通知
家谱系统正式上线运行，欢迎各位宗亲使用！
2025-09-08 08:32:452025-09-08 08:32:45