No update function from previous release of gmaps_content
lop - September 15, 2009 - 15:48
| Project: | Google Maps Tools |
| Version: | 6.x-2.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
I've briefly looked at the new dev release and there are some changes in gmaps_content_address table schema and table indexes but there's no update function from previous dev release (August 20).
I know this is still a development version but some of us are already using this marvelous and very promising module in production.
Maybe you can provide SQL update queries here if you don't want to touch the release queue.
Anyway thanks for these great modules and keep up the good work.
#1
Change is very simple:
- add address part columns from adminarea to thorougfare once again to the table prefixed by 'u_' (stand for 'upper'),
- set the fields like 'u_adminarea = UPPER(adminarea)', alter the indexes as gmaps_content_schema() defines them in gmaps_content.install,
- flush all caches (or at least schema cache).
This is just a performace boost change, which makes possible to eliminate the usage of the SQL level UPPER() function in queries.