MobiLink Synchronization Reference
MobiLink System Tables
Introduction
Stores all registered MobiLink users, including their password and their synchronization state. The state is used only for UltraLite remotes or version 7 Adaptive Server Anywhere remotes.
| Row | Description |
|---|---|
| user_id | INTEGER. Primary key. The user_id column stores a unique integer identifying the user. This value is only used internally by MobiLink. |
| name | VARCHAR(128). The name column stores the arbitrary name given to the user. |
| commit_state | INTEGER. The commit_state column stores the state. |
| progress | NUMERIC(20,0). The progress, also called the offset, refers to the point in the transaction log up to which all operations for subscriptions have been uploaded and acknowledged. This column is used for version 7 databases. For version 8.0 and up databases, the progress is stored in the ml_subscription table. |
| hashed_password | BINARY(20). The hashed_password column stores the MobiLink user's password in obfuscated form. If there is no password, this value is NULL. (This is not recommended.) |
| last_download_time | TIMESTAMP. Indicates the last time a download was applied to the consolidated for a given user or subscription. The default is January 1, 1900, 00:00:00. |
| last_upload_time | TIMESTAMP. Indicates the last time an upload was applied to the consolidated for a given user or subscription. The default is January 1, 1900, 00:00:00. |