dCXyzgUi

1DROP DATABASE IF EXISTS FruitShop;
2CREATE DATABASE FruitShop;
3USE FruitShop;
4
5CREATE TABLE Units (
6UnitId TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
7UnitName VARCHAR(10) NOT NULL,
8DateEntered DATETIME NOT NULL,
9DateUpdated TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
10PRIMARY KEY (UnitId)
11)ENGINE=InnoDB DEFAULT CHARSET=utf8;
12
13CREATE TABLE Fruit (
14FruitId SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
15FruitName VARCHAR(45) NOT NULL, 
16Inventory SMALLINT UNSIGNED NOT NULL,
17UnitId TINYINT UNSIGNED NOT NULL,
18DateEntered DATETIME NOT NULL,
19DateUpdated TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
20PRIMARY KEY (FruitId),
21CONSTRAINT fkFruitUnits FOREIGN KEY (UnitId) REFERENCES Units (UnitId) ON DELETE RESTRICT ON UPDATE CASCADE
22)ENGINE=InnoDB DEFAULT CHARSET=utf8;