delete from national_dialplan where isocode = 'de' and pattern like '015%';
delete from national_dialplan where isocode = 'de' and pattern like '016%';
delete from national_dialplan where isocode = 'de' and pattern like '017%';

insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('de','015XXXXXXXX','mobile','cell phone');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('de','015XXXXXXXXX','mobile','cell phone');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('de','016XXXXXXXX','mobile','pagers & cell phone');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('de','016XXXXXXXXX','mobile','pagers & cell phone');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('de','017XXXXXXXX','mobile','cell phone');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('de','017XXXXXXXXX','mobile','cell phone');

