# ************************************************************
# Sequel Pro SQL dump
# Version 4541
#
# http://www.sequelpro.com/
# https://github.com/sequelpro/sequelpro
#
# Host: ngabring.fusi.id (MySQL 5.7.36-0ubuntu0.18.04.1)
# Database: b2b
# Generation Time: 2021-11-02 03:48:36 +0000
# ************************************************************




# Dump of table role_user
# ------------------------------------------------------------


CREATE TABLE `role_user` (
  `user_id` bigint(20) unsigned NOT NULL,
  `role_id` bigint(20) unsigned NOT NULL,
  KEY `user_id_fk_5065335` (`user_id`),
  KEY `role_id_fk_5065335` (`role_id`),
  CONSTRAINT `role_id_fk_5065335` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_id_fk_5065335` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `role_user` (`user_id`, `role_id`)
VALUES
	(1,1),
	(2,2),
	(3,2),
	(4,2),
	(5,2),
	(6,2),
	(7,2),
	(8,2),
	(9,2),
	(10,2),
	(11,2),
	(12,2),
	(13,2),
	(14,2),
	(15,2),
	(16,2);



# Dump of table teams
# ------------------------------------------------------------


CREATE TABLE `teams` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `website` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `owner_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `owner_fk_5192437` (`owner_id`),
  CONSTRAINT `owner_fk_5192437` FOREIGN KEY (`owner_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `teams` (`id`, `name`, `address`, `phone_number`, `website`, `email`, `created_at`, `updated_at`, `deleted_at`, `owner_id`)
VALUES
	(1,'PT Fusi Global Teknologi','Jl. PHH Mustopa No.39','08118040685',NULL,'info@fusi.co.id','2021-10-25 07:18:17','2021-10-25 07:19:38',NULL,2),
	(2,'PT Daya Anugrah Mandiri','Jl Soekarno Hatta No 518 Bandung 40266','081322831688',NULL,'jeffri@daya-motor.com','2021-10-25 08:02:41','2021-10-25 08:05:16',NULL,3),
	(3,'Jtenardi1@gmail.com',NULL,NULL,NULL,NULL,'2021-10-25 08:14:23','2021-10-25 08:14:23',NULL,4),
	(4,'dayamotor.soekarnohatta@gmail.com',NULL,NULL,NULL,NULL,'2021-10-25 08:58:43','2021-10-25 08:58:43',NULL,5),
	(5,'dam.soekarnohatta@gmail.com',NULL,NULL,NULL,NULL,'2021-10-25 09:07:41','2021-10-25 09:07:41',NULL,6),
	(6,'iwan.rizberkahmandiri@gmail.com',NULL,NULL,NULL,NULL,'2021-10-25 10:15:09','2021-10-25 10:15:09',NULL,7),
	(7,'PT RIZ BERKAH MANDIRI','Jl tebet utara no 32','081517653058',NULL,'info.rizberkahmandiri@gmail.com','2021-10-25 10:20:04','2021-10-25 10:21:45',NULL,8),
	(8,'rsri8222@gmail.com',NULL,NULL,NULL,NULL,'2021-10-26 01:39:16','2021-10-26 01:39:16',NULL,9),
	(9,'Kopi Ngaso','Bandung','081211526580',NULL,'aljihadmohamad@gmail.com','2021-10-26 03:25:03','2021-10-26 03:29:29',NULL,10),
	(10,'PT Maintenance','Depok','0217711111',NULL,'adjiedep@gmail.com','2021-10-26 03:33:44','2021-10-26 06:03:49',NULL,11),
	(11,'neneng168@gmail.com',NULL,NULL,NULL,NULL,'2021-10-26 07:29:05','2021-10-26 07:29:05',NULL,12),
	(12,'PT. Prima Wahana Auto Mobil','Jl. RS Fatmawati Cipete Jakarta Selatan','0818200078',NULL,'infosalewuling@gmail.com','2021-10-27 04:32:56','2021-10-27 04:36:12',NULL,13),
	(13,'Bagasraga raga','Jl Raya Batujajar No 26 RT01 RW 02','089694026392',NULL,'hasea23@gmail.com','2021-10-27 04:56:04','2021-10-27 04:57:00',NULL,14),
	(14,'CoffeeIDN','Jl. Jamrud D9, Kemang Pratama Regency, Bekasi Barat','08119284559',NULL,'srbcoffeeidn@gmail.com','2021-10-28 10:18:19','2021-10-28 10:20:47',NULL,15),
	(15,'PT SURGA MOBIL INDONESIA','Pulo Buaran Raya Kav. I EE No.4, Jakarta Timur','08123294120',NULL,'aruna@mobeng.co.id','2021-10-28 15:35:19','2021-10-28 15:38:02',NULL,16);



# Dump of table users
# ------------------------------------------------------------


CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_verified_at` datetime DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `verified` tinyint(1) DEFAULT '0',
  `verified_at` datetime DEFAULT NULL,
  `verification_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remember_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `job_position` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_onboarding_finished` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `team_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`),
  KEY `team_fk_5192438` (`team_id`),
  CONSTRAINT `team_fk_5192438` FOREIGN KEY (`team_id`) REFERENCES `teams` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `users` (`id`, `name`, `email`, `phone_number`, `email_verified_at`, `password`, `verified`, `verified_at`, `verification_token`, `remember_token`, `job_position`, `is_onboarding_finished`, `created_at`, `updated_at`, `deleted_at`, `team_id`)
VALUES
	(1,'Admin','admin@admin.com','',NULL,'$2y$10$dovVUvszUqlYwMw9MwxrYuPP23f.Q4hiGCN6Hy8EJqQglVgRYnjES',1,'2021-10-24 22:43:05','',NULL,'',0,NULL,NULL,NULL,NULL),
	(2,'Yan Syafri Hidayat','yansyaf@gmail.com',NULL,NULL,'$2y$10$mdxtLEzYEbX3xZL1a5ASIOrvekGjUz6d7ypyy5Im2xkrwRX56kmPC',1,'2021-10-25 07:19:04',NULL,NULL,NULL,1,'2021-10-25 07:18:16','2021-10-25 07:19:38',NULL,1),
	(3,'JEFFRI SUHERMAN','jeffri@daya-motor.com',NULL,NULL,'$2y$10$m1nS0neXyALw5EviwH9Fhe4fVuvf2ZZfpBI9S41g1VZQBt.VrROHK',1,'2021-10-25 08:03:57',NULL,'NubgQ88HroXT4ALhmvEcdUXWHZ5GISFG9UdoRihmawURv0GaauMJlspNvUBH',NULL,1,'2021-10-25 08:02:40','2021-10-25 08:05:16',NULL,2),
	(4,'Justin Tenardi','Jtenardi1@gmail.com',NULL,NULL,'$2y$10$gJtiMWo5ggfOVlvQGflGNOWOtsd518dk.jYGNNyW4/Tp1QXcv021S',1,'2021-10-25 08:15:52',NULL,NULL,NULL,0,'2021-10-25 08:14:21','2021-10-25 08:15:52',NULL,3),
	(5,'Daya Motor Soekarnohatta','dayamotor.soekarnohatta@gmail.com',NULL,NULL,'$2y$10$Ru15VHUKjmEH.orF4dE0TOG78p5TqXTQRPGeHfk62jDAfBsVPSgnu',1,'2021-10-25 09:01:50',NULL,NULL,NULL,0,'2021-10-25 08:58:42','2021-10-25 09:01:50',NULL,4),
	(6,'Daya Motor Soekarnohatta','dam.soekarnohatta@gmail.com',NULL,NULL,'$2y$10$UlSW/fy3qL7zgODU4XtMVec6cCdv8oET1zPLKbcSGm1yUyDv6PeCC',1,'2021-10-25 09:09:30',NULL,NULL,NULL,0,'2021-10-25 09:07:39','2021-10-25 09:09:30',NULL,5),
	(7,'iwan agustian','iwan.rizberkahmandiri@gmail.com',NULL,NULL,'$2y$10$X3ZTrHho66t8l3Gf7/HunOSkJyELnPgiO.NHTELaf1cmo1QfKNNDq',0,NULL,'wENTUWOuyhrBA9licMblHQmVOn5gfH627uEWKPxT76mwMC2mNFmTnqtd8zw4EeKJ',NULL,NULL,0,'2021-10-25 10:15:08','2021-10-25 10:15:09',NULL,6),
	(8,'Riz berkah mandiri','info.rizberkahmandiri@gmail.com',NULL,NULL,'$2y$10$crl4s0fcJ4IAyNhydc4eZudm62X7crZCkap70rvT7bmrBKnRllP6K',1,'2021-10-25 10:20:17',NULL,NULL,NULL,1,'2021-10-25 10:20:02','2021-10-25 10:21:45',NULL,7),
	(9,'PT Daya Anugrah Mandiri','rsri8222@gmail.com',NULL,NULL,'$2y$10$cnxFp4hEvqmXd.uTtbix8u4fL75c5UQd0RrHMvHlPLSEWs4uOkOz6',0,NULL,'OH8F2Mg9aw0co0hDcjG5XvsWEao80uQLIjzBT3SYhhu3OHAIsg51mwc2fUJzyUpR',NULL,NULL,0,'2021-10-26 01:39:14','2021-10-26 01:39:16',NULL,8),
	(10,'Mohamad Al Jihad','aljihadmohamad@gmail.com',NULL,NULL,'$2y$10$vIhyTKSQUzlP3SGq5NdKMOn99c5Vm11nSvLLbszqeleHPU5rjK.TS',1,'2021-10-26 03:28:26',NULL,'gELj1kLutZbT6K0GInA8PdNNKsVVp2VcgsFqPFCiXMmiWrLmrhf4HRgzmVdb',NULL,1,'2021-10-26 03:25:02','2021-10-26 03:29:29',NULL,9),
	(11,'adjie','adjiedep@gmail.com',NULL,NULL,'$2y$10$AmkimP5MTZP1.p5277bxOeXmktwQGM0riU2nxVR04jVWKXOUFEBku',1,'2021-10-26 03:36:45',NULL,NULL,NULL,1,'2021-10-26 03:33:42','2021-10-26 06:03:49',NULL,10),
	(12,'Suzuki','neneng168@gmail.com',NULL,NULL,'$2y$10$Lqu0MH0S3Vim.RVdb9IJ7uM.oxSfuMMVA7M/Lxrt8Q9vZV3RBx/IW',0,NULL,'m86YCnO028yXiGswQukSl5Ogd3KS7JKyKObpMGJ0O6lG8O5b82RI1RnQ6SuJb5ek','P4HhQgdNEBg5IKPzVxdQTNmNuVKkwBBJjzGg2l3Cx5eBuzSTk8YmiArPNbx1',NULL,0,'2021-10-26 07:29:04','2021-10-26 07:29:05',NULL,11),
	(13,'Wuling Motors','infosalewuling@gmail.com',NULL,NULL,'$2y$10$khFglh/U.bDXd08IMYRFHeVPRY2f21oTAp5yuYpmwl4ufUVtqOzcK',1,'2021-10-27 04:33:39',NULL,'BsPHKjVWMAqGEkdbMCE5nf2qbJeJYxLEgt78vPSHih70LW3M3fOMXcJQXyrJ',NULL,1,'2021-10-27 04:32:54','2021-10-27 04:36:12',NULL,12),
	(14,'Bagasraga','hasea23@gmail.com',NULL,NULL,'$2y$10$yILLWsW62Qk...9sBx1w4OBP1S5JViU20Mt10.kBZAbm2Lu5FJ94a',1,'2021-10-27 04:56:44',NULL,NULL,NULL,1,'2021-10-27 04:56:03','2021-10-27 04:57:00',NULL,13),
	(15,'CoffeeIDN','srbcoffeeidn@gmail.com',NULL,NULL,'$2y$10$JK6VaNBDDDVCqmP4ikKEDOpwKMYFcbKyexxkMJA59E2wzeVSGnFou',1,'2021-10-28 10:18:49',NULL,'c3Mnpgw1ZobwmmIOdEar7LTFEkIokKgKx8M7YbWMwBnoe4LjNWwlTFe4aKIv',NULL,1,'2021-10-28 10:18:17','2021-10-28 10:20:47',NULL,14),
	(16,'MOBENG','aruna@mobeng.co.id',NULL,NULL,'$2y$10$IPtx9Sw0zfVHi84RBcrTiuUAGr5t7tv1p5Si6AmcwDgqKrn7agGo6',1,'2021-10-28 15:36:36',NULL,NULL,NULL,1,'2021-10-28 15:35:18','2021-10-28 15:38:02',NULL,15);




