-- -----------------------------------------------------
-- Data for table `externalAdmterTypeT`
-- -----------------------------------------------------
START TRANSACTION;

INSERT INTO externalAdmterTypeT (id, typeCode) 
VALUES (2, 'oblast') 
on duplicate key update typeCode = 'oblast';

INSERT INTO externalAdmterTypeT (id, typeCode) 
VALUES (3, 'raion') 
on duplicate key update typeCode = 'raion';

INSERT INTO externalAdmterTypeT (id, typeCode) 
VALUES (4, 'neighborhood') 
on duplicate key update typeCode = 'neighborhood';

INSERT INTO externalAdmterTypeT (id, typeCode) 
VALUES (5, 'villagecouncil') 
on duplicate key update typeCode = 'villagecouncil';

INSERT INTO externalAdmterTypeT (id, typeCode) 
VALUES (6, 'locality') 
on duplicate key update typeCode = 'locality';

INSERT INTO externalAdmterTypeT (id, typeCode) 
VALUES (7, 'locality') 
on duplicate key update typeCode = 'locality';

INSERT INTO externalAdmterTypeT (id, typeCode) 
VALUES (8, 'locality') 
on duplicate key update typeCode = 'locality';

INSERT INTO externalAdmterTypeT (id, typeCode) 
VALUES (9, 'locality') 
on duplicate key update typeCode = 'locality';

COMMIT;


-- -----------------------------------------------------
-- Data for table `externalAdmterTypeTL`
-- -----------------------------------------------------
START TRANSACTION;

INSERT INTO externalAdmterTypeTL (id, languageId, prefix, suffix) 
VALUES (2, 'ukr', '', 'область') 
on duplicate key update
    prefix = '',
    suffix = 'область';

INSERT INTO externalAdmterTypeTL (id, languageId, prefix, suffix) 
VALUES (2, 'rus', '', 'область') 
on duplicate key update
    prefix = '',
    suffix = 'область';

INSERT INTO externalAdmterTypeTL (id, languageId, prefix, suffix) 
VALUES (2, 'eng', '', 'oblast') 
on duplicate key update
    prefix = '',
    suffix = 'oblast';

INSERT INTO externalAdmterTypeTL (id, languageId, prefix, suffix) 
VALUES (3, 'ukr', '', 'район') 
on duplicate key update
    prefix = '',
    suffix = 'район';

INSERT INTO externalAdmterTypeTL (id, languageId, prefix, suffix) 
VALUES (3, 'rus', '', 'район') 
on duplicate key update
    prefix = '',
    suffix = 'район';

INSERT INTO externalAdmterTypeTL (id, languageId, prefix, suffix) 
VALUES (3, 'eng', '', 'raion') 
on duplicate key update
    prefix = '',
    suffix = 'raion';

INSERT INTO externalAdmterTypeTL (id, languageId, prefix, suffix) 
VALUES (4, 'ukr', '', 'район') 
on duplicate key update
    prefix = '',
    suffix = 'район';

INSERT INTO externalAdmterTypeTL (id, languageId, prefix, suffix) 
VALUES (4, 'rus', '', 'район') 
on duplicate key update
    prefix = '',
    suffix = 'район';

INSERT INTO externalAdmterTypeTL (id, languageId, prefix, suffix) 
VALUES (4, 'eng', '', 'district') 
on duplicate key update
    prefix = '',
    suffix = 'district';

INSERT INTO externalAdmterTypeTL (id, languageId, prefix, suffix) 
VALUES (5, 'ukr', '', 'сільська рада') 
on duplicate key update
    prefix = '',
    suffix = 'сільська рада';

INSERT INTO externalAdmterTypeTL (id, languageId, prefix, suffix) 
VALUES (5, 'rus', '', 'сельский совет') 
on duplicate key update
    prefix = '',
    suffix = 'сельский совет';

INSERT INTO externalAdmterTypeTL (id, languageId, prefix, suffix) 
VALUES (5, 'eng', '', 'village council') 
on duplicate key update
    prefix = '',
    suffix = 'village council';

INSERT INTO externalAdmterTypeTL (id, languageId, prefix, suffix) 
VALUES (6, 'ukr', 'м.', '') 
on duplicate key update
    prefix = 'м.',
    suffix = '';

INSERT INTO externalAdmterTypeTL (id, languageId, prefix, suffix) 
VALUES (6, 'rus', 'г.', '') 
on duplicate key update
    prefix = 'г.',
    suffix = '';

INSERT INTO externalAdmterTypeTL (id, languageId, prefix, suffix) 
VALUES (6, 'eng', '', 'city') 
on duplicate key update
    prefix = '',
    suffix = 'city';

INSERT INTO externalAdmterTypeTL (id, languageId, prefix, suffix) 
VALUES (7, 'ukr', 'смт.', '') 
on duplicate key update
    prefix = 'смт.',
    suffix = '';

INSERT INTO externalAdmterTypeTL (id, languageId, prefix, suffix) 
VALUES (7, 'rus', 'пгт.', '') 
on duplicate key update
    prefix = 'пгт.',
    suffix = '';

INSERT INTO externalAdmterTypeTL (id, languageId, prefix, suffix) 
VALUES (7, 'eng', '', 'township') 
on duplicate key update
    prefix = '',
    suffix = 'township';

INSERT INTO externalAdmterTypeTL (id, languageId, prefix, suffix) 
VALUES (8, 'ukr', 'с.', '') 
on duplicate key update
    prefix = 'с.',
    suffix = '';

INSERT INTO externalAdmterTypeTL (id, languageId, prefix, suffix) 
VALUES (8, 'rus', 'с.', '') 
on duplicate key update
    prefix = 'с.',
    suffix = '';

INSERT INTO externalAdmterTypeTL (id, languageId, prefix, suffix) 
VALUES (8, 'eng', '', 'village') 
on duplicate key update
    prefix = '',
    suffix = 'village';

INSERT INTO externalAdmterTypeTL (id, languageId, prefix, suffix) 
VALUES (9, 'ukr', 'с-ще', '') 
on duplicate key update
    prefix = 'с-ще',
    suffix = '';

INSERT INTO externalAdmterTypeTL (id, languageId, prefix, suffix) 
VALUES (9, 'rus', 'пос.', '') 
on duplicate key update
    prefix = 'пос.',
    suffix = '';

INSERT INTO externalAdmterTypeTL (id, languageId, prefix, suffix) 
VALUES (9, 'eng', '', 'hamlet') 
on duplicate key update
    prefix = '',
    suffix = 'hamlet';

COMMIT;