ayan4m1/DayZ-Private — pull request #91 by Geit (2012-08-30 15:16:22+00:00)
Title: Issue #9 - Revised Schema

First steps of reworking the schema to be more efficient, hopefully everything is up to scratch, no errors observed on a server after 5 hours of operation.

* Renamed all procedures to have uniform names in the format proc_
* delO -> proc_deleteObject
* getLoadout -> proc_getInstanceLoadout
* getO -> proc_getObjects
* getOC -> proc_getObjectPageCount
* getTasks -> proc_getSchedulerTasks
* getTC -> proc_getSchedulerTaskPageCount
* getTime -> proc_getInstanceTime
* insOselI -> proc_insertObject
* insUNselI -> proc_insertPlayer
* logLogin -> proc_logLogin
* logLogout -> proc_logLogout
* selIIBSM -> proc_getPlayer
* selMPSSH -> proc_getPlayerStats
* setCD -> proc_setPlayerDead
* update -> proc_updatePlayer
* updIH -> proc_updateObjectHealth
* updII -> proc_updateObjectInventory
* updIPF -> proc_updateObjectPosition
* updUI -> proc_updateObjectInventoryByUID
* Rewrote all procedures to use standardised parameter names in the format param_
* Removed extraneous comment marks that didn't have a comment attached from all procedures.
* Removed a pointless subquery (if check) from proc_getInstanceLoadout - loadout can never be type NULL anyway.
* Removed a pointless prepared statement, and rewrote, proc_getObjects.
* Removed a pointless prepared statement from, and rewrote, proc_getSchedulerTasks.
* Fixed a bug where the server time could be +- 24 hours the desired value.
* Made proc_insertObject, proc_logLogin and proc_logLogout use INSERT IGNORE to improve performance.
* proc_getPlayer now takes two parameters, one is used to update the players name, should their profile be different.
* Removed selIPIBMSSS, it doesn't appear to be used.
* Added an index to the objects table for Instance ID.
* Added an index to the players table for death status.