summaryrefslogtreecommitdiff
path: root/sql-files/main.sql
AgeCommit message (Expand)AuthorFilesLines
2008-08-23- Added column `mer_id` on char_dbzephyrus1-0/+1
2008-08-23- Database structure for Mercenary.zephyrus1-0/+15
2008-08-10Removed 'DROP TABLE' statements from main.sql (bugreport:1714)ultramage1-66/+33
2008-08-01Removed unused guardian hp columns from the guild castles table in main.sql (...ultramage1-8/+0
2008-07-26Merged the /loginmerge branch (topic:192754)ultramage1-21/+5
2008-06-23* Fixed: replaced TYPEs with ENGINEs in SQL files (for better compatibility, ...akrus1-2/+2
2008-04-13Forgot to change main.sql to reflect the update to quest_objective table.Kevin1-1/+2
2008-04-11Reverted the `login` table changes from r12464ultramage1-2/+2
2008-04-11New sql definitions for the quest code.Kevin1-7/+4
2008-04-10Char server now loads/saves quest information.Kevin1-0/+28
2008-04-04Replaced the TYPE keyword with ENGINE in all sql files, because this is the p...ultramage1-28/+28
2008-04-03Renamed 'connect_until_time' to 'expiration_time'.ultramage1-2/+2
2008-03-05- Added the auctiondb structurezephyrus1-0/+27
2008-01-10Fix to the sql files, password column length must be 32, to store md5 hashes =_=ultramage1-1/+1
2008-01-10Another round of login server cleaningultramage1-4/+4
2007-12-12* Some preparations for the guild script updateultramage1-7/+1
2007-11-07- Some updates on the mail system packets [Zephyrus]zephyrus1-1/+1
2007-10-30- Updated the mail sql structure in main.sql.zephyrus1-1/+1
2007-10-23* Removed the inter_athena.conf maildb settings as they are not required anym...zephyrus1-0/+28
2007-08-15- Merged and completed Latio's work on server-side hot-key saving (http://www...skotlex1-0/+15
2007-05-19* Added Global chat and Main chat loggingultramage1-1/+1
2007-05-19* SQL files fixupultramage1-11/+8
2007-03-02EOL-styled some more filesultramage1-578/+578
2006-09-13- Modified the login SQL server so that case insensitive lookups use "where n...skotlex1-3/+7
2006-09-12- Added manual deletion of sc_data entries when deleting a character (char-SQL)skotlex1-29/+18
2006-09-05- Fixed connect_until field being a smallint rather than int in the login tab...skotlex1-1/+1
2006-08-10- Fixed two instances in the login-sql server where the ip in the log-login t...skotlex1-1/+1
2006-08-10Fixed syntax error in 'guild' create table statementtoms1-1/+1
2006-08-08- Fixed yet again AS_SPLASHER doing full damage on all characters. Now you ca...skotlex1-1/+1
2006-07-20SQL fix for Homunc skillsDracoRPG1-3/+4
2006-07-17Orn's and Albator's Homunculus system, finally, YAY!!DracoRPG1-540/+584
2006-07-08- Fixed the char table having party/guild_id as smallint when they need int t...skotlex1-2/+2
2006-06-16sql optimizations.Euph1-539/+540
2006-06-14- Fixed main.sql adding a key on char_id rather than account_id for the char ...skotlex1-1/+1
2006-06-14Syntax errors :(Lance1-1/+1
2006-06-13- Updated mob_db.sql and item_db.sql to latest.skotlex1-0/+1
2006-05-31[Improved]: Lance1-1/+1
2006-05-19- Fixed loginlog definition in main.sql, thanks to Tempestaskotlex1-2/+2
2006-05-11- Fixed the definition of the KEY in the loginlog, thanks to TheUltraMageskotlex1-1/+1
2006-05-09- Fix on pc_skill which fixes overlapping when one gets more than one bonus f...skotlex1-1/+2
2006-03-14- Fixed the average_lv column size specification. Thanks to Joshuaali (upgrad...skotlex1-3/+3
2006-03-04- Some cleaning of the main.sql fileskotlex1-28/+28
2006-02-17- Added an upgrade_svn file to fix the party sql table (it lacks the auto-inc...skotlex1-1/+1
2006-02-16- Updated the login/char sql servers to let the sql tables autogenerate the n...skotlex1-14/+0
2006-01-29AS OF SVN REV. 5901, WE ARE NOW USING TRUNK. ALL UNTESTED BUGFIXES/FEATURES ...Valaris1-0/+551
2006-01-29Clearing trunk.Valaris1-501/+0
2005-02-10Added a auto increment 'start' value in the main.sql file ^^[Sirius](no author)1-1/+1
2004-12-19Added a friend0 columncodemaster1-0/+2
2004-11-29removed a USE that should not be thereamber1-2/+1
2004-11-14Fixed some file typesamber1-499/+499