text: -- phpMyAdmin SQL Dump
  -- version 4.2.11
  -- http://www.phpmyadmin.net
  --
  -- Host: 127.0.0.1
  -- Generation Time: Feb 20, 2017 at 12:14 PM
  -- Server version: 5.6.21
  -- PHP Version: 5.5.19
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  SET time_zone = "+00:00";
  
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8 */;
  
  --
  -- Database: `dating`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `countries`
  --
  
  CREATE TABLE IF NOT EXISTS `countries` (
  `country_id` int(11) NOT NULL,
    `country_code` varchar(2) NOT NULL DEFAULT '',
    `country_name` varchar(100) NOT NULL DEFAULT '',
    `add_date` datetime NOT NULL,
    `modify_date` datetime NOT NULL
  ) ENGINE=MyISAM AUTO_INCREMENT=247 DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `countries`
  --
  
  INSERT INTO `countries` (`country_id`, `country_code`, `country_name`, `add_date`, `modify_date`) VALUES
  (1, 'AF', 'Afghanistan', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (2, 'AL', 'Albania', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (3, 'DZ', 'Algeria', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (4, 'DS', 'American Samoa', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (5, 'AD', 'Andorra', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (6, 'AO', 'Angola', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (7, 'AI', 'Anguilla', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (8, 'AQ', 'Antarctica', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (9, 'AG', 'Antigua and Barbuda', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (10, 'AR', 'Argentina', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (11, 'AM', 'Armenia', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (12, 'AW', 'Aruba', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (13, 'AU', 'Australia', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (14, 'AT', 'Austria', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (15, 'AZ', 'Azerbaijan', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (16, 'BS', 'Bahamas', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (17, 'BH', 'Bahrain', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (18, 'BD', 'Bangladesh', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (19, 'BB', 'Barbados', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (20, 'BY', 'Belarus', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (21, 'BE', 'Belgium', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (22, 'BZ', 'Belize', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (23, 'BJ', 'Benin', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (24, 'BM', 'Bermuda', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (25, 'BT', 'Bhutan', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (26, 'BO', 'Bolivia', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (27, 'BA', 'Bosnia and Herzegovina', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (28, 'BW', 'Botswana', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (29, 'BV', 'Bouvet Island', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (30, 'BR', 'Brazil', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (31, 'IO', 'British Indian Ocean Territory', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (32, 'BN', 'Brunei Darussalam', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (33, 'BG', 'Bulgaria', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (34, 'BF', 'Burkina Faso', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (35, 'BI', 'Burundi', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (36, 'KH', 'Cambodia', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (37, 'CM', 'Cameroon', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (38, 'CA', 'Canada', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (39, 'CV', 'Cape Verde', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (40, 'KY', 'Cayman Islands', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (41, 'CF', 'Central African Republic', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (42, 'TD', 'Chad', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (43, 'CL', 'Chile', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (44, 'CN', 'China', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (45, 'CX', 'Christmas Island', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (46, 'CC', 'Cocos (Keeling) Islands', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (47, 'CO', 'Colombia', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (48, 'KM', 'Comoros', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (49, 'CG', 'Congo', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (50, 'CK', 'Cook Islands', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (51, 'CR', 'Costa Rica', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (52, 'HR', 'Croatia (Hrvatska)', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (53, 'CU', 'Cuba', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (54, 'CY', 'Cyprus', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (55, 'CZ', 'Czech Republic', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (56, 'DK', 'Denmark', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (57, 'DJ', 'Djibouti', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (58, 'DM', 'Dominica', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (59, 'DO', 'Dominican Republic', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (60, 'TP', 'East Timor', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (61, 'EC', 'Ecuador', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (62, 'EG', 'Egypt', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (63, 'SV', 'El Salvador', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (64, 'GQ', 'Equatorial Guinea', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (65, 'ER', 'Eritrea', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (66, 'EE', 'Estonia', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (67, 'ET', 'Ethiopia', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (68, 'FK', 'Falkland Islands (Malvinas)', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (69, 'FO', 'Faroe Islands', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (70, 'FJ', 'Fiji', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (71, 'FI', 'Finland', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (72, 'FR', 'France', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (73, 'FX', 'France, Metropolitan', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (74, 'GF', 'French Guiana', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (75, 'PF', 'French Polynesia', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (76, 'TF', 'French Southern Territories', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (77, 'GA', 'Gabon', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (78, 'GM', 'Gambia', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (79, 'GE', 'Georgia', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (80, 'DE', 'Germany', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (81, 'GH', 'Ghana', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (82, 'GI', 'Gibraltar', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (83, 'GK', 'Guernsey', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (84, 'GR', 'Greece', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (85, 'GL', 'Greenland', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (86, 'GD', 'Grenada', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (87, 'GP', 'Guadeloupe', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (88, 'GU', 'Guam', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (89, 'GT', 'Guatemala', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (90, 'GN', 'Guinea', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (91, 'GW', 'Guinea-Bissau', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (92, 'GY', 'Guyana', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (93, 'HT', 'Haiti', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (94, 'HM', 'Heard and Mc Donald Islands', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (95, 'HN', 'Honduras', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (96, 'HK', 'Hong Kong', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (97, 'HU', 'Hungary', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (98, 'IS', 'Iceland', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (99, 'IN', 'India', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (100, 'IM', 'Isle of Man', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (101, 'ID', 'Indonesia', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (102, 'IR', 'Iran (Islamic Republic of)', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (103, 'IQ', 'Iraq', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (104, 'IE', 'Ireland', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (105, 'IL', 'Israel', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (106, 'IT', 'Italy', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (107, 'CI', 'Ivory Coast', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (108, 'JE', 'Jersey', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (109, 'JM', 'Jamaica', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (110, 'JP', 'Japan', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (111, 'JO', 'Jordan', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (112, 'KZ', 'Kazakhstan', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (113, 'KE', 'Kenya', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (114, 'KI', 'Kiribati', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (115, 'KP', 'Korea, Democratic People''s Republic of', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (116, 'KR', 'Korea, Republic of', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (117, 'XK', 'Kosovo', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (118, 'KW', 'Kuwait', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (119, 'KG', 'Kyrgyzstan', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (120, 'LA', 'Lao People''s Democratic Republic', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (121, 'LV', 'Latvia', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (122, 'LB', 'Lebanon', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (123, 'LS', 'Lesotho', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (124, 'LR', 'Liberia', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (125, 'LY', 'Libyan Arab Jamahiriya', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (126, 'LI', 'Liechtenstein', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (127, 'LT', 'Lithuania', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (128, 'LU', 'Luxembourg', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (129, 'MO', 'Macau', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (130, 'MK', 'Macedonia', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (131, 'MG', 'Madagascar', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (132, 'MW', 'Malawi', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (133, 'MY', 'Malaysia', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (134, 'MV', 'Maldives', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (135, 'ML', 'Mali', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (136, 'MT', 'Malta', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (137, 'MH', 'Marshall Islands', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (138, 'MQ', 'Martinique', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (139, 'MR', 'Mauritania', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (140, 'MU', 'Mauritius', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (141, 'TY', 'Mayotte', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (142, 'MX', 'Mexico', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (143, 'FM', 'Micronesia, Federated States of', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (144, 'MD', 'Moldova, Republic of', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (145, 'MC', 'Monaco', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (146, 'MN', 'Mongolia', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (147, 'ME', 'Montenegro', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (148, 'MS', 'Montserrat', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (149, 'MA', 'Morocco', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (150, 'MZ', 'Mozambique', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (151, 'MM', 'Myanmar', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (152, 'NA', 'Namibia', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (153, 'NR', 'Nauru', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (154, 'NP', 'Nepal', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (155, 'NL', 'Netherlands', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (156, 'AN', 'Netherlands Antilles', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (157, 'NC', 'New Caledonia', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (158, 'NZ', 'New Zealand', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (159, 'NI', 'Nicaragua', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (160, 'NE', 'Niger', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (161, 'NG', 'Nigeria', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (162, 'NU', 'Niue', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (163, 'NF', 'Norfolk Island', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (164, 'MP', 'Northern Mariana Islands', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (165, 'NO', 'Norway', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (166, 'OM', 'Oman', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (167, 'PK', 'Pakistan', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (168, 'PW', 'Palau', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (169, 'PS', 'Palestine', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (170, 'PA', 'Panama', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (171, 'PG', 'Papua New Guinea', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (172, 'PY', 'Paraguay', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (173, 'PE', 'Peru', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (174, 'PH', 'Philippines', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (175, 'PN', 'Pitcairn', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (176, 'PL', 'Poland', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (177, 'PT', 'Portugal', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (178, 'PR', 'Puerto Rico', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (179, 'QA', 'Qatar', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (180, 'RE', 'Reunion', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (181, 'RO', 'Romania', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (182, 'RU', 'Russian Federation', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (183, 'RW', 'Rwanda', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (184, 'KN', 'Saint Kitts and Nevis', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (185, 'LC', 'Saint Lucia', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (186, 'VC', 'Saint Vincent and the Grenadines', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (187, 'WS', 'Samoa', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (188, 'SM', 'San Marino', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (189, 'ST', 'Sao Tome and Principe', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (190, 'SA', 'Saudi Arabia', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (191, 'SN', 'Senegal', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (192, 'RS', 'Serbia', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (193, 'SC', 'Seychelles', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (194, 'SL', 'Sierra Leone', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (195, 'SG', 'Singapore', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (196, 'SK', 'Slovakia', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (197, 'SI', 'Slovenia', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (198, 'SB', 'Solomon Islands', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (199, 'SO', 'Somalia', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (200, 'ZA', 'South Africa', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (201, 'GS', 'South Georgia South Sandwich Islands', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (202, 'ES', 'Spain', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (203, 'LK', 'Sri Lanka', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (204, 'SH', 'St. Helena', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (205, 'PM', 'St. Pierre and Miquelon', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (206, 'SD', 'Sudan', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (207, 'SR', 'Suriname', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (208, 'SJ', 'Svalbard and Jan Mayen Islands', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (209, 'SZ', 'Swaziland', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (210, 'SE', 'Sweden', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (211, 'CH', 'Switzerland', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (212, 'SY', 'Syrian Arab Republic', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (213, 'TW', 'Taiwan', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (214, 'TJ', 'Tajikistan', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (215, 'TZ', 'Tanzania, United Republic of', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (216, 'TH', 'Thailand', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (217, 'TG', 'Togo', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (218, 'TK', 'Tokelau', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (219, 'TO', 'Tonga', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (220, 'TT', 'Trinidad and Tobago', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (221, 'TN', 'Tunisia', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (222, 'TR', 'Turkey', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (223, 'TM', 'Turkmenistan', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (224, 'TC', 'Turks and Caicos Islands', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (225, 'TV', 'Tuvalu', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (226, 'UG', 'Uganda', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (227, 'UA', 'Ukraine', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (228, 'AE', 'United Arab Emirates', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (229, 'GB', 'United Kingdom', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (230, 'US', 'United States', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (231, 'UM', 'United States minor outlying islands', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (232, 'UY', 'Uruguay', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (233, 'UZ', 'Uzbekistan', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (234, 'VU', 'Vanuatu', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (235, 'VA', 'Vatican City State', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (236, 'VE', 'Venezuela', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (237, 'VN', 'Vietnam', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (238, 'VG', 'Virgin Islands (British)', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (239, 'VI', 'Virgin Islands (U.S.)', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (240, 'WF', 'Wallis and Futuna Islands', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (241, 'EH', 'Western Sahara', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (242, 'YE', 'Yemen', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (243, 'YU', 'Yugoslavia', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (244, 'ZR', 'Zaire', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (245, 'ZM', 'Zambia', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
  (246, 'ZW', 'Zimbabwe', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `countries`
  --
  ALTER TABLE `countries`
   ADD PRIMARY KEY (`country_id`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `countries`
  --
  ALTER TABLE `countries`
  MODIFY `country_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=247;
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  