--
-- Host: localhost    Database: nomadic_dev
-- ------------------------------------------------------


--
-- Table structure for table `booking_details`
--

CREATE TABLE `booking_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `booking_id` varchar(50) NOT NULL,
  `location_id` int DEFAULT NULL,
  `type` enum('studio','resource','rental') NOT NULL,
  `resource_id` int DEFAULT NULL,
  `equipment_id` int DEFAULT NULL,
  `studio_id` int DEFAULT NULL,
  `resource_type` int DEFAULT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `start_time` time NOT NULL,
  `end_time` time NOT NULL,
  `points` int DEFAULT '0',
  `data` text,
  `status` tinyint NOT NULL COMMENT '0=pending,1=complete,2=cancel',
  `created_by` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `booking_details`
--

INSERT INTO `booking_details` VALUES (1,'19743567',1,'studio',NULL,NULL,1,NULL,'2023-12-07','2023-12-07','08:00:00','10:00:00',50,NULL,0,1,1,'2023-12-05 10:55:06','2023-12-05 10:55:06'),(2,'19743567',1,'resource',1,NULL,NULL,1,'2023-12-07','2023-12-07','08:00:00','10:00:00',30,NULL,0,1,1,'2023-12-05 10:55:06','2023-12-05 10:55:06'),(4,'19743567',1,'rental',NULL,1,NULL,NULL,'2023-12-14','2023-12-21','08:00:00','10:00:00',10,NULL,1,1,1,'2023-12-05 10:55:06','2023-12-05 10:55:06'),(21,'1706119573',1,'resource',13,NULL,NULL,NULL,'2024-01-15','2024-01-15','09:00:00','11:00:00',2,'{\"hourly\":[\"2|2\"]}',2,7,NULL,NULL,'2024-01-28 18:11:51'),(20,'1706119573',1,'rental',NULL,3,NULL,NULL,'2024-01-15','2024-01-15','09:00:00','11:00:00',18,'{\"hourly\":[\"2|18\"]}',2,7,NULL,NULL,'2024-01-28 18:11:51'),(19,'1706119573',1,'studio',NULL,NULL,2,NULL,'2024-01-15','2024-01-15','09:00:00','11:00:00',30,'{\"hourly\":[\"2|30\"]}',2,7,NULL,NULL,'2024-01-28 18:11:51');

--
-- Table structure for table `booking_master`
--

CREATE TABLE `booking_master` (
  `id` int NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) NOT NULL,
  `booking_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `location_id` int NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `start_time` time NOT NULL,
  `end_time` time NOT NULL,
  `status` tinyint NOT NULL COMMENT '0=pending,1=complete,2=cancel',
  `total_points` int NOT NULL,
  `created_by` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `booking_master`
--

INSERT INTO `booking_master` VALUES (1,'06238d85-b98e-4ee2-8944-17cb88989117','19743567',1,'2023-12-07','2023-12-07','08:00:00','10:00:00',0,80,1,1,'2023-12-09 15:00:46','2023-12-09 15:00:46'),(3,'06238d85-b98e-4ee2-8944-17cb87274117','1706118153',1,'2024-01-15','2024-01-15','09:00:00','11:00:00',0,50,7,NULL,'2024-01-24 17:42:33','2024-01-24 17:42:33'),(10,'06238d85-b98e-4ee2-8944-17cb87274117','1706119573',1,'2024-01-15','2024-01-15','09:00:00','11:00:00',2,50,7,NULL,'2024-01-24 18:06:13','2024-01-28 18:11:51');

--
-- Table structure for table `currency`
--

CREATE TABLE `currency` (
  `id` int NOT NULL AUTO_INCREMENT,
  `currency` varchar(191) DEFAULT NULL,
  `rate` decimal(10,2) DEFAULT NULL,
  `date` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `currency`
--

INSERT INTO `currency` VALUES (1,'AUD',1.58,'2023-10-04 16:31:57'),(2,'EUR',0.95,'2023-10-04 16:31:57');

--
-- Table structure for table `equipment_category`
--

CREATE TABLE `equipment_category` (
  `id` int NOT NULL AUTO_INCREMENT,
  `cat_name` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `equipment_category`
--

INSERT INTO `equipment_category` VALUES (1,'Cameras','2023-10-20 10:27:12','2023-10-20 10:27:12'),(2,'DJ equipment','2023-10-20 10:27:31','2023-10-20 10:27:31'),(3,'Studio equipment','2023-10-20 10:27:50','2023-10-20 10:27:50');

--
-- Table structure for table `equipment_specialist`
--

CREATE TABLE `equipment_specialist` (
  `id` int NOT NULL AUTO_INCREMENT,
  `location_id` int NOT NULL,
  `user_uuid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `resource_type` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `equipment_specialist`
--

INSERT INTO `equipment_specialist` VALUES (1,1,'1',2,'2023-10-20 10:28:23','2023-10-20 10:28:23'),(6,1,'06238d85-b98e-4ee2-8944-17cb87274117',2,'2024-01-28 12:45:56','2024-01-28 12:45:56');

--
-- Table structure for table `equipments`
--

CREATE TABLE `equipments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `studios_id` int NOT NULL DEFAULT '0',
  `location_id` int NOT NULL DEFAULT '0',
  `photo` varchar(100) DEFAULT NULL,
  `name` varchar(100) NOT NULL,
  `category` int NOT NULL,
  `description` text,
  `serial_number` varchar(50) NOT NULL,
  `price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `cost_per_day` decimal(10,2) NOT NULL DEFAULT '0.00',
  `cost_per_hour` decimal(10,2) NOT NULL DEFAULT '0.00',
  `receipt` varchar(50) DEFAULT NULL,
  `note` text,
  `manual` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `manual_link` varchar(255) DEFAULT NULL,
  `specialist` int DEFAULT '0',
  `status` tinyint NOT NULL DEFAULT '1' COMMENT '0=Unavailable,1=Available',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `equipments`
--

INSERT INTO `equipments` VALUES (1,0,1,'1703435857_OIP.png','Pioneer DJM V1000000',2,'this equipment very useful this equipment very useful','0878-6060-0432',177.22,200.00,40.00,'1703245649_Account settings (2).jpg','note','1703245689_Account settings (7).jpg','http://test.com',1,1,'2023-10-20 10:28:23','2024-01-28 12:14:05'),(2,1,1,'','Pioneer V20',2,'this equipment very useful','0878-6060-0432',158.23,200.00,40.00,NULL,NULL,NULL,NULL,1,0,'2023-10-20 04:58:23','2024-01-28 12:13:45'),(3,0,1,'1703435857_OIP.png','Test equipment',1,'description...','DDGHH44388N',25.32,6.33,8.86,'1703435875_events1.png','NOTE...','1706381187_Invoice - 0009.pdf','http://test.com',1,1,'2023-12-24 17:02:52','2024-01-28 12:54:29'),(4,1,0,NULL,'Test studio',1,'description..','89DF333',95.32,0.00,0.00,'1703438391_events1.png','notes....','1703438391_EAadhaar_0013670060376120220703121158_24122023162744.pdf',NULL,0,1,'2023-12-24 17:19:51','2024-01-28 12:14:58');

--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `event_id` int NOT NULL AUTO_INCREMENT,
  `location_id` int NOT NULL,
  `user_uuid` varchar(191) NOT NULL,
  `event_type` varchar(50) DEFAULT NULL,
  `public_private` varchar(50) DEFAULT NULL,
  `stream_url` varchar(100) DEFAULT NULL,
  `event_title` varchar(100) DEFAULT NULL,
  `event_date` date DEFAULT NULL,
  `event_time` time DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `ticket_price` int DEFAULT NULL,
  `ticket_url` varchar(100) DEFAULT NULL,
  `thumbnail` varchar(100) DEFAULT NULL,
  `description` text,
  `event_status` tinyint NOT NULL DEFAULT '1',
  `created_by` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`event_id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `events`
--

INSERT INTO `events` VALUES (1,1,'06238d85-b98e-4ee2-8944-17cb88989117','online','public','test.com','Music event','2023-12-23','15:38:00','Bali, Hall C',20,'http://test.com','1707047504.png','<p>Embark on a journey with Nomadic Events &ndash; where every moment becomes an adventure. Join us for an unforgettable experience filled with laughter, connection, and the thrill of exploring new horizons. It\'s more than an event; it\'s a celebration of wanderlust and shared stories. Be part of the Nomadic community and let the extraordinary unfold.</p>',1,1,1,'2023-10-22 10:11:29','2024-02-04 11:51:44');

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `gallery`
--

CREATE TABLE `gallery` (
  `id` int NOT NULL AUTO_INCREMENT,
  `type` varchar(50) DEFAULT NULL,
  `image_type` varchar(50) NOT NULL,
  `ref_id` int DEFAULT NULL,
  `image_url` varchar(191) DEFAULT NULL,
  `description` text,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `gallery`
--

INSERT INTO `gallery` VALUES (15,'location','gallery',1,'1703713567.png',NULL,'2023-12-27 21:46:07','2023-12-27 21:46:07'),(21,'location','benefit',1,'1703717694.png','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit.</p>','2023-12-27 22:54:54','2023-12-27 22:54:54'),(43,'studio','gallery',3,'1707044047.png',NULL,'2024-02-04 10:54:07','2024-02-04 10:54:07'),(16,'location','gallery',1,'1703713576.png',NULL,'2023-12-27 21:46:16','2023-12-27 21:46:16'),(17,'location','gallery',1,'1703713587.png',NULL,'2023-12-27 21:46:27','2023-12-27 21:46:27'),(18,'location','gallery',1,'1703713597.png',NULL,'2023-12-27 21:46:37','2023-12-27 21:46:37'),(19,'location','gallery',1,'1703713611.png',NULL,'2023-12-27 21:46:51','2023-12-27 21:46:51'),(20,'location','gallery',1,'1703713695.png',NULL,'2023-12-27 21:48:15','2023-12-27 21:48:15'),(22,'location','benefit',1,'1703717714.png','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit.</p>','2023-12-27 22:55:14','2023-12-27 22:55:14'),(23,'location','benefit',1,'1703717722.png','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit.</p>','2023-12-27 22:55:22','2023-12-27 22:55:22'),(24,'location','benefit',1,'1703717732.png','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit.</p>','2023-12-27 22:55:32','2023-12-27 22:55:32'),(26,'studio','gallery',3,'1703761465.png',NULL,'2023-12-28 11:04:25','2023-12-28 11:04:25'),(27,'studio','gallery',3,'1703761469.png',NULL,'2023-12-28 11:04:29','2023-12-28 11:04:29'),(41,'location','gallery',1,'1707038486.png',NULL,'2024-02-04 09:21:26','2024-02-04 09:21:26');

--
-- Table structure for table `guest_data`
--

CREATE TABLE `guest_data` (
  `id` int NOT NULL AUTO_INCREMENT,
  `guest_event_id` int DEFAULT NULL,
  `fname` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `lname` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `mobile_number` varchar(100) DEFAULT NULL,
  `status` tinyint NOT NULL COMMENT '0=pending,1=complete',
  `created_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `guest_data`
--

INSERT INTO `guest_data` VALUES (1,1,'Sudhir 12','Bhadauria 12','abcd@gmail.com','878787878777',0,1,'2024-01-18 18:43:26','2024-01-18 18:43:26'),(2,1,'Sudhir 12','Bhadauria 12','abcd@gmail.com','878787878777',0,1,'2024-01-20 11:18:01','2024-01-20 11:18:01');

--
-- Table structure for table `landing_pages`
--

CREATE TABLE `landing_pages` (
  `id` int NOT NULL AUTO_INCREMENT,
  `type` varchar(100) DEFAULT NULL,
  `location_id` int DEFAULT NULL,
  `banner_picture` varchar(191) DEFAULT NULL,
  `description` text,
  `studios` varchar(255) DEFAULT NULL,
  `our_crew` varchar(191) DEFAULT NULL,
  `address` text,
  `opening_hours` mediumtext,
  `phone` varchar(13) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `how_to_get_there` text,
  `equipment_ids` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `landing_pages`
--

INSERT INTO `landing_pages` VALUES (1,'location',1,'1707038637.png','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent tristique leo vitae purus lacinia, ut euismod nulla viverra. Duis rutrum fringilla vestibulum.</p>','1,3,4,5','1,3,5','asdsds','testing...','+918786564378','sudhir.bhadauria18@gmail.com','testing...',NULL,'2023-10-07 18:18:00','2024-02-04 09:23:57'),(3,'studio',1,'1707046176.png','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent tristique leo vitae purus lacinia, ut euismod nulla viverra.</p>','1','1,3,5',NULL,NULL,NULL,NULL,NULL,'1','2023-10-20 10:53:23','2024-02-04 11:29:36'),(9,'studio',1,'1707046218.png','<p>content...</p>','2','1,3,5',NULL,NULL,NULL,NULL,NULL,'1,2,3','2024-01-15 16:31:03','2024-02-04 11:30:18'),(4,'location',2,'1703709959.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-12-26 07:45:02','2023-12-27 20:45:59'),(5,'location',3,'1703709978.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-12-26 07:46:31','2023-12-27 20:46:18'),(6,'location',4,'1703709593.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-12-27 20:39:53'),(7,'location',15,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-12-27 20:58:11','2023-12-27 20:58:11'),(8,'location',16,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-12-27 20:59:13','2023-12-27 20:59:13');

--
-- Table structure for table `language`
--

CREATE TABLE `language` (
  `id` int NOT NULL AUTO_INCREMENT,
  `language` varchar(191) NOT NULL,
  `iso_code` varchar(50) NOT NULL,
  `status` tinyint NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `language`
--

INSERT INTO `language` VALUES (1,'English','eg',1),(2,'Spanish','sp',1);

--
-- Table structure for table `location`
--

CREATE TABLE `location` (
  `id` int NOT NULL AUTO_INCREMENT,
  `location` varchar(191) NOT NULL,
  `slug` varchar(100) NOT NULL,
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `location`
--

INSERT INTO `location` VALUES (1,'Bali','bali','2023-09-23 12:13:51','2023-09-23 12:13:51'),(2,'Bangkok','bangkok','2023-09-23 12:14:36','2023-09-24 02:48:52'),(3,'Mexico','mexico','2023-09-23 12:15:13','2023-09-23 12:15:13'),(4,'Costa Rica','costa-rica','2023-09-23 12:15:13','2023-09-23 12:15:13');

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (8,'2019_05_03_000001_create_customer_columns',4),(3,'2019_05_03_000002_create_subscriptions_table',2),(4,'2019_05_03_000003_create_subscription_items_table',2),(5,'2019_08_19_000000_create_failed_jobs_table',2),(6,'2019_12_14_000001_create_personal_access_tokens_table',2),(7,'2023_09_13_222450_create_plans_table',3);

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
  `id` int NOT NULL AUTO_INCREMENT,
  `location_id` int NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `tags` text,
  `banner` varchar(100) DEFAULT NULL,
  `heading_intro` varchar(100) DEFAULT NULL,
  `para_intro` text,
  `heading_elaboration` varchar(100) DEFAULT NULL,
  `para_elaboration` text,
  `conclusion_picture` varchar(100) DEFAULT NULL,
  `heading_conclusion` varchar(100) DEFAULT NULL,
  `para_conclusion` text,
  `status` tinyint NOT NULL DEFAULT '1',
  `created_by` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `news`
--

INSERT INTO `news` VALUES (1,1,'Travel as a failure','Travel','1707674299.png','A story about a trip to Barcelona','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent tristique leo vitae purus lacinia, ut euismod nulla viverra. Duis rutrum fringilla vestibulum. Quisque gravida, tortor eget accumsan aliquet.</p>','A story about a trip to Barcelona 2','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent tristique leo vitae purus lacinia, ut euismod nulla viverra. Duis rutrum fringilla vestibulum. Quisque gravida, tortor eget accumsan aliquet.</p>','1707672324.png','A story about a trip to Barcelona 3','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent tristique leo vitae purus lacinia, ut euismod nulla viverra. Duis rutrum fringilla vestibulum. Quisque gravida, tortor eget accumsan aliquet.</p>',1,7,1,'2023-10-25 18:30:00','2024-02-11 23:28:19'),(3,1,'Travel as a fresh','Travel','1707048729.png','A story about travel','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent tristique leo vitae purus lacinia, ut euismod nulla viverra. Duis rutrum fringilla vestibulum. Quisque gravida, tortor eget accumsan aliquet.</p>','A story about a trip to Barcelona 2','<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent tristique leo vitae purus lacinia, ut euismod nulla viverra. Duis rutrum fringilla vestibulum. Quisque gravida, tortor eget accumsan aliquet.</p>','1707050151.png',NULL,NULL,1,1,1,'2024-01-24 17:36:21','2024-02-04 12:35:51');

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user` varchar(128) NOT NULL,
  `type` varchar(100) DEFAULT NULL,
  `reference_id` int DEFAULT NULL,
  `action` varchar(100) DEFAULT NULL,
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `status` tinyint NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `notifications`
--

INSERT INTO `notifications` VALUES (1,'06238d85-b98e-4ee2-8944-17cb87274117','booking',1706119573,'cancelled','Your booking has been cancelled.',1,'2024-01-28 18:12:39','2024-02-03 07:20:34'),(3,'06238d85-b98e-4ee2-8944-17cb87274117','booking',1706119573,'confirmed','Your booking has been confirmed.',1,'2024-01-30 17:48:54','2024-02-03 07:20:34'),(2,'06238d85-b98e-4ee2-8944-17cb87274117','point',4,'POINTS_PURCHASED','You have purchased 20 points.',1,'2024-01-30 16:42:19','2024-02-03 07:20:34');

--
-- Table structure for table `participants`
--

CREATE TABLE `participants` (
  `id` int NOT NULL AUTO_INCREMENT,
  `event_id` int NOT NULL,
  `user_id` int NOT NULL,
  `status` enum('going','interested') NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `event_id` (`event_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `participants`
--

INSERT INTO `participants` VALUES (10,1,1,'interested','2024-01-06 11:41:00','2024-01-06 11:41:00'),(12,1,1,'going','2024-01-06 11:56:39','2024-01-06 11:56:39');

--
-- Table structure for table `plans`
--

CREATE TABLE `plans` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `stripe_plan` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `price` int NOT NULL,
  `frequency` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `points` int NOT NULL,
  `num_of_guest` int NOT NULL,
  `advance_duration` int NOT NULL,
  `advance_frequency` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `plans`
--

INSERT INTO `plans` VALUES (1,'Guest','guest','',0,'month',0,0,0,'','2023-09-13 13:00:00',NULL),(2,'Starving Artisit','starving-artist','price_1Nq5zgBfA6yrUxU00QrQXG2L',1149,'month',10500,1,1,'week','2023-09-13 11:40:12',NULL),(3,'Up and coming','up-and-coming','price_1Nq63MBfA6yrUxU0j1TyeglI',1899,'month',17500,2,1,'month','2023-09-12 13:00:00',NULL),(4,'Almost Famous','almost-famous','price_1Nq643BfA6yrUxU0jhgGkvy2',2500,'month',2500,4,3,'month','2023-09-12 13:00:00',NULL);

--
-- Table structure for table `points`
--

CREATE TABLE `points` (
  `id` int NOT NULL AUTO_INCREMENT,
  `action` enum('MEMBERSHIP_CREDIT','POINTS_PURCHASED','POINTS_RECEIVED','POINTS_SENT','BOOK_EVENT') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `receivedby_uuid` varchar(191) NOT NULL,
  `sentby_uuid` varchar(191) DEFAULT NULL,
  `invoice_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `plan_id` int DEFAULT NULL,
  `booking_id` varchar(191) DEFAULT NULL,
  `credit` int DEFAULT NULL,
  `debit` int DEFAULT NULL,
  `balance` int NOT NULL,
  `amount` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `points`
--

INSERT INTO `points` VALUES (1,'MEMBERSHIP_CREDIT','06238d85-b98e-4ee2-8944-17cb87274117',NULL,'in_1O159aBfA6yrUxU0E4FST3B0',2,NULL,10500,NULL,10500,10500,'2023-10-14 11:51:23','2023-10-14 11:51:23'),(2,'POINTS_RECEIVED','b12e7acb-9d91-4628-aabd-3a82c039d5c1','06238d85-b98e-4ee2-8944-17cb87274117',NULL,NULL,NULL,10,NULL,10,NULL,'2023-10-14 12:30:29','2023-10-14 12:30:29'),(3,'POINTS_SENT','06238d85-b98e-4ee2-8944-17cb87274117','b12e7acb-9d91-4628-aabd-3a82c039d5c1',NULL,NULL,NULL,NULL,10,10490,NULL,'2023-10-14 12:30:29','2023-10-14 12:30:29'),(4,'POINTS_PURCHASED','06238d85-b98e-4ee2-8944-17cb87274117',NULL,NULL,NULL,NULL,3,NULL,10493,3,'2023-10-17 19:22:02','2023-10-17 19:22:02');

--
-- Table structure for table `resource_types`
--

CREATE TABLE `resource_types` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `status` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `resource_types`
--

INSERT INTO `resource_types` VALUES (1,'Audio Engineer',1),(2,'Audio Technician',1),(3,'Camera Operator',1),(4,'Mastering Engineer',1),(5,'Photographer',1);

--
-- Table structure for table `resources`
--

CREATE TABLE `resources` (
  `id` int NOT NULL AUTO_INCREMENT,
  `location_id` int NOT NULL,
  `resourceId` int NOT NULL,
  `resource_type_id` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `resources`
--

INSERT INTO `resources` VALUES (1,1,14,5,'2023-12-09 15:25:40','2023-12-09 15:25:40'),(2,1,13,1,'2023-12-28 10:10:30','2023-12-28 10:10:30');

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

CREATE TABLE `roles` (
  `role_id` int NOT NULL AUTO_INCREMENT,
  `role_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `role_slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `type` varchar(50) DEFAULT NULL,
  `status` int DEFAULT '1',
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;

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

INSERT INTO `roles` VALUES (1,'Super Admin','super-admin','no-access',1),(2,'admin','admin','usertype',1),(3,'Location Manager','location-manager','access',1),(4,'Content Manager','content-manager','access',1),(5,'Event Manager','event-manager','access',1),(6,'Rental Manager','rental-manager','access',1),(7,'Member','member','usertype',1),(8,'Guest','guest','usertype',1);

--
-- Table structure for table `schedules`
--

CREATE TABLE `schedules` (
  `id` int NOT NULL AUTO_INCREMENT,
  `location_id` int DEFAULT NULL,
  `type` enum('studio','resource','rental') NOT NULL,
  `refrence_id` int NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `start_time` time NOT NULL,
  `end_time` time NOT NULL,
  `daily_rate` decimal(10,2) DEFAULT '0.00',
  `hourly_rate` decimal(10,2) DEFAULT '0.00',
  `schedule_type` varchar(50) DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=54 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `schedules`
--

INSERT INTO `schedules` VALUES (47,1,'resource',1,'2024-02-19','2024-02-19','08:00:00','17:00:00',1.00,1.00,'recurring',1,NULL,'2023-12-24 12:15:00',NULL),(46,1,'resource',1,'2024-02-12','2024-02-12','08:00:00','17:00:00',1.00,1.00,'recurring',1,NULL,'2023-12-24 12:15:00',NULL),(45,1,'resource',1,'2024-02-05','2024-02-05','08:00:00','17:00:00',1.00,1.00,'recurring',1,NULL,'2023-12-24 12:15:00',NULL),(44,1,'resource',1,'2024-01-29','2024-01-29','08:00:00','17:00:00',1.00,1.00,'recurring',1,NULL,'2023-12-24 12:15:00',NULL),(43,1,'resource',1,'2024-01-22','2024-01-22','08:00:00','17:00:00',1.00,1.00,'recurring',1,NULL,'2023-12-24 12:15:00',NULL),(42,1,'resource',13,'2024-01-15','2024-01-15','08:00:00','17:00:00',1.00,1.00,'recurring',1,NULL,'2023-12-24 12:15:00',NULL),(41,1,'resource',1,'2024-01-08','2024-01-08','08:00:00','17:00:00',1.00,1.00,'recurring',1,NULL,'2023-12-24 12:15:00',NULL),(40,1,'resource',1,'2024-01-01','2024-01-01','08:00:00','17:00:00',1.00,1.00,'recurring',1,NULL,'2023-12-24 12:15:00',NULL),(39,1,'resource',1,'2023-12-25','2023-12-25','09:00:00','17:00:00',1.00,1.00,'daily',1,1,'2023-12-24 12:15:00','2023-12-24 14:43:47'),(28,1,'studio',1,'2023-12-07','2023-12-07','08:00:00','17:00:00',10.00,10.00,'daily',1,1,'2023-12-24 08:26:49','2023-12-26 10:54:51'),(29,1,'rental',3,'2024-01-15','2024-01-15','08:00:00','17:00:00',7.00,9.00,'daily',1,NULL,'2023-12-24 11:03:02',NULL),(30,1,'studio',1,'2023-12-25','2023-12-25','08:00:00','17:00:00',1.00,2.00,'recurring',1,NULL,'2023-12-24 12:03:27',NULL),(31,1,'studio',1,'2024-01-01','2024-01-01','08:00:00','17:00:00',1.00,2.00,'recurring',1,NULL,'2023-12-24 12:03:27',NULL),(32,1,'studio',1,'2024-01-08','2024-01-08','08:00:00','17:00:00',1.00,2.00,'recurring',1,NULL,'2023-12-24 12:03:27',NULL),(33,1,'studio',1,'2024-01-15','2024-01-15','08:00:00','17:00:00',10.00,15.00,'recurring',1,NULL,'2023-12-24 12:03:27',NULL),(34,1,'studio',1,'2024-01-22','2024-01-22','08:00:00','17:00:00',1.00,2.00,'recurring',1,NULL,'2023-12-24 12:03:27',NULL),(35,1,'studio',1,'2024-01-29','2024-01-29','08:00:00','17:00:00',1.00,2.00,'recurring',1,NULL,'2023-12-24 12:03:27',NULL),(36,1,'studio',1,'2024-02-05','2024-02-05','08:00:00','17:00:00',1.00,2.00,'recurring',1,NULL,'2023-12-24 12:03:27',NULL),(37,1,'studio',1,'2024-02-12','2024-02-12','08:00:00','17:00:00',1.00,2.00,'recurring',1,NULL,'2023-12-24 12:03:27',NULL),(38,1,'studio',1,'2024-02-19','2024-02-19','08:00:00','17:00:00',1.00,2.00,'recurring',1,NULL,'2023-12-24 12:03:27',NULL),(48,1,'studio',1,'2024-01-16','2024-01-16','08:00:00','17:00:00',8.00,12.00,'daily',1,1,'2024-01-14 15:22:54',NULL),(49,1,'studio',1,'2024-01-17','2024-01-17','08:00:00','17:00:00',11.00,12.00,'daily',1,1,'2024-01-14 15:22:54',NULL),(50,1,'studio',2,'2024-01-15','2024-01-15','08:00:00','17:00:00',10.00,15.00,'daily',1,1,'2024-01-15 16:27:35','2024-01-15 16:27:35'),(51,1,'studio',2,'2024-02-07','2024-02-07','08:00:00','17:00:00',10.00,15.00,'daily',1,1,'2024-01-20 19:12:34',NULL),(52,1,'studio',1,'2024-01-16','2024-01-16','08:00:00','17:00:00',10.00,13.00,'daily',1,NULL,'2024-01-25 17:15:48','2024-01-25 17:15:48'),(53,1,'resource',1,'2024-01-28','2024-01-28','08:00:00','17:00:00',9.49,18.99,'daily',1,1,'2024-01-28 14:15:26','2024-01-28 14:26:12');

--
-- Table structure for table `site_config`
--

CREATE TABLE `site_config` (
  `id` int NOT NULL AUTO_INCREMENT,
  `key_name` varchar(191) NOT NULL,
  `key_value` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `site_config`
--

INSERT INTO `site_config` VALUES (1,'points_per_usd',1);

--
-- Table structure for table `studio_types`
--

CREATE TABLE `studio_types` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `slug` varchar(50) NOT NULL,
  `status` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `studio_types`
--

INSERT INTO `studio_types` VALUES (1,'Fine Art','fine-art',1),(2,'Fashion','fashion',1),(3,'Music','music',1),(4,'Photography','photography',1),(5,'Video','video',1);

--
-- Table structure for table `studios`
--

CREATE TABLE `studios` (
  `id` int NOT NULL AUTO_INCREMENT,
  `location_id` int NOT NULL,
  `name` varchar(100) NOT NULL,
  `studio_type` int NOT NULL,
  `crew` varchar(191) DEFAULT NULL,
  `daily_rate` decimal(10,2) DEFAULT NULL,
  `hourly_rate` decimal(10,2) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `studios`
--

INSERT INTO `studios` VALUES (1,1,'Studio A Music',3,NULL,18.99,9.49,'2023-10-26 15:40:50','2024-01-28 12:27:46'),(2,1,'Studio B Video',5,'3,5',0.00,0.00,'2023-10-26 15:40:50','2024-01-28 11:31:02');

--
-- Table structure for table `subscription_items`
--

CREATE TABLE `subscription_items` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `subscription_id` bigint unsigned NOT NULL,
  `stripe_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `stripe_product` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `stripe_price` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `quantity` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `subscription_items_subscription_id_stripe_price_unique` (`subscription_id`,`stripe_price`),
  UNIQUE KEY `subscription_items_stripe_id_unique` (`stripe_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `subscription_items`
--

INSERT INTO `subscription_items` VALUES (1,1,'si_OoiarUqkXunVr4','prod_OdMjcrQGxKW20w','price_1Nq5zgBfA6yrUxU00QrQXG2L',1,'2023-10-14 10:33:07','2023-10-14 10:33:07');

--
-- Table structure for table `subscriptions`
--

CREATE TABLE `subscriptions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `stripe_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `stripe_status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `stripe_price` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `quantity` int DEFAULT NULL,
  `trial_ends_at` timestamp NULL DEFAULT NULL,
  `ends_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `subscriptions_stripe_id_unique` (`stripe_id`),
  KEY `subscriptions_user_id_stripe_status_index` (`user_id`,`stripe_status`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `subscriptions`
--

INSERT INTO `subscriptions` VALUES (1,7,'starving-artist','si_OoiarUqkXunVr4','active','price_1Nq5zgBfA6yrUxU00QrQXG2L',1,NULL,'2023-11-14 10:33:05','2023-10-14 10:33:07','2023-10-14 10:38:48');

--
-- Table structure for table `upcoming_guests`
--

CREATE TABLE `upcoming_guests` (
  `id` int NOT NULL AUTO_INCREMENT,
  `location_id` int NOT NULL,
  `invitation_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `ref_id` int NOT NULL,
  `guest_uuid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `host_uuid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `invitation_date` date NOT NULL,
  `invitation_time` time NOT NULL,
  `status` tinyint NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `upcoming_guests`
--

INSERT INTO `upcoming_guests` VALUES (1,1,'studio',0,'49847d85-b98e-4ee2-8944-17cb88989117','06238d85-b98e-4ee2-8944-17cb87274117','2023-12-31','08:00:00',2,'2023-12-31 10:33:45','2024-02-10 21:28:15'),(2,1,'Studio',0,'49d6ea7f-823c-4efb-9c62-221bea4d0e08','06238d85-b98e-4ee2-8944-17cb87274117','2024-01-19','00:33:58',0,'2024-01-18 19:03:58','2024-01-18 19:03:58'),(3,1,'Studio',0,'48279275-012d-4d61-b990-356e9a120a35','06238d85-b98e-4ee2-8944-17cb87274117','2024-01-19','01:04:57',1,'2024-01-18 19:34:57','2024-01-18 19:34:57');

--
-- Table structure for table `user_permissions`
--

CREATE TABLE `user_permissions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_uuid` varchar(191) DEFAULT NULL,
  `location_id` int NOT NULL,
  `role_id` int NOT NULL,
  `pages` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `created_At` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `user_permissions`
--

INSERT INTO `user_permissions` VALUES (30,'06238d85-b98e-4ee2-8944-17cb87274117',1,6,'rentals,equipment-schedule,upcoming-guests','2024-06-12 07:34:22','2024-06-12 07:34:22'),(19,'06238d85-b98e-4ee2-8944-17cb87274117',2,4,'location-landing-page,location-landing-page-save,local-studios,studio-landing-page,studio-landing-page-save,manage-news,news,save-news,delete-news,manage-events,events,save-events,delete-events','2023-12-26 16:01:27','2023-12-26 16:01:27'),(27,'49d6ea7f-823c-4efb-9c62-221bea4d0e08',1,3,'schedule-location,location-landing-page,location-landing-page-save,local-studios,studio-landing-page,studio-landing-page-save,studio-list,manage-news,news,save-news,delete-news,manage-events,events,save-events,delete-events,allevents,event-detail,event-responded,rentals,equipment-schedule,upcoming-guests','2024-06-12 07:32:58','2024-06-12 07:32:58'),(28,'48638d85-b98e-4ee2-8944-17cb88989117',1,4,'location-landing-page,location-landing-page-save,local-studios,studio-landing-page,studio-landing-page-save,manage-news,news,save-news,delete-news,manage-events,events,save-events,delete-events','2024-06-12 07:33:25','2024-06-12 07:33:25'),(29,'5cb2e986-9ddd-4f09-98b5-4bbbf8d9aa30',1,5,'manage-events,events,save-events,delete-events,allevents,event-detail,event-responded,upcoming-guests','2024-06-12 07:33:43','2024-06-12 07:33:43');


