diff options
| author | skotlex <skotlex@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2006-05-09 19:28:58 +0000 |
|---|---|---|
| committer | skotlex <skotlex@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2006-05-09 19:28:58 +0000 |
| commit | 3e87e8e3153ec82d1c3c2cea32dd910323949455 (patch) | |
| tree | d7bd52f160bf9a4d83c6b5a10f5a9d1e18c5439d /sql-files/upgrade_svn6533.sql | |
| parent | d0a7c2090946362a77301684f50e2c350b0e2218 (diff) | |
| download | hercules-3e87e8e3153ec82d1c3c2cea32dd910323949455.tar.gz hercules-3e87e8e3153ec82d1c3c2cea32dd910323949455.tar.bz2 hercules-3e87e8e3153ec82d1c3c2cea32dd910323949455.tar.xz hercules-3e87e8e3153ec82d1c3c2cea32dd910323949455.zip | |
- Fix on pc_skill which fixes overlapping when one gets more than one bonus for the same skill.
- Updated main.sql's loginlog table structure.
- Added svn_update6533.sql to update the loginlog structure as suggested by theultramage.
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6533 54d463be-8e91-2dee-dedb-b68131a5f0ec
Diffstat (limited to 'sql-files/upgrade_svn6533.sql')
| -rw-r--r-- | sql-files/upgrade_svn6533.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/sql-files/upgrade_svn6533.sql b/sql-files/upgrade_svn6533.sql new file mode 100644 index 000000000..5dffe0293 --- /dev/null +++ b/sql-files/upgrade_svn6533.sql @@ -0,0 +1,2 @@ +ALTER TABLE `loginlog` CHANGE `ip` `ip` CHAR( 15 ) NOT NULL
+ALTER TABLE `loginlog` ADD INDEX ( `ip` ( 15 ) )
|