167b3a7375
- Complete SvelteKit 2 + Svelte 5 template - Tailwind CSS styling with primary color customization - Pages: Home, About, Services, Contact - Contact form with D1 database backend - Placeholder system for site-specific values - Cloudflare adapter configuration Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
22 lines
685 B
SQL
22 lines
685 B
SQL
-- 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
|