INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2000','2000','2000','10.10.10.15','2000a','test','ACTIVE','Y','CCagent','station 2000','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2001','2001','2001','10.10.10.15','2001a','test','ACTIVE','Y','CCagent','station 2001','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2002','2002','2002','10.10.10.15','2002a','test','ACTIVE','Y','CCagent','station 2002','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2003','2003','2003','10.10.10.15','2003a','test','ACTIVE','Y','CCagent','station 2003','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2004','2004','2004','10.10.10.15','2004a','test','ACTIVE','Y','CCagent','station 2004','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2005','2005','2005','10.10.10.15','2005a','test','ACTIVE','Y','CCagent','station 2005','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2006','2006','2006','10.10.10.15','2006a','test','ACTIVE','Y','CCagent','station 2006','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2007','2007','2007','10.10.10.15','2007a','test','ACTIVE','Y','CCagent','station 2007','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2008','2008','2008','10.10.10.15','2008a','test','ACTIVE','Y','CCagent','station 2008','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2009','2009','2009','10.10.10.15','2009a','test','ACTIVE','Y','CCagent','station 2009','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2010','2010','2010','10.10.10.15','2010a','test','ACTIVE','Y','CCagent','station 2010','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2011','2011','2011','10.10.10.15','2011a','test','ACTIVE','Y','CCagent','station 2011','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2012','2012','2012','10.10.10.15','2012a','test','ACTIVE','Y','CCagent','station 2012','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2013','2013','2013','10.10.10.15','2013a','test','ACTIVE','Y','CCagent','station 2013','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2014','2014','2014','10.10.10.15','2014a','test','ACTIVE','Y','CCagent','station 2014','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2015','2015','2015','10.10.10.15','2015a','test','ACTIVE','Y','CCagent','station 2015','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2016','2016','2016','10.10.10.15','2016a','test','ACTIVE','Y','CCagent','station 2016','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2017','2017','2017','10.10.10.15','2017a','test','ACTIVE','Y','CCagent','station 2017','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2018','2018','2018','10.10.10.15','2018a','test','ACTIVE','Y','CCagent','station 2018','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2019','2019','2019','10.10.10.15','2019a','test','ACTIVE','Y','CCagent','station 2019','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2020','2020','2020','10.10.10.15','2020a','test','ACTIVE','Y','CCagent','station 2020','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2021','2021','2021','10.10.10.15','2021a','test','ACTIVE','Y','CCagent','station 2021','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2022','2022','2022','10.10.10.15','2022a','test','ACTIVE','Y','CCagent','station 2022','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2023','2023','2023','10.10.10.15','2023a','test','ACTIVE','Y','CCagent','station 2023','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2024','2024','2024','10.10.10.15','2024a','test','ACTIVE','Y','CCagent','station 2024','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2025','2025','2025','10.10.10.15','2025a','test','ACTIVE','Y','CCagent','station 2025','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2026','2026','2026','10.10.10.15','2026a','test','ACTIVE','Y','CCagent','station 2026','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2027','2027','2027','10.10.10.15','2027a','test','ACTIVE','Y','CCagent','station 2027','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2028','2028','2028','10.10.10.15','2028a','test','ACTIVE','Y','CCagent','station 2028','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2029','2029','2029','10.10.10.15','2029a','test','ACTIVE','Y','CCagent','station 2029','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2030','2030','2030','10.10.10.15','2030a','test','ACTIVE','Y','CCagent','station 2030','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2031','2031','2031','10.10.10.15','2031a','test','ACTIVE','Y','CCagent','station 2031','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2032','2032','2032','10.10.10.15','2032a','test','ACTIVE','Y','CCagent','station 2032','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2033','2033','2033','10.10.10.15','2033a','test','ACTIVE','Y','CCagent','station 2033','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2034','2034','2034','10.10.10.15','2034a','test','ACTIVE','Y','CCagent','station 2034','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2035','2035','2035','10.10.10.15','2035a','test','ACTIVE','Y','CCagent','station 2035','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2036','2036','2036','10.10.10.15','2036a','test','ACTIVE','Y','CCagent','station 2036','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2037','2037','2037','10.10.10.15','2037a','test','ACTIVE','Y','CCagent','station 2037','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2038','2038','2038','10.10.10.15','2038a','test','ACTIVE','Y','CCagent','station 2038','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2039','2039','2039','10.10.10.15','2039a','test','ACTIVE','Y','CCagent','station 2039','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2040','2040','2040','10.10.10.15','2040a','test','ACTIVE','Y','CCagent','station 2040','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2041','2041','2041','10.10.10.15','2041a','test','ACTIVE','Y','CCagent','station 2041','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2042','2042','2042','10.10.10.15','2042a','test','ACTIVE','Y','CCagent','station 2042','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2043','2043','2043','10.10.10.15','2043a','test','ACTIVE','Y','CCagent','station 2043','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2044','2044','2044','10.10.10.15','2044a','test','ACTIVE','Y','CCagent','station 2044','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2045','2045','2045','10.10.10.15','2045a','test','ACTIVE','Y','CCagent','station 2045','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2046','2046','2046','10.10.10.15','2046a','test','ACTIVE','Y','CCagent','station 2046','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2047','2047','2047','10.10.10.15','2047a','test','ACTIVE','Y','CCagent','station 2047','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2048','2048','2048','10.10.10.15','2048a','test','ACTIVE','Y','CCagent','station 2048','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2049','2049','2049','10.10.10.15','2049a','test','ACTIVE','Y','CCagent','station 2049','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2050','2050','2050','10.10.10.15','2050a','test','ACTIVE','Y','CCagent','station 2050','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2051','2051','2051','10.10.10.15','2051a','test','ACTIVE','Y','CCagent','station 2051','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2052','2052','2052','10.10.10.15','2052a','test','ACTIVE','Y','CCagent','station 2052','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2053','2053','2053','10.10.10.15','2053a','test','ACTIVE','Y','CCagent','station 2053','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2054','2054','2054','10.10.10.15','2054a','test','ACTIVE','Y','CCagent','station 2054','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2055','2055','2055','10.10.10.15','2055a','test','ACTIVE','Y','CCagent','station 2055','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2056','2056','2056','10.10.10.15','2056a','test','ACTIVE','Y','CCagent','station 2056','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2057','2057','2057','10.10.10.15','2057a','test','ACTIVE','Y','CCagent','station 2057','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2058','2058','2058','10.10.10.15','2058a','test','ACTIVE','Y','CCagent','station 2058','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2059','2059','2059','10.10.10.15','2059a','test','ACTIVE','Y','CCagent','station 2059','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2060','2060','2060','10.10.10.15','2060a','test','ACTIVE','Y','CCagent','station 2060','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2061','2061','2061','10.10.10.15','2061a','test','ACTIVE','Y','CCagent','station 2061','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2062','2062','2062','10.10.10.15','2062a','test','ACTIVE','Y','CCagent','station 2062','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2063','2063','2063','10.10.10.15','2063a','test','ACTIVE','Y','CCagent','station 2063','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2064','2064','2064','10.10.10.15','2064a','test','ACTIVE','Y','CCagent','station 2064','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2065','2065','2065','10.10.10.15','2065a','test','ACTIVE','Y','CCagent','station 2065','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2066','2066','2066','10.10.10.15','2066a','test','ACTIVE','Y','CCagent','station 2066','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2067','2067','2067','10.10.10.15','2067a','test','ACTIVE','Y','CCagent','station 2067','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2068','2068','2068','10.10.10.15','2068a','test','ACTIVE','Y','CCagent','station 2068','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2069','2069','2069','10.10.10.15','2069a','test','ACTIVE','Y','CCagent','station 2069','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2070','2070','2070','10.10.10.15','2070a','test','ACTIVE','Y','CCagent','station 2070','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2071','2071','2071','10.10.10.15','2071a','test','ACTIVE','Y','CCagent','station 2071','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2072','2072','2072','10.10.10.15','2072a','test','ACTIVE','Y','CCagent','station 2072','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2073','2073','2073','10.10.10.15','2073a','test','ACTIVE','Y','CCagent','station 2073','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2074','2074','2074','10.10.10.15','2074a','test','ACTIVE','Y','CCagent','station 2074','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2075','2075','2075','10.10.10.15','2075a','test','ACTIVE','Y','CCagent','station 2075','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2076','2076','2076','10.10.10.15','2076a','test','ACTIVE','Y','CCagent','station 2076','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2077','2077','2077','10.10.10.15','2077a','test','ACTIVE','Y','CCagent','station 2077','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2078','2078','2078','10.10.10.15','2078a','test','ACTIVE','Y','CCagent','station 2078','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2079','2079','2079','10.10.10.15','2079a','test','ACTIVE','Y','CCagent','station 2079','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2080','2080','2080','10.10.10.15','2080a','test','ACTIVE','Y','CCagent','station 2080','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2081','2081','2081','10.10.10.15','2081a','test','ACTIVE','Y','CCagent','station 2081','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2082','2082','2082','10.10.10.15','2082a','test','ACTIVE','Y','CCagent','station 2082','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2083','2083','2083','10.10.10.15','2083a','test','ACTIVE','Y','CCagent','station 2083','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2084','2084','2084','10.10.10.15','2084a','test','ACTIVE','Y','CCagent','station 2084','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2085','2085','2085','10.10.10.15','2085a','test','ACTIVE','Y','CCagent','station 2085','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2086','2086','2086','10.10.10.15','2086a','test','ACTIVE','Y','CCagent','station 2086','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2087','2087','2087','10.10.10.15','2087a','test','ACTIVE','Y','CCagent','station 2087','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2088','2088','2088','10.10.10.15','2088a','test','ACTIVE','Y','CCagent','station 2088','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2089','2089','2089','10.10.10.15','2089a','test','ACTIVE','Y','CCagent','station 2089','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2090','2090','2090','10.10.10.15','2090a','test','ACTIVE','Y','CCagent','station 2090','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2091','2091','2091','10.10.10.15','2091a','test','ACTIVE','Y','CCagent','station 2091','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2092','2092','2092','10.10.10.15','2092a','test','ACTIVE','Y','CCagent','station 2092','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2093','2093','2093','10.10.10.15','2093a','test','ACTIVE','Y','CCagent','station 2093','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2094','2094','2094','10.10.10.15','2094a','test','ACTIVE','Y','CCagent','station 2094','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2095','2095','2095','10.10.10.15','2095a','test','ACTIVE','Y','CCagent','station 2095','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2096','2096','2096','10.10.10.15','2096a','test','ACTIVE','Y','CCagent','station 2096','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2097','2097','2097','10.10.10.15','2097a','test','ACTIVE','Y','CCagent','station 2097','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2098','2098','2098','10.10.10.15','2098a','test','ACTIVE','Y','CCagent','station 2098','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2099','2099','2099','10.10.10.15','2099a','test','ACTIVE','Y','CCagent','station 2099','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2100','2100','2100','10.10.10.15','2100a','test','ACTIVE','Y','CCagent','station 2100','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2101','2101','2101','10.10.10.15','2101a','test','ACTIVE','Y','CCagent','station 2101','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2102','2102','2102','10.10.10.15','2102a','test','ACTIVE','Y','CCagent','station 2102','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2103','2103','2103','10.10.10.15','2103a','test','ACTIVE','Y','CCagent','station 2103','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2104','2104','2104','10.10.10.15','2104a','test','ACTIVE','Y','CCagent','station 2104','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2105','2105','2105','10.10.10.15','2105a','test','ACTIVE','Y','CCagent','station 2105','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2106','2106','2106','10.10.10.15','2106a','test','ACTIVE','Y','CCagent','station 2106','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2107','2107','2107','10.10.10.15','2107a','test','ACTIVE','Y','CCagent','station 2107','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2108','2108','2108','10.10.10.15','2108a','test','ACTIVE','Y','CCagent','station 2108','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2109','2109','2109','10.10.10.15','2109a','test','ACTIVE','Y','CCagent','station 2109','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2110','2110','2110','10.10.10.15','2110a','test','ACTIVE','Y','CCagent','station 2110','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2111','2111','2111','10.10.10.15','2111a','test','ACTIVE','Y','CCagent','station 2111','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2112','2112','2112','10.10.10.15','2112a','test','ACTIVE','Y','CCagent','station 2112','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2113','2113','2113','10.10.10.15','2113a','test','ACTIVE','Y','CCagent','station 2113','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2114','2114','2114','10.10.10.15','2114a','test','ACTIVE','Y','CCagent','station 2114','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2115','2115','2115','10.10.10.15','2115a','test','ACTIVE','Y','CCagent','station 2115','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2116','2116','2116','10.10.10.15','2116a','test','ACTIVE','Y','CCagent','station 2116','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2117','2117','2117','10.10.10.15','2117a','test','ACTIVE','Y','CCagent','station 2117','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2118','2118','2118','10.10.10.15','2118a','test','ACTIVE','Y','CCagent','station 2118','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2119','2119','2119','10.10.10.15','2119a','test','ACTIVE','Y','CCagent','station 2119','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2120','2120','2120','10.10.10.15','2120a','test','ACTIVE','Y','CCagent','station 2120','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2121','2121','2121','10.10.10.15','2121a','test','ACTIVE','Y','CCagent','station 2121','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2122','2122','2122','10.10.10.15','2122a','test','ACTIVE','Y','CCagent','station 2122','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2123','2123','2123','10.10.10.15','2123a','test','ACTIVE','Y','CCagent','station 2123','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2124','2124','2124','10.10.10.15','2124a','test','ACTIVE','Y','CCagent','station 2124','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2125','2125','2125','10.10.10.15','2125a','test','ACTIVE','Y','CCagent','station 2125','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2126','2126','2126','10.10.10.15','2126a','test','ACTIVE','Y','CCagent','station 2126','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2127','2127','2127','10.10.10.15','2127a','test','ACTIVE','Y','CCagent','station 2127','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2128','2128','2128','10.10.10.15','2128a','test','ACTIVE','Y','CCagent','station 2128','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2129','2129','2129','10.10.10.15','2129a','test','ACTIVE','Y','CCagent','station 2129','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2130','2130','2130','10.10.10.15','2130a','test','ACTIVE','Y','CCagent','station 2130','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2131','2131','2131','10.10.10.15','2131a','test','ACTIVE','Y','CCagent','station 2131','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2132','2132','2132','10.10.10.15','2132a','test','ACTIVE','Y','CCagent','station 2132','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2133','2133','2133','10.10.10.15','2133a','test','ACTIVE','Y','CCagent','station 2133','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2134','2134','2134','10.10.10.15','2134a','test','ACTIVE','Y','CCagent','station 2134','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2135','2135','2135','10.10.10.15','2135a','test','ACTIVE','Y','CCagent','station 2135','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2136','2136','2136','10.10.10.15','2136a','test','ACTIVE','Y','CCagent','station 2136','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2137','2137','2137','10.10.10.15','2137a','test','ACTIVE','Y','CCagent','station 2137','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2138','2138','2138','10.10.10.15','2138a','test','ACTIVE','Y','CCagent','station 2138','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2139','2139','2139','10.10.10.15','2139a','test','ACTIVE','Y','CCagent','station 2139','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2140','2140','2140','10.10.10.15','2140a','test','ACTIVE','Y','CCagent','station 2140','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2141','2141','2141','10.10.10.15','2141a','test','ACTIVE','Y','CCagent','station 2141','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2142','2142','2142','10.10.10.15','2142a','test','ACTIVE','Y','CCagent','station 2142','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2143','2143','2143','10.10.10.15','2143a','test','ACTIVE','Y','CCagent','station 2143','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2144','2144','2144','10.10.10.15','2144a','test','ACTIVE','Y','CCagent','station 2144','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2145','2145','2145','10.10.10.15','2145a','test','ACTIVE','Y','CCagent','station 2145','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2146','2146','2146','10.10.10.15','2146a','test','ACTIVE','Y','CCagent','station 2146','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2147','2147','2147','10.10.10.15','2147a','test','ACTIVE','Y','CCagent','station 2147','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2148','2148','2148','10.10.10.15','2148a','test','ACTIVE','Y','CCagent','station 2148','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2149','2149','2149','10.10.10.15','2149a','test','ACTIVE','Y','CCagent','station 2149','IAX2','-5','0000000000','test');
INSERT INTO phones (extension,dialplan_number,voicemail_id,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,outbound_cid,conf_secret) values('2150','2150','2150','10.10.10.15','2150a','test','ACTIVE','Y','CCagent','station 2150','IAX2','-5','0000000000','test');


INSERT IGNORE INTO phones
(extension,dialplan_number,voicemail_id,outbound_cid,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,conf_secret,company,email,delete_vm_after_email)
SELECT extension, dialplan_number, voicemail_id, outbound_cid, '10.10.10.16', REPLACE(login,'a','b'), pass, status, active, phone_type, fullname, 'IAX2', local_gmt, conf_secret, company, email, delete_vm_after_email from phones where login LIKE "%a" and dialplan_number > 1000 and dialplan_number < 3000 limit 1000;

INSERT IGNORE INTO phones
(extension,dialplan_number,voicemail_id,outbound_cid,server_ip,login,pass,status,active,phone_type,fullname,protocol,local_gmt,conf_secret,company,email,delete_vm_after_email)
SELECT extension, dialplan_number, voicemail_id, outbound_cid, '10.10.10.17', REPLACE(login,'a','c'), pass, status, active, phone_type, fullname, 'IAX2', local_gmt, conf_secret, company, email, delete_vm_after_email from phones where login LIKE "%a" and dialplan_number > 1000 and dialplan_number < 3000 limit 1000;


UPDATE phones set dialplan_number=CONCAT(dialplan_number,'0') where login LIKE "%a" and dialplan_number > 1000 and dialplan_number < 3000 limit 1000;
UPDATE phones set dialplan_number=CONCAT(dialplan_number,'1') where login LIKE "%b" and dialplan_number > 1000 and dialplan_number < 3000 limit 1000;
UPDATE phones set dialplan_number=CONCAT(dialplan_number,'2') where login LIKE "%c" and dialplan_number > 1000 and dialplan_number < 3000 limit 1000;


UPDATE phones SET server_ip='192.168.1.21' where server_ip='10.10.10.15';
UPDATE phones SET server_ip='192.168.1.22' where server_ip='10.10.10.16';
UPDATE phones SET server_ip='192.168.1.23' where server_ip='10.10.10.17';


INSERT INTO phones_alias SELECT REPLACE(login,'a',''),REPLACE(login,'a',' phone'),CONCAT(login, ',', REPLACE(login,'a','b'), ',', REPLACE(login,'a','c')) from phones where login like "%a" limit 1000;


UPDATE servers SET rebuild_conf_files='Y';
