-- --------------------------------------------------------
-- Server OS:                    Win64
-- HeidiSQL Version:             11.2.0.6213
-- --------------------------------------------------------


-- Dumping structure for table hgagent.retail_customer_role
CREATE TABLE IF NOT EXISTS `retail_customer_role` (
  `retail_customer_id` bigint unsigned NOT NULL,
  `role_id` bigint unsigned NOT NULL,
  KEY `retail_customer_role_retail_customer_id_foreign` (`retail_customer_id`),
  KEY `retail_customer_role_role_id_foreign` (`role_id`),
  CONSTRAINT `retail_customer_role_retail_customer_id_foreign` FOREIGN KEY (`retail_customer_id`) REFERENCES `retail_customers` (`id`) ON DELETE CASCADE,
  CONSTRAINT `retail_customer_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- Dumping data for table hgagent.retail_customer_role: ~0 rows (approximately)
DELETE FROM `retail_customer_role`;
INSERT INTO `retail_customer_role` (`retail_customer_id`, `role_id`) VALUES
	(2, 4),
	(3, 4);

