update apw_DAwardChapterName set sorter = sorter + 5 where sorter > 8;

insert into apw_DAwardChapterName (`id`, `title`, `type`, `sorter`) values
('projectYearTransportation', 'Project of the Year - Transportation', 'reward', 10),
('projectYearStructures', 'Project of the Year - Structures', 'reward', 9),
('projectYearEnvironment', 'Project of the Year - Environment', 'reward', 11),
('projectYearRestoration', 'Project of the Year - Historical Restoration / Preservation', 'reward', 12),
('projectYearRepair', 'Project of the Year - Disaster or Emergency Construction Repair', 'reward', 13);

-- --------------------------------------------------------------------------------------------------------------------

update apw_DAwardChapterName set sorter = sorter + 1 where sorter > 13;

insert into apw_DAwardChapterName (`id`, `title`, `type`, `sorter`) values
('projectYearOutstate', 'Project of the Year - Outstate', 'reward', 14);
