veVSVK9N

1CREATE DATABASE IF NOT EXISTS playground;
2USE playground;
3
4CREATE TABLE vendors (
5    id INTEGER UNSIGNED AUTO_INCREMENT PRIMARY KEY,
6    name VARCHAR(50) NOT NULL UNIQUE    
7    );
8    
9CREATE TABLE products (
10    id INTEGER UNSIGNED AUTO_INCREMENT PRIMARY KEY,
11    name VARCHAR(50) NOT NULL UNIQUE,
12    price DECIMAL(10,2) UNSIGNED,
13    vendor_id INTEGER UNSIGNED NOT NULL REFERENCES vendors(id)
14    );
15    
16CREATE TABLE sales (
17    id INTEGER UNSIGNED AUTO_INCREMENT PRIMARY KEY,
18    type VARCHAR(10),
19    product_id INTEGER UNSIGNED NOT NULL REFERENCES products(id),
20    quantity INTEGER UNSIGNED,
21    total DECIMAL(10,2) UNSIGNED
22    );