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 xmlsession.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
2013-03-01   c5057c88     added cache_type.short2 und .short2_trans_id
2013-03-03   c5057c88     added profile_options.optionset
2013-03-04   df313402     new table helppages

2013-03-08   7c785fcd     changes for vandalism archive-and-restore:
                            - added cache_logs_archived.deletion_date and deleted_by
                            - added tables caches_modified, cache_desc_modified,
                                caches_attributes_modified, cache_logs_restored,
																cache_pictures_modified and listing_restored
                            - modified lots of triggers
2013-03-09   09b51ecc     added field 'restored_by' to cache_coordinates, cache_countries,
                            cache_logs_archived, all new tables and to triggers
                          discarded table listing_restored
                          added index cache_logs_archived:user_id
                          
2013-03-10   f8738936     added field pictures.mappreview
2013-03-14   69abeb67     added fields coordinates_type.preposition and pp_trans_id
2013-03-15   a15b5582     discarded table 'data_licenses'
2013-03-16   80b89939     added fields coordinates.date_created and .last_modified
2013-03-18   37b5268a     added table 'saved_texts' + triggers
                          added triggers to table 'coordinates'

2013-03-20   085c1398     added field caches.listing_last_modified;
                            must be initialized once via Admin / DB Maintenance / sp_updateall_cache_listingdates
2013-03-24                added table 'pw_dict'
