Download production_db.sql from srikrishna1/postgresql_backup: direct link, hf CLI and curl.
- Browser
- Download file 1.89 kB
-
https://huggingface.co/datasets/srikrishna1/postgresql_backup/resolve/main/production_db.sql
- Command line
-
hf download hf://datasets/srikrishna1/postgresql_backup/production_db.sql
-
curl -L -o production_db.sql https://huggingface.co/datasets/srikrishna1/postgresql_backup/resolve/main/production_db.sql
1.89 kB
| -- PostgreSQL Production Database Backup | |
| -- Database: production_db | |
| -- Created: 2025-01-15 | |
| -- Create Users Table | |
| CREATE TABLE users ( | |
| id SERIAL PRIMARY KEY, | |
| name VARCHAR(100) NOT NULL, | |
| email VARCHAR(100) UNIQUE NOT NULL, | |
| created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP | |
| ); | |
| -- Insert Sample Data | |
| INSERT INTO users (name, email) VALUES | |
| ('John Doe', 'john.doe@example.com'), | |
| ('Jane Smith', 'jane.smith@example.com'), | |
| ('Bob Johnson', 'bob.johnson@example.com'), | |
| ('Alice Williams', 'alice.williams@example.com'), | |
| ('Charlie Brown', 'charlie.brown@example.com'); | |
| -- Create Products Table | |
| CREATE TABLE products ( | |
| id SERIAL PRIMARY KEY, | |
| product_name VARCHAR(200) NOT NULL, | |
| price DECIMAL(10, 2) NOT NULL, | |
| stock_quantity INTEGER DEFAULT 0, | |
| created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP | |
| ); | |
| -- Insert Product Data | |
| INSERT INTO products (product_name, price, stock_quantity) VALUES | |
| ('Laptop', 999.99, 50), | |
| ('Mouse', 29.99, 200), | |
| ('Keyboard', 79.99, 150), | |
| ('Monitor', 299.99, 75), | |
| ('Headphones', 149.99, 100); | |
| -- Create Orders Table | |
| CREATE TABLE orders ( | |
| id SERIAL PRIMARY KEY, | |
| user_id INTEGER REFERENCES users(id), | |
| product_id INTEGER REFERENCES products(id), | |
| quantity INTEGER NOT NULL, | |
| total_amount DECIMAL(10, 2) NOT NULL, | |
| order_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP | |
| ); | |
| -- Insert Order Data | |
| INSERT INTO orders (user_id, product_id, quantity, total_amount) VALUES | |
| (1, 1, 1, 999.99), | |
| (2, 2, 2, 59.98), | |
| (3, 3, 1, 79.99), | |
| (4, 4, 1, 299.99), | |
| (5, 5, 2, 299.98); | |
| -- Create Indexes | |
| CREATE INDEX idx_users_email ON users(email); | |
| CREATE INDEX idx_products_name ON products(product_name); | |
| CREATE INDEX idx_orders_user_id ON orders(user_id); | |
| CREATE INDEX idx_orders_product_id ON orders(product_id); | |
| -- End of backup | |