Andrew's Sprocket

CREATE TABLE provinces
(
province_id   smallint    NOT NULL AUTO_INCREMENT PRIMARY KEY,
province      varchar(50) NOT NULL,
province_abbr varchar(2)  NOT NULL
)ENGINE=InnoDB, COLLATE=utf8_general_ci;
 
INSERT INTO provinces
VALUES
(NULL, 'Alberta', 'AB'),
(NULL, 'British Columbia', 'BC'),
(NULL, 'Manitoba', 'MB'),
(NULL, 'New Brunswick', 'NB'),
(NULL, 'Newfoundland and Labrador', 'NL'),
(NULL, 'Northwest Territories', 'NT'),
(NULL, 'Nova Scotia', 'NS'),
(NULL, 'Nunavut', 'NU'),
(NULL, 'Ontario', 'ON'),
(NULL, 'Prince Edward Island', 'PE'),
(NULL, 'Quebec', 'QC'),
(NULL, 'Saskatchewan', 'SK'),
(NULL, 'Yukon', 'YT')
;