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 |
|
|||||||||||||||||
MemberID | INTEGER | (FK) | NN | MemberID (depending on MemberType. this refers to table Groups or Device) | |||||||||||||||
PointerProtocol | NVARCHAR(10) | NN | auto | Mouse
pointer protocol
|
|||||||||||||||
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) |
|
|||||||||||||||||
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));