· 7 years ago · Dec 26, 2018, 10:32 PM
1CREATE TABLE IF NOT EXISTS SoldItems (
2id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
3check_id INT(6) UNSIGNED NOT NULL,
4instances_id INT(6) UNSIGNED NOT NULL,
5selling_price FLOAT UNSIGNED NOT NULL,
6earnings FLOAT UNSIGNED NOT NULL,
7FOREIGN KEY(check_id) REFERENCES Checks(id),
8FOREIGN KEY(instances_id) REFERENCES ClothingInstances(id)
9);