UPDATE t_int_language SET fisstandard='1' WHERE fnumber in ('en_US','zh_TW','zh_CN');
UPDATE t_int_language SET fisstandard='0' WHERE fnumber not in ('en_US','zh_TW','zh_CN');

-- 德语
UPDATE t_int_language SET fstatus='C',fenable='0',fname='Deutsch (Deutschland)', fdescription = '德语 （德国）',fabbrcode='de_DE',fisstandard='1' where fnumber = 'de_DE';
UPDATE t_int_language_l SET fname='德语 （德国）',fdescription='德语 （德国）' WHERE fid=328738358987607040 and flocaleid='zh_CN';

-- 法语
UPDATE t_int_language SET fstatus='C',fenable='0',fname='français (France)', fdescription = '法语 （法国）',fabbrcode='fr_FR',fisstandard='1' where fnumber = 'fr_FR';
UPDATE t_int_language_l SET fname='法语 （法国）',fdescription='法语 （法国）' WHERE fid=328738365866492928 and flocaleid='zh_CN';


-- 印度尼西亚语
DELETE FROM t_int_language WHERE fid = 1976762420796751872;
INSERT INTO t_int_language (fid, fmasterid, fnumber, fisdefault, fenable, fstatus, fcreatorid, fcreatetime, fmodifierid, fmodifytime, fdisablerid, fdisabledate, fname, fdescription, fabbrcode, fisstandard) 
VALUES (1976762420796751872, 1976762420796751872, 'id_ID', '0', '0', 'C', 1, {ts'2024-06-20  00:00:00'}, 1, {ts'2024-06-20  00:00:00'}, 0, NULL, 'Bahasa Indonesia (Indonesia)', '印度尼西亚语 （印度尼西亚）', 'id_ID', '1');
DELETE FROM t_int_language_l WHERE fpkid = '46TGJZL87GI2';
INSERT INTO t_int_language_l (fpkid, fid, flocaleid, fname, fdescription) VALUES ('46TGJZL87GI2', 1976762420796751872, 'zh_CN', '印度尼西亚语 （印度尼西亚）', '印度尼西亚语 （印度尼西亚）');

-- 日语
UPDATE t_int_language SET fstatus='C',fenable='0',fname='日本語 (日本)', fdescription = '日语 （日本）',fabbrcode='ja_JP',fisstandard='1' where fnumber = 'ja_JP';
UPDATE t_int_language_l SET fname='日语 （日本）',fdescription='日语 （日本）' WHERE fid=328738389136491520 and flocaleid='zh_CN';

-- 马来语
UPDATE t_int_language SET fstatus='C',fenable='0',fname='Bahasa Melayu (Malaysia)', fdescription = '马来语 （马来西亚）',fabbrcode='ms_MY',fisstandard='1' where fnumber = 'ms_MY';
UPDATE t_int_language_l SET fname='马来语 （马来西亚）',fdescription='马来语 （马来西亚）' WHERE fid=328738382710590464 and flocaleid='zh_CN';

-- 泰语
UPDATE t_int_language SET fstatus='C',fenable='0',fname='ไทย (ไทย)', fdescription = '泰语 （泰国）',fabbrcode='th_TH',fisstandard='1' where fnumber = 'th_TH';
UPDATE t_int_language_l SET fname='泰语 （泰国）',fdescription='泰语 （泰国）' WHERE fid=328738394152879104 and flocaleid='zh_CN';

-- 越南语
UPDATE t_int_language SET fstatus='C',fenable='0',fname='Tiếng Việt (Việt Nam)', fdescription = '越南语 （越南）',fabbrcode='vi_VN',fisstandard='1' where fnumber = 'vi_VN';
UPDATE t_int_language_l SET fname='越南语 （越南）',fdescription='越南语 （越南）' WHERE fid=328738422556478464 and flocaleid='zh_CN';

-- 葡萄牙语
UPDATE t_int_language SET fstatus='C',fenable='0',fname='português (Portugal)', fdescription = '葡萄牙语 （葡萄牙）',fabbrcode='pt_PT',fisstandard='1' where fnumber = 'pt_PT';
UPDATE t_int_language_l SET fname='葡萄牙语 （葡萄牙）',fdescription='葡萄牙语 （葡萄牙）' WHERE fid=328738388523895808 and flocaleid='zh_CN';

DELETE FROM t_int_language_relation WHERE fid = 1;
INSERT INTO t_int_language_relation (fid, fstandardlan, fcustomlan) VALUES (1, 'de_DE', 'DE');
DELETE FROM t_int_language_relation WHERE fid = 2;
INSERT INTO t_int_language_relation (fid, fstandardlan, fcustomlan) VALUES (2, 'fr_FR', 'FR');
DELETE FROM t_int_language_relation WHERE fid = 3;
INSERT INTO t_int_language_relation (fid, fstandardlan, fcustomlan) VALUES (3, 'id_ID', 'ID');
DELETE FROM t_int_language_relation WHERE fid = 4;
INSERT INTO t_int_language_relation (fid, fstandardlan, fcustomlan) VALUES (4, 'ja_JP', 'JA');
DELETE FROM t_int_language_relation WHERE fid = 5;
INSERT INTO t_int_language_relation (fid, fstandardlan, fcustomlan) VALUES (5, 'ms_MY', 'MS');
DELETE FROM t_int_language_relation WHERE fid = 6;
INSERT INTO t_int_language_relation (fid, fstandardlan, fcustomlan) VALUES (6, 'th_TH', 'TH');
DELETE FROM t_int_language_relation WHERE fid = 7;
INSERT INTO t_int_language_relation (fid, fstandardlan, fcustomlan) VALUES (7, 'vi_VN', 'VI');
DELETE FROM t_int_language_relation WHERE fid = 8;
INSERT INTO t_int_language_relation (fid, fstandardlan, fcustomlan) VALUES (8, 'pt_PT', 'PT');
