Table: Language

This is a static table, do not change.

A static table that contains all known locales ofScout.

ColumnName	DataType	Key	Not Null	Default Value	Comment
ColumnName	DataType	Key	Not Null	Default Value	Comment
LanguageID	INTEGER	PK	NN		Unique ID of language entry
Name	NVARCHAR(255)		NN		Locale such as de_DE, en_US)
ReservedString1	NVARCHAR(255)
ReservedString2	NVARCHAR(255)
ReservedInt1	INTEGER
ReservedInt2	INTEGER

IndexName	IndexType	Columns
PRIMARY	PRIMARY	LanguageID

 

how to create

CREATE TABLE Language(
LanguageID INTEGER NOT NULL,
Name NVARCHAR(255) NOT NULL,
ReservedString1 NVARCHAR(255),
ReservedString2 NVARCHAR(255),
ReservedInt1 INTEGER,
ReservedInt2 INTEGER,
PRIMARY KEY (LanguageID));

 

How to initialize

INSERT INTO Language (LanguageID,Name) VALUES('1','da_DK');
INSERT INTO Language (LanguageID,Name) VALUES('2','de_DE');
INSERT INTO Language (LanguageID,Name) VALUES('3','de_CH');
INSERT INTO Language (LanguageID,Name) VALUES('4','en_GB');
INSERT INTO Language (LanguageID,Name) VALUES('5','en_US');
INSERT INTO Language (LanguageID,Name) VALUES('6','fr_FR');
INSERT INTO Language (LanguageID,Name) VALUES('7','fr_CH');
INSERT INTO Language (LanguageID,Name) VALUES('8','fr_BE');
INSERT INTO Language (LanguageID,Name) VALUES('9','nl_BE');
INSERT INTO Language (LanguageID,Name) VALUES('10','it_IT');
INSERT INTO Language (LanguageID,Name) VALUES('11','nl_NL');
INSERT INTO Language (LanguageID,Name) VALUES('12','hr_HR');
INSERT INTO Language (LanguageID,Name) VALUES('13','no_NO');
INSERT INTO Language (LanguageID,Name) VALUES('14','pl_PL');
INSERT INTO Language (LanguageID,Name) VALUES('15','pt_PT');
INSERT INTO Language (LanguageID,Name) VALUES('16','ro_RO');
INSERT INTO Language (LanguageID,Name) VALUES('17','sv_SE');
INSERT INTO Language (LanguageID,Name) VALUES('18','sl_SI');
INSERT INTO Language (LanguageID,Name) VALUES('19','es_ES');
INSERT INTO Language (LanguageID,Name) VALUES('20','cs_CZ');
INSERT INTO Language (LanguageID,Name) VALUES('21','hu_HU');
INSERT INTO Language (LanguageID,Name) VALUES('22','tr_TR');
INSERT INTO Language (LanguageID,Name) VALUES('23','ru_RU.ISO8859-5');
INSERT INTO Language (LanguageID,Name) VALUES('24','fi_FI');
INSERT INTO Language (LanguageID,Name) VALUES('25','sk_SK');
INSERT INTO Language (LanguageID,Name) VALUES('26','is_IS');
INSERT INTO Language (LanguageID,Name) VALUES('27','et_EE');
INSERT INTO Language (LanguageID,Name) VALUES('28','pt_BR');
INSERT INTO Language (LanguageID,Name) VALUES('29','el_GR');
INSERT INTO Language (LanguageID,Name) VALUES('30','ja_JP');