Simple Project(Part-3a)
.......................................................................................
In this section i will try to create some functions for logged user.Here first one is create profile.It's badly need to create two table(country,create_profile).
.......................................................................................
1.CREATE TABLE `create_profile` (
`id` int(10) NOT NULL auto_increment,
`userid` int(11) NOT NULL,
`userName` varchar(255) NOT NULL,
`userfatherName` varchar(255) NOT NULL,
`userOccupation` varchar(255) NOT NULL,
`userNationality` varchar(255) NOT NULL,
`userReligion` varchar(255) NOT NULL,
`userAddress` varchar(255) NOT NULL,
`userDesignation` varchar(255) NOT NULL,
`country` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
2.CREATE TABLE `countrys` (
`COUNTRY_ID` int(11) NOT NULL auto_increment,
`COUNTRY` varchar(100) collate utf8_unicode_ci default NULL,
`ISO3166CODE` varchar(2) collate utf8_unicode_ci default NULL,
`CONTINENT_ID` int(10) default NULL,
`ISACTIVE` tinyint(1) NOT NULL default '1',
`USER_ID_INSERTED` int(10) default NULL,
`USER_ID_UPDATED` int(10) default NULL,
`DATE_INSERTED` datetime default NULL,
`DATE_UPDATED` datetime default NULL,
PRIMARY KEY (`COUNTRY_ID`),
KEY `FK_COUNTRY_CONTINENT` (`CONTINENT_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=245 ;
--
-- Dumping data for table `countrys`
--
INSERT INTO `countrys` (`COUNTRY_ID`, `COUNTRY`, `ISO3166CODE`, `CONTINENT_ID`, `ISACTIVE`, `USER_ID_INSERTED`, `USER_ID_UPDATED`, `DATE_INSERTED`, `DATE_UPDATED`) VALUES
(1, 'Bangladesh', 'BD', 1, 1, 0, 3, '2010-02-06 08:02:57', '2010-06-16 15:06:26'),
(2, 'India', 'IN', 1, 1, 0, 5, '2010-02-06 09:02:09', '2010-02-08 12:02:11'),
(4, 'Afghanistan', 'AF', 1, 1, 0, 91, '2010-02-06 09:02:20', '2010-04-23 10:04:43'),
(5, 'Armenia', 'AM', 1, 1, 0, 91, '2010-02-06 09:02:13', '2010-04-23 10:04:02'),
(6, 'Azerbaijan', 'AZ', 1, 1, 0, 91, '2010-02-06 09:02:04', '2010-04-23 10:04:28'),
(7, 'Brunei', 'BN', 1, 1, 0, 91, '2010-02-06 09:02:22', '2010-04-23 10:04:12'),
(8, 'Bhutan', 'BT', 1, 1, 0, 91, '2010-02-06 09:02:42', '2010-04-23 10:04:25'),
(9, 'Cambodia', 'KH', 1, 1, 0, 91, '2010-02-06 09:02:14', '2010-04-23 10:04:43'),
(10, 'Indonesia', 'ID', 1, 1, 0, 91, '2010-02-06 09:02:31', '2010-04-23 10:04:59'),
(12, 'Malaysia', 'MY', 1, 1, 0, 91, '2010-02-06 09:02:05', '2010-04-23 10:04:54'),
(13, 'Maldives', 'MV', 1, 1, 0, 91, '2010-02-06 09:02:29', '2010-04-23 10:04:07'),
(14, 'Myanmar', 'MM', 1, 1, 0, 91, '2010-02-06 09:02:50', '2010-04-23 10:04:20'),
(15, 'Nepal', 'NP', 1, 1, 0, 91, '2010-02-06 09:02:06', '2010-04-23 10:04:33'),
(16, 'Pakistan', 'PK', 1, 1, 0, 91, '2010-02-06 09:02:19', '2010-04-23 10:04:47'),
(17, 'Papua New Guinea', 'PG', 1, 1, 0, 91, '2010-02-06 09:02:35', '2010-04-23 10:04:02'),
(18, 'Philippines', 'PH', 1, 1, 0, 91, '2010-02-06 09:02:48', '2010-04-23 10:04:15'),
(19, 'Singapore', 'SG', 1, 1, 0, 91, '2010-02-06 09:02:01', '2010-04-23 10:04:37'),
(20, 'Sri Lanka', 'LK', 1, 1, 0, 91, '2010-02-06 09:02:18', '2010-04-23 10:04:54'),
(21, 'Thailand', 'TH', 1, 1, 0, 91, '2010-02-06 09:02:30', '2010-04-23 10:04:08'),
(22, 'Vietnam', 'VN', 1, 1, 0, 91, '2010-02-06 09:02:46', '2010-04-23 10:04:27'),
(23, 'Kazakhstan', 'KZ', 1, 1, 0, 91, '2010-02-06 09:02:15', '2010-04-23 10:04:46'),
(24, 'Kyrgyzstan', 'KG', 1, 1, 0, 91, '2010-02-06 09:02:27', '2010-04-23 10:04:14'),
(25, 'Turkmenistan', 'TM', 1, 1, 0, 91, '2010-02-06 09:02:21', '2010-04-23 10:04:37'),
(26, 'Uzbekistan', 'UZ', 1, 1, 0, 91, '2010-02-06 09:02:34', '2010-04-23 10:04:53'),
(27, 'China', 'CN', 1, 1, 0, 91, '2010-02-06 09:02:46', '2010-04-23 10:04:17'),
(28, 'Japan', 'JP', 1, 1, 0, 91, '2010-02-06 09:02:22', '2010-04-23 10:04:36'),
(29, 'North Korea', 'KP', 1, 1, 0, 91, '2010-02-06 09:02:37', '2010-04-23 10:04:07'),
(30, 'South Korea', 'KR', 1, 1, 0, 91, '2010-02-06 09:02:52', '2010-04-23 10:04:57'),
(31, 'Mongolia', 'MN', 1, 1, 0, 91, '2010-02-06 09:02:04', '2010-04-23 10:04:13'),
(32, 'Taiwan', 'TW', 1, 1, 0, 91, '2010-02-06 09:02:17', '2010-04-23 10:04:40'),
(33, 'Bahrain', 'BH', 1, 1, 0, 91, '2010-02-06 09:02:02', '2010-04-23 10:04:58'),
(34, 'Georgia', 'GE', 1, 1, 0, 91, '2010-02-06 09:02:14', '2010-04-23 10:04:15'),
(35, 'Iran', 'IR', 1, 1, 0, 91, '2010-02-06 09:02:24', '2010-04-23 10:04:34'),
(36, 'Iraq', 'IQ', 1, 1, 0, 91, '2010-02-06 09:02:41', '2010-04-23 10:04:47'),
(37, 'Israel', 'IL', 1, 1, 0, 91, '2010-02-06 09:02:52', '2010-04-23 10:04:02'),
(38, 'Jordan', 'JO', 1, 1, 0, 91, '2010-02-06 09:02:03', '2010-04-23 10:04:18'),
(39, 'Kuwait', 'KW', 1, 1, 0, 91, '2010-02-06 09:02:16', '2010-04-23 10:04:36'),
(40, 'Lebanon', 'LB', 1, 1, 0, 91, '2010-02-06 09:02:27', '2010-04-23 10:04:53'),
(41, 'Oman', 'OM', 1, 1, 0, 91, '2010-02-06 09:02:37', '2010-04-23 10:04:16'),
(42, 'Qatar', 'QA', 1, 1, 0, 91, '2010-02-06 09:02:52', '2010-04-23 10:04:35'),
(43, 'Saudi Arabia', 'SA', 1, 1, 0, 91, '2010-02-06 09:02:06', '2010-04-23 10:04:08'),
(44, 'Syria', 'SY', 1, 1, 0, 91, '2010-02-06 09:02:20', '2010-04-23 10:04:55'),
(45, 'U.A.E.', 'AE', 1, 1, 0, 91, '2010-02-06 09:02:36', '2010-04-23 10:04:27'),
(46, 'Yemen', 'YE', 1, 1, 0, 91, '2010-02-06 09:02:08', '2010-04-23 10:04:43'),
(47, 'Albania', 'AL', 4, 1, 0, 91, '2010-02-06 09:02:45', '2010-04-23 10:04:02'),
(48, 'Andorra', 'AD', 4, 1, 0, 91, '2010-02-06 10:02:22', '2010-04-23 10:04:21'),
(49, 'Austria', 'AT', 4, 1, 0, 91, '2010-02-06 10:02:05', '2010-04-23 10:04:35'),
(50, 'Belgium', 'BE', 4, 1, 0, 91, '2010-02-06 10:02:33', '2010-04-23 10:04:53'),
(51, 'Bulgaria', 'BG', 4, 1, 0, 5, '2010-02-06 10:02:55', '2010-04-23 10:04:35'),
(52, 'Belarus', 'BY', 4, 1, 0, 5, '2010-02-06 10:02:21', '2010-04-23 10:04:54'),
(53, 'Bosnia and Herzegovina', 'BA', 4, 1, 0, 5, '2010-02-06 10:02:06', '2010-04-23 10:04:41'),
(54, 'Cyprus', 'CY', 4, 1, 0, 5, '2010-02-06 10:02:27', '2010-04-23 10:04:23'),
(55, 'Croatia', 'CR', 4, 1, 0, 5, '2010-02-06 10:02:42', '2010-04-23 10:04:09'),
(56, 'Czech Republic', 'CZ', 4, 1, 0, 5, '2010-02-06 10:02:57', '2010-04-23 10:04:52'),
(57, 'Denmark', 'DK', 4, 1, 0, 3, '2010-02-06 10:02:14', '2010-04-23 10:04:48'),
(58, 'Estonia', 'EE', 4, 1, 0, 5, '2010-02-06 10:02:43', '2010-04-23 10:04:53'),
(59, 'Finland', 'FI', 4, 1, 0, 3, '2010-02-06 10:02:08', '2010-04-23 10:04:57'),
(60, 'France', 'FR', 4, 1, 0, 3, '2010-02-06 10:02:36', '2010-04-23 10:04:34'),
(61, 'Germany', 'GE', 4, 1, 0, 3, '2010-02-06 10:02:52', '2010-04-23 10:04:32'),
(62, 'Greece', 'GR', 4, 1, 0, 3, '2010-02-06 10:02:17', '2010-04-23 10:04:37'),
(63, 'Hungary', 'HU', 4, 1, 0, 3, '2010-02-06 10:02:39', '2010-04-23 10:04:57'),
(64, 'Iceland', 'IS', 4, 1, 0, 3, '2010-02-06 10:02:56', '2010-04-23 10:04:22'),
(65, 'Ireland', 'IE', 4, 1, 0, 3, '2010-02-06 10:02:19', '2010-04-23 10:04:00'),
(66, 'Italy', 'IT', 4, 1, 0, 3, '2010-02-06 10:02:37', '2010-04-23 10:04:23'),
(67, 'Latvia', 'LV', 4, 1, 0, 3, '2010-02-06 10:02:51', '2010-04-23 10:04:50'),
(68, 'Lithuania', 'LT', 4, 1, 0, 3, '2010-02-06 10:02:22', '2010-04-23 10:04:53'),
(69, 'Luxembourg', 'LU', 4, 1, 0, 3, '2010-02-06 10:02:35', '2010-04-23 10:04:29'),
(70, 'Liechtenstein', 'LI', 4, 1, 0, 3, '2010-02-06 10:02:56', '2010-04-23 10:04:00'),
(71, 'Malta', 'MT', 4, 1, 0, 3, '2010-02-06 10:02:11', '2010-04-23 10:04:13'),
(72, 'Moldova', 'MD', 4, 1, 0, 3, '2010-02-06 10:02:37', '2010-04-23 10:04:44'),
(73, 'Monaco', 'MC', 4, 1, 0, 3, '2010-02-06 10:02:01', '2010-04-23 10:04:13'),
(74, 'Montenegro', 'ME', 4, 1, 0, 3, '2010-02-06 10:02:17', '2010-04-23 10:04:45'),
(75, 'Netherlands', 'NL', 4, 1, 0, 3, '2010-02-06 10:02:38', '2010-04-23 10:04:02'),
(76, 'Norway', 'NO', 4, 1, 0, 3, '2010-02-06 10:02:51', '2010-04-23 10:04:30'),
(77, 'Poland', 'PL', 4, 1, 0, 3, '2010-02-06 10:02:09', '2010-04-23 10:04:05'),
(78, 'Portugal', 'PT', 4, 1, 0, 3, '2010-02-06 10:02:25', '2010-04-23 10:04:37'),
(79, 'Romania', 'RO', 4, 1, 0, 3, '2010-02-06 10:02:43', '2010-04-23 10:04:14'),
(80, 'Russia', 'RU', 4, 1, 0, 3, '2010-02-06 10:02:30', '2010-04-23 10:04:52'),
(82, 'Serbia', 'RS', 4, 1, 0, 3, '2010-02-06 10:02:00', '2010-04-23 10:04:20'),
(84, 'Slovenia', 'SI', 4, 1, 0, 3, '2010-02-06 10:02:29', '2010-04-23 10:04:42'),
(85, 'Spain', 'ES', 4, 1, 0, 3, '2010-02-06 10:02:43', '2010-04-23 10:04:15'),
(86, 'Sweden', 'SE', 4, 1, 0, 3, '2010-02-06 10:02:58', '2010-04-23 10:04:01'),
(87, 'Switzerland', 'CH', 4, 1, 0, 3, '2010-02-06 10:02:14', '2010-04-23 10:04:25'),
(88, 'Turkey', 'TR', 4, 1, 0, 3, '2010-02-06 10:02:38', '2010-04-23 10:04:01'),
(89, 'Ukraine', 'UA', 4, 1, 0, 3, '2010-02-06 10:02:01', '2010-04-23 10:04:36'),
(90, 'United Kingdom', 'GB', 4, 1, 0, 3, '2010-02-06 10:02:18', '2010-04-23 10:04:11'),
(91, 'Vatican City State', 'VA', 4, 1, 0, 5, '2010-02-06 10:02:46', '2010-04-23 11:04:06'),
(92, 'Antigua and Barbuda', 'AG', 2, 1, 0, 3, '2010-02-06 10:02:58', '2010-04-23 10:04:10'),
(93, 'Bahamas', 'BS', 2, 1, 0, 3, '2010-02-06 10:02:19', '2010-04-23 10:04:44'),
(95, 'Belize', 'BZ', 2, 1, 0, 3, '2010-02-06 10:02:33', '2010-04-23 10:04:22'),
(96, 'Canada', 'CA', 2, 1, 0, 3, '2010-02-06 10:02:55', '2010-04-23 10:04:18'),
(97, 'Costa Rica', 'CR', 2, 1, 0, 3, '2010-02-06 10:02:12', '2010-04-23 10:04:43'),
(98, 'Cuba', 'CU', 2, 1, 0, 3, '2010-02-06 10:02:53', '2010-04-23 10:04:51'),
(99, 'Dominica', 'DM', 2, 1, 0, 3, '2010-02-06 10:02:08', '2010-04-23 10:04:26'),
(100, 'Dominican- Republic', 'DO', 2, 1, 0, 5, '2010-02-06 10:02:31', '2010-04-23 10:04:18'),
(101, 'El Salvador', 'SV', 2, 1, 0, 5, '2010-02-06 10:02:00', '2010-04-23 10:04:42'),
(102, 'Greenland', 'GL', 2, 1, 0, 3, '2010-02-06 10:02:21', '2010-07-02 11:07:59'),
(103, 'Grenada', 'GD', 2, 1, 0, 5, '2010-02-06 10:02:34', '2010-04-23 10:04:28'),
(104, 'United States', 'US', 2, 1, 0, 3, '2010-02-06 10:02:48', '2010-06-24 15:06:39'),
(105, 'Trinidad and Tobago', 'TT', 2, 1, 0, 5, '2010-02-06 10:02:12', '2010-04-23 10:04:49'),
(106, 'Saint Vincent and the Grenadines', 'VC', 2, 1, 0, 5, '2010-02-06 10:02:29', '2010-04-23 11:04:50'),
(107, 'Panama', 'PA', 2, 1, 0, 5, '2010-02-06 10:02:49', '2010-04-23 11:04:49'),
(108, 'Mexico', 'MX', 2, 1, 0, 5, '2010-02-06 10:02:04', '2010-04-23 10:04:22'),
(109, 'Jamaica', 'JM', 2, 1, 0, 5, '2010-02-06 10:02:31', '2010-04-23 11:04:07'),
(110, 'Haiti', 'HT', 2, 1, 0, 5, '2010-02-06 10:02:02', '2010-04-23 11:04:38'),
(111, 'Honduras', 'HN', 2, 1, 0, 5, '2010-02-06 10:02:22', '2010-04-23 11:04:13'),
(112, 'Guatemala', 'GT', 2, 1, 0, 5, '2010-02-06 10:02:35', '2010-04-23 10:04:28'),
(113, 'Argentina', 'AR', 3, 1, 0, 5, '2010-02-06 10:02:42', '2010-04-23 10:04:09'),
(114, 'Bolivia', 'BO', 3, 1, 0, 5, '2010-02-06 10:02:49', '2010-04-23 11:04:44'),
(115, 'Brazil', 'BR', 3, 1, 0, 5, '2010-02-06 10:02:04', '2010-04-23 10:04:39'),
(116, 'Chile', 'CL', 3, 1, 0, 5, '2010-02-06 10:02:17', '2010-04-23 10:04:15'),
(117, 'Colombia', 'CO', 3, 1, 0, 5, '2010-02-06 10:02:32', '2010-04-23 10:04:45'),
(118, 'Ecuador', 'EC', 3, 1, 0, 5, '2010-02-06 10:02:47', '2010-04-23 10:04:58'),
(119, 'Guyana', 'GY', 3, 1, 0, 5, '2010-02-06 10:02:01', '2010-04-23 10:04:36'),
(120, 'Paraguay', 'PY', 3, 1, 0, 5, '2010-02-06 10:02:21', '2010-04-23 10:04:11'),
(121, 'Peru', 'PE', 3, 1, 0, 5, '2010-02-06 10:02:33', '2010-04-23 10:04:46'),
(122, 'Uruguay', 'UY', 3, 1, 0, 5, '2010-02-06 10:02:11', '2010-04-23 10:04:25'),
(123, 'Venezuela', 'VE', 3, 1, 0, 5, '2010-02-06 10:02:28', '2010-04-23 10:04:53'),
(124, 'Australia', 'AU', 6, 1, 0, 5, '2010-02-06 10:02:20', '2010-04-23 10:04:13'),
(125, 'Fiji', 'FJ', 6, 1, 0, 5, '2010-02-06 10:02:47', '2010-04-23 10:04:01'),
(126, 'New Zealand', 'NZ', 6, 1, 0, 5, '2010-02-06 10:02:57', '2010-04-23 10:04:24'),
(127, 'Solomon Islands', 'SB', 6, 1, 0, 5, '2010-02-06 10:02:10', '2010-04-23 10:04:07'),
(128, 'Algeria', 'DZ', 5, 1, 0, 5, '2010-02-06 10:02:48', '2010-04-23 10:04:35'),
(129, 'Chad', 'TD', 5, 1, 0, 5, '2010-02-06 10:02:28', '2010-04-23 10:04:01'),
(130, 'Congo', 'CG', 5, 1, 0, 5, '2010-02-06 10:02:48', '2010-04-23 10:04:43'),
(131, 'Egypt', 'EG', 5, 1, 0, 5, '2010-02-06 10:02:06', '2010-04-23 10:04:13'),
(132, 'Ethiopia', 'ET', 5, 1, 0, 5, '2010-02-06 10:02:33', '2010-04-23 10:04:52'),
(133, 'Gambia', 'GM', 5, 1, 0, 5, '2010-02-06 10:02:57', '2010-04-23 10:04:28'),
(134, 'Ghana', 'GH', 5, 1, 0, 5, '2010-02-06 10:02:11', '2010-04-23 10:04:50'),
(135, 'Kenya', 'KE', 5, 1, 0, 5, '2010-02-06 10:02:11', '2010-04-23 10:04:39'),
(136, 'Liberia', 'LR', 5, 1, 0, 5, '2010-02-06 10:02:43', '2010-04-23 10:04:14'),
(137, 'Libya', 'LY', 5, 1, 0, 5, '2010-02-06 11:02:35', '2010-04-23 10:04:56'),
(138, 'Nigeria', 'NG', 5, 1, 0, 5, '2010-02-06 11:02:30', '2010-04-23 10:04:58'),
(139, 'Senegal', 'SN', 5, 1, 0, 5, '2010-02-06 11:02:12', '2010-04-23 10:04:19'),
(140, 'South Africa', 'ZA', 5, 1, 0, 5, '2010-02-06 11:02:14', '2010-04-23 10:04:50'),
(141, 'Sudan', 'SD', 5, 1, 0, 5, '2010-02-06 11:02:39', '2010-04-23 10:04:18'),
(142, 'Tanzania', 'TZ', 5, 1, 0, 5, '2010-02-06 11:02:04', '2010-04-23 10:04:00'),
(143, 'Togo', 'TG', 5, 1, 0, 5, '2010-02-06 11:02:26', '2010-04-23 10:04:18'),
(144, 'Western Sahara', 'EH', 5, 1, 0, 5, '2010-02-06 11:02:42', '2010-04-23 10:04:57'),
(145, 'Uganda', 'UG', 5, 1, 0, 5, '2010-02-06 11:02:08', '2010-04-23 10:04:29'),
(146, 'Zimbabwe', 'ZW', 5, 1, 0, 5, '2010-02-06 11:02:26', '2010-04-23 10:04:07'),
(147, 'Morocco', 'MA', 5, 1, 5, 5, '2010-02-09 06:02:10', '2010-04-23 10:04:26'),
(148, 'Palestine', 'PS', 1, 1, 5, 5, '2010-02-09 07:02:41', '2010-04-23 10:04:50'),
(149, 'CAMEROON', 'CM', 5, 1, 3, 3, '2010-06-16 16:06:42', '2010-07-02 11:07:54'),
(150, 'HONG KONG', 'HK', 1, 1, 3, NULL, '2010-06-29 10:06:09', NULL),
(151, 'JERSEY', 'JE', 4, 1, 3, NULL, '2010-07-02 14:07:28', NULL),
(152, 'KIRIBATI', 'KI', 6, 1, 3, NULL, '2010-07-02 14:07:39', NULL),
(153, 'LESOTHO', 'LS', 5, 1, 3, NULL, '2010-07-02 14:07:20', NULL),
(154, 'MACAO', 'MO', 1, 1, 3, NULL, '2010-07-02 14:07:07', NULL),
(155, 'ANGOLA', 'AO', 5, 1, 3, NULL, '2010-07-02 14:07:08', NULL),
(156, 'MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF', 'MK', 4, 1, 3, NULL, '2010-07-02 14:07:25', NULL),
(157, 'MADAGASCAR', 'MG', 5, 1, 3, NULL, '2010-07-02 14:07:12', NULL),
(158, 'MALAWI', 'MW', 5, 1, 3, NULL, '2010-07-02 14:07:01', NULL),
(159, 'MALI', 'ML', 5, 1, 3, NULL, '2010-07-02 14:07:34', NULL),
(160, 'BENIN', 'BJ', 5, 1, 3, NULL, '2010-07-02 14:07:44', NULL),
(161, 'MARSHALL ISLANDS', 'MH', 6, 1, 3, NULL, '2010-07-02 14:07:16', NULL),
(162, 'BERMUDA', 'BM', 2, 1, 3, NULL, '2010-07-02 14:07:37', NULL),
(163, 'MARTINIQUE', 'MQ', 3, 1, 3, NULL, '2010-07-02 14:07:00', NULL),
(164, 'MAURITANIA', 'MR', 5, 1, 3, NULL, '2010-07-02 14:07:09', NULL),
(165, 'BOTSWANA', 'BW', 5, 1, 3, NULL, '2010-07-02 14:07:28', NULL),
(166, 'MAURITIUS', 'MU', 5, 1, 3, NULL, '2010-07-02 14:07:55', NULL),
(167, 'MAYOTTE', 'YT', 5, 1, 3, NULL, '2010-07-02 14:07:24', NULL),
(168, 'BRITISH INDIAN OCEAN TERRITORY', 'AO', 1, 1, 3, NULL, '2010-07-02 14:07:05', NULL),
(169, 'MICRONESIA, FEDERATED STATES OF', 'FM', 6, 1, 3, NULL, '2010-07-02 14:07:04', NULL),
(170, 'BURKINA FASO', 'BF', 5, 1, 3, NULL, '2010-07-02 14:07:24', NULL),
(171, 'BURUNDI', 'BI', 5, 1, 3, NULL, '2010-07-02 14:07:40', NULL),
(172, 'MONTSERRAT', 'MS', 3, 1, 3, NULL, '2010-07-02 14:07:50', NULL),
(173, 'CAPE VERDE', 'CV', 5, 1, 3, NULL, '2010-07-02 14:07:05', NULL),
(174, 'MOZAMBIQUE', 'MZ', 5, 1, 3, NULL, '2010-07-02 14:07:37', NULL),
(175, 'NAMIBIA', 'NA', 5, 1, 3, NULL, '2010-07-02 14:07:18', NULL),
(176, 'CAYMAN ISLANDS', 'KY', 2, 1, 3, NULL, '2010-07-02 14:07:54', NULL),
(177, 'NAURU', 'NR', 6, 1, 3, NULL, '2010-07-02 14:07:30', NULL),
(178, 'NETHERLANDS ANTILLES', 'AN', 2, 1, 3, NULL, '2010-07-02 14:07:40', NULL),
(179, 'CENTRAL AFRICAN REPUBLIC', 'CF', 5, 1, 3, NULL, '2010-07-02 14:07:22', NULL),
(180, 'ANTARCTICA', 'AQ', 7, 1, 3, NULL, '2010-07-02 14:07:12', NULL),
(181, 'NEW CALEDONIA', 'NC', 6, 1, 3, NULL, '2010-07-02 14:07:30', NULL),
(182, 'NICARAGUA', 'NI', 2, 1, 3, NULL, '2010-07-02 14:07:07', NULL),
(183, 'NIGER', 'NE', 5, 1, 3, NULL, '2010-07-02 14:07:53', NULL),
(184, 'NIUE', 'NU', 6, 1, 3, NULL, '2010-07-02 14:07:31', NULL),
(185, 'NORFOLK ISLAND', 'NF', 6, 1, 3, NULL, '2010-07-02 14:07:03', NULL),
(186, 'NORTHERN MARIANA ISLANDS', 'MP', 6, 1, 3, NULL, '2010-07-02 15:07:42', NULL),
(187, 'PALAU', 'PW', 6, 1, 3, NULL, '2010-07-02 15:07:26', NULL),
(188, 'PITCAIRN', 'PN', 2, 1, 3, NULL, '2010-07-02 15:07:57', NULL),
(189, 'PUERTO RICO', 'PR', 2, 1, 3, NULL, '2010-07-02 15:07:49', NULL),
(190, 'ANGUILLA', 'AI', 2, 1, 3, NULL, '2010-07-02 15:07:51', NULL),
(191, 'ALAND ISLANDS', 'AX', 6, 1, 3, 3, '2010-07-02 15:07:02', '2010-07-02 15:07:21'),
(192, 'ARUBA', 'AW', 3, 1, 3, NULL, '2010-07-02 15:07:13', NULL),
(193, 'CHRISTMAS ISLAND', 'CX', 1, 1, 3, NULL, '2010-07-02 15:07:57', NULL),
(194, 'COMOROS', 'KM', 5, 1, 3, NULL, '2010-07-02 15:07:28', NULL),
(195, 'REUNION', 'RE', 5, 1, 3, NULL, '2010-07-02 15:07:22', NULL),
(196, 'CONGO, THE DEMOCRATIC REPUBLIC OF THE', 'CD', 5, 1, 3, NULL, '2010-07-02 15:07:48', NULL),
(197, 'RWANDA', 'RW', 5, 1, 3, NULL, '2010-07-02 15:07:09', NULL),
(198, 'COOK ISLANDS', 'CK', 3, 1, 3, NULL, '2010-07-02 15:07:03', NULL),
(199, 'SAINT BARTHÉLEMY', 'BL', 2, 1, 3, NULL, '2010-07-02 15:07:35', NULL),
(200, 'SAINT HELENA', 'SH', 5, 1, 3, NULL, '2010-07-02 15:07:28', NULL),
(201, 'DJIBOUTI', 'DJ', 5, 1, 3, NULL, '2010-07-02 15:07:49', NULL),
(202, 'SAINT KITTS AND NEVIS', 'KN', 2, 1, 3, NULL, '2010-07-02 15:07:13', NULL),
(203, 'EQUATORIAL GUINEA', 'GQ', 6, 1, 3, NULL, '2010-07-02 15:07:35', NULL),
(204, 'COCOS (KEELING) ISLANDS', 'CC', 5, 1, 3, NULL, '2010-07-02 15:07:56', NULL),
(205, 'ERITREA', 'ER', 5, 1, 3, NULL, '2010-07-02 15:07:06', NULL),
(206, 'FALKLAND ISLANDS (MALVINAS)', 'FK', 7, 1, 3, NULL, '2010-07-02 15:07:53', NULL),
(207, 'FAROE ISLANDS', 'FO', 4, 1, 3, NULL, '2010-07-02 15:07:09', NULL),
(208, 'FRENCH GUIANA', 'GF', 3, 1, 3, NULL, '2010-07-02 15:07:46', NULL),
(209, 'FRENCH POLYNESIA', 'PF', 6, 1, 3, NULL, '2010-07-02 15:07:33', NULL),
(210, 'SAINT LUCIA', 'LC', 2, 1, 3, NULL, '2010-07-02 15:07:45', NULL),
(211, 'FRENCH SOUTHERN TERRITORIES', 'TF', 6, 1, 3, NULL, '2010-07-02 15:07:13', NULL),
(212, 'GABON', 'GA', 5, 1, 3, NULL, '2010-07-02 15:07:46', NULL),
(213, 'GIBRALTAR', 'GI', 4, 1, 3, NULL, '2010-07-02 15:07:54', NULL),
(214, 'SAINT MARTIN', 'MF', 4, 1, 3, NULL, '2010-07-02 15:07:42', NULL),
(215, 'SAINT PIERRE AND MIQUELON', 'SA', 2, 1, 3, NULL, '2010-07-02 15:07:13', NULL),
(216, 'SAMOA', 'WS', 6, 1, 3, NULL, '2010-07-02 15:07:55', NULL),
(217, 'SAN MARINO', 'SM', 4, 1, 3, NULL, '2010-07-02 15:07:36', NULL),
(218, 'SAO TOME AND PRINCIPE', 'ST', 5, 1, 3, NULL, '2010-07-02 15:07:13', NULL),
(219, 'SLOVAKIA', 'SK', 4, 1, 3, NULL, '2010-07-02 15:07:07', NULL),
(220, 'SEYCHELLES', 'SC', 5, 1, 3, NULL, '2010-07-02 15:07:21', NULL),
(221, 'SIERRA LEONE', 'SL', 5, 1, 3, NULL, '2010-07-02 15:07:31', NULL),
(222, 'SOMALIA', 'SO', 5, 1, 3, NULL, '2010-07-02 15:07:04', NULL),
(223, 'SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS', 'GS', 3, 1, 3, NULL, '2010-07-02 15:07:17', NULL),
(224, 'SWAZILAND', 'SZ', 5, 1, 3, NULL, '2010-07-02 15:07:04', NULL),
(225, 'SVALBARD AND JAN MAYEN', 'SJ', 4, 1, 3, NULL, '2010-07-02 15:07:51', NULL),
(226, 'SURINAME', 'SR', 3, 1, 3, NULL, '2010-07-02 15:07:18', NULL),
(227, 'GUADELOUPE', 'GP', 2, 1, 3, NULL, '2010-07-02 15:07:14', NULL),
(228, 'GUAM', 'GU', 2, 1, 3, NULL, '2010-07-02 15:07:41', NULL),
(229, 'GUERNSEY', 'GG', 4, 1, 3, NULL, '2010-07-02 15:07:55', NULL),
(230, 'GUINEA', 'GN', 5, 1, 3, NULL, '2010-07-02 15:07:19', NULL),
(231, 'GUINEA-BISSAU', 'GW', 5, 1, 3, NULL, '2010-07-02 15:07:10', NULL),
(232, 'TAJIKISTAN', 'TJ', 1, 1, 3, NULL, '2010-07-02 15:07:16', NULL),
(233, 'TIMOR-LESTE', 'TL', 1, 1, 3, NULL, '2010-07-02 16:07:45', NULL),
(234, 'TOKELAU', 'TK', 6, 1, 3, NULL, '2010-07-02 16:07:40', NULL),
(235, 'TONGA', 'TO', 6, 1, 3, NULL, '2010-07-02 16:07:49', NULL),
(236, 'TUNISIA', 'TN', 5, 1, 3, NULL, '2010-07-02 16:07:20', NULL),
(237, 'TURKS AND CAICOS ISLANDS', 'TC', 2, 1, 3, NULL, '2010-07-02 16:07:21', NULL),
(238, 'TUVALU', 'TV', 6, 1, 3, NULL, '2010-07-02 16:07:34', NULL),
(239, 'UNITED STATES MINOR OUTLYING ISLANDS', 'UM', 6, 1, 3, NULL, '2010-07-02 16:07:45', NULL),
(240, 'VANUATU', 'VU', 6, 1, 3, NULL, '2010-07-02 16:07:01', NULL),
(241, 'VIRGIN ISLANDS, BRITISH', 'VG', 2, 1, 3, NULL, '2010-07-02 16:07:53', NULL),
(242, 'VIRGIN ISLANDS, U.S.', 'VI', 2, 1, 3, NULL, '2010-07-02 16:07:17', NULL),
(243, 'WALLIS AND FUTUNA', 'WF', 6, 1, 3, NULL, '2010-07-02 16:07:46', NULL),
(244, 'ZAMBIA', 'ZM', 5, 1, 3, NULL, '2010-07-02 16:07:16', NULL);
-- --------------------------------------------------------
In this section i will try to create some functions for logged user.Here first one is create profile.It's badly need to create two table(country,create_profile).
.......................................................................................
1.CREATE TABLE `create_profile` (
`id` int(10) NOT NULL auto_increment,
`userid` int(11) NOT NULL,
`userName` varchar(255) NOT NULL,
`userfatherName` varchar(255) NOT NULL,
`userOccupation` varchar(255) NOT NULL,
`userNationality` varchar(255) NOT NULL,
`userReligion` varchar(255) NOT NULL,
`userAddress` varchar(255) NOT NULL,
`userDesignation` varchar(255) NOT NULL,
`country` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
2.CREATE TABLE `countrys` (
`COUNTRY_ID` int(11) NOT NULL auto_increment,
`COUNTRY` varchar(100) collate utf8_unicode_ci default NULL,
`ISO3166CODE` varchar(2) collate utf8_unicode_ci default NULL,
`CONTINENT_ID` int(10) default NULL,
`ISACTIVE` tinyint(1) NOT NULL default '1',
`USER_ID_INSERTED` int(10) default NULL,
`USER_ID_UPDATED` int(10) default NULL,
`DATE_INSERTED` datetime default NULL,
`DATE_UPDATED` datetime default NULL,
PRIMARY KEY (`COUNTRY_ID`),
KEY `FK_COUNTRY_CONTINENT` (`CONTINENT_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=245 ;
--
-- Dumping data for table `countrys`
--
INSERT INTO `countrys` (`COUNTRY_ID`, `COUNTRY`, `ISO3166CODE`, `CONTINENT_ID`, `ISACTIVE`, `USER_ID_INSERTED`, `USER_ID_UPDATED`, `DATE_INSERTED`, `DATE_UPDATED`) VALUES
(1, 'Bangladesh', 'BD', 1, 1, 0, 3, '2010-02-06 08:02:57', '2010-06-16 15:06:26'),
(2, 'India', 'IN', 1, 1, 0, 5, '2010-02-06 09:02:09', '2010-02-08 12:02:11'),
(4, 'Afghanistan', 'AF', 1, 1, 0, 91, '2010-02-06 09:02:20', '2010-04-23 10:04:43'),
(5, 'Armenia', 'AM', 1, 1, 0, 91, '2010-02-06 09:02:13', '2010-04-23 10:04:02'),
(6, 'Azerbaijan', 'AZ', 1, 1, 0, 91, '2010-02-06 09:02:04', '2010-04-23 10:04:28'),
(7, 'Brunei', 'BN', 1, 1, 0, 91, '2010-02-06 09:02:22', '2010-04-23 10:04:12'),
(8, 'Bhutan', 'BT', 1, 1, 0, 91, '2010-02-06 09:02:42', '2010-04-23 10:04:25'),
(9, 'Cambodia', 'KH', 1, 1, 0, 91, '2010-02-06 09:02:14', '2010-04-23 10:04:43'),
(10, 'Indonesia', 'ID', 1, 1, 0, 91, '2010-02-06 09:02:31', '2010-04-23 10:04:59'),
(12, 'Malaysia', 'MY', 1, 1, 0, 91, '2010-02-06 09:02:05', '2010-04-23 10:04:54'),
(13, 'Maldives', 'MV', 1, 1, 0, 91, '2010-02-06 09:02:29', '2010-04-23 10:04:07'),
(14, 'Myanmar', 'MM', 1, 1, 0, 91, '2010-02-06 09:02:50', '2010-04-23 10:04:20'),
(15, 'Nepal', 'NP', 1, 1, 0, 91, '2010-02-06 09:02:06', '2010-04-23 10:04:33'),
(16, 'Pakistan', 'PK', 1, 1, 0, 91, '2010-02-06 09:02:19', '2010-04-23 10:04:47'),
(17, 'Papua New Guinea', 'PG', 1, 1, 0, 91, '2010-02-06 09:02:35', '2010-04-23 10:04:02'),
(18, 'Philippines', 'PH', 1, 1, 0, 91, '2010-02-06 09:02:48', '2010-04-23 10:04:15'),
(19, 'Singapore', 'SG', 1, 1, 0, 91, '2010-02-06 09:02:01', '2010-04-23 10:04:37'),
(20, 'Sri Lanka', 'LK', 1, 1, 0, 91, '2010-02-06 09:02:18', '2010-04-23 10:04:54'),
(21, 'Thailand', 'TH', 1, 1, 0, 91, '2010-02-06 09:02:30', '2010-04-23 10:04:08'),
(22, 'Vietnam', 'VN', 1, 1, 0, 91, '2010-02-06 09:02:46', '2010-04-23 10:04:27'),
(23, 'Kazakhstan', 'KZ', 1, 1, 0, 91, '2010-02-06 09:02:15', '2010-04-23 10:04:46'),
(24, 'Kyrgyzstan', 'KG', 1, 1, 0, 91, '2010-02-06 09:02:27', '2010-04-23 10:04:14'),
(25, 'Turkmenistan', 'TM', 1, 1, 0, 91, '2010-02-06 09:02:21', '2010-04-23 10:04:37'),
(26, 'Uzbekistan', 'UZ', 1, 1, 0, 91, '2010-02-06 09:02:34', '2010-04-23 10:04:53'),
(27, 'China', 'CN', 1, 1, 0, 91, '2010-02-06 09:02:46', '2010-04-23 10:04:17'),
(28, 'Japan', 'JP', 1, 1, 0, 91, '2010-02-06 09:02:22', '2010-04-23 10:04:36'),
(29, 'North Korea', 'KP', 1, 1, 0, 91, '2010-02-06 09:02:37', '2010-04-23 10:04:07'),
(30, 'South Korea', 'KR', 1, 1, 0, 91, '2010-02-06 09:02:52', '2010-04-23 10:04:57'),
(31, 'Mongolia', 'MN', 1, 1, 0, 91, '2010-02-06 09:02:04', '2010-04-23 10:04:13'),
(32, 'Taiwan', 'TW', 1, 1, 0, 91, '2010-02-06 09:02:17', '2010-04-23 10:04:40'),
(33, 'Bahrain', 'BH', 1, 1, 0, 91, '2010-02-06 09:02:02', '2010-04-23 10:04:58'),
(34, 'Georgia', 'GE', 1, 1, 0, 91, '2010-02-06 09:02:14', '2010-04-23 10:04:15'),
(35, 'Iran', 'IR', 1, 1, 0, 91, '2010-02-06 09:02:24', '2010-04-23 10:04:34'),
(36, 'Iraq', 'IQ', 1, 1, 0, 91, '2010-02-06 09:02:41', '2010-04-23 10:04:47'),
(37, 'Israel', 'IL', 1, 1, 0, 91, '2010-02-06 09:02:52', '2010-04-23 10:04:02'),
(38, 'Jordan', 'JO', 1, 1, 0, 91, '2010-02-06 09:02:03', '2010-04-23 10:04:18'),
(39, 'Kuwait', 'KW', 1, 1, 0, 91, '2010-02-06 09:02:16', '2010-04-23 10:04:36'),
(40, 'Lebanon', 'LB', 1, 1, 0, 91, '2010-02-06 09:02:27', '2010-04-23 10:04:53'),
(41, 'Oman', 'OM', 1, 1, 0, 91, '2010-02-06 09:02:37', '2010-04-23 10:04:16'),
(42, 'Qatar', 'QA', 1, 1, 0, 91, '2010-02-06 09:02:52', '2010-04-23 10:04:35'),
(43, 'Saudi Arabia', 'SA', 1, 1, 0, 91, '2010-02-06 09:02:06', '2010-04-23 10:04:08'),
(44, 'Syria', 'SY', 1, 1, 0, 91, '2010-02-06 09:02:20', '2010-04-23 10:04:55'),
(45, 'U.A.E.', 'AE', 1, 1, 0, 91, '2010-02-06 09:02:36', '2010-04-23 10:04:27'),
(46, 'Yemen', 'YE', 1, 1, 0, 91, '2010-02-06 09:02:08', '2010-04-23 10:04:43'),
(47, 'Albania', 'AL', 4, 1, 0, 91, '2010-02-06 09:02:45', '2010-04-23 10:04:02'),
(48, 'Andorra', 'AD', 4, 1, 0, 91, '2010-02-06 10:02:22', '2010-04-23 10:04:21'),
(49, 'Austria', 'AT', 4, 1, 0, 91, '2010-02-06 10:02:05', '2010-04-23 10:04:35'),
(50, 'Belgium', 'BE', 4, 1, 0, 91, '2010-02-06 10:02:33', '2010-04-23 10:04:53'),
(51, 'Bulgaria', 'BG', 4, 1, 0, 5, '2010-02-06 10:02:55', '2010-04-23 10:04:35'),
(52, 'Belarus', 'BY', 4, 1, 0, 5, '2010-02-06 10:02:21', '2010-04-23 10:04:54'),
(53, 'Bosnia and Herzegovina', 'BA', 4, 1, 0, 5, '2010-02-06 10:02:06', '2010-04-23 10:04:41'),
(54, 'Cyprus', 'CY', 4, 1, 0, 5, '2010-02-06 10:02:27', '2010-04-23 10:04:23'),
(55, 'Croatia', 'CR', 4, 1, 0, 5, '2010-02-06 10:02:42', '2010-04-23 10:04:09'),
(56, 'Czech Republic', 'CZ', 4, 1, 0, 5, '2010-02-06 10:02:57', '2010-04-23 10:04:52'),
(57, 'Denmark', 'DK', 4, 1, 0, 3, '2010-02-06 10:02:14', '2010-04-23 10:04:48'),
(58, 'Estonia', 'EE', 4, 1, 0, 5, '2010-02-06 10:02:43', '2010-04-23 10:04:53'),
(59, 'Finland', 'FI', 4, 1, 0, 3, '2010-02-06 10:02:08', '2010-04-23 10:04:57'),
(60, 'France', 'FR', 4, 1, 0, 3, '2010-02-06 10:02:36', '2010-04-23 10:04:34'),
(61, 'Germany', 'GE', 4, 1, 0, 3, '2010-02-06 10:02:52', '2010-04-23 10:04:32'),
(62, 'Greece', 'GR', 4, 1, 0, 3, '2010-02-06 10:02:17', '2010-04-23 10:04:37'),
(63, 'Hungary', 'HU', 4, 1, 0, 3, '2010-02-06 10:02:39', '2010-04-23 10:04:57'),
(64, 'Iceland', 'IS', 4, 1, 0, 3, '2010-02-06 10:02:56', '2010-04-23 10:04:22'),
(65, 'Ireland', 'IE', 4, 1, 0, 3, '2010-02-06 10:02:19', '2010-04-23 10:04:00'),
(66, 'Italy', 'IT', 4, 1, 0, 3, '2010-02-06 10:02:37', '2010-04-23 10:04:23'),
(67, 'Latvia', 'LV', 4, 1, 0, 3, '2010-02-06 10:02:51', '2010-04-23 10:04:50'),
(68, 'Lithuania', 'LT', 4, 1, 0, 3, '2010-02-06 10:02:22', '2010-04-23 10:04:53'),
(69, 'Luxembourg', 'LU', 4, 1, 0, 3, '2010-02-06 10:02:35', '2010-04-23 10:04:29'),
(70, 'Liechtenstein', 'LI', 4, 1, 0, 3, '2010-02-06 10:02:56', '2010-04-23 10:04:00'),
(71, 'Malta', 'MT', 4, 1, 0, 3, '2010-02-06 10:02:11', '2010-04-23 10:04:13'),
(72, 'Moldova', 'MD', 4, 1, 0, 3, '2010-02-06 10:02:37', '2010-04-23 10:04:44'),
(73, 'Monaco', 'MC', 4, 1, 0, 3, '2010-02-06 10:02:01', '2010-04-23 10:04:13'),
(74, 'Montenegro', 'ME', 4, 1, 0, 3, '2010-02-06 10:02:17', '2010-04-23 10:04:45'),
(75, 'Netherlands', 'NL', 4, 1, 0, 3, '2010-02-06 10:02:38', '2010-04-23 10:04:02'),
(76, 'Norway', 'NO', 4, 1, 0, 3, '2010-02-06 10:02:51', '2010-04-23 10:04:30'),
(77, 'Poland', 'PL', 4, 1, 0, 3, '2010-02-06 10:02:09', '2010-04-23 10:04:05'),
(78, 'Portugal', 'PT', 4, 1, 0, 3, '2010-02-06 10:02:25', '2010-04-23 10:04:37'),
(79, 'Romania', 'RO', 4, 1, 0, 3, '2010-02-06 10:02:43', '2010-04-23 10:04:14'),
(80, 'Russia', 'RU', 4, 1, 0, 3, '2010-02-06 10:02:30', '2010-04-23 10:04:52'),
(82, 'Serbia', 'RS', 4, 1, 0, 3, '2010-02-06 10:02:00', '2010-04-23 10:04:20'),
(84, 'Slovenia', 'SI', 4, 1, 0, 3, '2010-02-06 10:02:29', '2010-04-23 10:04:42'),
(85, 'Spain', 'ES', 4, 1, 0, 3, '2010-02-06 10:02:43', '2010-04-23 10:04:15'),
(86, 'Sweden', 'SE', 4, 1, 0, 3, '2010-02-06 10:02:58', '2010-04-23 10:04:01'),
(87, 'Switzerland', 'CH', 4, 1, 0, 3, '2010-02-06 10:02:14', '2010-04-23 10:04:25'),
(88, 'Turkey', 'TR', 4, 1, 0, 3, '2010-02-06 10:02:38', '2010-04-23 10:04:01'),
(89, 'Ukraine', 'UA', 4, 1, 0, 3, '2010-02-06 10:02:01', '2010-04-23 10:04:36'),
(90, 'United Kingdom', 'GB', 4, 1, 0, 3, '2010-02-06 10:02:18', '2010-04-23 10:04:11'),
(91, 'Vatican City State', 'VA', 4, 1, 0, 5, '2010-02-06 10:02:46', '2010-04-23 11:04:06'),
(92, 'Antigua and Barbuda', 'AG', 2, 1, 0, 3, '2010-02-06 10:02:58', '2010-04-23 10:04:10'),
(93, 'Bahamas', 'BS', 2, 1, 0, 3, '2010-02-06 10:02:19', '2010-04-23 10:04:44'),
(95, 'Belize', 'BZ', 2, 1, 0, 3, '2010-02-06 10:02:33', '2010-04-23 10:04:22'),
(96, 'Canada', 'CA', 2, 1, 0, 3, '2010-02-06 10:02:55', '2010-04-23 10:04:18'),
(97, 'Costa Rica', 'CR', 2, 1, 0, 3, '2010-02-06 10:02:12', '2010-04-23 10:04:43'),
(98, 'Cuba', 'CU', 2, 1, 0, 3, '2010-02-06 10:02:53', '2010-04-23 10:04:51'),
(99, 'Dominica', 'DM', 2, 1, 0, 3, '2010-02-06 10:02:08', '2010-04-23 10:04:26'),
(100, 'Dominican- Republic', 'DO', 2, 1, 0, 5, '2010-02-06 10:02:31', '2010-04-23 10:04:18'),
(101, 'El Salvador', 'SV', 2, 1, 0, 5, '2010-02-06 10:02:00', '2010-04-23 10:04:42'),
(102, 'Greenland', 'GL', 2, 1, 0, 3, '2010-02-06 10:02:21', '2010-07-02 11:07:59'),
(103, 'Grenada', 'GD', 2, 1, 0, 5, '2010-02-06 10:02:34', '2010-04-23 10:04:28'),
(104, 'United States', 'US', 2, 1, 0, 3, '2010-02-06 10:02:48', '2010-06-24 15:06:39'),
(105, 'Trinidad and Tobago', 'TT', 2, 1, 0, 5, '2010-02-06 10:02:12', '2010-04-23 10:04:49'),
(106, 'Saint Vincent and the Grenadines', 'VC', 2, 1, 0, 5, '2010-02-06 10:02:29', '2010-04-23 11:04:50'),
(107, 'Panama', 'PA', 2, 1, 0, 5, '2010-02-06 10:02:49', '2010-04-23 11:04:49'),
(108, 'Mexico', 'MX', 2, 1, 0, 5, '2010-02-06 10:02:04', '2010-04-23 10:04:22'),
(109, 'Jamaica', 'JM', 2, 1, 0, 5, '2010-02-06 10:02:31', '2010-04-23 11:04:07'),
(110, 'Haiti', 'HT', 2, 1, 0, 5, '2010-02-06 10:02:02', '2010-04-23 11:04:38'),
(111, 'Honduras', 'HN', 2, 1, 0, 5, '2010-02-06 10:02:22', '2010-04-23 11:04:13'),
(112, 'Guatemala', 'GT', 2, 1, 0, 5, '2010-02-06 10:02:35', '2010-04-23 10:04:28'),
(113, 'Argentina', 'AR', 3, 1, 0, 5, '2010-02-06 10:02:42', '2010-04-23 10:04:09'),
(114, 'Bolivia', 'BO', 3, 1, 0, 5, '2010-02-06 10:02:49', '2010-04-23 11:04:44'),
(115, 'Brazil', 'BR', 3, 1, 0, 5, '2010-02-06 10:02:04', '2010-04-23 10:04:39'),
(116, 'Chile', 'CL', 3, 1, 0, 5, '2010-02-06 10:02:17', '2010-04-23 10:04:15'),
(117, 'Colombia', 'CO', 3, 1, 0, 5, '2010-02-06 10:02:32', '2010-04-23 10:04:45'),
(118, 'Ecuador', 'EC', 3, 1, 0, 5, '2010-02-06 10:02:47', '2010-04-23 10:04:58'),
(119, 'Guyana', 'GY', 3, 1, 0, 5, '2010-02-06 10:02:01', '2010-04-23 10:04:36'),
(120, 'Paraguay', 'PY', 3, 1, 0, 5, '2010-02-06 10:02:21', '2010-04-23 10:04:11'),
(121, 'Peru', 'PE', 3, 1, 0, 5, '2010-02-06 10:02:33', '2010-04-23 10:04:46'),
(122, 'Uruguay', 'UY', 3, 1, 0, 5, '2010-02-06 10:02:11', '2010-04-23 10:04:25'),
(123, 'Venezuela', 'VE', 3, 1, 0, 5, '2010-02-06 10:02:28', '2010-04-23 10:04:53'),
(124, 'Australia', 'AU', 6, 1, 0, 5, '2010-02-06 10:02:20', '2010-04-23 10:04:13'),
(125, 'Fiji', 'FJ', 6, 1, 0, 5, '2010-02-06 10:02:47', '2010-04-23 10:04:01'),
(126, 'New Zealand', 'NZ', 6, 1, 0, 5, '2010-02-06 10:02:57', '2010-04-23 10:04:24'),
(127, 'Solomon Islands', 'SB', 6, 1, 0, 5, '2010-02-06 10:02:10', '2010-04-23 10:04:07'),
(128, 'Algeria', 'DZ', 5, 1, 0, 5, '2010-02-06 10:02:48', '2010-04-23 10:04:35'),
(129, 'Chad', 'TD', 5, 1, 0, 5, '2010-02-06 10:02:28', '2010-04-23 10:04:01'),
(130, 'Congo', 'CG', 5, 1, 0, 5, '2010-02-06 10:02:48', '2010-04-23 10:04:43'),
(131, 'Egypt', 'EG', 5, 1, 0, 5, '2010-02-06 10:02:06', '2010-04-23 10:04:13'),
(132, 'Ethiopia', 'ET', 5, 1, 0, 5, '2010-02-06 10:02:33', '2010-04-23 10:04:52'),
(133, 'Gambia', 'GM', 5, 1, 0, 5, '2010-02-06 10:02:57', '2010-04-23 10:04:28'),
(134, 'Ghana', 'GH', 5, 1, 0, 5, '2010-02-06 10:02:11', '2010-04-23 10:04:50'),
(135, 'Kenya', 'KE', 5, 1, 0, 5, '2010-02-06 10:02:11', '2010-04-23 10:04:39'),
(136, 'Liberia', 'LR', 5, 1, 0, 5, '2010-02-06 10:02:43', '2010-04-23 10:04:14'),
(137, 'Libya', 'LY', 5, 1, 0, 5, '2010-02-06 11:02:35', '2010-04-23 10:04:56'),
(138, 'Nigeria', 'NG', 5, 1, 0, 5, '2010-02-06 11:02:30', '2010-04-23 10:04:58'),
(139, 'Senegal', 'SN', 5, 1, 0, 5, '2010-02-06 11:02:12', '2010-04-23 10:04:19'),
(140, 'South Africa', 'ZA', 5, 1, 0, 5, '2010-02-06 11:02:14', '2010-04-23 10:04:50'),
(141, 'Sudan', 'SD', 5, 1, 0, 5, '2010-02-06 11:02:39', '2010-04-23 10:04:18'),
(142, 'Tanzania', 'TZ', 5, 1, 0, 5, '2010-02-06 11:02:04', '2010-04-23 10:04:00'),
(143, 'Togo', 'TG', 5, 1, 0, 5, '2010-02-06 11:02:26', '2010-04-23 10:04:18'),
(144, 'Western Sahara', 'EH', 5, 1, 0, 5, '2010-02-06 11:02:42', '2010-04-23 10:04:57'),
(145, 'Uganda', 'UG', 5, 1, 0, 5, '2010-02-06 11:02:08', '2010-04-23 10:04:29'),
(146, 'Zimbabwe', 'ZW', 5, 1, 0, 5, '2010-02-06 11:02:26', '2010-04-23 10:04:07'),
(147, 'Morocco', 'MA', 5, 1, 5, 5, '2010-02-09 06:02:10', '2010-04-23 10:04:26'),
(148, 'Palestine', 'PS', 1, 1, 5, 5, '2010-02-09 07:02:41', '2010-04-23 10:04:50'),
(149, 'CAMEROON', 'CM', 5, 1, 3, 3, '2010-06-16 16:06:42', '2010-07-02 11:07:54'),
(150, 'HONG KONG', 'HK', 1, 1, 3, NULL, '2010-06-29 10:06:09', NULL),
(151, 'JERSEY', 'JE', 4, 1, 3, NULL, '2010-07-02 14:07:28', NULL),
(152, 'KIRIBATI', 'KI', 6, 1, 3, NULL, '2010-07-02 14:07:39', NULL),
(153, 'LESOTHO', 'LS', 5, 1, 3, NULL, '2010-07-02 14:07:20', NULL),
(154, 'MACAO', 'MO', 1, 1, 3, NULL, '2010-07-02 14:07:07', NULL),
(155, 'ANGOLA', 'AO', 5, 1, 3, NULL, '2010-07-02 14:07:08', NULL),
(156, 'MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF', 'MK', 4, 1, 3, NULL, '2010-07-02 14:07:25', NULL),
(157, 'MADAGASCAR', 'MG', 5, 1, 3, NULL, '2010-07-02 14:07:12', NULL),
(158, 'MALAWI', 'MW', 5, 1, 3, NULL, '2010-07-02 14:07:01', NULL),
(159, 'MALI', 'ML', 5, 1, 3, NULL, '2010-07-02 14:07:34', NULL),
(160, 'BENIN', 'BJ', 5, 1, 3, NULL, '2010-07-02 14:07:44', NULL),
(161, 'MARSHALL ISLANDS', 'MH', 6, 1, 3, NULL, '2010-07-02 14:07:16', NULL),
(162, 'BERMUDA', 'BM', 2, 1, 3, NULL, '2010-07-02 14:07:37', NULL),
(163, 'MARTINIQUE', 'MQ', 3, 1, 3, NULL, '2010-07-02 14:07:00', NULL),
(164, 'MAURITANIA', 'MR', 5, 1, 3, NULL, '2010-07-02 14:07:09', NULL),
(165, 'BOTSWANA', 'BW', 5, 1, 3, NULL, '2010-07-02 14:07:28', NULL),
(166, 'MAURITIUS', 'MU', 5, 1, 3, NULL, '2010-07-02 14:07:55', NULL),
(167, 'MAYOTTE', 'YT', 5, 1, 3, NULL, '2010-07-02 14:07:24', NULL),
(168, 'BRITISH INDIAN OCEAN TERRITORY', 'AO', 1, 1, 3, NULL, '2010-07-02 14:07:05', NULL),
(169, 'MICRONESIA, FEDERATED STATES OF', 'FM', 6, 1, 3, NULL, '2010-07-02 14:07:04', NULL),
(170, 'BURKINA FASO', 'BF', 5, 1, 3, NULL, '2010-07-02 14:07:24', NULL),
(171, 'BURUNDI', 'BI', 5, 1, 3, NULL, '2010-07-02 14:07:40', NULL),
(172, 'MONTSERRAT', 'MS', 3, 1, 3, NULL, '2010-07-02 14:07:50', NULL),
(173, 'CAPE VERDE', 'CV', 5, 1, 3, NULL, '2010-07-02 14:07:05', NULL),
(174, 'MOZAMBIQUE', 'MZ', 5, 1, 3, NULL, '2010-07-02 14:07:37', NULL),
(175, 'NAMIBIA', 'NA', 5, 1, 3, NULL, '2010-07-02 14:07:18', NULL),
(176, 'CAYMAN ISLANDS', 'KY', 2, 1, 3, NULL, '2010-07-02 14:07:54', NULL),
(177, 'NAURU', 'NR', 6, 1, 3, NULL, '2010-07-02 14:07:30', NULL),
(178, 'NETHERLANDS ANTILLES', 'AN', 2, 1, 3, NULL, '2010-07-02 14:07:40', NULL),
(179, 'CENTRAL AFRICAN REPUBLIC', 'CF', 5, 1, 3, NULL, '2010-07-02 14:07:22', NULL),
(180, 'ANTARCTICA', 'AQ', 7, 1, 3, NULL, '2010-07-02 14:07:12', NULL),
(181, 'NEW CALEDONIA', 'NC', 6, 1, 3, NULL, '2010-07-02 14:07:30', NULL),
(182, 'NICARAGUA', 'NI', 2, 1, 3, NULL, '2010-07-02 14:07:07', NULL),
(183, 'NIGER', 'NE', 5, 1, 3, NULL, '2010-07-02 14:07:53', NULL),
(184, 'NIUE', 'NU', 6, 1, 3, NULL, '2010-07-02 14:07:31', NULL),
(185, 'NORFOLK ISLAND', 'NF', 6, 1, 3, NULL, '2010-07-02 14:07:03', NULL),
(186, 'NORTHERN MARIANA ISLANDS', 'MP', 6, 1, 3, NULL, '2010-07-02 15:07:42', NULL),
(187, 'PALAU', 'PW', 6, 1, 3, NULL, '2010-07-02 15:07:26', NULL),
(188, 'PITCAIRN', 'PN', 2, 1, 3, NULL, '2010-07-02 15:07:57', NULL),
(189, 'PUERTO RICO', 'PR', 2, 1, 3, NULL, '2010-07-02 15:07:49', NULL),
(190, 'ANGUILLA', 'AI', 2, 1, 3, NULL, '2010-07-02 15:07:51', NULL),
(191, 'ALAND ISLANDS', 'AX', 6, 1, 3, 3, '2010-07-02 15:07:02', '2010-07-02 15:07:21'),
(192, 'ARUBA', 'AW', 3, 1, 3, NULL, '2010-07-02 15:07:13', NULL),
(193, 'CHRISTMAS ISLAND', 'CX', 1, 1, 3, NULL, '2010-07-02 15:07:57', NULL),
(194, 'COMOROS', 'KM', 5, 1, 3, NULL, '2010-07-02 15:07:28', NULL),
(195, 'REUNION', 'RE', 5, 1, 3, NULL, '2010-07-02 15:07:22', NULL),
(196, 'CONGO, THE DEMOCRATIC REPUBLIC OF THE', 'CD', 5, 1, 3, NULL, '2010-07-02 15:07:48', NULL),
(197, 'RWANDA', 'RW', 5, 1, 3, NULL, '2010-07-02 15:07:09', NULL),
(198, 'COOK ISLANDS', 'CK', 3, 1, 3, NULL, '2010-07-02 15:07:03', NULL),
(199, 'SAINT BARTHÉLEMY', 'BL', 2, 1, 3, NULL, '2010-07-02 15:07:35', NULL),
(200, 'SAINT HELENA', 'SH', 5, 1, 3, NULL, '2010-07-02 15:07:28', NULL),
(201, 'DJIBOUTI', 'DJ', 5, 1, 3, NULL, '2010-07-02 15:07:49', NULL),
(202, 'SAINT KITTS AND NEVIS', 'KN', 2, 1, 3, NULL, '2010-07-02 15:07:13', NULL),
(203, 'EQUATORIAL GUINEA', 'GQ', 6, 1, 3, NULL, '2010-07-02 15:07:35', NULL),
(204, 'COCOS (KEELING) ISLANDS', 'CC', 5, 1, 3, NULL, '2010-07-02 15:07:56', NULL),
(205, 'ERITREA', 'ER', 5, 1, 3, NULL, '2010-07-02 15:07:06', NULL),
(206, 'FALKLAND ISLANDS (MALVINAS)', 'FK', 7, 1, 3, NULL, '2010-07-02 15:07:53', NULL),
(207, 'FAROE ISLANDS', 'FO', 4, 1, 3, NULL, '2010-07-02 15:07:09', NULL),
(208, 'FRENCH GUIANA', 'GF', 3, 1, 3, NULL, '2010-07-02 15:07:46', NULL),
(209, 'FRENCH POLYNESIA', 'PF', 6, 1, 3, NULL, '2010-07-02 15:07:33', NULL),
(210, 'SAINT LUCIA', 'LC', 2, 1, 3, NULL, '2010-07-02 15:07:45', NULL),
(211, 'FRENCH SOUTHERN TERRITORIES', 'TF', 6, 1, 3, NULL, '2010-07-02 15:07:13', NULL),
(212, 'GABON', 'GA', 5, 1, 3, NULL, '2010-07-02 15:07:46', NULL),
(213, 'GIBRALTAR', 'GI', 4, 1, 3, NULL, '2010-07-02 15:07:54', NULL),
(214, 'SAINT MARTIN', 'MF', 4, 1, 3, NULL, '2010-07-02 15:07:42', NULL),
(215, 'SAINT PIERRE AND MIQUELON', 'SA', 2, 1, 3, NULL, '2010-07-02 15:07:13', NULL),
(216, 'SAMOA', 'WS', 6, 1, 3, NULL, '2010-07-02 15:07:55', NULL),
(217, 'SAN MARINO', 'SM', 4, 1, 3, NULL, '2010-07-02 15:07:36', NULL),
(218, 'SAO TOME AND PRINCIPE', 'ST', 5, 1, 3, NULL, '2010-07-02 15:07:13', NULL),
(219, 'SLOVAKIA', 'SK', 4, 1, 3, NULL, '2010-07-02 15:07:07', NULL),
(220, 'SEYCHELLES', 'SC', 5, 1, 3, NULL, '2010-07-02 15:07:21', NULL),
(221, 'SIERRA LEONE', 'SL', 5, 1, 3, NULL, '2010-07-02 15:07:31', NULL),
(222, 'SOMALIA', 'SO', 5, 1, 3, NULL, '2010-07-02 15:07:04', NULL),
(223, 'SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS', 'GS', 3, 1, 3, NULL, '2010-07-02 15:07:17', NULL),
(224, 'SWAZILAND', 'SZ', 5, 1, 3, NULL, '2010-07-02 15:07:04', NULL),
(225, 'SVALBARD AND JAN MAYEN', 'SJ', 4, 1, 3, NULL, '2010-07-02 15:07:51', NULL),
(226, 'SURINAME', 'SR', 3, 1, 3, NULL, '2010-07-02 15:07:18', NULL),
(227, 'GUADELOUPE', 'GP', 2, 1, 3, NULL, '2010-07-02 15:07:14', NULL),
(228, 'GUAM', 'GU', 2, 1, 3, NULL, '2010-07-02 15:07:41', NULL),
(229, 'GUERNSEY', 'GG', 4, 1, 3, NULL, '2010-07-02 15:07:55', NULL),
(230, 'GUINEA', 'GN', 5, 1, 3, NULL, '2010-07-02 15:07:19', NULL),
(231, 'GUINEA-BISSAU', 'GW', 5, 1, 3, NULL, '2010-07-02 15:07:10', NULL),
(232, 'TAJIKISTAN', 'TJ', 1, 1, 3, NULL, '2010-07-02 15:07:16', NULL),
(233, 'TIMOR-LESTE', 'TL', 1, 1, 3, NULL, '2010-07-02 16:07:45', NULL),
(234, 'TOKELAU', 'TK', 6, 1, 3, NULL, '2010-07-02 16:07:40', NULL),
(235, 'TONGA', 'TO', 6, 1, 3, NULL, '2010-07-02 16:07:49', NULL),
(236, 'TUNISIA', 'TN', 5, 1, 3, NULL, '2010-07-02 16:07:20', NULL),
(237, 'TURKS AND CAICOS ISLANDS', 'TC', 2, 1, 3, NULL, '2010-07-02 16:07:21', NULL),
(238, 'TUVALU', 'TV', 6, 1, 3, NULL, '2010-07-02 16:07:34', NULL),
(239, 'UNITED STATES MINOR OUTLYING ISLANDS', 'UM', 6, 1, 3, NULL, '2010-07-02 16:07:45', NULL),
(240, 'VANUATU', 'VU', 6, 1, 3, NULL, '2010-07-02 16:07:01', NULL),
(241, 'VIRGIN ISLANDS, BRITISH', 'VG', 2, 1, 3, NULL, '2010-07-02 16:07:53', NULL),
(242, 'VIRGIN ISLANDS, U.S.', 'VI', 2, 1, 3, NULL, '2010-07-02 16:07:17', NULL),
(243, 'WALLIS AND FUTUNA', 'WF', 6, 1, 3, NULL, '2010-07-02 16:07:46', NULL),
(244, 'ZAMBIA', 'ZM', 5, 1, 3, NULL, '2010-07-02 16:07:16', NULL);
-- --------------------------------------------------------
0 Response to "Simple Project(Part-3a)"
Post a Comment