summaryrefslogtreecommitdiff
path: root/sql-files/main.sql
AgeCommit message (Expand)AuthorFilesLines
2011-04-16* Added support for visible garments/robes.ai4rei1-0/+1
2011-04-16* Updated field `weapon` in table `char` to default to '0' (bare-handed) rath...ai4rei1-1/+1
2011-03-24- Removed extra <TAB> from const.txtbrianluau1-4/+4
2011-02-08* Added support for new delayed character deletion.ai4rei1-0/+1
2011-01-14* Added 'birthdate' field to account data. For SQL apply upgrade_svn14672.sql...ai4rei1-0/+1
2010-12-12* Removed `motd` from `ragsrvinfo` table in main.sql, missed in previous comm...ai4rei1-2/+1
2010-02-09Expanded range for cached and stored-in-db guild member exp (devotion) from u...Paradox924X1-1/+1
2009-10-12Added missing sql update file for renameInkfish1-0/+1
2009-09-04forget to update main.sqlInkfish1-3/+0
2009-07-26* Some updates of Quest Log systemInkfish1-15/+9
2009-03-15Corrected the `char` table's 'manner' column type to match the type used by t...ultramage1-1/+1
2009-02-21Corrected revision number for the previous upgrade script.ultramage1-2/+2
2008-11-16- Item Rental System.zephyrus1-0/+4
2008-09-07- Removed mer_id from main.sql in char table. (Bug Report 2192)zephyrus1-1/+0
2008-09-01- Moved char server's mercenary code to a different file (int_mercenary.*)zephyrus1-0/+16
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