-- phpMyAdmin SQL Dump -- version 3.3.9 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Aug 01, 2014 at 06:54 PM -- Server version: 5.5.8 -- PHP Version: 5.3.5 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!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: `ssmapplication1styear` -- -- -------------------------------------------------------- -- -- Table structure for table `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` -- 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 to #SITENAME# Affiliate System!', '\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 as a member of the #SITENAME#.
\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 System.
\r\n
\r\n Thank you,
\r\n {SITENAME} Affiliate System Support Team
\r\n
\r\n
© Copyright {YEAR} {SITENAME} All Rights Reserved.
\r\n\r\n\r\n'); -- -------------------------------------------------------- -- -- Table structure for table `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=6 ; -- -- 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');