UPDATE CADTAC11 SET NOMIMPRIMANTE = ''

	UPDATE COBROB02 SET ACTIF = 'FALSE' WHERE LOGICIEL = 'COL'   
	UPDATE COBROB02 SET STATUTROBOT = '1', INFOEXEC = '', DATEDERNEXEC = '18000101', HEUREDERNEXEC = ''
	UPDATE COBROB02 SET ACTIF = 'TRUE' WHERE LOGICIEL = 'COL' AND NOROBOT IN ('1')

	UPDATE CADGEN01 SET URLMOODLE = ''
	UPDATE CADGEN01 SET URLSOCI = ''

	UPDATE CADGEN01 SET URLMOODLETEST = 'https://campustest.cegepadistance.ca/'
	UPDATE COBWEB19 SET ADRPORTAIL = 'https://coba-dev.cegepadistance.ca/ColNetTest/login.asp'

	UPDATE COLGEN05 SET CHEMINSIGLE = '', CHEMINSIGNATURE = ''

	UPDATE CADGEN01 
	SET CHEMINAFE = REPLACE(CHEMINAFE, 'E:\CobaWeb\ColV6\Data\CAD\', 'C:\CobaWeb\ColV6Test\Data\CAD\'),
		CHEMINIMAGEDOSS = REPLACE(CHEMINIMAGEDOSS, 'E:\CobaWeb\ColV6\Data\CAD\', 'C:\CobaWeb\ColV6Test\Data\CAD\'),
		CHEMINPMTFEL = REPLACE(CHEMINPMTFEL, 'E:\CobaWeb\ColV6\Data\CAD\', 'C:\CobaWeb\ColV6Test\Data\CAD\'),
		CHEMINSOBEC  = REPLACE(CHEMINSOBEC, 'E:\CobaWeb\ColV6\Data\CAD\', 'C:\CobaWeb\ColV6Test\Data\CAD\'),
		CHEMINJRNROBOT = REPLACE(CHEMINJRNROBOT, 'E:\CobaWeb\ColV6\Data\CAD\', 'C:\CobaWeb\ColV6Test\Data\CAD\'),
		CHEMINIMP = REPLACE(CHEMINIMP, 'E:\CobaWeb\ColV6\Data\CAD\', 'C:\CobaWeb\ColV6Test\Data\CAD\'),
		CHEMINPOSTECAN = REPLACE(CHEMINPOSTECAN, 'E:\CobaWeb\ColV6\Data\CAD\', 'C:\CobaWeb\ColV6Test\Data\CAD\'),
		CHEMINSRAM = REPLACE(CHEMINSRAM, 'E:\CobaWeb\ColV6\Data\CAD\', 'C:\CobaWeb\ColV6Test\Data\CAD\'),
		CHEMINRAPPORT = REPLACE(CHEMINRAPPORT, 'E:\CobaWeb\ColV6\Data\CAD\', 'C:\CobaWeb\ColV6Test\Data\CAD\'),
		CHEMINFINANCES = REPLACE(CHEMINFINANCES, 'E:\CobaWeb\ColV6\Data\CAD\', 'C:\CobaWeb\ColV6Test\Data\CAD\')

	UPDATE COLTMP01 SET VALEURCHAMPTMP = 'N' WHERE TYPECHAMPTMP = 'TACHESCAD' AND CLECHAMPTMP IN ('TRSSYSEC', 'TRSSOCRATE', 'TRSARIANE', 'IMPRAPPORTPAPIER')
	UPDATE COLTMP01 SET VALEURCHAMPTMP = 'COBA' WHERE TYPECHAMPTMP = 'TACHESCAD' AND CLECHAMPTMP IN ('FTPIMPRIMEUR')
	UPDATE COLTMP01 SET VALEURCHAMPTMP = 'courrielscad@berger-levrault.com' WHERE TYPECHAMPTMP = 'TACHESCAD' AND CLECHAMPTMP IN ('ADRESSECOURRIELTEST')
	
	DELETE FROM COBTMP01 WHERE TYPECHAMPTMP = 'COBGES0114' AND CLECHAMPTMP = 'COLCOBAWEBAPPSPROD'
	DELETE FROM COBTMP01 WHERE TYPECHAMPTMP = 'COBGES0114' AND CLECHAMPTMP = 'COLSRV-COBA-WEBAPP'
	
	UPDATE COBWEB19 SET PARAMETRES = REPLACE(PARAMETRES, 'SITEANGLAIS=https://portail.cegepadistance.ca/colnet/login.asp?NoRegr=2', 'SITEANGLAIS=') 

	UPDATE COBWEB50 SET INDTRXREELLE = 'FALSE', NOMAGASINHPP = 'APblZVzSyft7ycK0', NOCPTMARCHANHPP = '00353', ADRTRXREELLEHPP = 'https://test.ctpaiement.ca' WHERE NOMARCHAND = 3
	UPDATE COBTMP01 SET MEMOCHAMPTMP = CHAR(0) + CHAR(0) + '5471J8T3S93ATOO634934V2KV08090E4P9' + CHAR(0) + '0' + CHAR(0) WHERE TYPECHAMPTMP = 'CTPAIEMENT' AND CLECHAMPTMP = '3'