-- MySQL dump 10.13  Distrib 8.0.36, for Linux (x86_64)
--
-- Host: localhost    Database: exenize
-- ------------------------------------------------------
-- Server version	8.0.36-0ubuntu0.22.04.1

/*!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 */;
/*!50503 SET NAMES utf8mb4 */;
/*!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 `admin`
--

DROP TABLE IF EXISTS `admin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `admin` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(255) DEFAULT NULL,
  `password_hash` varchar(255) DEFAULT NULL,
  `password_reset_token` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `auth_key` varchar(255) DEFAULT NULL,
  `status` int DEFAULT NULL,
  `package_id` int DEFAULT NULL,
  `terminated` tinyint(1) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `admin`
--

LOCK TABLES `admin` WRITE;
/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
INSERT INTO `admin` VALUES (1,'Admin Exenize','$2y$13$pYuF.gFkIyQaS0VapcjjlOaqQF8cFC3N6gwJjYlgK/YQ5E5DIMeyW',NULL,'infoexenize@exenize.com','moR_EC6BtZng17RkZocexgpnTXSeTW1D',10,NULL,NULL,NULL,1710588277,1710588277);
/*!40000 ALTER TABLE `admin` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `budget`
--

DROP TABLE IF EXISTS `budget`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `budget` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `text` text COLLATE utf8mb3_unicode_ci,
  `user_id` int DEFAULT NULL,
  `producer_service` int DEFAULT NULL,
  `unexpected_cost` int DEFAULT NULL,
  `excess_cost` int DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `budget`
--

LOCK TABLES `budget` WRITE;
/*!40000 ALTER TABLE `budget` DISABLE KEYS */;
/*!40000 ALTER TABLE `budget` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `budget_team`
--

DROP TABLE IF EXISTS `budget_team`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `budget_team` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `phase` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `items` longtext COLLATE utf8mb3_unicode_ci,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `budget_team`
--

LOCK TABLES `budget_team` WRITE;
/*!40000 ALTER TABLE `budget_team` DISABLE KEYS */;
/*!40000 ALTER TABLE `budget_team` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `budget_team_item_detail`
--

DROP TABLE IF EXISTS `budget_team_item_detail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `budget_team_item_detail` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `budget_id` int DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `item_id` int DEFAULT NULL,
  `order` int DEFAULT NULL,
  `team_item_data` longtext COLLATE utf8mb3_unicode_ci,
  `item_name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `tax` longtext COLLATE utf8mb3_unicode_ci,
  `spent_data` longtext COLLATE utf8mb3_unicode_ci,
  `is_excluded` tinyint(1) DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `budget_team_item_detail`
--

LOCK TABLES `budget_team_item_detail` WRITE;
/*!40000 ALTER TABLE `budget_team_item_detail` DISABLE KEYS */;
/*!40000 ALTER TABLE `budget_team_item_detail` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `budget_team_item_name`
--

DROP TABLE IF EXISTS `budget_team_item_name`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `budget_team_item_name` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `budget_id` int DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `stage` int DEFAULT NULL,
  `team_name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `budget_team_item_name`
--

LOCK TABLES `budget_team_item_name` WRITE;
/*!40000 ALTER TABLE `budget_team_item_name` DISABLE KEYS */;
/*!40000 ALTER TABLE `budget_team_item_name` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `budget_team_item_spent`
--

DROP TABLE IF EXISTS `budget_team_item_spent`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `budget_team_item_spent` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `budget_id` int DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `data` longtext COLLATE utf8mb3_unicode_ci,
  `item_name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `budget_team_item_spent`
--

LOCK TABLES `budget_team_item_spent` WRITE;
/*!40000 ALTER TABLE `budget_team_item_spent` DISABLE KEYS */;
/*!40000 ALTER TABLE `budget_team_item_spent` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `calendars`
--

DROP TABLE IF EXISTS `calendars`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `calendars` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `start` date DEFAULT NULL,
  `end` date DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `color` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `daily_plan_slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `calendars`
--

LOCK TABLES `calendars` WRITE;
/*!40000 ALTER TABLE `calendars` DISABLE KEYS */;
/*!40000 ALTER TABLE `calendars` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `callsheet_casts`
--

DROP TABLE IF EXISTS `callsheet_casts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `callsheet_casts` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `callsheet_slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `cast_no` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `cast` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `role` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `set` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `pick_up` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `hair_make_up` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `costume` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `ready` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `order` int DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `callsheet_casts`
--

LOCK TABLES `callsheet_casts` WRITE;
/*!40000 ALTER TABLE `callsheet_casts` DISABLE KEYS */;
/*!40000 ALTER TABLE `callsheet_casts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `callsheet_check_cast`
--

DROP TABLE IF EXISTS `callsheet_check_cast`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `callsheet_check_cast` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `callsheet_id` int DEFAULT NULL,
  `callsheet_cast_id` int DEFAULT NULL,
  `cast` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `role` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `set` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `info` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `order` int DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `callsheet_check_cast`
--

LOCK TABLES `callsheet_check_cast` WRITE;
/*!40000 ALTER TABLE `callsheet_check_cast` DISABLE KEYS */;
/*!40000 ALTER TABLE `callsheet_check_cast` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `callsheet_check_datas`
--

DROP TABLE IF EXISTS `callsheet_check_datas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `callsheet_check_datas` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `callsheet_id` int DEFAULT NULL,
  `info` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `notes` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `extra_notes` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `company` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `shoot_day` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `weather` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `call` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `call_info` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `break` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `break_info` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `breakfast` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `breakfast_info` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `finish` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `finish_info` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `callsheet_check_datas`
--

LOCK TABLES `callsheet_check_datas` WRITE;
/*!40000 ALTER TABLE `callsheet_check_datas` DISABLE KEYS */;
/*!40000 ALTER TABLE `callsheet_check_datas` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `callsheet_check_pickup`
--

DROP TABLE IF EXISTS `callsheet_check_pickup`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `callsheet_check_pickup` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `callsheet_id` int DEFAULT NULL,
  `callsheet_pickup_id` int DEFAULT NULL,
  `crew` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `pickup` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `set` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `callsheet_check_pickup`
--

LOCK TABLES `callsheet_check_pickup` WRITE;
/*!40000 ALTER TABLE `callsheet_check_pickup` DISABLE KEYS */;
/*!40000 ALTER TABLE `callsheet_check_pickup` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `callsheet_check_scene`
--

DROP TABLE IF EXISTS `callsheet_check_scene`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `callsheet_check_scene` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `callsheet_slug` int DEFAULT NULL,
  `episode` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `fgr` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `scene_no` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `place` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `page` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `d_n_i_e` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `synopsis` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `plan_cast` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `equipment` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `plan_ready` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `scenario_day` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `hair_make_up` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `costume` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `order` int DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `callsheet_check_scene`
--

LOCK TABLES `callsheet_check_scene` WRITE;
/*!40000 ALTER TABLE `callsheet_check_scene` DISABLE KEYS */;
/*!40000 ALTER TABLE `callsheet_check_scene` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `callsheet_check_second_scenes`
--

DROP TABLE IF EXISTS `callsheet_check_second_scenes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `callsheet_check_second_scenes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `callsheet_slug` int DEFAULT NULL,
  `episode` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `fgr` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `scene_no` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `place` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `page` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `d_n_i_e` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `synopsis` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `plan_cast` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `equipment` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `plan_ready` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `scenario_day` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `hair_make_up` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `costume` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `order` int DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `callsheet_check_second_scenes`
--

LOCK TABLES `callsheet_check_second_scenes` WRITE;
/*!40000 ALTER TABLE `callsheet_check_second_scenes` DISABLE KEYS */;
/*!40000 ALTER TABLE `callsheet_check_second_scenes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `callsheet_datas`
--

DROP TABLE IF EXISTS `callsheet_datas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `callsheet_datas` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `callsheet_slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `info` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `notes` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `extra_notes` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `company` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `shoot_day` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `weather` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `call` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `break` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `breakfast` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `finish` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `callsheet_datas`
--

LOCK TABLES `callsheet_datas` WRITE;
/*!40000 ALTER TABLE `callsheet_datas` DISABLE KEYS */;
/*!40000 ALTER TABLE `callsheet_datas` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `callsheet_pickups`
--

DROP TABLE IF EXISTS `callsheet_pickups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `callsheet_pickups` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `callsheet_slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `crew` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `pickup` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `set` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `callsheet_pickups`
--

LOCK TABLES `callsheet_pickups` WRITE;
/*!40000 ALTER TABLE `callsheet_pickups` DISABLE KEYS */;
/*!40000 ALTER TABLE `callsheet_pickups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `callsheet_scenes`
--

DROP TABLE IF EXISTS `callsheet_scenes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `callsheet_scenes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `callsheet_slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `episode` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `fgr` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `scene_no` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `place` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `page` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `d_n_i_e` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `synopsis` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `plan_cast` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `equipment` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `plan_ready` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `scenario_day` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `hair_make_up` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `costume` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `order` int DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `callsheet_scenes`
--

LOCK TABLES `callsheet_scenes` WRITE;
/*!40000 ALTER TABLE `callsheet_scenes` DISABLE KEYS */;
/*!40000 ALTER TABLE `callsheet_scenes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `callsheet_second_scenes`
--

DROP TABLE IF EXISTS `callsheet_second_scenes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `callsheet_second_scenes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `callsheet_slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `episode` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `fgr` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `scene_no` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `place` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `page` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `d_n_i_e` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `synopsis` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `plan_cast` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `equipment` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `plan_ready` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `scenario_day` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `hair_make_up` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `costume` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `order` int DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `callsheet_second_scenes`
--

LOCK TABLES `callsheet_second_scenes` WRITE;
/*!40000 ALTER TABLE `callsheet_second_scenes` DISABLE KEYS */;
/*!40000 ALTER TABLE `callsheet_second_scenes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `callsheets`
--

DROP TABLE IF EXISTS `callsheets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `callsheets` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `callsheets`
--

LOCK TABLES `callsheets` WRITE;
/*!40000 ALTER TABLE `callsheets` DISABLE KEYS */;
/*!40000 ALTER TABLE `callsheets` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `config`
--

DROP TABLE IF EXISTS `config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `config` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `exclude_scenes_on_daily_plan` tinyint(1) DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `config`
--

LOCK TABLES `config` WRITE;
/*!40000 ALTER TABLE `config` DISABLE KEYS */;
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `crew_suggestion`
--

DROP TABLE IF EXISTS `crew_suggestion`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `crew_suggestion` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `suggestion` longtext COLLATE utf8mb3_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `crew_suggestion`
--

LOCK TABLES `crew_suggestion` WRITE;
/*!40000 ALTER TABLE `crew_suggestion` DISABLE KEYS */;
/*!40000 ALTER TABLE `crew_suggestion` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `crews`
--

DROP TABLE IF EXISTS `crews`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `crews` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `department` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `blood_type` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `id_number` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `insurance_number` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `crews`
--

LOCK TABLES `crews` WRITE;
/*!40000 ALTER TABLE `crews` DISABLE KEYS */;
/*!40000 ALTER TABLE `crews` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `daily_plan`
--

DROP TABLE IF EXISTS `daily_plan`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `daily_plan` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `shoot_date` date DEFAULT NULL,
  `shoot_day` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `is_alternative` tinyint(1) DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `daily_plan`
--

LOCK TABLES `daily_plan` WRITE;
/*!40000 ALTER TABLE `daily_plan` DISABLE KEYS */;
/*!40000 ALTER TABLE `daily_plan` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `daily_plan_notes`
--

DROP TABLE IF EXISTS `daily_plan_notes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `daily_plan_notes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `daily_plan_id` int DEFAULT NULL,
  `note_detail` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `note_header` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `daily_plan_notes`
--

LOCK TABLES `daily_plan_notes` WRITE;
/*!40000 ALTER TABLE `daily_plan_notes` DISABLE KEYS */;
/*!40000 ALTER TABLE `daily_plan_notes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `daily_plan_script_breakdown`
--

DROP TABLE IF EXISTS `daily_plan_script_breakdown`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `daily_plan_script_breakdown` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `crew_no` int DEFAULT NULL,
  `order` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `daily_plan_slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `script_breakdown_slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `daily_plan_script_breakdown`
--

LOCK TABLES `daily_plan_script_breakdown` WRITE;
/*!40000 ALTER TABLE `daily_plan_script_breakdown` DISABLE KEYS */;
/*!40000 ALTER TABLE `daily_plan_script_breakdown` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `daily_plan_suggestion`
--

DROP TABLE IF EXISTS `daily_plan_suggestion`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `daily_plan_suggestion` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `suggestion` longtext COLLATE utf8mb3_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `daily_plan_suggestion`
--

LOCK TABLES `daily_plan_suggestion` WRITE;
/*!40000 ALTER TABLE `daily_plan_suggestion` DISABLE KEYS */;
/*!40000 ALTER TABLE `daily_plan_suggestion` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `department`
--

DROP TABLE IF EXISTS `department`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `department` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `type` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `cover` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `cover_filename` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `file` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `department`
--

LOCK TABLES `department` WRITE;
/*!40000 ALTER TABLE `department` DISABLE KEYS */;
/*!40000 ALTER TABLE `department` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `department_files`
--

DROP TABLE IF EXISTS `department_files`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `department_files` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `department_slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `attachment` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `extension` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `department_files`
--

LOCK TABLES `department_files` WRITE;
/*!40000 ALTER TABLE `department_files` DISABLE KEYS */;
/*!40000 ALTER TABLE `department_files` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `expense_detail`
--

DROP TABLE IF EXISTS `expense_detail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `expense_detail` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `expense_slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `attachment` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `expense_detail`
--

LOCK TABLES `expense_detail` WRITE;
/*!40000 ALTER TABLE `expense_detail` DISABLE KEYS */;
/*!40000 ALTER TABLE `expense_detail` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `expense_detail_files`
--

DROP TABLE IF EXISTS `expense_detail_files`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `expense_detail_files` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `expense_detail_slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `extension` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `attachment` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `attachment_filename` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `expense_detail_files`
--

LOCK TABLES `expense_detail_files` WRITE;
/*!40000 ALTER TABLE `expense_detail_files` DISABLE KEYS */;
/*!40000 ALTER TABLE `expense_detail_files` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `expense_suggestion`
--

DROP TABLE IF EXISTS `expense_suggestion`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `expense_suggestion` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `suggestion` longtext COLLATE utf8mb3_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `expense_suggestion`
--

LOCK TABLES `expense_suggestion` WRITE;
/*!40000 ALTER TABLE `expense_suggestion` DISABLE KEYS */;
/*!40000 ALTER TABLE `expense_suggestion` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `expense_types`
--

DROP TABLE IF EXISTS `expense_types`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `expense_types` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `expense_types`
--

LOCK TABLES `expense_types` WRITE;
/*!40000 ALTER TABLE `expense_types` DISABLE KEYS */;
/*!40000 ALTER TABLE `expense_types` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `expenses`
--

DROP TABLE IF EXISTS `expenses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `expenses` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `expense` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `department` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `type` int DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `spent_date` date DEFAULT NULL,
  `expense_close_date` date DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `expenses`
--

LOCK TABLES `expenses` WRITE;
/*!40000 ALTER TABLE `expenses` DISABLE KEYS */;
/*!40000 ALTER TABLE `expenses` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `file_share`
--

DROP TABLE IF EXISTS `file_share`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `file_share` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `file` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `file_web_name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `extension` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `watermark` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `file_type` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `binaryfile` tinyint(1) DEFAULT NULL,
  `allow_multiple_click` tinyint(1) DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `file_share`
--

LOCK TABLES `file_share` WRITE;
/*!40000 ALTER TABLE `file_share` DISABLE KEYS */;
/*!40000 ALTER TABLE `file_share` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `file_share_details`
--

DROP TABLE IF EXISTS `file_share_details`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `file_share_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `header` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `file_slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `access_token` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `is_seen` tinyint(1) DEFAULT NULL,
  `is_downloaded` tinyint(1) DEFAULT NULL,
  `downloaded_at` longtext COLLATE utf8mb3_unicode_ci,
  `seent_at` longtext COLLATE utf8mb3_unicode_ci,
  `allow_multiple_click` tinyint(1) DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `file_share_details`
--

LOCK TABLES `file_share_details` WRITE;
/*!40000 ALTER TABLE `file_share_details` DISABLE KEYS */;
/*!40000 ALTER TABLE `file_share_details` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `identities`
--

DROP TABLE IF EXISTS `identities`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `identities` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `project_name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `producer` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `cast` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `art_crew` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `production_crew` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `camera_crew` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `costume_crew` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `light_crew` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `sound_crew` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `director` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `script` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `writer` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `dop` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `editing` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `music` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `company` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `aspect` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `year` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `language` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `format` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `country` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `graphic` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `special_effect` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `sound_design` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `identity_image_web` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `identity_image` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `company_image_web` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `company_image` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `identities`
--

LOCK TABLES `identities` WRITE;
/*!40000 ALTER TABLE `identities` DISABLE KEYS */;
/*!40000 ALTER TABLE `identities` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `location_files`
--

DROP TABLE IF EXISTS `location_files`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `location_files` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `location_slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `attachment` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `attachment_filename` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `extension` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `location_files`
--

LOCK TABLES `location_files` WRITE;
/*!40000 ALTER TABLE `location_files` DISABLE KEYS */;
/*!40000 ALTER TABLE `location_files` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `locations`
--

DROP TABLE IF EXISTS `locations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `locations` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `contact` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `notes` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `map` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `locations`
--

LOCK TABLES `locations` WRITE;
/*!40000 ALTER TABLE `locations` DISABLE KEYS */;
/*!40000 ALTER TABLE `locations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `match_storyboard_script_breakdown`
--

DROP TABLE IF EXISTS `match_storyboard_script_breakdown`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `match_storyboard_script_breakdown` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `storyboard_id` int DEFAULT NULL,
  `script_breakdown_id` int DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `match_storyboard_script_breakdown`
--

LOCK TABLES `match_storyboard_script_breakdown` WRITE;
/*!40000 ALTER TABLE `match_storyboard_script_breakdown` DISABLE KEYS */;
/*!40000 ALTER TABLE `match_storyboard_script_breakdown` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `migration`
--

DROP TABLE IF EXISTS `migration`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `migration` (
  `version` varchar(180) NOT NULL,
  `apply_time` int DEFAULT NULL,
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `migration`
--

LOCK TABLES `migration` WRITE;
/*!40000 ALTER TABLE `migration` DISABLE KEYS */;
INSERT INTO `migration` VALUES ('m000000_000000_base',1702737312),('m231210_112037_create_exenize_db',1702737322),('m231216_145811_create_signup_token_table',1702738885),('m231216_182258_create_user',1702752658),('m231216_201551_add_new_migration',1702758431),('m240316_110739_create_admin_table',1710588110),('m240316_111233_timeline_event',1710588159);
/*!40000 ALTER TABLE `migration` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `notifications`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `notifications` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `type` int DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `notifications` WRITE;
/*!40000 ALTER TABLE `notifications` DISABLE KEYS */;
/*!40000 ALTER TABLE `notifications` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `package_usage`
--

DROP TABLE IF EXISTS `package_usage`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `package_usage` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `package_id` int DEFAULT NULL,
  `project` int DEFAULT NULL,
  `crew` int DEFAULT NULL,
  `callsheet` int DEFAULT NULL,
  `script_breakdown` int DEFAULT NULL,
  `expenses` int DEFAULT NULL,
  `storyboard` int DEFAULT NULL,
  `scenario` int DEFAULT NULL,
  `report` int DEFAULT NULL,
  `type` int DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `deleted_at` int DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `package_usage`
--

LOCK TABLES `package_usage` WRITE;
/*!40000 ALTER TABLE `package_usage` DISABLE KEYS */;
INSERT INTO `package_usage` VALUES (1,1,1,1,0,0,0,0,0,0,NULL,NULL,1702752658,NULL,1702753141,1,NULL,NULL),(2,6,1,1,0,0,0,0,0,0,NULL,NULL,1703355586,NULL,1703430278,6,NULL,NULL),(3,7,1,1,0,0,0,0,0,0,NULL,NULL,1703438990,NULL,1710610802,7,NULL,NULL);
/*!40000 ALTER TABLE `package_usage` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `packages`
--

DROP TABLE IF EXISTS `packages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `packages` (
  `id` int NOT NULL AUTO_INCREMENT,
  `package_name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `project` int DEFAULT NULL,
  `crew` int DEFAULT NULL,
  `callsheet` int DEFAULT NULL,
  `script_breakdown` int DEFAULT NULL,
  `expenses` int DEFAULT NULL,
  `storyboard` int DEFAULT NULL,
  `scenario` int DEFAULT NULL,
  `report` int DEFAULT NULL,
  `type` int DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `packages`
--

LOCK TABLES `packages` WRITE;
/*!40000 ALTER TABLE `packages` DISABLE KEYS */;
INSERT INTO `packages` VALUES (1,'Generous',500,500000,500000,500000,500000,500000,500000,500000,3,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `packages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `panel_todo`
--

DROP TABLE IF EXISTS `panel_todo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `panel_todo` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `panel_todo`
--

LOCK TABLES `panel_todo` WRITE;
/*!40000 ALTER TABLE `panel_todo` DISABLE KEYS */;
INSERT INTO `panel_todo` VALUES (1,3,'WVU2DvARzfE8WR7HVTqSx9yL6z3sTO_H1710610869','asd',NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `panel_todo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `projects`
--

DROP TABLE IF EXISTS `projects`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `projects` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `director` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `producer` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `projects`
--

LOCK TABLES `projects` WRITE;
/*!40000 ALTER TABLE `projects` DISABLE KEYS */;
INSERT INTO `projects` VALUES (1,'Deneme','BxIvRlP9iuB3o1zgqW2pCfxZb0wBdebf1702753141','a','b',1702753141,1,1702753141,1),(2,'New Project','cU5qb5AgLHhdaOG_ycf0BtlXxu0ZhWCN1703430278','ali','ali',1703430278,6,1703430278,6),(3,'Yeni Proje','pqunolEqP_gVUxCpiFO3bV6wnyHjL-RT1710610802','Barış','Fert',1710610802,7,1710610802,7);
/*!40000 ALTER TABLE `projects` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `report_access`
--

DROP TABLE IF EXISTS `report_access`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `report_access` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `token` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `end_date` int DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `report_access`
--

LOCK TABLES `report_access` WRITE;
/*!40000 ALTER TABLE `report_access` DISABLE KEYS */;
/*!40000 ALTER TABLE `report_access` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `scenarios`
--

DROP TABLE IF EXISTS `scenarios`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `scenarios` (
  `id` int NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `project_id` int DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `header` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `file` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `file_web_filename` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `extension` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `episode` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `scenarios`
--

LOCK TABLES `scenarios` WRITE;
/*!40000 ALTER TABLE `scenarios` DISABLE KEYS */;
/*!40000 ALTER TABLE `scenarios` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `script_breakdown`
--

DROP TABLE IF EXISTS `script_breakdown`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `script_breakdown` (
  `id` int NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `project_id` int DEFAULT NULL,
  `scene_note` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `scene_no` int DEFAULT NULL,
  `episode` int DEFAULT NULL,
  `place` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `d_n` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `i_e` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `episode_note` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `scenario_day` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `cast` longtext COLLATE utf8mb3_unicode_ci,
  `equipment` longtext COLLATE utf8mb3_unicode_ci,
  `costume` longtext COLLATE utf8mb3_unicode_ci,
  `hair_make_up` longtext COLLATE utf8mb3_unicode_ci,
  `fgr` longtext COLLATE utf8mb3_unicode_ci,
  `page` longtext COLLATE utf8mb3_unicode_ci,
  `synopsis` longtext COLLATE utf8mb3_unicode_ci,
  `full_scene_text` longtext COLLATE utf8mb3_unicode_ci,
  `done` tinyint(1) DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `script_breakdown`
--

LOCK TABLES `script_breakdown` WRITE;
/*!40000 ALTER TABLE `script_breakdown` DISABLE KEYS */;
/*!40000 ALTER TABLE `script_breakdown` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `script_breakdown_suggestion`
--

DROP TABLE IF EXISTS `script_breakdown_suggestion`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `script_breakdown_suggestion` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `suggestion` longtext COLLATE utf8mb3_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `script_breakdown_suggestion`
--

LOCK TABLES `script_breakdown_suggestion` WRITE;
/*!40000 ALTER TABLE `script_breakdown_suggestion` DISABLE KEYS */;
/*!40000 ALTER TABLE `script_breakdown_suggestion` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `signup_token`
--

DROP TABLE IF EXISTS `signup_token`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `signup_token` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `token` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `signup_token`
--

LOCK TABLES `signup_token` WRITE;
/*!40000 ALTER TABLE `signup_token` DISABLE KEYS */;
/*!40000 ALTER TABLE `signup_token` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `storyboard_access`
--

DROP TABLE IF EXISTS `storyboard_access`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `storyboard_access` (
  `id` int NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `project_id` int DEFAULT NULL,
  `token` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `storyboard_access`
--

LOCK TABLES `storyboard_access` WRITE;
/*!40000 ALTER TABLE `storyboard_access` DISABLE KEYS */;
/*!40000 ALTER TABLE `storyboard_access` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `storyboards`
--

DROP TABLE IF EXISTS `storyboards`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `storyboards` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `scene_no` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `width` int DEFAULT NULL,
  `height` int DEFAULT NULL,
  `ratio` int DEFAULT NULL,
  `plan_no` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `episode` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `image_web_filename` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `deleted_at` int DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `storyboards`
--

LOCK TABLES `storyboards` WRITE;
/*!40000 ALTER TABLE `storyboards` DISABLE KEYS */;
/*!40000 ALTER TABLE `storyboards` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tax_list`
--

DROP TABLE IF EXISTS `tax_list`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tax_list` (
  `id` int NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `budget_id` int DEFAULT NULL,
  `tax` int DEFAULT NULL,
  `type` int DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tax_list`
--

LOCK TABLES `tax_list` WRITE;
/*!40000 ALTER TABLE `tax_list` DISABLE KEYS */;
/*!40000 ALTER TABLE `tax_list` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `team_user_token`
--

DROP TABLE IF EXISTS `team_user_token`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `team_user_token` (
  `id` int NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `admin_user` int DEFAULT NULL,
  `project_id` int DEFAULT NULL,
  `token` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `is_valid` tinyint(1) DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `team_user_token`
--

LOCK TABLES `team_user_token` WRITE;
/*!40000 ALTER TABLE `team_user_token` DISABLE KEYS */;
/*!40000 ALTER TABLE `team_user_token` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `timeline_event`
--

DROP TABLE IF EXISTS `timeline_event`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `timeline_event` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `data` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `event` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `category` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `timeline_event`
--

LOCK TABLES `timeline_event` WRITE;
/*!40000 ALTER TABLE `timeline_event` DISABLE KEYS */;
INSERT INTO `timeline_event` VALUES (1,3,'{\"user\":\"ufuk\",\"identifier\":\"asd\",\"slug\":\"\"}','create','panel',1710610869,NULL,NULL,NULL);
/*!40000 ALTER TABLE `timeline_event` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `todo_task`
--

DROP TABLE IF EXISTS `todo_task`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `todo_task` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `tab_active` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `panel_todo_id` int DEFAULT NULL,
  `tab_slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `detail` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `cover` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `cover_filename` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `link` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `is_done` tinyint(1) DEFAULT NULL,
  `file` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `todo_task`
--

LOCK TABLES `todo_task` WRITE;
/*!40000 ALTER TABLE `todo_task` DISABLE KEYS */;
/*!40000 ALTER TABLE `todo_task` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_allowed_function`
--

DROP TABLE IF EXISTS `user_allowed_function`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_allowed_function` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `team_user_id` int DEFAULT NULL,
  `admin_user` int DEFAULT NULL,
  `crew` tinyint(1) DEFAULT NULL,
  `script_breakdown` tinyint(1) DEFAULT NULL,
  `callsheet` tinyint(1) DEFAULT NULL,
  `calendar` tinyint(1) DEFAULT NULL,
  `expense` tinyint(1) DEFAULT NULL,
  `identity` tinyint(1) DEFAULT NULL,
  `scenario` tinyint(1) DEFAULT NULL,
  `storyboard` tinyint(1) DEFAULT NULL,
  `todo` tinyint(1) DEFAULT NULL,
  `budget` tinyint(1) DEFAULT NULL,
  `report` tinyint(1) DEFAULT NULL,
  `daily_plan` tinyint(1) DEFAULT NULL,
  `user_allowed_function` tinyint(1) DEFAULT NULL,
  `timeline_event` tinyint(1) DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_allowed_function`
--

LOCK TABLES `user_allowed_function` WRITE;
/*!40000 ALTER TABLE `user_allowed_function` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_allowed_function` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_allowed_panel_todo`
--

DROP TABLE IF EXISTS `user_allowed_panel_todo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_allowed_panel_todo` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `team_user_id` int DEFAULT NULL,
  `panel_todo_slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_allowed_panel_todo`
--

LOCK TABLES `user_allowed_panel_todo` WRITE;
/*!40000 ALTER TABLE `user_allowed_panel_todo` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_allowed_panel_todo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
  `id` int NOT NULL AUTO_INCREMENT,
  `status` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `phone_number` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `username` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `ip_address` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `refresh_token` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `language` int DEFAULT NULL,
  `package_id` int DEFAULT NULL,
  `expires_at` int DEFAULT NULL,
  `agreement` tinyint(1) DEFAULT NULL,
  `terminated` int DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `password_hash` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `auth_key` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `verification_token` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `role` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'10',NULL,'Ufuk Yesiloglu','test','123123',NULL,1,1,NULL,1,NULL,1702752658,NULL,1702752658,NULL,'$2y$13$6oCUAB3g.qZ.hm/fEhUdEuorSO2dpWaiiO2VqrMgenNVT0fH0y31a','90Gq4jQxiYJfVt8a6a7jKZrs0zauNPqC','g_yusWOQZ9UT-KTKsEqVsQUXHHX43AH9_1702752658',NULL),(6,'10',NULL,'ali','ali-yigit@outlook.com','79.117.230.203',NULL,1,1,NULL,1,NULL,1703355585,NULL,1703355585,NULL,'$2y$13$iDsWnVe3YC6GXK9oYTrnxu8NDTGhPx.FYFosl/Ae11XsI.WOVFL7i','q5xThhZrozf7MZ85gNtPUqKR4U7o8bap','XOOP10va9-llipbrDAONDr_unGmT37DM_1703355585',NULL),(7,'10',NULL,'ufuk','ufukyesiloglu@gmail.com','79.117.230.203',NULL,1,1,NULL,1,NULL,1703438990,NULL,1703438990,NULL,'$2y$13$CizEOVJqkDRMoNqxMv6PkO7zpz3fvzscZYjDaUnXoreuabwAjM7ZS','oBS-00zHwPVbW64qmoKCmHv-RF436WAJ','03rS-UbD_O9SCPb6RSI_1Z8UDG5FbCch_1703438990',NULL);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users_projects`
--

DROP TABLE IF EXISTS `users_projects`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `users_projects` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `role` int DEFAULT NULL,
  `user_allowed_function_id` int DEFAULT NULL,
  `is_default` tinyint(1) DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users_projects`
--

LOCK TABLES `users_projects` WRITE;
/*!40000 ALTER TABLE `users_projects` DISABLE KEYS */;
INSERT INTO `users_projects` VALUES (1,1,1,1,NULL,1,1702753141,NULL,NULL,NULL),(2,2,6,1,NULL,1,1703430278,NULL,NULL,NULL),(3,3,7,1,NULL,1,1710610802,NULL,NULL,NULL);
/*!40000 ALTER TABLE `users_projects` 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 2024-03-17 18:14:58