Controller Database Schema

Database Schema v1.2 @author Micheal

Application
 - name - String (30)
 - package_name - String (100)
 - intent_name - String (100)
 - description - String (255)
 - type - String (30)
 - starttime - Date
 - endtime - Date
 - download - String (255)  --- deleted
 - version - String (10)
 - active - String (1)      --- added
 - created - Date (Now)
 - updated - Date (Now)

Device
 - id - String (15)
 - email - String (30)
 - reg_id - String (300)
 - collapse_key - String (255)
 - last_messaged - Date
 - failed_push - Boolean
 - update_interval - String (5)
 - active - String (1)   --- added
 - created - Date
 - updated - Date

DeviceApplication
 - dev_id (Foreign Key Device)
 - app_id (Foreign Key Application)
 - action - String (30)   --- deleted

Transaction
 - user (Foreign Key User)
 - total - Int
 - progress - Int
 - start - Date
 - end - Date

TransactionDevApp
 - tid (Foreign Key Transaction)
 - dev (Foreign Key Device)
 - app (Foreign Key Application)
 - action - String(1)
 - result - String(2)
 - start - Date
 - end - Date