35 lines
1.0 KiB
YAML
35 lines
1.0 KiB
YAML
apiVersion: v1
|
|
kind: ConfigMap
|
|
metadata:
|
|
name: icebay-init
|
|
namespace: icebay
|
|
labels:
|
|
app: icebay
|
|
component: database
|
|
data:
|
|
init.sql: |
|
|
CREATE TABLE IF NOT EXISTS orders (
|
|
id SERIAL PRIMARY KEY,
|
|
name VARCHAR(200) NOT NULL,
|
|
address TEXT NOT NULL,
|
|
items TEXT NOT NULL,
|
|
status VARCHAR(50) DEFAULT 'pending',
|
|
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
|
|
);
|
|
CREATE TABLE IF NOT EXISTS contacts (
|
|
id SERIAL PRIMARY KEY,
|
|
name VARCHAR(200) NOT NULL,
|
|
email VARCHAR(200) NOT NULL,
|
|
subject VARCHAR(300),
|
|
message TEXT NOT NULL,
|
|
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
|
|
);
|
|
CREATE TABLE IF NOT EXISTS users (
|
|
id SERIAL PRIMARY KEY,
|
|
name VARCHAR(200) NOT NULL,
|
|
email VARCHAR(200) UNIQUE NOT NULL,
|
|
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
|
|
);
|
|
INSERT INTO orders (name, address, items, status) VALUES
|
|
('Demo Customer','SaiBaba Colony, Coimbatore','Arabian Fantasy x5, Vanilla x3','confirmed');
|