﻿ALTER TABLE T_DICTIONARYITEMBASE NOCHECK CONSTRAINT all


ALTER TABLE T_ELETPALYAMODELLSTATUSZOK NOCHECK CONSTRAINT all


ALTER TABLE T_PEDAGOGUSELETPALYAMODELL NOCHECK CONSTRAINT all

UPDATE T_PEDAGOGUSELETPALYAMODELL
	SET C_PORTFOLIOSTATUSZ = 6521
	WHERE C_PORTFOLIOSTATUSZ IS NOT NULL
	  AND C_PORTFOLIOSTATUSZ IN (1571, 1572, 1573, 1574)

ALTER TABLE T_PEDAGOGUSELETPALYAMODELL WITH CHECK CHECK CONSTRAINT all


UPDATE T_ELETPALYAMODELLSTATUSZOK
	SET TOROLT = 'T'
	WHERE ID IN (1571, 1572, 1573, 1574)

ALTER TABLE T_ELETPALYAMODELLSTATUSZOK WITH CHECK CHECK CONSTRAINT all


UPDATE T_DICTIONARYITEMBASE
	SET TOROLT = 'T'
	WHERE ID IN (1571, 1572, 1573, 1574, 1291)

ALTER TABLE T_DICTIONARYITEMBASE WITH CHECK CHECK CONSTRAINT all


ALTER TABLE T_TARGYKATEGORIATIPUS NOCHECK CONSTRAINT all

UPDATE T_TARGYKATEGORIATIPUS
	SET TOROLT = 'T'
	WHERE ID = 1291

ALTER TABLE T_TARGYKATEGORIATIPUS WITH CHECK CHECK CONSTRAINT all

UPDATE T_TANTARGY
	SET C_TARGYKATEGORIA = 1197
	WHERE C_TARGYKATEGORIA IS NOT NULL
	  AND C_TARGYKATEGORIA = 1291
