------
-- OSDB : The Open Source Database Network
--
-- http://www.osdb.org
------
--
-- pgsql_states_canada.sql
--
-- NOTE: This script does not create indexes.


create table states_canada (
    name character varying(40) not null,
    code character varying(2) not null
);


insert into states_canada (name, code) values ('Alberta', 'AB');
insert into states_canada (name, code) values ('British Columbia', 'BC');
insert into states_canada (name, code) values ('Manitoba', 'MB');
insert into states_canada (name, code) values ('New Brunswick', 'NB');
insert into states_canada (name, code) values ('Newfoundland', 'NF');
insert into states_canada (name, code) values ('Nova Scotia', 'NS');
insert into states_canada (name, code) values ('Northern Territories', 'NT');
insert into states_canada (name, code) values ('Ontario', 'ON');
insert into states_canada (name, code) values ('Prince Edward Island', 'PE');
insert into states_canada (name, code) values ('Quebec', 'QC');
insert into states_canada (name, code) values ('Saskatchewan', 'SK');
insert into states_canada (name, code) values ('Yukon Territory', 'YT');