From 63346b0e5fed404dc7becc01b8d829e69865f8cc Mon Sep 17 00:00:00 2001 From: ultramage Date: Sat, 21 Feb 2009 10:59:18 +0000 Subject: Corrected revision number for the previous upgrade script. Applied changes made inside the script to main.sql. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13542 54d463be-8e91-2dee-dedb-b68131a5f0ec --- sql-files/main.sql | 4 ++-- sql-files/upgrade_svn13540.sql | 2 -- sql-files/upgrade_svn13541.sql | 2 ++ 3 files changed, 4 insertions(+), 4 deletions(-) delete mode 100644 sql-files/upgrade_svn13540.sql create mode 100644 sql-files/upgrade_svn13541.sql (limited to 'sql-files') diff --git a/sql-files/main.sql b/sql-files/main.sql index f62b65baf..472f95edd 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -71,8 +71,8 @@ CREATE TABLE IF NOT EXISTS `char` ( `hp` mediumint(8) unsigned NOT NULL default '0', `max_sp` mediumint(6) unsigned NOT NULL default '0', `sp` mediumint(6) unsigned NOT NULL default '0', - `status_point` smallint(4) unsigned NOT NULL default '0', - `skill_point` smallint(4) unsigned NOT NULL default '0', + `status_point` int(11) unsigned NOT NULL default '0', + `skill_point` int(11) unsigned NOT NULL default '0', `option` int(11) NOT NULL default '0', `karma` tinyint(3) NOT NULL default '0', `manner` tinyint(3) NOT NULL default '0', diff --git a/sql-files/upgrade_svn13540.sql b/sql-files/upgrade_svn13540.sql deleted file mode 100644 index 1c770d074..000000000 --- a/sql-files/upgrade_svn13540.sql +++ /dev/null @@ -1,2 +0,0 @@ -ALTER TABLE `char` CHANGE `status_point` `status_point` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0'; -ALTER TABLE `char` CHANGE `skill_point` `skill_point` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0'; diff --git a/sql-files/upgrade_svn13541.sql b/sql-files/upgrade_svn13541.sql new file mode 100644 index 000000000..1c770d074 --- /dev/null +++ b/sql-files/upgrade_svn13541.sql @@ -0,0 +1,2 @@ +ALTER TABLE `char` CHANGE `status_point` `status_point` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0'; +ALTER TABLE `char` CHANGE `skill_point` `skill_point` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0'; -- cgit v1.2.3-70-g09d2