SQL Setup

SQL Setup

As you'll notice, the code for these is the same apart from the tablename it injects into. If you are using a multicharacter system, you must ensure that you have toggled the option for it in the Config.lua to true!

QBCore Framework

Single Character

CREATE TABLE IF NOT EXISTS player_reputation (
    player_id VARCHAR(50) NOT NULL,
    totalLevel INT NOT NULL DEFAULT 0,
    mining INT NOT NULL DEFAULT 0,
    fishing INT NOT NULL DEFAULT 0,
    weed_harvesting INT NOT NULL DEFAULT 0,
    PRIMARY KEY (player_id)
);

Multi Character

CREATE TABLE IF NOT EXISTS user_reputation (
    character_id VARCHAR(50) NOT NULL,
    totalLevel INT NOT NULL DEFAULT 0,
    mining INT NOT NULL DEFAULT 0,
    fishing INT NOT NULL DEFAULT 0,
    weed_harvesting INT NOT NULL DEFAULT 0,
    PRIMARY KEY (character_id)
);

Qbox Framework

Single Character

CREATE TABLE IF NOT EXISTS player_reputation (
    identifier VARCHAR(50) NOT NULL,
    totalLevel INT NOT NULL DEFAULT 0,
    mining INT NOT NULL DEFAULT 0,
    fishing INT NOT NULL DEFAULT 0,
    weed_harvesting INT NOT NULL DEFAULT 0,
    PRIMARY KEY (identifier)
);

Multi Character

CREATE TABLE IF NOT EXISTS user_reputation (
    charid INT NOT NULL,
    totalLevel INT NOT NULL DEFAULT 0,
    mining INT NOT NULL DEFAULT 0,
    fishing INT NOT NULL DEFAULT 0,
    weed_harvesting INT NOT NULL DEFAULT 0,
    PRIMARY KEY (charid)
);

ESX Framework

Single Character

CREATE TABLE IF NOT EXISTS player_reputation (
    identifier VARCHAR(50) NOT NULL,
    totalLevel INT NOT NULL DEFAULT 0,
    mining INT NOT NULL DEFAULT 0,
    fishing INT NOT NULL DEFAULT 0,
    weed_harvesting INT NOT NULL DEFAULT 0,
    PRIMARY KEY (identifier)
);

Multi Character

CREATE TABLE IF NOT EXISTS user_reputation (
    charid INT NOT NULL,
    totalLevel INT NOT NULL DEFAULT 0,
    mining INT NOT NULL DEFAULT 0,
    fishing INT NOT NULL DEFAULT 0,
    weed_harvesting INT NOT NULL DEFAULT 0,
    PRIMARY KEY (charid)
);