if (select count(*) from PermissionTypes where Name='Право сторни операции')=0 then INSERT INTO PermissionTypes(N,Name,"Default") VALUES((select max(N+1) from PermissionTypes),'Право сторни операции',1); end if; GO FOR f AS curs scroll CURSOR FOR SELECT n as nomer FROM admingroups DO if (select count(*) from Permissions where GroupNo=nomer and PermissionNo=(select N from PermissionTypes where Name='Право сторни операции'))=0 then if nomer = 1 then insert into permissions values ( nomer, (select N from PermissionTypes where Name='Право сторни операции'), 0 ) else insert into permissions values ( nomer, (select N from PermissionTypes where Name='Право сторни операции'), 1 ) end if; end if; END FOR; GO if (select count(*) from PermissionTags where TagNo=5010 and Type= (select N from PermissionTypes where Name='Право сторни операции'))=0 then INSERT INTO PermissionTags(TagNo,Type,Note) VALUES(5010,(select N from PermissionTypes where Name='Право сторни операции'),'Право сторни операции'); end if;