RM 2.1 How can I update this value through SQL query?

[Sadiq6210]

Hello,

In RM Edit category, there is an option called (Enable versioning)
This option is selected by default and we want to uncheck this option for ALL RM categories, however we have 519 categories and it is difficult to edit each category.

What is the SQL query that we can run to uncheck (Enable versioning) for all categories?

 

[Sadiq6210]

OK I did it, this is the query if anyone need it:

UPDATE xf_rm_category
SET enable_versioning = REPLACE(enable_versioning, '1', '0');