Table: DynamicClientGroupDevices

ColumnName DataType Key Not Null Default Value Comment
DynamicClientGroupDevicesID INTEGER PK NN   Unique ID of Dynamic Client Group devices
DynamicClientGroupID INTEGER       ID of the Dynamic Client Group the device belongs to
Mac NVARCHAR(255)       MAC address of the device
ClientIdentifier UNIQUEIDENTIFIER   NN   Unique identifier for client devices and eLux portable sticks
ReservedString1 NVARCHAR(255)        
ReservedString2 NVARCHAR(255)        
ReservedInt1 INTEGER        
ReservedInt2 INTEGER        
IndexName IndexType Columns
PRIMARY PRIMARY DynamicClientGroupDevicesID

 

how to create

CREATE TABLE DynamicClientGroupDevices(
DynamicClientGroupDevicesID INTEGER NOT NULL,
DynamicClientGroupID INTEGER,
Mac NVARCHAR(255),
ClientIdentifier UNIQUEIDENTIFIER,
ReservedString1 NVARCHAR(255),
ReservedString2 NVARCHAR(255),
ReservedInt1 INTEGER,
ReservedInt2 INTEGER,
PRIMARY KEY (DynamicClientGroupDevicesID));