41 lines
1.0 KiB
SQL
41 lines
1.0 KiB
SQL
-- Create Database
|
|
-- CREATE DATABASE pottery_db;
|
|
|
|
-- Products Table
|
|
CREATE TABLE IF NOT EXISTS products (
|
|
id SERIAL PRIMARY KEY,
|
|
title VARCHAR(255) NOT NULL,
|
|
price DECIMAL(10, 2) NOT NULL,
|
|
image TEXT NOT NULL,
|
|
description TEXT,
|
|
gallery JSONB DEFAULT '[]',
|
|
slug TEXT,
|
|
number TEXT,
|
|
aspect_ratio TEXT
|
|
);
|
|
|
|
-- Articles Table
|
|
CREATE TABLE IF NOT EXISTS articles (
|
|
id SERIAL PRIMARY KEY,
|
|
title VARCHAR(255) NOT NULL,
|
|
date VARCHAR(50) NOT NULL,
|
|
image TEXT NOT NULL,
|
|
sections JSONB DEFAULT '[]',
|
|
slug TEXT,
|
|
category TEXT,
|
|
description TEXT
|
|
);
|
|
|
|
-- Orders Table
|
|
CREATE TABLE IF NOT EXISTS orders (
|
|
id SERIAL PRIMARY KEY,
|
|
customer_email TEXT NOT NULL,
|
|
customer_name TEXT NOT NULL,
|
|
shipping_address JSONB NOT NULL,
|
|
items JSONB NOT NULL,
|
|
total_amount DECIMAL(10, 2) NOT NULL,
|
|
payment_status TEXT DEFAULT 'pending',
|
|
shipping_status TEXT DEFAULT 'pending',
|
|
created_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP
|
|
);
|