SQL

ESX

CREATE TABLE IF NOT EXISTS `player_outfits` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `identifier` varchar(50) DEFAULT NULL,
  `outfitname` varchar(50) NOT NULL,
  `model` varchar(50) DEFAULT NULL,
  `skin` text DEFAULT NULL,
  `outfitId` varchar(50) NOT NULL,
  `active` int(2) DEFAULT 0,
  `props` LONGTEXT;
  PRIMARY KEY (`id`),
  KEY `identifier` (`identifier`),
  KEY `outfitId` (`outfitId`)
);

QB

ALTER TABLE `player_outfits` ADD COLUMN
(
    `active` int(2) DEFAULT 0,
    `props` LONGTEXT;
);

Last updated