Table: Groups
Each entry represents a organization unit (formerly known as group) of the Scout Enterprise hierarchy. Every OU has exact one owner OU, which is also known as parent OU.
ColumnName | DataType | Key | Not Null | Default Value | Comment | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
GroupID | INTEGER | PK | NN | Unique OU/group ID | |||||||||||||
WolServerID | INTEGER | FK | WakeOnLAN
server ID Foreign key referring to table Server.ServerID |
||||||||||||||
LocationID | INTEGER | FK | NN | ID of the
owning OU/group Foreign key refers to table Groups.GroupID -1: top level OU |
|||||||||||||
Name | NVARCHAR(255) | NN | Unique name of OU/group | ||||||||||||||
UseParent | SMALLINT(6) | NN | 1 | Use
setup of the owning OU/group 0|1 |
|||||||||||||
Info1 | NVARCHAR(255) | Arbitrary user information | |||||||||||||||
Info2 | NVARCHAR(255) | Arbitrary user information | |||||||||||||||
Info3 | NVARCHAR(255) | Arbitrary user information | |||||||||||||||
ClientAccessType | INTEGER | 1 | Group
access control for clients
|
||||||||||||||
ClientAccessPassword | NVARCHAR(255) | Crypted password required to join the OU/group | |||||||||||||||
UseParentApps | SMALLINT(6) | 1 | Use
applications of the owning group in addition 0|1 |
||||||||||||||
UseParentAppDefaults | SMALLINT(6) | 1 | Use
application settings of the owning OU/group 0|1 |
||||||||||||||
DefaultPrinter | NVARCHAR(255) | Name of default printer (must exist in table Printer for the according SetupID) | |||||||||||||||
DriverNames | NVARCHAR(max) | OU/group
specific list of printer/driver mappings printer1==driver1::printer2==driver2::printerN==driverN |
|||||||||||||||
LastApplicationAction | NVARCHAR(255) | #NONE | Action
takes place when the last application is closed
|
||||||||||||||
LastApplicationActionDelay | INTEGER | 0 | Delay (in seconds) before LastApplicationAction is processed | ||||||||||||||
Resolution | NVARCHAR(255) | 1024x768 | Screen
resolution 640x480|800x600|1024x768|1152x864|1280x1024|1600x1200 |
||||||||||||||
Frequency | INTEGER | 60 | Screen
frequency 60|70|75|80|85|90|100 |
||||||||||||||
ColorDepth | INTEGER | 16 | Screen
color depth 8|16|24 |
||||||||||||||
UseDDC | SMALLINT(6) | 1 | Use DDC setting of the owning OU/group 0|1 |
||||||||||||||
UseParentScreenSettings | SMALLINT(6) | 1 | Use
screen settings of the owning OU/group 0|1 |
||||||||||||||
UpdateParallel | INTEGER | 10 | Amount of devices which are updated together | ||||||||||||||
UpdateDelay | INTEGER | 30 | -obsolete- | ||||||||||||||
UpdateConnect | INTEGER | 2 | Timeout (in seconds) when connecting a device | ||||||||||||||
UseParentUpdateSettings | SMALLINT(6) | 1 | Use
update settings of the owning OU/group 0|1 |
||||||||||||||
UseParentMouseKBSettings | SMALLINT(6) | 1 | Use
mouse and keyboard settings of the owning OU/group 0|1 |
||||||||||||||
UsePeerIP | SMALLINT(6) | 0 | Use
peer IP (such as access point with NAT) when connecting the client
(instead of device IP) 0|1 |
||||||||||||||
UseParentArray | NVARCHAR(255) | FF | Bit field indicates which property should be used from the owning OU/group | ||||||||||||||
FirstContactAction | INTEGER | -1 | |||||||||||||||
SetupID | INTEGER | FK | 0 | Setup ID (foreign key referring to table Setup.SetupID) | |||||||||||||
DevNameTemplate | NVARCHAR(255) | Name of the device name template Example: <DEV>_MAC |
|||||||||||||||
DeviceCount | INTEGER | Number of devices in this OU and subordinate OUs | |||||||||||||||
ReservedString1 | NVARCHAR(255) | ||||||||||||||||
ReservedString2 | NVARCHAR(255) | ||||||||||||||||
ReservedInt1 | INTEGER | ||||||||||||||||
ReservedInt2 | INTEGER | ||||||||||||||||
Note | NVARCHAR(255) | ||||||||||||||||
OUType | INTEGER | NN | 0 |
IndexName | IndexType | Columns |
---|---|---|
PRIMARY | PRIMARY | GroupID |
How to create
CREATE TABLE Groups(
GroupID INTEGER NOT NULL,
WolServerID INTEGER,
LocationID INTEGER NOT NULL,
Name NVARCHAR(255) NOT NULL,
UseParent SMALLINT NOT NULL,
Info1 NVARCHAR(255),
Info2 NVARCHAR(255),
Info3 NVARCHAR(255),
ClientAccessType INTEGER,
ClientAccessPassword NVARCHAR(255),
UseParentApps SMALLINT,
UseParentAppDefaults SMALLINT,
DefaultPrinter NVARCHAR(255),
DriverNames NVARCHAR(max),
LastApplicationAction NVARCHAR(255),
LastApplicationActionDelay INTEGER,
Resolution NVARCHAR(255),
Frequency INTEGER,
ColorDepth INTEGER,
UseParentScreenSettings SMALLINT,
UpdateParallel INTEGER,
UpdateDelay INTEGER,
UpdateConnect INTEGER,
UseParentUpdateSettings SMALLINT,
UseParentMouseKBSettings SMALLINT,
UsePeerIP SMALLINT,
UseParentArray NVARCHAR(255),
FirstContactAction INTEGER,
SetupID INTEGER,
DevNameTemplate NVARCHAR(255),
DeviceCount INTEGER,
ReservedString1 NVARCHAR(255),
ReservedString2 NVARCHAR(255),
ReservedInt1 INTEGER,
ReservedInt2 INTEGER,
Note NVARCHAR(255),
OUType INTEGER NOT NULL,
CONSTRAINT FK_Groups_WolServerID_Server_ServerID FOREIGN KEY (WolServerID)
REFERENCES Server (ServerID),
CONSTRAINT FK_Groups_SetupID_Setup_SetupID FOREIGN KEY (SetupID)
REFERENCES Setup (SetupID),
PRIMARY KEY (GroupID));