-- Users Table --
DROP TABLE IF EXISTS `Users`;
CREATE TABLE `Users` (`UID` INTEGER(63) UNIQUE PRIMARY KEY, `lastPlayerName` VARCHAR(127),
`steam` VARCHAR(127), `gameLicense` VARCHAR(127), `discord` VARCHAR(127));

-- Objects Table --
DROP TABLE IF EXISTS `Objects`;
CREATE TABLE `Objects` (`ID` INTEGER(63) UNIQUE PRIMARY KEY, `Owned_By_UID` INTEGER(63),
`Spawncode` VARCHAR(127), `isVehicle` BIT(1), `serverKey` VARCHAR(127));

-- TrustTracker Table --
DROP TABLE IF EXISTS `TrustTracker`;
CREATE TABLE `TrustTracker` (`TTID` INTEGER(63) UNIQUE PRIMARY KEY, `ID` INTEGER(63),
`Trusted_To_UID` INTEGER(63), `serverKey` VARCHAR(127));

-- Admins --
DROP TABLE IF EXISTS `Admins`;
CREATE TABLE `Admins` (`AID` INTEGER(63) UNIQUE PRIMARY KEY, `UID` INTEGER(63), `permissionRemoveOwner` BIT(1),
`permissionSetOwner` BIT(1), `permissionViewTrust` BIT(1), `serverKey` VARCHAR(127));

-- BadUsers --
DROP TABLE IF EXISTS `BadUsers`;
CREATE TABLE `BadUsers` (`BadID` INTEGER(63), `Username` VARCHAR(127), `Email` VARCHAR(255) UNIQUE PRIMARY KEY, `Password` VARCHAR(255),
`emailVerified` BIT(1), `serverKey` VARCHAR(127), `inviteCode` VARCHAR(255));