SQLite format 3@ ''.4   T  F''Ktablelocation_pinslocation_pinsCREATE TABLE location_pins (_id INTEGER PRIMARY KEY AUTOINCREMENT, track_id INTEGER REFERENCES tracks(_id), name TEXT, description TEXT, category TEXT, icon TEXT, latitude TEXT, longitude TEXT, accuracy TEXT, elevation TEXT, phone_UTC TEXT, point_Zone_Date TEXT, txt1 TEXT, txt2 TEXT )6;tableevent_logevent_logCREATE TABLE event_log (_id INTEGER PRIMARY KEY AUTOINCREMENT, phone_UTC TEXT, event_type TEXT, track_id INTEGER, latitude TEXT, longitude TEXT, accuracy TEXT, elevation TEXT, speed TEXT, point_Zone_Date TEXT, control_id TEXT, proximity TEXT, event_title TEXT, event_detail TEXT)0++tablecontrol_punchescontrol_punchesCREATE TABLE control_punches (_id INTEGER PRIMARY KEY AUTOINCREMENT, track_id INTEGER REFERENCES tracks(_id), latitude TEXT, longitude TEXT, elevation TEXT, speed TEXT, point_Zone_Date TEXT, phone_UTC TEXT, control_id TEXT, proximity TEXT, txt1 TEXT, txt2 TEXT)!!Itableway_pointsway_pointsCREATE TABLE way_points (_id INTEGER PRIMARY KEY AUTOINCREMENT, track_id INTEGER REFERENCES tracks(_id), latitude TEXT, longitude TEXT, accuracy TEXT, elevation TEXT, speed TEXT, point_Zone_Date TEXT, txt1 TEXT, txt2 TEXT)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)"tabletrackstracksCREATE TABLE tracks (_id INTEGER PRIMARY KEY AUTOINCREMENT, track_Name TEXT, track_Description TEXT, start_Time TEXT, distance TEXT, duration TEXT, event TEXT, event_Details TEXT, runner TEXT, settings TEXT, app TEXT, phone TEXT, result TEXT, txt1 TEXT, txt2 TEXT)  HACCK M? 2020-06-27T12:46:43.9187752020-06-27T11:46:43.918724Z2020-06-27T11:46:43.918724ZTBDTBD{"eventName":null,"eventType":null,"punchType":null,"scoreType":null,"specificScatterNumber":null,"locationDisplay":true,"trackDisplay":null,"massStart":null,"perusalTime":null,"silentPunch":false}{"user_surname":"Robinson","user_firstName":"John","user_gender":"Male","user_emailAddress":"jsfr100@hotmail.com","user_mobilePhone":"07902029553","user_yob":"1950","user_postalcode":"WS12 4TP","user_club":"Walton chasers"}{"appVersionId":"MapRunF 4.8.8"}{"operatingSystem":"ios"}TBD !way_points  tracks event_log SR Q O S /1= 52.71763551318581-2.03804964261244816.0163.30.122020-06-27T11:46:55.083ZT /3= 52.71763084576109-2.038057847317300616.0163.30.082020-06-27T11:46:54.091ZT /3= 52.71762740833955-2.038067154088224316.0163.20.192020-06-27T11:46:53.092ZT /3= 52.71762412264575-2.038074971900638616.0174.50.252020-06-27T11:46:52.363ZS /1= 52.71757943673289-2.03805910986717424.0161.10.112020-06-27T11:46:50.837ZS /1= 52.71756023639187-2.03801425483083532.0184.70.152020-06-27T11:46:49.837ZU 13= 52.717572956659836-2.037957744898045524.0142.10.212020-06-27T11:46:48.837ZT /3= 52.71758619903807-2.037950029115372324.0142.31.492020-06-27T11:46:47.837ZT /3= 52.71773583943121-2.038054275072123664.0151.61.492020-06-27T11:46:46.837ZS /1= 52.71774457000401-2.03817128820999565.0161.6-1.02020-06-27T11:46:44.454ZT /3= 52.71775551939008-2.038110312986898348.0142.20.522020-06-27T11:45:36.698ZU 13= 52.717742919921875-2.038110312986898348.0142.20.522020-06-27T11:45:44.698Z  ( d ? >QTVnr'(UC#!92020-06-27T11:46:56.460048ZMapRunEventBGLocationBG.STOP, Success: True%C!/1=+S2020-06-27T11:46:56.449322ZBGLOCATION52.71763551318581-2.03804964261244816.02020-06-27T11:46:55.083ZonEnabledChange[EnabledChangeEvent enabled: false]zC#2020-06-27T11:46:56.440050ZMapRunEventUser ExitThe user has tapped home in the App Bar and confirmed exit.qC /1= 2020-06-27T11:46:56.114096ZWayPoint52.71763551318581-2.03804964261244816.02020-06-27T11:46:55.083ZrC /3= 2020-06-27T11:46:55.079155ZWayPoint52.71763084576109-2.038057847317300616.02020-06-27T11:46:54.091ZrC /3= 2020-06-27T11:46:54.114234ZWayPoint52.71762740833955-2.038067154088224316.02020-06-27T11:46:53.092ZrC /3= 2020-06-27T11:46:53.090023ZWayPoint52.71762412264575-2.038074971900638616.02020-06-27T11:46:52.363ZqC /1= 2020-06-27T11:46:51.548528ZWayPoint52.71757943673289-2.03805910986717424.02020-06-27T11:46:50.837ZC!/1=)2020-06-27T11:46:51.448776ZBGLOCATION52.71756023639187-2.03801425483083532.02020-06-27T11:46:49.837ZActivityChangestillqC /1= 2020-06-27T11:46:50.552676ZWayPoint52.71756023639187-2.03801425483083532.02020-06-27T11:46:49.837ZsC 13= 2020-06-27T11:46:49.596072ZWayPoint52.717572956659836-2.037957744898045524.02020-06-27T11:46:48.837ZC!/3=)2020-06-27T11:46:48.891856ZBGLOCATION52.71758619903807-2.037950029115372324.02020-06-27T11:46:47.837ZActivityChangestillr C /3= 2020-06-27T11:46:48.564258ZWayPoint52.71758619903807-2.037950029115372324.02020-06-27T11:46:47.837Zr C /3= 2020-06-27T11:46:47.583955ZWayPoint52.71773583943121-2.038054275072123664.02020-06-27T11:46:46.837Z C!/1=)2020-06-27T11:46:46.581398ZBGLOCATION52.71774457000401-2.03817128820999565.02020-06-27T11:46:44.454ZActivityChangestillx C#;e2020-06-27T11:46:45.348984ZMapRunEventAppLifeCycleStateChangeRunView going into AppLifecycleState.resumedq C /1= 2020-06-27T11:46:44.468581ZWayPoint52.71774457000401-2.03817128820999565.02020-06-27T11:46:44.454ZrC /3= 2020-06-27T11:46:44.071045ZWayPoint52.71775551939008-2.038110312986898348.02020-06-27T11:45:36.698Z C!13=%2020-06-27T11:46:44.070021ZBGLOCATION52.717742919921875-2.038110312986898348.02020-06-27T11:45:44.698ZMotionChangeto MovingsC 13= 2020-06-27T11:46:43.942537ZWayPoint52.717742919921875-2.038110312986898348.02020-06-27T11:45:44.698ZVC#!;2020-06-27T11:46:43.936592ZMapRunEventBGLocationBG.START, Success: TrueVC A2020-06-27T11:46:43.934835ZNew TrackTrackId:12020-06-27T12:46:43.918775yC#;g2020-06-27T11:46:41.259029ZMapRunEventAppLifeCycleStateChangeRunView going into AppLifecycleState.inactiveLC#C2020-06-27T11:46:41.177401ZMapRunEventEnter RunView with Settingsserver: s; gpsSource: Phone GPS; mapDisplay: null; mapTransparency: null; locationDisplay: true; trackDisplay: null; locationPinsDisplay: null; silentPunch: false; ctlGoesGreen: null; punchTolerance: 12; autoUpload: null; liveFireStoreEnabled: null; liveFireStoreInterval: 10; GPSBatSave: null; eventType: null; scoreType: null; eventTime: null; punchType: null; eventHasPIN: null; eventPINExpiryDate: null; specificScatterNumber: null; massStart: null; massStartEarly: null; perusalTime: null; eventIsSAW: null; northMap: null; HITMO: null; punchNonGPS: null; PromptTC: null; PromptSpecial: null; minVersion: null; eventOrigin: null; mapProtected: null; trackWidth: null; trackLineColour: null; locationCircleSize: null; locationPinSize: null; locationPinStyle: null; logLevel: null; levelOfReporting: null; alertSound: null; maxDataStorage: null; PC#-#2020-06-25T11:11:29.829379ZMapRunEventMapRun App StartApp startup