terraria.sql

--- Output from query creator using MySQL
CREATE TABLE `Bans` (`IP` CHAR(16), `Name` TEXT, `UUID` TEXT, `Reason` TEXT, `BanningUser` TEXT, `Date` TEXT, `Expiration` TEXT, PRIMARY KEY (`IP`))
CREATE TABLE `Warps` (`Id` INT AUTO_INCREMENT, `WarpName` VARCHAR(50), `X` INT, `Y` INT, `WorldID` VARCHAR(50), `Private` TEXT, UNIQUE (`WarpName`, `WorldID`), PRIMARY KEY (`Id`))
CREATE TABLE `Regions` (`Id` INT AUTO_INCREMENT, `X1` INT, `Y1` INT, `width` INT, `height` INT, `RegionName` VARCHAR(50), `WorldID` VARCHAR(50), `UserIds` TEXT, `Protected` INT, `Groups` TEXT, `Owner` VARCHAR(50), `Z` INT, UNIQUE (`RegionName`, `WorldID`), PRIMARY KEY (`Id`))
CREATE TABLE `Users` (`ID` INT AUTO_INCREMENT, `Username` VARCHAR(32), `Password` VARCHAR(128), `UUID` VARCHAR(128), `Usergroup` TEXT, `Registered` TEXT, `LastAccessed` TEXT, `KnownIPs` TEXT, UNIQUE (`Username`), PRIMARY KEY (`ID`))
CREATE TABLE `GroupList` (`GroupName` VARCHAR(32), `Parent` VARCHAR(32), `Commands` TEXT, `ChatColor` TEXT, `Prefix` TEXT, `Suffix` TEXT, PRIMARY KEY (`GroupName`))
CREATE TABLE `ItemBans` (`ItemName` VARCHAR(50), `AllowedGroups` TEXT, PRIMARY KEY (`ItemName`))
CREATE TABLE `ProjectileBans` (`ProjectileID` INT, `AllowedGroups` TEXT, PRIMARY KEY (`ProjectileID`))
CREATE TABLE `TileBans` (`TileId` INT, `AllowedGroups` TEXT, PRIMARY KEY (`TileId`))
CREATE TABLE `RememberedPos` (`Name` VARCHAR(50), `IP` TEXT, `X` INT, `Y` INT, `WorldID` TEXT, PRIMARY KEY (`Name`))
CREATE TABLE `tsCharacter` (`Account` INT, `Health` INT, `MaxHealth` INT, `Mana` INT, `MaxMana` INT, `Inventory` TEXT, `spawnX` INT, `spawnY` INT, `hair` INT, `hairDye` INT, `hairColor` INT, `pantsColor` INT, `shirtColor` INT, `underShirtColor` INT, `shoeColor` INT, `hideVisuals` INT, `skinColor` INT, `eyeColor` INT, `questsCompleted` INT, PRIMARY KEY (`Account`))
CREATE TABLE `vcCharacterVocation` (`id` INT, `level` INT, `experience` BIGINT, `vocation` VARCHAR(16), PRIMARY KEY (`id`, `vocation`), FOREIGN KEY (`id`) REFERENCES `Users`(`ID`) ON DELETE CASCADE ON UPDATE CASCADE)
CREATE  INDEX `idx_level` ON `vcCharacterVocation` (`level`  ASC)
CREATE UNIQUE INDEX `idx_vocation` ON `vcCharacterVocation` (`vocation` (16) ASC)

--- Output from query creator using SQLite
CREATE TABLE "Bans" ("IP" TEXT(16), "Name" TEXT, "UUID" TEXT, "Reason" TEXT, "BanningUser" TEXT, "Date" TEXT, "Expiration" TEXT, PRIMARY KEY ("IP"))
CREATE TABLE "Warps" ("Id" INTEGER PRIMARY KEY AUTOINCREMENT, "WarpName" TEXT(50), "X" INTEGER, "Y" INTEGER, "WorldID" TEXT(50), "Private" TEXT, UNIQUE ("WarpName", "WorldID"))
CREATE TABLE "Regions" ("Id" INTEGER PRIMARY KEY AUTOINCREMENT, "X1" INTEGER, "Y1" INTEGER, "width" INTEGER, "height" INTEGER, "RegionName" TEXT(50), "WorldID" TEXT(50), "UserIds" TEXT, "Protected" INTEGER, "Groups" TEXT, "Owner" TEXT(50), "Z" INTEGER, UNIQUE ("RegionName", "WorldID"))
CREATE TABLE "Users" ("ID" INTEGER PRIMARY KEY AUTOINCREMENT, "Username" TEXT(32), "Password" TEXT(128), "UUID" TEXT(128), "Usergroup" TEXT, "Registered" TEXT, "LastAccessed" TEXT, "KnownIPs" TEXT, UNIQUE ("Username"))
CREATE TABLE "GroupList" ("GroupName" TEXT(32), "Parent" TEXT(32), "Commands" TEXT, "ChatColor" TEXT, "Prefix" TEXT, "Suffix" TEXT, PRIMARY KEY ("GroupName"))
CREATE TABLE "ItemBans" ("ItemName" TEXT(50), "AllowedGroups" TEXT, PRIMARY KEY ("ItemName"))
CREATE TABLE "ProjectileBans" ("ProjectileID" INTEGER, "AllowedGroups" TEXT, PRIMARY KEY ("ProjectileID"))
CREATE TABLE "TileBans" ("TileId" INTEGER, "AllowedGroups" TEXT, PRIMARY KEY ("TileId"))
CREATE TABLE "RememberedPos" ("Name" TEXT(50), "IP" TEXT, "X" INTEGER, "Y" INTEGER, "WorldID" TEXT, PRIMARY KEY ("Name"))
CREATE TABLE "tsCharacter" ("Account" INTEGER, "Health" INTEGER, "MaxHealth" INTEGER, "Mana" INTEGER, "MaxMana" INTEGER, "Inventory" TEXT, "spawnX" INTEGER, "spawnY" INTEGER, "hair" INTEGER, "hairDye" INTEGER, "hairColor" INTEGER, "pantsColor" INTEGER, "shirtColor" INTEGER, "underShirtColor" INTEGER, "shoeColor" INTEGER, "hideVisuals" INTEGER, "skinColor" INTEGER, "eyeColor" INTEGER, "questsCompleted" INTEGER, PRIMARY KEY ("Account"))
CREATE TABLE "vcCharacterVocation" ("id" INTEGER, "level" INTEGER, "experience" BIGINT, "vocation" TEXT(16), PRIMARY KEY ("id", "vocation"), FOREIGN KEY ("id") REFERENCES "Users"("ID") ON DELETE CASCADE ON UPDATE CASCADE)
CREATE  INDEX "idx_level" ON "vcCharacterVocation" ("level" ASC)
CREATE UNIQUE INDEX "idx_vocation" ON "vcCharacterVocation" ("vocation" ASC)