-- Prayer Type
CREATE TABLE `prayer_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `status` tinyint(1) DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `prayer_types` (`id`, `title`, `slug`, `status`, `created_by`, `created`, `modified`) VALUES
(8,	'Emotional Healing',	'emotional-healing-7MYQMQ',	1,	7,	'2022-12-03 16:43:38',	'2022-12-03 11:13:38'),
(9,	'Physical Healing',	'physical-healing-Kr1XM3',	1,	7,	'2022-12-03 16:43:53',	'2022-12-03 11:13:53'),
(10,	'Finances',	'finances-7L9yLo',	1,	7,	'2022-12-03 16:44:09',	'2022-12-03 11:14:09'),
(11,	'ee',	'ee-8MZBMx',	0,	7,	'2022-12-03 16:44:21',	'2022-12-06 05:41:47');

-- Prayer Req
CREATE TABLE `prayer_registrations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `first_name` varchar(255) DEFAULT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `prayer_type_id` int(11) DEFAULT NULL,
  `message` text DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `prayer_type_id` (`prayer_type_id`),
  CONSTRAINT `prayer_registrations_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `prayer_registrations_ibfk_2` FOREIGN KEY (`prayer_type_id`) REFERENCES `prayer_types` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `prayer_registrations` (`id`, `user_id`, `first_name`, `last_name`, `email`, `prayer_type_id`, `message`, `created`, `modified`) VALUES
(1,	123,	'Rakesh',	'Kumar',	'rakesh.globiztechnology@gmail.com',	9,	'a written or spoken piece of information that you send to or leave for a person when you cannot speak to him/her',	NULL,	'2022-12-03 11:15:43'),
(3,	123,	'Rohan',	'Kumar',	'rakesh.globiztechnology@gmail.com',	9,	'a written or spoken piece of information that you send to or leave for a person when you cannot speak to him/her',	NULL,	'2022-12-03 11:53:18'),
(6,	123,	'Rakesh',	'Kumar',	'rakesh.globiztechnology@gmail.com',	9,	'a written or spoken piece of information that you send to or leave for a person when you cannot speak to him/her',	NULL,	'2022-12-03 11:15:43'),
(7,	123,	'Rohan',	'Kumar',	'rakesh.globiztechnology@gmail.com',	9,	'a written or spoken piece of information that you send to or leave for a person when you cannot speak to him/her',	NULL,	'2022-12-03 11:53:18');

-- Event Req
CREATE TABLE `event_registrations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `first_name` varchar(255) DEFAULT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone_number` varchar(255) DEFAULT NULL,
  `message` text DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `event_registrations_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `event_registrations` (`id`, `user_id`, `first_name`, `last_name`, `email`, `phone_number`, `message`, `created`, `modified`) VALUES
(1,	123,	'Ravi',	'Sharma',	'r@gmail.com',	'7575445545',	'a written or spoken piece of information that you send to or leave for a person when you cannot speak to him/her',	NULL,	'2022-12-05 05:21:13');

-- Mission Req
CREATE TABLE `mission_registrations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `first_name` varchar(255) DEFAULT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone_number` varchar(255) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `mission_registrations_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `mission_registrations` (`id`, `user_id`, `first_name`, `last_name`, `email`, `phone_number`, `created`, `modified`) VALUES
(1,	123,	'Raghav',	'Sastri',	'r@gmail.com',	'7845454455',	NULL,	'2022-12-05 05:48:47'),
(2,	123,	'Raghav',	'Sastri',	'r@gmail.com',	'7845454455',	NULL,	'2022-12-05 05:48:47');

-- 06/12
UPDATE `web_settings` SET
`id` = '1',
`banner_title` = 'Live inspired. Reach your dreams. Become all God created you to be!',
`banner_image` = '/uploads/fullImage/16703154488035-banner.png',
`banner_is_button` = '1',
`banner_button_text` = 'Read more',
`banner_button_link` = 'https://twitter.com/',
`section_2_title` = 'Welcome to Fellowship Found',
`section_2_description` = '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut. Lorem ipsum dolor sit amet, consectetur adipiscing efdf</p>',
`section_3_title_1` = 'Lorem ipsum dolor sit amet adipiscing elit,',
`section_3_descrption_1` = NULL,
`section_3_image_1` = '/uploads/fullImage/16699760524568-discount-badge-1.png',
`section_3_is_button_1` = '1',
`section_3_button_text_1` = 'Order now',
`section_3_button_link_1` = 'https://twitter.com/',
`section_3_title_2` = 'Lorem ipsum dolor sit amet adipiscing elit,',
`section_3_descrption_2` = NULL,
`section_3_image_2` = '/uploads/fullImage/1669976056977-discount-badge-2.png',
`section_3_is_button_2` = '1',
`section_3_button_text_2` = 'Order now',
`section_3_button_link_2` = 'https://twitter.com/',
`upcoming_event_title` = 'Upcoming Events',
`upcoming_event_section` = '[\"106\",\"101\",\"97\",\"102\"]',
`prayer_title` = 'Need a prayer?',
`prayer_description` = 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut. Lorem ipsum dolor sit amet, consectetur adipiscing elit',
`prayer_image` = '/uploads/fullImage/1669978591433-img-20220713-091944.jpg',
`prayer_is_button` = '1',
`prayer_button_text` = 'Ask for prayer',
`prayer_button_link` = 'https://twitter.com/',
`need_help_title` = 'Help Those in Need',
`need_help_description` = 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut. Lorem ipsum dolor sit amet, consectetur adipiscing elit',
`need_help_image` = '/uploads/fullImage/16699789372065-group-144.png',
`need_help_is_button` = '1',
`need_help_button_text` = 'Donate Now',
`need_help_button_link` = 'https://twitter.com/',
`latest_blog_title` = 'Latest Blog',
`latest_blog_section` = '[\"84\",\"87\",\"85\"]',
`testimonial_title` = 'What people say about us ',
`testimonial_section` = '[\"21\",\"24\",\"23\"]',
`testimonial_image` = '/uploads/fullImage/16699786092884-img-20220713-091944.jpg',
`testimonial_is_button` = '1',
`testimonial_button_text` = 'View More',
`testimonial_button_link` = 'https://twitter.com/',
`quick_links_title` = 'Useful Links',
`footer_menu` = '[{\"menu_title\":\"About Us\",\"menu_url\":\"http:\\/\\/localhost\\/laravel\\/fellowship\\/public\\/about-us\"},{\"menu_title\":\"Feedback\",\"menu_url\":\"http:\\/\\/localhost\\/laravel\\/fellowship\\/public\\/feedback\"},{\"menu_title\":\"Terms & Conditions\",\"menu_url\":\"http:\\/\\/localhost\\/laravel\\/fellowship\\/public\\/terms-conditions\"},{\"menu_title\":\"Privacy Policy\",\"menu_url\":\"http:\\/\\/localhost\\/laravel\\/fellowship\\/public\\/privacy-policy\"},{\"menu_title\":\"Contact Us\",\"menu_url\":\"http:\\/\\/localhost\\/laravel\\/fellowship\\/public\\/contact-us\"},{\"menu_title\":\"FAQs\",\"menu_url\":\"http:\\/\\/localhost\\/laravel\\/fellowship\\/public\\/faq\"}]',
`contact_info_title` = 'Contact Us',
`address` = '7-2-307, 307/1, Ashok Nagar Takaar lorem dummy address',
`phone_number_1` = '+91 98765-43210',
`email` = 'info@fellowship.com',
`follow_us_title` = 'Follow us',
`follow_us_sub_title` = 'Get connected with us on social media',
`facebook` = 'https://www.facebook.com',
`instagram` = 'https://www.instagram.com',
`whatsapp` = 'https://www.whatsapp.com',
`powered_by` = 'Globiz Technology Inc.',
`powered_by_link` = 'https://globiztechnology.com/',
`created_by` = '7',
`deleted_at` = NULL,
`created` = '2022-10-20 11:57:38',
`modified` = now()
WHERE `id` = '1';

ALTER TABLE `events`
ADD `address` text COLLATE 'utf8_general_ci' NULL AFTER `description`,
CHANGE `modified` `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE CURRENT_TIMESTAMP AFTER `created`;

ALTER TABLE `web_settings`
ADD `upcoming_event_is_button` tinyint(4) NULL AFTER `upcoming_event_section`,
ADD `upcoming_event_button_text` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `upcoming_event_is_button`,
ADD `upcoming_event_button_link` varchar(255) COLLATE 'utf8_general_ci' NULL AFTER `upcoming_event_button_text`,
CHANGE `modified` `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE CURRENT_TIMESTAMP AFTER `created`;

UPDATE `web_settings` SET
`id` = '1',
`banner_title` = 'Live inspired. Reach your dreams. Become all God created you to be!',
`banner_image` = '/uploads/fullImage/16703154488035-banner.png',
`banner_is_button` = '1',
`banner_button_text` = 'Read more',
`banner_button_link` = 'https://twitter.com/',
`section_2_title` = 'Welcome to Fellowship Found',
`section_2_description` = '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut. Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut.Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut. Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>',
`section_3_title_1` = 'Lorem ipsum dolor sit amet adipiscing elit,',
`section_3_descrption_1` = NULL,
`section_3_image_1` = '/uploads/fullImage/16699760524568-discount-badge-1.png',
`section_3_is_button_1` = '1',
`section_3_button_text_1` = 'Order now',
`section_3_button_link_1` = 'https://twitter.com/',
`section_3_title_2` = 'Lorem ipsum dolor sit amet adipiscing elit,',
`section_3_descrption_2` = NULL,
`section_3_image_2` = '/uploads/fullImage/1669976056977-discount-badge-2.png',
`section_3_is_button_2` = '1',
`section_3_button_text_2` = 'Order now',
`section_3_button_link_2` = 'https://twitter.com/',
`upcoming_event_title` = 'Upcoming Events',
`upcoming_event_section` = '[\"108\",\"109\",\"110\",\"111\"]',
`upcoming_event_is_button` = '1',
`upcoming_event_button_text` = 'Read more',
`upcoming_event_button_link` = 'https://twitter.com/',
`prayer_title` = 'Need a prayer?',
`prayer_description` = 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut. Lorem ipsum dolor sit amet, consectetur adipiscing elit',
`prayer_image` = '/uploads/fullImage/1669978591433-img-20220713-091944.jpg',
`prayer_is_button` = '1',
`prayer_button_text` = 'Ask for prayer',
`prayer_button_link` = 'https://twitter.com/',
`need_help_title` = 'Help Those in Need',
`need_help_description` = 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut. Lorem ipsum dolor sit amet, consectetur adipiscing elit',
`need_help_image` = '/uploads/fullImage/16699789372065-group-144.png',
`need_help_is_button` = '1',
`need_help_button_text` = 'Donate Now',
`need_help_button_link` = 'https://twitter.com/',
`latest_blog_title` = 'Latest Blog',
`latest_blog_section` = '[\"84\",\"87\",\"85\"]',
`testimonial_title` = 'What people say about us',
`testimonial_section` = '[\"31\",\"29\"]',
`testimonial_image` = '/uploads/fullImage/16699786092884-img-20220713-091944.jpg',
`testimonial_is_button` = '1',
`testimonial_button_text` = 'View More',
`testimonial_button_link` = 'https://twitter.com/',
`quick_links_title` = 'Useful Links',
`footer_menu` = '[{\"menu_title\":\"About Us\",\"menu_url\":\"http:\\/\\/localhost\\/laravel\\/fellowship\\/public\\/about-us\"},{\"menu_title\":\"Feedback\",\"menu_url\":\"http:\\/\\/localhost\\/laravel\\/fellowship\\/public\\/feedback\"},{\"menu_title\":\"Terms & Conditions\",\"menu_url\":\"http:\\/\\/localhost\\/laravel\\/fellowship\\/public\\/terms-conditions\"},{\"menu_title\":\"Privacy Policy\",\"menu_url\":\"http:\\/\\/localhost\\/laravel\\/fellowship\\/public\\/privacy-policy\"},{\"menu_title\":\"Contact Us\",\"menu_url\":\"http:\\/\\/localhost\\/laravel\\/fellowship\\/public\\/contact-us\"},{\"menu_title\":\"FAQs\",\"menu_url\":\"http:\\/\\/localhost\\/laravel\\/fellowship\\/public\\/faq\"}]',
`contact_info_title` = 'Contact Us',
`address` = '7-2-307, 307/1, Ashok Nagar Takaar lorem dummy address',
`phone_number_1` = '+91 98765-43210',
`email` = 'info@fellowship.com',
`follow_us_title` = 'Follow us',
`follow_us_sub_title` = 'Get connected with us on social media',
`facebook` = 'https://www.facebook.com',
`instagram` = 'https://www.instagram.com',
`whatsapp` = 'https://www.whatsapp.com',
`powered_by` = 'Globiz Technology Inc.',
`powered_by_link` = 'https://globiztechnology.com/',
`created_by` = '7',
`deleted_at` = NULL,
`created` = '2022-10-20 11:57:38',
`modified` = now()
WHERE `id` = '1';

-- 07/12

UPDATE `web_settings` SET
`id` = '1',
`banner_title` = 'Live inspired. Reach your dreams. Become all God created you to be!',
`banner_image` = '/uploads/fullImage/16703895685973-banner.png',
`banner_is_button` = '1',
`banner_button_text` = 'Read more',
`banner_button_link` = 'https://twitter.com/',
`section_2_title` = 'Welcome to Fellowship Found',
`section_2_description` = '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut. Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut.Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut. Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>',
`latest_product_title` = 'Latest Products',
`latest_product_section` = '[\"1135\",\"1136\",\"1137\",\"1138\"]',
`latest_product_is_button` = '1',
`latest_product_button_text` = 'Order now',
`latest_product_button_link` = 'https://twitter.com/',
`section_3_title_1` = 'Lorem ipsum dolor sit amet adipiscing elit,',
`section_3_descrption_1` = NULL,
`section_3_image_1` = '/uploads/fullImage/16699760524568-discount-badge-1.png',
`section_3_is_button_1` = '1',
`section_3_button_text_1` = 'Order now',
`section_3_button_link_1` = 'https://twitter.com/',
`section_3_title_2` = 'Lorem ipsum dolor sit amet adipiscing elit,',
`section_3_descrption_2` = NULL,
`section_3_image_2` = '/uploads/fullImage/1669976056977-discount-badge-2.png',
`section_3_is_button_2` = '1',
`section_3_button_text_2` = 'Order now',
`section_3_button_link_2` = 'https://twitter.com/',
`upcoming_event_title` = 'Upcoming Events',
`upcoming_event_section` = '[\"108\",\"109\",\"110\",\"111\"]',
`upcoming_event_is_button` = '1',
`upcoming_event_button_text` = 'Read more',
`upcoming_event_button_link` = 'https://twitter.com/',
`prayer_title` = 'Need a prayer?',
`prayer_description` = 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut. Lorem ipsum dolor sit amet, consectetur adipiscing elit',
`prayer_image` = '/uploads/fullImage/1669978591433-img-20220713-091944.jpg',
`prayer_is_button` = '1',
`prayer_button_text` = 'Ask for prayer',
`prayer_button_link` = 'https://twitter.com/',
`need_help_title` = 'Help Those in Need',
`need_help_description` = 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut. Lorem ipsum dolor sit amet, consectetur adipiscing elit',
`need_help_image` = '/uploads/fullImage/16703291426440-listy.png',
`need_help_is_button` = '1',
`need_help_button_text` = 'Donate Now',
`need_help_button_link` = 'https://twitter.com/',
`latest_blog_title` = 'Latest Articles',
`latest_blog_section` = '[\"84\",\"85\"]',
`testimonial_title` = 'What people say about us',
`testimonial_section` = '[\"31\",\"29\"]',
`testimonial_image` = '/uploads/fullImage/16699786092884-img-20220713-091944.jpg',
`testimonial_is_button` = '1',
`testimonial_button_text` = 'View More',
`testimonial_button_link` = 'https://twitter.com/',
`quick_links_title` = 'Useful Links',
`footer_menu` = '[{\"menu_title\":\"About Us\",\"menu_url\":\"http:\\/\\/localhost\\/laravel\\/fellowship\\/public\\/about-us\"},{\"menu_title\":\"Feedback\",\"menu_url\":\"http:\\/\\/localhost\\/laravel\\/fellowship\\/public\\/feedback\"},{\"menu_title\":\"Terms & Conditions\",\"menu_url\":\"http:\\/\\/localhost\\/laravel\\/fellowship\\/public\\/terms-conditions\"},{\"menu_title\":\"Privacy Policy\",\"menu_url\":\"http:\\/\\/localhost\\/laravel\\/fellowship\\/public\\/privacy-policy\"},{\"menu_title\":\"Contact Us\",\"menu_url\":\"http:\\/\\/localhost\\/laravel\\/fellowship\\/public\\/contact-us\"},{\"menu_title\":\"FAQs\",\"menu_url\":\"http:\\/\\/localhost\\/laravel\\/fellowship\\/public\\/faq\"}]',
`contact_info_title` = 'Contact Us',
`address` = '7-2-307, 307/1, Ashok Nagar Takaar lorem dummy address',
`phone_number_1` = '+91 98765-43210',
`email` = 'info@fellowship.com',
`follow_us_title` = 'Follow us',
`follow_us_sub_title` = 'Get connected with us on social media',
`facebook` = 'https://www.facebook.com',
`instagram` = 'https://www.instagram.com',
`whatsapp` = 'https://www.whatsapp.com',
`powered_by` = 'Globiz Technology Inc.',
`powered_by_link` = 'https://globiztechnology.com/',
`created_by` = '7',
`deleted_at` = NULL,
`created` = '2022-10-20 11:57:38',
`modified` = now()
WHERE `id` = '1';