CREATE TABLE IF NOT EXISTS `player_outfits` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`citizenid` varchar(50) DEFAULT NULL,
`outfitname` varchar(50) NOT NULL DEFAULT '0',
`model` varchar(50) DEFAULT NULL,
`props` text DEFAULT NULL,
`components` text DEFAULT NULL,
`skin` text DEFAULT NULL,
`outfitId` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `outfitId` (`outfitId`),
KEY `citizenid` (`citizenid`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `shared_outfits` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`outfitname` varchar(50) NOT NULL,
`sex` int(11) NOT NULL DEFAULT 0,
`skin` text NOT NULL,
`job_gang` varchar(50) NOT NULL,
`level` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;
CREATE TABLE IF NOT EXISTS `skin_config` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`owner` varchar(50) DEFAULT NULL,
`sex` int(11) DEFAULT NULL,
`clothes` text DEFAULT NULL,
`models` text DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;