-- redo the status relationshipsALTER TABLE opportunities ADD status_id INT;UPDATE opportunities SET status_id =CASE opportunities.statusWHEN 'Awaiting Quote' or 'awaiting_quote' THEN 1WHEN 'Quoted' or 'quoted' THEN 2WHEN 'In Design' or 'in_design' THEN 3WHEN 'Out For Approval' or 'approval' THEN 4WHEN 'Approved (toolpath)' or 'approved' THEN 5WHEN 'In Production' or 'in_production' THEN 6WHEN 'Partially Shipped' or 'partially_shipped' THEN 7WHEN 'Fully Shipped' or 'fully_shipped' THEN 8WHEN 'On Hold (customer)' or 'on_hold_customer' THEN 9WHEN 'On Hold (datum)' or 'on_hold_datum' THEN 10WHEN 'Dead' or 'dead' THEN 11END;