Add con_state column in DBi_measure

Created by: E3V3A

The new con_state column in DBi_measure should contain the AOS current connection and data activity states as given by the API with:

  DATA_ACTIVITY:   No,In,Ou,IO,Do
  DATA_CONNECTION: Di,Ct,Cd,Su
  CALL_STATE:      idle,ringing,offhook
  SERVICE_STATE:   emergency_only,in,out,off

See: PhoneStateListener developer info.

We should also add the current roaming state (as a Boolean) to this column.

Question: How should we format this column? Answer: T.B.D...

In the old tables we had these items stored as TEXT and separated by |. We could do something similar or we could use numbers like 1211 to represent [No,Ct,idle,emergency_only] etc. Any ideas?

Whatever ideas you might have, please always consider to minimize the required Java code for processing these.

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.