index
:
evol/hercules
jak1/ci_fix
jak1/remove_unusable_console_output
master
rebased
test
tmphpm
The Mana World fork of Hercules. This is vanilla Hercules with a few tiny modifications for our specific needs. Mutually-beneficial modifications are contributed upstream.
root
summary
refs
log
tree
commit
diff
log msg
author
committer
range
path:
root
/
sql-files
/
main.sql
Age
Commit message (
Expand
)
Author
Files
Lines
2008-08-23
- Added column `mer_id` on char_db
zephyrus
1
-0
/
+1
2008-08-23
- Database structure for Mercenary.
zephyrus
1
-0
/
+15
2008-08-10
Removed 'DROP TABLE' statements from main.sql (bugreport:1714)
ultramage
1
-66
/
+33
2008-08-01
Removed unused guardian hp columns from the guild castles table in main.sql (...
ultramage
1
-8
/
+0
2008-07-26
Merged the /loginmerge branch (topic:192754)
ultramage
1
-21
/
+5
2008-06-23
* Fixed: replaced TYPEs with ENGINEs in SQL files (for better compatibility, ...
akrus
1
-2
/
+2
2008-04-13
Forgot to change main.sql to reflect the update to quest_objective table.
Kevin
1
-1
/
+2
2008-04-11
Reverted the `login` table changes from r12464
ultramage
1
-2
/
+2
2008-04-11
New sql definitions for the quest code.
Kevin
1
-7
/
+4
2008-04-10
Char server now loads/saves quest information.
Kevin
1
-0
/
+28
2008-04-04
Replaced the TYPE keyword with ENGINE in all sql files, because this is the p...
ultramage
1
-28
/
+28
2008-04-03
Renamed 'connect_until_time' to 'expiration_time'.
ultramage
1
-2
/
+2
2008-03-05
- Added the auctiondb structure
zephyrus
1
-0
/
+27
2008-01-10
Fix to the sql files, password column length must be 32, to store md5 hashes =_=
ultramage
1
-1
/
+1
2008-01-10
Another round of login server cleaning
ultramage
1
-4
/
+4
2007-12-12
* Some preparations for the guild script update
ultramage
1
-7
/
+1
2007-11-07
- Some updates on the mail system packets [Zephyrus]
zephyrus
1
-1
/
+1
2007-10-30
- Updated the mail sql structure in main.sql.
zephyrus
1
-1
/
+1
2007-10-23
* Removed the inter_athena.conf maildb settings as they are not required anym...
zephyrus
1
-0
/
+28
2007-08-15
- Merged and completed Latio's work on server-side hot-key saving (http://www...
skotlex
1
-0
/
+15
2007-05-19
* Added Global chat and Main chat logging
ultramage
1
-1
/
+1
2007-05-19
* SQL files fixup
ultramage
1
-11
/
+8
2007-03-02
EOL-styled some more files
ultramage
1
-578
/
+578
2006-09-13
- Modified the login SQL server so that case insensitive lookups use "where n...
skotlex
1
-3
/
+7
2006-09-12
- Added manual deletion of sc_data entries when deleting a character (char-SQL)
skotlex
1
-29
/
+18
2006-09-05
- Fixed connect_until field being a smallint rather than int in the login tab...
skotlex
1
-1
/
+1
2006-08-10
- Fixed two instances in the login-sql server where the ip in the log-login t...
skotlex
1
-1
/
+1
2006-08-10
Fixed syntax error in 'guild' create table statement
toms
1
-1
/
+1
2006-08-08
- Fixed yet again AS_SPLASHER doing full damage on all characters. Now you ca...
skotlex
1
-1
/
+1
2006-07-20
SQL fix for Homunc skills
DracoRPG
1
-3
/
+4
2006-07-17
Orn's and Albator's Homunculus system, finally, YAY!!
DracoRPG
1
-540
/
+584
2006-07-08
- Fixed the char table having party/guild_id as smallint when they need int t...
skotlex
1
-2
/
+2
2006-06-16
sql optimizations.
Euph
1
-539
/
+540
2006-06-14
- Fixed main.sql adding a key on char_id rather than account_id for the char ...
skotlex
1
-1
/
+1
2006-06-14
Syntax errors :(
Lance
1
-1
/
+1
2006-06-13
- Updated mob_db.sql and item_db.sql to latest.
skotlex
1
-0
/
+1
2006-05-31
[Improved]:
Lance
1
-1
/
+1
2006-05-19
- Fixed loginlog definition in main.sql, thanks to Tempesta
skotlex
1
-2
/
+2
2006-05-11
- Fixed the definition of the KEY in the loginlog, thanks to TheUltraMage
skotlex
1
-1
/
+1
2006-05-09
- Fix on pc_skill which fixes overlapping when one gets more than one bonus f...
skotlex
1
-1
/
+2
2006-03-14
- Fixed the average_lv column size specification. Thanks to Joshuaali (upgrad...
skotlex
1
-3
/
+3
2006-03-04
- Some cleaning of the main.sql file
skotlex
1
-28
/
+28
2006-02-17
- Added an upgrade_svn file to fix the party sql table (it lacks the auto-inc...
skotlex
1
-1
/
+1
2006-02-16
- Updated the login/char sql servers to let the sql tables autogenerate the n...
skotlex
1
-14
/
+0
2006-01-29
AS OF SVN REV. 5901, WE ARE NOW USING TRUNK. ALL UNTESTED BUGFIXES/FEATURES ...
Valaris
1
-0
/
+551
2006-01-29
Clearing trunk.
Valaris
1
-501
/
+0
2005-02-10
Added a auto increment 'start' value in the main.sql file ^^[Sirius]
(no author)
1
-1
/
+1
2004-12-19
Added a friend0 column
codemaster
1
-0
/
+2
2004-11-29
removed a USE that should not be there
amber
1
-2
/
+1
2004-11-14
Fixed some file types
amber
1
-499
/
+499
[next]