summaryrefslogtreecommitdiff
path: root/Codemerx/Gestor.Application.Migration.Files.20230718_226.SQL
blob: 3b30e8b6ac2995b9dfb86763139574b9d44c6b32 (plain)
1
2
3
4
5
6
7
8
9
IF (object_id( 'Permissao' ) IS NOT NULL)
BEGIN
    IF NOT EXISTS(SELECT 1 FROM [dbo].[Permissao] WHERE [idpermissao] = 0)
    BEGIN
	    SET IDENTITY_INSERT Permissao ON 
        INSERT INTO Permissao (idpermissao,Nome,Tipo) VALUES (0,'Sem Acesso',0)
        SET IDENTITY_INSERT Permissao OFF
    END
END