index
:
ml/hercules
tmw2
Hercules
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
2010-02-09
Expanded range for cached and stored-in-db guild member exp (devotion) from u...
Paradox924X
1
-1
/
+1
2009-10-12
Added missing sql update file for rename
Inkfish
1
-0
/
+1
2009-09-04
forget to update main.sql
Inkfish
1
-3
/
+0
2009-07-26
* Some updates of Quest Log system
Inkfish
1
-15
/
+9
2009-03-15
Corrected the `char` table's 'manner' column type to match the type used by t...
ultramage
1
-1
/
+1
2009-02-21
Corrected revision number for the previous upgrade script.
ultramage
1
-2
/
+2
2008-11-16
- Item Rental System.
zephyrus
1
-0
/
+4
2008-09-07
- Removed mer_id from main.sql in char table. (Bug Report 2192)
zephyrus
1
-1
/
+0
2008-09-01
- Moved char server's mercenary code to a different file (int_mercenary.*)
zephyrus
1
-0
/
+16
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
[next]