MobiLink Synchronization Reference
MobiLink System Tables
The MobiLink system tables store information about MobiLink users, subscriptions, tables, scripts, and script versions. They are created when you run the MobiLink setup scripts for your consolidated database, and are updated as you use MobiLink. They are not like RDBMS system tables in that you can alter them directly.
For more information about how to create these tables, see Setting up a consolidated database.
The MobiLink system tables are stored in the consolidated database. Unlike most system tables, you can modify them. However, except in rare circumstances you should not alter them directly.
Adaptive Server Anywhere remote databases also have system tables. For more information, see System Tables. UltraLite databases do not have system tables.
The following section shows details of the MobiLink system tables. In some DBMSs, the data types are slightly different.
IBM DB2 UDB version 5.2 only supports column names and other identifiers of 18 characters or less. In a DB2 5.2 consolidated database, MobiLink system tables are truncated where necessary.
ml_connection_script
ml_script
ml_script_version
ml_scripts_modified
ml_subscription
ml_table
ml_table_script
ml_user