-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Feb 02, 2026 at 02:00 AM
-- Server version: 11.4.9-MariaDB-cll-lve-log
-- PHP Version: 8.3.29

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `thiqljmz_banksfinders`
--

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

--
-- Table structure for table `scroll_popup_terms_conditions`
--

CREATE TABLE `scroll_popup_terms_conditions` (
  `idscroll_popup_terms_condition` int(11) NOT NULL,
  `category_name` varchar(120) NOT NULL,
  `category_order` int(11) NOT NULL DEFAULT 1,
  `description_point` varchar(500) NOT NULL,
  `point_order` int(11) NOT NULL DEFAULT 1,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `scroll_popup_terms_conditions`
--

INSERT INTO `scroll_popup_terms_conditions` (`idscroll_popup_terms_condition`, `category_name`, `category_order`, `description_point`, `point_order`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Offer', 1, 'Card Type: Blue Islamic Credit Card (VISA Signature).', 1, 1, '2026-02-02 06:56:13', '2026-02-02 06:56:13'),
(2, 'Offer', 1, 'Campaign Duration: 27 Nov 2025 to 28 Feb 2026.', 2, 1, '2026-02-02 06:56:13', '2026-02-02 06:56:13'),
(3, 'Offer', 1, '3 Month Spend Target: AED 30,000.', 3, 1, '2026-02-02 06:56:13', '2026-02-02 06:56:13'),
(4, 'Offer', 1, 'AF FAB Rewards Amount: 35,000 (credited as 1,000,000 AF FAB Rewards on meeting spend condition).', 4, 1, '2026-02-02 06:56:13', '2026-02-02 06:56:13'),
(5, 'Offer', 1, 'Spend Condition: Retail spend of AED 10,000 per month for three months.', 5, 1, '2026-02-02 06:56:13', '2026-02-02 06:56:13'),
(6, 'Offer', 1, 'All cardholders who joined in the first two months can qualify for this offer.', 6, 1, '2026-02-02 06:56:13', '2026-02-02 06:56:13'),
(7, 'Benefit to customer', 2, 'All new eligible customers meeting the spend condition and offer terms & conditions will receive 1 Million AF FAB Rewards worth AED 5,000.', 1, 1, '2026-02-02 06:56:13', '2026-02-02 06:56:13'),
(8, 'Campaign Terms & Conditions', 3, 'Applicable Credit Card: Blue FAB Islamic Credit Card (Visa Signature).', 1, 1, '2026-02-02 06:56:13', '2026-02-02 06:56:13'),
(9, 'Campaign Terms & Conditions', 3, 'Campaign Duration: 27 Nov 2025 to 31 Jan 2026.', 2, 1, '2026-02-02 06:56:13', '2026-02-02 06:56:13'),
(10, 'Campaign Terms & Conditions', 3, 'Offer Details: Earn AED 5,000 cashback in the form of AF FAB Rewards on meeting the spend condition.', 3, 1, '2026-02-02 06:56:13', '2026-02-02 06:56:13'),
(11, 'Campaign Terms & Conditions', 3, 'Spend condition: Retail spend of AED 10,000 per month for three months. Balance Transfer, Quick Cash, and EPP transactions will not be considered or qualify for the offer.', 4, 1, '2026-02-02 06:56:13', '2026-02-02 06:56:13'),
(12, 'Campaign Terms & Conditions', 3, 'Offer is only available for customers who apply for the card during the offer period and meet the minimum monthly spend target in the first three months of card issuance.', 5, 1, '2026-02-02 06:56:13', '2026-02-02 06:56:13'),
(13, 'Campaign Terms & Conditions', 3, 'New customers to FAB/FAB Islamic or existing customers who have not previously held an AF FAB BLUE credit card can apply for the new Blue Islamic Credit Card under this campaign.', 6, 1, '2026-02-02 06:56:13', '2026-02-02 06:56:13'),
(14, 'Campaign Terms & Conditions', 3, 'Customers who spend as per campaign offer terms will qualify for the Rewards.', 7, 1, '2026-02-02 06:56:13', '2026-02-02 06:56:13'),
(15, 'Campaign Terms & Conditions', 3, 'Reward shall be credited in the form of AF FAB Rewards within ninety (90) days of the end of the Offer Period.', 8, 1, '2026-02-02 06:56:13', '2026-02-02 06:56:13'),
(16, 'Campaign Terms & Conditions', 3, 'To be eligible for the Rewards Offer, customers must be non-delinquent and non-blocked on the Credit Date. Any subsequent payment towards delinquency/block existing on the Credit Date will not entitle the customer to receive the cashback.', 9, 1, '2026-02-02 06:56:13', '2026-02-02 06:56:13'),
(17, 'Campaign Terms & Conditions', 3, 'FAB Islamic reserves the right, at its absolute discretion, to exclude any customer deemed engaged in fraudulent activity, misuse of card, or violation of these Terms and Conditions.', 10, 1, '2026-02-02 06:56:13', '2026-02-02 06:56:13'),
(18, 'Campaign Terms & Conditions', 3, 'FAB Islamic may exclude customers who breach FAB Islamic Credit Card policy, terms & conditions.', 11, 1, '2026-02-02 06:56:13', '2026-02-02 06:56:13'),
(19, 'Campaign Terms & Conditions', 3, 'Any disputes regarding the Reward Offer should be raised with FAB Islamic within 4 months of the end of the Offer Period.', 12, 1, '2026-02-02 06:56:13', '2026-02-02 06:56:13'),
(20, 'Campaign Terms & Conditions', 3, 'FAB Islamic Credit Cards Terms and Conditions and Al-Futtaim Blue FAB Islamic Credit Card Rewards Terms & Conditions shall continue to apply.', 13, 1, '2026-02-02 06:56:13', '2026-02-02 06:56:13'),
(21, 'Reference / Regulatory', 4, 'First Abu Dhabi Bank PJSC is licensed and regulated by the Central Bank of the United Arab Emirates.', 1, 1, '2026-02-02 06:56:13', '2026-02-02 06:56:13'),
(22, 'Reference / Regulatory', 4, 'Registered office address: P.O. Box 6316, Abu Dhabi, United Arab Emirates.', 2, 1, '2026-02-02 06:56:13', '2026-02-02 06:56:13');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `scroll_popup_terms_conditions`
--
ALTER TABLE `scroll_popup_terms_conditions`
  ADD PRIMARY KEY (`idscroll_popup_terms_condition`),
  ADD KEY `idx_scroll_popup_tc_active_order` (`is_active`,`category_order`,`point_order`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `scroll_popup_terms_conditions`
--
ALTER TABLE `scroll_popup_terms_conditions`
  MODIFY `idscroll_popup_terms_condition` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
