Register new WCS store view by using database

To register a new view by using SQL queries:

insert into acaction (acaction_id, action) values ((select counter from keys where tablename='acaction'), 'NewView'); 

insert into acactactgp (ACACTGRP_ID,ACACTION_ID) values 
((SELECT ACACTGRP_ID FROM ACACTGRP WHERE GROUPNAME = 'AllSiteUsersViews' 
and member_id in (select orgentity_id from orgentity where orgentityname='Root Organization') 
), 
(select acaction_id from acaction where action='NewView')); 

UPDATE KEYS SET COUNTER = COUNTER+1 WHERE TABLENAME = 'acaction';
commit