########################################################################################## VEHPI-9: States Table ########################################################################################## Issue Type: Sub-task ----------------------------------------------------------------------------------------- Issue Information ==================== Priority: Major Status: Closed Resolution: Done (2013-12-13 07:00:17) Project: VehManPi (VEHPI) Reported By: btasker Assigned To: btasker Child of: VEHPI-8 - Set up Sqlite DB Components: - Database Targeted for fix in version: - 1.0 Time Estimate: 0 minutes Time Logged: 0 minutes ----------------------------------------------------------------------------------------- Issue Description ================== The system should record it's current state (i.e. is the vehicle moving, is it currently attempting to submit a GPX file etc). Need to design and create the table for this ----------------------------------------------------------------------------------------- Activity ========== ----------------------------------------------------------------------------------------- 2013-12-12 19:20:19 btasker ----------------------------------------------------------------------------------------- Should include a timestamp of when that state was set - so for example if moving == 0 we can quickly tell how long we believe the vehicle has been stationary ----------------------------------------------------------------------------------------- 2013-12-13 07:00:17 ----------------------------------------------------------------------------------------- btasker changed status from 'Open' to 'Resolved' ----------------------------------------------------------------------------------------- 2013-12-13 07:00:17 ----------------------------------------------------------------------------------------- btasker added 'Done' to resolution ----------------------------------------------------------------------------------------- 2013-12-13 07:00:26 ----------------------------------------------------------------------------------------- btasker changed status from 'Resolved' to 'Closed'