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)');