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

START TRANSACTION;



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

--
-- Table structure for table `tblapplication`
--

CREATE TABLE `tblapplication` (
  `ID` int(5) NOT NULL,
  `ApplicationNumber` varchar(250) DEFAULT NULL,
  `FullName` varchar(250) DEFAULT NULL,
  `Email` varchar(250) DEFAULT NULL,
  `MobileNumber` bigint(10) DEFAULT NULL,
  `FatherName` varchar(250) DEFAULT NULL,
  `Address` mediumtext DEFAULT NULL,
  `State` varchar(250) DEFAULT NULL,
  `City` varchar(250) DEFAULT NULL,
  `Pincode` int(10) DEFAULT NULL,
  `Occupationtype` varchar(250) DEFAULT NULL,
  `MonthlyIncome` decimal(10,0) DEFAULT NULL,
  `Pancard` varchar(250) DEFAULT NULL,
  `Addressproof` varchar(250) DEFAULT NULL,
  `ApplicationDate` timestamp NULL DEFAULT current_timestamp(),
  `Status` varchar(250) DEFAULT NULL,
  `Remark` varchar(250) DEFAULT NULL,
  `MaximumLimit` decimal(10,0) DEFAULT NULL,
  `UpdationDate` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tblapplication`
--

INSERT INTO `tblapplication` (`ID`, `ApplicationNumber`, `FullName`, `Email`, `MobileNumber`, `FatherName`, `Address`, `State`, `City`, `Pincode`, `Occupationtype`, `MonthlyIncome`, `Pancard`, `Addressproof`, `ApplicationDate`, `Status`, `Remark`, `MaximumLimit`, `UpdationDate`) VALUES
(45, '7206506790400371', 'John', 'byjohnson4real@gmail.com', 9032903529, 'Odozie', 'No 2 CSX Street', 'Delta', 'Asaba', 311308, 'Business', 45000, '6921b975f5ee57099f54ddf6f44c59ac1736308564.jpg', '1a42a767bc3ced886dca45700309ddc71736308564.jpg', '2025-01-08 03:56:04', 'Rejected', 'Your credit card request is rejected.', 0, '2025-01-17 22:40:57'),
(46, '1619655139562822', 'Linda', 'Lindaarmstrong2u@gmail.com', 6464600352, 'Armstrong', '329 Erie St', 'New York', 'Buffalo', 14202, 'Salaried', 45550, 'f4b9de24dea1cf4d0428adf702d58c7e1736892271.jpg', 'aa8843c933c585f07f6ab830e1020d571736892271.jpg', '2025-01-14 22:04:31', 'Accepted', 'Your endorsement card request accepted.', 2027, '2025-01-14 22:06:24'),
(47, '3231328402946478', 'Elon', 'myoriginalmail@email.com', 6464600352, 'Musk', '329 Erie St', 'New York', 'Buffalo', 14202, 'Self-Employeed', 45550, '8bfeefbf616bf9ad6a8353cdf06924751736896351.jpg', '966ab8cc73053c8d2bb948da4020ccc21736896351.jpg', '2025-01-14 23:12:31', 'Accepted', 'Rejected', 0, '2025-01-17 22:31:41');

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

--
-- Table structure for table `tblpage`
--

CREATE TABLE `tblpage` (
  `ID` int(10) NOT NULL,
  `PageType` varchar(200) DEFAULT NULL,
  `PageTitle` varchar(200) DEFAULT NULL,
  `PageDescription` mediumtext DEFAULT NULL,
  `Email` varchar(200) DEFAULT NULL,
  `MobileNumber` bigint(10) DEFAULT NULL,
  `UpdationDate` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tblpage`
--

INSERT INTO `tblpage` (`ID`, `PageType`, `PageTitle`, `PageDescription`, `Email`, `MobileNumber`, `UpdationDate`) VALUES
(1, 'aboutus', 'Years of Excellence', 'Welcome to PEC Global! We are dedicated to creating a safe and exclusive platform for fans worldwide. Our Prime Endorsement Card (PEC) offers a secure way for fans to engage with their favorite celebrities while enjoying a host of benefits.\r\n\r\nAt PEC Global, we strive to eliminate scams and provide a seamless experience for fans. When interacting with profiles, fans can request the unique 18-digit Endorsement Number. If the profile cannot provide this number, it indicates a scam. This safeguard ensures genuine connections and interactions. Join us in building a trustworthy and exhilarating community where dreams meet reality.', NULL, NULL, '2025-01-18 16:47:56'),
(2, 'contactus', 'Have questions or need assistance? We’re here to help!', 'PEC Global Headquarters, #23 Bevis Street, BENTLEIGH EAST Victoria 3165', 'support@primeendorsementcard.com', 16464600352, '2025-01-17 19:30:58');

--
-- Indexes for table `tblapplication`
--
ALTER TABLE `tblapplication`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `tblpage`
--
ALTER TABLE `tblpage`
  ADD PRIMARY KEY (`ID`);

--
-- AUTO_INCREMENT for table `tblapplication`
--
ALTER TABLE `tblapplication`
  MODIFY `ID` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=49;

--
-- AUTO_INCREMENT for table `tblpage`
--
ALTER TABLE `tblpage`
  MODIFY `ID` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
COMMIT;

