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

START TRANSACTION;



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

--
-- Table structure for table `blog`
--

CREATE TABLE `blog` (
  `id` int(11) NOT NULL,
  `blog_title` varchar(300) NOT NULL,
  `blog_desc` varchar(300) NOT NULL,
  `blog_detail` varchar(2000) NOT NULL,
  `ufile` varchar(1000) NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `blog`
--

INSERT INTO `blog` (`id`, `blog_title`, `blog_desc`, `blog_detail`, `ufile`, `updated_at`) VALUES
(1, 'We provide the best digital services', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Impedit nihil tenetur minus quidem.', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Impedit nihil tenetur minus quidem est deserunt molestias accusamus harum ullam tempore debitis et, expedita, repellat delectus aspernatur neque itaque qui quod.Lorem ipsum dolor sit amet, consectetur adipisicing elit. Impedit nihil tenetur minus quidem est deserunt molestias accusamus harum ullam tempore debitis et, expedita, repellat delectus aspernatur neque itaque qui quod.Lorem ipsum dolor sit amet, consectetur adipisicing elit. Impedit nihil tenetur minus quidem est deserunt molestias accusamus harum ullam tempore debitis et, expedita, repellat delectus aspernatur neque itaque qui quod.Lorem ipsum dolor sit amet, consectetur adipisicing elit. Impedit nihil tenetur minus quidem est deserunt molestias accusamus harum ullam tempore debitis et, expedita, repellat delectus aspernatur neque itaque qui quod.Lorem ipsum dolor sit amet, consectetur adipisicing elit. Impedit nihil tenetur minus quidem est deserunt molestias accusamus harum ullam tempore debitis et, expedita, repellat delectus aspernatur neque itaque qui quod.', '', '2022-07-15 12:47:45'),
(2, 'We provide the best digital services', 'We provide the best digital servicesWe provide the best digital servicesWe provide the best digital services', 'We provide the best digital servicesWe provide the best digital servicesWe provide the best digital servicesWe provide the best digital servicesWe provide the best digital servicesWe provide the best digital servicesWe provide the best digital services', '60936059d354562031616499540.png', '2022-07-16 05:49:44');

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

--
-- Table structure for table `logo`
--

CREATE TABLE `logo` (
  `id` int(11) NOT NULL,
  `xfile` varchar(1000) NOT NULL,
  `ufile` varchar(1000) NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `logo`
--

INSERT INTO `logo` (`id`, `xfile`, `ufile`, `updated_at`) VALUES
(1, '8320logo_back_color.png', '681logo_back_white.png', '2025-09-17 01:06:34');

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

--
-- Table structure for table `portfolio`
--

CREATE TABLE `portfolio` (
  `id` int(11) NOT NULL,
  `port_title` varchar(500) NOT NULL,
  `port_desc` varchar(1000) NOT NULL,
  `port_detail` varchar(2000) NOT NULL,
  `ufile` varchar(1000) NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `portfolio`
--

INSERT INTO `portfolio` (`id`, `port_title`, `port_desc`, `port_detail`, `ufile`, `updated_at`) VALUES
(4, 'Game Shopping Center – Technology Audit (2022)', 'We audited and formatted all IT equipment at Game Shopping Center before its Ghana exit.', 'In 2022, Fihankra Technologies was contracted to manage the technology equipment audit of Game Shopping Center during its Ghana market exit. Our team handled system checks, formatting, and data management processes, ensuring a smooth and secure transition of assets. This project highlighted our expertise in IT infrastructure and professional auditing.', '7495game.jpg', '2025-09-17 02:08:57'),
(5, 'AAMUSTED Timetable Management System', 'We built and manage AAMUSTED’s digital timetable system, used daily across faculties.', 'Fihankra Technologies designed and implemented the official timetable management system for Akenten Appiah-Menka University of Skills Training and Entrepreneurial Development (AAMUSTED). The platform streamlines lecture scheduling, classroom allocations, and resource planning. Our team continues to manage, update, and provide technical support, ensuring efficiency in the university’s academic planning.', '3235aamusted.png', '2025-09-17 02:11:40'),
(6, 'Quick Change POS', 'We developed Quick Change POS, a fast, user-friendly retail and sales management system.', 'Quick Change POS is our proprietary Point of Sale system designed for retail businesses. It provides real-time inventory tracking, sales management, and reporting features. With its simple interface and offline capability, the software supports small and medium enterprises in handling transactions efficiently.', '3646quick.png', '2025-09-17 02:49:43'),
(7, 'Cast Ghana – Event Management Platform', 'We own Cast Ghana, a platform for event ticketing, voting, and pageantry management.', 'Cast Ghana is a flagship innovation by Fihankra Technologies. The platform empowers event organizers to create events, manage ticket sales, conduct voting for awards and pageants, and even hire event-related services. With built-in scalability and mobile support, Cast Ghana is revolutionizing how events are managed in Ghana and across Africa.', '9332cast_ghana.jpg', '2025-09-17 02:50:17');

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

--
-- Table structure for table `section_title`
--

CREATE TABLE `section_title` (
  `id` int(11) NOT NULL,
  `about_title` varchar(500) NOT NULL,
  `about_text` varchar(1000) NOT NULL,
  `why_title` varchar(500) NOT NULL,
  `why_text` varchar(1000) NOT NULL,
  `service_title` varchar(500) NOT NULL,
  `service_text` varchar(1000) NOT NULL,
  `port_title` varchar(500) NOT NULL,
  `port_text` varchar(1000) NOT NULL,
  `test_title` varchar(500) NOT NULL,
  `test_text` varchar(1000) NOT NULL,
  `contact_title` varchar(500) NOT NULL,
  `contact_text` varchar(1000) NOT NULL,
  `enquiry_title` varchar(500) NOT NULL,
  `enquiry_text` varchar(1000) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `section_title`
--

INSERT INTO `section_title` (`id`, `about_title`, `about_text`, `why_title`, `why_text`, `service_title`, `service_text`, `port_title`, `port_text`, `test_title`, `test_text`, `contact_title`, `contact_text`, `enquiry_title`, `enquiry_text`) VALUES
(1, 'We Build Ideas Into Solutions', 'Fihankra Technologies is a forward-thinking tech company dedicated to software development, event management, and IT consulting. We craft innovative solutions tailored to meet business challenges while driving digital growth and efficiency.', 'Innovation You Can Trust', 'We blend creativity, technical expertise, and reliability to deliver solutions that make an impact. Choosing us means partnering with a team committed to quality, innovation, and your success.', 'Solutions That Drive Growth', 'Our services cover custom software development, event management platforms, and IT consulting. We provide tailored digital solutions designed to help you grow, scale, and stay competitive.', 'Our Recent Works', 'We have successfully built impactful solutions like Cast Ghana (event management), Quick Change POS, and the AAMUSTED Timetable System. Each project reflects our commitment to innovation and results.', 'Trusted By Our Clients', 'Clients choose us for reliable technology and real results. Their feedback highlights our dedication to excellence, innovation, and customer satisfaction in every project we deliver.', 'Let’s Work Together', 'Partner with Fihankra Technologies for your next project. Reach out today, and let’s create innovative solutions that drive your business forward.', 'Share Your Vision With Us', 'Have an idea, question, or project in mind? Send us your enquiry, and our team will provide customized solutions to bring your vision to life.');

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

--
-- Table structure for table `service`
--

CREATE TABLE `service` (
  `id` int(11) NOT NULL,
  `service_title` varchar(500) NOT NULL,
  `service_desc` varchar(1000) NOT NULL,
  `service_detail` varchar(2000) NOT NULL,
  `ufile` varchar(1000) NOT NULL,
  `upadated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `service`
--

INSERT INTO `service` (`id`, `service_title`, `service_desc`, `service_detail`, `ufile`, `upadated_at`) VALUES
(5, 'Software Development', 'We create reliable web, mobile, and desktop software solutions that help businesses grow and stay ahead.', 'At Fihankra Technologies, we specialize in delivering innovative software that solves real-world problems. From mobile and web applications to enterprise systems, we build scalable, secure, and user-friendly solutions that empower businesses and individuals. Our development process includes consultation, design, testing, and continuous improvement to ensure our clients always stay ahead of the curve.', '5390dev.webp', '2025-09-17 01:42:54'),
(6, 'IT Consulting & Training', 'We guide businesses in adopting the right technologies and train teams with modern digital and tech skills.', 'Our IT consulting services guide organizations in implementing efficient and cost-effective technology strategies. Whether it\'s infrastructure setup, cybersecurity, or workflow automation, we provide hands-on guidance to achieve results. Additionally, our training programs empower students, professionals, and organizations with practical knowledge in programming, AI, cloud computing, and emerging technologies.', '6375tranning.jpg', '2025-09-17 01:43:26'),
(7, 'General Event Management', 'We plan and manage events of all kinds, with our Cast Ghana platform making voting and ticketing easy.', 'From corporate events to award shows, Fihankra Technologies manages every detail to perfection. Through our flagship platform, Cast Ghana, we simplify event creation, ticket sales, voting systems, and pageantry management. Our goal is to blend innovation with cultural relevance, ensuring every event leaves a lasting impact.', '9091event.jpg', '2025-09-17 01:45:37'),
(8, 'Sales & Hiring of Event Materials', 'We provide quality event equipment for hire or sale, including sound, tents, lighting, and stage setups.', 'In addition to event planning, we provide a wide range of event management materials for sale and hire. Our inventory includes sound systems, lighting equipment, projectors, tents, chairs, decorations, and stage setups. With reliable delivery and setup services, clients can focus on the success of their event while we handle the logistics.', '9347sales.webp', '2025-09-17 01:44:36');

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

--
-- Table structure for table `siteconfig`
--

CREATE TABLE `siteconfig` (
  `id` int(11) NOT NULL,
  `site_keyword` varchar(1000) NOT NULL,
  `site_desc` varchar(500) NOT NULL,
  `site_title` varchar(300) NOT NULL,
  `site_about` varchar(1000) NOT NULL,
  `site_footer` varchar(1000) NOT NULL,
  `follow_text` varchar(1000) NOT NULL,
  `site_url` varchar(50) NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `siteconfig`
--

INSERT INTO `siteconfig` (`id`, `site_keyword`, `site_desc`, `site_title`, `site_about`, `site_footer`, `follow_text`, `site_url`, `updated_at`) VALUES
(1, 'Fihankra Technologies , Software Development in Ghana,  Event Management Platform,  IT Consulting Services , Digital Transformation,  Custom Software Solutions,  Tech Startup Ghana,  Event Ticketing & Voting Platform , Business IT Solutions ,Technology Innovation', 'Fihankra Technologies is a Ghana-based tech company specializing in custom software development, event management platforms, and IT consulting services. We deliver innovative digital solutions that empower businesses, organizations, and individuals to thrive in today’s competitive technology-driven world.', 'Fihankra Tech', 'Fihankra Technologies is a trusted partner in software innovation, event management solutions, and IT consulting. We combine creativity and technology to deliver results that drive growth and success.', '� 2025 All Rights Reserved', '👉 Stay connected with Fihankra Technologies!\r\nFollow us for the latest updates, innovations, and tech insights.', 'https://fihankratech.com/', '2025-09-16 21:58:50');

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

--
-- Table structure for table `sitecontact`
--

CREATE TABLE `sitecontact` (
  `id` int(11) NOT NULL,
  `phone1` varchar(150) NOT NULL,
  `phone2` varchar(150) NOT NULL,
  `email1` varchar(100) NOT NULL,
  `email2` varchar(100) NOT NULL,
  `longitude` varchar(100) NOT NULL,
  `latitude` varchar(150) NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `sitecontact`
--

INSERT INTO `sitecontact` (`id`, `phone1`, `phone2`, `email1`, `email2`, `longitude`, `latitude`, `updated_at`) VALUES
(1, '+233 24 848 5308', '+233 50 835 4270', 'platform@fihankratech.com', 'info@fihankratech.com ', '6.795292283464297', '-1.5706982034020185', '2025-09-16 21:29:57');

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

--
-- Table structure for table `slider`
--

CREATE TABLE `slider` (
  `id` int(11) NOT NULL,
  `slide_title` varchar(150) NOT NULL,
  `slide_text` varchar(500) NOT NULL,
  `ufile` varchar(1000) NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `slider`
--

INSERT INTO `slider` (`id`, `slide_title`, `slide_text`, `ufile`, `updated_at`) VALUES
(2, 'Building Smarter Software', 'From custom applications to enterprise platforms, we deliver scalable and innovative software solutions tailored to your business.', '2158computer-programmers-colocation-ibm-software-engineering-programmer-software-developer-software-development-collaboration-classroom-location-removebg-preview.png', '2025-09-16 22:16:44'),
(3, 'Powering Events with Technology', 'Manage, organize, and grow your events with our Cast Ghana platform and event solutions — designed to simplify ticketing, voting, and engagement.', '626501-FullServiceEventManagement.png', '2025-09-16 22:21:14'),
(4, 'Reliable IT Consulting', 'We guide businesses with expert IT strategies to improve efficiency, security, and digital transformation.', '1848Consulting-Overview-removebg-preview.png', '2025-09-16 22:25:53');

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

--
-- Table structure for table `social`
--

CREATE TABLE `social` (
  `id` int(11) NOT NULL,
  `name` varchar(150) NOT NULL,
  `fa` varchar(150) NOT NULL,
  `social_link` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `static`
--

CREATE TABLE `static` (
  `id` int(11) NOT NULL,
  `stitle` varchar(150) NOT NULL,
  `stext` varchar(500) NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `static`
--

INSERT INTO `static` (`id`, `stitle`, `stext`, `updated_at`) VALUES
(1, 'Driving Innovation, Creating Impact', 'At Fihankra Technologies, we combine creativity, technology, and expertise to deliver solutions that transform ideas into success stories.', '2025-09-16 22:12:08');

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

--
-- Table structure for table `testimony`
--

CREATE TABLE `testimony` (
  `id` int(11) NOT NULL,
  `message` varchar(300) NOT NULL,
  `name` varchar(150) NOT NULL,
  `position` varchar(100) NOT NULL,
  `ufile` varchar(1000) NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `why_us`
--

CREATE TABLE `why_us` (
  `id` int(11) NOT NULL,
  `title` varchar(200) NOT NULL,
  `detail` varchar(500) NOT NULL,
  `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `why_us`
--

INSERT INTO `why_us` (`id`, `title`, `detail`, `updated_on`) VALUES
(7, 'Client-Centered Approach', 'Your success is our priority. We listen, understand your needs, and tailor solutions that drive measurable results.', '2025-09-17 01:17:09'),
(8, 'Innovation You Can Trust', 'We blend creativity with cutting-edge technology, ensuring every project is not just modern but also impactful and sustainable.', '2025-09-17 01:17:20'),
(9, 'Proven Expertise', 'We combine years of hands-on experience in software development, event management, and IT consulting to deliver reliable, future-ready solutions.', '2025-09-17 01:18:45');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

