IF  NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID('dbo.tbCCCliDocumentosLock'))
BEGIN
       CREATE TABLE dbo.tbCCCliDocumentosLock
       (
             teCodigo NVARCHAR(3) PRIMARY KEY,
             lock BIT NOT NULL
       )
END

IF NOT EXISTS (SELECT * FROM sys.objects WHERE type = 'P' AND name = 'SPtbCCCliDocumentosUnLock')
BEGIN
       EXEC ('
       CREATE PROCEDURE SPtbCCCliDocumentosUnLock @Codigo nvarchar(3)
       AS
       BEGIN
       IF NOT EXISTS (SELECT * FROM tbCCCliDocumentosLock WHERE teCodigo = @Codigo)
             BEGIN
                    INSERT INTO tbCCCliDocumentosLock VALUES(@Codigo,0)
             END
             UPDATE tbCCCliDocumentosLock SET lock=0 WHERE teCodigo=@Codigo
       END')
END