INSERT INTO FNV (FNV_ID,FNV_FUNCTION,FNV_ACCESS_VALS,FNV_DEFAULT,FNV_CHANGE_COUNT) SELECT ISNULL((SELECT MAX(FNV_ID)+1 FROM FNV),1),'webTeamSplit','No,Yes','No',1  FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM FNV f2 WHERE f2.FNV_FUNCTION='webTeamSplit' AND f2.FNV_ACCESS_VALS='No,Yes');
GO

IF EXISTS (SELECT 1 FROM OPT WHERE (OPT_ID = 4) AND (OPT_NAME <> 'teamroleSPLITONSUBMIT'))
THROW 60000, 'Invalid pre-existing ''OPT'' record', 1
GO

IF NOT EXISTS (SELECT 1 FROM OPT WHERE (OPT_ID = 4))
INSERT INTO OPT (OPT_ID, OPT_DESCR, OPT_TBL, OPT_NAME, OPT_DEFAULT, OPT_CHANGE_COUNT) values (4, 'Split FTEs into standalone roles when submitting', NULL, 'teamroleSPLITONSUBMIT', NULL, 1);
GO