Transfer content of the basic tables

The basic tables are relatively small.

If you need them locally, a complete download on a regular basis is recommended, since several of these basic tables does not have a “date stamp” (or similar) to support easy selection of changes only.

These important basic tables are usually updated each night:

• Tables access_points and agents contain a dte_updated column and a deleted flag
• Tables queues and menues do not have dte_updated column. If a menu or queue is deleted in Puzzel, we do not remove it from the relevant Raw data table, but we update the queue's/menu's description if it's changed.

The other basic tables are very seldom updated.