-- http://www.phpmyadmin.net
--




--
-- Database: `910550_sfase`
--

-- --------------------------------------------------------

--
-- Table structure for table `itf_siteinfo`
--

CREATE TABLE IF NOT EXISTS `itf_siteinfo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sitename` varchar(255) NOT NULL,
  `emailid` varchar(100) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `itf_siteinfo`
--

INSERT INTO `itf_siteinfo` (`id`, `sitename`, `emailid`, `status`) VALUES
(1, ' Admin Panel', 'd@emarketzindia.com', 1);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_country`
--

CREATE TABLE IF NOT EXISTS `tbl_country` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `iso` char(2) NOT NULL,
  `name` varchar(80) NOT NULL,
  `nicename` varchar(80) NOT NULL,
  `iso3` char(3) DEFAULT NULL,
  `numcode` smallint(6) DEFAULT NULL,
  `phonecode` int(5) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=254 ;

--
-- Dumping data for table `tbl_country`
--

INSERT INTO `tbl_country` (`id`, `iso`, `name`, `nicename`, `iso3`, `numcode`, `phonecode`) VALUES
(1, 'AF', 'AFGHANISTAN', 'Afghanistan', 'AFG', 4, 93),
(2, 'AL', 'ALBANIA', 'Albania', 'ALB', 8, 355),
(3, 'DZ', 'ALGERIA', 'Algeria', 'DZA', 12, 213),
(4, 'AS', 'AMERICAN SAMOA', 'American Samoa', 'ASM', 16, 1684),
(5, 'AD', 'ANDORRA', 'Andorra', 'AND', 20, 376),
(6, 'AO', 'ANGOLA', 'Angola', 'AGO', 24, 244),
(7, 'AI', 'ANGUILLA', 'Anguilla', 'AIA', 660, 1264),
(9, 'AG', 'ANTIGUA AND BARBUDA', 'Antigua and Barbuda', 'ATG', 28, 1268),
(10, 'AR', 'ARGENTINA', 'Argentina', 'ARG', 32, 54),
(11, 'AM', 'ARMENIA', 'Armenia', 'ARM', 51, 374),
(12, 'AW', 'ARUBA', 'Aruba', 'ABW', 533, 297),
(13, 'AU', 'AUSTRALIA', 'Australia', 'AUS', 36, 61),
(14, 'AT', 'AUSTRIA', 'Austria', 'AUT', 40, 43),
(15, 'AZ', 'AZERBAIJAN', 'Azerbaijan', 'AZE', 31, 994),
(16, 'BS', 'BAHAMAS', 'Bahamas', 'BHS', 44, 1242),
(17, 'BH', 'BAHRAIN', 'Bahrain', 'BHR', 48, 973),
(18, 'BD', 'BANGLADESH', 'Bangladesh', 'BGD', 50, 880),
(19, 'BB', 'BARBADOS', 'Barbados', 'BRB', 52, 1246),
(20, 'BY', 'BELARUS', 'Belarus', 'BLR', 112, 375),
(21, 'BE', 'BELGIUM', 'Belgium', 'BEL', 56, 32),
(22, 'BZ', 'BELIZE', 'Belize', 'BLZ', 84, 501),
(23, 'BJ', 'BENIN', 'Benin', 'BEN', 204, 229),
(24, 'BM', 'BERMUDA', 'Bermuda', 'BMU', 60, 1441),
(25, 'BT', 'BHUTAN', 'Bhutan', 'BTN', 64, 975),
(26, 'BO', 'BOLIVIA', 'Bolivia', 'BOL', 68, 591),
(27, 'BA', 'BOSNIA AND HERZEGOVINA', 'Bosnia and Herzegovina', 'BIH', 70, 387),
(28, 'BW', 'BOTSWANA', 'Botswana', 'BWA', 72, 267),
(30, 'BR', 'BRAZIL', 'Brazil', 'BRA', 76, 55),
(31, 'IO', 'BRITISH INDIAN OCEAN TERRITORY', 'British Indian Ocean Territory', NULL, NULL, 246),
(32, 'BN', 'BRUNEI DARUSSALAM', 'Brunei Darussalam', 'BRN', 96, 673),
(33, 'BG', 'BULGARIA', 'Bulgaria', 'BGR', 100, 359),
(34, 'BF', 'BURKINA FASO', 'Burkina Faso', 'BFA', 854, 226),
(35, 'BI', 'BURUNDI', 'Burundi', 'BDI', 108, 257),
(36, 'KH', 'CAMBODIA', 'Cambodia', 'KHM', 116, 855),
(37, 'CM', 'CAMEROON', 'Cameroon', 'CMR', 120, 237),
(38, 'CA', 'CANADA', 'Canada', 'CAN', 124, 1),
(39, 'CV', 'CAPE VERDE', 'Cape Verde', 'CPV', 132, 238),
(40, 'KY', 'CAYMAN ISLANDS', 'Cayman Islands', 'CYM', 136, 1345),
(41, 'CF', 'CENTRAL AFRICAN REPUBLIC', 'Central African Republic', 'CAF', 140, 236),
(42, 'TD', 'CHAD', 'Chad', 'TCD', 148, 235),
(43, 'CL', 'CHILE', 'Chile', 'CHL', 152, 56),
(44, 'CN', 'CHINA', 'China', 'CHN', 156, 86),
(45, 'CX', 'CHRISTMAS ISLAND', 'Christmas Island', NULL, NULL, 61),
(46, 'CC', 'COCOS (KEELING) ISLANDS', 'Cocos (Keeling) Islands', NULL, NULL, 672),
(47, 'CO', 'COLOMBIA', 'Colombia', 'COL', 170, 57),
(48, 'KM', 'COMOROS', 'Comoros', 'COM', 174, 269),
(49, 'CG', 'CONGO', 'Congo', 'COG', 178, 242),
(50, 'CD', 'CONGO, THE DEMOCRATIC REPUBLIC OF THE', 'Congo, the Democratic Republic of the', 'COD', 180, 242),
(51, 'CK', 'COOK ISLANDS', 'Cook Islands', 'COK', 184, 682),
(52, 'CR', 'COSTA RICA', 'Costa Rica', 'CRI', 188, 506),
(53, 'CI', 'COTE D''IVOIRE', 'Cote D''Ivoire', 'CIV', 384, 225),
(54, 'HR', 'CROATIA', 'Croatia', 'HRV', 191, 385),
(55, 'CU', 'CUBA', 'Cuba', 'CUB', 192, 53),
(56, 'CY', 'CYPRUS', 'Cyprus', 'CYP', 196, 357),
(57, 'CZ', 'CZECH REPUBLIC', 'Czech Republic', 'CZE', 203, 420),
(58, 'DK', 'DENMARK', 'Denmark', 'DNK', 208, 45),
(59, 'DJ', 'DJIBOUTI', 'Djibouti', 'DJI', 262, 253),
(60, 'DM', 'DOMINICA', 'Dominica', 'DMA', 212, 1767),
(61, 'DO', 'DOMINICAN REPUBLIC', 'Dominican Republic', 'DOM', 214, 1809),
(62, 'EC', 'ECUADOR', 'Ecuador', 'ECU', 218, 593),
(63, 'EG', 'EGYPT', 'Egypt', 'EGY', 818, 20),
(64, 'SV', 'EL SALVADOR', 'El Salvador', 'SLV', 222, 503),
(65, 'GQ', 'EQUATORIAL GUINEA', 'Equatorial Guinea', 'GNQ', 226, 240),
(66, 'ER', 'ERITREA', 'Eritrea', 'ERI', 232, 291),
(67, 'EE', 'ESTONIA', 'Estonia', 'EST', 233, 372),
(68, 'ET', 'ETHIOPIA', 'Ethiopia', 'ETH', 231, 251),
(69, 'FK', 'FALKLAND ISLANDS (MALVINAS)', 'Falkland Islands (Malvinas)', 'FLK', 238, 500),
(70, 'FO', 'FAROE ISLANDS', 'Faroe Islands', 'FRO', 234, 298),
(71, 'FJ', 'FIJI', 'Fiji', 'FJI', 242, 679),
(72, 'FI', 'FINLAND', 'Finland', 'FIN', 246, 358),
(73, 'FR', 'FRANCE', 'France', 'FRA', 250, 33),
(74, 'GF', 'FRENCH GUIANA', 'French Guiana', 'GUF', 254, 594),
(75, 'PF', 'FRENCH POLYNESIA', 'French Polynesia', 'PYF', 258, 689),
(77, 'GA', 'GABON', 'Gabon', 'GAB', 266, 241),
(78, 'GM', 'GAMBIA', 'Gambia', 'GMB', 270, 220),
(79, 'GE', 'GEORGIA', 'Georgia', 'GEO', 268, 995),
(80, 'DE', 'GERMANY', 'Germany', 'DEU', 276, 49),
(81, 'GH', 'GHANA', 'Ghana', 'GHA', 288, 233),
(82, 'GI', 'GIBRALTAR', 'Gibraltar', 'GIB', 292, 350),
(83, 'GR', 'GREECE', 'Greece', 'GRC', 300, 30),
(84, 'GL', 'GREENLAND', 'Greenland', 'GRL', 304, 299),
(85, 'GD', 'GRENADA', 'Grenada', 'GRD', 308, 1473),
(86, 'GP', 'GUADELOUPE', 'Guadeloupe', 'GLP', 312, 590),
(87, 'GU', 'GUAM', 'Guam', 'GUM', 316, 1671),
(88, 'GT', 'GUATEMALA', 'Guatemala', 'GTM', 320, 502),
(89, 'GN', 'GUINEA', 'Guinea', 'GIN', 324, 224),
(90, 'GW', 'GUINEA-BISSAU', 'Guinea-Bissau', 'GNB', 624, 245),
(91, 'GY', 'GUYANA', 'Guyana', 'GUY', 328, 592),
(92, 'HT', 'HAITI', 'Haiti', 'HTI', 332, 509),
(94, 'VA', 'HOLY SEE (VATICAN CITY STATE)', 'Holy See (Vatican City State)', 'VAT', 336, 39),
(95, 'HN', 'HONDURAS', 'Honduras', 'HND', 340, 504),
(96, 'HK', 'HONG KONG', 'Hong Kong', 'HKG', 344, 852),
(97, 'HU', 'HUNGARY', 'Hungary', 'HUN', 348, 36),
(98, 'IS', 'ICELAND', 'Iceland', 'ISL', 352, 354),
(99, 'IN', 'INDIA', 'India', 'IND', 356, 91),
(100, 'ID', 'INDONESIA', 'Indonesia', 'IDN', 360, 62),
(101, 'IR', 'IRAN, ISLAMIC REPUBLIC OF', 'Iran, Islamic Republic of', 'IRN', 364, 98),
(102, 'IQ', 'IRAQ', 'Iraq', 'IRQ', 368, 964),
(103, 'IE', 'IRELAND', 'Ireland', 'IRL', 372, 353),
(104, 'IL', 'ISRAEL', 'Israel', 'ISR', 376, 972),
(105, 'IT', 'ITALY', 'Italy', 'ITA', 380, 39),
(106, 'JM', 'JAMAICA', 'Jamaica', 'JAM', 388, 1876),
(107, 'JP', 'JAPAN', 'Japan', 'JPN', 392, 81),
(108, 'JO', 'JORDAN', 'Jordan', 'JOR', 400, 962),
(109, 'KZ', 'KAZAKHSTAN', 'Kazakhstan', 'KAZ', 398, 7),
(110, 'KE', 'KENYA', 'Kenya', 'KEN', 404, 254),
(111, 'KI', 'KIRIBATI', 'Kiribati', 'KIR', 296, 686),
(112, 'KP', 'KOREA, DEMOCRATIC PEOPLE''S REPUBLIC OF', 'Korea, Democratic People''s Republic of', 'PRK', 408, 850),
(113, 'KR', 'KOREA, REPUBLIC OF', 'Korea, Republic of', 'KOR', 410, 82),
(114, 'KW', 'KUWAIT', 'Kuwait', 'KWT', 414, 965),
(115, 'KG', 'KYRGYZSTAN', 'Kyrgyzstan', 'KGZ', 417, 996),
(116, 'LA', 'LAO PEOPLE''S DEMOCRATIC REPUBLIC', 'Lao People''s Democratic Republic', 'LAO', 418, 856),
(117, 'LV', 'LATVIA', 'Latvia', 'LVA', 428, 371),
(118, 'LB', 'LEBANON', 'Lebanon', 'LBN', 422, 961),
(119, 'LS', 'LESOTHO', 'Lesotho', 'LSO', 426, 266),
(120, 'LR', 'LIBERIA', 'Liberia', 'LBR', 430, 231),
(121, 'LY', 'LIBYAN ARAB JAMAHIRIYA', 'Libyan Arab Jamahiriya', 'LBY', 434, 218),
(122, 'LI', 'LIECHTENSTEIN', 'Liechtenstein', 'LIE', 438, 423),
(123, 'LT', 'LITHUANIA', 'Lithuania', 'LTU', 440, 370),
(124, 'LU', 'LUXEMBOURG', 'Luxembourg', 'LUX', 442, 352),
(125, 'MO', 'MACAO', 'Macao', 'MAC', 446, 853),
(126, 'MK', 'MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF', 'Macedonia, the Former Yugoslav Republic of', 'MKD', 807, 389),
(127, 'MG', 'MADAGASCAR', 'Madagascar', 'MDG', 450, 261),
(128, 'MW', 'MALAWI', 'Malawi', 'MWI', 454, 265),
(129, 'MY', 'MALAYSIA', 'Malaysia', 'MYS', 458, 60),
(130, 'MV', 'MALDIVES', 'Maldives', 'MDV', 462, 960),
(131, 'ML', 'MALI', 'Mali', 'MLI', 466, 223),
(132, 'MT', 'MALTA', 'Malta', 'MLT', 470, 356),
(133, 'MH', 'MARSHALL ISLANDS', 'Marshall Islands', 'MHL', 584, 692),
(134, 'MQ', 'MARTINIQUE', 'Martinique', 'MTQ', 474, 596),
(135, 'MR', 'MAURITANIA', 'Mauritania', 'MRT', 478, 222),
(136, 'MU', 'MAURITIUS', 'Mauritius', 'MUS', 480, 230),
(137, 'YT', 'MAYOTTE', 'Mayotte', NULL, NULL, 269),
(138, 'MX', 'MEXICO', 'Mexico', 'MEX', 484, 52),
(139, 'FM', 'MICRONESIA, FEDERATED STATES OF', 'Micronesia, Federated States of', 'FSM', 583, 691),
(140, 'MD', 'MOLDOVA, REPUBLIC OF', 'Moldova, Republic of', 'MDA', 498, 373),
(141, 'MC', 'MONACO', 'Monaco', 'MCO', 492, 377),
(142, 'MN', 'MONGOLIA', 'Mongolia', 'MNG', 496, 976),
(143, 'MS', 'MONTSERRAT', 'Montserrat', 'MSR', 500, 1664),
(144, 'MA', 'MOROCCO', 'Morocco', 'MAR', 504, 212),
(145, 'MZ', 'MOZAMBIQUE', 'Mozambique', 'MOZ', 508, 258),
(146, 'MM', 'MYANMAR', 'Myanmar', 'MMR', 104, 95),
(147, 'NA', 'NAMIBIA', 'Namibia', 'NAM', 516, 264),
(148, 'NR', 'NAURU', 'Nauru', 'NRU', 520, 674),
(149, 'NP', 'NEPAL', 'Nepal', 'NPL', 524, 977),
(150, 'NL', 'NETHERLANDS', 'Netherlands', 'NLD', 528, 31),
(151, 'AN', 'NETHERLANDS ANTILLES', 'Netherlands Antilles', 'ANT', 530, 599),
(152, 'NC', 'NEW CALEDONIA', 'New Caledonia', 'NCL', 540, 687),
(153, 'NZ', 'NEW ZEALAND', 'New Zealand', 'NZL', 554, 64),
(154, 'NI', 'NICARAGUA', 'Nicaragua', 'NIC', 558, 505),
(155, 'NE', 'NIGER', 'Niger', 'NER', 562, 227),
(156, 'NG', 'NIGERIA', 'Nigeria', 'NGA', 566, 234),
(157, 'NU', 'NIUE', 'Niue', 'NIU', 570, 683),
(158, 'NF', 'NORFOLK ISLAND', 'Norfolk Island', 'NFK', 574, 672),
(159, 'MP', 'NORTHERN MARIANA ISLANDS', 'Northern Mariana Islands', 'MNP', 580, 1670),
(160, 'NO', 'NORWAY', 'Norway', 'NOR', 578, 47),
(161, 'OM', 'OMAN', 'Oman', 'OMN', 512, 968),
(162, 'PK', 'PAKISTAN', 'Pakistan', 'PAK', 586, 92),
(163, 'PW', 'PALAU', 'Palau', 'PLW', 585, 680),
(164, 'PS', 'PALESTINIAN TERRITORY, OCCUPIED', 'Palestinian Territory, Occupied', NULL, NULL, 970),
(165, 'PA', 'PANAMA', 'Panama', 'PAN', 591, 507),
(166, 'PG', 'PAPUA NEW GUINEA', 'Papua New Guinea', 'PNG', 598, 675),
(167, 'PY', 'PARAGUAY', 'Paraguay', 'PRY', 600, 595),
(168, 'PE', 'PERU', 'Peru', 'PER', 604, 51),
(169, 'PH', 'PHILIPPINES', 'Philippines', 'PHL', 608, 63),
(171, 'PL', 'POLAND', 'Poland', 'POL', 616, 48),
(172, 'PT', 'PORTUGAL', 'Portugal', 'PRT', 620, 351),
(173, 'PR', 'PUERTO RICO', 'Puerto Rico', 'PRI', 630, 1787),
(174, 'QA', 'QATAR', 'Qatar', 'QAT', 634, 974),
(175, 'RE', 'REUNION', 'Reunion', 'REU', 638, 262),
(176, 'RO', 'ROMANIA', 'Romania', 'ROM', 642, 40),
(177, 'RU', 'RUSSIAN FEDERATION', 'Russian Federation', 'RUS', 643, 70),
(178, 'RW', 'RWANDA', 'Rwanda', 'RWA', 646, 250),
(179, 'SH', 'SAINT HELENA', 'Saint Helena', 'SHN', 654, 290),
(180, 'KN', 'SAINT KITTS AND NEVIS', 'Saint Kitts and Nevis', 'KNA', 659, 1869),
(181, 'LC', 'SAINT LUCIA', 'Saint Lucia', 'LCA', 662, 1758),
(182, 'PM', 'SAINT PIERRE AND MIQUELON', 'Saint Pierre and Miquelon', 'SPM', 666, 508),
(183, 'VC', 'SAINT VINCENT AND THE GRENADINES', 'Saint Vincent and the Grenadines', 'VCT', 670, 1784),
(184, 'WS', 'SAMOA', 'Samoa', 'WSM', 882, 684),
(185, 'SM', 'SAN MARINO', 'San Marino', 'SMR', 674, 378),
(186, 'ST', 'SAO TOME AND PRINCIPE', 'Sao Tome and Principe', 'STP', 678, 239),
(187, 'SA', 'SAUDI ARABIA', 'Saudi Arabia', 'SAU', 682, 966),
(188, 'SN', 'SENEGAL', 'Senegal', 'SEN', 686, 221),
(189, 'CS', 'SERBIA AND MONTENEGRO', 'Serbia and Montenegro', NULL, NULL, 381),
(190, 'SC', 'SEYCHELLES', 'Seychelles', 'SYC', 690, 248),
(191, 'SL', 'SIERRA LEONE', 'Sierra Leone', 'SLE', 694, 232),
(192, 'SG', 'SINGAPORE', 'Singapore', 'SGP', 702, 65),
(193, 'SK', 'SLOVAKIA', 'Slovakia', 'SVK', 703, 421),
(194, 'SI', 'SLOVENIA', 'Slovenia', 'SVN', 705, 386),
(195, 'SB', 'SOLOMON ISLANDS', 'Solomon Islands', 'SLB', 90, 677),
(196, 'SO', 'SOMALIA', 'Somalia', 'SOM', 706, 252),
(197, 'ZA', 'SOUTH AFRICA', 'South Africa', 'ZAF', 710, 27),
(199, 'ES', 'SPAIN', 'Spain', 'ESP', 724, 34),
(200, 'LK', 'SRI LANKA', 'Sri Lanka', 'LKA', 144, 94),
(201, 'SD', 'SUDAN', 'Sudan', 'SDN', 736, 249),
(202, 'SR', 'SURINAME', 'Suriname', 'SUR', 740, 597),
(203, 'SJ', 'SVALBARD AND JAN MAYEN', 'Svalbard and Jan Mayen', 'SJM', 744, 47),
(204, 'SZ', 'SWAZILAND', 'Swaziland', 'SWZ', 748, 268),
(205, 'SE', 'SWEDEN', 'Sweden', 'SWE', 752, 46),
(206, 'CH', 'SWITZERLAND', 'Switzerland', 'CHE', 756, 41),
(207, 'SY', 'SYRIAN ARAB REPUBLIC', 'Syrian Arab Republic', 'SYR', 760, 963),
(208, 'TW', 'TAIWAN, PROVINCE OF CHINA', 'Taiwan, Province of China', 'TWN', 158, 886),
(209, 'TJ', 'TAJIKISTAN', 'Tajikistan', 'TJK', 762, 992),
(210, 'TZ', 'TANZANIA, UNITED REPUBLIC OF', 'Tanzania, United Republic of', 'TZA', 834, 255),
(211, 'TH', 'THAILAND', 'Thailand', 'THA', 764, 66),
(212, 'TL', 'TIMOR-LESTE', 'Timor-Leste', NULL, NULL, 670),
(213, 'TG', 'TOGO', 'Togo', 'TGO', 768, 228),
(214, 'TK', 'TOKELAU', 'Tokelau', 'TKL', 772, 690),
(215, 'TO', 'TONGA', 'Tonga', 'TON', 776, 676),
(216, 'TT', 'TRINIDAD AND TOBAGO', 'Trinidad and Tobago', 'TTO', 780, 1868),
(217, 'TN', 'TUNISIA', 'Tunisia', 'TUN', 788, 216),
(218, 'TR', 'TURKEY', 'Turkey', 'TUR', 792, 90),
(219, 'TM', 'TURKMENISTAN', 'Turkmenistan', 'TKM', 795, 7370),
(220, 'TC', 'TURKS AND CAICOS ISLANDS', 'Turks and Caicos Islands', 'TCA', 796, 1649),
(221, 'TV', 'TUVALU', 'Tuvalu', 'TUV', 798, 688),
(222, 'UG', 'UGANDA', 'Uganda', 'UGA', 800, 256),
(223, 'UA', 'UKRAINE', 'Ukraine', 'UKR', 804, 380),
(224, 'AE', 'UNITED ARAB EMIRATES', 'United Arab Emirates', 'ARE', 784, 971),
(225, 'GB', 'UNITED KINGDOM', 'United Kingdom', 'GBR', 826, 44),
(226, 'US', 'UNITED STATES', 'United States', 'USA', 840, 1),
(227, 'UM', 'UNITED STATES MINOR OUTLYING ISLANDS', 'United States Minor Outlying Islands', NULL, NULL, 1),
(228, 'UY', 'URUGUAY', 'Uruguay', 'URY', 858, 598),
(229, 'UZ', 'UZBEKISTAN', 'Uzbekistan', 'UZB', 860, 998),
(230, 'VU', 'VANUATU', 'Vanuatu', 'VUT', 548, 678),
(231, 'VE', 'VENEZUELA', 'Venezuela', 'VEN', 862, 58),
(232, 'VN', 'VIET NAM', 'Viet Nam', 'VNM', 704, 84),
(233, 'VG', 'VIRGIN ISLANDS, BRITISH', 'Virgin Islands, British', 'VGB', 92, 1284),
(234, 'VI', 'VIRGIN ISLANDS, U.S.', 'Virgin Islands, U.s.', 'VIR', 850, 1340),
(235, 'WF', 'WALLIS AND FUTUNA', 'Wallis and Futuna', 'WLF', 876, 681),
(236, 'EH', 'WESTERN SAHARA', 'Western Sahara', 'ESH', 732, 212),
(237, 'YE', 'YEMEN', 'Yemen', 'YEM', 887, 967),
(238, 'ZM', 'ZAMBIA', 'Zambia', 'ZMB', 894, 260),
(239, 'ZW', 'ZIMBABWE', 'Zimbabwe', 'ZWE', 716, 263),
(240, 'RS', 'SERBIA', 'Serbia', 'SRB', 688, 381),
(242, 'ME', 'MONTENEGRO', 'Montenegro', 'MNE', 499, 382),
(243, 'AX', 'ALAND ISLANDS', 'Aland Islands', 'ALA', 248, 358),
(244, 'BQ', 'BONAIRE, SINT EUSTATIUS AND SABA', 'Bonaire, Sint Eustatius and Saba', 'BES', 535, 599),
(245, 'CW', 'CURACAO', 'Curacao', 'CUW', 531, 599),
(246, 'GG', 'GUERNSEY', 'Guernsey', 'GGY', 831, 44),
(247, 'IM', 'ISLE OF MAN', 'Isle of Man', 'IMN', 833, 44),
(248, 'JE', 'JERSEY', 'Jersey', 'JEY', 832, 44),
(249, 'XK', 'KOSOVO', 'Kosovo', '---', 0, 381),
(250, 'BL', 'SAINT BARTHELEMY', 'Saint Barthelemy', 'BLM', 652, 590),
(251, 'MF', 'SAINT MARTIN', 'Saint Martin', 'MAF', 663, 590),
(252, 'SX', 'SINT MAARTEN', 'Sint Maarten', 'SXM', 534, 1),
(253, 'SS', 'SOUTH SUDAN', 'South Sudan', 'SSD', 728, 211);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_editor_book_events`
--

CREATE TABLE IF NOT EXISTS `tbl_editor_book_events` (
  `book_id` int(11) NOT NULL AUTO_INCREMENT,
  `event_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `book_date` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`book_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7 ;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_editor_book_webinar`
--

CREATE TABLE IF NOT EXISTS `tbl_editor_book_webinar` (
  `book_id` int(11) NOT NULL AUTO_INCREMENT,
  `webinar_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `book_date` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`book_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=8 ;

--
-- Dumping data for table `tbl_editor_book_webinar`
--

INSERT INTO `tbl_editor_book_webinar` (`book_id`, `webinar_id`, `user_id`, `status`, `book_date`) VALUES
(5, 4, 21, 0, '12-05-2015'),
(7, 5, 51, 0, '26-03-2016');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_editor_feedback`
--

CREATE TABLE IF NOT EXISTS `tbl_editor_feedback` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `editor_id` int(11) NOT NULL,
  `st_id` int(11) NOT NULL,
  `comments` text NOT NULL,
  `ratings` int(11) NOT NULL,
  `created_date` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `tbl_editor_feedback`
--

INSERT INTO `tbl_editor_feedback` (`id`, `editor_id`, `st_id`, `comments`, `ratings`, `created_date`) VALUES
(1, 44, 6, 'fhgfh', 5, '1450437505'),
(2, 43, 6, 'Hello', 4, '1450438218'),
(3, 44, 6, 'Hello', 3, '1450438259'),
(4, 43, 6, 'What This', 5, '1450438273'),
(5, 43, 6, 'hiii', 5, '1450438282'),
(6, 44, 6, 'This is fine', 2, '1450442690'),
(7, 43, 6, 'This is very fine.', 2, '1450442717'),
(8, 51, 13, 'He is not good...', 4, '1458977775'),
(9, 43, 15, 'resting', 5, '1459413970'),
(10, 43, 15, 'test', 4, '1459415251');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_editor_post_leads`
--

CREATE TABLE IF NOT EXISTS `tbl_editor_post_leads` (
  `lead_id` int(11) NOT NULL AUTO_INCREMENT,
  `editor_id` int(11) NOT NULL,
  `post_id` int(11) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  `created_date` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`lead_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=11 ;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_editor_upgrade`
--

CREATE TABLE IF NOT EXISTS `tbl_editor_upgrade` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `created_date` varchar(100) NOT NULL,
  `expiry_date` varchar(100) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `tbl_editor_upgrade`
--

INSERT INTO `tbl_editor_upgrade` (`id`, `user_id`, `created_date`, `expiry_date`, `status`) VALUES
(8, 40, '1448348533', '1479880800', 0),
(9, 41, '1448601064', '1480053600', 0),
(10, 41, '1448601326', '1480053600', 0);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_events`
--

CREATE TABLE IF NOT EXISTS `tbl_events` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `event_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `reference_no` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `start_date` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `start_date_check` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `start_time` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `end_date` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `end_time` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `country` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `city` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `address` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `perma_url` text COLLATE utf8_unicode_ci NOT NULL,
  `meta_title` text COLLATE utf8_unicode_ci NOT NULL,
  `meta_description` text COLLATE utf8_unicode_ci NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  `created_date` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=16 ;

--
-- Dumping data for table `tbl_events`
--

INSERT INTO `tbl_events` (`id`, `event_title`, `reference_no`, `start_date`, `start_date_check`, `start_time`, `end_date`, `end_time`, `country`, `city`, `address`, `description`, `perma_url`, `meta_title`, `meta_description`, `status`, `created_date`) VALUES
(9, 'Introduction to STATA ', '45646', '08/30/2015', '1440910800', '00:00', '09/30/2015', '00:00', '1', 'New Delhi', 'NSP', 'hhhhhhhhh', 'dfgdfg', 'Manage your Submitted Journals - Journals Directory', 'dfdsf', 1, '20-04-2015'),
(12, 'nominated for largest power transmission line', '(#135RE) PGCIL', '07/31/2015', '1438318800', '07:30', '09/26/2015', '15:00', '99', 'New Delhi', 'NSP', 'The Society for Editors and Proofreaders (SfEP) is a professional organisation based in the UK for editors and proofreaders – the people who strive to make text accurate and readable.\r\nThe Society for Editors and Proofreaders (SfEP) is a professional organisation based in the UK for editors and proofreaders – the people who strive to make text accurate and readable.\r\nThis website contains much information – for members, for tho se who would like to employ them and for anyone connected in some way to the production of text. In particular, you can find out about:\r\njoining the Society\r\ntraining in proofreading and copy-editing\r\nusing the services of SfEP members.\r\n', '', '', '', 1, '25-04-2015'),
(13, 'nominated for largest power transmission line', '(#135RE) PGCIL', '08/18/2015', '1439874000', '05:00', '09/21/2015', '05:30', '243', 'New Delhi', '', 'The Society for Editors and Proofreaders (SfEP) is a professional organisation based in the UK for editors and proofreaders – the people who strive to make text accurate and readable.\r\nThe Society for Editors and Proofreaders (SfEP) is a professional organisation based in the UK for editors and proofreaders – the people who strive to make text accurate and readable.\r\nThis website contains much information – for members, for tho se who would like to employ them and for anyone connected in some way to the production of text. In particular, you can find out about:\r\njoining the Society\r\ntraining in proofreading and copy-editing\r\nusing the services of SfEP members.\r\n', 'nominated for largest power transmission line', '', '', 1, '25-04-2015'),
(14, 'nominated for largest power', '45646', '07/30/2015', '1438232400', '02:00', '08/18/2015', '04:00', '2', 'New Delhi', 'NSP,New delhi', 'The Society for Editors and Proofreaders (SfEP) is a professional organisation based in the UK for editors and proofreaders – the people who strive to make text accurate and readable.', '', 'Manage your Submitted Journals - Journals Directory', 'dgdfgfdg', 1, '04-05-2015'),
(15, 'First Event by Vishal', '28288', '03/27/2016', '1459051200', '06:00', '03/31/2016', '11:00', '99', 'New Delhi', 'NSP, Pitampura', 'this is first evenyt', 'http://www.sfase.org/test/first-event-vishal1.php', 'This could be the meta title', 'This could be the meta description ', 1, '26-03-2016');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_hire_editor`
--

CREATE TABLE IF NOT EXISTS `tbl_hire_editor` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `job_id` int(11) NOT NULL,
  `editor_id` int(11) NOT NULL,
  `st_id` int(11) NOT NULL,
  `status` int(11) NOT NULL COMMENT 'first_hire=0,inproccess=1,waiting=2,incomplte=3,complete=4',
  `hire_date` varchar(100) NOT NULL,
  `comments` text NOT NULL,
  `upload_file` text NOT NULL,
  `uploaded_date` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

--
-- Dumping data for table `tbl_hire_editor`
--

INSERT INTO `tbl_hire_editor` (`id`, `job_id`, `editor_id`, `st_id`, `status`, `hire_date`, `comments`, `upload_file`, `uploaded_date`) VALUES
(1, 23, 43, 6, 4, '1450087669', '', '14503518140testing Issue-QM.rtf', '1450351814'),
(2, 21, 44, 6, 1, '1450163188', '', '', ''),
(3, 20, 43, 6, 4, '1450412780', 'Hello', '14504217280Query_04-11-2015.xls||14504217281testing Issue-QM.rtf||14504217282logo-210x182.png', '1450421728'),
(4, 34, 40, 12, 4, '1456996101', 'done. please check and revert.', '14569964450Test Test.docx', '1456996445'),
(5, 35, 40, 12, 4, '1456997000', '', '14569970650Test Test.docx', '1456997065'),
(6, 22, 41, 6, 1, '1457066670', '', '', ''),
(7, 36, 41, 6, 3, '1457091770', 'hhhhhhhhhhhhhh', '14570937180SfASE Testing.odt', '1457093718'),
(8, 37, 40, 12, 0, '1457323732', '', '', ''),
(9, 38, 40, 12, 1, '1458207692', '', '', ''),
(10, 39, 51, 13, 3, '1458975903', 'Hi,\r\n\r\nI have done my task. Please review the attached work sheet.', '14589766680abcd.docx||14589766681edupliance-logo.png', '1458976668'),
(11, 41, 51, 13, 4, '1458977994', 'Hi,\r\n\r\nThis is done now..', '14589780740abcd.docx', '1458978074'),
(12, 45, 43, 15, 4, '1459333365', '', '14593414770List of Issues in Sfase1.docx', '1459341477'),
(13, 46, 43, 15, 1, '1459341786', '', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_job_apply`
--

CREATE TABLE IF NOT EXISTS `tbl_job_apply` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `editor_id` int(11) NOT NULL,
  `job_id` int(11) NOT NULL,
  `st_id` int(11) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '0' COMMENT '0=first_assign, 1=inproccess',
  `apply_date` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;

--
-- Dumping data for table `tbl_job_apply`
--

INSERT INTO `tbl_job_apply` (`id`, `editor_id`, `job_id`, `st_id`, `status`, `apply_date`) VALUES
(5, 43, 20, 6, 1, '1450069463'),
(6, 43, 24, 8, 0, '1450072841'),
(7, 43, 21, 6, 1, '1450072902'),
(8, 44, 24, 8, 0, '1450077776'),
(9, 44, 23, 6, 1, '1450077790'),
(10, 44, 21, 6, 1, '1450077889'),
(11, 43, 23, 6, 1, '1450086048'),
(12, 41, 22, 6, 1, '1450696199'),
(13, 43, 30, 6, 0, '1451285514'),
(14, 40, 34, 12, 1, '1456996032'),
(15, 40, 35, 12, 1, '1456996790'),
(16, 41, 36, 6, 1, '1457090790'),
(17, 40, 37, 12, 1, '1457323660'),
(18, 40, 38, 12, 1, '1458207341'),
(19, 51, 39, 13, 1, '1458975109'),
(20, 51, 41, 13, 1, '1458977692'),
(21, 64, 40, 13, 0, '1459314306'),
(22, 73, 40, 13, 0, '1459327636'),
(23, 43, 45, 15, 1, '1459332522'),
(24, 43, 29, 10, 0, '1459339466'),
(25, 43, 46, 15, 1, '1459339626'),
(26, 43, 48, 15, 0, '1459410600');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_message`
--

CREATE TABLE IF NOT EXISTS `tbl_message` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `editor_id` int(11) NOT NULL,
  `st_id` int(11) NOT NULL,
  `sender_type` int(11) NOT NULL COMMENT '1=editor,2=student',
  `message` text NOT NULL,
  `date` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=45 ;

--
-- Dumping data for table `tbl_message`
--

INSERT INTO `tbl_message` (`id`, `editor_id`, `st_id`, `sender_type`, `message`, `date`) VALUES
(1, 43, 6, 2, 'gffh', '1450166952'),
(2, 43, 6, 2, 'Hello', '1450170121'),
(3, 43, 6, 2, 'How are You', '1450170151'),
(4, 43, 6, 2, 'Hi', '1450170199'),
(5, 43, 6, 2, 'Hello', '1450176126'),
(6, 43, 6, 2, 'hhhhhh', '1450176314'),
(7, 43, 6, 2, 'jjjjjjjjjj', '1450176589'),
(8, 43, 6, 2, 'kkkk', '1450176749'),
(9, 43, 6, 2, 'Hello', '1450178902'),
(10, 43, 6, 2, 'hjjj', '1450179566'),
(11, 44, 6, 2, 'Hello', '1450179841'),
(12, 44, 6, 2, 'Hi..', '1450180584'),
(13, 44, 6, 2, 'jjjj', '1450180785'),
(14, 44, 6, 2, 'kkkk', '1450180792'),
(15, 39, 6, 2, 'hello', '1450182371'),
(16, 43, 6, 1, 'Hello', '1450344803'),
(17, 43, 6, 1, 'hiiiiiiiiii', '1450345077'),
(18, 43, 6, 1, 'kkk', '1450346261'),
(19, 43, 6, 1, 'yes', '1450346831'),
(20, 43, 6, 2, 'Yes ok', '1450347858'),
(21, 44, 9, 2, 'how r u', '1450691714'),
(22, 39, 9, 2, 'hii', '1450692620'),
(23, 41, 9, 2, 'hi', '1450696340'),
(24, 44, 9, 2, 'hi', '1450848594'),
(25, 44, 10, 2, 'hi', '1450851619'),
(26, 43, 6, 1, 'kiiiiii', '1451276869'),
(27, 43, 6, 1, 'Hhhhhh', '1451277034'),
(28, 43, 6, 1, 'kkk', '1451277054'),
(29, 43, 6, 2, 'dfgdgfhtyt', '1451277284'),
(30, 45, 6, 2, 'heelo', '1451277317'),
(31, 43, 6, 2, 'kkkkkkkk', '1451279662'),
(32, 45, 6, 2, 'hhhhhh', '1451279726'),
(33, 43, 6, 2, 'hgfh', '1451284762'),
(34, 40, 9, 2, 'hi', '1451969357'),
(35, 40, 9, 1, 'what is the work scope', '1452758719'),
(36, 40, 9, 1, 'Hi', '1456996193'),
(37, 40, 9, 1, 'hello', '1456996310'),
(38, 40, 12, 2, 'hi mam', '1456996808'),
(39, 40, 12, 1, 'hi', '1456996958'),
(40, 40, 12, 2, 'sdsds', '1458207402'),
(41, 51, 13, 2, 'Hello Vishal Editor...', '1458973928'),
(42, 51, 13, 1, 'Hi Vishal Scholar.......Hope you good. Hi Vishal Scholar.......Hope you good. Hi Vishal Scholar.......Hope you good. Hi Vishal Scholar.......Hope you good. Hi Vishal Scholar.......Hope you good. Hi Vishal Scholar.......Hope you good. Hi Vishal Scholar.......Hope you good. Hi Vishal Scholar.......Hope you good. Hi Vishal Scholar.......Hope you good. Hi Vishal Scholar.......Hope you good. Hi Vishal Scholar.......Hope you good. Hi Vishal Scholar.......Hope you good. Hi Vishal Scholar.......Hope you good.', '1458973982'),
(43, 51, 13, 1, 'Waiting for your revert...', '1458973998'),
(44, 51, 13, 2, 'Hi, I have selected you..', '1458975512');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_online_webinars`
--

CREATE TABLE IF NOT EXISTS `tbl_online_webinars` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `webinar_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `reference_no` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `date` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `date_check` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `image` text COLLATE utf8_unicode_ci NOT NULL,
  `key_benefits` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  `created_date` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7 ;

--
-- Dumping data for table `tbl_online_webinars`
--

INSERT INTO `tbl_online_webinars` (`id`, `webinar_title`, `reference_no`, `date`, `date_check`, `image`, `key_benefits`, `description`, `status`, `created_date`) VALUES
(1, 'sdfsdf', 'sdfsdf', '08/26/2015', '1440565200', '1438084437Tulips.jpg', '<!DOCTYPE html>\r\n<html>\r\n<head>\r\n</head>\r\n<body>\r\n\r\n</body>\r\n</html>', '<!DOCTYPE html>\r\n<html>\r\n<head>\r\n</head>\r\n<body>\r\n<p>dsfsdf</p>\r\n</body>\r\n</html>', 1, '21-04-2015'),
(2, 'sdfsdf', '45646', '08/19/2015', '1439960400', '1438084404Chrysanthemum.jpg', '<!DOCTYPE html>\r\n<html>\r\n<head>\r\n</head>\r\n<body>\r\n\r\n</body>\r\n</html>', '<!DOCTYPE html>\r\n<html>\r\n<head>\r\n</head>\r\n<body>\r\n<p><strong>Breakfast briefing/roundtable discussion A joint event with the International Longevity Centre UK (a think tank)</strong> <br /><br />SFASE hosted its first roundtable breakfast briefing on 20 November 2013 at the SfEP office. The guests included representatives from Age UK, Which? and International Longevity Centre and they discussed ''editing, imagery, marketing and writing for an ageing society &ndash; how to overcome barriers to effective communication''. <br /><br />SFASE initiated the event after reading the International Longevity Centre UK''s (ILC-UK) paper titled Golden Economy The Consumer Marketplace in an Ageing Society and wanted to follow up on some of the findings, namely that technical jargon, unclear instructions, poor language, misleading and dishonest <br /><br />Information and lack of clarity are barriers that can and do change attitudes, perceptions and desire to buy products or use services for the older generation. We were very interested in these findings because we are a professional body interested in upholding editorial excellence, so the whole communications, writing, phraseology, terminology sphere is very important to us.</p>\r\n<p>&nbsp;</p>\r\n<p>Booking is now open: please follow the links on the right of this page.</p>\r\n<p>&nbsp;</p>\r\n<p>Please email us if you have any comments or queries.</p>\r\n<p>&nbsp;</p>\r\n<p>Christine Vaughan, <strong><span class="style2">SFASE conference director</span></strong> <a class="link-patrn" href="mailto:conference@sfep.org.uk">conference@sfase.org</a></p>\r\n</body>\r\n</html>', 1, '21-04-2015'),
(3, 'sdfsdf', '45646', '08/28/2015', '1440738000', '1429592715IMG_06072013_105530.png', '<!DOCTYPE html>\r\n<html>\r\n<head>\r\n</head>\r\n<body>\r\n<ul class="web-key">\r\n<li>University of York campus map</li>\r\n<li>Travel information)</li>\r\n<li>Conference programme (provisional)</li>\r\n<li>Pre-booking information</li>\r\n</ul>\r\n</body>\r\n</html>', '<!DOCTYPE html>\r\n<html>\r\n<head>\r\n</head>\r\n<body>\r\n<p><strong>Breakfast briefing/roundtable discussion A joint event with the International Longevity Centre UK (a think tank)</strong> <br /><br />SFASE hosted its first roundtable breakfast briefing on 20 November 2013 at the SfEP office. The guests included representatives from Age UK, Which? and International Longevity Centre and they discussed ''editing, imagery, marketing and writing for an ageing society &ndash; how to overcome barriers to effective communication''. <br /><br />SFASE initiated the event after reading the International Longevity Centre UK''s (ILC-UK) paper titled Golden Economy The Consumer Marketplace in an Ageing Society and wanted to follow up on some of the findings, namely that technical jargon, unclear instructions, poor language, misleading and dishonest <br /><br />Information and lack of clarity are barriers that can and do change attitudes, perceptions and desire to buy products or use services for the older generation. We were very interested in these findings because we are a professional body interested in upholding editorial excellence, so the whole communications, writing, phraseology, terminology sphere is very important to us.</p>\r\n<p>&nbsp;</p>\r\n<p>Booking is now open: please follow the links on the right of this page.</p>\r\n<p>&nbsp;</p>\r\n<p>Please email us if you have any comments or queries.</p>\r\n<p>&nbsp;</p>\r\n<p>Christine Vaughan, <strong><span class="style2">SFASE conference director</span></strong> <a class="link-patrn" href="mailto:conference@sfep.org.uk">conference@sfase.org</a></p>\r\n</body>\r\n</html>', 1, '21-04-2015'),
(4, 'hhhhhhhhh', '(#135RE) PGCIL', '08/29/2015', '1440824400', '1430737064BELK Asia Pacific Journal of Finance and Risk Management.jpg', '<!DOCTYPE html>\r\n<html>\r\n<head>\r\n</head>\r\n<body>\r\n<ul>\r\n<li>The Society for Editors and Proofreaders (SfEP) is a professional</li>\r\n<li>organisation based in the UK for editors and proofreaders &ndash;</li>\r\n<li>the people who strive to make text accurate and readable.</li>\r\n</ul>\r\n</body>\r\n</html>', '<!DOCTYPE html>\r\n<html>\r\n<head>\r\n</head>\r\n<body>\r\n<p>The Society for Editors and Proofreaders (SfEP) is a professional organisation based in the UK for editors and proofreaders &ndash; the people who strive to make text accurate and readable.</p>\r\n</body>\r\n</html>', 1, '04-05-2015'),
(5, 'Webinar by Vishal Verma 1', '292992', '03/31/2016', '1459396800', '1458980229FullSizeRender (2).jpg', '<!DOCTYPE html>\r\n<html>\r\n<head>\r\n</head>\r\n<body>\r\n<p>This is testing key beneftics..This is testing key beneftics..This is testing key beneftics..This is testing key beneftics..This is testing key beneftics..This is testing key beneftics..This is testing key beneftics..This is testing key beneftics..This is testing key beneftics..This is testing key beneftics..This is testing key beneftics..This is testing key beneftics..This is testing key beneftics..This is testing key beneftics..This is testing key beneftics..This is testing key beneftics..This is testing key beneftics..This is testing key beneftics..This is testing key beneftics..</p>\r\n</body>\r\n</html>', '<!DOCTYPE html>\r\n<html>\r\n<head>\r\n</head>\r\n<body>\r\n<p>This is testing description.&nbsp;This is testing description.&nbsp;This is testing description.&nbsp;This is testing description.&nbsp;This is testing description.&nbsp;This is testing description.&nbsp;This is testing description.&nbsp;This is testing description.&nbsp;This is testing description.&nbsp;This is testing description.&nbsp;This is testing description.&nbsp;This is testing description.&nbsp;This is testing description.&nbsp;This is testing description.&nbsp;This is testing description.&nbsp;</p>\r\n</body>\r\n</html>', 1, '26-03-2016'),
(6, '2nd Webinat by Vishal verma', '828281', '03/31/2016', '1459396800', '1458980364emarketz-logo.png', '<!DOCTYPE html>\r\n<html>\r\n<head>\r\n</head>\r\n<body>\r\n<p>Key Benefits are:</p>\r\n<p>ABCDDD</p>\r\n<p>PQEHEHHE</p>\r\n<p>DKDHKD</p>\r\n</body>\r\n</html>', '<!DOCTYPE html>\r\n<html>\r\n<head>\r\n</head>\r\n<body>\r\n<p>Nothing to dispay.&nbsp;Nothing to dispay.&nbsp;Nothing to dispay.&nbsp;Nothing to dispay.&nbsp;Nothing to dispay.&nbsp;Nothing to dispay.&nbsp;Nothing to dispay.&nbsp;Nothing to dispay.&nbsp;Nothing to dispay.&nbsp;Nothing to dispay.&nbsp;Nothing to dispay.&nbsp;Nothing to dispay.&nbsp;Nothing to dispay.&nbsp;Nothing to dispay.&nbsp;Nothing to dispay.&nbsp;Nothing to dispay.&nbsp;Nothing to dispay.&nbsp;Nothing to dispay.&nbsp;Nothing to dispay.&nbsp;Nothing to dispay.&nbsp;Nothing to dispay.&nbsp;Nothing to dispay.&nbsp;Nothing to dispay.&nbsp;Nothing to dispay.&nbsp;Nothing to dispay.&nbsp;Nothing to dispay.&nbsp;Nothing to dispay.&nbsp;Nothing to dispay.&nbsp;Nothing to dispay.&nbsp;</p>\r\n</body>\r\n</html>', 1, '26-03-2016');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_post_editing`
--

CREATE TABLE IF NOT EXISTS `tbl_post_editing` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `job_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `subject_area` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `servies` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `deadline` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `word_count` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `more_information` text COLLATE utf8_unicode_ci NOT NULL,
  `attach_document` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status` int(11) NOT NULL DEFAULT '0',
  `created_date` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `st_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=49 ;

--
-- Dumping data for table `tbl_post_editing`
--

INSERT INTO `tbl_post_editing` (`id`, `job_title`, `subject_area`, `servies`, `deadline`, `word_count`, `more_information`, `attach_document`, `status`, `created_date`, `st_id`) VALUES
(19, 'Supersandwich', 'Aeronautical engineering', 'Editing', '11/25/2015', '500', 'Hero No. 1', '', 0, '11-12-2015', 6),
(20, 'Supersandwich', 'Agricultural science', 'Editing', '12/21/2015', '500', 'sadasd', '', 0, '11-12-2015', 6),
(21, 'Software Developer', 'Applied physics', 'Proofreading', '12/18/2015', '500', 'hhhhhhhhhhhhhh', '', 0, '11-12-2015', 6),
(22, 'PHP Developer', 'Condensed matter physics', 'Editing + Formatting', '12/19/2015', '100', 'hhhhhhhhh', '', 0, '11-12-2015', 6),
(23, 'Software Developer', 'Personal communication', 'Proofreading + Formatting', '12/25/2015', '100', 'ddddddddddddd', '14498263150testing Issue-QM.rtf||14498263151opencartdemo.sql', 0, '11-12-2015', 6),
(24, 'Software Engineer', 'Condensed matter physics', 'Proofreading', '12/12/2015', '1000', 'hhhhhhhhhh', '14498266270Invoice_EDU1042.docx', 0, '11-12-2015', 8),
(25, 'Require Editor for PHD Thesis editing', 'Computer science and information systems', 'Editing', '12/29/2015', '10000', '', '14506941420test.doc||14506941421westendway.rtf||14506941422Home.png||14506941423E commerce admin details.xlsx', 0, '21-12-2015', 9),
(26, 'Require Editor for PHD Thesis editing', 'Computer science and information systems', 'Editing + Formatting', '12/29/2015', '12122', '', '', 0, '21-12-2015', 9),
(27, 'Require Editor for PHD Thesis editing', 'Computer science and information systems', 'Editing + Formatting', '12/29/2015', '1000', '', '', 0, '21-12-2015', 9),
(28, 'Edit PHD thesis', 'Computer science and information systems', 'Proofreading', '12/31/2015', '123330', 'hksfhbf', '14508484780360ECommerce Details.docx', 0, '22-12-2015', 9),
(29, 'Editor', 'Marketing', 'Editing', '12/24/2015', '1000', 'afscdsc', '14508517750https.docx', 0, '23-12-2015', 10),
(30, 'Software Engineer New', 'Allied health professions', 'Formatting', '12/24/2015', '500', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book', '14512788270Invoice_EDU1042.docx', 0, '27-12-2015', 6),
(31, 'Require Editor for PHD Thesis editing', 'Communication studies', 'Editing + Formatting', '01/20/2016', '10000', 'hfjhg', '', 0, '04-01-2016', 9),
(32, 'management project', 'Other - humanities, arts, and social sciences', 'Proofreading', '01/22/2016', '20000', '', '14527590230New OpenDocument Text.odt', 0, '14-01-2016', 12),
(33, 'DASDS', 'SDFDSFSD', 'Editing', '01/13/2016', '4524', 'SDFSD', '', 0, '21-01-2016', 9),
(34, 'TEST', 'Management', 'Proofreading + Formatting', '03/17/2016', '3000', '', '14569959900Test Test.docx', 0, '03-03-2016', 12),
(35, 'project test', 'Other - humanities, arts, and social sciences', 'Proofreading + Formatting', '03/23/2016', '2000', '', '14569967600Test.rtf', 0, '03-03-2016', 12),
(36, 'New Project', 'Agricultural science', 'Editing + Formatting', '03/18/2016', '500', 'Testings', '14570907560Redmarkediting Testing.docx', 0, '04-03-2016', 6),
(37, 'test2', 'Business, management, and accounting', 'Proofreading + Formatting', '03/22/2016', '3000', 'test', '', 0, '06-03-2016', 12),
(38, 'Test Project', 'Business, management, and accounting', 'Proofreading + Formatting', '03/31/2016', '22', 'sdsd', '14582072110abcd.docx', 0, '17-03-2016', 12),
(39, 'FIrst job assign to Vishal Editorrd by Schoolarrr', 'History', 'Proofreading + Formatting', '03/31/2016', '5000', 'this is testing infoirmation. this is testing infoirmation. this is testing infoirmation. this is testing infoirmation. this is testing infoirmation. this is testing infoirmation. ', '14589747060abcd.docx||14589747061robots.txt', 1, '26-03-2016', 13),
(40, 'Second job by Vishal Scholarrrrr', 'Literature', 'Editing', '03/26/2016', '4000', 'testjing.. testjing.. testjing.. testjing.. testjing.. testjing.. testjing.. testjing.. testjing.. testjing.. ', '14589771230Sample format of article content.docx', 0, '26-03-2016', 13),
(41, 'Third job by Vishal Scholarrrrr', 'Computer science and information systems', 'Editing + Formatting', '03/26/2016', '6000', 'nothing..trsting.nothing..trsting.nothing..trsting.nothing..trsting.nothing..trsting.nothing..trsting.', '14589775140Sample format of article content.docx', 0, '26-03-2016', 13),
(42, '4th Job by Vishal Scholar', 'Internal medicine', 'Proofreading', '03/29/2016', '3333', 'this is testing', '14589823980Sample format of article content.docx', 0, '26-03-2016', 13),
(43, '5th Job by Vishal Scholar', 'Biomedical engineering', 'Proofreading + Formatting', '03/29/2016', '9999', 'sssf s s d', '14589824630Sample format of article content.docx', 0, '26-03-2016', 13),
(44, 'website', 'website', 'Editing', '03/16/2016', '1000', 'testing', '14593302640List of Issues in Sfase1.docx', 1, '30-03-2016', 15),
(45, 'website', 'fsdfsdfsdfsdfsd', 'Editing', '03/31/2016', '1000', 'sdfsdsdfgsdfsdf', '14593320010List of Issues in Sfase1.docx', 1, '30-03-2016', 15),
(46, 'software', 'rtfhrtrtyh', 'Editing', '13-03-2016', '5000', 'tytrtyhrtrgher', '14593395970List of Issues in Sfase1.docx', 1, '30-03-2016', 15),
(47, 'assignment', 'refrefe', 'Editing', '03/26/2016', '245', 'ergerer', '14594022820List of Issues in Sfase1.docx', 1, '31/03/2016', 15),
(48, 'yrtyrtyrtyrty', 'aasderfetretr', 'Editing', '31-03-2016', '452345345', 'rege', '14594105690List of Issues in Sfase1.docx', 1, '31-03-2016', 15);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_subject_area`
--

CREATE TABLE IF NOT EXISTS `tbl_subject_area` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subject_area_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=105 ;

--
-- Dumping data for table `tbl_subject_area`
--

INSERT INTO `tbl_subject_area` (`id`, `subject_area_name`) VALUES
(1, 'Anthropology'),
(2, 'Archaeology'),
(3, 'Behavioral science'),
(4, 'Business, management, and accounting'),
(5, 'Communication studies'),
(6, 'Cultural studies'),
(7, 'Decision sciences'),
(8, 'Economics, econometrics, and finance'),
(9, 'Education'),
(10, 'Ethnic and gender studies'),
(11, 'Fine arts'),
(12, 'Geography'),
(13, 'History'),
(14, 'Information science'),
(15, 'Law'),
(16, 'Linguistics'),
(17, 'Literature'),
(18, 'Media and journalism'),
(19, 'Music'),
(20, 'Nursing/Healthcare'),
(21, 'Performing arts'),
(22, 'Personal communication'),
(23, 'Philosophy'),
(24, 'Political science'),
(25, 'Psychology'),
(26, 'Religious studies and theology'),
(27, 'Sociology'),
(28, 'Sports and recreation studies'),
(29, 'Visual arts'),
(30, 'Other - humanities, arts, and social sciences'),
(31, 'Aeronautical engineering'),
(32, 'Applied physics'),
(33, 'Artificial intelligence and robotics'),
(34, 'Astronomy and astrophysics'),
(35, 'Atomic, molecular, and optical physics'),
(36, 'Biochemistry'),
(37, 'Biomedical engineering'),
(38, 'Chemical Engineering'),
(39, 'Chemistry'),
(40, 'Civil engineering'),
(41, 'Computer science and information systems'),
(42, 'Condensed matter physics'),
(43, 'Earth and planetary sciences'),
(44, 'Electronics and electrical engineering'),
(45, 'Energy'),
(46, 'Environmental science'),
(47, 'Experimental physics'),
(48, 'Industrial engineering'),
(49, 'Inorganic chemistry'),
(50, 'Materials science'),
(51, 'Mathematics'),
(52, 'Mechanical engineering'),
(53, 'Nanotechnology'),
(54, 'Nuclear and particle physics'),
(55, 'Organic chemistry'),
(56, 'Physical chemistry'),
(57, 'Physics'),
(58, 'Quantum physics'),
(59, 'Statistics'),
(60, 'Theoretical chemistry'),
(61, 'Theoretical physics'),
(62, 'Other - physical sciences and engineering'),
(63, 'Robotics'),
(64, 'Agricultural science'),
(65, 'Allied health professions'),
(66, 'Anatomy and taxonomy'),
(67, 'Biochemistry and molecular biology'),
(68, 'Biotechnology'),
(69, 'Botany'),
(70, 'Cardiology'),
(71, 'Dentistry'),
(72, 'Dermatology'),
(73, 'Ecology'),
(74, 'ENT (Otolaryngology)'),
(75, 'Entomology'),
(76, 'Evolutionary biology'),
(77, 'Gastroenterology and hepatology'),
(78, 'Genetics and genomics'),
(79, 'Geriatrics'),
(80, 'Hematology'),
(81, 'Immunology and microbiology'),
(82, 'Infectious diseases'),
(83, 'Internal medicine'),
(84, 'Neuroscience and neurology'),
(85, 'Nursing'),
(86, 'Nutrition and dietetics'),
(87, 'Obstetrics and gynecology'),
(88, 'Oncology'),
(89, 'Ophthalmology'),
(90, 'Orthopedics'),
(91, 'Pathology'),
(92, 'Pediatrics'),
(93, 'Pharmacology, toxicology, and pharmaceutics'),
(94, 'Physiology'),
(95, 'Plastic surgery'),
(96, 'Preventive medicine and public health'),
(97, 'Psychiatry and clinical psychology'),
(98, 'Respiratory care'),
(99, 'Sports medicine'),
(100, 'Surgery'),
(101, 'Urology'),
(102, 'Veterinary'),
(103, 'Zoology'),
(104, 'Other - medicine and life sciences');

