ALTER TABLE `mm_PersonnelPosition` ADD UNIQUE(`title`);
ALTER TABLE `mm_PersonnelPosition` ADD `old` ENUM('n','y') NOT NULL AFTER `sorter`, ADD INDEX (`old`) ;
UPDATE `mm_PersonnelPosition` SET `old` = 'y';

INSERT INTO `mm_PersonnelPosition` (`title`, `old`) VALUES
('Accountant/Bookkeeper', 'n'),
('Administrative Assistant', 'n'),
('Apprentice Lineworker', 'n'),
('Assistant City Manager/Administrator', 'n'),
('Assistant General Manager', 'n'),
('Assistant Line Foreman', 'n'),
('Assistant Superintendent', 'n'),
('Billing Clerk/Cashier', 'n'),
('Billing/Customer Relations', 'n'),
('Building Inspector', 'n'),
('Cable TV Technician', 'n'),
('Chief Meter Service/Repairman', 'n'),
('City Attorney', 'n'),
('City Clerk/Treasurer', 'n'),
('City Manager/Administrator', 'n'),
('Coal & Ash Foreman', 'n'),
('Commissioner', 'n'),
('Communications Director', 'n'),
('Computer Programmer/Analyst', 'n'),
('Computer Technician/IT', 'n'),
('Construction/Equipment Operator', 'n'),
('Council Member', 'n'),
('Credit/Collections', 'n'),
('Custodian', 'n'),
('Customer Service', 'n'),
('Customer Service Manager', 'n'),
('Deputy City Clerk', 'n'),
('Dispatcher', 'n'),
('Economic Development', 'n'),
('Electric Groundman/Truck Driver', 'n'),
('Electrical Inspector', 'n'),
('Electrical Superintendent', 'n'),
('Electrician', 'n'),
('Energy Coordinator', 'n'),
('Engineer', 'n'),
('Finance Officer', 'n'),
('Gas Technician', 'n'),
('General Manager', 'n'),
('Greenskeeper', 'n'),
('Human Resources', 'n'),
('Inventory Clerk', 'n'),
('Journey Lineworker', 'n'),
('Lab Technician', 'n'),
('Line Foreman', 'n'),
('Line Superintendent', 'n'),
('Lineworker', 'n'),
('Load Management Operator', 'n'),
('Locator/Laborer', 'n'),
('Maintenance', 'n'),
('Maintenance Superintendent', 'n'),
('Mayor', 'n'),
('Meter Reader', 'n'),
('Meter Service/Repairman', 'n'),
('Natural Gas System Foreman', 'n'),
('Natural Gas System Superintendent', 'n'),
('Office Manager', 'n'),
('Operations Manager', 'n'),
('Parks Foreman', 'n'),
('Parks Supervisor', 'n'),
('Police Chief', 'n'),
('Police Officer', 'n'),
('Power Plant Fireman', 'n'),
('Power Plant Foreman', 'n'),
('Power Plant Mechanic', 'n'),
('Power Plant Operator', 'n'),
('Power Plant Shift Engineer', 'n'),
('Power Plant Superintendent', 'n'),
('Public Works', 'n'),
('Public Works Director', 'n'),
('Public Works Foreman', 'n'),
('Purchasing Agent', 'n'),
('Recreation Director', 'n'),
('Safety Coordinator', 'n'),
('Sanitation Worker', 'n'),
('Scada Operator', 'n'),
('Seasonal Worker', 'n'),
('Secretary/Receptionist', 'n'),
('Security System Technician', 'n'),
('Steam Heat System Foreman', 'n'),
('Street Superintendent', 'n'),
('Transportation Mechanic', 'n'),
('Warehouse Supervisor', 'n'),
('Water Division Manager', 'n'),
('Water/Wastewater Foreman', 'n'),
('Water/Wastewater Operator', 'n'),
('Water/Wastewater Supervisor', 'n'),
('Zoning Administrator', 'n')

ON DUPLICATE KEY UPDATE `old` = VALUES(`old`);

DELETE FROM `mm_PersonnelPosition` WHERE `old` = 'y';

ALTER TABLE `mm_PersonnelPosition`
  DROP `sorter`,
  DROP `old`;
