Scout Database Model (CR)
Table: XkbLayout
Static table, do not change.
Holds a list of available keyboard layout names.
| ColumnName | DataType | Key | Not Null | Default Value | Comment |
|---|---|---|---|---|---|
| XkbLayoutID | INTEGER | PK | NN | Unique ID of keyboard layout entry | |
| Name | NVARCHAR(255) | NN | Locale name (e.g. de, us) | ||
| ReservedString1 | NVARCHAR(255) | ||||
| ReservedString2 | NVARCHAR(255) | ||||
| ReservedInt1 | INTEGER | ||||
| ReservedInt2 | INTEGER |
| IndexName | IndexType | Columns |
|---|---|---|
| PRIMARY | PRIMARY | XkbLayoutID |
How to create
CREATE TABLE XkbLayout(
XkbLayoutID INTEGER NOT NULL,
Name NVARCHAR(255) NOT NULL,
ReservedString1 NVARCHAR(255),
ReservedString2 NVARCHAR(255),
ReservedInt1 INTEGER,
ReservedInt2 INTEGER,
PRIMARY KEY (XkbLayoutID));
How to initialize
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('1','be');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('2','cz');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('3','us_cz');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('4','dk');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('5','nl');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('6','gb');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('7','us');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('8','fr');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('9','fr_CH');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('10','de');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('11','de_CH');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('12','hu');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('13','it');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('14','no');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('15','pl');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('16','pl(programmers)');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('17','pt');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('18','sk');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('19','see1');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('20','es');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('21','se');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('22','trf');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('23','trq');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('24','en_US');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('25','be(nl)');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('26','ru');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('27','fi');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('28','is');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('29','ee');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('30','fo');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('31','jp');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('32','bg');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('33','la');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('34','br(abnt)');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('35','br(abnt2)');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('36','bg(phonetic)');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('37','el');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('38','hr');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('39','jp(OADG109A)');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('40','ca(fr)');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('41','ca(multix)');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('42','ca(fr-legacy)');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('43','lv');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('44','lt');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('45','lt(std)');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('46','lt(ibm)');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('47','ie');
INSERT INTO XkbLayout (XkbLayoutID,Name) VALUES('48','pl(std)');
Table: XkbLayout
Copied!
Failed!