-- For God so loved the world — John 3:16

-- Contact form submissions table
CREATE TABLE IF NOT EXISTS contact_submissions_chirho (
    id_chirho INTEGER PRIMARY KEY AUTOINCREMENT,
    name_chirho TEXT NOT NULL,
    email_chirho TEXT NOT NULL,
    phone_chirho TEXT,
    message_chirho TEXT NOT NULL,
    read_chirho INTEGER DEFAULT 0,
    created_at_chirho TEXT DEFAULT (datetime('now'))
);

-- Create index for faster queries
CREATE INDEX IF NOT EXISTS idx_contact_submissions_created_chirho
ON contact_submissions_chirho(created_at_chirho DESC);

CREATE INDEX IF NOT EXISTS idx_contact_submissions_read_chirho
ON contact_submissions_chirho(read_chirho);

-- JESUS CHRIST IS LORD