install.sql

CREATE DATABASE bossdocs CHARACTER SET utf8;
USE bossdocs;

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

CREATE TABLE navbar (
    name TEXT,
    link TEXT,
    uniqueid TEXT
);

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

CREATE TABLE categories (
    uniqueid TEXT,
    name TEXT,
    link TEXT,
    description TEXT,
    pos INT
);

CREATE TABLE articles (
    uniqueid TEXT,
    catid TEXT,
    name TEXT,
    link TEXT,
    content TEXT,
    pos INT,
    discordroleid TEXT
);

CREATE TABLE staff (
    userid TEXT
);

ALTER DATABASE bossdocs CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
ALTER TABLE sitesettings CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
ALTER TABLE navbar 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 categories CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
ALTER TABLE articles 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, guildid) VALUES ('My Docs', 'An amazing documentation website that will guide you through everything you need to know!', '#FE3332', 'none');
INSERT INTO navbar(name, link, uniqueid) VALUES ('Home', '/', 'asdhqwejhasd');
INSERT INTO navbar(name, link, uniqueid) VALUES ('Discord', '/discord', 'fjkhqwebfskjhasd');
INSERT INTO staff (userid) VALUES ('704094587836301392');