install.sql

CREATE DATABASE bossstatus CHARACTER SET utf8;
use bossstatus;

CREATE TABLE sitesettings (
    sitename TEXT,
    sitedesc TEXT,
    sitecolor TEXT
);

CREATE TABLE users (
    id TEXT,
    email TEXT,
    password TEXT
);

CREATE TABLE services (
    uniqueid TEXT,
    name TEXT,
    position INT,
    category TEXT,
    ip TEXT,
    port TEXT,
    status TEXT,
    tooltip TEXT,
    alerts BOOLEAN,
    webhook TEXT,
    lastpingonline BOOLEAN
);

CREATE TABLE incidents (
    uniqueid TEXT,
    title TEXT,
    color TEXT,
    details TEXT,
    closed BOOLEAN,
    datetime TEXT
);

CREATE TABLE incidentupdates (
    uniqueid TEXT,
    incidentid TEXT,
    title TEXT,
    details TEXT,
    datetime TEXT
);

CREATE TABLE servicecats (
    uniqueid TEXT,
    name TEXT,
    position INT
);

CREATE TABLE pings (
    id INT NOT NULL AUTO_INCREMENT,
    serviceid TEXT,
    online INT,
    datetime TEXT,
PRIMARY KEY (id));

CREATE TABLE staff (
    userid TEXT
);

ALTER DATABASE bossstatus CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
ALTER TABLE sitesettings CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
ALTER TABLE users CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
ALTER TABLE services CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
ALTER TABLE incidents CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
ALTER TABLE incidentupdates CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
ALTER TABLE servicecats CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
ALTER TABLE pings CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
ALTER TABLE staff CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;

INSERT INTO sitesettings (sitename, sitedesc, sitecolor) VALUES ('Change Me', 'A description placeholder...', '#006fed');