ogrechkoandClaude Sonnet 5
130c5382cd
Multi-page public site (Next.js), Node/Express backend with Postgres, and Vite admin/account app, restructured from a single-page layout into dedicated service, promotions, cases, about, FAQ, and blog pages for SEO. Co-Authored-By: Claude Sonnet 5 <noreply@anthropic.com> Claude-Session: https://claude.ai/code/session_013otXCiTZsxdZ4SJKZ9wUky
20 lines
582 B
SQL
20 lines
582 B
SQL
CREATE TABLE IF NOT EXISTS customers (
|
|
id SERIAL PRIMARY KEY,
|
|
name TEXT NOT NULL,
|
|
email TEXT UNIQUE NOT NULL,
|
|
password_hash TEXT NOT NULL,
|
|
company TEXT,
|
|
phone TEXT,
|
|
created_at TIMESTAMPTZ DEFAULT now()
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS support_messages (
|
|
id SERIAL PRIMARY KEY,
|
|
customer_id INT NOT NULL REFERENCES customers(id) ON DELETE CASCADE,
|
|
sender TEXT NOT NULL CHECK (sender IN ('customer', 'staff')),
|
|
body TEXT NOT NULL,
|
|
created_at TIMESTAMPTZ DEFAULT now()
|
|
);
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_support_messages_customer ON support_messages(customer_id);
|