The table lo_lock contains information used to restrict editing access to a template. The template database locks at template level. I.e. only one user may edit a single template at any time.

The lock table also contains rows used to store timestamps for last updates within a single gallery or the database overall. These values may be used to poll the database for changes. These timestamps are stored in the lo_updatedate field.

Note that the lo_insertedby field is used to identify the lock type:

• Template - This is a true lock, locking the corresponding template. The template is identified by the value in the lo_recno column which contains a foreign key to the te_recno value in the te_template table.

• Gallery - Contains a timestamp when the corresponding gallery was last updated. The gallery is identified by the lo_recno which for gallery types contains a foreign key to the corresponding gallery, ga_recno in the ga_gallery table. The foreign key is a function of the lo_recno value as follows:

ga_recno = 10 - lo_recno

• Database - Contains a timestamp when the database was last updated.

• Other values are deprecated.