DROP TABLE IF EXISTS `access_types`;
CREATE TABLE `access_types` (
  `type` int(10) unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`type`),
  UNIQUE KEY `access_types_name_unique` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `access_types` (`type`, `name`) VALUES
(1,	'Read'),
(2,	'Write');

DROP TABLE IF EXISTS `entities`;
CREATE TABLE `entities` (
  `id` int(10) unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `logo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `entities` (`id`, `name`, `logo`, `created_at`, `updated_at`) VALUES
(1,	'Evollu',	'evollu.png',	NULL,	NULL),
(2,	'GLINTT',	NULL,	NULL,	NULL),
(4,	'Farmácia de demonstração',	NULL,	NULL,	NULL),
(5,	'Farmácia 1',	NULL,	NULL,	NULL),
(6,	'Farmácia 2',	NULL,	NULL,	NULL),
(10,	'Widex',	'widex.png',	NULL,	NULL),
(101,	'Farmácia Benfica',	NULL,	NULL,	NULL),
(102,	'Fórum Almada',	NULL,	NULL,	NULL),
(103,	'Farmácia joão Castro Rodrigues',	NULL,	NULL,	NULL),
(104,	'Farmácia Lisboa',	NULL,	NULL,	NULL),
(105,	'Farmácia Veritas Oueiras',	NULL,	NULL,	NULL),
(106,	'Farmácia Dias e Brito',	NULL,	NULL,	NULL),
(107,	'Farmácia Veritas',	NULL,	NULL,	NULL);

DROP TABLE IF EXISTS `info_types`;
CREATE TABLE `info_types` (
  `type` int(10) unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`type`),
  UNIQUE KEY `info_types_name_unique` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `info_types` (`type`, `name`) VALUES
(2000,	'lead'),
(1000,	'reference'),
(100,	'user');

DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `entity_id` int(10) unsigned NOT NULL,
  `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`),
  KEY `users_entity_id_foreign` (`entity_id`),
  CONSTRAINT `users_entity_id_foreign` FOREIGN KEY (`entity_id`) REFERENCES `entities` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `users` (`id`, `name`, `email`, `password`, `entity_id`, `remember_token`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1,	'Luis Marcelino',	'luis.marcelino@evollu.com',	'$2y$10$oCTddBW4jmMTyOxVoWXT2Oez8K7In99BJr8NaU/CdlswoeQmak0Jm',	1,	NULL,	NULL,	NULL,	NULL),
(2,	'Sergio Paulo',	'sergio.paulo@evollu.com',	'$2y$10$n4aqjOLikUlyZbzg3RvbmuZ5CVxeJmzAO808rzf.b5tZTuxQkUti.',	1,	NULL,	NULL,	NULL,	NULL),
(3,	'Vitor Jesus',	'vitor.jesus@evollu.com',	'$2y$10$NPr25znWbKSinNutAz60Mez/IPYkaO1KVjJ7KJ3mLswFU6y6wyYj6',	1,	NULL,	NULL,	NULL,	NULL),
(4,	'Demo Farmácia',	'demo.farma@evollu.com',	'$2y$10$QXzDNOWOOI.XGSBd0cpf7ecAZqEZXPYHd/lA42658HWPrmlRhzZj.',	4,	NULL,	NULL,	NULL,	NULL),
(5,	'Farma1',	'farma1@mail.com',	'$2y$10$8FznY8bbX5gCss0xX25F4ugWJm2vIWXZb.bUqcig46TwkWGEk0VPS',	4,	NULL,	NULL,	NULL,	NULL),
(6,	'Farma2',	'farma2@mail.com',	'$2y$10$g1iVtjF2xS/46dMfgi6ew.qBJh5lL1nbgZrC22NOt5lArxQuvsUDa',	4,	NULL,	NULL,	NULL,	NULL),
(7,	'Farma3',	'farma3@mail.com',	'$2y$10$M3EwJoJQqIte9BUEZotiCes8OxSuACIJ0MhgV1yneW6MHTnQ3cjZm',	5,	NULL,	NULL,	NULL,	NULL),
(8,	'Farma4',	'farma4@mail.com',	'$2y$10$QXn4ghnaX6C0y39Hvetp0uW0Ty6RLEgXY0roMjQ5nFJsdJEGEV/NW',	6,	NULL,	NULL,	NULL,	NULL),
(9,	'widex',	'widex@mail.com',	'$2y$10$cVkQ1nkOu3P2zL7j9VFG/ecbsEdnqTOlgr5iYkoUb/R.QrUYrmJQ6',	10,	NULL,	NULL,	NULL,	NULL),
(10,	'Farmácia Benfica',	'farmaciabenfica.lx@gmail.com',	'$2y$10$jBu8rNN7AvTYvPZLZPi0oe3ujZrMVQwG2aE/cQDqfNztS587.5lnu',	101,	NULL,	NULL,	NULL,	NULL),
(11,	'Fórum Almada',	'farmacia.almadaforum@gmail.com',	'$2y$10$laVZ0ZnEa9nekrKuOR74quY02Yt4jJAcINKFhxcRyre4ySqSBTv1G',	102,	NULL,	NULL,	NULL,	NULL),
(12,	'Farmácia JCR',	'farmacia.jcr@gmail.com',	'$2y$10$1vjOlfiuDk/3SGjje1.xx.2DLOtv9rvU4jX/rBGYK/qxW3DFYWMA2',	103,	NULL,	NULL,	NULL,	NULL),
(13,	'Farmácia Lisboa',	'farmacialisboatelheiras@wedotalent.pt',	'$2y$10$NJ6/YeA3Ib6GE.uXAULECu6JLlD99B8UhoQc5efcKKPf8.T4Njefa',	104,	NULL,	NULL,	NULL,	NULL),
(14,	'Farmácia Dias e Brito',	'farmaciadiasebrito@gmail.com',	'$2y$10$/VGme25tlwEaDPQk0XxmTuGczwSqS4zc6FwnJPVmcM1G5vthw7L/i',	106,	NULL,	NULL,	NULL,	NULL),
(15,	'Margarida Seixas',	'margarida.seixas@pharmateam.com',	'$2y$10$fjoj0anFaS.HucZCeHxzt.Bp3jR41Ai/t8.vMuPW4NrAaQ7Yhy2zq',	107,	NULL,	NULL,	NULL,	NULL),
(16,	'Marta Silvério',	'marta.silverio@evollu.com',	'$2y$10$Wxr/oOqs5B1nEoAtgpYUUuHz5.QvCfZ.gISKe0zNQBU1T6qsUxmru',	1,	NULL,	NULL,	NULL,	NULL),
(17,	'Tiago Nunes',	'tiago.nunes@widex.pt',	'$2y$10$FK4YZxlSBuKsVcJtbeq6yemrJ7Ds46pUXyCP0pgmGgg16YSqOz9lq',	10,	NULL,	NULL,	NULL,	NULL),
(18,	'Alexandra Frazão',	'alexandra.frazao@widex.pt',	'$2y$10$F980BAwbWEya7q129Ww.TeaNFUKCAUZAM3HkOezDKAH2zQUTrQMJW',	10,	NULL,	NULL,	NULL,	NULL),
(19,	'Ricardo Domingues',	'ricardo.domingues@evollu.com',	'$2y$10$oCTddBW4jmMTyOxVoWXT2Oez8K7In99BJr8NaU/CdlswoeQmak0Jm',	1,	NULL,	NULL,	NULL,	NULL);

DROP TABLE IF EXISTS `users_permissions`;
CREATE TABLE `users_permissions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `entity_id` int(10) unsigned NOT NULL,
  `access_type` int(10) unsigned NOT NULL,
  `info_type` int(10) unsigned NOT NULL,
  `updated_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `users_permissions_user_id_foreign` (`user_id`),
  KEY `users_permissions_entity_id_foreign` (`entity_id`),
  KEY `users_permissions_access_type_foreign` (`access_type`),
  KEY `users_permissions_info_type_foreign` (`info_type`),
  KEY `users_permissions_updated_by_foreign` (`updated_by`),
  CONSTRAINT `users_permissions_access_type_foreign` FOREIGN KEY (`access_type`) REFERENCES `access_types` (`type`),
  CONSTRAINT `users_permissions_entity_id_foreign` FOREIGN KEY (`entity_id`) REFERENCES `entities` (`id`),
  CONSTRAINT `users_permissions_info_type_foreign` FOREIGN KEY (`info_type`) REFERENCES `info_types` (`type`),
  CONSTRAINT `users_permissions_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`),
  CONSTRAINT `users_permissions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `users_permissions` (`id`, `user_id`, `entity_id`, `access_type`, `info_type`, `updated_by`, `created_at`, `updated_at`) VALUES
(1,	1,	1,	2,	1000,	NULL,	NULL,	NULL),
(2,	1,	5,	2,	1000,	NULL,	NULL,	NULL),
(3,	1,	1,	2,	2000,	NULL,	NULL,	NULL),
(4,	1,	4,	2,	2000,	NULL,	NULL,	NULL),
(5,	1,	4,	1,	1000,	NULL,	NULL,	NULL),
(6,	2,	1,	2,	1000,	NULL,	NULL,	NULL),
(7,	2,	6,	2,	1000,	NULL,	NULL,	NULL),
(8,	2,	4,	2,	1000,	NULL,	NULL,	NULL),
(9,	2,	4,	2,	2000,	NULL,	NULL,	NULL),
(10,	3,	1,	2,	1000,	NULL,	NULL,	NULL),
(11,	3,	1,	2,	2000,	NULL,	NULL,	NULL),
(12,	4,	4,	2,	1000,	NULL,	NULL,	NULL),
(13,	10,	101,	2,	1000,	NULL,	NULL,	NULL),
(14,	11,	102,	2,	1000,	NULL,	NULL,	NULL),
(15,	12,	103,	2,	1000,	NULL,	NULL,	NULL),
(16,	13,	104,	2,	1000,	NULL,	NULL,	NULL),
(17,	14,	106,	2,	1000,	NULL,	NULL,	NULL),
(18,	15,	107,	2,	1000,	NULL,	NULL,	NULL),
(19,	16,	4,	2,	1000,	NULL,	NULL,	NULL),
(20,	16,	1,	2,	1000,	NULL,	NULL,	NULL),
(21,	16,	1,	2,	2000,	NULL,	NULL,	NULL),
(22,	19,	4,	1,	100,	NULL,	NULL,	NULL),
(23,	19,	1,	2,	100,	NULL,	NULL,	NULL),
(26,	19,	1,	2,	1000,	NULL,	NULL,	NULL),
(27,	19,	1,	2,	2000,	NULL,	NULL,	NULL);


DROP TABLE IF EXISTS `authorization_codes`;
CREATE TABLE `authorization_codes` (
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `client_id` int(10) unsigned NOT NULL,
  `scope` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ttl` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`code`),
  KEY `authorization_codes_user_id_foreign` (`user_id`),
  KEY `authorization_codes_client_id_foreign` (`client_id`),
  CONSTRAINT `authorization_codes_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`),
  CONSTRAINT `authorization_codes_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


DROP TABLE IF EXISTS `clients`;
CREATE TABLE `clients` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `redirect_uri` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `secret` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `clients` (`id`, `redirect_uri`, `name`, `description`, `secret`) VALUES
(1,	'leads-dev.evollu.com',	'Leads',	'Evollu Leads',	'secretp@ssword');

DROP TABLE IF EXISTS `refresh_tokens`;
CREATE TABLE `refresh_tokens` (
  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `client_id` int(10) unsigned NOT NULL,
  `scope` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`token`),
  KEY `refresh_tokens_user_id_foreign` (`user_id`),
  KEY `refresh_tokens_client_id_foreign` (`client_id`),
  CONSTRAINT `refresh_tokens_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`),
  CONSTRAINT `refresh_tokens_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


DROP TABLE IF EXISTS `tokens`;
CREATE TABLE `tokens` (
  `token` varchar(400) COLLATE latin1_bin NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `client_id` int(10) unsigned NOT NULL,
  `scope` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ttl` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`token`),
  KEY `tokens_user_id_foreign` (`user_id`),
  KEY `tokens_client_id_foreign` (`client_id`),
  CONSTRAINT `tokens_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`),
  CONSTRAINT `tokens_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_bin;