Table: IniEntry

Each record represents a entry in a ini file which is located at the thin client. It can be assigned to a single device or group.

ColumnName	DataType	Key	Not Null	Default Value	Comment
IniEntryID	INTEGER	PK	NN		Unique ini 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)
IniFile	NVARCHAR(255)				Name of ini file (absolute path on thin client)
IniSection	NVARCHAR(255)				Name of section in ini file
IniKey	NVARCHAR(255)				Name of key in ini file
IniValue	NVARCHAR(255)				Value
ReservedString1	NVARCHAR(255)
ReservedString2	NVARCHAR(255)
ReservedInt1	INTEGER
ReservedInt2	INTEGER

IndexName	IndexType	Columns
PRIMARY	PRIMARY	IniEntryID MemberID

 

How to create

CREATE TABLE IniEntry(
IniEntryID INTEGER NOT NULL,
MemberType INTEGER,
MemberID INTEGER,
IniFile NVARCHAR(255),
IniSection NVARCHAR(255),
IniKey NVARCHAR(255),
IniValue NVARCHAR(255),
ReservedString1 NVARCHAR(255),
ReservedString2 NVARCHAR(255),
ReservedInt1 INTEGER,
ReservedInt2 INTEGER,
PRIMARY KEY (IniEntryID));