-- DO NOT RUN ON LIVE AS FIELD ALREADY EXISTS ON LIVE
INSERT IGNORE INTO `fields_meta_data` VALUES ('Opportunitiesclose_plan_c','close_plan_c','LBL_CLOSE_PLAN',NULL,NULL,'Opportunities','enhancedurl',255,0,'http://mrm.supered.com.au/#bwc/index.php?module=Opportunities&action=ShowOrgChart&record={id}','2014-06-03 00:21:50',0,0,0,0,1,'false',NULL,NULL,'0','_self');

-- Create Opps field
ALTER TABLE opportunities_cstm add COLUMN close_plan_c varchar(255)  DEFAULT 'http://mrm.supered.com.au/#bwc/index.php?module=Opportunities&action=ShowOrgChart&record={id}' NULL ;

