
π SQL
CREATE TABLE IF NOT EXISTS closed_shop_stock (
job VARCHAR(50),
item_name VARCHAR(100),
price INT,
stock INT,
PRIMARY KEY (job, item_name)
);Last updated

CREATE TABLE IF NOT EXISTS closed_shop_stock (
job VARCHAR(50),
item_name VARCHAR(100),
price INT,
stock INT,
PRIMARY KEY (job, item_name)
);Last updated