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.
Name | Type | Allow Null | Description |
|---|---|---|---|
lo_recno | integer | No | Primary key. Also used to identify either a gallery or a template depending upon the lock type. See description above. |
lo_ga_recno | integer | Yes | Optional foreign key referencing the gallery owning the lock. |
lo_ga_name | varchar(32) | Yes | The name of the gallery owning the lock. |
lo_insertedby | varchar(32) | No | Contains the lock type. Either Template, Gallery or Database. See description above. |