diff options
| -rw-r--r-- | Changelog-Trunk.txt | 3 | ||||
| -rw-r--r-- | sql-files/main.sql | 2 | ||||
| -rw-r--r-- | sql-files/upgrade_svn5311.sql | 1 |
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;
|