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

START TRANSACTION;



--
-- Database: `valoores_web`
--

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

--
-- Table structure for table `banking_application`
--

CREATE TABLE `banking_application` (
  `id` int(11) NOT NULL,
  `class` longtext NOT NULL,
  `style` longtext NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` longtext NOT NULL,
  `video` longtext NOT NULL,
  `more` longtext NOT NULL,
  `quick` longtext NOT NULL,
  `demo` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `banking_application`
--

INSERT INTO `banking_application` (`id`, `class`, `style`, `title`, `description`, `video`, `more`, `quick`, `demo`) VALUES
(1, '', '', 'in\'AML', 'in\'AML solution provides an enterprise platform enabling efficient detection, investigation, and reporting of suspected money laundering and terrorist financing activity. It helps financial institutions tackle risk & compliance problems.', 'BQc6a9XEvKc', 'https://banking.valoores.com/aml.php', 'https://demo.valoores.com/valooresdashboards/', 'https://banking.valoores.com/requestdemo.php'),
(2, '', '', 'in\'Profit', 'in\'Profit solution drives a company\'s profitability. Rich, intelligent & compliant to international standards are in\'Profit\'s bread and butter. Instant decision making tool with wide range of analytics.', 'mdfYKS5bRio', 'https://banking.valoores.com/inprofit.php', 'https://demo.valoores.com/valooresdashboards/', 'https://banking.valoores.com/requestdemo.php'),
(3, '', '', 'in\'IFRS9', 'in\'IFRS9 solution is built on a logical, single classification and measurement approach for financial assets. It will accommodate you to cope with the new tsunami of Compliance, Regulations and Risk Management in 2018.', '-8cjAawAoac', 'https://banking.valoores.com/inprofit.php', 'https://demo.valoores.com/valooresdashboards/', 'https://banking.valoores.com/requestdemo.php'),
(4, '', '', 'in\'Crypto', 'Crypto Compliance Management System emerges as a pivotal necessity, offering an innovative solution with groundbreaking technology that harnesses geospatial data. This system stands at the forefront in the relentless battle against financial crimes linked to cryptocurrencies.', '-8cjAawAoac', '/banking/feature?page=crypto', 'https://demo.valoores.com/valooresdashboards/', 'https://banking.valoores.com/requestdemo.php');

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

--
-- Table structure for table `banking_carousel`
--

CREATE TABLE `banking_carousel` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` longtext NOT NULL,
  `position` longtext NOT NULL,
  `link` longtext NOT NULL,
  `button` varchar(255) NOT NULL,
  `document` longtext NOT NULL,
  `class` longtext NOT NULL,
  `img_style` longtext NOT NULL,
  `text_style` longtext NOT NULL,
  `orders` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `banking_sections`
--

CREATE TABLE `banking_sections` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` longtext NOT NULL,
  `text_container` longtext NOT NULL,
  `img_container` longtext NOT NULL,
  `orders` int(11) NOT NULL,
  `class` longtext NOT NULL,
  `type` longtext NOT NULL,
  `link` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `banking_sections`
--

INSERT INTO `banking_sections` (`id`, `title`, `description`, `text_container`, `img_container`, `orders`, `class`, `type`, `link`) VALUES
(1, '<span>About Us</span>', 'VALOORES is one of the global leading providers of Enterprise Management & Decision Making solutions. Established in 1989, VALOORES operates in ten countries. We are a world class company providing products and services to global Mega Tier 1 enterprises.', 'video_player-container', 'content__title', 1, 'container mt-5 intro_container', 'intro', 'https://demo.valoores.com/valooresdashboards/'),
(2, '<h4>Why Choosing VALOORES in\'Banking?</h4>', '<p>The search for a better BI solution stops here. At VALOORES, our objective is to provide you with the only Dashboard, Business Intelligence and Analytics Solutions you\'ll need for your business. With VALOORES\' powerful and intuitive BI and Analytics Solutions, you stay connected to your data wherever you are in the world with our technology. Our highly incorporated BI solution optimizes the usage of the large data transforming it into readable, reliable and relevant information. Engage with your peers and your customers. Share your data with just a click using our advanced Dashboard solutions. VALOORES solutions are designed with you in mind, for real people using real data making important business decisions that will positively impact growth and overall performance of organizational results. We give you the right solutions to bring you intuitive, intelligent, sharable information to keep you two steps ahead of the competition.</p>', 'col-md-7', 'col-md-5', 2, 'container choice_content', 'choice', ''),
(3, '<h3>Our Featured Applications</h3>', '<h5>VALOORES Online & Offline Demos</h5>', 'd-flex align-items-center justify-content-around flex-row text-center', 'row text-center d-flex flex-column align-items-center justify-content-center', 3, '', 'application', ''),
(4, '<h2> Powerful Dashboard Visualizations </h2>', 'Learn More', 'row d-flex flex-column align-items-center justify-content-center text-center text-white w-100 p-5', 'dashboard_container-bg d-flex align-items-center justify-content-center', 4, '', 'paralax', 'https://banking.valoores.com/portalbi.php'),
(5, '<h2>You have the VALUE, we bring you the ADDED VALUE. it\'s VALOORES!</h2>', 'Contact Us', 'row d-flex flex-column align-items-center justify-content-center text-center text-white w-100 p-5', 'dashboard_container-bg d-flex align-items-center justify-content-center', 5, '', 'paralax2', 'https://banking.valoores.com/portalbi.php');

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

--
-- Table structure for table `banking_slider`
--

CREATE TABLE `banking_slider` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` longtext NOT NULL,
  `header` longtext NOT NULL,
  `link` longtext NOT NULL,
  `style` longtext NOT NULL,
  `class` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `banking_slider`
--

INSERT INTO `banking_slider` (`id`, `title`, `description`, `header`, `link`, `style`, `class`) VALUES
(1, '<h1 class=\"w-75\">in\'Risk Compliance<br></h1>', '<p>VALOORES in\'Risk Compliance helps you reach your goals, to allow your organization to be fully prepared for unpredictable events.</p>', 'in\'Risk Compliance', '/banking/feature?page=risk-and-compliance', '', ''),
(2, '<h1 class=\"w-75\">in\'Profit<br></h1>', '<p>VALOORES in\'Profit drives a company\'s profitability. Rich, intelligent &amp; compliant to international standards are in\'Profit\'s bread and butter.</p>', 'in\'Profit', '/banking/feature?page=inprofit', '', ''),
(3, '<h1 class=\"w-75\">in\'Data Governance<br></h1>', '<p>With the popularity of implementing business intelligence (BI) applications, it is vital for Banks and Financial Institutions to manage the Master Data Management (MDM) in order to offer a consistent and centralized view of the data across the enterprise\'s systems.</p>', 'in\'Data', '/banking/feature?page=indatagovernance', '', ''),
(4, '<h1 class=\"w-75\">in\'Marketing Optimization<br></h1>', '<p>Get the flexibility you need to keep up with evolving customer expectations, demographics, and demand with VALOORES in\'Campaign, in\'Pricing &amp; in\'Deals.</p>', 'in\'Marketing', '/banking/feature?page=marketing-optimization', '', ''),
(5, '<h1 class=\"w-75\">in\'Analytics<br></h1>', '<p>Predictive analytics and forecasting are becoming more essential for organizations due to high competitive markets.</p>', 'Analytics', '/analytics', 'Analytics', ''),
(6, '<h1 class=\"w-75\">in\'Kernel<br></h1>', '<p>VALOORES in\'Kernel lets you manage the workforce, fortify diversity, automate processes while maintaining task traceability to reinforce accountability.</p>', 'in\'Kernel', '/banking/feature?page=inkernel', 'Analytics', ''),
(7, '<h1 class=\"w-75\">in\'Payment Services<br></h1>', '<p>VALOORES in\'Payment is a complete payment and receipt processing solution that enables efficient, reliable and secure financial transactions. It lowers costs and improves control by integrating out-of-the-box with major processors and financial institutions.</p>', 'in\'Payment', '/banking/feature?page=financialservices', '', ''),
(8, '<h1 class=\"w-75\">in\'Asset Management<br></h1>', '<p>Offers solutions in middle-office and back-office functions enabling key capital market players like asset managers, custodians, broker/dealers, fund administrators to retain competitive advantage in a dynamic market environment.</p>', 'in\'Asset', '/banking/feature?page=inassetmanagement', '', ''),
(9, '<h1 class=\"w-75\">in\'Cards Merchant<br></h1>', '<p>VALOORES in\'Cards Merchant is a single solution for all your card management activities. From forecasting issuance and fulfilment to file management and reporting.</p>', 'in\'Cards', '/banking/feature?page=cardsmerchant', '', '');

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

--
-- Table structure for table `carousel`
--

CREATE TABLE `carousel` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `link` varchar(255) NOT NULL,
  `position` varchar(255) NOT NULL,
  `class` varchar(255) NOT NULL,
  `orders` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `carousel`
--

INSERT INTO `carousel` (`id`, `title`, `description`, `link`, `position`, `class`, `orders`) VALUES
(14, '', 'We can\'t solve problems by using the same kind of thinking we used when we created them. The whole of science is nothing more than a refinement of everyday thinking. <br />         <span style={{ fontStyle: \'italic\' }}>~ Albert Einstein ~</span>', 'https://analytics.valoores.com/', 'slidePos', 'yes', 1),
(15, 'Geospatial<br /> For Public Sectors', 'Whether you\'re a small business owner<br /> or a multinational retail corporation,<br />Valoores Crowd Intelligence System is <br />your powerful tool for driving growth.', '/Geospatial', 'slideGeoPos', 'yes', 2),
(16, 'Geospatial<br /> For Private Sectors', 'We have gone beyond basic location data, which simply tells us where things are.', 'https://indatacrowd.valoores.com/', 'slidePos', 'yes', 3),
(17, 'Retail and Supply Chain', 'Valoores uses supply chain technologies and advanced retail services for responding to market needs.', 'https://retail.valoores.com/', 'slidePos', 'yes', 4),
(18, 'Artificial Intelligence', 'AI is the cornerstone of our software solutions at Valoores. It\'s essential across sectors like retail, finance, and government, addressing challenges, multitasking, and meeting consumer expectations in a rapidly evolving landscape.', '/ai', 'slideAiPos', 'yes', 5),
(19, 'in\'VCIS Technology & Data Management', 'Poor data quality can cost businesses millions, but Valoores can help mitigate risks and reduce overall costs.', 'https://indatacrowd.valoores.com/', 'slidePos', 'yes', 6),
(20, 'Big Data Isn\'t About<br /> Bits, But Talent.', 'A wealth of information<br /> creates a poverty of attention.<br /> With big data, comes big<br /> responsibility to derive insight,<br/> make decisions and drive value.', '', 'slideBigPos', 'yes', 7),
(21, 'Government', 'Valoores solutions facilitate the use of information and communication technologies to provide and improve public-sector services', 'https://gov.valoores.com/', 'slidePos', 'yes', 8),
(22, 'Financial Services', 'Valoores Delivers intelligent financial solutions and productivity-enhancing case management tools for financial institutions.', '/banking', 'slidePos', 'yes', 9),
(23, '<div style={{ color: \'#001d6e\' }}>           Multichannel Communication & Multimedia         </div>', '<div style={{ color: \'#001d6e\' }}>           We offer a comprehensive suite of services that enable organizations to connect, captivate, and collaborate effectively in today\'s dynamic digital landscape.         </div>', 'https://multimedia.valoores.com/', 'slideMultiPos', 'yes', 10),
(24, '<div className=\'slide10Font\'>           VALOORES announces the           Next Generation v20 Ecosystem<br />           That marches at the same drum           with the latest Digital Transformation guidelines         </div>', '', 'https://valoores.com/v20.php', 'slideEcoPos', 'yes', 11),
(25, '<div style={{ fontSize: \'2.5rem\', lineHeight: \'2.8rem\', fontWeight: \"500\" }}>           You have the VALUE,<br />           we bring you the<br /> <span style={{}}>Added VALUE</span><br /><br />           it\'s VALOORES!         </div>', '', 'https://indatacrowd.valoores.com/', 'slidePos', 'no', 12);

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

--
-- Table structure for table `clients`
--

CREATE TABLE `clients` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `link` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `clients`
--

INSERT INTO `clients` (`id`, `name`, `link`) VALUES
(44, 'carrefour', 'https://www.carrefour.com'),
(45, 'qib', 'https://www.qib.com.qa'),
(46, 'bob', 'https://insurance.valoores.com/'),
(47, 'kafalat', 'https://kafalat.com.lb/'),
(48, 'fnac', 'https://fnac.com/'),
(49, 'cvs', 'https://www.cvs.com'),
(50, 'bdl', 'https://insurance.valoores.com/'),
(51, 'bobfinance', 'https://insurance.valoores.com/'),
(52, 'canadiantyre', 'https://www.canadiantire.ca/en.html'),
(53, 'fransa', 'https://www.fransabank.com/'),
(54, 'blf', 'https://www.eblf.com/'),
(55, 'abl', 'https://banking.valoores.com/');

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

--
-- Table structure for table `counter`
--

CREATE TABLE `counter` (
  `id` int(11) NOT NULL,
  `value` varchar(255) NOT NULL,
  `extension` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `counter`
--

INSERT INTO `counter` (`id`, `value`, `extension`, `title`) VALUES
(15, '30', '+', 'Leading The Market'),
(16, '500', '+', 'Members Worldwide'),
(17, '100', '+', 'Satisfied Clients'),
(18, '25', '+', 'Lines Of Busines');

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

--
-- Table structure for table `docs`
--

CREATE TABLE `docs` (
  `id` int(11) NOT NULL,
  `doc_name` longtext NOT NULL,
  `doc_name_ar` longtext DEFAULT NULL,
  `doc_desc` longtext NOT NULL,
  `doc_desc_ar` longtext DEFAULT NULL,
  `doc_type` longtext NOT NULL,
  `doc_path` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `docs`
--

INSERT INTO `docs` (`id`, `doc_name`, `doc_name_ar`, `doc_desc`, `doc_desc_ar`, `doc_type`, `doc_path`) VALUES
(1, 'ALM', NULL, 'ALM White Paper', NULL, 'White Paper', '../valoores_front/src/docs/almwhitepaper.pdf'),
(2, 'AML', NULL, 'AML', NULL, 'White Paper', '../valoores_front/src/docs/AML.pdf'),
(3, 'AML Cases', NULL, 'AML Cases', NULL, 'White Paper', '../valoores_front/src/docs/amlcases.pdf'),
(4, 'Analytics Applications And Project Lifecycle', NULL, 'Analytics Applications And Project Lifecycle_whitepaper 2017', NULL, 'White Paper', '../valoores_front/src/docs/analytics_applications_and_project_lifecycle_whitepaper2017.pdf'),
(5, 'Analytics Data Quality', NULL, 'Analytics Data Quality_white Paper_2017', NULL, 'White Paper', '../valoores_front/src/docs/analytics_data_quality_white_paper_2017.pdf'),
(6, 'Application Of Business Intelligence in The Banking Industry', NULL, 'Application Of Business Intelligence in The Banking Industry', NULL, 'White Paper', '../valoores_front/src/docs/Application-of-Business-Intelligence-in-the-Banking-Industry.pdf'),
(7, 'Loyalty in Retail Banking 2013', NULL, 'BAIN_REPORT Loyalty in Retail Banking 2013', NULL, 'White Paper', '../valoores_front/src/docs/BAIN_REPORT_Loyalty_in_Retail_Banking_2013.pdf'),
(8, 'Bank Regulations And Compliance', NULL, 'Bank Regulations And Compliance', NULL, 'White Paper', '../valoores_front/src/docs/bank-regulations-and-compliance.pdf'),
(9, 'BOB Factsheet', NULL, 'BOB_Factsheet', NULL, 'White Paper', '../valoores_front/src/docs/bob-factsheet.pdf'),
(11, 'BOB Valoores FPMS', NULL, 'BOB Valoores FPMS', NULL, 'White Paper', '../valoores_front/src/docs/bob-valoores-fpms.pdf'),
(13, 'Business Intelligence for Banking', NULL, 'Business Intelligence for Banking', NULL, 'White Paper', '../valoores_front/src/docs/business-intelligence-for-banking.pdf'),
(14, 'Business Intelligence Approaches To Key Business Factors In Banking', NULL, 'Business Intelligence Approaches To Key Business Factors In Banking', NULL, 'White Paper', '../valoores_front/src/docs/BusinessIntelligenceApproachesToKeyBusinessFactorsInBanking.pdf'),
(15, 'Cards Merchant', NULL, 'Cards Merchant', NULL, 'White Paper', '../valoores_front/src/docs/cardsmerchant.pdf'),
(16, 'Compliance-2020-Factsheet', NULL, 'Compliance-2020-Factsheet', NULL, 'White Paper', '../valoores_front/src/docs/compliance-2020-factsheet.pdf'),
(17, 'CRM-insurance', NULL, 'CRM-insurance', NULL, 'White Paper', '../valoores_front/src/docs/CRM-insurance.pdf'),
(18, 'Dashboard-Business Intelligence in Banking', NULL, 'Dashboard-Business Intelligence in Banking', NULL, 'White Paper', '../valoores_front/src/docs/dashboard-Business-Intelligence-in-Banking.pdf'),
(19, 'Dashboards', NULL, 'Dashboards', NULL, 'White Paper', '../valoores_front/src/docs/dashboards.pdf'),
(20, 'Data Exchange', NULL, 'Data Exchange', NULL, 'White Paper', '../valoores_front/src/docs/data-exchange.pdf'),
(21, 'Document Manager', NULL, 'Document Manager', NULL, 'White Paper', '../valoores_front/src/docs/document-manager.pdf'),
(22, 'Doha 2020 Conference Agenda', NULL, 'Doha 2020 Conference Agenda', NULL, 'White Paper', '../valoores_front/src/docs/Doha-2020-conference-agenda.pdf'),
(23, 'Economic & Financial Indicators- Training at the Association of Banks in Lebanon', NULL, 'Economic & Financial Indicators- Training at the Association of Banks in Lebanon', NULL, 'White Paper', '../valoores_front/src/docs/Economic & Financial Indicators- Training at the Association of Banks in Lebanon.pdf'),
(24, 'Enterprise Rating', NULL, 'Enterprise Rating', NULL, 'White Paper', '../valoores_front/src/docs/enterprise-rating.pdf'),
(25, 'EY Global Consumer Banking Survey 2014', NULL, 'EY Global Consumer Banking Survey 2014', NULL, 'White Paper', '../valoores_front/src/docs/EY-Global-Consumer-Banking-Survey-2014.pdf'),
(27, 'Factsheet In IRFP', NULL, 'Factsheet In IRFP', NULL, 'White Paper', '../valoores_front/src/docs/Factsheet-In-irfp.pdf'),
(28, 'FATCA - Valoores in\'Via', NULL, 'FATCA - Valoores in\'Via', NULL, 'White Paper', '../valoores_front/src/docs/FATCA - Valoores in\'Via.pdf'),
(29, 'FATCA', NULL, 'FATCA', NULL, 'White Paper', '../valoores_front/src/docs/FATCA.pdf'),
(30, 'Financial Ratios', NULL, 'Financial Ratios', NULL, 'White Paper', '../valoores_front/src/docs/Financial-Ratios.pdf'),
(31, 'Framework', NULL, 'Framework', NULL, 'White Paper', '../valoores_front/src/docs/framework.pdf'),
(33, 'FRR', NULL, 'FRR', NULL, 'White Paper', '../valoores_front/src/docs/FRR.pdf'),
(34, 'GRC insurance', NULL, 'GRC insurance', NULL, 'White Paper', '../valoores_front/src/docs/grc-insurance.pdf'),
(35, 'How Key Risk Indicators can Sharpen Focus on Emerging Risks', NULL, 'How Key Risk Indicators can Sharpen Focus on Emerging Risks', NULL, 'White Paper', '../valoores_front/src/docs/How-Key-Risk-Indicators-can-Sharpen-Focus-on-Emerging-Risks.pdf'),
(36, 'ICV', NULL, 'ICV', NULL, 'White Paper', '../valoores_front/src/docs/icv.pdf'),
(37, 'IFRS 9 Accounting and Reporting Effects on Banks_v0.2', NULL, 'IFRS 9 Accounting and Reporting Effects on Banks_v0.2', NULL, 'White Paper', '../valoores_front/src/docs/IFRS 9 Accounting and Reporting Effects on Banks_v0.2.pdf'),
(45, 'IFRS9', NULL, 'IFRS9', NULL, 'White Paper', '../valoores_front/src/docs/IFRS9.pdf'),
(46, 'In\'Cards Merchant', NULL, 'In\'Cards Merchant', NULL, 'White Paper', '../valoores_front/src/docs/in\'cards-Merchant.pdf'),
(47, 'In\'Debt And Recovery', NULL, 'In\'Debt And Recovery', NULL, 'White Paper', '../valoores_front/src/docs/In\'DebtAndRecovery.pdf'),
(48, 'in\'FC Enterprise Fraud Monitoring', NULL, 'in\'FC Enterprise Fraud Monitoring', NULL, 'White Paper', '../valoores_front/src/docs/in\'FC-Enterprise-Fraud-Monitoring.pdf'),
(49, 'in\'Payment Factsheet', NULL, 'in\'Payment Factsheet', NULL, 'White Paper', '../valoores_front/src/docs/in\'Payment-factsheet.pdf'),
(50, 'in\'Profit Enterprise Performance Management', NULL, 'in\'Profit Enterprise Performance Management', NULL, 'White Paper', '../valoores_front/src/docs/in\'Profit - Enterprise Performance Management (for publishing)pdf.pdf'),
(51, 'In\'ALM', NULL, 'In\'ALM', NULL, 'White Paper', '../valoores_front/src/docs/inALM.pdf'),
(52, 'In\'Analytics', NULL, 'In\'Analytics', NULL, 'White Paper', '../valoores_front/src/docs/inanalytica.pdf'),
(53, 'In\'Balance Sheet Planner', NULL, 'In\'Balance Sheet Planner', NULL, 'White Paper', '../valoores_front/src/docs/inBalance-sheet-Planner.pdf'),
(54, 'In\'Cash Flow', NULL, 'In\'Cash Flow', NULL, 'White Paper', '../valoores_front/src/docs/incashflow.pdf'),
(55, 'Income Statement', NULL, 'Income Statement', NULL, 'White Paper', '../valoores_front/src/docs/income-statement.pdf'),
(56, 'In\'Profit', NULL, 'In\'Profit', NULL, 'White Paper', '../valoores_front/src/docs/inProfit.pdf'),
(57, 'Insurance Calculation Engine', NULL, 'Insurance Calculation Engine', NULL, 'White Paper', '../valoores_front/src/docs/insurance-calculation-engine.pdf'),
(58, 'Insurance Claims Management', NULL, 'Insurance Claims Management', NULL, 'White Paper', '../valoores_front/src/docs/insurance-claims-management.pdf'),
(59, 'Insurance Data Foundation', NULL, 'Insurance Data Foundation', NULL, 'White Paper', '../valoores_front/src/docs/insurance-data-foundation.pdf'),
(61, 'Insurance Policy Administration', NULL, 'Insurance Policy Administration', NULL, 'White Paper', '../valoores_front/src/docs/insurance-policy-administration.pdf'),
(63, 'Insurance Revenue Management', NULL, 'Insurance Revenue Management', NULL, 'White Paper', '../valoores_front/src/docs/insurance-revenue-management.pdf'),
(64, 'Introduction to Capital Markets', NULL, 'Introduction to Capital Markets', NULL, 'White Paper', '../valoores_front/src/docs/Introduction-to-capital-markets.pdf'),
(65, 'KPIs and KRIs: A Simple Guide', NULL, 'KPIs and KRIs: A Simple Guide', NULL, 'White Paper', '../valoores_front/src/docs/KPIs-and-KRIs-A-Simple-Guide.pdf'),
(66, 'KYC', NULL, 'KYC', NULL, 'White Paper', '../valoores_front/src/docs/KYC.pdf'),
(67, 'Operational Excellence in Retail Banking', NULL, 'Operational Excellence in Retail Banking', NULL, 'White Paper', '../valoores_front/src/docs/operational-excellence-in-retail-banking.pdf'),
(68, 'Other Retail Banking KPIs', NULL, 'Other Retail Banking KPIs', NULL, 'White Paper', '../valoores_front/src/docs/Other-Retail-Banking-KPIs.pdf'),
(69, 'Overview of Basel III Regulations', NULL, 'Overview of Basel III Regulations', NULL, 'White Paper', '../valoores_front/src/docs/Overview-of-Basel-III-Regulations.pdf'),
(71, 'Press Release', NULL, 'Press Release', NULL, 'White Paper', '../valoores_front/src/docs/press-release.pdf'),
(72, 'Regulatory', NULL, 'Regulatory', NULL, 'White Paper', '../valoores_front/src/docs/regulatory.pdf'),
(73, 'Research and Innovation Communications', NULL, 'Research and Innovation Communications', NULL, 'White Paper', '../valoores_front/src/docs/Research-and-Innovation-Communications.pdf'),
(74, 'Retail Banking Industry Report', NULL, 'Retail Banking Industry Report', NULL, 'White Paper', '../valoores_front/src/docs/RetailBankingIndustryReport.pdf'),
(75, 'Summary Table of International Accounting Regulations', NULL, 'Summary Table of International Accounting Regulations', NULL, 'White Paper', '../valoores_front/src/docs/Summary-Table-of-International-Accounting-Regulations.pdf'),
(76, 'T2R', NULL, 'T2R', NULL, 'White Paper', '../valoores_front/src/docs/t2r.pdf'),
(77, 'The Importance of Defining Targeted KPIs \nAnd KRIs', NULL, 'The Importance of Defining Targeted KPIs \nAnd KRIs', NULL, 'White Paper', '../valoores_front/src/docs/TheimportanceofDefiningTargetedKPIsKRIs.pdf'),
(78, 'VALOORES ABL Press Release', NULL, 'VALOORES ABL Press Release', NULL, 'White Paper', '../valoores_front/src/docs/v1.1-VALOORES-ABL-Press-Release.pdf'),
(79, 'Valoores - Data Governance', NULL, 'Valoores - Data Governance', NULL, 'White Paper', '../valoores_front/src/docs/Valoores - Data Governance.pdf'),
(80, 'Valoores GRC', NULL, 'Valoores GRC', NULL, 'White Paper', '../valoores_front/src/docs/Valoores GRC.pdf'),
(81, 'Valoores in\'Profit - Fact Sheet', NULL, 'Valoores in\'Profit - Fact Sheet', NULL, 'White Paper', '../valoores_front/src/docs/Valoores in\'Profit - Fact Sheet.pdf'),
(82, 'Valoores Arabia Insurance Reuters Refinitiv', NULL, 'Valoores Arabia Insurance Reuters Refinitiv', NULL, 'White Paper', '../valoores_front/src/docs/valoores-arabiainsurance-reuters-refinitiv.pdf'),
(83, 'Valoores BDL IFRS9 Summit Presentation', NULL, 'Valoores BDL IFRS9 Summit Presentation', NULL, 'White Paper', '../valoores_front/src/docs/Valoores-BDL-IFRS9-Summit-Presentation.pdf'),
(84, 'Valoores Cloud Computing', NULL, 'Valoores Cloud Computing', NULL, 'White Paper', '../valoores_front/src/docs/Valoores-Cloud-Computing.pdf'),
(85, 'Valoores Executive Letter Compliance Services', NULL, 'Valoores Executive Letter Compliance Services', NULL, 'White Paper', '../valoores_front/src/docs/valoores-executive-letter-complianceservices.pdf'),
(86, 'Valoores Financial Services RFR', NULL, 'Valoores Financial Services RFR', NULL, 'White Paper', '../valoores_front/src/docs/Valoores-Financial-Services-RFR.pdf'),
(87, 'Valoores-Financial-Services-RRS', NULL, 'Valoores-Financial-Services-RRS', NULL, 'White Paper', '../valoores_front/src/docs/Valoores-Financial-Services-RRS.pdf'),
(88, 'VALOORES FS Regulatory Compliance Era 2020 and Beyond', NULL, 'VALOORES FS Regulatory Compliance Era 2020 and Beyond', NULL, 'White Paper', '../valoores_front/src/docs/VALOORES-FS-Regulatory-Compliance-Era-2020-and-Beyond-v105.pdf'),
(89, 'Valoores Global Framework-2017', NULL, 'Valoores Global Framework-2017', NULL, 'White Paper', '../valoores_front/src/docs/Valoores-Global-Framework-2017.pdf'),
(90, 'VALOORES Global Partner Business Plan', NULL, 'VALOORES Global Partner Business Plan', NULL, 'White Paper', '../valoores_front/src/docs/VALOORES-Global-Partner-Business-Plan-v098.pdf'),
(93, 'valoores In\'Via', NULL, 'valoores In\'Via', NULL, 'White Paper', '../valoores_front/src/docs/valoores-invia.pdf'),
(94, 'Valoores Real Time BI-A Banking Perspective', NULL, 'Valoores Real Time BI-A Banking Perspective', NULL, 'White Paper', '../valoores_front/src/docs/Valoores-Real-Time-BI-a-Banking-Perspective.pdf'),
(96, 'VALOORES-An Executive Summary', NULL, 'VALOORES-An Executive Summary', NULL, 'White Paper', '../valoores_front/src/docs/VALOORES_An_Executive_Summary_in_2_Pages.pdf'),
(97, 'Valoores Internship Announcement', NULL, 'Valoores Internship Announcement November 2017', NULL, 'White Paper', '../valoores_front/src/docs/Valoores_Internship_Announcement_Nov2017.pdf'),
(98, 'VBS-BOB-FPS', NULL, 'VBS-BOB-FPS', NULL, 'White Paper', '../valoores_front/src/docs/VBS-BOB-FPS.pdf'),
(99, 'VBS-V20-Release Note-v0.1', NULL, 'VBS-V20-Release Note-v0.1', NULL, 'White Paper', '../valoores_front/src/docs/VBS-V20-Release Note-v0.1.pdf'),
(100, 'World Retail Banking Report 2013', NULL, 'World Retail Banking Report 2013', NULL, 'White Paper', '../valoores_front/src/docs/world-retail-banking-report-2013.pdf');

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

--
-- Table structure for table `icons`
--

CREATE TABLE `icons` (
  `id` int(11) NOT NULL,
  `icon_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `icon_path` varchar(255) DEFAULT NULL,
  `related_id` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `icons`
--

INSERT INTO `icons` (`id`, `icon_name`, `icon_path`, `related_id`) VALUES
(41, 'counter1.png', '../valoores_front/src/icons/counter1.png', 'counter_15'),
(42, 'counter2.png', '../valoores_front/src/icons/counter2.png', 'counter_16'),
(43, 'counter3.png', '../valoores_front/src/icons/counter3.png', 'counter_17'),
(44, 'counter4.png', '../valoores_front/src/icons/counter4.png', 'counter_18'),
(48, 'carrefour.png', '../valoores_front/src/icons/carrefour.png', 'clients_44'),
(49, 'qib.png', '../valoores_front/src/icons/qib.png', 'clients_45'),
(50, 'bob.png', '../valoores_front/src/icons/bob.png', 'clients_46'),
(51, 'kafalat.png', '../valoores_front/src/icons/kafalat.png', 'clients_47'),
(52, 'fnac.png', '../valoores_front/src/icons/fnac.png', 'clients_48'),
(53, 'cvs.png', '../valoores_front/src/icons/cvs.png', 'clients_49'),
(54, 'bdl.png', '../valoores_front/src/icons/bdl.png', 'clients_50'),
(55, 'bobfinance.png', '../valoores_front/src/icons/bobfinance.png', 'clients_51'),
(56, 'canadiantyre.png', '../valoores_front/src/icons/canadiantyre.png', 'clients_52'),
(57, 'fransa.png', '../valoores_front/src/icons/fransa.png', 'clients_53'),
(58, 'blf.png', '../valoores_front/src/icons/blf.png', 'clients_54'),
(59, 'abl.png', '../valoores_front/src/icons/abl.png', 'clients_55'),
(60, '', '../valoores_front/src/icons/icon1.png', 'slider_1'),
(61, '', '../valoores_front/src/icons/icon2.png', 'slider_2'),
(62, '', '../valoores_front/src/icons/icon3.png', 'slider_3'),
(63, '', '../valoores_front/src/icons/icon4.png', 'slider_4'),
(64, '', '../valoores_front/src/icons/icon5.png', 'slider_5'),
(65, '', '../valoores_front/src/icons/icon6.png', 'slider_6'),
(66, '', '../valoores_front/src/icons/icon7.png', 'slider_7'),
(67, '', '../valoores_front/src/icons/icon8.png', 'slider_8'),
(68, '', '../valoores_front/src/icons/icon9.png', 'slider_9'),
(69, '', '../valoores_front/src/icons/app1.png', 'application_1'),
(70, '', '../valoores_front/src/icons/app2.png', 'application_2'),
(71, '', '../valoores_front/src/icons/app3.png', 'application_3'),
(72, '', '../valoores_front/src/icons/icon10.png', 'application_4');

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

--
-- Table structure for table `images`
--

CREATE TABLE `images` (
  `id` int(11) NOT NULL,
  `image_path` varchar(255) NOT NULL,
  `related_id` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `images`
--

INSERT INTO `images` (`id`, `image_path`, `related_id`) VALUES
(10, '../valoores_front/src/img/financial.jpg', 'main_cards_1'),
(20, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_1'),
(21, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_2'),
(22, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_3'),
(23, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_4'),
(24, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_5'),
(25, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_6'),
(26, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_7'),
(27, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_8'),
(28, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_9'),
(30, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_11'),
(32, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_13'),
(33, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_14'),
(34, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_15'),
(35, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_16'),
(36, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_17'),
(37, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_18'),
(38, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_19'),
(39, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_20'),
(40, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_21'),
(41, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_22'),
(42, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_23'),
(43, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_24'),
(44, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_25'),
(46, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_27'),
(47, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_28'),
(48, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_29'),
(49, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_30'),
(50, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_31'),
(52, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_33'),
(53, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_34'),
(54, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_35'),
(55, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_36'),
(56, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_37'),
(64, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_45'),
(65, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_46'),
(66, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_47'),
(67, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_48'),
(68, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_49'),
(69, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_50'),
(70, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_51'),
(71, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_52'),
(72, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_53'),
(73, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_54'),
(74, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_55'),
(75, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_56'),
(76, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_57'),
(77, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_58'),
(78, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_59'),
(80, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_61'),
(82, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_63'),
(83, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_64'),
(84, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_65'),
(85, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_66'),
(86, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_67'),
(87, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_68'),
(88, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_69'),
(90, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_71'),
(91, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_72'),
(92, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_73'),
(93, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_74'),
(94, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_75'),
(95, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_76'),
(96, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_77'),
(97, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_78'),
(98, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_79'),
(99, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_80'),
(100, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_81'),
(101, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_82'),
(102, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_83'),
(103, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_84'),
(104, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_85'),
(105, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_86'),
(106, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_87'),
(107, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_88'),
(108, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_89'),
(109, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_90'),
(112, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_93'),
(113, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_94'),
(115, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_96'),
(116, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_97'),
(117, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_98'),
(118, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_99'),
(119, '../valoores_front/src/img/full_logoC - Copy.png', 'docs_100'),
(132, '../valoores_front/src/img/Service1.jpg', 'shortcut_cards_3'),
(133, '../../valoores_front_react/src/img/upload/sections/city_update 2023_05_23 12_52.jpg', 'sections_11'),
(134, '../valoores_front/src/img/valooresframework.gif', 'sections_12'),
(135, '../valoores_front/src/img/Screenshot (6).png', 'sections_13'),
(136, '../valoores_front/src/img/ai.jpg', 'main_cards_3'),
(137, '../valoores_front/src/img/goverment.jpg', 'main_cards_4'),
(138, '../valoores_front/src/img/telecommunication.jpg', 'main_cards_5'),
(139, '../valoores_front/src/img/geospatial.jpg', 'main_cards_6'),
(140, '../valoores_front/src/img/retail.jpg', 'main_cards_7'),
(141, '../valoores_front/src/img/healthcare.jpg', 'main_cards_8'),
(142, '../valoores_front/src/img/communication.jpg', 'main_cards_9'),
(143, '../valoores_front/src/img/consulting.jpg', 'main_cards_10'),
(144, '../valoores_front/src/img/Service2.jpg', 'shortcut_cards_4'),
(145, '../valoores_front/src/img/Service3.jpg', 'shortcut_cards_5'),
(146, '../valoores_front/src/img/Service4.jpg', 'shortcut_cards_6'),
(147, '../valoores_front/src/img/Service5.jpg', 'shortcut_cards_7'),
(148, '../valoores_front/src/img/Service6.jpg', 'shortcut_cards_8'),
(149, '../valoores_front/src/img/Service7.jpg', 'shortcut_cards_9'),
(150, '../valoores_front/src/img/Service8.jpg', 'shortcut_cards_10'),
(151, '../valoores_front/src/img/Service9.jpg', 'shortcut_cards_11'),
(152, '../valoores_front/src/img/Service10.jpg', 'shortcut_cards_12'),
(153, '../valoores_front/src/img/Service11.jpg', 'shortcut_cards_13'),
(154, '../valoores_front/src/img/Service12.jpg', 'shortcut_cards_14'),
(155, '../valoores_front/src/img/avatar.jpg', 'sections_14'),
(156, '../valoores_front/src/img/avatar.jpg', 'sections_15'),
(157, '../valoores_front/src/img/avatar.jpg', 'sections_16'),
(158, '../valoores_front/src/img/slide1.jpg', 'carousel_14'),
(159, '../valoores_front/src/img/geospatial.jpg', 'carousel_15'),
(160, '../valoores_front/src/img/geo.jpg', 'carousel_16'),
(161, '../valoores_front/src/img/retail.jpg', 'carousel_17'),
(162, '../valoores_front/src/img/ai.jpg', 'carousel_18'),
(163, '../valoores_front/src/img/knowledge.jpg', 'carousel_19'),
(164, '../valoores_front/src/img/bigdata.jpg', 'carousel_20'),
(165, '../valoores_front/src/img/goverment.jpg', 'carousel_21'),
(166, '../valoores_front/src/img/financial.jpg', 'carousel_22'),
(167, '../valoores_front/src/img/slide6.jpg', 'carousel_23'),
(168, '../valoores_front/src/img/slide10.jpg', 'carousel_24'),
(169, '../valoores_front/src/img/slide7.jpg', 'carousel_25'),
(170, '../valoores_front/src/img/avatar.jpg', 'sections_17'),
(171, '', 'Bsections_1'),
(172, '../valoores_front/src/img/image1.jpg', 'slider_1'),
(173, '../valoores_front/src/img/image2.jpg', 'slider_2'),
(174, '../valoores_front/src/img/image3.jpg', 'slider_3'),
(175, '../valoores_front/src/img/image4.jpg', 'slider_4'),
(176, '../valoores_front/src/img/image5.jpg', 'slider_5'),
(177, '../valoores_front/src/img/image6.jpg', 'slider_6'),
(178, '../valoores_front/src/img/image7.jpg', 'slider_7'),
(179, '../valoores_front/src/img/image8.jpg', 'slider_8'),
(180, '../valoores_front/src/img/image9.jpg', 'slider_9'),
(181, '../valoores_front/src/img/services2.png', 'Bsections_2'),
(182, '../valoores_front/src/img/full_logoC - Copy.png', 'Bsections_3'),
(183, '../valoores_front/src/img/dashboardParalax.jpg', 'Bsections_4'),
(184, '../valoores_front/src/img/paralax2.jpg', 'Bsections_5');

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

--
-- Table structure for table `main_cards`
--

CREATE TABLE `main_cards` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `title_ar` varchar(255) DEFAULT NULL,
  `description` longtext NOT NULL,
  `description_ar` longtext DEFAULT NULL,
  `link` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `main_cards`
--

INSERT INTO `main_cards` (`id`, `title`, `title_ar`, `description`, `description_ar`, `link`) VALUES
(1, 'Financial Services', NULL, 'Valoores Delivers intelligent financial solutions and productivity-enhancing case management tools for financial institutions... Read More →', NULL, '/banking'),
(3, 'Artificial Intelligence and Big Data', NULL, 'Our Solutions connect the Power of AI to drive Intelligent Automation, Predictive Analytics, and Decision-Making, revolutionizing industries and empowering businesses to achieve efficiency and innovation...  Read More →', NULL, '/ai'),
(4, 'Government', NULL, 'Valoores solutions facilitates the use of information and communication technologies to provide and improve public-sector services... Read More →', NULL, 'https://gov.valoores.com/'),
(5, 'Telecommunication', NULL, 'Our approach leverages communication channels to optimize performance, enhance collaboration, and deliver user experiences for governmental and non-governmental needs... Read More →', NULL, '/slide4'),
(6, 'Geospatial', NULL, 'We have gone beyond basic location data, which simply tells us where things are... Read More →', NULL, '/Geospatial'),
(7, 'Retail and Supply Chain', NULL, 'Valoores uses supply chain technologies and advanced retail services for responding to market needs... Read More →', NULL, 'https://retail.valoores.com/'),
(8, 'Healthcare', NULL, 'VALOORES in\'Healthcare Harnessing big data to derive insights for improving healthcare delivery and reducing waste... Read More →', NULL, 'https://healthcare.valoores.com/'),
(9, 'Communication and Multimedia', NULL, 'We offer a comprehensive suite of services that enable organizations to connect, captivate, and collaborate effectively in today\'s dynamic digital landscape...  Read More →', NULL, 'https://multimedia.valoores.com/'),
(10, 'Consulting Services', NULL, 'Our Consulting Services offer strategic guidance and tailored insights to help businesses optimize their technology stack, streamline processes, and drive innovation... Read More →', NULL, '/slide9');

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

--
-- Table structure for table `request_document`
--

CREATE TABLE `request_document` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `profession` varchar(255) NOT NULL,
  `company` varchar(255) NOT NULL,
  `document_path` longtext NOT NULL,
  `date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `sections`
--

CREATE TABLE `sections` (
  `id` int(11) NOT NULL,
  `title` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `title_ar` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `description` longtext NOT NULL,
  `description_ar` longtext CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `orders` int(11) NOT NULL,
  `image_container` varchar(255) NOT NULL,
  `text_container` varchar(255) NOT NULL,
  `class` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `link` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `sections`
--

INSERT INTO `sections` (`id`, `title`, `title_ar`, `description`, `description_ar`, `orders`, `image_container`, `text_container`, `class`, `type`, `link`) VALUES
(11, '<h2>                   <img src=\"data:image/png;base64,[BLOB]\" alt=\"\" /><br />                   <span>More than 30 Years in less than 30 Seconds</span>                 </h2>', NULL, '<p>Enterprise Business Solutions in Financial Services, Cyber Crimes, BI, Analytics, in\'Advanced Certified Anti-Hacking and State Security Clouds Model. VALOORES is one of the leading providers of Enterprise Business Solutions and BI Vertical Decision Making. We are a World Class Company implementing products and services to Tier1 Corp. Our resources pool is spread over North America (US and Canada), Europe (Eastern & Western), Africa, and the Middle East. VALOORES, established in 1989, operates in 17 countries.</p><div class=\"button_div\"><a class=\"btn btn-show-sec\" href=\"https://demo.valoores.com/valooresdashboards/\" target= \"_blank\">Request A Demo </a> </div>', NULL, 1, 'col-md-6', 'col-md-6', 'content__title', 'intro', 'video_player-container');
INSERT INTO `sections` (`id`, `title`, `title_ar`, `description`, `description_ar`, `orders`, `image_container`, `text_container`, `class`, `type`, `link`) VALUES
(12, '<h2>The Global <span>Compliance Pain</span>                       </h2>', NULL, '<p class=\"mt-3\">Experience the most powerful and flexible tools for Compliance <br>                         <br>At VALOORES, we take a different approach to data intelligence providing real-time transparency into the risk of Financial Institutions\' customers. Specializing in high-risk processes with high volume clients, our global coverage enables us to spot tens of thousands of risk events within millions of structured and unstructured data sources, every day. <br>                         <br>As institutions improve their tools, VALOORES is often chosen to digitize client onboarding (KYC/KYB), monitor ongoing customer behaviors and financial crime risk, and comply with AML/CFT. Our suite of products can be configured to serve all banking sectors from Tier 1 Financial Institutions to Community Banks focusing on one to two banking segments. <br>                         <br>“The system is simple to set up and use, and flexible to fine-tune. Using \'shared compliance infrastructure\' also allows us to focus our technical resource on other core business activities”                       </p>', NULL, 2, 'col-md-6', 'col-md-6', 'compliance__title', 'compliance', 'https://valoores.com/slider.php'),
(13, '<h2>                     <span>VALOORES in\'Group: </span>Solutions                   </h2>', NULL, '<p>VALOORES provides clean, clear and classy data and unparalleled insight and analytics through tools tailored to your workflow so you can move from big ideas to big results.</p>', NULL, 3, 'col-md-4 my-4 flex-display', 'row d-flex flex-row mb-3', 'business__card-container text-center', 'solutions', 'solutions'),
(14, '<h2>A <span>Service </span>For Your Every Need!</h2>', NULL, '', NULL, 4, 'col-md-4 p-3', 'services__title', 'overlay__bg', 'services', 'services__content'),
(15, '<h2>Sharing with you <span>our list of clients</span></h2>', NULL, 'btn btn-show', NULL, 5, 'client_list', 'clients__title', 'text-center mt-5', 'clients', ''),
(16, '<h2>Why choose <span className=\'fw-bold mb-5\'>Valoores?</span></h2>', NULL, '', NULL, 6, 'inner_container', 'row d-flex flex-row mb-3', 'counter_content d-flex', 'counter', 'd-flex flex-row align-items-center'),
(17, 'carousel_video', NULL, 'video_section', NULL, 7, 'img_content row', 'text_content col-md-6', 'd-flex flex-row gap-8 mt-4', 'carousel', 'video_content col-md-6');

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

--
-- Table structure for table `shortcut_cards`
--

CREATE TABLE `shortcut_cards` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `title_ar` varchar(255) DEFAULT NULL,
  `description` longtext NOT NULL,
  `description_ar` longtext DEFAULT NULL,
  `link` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `shortcut_cards`
--

INSERT INTO `shortcut_cards` (`id`, `title`, `title_ar`, `description`, `description_ar`, `link`) VALUES
(3, 'AML', NULL, 'Big data has not only changed the way that banks address AML, but has also heightened the expectations... Read More →', NULL, 'https://banking.valoores.com/aml.php'),
(4, 'Fraud Management', NULL, 'Rapidly detect and prevent complex fraud schemes to minimize losses, maximize customer trust and reduce... Read More →', NULL, 'https://banking.valoores.com/infraud.php'),
(5, 'Regulatory', NULL, 'Opportunities to accelerate the Change Management in the Banking sector. Read More →', NULL, 'https://banking.valoores.com/regulatoryreportingsolution.php'),
(6, 'Payment', NULL, 'VALOORES in\'Payment provides key services such as: Remittance,Bill Payments, Mobile Top-Up, Corporate...  Read More →', NULL, 'https://payment.valoores.com/'),
(7, 'Via', NULL, 'Delivers a best-in-class solution that is functionally rich, easily upgradeable, and highly efficient for insurance... Read More →', NULL, 'https://banking.valoores.com/invia.php'),
(8, 'Merchandising Business Suite', NULL, 'Merchandising Business Suite  The right product, sold for the right price, at the right place & time. Read More →', NULL, 'https://retail.valoores.com/retail-merchandising-business-suite.php'),
(9, 'Investor Relations Financial Performance (IRFP)', NULL, 'Is a single source platform for a powerful array of deep financial data, analytics, and research information... Read More →', NULL, 'https://banking.valoores.com/irfp.php'),
(10, 'Profit', NULL, 'VALOORES in\'Profit drives a company\'s profitability. Rich, intelligent & compliant to international standards... Read More →', NULL, 'https://banking.valoores.com/inprofit.php'),
(11, 'Business Intelligence', NULL, 'Collect information from multiple data sources,in different platforms.  Read More →', NULL, 'https://banking.valoores.com/businessintelligence.php'),
(12, 'Campaign', NULL, 'The ongoing regulatory changes that occurred to organizations all over the world due to the economic crisis... Read More →', NULL, 'https://banking.valoores.com/incampaign.php'),
(13, 'KYC Know Your Customer', NULL, 'KYC allows you to assess customer risks; meet regulatory requirements and improve overalls... Read More →', NULL, 'https://banking.valoores.com/kyc.php'),
(14, 'IFRS9', NULL, 'Regulatory Tsunami\"comes to succeed IAS 39 by introducing new requirements and models... Read More →', NULL, 'https://banking.valoores.com/ifrs9.php');

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

--
-- Table structure for table `videos`
--

CREATE TABLE `videos` (
  `id` int(11) NOT NULL,
  `video_name` varchar(255) DEFAULT NULL,
  `video_desc` varchar(255) DEFAULT NULL,
  `video_path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `VIDid` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `videos`
--

INSERT INTO `videos` (`id`, `video_name`, `video_desc`, `video_path`, `VIDid`) VALUES
(17, 'test 3', 'test description 3', 'test link 3?modestbranding=1&amp;rel=0', 1),
(19, 'testing', 'testing', 'testing?modestbranding=1&amp;rel=0', 2);

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

