ALTER TABLE
`users`
ADD
IF NOT EXISTS `inside_lab` VARCHAR(50) NULL DEFAULT NULL;
DROP TABLE IF EXISTS `drug_farm`;
CREATE TABLE `drug_farm` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
`creator` VARCHAR(80) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`type` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
`zone` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`maxCollectionCount` INT(11) NOT NULL DEFAULT '5',
`blip` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `name` (`name`) USING BTREE
)
COLLATE='utf8mb3_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1
;
DROP TABLE IF EXISTS `drug_labs`;
CREATE TABLE `drug_labs` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`creator` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`owner` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`stash` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`wardrobe` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`shell` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`blip` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`price` INT(11) NULL DEFAULT '500',
`holders` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`locked` TINYINT(2) NULL DEFAULT '0',
`level` INT(11) NULL DEFAULT '1',
`progress` INT(11) NULL DEFAULT '0',
`public` TINYINT(1) NULL DEFAULT '0',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `name` (`name`) USING BTREE
)
COLLATE='utf8mb3_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1
;
DROP TABLE IF EXISTS `drug_lab_decorations`;
CREATE TABLE `drug_lab_decorations` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`lab` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`creator` VARCHAR(70) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
`modelName` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
`coords` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`rotation` TEXT NOT NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
`inStash` TINYINT(1) NOT NULL DEFAULT '0',
`created` TIMESTAMP NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `id` (`id`, `lab`) USING BTREE
)
COLLATE='utf8mb3_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1
;
DROP TABLE IF EXISTS `drug_seller`;
CREATE TABLE `drug_seller` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
`creator` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
`blip` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`entry` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`model` VARCHAR(50) NOT NULL COLLATE 'utf8mb3_general_ci',
`time` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`knock` TINYINT(1) NOT NULL DEFAULT '0',
`itemListId` VARCHAR(50) NOT NULL COLLATE 'utf8mb3_general_ci',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `name` (`name`) USING BTREE
)
COLLATE='utf8mb3_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1
;ALTER TABLE
`players`
ADD
IF NOT EXISTS `inside_lab` VARCHAR(50) NULL DEFAULT NULL;
DROP TABLE IF EXISTS `drug_farm`;
CREATE TABLE `drug_farm` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
`creator` VARCHAR(80) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`type` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
`zone` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`maxCollectionCount` INT(11) NOT NULL DEFAULT '5',
`blip` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `name` (`name`) USING BTREE
)
COLLATE='utf8mb3_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1
;
DROP TABLE IF EXISTS `drug_labs`;
CREATE TABLE `drug_labs` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`creator` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`owner` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`stash` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`wardrobe` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`shell` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`blip` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`price` INT(11) NULL DEFAULT '500',
`holders` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`locked` TINYINT(2) NULL DEFAULT '0',
`level` INT(11) NULL DEFAULT '1',
`progress` INT(11) NULL DEFAULT '0',
`public` TINYINT(1) NULL DEFAULT '0',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `name` (`name`) USING BTREE
)
COLLATE='utf8mb3_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1
;
DROP TABLE IF EXISTS `drug_lab_decorations`;
CREATE TABLE `drug_lab_decorations` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`lab` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`creator` VARCHAR(70) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
`modelName` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
`coords` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`rotation` TEXT NOT NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
`inStash` TINYINT(1) NOT NULL DEFAULT '0',
`created` TIMESTAMP NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `id` (`id`, `lab`) USING BTREE
)
COLLATE='utf8mb3_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1
;
DROP TABLE IF EXISTS `drug_seller`;
CREATE TABLE `drug_seller` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
`creator` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
`blip` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`entry` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`model` VARCHAR(50) NOT NULL COLLATE 'utf8mb3_general_ci',
`time` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`knock` TINYINT(1) NOT NULL DEFAULT '0',
`itemListId` VARCHAR(50) NOT NULL COLLATE 'utf8mb3_general_ci',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `name` (`name`) USING BTREE
)
COLLATE='utf8mb3_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1
;