From 581475bc6416790765c498aa3d611f6868ffb64a Mon Sep 17 00:00:00 2001 From: amber Date: Sun, 14 Nov 2004 16:18:26 +0000 Subject: Fixed some file types git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/athena@172 54d463be-8e91-2dee-dedb-b68131a5f0ec --- sql-files/upgrade_817.sql | 206 +++++++++++++++++++++++----------------------- 1 file changed, 103 insertions(+), 103 deletions(-) (limited to 'sql-files/upgrade_817.sql') diff --git a/sql-files/upgrade_817.sql b/sql-files/upgrade_817.sql index a407d2669..305254388 100644 --- a/sql-files/upgrade_817.sql +++ b/sql-files/upgrade_817.sql @@ -1,103 +1,103 @@ -# Upgrade database for version 817 to 0.5.2 - -#DROP TABLE `charlog`; -#DROP TABLE `interlog`; -#DROP TABLE `guild_storage`; - -ALTER TABLE `global_reg_value` DROP COLUMN `type`; -ALTER TABLE `global_reg_value` DROP COLUMN `account_id`; - -# -------------------------------------------------------------- -# Fix the bug that some fields cannot exceed 127 -ALTER TABLE `char` MODIFY `str` int(11) unsigned NOT NULL; -ALTER TABLE `char` MODIFY `agi` int(11) unsigned NOT NULL; -ALTER TABLE `char` MODIFY `vit` int(11) unsigned NOT NULL; -ALTER TABLE `char` MODIFY `int` int(11) unsigned NOT NULL; -ALTER TABLE `char` MODIFY `dex` int(11) unsigned NOT NULL; -ALTER TABLE `char` MODIFY `luk` int(11) unsigned NOT NULL; -ALTER TABLE `char` MODIFY `base_level` int(11) unsigned NOT NULL default '1'; -ALTER TABLE `char` MODIFY `job_level` int(11) unsigned NOT NULL default '1'; - -# -------------------------------------------------------------------- -# Bug fix : wrong index -ALTER TABLE `storage` DROP INDEX `char_id`, ADD INDEX (`account_id`); - -# ---------------------------------------------------------------- -# Add log tables - - -# Table: `charlog` -# -CREATE TABLE `charlog` ( - `time` datetime NOT NULL default '0000-00-00 00:00:00', - `char_msg` varchar(255) NOT NULL default 'char select', - `account_id` int(11) NOT NULL default '0', - `char_num` tinyint(4) NOT NULL default '0', - `name` varchar(255) NOT NULL default '', - `str` int(11) unsigned NOT NULL default '0', - `agi` int(11) unsigned NOT NULL default '0', - `vit` int(11) unsigned NOT NULL default '0', - `int` int(11) unsigned NOT NULL default '0', - `dex` int(11) unsigned NOT NULL default '0', - `luk` int(11) unsigned NOT NULL default '0', - `hair` tinyint(4) NOT NULL default '0', - `hair_color` int(11) NOT NULL default '0' -) TYPE=MyISAM; - -# Table: 'interlog' -# -CREATE TABLE `interlog` ( - `time` datetime NOT NULL default '0000-00-00 00:00:00', - `log` varchar(255) NOT NULL default '' -) TYPE=MyISAM; - -# ---------------------------------------------------------- -# Add new table guild_storage - - -# Table: 'guild_storage' -# -CREATE TABLE `guild_storage` ( - `id` int(10) unsigned NOT NULL auto_increment, - `guild_id` int(11) NOT NULL default '0', - `nameid` int(11) NOT NULL default '0', - `amount` int(11) NOT NULL default '0', - `equip` mediumint(8) unsigned NOT NULL default '0', - `identify` smallint(6) NOT NULL default '0', - `refine` tinyint(3) unsigned NOT NULL default '0', - `attribute` tinyint(4) NOT NULL default '0', - `card0` int(11) NOT NULL default '0', - `card1` int(11) NOT NULL default '0', - `card2` int(11) NOT NULL default '0', - `card3` int(11) NOT NULL default '0', - PRIMARY KEY (`id`), - KEY `guild_id` (`guild_id`) -) TYPE=MyISAM; - -# ------------------------------------------------------------------- -# Change global_reg_value table -# type = 1 account_reg for all connected map-server ( like Chaos Loki Sakary ) -# type = 2 account_reg for current map-server -# type = 3 char_reg for current map-server - -ALTER TABLE `global_reg_value` ADD `type` int(11) NOT NULL default '3'; -ALTER TABLE `global_reg_value` ADD `account_id` int(11) NOT NULL default '0', ADD INDEX (`account_id`); - -ALTER TABLE `guild_member` CHANGE `exp` `exp` BIGINT DEFAULT '0' NOT NULL; - -ALTER TABLE `login` CHANGE `email` `email` varchar(100) NOT NULL default 'user@athena'; -ALTER TABLE `login` CHANGE `user_pass` `user_pass` varchar(32) NOT NULL default '0'; - -ALTER TABLE `char` CHANGE `class` `class` int(11) NOT NULL default '0'; - -DROP TABLE `ragsrvinfo`; - -CREATE TABLE `ragsrvinfo` ( - `index` int(11) NOT NULL default '0', - `name` varchar(255) NOT NULL default '', - `exp` int(11) NOT NULL default '0', - `jexp` int(11) NOT NULL default '0', - `drop` int(11) NOT NULL default '0', - `motd` varchar(255) NOT NULL default '' -) TYPE=MyISAM; - +# Upgrade database for version 817 to 0.5.2 + +#DROP TABLE `charlog`; +#DROP TABLE `interlog`; +#DROP TABLE `guild_storage`; + +ALTER TABLE `global_reg_value` DROP COLUMN `type`; +ALTER TABLE `global_reg_value` DROP COLUMN `account_id`; + +# -------------------------------------------------------------- +# Fix the bug that some fields cannot exceed 127 +ALTER TABLE `char` MODIFY `str` int(11) unsigned NOT NULL; +ALTER TABLE `char` MODIFY `agi` int(11) unsigned NOT NULL; +ALTER TABLE `char` MODIFY `vit` int(11) unsigned NOT NULL; +ALTER TABLE `char` MODIFY `int` int(11) unsigned NOT NULL; +ALTER TABLE `char` MODIFY `dex` int(11) unsigned NOT NULL; +ALTER TABLE `char` MODIFY `luk` int(11) unsigned NOT NULL; +ALTER TABLE `char` MODIFY `base_level` int(11) unsigned NOT NULL default '1'; +ALTER TABLE `char` MODIFY `job_level` int(11) unsigned NOT NULL default '1'; + +# -------------------------------------------------------------------- +# Bug fix : wrong index +ALTER TABLE `storage` DROP INDEX `char_id`, ADD INDEX (`account_id`); + +# ---------------------------------------------------------------- +# Add log tables + + +# Table: `charlog` +# +CREATE TABLE `charlog` ( + `time` datetime NOT NULL default '0000-00-00 00:00:00', + `char_msg` varchar(255) NOT NULL default 'char select', + `account_id` int(11) NOT NULL default '0', + `char_num` tinyint(4) NOT NULL default '0', + `name` varchar(255) NOT NULL default '', + `str` int(11) unsigned NOT NULL default '0', + `agi` int(11) unsigned NOT NULL default '0', + `vit` int(11) unsigned NOT NULL default '0', + `int` int(11) unsigned NOT NULL default '0', + `dex` int(11) unsigned NOT NULL default '0', + `luk` int(11) unsigned NOT NULL default '0', + `hair` tinyint(4) NOT NULL default '0', + `hair_color` int(11) NOT NULL default '0' +) TYPE=MyISAM; + +# Table: 'interlog' +# +CREATE TABLE `interlog` ( + `time` datetime NOT NULL default '0000-00-00 00:00:00', + `log` varchar(255) NOT NULL default '' +) TYPE=MyISAM; + +# ---------------------------------------------------------- +# Add new table guild_storage + + +# Table: 'guild_storage' +# +CREATE TABLE `guild_storage` ( + `id` int(10) unsigned NOT NULL auto_increment, + `guild_id` int(11) NOT NULL default '0', + `nameid` int(11) NOT NULL default '0', + `amount` int(11) NOT NULL default '0', + `equip` mediumint(8) unsigned NOT NULL default '0', + `identify` smallint(6) NOT NULL default '0', + `refine` tinyint(3) unsigned NOT NULL default '0', + `attribute` tinyint(4) NOT NULL default '0', + `card0` int(11) NOT NULL default '0', + `card1` int(11) NOT NULL default '0', + `card2` int(11) NOT NULL default '0', + `card3` int(11) NOT NULL default '0', + PRIMARY KEY (`id`), + KEY `guild_id` (`guild_id`) +) TYPE=MyISAM; + +# ------------------------------------------------------------------- +# Change global_reg_value table +# type = 1 account_reg for all connected map-server ( like Chaos Loki Sakary ) +# type = 2 account_reg for current map-server +# type = 3 char_reg for current map-server + +ALTER TABLE `global_reg_value` ADD `type` int(11) NOT NULL default '3'; +ALTER TABLE `global_reg_value` ADD `account_id` int(11) NOT NULL default '0', ADD INDEX (`account_id`); + +ALTER TABLE `guild_member` CHANGE `exp` `exp` BIGINT DEFAULT '0' NOT NULL; + +ALTER TABLE `login` CHANGE `email` `email` varchar(100) NOT NULL default 'user@athena'; +ALTER TABLE `login` CHANGE `user_pass` `user_pass` varchar(32) NOT NULL default '0'; + +ALTER TABLE `char` CHANGE `class` `class` int(11) NOT NULL default '0'; + +DROP TABLE `ragsrvinfo`; + +CREATE TABLE `ragsrvinfo` ( + `index` int(11) NOT NULL default '0', + `name` varchar(255) NOT NULL default '', + `exp` int(11) NOT NULL default '0', + `jexp` int(11) NOT NULL default '0', + `drop` int(11) NOT NULL default '0', + `motd` varchar(255) NOT NULL default '' +) TYPE=MyISAM; + -- cgit v1.2.3-70-g09d2