-- Canada alarm,local,longdistance,international,tollfree,premium
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('ca','011NX.','international','International');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('ca','1NXXNXXXXXX','longdistance','Long Distance 1 plus');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('ca','NXXNXXXXXX','longdistance','Long Distance Ten Digit');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('ca','NXXXXXX','local','Local');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('ca','800NXXXXXX','tollfree','Tollfree');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('ca','888NXXXXXX','tollfree','Tollfree');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('ca','877NXXXXXX','tollfree','Tollfree');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('ca','866NXXXXXX','tollfree','Tollfree');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('ca','1800NXXXXXX','tollfree','Tollfree');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('ca','1888NXXXXXX','tollfree','Tollfree');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('ca','1877NXXXXXX','tollfree','Tollfree');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('ca','1866NXXXXXX','tollfree','Tollfree');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('ca','911','alarm','Emergency');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('ca','411','local','Local Directory Assistance');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('ca','5YYNXXXXXX','local','Personal Communication Services (follow me)');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('ca','211','tollfree','Community Information and Referral Services');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('ca','311','alarm','Non-Emergency Police and Other Governmental Services');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('ca','511','tollfree','Traffic and Transportation Information');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('ca','611','tollfree','Repair Service');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('ca','711','tollfree','Telecommunications Relay Service (TRS)');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('ca','811','tollfree','Access to One Call Services to Protect Pipeline and Utilities from Excavation Damage');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('ca','1900NXXXXXX','premium','Premium Services');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('ca','1976NXXXXXX','premium','Premium Services');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('ca','900NXXXXXX','premium','Premium Services');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('ca','976NXXXXXX','premium','Premium Services');
insert into national_dialplan(isocode,pattern,class,remark) VALUES
  ('ca','456NXXXXXX','local','Carrier-Specific Services');

