SQL

CREATE TABLE IF NOT EXISTS `gloveboxitems` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`plate` VARCHAR(255) NOT NULL COLLATE 'latin1_swedish_ci',
	`items` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`label` VARCHAR(100) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`slots` INT(11) NULL DEFAULT NULL,
	`personal` VARCHAR(255) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`weight` INT(11) NULL DEFAULT NULL,
	`job` VARCHAR(100) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	PRIMARY KEY (`plate`) USING BTREE,
	INDEX `id` (`id`) USING BTREE
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
AUTO_INCREMENT=152;

CREATE TABLE IF NOT EXISTS `stashitems` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`stash` VARCHAR(255) NOT NULL COLLATE 'latin1_swedish_ci',
	`items` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`label` VARCHAR(100) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`slots` INT(11) NULL DEFAULT NULL,
	`job` VARCHAR(100) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`personal` VARCHAR(255) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`weight` INT(11) NULL DEFAULT NULL,
	PRIMARY KEY (`stash`) USING BTREE,
	INDEX `id` (`id`) USING BTREE
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1;

CREATE TABLE IF NOT EXISTS `trunkitems` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`plate` VARCHAR(255) NOT NULL COLLATE 'latin1_swedish_ci',
	`items` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`label` VARCHAR(100) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`personal` VARCHAR(255) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	`weight` INT(11) NULL DEFAULT NULL,
	`slots` INT(11) NULL DEFAULT NULL,
	`job` VARCHAR(100) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
	PRIMARY KEY (`plate`) USING BTREE,
	INDEX `id` (`id`) USING BTREE
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1;

DROP TABLE IF EXISTS `origen_customitems`;
CREATE TABLE `origen_customitems` (
	`name` VARCHAR(100) NOT NULL,
	`label` VARCHAR(255) NOT NULL,
	`weight` INT NOT NULL DEFAULT 0,
	`type` VARCHAR(50) NOT NULL DEFAULT 'item',
	`image` VARCHAR(255),
	`description` TEXT,
	`unique` TINYINT(1) NOT NULL DEFAULT 0,
	`stack` TINYINT(1) NOT NULL DEFAULT 0,
	`close` TINYINT(1) NOT NULL DEFAULT 1,
	`server` JSON,
	`client` JSON,
	`buttons` JSON,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `origen_customitems` (
	`name` VARCHAR(100) NOT NULL COLLATE 'utf8mb4_unicode_ci',
	`label` VARCHAR(255) NOT NULL COLLATE 'utf8mb4_unicode_ci',
	`weight` INT(11) NOT NULL DEFAULT '0',
	`type` VARCHAR(50) NOT NULL DEFAULT 'item' COLLATE 'utf8mb4_unicode_ci',
	`image` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`description` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`unique` TINYINT(1) NOT NULL DEFAULT '0',
	`stack` TINYINT(1) NOT NULL DEFAULT '0',
	`close` TINYINT(1) NOT NULL DEFAULT '1',
	`server` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`client` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	`buttons` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
	PRIMARY KEY (`name`) USING BTREE,
	CONSTRAINT `server` CHECK (json_valid(`server`)),
	CONSTRAINT `client` CHECK (json_valid(`client`)),
	CONSTRAINT `buttons` CHECK (json_valid(`buttons`))
) COLLATE='utf8mb4_unicode_ci' ENGINE=InnoDB;
PreviousInstallationNextScripts Support

Last updated