-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `ibcfr_ibcfr`
--

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

--
-- Table structure for table `alumnis`
--

CREATE TABLE `alumnis` (
  `id` int(11) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `mobile` varchar(15) DEFAULT NULL,
  `position` varchar(255) DEFAULT NULL,
  `biography` longtext DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `alumnis`
--

INSERT INTO `alumnis` (`id`, `name`, `email`, `mobile`, `position`, `biography`, `image`, `created_at`, `updated_at`) VALUES
(1, 'Enock Monyancha', 'enocmonyancha@gmail.com', '0799117020', 'Software Developer', 'Software Engineer, Cyber Security Expert, Web Developer, Android Developer, Entrepreneur', '202209231709test.png', '2022-09-23 14:09:05', '2022-09-23 14:09:05');

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

--
-- Table structure for table `blogs`
--

CREATE TABLE `blogs` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `ch_favorites`
--

CREATE TABLE `ch_favorites` (
  `id` bigint(20) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `favorite_id` bigint(20) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `ch_messages`
--

CREATE TABLE `ch_messages` (
  `id` bigint(20) NOT NULL,
  `type` varchar(191) NOT NULL,
  `from_id` bigint(20) NOT NULL,
  `to_id` bigint(20) NOT NULL,
  `body` varchar(5000) DEFAULT NULL,
  `attachment` varchar(191) DEFAULT NULL,
  `seen` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ch_messages`
--

INSERT INTO `ch_messages` (`id`, `type`, `from_id`, `to_id`, `body`, `attachment`, `seen`, `created_at`, `updated_at`) VALUES
(1921886308, 'user', 1, 1, 'Test me', NULL, 1, '2022-09-24 09:17:58', '2022-09-24 09:18:05'),
(2001398184, 'user', 1, 1, 'helo', NULL, 1, '2022-09-22 15:29:24', '2022-09-22 15:29:26'),
(2279365677, 'user', 1, 1, 'this is a test message', NULL, 1, '2022-09-22 15:29:36', '2022-09-22 15:29:37'),
(2483338052, 'user', 1, 1, 'hello', NULL, 1, '2022-09-24 05:27:24', '2022-09-24 05:27:28');

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

--
-- Table structure for table `contributions`
--

CREATE TABLE `contributions` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `donations`
--

CREATE TABLE `donations` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `details` longtext DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `rsvp` int(11) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `events`
--

INSERT INTO `events` (`id`, `title`, `details`, `location`, `image`, `date`, `rsvp`, `created_at`, `updated_at`) VALUES
(5, 'Alumni Meeting 2022', 'Alumni Meeting 2022', 'Baraton University Main Campus', '20220923143949141526668_ea9e08b8d2_c.jpg', '2022-10-06 09:40:00', 0, '2022-09-23 11:39:14', '2022-09-23 11:39:14'),
(6, '40th Graduation Ceremony', '40th Graduation Ceremony', 'Nairobi, Kenya', '20220923144149141929891_b8035da0d3_c.jpg', '2022-12-17 08:41:00', 0, '2022-09-23 11:41:57', '2022-09-23 11:41:57');

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(191) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `galleries`
--

CREATE TABLE `galleries` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `galleries`
--

INSERT INTO `galleries` (`id`, `title`, `image`, `created_at`, `updated_at`) VALUES
(6, '40th Graduation Ceremony', '20220923125149140572623_ea80909fe3_c.jpg', '2022-09-23 09:51:17', '2022-09-23 09:51:17'),
(7, '40th Graduation Ceremony', '20220923125149141469308_c6cfc5aa13_c.jpg', '2022-09-23 09:51:28', '2022-09-23 09:51:28'),
(8, '40th Graduation Ceremony', '20220923125149141929891_b8035da0d3_c.jpg', '2022-09-23 09:51:41', '2022-09-23 09:51:41'),
(9, '40th Graduation Ceremony', '20220923125349142202382_5080ccfaf3_c.jpg', '2022-09-23 09:53:03', '2022-09-23 09:53:03'),
(10, '40th Graduation Ceremony', '20220923131949141553518_61b17c212f_c.jpg', '2022-09-23 10:19:27', '2022-09-23 10:19:27'),
(11, '40th Graduation Ceremony', '20220923131949141505883_6fbe41d707_c.jpg', '2022-09-23 10:19:38', '2022-09-23 10:19:38'),
(12, '40th Graduation Ceremony', '20220923131949141493883_1577faa745_c.jpg', '2022-09-23 10:19:48', '2022-09-23 10:19:48'),
(13, '40th Graduation Ceremony', '20220923132049141526668_ea9e08b8d2_c.jpg', '2022-09-23 10:20:13', '2022-09-23 10:20:13');

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

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(191) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2022_09_22_999999_add_active_status_to_users', 2),
(5, '2022_09_22_999999_add_avatar_to_users', 2),
(6, '2022_09_22_999999_add_dark_mode_to_users', 2),
(7, '2022_09_22_999999_add_messenger_color_to_users', 2),
(8, '2022_09_22_999999_create_favorites_table', 2),
(9, '2022_09_22_999999_create_messages_table', 2);

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

--
-- Table structure for table `projects`
--

CREATE TABLE `projects` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `details` longtext DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `budget` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `projects`
--

INSERT INTO `projects` (`id`, `title`, `details`, `start_date`, `end_date`, `budget`, `status`, `image`, `created_at`, `updated_at`) VALUES
(2, 'Building Project 2022', '<section>\r\n<div>\r\n<div>\r\n<div>\r\n<div>\r\n<div><a href=\"https://leanconstructionblog.com/last-planner.html\">Last Planner</a></div>\r\n<h2>Rewards Of Visual Production Planning</h2>\r\n<div>\r\n<ul style=\"list-style-type: none;\">\r\n<li><a href=\"https://leanconstructionblog.com/jean-laurent.html\"><img style=\"width: 3rem; height: 3rem;\" src=\"https://lh6.googleusercontent.com/FJpruvHfR6D21p3fWXFLfKPok9n_a3NLpnC10xeKhPV3f4K5xal_PIbGIC4F5DMoA_6DbvWwF6dgNYMlWkFev3rcvd-LYwwtZxo9uN4eeS0wkepbgmBJ9bOj_q7XRXoC2FzaJibFv09bJbVnLQ\" alt=\"author\">Jean Laurent</a></li>\r\n<li><a href=\"https://leanconstructionblog.com/john-cleary.html\"><img style=\"width: 3rem; height: 3rem;\" src=\"https://lh3.googleusercontent.com/Ji5XHpA61IMtNJooDqrN0ntemUjiU99_CbMzKSIR7kXhaqOdixu_du9szkgej2rAXgpzIZrVRSncrVYQcdLf_4k72BeQIXrgnDHeOuFgqpseunzbjig7sB7YeF24tg7Fh_aj6RBE0iukuQiNFQ\" alt=\"author\">John Cleary</a></li>\r\n<li><em>.</em>May 9, 2022</li>\r\n</ul>\r\n</div>\r\n</div>\r\n</div>\r\n<div><img style=\"height: auto;\" src=\"https://lh5.googleusercontent.com/4sKqCunmpLr3eFGhUMT4eWVrVlg65dazWuPRs-1Qhg7Ty8GAO9sPOPYjmELlvd2gO_yMtws_D3bc-QqAhIud7ObplBgBbTSw3qc6D6gh55IiBOhk--HqkrfKfKR0c10yIIpYl0EP6Y4aTF9Wzg\" alt=\"\" width=\"600\" height=\"600\"></div>\r\n</div>\r\n</div>\r\n</section>\r\n<div>\r\n<div>\r\n<div>\r\n<div><main>\r\n<article>\r\n<div>\r\n<div>&nbsp;</div>\r\n<p>The principles of Lean Construction are rapidly adopted by construction companies at a project management and admin level. However, the benefits are exponential when focusing on field application that benefits the trades. The challenge is that project management teams are well trained to understand Lean principles and suggest what needs to be implemented in the field without involving field team members. On a typical construction project, the trade receives a schedule, a set of drawings and overall expectation of sequence and goals in relation to other trades. However the project teams should adopt a similar approach to the Last Planner System where the Last Planner identifies what would benefit its crews in correlation to the overall project goals, and with the help of Lean Leaders apply appropriate Lean principles to a specific need.</p>\r\n<h5>IMPLEMENTATION</h5>\r\n<p>At DPR we provided an example of how a concrete construction crew identified opportunities to improve production, awareness and overall performance. The team developed a visual production plan combining visual planning, production planning and quality elements that requires full participation of both field crew and project management.<br><br><strong>STEP 1:</strong>&nbsp;With the help of the Foreman and a few crew leaders, we meet to understand how to best sequence our activities. We carefully review drawings to understand all constraints in order to develop a clear and simple visual plan.<br><br><strong>STEP 2:</strong>&nbsp;Once the sequence was understood we met to develop a crew loaded concrete schedule in order to understand the impact of manpower on the financial health of the project. Doing so allowed us to compare budgeted man-hours against planned man-hours and quickly make adjustments to get a projection. At the end of this meeting the team was able to come up with a schedule that allows us to have an allocated crew and remain within budget.<br><br><strong>STEP 3:</strong>&nbsp;In preparation to start activities in the field, STEP 3 combines the Visual Plan from STEP 1 and the Crew Loaded Schedule from STEP 2 to develop a VISUAL PRODUCTION PLAN. The drawings were printed in A0 format and displayed in the field on boards for the crews to easily identify:</p>\r\n<ul>\r\n<li>Sequence and flow of work</li>\r\n<li>Daily goals per activity performed (quantified per SF, CY, LF, etc.)</li>\r\n<li>Display of required metrics for the project to help review quantities.</li>\r\n<li>Crew Loaded Schedule to show how many crew members are required per day for each activity</li>\r\n<li>Quantity Loaded Schedule to show the goals per day for each activity.</li>\r\n<li>Tracking sheets to enable the crews to track manpower and quantities put in place each day.</li>\r\n</ul>\r\n<p><strong>STEP 4:</strong>&nbsp;Every morning the crew meet for their daily huddle. During the meeting they utilize the boards to review the activities for the day, discuss potential roadblocks and review the overall workflow. At the end of each work day the foreman inputs the quantity in place and the manpower for each activity.<br><br><strong>STEP 5:</strong>&nbsp;The last STEP relates to the PDCA cycle and the spirit of continuous improvement. All the data is then inputted into a master spreadsheet so that we can compare the planned vs budgeted vs actual production data. This process allows the team to immediately identify overruns or loss of production and perform adjustments to the schedule and sequence.</p>\r\n<h5>TAKEAWAYS</h5>\r\n<p>With the use of visual production planning combined with the PDCA principles the team was able to continuously problem solve and find the solutions needed to overcome a 4-month delay. Through the precise monitoring of production rates, the project was able to manage budget and forecast schedule more accurately. Through collaborative scheduling, the project was able to problem solve and rethink traditional construction sequencing as challenges presented as well as implement the newest advances of prefabrication. Through visually planning the project, the team was motivated to trust others and partake in out of the box thinking and problem solving. Field, admin and design engagement leading to increased project performance and overall collaboration.<br><br>The team also faced challenges in implementing this innovative approach and identified the following areas of improvement:</p>\r\n<ol>\r\n<li>Prior to starting work it is key to perform an appropriate kickoff meeting with the crew and stakeholders. During this training the team reviews the process, goals, and overall understanding of lean principles.</li>\r\n<li>Team members also highlighted that the Visual Boards could include a section dedicated to constraints identified in the field and about the process to be reviewed weekly. This would allow for continuous improvement related to team engagement and problem solving.</li>\r\n<li>On a production tracking standpoint this project helped realize the need for accurate real time data that motivates us to improve our tracking tools and use across projects. Technology was a challenge because we had to develop our own custom tracking spreadsheet that made it challenging to collaborate with others, track data from multiple projects, share lessons learned and avoid using multiple support to implement our processes.</li>\r\n</ol>\r\n<br>\r\n<p>Combining production tracking with visual planning enables the entire Project Team to be aware of all necessary information to successfully collaborate, raise awareness and better identify and optimize value from a holistic viewpoint. This heightened awareness was instrumental in salvaging a challenging project schedule on a Southern California DATA CENTER. With the use of production tracking combined with visual planning, the team was able to repeatedly identify and solve problems, achieve milestones and find the solutions needed to overcome a 4-month delay.</p>\r\n<h5>REFERENCES</h5>\r\n<p>1. Laurent, J. E. &amp; Leicht, R. M. 2017, \'Cross-Functional Project Teams in Construction: A Longitudinal Case Study\' In:, 25th Annual Conference of the International Group for Lean Construction. Heraklion, Greece, 9-12 Jul 2017. pp 317-324. <a href=\"https://doi.org/10.24928/2017/0063\">https://doi.org/10.24928/2017/0063</a><br>2. Mu&ntilde;oz, A. , Laurent, J. &amp; Dierks, C. 2019, \'Team Health: A Measured Approach to Collective Learning\' In:, Proc. 27th Annual Conference of the International Group for Lean Construction (IGLC). Dublin, Ireland, 3-5 Jul 2019. pp 191-202. <a href=\"https://doi.org/10.24928/2019/0245\">https://doi.org/10.24928/2019/0245</a><br>3. Laurent, J. E. &amp; Leicht, R. M. 2019, &lsquo;Practices for Designing Cross-Functional Teams for Integrated Project Delivery&rsquo; In: ASCE, Journal of Construction Engineering and Management. Volume 145 Issue 3 &ndash; March 2019. <a href=\"https://doi.org/10.1061/(ASCE)CO.1943-7862.0001605\">https://doi.org/10.1061/(ASCE)CO.1943-7862.0001605</a><br>4. Cleary, J.W., and Munoz, A. (2018). &ldquo;Reaping the Rewards of Production Tracking&rdquo; In: Proc. 26th Annual Conference of the International Group for Lean Construction (IGLC), Gonz&aacute;lez, V.A. (ed.), Chennai, India, pp. xx&ndash;xx. DOI: <a href=\"https://doi.org/10.24928/2018/0494\">https://doi.org/10.24928/2018/0494</a>.</p>\r\n</div>\r\n</article>\r\n</main></div>\r\n</div>\r\n</div>\r\n</div>', '2022-09-24', '2022-12-03', '5689000', 'Started', '202209241055crane-data.jpg', '2022-09-24 07:55:36', '2022-09-24 07:55:36'),
(3, 'Church Building Construction', '<p>Church Building Construction</p>', '2022-09-30', '2022-10-28', '20000000', 'Ongoing', '202209241126download.jpg', '2022-09-24 08:26:01', '2022-09-24 08:26:01');

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

--
-- Table structure for table `reports`
--

CREATE TABLE `reports` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `tracking_id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `category` varchar(255) DEFAULT NULL,
  `comments` varchar(255) DEFAULT NULL,
  `paid` varchar(10) DEFAULT NULL,
  `amount` decimal(28,4) DEFAULT NULL,
  `gateway` varchar(255) DEFAULT NULL,
  `sender` varchar(255) DEFAULT NULL,
  `receiver` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `cname` varchar(255) DEFAULT NULL,
  `cperson` varchar(255) DEFAULT NULL,
  `ccountry` varchar(255) DEFAULT NULL,
  `cphone` varchar(255) DEFAULT NULL,
  `cemail` varchar(255) DEFAULT NULL,
  `cwebsite` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `feedback` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `reports`
--

INSERT INTO `reports` (`id`, `user_id`, `tracking_id`, `name`, `email`, `phone`, `address`, `city`, `country`, `category`, `comments`, `paid`, `amount`, `gateway`, `sender`, `receiver`, `date`, `cname`, `cperson`, `ccountry`, `cphone`, `cemail`, `cwebsite`, `status`, `feedback`, `created_at`, `updated_at`) VALUES
(1, NULL, 153566804, 'Enock Monyancha', 'enocmonyancha@gmail.com', '+254601552566', 'Teleview', 'Eldoret', 'Kenya', 'Crypto Scam', 'I was scammed', 'Yes', 5000.0000, 'Cryptocurrency (eg. Bitcoin)', 'asdfsdfsdfdsfdsfsdfsd', 'kjhkljljklkghjkljhkljklhjkljk', '2022-11-01', 'Sasasoft Tech', 'Erick Momanyi', 'Nairobi, Kenya', '07825562321', 'info@sasasoft.com', 'www.sasasoft.com', 'Pending', 'monyancha is good', '2022-11-08 10:40:44', '2024-07-07 09:18:34'),
(2, NULL, 83070498, 'Cynthia Nyaranda', 'enock@gmail.com', '0799117020', 'Elgonview', 'Eldoret', 'Kenya', 'Job, investment, money-making opportunity, franchise scam', 'I was scammed through work', 'Yes', 1000.0000, 'Cheque', 'sdhfjsdjfsdjfhj', 'sdsjdhsjdfhsj', '2022-11-03', 'Safaricom', 'Charles Muga', 'Riftvalley', '0798534258', 'info@saf.com', 'www.saf.com', 'Completed', NULL, '2022-11-08 12:36:06', '2022-11-08 15:11:05'),
(3, NULL, 134888026, 'Maggy Achiloma', 'maggy@gmail.com', '07456236986', 'Kakamega', 'Kakamega', 'Kenya', 'Auto sale, repair', 'Describe what happened.', 'Yes', 100.0000, 'Bank Wire Transfer', 'werwerewrwer', 'mbnmbnmbnmbnm', '2022-11-02', 'Poly Pro', 'Samuel', 'Kenya', '07866325663', 'poly@gmail.com', 'www.poly.com', 'Pending', 'Waiting for Review', '2022-11-08 15:17:59', '2022-11-08 15:17:59'),
(4, NULL, 5028442, 'enock', 'enocmonya@gmail.com', '+35845899', 'ertert', 'errtiu', 'kerituiu', 'Sweepstakes, prize, lottery', 'ruwerfrhguerghu', 'Yes', 45645.0000, 'Money Order', '475698589', '945869458', '2024-04-17', 'etueirutieru', 'itueirtiui', 'irutieirtui', '34895683968', 'urwtuiu@gmail.com', 'https://sdfhsdkg.com', 'Pending', 'Waiting for Review', '2024-04-17 11:00:13', '2024-04-17 11:00:13'),
(5, NULL, 56011469, 'Mary Lusanda', 'maryanthon28@gmail.com', '‪+27 71 165 5883‬', 'Komani', 'Eastern cape qeenstown', 'South Africa', 'Crypto Scam', 'I invested my capital in the company and I didn’t get paid of my profits and capital', 'Yes', NULL, 'Cryptocurrency (eg. Bitcoin)', 'TQJwyRA3vscB8J7zCtCv8Gmi6Qt2migPw7', '0xe8869Db87053637Bd9168cF6DAb8D2a13597A581', '2023-04-01', 'Neurocapital/david', 'David Martin', 'United Kingdom', '+447398298988', 'Neurocapitallimited@gmail.com', 'Neurocapital.com', 'Pending', 'Waiting for Review', '2024-04-17 11:19:19', '2024-04-17 11:19:19');

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

--
-- Table structure for table `scholarships`
--

CREATE TABLE `scholarships` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `details` longtext DEFAULT NULL,
  `amount` int(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `closing_date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `scholarships`
--

INSERT INTO `scholarships` (`id`, `title`, `details`, `amount`, `image`, `closing_date`, `created_at`, `updated_at`) VALUES
(1, 'Alumni Scholarship 2022', '<p>Alumni Scholarship 2022</p>', 2000000, '20220924161549141526668_ea9e08b8d2_c.jpg', '2022-10-30', '2022-09-24 13:15:38', '2022-09-24 13:15:38'),
(2, 'Scholarship for needy Students', '<p>Scholarship for needy Students</p>', 3900000, '202209241637Commencement-Exercise-UEAB-40th-Graduation.jpg', '2022-11-30', '2022-09-24 13:37:39', '2022-09-24 13:37:39');

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

--
-- Table structure for table `students`
--

CREATE TABLE `students` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `amount` int(11) DEFAULT 0,
  `status` varchar(255) DEFAULT NULL,
  `story` longtext DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `students`
--

INSERT INTO `students` (`id`, `user_id`, `amount`, `status`, `story`, `image`, `created_at`, `updated_at`) VALUES
(1, 1, 50000, 'Pending', '<p>I need help to pay my school fees</p>', '202209241352download.jpg', '2022-09-24 10:52:20', '2022-09-24 10:52:20'),
(2, 1, 25000, 'Pending', '<p>My first semester fees</p>', '202209241431297443519_169501305638285_9205890501749680034_n.png', '2022-09-24 11:31:38', '2022-09-24 11:31:38'),
(3, 1, 3000, 'Pending', '<p>School graduation clearance fees</p>', '20220924143249141493883_1577faa745_c.jpg', '2022-09-24 11:32:56', '2022-09-24 11:32:56');

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

--
-- Table structure for table `support_attachments`
--

CREATE TABLE `support_attachments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `support_message_id` int(10) UNSIGNED DEFAULT NULL,
  `attachment` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `support_messages`
--

CREATE TABLE `support_messages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `support_ticket_id` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `message` longtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `support_messages`
--

INSERT INTO `support_messages` (`id`, `support_ticket_id`, `admin_id`, `message`, `created_at`, `updated_at`) VALUES
(1, 1, 0, 'Hi,\r\n\r\nI was just browsing your website and I came up with a great plan to re-develop your website using the latest technology to generate additional revenue and beat your opponents. wealthpromax.com\r\n\r\nI\'m an excellent web developer capable of almost anything you can come up with, and my costs are affordable for nearly everyone.\r\n\r\nI would be happy to send you \"Quotes\", “Proposal” Past work Details, \"Our Packages\", and “Offers”!\r\n\r\nThanks in advance,\r\nNishant (Business Development Executive)', '2024-04-07 11:41:18', '2024-04-07 11:41:18'),
(2, 2, 0, 'Hello,\r\n\r\nUpon reviewing your website, I\'ve noticed that it lacks many functionalities and features that could greatly benefit your business and enhance the user experience for  your visitors. Additionally, I attempted to find your website using relevant keywords, but it did not appear in Google search results. This is likely due to a lack of SEO (search engine optimization). As a result, your website intially achieve.\r\n\r\nLet\'s schedule a phone call to discuss these matters in detail. I\'m confident that we can resolve these issues within a few weeks. Please reply to this email with your time availability, phone number, time zone you follow and i will call accordingly.\r\n\r\nThank you,\r\nHarvey Miller', '2024-04-08 23:56:54', '2024-04-08 23:56:54'),
(3, 3, 0, 'Hello financiapluse.com Team,\r\n\r\nI would like to talk about your website SEO!\r\n\r\nI can assist you in gaining more leads and sales from your website and getting it to appear on Google\'s top page. \r\n\r\n If interested, May I send you a price & quote?\r\n\r\nThanks,\r\nNitin Chaudhary\r\nInternational SEO Project Manager\r\nEmail:- rankinghat9@gmail.com\r\nContact Number:- +1- (209) 813-5119\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nIf you don’t want me to contact you again about this, reply with “opt-out”', '2024-04-09 09:46:40', '2024-04-09 09:46:40'),
(4, 4, 0, 'Hello wealthpromax.com,\r\n\r\nI would like to discuss SEO!\r\n\r\nI can help your website to get on first page of Google and increase the number of leads and sales you are getting from your website.\r\n\r\nMay I send you a quote & price list?\r\n\r\nThanks & Regards,\r\nPaul S\r\nSr SEO consultant\r\nwww.Letsgetuoptimize.com\r\nPh. No: 949-313-8897 (USA)\r\n\r\n\r\n\r\n\r\n\r\nIf you don’t want me to contact you again about this, reply with “opt-out”', '2024-04-11 11:23:24', '2024-04-11 11:23:24'),
(5, 5, 0, 'Hi,\r\n\r\nI found your details on Google.com and I have looked at your website and realized your website has great design but your website ranking is not good on all search engines Google, AOL, Yahoo and Bing.\r\n\r\nOur main focus will be to help generate more sales & online traffic.\r\n\r\nWe can place your website on Google\'s 1st page. We will improve your website’s position on Google and get more traffic.\r\n\r\nIf interested, kindly provide me your name, phone number, and email.\r\n\r\nYour sincerely,\r\nDenis', '2024-04-11 11:36:14', '2024-04-11 11:36:14'),
(6, 6, 0, 'Hi,\r\n\r\nI found your details on Google.com and I have looked at your website and realized your website has great design but your website ranking is not good on all search engines Google, AOL, Yahoo and Bing.\r\n\r\nOur main focus will be to help generate more sales & online traffic.\r\n\r\nWe can place your website on Google\'s 1st page. We will improve your website’s position on Google and get more traffic.\r\n\r\nIf interested, kindly provide me your name, phone number, and email.\r\n\r\nYour sincerely,\r\nDenis', '2024-04-11 11:36:14', '2024-04-11 11:36:14'),
(7, 7, 0, 'Hello financiapluse.com,\r\n\r\nI would like to discuss SEO!\r\n\r\nI can help your website to get on first page of Google and increase the number of leads and sales you are getting from your website.\r\n\r\nMay I send you a quote & price list?\r\n\r\nThanks & Regards,\r\nPaul S\r\nSr SEO consultant\r\nwww.Letsgetuoptimize.com\r\nPh. No: 949-313-8897 (USA)\r\n\r\n\r\n\r\n\r\n\r\nIf you don’t want me to contact you again about this, reply with “opt-out”', '2024-04-12 17:27:58', '2024-04-12 17:27:58'),
(8, 8, 0, 'Hi Team wealthpromax.com, \r\n \r\nI was looking at your website and realized that despite having a great design; it was not ranking high on any of the search engines (Google, Yahoo & Bing) for most of the keywords related to your business.\r\n\r\nWe can place your website on Google\'s 1st page.\r\n\r\n✓ Top ranking on Google search!\r\n✓ Improve website traffic!\r\n✓ Increase Your Leads, Sales & Revenue!\r\n\r\nIf you are interested, I will send you our SEO Packages and Cost.\r\n \r\nRegards,\r\nDenis S\r\nSr SEO consultant\r\nwww.Increaseorganictraffic.com\r\nPh. No: 1-804-715-1479\r\n\r\n\r\n\r\nIf you don’t want me to contact you again about this, reply with “unsubscribe”', '2024-04-12 19:35:39', '2024-04-12 19:35:39'),
(9, 9, 0, 'Winston here from Iowa. I\'m always watching to see what newer sites are going up and I just wanted to see if you would like an extra hand with getting some targeted traffic, create videos/images/adcopy, remove negative listings, the list goes on.  I\'ll even shoulder 90% of the costs, dedicating my time and tools that I\'ve created myself and bought over the years.  I\'ve been doing this for over 22 years, helped thousands of people and have loved every minute of it.\r\n\r\nThere\'s virtually no cost on my end to do any of this for you except for my time starting at 99 a month. I don\'t mean to impose; I was just curious if I could lend a hand.  \r\n\r\nBrief history, I\'ve been working from home for a couple decades now and I love helping others.  I\'m married, have three girls and if I can provide for them by helping you and giving back by using the tools and knowledge I\'ve built and learned over the years, I can\'t think of a better win-win.\r\n\r\nIt amazes me that no one else is helping others quite like I do and I\'d love to show you how I can help out.  So, if you need any extra help in any way, please let me know either way as I value your time and don\'t want to pester you.\r\n\r\nPS – If I didn’t mention something you might need help with just ask, I only mentioned a handful of things to keep this brief :-)\r\n\r\n\r\nAll the best,\r\n\r\nWinston\r\nCell - 1-319-435-1790‬\r\nMy Site (w/Live Chat) - https://cutt.ly/ww91SRIU', '2024-04-13 03:47:08', '2024-04-13 03:47:08'),
(10, 10, 0, 'hello', '2024-04-13 13:22:47', '2024-04-13 13:22:47'),
(11, 11, 0, 'hello', '2024-04-13 13:23:45', '2024-04-13 13:23:45'),
(12, 12, 0, 'hello', '2024-04-13 13:26:45', '2024-04-13 13:26:45'),
(13, 13, 0, 'hello', '2024-04-13 13:28:54', '2024-04-13 13:28:54'),
(14, 14, 0, 'hello', '2024-04-13 13:31:12', '2024-04-13 13:31:12'),
(15, 15, 0, 'hello', '2024-04-13 13:40:34', '2024-04-13 13:40:34'),
(16, 15, 0, 'abc', '2024-04-13 14:04:17', '2024-04-13 14:04:17'),
(17, 15, 0, 'kevin', '2024-04-13 14:04:31', '2024-04-13 14:04:31'),
(18, 16, 0, 'test', '2024-04-13 14:05:15', '2024-04-13 14:05:15'),
(19, 16, 0, 'test 2', '2024-04-13 14:05:25', '2024-04-13 14:05:25'),
(20, 16, 1, 'monyancha', '2024-04-16 18:42:25', '2024-04-16 18:42:25');

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

--
-- Table structure for table `support_tickets`
--

CREATE TABLE `support_tickets` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(10) DEFAULT 0,
  `name` varchar(40) DEFAULT NULL,
  `email` varchar(40) DEFAULT NULL,
  `ticket` varchar(40) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0: Open, 1: Answered, 2: Replied, 3: Closed',
  `priority` tinyint(1) NOT NULL DEFAULT 0 COMMENT '1 = Low, 2 = medium, 3 = heigh',
  `last_reply` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `support_tickets`
--

INSERT INTO `support_tickets` (`id`, `user_id`, `name`, `email`, `ticket`, `subject`, `status`, `priority`, `last_reply`, `created_at`, `updated_at`) VALUES
(15, 2, NULL, 'enock@gmail.com', '463798', 'hello', 2, 3, '2024-04-13 17:04:31', '2024-04-13 13:40:33', '2024-04-13 14:04:31'),
(16, 2, NULL, 'enock@gmail.com', '715300', 'test', 1, 3, '2024-04-16 21:42:25', '2024-04-13 14:05:15', '2024-04-16 18:42:25');

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

--
-- Table structure for table `wallets`
--

CREATE TABLE `wallets` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `logo` varchar(255) NOT NULL,
  `status` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `wallets`
--

INSERT INTO `wallets` (`id`, `name`, `logo`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Star Gazer', '202209201728star-asdf3d02912917a498193913941-1.jpg', 'Active', '2022-09-20 20:50:09', '2022-09-20 14:28:29'),
(2, 'Phantom', '202209201838phantom.jpeg', 'Active', '2022-09-20 15:38:42', '2022-09-20 15:38:42'),
(3, 'Trust', '2022092018398EC6357A-83EC-43AE-86A4-2B3849D96BC8.png', 'Active', '2022-09-20 15:39:39', '2022-09-20 15:39:39'),
(4, 'Binance Smart Chain', '202209201841A7426CE1-406F-47C9-96BF-7E3FE49B31F6.png', 'Active', '2022-09-20 15:41:19', '2022-09-20 15:41:19'),
(5, 'Blockchain', '202209201842651B8333-1A4C-439B-B917-D90345884799.png', 'Active', '2022-09-20 15:42:38', '2022-09-20 15:42:38'),
(6, 'Aktionariat', '202209201843CEF9F0C1-82EA-4627-8151-4D9689484FEE.png', 'Active', '2022-09-20 15:43:33', '2022-09-20 15:43:33'),
(7, 'Ledger', '202209201844AF7FF983-8AA6-4E7E-8E4F-1FBA5557BA9F.jpeg', 'Active', '2022-09-20 15:44:12', '2022-09-20 15:44:12'),
(8, 'Ellipal', '20220920184546F6BADE-FCC7-4931-AEA4-B86CC7E1D262.png', 'Active', '2022-09-20 15:45:13', '2022-09-20 15:45:13'),
(9, 'KEY RING PRO', '2022092018518FC6D1A7-CCAD-4BC3-A5E6-A3497B92C335.png', 'Active', '2022-09-20 15:51:28', '2022-09-20 15:51:28'),
(10, 'Coinbase', '20220920185575AD2CA5-E937-4A5E-ACE8-464B237E57E5.jpeg', 'Active', '2022-09-20 15:55:18', '2022-09-20 15:55:18'),
(11, 'Midas Wallet', '20220920185672FC1245-0092-45F2-BC4E-8B75CD742B77.png', 'Active', '2022-09-20 15:56:31', '2022-09-20 15:56:31');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `alumnis`
--
ALTER TABLE `alumnis`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `blogs`
--
ALTER TABLE `blogs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `ch_favorites`
--
ALTER TABLE `ch_favorites`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `ch_messages`
--
ALTER TABLE `ch_messages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `contributions`
--
ALTER TABLE `contributions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `donations`
--
ALTER TABLE `donations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `events`
--
ALTER TABLE `events`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `galleries`
--
ALTER TABLE `galleries`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `projects`
--
ALTER TABLE `projects`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `reports`
--
ALTER TABLE `reports`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `scholarships`
--
ALTER TABLE `scholarships`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `students`
--
ALTER TABLE `students`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `support_attachments`
--
ALTER TABLE `support_attachments`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `support_messages`
--
ALTER TABLE `support_messages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `support_tickets`
--
ALTER TABLE `support_tickets`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `wallets`
--
ALTER TABLE `wallets`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `alumnis`
--
ALTER TABLE `alumnis`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `blogs`
--
ALTER TABLE `blogs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `contributions`
--
ALTER TABLE `contributions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `donations`
--
ALTER TABLE `donations`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `events`
--
ALTER TABLE `events`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `galleries`
--
ALTER TABLE `galleries`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `projects`
--
ALTER TABLE `projects`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `reports`
--
ALTER TABLE `reports`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `scholarships`
--
ALTER TABLE `scholarships`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `students`
--
ALTER TABLE `students`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `support_attachments`
--
ALTER TABLE `support_attachments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `support_messages`
--
ALTER TABLE `support_messages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `support_tickets`
--
ALTER TABLE `support_tickets`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `wallets`
--
ALTER TABLE `wallets`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
COMMIT;

