Page cover

πŸ“…SQL

To ensure the closed shop stock system works as intended you must run or import the SQL file provided in the folder [SQL] to your database. Failure to do so will result in errors

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