-- MySQL: Creating a Table
CREATE DATABASE ecommerce;
USE ecommerce;

CREATE TABLE products (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    price DECIMAL(10,2) NOT NULL,
    stock INT DEFAULT 0,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- PostgreSQL: Creating a Table
CREATE DATABASE ecommerce;

\c ecommerce  -- Connect to database

CREATE TABLE products (
    id SERIAL PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    price DECIMAL(10,2) NOT NULL,
    stock INT DEFAULT 0,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- Both: Inserting Data
INSERT INTO products (name, price, stock) 
VALUES ('Laptop', 999.99, 10),
       ('Mouse', 29.99, 50);

-- Both: Creating a Backup (MySQL vs PostgreSQL)
-- MySQL: mysqldump -u root -p ecommerce > backup.sql
-- PostgreSQL: pg_dump -U postgres ecommerce > backup.sql