if not exists(select * from PermissionTags where TagNo = 8000) then insert into "PermissionTags" ("TagNo", "Type", "Note") values(8000, 1000, 'Внасяне на пари в касовия апарат'); end if; GO if not exists(select * from PermissionTags where TagNo = 8001) then insert into "PermissionTags" ("TagNo", "Type", "Note") values(8001, 1000, 'Изнасяне на пари от касовия апарат'); end if; GO if not exists(select * from PermissionTypes where N = 15000) then insert into PermissionTypes(N,Name,"Default") values(15000,'Одит',1); end if; GO if not exists(select * from PermissionTags where TagNo = 9000) then insert into "PermissionTags" ("TagNo", "Type", "Note") values(9000, 15000, 'Одиторски справки'); end if; GO if not exists(select * from PermissionTags where TagNo = 9001) then insert into "PermissionTags" ("TagNo", "Type", "Note") values(9001, 15000, 'Достъп до базата данни'); end if; GO if not exists(select * from Permissions where GroupNo = 100 and PermissionNo = 15000) then insert into Permissions(GroupNo,PermissionNo,Stoinost) values(100,15000,0) end if; GO insert into DBA.Permissions( GroupNo,PermissionNo,Stoinost ) select 100,PermissionNo,Stoinost from Permissions where GroupNo = -1