CREATE DATABASE admin_premium;
USE admin_premium;

CREATE TABLE categories (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL
);

CREATE TABLE products (
    id INT AUTO_INCREMENT PRIMARY KEY,
    category_id INT,
    title VARCHAR(200),
    image VARCHAR(255),
    price1 VARCHAR(50),
    price100 VARCHAR(50),
    price300 VARCHAR(50),
    price500 VARCHAR(50),
    note TEXT,
    FOREIGN KEY (category_id) REFERENCES categories(id) ON DELETE CASCADE
);