

/*populating current table and Backlog*/


INSERT INTO PROJECTIONS VALUES(1, "A",12, 1, 1, 1)
UPDATE P_Log
SET When_Changed='01/01/1996'
WHERE PROJECTION_ID=1


INSERT INTO PROJECTIONS VALUES(2, "B",10, 1, 1, 1)
UPDATE P_Log 
SET When_Changed='01/01/1996'
WHERE PROJECTION_ID=2


INSERT INTO PROJECTIONS VALUES(3, "C",15, 1, 1, 1)
UPDATE P_Log 
SET When_Changed='01/01/1996'
WHERE PROJECTION_ID=3


INSERT INTO PROJECTIONS VALUES(4, "D",17, 1, 1, 1)
UPDATE P_Log 
SET When_Changed='01/01/1996'
WHERE PROJECTION_ID=4


INSERT INTO PROJECTIONS VALUES(5, "E",18, 1, 1, 1)
UPDATE P_Log 
SET When_Changed='01/01/1996'
WHERE PROJECTION_ID=5


DELETE FROM PROJECTIONS WHERE PROJECTION_ID=5 
UPDATE P_Log 
SET When_Changed='02/3/1996' 
WHERE PROJECTION_ID=5 
AND
	(When_Changed=(	SELECT MAX(When_Changed) 
			FROM P_Log 
			WHERE PROJECTION_ID=5))


UPDATE PROJECTIONS 
SET PROJECTION_TYPE=13 
WHERE PROJECTION_ID=2
UPDATE P_Log 
SET When_Changed='3/20/1996'
WHERE PROJECTION_ID=2
AND 
	(When_Changed=(	SELECT MAX(When_Changed) 
			FROM P_Log 
			WHERE PROJECTION_ID=2))


UPDATE PROJECTIONS 
SET PROJECTION_TYPE=11 
WHERE PROJECTION_ID=3
UPDATE P_Log 
SET When_Changed='5/28/1996'
WHERE PROJECTION_ID=3 
AND
	(When_Changed=(	SELECT MAX(When_Changed) 
			FROM P_Log 
			WHERE PROJECTION_ID=3))


UPDATE PROJECTIONS 
SET PROJECTION_TYPE=14 
WHERE PROJECTION_ID=2
UPDATE P_Log 
SET When_Changed='6/14/1996'
WHERE PROJECTION_ID=2 
AND
	(When_Changed=(	SELECT MAX(When_Changed) 
			FROM P_Log 
			WHERE PROJECTION_ID=2))


INSERT INTO PROJECTIONS VALUES(5, "E", 19, 1, 1, 1)
UPDATE P_Log 
SET When_Changed='04/09/1996'
WHERE PROJECTION_ID=5 
AND
	(When_Changed=(	SELECT MAX(When_Changed) 
			FROM P_Log 
			WHERE PROJECTION_ID=5))


DELETE FROM PROJECTIONS 
WHERE PROJECTION_ID=4 
UPDATE P_Log 
SET When_Changed='07/12/1996'
WHERE PROJECTION_ID=4 
AND
	(When_Changed=(	SELECT MAX(When_Changed) 
			FROM P_Log 
			WHERE PROJECTION_ID=4))


INSERT INTO PROJECTIONS VALUES(4, "D", 18, 1, 1, 1)
UPDATE P_Log 
SET When_Changed='08/30/1996'
WHERE PROJECTION_ID=4 
AND
	(When_Changed=(	SELECT MAX(When_Changed) 
			FROM P_Log 
			WHERE PROJECTION_ID=4))
