- Added an upgrade_svn file to fix the party sql table (it lacks the auto-increment property on the party_id column)

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@5311 54d463be-8e91-2dee-dedb-b68131a5f0ec

3 files changed, 5 insertions, 1 deletions

diff --git a/Changelog-Trunk.txt b/Changelog-Trunk.txt
index ba5114dc8..26870c228 100644
--- a/Changelog-Trunk.txt
+++ b/Changelog-Trunk.txt
@@ -5,6 +5,9 @@ IF YOU HAVE A WORKING AND TESTED BUGFIX PUT IT INTO STABLE AS WELL AS TRUNK.  EV
 GOES INTO TRUNK AND WILL BE MERGED INTO STABLE BY VALARIS AND WIZPUTER. -- VALARIS

 

 2006/02/17

+	* Added an upgrade_svn file that should fix the party table by making the

+	  party_id auto-incremental. Apply this or new parties will always fail!

+	  [Skotlex]

 	* Changed around the included files in irc.c to see if it compiles under

 	  Win32 native. [Skotlex]

 	* Char-SQL server updates: [Skotlex]

diff --git a/sql-files/main.sql b/sql-files/main.sql
index 927e8248f..e99c66787 100644
--- a/sql-files/main.sql
+++ b/sql-files/main.sql
@@ -433,7 +433,7 @@ CREATE TABLE `memo` (
 

 DROP TABLE IF EXISTS `party`;

 CREATE TABLE `party` (

-  `party_id` int(11) unsigned NOT NULL default '100',

+  `party_id` int(11) unsigned NOT NULL auto_increment,

   `name` char(100) NOT NULL default '',

   `exp` tinyint(11) unsigned NOT NULL default '0',

   `item` tinyint(11) unsigned NOT NULL default '0',

diff --git a/sql-files/upgrade_svn5311.sql b/sql-files/upgrade_svn5311.sql
new file mode 100644
index 000000000..e7b4db9a4
--- /dev/null
+++ b/sql-files/upgrade_svn5311.sql
@@ -0,0 +1 @@
+ALTER TABLE `party` MODIFY `party_id` int(11) unsigned NOT NULL auto_increment;