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 = 'SPtbCCCliDocumentosLock')
BEGIN
       EXEC ('
       CREATE PROCEDURE SPtbCCCliDocumentosLock @Codigo nvarchar(3)
       AS
             IF NOT EXISTS (SELECT * FROM tbCCCliDocumentosLock WHERE teCodigo = @Codigo)
             BEGIN
                    INSERT INTO tbCCCliDocumentosLock VALUES(@Codigo,0)
             END
             UPDATE tbCCCliDocumentosLock SET lock=1 WHERE teCodigo=@Codigo
       ')
END