# ************************************************************
# 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);




