Scout Database Model (LTSR)
Table: Multimedia
Holds the data from Setup > Multimedia.
| ColumnName | DataType | Key | Not Null | Default Value | Comment |
|---|---|---|---|---|---|
| MultimediaID | INTEGER IDENTITY(1,1) | PK | NN | ||
| MemberType | INTEGER | NN | Always 5 (means: Type is Setup) | ||
| MemberID | INTEGER | NN | Setup ID if MemberType is 5 | ||
| OutputPriority | NVARCHAR(255) | NN | Comma-separated list of output devices | ||
| The first has precedence | |||||
| Example: digital,usb,analog | |||||
| OutputUSB | INTEGER | NN | Volume level of usb output 0-100 | ||
| OutputAnalog | INTEGER | NN | Volume level of analog output 0-100 | ||
| OutputDigital | INTEGER | NN | Volume level of digital output 0-100 | ||
| OutputMuteUSB | BIT | NN | Mute flag for usb output 0 or 1 | ||
| OutputMuteAnalog | BIT | NN | Mute flag for analog output 0 or 1 | ||
| OutputMuteDigital | BIT | NN | Mute flag for digital output 0 or 1 | ||
| InputPriority | NVARCHAR(255) | NN | Comma-separated list of input devices | ||
| The first has precedence | |||||
| Example: digital,usb,analog | |||||
| InputUSB | INTEGER | NN | Level of usb input 0-100 | ||
| InputAnalog | INTEGER | NN | Level of analog input 0-100 | ||
| InputMuteUSB | BIT | NN | Mute flag for usb input 0 or 1 | ||
| InputMuteAnalog | BIT | NN | Mute flag for analog input 0 or 1 | ||
| SystemBeep | BIT | NN | Enable/disable system beep 0 or 1 |
| IndexName | IndexType | Columns |
|---|---|---|
| PRIMARY | PRIMARY | MultimediaID |
How to create
CREATE TABLE Multimedia(
MultimediaID INTEGER IDENTITY (1,1) NOT NULL,
MemberType INTEGER NOT NULL,
MemberID INTEGER NOT NULL,
OutputPriority NVARCHAR(255) NOT NULL,
OutputUSB INTEGER NOT NULL,
OutputAnalog INTEGER NOT NULL,
OutputDigital INTEGER NOT NULL,
OutputMuteUSB BIT NOT NULL,
OutputMuteAnalog BIT NOT NULL,
OutputMuteDigital BIT NOT NULL,
InputPriority NVARCHAR(255) NOT NULL,
InputUSB INTEGER NOT NULL,
InputAnalog INTEGER NOT NULL,
InputMuteUSB BIT NOT NULL,
InputMuteAnalog BIT NOT NULL,
SystemBeep BIT NOT NULL,
CONSTRAINT PK_Multimedia
PRIMARY KEY (MultimediaID));
How to initialize
INSERT INTO Multimedia SELECT 5,SetupID,'usb,analog,digital',MasterVolume/0.63,MasterVolume/0.63,MasterVolume/0.63,(MicMute & 2),(MicMute & 2),(MicMute & 2),'usb,analog',MicVolume,MicVolume,(MicMute & 1), (MicMute & 1), XDMCPSound, SystemBeep FROM Setup WITH (HOLDLOCK TABLOCKX);
Table: Multimedia
Copied!
Failed!