-- MySQL dump 10.13  Distrib 5.7.44, for Linux (x86_64)
--
-- Host: localhost    Database: indigon4_entertainment
-- ------------------------------------------------------
-- Server version	5.7.44

/*!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 utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `entertainment`
--

DROP TABLE IF EXISTS `entertainment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `entertainment` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `category` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Live Music|Performers|Specialty Acts|Experience-Based',
  `sub_category` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Band|Acoustic|Jazz|DJ|DJ + Live Hybrid|Magician|Comedian|MC / Host|Dancers|Aerialists|Fire performers|LED / glow shows|Cirque-style|Wine educators|Sommeliers|Cooking demos|Mixologists',
  `tags` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'comma-separated: cover,tribute,jazz,acoustic,string,ceremony,roaring-20s,yacht-rock',
  `recommended_for` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'e.g. Corporate Gala, Cocktail Hour, Wedding',
  `description` text COLLATE utf8mb4_unicode_ci,
  `location` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'e.g. Napa / Sonoma / SF',
  `phone` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `website` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `photo_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `video_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_featured` tinyint(1) NOT NULL DEFAULT '0',
  `is_high_energy` tinyint(1) NOT NULL DEFAULT '0',
  `is_luxury` tinyint(1) NOT NULL DEFAULT '0',
  `is_large_scale` tinyint(1) NOT NULL DEFAULT '0',
  `status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_category` (`category`),
  KEY `idx_sub_category` (`sub_category`),
  KEY `idx_status` (`status`),
  KEY `idx_is_featured` (`is_featured`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `entertainment`
--

LOCK TABLES `entertainment` WRITE;
/*!40000 ALTER TABLE `entertainment` DISABLE KEYS */;
INSERT INTO `entertainment` VALUES (1,'The Cheeseballs','Live Music','Band','cover,party','Corporate Gala, Large Events','High-energy corporate party band covering top hits from every decade.','San Francisco, CA',NULL,NULL,'https://www.thecheeseballs.com','https://cdn0.weddingwire.com/solic/6/5/2/3/0/0/t10_2x_the-cheeseballs_51_30256.webp',NULL,1,1,1,1,'active','2026-03-27 14:19:15','2026-03-27 14:19:15'),(2,'Pop Rocks','Live Music','Band','cover,party','Corporate Events, Weddings','Top Bay Area dance band delivering non-stop energy on the dance floor.','San Francisco, CA',NULL,NULL,'https://www.poprocksband.com','https://cdn0.weddingwire.com/solic/8/7/0/3/1/0/t10_2x_pop-rocks-band_51_103078.webp',NULL,1,1,1,1,'active','2026-03-27 14:19:15','2026-03-27 14:19:15'),(3,'Lucky Devils Band','Live Music','Band','cover,party','Corporate Gala, Conferences','Premium event band with a massive repertoire of crowd-pleasing hits.','San Francisco, CA',NULL,NULL,'https://www.luckydevilsband.com','https://cdn0.weddingwire.com/solic/5/7/2/1/0/0/t10_2x_lucky-devils-band_51_10275.webp',NULL,1,1,1,1,'active','2026-03-27 14:19:15','2026-03-27 14:19:15'),(4,'Neon Velvet','Live Music','Band','cover,luxury','Luxury Events, Corporate','High-end performance band specializing in upscale corporate and private events.','San Francisco, CA',NULL,NULL,'https://www.neonvelvet.com',NULL,NULL,1,1,1,1,'active','2026-03-27 14:19:15','2026-03-27 14:19:15'),(5,'Hip Service','Live Music','Band','cover,corporate','Tech Events, Corporate Parties','Corporate-focused band with deep experience in tech and conference events.','San Francisco, CA',NULL,NULL,'https://www.hipservice.com',NULL,NULL,1,1,1,1,'active','2026-03-27 14:19:15','2026-03-27 14:19:15'),(6,'Mustache Harbor','Live Music','Band','yacht-rock,cover','Corporate Parties, Themed Events','The Bay Area\'s premier yacht rock band — smooth, fun, and unforgettable.','San Francisco, CA',NULL,NULL,'https://www.mustacheharbor.com','https://assets.simpleviewinc.com/simpleview/image/upload/c_fill,h_600,q_75,w_800/v1/crm/sanjose/Mustache-Harbor_1.jpg',NULL,1,1,1,1,'active','2026-03-27 14:19:15','2026-03-27 14:19:15'),(7,'Tainted Love','Live Music','Band','tribute,cover','Corporate Events, Large Parties','The ultimate 80s tribute band bringing the decade back to life.','San Francisco, CA',NULL,NULL,'https://www.taintedlove.com',NULL,NULL,1,1,1,1,'active','2026-03-27 14:19:15','2026-03-27 14:19:15'),(8,'Fast Times','Live Music','Band','tribute,cover','Corporate Events','80s party band with authentic costumes and a massive hit list.','San Francisco, CA',NULL,NULL,'https://www.fasttimesband.com',NULL,NULL,1,1,1,1,'active','2026-03-27 14:19:15','2026-03-27 14:19:15'),(9,'The Spazmatics','Live Music','Band','tribute,cover','Corporate Events','National touring 80s act with theatrical costumes and full production.','Bay Area, CA',NULL,NULL,'https://www.thespazmatics.com',NULL,NULL,1,1,1,1,'active','2026-03-27 14:19:15','2026-03-27 14:19:15'),(10,'The Purple Ones','Live Music','Band','tribute','Corporate Events, Galas','The Bay Area\'s most celebrated Prince tribute band.','Bay Area, CA',NULL,NULL,NULL,NULL,NULL,1,1,1,1,'active','2026-03-27 14:19:15','2026-03-27 14:19:15'),(11,'Boutique DJs','DJ',NULL,NULL,'Corporate Events, Conferences','Top-tier corporate DJ company serving Fortune 500 clients across the Bay Area.','San Francisco, CA',NULL,NULL,'https://www.boutiquedjs.com','https://lh3.googleusercontent.com/p/AF1QipNft0JK2gNW3CvYxHkxyu2BMqL4RUWTHSKEhupO=s1360-w1360-h1020-rw',NULL,1,1,1,1,'active','2026-03-27 14:19:15','2026-03-27 21:38:28'),(12,'Bay Area Beats DJs','DJ',NULL,NULL,'Corporate Events, Weddings','15+ years experience with Indian, Mexican, Jewish, Arabic and most types of weddings, including of course…American weddings! Our DJs specialize in making your wedding dreams come true!','San Francisco, CA',NULL,NULL,NULL,'https://indigo-live-images.s3.us-west-1.amazonaws.com/entertainment/img_69c76b43cc0c63.79179736.webp',NULL,1,1,1,1,'active','2026-03-27 14:19:15','2026-03-27 22:46:44'),(13,'DART Collective','DJ',NULL,'corporate,luxury','Luxury Events, Corporate','DJ + live musicians hybrid — saxophone, percussion, and more layered over DJ sets.','San Francisco, CA',NULL,NULL,'https://www.dartcollective.com',NULL,NULL,1,1,1,1,'active','2026-03-27 14:19:15','2026-03-27 20:45:45'),(14,'Golden Bell Music','DJ',NULL,'hybrid,luxury','Corporate Events, Luxury','DJ + live performers creating a unique hybrid entertainment experience.','Bay Area, CA',NULL,NULL,NULL,NULL,NULL,1,1,1,1,'active','2026-03-27 14:19:15','2026-03-27 20:45:45'),(15,'DJ E-Rock','DJ',NULL,'club,corporate','Corporate Events, Nightlife','Radio personality and professional DJ with decades of Bay Area event experience.','San Francisco, CA',NULL,NULL,NULL,NULL,NULL,1,1,1,1,'active','2026-03-27 14:19:15','2026-03-27 20:45:45'),(16,'Jay Alexander','Performers','Magician','corporate','Corporate Events, Galas','Award-winning Bay Area magician specializing in close-up and stage magic.','San Francisco, CA',NULL,NULL,'https://www.jayalexander.com',NULL,NULL,1,0,1,1,'active','2026-03-27 14:19:15','2026-03-27 14:19:15'),(17,'Robert Strong','Performers','Magician','corporate','Corporate Events','Award-winning magician and mentalist with national TV credits.','San Francisco, CA',NULL,NULL,'https://www.robertstrong.com',NULL,NULL,1,0,1,1,'active','2026-03-27 14:19:15','2026-03-27 14:19:15'),(18,'Dana Daniels','Performers','Magician','comedy','Corporate Events','Comedy magician with a hilarious parrot sidekick — perfect for corporate dinners.','Bay Area, CA',NULL,NULL,NULL,NULL,NULL,1,0,1,1,'active','2026-03-27 14:19:15','2026-03-27 14:19:15'),(19,'Michael O\'Brien','Speakers & Hosts','MC / Host','corporate','Corporate Conferences, Awards Shows','Professional MC and host with extensive corporate event experience.','San Francisco, CA',NULL,NULL,NULL,NULL,NULL,1,0,1,1,'active','2026-03-27 14:19:15','2026-03-27 20:49:35'),(20,'Johnny Steele','Performers','Comedian','comedy','Corporate Events, Dinners','Clean corporate comedian who tailors material to your audience and industry.','San Francisco, CA',NULL,NULL,NULL,NULL,NULL,1,0,1,1,'active','2026-03-27 14:19:15','2026-03-27 14:19:15'),(22,'Vau de Vire Society','Specialty Acts','Dancers','luxury','Corporate Events, Galas','Cirque-style performers and dancers creating immersive theatrical experiences.','San Francisco, CA',NULL,NULL,'https://www.vaudeviresociety.com',NULL,NULL,1,1,1,1,'active','2026-03-27 14:19:15','2026-03-27 14:19:15'),(23,'Fire Groove','Specialty Acts','Fire Performer',NULL,'Outdoor Events, Festivals','Professional fire performance group for outdoor events and festivals.','Bay Area, CA',NULL,NULL,NULL,NULL,NULL,1,1,1,1,'active','2026-03-27 14:19:15','2026-03-27 14:19:15'),(24,'LED Flow Artists','Specialty Acts','LED Performer',NULL,'Tech Events, Night Events','LED and glow performance group perfect for tech events and evening galas.','San Francisco, CA',NULL,NULL,NULL,NULL,NULL,1,1,1,1,'active','2026-03-27 14:19:15','2026-03-27 14:19:15'),(26,'Master Sommelier Emily Wines','Experiences','Sommelier','wine,luxury','Corporate Dinners, Wine Tastings','World-class sommelier offering guided tastings and wine education for corporate events.','Napa, CA',NULL,NULL,NULL,NULL,NULL,1,0,1,0,'active','2026-03-27 14:19:15','2026-03-27 14:19:15'),(27,'The Perfect Pour','Experiences','Mixologist','cocktail','Corporate Events, Cocktail Hours','Craft cocktail service with custom menu creation for corporate and private events.','San Francisco, CA',NULL,NULL,NULL,NULL,NULL,1,0,1,0,'active','2026-03-27 14:19:15','2026-03-27 14:19:15'),(28,'Chef Tyler Florence Events','Experiences','Chef Experience',NULL,'Corporate Dinners, VIP Events','Celebrity chef experience featuring interactive cooking demonstrations and curated menus.','Bay Area, CA',NULL,NULL,NULL,'https://www.instagram.com/paulvitagliano/reel/DVQ-B93ESvD',NULL,1,0,1,0,'active','2026-03-27 14:19:15','2026-03-27 21:55:45'),(29,'Scott McKain','Speakers & Hosts','Speaker','corporate','Corporate Conferences','Hall of Fame keynote speaker on customer experience and business distinction.','San Francisco, CA',NULL,NULL,NULL,NULL,NULL,1,0,1,1,'active','2026-03-27 14:19:15','2026-03-27 14:19:15'),(30,'Garrison Wynn','Speakers & Hosts','Speaker','corporate','Corporate Conferences, Incentive Events','Comedian and motivational speaker combining humor with actionable business insights.','Bay Area, CA',NULL,NULL,NULL,NULL,NULL,1,0,1,1,'active','2026-03-27 14:19:15','2026-03-27 14:19:15'),(31,'Professional Auction Services','Speakers & Hosts','Auctioneer',NULL,'Fundraisers, Charity Galas','Experienced charity auctioneer maximizing revenue for nonprofit and corporate fundraisers.','San Francisco, CA',NULL,NULL,NULL,NULL,NULL,1,0,1,1,'active','2026-03-27 14:19:15','2026-03-27 14:19:15');
/*!40000 ALTER TABLE `entertainment` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `entertainment_photos`
--

DROP TABLE IF EXISTS `entertainment_photos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `entertainment_photos` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `entertainment_id` int(10) unsigned NOT NULL,
  `photo_url` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_primary` tinyint(1) NOT NULL DEFAULT '0',
  `sort_order` int(10) unsigned NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_ent_id` (`entertainment_id`),
  KEY `idx_primary` (`is_primary`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `entertainment_photos`
--

LOCK TABLES `entertainment_photos` WRITE;
/*!40000 ALTER TABLE `entertainment_photos` DISABLE KEYS */;
INSERT INTO `entertainment_photos` VALUES (2,12,'https://indigo-live-images.s3.us-west-1.amazonaws.com/entertainment/img_69c76b43cc0c63.79179736.webp',1,1,'2026-03-27 22:46:44'),(3,12,'https://indigo-live-images.s3.us-west-1.amazonaws.com/entertainment/img_69c76b5f2d9b54.94534619.webp',0,2,'2026-03-27 22:47:12');
/*!40000 ALTER TABLE `entertainment_photos` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-03-28 13:32:11
