--Create estore tables sql commands

DROP TABLE IF EXISTS my_categories;
CREATE TABLE my_categories 
(
  cat_id CHAR(3) PRIMARY KEY,
  cat_name VARCHAR(15) NOT NULL UNIQUE
);

DROP TABLE IF EXISTS my_products;
CREATE TABLE my_products
(
  pdt_id INT PRIMARY KEY AUTO_INCREMENT,
  pdt_name VARCHAR(20) NOT NULL,
  cat CHAR(3) NOT NULL,
  amount INT DEFAULT NULL,
  price DECIMAL(10, 2) NOT NULL,
  img VARCHAR(30) NOT NULL
); 