[TUTORIAL] Make Your Own Server Hive - Use 1 Database for multiple servers - update for 106

[kingpapawawa]

All credit for this tutorial goes to Gr8 

 

follow his directions with a couple of small edits...

CREATE TABLE IF NOT EXISTS `object_data_1` (
    `ObjectID` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
    `ObjectUID` BIGINT(24) NOT NULL DEFAULT '0',
    `Instance` INT(11) UNSIGNED NOT NULL,
    `Classname` VARCHAR(50) NULL DEFAULT NULL,
    `Datestamp` DATETIME NOT NULL,
    `LastUpdated` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `CharacterID` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', //change INT(11) to BIGINT(20)
    `Worldspace` VARCHAR(128) NOT NULL DEFAULT '[]',
    `Inventory` LONGTEXT NULL,
    `Hitpoints` VARCHAR(1024) NOT NULL DEFAULT '[]',  //change  512 to 1024
    `Fuel` DOUBLE(13,5) NOT NULL DEFAULT '1.00000',
    `Damage` DOUBLE(13,5) NOT NULL DEFAULT '0.00000',
    `StorageCoins` BIGINT(20) NOT NULL DEFAULT '0',  //add this line
    PRIMARY KEY (`ObjectID`),
    INDEX `ObjectUID` (`ObjectUID`) USING BTREE,
    INDEX `Instance` (`Instance`) USING BTREE
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
AUTO_INCREMENT=74383;