Installation

Add this to your sql:

CREATE TABLE IF NOT EXISTS restraining_orders (
    id INT AUTO_INCREMENT PRIMARY KEY,
    maker_cid VARCHAR(50) NOT NULL,
    target_cid VARCHAR(50) NOT NULL,
    maker_name VARCHAR(255) NOT NULL,
    target_name VARCHAR(255) NOT NULL,
    duration INT NOT NULL,
    expiration_time TIMESTAMP NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE IF NOT EXISTS trespassing_orders (
    id INT AUTO_INCREMENT PRIMARY KEY,
    business_name VARCHAR(255) NOT NULL,
    player_cid VARCHAR(50) NOT NULL,
    player_name VARCHAR(255) NOT NULL,
    duration INT NOT NULL,
    expiration_time TIMESTAMP NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- i had forgotten about the distance initally, and couldnt be asked to update the sqls

ALTER TABLE restraining_orders
ADD COLUMN distance INT NOT NULL DEFAULT 100; 

ALTER TABLE trespassing_orders
ADD COLUMN distance INT NOT NULL DEFAULT 100;

Enjoy! You can let us know if theres any issues or if you have any questions here