تجهيز بيانات منتجات المتجر

-- Create The Products Table
CREATE TABLE products (
    id INTEGER PRIMARY KEY,
    name TEXT NOT NULL,
    category TEXT NOT NULL,
    price_cents INTEGER NOT NULL CHECK (price_cents >= 0),
    stock INTEGER NOT NULL DEFAULT 0 CHECK (stock >= 0),
    description TEXT
);

-- Insert The Products
INSERT INTO products (id, name, category, price_cents, stock, description)
VALUES
    (1, 'Keyboard', 'Accessories', 5000, 12, 'Mechanical'),
    (2, 'Mouse', 'Accessories', 2500, 30, NULL),
    (3, 'Monitor', 'Displays', 20000, 5, '24 inch'),
    (4, 'Laptop', 'Computers', 80000, 3, 'Portable'),
    (5, 'Cable', 'Accessories', 1000, 0, NULL),
    (6, 'Stand', 'Accessories', 3000, 8, 'Adjustable');

-- Display The Products Ordered By ID
SELECT id, name, price_cents, stock
FROM products
ORDER BY id;