Table: EnvironmentEntry

The entry represents a environment variable which is set on the device. It can be assigned to a single device or group.

ColumnName DataType Key   Not Null   Default Value Comment
EnvironmentEntryID INTEGER PK NN   Unique environment entry ID
MemberType INTEGER       Member type
1 TYPE_GROUP MemberID refers to Groups
4 TYPE_DEVICE_ENTRY MemberID refers to Device
MemberID INTEGER (FK) NN   MemberID (depending on MemberType this refers to table Groups or Device)
EnvironmentKey NVARCHAR(255)       Name of environment variable
EnvironmentValue NVARCHAR(255)       Value of environment variable
ReservedString1 NVARCHAR(255)        
ReservedString2 NVARCHAR(255)        
ReservedInt1 INTEGER        
ReservedInt2 INTEGER        
IndexName IndexType Columns
PRIMARY PRIMARY EnvironmentEntryID
MemberID

 

How to create

CREATE TABLE EnvironmentEntry(
EnvironmentEntryID INTEGER NOT NULL,
MemberType INTEGER,
MemberID INTEGER,
EnvironmentKey NVARCHAR(255),
EnvironmentValue NVARCHAR(255),
ReservedString1 NVARCHAR(255),
ReservedString2 NVARCHAR(255),
ReservedInt1 INTEGER,
ReservedInt2 INTEGER,
PRIMARY KEY (EnvironmentEntryID));