summaryrefslogtreecommitdiff
path: root/sql-files/upgrades/rAthena-main-upgrade.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql-files/upgrades/rAthena-main-upgrade.sql')
-rw-r--r--sql-files/upgrades/rAthena-main-upgrade.sql165
1 files changed, 94 insertions, 71 deletions
diff --git a/sql-files/upgrades/rAthena-main-upgrade.sql b/sql-files/upgrades/rAthena-main-upgrade.sql
index 266b61fd0..f00386207 100644
--- a/sql-files/upgrades/rAthena-main-upgrade.sql
+++ b/sql-files/upgrades/rAthena-main-upgrade.sql
@@ -4,9 +4,9 @@
-- Remember to make a backup before applying.
-- We are not liable for any data loss this may cause.
-- Apply in the same database you applied your main.sql
--- Last revised: March 26, 2014 12:57 GMT
+-- Last revised: July 22, 2014 21:45 GMT
--- Drop table contents from ´sc_data´ since we use a different status order than rAthena
+-- Drop table contents from `sc_data` since we use a different status order than rAthena
-- /!\ WARNING /!\ This will remove _ALL_ of the status effects active on the server
-- You can disable this, but this is a SECURITY MEASURE
-- This will remove even jailed status from users!
@@ -15,51 +15,76 @@ TRUNCATE TABLE `sc_data`;
-- Drop table `skillcooldown` since it's not used in Hercules
DROP TABLE IF EXISTS `skillcooldown`;
+-- Upgrades for table `auction`
+ALTER TABLE `auction` MODIFY `nameid` INT(11) NOT NULL DEFAULT '0',
+ MODIFY `card0` SMALLINT(11) NOT NULL DEFAULT '0',
+ MODIFY `card1` SMALLINT(11) NOT NULL DEFAULT '0',
+ MODIFY `card2` SMALLINT(11) NOT NULL DEFAULT '0',
+ MODIFY `card3` SMALLINT(11) NOT NULL DEFAULT '0';
-- Upgrades for table `cart_inventory`
-ALTER TABLE `cart_inventory` MODIFY `bound` tinyint(1) unsigned NOT NULL default '0';
-
+ALTER TABLE `cart_inventory` MODIFY `nameid` INT(11) NOT NULL DEFAULT '0',
+ MODIFY `card0` SMALLINT(11) NOT NULL DEFAULT '0',
+ MODIFY `card1` SMALLINT(11) NOT NULL DEFAULT '0',
+ MODIFY `card2` SMALLINT(11) NOT NULL DEFAULT '0',
+ MODIFY `card3` SMALLINT(11) NOT NULL DEFAULT '0',
+ MODIFY `bound` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0';
-- Upgrades for table `char`
-ALTER TABLE `char` CHANGE `moves` `slotchange` SMALLINT(3) UNSIGNED NOT NULL default '0',
- ADD `char_opt` INT( 11 ) UNSIGNED NOT NULL default '0' AFTER `slotchange`,
- ADD `font` TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `char_opt`;
-
+ALTER TABLE `char` CHANGE `moves` `slotchange` SMALLINT(3) UNSIGNED NOT NULL DEFAULT '0',
+ ADD `char_opt` INT(11) UNSIGNED NOT NULL DEFAULT '0' AFTER `slotchange`,
+ MODIFY `font` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `char_opt`,
+ ADD `uniqueitem_counter` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' AFTER `unban_time`;
-- Upgrades for table `charlog`
-ALTER TABLE `charlog` ADD COLUMN `char_id` int(11) unsigned NOT NULL default '0' AFTER `account_id`;
-
+ALTER TABLE `charlog` ADD COLUMN `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0' AFTER `account_id`;
-- Upgrades for table `guild_storage`
-ALTER TABLE `guild_storage` MODIFY `bound` tinyint(1) unsigned NOT NULL default '0';
-
+ALTER TABLE `guild_storage` MODIFY `nameid` INT(11) NOT NULL DEFAULT '0',
+ MODIFY `card0` SMALLINT(11) NOT NULL DEFAULT '0',
+ MODIFY `card1` SMALLINT(11) NOT NULL DEFAULT '0',
+ MODIFY `card2` SMALLINT(11) NOT NULL DEFAULT '0',
+ MODIFY `card3` SMALLINT(11) NOT NULL DEFAULT '0',
+ MODIFY `bound` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0';
-- Upgrades for table `inventory`
-ALTER TABLE `inventory` MODIFY `bound` tinyint(1) unsigned NOT NULL default '0';
-
+ALTER TABLE `inventory` MODIFY `nameid` INT(11) NOT NULL DEFAULT '0',
+ MODIFY `card0` SMALLINT(11) NOT NULL DEFAULT '0',
+ MODIFY `card1` SMALLINT(11) NOT NULL DEFAULT '0',
+ MODIFY `card2` SMALLINT(11) NOT NULL DEFAULT '0',
+ MODIFY `card3` SMALLINT(11) NOT NULL DEFAULT '0',
+ MODIFY `bound` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0';
-- Login table will be upgraded at a later point on this file
-- so that we can save the bank vault.
+-- Upgrades for table `mail`
+ALTER TABLE `mail` MODIFY `nameid` INT(11) NOT NULL DEFAULT '0',
+ MODIFY `card0` SMALLINT(11) NOT NULL DEFAULT '0',
+ MODIFY `card1` SMALLINT(11) NOT NULL DEFAULT '0',
+ MODIFY `card2` SMALLINT(11) NOT NULL DEFAULT '0',
+ MODIFY `card3` SMALLINT(11) NOT NULL DEFAULT '0';
-- Upgrades for table `mapreg`
-ALTER TABLE `mapreg` MODIFY `varname` varchar(32) BINARY NOT NULL,
+ALTER TABLE `mapreg` MODIFY `varname` VARCHAR(32) BINARY NOT NULL,
DROP KEY `varname`,
DROP KEY `index`,
- ADD PRIMARY KEY (`varname`,`index`);
+ ADD PRIMARY KEY (`varname`,`index`);
+
+-- Upgrades for table `pet`
+ALTER TABLE `pet` MODIFY `egg_id` SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0';
-- Upgrades for table `sc_data`
ALTER TABLE `sc_data` ADD PRIMARY KEY (`account_id`,`char_id`,`type`);
-
--
-- Table structure for table `sql_updates`
--
CREATE TABLE IF NOT EXISTS `sql_updates` (
- `timestamp` int(11) unsigned NOT NULL,
- `ignored` enum('Yes','No') NOT NULL DEFAULT 'No',
+ `timestamp` INT(11) UNSIGNED NOT NULL,
+ `ignored` ENUM('Yes','No') NOT NULL DEFAULT 'No',
PRIMARY KEY (`timestamp`)
) ENGINE=MyISAM;
@@ -88,22 +113,28 @@ INSERT INTO `sql_updates` (`timestamp`) VALUES (1388854043); -- 2014-01-04--16-4
INSERT INTO `sql_updates` (`timestamp`) VALUES (1389028967); -- 2014-01-06--17-22.sql
INSERT INTO `sql_updates` (`timestamp`) VALUES (1392832626); -- 2014-02-19--17-57.sql
INSERT INTO `sql_updates` (`timestamp`) VALUES (1395789302); -- 2014-03-25--23-57.sql
-
+INSERT INTO `sql_updates` (`timestamp`) VALUES (1396893866); -- 2014-04-07--22-04.sql
+INSERT INTO `sql_updates` (`timestamp`) VALUES (1398477600); -- 2014-04-26--10-00.sql
+INSERT INTO `sql_updates` (`timestamp`) VALUES (1400256139); -- 2014-05-17--00-06.sql
-- Updates to table `storage`
-ALTER TABLE `storage` MODIFY `bound` tinyint(1) unsigned NOT NULL default '0';
-
+ALTER TABLE `storage` MODIFY `nameid` INT(11) NOT NULL DEFAULT '0',
+ MODIFY `card0` SMALLINT(11) NOT NULL DEFAULT '0',
+ MODIFY `card1` SMALLINT(11) NOT NULL DEFAULT '0',
+ MODIFY `card2` SMALLINT(11) NOT NULL DEFAULT '0',
+ MODIFY `card3` SMALLINT(11) NOT NULL DEFAULT '0',
+ MODIFY `bound` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0';
--
-- Table structure for table `account_data`
--
CREATE TABLE IF NOT EXISTS `account_data` (
- `account_id` int(11) unsigned NOT NULL default '0',
- `bank_vault` int(11) unsigned NOT NULL default '0',
- `base_exp` TINYINT( 4 ) UNSIGNED NOT NULL default '100',
- `base_drop` TINYINT( 4 ) UNSIGNED NOT NULL default '100',
- `base_death` TINYINT( 4 ) UNSIGNED NOT NULL default '100',
+ `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+ `bank_vault` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+ `base_exp` TINYINT( 4 ) UNSIGNED NOT NULL DEFAULT '100',
+ `base_drop` TINYINT( 4 ) UNSIGNED NOT NULL DEFAULT '100',
+ `base_death` TINYINT( 4 ) UNSIGNED NOT NULL DEFAULT '100',
PRIMARY KEY (`account_id`)
) ENGINE=MyISAM;
@@ -111,29 +142,25 @@ CREATE TABLE IF NOT EXISTS `account_data` (
-- to our account_data table. There may be some not working cases.
INSERT INTO `account_data` (`account_id`, `bank_vault`) SELECT `account_id`, `bank_vault` FROM `login` WHERE `bank_vault` > 0 ;
-
-- Upgrades for table `login`
ALTER TABLE `login` DROP COLUMN `vip_time`,
DROP COLUMN `old_group`,
DROP COLUMN `bank_vault`;
-
-- Drop table `bonus_script` since it's not used in Hercules
DROP TABLE IF EXISTS `bonus_script`;
-
--
-- Table structure for table `npc_market_data`
--
CREATE TABLE IF NOT EXISTS `npc_market_data` (
- `name` varchar(24) NOT NULL default '',
- `itemid` int(11) unsigned NOT NULL default '0',
- `amount` int(11) unsigned NOT NULL default '0',
- PRIMARY KEY (`name`,`itemid`)
+ `name` VARCHAR(24) NOT NULL DEFAULT '',
+ `itemid` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+ `amount` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+ PRIMARY KEY (`name`,`itemid`)
) ENGINE=MyISAM;
-
-- Autotrade saving. Very special thanks to Dastgir Pojee!
--
-- Vending Database Update
@@ -155,7 +182,7 @@ ALTER TABLE `vending_items`
MODIFY `price` INT(11) NOT NULL DEFAULT '0';
ALTER TABLE `vending_items`
- ADD PRIMARY KEY( `char_id`, `itemkey`);
+ ADD PRIMARY KEY ( `char_id`, `itemkey`);
RENAME TABLE `vending_items` TO `autotrade_data`;
@@ -205,11 +232,11 @@ DROP TABLE IF EXISTS `buyingstores`, `buyingstore_items`;
--
CREATE TABLE IF NOT EXISTS `acc_reg_num_db` (
- `account_id` int(11) unsigned NOT NULL default '0',
- `key` varchar(32) BINARY NOT NULL default '',
- `index` int(11) unsigned NOT NULL default '0',
- `value` int(11) NOT NULL default '0',
- PRIMARY KEY (`account_id`,`key`,`index`),
+ `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+ `key` VARCHAR(32) BINARY NOT NULL DEFAULT '',
+ `index` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+ `value` INT(11) NOT NULL DEFAULT '0',
+ PRIMARY KEY (`account_id`,`key`,`index`),
KEY `account_id` (`account_id`)
) ENGINE=MyISAM;
@@ -219,71 +246,66 @@ CREATE TABLE IF NOT EXISTS `acc_reg_num_db` (
--
CREATE TABLE IF NOT EXISTS `acc_reg_str_db` (
- `account_id` int(11) unsigned NOT NULL default '0',
- `key` varchar(32) BINARY NOT NULL default '',
- `index` int(11) unsigned NOT NULL default '0',
- `value` varchar(254) NOT NULL default '0',
- PRIMARY KEY (`account_id`,`key`,`index`),
+ `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+ `key` VARCHAR(32) BINARY NOT NULL DEFAULT '',
+ `index` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+ `value` VARCHAR(254) NOT NULL DEFAULT '0',
+ PRIMARY KEY (`account_id`,`key`,`index`),
KEY `account_id` (`account_id`)
) ENGINE=MyISAM;
-
--
-- Table structure for table `char_reg_num_db`
--
CREATE TABLE IF NOT EXISTS `char_reg_num_db` (
- `char_id` int(11) unsigned NOT NULL default '0',
- `key` varchar(32) BINARY NOT NULL default '',
- `index` int(11) unsigned NOT NULL default '0',
- `value` int(11) NOT NULL default '0',
- PRIMARY KEY (`char_id`,`key`,`index`),
+ `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+ `key` VARCHAR(32) BINARY NOT NULL DEFAULT '',
+ `index` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+ `value` INT(11) NOT NULL DEFAULT '0',
+ PRIMARY KEY (`char_id`,`key`,`index`),
KEY `char_id` (`char_id`)
) ENGINE=MyISAM;
-
--
-- Table structure for table `char_reg_str_db`
--
CREATE TABLE IF NOT EXISTS `char_reg_str_db` (
- `char_id` int(11) unsigned NOT NULL default '0',
- `key` varchar(32) BINARY NOT NULL default '',
- `index` int(11) unsigned NOT NULL default '0',
- `value` varchar(254) NOT NULL default '0',
- PRIMARY KEY (`char_id`,`key`,`index`),
+ `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+ `key` VARCHAR(32) BINARY NOT NULL DEFAULT '',
+ `index` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+ `value` VARCHAR(254) NOT NULL DEFAULT '0',
+ PRIMARY KEY (`char_id`,`key`,`index`),
KEY `char_id` (`char_id`)
) ENGINE=MyISAM;
-
--
-- Table structure for table `global_acc_reg_num_db`
--
CREATE TABLE IF NOT EXISTS `global_acc_reg_num_db` (
- `account_id` int(11) unsigned NOT NULL default '0',
- `key` varchar(32) BINARY NOT NULL default '',
- `index` int(11) unsigned NOT NULL default '0',
- `value` int(11) NOT NULL default '0',
- PRIMARY KEY (`account_id`,`key`,`index`),
+ `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+ `key` VARCHAR(32) BINARY NOT NULL DEFAULT '',
+ `index` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+ `value` INT(11) NOT NULL DEFAULT '0',
+ PRIMARY KEY (`account_id`,`key`,`index`),
KEY `account_id` (`account_id`)
) ENGINE=MyISAM;
-
--
-- Table structure for table `global_acc_reg_str_db`
--
CREATE TABLE IF NOT EXISTS `global_acc_reg_str_db` (
- `account_id` int(11) unsigned NOT NULL default '0',
- `key` varchar(32) BINARY NOT NULL default '',
- `index` int(11) unsigned NOT NULL default '0',
- `value` varchar(254) NOT NULL default '0',
- PRIMARY KEY (`account_id`,`key`,`index`),
+ `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+ `key` VARCHAR(32) BINARY NOT NULL DEFAULT '',
+ `index` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+ `value` VARCHAR(254) NOT NULL DEFAULT '0',
+ PRIMARY KEY (`account_id`,`key`,`index`),
KEY `account_id` (`account_id`)
) ENGINE=MyISAM;
-
-- Saving the data
INSERT INTO `acc_reg_num_db` (`account_id`, `key`, `index`, `value`) SELECT `account_id`, `str`, 0, `value` FROM `global_reg_value` WHERE `type` = 2 AND `str` NOT LIKE '%$';
INSERT INTO `acc_reg_str_db` (`account_id`, `key`, `index`, `value`) SELECT `account_id`, `str`, 0, `value` FROM `global_reg_value` WHERE `type` = 2 AND `str` LIKE '%$';
@@ -294,3 +316,4 @@ INSERT INTO `global_acc_reg_str_db` (`account_id`, `key`, `index`, `value`) SELE
-- Dropping now useless table
DROP TABLE `global_reg_value`;
+
generated by cgit v1.2.3-60-g2f50 (git 2.42.0) at 2024-08-07 16:26:26 +0000