Copy DROP TABLE IF EXISTS player_houses;
DROP TABLE IF EXISTS houselocations;
DROP TABLE IF EXISTS house_plants;
Do not start the resource without first having installed the complete database, if you start the resource in the database, you will get critical errors.
Copy ALTER TABLE `players` ADD IF NOT EXISTS `inside` VARCHAR ( 100 );
CREATE TABLE ` houselocations ` (
`id` int ( 11 ) NOT NULL AUTO_INCREMENT,
`name` varchar ( 255 ) NOT NULL ,
`label` varchar ( 255 ) DEFAULT NULL ,
`coords` text DEFAULT NULL ,
`owned` tinyint ( 2 ) DEFAULT NULL ,
`houseID` varchar ( 50 ) DEFAULT NULL ,
`price` int ( 11 ) DEFAULT NULL ,
`tier` text DEFAULT NULL ,
`garage` text DEFAULT NULL ,
`creator` varchar ( 50 ) DEFAULT NULL ,
`mlo` text DEFAULT NULL ,
`ipl` text DEFAULT NULL ,
`garageShell` text DEFAULT NULL ,
PRIMARY KEY ( `id` ),
KEY `name` ( `name` )
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;
CREATE TABLE ` player_houses ` (
`house` varchar ( 50 ) NOT NULL ,
`identifier` varchar ( 50 ) DEFAULT NULL ,
`citizenid` varchar ( 50 ) DEFAULT NULL ,
`insideId` varchar ( 50 ) DEFAULT NULL ,
`keyholders` text DEFAULT NULL ,
`decorations` LONGTEXT DEFAULT NULL ,
`stash` text DEFAULT NULL ,
`houseID` varchar ( 50 ) DEFAULT NULL ,
`outfit` text DEFAULT NULL ,
`logout` text DEFAULT NULL ,
`decorateStash` text DEFAULT NULL ,
`charge` text DEFAULT NULL ,
`credit` varchar ( 50 ) DEFAULT NULL ,
`creditPrice` varchar ( 50 ) DEFAULT NULL ,
PRIMARY KEY ( `house` )
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;
CREATE TABLE ` house_plants ` (
`id` int ( 11 ) NOT NULL AUTO_INCREMENT,
`building` varchar ( 50 ) DEFAULT NULL ,
`stage` varchar ( 50 ) DEFAULT 'stage-a' ,
`sort` varchar ( 50 ) DEFAULT NULL ,
`gender` varchar ( 50 ) DEFAULT NULL ,
`food` int ( 11 ) DEFAULT 100 ,
`health` int ( 11 ) DEFAULT 100 ,
`progress` int ( 11 ) DEFAULT 0 ,
`coords` text DEFAULT NULL ,
`plantid` varchar ( 50 ) DEFAULT NULL ,
PRIMARY KEY ( `id` ),
KEY `building` ( `building` ),
KEY `plantid` ( `plantid` )
) ENGINE = InnoDB AUTO_INCREMENT = 7123 DEFAULT CHARSET = utf8mb4;
ALTER TABLE `houselocations` ADD IF NOT EXISTS `houseID` varchar ( 50 ) DEFAULT NULL ;
ALTER TABLE `player_houses` ADD IF NOT EXISTS `houseID` varchar ( 50 ) DEFAULT NULL ;
ALTER TABLE `player_houses` ADD IF NOT EXISTS `timer` int NULL DEFAULT '0' ;
ALTER TABLE `player_houses` CONVERT TO CHARACTER SET `utf8mb4` COLLATE `utf8mb4_general_ci` ;