Table: MouseKB

Each record represents a set of mouse and keyboard settings which are relevant to a single device or group.

ColumnName DataType Key Not Null DefaultValue Comment
MouseKBID INTEGER PK NN   Unique ini entry ID
MemberType INTEGER      
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)
PointerProtocol NVARCHAR(10)   NN auto Mouse pointer protocol
autoauto-detect (Buttons=5
PS/22 button mouse (Buttons=2) or 3 button mouse (Buttons=3
IMPS/2wheel mouse (Buttons=5
noneno mouse (set Buttons=none)
LeftHandMouse SMALLINT(6)   NN 0 Left hand mouse
0|1
MultiClickTime INTEGER   NN 500 Double click time 100(fast) - 900(slow)
DeadKeys SMALLINT(6)   NN 1 Dead keys active
0|1
Numlock  SMALLINT(6)   NN 1 Numlock at start
0|1
PointerSpeed NVARCHAR(15)     2/1 Mouse acceleration 3/10(slow) - 13/2(fast)
KeyboardDelay INTEGER     500 Keyboard delay (100-1510)
KeyboardSpeed INTEGER   NN 30 Keyboard speed (10-250)
ConsoleSwitch INTEGER        
XkbLayoutID INTEGER FK NN   Keyboard Layout (foreign key refers to table Xkblayout.XkbLayoutID)
KeyboardModel NVARCHAR(255)      
Auto Keyboard model is detected automatically: configured by default
Cherry Cherry G81-8000 keyboard
Desko Desko MCx 4717 keyboard
K293 MFII keyboard
TYPE6 Sun Type6 keyboard
K235 Trimo 3270 keyboard
K257 97801 keyboard
ExtendedKeys INTEGER       0: No keys
127: All keys
TouchpadState TINYINT     1  
IndexName IndexType Columns
PRIMARY PRIMARY MouseKBID
MemberID

 

How to create

CREATE TABLE MouseKB(
MouseKBID INTEGER NOT NULL,
MemberType INTEGER NOT NULL,
MemberID INTEGER NOT NULL,
PointerProtocol NVARCHAR(10) NOT NULL,
LeftHandMouse SMALLINT NOT NULL,
MultiClickTime INTEGER NOT NULL,
DeadKeys SMALLINT NOT NULL,
Numlock SMALLINT NOT NULL,
PointerSpeed NVARCHAR(15),
KeyboardDelay INTEGER,
KeyboardSpeed INTEGER NOT NULL,
ConsoleSwitch INTEGER,
XkbLayoutID INTEGER NOT NULL,
KeyboardModel NVARCHAR(255),
TouchpadState TINYINT,
ExtendedKeys INTEGER,
PRIMARY KEY (MouseKBID));