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