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
] &