--
-- Host: localhost    Database: portal_sigap_9
-- ------------------------------------------------------


--
-- Table structure for table `data_rows`
--

CREATE TABLE `data_rows` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `data_type_id` int(10) unsigned NOT NULL,
  `field` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `required` tinyint(1) NOT NULL DEFAULT '0',
  `browse` tinyint(1) NOT NULL DEFAULT '1',
  `read` tinyint(1) NOT NULL DEFAULT '1',
  `edit` tinyint(1) NOT NULL DEFAULT '1',
  `add` tinyint(1) NOT NULL DEFAULT '1',
  `delete` tinyint(1) NOT NULL DEFAULT '1',
  `details` text COLLATE utf8mb4_unicode_ci,
  `order` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `data_rows`
--



--
-- Table structure for table `data_types`
--

CREATE TABLE `data_types` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name_singular` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name_plural` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `model_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `policy_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `controller` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `generate_permissions` tinyint(1) NOT NULL DEFAULT '0',
  `server_side` tinyint(4) NOT NULL DEFAULT '0',
  `details` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `data_types_name_unique` (`name`),
  UNIQUE KEY `data_types_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `data_types`
--

INSERT INTO `data_types` VALUES (1,'users','users','User','Users','voyager-person','TCG\\Voyager\\Models\\User','TCG\\Voyager\\Policies\\UserPolicy','TCG\\Voyager\\Http\\Controllers\\VoyagerUserController',NULL,1,0,'{\"order_column\":null,\"order_display_column\":null,\"order_direction\":\"desc\",\"default_search_key\":null,\"scope\":null}','2023-10-07 12:51:47','2023-11-05 09:44:46'),(2,'menus','menus','Menu','Menus','voyager-list','TCG\\Voyager\\Models\\Menu',NULL,'','',1,0,NULL,'2023-10-07 12:51:47','2023-10-07 12:51:47'),(3,'roles','roles','Role','Roles','voyager-lock','TCG\\Voyager\\Models\\Role',NULL,'TCG\\Voyager\\Http\\Controllers\\VoyagerRoleController','',1,0,NULL,'2023-10-07 12:51:47','2023-10-07 12:51:47'),(8,'leasing','leasing','Leasing','Leasing','voyager-file-text','App\\Models\\leasing',NULL,NULL,NULL,1,1,'{\"order_column\":\"id\",\"order_display_column\":\"id\",\"order_direction\":\"desc\",\"default_search_key\":\"id\",\"scope\":null}','2023-11-12 09:37:00','2023-11-14 03:07:00'),(9,'leasing_issue','leasing-issue','Leasing Issue','Leasing Issue','voyager-question','App\\Models\\leasing_issue',NULL,NULL,NULL,1,1,'{\"order_column\":\"id\",\"order_display_column\":\"id\",\"order_direction\":\"desc\",\"default_search_key\":\"id\",\"scope\":null}','2023-11-12 09:42:23','2023-11-14 02:47:43');

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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


--
-- Table structure for table `leasing`
--

CREATE TABLE `leasing` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nama_customer` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_id` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jumlah_kendaraan` int(11) DEFAULT '0',
  `status` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `leasing`
--

INSERT INTO `leasing` VALUES (1,'PT. EPPSJ','EPPSJ',30,'active','2023-11-14 03:16:29','2023-11-14 03:16:29'),(2,'PT. ABCDS','ABCDS',10,'active','2023-11-14 03:18:53','2023-11-14 03:18:53'),(3,'PT. CDEFG','CDEFG',3,'active','2023-11-14 03:19:30','2023-11-14 03:19:30'),(4,'PT. GGHSG','GGHSG',2,'active','2023-11-14 03:19:55','2023-11-14 03:19:55'),(5,'PT. JJSHHD','JJSHHD',2,'active','2023-11-14 03:20:30','2023-11-14 03:20:30');

--
-- Table structure for table `leasing_issue`
--

CREATE TABLE `leasing_issue` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `customer_Id` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `leasing_id` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `police` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deadline` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `keterangan` text COLLATE utf8mb4_unicode_ci,
  `status` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `leasing_issue`
--

INSERT INTO `leasing_issue` VALUES (1,'PT EPPSJ',NULL,'B1234CDE','2023-11-22 00:00:00','Mobil menabrak pembatas tiang di Astra Tower. Mobil akan masuk ke bengkel untuk perbaikan dan diharapkan selesai 22 Nov 2023','active','2023-11-14 02:56:28','2023-11-14 02:59:51'),(2,'PT EPPSJ',NULL,'B2234KFE','2023-11-13 00:00:00','Mobil selesai di lakukan maintenance','finish','2023-11-14 02:58:23','2023-11-14 02:58:23');

--
-- Table structure for table `menu_items`
--

CREATE TABLE `menu_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `menu_id` int(10) unsigned DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `target` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '_self',
  `icon_class` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `order` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `route` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parameters` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menu_items`
--

INSERT INTO `menu_items` VALUES (1,1,'Dashboard','','_self','voyager-boat',NULL,NULL,1,'2023-10-07 12:51:47','2023-10-07 12:51:47','voyager.dashboard',NULL),(2,1,'Media','','_self','voyager-images',NULL,NULL,5,'2023-10-07 12:51:47','2023-10-07 12:51:47','voyager.media.index',NULL),(3,1,'Users','','_self','voyager-person',NULL,NULL,3,'2023-10-07 12:51:47','2023-10-07 12:51:47','voyager.users.index',NULL),(4,1,'Roles','','_self','voyager-lock',NULL,NULL,2,'2023-10-07 12:51:47','2023-10-07 12:51:47','voyager.roles.index',NULL),(5,1,'Tools','','_self','voyager-tools',NULL,NULL,9,'2023-10-07 12:51:47','2023-10-07 12:51:47',NULL,NULL),(6,1,'Menu Builder','','_self','voyager-list',NULL,5,10,'2023-10-07 12:51:47','2023-10-07 12:51:47','voyager.menus.index',NULL),(7,1,'Database','','_self','voyager-data',NULL,5,11,'2023-10-07 12:51:47','2023-10-07 12:51:47','voyager.database.index',NULL),(8,1,'Compass','','_self','voyager-compass',NULL,5,12,'2023-10-07 12:51:47','2023-10-07 12:51:47','voyager.compass.index',NULL),(9,1,'BREAD','','_self','voyager-bread',NULL,5,13,'2023-10-07 12:51:47','2023-10-07 12:51:47','voyager.bread.index',NULL),(10,1,'Settings','','_self','voyager-settings',NULL,NULL,14,'2023-10-07 12:51:47','2023-10-07 12:51:47','voyager.settings.index',NULL),(11,1,'AWH Report','/all-report','_self','voyager-dashboard','#000000',NULL,15,'2023-10-15 17:15:36','2023-10-15 17:33:03',NULL,''),(14,1,'Drivers','','_self','voyager-lifebuoy','#000000',NULL,16,'2023-11-05 05:11:00','2023-11-05 05:19:25','voyager.driver.index',NULL),(15,1,'Timesheet Settlement','/admin/timesheet_settlement','_self','voyager-file-text','#000000',NULL,17,'2023-11-10 11:31:17','2023-11-10 11:31:17',NULL,''),(16,1,'Dashboard Leasing','/admin/dashboard-leasing','_self','voyager-activity','#000000',NULL,18,'2023-11-12 07:01:51','2023-11-12 07:01:51',NULL,''),(17,1,'Leasing','','_self','voyager-file-text',NULL,NULL,19,'2023-11-12 09:37:00','2023-11-12 09:37:00','voyager.leasing.index',NULL),(18,1,'Leasing Issue','','_self','voyager-question',NULL,NULL,20,'2023-11-12 09:42:23','2023-11-12 09:42:23','voyager.leasing-issue.index',NULL),(19,2,'Dashboard','/admin/dashboard-leasing','_self','voyager-boat','#000000',NULL,21,'2023-11-13 19:34:58','2023-11-13 19:34:58',NULL,''),(20,2,'Vehicle Data','/admin/leasing','_self','voyager-file-text','#000000',NULL,22,'2023-11-13 19:47:47','2023-11-13 19:47:47',NULL,'');

--
-- Table structure for table `menus`
--

CREATE TABLE `menus` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `menus_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menus`
--

INSERT INTO `menus` VALUES (1,'admin','2023-10-07 12:51:47','2023-10-07 12:51:47'),(2,'leasing','2023-11-13 19:33:18','2023-11-13 19:33:18');

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

CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1),(3,'2016_01_01_000000_add_voyager_user_fields',1),(4,'2016_01_01_000000_create_data_types_table',1),(5,'2016_05_19_173453_create_menu_table',1),(6,'2016_10_21_190000_create_roles_table',1),(7,'2016_10_21_190000_create_settings_table',1),(8,'2016_11_30_135954_create_permission_table',1),(9,'2016_11_30_141208_create_permission_role_table',1),(10,'2016_12_26_201236_data_types__add__server_side',1),(11,'2017_01_13_000000_add_route_to_menu_items_table',1),(12,'2017_01_14_005015_create_translations_table',1),(13,'2017_01_15_000000_make_table_name_nullable_in permissions_table',1),(14,'2017_03_06_000000_add_controller_to_data_types_table',1),(15,'2017_04_21_000000_add_order_to_data_rows_table',1),(16,'2017_07_05_210000_add_policyname_to_data_types_table',1),(17,'2017_08_05_000000_add_group_to_settings_table',1),(18,'2017_11_26_013050_add_user_role_relationship',1),(19,'2017_11_26_015000_create_user_roles_table',1),(20,'2018_03_11_000000_add_user_settings',1),(21,'2018_03_14_000000_add_details_to_data_types_table',1),(22,'2018_03_16_000000_make_settings_value_nullable',1),(23,'2019_08_19_000000_create_failed_jobs_table',1),(24,'2019_12_14_000001_create_personal_access_tokens_table',1);

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `password_resets`
--


--
-- Table structure for table `permission_role`
--

CREATE TABLE `permission_role` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `role_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `permission_role_permission_id_index` (`permission_id`),
  KEY `permission_role_role_id_index` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permission_role`
--

INSERT INTO `permission_role` VALUES (1,1),(1,3),(1,4),(2,1),(3,1),(4,1),(5,1),(6,1),(7,1),(8,1),(9,1),(10,1),(11,1),(12,1),(13,1),(14,1),(15,1),(16,1),(17,1),(18,1),(19,1),(20,1),(21,1),(22,1),(23,1),(24,1),(25,1),(31,1),(31,3),(32,1),(32,3),(33,1),(33,3),(34,1),(34,3),(35,1),(35,3),(36,1),(36,4),(37,1),(37,4),(38,1),(38,4),(39,1),(39,4),(40,1),(40,4),(41,1),(41,4),(42,1),(42,4),(43,1),(43,4),(44,1),(44,4),(45,1),(45,4);

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `table_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` VALUES (1,'browse_admin',NULL,'2023-10-07 12:51:47','2023-10-07 12:51:47'),(2,'browse_bread',NULL,'2023-10-07 12:51:47','2023-10-07 12:51:47'),(3,'browse_database',NULL,'2023-10-07 12:51:47','2023-10-07 12:51:47'),(4,'browse_media',NULL,'2023-10-07 12:51:47','2023-10-07 12:51:47'),(5,'browse_compass',NULL,'2023-10-07 12:51:48','2023-10-07 12:51:48'),(6,'browse_menus','menus','2023-10-07 12:51:48','2023-10-07 12:51:48'),(7,'read_menus','menus','2023-10-07 12:51:48','2023-10-07 12:51:48'),(8,'edit_menus','menus','2023-10-07 12:51:48','2023-10-07 12:51:48'),(9,'add_menus','menus','2023-10-07 12:51:48','2023-10-07 12:51:48'),(10,'delete_menus','menus','2023-10-07 12:51:48','2023-10-07 12:51:48'),(11,'browse_roles','roles','2023-10-07 12:51:48','2023-10-07 12:51:48'),(12,'read_roles','roles','2023-10-07 12:51:48','2023-10-07 12:51:48'),(13,'edit_roles','roles','2023-10-07 12:51:48','2023-10-07 12:51:48'),(14,'add_roles','roles','2023-10-07 12:51:48','2023-10-07 12:51:48'),(15,'delete_roles','roles','2023-10-07 12:51:48','2023-10-07 12:51:48'),(16,'browse_users','users','2023-10-07 12:51:48','2023-10-07 12:51:48'),(17,'read_users','users','2023-10-07 12:51:48','2023-10-07 12:51:48'),(18,'edit_users','users','2023-10-07 12:51:48','2023-10-07 12:51:48'),(19,'add_users','users','2023-10-07 12:51:48','2023-10-07 12:51:48'),(20,'delete_users','users','2023-10-07 12:51:48','2023-10-07 12:51:48'),(21,'browse_settings','settings','2023-10-07 12:51:48','2023-10-07 12:51:48'),(22,'read_settings','settings','2023-10-07 12:51:48','2023-10-07 12:51:48'),(23,'edit_settings','settings','2023-10-07 12:51:48','2023-10-07 12:51:48'),(24,'add_settings','settings','2023-10-07 12:51:48','2023-10-07 12:51:48'),(25,'delete_settings','settings','2023-10-07 12:51:48','2023-10-07 12:51:48'),(31,'browse_driver','driver','2023-11-05 04:36:10','2023-11-05 04:36:10'),(32,'read_driver','driver','2023-11-05 04:36:10','2023-11-05 04:36:10'),(33,'edit_driver','driver','2023-11-05 04:36:10','2023-11-05 04:36:10'),(34,'add_driver','driver','2023-11-05 04:36:10','2023-11-05 04:36:10'),(35,'delete_driver','driver','2023-11-05 04:36:10','2023-11-05 04:36:10'),(36,'browse_leasing','leasing','2023-11-12 09:37:00','2023-11-12 09:37:00'),(37,'read_leasing','leasing','2023-11-12 09:37:00','2023-11-12 09:37:00'),(38,'edit_leasing','leasing','2023-11-12 09:37:00','2023-11-12 09:37:00'),(39,'add_leasing','leasing','2023-11-12 09:37:00','2023-11-12 09:37:00'),(40,'delete_leasing','leasing','2023-11-12 09:37:00','2023-11-12 09:37:00'),(41,'browse_leasing_issue','leasing_issue','2023-11-12 09:42:23','2023-11-12 09:42:23'),(42,'read_leasing_issue','leasing_issue','2023-11-12 09:42:23','2023-11-12 09:42:23'),(43,'edit_leasing_issue','leasing_issue','2023-11-12 09:42:23','2023-11-12 09:42:23'),(44,'add_leasing_issue','leasing_issue','2023-11-12 09:42:23','2023-11-12 09:42:23'),(45,'delete_leasing_issue','leasing_issue','2023-11-12 09:42:23','2023-11-12 09:42:23');

--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `personal_access_tokens`
--


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

CREATE TABLE `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `roles` VALUES (1,'admin','Administrator','2023-11-05 02:52:39','2023-11-05 02:52:39'),(2,'user','Normal User','2023-11-05 02:52:39','2023-11-05 02:52:39'),(3,'customer','Customer','2023-11-05 02:52:39','2023-11-05 02:52:39'),(4,'leasing','Leasing','2023-11-13 20:03:26','2023-11-13 20:03:26');

--
-- Table structure for table `translations`
--

CREATE TABLE `translations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `table_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `column_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `foreign_key` int(10) unsigned NOT NULL,
  `locale` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `translations_table_name_column_name_foreign_key_locale_unique` (`table_name`,`column_name`,`foreign_key`,`locale`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `translations`
--


--
-- Table structure for table `user_roles`
--

CREATE TABLE `user_roles` (
  `user_id` bigint(20) unsigned NOT NULL,
  `role_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`user_id`,`role_id`),
  KEY `user_roles_user_id_index` (`user_id`),
  KEY `user_roles_role_id_index` (`role_id`),
  CONSTRAINT `user_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_roles_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_roles`
--



