summaryrefslogtreecommitdiff
path: root/src/sql/mysql
AgeCommit message (Collapse)AuthorFilesLines
2008-11-06Added table tmw_item_instances and tmw_item_attributes for mySQL and SQLite ↵Andreas Habel1-25/+48
as preparation for unique item attributes. Fixed some formatting issues in mySQL Script.
2008-11-03Added tables and statements to store and retrieve letters. Attachments not ↵Andreas Habel1-1/+55
functional as long as items not stored as individual items.
2008-10-17Added SQL table definitions for item auctions.Andreas Habel1-0/+69
2008-09-19* Doxygen now writes all warnings into a separate fileAndreas Habel1-13/+17
* Added link to wiki documentation as comment into tmwserv.xml * Added table tmw_char_skills to store skills of a character and removed weapon skills from table tmw_characters.
2008-09-17fixed CHARSET parameter to utf8Andreas Habel1-7/+7
2008-09-17* Added installation scripts to set up database schemas for mysql, sqlite ↵Andreas Habel2-0/+187
and postgresql. The create table statements have been completely removed out from the c++ source into separate, provider specific sql files. Accountserver will no longer create a sqlite file if none present. * Added database specific config parameters to configure each provider independent. * Simplified the connect routine of DALStorage class since every dataprovider is now responsible to retrieve its own parameters. * Extended abstract dataprovider to support transactions, functionally implemented for SQLite and mySQL. * Added methods to retrieve last inserted auto-increment value and the number of modified rows by the last statement. * Rewrite of DALStorage class to be a little more transactional. * Fixed a bug when deleting a character. Old function left data in quests table and guilds table. * Doxygen now also includes non-documented functions and provides a dictionary for all classes