Write an SQL statement for updating the terms table column user_group_ids with an array of ids of user groups that a user group has term_id column set to match the term.id. Please reply with exactly 3 paragraphs and separate each paragraph with two new lines. The very first paragraph must start with the word "file".
user