Pages

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

Posts Quoted:
Reply
Clear All Quotes