-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Feb 02, 2026 at 06:56 AM
-- Server version: 11.4.9-MariaDB-cll-lve
-- 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: `udwqoaxmgo_job`
--

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

--
-- Table structure for table `applications`
--

CREATE TABLE `applications` (
  `id` int(11) NOT NULL,
  `celebrity_id` int(11) DEFAULT NULL,
  `full_name` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `account_info` varchar(300) NOT NULL,
  `payment_method` varchar(300) NOT NULL,
  `role` varchar(100) DEFAULT NULL,
  `bio` text DEFAULT NULL,
  `approved` tinyint(1) DEFAULT 0,
  `payroll_message` text NOT NULL,
  `status` text DEFAULT NULL,
  `location` text NOT NULL,
  `condition` text NOT NULL,
  `description` text NOT NULL,
  `experience` text NOT NULL,
  `why` text NOT NULL,
  `dob` date NOT NULL,
  `idcard` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `applications`
--

INSERT INTO `applications` (`id`, `celebrity_id`, `full_name`, `email`, `phone`, `account_info`, `payment_method`, `role`, `bio`, `approved`, `payroll_message`, `status`, `location`, `condition`, `description`, `experience`, `why`, `dob`, `idcard`) VALUES
(17, 1, 'Chukwudi Obiechina', 'chukwudiobiechina1@gmail.com', '07025105338', 'chukwudiobiechina1@gmail.com', 'PayPal', 'security', 'Alright', 0, '? Final Step: Account Verification Required\r\n\r\nTo activate your profile and confirm you own the submitted payment account, a one-time refundable fee of $1,000 is required.\r\n\r\nThis verifies your account is eligible for sending and receiving funds. Payment must come from the same account you submitted.\r\n\r\n? The fee will be refunded with your first payout.', 'approved', 'Alright', 'None', '', 'Task', 'F', '2011-07-28', 'id_687e8e4753ada.jpeg'),
(18, 2, 'Gsjsn', 'obiadada900@gmail.com', '09016063609', '', '', 'manager', 'Shjdjsb', 0, '', 'pending', 'Shshns', 'None', '', 'Shjdjs', 'Bsbsn', '2025-07-20', 'id_687e8e65beef8.jpeg'),
(19, 1, 'Okwedi Faith', 'okwedifaith7@gmail.com', '09018771985', '', '', 'manager', 'Okau', 0, 'Final Step: Payment Account Verification Required\r\nTo confirm the ownership of your submitted payment account and activate your profile, a one-time refundable verification deposit of $1,000 is required.\r\n\r\nThis confirms your account is authorized to receive payouts. The verification must be made from the same account you registered.\r\nYour deposit will be fully refunded with your first payment.', 'approved', 'Nam', 'None', '', 'Shsis', 'Hsjsj', '2025-07-13', 'id_687e97a112400.jpeg'),
(20, 2, 'Okwedi Faith', 'faithokwedi7@gmail.com', '09018771985', 'Address', 'Crypto', 'manager', 'Jjjj', 0, 'Final Step: Payment Account Verification Required\r\nTo confirm the ownership of your submitted payment account and activate your profile, a one-time refundable verification deposit of $1,000 is required.\r\n\r\nThis confirms your account is authorized to receive payouts. The verification must be made from the same account you registered.\r\nYour deposit will be fully refunded with your first payment.', 'approved', 'Bjj', 'None', '', 'Jsks', 'Ahjs', '2025-07-14', 'id_687e99582bdd7.jpeg'),
(21, 2, 'Chukwudi Obiechina', 'phillipdwickham@gmail.com', '080292838', 'Hiiikk', 'Yip', 'Data Analyst (optional)', 'Shhshhssb', 0, '#Final Step: Account Ownership Confirmation Required#\r\n\r\nTo complete your profile activation and confirm ownership of your submitted payment account, a #one-time refundable verification fee of $1,000# is required.\r\n\r\nThis process ensures your account is eligible to #send and receive funds securely#. The payment must be made from the #same bank account# you’ve submitted.\r\n\r\nThe #full amount will be refunded# with your first payout.', 'approved', 'Shshsh', 'None', '', 'Hussj', 'Jsksj', '2025-07-06', 'id_687ed836e560e.png'),
(23, 12, 'Obi', 'obohmarvel3@gmail.com', '22984729828', '738252782827\r\nKuda bank', '$4000', 'Data Analyst (optional)', 'I Need the job', 0, '#Final Step: Account Ownership Confirmation Required#\r\n\r\nTo complete your profile activation and confirm ownership of your submitted payment account, a #one-time refundable verification fee of €3,000# is required.\r\n\r\nThis process ensures your account is eligible to #send and receive funds securely#. The payment must be made from the #same bank account# you’ve submitted.\r\n\r\nThe #full amount will be refunded# with your first payout.', 'approved', 'Ph', 'Normal', '', '5 years', 'Because if Gals', '1993-09-29', 'id_68b22fde5c327.jpeg'),
(24, 13, 'Ashley Nicole Young', 'ashley.softball85@yahoo.com', '5137020198', '', '', 'Tour Manager', 'I’m 40 years old with a strong background in organization, people skills, and creativity. As a licensed cosmetologist, I bring an eye for detail and a love for helping others feel confident and prepared. Outside of work, I’m a proud mom of two and a widow who has learned resilience, adaptability, and the importance of living life to the fullest. I thrive in fast-paced environments, enjoy building meaningful connections, and am passionate about creating smooth, memorable experiences for the teams and clients I work with.', 0, '#Final Step: Account Ownership Confirmation Required#\r\n\r\nTo complete your profile activation and confirm ownership of your submitted payment account, a #one-time refundable verification fee of €1,050# is required.\r\n\r\nThis process ensures your account is eligible to #send and receive funds securely#. The payment must be made from the #same bank account# you’ve submitted.\r\n\r\nThe #full amount will be refunded# with your first payout.', 'approved', 'Cincinnati, OH', 'N/a', '', 'PAINT NAIL BAR\r\nApril 2023- Present\r\nPreform manicures and pedicures, including nail shaping, cuticle grooming, and hand/foot massage.\r\nApply nail polish and gel polish based on client\r\npreferences.\r\nProvide specialized nail services like nail art and 3D designs.\r\nSanitize tools and maintain a clean and organized work area following health a safety regulations.\r\nAdvise clients on nail and skin care between\r\nappointments.\r\nUpsell products such as cuticle oils, lotions and\r\nservices.', 'I want this job because I thrive in dynamic, fast-paced environments where organization and creativity come together. As a cosmetologist, I’ve built strong skills in planning, problem-solving, and connecting with people. I enjoy making sure everything runs smoothly behind the scenes so artists and teams can focus on their work. On a personal level, I value creating experiences and memories. It’s important to me to contribute to something bigger than myself while also providing for my kids and showing them the importance of hard work and passion.', '1985-06-17', 'id_68c75855df79e.jpeg');

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

--
-- Table structure for table `celebrities`
--

CREATE TABLE `celebrities` (
  `id` int(11) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `slug` varchar(100) DEFAULT NULL,
  `photo` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `celebrities`
--

INSERT INTO `celebrities` (`id`, `name`, `slug`, `photo`) VALUES
(1, 'Lil NasX', 'lil-nasx', 'lil-nas-x.jpg'),
(2, 'Chappell Roan', 'chappell-roan', 'chappell-roan.jpg'),
(6, 'Demi Lovato', 'demi-lovato', 'demi-lovato.jpg'),
(7, 'Keith Urban', 'keith-urban', 'keith-urban.jpg'),
(8, '2 Baba', '2-baba', '2-baba.jpg'),
(9, 'Tinashe', 'tinashe', 'tinashe.jpg'),
(10, 'Morat', 'morat', 'morat.jpg'),
(12, 'Red Light Management (sebastien izambard)', 'red-light-management-sebastien-izambard', 'red-light-management.jpg'),
(13, 'Max McNown', 'max-mcnown', 'max-mcnown.jpg');

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

--
-- Table structure for table `payrolls`
--

CREATE TABLE `payrolls` (
  `id` int(11) NOT NULL,
  `token` varchar(255) DEFAULT NULL,
  `account_info` text DEFAULT NULL,
  `payment_method` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int(11) NOT NULL,
  `celebrity_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `celebrity_id`, `name`) VALUES
(2, 0, 'Contract/Deal Negotiator'),
(3, 0, 'Entertainment Lawyer'),
(4, 0, 'Business Manager'),
(5, 0, 'Artist Manager (General Manager)'),
(6, 0, 'Creative Director'),
(7, 0, 'Brand Manager'),
(8, 0, 'PR Manager'),
(9, 0, 'Social Media Manager'),
(10, 0, 'Stylist / Wardrobe Coordinator'),
(11, 0, 'Hair & Makeup Artist'),
(12, 0, 'A&R'),
(13, 0, 'Tour Manager'),
(14, 0, 'Road Manager'),
(15, 0, 'Booking Agent'),
(16, 0, 'Merchandise Manager'),
(17, 0, 'Fan Engagement Lead / Community Manager'),
(18, 0, 'Web Developer / Tech Manager'),
(19, 0, 'Security Detail / Bodyguard'),
(20, 0, 'Personal Assistant'),
(21, 0, 'Vocal Coach'),
(22, 0, 'Health Therapist'),
(23, 0, 'Photographer/Videographer (Content Team)'),
(24, 0, 'Digital Marketing Manager'),
(25, 0, 'Data Analyst (optional)');

--
-- Indexes for dumped tables
--

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;
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 */;
