-- PostgreSQL database dump
-- Vanguard Industries Platform
-- Generated: 2026-02-10 03:00:00 UTC

SET statement_timeout = 0;
SET lock_timeout = 0;

CREATE TABLE users (
    id SERIAL PRIMARY KEY,
    username VARCHAR(100) UNIQUE NOT NULL,
    email VARCHAR(255) UNIQUE NOT NULL,
    password_hash VARCHAR(255) NOT NULL,
    role VARCHAR(50) DEFAULT 'user',
    is_admin BOOLEAN DEFAULT FALSE
);

INSERT INTO users (username, email, password_hash, role, is_admin) VALUES
('admin', 'admin@vanguard-industries.com', '$2b$12$LK.e4wd3N5eFtLg8k3xOWe5Bf.Xf0fLwWxT5bY', 'admin', true),
('john.doe', 'john.doe@example.com', '$2b$12$8sK.Wd3R5eGtLh7f4yPNXd6Ag.Yg1gMxXyU6cZ', 'user', false),
('jane.smith', 'jane.smith@example.com', '$2b$12$3nM.Qr2S4dDsJk6g5xOVYb7Ch.Zh2hNyYzV7dA', 'user', false);

CREATE TABLE payment_methods (
    id SERIAL PRIMARY KEY,
    user_id INTEGER REFERENCES users(id),
    card_type VARCHAR(50),
    card_number VARCHAR(20),
    expiry VARCHAR(10),
    cardholder_name VARCHAR(255)
);

INSERT INTO payment_methods (user_id, card_type, card_number, expiry, cardholder_name) VALUES
(2, 'Visa', '4111111111111111', '12/28', 'John Doe'),
(3, 'Mastercard', '5500000000000004', '06/27', 'Jane Smith');

-- More tables follow...