begin;

insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('ca','855NXXXXXX','tollfree','Tollfree');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('ca','1855NXXXXXX','tollfree','Tollfree');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','855NXXXXXX','tollfree','Tollfree');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','1855NXXXXXX','tollfree','Tollfree');

update national_dialplan set pattern='1NXX976XXXX' where (isocode='ca' or isocode='us') and pattern='1976NXXXXXX';
update national_dialplan set pattern='NXX976XXXX' where (isocode='ca' or isocode='us') and pattern='976NXXXXXX';



-- other NANPA Countries outside US
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','242NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','246NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','264NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','268NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','284NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','340NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','343NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','345NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','441NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','473NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','649NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','664NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','670NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','671NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','684NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','721NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','758NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','767NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','784NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','787NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','809NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','829NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','849NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','868NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','869NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','876NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','939NXXXXXX','international','International');


-- Other NANPA targets outside US, with preceding 1
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','1242NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','1246NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','1264NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','1268NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','1284NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','1340NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','1343NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','1345NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','1441NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','1473NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','1649NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','1664NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','1670NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','1671NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','1684NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','1721NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','1758NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','1767NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','1784NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','1787NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','1809NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','1829NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','1849NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','1868NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','1869NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','1876NXXXXXX','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('us','1939NXXXXXX','international','International');

commit;
