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
{ { � 1�33系统上线通知<p>家谱系统正式上线运行,欢迎各位宗亲使用!</p>2025-09-08 08:32:452025-09-08 08:32:45