Updating from 1.x to 2.x
To update from 1.x to 2.x, you will need to perform a few commands.
First of all, typing /banexport update If you are running off a MySQL database, you will need to execute these queries:
CREATE TABLE `banhistory` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(32) NOT NULL, `reason` text NOT NULL, `admin` varchar(32) NOT NULL, `date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP, `IP` varchar(15) NOT NULL, PRIMARY KEY (`id`) ); CREATE TABLE `baninfo` ( `id` int(11) NOT NULL AUTO_INCREMENT, `player` varchar(32) NOT NULL, `information` text NOT NULL, `admin` varchar(32) NOT NULL, `x` int(4) NOT NULL, `y` int(4) NOT NULL, `z` int(4) NOT NULL, PRIMARY KEY (`id`) ); CREATE TABLE `warnings` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(30) NOT NULL, `warning` text NOT NULL, `admin` varchar(30) NOT NULL, PRIMARY KEY (`id`) ) ;
Once that is done, start up your server and type in /banexport update. This will transfer all the additional information. Once that is done, execute this query:
ALTER TABLE `banlist` DROP COLUMN `additional`;
Now you should be good to go!
Note, if running off SQLite, it will do this for you automatically.
Comments