Gerrit remove Need Verified +1 (Verified)

I just installed a Gerrit server and wish to get rid of the Need Verified +1 (Verified) permission. Our team would only like to +2 changes instead of doing both things.

I tried following the steps at http://review.coreboot.org/Documentation/access-control.html#category_CVRW

DELETE FROM approval_categories      WHERE category_id = 'VRIF';
DELETE FROM approval_category_values WHERE category_id = 'VRIF';

But I'm running a H2 database and I guess I'm just not sure exactly how to edit it without using J开发者_运维知识库ava.

You can use the gerrit gsql command to get interactive query support directly against the underlying SQL database: http://review.coreboot.org/Documentation/cmd-gsql.html

ssh -p 29418 review.example.com gerrit gsql

There you can issue the DELETE commands:

DELETE FROM approval_categories      WHERE category_id = 'VRIF';
DELETE FROM approval_category_values WHERE category_id = 'VRIF';