SQLite format 3 @ .zq
�
���r7
��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
)��}tablepersonspersonsCREATE 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,
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$H2IUCJCyP5xHhsXTCafjMuad0JGcEYkWI4pZAD7xk2tLRJELjbs2e2025-09-06 08:24:24
� � admin
� � ���� 'announcementspersonsnews announcements users
] &