From 581475bc6416790765c498aa3d611f6868ffb64a Mon Sep 17 00:00:00 2001
From: amber <amber@54d463be-8e91-2dee-dedb-b68131a5f0ec>
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

