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