Age | Commit message (Collapse) | Author | Files | Lines |
|
This upgrade will be the first, we provide database installation scripts
and update scripts to upgrade from the previous version. For more details
about database upgrades see
http://wiki.themanaworld.org/index.php/Upgrade_Database and feel free to
comment.
|
|
Easy enough to create, so we shouldn't have this in the repository.
Creating it goes like:
sqlite3 tmw.db < src/sql/sqlite/createTables.sql
|
|
The provided CreateTable.sql scripts store their versions inline of a database table. The account server checks this version number with its known
compatible version. If the numbers don't match, the account server raises an error and shuts down.
|
|
as preparation for unique item attributes. Fixed some formatting issues in mySQL Script.
|
|
functional as long as items not stored as individual items.
|
|
|
|
* 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.
|
|
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
|