Scout Database Model (CR)
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 |
| auto - auto-detect (Buttons=5) | |||||
| PS/2 - 2 button mouse (Buttons=2) or 3 button mouse (Buttons=3) | |||||
| IMPS/2 - wheel mouse (Buttons=5) | |||||
| none - no mouse (set Buttons=none) | |||||
| LeftHandMouse | SMALLINT(6) | NN | 0 | Left hand mouse0/1 | |
| MultiClickTime | INTEGER | NN | 500 | Double click time 100(fast) - 900(slow) | |
| DeadKeys | SMALLINT(6) | NN | 1 | Dead keys active0/1 | |
| Numlock | SMALLINT(6) | NN | 1 | Numlock at start0/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 keys127: All keys | |||
| TouchpadState | TINYINT | 1 |
| IndexName | IndexType | Columns |
|---|---|---|
| PRIMARY | PRIMARY | MouseKBIDMemberID |
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));
Table: MouseKB
In this article
Copied!
Failed!