LetSync Desktop needs some extra tables in order to operate properly. These tables are used to run tasks properly, to record errors that may occur while running a task, and to keep your database up-to-date for future new fields.
You cannot delete any column of any table because LetSync Desktop will throw an error on that table.
- history: this table will record the date that any operation (populate, refresh, or update from/to QuickBooks) was done. This task is crucial for “Refresh From QuickBooks” and “Update and Refresh tasks”
- error_table: this table will record the errors that happen when running a task if it is any.
- dataextdef: this table is for the custom fields. This table will save which custom fields are assigned to which table.
- LSDatabase: this table will tell the version of the LetSync Desktop database you are running. If there is any future field that is added, this version will increase.
MySQL Create Statement LetSync Desktop: download