summaryrefslogtreecommitdiff
path: root/src/sql/postgresql
AgeCommit message (Collapse)AuthorFilesLines
2012-03-16Fixed the version in the createTables.sql scriptsThorbjørn Lindeijer1-4/+3
Forgot this in 1afbfb7e5fb5c133924ed8d376c6064575fc1c36. Reviewed-by: Bertram, Ablu.
2012-03-13Fixed problems with map-bound world state variablesThorbjørn Lindeijer1-4/+5
Due to a wrong primary key, which covered only the state name, it was impossible to use the same state name on different maps. This has now been fixed. Another problem was that the map variables were being included in the global variables, because the related database query did not filter on the map_id column properly. While fixing that, the map_id column now allows explicitly marking a state variable as global (with the value 0) or system variables (with the value -1). System variables are currently not accessible from scripts, but that could be changed later. Reviewed-by: Yohann Ferreira Reviewed-by: Erik Schilling
2009-12-06Fixed name of the project in copyright headersThorbjørn Lindeijer1-0/+20
Also updated the headers to refer to the GPL by URL instead of suggesting to contact the FSF by snail mail, as per the latest GPL usage instructions.
2009-10-24Rebranding tmwserv to manaservThorbjørn Lindeijer1-32/+32
Includes a database update. Use update_6_to_7.sql to update existing sqlite databases.
2008-09-17* Added installation scripts to set up database schemas for mysql, sqlite ↵Andreas Habel1-0/+102
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