SQL example

CREATE DATABASE IF NOT EXISTS greenfield_db CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ; USE greenfield_db ; SET FOREIGN_KEY_CHECKS = 0 ; DROP TABLE IF EXISTS reviews ; DROP TABLE IF EXISTS order_items ; DROP TABLE IF EXISTS orders ; DROP TABLE IF EXISTS products ; DROP TABLE IF EXISTS categories ; DROP TABLE IF EXISTS users ; SET FOREIGN_KEY_CHECKS = 1 ; CREATE TABLE users ( id INT AUTO_INCREMENT PRIMARY KEY , first_name VARCHAR ( 100 ) NOT NULL , last_name VARCHAR ( 100 ) NOT NULL , email VARCHAR ( 255 ) NOT NULL UNIQUE , password_hash VARCHAR ( 255 ) NOT NULL , role ENUM ( 'customer' , 'producer' , 'admin' ) DEFAULT 'customer' , bio TEXT , logo_url VARCHAR ( 500 ), loyalty_points INT DEFAULT 0 , created_at DATETIME DEFAULT CURRENT_TIMESTAMP ); CREATE TABLE categories ( id INT AUTO_INCREMENT PRIMARY KEY , name VARCHAR ( 100 ) NOT NULL UNIQUE ); CREATE TABLE products ( id INT AUTO_INCREMENT PRIMARY KEY , producer_id INT NOT NULL , category_id INT , name VARCHAR ( 200 ) NOT NULL