LDeyN4zb

1CREATE TABLE IF NOT EXISTS `skinData` (
2`SkinID` INTEGER PRIMARY KEY AUTO_INCREMENT,
3`DisplayName` VARCHAR(255),
4`Timestamp` BIGINT NOT NULL,
5`UUID` CHAR(36) NOT NULL ON DUPLICATE KEY UPDATE,
6`Name` VARCHAR(16) NOT NULL,
7`SlimModel` BIT DEFAULT 0 NOT NULL,
8`SkinURL` VARCHAR(255) NOT NULL,
9`CapeURL` VARCHAR(255),
10`Signature` BLOB NOT NULL
11);
12
13CREATE TABLE IF NOT EXISTS `preferences` (
14`UserID` INTEGER PRIMARY KEY AUTO_INCREMENT,
15`UUID` CHAR(36) NOT NULL ON DUPLICATE KEY UPDATE,
16`TargetSkin` INTEGER NOT NULL,
17`KeepSkin` BIT NOT NULL DEFAULT 1,
18FOREIGN KEY (`TargetSkin`) REFERENCES `skinData` (`SkinID`)
19ON DELETE CASCADE
20);