Sa16JMBQ

1CREATE TABLE IF NOT EXISTS ClothingInstances (
2id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
3models_id INT(6) UNSIGNED NOT NULL,
4selling_price FLOAT UNSIGNED NOT NULL,
5wholesale_price FLOAT UNSIGNED NOT NULL,
6size ENUM("XS", "S", "M", "L", "XL", "XXL", "XXXL") NOT NULL,
7amount_available SMALLINT UNSIGNED NOT NULL,
8FOREIGN KEY(models_id) REFERENCES ClothingModels(id) 
9);