Database changes since Version 3.0

master branch


date         commit ID    change
----         ---------    --------
2012-08-06   1ba2be52     changed triggers sysTransBeforeInsert and sysTransTextBeforeInsert
2012-08-07   eda58c51     new field caches.is_publishdate; changed trigger cachesBeforeUpdate
2012-08-08   fc481334     changed trigger cachesBeforeInsert
2012-08-23   b7ae9cc1     increased caches.wp_oc length from 6 to 7 chars

2012-08-23   bdc79495     OKAPI will do these changes AUTOMATICALLY upon installation:
                            - add okapi_* tables
                            - add caches.okapi_syncbase, initialize it and add corresponding index
                            - add and initialize cache_logs(_archived).okapi_syncbase
                          See installation instructions at http://code.google.com/p/opencaching-api

2012-08-24   c32a4b06     added cache_rating.rating_date and index 'date'; must be initialized by:
                            UPDATE cache_rating SET rating_date = (SELECT MIN(`date`) FROM cache_logs WHERE cache_logs.cache_id=cache_rating.cache_id AND cache_logs.user_id=cache_rating.user_id AND cache_logs.type IN (1,7))
                          added trigger cacheRatingBeforeInsert
2012-08-27   9bc361c3     changed trigger cacheRatingBeforeInsert
2012-11-04   d6ae7868     - new table cache_waypoint_pool
                          - new stored functions WPTODEC() and DECTOWP()
2012-11-17   39a25f99     removed cache_waypoint_pool.cache_id and index cache_id
                          added cache_waypoint_pool.uuid and index uuid
                          changed caches.wp_oc to 'NOT NULL'
2013-02-12   d15ee5f9     added indices logentries:date and email_user:date
2013-02-15   92e522f6     adjusted developer and production system:
                          - added index logentries:userid
                          - changed user.password length to 32
													- removed sqlsession.remote_addr and index remote_addr
2013-02-16   06d832c3     new table data_licenses
                          added user.data_license
2013-02-17   b7b51eab     added user.email_problems
