STEP 3
Add tables and columns to DB
Installer try to add new tables and columns to database.
Query: ALTER TABLE `accounts` ADD `key` VARCHAR(20) NOT NULL DEFAULT '0'
SQLSTATE: 42S21
Driver code: 1060
Error message: Duplicate column name 'key'
Could not add column key to table accounts. Already exist?
Query: ALTER TABLE `accounts` ADD `email_new` VARCHAR(255) NOT NULL DEFAULT ''
SQLSTATE: 42S21
Driver code: 1060
Error message: Duplicate column name 'email_new'
Could not add column email_new to table accounts. Already exist?
Query: ALTER TABLE `accounts` ADD `email_new_time` INT(11) NOT NULL DEFAULT '0'
SQLSTATE: 42S21
Driver code: 1060
Error message: Duplicate column name 'email_new_time'
Could not add column email_new_time to table accounts. Already exist?
Query: ALTER TABLE `accounts` ADD `rlname` VARCHAR(255) NOT NULL DEFAULT ''
SQLSTATE: 42S21
Driver code: 1060
Error message: Duplicate column name 'rlname'
Could not add column rlname to table accounts. Already exist?
Query: ALTER TABLE `accounts` ADD `location` VARCHAR(255) NOT NULL DEFAULT ''
SQLSTATE: 42S21
Driver code: 1060
Error message: Duplicate column name 'location'
Could not add column location to table accounts. Already exist?
Query: ALTER TABLE `accounts` ADD `page_access` INT(11) NOT NULL DEFAULT '0'
SQLSTATE: 42S21
Driver code: 1060
Error message: Duplicate column name 'page_access'
Could not add column page_access to table accounts. Already exist?
Query: ALTER TABLE `accounts` ADD `email_code` VARCHAR(255) NOT NULL DEFAULT ''
SQLSTATE: 42S21
Driver code: 1060
Error message: Duplicate column name 'email_code'
Could not add column email_code to table accounts. Already exist?
Query: ALTER TABLE `accounts` ADD `next_email` INT(11) NOT NULL DEFAULT '0'
SQLSTATE: 42S21
Driver code: 1060
Error message: Duplicate column name 'next_email'
Could not add column next_email to table accounts. Already exist?
Query: ALTER TABLE `accounts` ADD `premium_points` INT(11) NOT NULL DEFAULT '0'
SQLSTATE: 42S21
Driver code: 1060
Error message: Duplicate column name 'premium_points'
Could not add column premium_points to table accounts. Already exist?
Query: ALTER TABLE `accounts` ADD `create_date` INT(11) NOT NULL DEFAULT '0'
SQLSTATE: 42S21
Driver code: 1060
Error message: Duplicate column name 'create_date'
Could not add column create_date to table accounts. Already exist?
Query: ALTER TABLE `accounts` ADD `create_ip` INT(11) NOT NULL DEFAULT '0'
SQLSTATE: 42S21
Driver code: 1060
Error message: Duplicate column name 'create_ip'
Could not add column create_ip to table accounts. Already exist?
Query: ALTER TABLE `accounts` ADD `last_post` INT(11) NOT NULL DEFAULT '0'
SQLSTATE: 42S21
Driver code: 1060
Error message: Duplicate column name 'last_post'
Could not add column last_post to table accounts. Already exist?
Query: ALTER TABLE `accounts` ADD `flag` VARCHAR(80) NOT NULL DEFAULT ''
SQLSTATE: 42S21
Driver code: 1060
Error message: Duplicate column name 'flag'
Could not add column flag to table accounts. Already exist?
Query: ALTER TABLE `guilds` ADD `description` TEXT NOT NULL DEFAULT ''
SQLSTATE: 42S21
Driver code: 1060
Error message: Duplicate column name 'description'
Could not add column description to table guilds. Already exist?
Query: ALTER TABLE `guilds` ADD `guild_logo` MEDIUMBLOB NULL DEFAULT NULL
SQLSTATE: 42S21
Driver code: 1060
Error message: Duplicate column name 'guild_logo'
Query: ALTER TABLE `guilds` ADD `guild_logo` MEDIUMBLOB NOT NULL DEFAULT ''
SQLSTATE: 42S21
Driver code: 1060
Error message: Duplicate column name 'guild_logo'
Could not add column guild_logo to table guilds. Already exist?
Query: ALTER TABLE `guilds` ADD `create_ip` INT(11) NOT NULL DEFAULT '0'
SQLSTATE: 42S21
Driver code: 1060
Error message: Duplicate column name 'create_ip'
Could not add column create_ip to table guilds. Already exist?
Query: ALTER TABLE `guilds` ADD `balance` BIGINT UNSIGNED NOT NULL DEFAULT '0'
SQLSTATE: 42S21
Driver code: 1060
Error message: Duplicate column name 'balance'
Could not add column balance to table guilds. Already exist?
Query: ALTER TABLE `players` ADD `deleted` TINYINT(1) NOT NULL DEFAULT '0'
SQLSTATE: 42S21
Driver code: 1060
Error message: Duplicate column name 'deleted'
Could not add column deleted to table players. Already exist?
Query: ALTER TABLE `players` ADD `description` VARCHAR(255) NOT NULL DEFAULT ''
SQLSTATE: 42S21
Driver code: 1060
Error message: Duplicate column name 'description'
Could not add column description to table players. Already exist?
Query: ALTER TABLE `players` ADD `comment` TEXT NOT NULL DEFAULT ''
SQLSTATE: 42S21
Driver code: 1060
Error message: Duplicate column name 'comment'
Could not add column comment to table players. Already exist?
Query: ALTER TABLE `players` ADD `create_ip` INT(11) NOT NULL DEFAULT '0'
SQLSTATE: 42S21
Driver code: 1060
Error message: Duplicate column name 'create_ip'
Could not add column create_ip to table players. Already exist?
Query: ALTER TABLE `players` ADD `create_date` INT(11) NOT NULL DEFAULT '0'
SQLSTATE: 42S21
Driver code: 1060
Error message: Duplicate column name 'create_date'
Could not add column create_date to table players. Already exist?
Query: ALTER TABLE `players` ADD `hide_char` INT(11) NOT NULL DEFAULT '0'
SQLSTATE: 42S21
Driver code: 1060
Error message: Duplicate column name 'hide_char'
Could not add column hide_char to table players. Already exist?
Query: CREATE TABLE `z_ots_comunication` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL, `type` varchar(255) NOT NULL, `action` varchar(255) NOT NULL, `param1` varchar(255) NOT NULL, `param2` varchar(255) NOT NULL, `param3` varchar(255) NOT NULL, `param4` varchar(255) NOT NULL, `param5` varchar(255) NOT NULL, `param6` varchar(255) NOT NULL, `param7` varchar(255) NOT NULL, `delete_it` int(2) NOT NULL default '1', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SQLSTATE: 42S01
Driver code: 1050
Error message: Table 'z_ots_comunication' already exists
Could not create table z_ots_comunication. Already exist?
Query: CREATE TABLE `z_shop_offer` ( `id` int(11) NOT NULL auto_increment, `points` int(11) NOT NULL default '0', `itemid1` int(11) NOT NULL default '0', `count1` int(11) NOT NULL default '0', `itemid2` int(11) NOT NULL default '0', `count2` int(11) NOT NULL default '0', `offer_type` varchar(255) default NULL, `offer_description` text NOT NULL, `offer_name` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SQLSTATE: 42S01
Driver code: 1050
Error message: Table 'z_shop_offer' already exists
Could not create table z_shop_offer. Already exist?
Query: CREATE TABLE `z_shop_history_item` ( `id` int(11) NOT NULL auto_increment, `to_name` varchar(255) NOT NULL default '0', `to_account` int(11) NOT NULL default '0', `from_nick` varchar(255) NOT NULL, `from_account` int(11) NOT NULL default '0', `price` int(11) NOT NULL default '0', `offer_id` varchar(255) NOT NULL default '', `trans_state` varchar(255) NOT NULL, `trans_start` int(11) NOT NULL default '0', `trans_real` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SQLSTATE: 42S01
Driver code: 1050
Error message: Table 'z_shop_history_item' already exists
Could not create table z_shop_history_item. Already exist?
Query: CREATE TABLE `z_forum` ( `id` int(11) NOT NULL auto_increment, `first_post` int(11) NOT NULL default '0', `last_post` int(11) NOT NULL default '0', `section` int(3) NOT NULL default '0', `replies` int(20) NOT NULL default '0', `views` int(20) NOT NULL default '0', `author_aid` int(20) NOT NULL default '0', `author_guid` int(20) NOT NULL default '0', `post_text` text NOT NULL, `post_topic` varchar(255) NOT NULL, `post_smile` tinyint(1) NOT NULL default '0', `post_date` int(20) NOT NULL default '0', `last_edit_aid` int(20) NOT NULL default '0', `edit_date` int(20) NOT NULL default '0', `post_ip` varchar(15) NOT NULL default '0.0.0.0', PRIMARY KEY (`id`), KEY `section` (`section`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SQLSTATE: 42S01
Driver code: 1050
Error message: Table 'z_forum' already exists
Could not create table z_forum. Already exist?
Tables and columns added to database.
Go to STEP 4 - Add samples