--Hash:FABBA3B2C642B5A61A14ABEA7FA8B21D
SET XACT_ABORT ON
BEGIN TRANSACTION;

GO

SET DATEFORMAT mdy;

--Validar que no existan scripts que no se hayan ejecutado
--//
IF EXISTS
(
	SELECT a.NumVersion + 1 AS HuecoInicio
	FROM ZiurVersiones a
	LEFT JOIN ZiurVersiones b ON a.NumVersion + 1 = b.NumVersion
	WHERE a.NumVersion>830 AND b.NumVersion IS NULL
	AND a.NumVersion + 1 < 893
)
RAISERROR('Error : hay un script que no se ejecuto , debe ejecutarlo manualmente.', 20, -1) with log
--//

/*
 Plantilla de script anterior a la implementación							
--------------------------------------------------------------------------------------
 Este archivo contiene instrucciones de SQL que se ejecutarán antes del script de compilación	
 Use la sintaxis de SQLCMD para incluir un archivo en el script anterior a la implementación			
 Ejemplo:      :r .\miArchivo.sql								
 Use la sintaxis de SQLCMD para hacer referencia a una variable en el script anterior a la implementación		
 Ejemplo:      :setvar TableName miTabla							
               SELECT * FROM [$(TableName)]					
--------------------------------------------------------------------------------------
*/
GO

UPDATE Permisos_Interfaces SET VideoURL = 'https://youtu.be/nOq-cyxurYM' WHERE IdInterface = 3
UPDATE Permisos_Interfaces SET VideoURL = 'https://youtu.be/sesSiRa_ySM' WHERE IdInterface = 4
UPDATE Permisos_Interfaces SET VideoURL = 'https://youtu.be/-cZhkO03VVE' WHERE IdInterface = 5
UPDATE Permisos_Interfaces SET VideoURL = 'https://youtu.be/byzUWWJ-Xac' WHERE IdInterface = 6
UPDATE Permisos_Interfaces SET VideoURL = 'https://youtu.be/Kpj3hpCr-O4' WHERE IdInterface = 7
UPDATE Permisos_Interfaces SET VideoURL = 'https://youtu.be/NUJQWJctrz4' WHERE IdInterface = 8
UPDATE Permisos_Interfaces SET VideoURL = 'https://youtu.be/Ril21CBfqpM' WHERE IdInterface = 10
UPDATE Permisos_Interfaces SET VideoURL = 'https://youtu.be/wKgVd3MyprA' WHERE IdInterface = 11
UPDATE Permisos_Interfaces SET VideoURL = 'https://youtu.be/GwtpZJTu0nI' WHERE IdInterface = 14
UPDATE Permisos_Interfaces SET VideoURL = 'https://youtu.be/1s-tdapHilQ' WHERE IdInterface = 15
UPDATE Permisos_Interfaces SET VideoURL = 'https://youtu.be/Os1hWeJpkb8' WHERE IdInterface = 16
UPDATE Permisos_Interfaces SET VideoURL = 'https://youtu.be/B1bZRlGro5c' WHERE IdInterface = 17
UPDATE Permisos_Interfaces SET VideoURL = 'https://youtu.be/-TTpO2gPJtQ' WHERE IdInterface = 20
UPDATE Permisos_Interfaces SET VideoURL = 'https://youtu.be/dIJsKIkOCQY' WHERE IdInterface = 25
UPDATE Permisos_Interfaces SET VideoURL = 'https://youtu.be/ECpl2B8tLig' WHERE IdInterface = 28
UPDATE Permisos_Interfaces SET VideoURL = 'https://youtu.be/0ebcZrZ38HQ' WHERE IdInterface = 29
UPDATE Permisos_Interfaces SET VideoURL = 'https://youtu.be/Nys19GUfnos' WHERE IdInterface = 42
UPDATE Permisos_Interfaces SET VideoURL = 'https://youtu.be/lYh6dIUbWKM' WHERE IdInterface = 43
UPDATE Permisos_Interfaces SET VideoURL = 'https://youtu.be/pXkEvUq3jQc' WHERE IdInterface = 45
UPDATE Permisos_Interfaces SET VideoURL = 'https://youtu.be/EegvcA33Cmw' WHERE IdInterface = 46
UPDATE Permisos_Interfaces SET VideoURL = 'https://youtu.be/P717xpb0_mE' WHERE IdInterface = 49
UPDATE Permisos_Interfaces SET VideoURL = 'https://youtu.be/bm5jH7nJCms' WHERE IdInterface = 50
UPDATE Permisos_Interfaces SET VideoURL = 'https://youtu.be/Lr541IXYbD8' WHERE IdInterface = 133
UPDATE Permisos_Interfaces SET VideoURL = 'https://youtu.be/n5xAQTnbkYo' WHERE IdInterface = 162
UPDATE Permisos_Interfaces SET VideoURL = 'https://youtu.be/VoXQkHmy9TM' WHERE IdInterface = 183
UPDATE Permisos_Interfaces SET VideoURL = 'https://youtu.be/PG6dtWuyznU' WHERE IdInterface = 188
UPDATE Permisos_Interfaces SET VideoURL = 'https://youtu.be/J82mSh7AV9k' WHERE IdInterface = 284
UPDATE Permisos_Interfaces SET VideoURL = 'https://youtu.be/Ik6T2qDOBf0' WHERE IdInterface = 298
UPDATE Permisos_Interfaces SET VideoURL = 'https://youtu.be/wurCCXo0p_g' WHERE IdInterface = 330
UPDATE Permisos_Interfaces SET VideoURL = 'https://youtu.be/c6Ww1IkM0aE' WHERE IdInterface = 341
UPDATE Permisos_Interfaces SET VideoURL = 'https://youtu.be/wKsZwn-Ffys' WHERE IdInterface = 342
UPDATE Permisos_Interfaces SET VideoURL = 'https://youtu.be/6I3C2jQQtIc' WHERE IdInterface = 351
UPDATE Permisos_Interfaces SET VideoURL = 'https://youtu.be/XM7VWjRH3I0' WHERE IdInterface = 359
UPDATE Permisos_Interfaces SET VideoURL = 'https://youtu.be/o8gDuzjQO6U' WHERE IdInterface = 387
UPDATE Permisos_Interfaces SET VideoURL = 'https://youtu.be/ymGRfxwt85Q' WHERE IdInterface = 48
GO


INSERT INTO ZiurVersiones (IdVersion, NumVersion, Descripcion)
VALUES (303,893,'Videos Corte Julio 2021')
GO

COMMIT;
GO
