mi
17 lines
530 B
Markdown
17 lines
530 B
Markdown
INSERT INTO han_app.popular_questions (
|
|
id,
|
|
mnemonic,
|
|
locale,
|
|
question_text,
|
|
sort_order,
|
|
record_status
|
|
)
|
|
VALUES
|
|
(gen_random_uuid(), 'popular.patent_check', 'ru', 'Проверить патент', 20, 'A'),
|
|
(gen_random_uuid(), 'popular.rkl_check', 'ru', 'Проверить в РКЛ', 30, 'A')
|
|
ON CONFLICT (mnemonic, locale) DO UPDATE
|
|
SET
|
|
question_text = EXCLUDED.question_text,
|
|
sort_order = EXCLUDED.sort_order,
|
|
record_status = 'A',
|
|
updated_at = now(); |