EsPj7ETB

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,
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,
16  `TargetSkin` INTEGER  NOT NULL,
17  `KeepSkin`   BIT      NOT NULL   DEFAULT 1,
18  UNIQUE (`UUID`),
19  FOREIGN KEY (`TargetSkin`) REFERENCES `skinData` (`SkinID`)
20    ON DELETE CASCADE
21);