summaryrefslogtreecommitdiffstats
path: root/src/sql
Commit message (Collapse)AuthorAgeFilesLines
...
* Update table tmw_accounts. Added columns to store secret key and expirationAndreas Habel2009-08-172-9/+24
| | | | time for password recovery via tmwweb/email.
* Mysql update fileblue1122009-04-202-15/+18
| | | | | Update file... updated ^^' You can execute it a second time, there's no problem.
* Update script mysql 2 to 3Blue1122009-04-191-0/+16
|
* Mysql Backend Update mysql database to version 3 Fixed compile error with ↵Blue1122009-04-191-2/+10
| | | | mysql backend
* Fix database version in sqlite db creation fileJared Adams2009-03-081-1/+1
|
* Fix a bug in the sqlite db creation fileJared Adams2009-03-081-1/+1
|
* Fix error in sqlite 2 to 3 update scriptJared Adams2009-03-081-1/+1
|
* Added transactions for chat events.David Athay2009-03-051-1/+1
|
* Added transactional historyDavid Athay2009-03-052-0/+25
|
* Added new table to store online users. See mantis #553Andreas Habel2008-12-014-9/+121
| | | | | | | | 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.
* Fixed a bug in tmw_world_states table script reported by YellowShadow. ↵Andreas Habel2008-11-181-1/+1
| | | | Modified column value to be nullable according to the sqlite table specification.
* Removed the binary sqlite3 databaseBjørn Lindeijer2008-11-161-0/+0
| | | | | | | 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
* Added check for database version on startup of Accountserver.Andreas Habel2008-11-143-2/+7
| | | | | 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.
* Added table tmw_item_instances and tmw_item_attributes for mySQL and SQLite ↵Andreas Habel2008-11-063-48/+96
| | | | as preparation for unique item attributes. Fixed some formatting issues in mySQL Script.
* Added tables and statements to store and retrieve letters. Attachments not ↵Andreas Habel2008-11-032-2/+94
| | | | functional as long as items not stored as individual items.
* Added SQL table definitions for item auctions.Andreas Habel2008-10-173-0/+117
|
* * Doxygen now writes all warnings into a separate fileAndreas Habel2008-09-193-24/+31
| | | | | * 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.
* fixed CHARSET parameter to utf8Andreas Habel2008-09-171-7/+7
|
* * Added installation scripts to set up database schemas for mysql, sqlite ↵Andreas Habel2008-09-175-0/+391
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
generated by cgit (git 2.34.1) at 2025-08-31 07:24:38 +0000