CREATE TABLE skus(sku varchar(50) primary key, total_allotment UNSIGNED INT, // Total Allotment current_allotment UNSIGNED INT, // Current Available Allotment committed_allotment UNSIGNED INT); // Total Sold Allotment CREATE TABLE skus_pending(session_id CHAR(32), sku VARCHAR(50), quantity UNSIGNED INT);