Viz Mosart Administrator Guide

Version 5.2 | Published May 22, 2023 ©

ga_gallery

The table ga_gallery contains all Mosart galleries using the database.

Note: In Mosart AvAutomation the property ThisGallery shall reflect the gallery name as stored in the ga_name column.

Name

Type

Allow Null

Description

ga_recno

integer

No

Primary key.

ga_shared

smallint

Yes

Set to true (1) for the shared gallery. The shared gallery may be used by clients to obtain all shared template sets within the database. Only one gallery shall be used as the shared gallery. By default, a virtual gallery named SHARED is used for this purpose.

ga_name

varchar(32)

No

The gallery name.

ga_description

varchar(128)

Yes

Optional gallery description.

ga_avconfigxml

longtext

Yes

The XML formatted contents of the avconfig.xml file used in this gallery.

ga_ts_recno

integer

Yes

Optional foreign key referencing the ‘default’ template set of the gallery.

ga_dbversion

string

Yes

The database version used by the Mosart applications for the gallery. This database version reflects the current Mosart version.

Note: One row only should have ga_shared = 1. The name of this gallery is by default set to ‘SHARED’. All shared templates belong to this gallery.