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