Page cover

πŸ“…SQL

  • To ensure the 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 firstaid_stock (
    zone_name VARCHAR(50) NOT NULL,
    item_name VARCHAR(50) NOT NULL,
    stock INT NOT NULL,
    PRIMARY KEY (zone_name, item_name)
);

Last updated