##########################################################################################

       VEH-58: Perform Manual Split of JourneyTrackPoints table on live API

##########################################################################################


Issue Type: Sub-task 
-----------------------------------------------------------------------------------------

Issue Information
====================

Priority: Major					Status:      Closed
Resolution:  Done (2013-12-27 00:03:41)
Project: VehMan (VEH)


Reported By: btasker					
Assigned To: btasker
Child of: VEH-56 - Split JourneyTrackPoints Table  


Components: 
	- Journeys 


Targeted for fix in version: 
	- 1.0.2


Time Estimate: 0 minutes
Time Logged:   0 minutes


-----------------------------------------------------------------------------------------

Issue Description
==================

Once VEH-56 is ready to roll out, the existing JourneyTrackPoints table will need to be
manually split to match the new table name schema

-----------------------------------------------------------------------------------------

Attachments
============

	- track_renumbering.txt


-----------------------------------------------------------------------------------------

Activity
==========

	
-----------------------------------------------------------------------------------------
2013-12-27 00:03:35              btasker
-----------------------------------------------------------------------------------------

Attached file shows the commands use to renumber the tracks. Decided the number of empty
tables created by manually splitting just wasn't worth the headache.

Have reset the AUTO_INCREMENT counter for JourneyTrackPoints so the values should follow
on.

Current max PK is 116
	
-----------------------------------------------------------------------------------------
2013-12-27 00:03:35              
-----------------------------------------------------------------------------------------

btasker added 'track_renumbering.txt' to Attachments
	
-----------------------------------------------------------------------------------------
2013-12-27 00:03:42              
-----------------------------------------------------------------------------------------

btasker changed status from 'Open' to 'Resolved'
	
-----------------------------------------------------------------------------------------
2013-12-27 00:03:42              
-----------------------------------------------------------------------------------------

btasker added 'Done' to resolution
	
-----------------------------------------------------------------------------------------
2013-12-27 00:03:47              
-----------------------------------------------------------------------------------------

btasker changed status from 'Resolved' to 'Closed'