CREATE TABLE IF NOT EXISTS admins (id INT AUTO_INCREMENT PRIMARY KEY, username VARCHAR(80) UNIQUE NOT NULL, password_hash VARCHAR(255) NOT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP);
CREATE TABLE IF NOT EXISTS guests (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(180) NOT NULL, token VARCHAR(40) UNIQUE NOT NULL, attendance ENUM('pending','attending','not_attending') DEFAULT 'pending', created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP);
CREATE TABLE IF NOT EXISTS messages (id INT AUTO_INCREMENT PRIMARY KEY, guest_id INT NULL, name VARCHAR(180) NOT NULL, message TEXT NOT NULL, attendance ENUM('pending','attending','not_attending') DEFAULT 'pending', created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, FOREIGN KEY (guest_id) REFERENCES guests(id) ON DELETE SET NULL);
CREATE TABLE IF NOT EXISTS settings (id INT AUTO_INCREMENT PRIMARY KEY, setting_key VARCHAR(100) UNIQUE NOT NULL, setting_value TEXT NOT NULL);
CREATE TABLE IF NOT EXISTS wedding_gifts (id INT AUTO_INCREMENT PRIMARY KEY, type VARCHAR(30) DEFAULT 'bank', bank_name VARCHAR(100), account_number VARCHAR(100), account_holder VARCHAR(150), label VARCHAR(100), created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP);
INSERT IGNORE INTO admins(username,password_hash) VALUES ('gilang','$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC9yqYQhGQvG4h8p4Q6m');
INSERT IGNORE INTO settings(setting_key,setting_value) VALUES
('bride_name','Ayu Rahmawati'),('groom_name','Gilang Ramdan'),('wedding_date','2027-01-01 08:00:00'),('event_title','NIKAH'),('venue','Lokasi Acara'),('address','Jl....., Kab. Karawang, Jawa Barat'),('maps_url','https://maps.google.com'),('bride_parents','Bapak .... & Ibu ....'),('groom_parents','Bapak .... & Ibu ....'),('bride_instagram','@ayurahmawati'),('groom_instagram','@gilangramdan'),('opening_text','Maha Suci Allah yang telah menciptakan makhluk-Nya berpasang-pasangan. Ya Allah semoga ridho-Mu tercurah mengiringi pernikahan kami.');