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

START TRANSACTION;



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

--
-- Table structure for table `bookings`
--

CREATE TABLE `bookings` (
  `id` int(11) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `job` varchar(255) DEFAULT NULL,
  `sex` varchar(25) DEFAULT NULL,
  `phone` varchar(25) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `airport` varchar(255) DEFAULT NULL,
  `budget` varchar(50) DEFAULT NULL,
  `celebrity` varchar(255) NOT NULL,
  `event_date` varchar(255) DEFAULT NULL,
  `event_location` varchar(255) DEFAULT NULL,
  `event_type` varchar(255) DEFAULT NULL,
  `event_info` text DEFAULT NULL,
  `date_booked` varchar(50) DEFAULT NULL,
  `celebrity_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `celebrity`
--

CREATE TABLE `celebrity` (
  `id` int(11) NOT NULL,
  `fname` varchar(50) NOT NULL,
  `bio` text NOT NULL,
  `dob` varchar(50) NOT NULL,
  `occupation` varchar(255) DEFAULT NULL,
  `fee` varchar(50) DEFAULT NULL,
  `years_active` varchar(255) DEFAULT NULL,
  `photo` blob DEFAULT NULL,
  `category` varchar(50) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `celebrity`
--

INSERT INTO `celebrity` (`id`, `fname`, `bio`, `dob`, `occupation`, `fee`, `years_active`, `photo`, `category`, `description`) VALUES
(10, 'DUSTIN CHARLES LYNCH', 'Lynch said he started playing guitar when he was around 8 or 9 but soon abandoned it, and then picked it up again at 15. When he was 16, he performed at the Bluebird Caf&amp;eacute; in Nashville on an open mic night and was well received by the audience, so he decided to start a band', '09/11/1990', 'rapper', '£‎2000', NULL, 0x6c796e63682e6a7067, 'top', 'An American country music singer and songwriter'),
(12, 'ZAC EFRON', 'He rose to prominence in the late 2000s for his leading role as Troy Bolton in the High School Musical trilogy (2006&amp;ndash;2008).', '09/11/1992', 'ACTOR', '£‎9000', NULL, 0x7a61632e6a7067, 'popular', 'Zachary David Alexander Efron is an American actor.'),
(13, 'MILO VENTIMIGLIA', 'Making his screen acting debut on The Fresh Prince of Bel-Air in 1995. He portrayed the lead role on the short-lived series Opposite Sex in 2000 before landing his breakthrough role the following year as Jess Mariano on Gilmore Girls.', '09/11/1989', 'ACTOR', '£‎‎2300', NULL, 0x6d696c6f2e6a7067, 'popular', 'He is an American actor'),
(14, 'BRAD PITT', 'He is the recipient of various accolades, including two Academy Awards, a British Academy Film Award, two Golden Globe Awards, and a Primetime Emmy Award.', '31/10/2022', 'Actor', '£‎‎2300', NULL, 0x427261645f506974745f323031395f62795f476c656e6e5f4672616e6369732e6a7067, 'top', 'William Bradley Pitt is an American actor and film producer.'),
(15, 'KEANU CHARLES REEVES', 'Reeves began acting in theatre productions and in television films before making his feature film debut in Youngblood', '09/11/1992', 'Producer', '£‎5600', NULL, 0x7265657665732e6a7067, 'popular', 'movie producer'),
(16, 'ERIC CHURCH', 'Releasing six studio albums through Capitol Nashville since 2005. His debut album, 2006\'s Sinners Like Me, produced three singles on the Billboard country charts including the top 20 hits &amp;quot;How \'Bout You&amp;quot;, &amp;quot;Two Pink Lines&amp;quot;, and &amp;quot;Guys Like Me&amp;quot;.', '09/11/1990', 'SINGER', '£‎5600', NULL, 0x657269632e6a7067, 'popular', 'Eric is a Singer &amp;amp; Songwriter'),
(17, 'HENRY CAVILL', 'English Actor for Portraying Superman in the DC Universe &amp;amp; Geralt of Rivia in Netflix\'s &amp;quot;The Witcher&amp;quot; Travels from:   Los Angeles, CA, USA', '09/11/1990', 'ACTOR', '£‎‎4589', NULL, 0x68656e72792e6a7067, 'popular', 'Actors, Television Personality'),
(18, 'VIN DIESEL', 'He rose to prominence in the late 2000s for his leading role as Troy Bolton in the High School Musical trilogy (2006 &amp;amp;2008).', '09/11/1982', 'ACTOR', '£‎3500', NULL, 0x76696e642e6a7067, 'popular', 'Actor and Film Producer'),
(19, 'TRAVIS FIMMEL', 'His role as Ragnar Lothbrok in the History Channel television series Vikings.', '09/11/1989', 'Songwriter', '£‎2000', NULL, 0x7472617669732e6a7067, 'popular', 'Musician, Singer, Songwriter and Actor'),
(20, 'TOBY KEITH', 'He is American country music singer, songwriter, actor, and record producer. Known professionally by his given names, Keith released his first four studio albums.', '09/11/1968', 'SINGER', '£‎1800', NULL, 0x746f62792e6a7067, 'top', 'TOBY KEITH is an American singer and songwriter'),
(21, 'ROBERT WILLIAM FLAY', 'Flay is the owner and executive chef of several restaurants and franchises, including Bobby\'s Burger Palace, Bobby\'s Burgers, and Amalfi.', '09/11/1997', 'Celebrity chef &amp;amp; restaurateur', '£‎2300', NULL, 0x666c61792e6a7067, 'top', 'Celebrity chef, restaurateur, and reality television personality'),
(22, 'PEDRO ALONSO', 'His role of Andr&amp;eacute;s &amp;quot;Berlin&amp;quot; de Fonollosa in the Spanish heist series Money Heist (La casa de papel) and for the role of Diego Murqu&amp;iacute;a in the historical drama series Gran Hotel.', '09/11/1989', 'ACTOR', '£‎44000', NULL, 0x706564726f2d616c6f6e736f2e6a7067, 'top', 'Pedro Alonso  is an actor, a writer and an artist'),
(23, 'SIR RICHARD STARKEY', 'The drummer for the Beatles. He occasionally sang lead vocals with the group, usually for one song on each album, including &amp;quot;Yellow Submarine&amp;quot;, &amp;quot;With a Little Help from My Friends&amp;quot; and their cover of &amp;quot;Act Naturally&amp;quot;. He also wrote and sang the Beatles\' songs &amp;quot;Don\'t Pass Me By&amp;quot; and &amp;quot;Octopus\'s Garden&amp;quot;, and is credited as a co-writer of others.', '09/11/1992', 'ACTOR', '£‎2000', NULL, 0x7369722e6a7067, 'top', 'SIR RICHARD STARKEY is a Musician, Singer, Songwriter and Actor'),
(24, 'MALTE FYNBOE MANNICHE', 'His identity was unknown until the father of his host family from an exchange trip announced his name on Facebook.[2] His name translates to &amp;quot;gold boy&amp;quot; or &amp;quot;golden boy&amp;quot; in English.[2] As Gulddreng, Ebert was known for always wearing sunglasses,[2] which helped to obscure his identity. His first seven singles, &amp;quot;Model&amp;quot;, &amp;quot;Se mig nu&amp;quot;, &amp;quot;Hva\' s&amp;aring;&amp;quot;, &amp;quot;Drikker for lidt&amp;quot;, &amp;quot;Nemt&amp;quot;, &amp;quot;Guld jul&amp;quot; and &amp;quot;Ked af det&amp;quot;, all peaked at number 1 in Denmark, with &amp;quot;Se mig nu&amp;quot;, &amp;quot;Drikker for lidt&amp;quot;, &amp;quot;Guld jul&amp;quot;, and &amp;quot;Ked af det&amp;quot; debuting at the top spot', '09/11/1990', 'Musician', '£‎‎2300', NULL, 0x6562657265742e6a7067, 'top', 'MALTE FYNBOE MANNICHE is A Danish musician, Singer, rapper, comedian'),
(25, 'JACK WAGNER', 'Known for:   American actor and singer, best known for his roles on the soap operas General Hospital, Santa Barbara, The Bold and the Beautiful, and Melrose Place.', '09/11/1990', 'ACTOR', '£‎‎2000', NULL, 0x7761672e6a7067, 'featured', 'JACK WAGNER is an American actor and a passionate singer'),
(26, 'CHRIS YOUNG', 'American country music singer and songwriter and winner of (Season 4) the television program Nashville Star', '09/11/1982', 'ACTOR', '£‎‎5600', NULL, 0x63687269732e6a7067, 'featured', 'American country music singer'),
(27, 'JOE MANGANIELLO', 'JOE MANGANIELLO is an actor, a writer and an artist', '09/11/1990', 'ACTOR', '£‎‎2000', NULL, 0x6d616e672e6a7067, 'featured', 'JOE MANGANIELLO is an actor, a writer and an artist'),
(28, 'LUKE COMBS', 'Known for:    releasing two albums for Columbia Nashville, which have combined to produce 10 singles, nine of which reached number one on Billboard\'s Country Airplay chart.', '09/11/1989', 'ACTOR', '£‎‎2300', NULL, 0x636f6d62732e6a7067, 'featured', 'LUKE COMBS is an actor'),
(29, 'SARAH PAULSON', 'Emmy Award-Winning Actress', '09/11/1982', 'Actress', '£‎‎5600', NULL, 0x73617261682e6a7067, 'featured', 'SARAH PAULSON is an Emmy Award-Winning Actress'),
(30, 'JON BON JOVI', 'The founder and frontman of the Grammy Award-winning rock band Bon Jovi, which was formed in 1983.', '09/11/1982', 'Philanthropist', '£‎31000', NULL, 0x6a6f6e2e6a7067, 'featured', 'Singer, Songwriter, Record producer, Philanthropist, Actor'),
(32, 'CHRIS PRATT', 'CHRIS PRATT is a Musician, Singer, Songwriter and Actor', '01/11/1981', 'ACTOR', '£‎‎770', NULL, 0x70726174742e6a7067, 'featured', 'CHRIS PRATT is a Musician, Singer, Songwriter and Actor'),
(33, 'BRADLEY COOPER', 'BRADLEY COOPER is a Musician, Singer, Songwriter and Actor', '09/11/1990', 'ACTOR', '£‎‎2000', NULL, 0x636f6f7065722e6a7067, 'featured', 'BRADLEY COOPER is a Musician, Singer, Songwriter and Actor'),
(34, 'GERARD BUTLER', 'Known for  his portrayal of King Leonidas in Zack Snyder\'s fantasy war film 300. That role earned him nominations for an Empire Award for Best Actor and a Saturn Award for Best Actor and a win for MTV Movie Award for Best Fight. In the 2010s, he voiced the role of Stoick the Vast in the animated action-fantasy film How to Train Your Dragon, a role he later reprised in Legend of the Boneknapper Dragon (2010), Gift of the Night Fury (2011), How to Train Your Dragon 2 (2014), and How to Train Your Dragon: The Hidden World (2019).', '03/1/1978', 'ACTOR', '£‎98000', NULL, 0x6765726172642d6275746c65722e6a7067, 'featured', 'Known for  his portrayal of King Leonidas in Zack Snyder\'s fantasy war film'),
(36, 'SONG SEUNG-HEON', '', 'October 5th, 1976', 'ACTOR / MODEL', '', NULL, 0x576861747341707020496d61676520323032332d30312d333020617420342e31312e323420414d2e6a706567, 'popular', 'Song Seung-heon is a South Korean model and actor who has acted in various television dramas and won many awards for this creativity.'),
(40, 'LEE JOON-GI', 'Lee Joon-gi is a South Korean actor, singer, dancer, and model. He rose to fame on his first leading role playing a clown in the critically acclaimed film The King and the Clown and gained further recognition in the romantic comedy My Girl.', '17 April 1982', 'ACTOR / MODEL', 'Undisclosed', NULL, 0x6c656565652e6a706567, 'top', 'Actor, singer, dancer, model'),
(41, 'PARK SEO-JOON', 'Park Seo-joon is a South Korean actor. He is best known for his starring roles in the television series Kill Me, Heal Me, She Was Pretty, Hwarang: The Poet Warrior Youth, Fight for My Way, What\'s Wrong with Secretary Kim, and Itaewon Class.', '16 December 1988', 'Actor', 'Undisclosed', NULL, 0x5041524b2e6a706567, 'popular', 'Actor'),
(42, 'KIM SOO-HYUN', 'Kim Soo-hyun is a South Korean actor. One of the highest-paid actors in South Korea, his accolades include four Baeksang Arts Awards, two Grand Bell Awards and one Blue Dragon Film Award. From 2012 to 2016 and in 2021, he has appeared in Forbes Korea Power Celebrity 40 list.', 'February 16, 1988', 'Actor', 'Undisclosed', NULL, 0x736f6f206879756e2e6a706567, 'popular', 'Actor'),
(43, 'LEE DONG-WOOK', 'Lee Dong-wook is a South Korean actor, host, model and entertainer. He is best known for his leading roles in the television dramas My Girl, Scent of a Woman, The Fugitive of Joseon, Hotel King, Guardian: ...', 'November 6, 1981', 'ACTOR / MODEL', 'Undisclosed', NULL, 0x646f6e6720776f6f6b2e6a706567, 'popular', 'Actor'),
(44, 'PARK HYUNG-SIK', 'Park Hyung-sik is a South Korean actor, singer and dancer. After three years of training, he debuted as a member of the South Korean boy group ZE:A in 2010.', '16 November 1991', 'ACTOR / SINGER', 'Undisclosed', NULL, 0x73696b2e6a706567, 'popular', 'Actor'),
(45, 'OK TAEC-YEON', 'Ok Taec-yeon, known mononymously as Taecyeon, is a South Korean rapper, singer, songwriter, actor and entrepreneur. He is the rapper of the South Korean boy band 2PM.', '27 December 1988', 'RAPPER / SINGER / SONGWRITER', 'Undisclosed', NULL, 0x4f4b2e6a706567, 'popular', 'Actor'),
(46, 'CHA EUN-WOO', 'Lee Dong-min, known professionally as Cha Eun-woo, is a South Korean singer, actor, and model under the label Fantagio. He is a member of the South Korean boy band Astro.', '30 March 1997', 'SINGER / ACTOR  / MODEL', 'Undisclosed', NULL, 0x6368612e706e67, 'popular', 'Actor'),
(47, 'LEE DONG-HAE', 'Lee Dong-hae, referred to as Donghae, is a South Korean singer, songwriter, composer and actor. He became a trainee under SM Entertainment after winning a prize at SM\'s Youth Best Contest in 2001. After four years of training, Donghae debuted as a member of boy group Super Junior in November 2005.', '15 October 1986', 'SINGER / SONGWRITER', 'Undisclosed', NULL, 0x6861652e6a706567, 'popular', 'Actor'),
(48, 'KIM RYEOWOOK', 'Kim Ryeo-wook, better known by the mononym Ryeowook, is a South Korean singer, songwriter and musical actor.', '21 June 1987', 'SINGER / SONGWRITER', 'Undisclosed', NULL, 0x5279656f776f6f6b2e6a706567, 'popular', 'Actor'),
(49, 'CHOI SI-WON', 'Choi Si-won, known mononymously as Siwon, is a South Korean singer, songwriter, model, and actor known for his work as a member of South Korean boy group Super Junior.', '7 April 1986', 'SINGER / SONGWRITER', 'Undisclosed', NULL, 0x776f6e2e6a706567, 'popular', 'Actor'),
(50, 'HAN GENG', 'Han Geng is a Chinese Mandopop singer and actor. He started his career in 2001, when he was chosen by S.M. Entertainment to become a member of South Korean boy band Super Junior, which debuted in 2005. He later became the leader of its sub-group Super Junior-M in 2008.', '9 February 1984', 'ACTOR / SINGER', 'Undisclosed', NULL, 0x68616e2e6a706567, 'popular', 'Actor'),
(51, 'JUSTIN CHEUNG', 'Justin Cheung is an actor born and raised in Hong Kong. He is known for his breakthrough role as, Cocky, on OCTB. OCTB was renewed for a second and third season. Deception Of The Novelist is Cheung\'s first film as a producer and lead, released in theaters in 2019 with limited screenings in the the United States.', '11 March 1983', 'Actor / SHOW HOST', 'Undisclosed', NULL, 0x436865756e672e77656270, 'popular', 'Actor'),
(52, 'LOUIS CHEUNG', 'Louis Cheung is a Hong Kong singer, songwriter, and actor. He is an alumnus of The Hong Kong Academy for Performing Arts, majoring in acting. His first play was in 1997, and he has performed in a total of more than 20 stage plays, including the classic &amp;quot;A Streetcar Named Desire&amp;quot;, in which he played Stanley Kowalski.', '11 January 1980', 'SINGER / SONGWRITER', 'Undisclosed', NULL, 0x4c6f7569735f436865756e672e6a706567, 'popular', 'Actor'),
(53, 'LOUIS KOO', 'Louis Koo Tin-lok is a Hong Kong actor, singer and film producer. He began his professional career as an actor in local television series, winning TVB\'s Best Actor award in 1999 and 2001. After 2001, he fully focused on film career and became one of the stalwarts of the Hong Kong film industry.', '21 October 1970', 'ACTOR / MODEL / FILM PRODUCER', 'Undisclosed', NULL, 0x6b6f6f2e6a706567, 'popular', 'Actor'),
(54, 'JUNG WOO-SUNG', 'Jung Woo-sung is a South Korean actor and the first Korean UNHCR Goodwill Ambassador. Jung started his career as a fashion model, rising to stardom and teenage cult status with the gangster film Beat, for which he won Best New Actor at the 17th Korean Association of Film Critics Awards.', '22 April 1973', 'ACTOR / DIRECTOR / PRODUCER', 'Undisclosed', NULL, 0x4a756e672d576f6f2d73756e672d2e6a706567, 'popular', 'Actor'),
(55, 'MICHELE MORRONE', 'Michele Morrone is an Italian actor, model, singer, and fashion designer appearing in both Italian and Polish films. He gained international recognition after portraying the role of Massimo Torricelli in the 2020 erotic romantic drama 365 Days.', '3 October 1990', 'ACTOR / SINGER / MODEL', 'Undisclosed', NULL, 0x4d494348454c452e6a706567, 'popular', 'Actor'),
(56, 'GADO LD', 'ggool', '02/01/1990', 'business', '£‎2900', NULL, 0x322e6a7067, 'top', 'Musician, Singer, Songwriter, Producer, and Guitarist'),
(57, 'LUIS MIGUEL', 'Luis Miguel Gallego Basteri is a Mexican singer. Born to parents of Spanish and Italian descent, he is often referred to as El Sol de Mexico, derived from the nickname his mother gave him as a child: &amp;amp;quot;Mi sol&amp;amp;quot;.', '19 April 1970', 'SINGER', 'Undisclosed', NULL, 0x4c7569735f4d696775656c2e6a7067, 'top', 'SINGER'),
(58, 'LEE SOO-HYUK', 'Lee Hyuk-soo is debuted as a model in designer Jung Wook-jun\'s Lone Costume fashion show in 2006. He walked down the runways of the nation\'s famous fashion brands including General Idea and Song Zio, and did cover shoots for several renowned fashion magazines such as GQ, Bazaar and Elle.', '31 May 1988', 'Model, Actor', 'Undisclosed ', NULL, 0x6c656520736f6f2e706e67, 'top', 'Actor'),
(59, 'WI HA-JOON', 'Wi Ha-joon is a South Korean actor and model. He is best known for his roles in the films Gonjiam: Haunted Asylum, Shark: The Beginning and Midnight, as well as the television series Something in the Rain, Romance Is a Bonus Book, 18 Again, and Squid Game, the lattermost of which brought him international fame.', '5 August 1991', 'Actor-model', 'Undisclosed', NULL, 0x6a6f6f6e2e6a706567, 'popular', 'Actor');

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

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

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

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

