-
Notifications
You must be signed in to change notification settings - Fork 46
/
db-changes.txt
68 lines (58 loc) · 4.09 KB
/
db-changes.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
Database changes since Version 3.0
master branch
date commit ID change
---- --------- --------
2012-08-06 1ba2be5 changed triggers sysTransBeforeInsert and sysTransTextBeforeInsert
2012-08-07 eda58c5 new field caches.is_publishdate; changed trigger cachesBeforeUpdate
2012-08-08 fc48133 changed trigger cachesBeforeInsert
2012-08-23 b7ae9cc increased caches.wp_oc length from 6 to 7 chars
2012-08-23 bdc7949 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 c32a4b0 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 9bc361c changed trigger cacheRatingBeforeInsert
2012-11-04 d6ae786 - new table cache_waypoint_pool
- new stored functions WPTODEC() and DECTOWP()
2012-11-17 39a25f9 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 d15ee5f added indices logentries:date and email_user:date
2013-02-15 92e522f 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 06d832c new table data_licenses
added user.data_license
2013-02-17 b7b51ea added user.email_problems
2013-03-01 c5057c8 added cache_type.short2 und .short2_trans_id
2013-03-03 c5057c8 added profile_options.optionset
2013-03-04 df31340 new table helppages
2013-03-08 7c785fc 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 09b51ec 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 f873893 added field pictures.mappreview
2013-03-14 69abeb6 added fields coordinates_type.preposition and pp_trans_id
2013-03-15 a15b558 discarded table 'data_licenses'
2013-03-16 80b8993 added fields coordinates.date_created and .last_modified
2013-03-18 37b5268 added table 'saved_texts' + triggers
added triggers to table 'coordinates'
2013-03-20 085c139 added field caches.listing_last_modified;
must be initialized once via Admin / DB Maintenance / sp_updateall_cache_listingdates
2013-03-24 9644465 added table 'pw_dict'
2013-03-25 21d92fe added field cache_reports.date_created + trigger
2013-03-27 467aae4 added fields cache_attrib.gc_id, .gc_inc and .gc_name
==== From here, all DB changes are automatically done when you run bin/dbupdate.php. ====
2013-04-06 e281cfa changed cach_logs.date and cach_logs_archived.date type to datetime
2013-04-22 c989c00 added fields caches.meta_last_modified, cache_logs.log_last_modified,
cache_logs_archived.log_last_modified, and triggers