Countries List

CREATE TABLE `tbl_countries` (
  `cnt_id` int(11) NOT NULL,
  `cnt_name` varchar(64) NOT NULL DEFAULT '',
  `cnt_iso_code` varchar(4) DEFAULT NULL,
  `cnt_isd_code` varchar(8) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `tbl_countries` (`cnt_id`, `cnt_name`, `cnt_iso_code`, `cnt_isd_code`) VALUES
(1, 'Afghanistan', 'AF', '93'),
(2, 'Albania', 'AL', '355'),
(3, 'Algeria', 'DZ', '213'),
(4, 'American Samoa', 'AS', '1-684'),
(5, 'Andorra', 'AD', '376');

ALTER TABLE `tbl_countries`
  ADD PRIMARY KEY (`cnt_id`),
  ADD KEY `cnt_name` (`cnt_name`);

ALTER TABLE `tbl_countries`
  MODIFY `cnt_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=250;
COMMIT;