-- phpMyAdmin SQL Dump -- version 3.5.8.2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jul 21, 2014 at 12:08 PM -- Server version: 5.5.37-35.1-log -- PHP Version: 5.4.23 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `slosocce_ssmapp` -- -- -------------------------------------------------------- -- -- Table structure for table `country` -- DROP TABLE IF EXISTS `country`; CREATE TABLE IF NOT EXISTS `country` ( `country_id` int(11) NOT NULL AUTO_INCREMENT, `country_name` varchar(100) COLLATE latin1_general_ci NOT NULL, PRIMARY KEY (`country_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=240 ; -- -- Dumping data for table `country` -- INSERT INTO `country` (`country_id`, `country_name`) VALUES (1, 'United States'), (2, 'Canada'), (3, 'Afghanistan'), (4, 'Åland Islands'), (5, 'Albania'), (6, 'Algeria'), (7, 'American Samoa'), (8, 'Andorra'), (9, 'Angola'), (10, 'Anguilla'), (11, 'Antarctica'), (12, 'Antigua and Barbuda'), (13, 'Argentina'), (14, 'Armenia'), (15, 'Aruba'), (16, 'Australia'), (17, 'Austria'), (18, 'Azerbaijan'), (19, 'The Bahamas'), (20, 'Bahrain'), (21, 'Bangladesh'), (22, 'Barbados'), (23, 'Belarus'), (24, 'Belgium'), (25, 'Belize'), (26, 'Benin'), (27, 'Bermuda'), (28, 'Bhutan'), (29, 'Bolivia'), (30, 'Bosnia and Herzegovina'), (31, 'Botswana'), (32, 'Bouvet Island'), (33, 'Brazil'), (34, 'British Indian Ocean Territory'), (35, 'Brunei'), (36, 'Bulgaria'), (37, 'Burkina Faso'), (38, 'Burundi'), (39, 'Cambodia'), (40, 'Cameroon'), (41, 'Cape Verde'), (42, 'Cayman Islands'), (43, 'Central African Republic'), (44, 'Chad'), (45, 'Chile'), (46, 'Christmas Island'), (47, 'Cocos (Keeling) Islands'), (48, 'Colombia'), (49, 'Comoros'), (50, 'Democratic Republic of the Congo'), (51, 'Republic of the Congo'), (52, 'Cook Islands'), (53, 'Costa Rica'), (54, 'Croatia'), (55, 'Cuba'), (56, 'Cyprus'), (57, 'Czech Republic'), (58, 'Denmark'), (59, 'Djibouti'), (60, 'Dominica'), (61, 'Dominican Republic'), (62, 'East Timor'), (63, 'Ecuador'), (64, 'Egypt'), (65, 'El Salvador'), (66, 'Equatorial Guinea'), (67, 'Eritrea'), (68, 'Estonia'), (69, 'Ethiopia'), (70, 'Falkland Islands'), (71, 'Faroe Islands'), (72, 'Fiji'), (73, 'Finland'), (74, 'France'), (75, 'French Guiana'), (76, 'French Polynesia'), (77, 'French Southern Territories'), (78, 'Gabon'), (79, 'Gambia'), (80, 'Georgia'), (81, 'Germany'), (82, 'Ghana'), (83, 'Gibraltar'), (84, 'Greece'), (85, 'Greenland'), (86, 'Grenada'), (87, 'Guadeloupe'), (88, 'Guam'), (89, 'Guatemala'), (90, 'Guernsey'), (91, 'Guinea'), (92, 'Guinea-Bissau'), (93, 'Guyana'), (94, 'Haiti'), (95, 'Heard Island and McDonald Islands'), (96, 'Honduras'), (97, 'Hong Kong'), (98, 'Hungary'), (99, 'Iceland'), (100, 'India'), (101, 'Indonesia'), (102, 'Iran'), (103, 'Iraq'), (104, 'Ireland'), (105, 'Isle of Man'), (106, 'Israel'), (107, 'Italy'), (108, 'Jamaica'), (109, 'Japan'), (110, 'Jersey'), (111, 'Jordan'), (112, 'Kazakhstan'), (113, 'Kenya'), (114, 'Kiribati'), (115, 'North Korea'), (116, 'South Korea'), (117, 'Kuwait'), (118, 'Kyrgyzstan'), (119, 'Laos'), (120, 'Latvia'), (121, 'Lebanon'), (122, 'Lesotho'), (123, 'Liberia'), (124, 'Libya'), (125, 'Liechtenstein'), (126, 'Lithuania'), (127, 'Luxembourg'), (128, 'Macau'), (129, 'Macedonia'), (130, 'Madagascar'), (131, 'Malawi'), (132, 'Malaysia'), (133, 'Maldives'), (134, 'Mali'), (135, 'Malta'), (136, 'Marshall Islands'), (137, 'Martinique'), (138, 'Mauritania'), (139, 'Mauritius'), (140, 'Mayotte'), (141, 'Mexico'), (142, 'Micronesia'), (143, 'Moldova'), (144, 'Monaco'), (145, 'Mongolia'), (146, 'Montenegro'), (147, 'Montserrat'), (148, 'Morocco'), (149, 'Mozambique'), (150, 'Myanmar'), (151, 'Namibia'), (152, 'Nauru'), (153, 'Nepal'), (154, 'Netherlands Antilles'), (155, 'New Caledonia'), (156, 'New Zealand'), (157, 'Nicaragua'), (158, 'Niger'), (159, 'Nigeria'), (160, 'Niue'), (161, 'Norfolk Island'), (162, 'Northern Mariana Islands'), (163, 'Norway'), (164, 'Oman'), (165, 'Pakistan'), (166, 'Palau'), (167, 'Panama'), (168, 'Papua New Guinea'), (169, 'Paraguay'), (170, 'Peru'), (171, 'Philippines'), (172, 'Pitcairn Islands'), (173, 'Poland'), (174, 'Portugal'), (175, 'Qatar'), (176, 'Réunion'), (177, 'Romania'), (178, 'Russia'), (179, 'Rwanda'), (180, 'Saint Helena'), (181, 'Saint Kitts and Nevis'), (182, 'Saint Lucia'), (183, 'Saint Pierre and Miquelon'), (184, 'Saint Vincent and the Grenadines'), (185, 'Samoa'), (186, 'San Marino'), (187, 'São Tomé and Príncipe'), (188, 'Saudi Arabia'), (189, 'Senegal'), (190, 'Serbia'), (191, 'Seychelles'), (192, 'Sierra Leone'), (193, 'Singapore'), (194, 'Slovakia'), (195, 'Slovenia'), (196, 'Solomon Islands'), (197, 'Somalia'), (198, 'South Africa'), (199, 'South Georgia and the South Sandwich Islands'), (200, 'Spain'), (201, 'Sri Lanka'), (202, 'Sudan'), (203, 'Suriname'), (204, 'Svalbard'), (205, 'Swaziland'), (206, 'Sweden'), (207, 'Switzerland'), (208, 'Syria'), (209, 'Taiwan'), (210, 'Tajikistan'), (211, 'Tanzania'), (212, 'Thailand'), (213, 'Togo'), (214, 'Tokelau'), (215, 'Tonga'), (216, 'Trinidad and Tobago'), (217, 'Tunisia'), (218, 'Turkey'), (219, 'Turkmenistan'), (220, 'Turks and Caicos Islands'), (221, 'Tuvalu'), (222, 'Uganda'), (223, 'Ukraine'), (224, 'United Arab Emirates'), (225, 'United Kingdom'), (226, 'United States Minor Outlying Islands'), (227, 'Uruguay'), (228, 'Uzbekistan'), (229, 'Vanuatu'), (230, 'Vatican City'), (231, 'Venezuela'), (232, 'Vietnam'), (233, 'British Virgin Islands'), (234, 'United States Virgin Islands'), (235, 'Wallis and Futuna'), (236, 'Western Sahara'), (237, 'Yemen'), (238, 'Zambia'), (239, 'Zimbabwe'); -- -------------------------------------------------------- -- -- Table structure for table `email_templates` -- DROP TABLE IF EXISTS `email_templates`; CREATE TABLE IF NOT EXISTS `email_templates` ( `email_template_id` int(11) NOT NULL AUTO_INCREMENT, `template_name` varchar(255) NOT NULL, `subject` varchar(500) DEFAULT NULL, `content` text, PRIMARY KEY (`email_template_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; -- -- Dumping data for table `email_templates` -- INSERT INTO `email_templates` (`email_template_id`, `template_name`, `subject`, `content`) VALUES (1, 'FORGOT_PASSWORD', 'Your new password.', '\r\n\r\n\r\n\r\nWelcome\r\n\r\n\r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n

\r\n \r\n \r\n \r\n \r\n
Hello {USERNAME},
\r\n
\r\n Your new password is: {PASSWORD}
\r\n
\r\n
\r\n Thank you,
\r\n HRock School of Supernatural Ministry. ALL Rights Reserved.
\r\n
\r\n
© Copyright {YEAR} HRock School of Supernatural Ministry. ALL Rights Reserved.
\r\n\r\n\r\n'), (2, 'WELCOME_EMAIL', 'Welcome', '\r\n\r\n\r\n\r\nWelcome\r\n\r\n\r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n

\r\n \r\n \r\n \r\n \r\n \r\n \r\n

Welcome to
\r\n
\r\n Hello {FULLNAME},
\r\n
\r\n You have successfully registered with HRock School of Supernatural Ministry.
\r\n
\r\n Following are the login details.
\r\n
\r\n Username: {USERNAME}
\r\n Password: {PASSWORD}

\r\n


\r\n Thank you,
\r\n {SITENAME} System Support Team

\r\n
© Copyright {YEAR} HRock School of Supernatural Ministry. ALL Rights Reserved.
\r\n\r\n\r\n'), (3, 'NEW_USER_REGISTRATION', 'New user registration', '\r\n\r\n\r\n\r\nWelcome to {SITENAME}\r\n\r\n\r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n

\r\n \r\n \r\n \r\n \r\n
Hello Admin,
\r\n
\r\n New user {FULLNAME} has registered with the SSM 1st year application process.
\r\n
\r\n Thank you,
\r\n
\r\n
© Copyright {YEAR} HRock School of Supernatural Ministry. ALL Rights Reserved.
\r\n\r\n\r\n'); -- -------------------------------------------------------- -- -- Table structure for table `member` -- DROP TABLE IF EXISTS `member`; CREATE TABLE IF NOT EXISTS `member` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `avtar` varchar(255) NOT NULL, `date_form` date NOT NULL, `full_name` varchar(255) NOT NULL, `gender` enum('Male','Female') NOT NULL, `phone_number` varchar(255) NOT NULL, `street_address` text NOT NULL, `street_address_2` text NOT NULL, `city` varchar(255) NOT NULL, `state` varchar(255) NOT NULL, `zip_code` varchar(255) NOT NULL, `country` varchar(255) NOT NULL, `birth_date` date NOT NULL, `email` varchar(255) NOT NULL, `marital_status` enum('Single','Married','Divorced','Separated') NOT NULL, `spouse_attending_school` enum('Yes','No') NOT NULL, `are_you_christian` enum('Yes','No') NOT NULL, `when_you_accept_christ` varchar(255) NOT NULL, `baptized_in_spirit` enum('Yes','No') NOT NULL, `baptized_when` varchar(255) NOT NULL, `relationship_with_god` text NOT NULL, `current_church_attend` varchar(255) NOT NULL, `church_attend_how_long` varchar(255) NOT NULL, `church_attend_how_often` enum('weekly','2-3 times/month','monthly','other') NOT NULL, `senior_pastors_name` varchar(255) NOT NULL, `recently_left_another_church` enum('Yes','No') NOT NULL, `recently_left_another_church_when` varchar(255) NOT NULL, `actively_serving_volunteering_ministry` enum('Yes','No') NOT NULL, `your_involvement` text NOT NULL, `parents_names` int(11) NOT NULL, `parents_phone_number` int(11) NOT NULL, `name_of_spouse` int(11) NOT NULL, `spouse_birth_date` int(11) NOT NULL, `children_names_ages` int(11) NOT NULL, `school_name_city_state_1` varchar(255) NOT NULL, `year_graduate_degree_major_1` varchar(255) NOT NULL, `school_name_city_state_2` varchar(255) NOT NULL, `year_graduate_degree_major_2` varchar(255) NOT NULL, `school_name_city_state_3` varchar(255) NOT NULL, `year_graduate_degree_major_3` varchar(255) NOT NULL, `school_name_city_state_4` varchar(255) NOT NULL, `year_graduate_degree_major_4` varchar(255) NOT NULL, `employer_job_title_years_worked_1` text NOT NULL, `employer_job_title_years_worked_2` text NOT NULL, `employer_job_title_years_worked_3` text NOT NULL, `employer_job_title_years_worked_4` text NOT NULL, `type_of_christian_service` text NOT NULL, `used_tobacoo_last_six_months` enum('Yes','No') NOT NULL, `drunk_alcoholic_beverages_last_six_months` enum('Yes','No') NOT NULL, `tobacoo_alcholic_explain` text NOT NULL, `involved_with_pornography_last_tweleve_months` enum('Yes','No') NOT NULL, `involved_with_pornography_when_last` text NOT NULL, `involved_in_homosecuality_last_five_years` enum('Yes','No') NOT NULL, `involved_in_homosecuality_when_last` text NOT NULL, `ever_been_arrested` enum('Yes','No') NOT NULL, `ever_been_arrested_when` text NOT NULL, `ever_convicted` enum('Yes','No') NOT NULL, `ever_convicted_when_where` text NOT NULL, `ever_involved_occult` enum('Yes','No') NOT NULL, `ever_involved_occult_explanation` text NOT NULL, `used_illegal_drugs` enum('Yes','No') NOT NULL, `used_illegal_drugs_explanation` text NOT NULL, `sexually_active_last_year` enum('Yes','No') NOT NULL, `personal_recommen_first_name` varchar(255) NOT NULL, `personal_recommen_last_name` varchar(255) NOT NULL, `personal_recommen_area_code` varchar(255) NOT NULL, `personal_recommen_phone_number` varchar(255) NOT NULL, `personal_recommen_street_address` text NOT NULL, `personal_recommen_street_addres_2` text NOT NULL, `personal_recommen_city` varchar(255) NOT NULL, `personal_recommen_state` varchar(255) NOT NULL, `personal_recommen_zip_code` varchar(255) NOT NULL, `personal_recommen_country` varchar(255) NOT NULL, `personal_recommen_email` varchar(255) NOT NULL, `pastoral_recommen_first_name` varchar(255) NOT NULL, `pastoral_recommen_last_name` varchar(255) NOT NULL, `pastoral_recommen_area_code` varchar(255) NOT NULL, `pastoral_recommen_phone_number` varchar(255) NOT NULL, `pastoral_recommen_street_address` text NOT NULL, `pastoral_recommen_street_addres_2` text NOT NULL, `pastoral_recommen_city` varchar(255) NOT NULL, `pastoral_recommen_state` varchar(255) NOT NULL, `pastoral_recommen_zip_code` varchar(255) NOT NULL, `pastoral_recommen_country` varchar(255) NOT NULL, `pastoral_recommen_email` varchar(255) NOT NULL, `personal_recommen_payment_method` enum('Cash','Check (made payable to Hrock SSM)') NOT NULL, `personal_recommen_digital_signature` varchar(255) NOT NULL, `personal_recommen_todays_date` date NOT NULL, `created` datetime NOT NULL, `updated` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ; -- -- Dumping data for table `member` -- INSERT INTO `member` (`id`, `username`, `password`, `avtar`, `date_form`, `full_name`, `gender`, `phone_number`, `street_address`, `street_address_2`, `city`, `state`, `zip_code`, `country`, `birth_date`, `email`, `marital_status`, `spouse_attending_school`, `are_you_christian`, `when_you_accept_christ`, `baptized_in_spirit`, `baptized_when`, `relationship_with_god`, `current_church_attend`, `church_attend_how_long`, `church_attend_how_often`, `senior_pastors_name`, `recently_left_another_church`, `recently_left_another_church_when`, `actively_serving_volunteering_ministry`, `your_involvement`, `parents_names`, `parents_phone_number`, `name_of_spouse`, `spouse_birth_date`, `children_names_ages`, `school_name_city_state_1`, `year_graduate_degree_major_1`, `school_name_city_state_2`, `year_graduate_degree_major_2`, `school_name_city_state_3`, `year_graduate_degree_major_3`, `school_name_city_state_4`, `year_graduate_degree_major_4`, `employer_job_title_years_worked_1`, `employer_job_title_years_worked_2`, `employer_job_title_years_worked_3`, `employer_job_title_years_worked_4`, `type_of_christian_service`, `used_tobacoo_last_six_months`, `drunk_alcoholic_beverages_last_six_months`, `tobacoo_alcholic_explain`, `involved_with_pornography_last_tweleve_months`, `involved_with_pornography_when_last`, `involved_in_homosecuality_last_five_years`, `involved_in_homosecuality_when_last`, `ever_been_arrested`, `ever_been_arrested_when`, `ever_convicted`, `ever_convicted_when_where`, `ever_involved_occult`, `ever_involved_occult_explanation`, `used_illegal_drugs`, `used_illegal_drugs_explanation`, `sexually_active_last_year`, `personal_recommen_first_name`, `personal_recommen_last_name`, `personal_recommen_area_code`, `personal_recommen_phone_number`, `personal_recommen_street_address`, `personal_recommen_street_addres_2`, `personal_recommen_city`, `personal_recommen_state`, `personal_recommen_zip_code`, `personal_recommen_country`, `personal_recommen_email`, `pastoral_recommen_first_name`, `pastoral_recommen_last_name`, `pastoral_recommen_area_code`, `pastoral_recommen_phone_number`, `pastoral_recommen_street_address`, `pastoral_recommen_street_addres_2`, `pastoral_recommen_city`, `pastoral_recommen_state`, `pastoral_recommen_zip_code`, `pastoral_recommen_country`, `pastoral_recommen_email`, `personal_recommen_payment_method`, `personal_recommen_digital_signature`, `personal_recommen_todays_date`, `created`, `updated`) VALUES (0, 'admin', '21232f297a57a5a743894a0e4a801fc3', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0000-00-00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (4, 'webmedia', '2ffbed6303768b8b2a9132c0b012a945', 'avtar_4.jpg', '0000-00-00', 'web media', '', '(111) 112-2222', 'Address', '', 'City', 'State', '1234567890', '', '1984-06-15', 'webmediacreatives@gmail.com', 'Married', 'No', 'No', 'If yes,, when did you accept Christ?', 'No', 'If yes, when?', 'Describe your relationship with God:', 'What church do you currently attend?', 'For How long?', 'weekly', 'Senior Pastor''s name:', 'Yes', 'when', 'Yes', 'Describe your involvement', 0, 0, 0, 0, 0, 'school name, city, state 1', 'Year Graduated/Degree/Major1', 'school name, city, state2', 'Year Graduated/Degree/Major2', 'school name, city, state3', 'Year Graduated/Degree/Major3', 'school name, city, state4', 'Year Graduated/Degree/Major4', '1. Employer/ Job Title/ # of Years Worked', '2. Employer/ Job Title/ # of Years Worked', '3. Employer/ Job Title/ # of Years Worked', '4. Employer/ Job Title/ # of Years Worked', 'What type of Christian service have you done?', 'Yes', 'Yes', 'If yes, please explain:', 'Yes', 'If so, when was the last time, and what are you doing to remain pure in this area?', 'Yes', 'If so, when was the last time? And please explain what God has done to restore you:', 'Yes', 'If yes, when? Please provide a brief explanation:', 'Yes', 'If yes, when and where? Please provide a brief explanation:', 'Yes', 'If yes, please provide a brief explanation:', 'Yes', 'If yes, please explain:', 'Yes', 'Firstname', 'Lastname', 'areacode', 'phonenumber', 'street address', 'street address 2', 'city', 'state', 'postal', 'India', 'email@test.com', 'firstname 1', 'lastname1', 'areacode 2', 'phone 2', 'street address 11', 'street address 2 11', 'city 1', 'state 1', 'posta 1', 'Pakistan', 'email1@gmail.com', 'Check (made payable to Hrock SSM)', 'Digital signature', '2001-11-11', '2014-06-25 10:47:10', '2014-07-03 10:42:44'), (5, 'klarsendesign', '9dc0869b4645b2382a3902d574617562', 'avtar_5.jpg', '0000-00-00', 'Kirste Larsen', 'Female', '(626) 241-5757', '123 S. Chester Ave. #3', '', 'Pasadena', 'CA', '91106', '', '0000-00-00', 'klarsendesign@gmail.com', 'Single', 'No', 'Yes', '', 'Yes', '', '', '', '', 'weekly', '', 'Yes', '', 'Yes', '', 0, 0, 0, 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', 'Yes', 'Yes', '', 'Yes', '', 'Yes', '', 'Yes', '', 'Yes', '', 'Yes', '', 'Yes', '', 'Yes', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Cash', '', '0000-00-00', '2014-07-03 11:00:15', '2014-07-03 11:05:43'), (6, 'Tainarimorales@yahoo.com', '557dc04af9dc7dff84623ad762bfe879', '', '0000-00-00', 'Tainari Morales', 'Female', '(562) 500-0867', '12648 Paddison ave', '', 'Norwalk', 'California', '90650', '', '0000-00-00', 'tainarimorales@yahoo.com', 'Married', 'Yes', 'Yes', '', 'Yes', '', '', '', '', 'weekly', '', 'Yes', '', 'Yes', '', 0, 0, 0, 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', 'Yes', 'Yes', '', 'Yes', '', 'Yes', '', 'Yes', '', 'Yes', '', 'Yes', '', 'Yes', '', 'Yes', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Cash', '', '0000-00-00', '2014-07-08 13:04:04', '2014-07-19 17:30:09'), (7, 'leonelmorales1985@yahoo.com', 'e8ca9f575487f631ae9cda0aaba2cf9e', '', '0000-00-00', 'Leonel Morales', 'Male', '', '', '', '', '', '', '', '0000-00-00', 'leonelmorales1985@yahoo.com', 'Single', 'Yes', 'Yes', '', 'Yes', '', '', '', '', 'weekly', '', 'Yes', '', 'Yes', '', 0, 0, 0, 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', 'Yes', 'Yes', '', 'Yes', '', 'Yes', '', 'Yes', '', 'Yes', '', 'Yes', '', 'Yes', '', 'Yes', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Cash', '', '0000-00-00', '2014-07-19 18:06:22', '2014-07-19 18:06:22'); /*!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 */;