-- --------------------------------------------------------
-- Server OS:                    Win64
-- HeidiSQL Version:             11.3.0.6295
-- --------------------------------------------------------


-- Dumping structure for table quatenus.account_card_types
CREATE TABLE IF NOT EXISTS `account_card_types` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `customer_account_id` int(10) unsigned DEFAULT NULL,
  `card_type_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table quatenus.account_card_types: ~7 rows (approximately)
INSERT INTO `account_card_types` (`id`, `customer_account_id`, `card_type_id`, `created_at`, `updated_at`) VALUES
	(1, 2, 2, '2021-10-28 15:15:50', '2021-10-28 15:15:50'),
	(2, 1, 2, '2021-10-28 15:24:07', '2021-10-28 15:24:07'),
	(3, 1, 3, '2021-10-28 15:27:59', '2021-10-28 15:27:59'),
	(4, 1, 1, '2021-10-28 15:29:56', '2021-10-28 15:29:56'),
	(5, 7, 3, '2021-11-09 14:32:10', '2021-11-09 14:32:10'),
	(6, 8, 3, '2021-11-23 15:38:01', '2021-11-23 15:38:01'),
	(7, 9, 3, '2021-11-23 15:39:25', '2021-11-23 15:39:25');

-- Dumping structure for table quatenus.account_types
CREATE TABLE IF NOT EXISTS `account_types` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `user_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `account_types_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table quatenus.account_types: ~5 rows (approximately)
INSERT INTO `account_types` (`id`, `name`, `description`, `status`, `user_id`, `created_at`, `updated_at`) VALUES
	(1, 'Empresa', 'Está tipo de Cartão é destinado as empresas que queiram dar os serviços de saúde aos seus colaboradores.', 'active', NULL, '2021-10-28 15:03:00', '2022-05-17 14:03:20'),
	(2, 'Família', 'Este Cartão é destinado a familia', 'active', NULL, '2021-10-28 15:03:00', '2021-10-28 15:03:00'),
	(3, 'Singular', 'Conta Pessoal', 'active', NULL, '2021-10-28 15:03:00', '2021-10-28 15:03:00'),
	(4, 'Conjunta iMali', 'Conta Conjunta iMali', 'active', NULL, '2022-05-10 11:58:30', '2022-05-10 11:58:30'),
	(5, 'TESTE 34', 'Conta Conjunta #24', 'active', NULL, '2022-05-10 12:10:26', '2022-05-17 14:16:31');

-- Dumping structure for table quatenus.card_types
CREATE TABLE IF NOT EXISTS `card_types` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'activo',
  `user_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `card_types_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table quatenus.card_types: ~3 rows (approximately)
INSERT INTO `card_types` (`id`, `name`, `description`, `status`, `user_id`, `created_at`, `updated_at`) VALUES
	(2, 'Empresa', 'Este Cartão é destinado a familia', 'activo', NULL, '2021-10-28 15:03:00', '2021-10-28 15:03:00'),
	(3, 'Singular', 'Conta Pessoal', 'activo', NULL, '2021-10-28 15:03:00', '2021-10-28 15:03:00'),
	(5, 'Combatente', 'mensagem combatente', 'activo', NULL, '2022-05-17 14:06:48', '2022-05-17 14:06:48'),
	(8, 'Nova Category', 'Bussiness', 'activo', NULL, '2022-05-26 12:01:57', '2022-05-26 12:01:57');

-- Dumping structure for table quatenus.companies
CREATE TABLE IF NOT EXISTS `companies` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nuit` int(11) DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_phone_fixo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_phone_mobile` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `manager_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pin` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `companies_nuit_unique` (`nuit`),
  UNIQUE KEY `companies_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table quatenus.companies: ~25 rows (approximately)
INSERT INTO `companies` (`id`, `name`, `nuit`, `email`, `address`, `status`, `contact_phone_fixo`, `contact_phone_mobile`, `manager_name`, `password`, `logo`, `pin`, `user_id`, `created_at`, `updated_at`) VALUES
	(1, 'Amparo', 1245245489, 'miguelmacamo9@gmail.com', 'Maputo, Rua cardoso 41', 'activo', '21841520', '845030902', 'Miguel', '$2y$10$xAWiwcCIvAbT2KFcT1ajO.TzW2/T0VW7Mfp1HrdEQUCkF2fv/K1jS', NULL, '$2y$10$bMbF6Rd0LcVFpakbELNjd.QxiqgSRlpSVMZh/Fhu22WYCZfpHEPG6', NULL, '2021-10-28 15:03:01', '2021-10-28 15:03:01'),
	(2, NULL, NULL, NULL, NULL, 'activo', NULL, NULL, NULL, '$2y$10$8m7xPJeBcskvhu8JKHQFqe3hXrnRvJOsuLigIp8mpISYo05F4Vm0e', NULL, '$2y$10$W9x0OVv/UEJdpSs1eQWfwuSWYBJwQ2yG7O1CONwb0Sq1x6J69Uuda', NULL, '2022-05-16 14:18:47', '2022-05-16 14:18:47'),
	(3, NULL, NULL, NULL, NULL, 'activo', NULL, NULL, NULL, '$2y$10$iILahnPCSqj61rsv1HDvZO82uusaENtd297JUpqOjv3m9vr79nmZK', NULL, '$2y$10$1TIHfmYbJ9bYfKVKO7CWr.S/a5h3/WEE14fB5mHRpuJJx2cxyRwaW', NULL, '2022-05-17 08:26:04', '2022-05-17 08:26:04'),
	(4, NULL, NULL, NULL, NULL, 'activo', NULL, NULL, NULL, '$2y$10$AvFtxRF3mSHlrBeD/U9GZuQTXgJaQxMzygigj2/Wt96tHmXK6HU4q', NULL, '$2y$10$NZoIA4AFTOE6ThwYtOxRA.O6dKfKZMIq9PUYnfgJJM9A9Hiru8Vay', NULL, '2022-05-17 08:26:46', '2022-05-17 08:26:46'),
	(5, NULL, NULL, NULL, NULL, 'activo', NULL, NULL, NULL, '$2y$10$5xkul6sviDqpibHTO2GDDu9RAj4tmbzXwr2n/RGi.Iv6jS7cr91bC', NULL, '$2y$10$K9MizccOj1707jL.ufzesey/ApPKcIxiVbwSrY4NsqD74nOGvmiXS', NULL, '2022-05-17 08:29:32', '2022-05-17 08:29:32'),
	(6, NULL, NULL, NULL, NULL, 'activo', NULL, NULL, NULL, '$2y$10$R.51XZjV7f/./2XCM2AgIOG64Nn2OYYVFL/6D./Hnu0H3Txe3D3Lm', NULL, '$2y$10$tYFlkpCZeh6nqZIZGA67Iupg3S1jIDRzpXqPd0TdzA0yP2PT5cc9q', NULL, '2022-05-17 08:55:02', '2022-05-17 08:55:02'),
	(7, NULL, NULL, NULL, NULL, 'activo', NULL, NULL, NULL, '$2y$10$6kw8kuFYc.Mpr/NlRN8HMuoz1dEPcca43qe5wjmx4.bUSeMMNIwUa', NULL, '$2y$10$3CTYJvziN62g2OUbfb5Q3euik3Hfkit0QOrHe9NiA6VK41nmec9bu', NULL, '2022-05-17 08:55:18', '2022-05-17 08:55:18'),
	(8, NULL, NULL, NULL, NULL, 'activo', NULL, NULL, NULL, '$2y$10$hl3AJtinx7eYT0nv1aKhx.t8aUzvx77LBcQ6SB8j.x/A08rsOm4x2', NULL, '$2y$10$0Ap3hQyWxZWGV4m/p524Hucn9LWBoHLsTrevCs9e4.9XkNdg2zzrO', NULL, '2022-05-17 09:57:06', '2022-05-17 09:57:06'),
	(9, NULL, NULL, NULL, NULL, 'activo', NULL, NULL, NULL, '$2y$10$BNo17axBturznI302203y.gFDFeCrWzO/V3pWZpFLt8FtSSc3nQ0u', NULL, '$2y$10$W1GFwJK8RguGC41RWDWBUOTXAAFxWGjoMIF0SU98Tx4ASmj7IAfZG', NULL, '2022-05-17 10:05:07', '2022-05-17 10:05:07'),
	(10, NULL, NULL, NULL, NULL, 'activo', NULL, NULL, NULL, '$2y$10$VPY7M2cGvigzQQfANYKRKeh7zHbma/NRuSbOPEge1L6T0sM6NoreG', NULL, '$2y$10$I.l6BguYBUDFl4803VKDBu0ZNW9xgiJkQlmzMlc0R0CKIBB7CYunW', NULL, '2022-05-17 10:07:49', '2022-05-17 10:07:49'),
	(11, NULL, NULL, NULL, NULL, 'activo', NULL, NULL, NULL, '$2y$10$moK0D0Z.LctO5gz8r7yrf.hXfw/XUHJifFil4YWVjW6lQndelai0W', NULL, '$2y$10$yJ9lx5RYFmTnS5vbMqGrfOeX4PKTlEJ3kPsEHB5ft13FKusqVApIG', NULL, '2022-05-17 10:28:57', '2022-05-17 10:28:57'),
	(12, NULL, NULL, NULL, NULL, 'activo', NULL, NULL, NULL, '$2y$10$4PvFllZ8lCNs6rM8VCrAqexHCM5Dd8LqLcgscGXKh.xgPnACmV14m', NULL, '$2y$10$HBAfakNMqS3bRp41Vo4WcuD97EkrYUrRr/MJwpPLpKGED2zSyc0QO', NULL, '2022-05-17 11:44:31', '2022-05-17 11:44:31'),
	(13, NULL, NULL, NULL, NULL, 'activo', NULL, NULL, NULL, '$2y$10$fAM7uY/sgNy/deJhRQjEWOtf8nrZjpEFv7mjdIxJdL5hkHplq8PVm', NULL, '$2y$10$pP9MyhUHnsfDORs1XKoXrOWaAx6Pk/xOT6R1n6xN5OtZM/y22l8Iy', NULL, '2022-05-17 13:50:31', '2022-05-17 13:50:31'),
	(14, NULL, NULL, NULL, NULL, 'activo', NULL, NULL, NULL, '$2y$10$GGNo4UWVUxninhzTMBSppO5WgUFq8peT2iGoggTT0jdIiAjDSCQxy', NULL, '$2y$10$u3CQm/bnHFnP8vxmxOqP3eJvwm9.vnpeDu3pD2qtKk80D/1OAfFAy', NULL, '2022-05-17 14:20:29', '2022-05-17 14:20:29'),
	(15, NULL, NULL, NULL, NULL, 'activo', NULL, NULL, NULL, '$2y$10$AJBnHBo2ZO4a5csubnu2uOH2.29Wy6zWExTfiY9TtZueuabJftRtG', NULL, '$2y$10$nsr9BgA0zcF7texhtxyTU.VMB5xD1ng.mieE0eO/JymJUA1YBCSmW', NULL, '2022-05-17 14:21:38', '2022-05-17 14:21:38'),
	(16, NULL, NULL, NULL, NULL, 'activo', NULL, NULL, NULL, '$2y$10$9hoa.y2.Oh/Si4J7q6ObBurTuDR6LlZFklA6LVZi8M7PmB8lmmOUe', NULL, '$2y$10$GVpWe77X5fuvpq2XOfk.5eTUAMkSJsU2pBCzISk1ze7ztJ7uBAVqi', NULL, '2022-05-17 14:22:11', '2022-05-17 14:22:11'),
	(17, NULL, NULL, NULL, NULL, 'activo', NULL, NULL, NULL, '$2y$10$.Xf7GSvOKHib9dj3/5A33eYPLZIYb1WTZYKnGRkjIwacgEyL34Wgy', NULL, '$2y$10$75bMECUmySy6DJ3Lv1SIgunlOrDORLPgIjevmmBpcRpH2EsSjbdsa', NULL, '2022-05-17 14:23:14', '2022-05-17 14:23:14'),
	(18, NULL, NULL, NULL, NULL, 'activo', NULL, NULL, NULL, '$2y$10$i4QV2ZDootuezdAZUOWGYOF8QJljiSSAIjBQpgi0ktqrjXIGjfnCi', NULL, '$2y$10$iNUAC5jNY.mdlTa3ib0l2u/buKGrBJFuvLX4r/9eggQvaxw3cexqG', NULL, '2022-05-17 14:23:53', '2022-05-17 14:23:53'),
	(19, NULL, NULL, NULL, NULL, 'activo', NULL, NULL, NULL, '$2y$10$unPPQNaW/7QlsrEg7DutV.hWW1WhZgkJNq9NJmszxQ9q3OjB1Clwa', NULL, '$2y$10$boID65sATyb3HUPSMAr.1OpjzdrqTnb5oYuKvhqkyIam1EymqakwO', NULL, '2022-05-17 14:24:49', '2022-05-17 14:24:49'),
	(20, NULL, NULL, NULL, NULL, 'activo', NULL, NULL, NULL, '$2y$10$qzaIHKXkt.O93ru8JRuc9.2mArnTuRKdnMSR1VQEMsVWHPguPbgJC', NULL, '$2y$10$kAt2TWKN4ASW4AG6Yg3/a.ofNuQ0.oE4v74NXoeJd57FgSym8zGde', NULL, '2022-05-17 14:26:49', '2022-05-17 14:26:49'),
	(21, NULL, NULL, NULL, NULL, 'activo', NULL, NULL, NULL, '$2y$10$J45UQ0xJldtNFAXem9GIL.01u1NdK/O7PZ3hYLHJl0r5DAeXaIleS', NULL, '$2y$10$PnK8NnXu6u/KeMpOcbYSC.Wv0SIlJkrhwPWorBiCDaSAu8tnzkYCu', NULL, '2022-05-17 14:26:52', '2022-05-17 14:26:52'),
	(22, NULL, NULL, NULL, NULL, 'activo', NULL, NULL, NULL, '$2y$10$f.Oqf0MLUBlPCUhABxQ11uz.qaEn.kAizfSyX2n9xxR6iz0lqPLFm', NULL, '$2y$10$Mh.l/Nt.anLdzggKMAdFI.fumAQBvtYsBJWfc0pta1Z08LF69fxKm', NULL, '2022-05-17 14:27:16', '2022-05-17 14:27:16'),
	(23, NULL, NULL, NULL, NULL, 'activo', NULL, NULL, NULL, '$2y$10$3iM19ve7oUK9bGFvZcsnk.izqQkAtu7asU7KtrdoXv8PPc3cnpcBW', NULL, '$2y$10$gd1mLYSuK.PWUZI.o.NDseSlZGaCQ2dusoX1sclNRv9nB6usevFXm', NULL, '2022-05-17 14:31:05', '2022-05-17 14:31:05'),
	(24, NULL, NULL, NULL, NULL, 'activo', NULL, NULL, NULL, '$2y$10$RSOvdG7jk53KYqNELmNECu.AUidDg4OCvJsZizi5I71yaX0yUO/Ey', NULL, '$2y$10$/NWmcdthp1SinBAgRRbBJuyOUugA/LnuvTZetv1Rzm/e3FeEQKLiq', NULL, '2022-05-17 14:32:19', '2022-05-17 14:32:19'),
	(25, NULL, NULL, NULL, NULL, 'activo', NULL, NULL, NULL, '$2y$10$FFL94vZCLMyK3ud9QUtBDuURk4t3ljsmIU8kUG5z2w8GTIWk8nAL.', NULL, '$2y$10$9tAGaIeWujaMnI6WXQTWAeOMBj9oQE7r.u8mQ9595Q2g8p3zz2x3a', NULL, '2022-05-17 14:32:38', '2022-05-17 14:32:38');

-- Dumping structure for table quatenus.customer_accounts
CREATE TABLE IF NOT EXISTS `customer_accounts` (
  `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,
  `nuit` int(11) DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile_phone1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile_phone2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'activo',
  `account_number` int(11) DEFAULT NULL,
  `reference` bigint(20) DEFAULT NULL,
  `payment_enabled` tinyint(1) DEFAULT 1,
  `balance` double NOT NULL DEFAULT 0,
  `balance_cards` double NOT NULL DEFAULT 0,
  `card_balance_limit` double NOT NULL DEFAULT 0,
  `card_has_limit` tinyint(1) NOT NULL DEFAULT 1,
  `captive_balance` double NOT NULL DEFAULT 0,
  `accounting_balance` double NOT NULL DEFAULT 0,
  `last_balance` double NOT NULL DEFAULT 0,
  `fee` double NOT NULL DEFAULT 0,
  `document_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `document_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `qrcode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `public_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pin` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_type_id` int(10) unsigned DEFAULT NULL,
  `user_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `customer_accounts_nuit_unique` (`nuit`),
  UNIQUE KEY `customer_accounts_email_unique` (`email`),
  UNIQUE KEY `customer_accounts_mobile_phone1_unique` (`mobile_phone1`),
  UNIQUE KEY `customer_accounts_account_number_unique` (`account_number`),
  UNIQUE KEY `customer_accounts_reference_unique` (`reference`),
  UNIQUE KEY `customer_accounts_public_id_unique` (`public_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table quatenus.customer_accounts: ~4 rows (approximately)
INSERT INTO `customer_accounts` (`id`, `name`, `address`, `nuit`, `email`, `mobile_phone1`, `mobile_phone2`, `status`, `account_number`, `reference`, `payment_enabled`, `balance`, `balance_cards`, `card_balance_limit`, `card_has_limit`, `captive_balance`, `accounting_balance`, `last_balance`, `fee`, `document_type`, `document_number`, `qrcode`, `public_id`, `password`, `pin`, `account_type_id`, `user_id`, `created_at`, `updated_at`) VALUES
	(1, 'Quatenus', 'Matola, bairro de Mapandane', 123456789, 'backup@gmail.com', '849231169', '+258849231169', 'activo', 220000001, 22000000184, 1, 40, 0, 200, 1, 0, 0, 0, 0, 'BI', '123456789123K', NULL, '970774d9-bfcf-4728-9d64-c78b2212ec04', NULL, NULL, NULL, 3, '2022-05-26 14:43:45', '2022-05-26 14:44:43'),
	(2, 'Ivo', 'Maputo, Filipe Samuel Magaia', 123456783, 'backup2@gmail.com', '849231165', '849231169', 'activo', 220000007, 22000000281, 1, 125, 0, 0, 0, 0, 0, 0, 0, 'CARTÃO DE ELEITOR', '123113332312312', 'http://192.168.31.170/quatenus/public/images/account/35efb326-8202-4401-9ccd-336721ba80e1.svg', '35efb326-8202-4401-9ccd-336721ba80e1', NULL, NULL, 5, 3, '2022-05-26 15:03:50', '2022-05-26 15:32:34'),
	(5, 'IVOR', 'Maputo, Filipe Samuel Magaia', 123456787, 'backup3@gmail.com', '849231160', '849231169', 'activo', 220000008, 22000000863, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'DIRE', '2213213123213213', 'http://192.168.31.170/quatenus/public/images/account/1b2cfff2-9ee4-4178-be57-65b6415a998f.svg', '1b2cfff2-9ee4-4178-be57-65b6415a998f', NULL, NULL, 3, 3, '2022-05-26 15:09:26', '2022-05-26 15:09:26'),
	(6, 'Rodrigues', 'Maputo, Filipe Samuel Magaia', 12345679, 'backup4@gmail.com', '849231161', '849231169', 'activo', 220000009, 22000000960, 1, 300, 0, 0, 0, 0, 0, 0, 0, 'DIRE', '131212312312312', 'http://192.168.31.170/quatenus/public/images/account/ed6bcabf-5f29-429e-bc28-26f176ae1a1a.svg', 'ed6bcabf-5f29-429e-bc28-26f176ae1a1a', NULL, NULL, 3, 3, '2022-05-26 15:34:48', '2022-05-26 15:35:36');

-- Dumping structure for table quatenus.customer_cards
CREATE TABLE IF NOT EXISTS `customer_cards` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'Quatenus Cartões',
  `phone_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '833197222',
  `card_number` int(11) NOT NULL,
  `reference` bigint(20) NOT NULL,
  `card_balance_limit` double NOT NULL DEFAULT 0,
  `card_balance` double NOT NULL DEFAULT 0,
  `expire_at` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'nunca',
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'activo',
  `can_pay` tinyint(1) NOT NULL DEFAULT 0,
  `can_receive_notification` tinyint(1) NOT NULL DEFAULT 0,
  `can_recharge` tinyint(1) NOT NULL DEFAULT 0,
  `type_user` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `qrcode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `public_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `session_status` int(11) DEFAULT 0,
  `customer_account_id` int(10) unsigned DEFAULT NULL,
  `card_type_id` int(10) unsigned DEFAULT NULL,
  `user_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `customer_cards_card_number_unique` (`card_number`),
  UNIQUE KEY `customer_cards_reference_unique` (`reference`),
  UNIQUE KEY `customer_cards_public_id_unique` (`public_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table quatenus.customer_cards: ~5 rows (approximately)
INSERT INTO `customer_cards` (`id`, `username`, `phone_number`, `card_number`, `reference`, `card_balance_limit`, `card_balance`, `expire_at`, `status`, `can_pay`, `can_receive_notification`, `can_recharge`, `type_user`, `qrcode`, `public_id`, `session_status`, `customer_account_id`, `card_type_id`, `user_id`, `created_at`, `updated_at`) VALUES
	(1, 'Quatenus Cartões', '833197222', 220000002, 22000000184, 100, 100, '26-05-2026 14:47:04', 'activo', 1, 1, 1, NULL, 'http://192.168.31.170/quatenus/public/images/cards/98a7c2e1-ff0d-40f5-a00e-d0745dc578cd.svg', '98a7c2e1-ff0d-40f5-a00e-d0745dc578cd', 0, 1, 2, 3, '2022-05-26 14:43:45', '2022-05-26 14:47:04'),
	(2, 'Quatenus Cartões', '833197222', 220000003, 22000000378, 0, 0, 'nunca', 'activo', 0, 0, 0, NULL, 'http://192.168.31.170/quatenus/public/images/cards/82a4e01e-1940-430e-aba4-633a624f6692.svg', '82a4e01e-1940-430e-aba4-633a624f6692', 0, 1, 2, 3, '2022-05-26 14:43:45', '2022-05-26 14:43:45'),
	(3, 'Quatenus Cartões', '833197222', 220000004, 22000000475, 0, 0, 'nunca', 'activo', 0, 0, 0, NULL, 'http://192.168.31.170/quatenus/public/images/cards/28311ba1-afe5-47e8-8d95-c00fb03966b2.svg', '28311ba1-afe5-47e8-8d95-c00fb03966b2', 0, 1, 2, 3, '2022-05-26 14:43:45', '2022-05-26 14:43:45'),
	(4, 'Quatenus Cartões', '833197222', 220000005, 22000000572, 0, 0, 'nunca', 'activo', 0, 0, 0, NULL, 'http://192.168.31.170/quatenus/public/images/cards/40df9d02-22a8-42cc-b412-8b39aeecd2d3.svg', '40df9d02-22a8-42cc-b412-8b39aeecd2d3', 0, 1, 2, 3, '2022-05-26 14:43:45', '2022-05-26 14:43:45'),
	(5, 'Quatenus Cartões', '833197222', 220000006, 22000000669, 0, 0, 'nunca', 'activo', 0, 0, 0, NULL, 'http://192.168.31.170/quatenus/public/images/cards/671d8bbb-b87f-480f-93e6-3fced582d942.svg', '671d8bbb-b87f-480f-93e6-3fced582d942', 0, 1, 2, 3, '2022-05-26 14:43:45', '2022-05-26 14:43:45');

-- Dumping structure for table quatenus.failed_jobs
CREATE TABLE IF NOT EXISTS `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 quatenus.failed_jobs: ~0 rows (approximately)

-- Dumping structure for table quatenus.merchants
CREATE TABLE IF NOT EXISTS `merchants` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `merchant_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `merchant_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `merchant_phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `merchant_nuit` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `merchant_nib` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `merchant_company_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `merchant_company_logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `merchant_company_nuit` int(11) DEFAULT NULL,
  `merchant_company_phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `merchant_company_mobile` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `merchant_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `merchant_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `merchant_profile` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'admin',
  `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1234',
  `nib` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `store_firebase_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `merchants_merchant_nuit_unique` (`merchant_nuit`),
  UNIQUE KEY `merchants_merchant_nib_unique` (`merchant_nib`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table quatenus.merchants: ~0 rows (approximately)
INSERT INTO `merchants` (`id`, `merchant_name`, `merchant_email`, `merchant_phone`, `merchant_nuit`, `merchant_nib`, `merchant_company_name`, `merchant_company_logo`, `merchant_company_nuit`, `merchant_company_phone`, `merchant_company_mobile`, `merchant_address`, `merchant_status`, `merchant_profile`, `password`, `pin`, `nib`, `store_firebase_token`, `user_id`, `created_at`, `updated_at`) VALUES
	(1, 'Miguel Macamo', 'miguelmacamo9@gmail.com', '845030902', '123456789', '123456789123456789123', 'Petromoc', NULL, 121485121, '845030902', '845030902', 'Maputo, Joa Gabriel av mocambique 214', 'activo', 'admin', '$2y$10$B3QsaeKIuccUgOeHAdtGQefGlR8kbM.g1og84vuwalAZSFwRDQrze', '$2y$10$dmjMjWsFQFoo251Y.pf0u.Y/add5RjhdoCQ3AhewJ6F1NtI0CEUcq', NULL, NULL, NULL, '2021-10-28 15:03:01', '2022-05-26 15:41:12');

-- Dumping structure for table quatenus.migrations
CREATE TABLE IF NOT EXISTS `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 quatenus.migrations: ~22 rows (approximately)
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(1, '2014_10_12_000000_create_users_table', 1),
	(2, '2014_10_12_100000_create_password_resets_table', 1),
	(3, '2016_06_01_000001_create_oauth_auth_codes_table', 1),
	(4, '2016_06_01_000002_create_oauth_access_tokens_table', 1),
	(5, '2016_06_01_000003_create_oauth_refresh_tokens_table', 1),
	(6, '2016_06_01_000004_create_oauth_clients_table', 1),
	(7, '2016_06_01_000005_create_oauth_personal_access_clients_table', 1),
	(8, '2019_08_19_000000_create_failed_jobs_table', 1),
	(9, '2019_12_14_000001_create_personal_access_tokens_table', 1),
	(10, '2021_09_13_125640_create_merchants_table', 1),
	(11, '2021_09_13_125850_create_stores_table', 1),
	(12, '2021_09_13_130150_create_operators_table', 1),
	(13, '2021_09_19_094825_create_card_types_table', 1),
	(14, '2021_09_19_110829_create_account_types_table', 1),
	(15, '2021_09_20_093345_create_companies_table', 1),
	(16, '2021_09_20_094341_create_customer_accounts_table', 1),
	(18, '2021_09_20_094432_create_payments_table', 1),
	(19, '2021_09_20_094448_create_recharges_table', 1),
	(20, '2021_09_20_094459_create_refunds_table', 1),
	(21, '2021_10_12_095253_create_payment_tokens_table', 1),
	(22, '2021_10_28_121730_create_account_card_types_table', 1),
	(24, '2021_09_20_094416_create_customer_cards_table', 2);

-- Dumping structure for table quatenus.oauth_access_tokens
CREATE TABLE IF NOT EXISTS `oauth_access_tokens` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `client_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `scopes` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_access_tokens_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table quatenus.oauth_access_tokens: ~48 rows (approximately)
INSERT INTO `oauth_access_tokens` (`id`, `user_id`, `client_id`, `name`, `scopes`, `revoked`, `created_at`, `updated_at`, `expires_at`) VALUES
	('02bf5d80c1316ba5b6c09c2e626d06e28e0c38ca18fa3501003619f78e050b2c495142ab441ae0b7', 1, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2022-03-03 16:21:55', '2022-03-03 16:21:55', '2023-03-03 14:21:55'),
	('07b4a72932324f31920f76382829d5887c6c3938ec656e3951c1ceb4458313ba21799ad189e1eda6', 2, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2021-10-29 10:05:54', '2021-10-29 10:05:54', '2022-10-29 08:05:54'),
	('0c8fa8857079859ed896292b9230157482a194848771a4514d5833ecfb9fe1a00f06f7183fbc4067', 1, '94917b8f-2df3-4b1a-90b1-1516c5b6f134', NULL, '["*"]', 1, '2021-11-09 13:52:46', '2021-11-09 13:52:46', '2022-11-09 11:52:46'),
	('0d9272540a8e069bdf45769a36ea56411dc3221e9d09aecc9478222b53eeee2b6da31a89a754f3b2', 3, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2022-05-17 11:09:33', '2022-05-17 11:09:33', '2023-05-17 11:09:33'),
	('0fa1fac43fb3552c17f7107f1fe953860bceb9839b097ee043d2e01b12eba8ec7e6a7d4cbff640a1', 3, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2022-05-10 11:35:13', '2022-05-10 11:35:13', '2023-05-10 09:35:13'),
	('10f4802dfa514682f9473df12c8a1f5a93782f92daf313718fa087aa1699ccf069a08b16749ceb00', 1, '94917b8f-2df3-4b1a-90b1-1516c5b6f134', NULL, '["*"]', 0, '2021-10-28 16:50:09', '2021-10-28 16:50:09', '2022-10-28 14:50:09'),
	('11a537eeed5e4178e245591f40cee7314a00ae228ae0cdff48d17783cc354af2329df5c17a27b5b9', 1, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2021-10-29 10:24:30', '2021-10-29 10:24:30', '2022-10-29 08:24:30'),
	('1798273f216a494df40861a6d408ac576c65afd13d1d9a87bf251727c104d1e807b4a5a2cf040a25', 1, '94917b8f-2df3-4b1a-90b1-1516c5b6f134', NULL, '["*"]', 0, '2022-02-10 12:59:41', '2022-02-10 12:59:41', '2023-02-10 10:59:41'),
	('179fb0ae0ad4b5e4c9e698ce7f03dd219bdfba2856510c6c98f65870750e6673459b73b1815085c0', 5, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2022-05-16 14:36:48', '2022-05-16 14:36:48', '2023-05-16 12:36:48'),
	('17d70e0545bbee26827da7df3b37b51932ceb4cc17b579d360529ed8b1849b89080dd9ff65184974', 1, '94917b8f-2df3-4b1a-90b1-1516c5b6f134', NULL, '["*"]', 0, '2021-10-29 10:39:47', '2021-10-29 10:39:47', '2022-10-29 08:39:47'),
	('22720dbd67fe4c5ca5fdecbe4b84e7d3e548c90ad1a6f92077e9b74d16c38effe6c508a3fba9a711', 3, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2022-05-18 10:06:45', '2022-05-18 10:06:45', '2023-05-18 10:06:45'),
	('2910af343fb83d169455e780972e56c4a4b0111b79cc8a8943335db68ffaae00fe1e2e8d2ed6a6b8', 1, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2021-10-28 15:06:50', '2021-10-28 15:06:50', '2022-10-28 13:06:50'),
	('292fe057e4b4a97f27d2a48e3860e00d029f47eec9ff47a81bcfee82e9516ce5837b6a56cdedaca6', 1, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2021-10-28 15:07:23', '2021-10-28 15:07:23', '2022-10-28 13:07:23'),
	('299031ced9ad2623958e8176b3af901dc85381c6bb2fa30db7caf85acfa655945ea86b095ac01f8b', 1, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2022-03-03 16:18:13', '2022-03-03 16:18:13', '2023-03-03 14:18:13'),
	('29a73a7449446d6933e09569f5305b1af5618dd1f1c9d282176a01db37021c02eadbd48e48a30719', 3, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2022-05-17 14:23:32', '2022-05-17 14:23:32', '2023-05-17 14:23:32'),
	('2c0530d64308b3351eb4029e22a7454485945742cc351a2a96ad788978e27c33945f763fce555d1a', 5, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2022-05-16 14:36:08', '2022-05-16 14:36:08', '2023-05-16 12:36:08'),
	('3097ea31d94d4c096ef737033e24b268af585e8eb139b5efd8c17ecaa2f161d5812cf36111d27761', 3, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2022-05-25 13:59:49', '2022-05-25 13:59:49', '2023-05-25 13:59:49'),
	('31acf1c07859f73bddd0691be9c140b353f5bcfe66abf498b3e1bbd475ef153b2590c98aa02f3665', 1, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2022-02-10 12:44:53', '2022-02-10 12:44:53', '2023-02-10 10:44:53'),
	('337d04d7dbb6956c7f559a7cf63fe350b3e3f624d04690082c37992378271c0bcd0105eed4cb1ca5', 3, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2022-05-26 16:25:34', '2022-05-26 16:25:34', '2023-05-26 16:25:34'),
	('350b06b55fdb2ebc6fa82635d6bc837c34d6816aeafd8d6a4fb719f39cbbaa1c30f21a7291a2fc51', 1, '94917b8f-2df3-4b1a-90b1-1516c5b6f134', NULL, '["*"]', 0, '2022-03-03 14:41:15', '2022-03-03 14:41:15', '2023-03-03 12:41:15'),
	('3c82a362d0225d07d5d587ec869f6d02a9f909210b10675abb3422e5ffde18c08acb8b72a72ff28c', 2, '94917b8f-2df3-4b1a-90b1-1516c5b6f134', NULL, '["*"]', 0, '2021-11-23 15:45:25', '2021-11-23 15:45:25', '2022-11-23 13:45:25'),
	('420394586337810928cec46171ad2e7d7d32dc3081c93761655727d5197961582b921af530e1202c', 1, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2021-10-28 21:12:25', '2021-10-28 21:12:25', '2022-10-28 19:12:25'),
	('4b552ce47c04ce6b250b73e1c32f2eaf590c5fa2b5237dc179cbb2b55c31f01673a33fbbc0e67637', 2, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2021-10-29 09:01:33', '2021-10-29 09:01:33', '2022-10-29 07:01:33'),
	('4fe4ae913613563379c85bd2403577fc25806ceaffd178811f7e4068672a2955dba393bdfa4dc7b8', 3, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2022-05-10 11:19:11', '2022-05-10 11:19:11', '2023-05-10 09:19:11'),
	('51b3a0d8c79a5459c5a2a6dff5e27227ca79038ad14d8d4a64320e5ff8d82653c0e71360f627acaa', 1, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2021-11-02 11:16:04', '2021-11-02 11:16:04', '2022-11-02 09:16:04'),
	('530e4c9987063fb53676d86ffd3efb3fe6ff68e2d4f9d0c7f0b1a41eefe5dc2ad7137a8ea7bbe39d', 3, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2022-05-16 14:08:57', '2022-05-16 14:08:57', '2023-05-16 12:08:57'),
	('5a3a81b5df03f759eb29f5a23acf543ae0677d7740dc838d77ee360e81f54463f6b639f73685307d', 3, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2021-11-23 16:20:55', '2021-11-23 16:20:55', '2022-11-23 14:20:55'),
	('5cd03eaafed8e8ec388b7f870ba13f5053f5fea4d00f0ed085e6ee4ef47bda26d61b37918dc03e4e', 2, '94917b8f-2df3-4b1a-90b1-1516c5b6f134', NULL, '["*"]', 0, '2021-11-23 15:45:36', '2021-11-23 15:45:36', '2022-11-23 13:45:36'),
	('5e6e3507f8ea244c3fe6fbac4cd2713358c8534c89c861b06d17e55067ce5765750b928d4b803f8a', 1, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2022-02-07 12:03:54', '2022-02-07 12:03:54', '2023-02-07 10:03:54'),
	('6dfc84827b6e550702964c7d7264d4fa44bf1d6302a1f6231a45e1020f8e253bd3ec7efc7280afae', 1, '94917b8f-2df3-4b1a-90b1-1516c5b6f134', NULL, '["*"]', 1, '2022-04-26 10:37:32', '2022-04-26 10:37:32', '2023-04-26 08:37:32'),
	('6e0cd183f4081754c6a659926495fd694606b1151cec0907e0f14ea5e7bfb6ee7e05f9ecdaa4fe71', 1, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2021-11-02 14:28:00', '2021-11-02 14:28:00', '2022-11-02 12:28:00'),
	('72f6e6a43af0fb593cd4aa0d6080bea059ac5ddbe2b293e582f3c5058eeb855020c2fba8d4a0e65b', 3, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2021-11-09 15:27:11', '2021-11-09 15:27:11', '2022-11-09 13:27:11'),
	('75111f024a4e7c75a57120199c44df6c38a3cd8aad566f17e165d4c45eb017dd14ee9f5ce5a479a9', 1, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2021-11-11 19:35:55', '2021-11-11 19:35:55', '2022-11-11 17:35:55'),
	('7dace7b040e40c8eea78d0e18fbd40c49b66452e9e86e5cb8b2fd2d573eec7403fd991c997197f37', 3, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2022-05-09 14:53:40', '2022-05-09 14:53:40', '2023-05-09 12:53:40'),
	('82c4acf33e9b7ceec864a5e56987c4b0b543bec075459ea6454798b4d90dafe5cd45d5aebbcc7f4a', 3, '94917b8f-2df3-4b1a-90b1-1516c5b6f134', NULL, '["*"]', 1, '2022-02-10 13:00:46', '2022-02-10 13:00:46', '2023-02-10 11:00:46'),
	('8fa8688b0efe0f8fa5b98c947b4d7f162e27cc607fa015e1d515d59e5fb4b81395a4d46eded8e00b', 1, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2022-02-07 12:39:49', '2022-02-07 12:39:49', '2023-02-07 10:39:49'),
	('91e239d12429ed1621becd46a70472a475ad6d0a0411430637654ea93a8947f144404b25d5c39f37', 2, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2021-10-29 09:45:23', '2021-10-29 09:45:23', '2022-10-29 07:45:23'),
	('92b6d0ad8003378fbcd434c24c4a7be1a1a53f9b13aecf5c4ae1aac5b2fac712bf663a0c101d69a0', 3, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2022-05-10 14:01:52', '2022-05-10 14:01:52', '2023-05-10 12:01:52'),
	('92f04a29f09adc33f4e0e047e6a3ce133c68b30a83c48c947b716e328ce63223c7cc54b6d68a738e', 1, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2021-10-29 08:55:00', '2021-10-29 08:55:00', '2022-10-29 06:55:00'),
	('9defe38e702fee73c984e7fd8aba4fd14df7d25f5315cbf52b1068b69595ff2ab021baddec32fd8e', 1, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2021-10-29 09:46:10', '2021-10-29 09:46:10', '2022-10-29 07:46:10'),
	('a0ffda6b8f107c776c6c246a4f13938b52840d3e31b6ab9e0ea8ee112905d5517f014c73558e3564', 1, '94917b8f-2df3-4b1a-90b1-1516c5b6f134', NULL, '["*"]', 0, '2022-04-26 11:04:04', '2022-04-26 11:04:04', '2023-04-26 09:04:04'),
	('a6391d0b5f06164c1c29f72487c31c4563bd45bf6e653d7c6bee70b3418c39d1091d9ae1c151b6ba', 2, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2021-10-29 10:06:44', '2021-10-29 10:06:44', '2022-10-29 08:06:44'),
	('a7d43b950b2a31fbe25cd86edaaeaa2be7a27cf459ab53d609ab632487a8d2a3f70ec17827ba707f', 1, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2021-10-29 10:23:19', '2021-10-29 10:23:19', '2022-10-29 08:23:19'),
	('a7e0f2229228d6e270c8520309d35e09ffe2c7e9a51d6375d83f7e3caf7c5edecf2554e6d08708ef', 1, '94917b8f-2df3-4b1a-90b1-1516c5b6f134', NULL, '["*"]', 0, '2021-10-28 16:13:06', '2021-10-28 16:13:06', '2022-10-28 14:13:06'),
	('b958418a39f72c05a5993f2936d4c87a2d3fe80f9a0d22f3d7b1cbd83b277560b23756b24542c84f', 1, '94917b8f-2df3-4b1a-90b1-1516c5b6f134', NULL, '["*"]', 0, '2022-02-11 11:08:04', '2022-02-11 11:08:04', '2023-02-11 09:08:04'),
	('bf7cf1ba5b2ba646f0d71c9d9d4ed05ab3835df8fd7585b093002146e4595c550b6345bf29b59d8c', 5, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2022-05-16 14:35:34', '2022-05-16 14:35:34', '2023-05-16 12:35:34'),
	('c87c9ceed5ecd9c0aa996d2fb9f6b0e70fc821066a23131c7c05cac3912c73535c11cef9955a5dae', 3, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2022-05-10 14:03:25', '2022-05-10 14:03:25', '2023-05-10 12:03:25'),
	('e181c2ec46d9c8673a36749828d91454aeafd2c802d7d62fc8699a5eb1aff0397bf9f80bebbdb3b3', 1, '94917b8f-2df3-4b1a-90b1-1516c5b6f134', NULL, '["*"]', 0, '2022-04-26 10:40:20', '2022-04-26 10:40:20', '2023-04-26 08:40:20'),
	('e3caad961356a9037570c44aede5b1bedf67cbfbfab81cb75e4e3958b1ee971c02ee559691eaf642', 3, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2022-05-10 12:52:44', '2022-05-10 12:52:44', '2023-05-10 10:52:44'),
	('ea3b4583c5676da3c589c362865ac9dfe66031ef4cd69ca076f224b061c1ee31cce372115d5d8bed', 4, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2022-05-10 12:44:03', '2022-05-10 12:44:03', '2023-05-10 10:44:03'),
	('f04717f40c0adf0e7f1dd0d83cc86a0a3760ea54b4f12b8ed9149e5d41e3aad8871814e3ac867cbc', 3, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2022-05-16 12:41:57', '2022-05-16 12:41:57', '2023-05-16 10:41:57'),
	('f7ef207db67e352199e1bf371bdaa5ebf7b162ac430264f6d6216ae4e5c6a9d0d7afd2d487903ec2', 3, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2022-05-16 14:58:25', '2022-05-16 14:58:25', '2023-05-16 14:58:25'),
	('f7fd5ea4be57d6b1f51da54ca5e389d754329c0a65baf4ce20e1cec6cd14ee66337164f9f9e5fb52', 3, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2022-05-26 11:45:15', '2022-05-26 11:45:15', '2023-05-26 11:45:15'),
	('fa659d4028ae81dea96c80f16558055447d70eef0e7a6305f90ccab779aa12fbd000ca2ad6901166', 3, '949344ce-70fd-4341-b9e6-314d048bfed8', NULL, '["*"]', 0, '2021-11-09 15:20:37', '2021-11-09 15:20:37', '2022-11-09 13:20:37'),
	('fa85e9809f6192e0a099b27a127c037a16b0177cb4ed6d30888a14d2afd7fa3cc0a009e5e8606ae8', 1, '94917b8f-2df3-4b1a-90b1-1516c5b6f134', NULL, '["*"]', 1, '2022-04-26 10:43:19', '2022-04-26 10:43:19', '2023-04-26 08:43:19');

-- Dumping structure for table quatenus.oauth_auth_codes
CREATE TABLE IF NOT EXISTS `oauth_auth_codes` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `client_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `scopes` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_auth_codes_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table quatenus.oauth_auth_codes: ~0 rows (approximately)

-- Dumping structure for table quatenus.oauth_clients
CREATE TABLE IF NOT EXISTS `oauth_clients` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `secret` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `provider` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `redirect` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `personal_access_client` tinyint(1) NOT NULL,
  `password_client` tinyint(1) NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_clients_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table quatenus.oauth_clients: ~4 rows (approximately)
INSERT INTO `oauth_clients` (`id`, `user_id`, `name`, `secret`, `provider`, `redirect`, `personal_access_client`, `password_client`, `revoked`, `created_at`, `updated_at`) VALUES
	('94917b8f-2df3-4b1a-90b1-1516c5b6f134', NULL, 'Amparo Password Grant Client', '3E3IAHETHTNc49MqnuDBQcrZdSq70wmrA6sce5o6', 'operators', 'http://localhost', 0, 1, 0, '2021-10-28 15:03:15', '2021-10-28 15:03:15'),
	('949344ce-70fd-4341-b9e6-314d048bfed8', NULL, 'Amparo Password Grant Client', 'wwIrMatFGF0aSy726mJX3UFiD4eys4U8XejJREXq', 'users', 'http://localhost', 0, 1, 0, '2021-10-28 15:03:14', '2021-10-28 15:03:14'),
	('94bdbbbc-4692-4c6a-a0f8-33112262ab70', NULL, 'Amparo Personal Access Client', 'DOojG1lcBqQAj58iJk3mwaNDTO8txuYppyr0OcH1', NULL, 'http://localhost', 1, 0, 0, '2021-10-28 15:03:14', '2021-10-28 15:03:14'),
	('94bdbbbe-78ce-4e9a-8295-ece3210a4306', NULL, 'Amparo Personal Access Client', '6Om4o7W0ozJzUpD4gO6VFmbf2huXoGfQ9n7I8wE3', NULL, 'http://localhost', 1, 0, 0, '2021-10-28 15:03:15', '2021-10-28 15:03:15');

-- Dumping structure for table quatenus.oauth_personal_access_clients
CREATE TABLE IF NOT EXISTS `oauth_personal_access_clients` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `client_id` char(36) COLLATE utf8mb4_unicode_ci NOT 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 quatenus.oauth_personal_access_clients: ~2 rows (approximately)
INSERT INTO `oauth_personal_access_clients` (`id`, `client_id`, `created_at`, `updated_at`) VALUES
	(1, '94bdbbbc-4692-4c6a-a0f8-33112262ab70', '2021-10-28 15:03:14', '2021-10-28 15:03:14'),
	(2, '94bdbbbe-78ce-4e9a-8295-ece3210a4306', '2021-10-28 15:03:15', '2021-10-28 15:03:15');

-- Dumping structure for table quatenus.oauth_refresh_tokens
CREATE TABLE IF NOT EXISTS `oauth_refresh_tokens` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `access_token_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table quatenus.oauth_refresh_tokens: ~48 rows (approximately)
INSERT INTO `oauth_refresh_tokens` (`id`, `access_token_id`, `revoked`, `expires_at`) VALUES
	('020daf67b5ca97cd948bd8255edad6bb6d062ec81896b2d04cec60f3b9bdf0d7fac88807e44bc620', '11a537eeed5e4178e245591f40cee7314a00ae228ae0cdff48d17783cc354af2329df5c17a27b5b9', 0, '2022-10-29 08:24:30'),
	('05a6be5a1a39ae07d05c7719fc891d02640b4f9c1d9e6464c8f7a76de153db24e6a3d5e7cec33121', '0c8fa8857079859ed896292b9230157482a194848771a4514d5833ecfb9fe1a00f06f7183fbc4067', 1, '2022-11-09 11:52:46'),
	('08b2a4ab980c5542cc75c0d998bfde04472368b9f8d82307dff315530568866dd464cbecd5a8f373', '0fa1fac43fb3552c17f7107f1fe953860bceb9839b097ee043d2e01b12eba8ec7e6a7d4cbff640a1', 0, '2023-05-10 09:35:13'),
	('0d77a9bb8d2307f2535f0fc069c31c7cec7553549d2af8d9aa3d163b94b6a395920f0034be99e2de', '4b552ce47c04ce6b250b73e1c32f2eaf590c5fa2b5237dc179cbb2b55c31f01673a33fbbc0e67637', 0, '2022-10-29 07:01:33'),
	('149a8d0c77041154b8bd2442369e9699e9a07c6407e784a406b116f52dd80c43faf065f301c14a53', '51b3a0d8c79a5459c5a2a6dff5e27227ca79038ad14d8d4a64320e5ff8d82653c0e71360f627acaa', 0, '2022-11-02 09:16:04'),
	('14f59d2b53eb3e3e5e52b90cd6796d939fcd8f7aec60865382c2a39763401d10aeb7b5cf59e6c2e5', '6dfc84827b6e550702964c7d7264d4fa44bf1d6302a1f6231a45e1020f8e253bd3ec7efc7280afae', 1, '2023-04-26 08:37:32'),
	('2205acf556c916bb4e4683709fe1e4bdc0511c780b01a97289833847fe164b645abaad7e99426a91', 'ea3b4583c5676da3c589c362865ac9dfe66031ef4cd69ca076f224b061c1ee31cce372115d5d8bed', 0, '2023-05-10 10:44:03'),
	('221a93655333816371926c23c7a1a37456ff5a1a9cbf80a09b4c03d6887ad22ed4730d1bb3d026e3', '82c4acf33e9b7ceec864a5e56987c4b0b543bec075459ea6454798b4d90dafe5cd45d5aebbcc7f4a', 1, '2023-02-10 11:00:46'),
	('262986214e480fdd7c930d675940a92ef6bb90756887c3c23f0b32b8ce4aac7113ae9a5679f9a872', '1798273f216a494df40861a6d408ac576c65afd13d1d9a87bf251727c104d1e807b4a5a2cf040a25', 0, '2023-02-10 10:59:41'),
	('27fb58a8a4a22938bd0d65ac9bc6d5a675608721614a73ad2985ba0449b988924f272d50154772d7', '7dace7b040e40c8eea78d0e18fbd40c49b66452e9e86e5cb8b2fd2d573eec7403fd991c997197f37', 0, '2023-05-09 12:53:40'),
	('285dd070caeef3715acc542414d6bfc862febd23ee631eab343398a5df0630f422db87cf351b4b1a', '5cd03eaafed8e8ec388b7f870ba13f5053f5fea4d00f0ed085e6ee4ef47bda26d61b37918dc03e4e', 0, '2022-11-23 13:45:36'),
	('3161cddc04de46b5a6252a83c8b45fcf501447f1e7d2bfa0e7b6b1e5702a3e8dd295046928589f40', '0d9272540a8e069bdf45769a36ea56411dc3221e9d09aecc9478222b53eeee2b6da31a89a754f3b2', 0, '2023-05-17 11:09:33'),
	('3512ff1c59b44cddb75a0a1a55797b0f6547b5c0be26ed4fa3d390ecf6ae6aa522155906619c11f6', 'f7ef207db67e352199e1bf371bdaa5ebf7b162ac430264f6d6216ae4e5c6a9d0d7afd2d487903ec2', 0, '2023-05-16 14:58:25'),
	('37fc41982c62b0a763840949b877ce2e08db68daf0d6d04fef5e1511462c56f12e8f8adcb4d4fa76', '07b4a72932324f31920f76382829d5887c6c3938ec656e3951c1ceb4458313ba21799ad189e1eda6', 0, '2022-10-29 08:05:54'),
	('3be1a26e9c50f05f1955e409e78062b76275e695f426c34a84d706ff7c8e860f9dab54f3b10c347b', '350b06b55fdb2ebc6fa82635d6bc837c34d6816aeafd8d6a4fb719f39cbbaa1c30f21a7291a2fc51', 0, '2023-03-03 12:41:15'),
	('41f6e02f26291a0364e762ef801b2d99045a23a6f0730c2b43b5285448d7589504893511ed371d29', '4fe4ae913613563379c85bd2403577fc25806ceaffd178811f7e4068672a2955dba393bdfa4dc7b8', 0, '2023-05-10 09:19:11'),
	('43bd1c51fca42c93b27e8d361e80cc2d20f02f17c561cbad5988e26c6ab69062d7fa91084c7ed68d', '02bf5d80c1316ba5b6c09c2e626d06e28e0c38ca18fa3501003619f78e050b2c495142ab441ae0b7', 0, '2023-03-03 14:21:55'),
	('4471d9c348b7ca4d36eaee60851d57e2ee8b8fb45a2393e0d6709b98fd87a8eb201d4f10d7c5d9a5', '5e6e3507f8ea244c3fe6fbac4cd2713358c8534c89c861b06d17e55067ce5765750b928d4b803f8a', 0, '2023-02-07 10:03:54'),
	('4c0ce91451d78dab72ce3c9de504e17a07bae7db04302bba4c344442d0a8f209333f0fec49e20623', 'a7d43b950b2a31fbe25cd86edaaeaa2be7a27cf459ab53d609ab632487a8d2a3f70ec17827ba707f', 0, '2022-10-29 08:23:19'),
	('5860ddc330c9d8db335ab0ddee3d83b1435e1029caadaeba11cdc421472775a6fe5de9c342ad4611', '31acf1c07859f73bddd0691be9c140b353f5bcfe66abf498b3e1bbd475ef153b2590c98aa02f3665', 0, '2023-02-10 10:44:53'),
	('5ef3bebc356f6e8d427d16378ead5f1da5c7f636281d08fdebfcb9bb52d076c25cc73ff5fc86f6f9', '29a73a7449446d6933e09569f5305b1af5618dd1f1c9d282176a01db37021c02eadbd48e48a30719', 0, '2023-05-17 14:23:33'),
	('60655d52642eedbf0d60b5535d0f56430808f4ea1938baeff9a421b66e01c49c112efda5d0e6f0c3', 'f04717f40c0adf0e7f1dd0d83cc86a0a3760ea54b4f12b8ed9149e5d41e3aad8871814e3ac867cbc', 0, '2023-05-16 10:41:57'),
	('658badb814367fb35c850cea8f07f796445cbc1fe0d2a5cfac4e7e41d7bcaee5911edb2fcca18ad4', 'b958418a39f72c05a5993f2936d4c87a2d3fe80f9a0d22f3d7b1cbd83b277560b23756b24542c84f', 0, '2023-02-11 09:08:04'),
	('66f8cd6bafb79fbca233378cbfd9e736e44b6bcb3da80eaa723b982e23d97fcbbab3023384e0da36', '92f04a29f09adc33f4e0e047e6a3ce133c68b30a83c48c947b716e328ce63223c7cc54b6d68a738e', 0, '2022-10-29 06:55:00'),
	('68ec55e33dd7df508aecdf22b500d82c52d1ad61d0b6a443e8ac39f2839a4334c4dd00918b1630f9', 'fa659d4028ae81dea96c80f16558055447d70eef0e7a6305f90ccab779aa12fbd000ca2ad6901166', 0, '2022-11-09 13:20:38'),
	('6f9c224b251ce04087c3b658305d534bfcfe4025a50b9d660d5404955b7794b328728ac741b7e8b5', 'bf7cf1ba5b2ba646f0d71c9d9d4ed05ab3835df8fd7585b093002146e4595c550b6345bf29b59d8c', 0, '2023-05-16 12:35:34'),
	('70daf765dcf40df9ca0392183f36bb3e09e8a954101fe72d87caf15b37d81f0a49b1e3ca71017815', '420394586337810928cec46171ad2e7d7d32dc3081c93761655727d5197961582b921af530e1202c', 0, '2022-10-28 19:12:25'),
	('7128ebefac22a8aa82aa7cf893c2433c170030c9435f42591ec6cf11a8a261143a7f57d82deda261', '17d70e0545bbee26827da7df3b37b51932ceb4cc17b579d360529ed8b1849b89080dd9ff65184974', 0, '2022-10-29 08:39:47'),
	('7298819f276fd619f21dc866b5932cac1270dbf90b2f412ee43c72f0246a0be3d369ed62ec484e84', '337d04d7dbb6956c7f559a7cf63fe350b3e3f624d04690082c37992378271c0bcd0105eed4cb1ca5', 0, '2023-05-26 16:25:34'),
	('745543f279a977c164d62708d4e1a0826bf54fe58715384e02aaea4560410476f904983d85d9254d', '22720dbd67fe4c5ca5fdecbe4b84e7d3e548c90ad1a6f92077e9b74d16c38effe6c508a3fba9a711', 0, '2023-05-18 10:06:45'),
	('7b489c2f13235cf206345cdfd55e3f1c972fde7a89fedb63184c2f97815a627c950a96c34afaaad7', '9defe38e702fee73c984e7fd8aba4fd14df7d25f5315cbf52b1068b69595ff2ab021baddec32fd8e', 0, '2022-10-29 07:46:10'),
	('7bc7ae366103fb0cee1d316487b5eb0bd67b536d8ac35b14e071bf81e2a7216f9f7205226d9aadb7', '2c0530d64308b3351eb4029e22a7454485945742cc351a2a96ad788978e27c33945f763fce555d1a', 0, '2023-05-16 12:36:08'),
	('7d37815b824221a55fa4aabf65c6a7072bcb2869bb98c5a4b63bbe6929fceb1b1e12d50d3b019153', 'e181c2ec46d9c8673a36749828d91454aeafd2c802d7d62fc8699a5eb1aff0397bf9f80bebbdb3b3', 0, '2023-04-26 08:40:20'),
	('84d0da32af4f3f98c73030cb1e1bb4bf514f5a9e26b2855c1bb040d60dde93e4062819ebaead8f50', 'a7e0f2229228d6e270c8520309d35e09ffe2c7e9a51d6375d83f7e3caf7c5edecf2554e6d08708ef', 0, '2022-10-28 14:13:06'),
	('861b659e657ee7cf160467c277a59e2637ebcbb0a066116457a87afb20ed92d330f791b4067627ed', 'f7fd5ea4be57d6b1f51da54ca5e389d754329c0a65baf4ce20e1cec6cd14ee66337164f9f9e5fb52', 0, '2023-05-26 11:45:15'),
	('934f4481bc51406e6b5f98aa71ca00412bc1d838c72668267e502a8c4176c2faf754b389673d5c68', '10f4802dfa514682f9473df12c8a1f5a93782f92daf313718fa087aa1699ccf069a08b16749ceb00', 0, '2022-10-28 14:50:09'),
	('93ecfb3ae1c1cdbef2164ae4e44213792d1ddbab9c0db4cf28f6ac3010c5723613c4020528377e41', '8fa8688b0efe0f8fa5b98c947b4d7f162e27cc607fa015e1d515d59e5fb4b81395a4d46eded8e00b', 0, '2023-02-07 10:39:49'),
	('94db4795f65556576e50d2a87f882ae55dc493fd2fd30fcaf53e8de81f5f26dfe7f7b72b03418e75', '6e0cd183f4081754c6a659926495fd694606b1151cec0907e0f14ea5e7bfb6ee7e05f9ecdaa4fe71', 0, '2022-11-02 12:28:00'),
	('a04b50522540c95322a8c06a94ccf3ee5030cba4ae81d8cdbdef439cc314f3a393928fcb85c35e02', 'a0ffda6b8f107c776c6c246a4f13938b52840d3e31b6ab9e0ea8ee112905d5517f014c73558e3564', 0, '2023-04-26 09:04:04'),
	('a3c734e3c7d90f15d2ad44b5169b8c331a918eaf2bfeb4761c0b6cbc79fe06e91e69c70fb210a435', '299031ced9ad2623958e8176b3af901dc85381c6bb2fa30db7caf85acfa655945ea86b095ac01f8b', 0, '2023-03-03 14:18:13'),
	('aea127f04343d082180288b9ff16e356084647a7e9b39e4024e9668f0bf27f7dc6854d940ed91622', '75111f024a4e7c75a57120199c44df6c38a3cd8aad566f17e165d4c45eb017dd14ee9f5ce5a479a9', 0, '2022-11-11 17:35:56'),
	('b0cdc3d4ba8bf5b0a633a5ac6563fcb3ebba22a3b03d66d94dd435701a530cebe955003962d16e43', 'a6391d0b5f06164c1c29f72487c31c4563bd45bf6e653d7c6bee70b3418c39d1091d9ae1c151b6ba', 0, '2022-10-29 08:06:44'),
	('b19f1cdfb673e4988a384d456e75432c43bdb8633ac06b4aad19cb54f0fd09022c43fa7a3b8cf147', '3c82a362d0225d07d5d587ec869f6d02a9f909210b10675abb3422e5ffde18c08acb8b72a72ff28c', 0, '2022-11-23 13:45:25'),
	('bcc4c9a1549a235e8530d1d2f6fcfa3163ad60bab6b0645c7492b7f0fec391d48afeb9a351a4a3c7', '92b6d0ad8003378fbcd434c24c4a7be1a1a53f9b13aecf5c4ae1aac5b2fac712bf663a0c101d69a0', 0, '2023-05-10 12:01:52'),
	('c2d316c7a175ab37dde9892b6124935fc67a9741536d6386cdf79cb47bfd9cca0c4f6429ae5e09d0', '530e4c9987063fb53676d86ffd3efb3fe6ff68e2d4f9d0c7f0b1a41eefe5dc2ad7137a8ea7bbe39d', 0, '2023-05-16 12:08:57'),
	('c42fa9d9298df126b6577b7bf064d39518f15d3dc27d05bcc32e4b2ab6cb2d03c68a21315f6aa6a9', '2910af343fb83d169455e780972e56c4a4b0111b79cc8a8943335db68ffaae00fe1e2e8d2ed6a6b8', 0, '2022-10-28 13:06:51'),
	('d818430d95106cdfb54398551b2f76d1b1c8898a1427a3d9d6eef2cc6487dc8bd28b1d9830dbe15b', '292fe057e4b4a97f27d2a48e3860e00d029f47eec9ff47a81bcfee82e9516ce5837b6a56cdedaca6', 0, '2022-10-28 13:07:23'),
	('e53e0936a50dbe5143121f46b3f9633b5b4d6df5bd30ed23256c8ebea11be9d04e16818d30dd137c', '179fb0ae0ad4b5e4c9e698ce7f03dd219bdfba2856510c6c98f65870750e6673459b73b1815085c0', 0, '2023-05-16 12:36:48'),
	('e76fdb9da6ba1b3c7c105077837622cb651e4110505db84557455ec81b63b72a83b59fc79d0773a0', '3097ea31d94d4c096ef737033e24b268af585e8eb139b5efd8c17ecaa2f161d5812cf36111d27761', 0, '2023-05-25 13:59:49'),
	('e7b4149640e046941e0ba2dff3d9f7caa5adf22abd29d9070193577b164aec055c74119fba272851', 'c87c9ceed5ecd9c0aa996d2fb9f6b0e70fc821066a23131c7c05cac3912c73535c11cef9955a5dae', 0, '2023-05-10 12:03:25'),
	('f21a12218bc3fd1bc06054a5c656caea6bae1ac5112edc6c13ef3fab6fd508e5a1b59dd095820029', '72f6e6a43af0fb593cd4aa0d6080bea059ac5ddbe2b293e582f3c5058eeb855020c2fba8d4a0e65b', 0, '2022-11-09 13:27:11'),
	('f47f37eb12e6559dc6d0ea00610a3cf097fa5d563a45666187aaeb77d75dc6a62dcc409a5579b4a7', 'fa85e9809f6192e0a099b27a127c037a16b0177cb4ed6d30888a14d2afd7fa3cc0a009e5e8606ae8', 1, '2023-04-26 08:43:20'),
	('f6eb306d50cc2d3c5259b0687094186f1e86fe3188c9ec2510ffaa8d668452160ab64f233a27fe81', '91e239d12429ed1621becd46a70472a475ad6d0a0411430637654ea93a8947f144404b25d5c39f37', 0, '2022-10-29 07:45:23'),
	('f84441f555345ad5852f628f41b517146eaa435e059ea88e0ac80466cb4b1cd80cf4d89fa32e1ff7', 'e3caad961356a9037570c44aede5b1bedf67cbfbfab81cb75e4e3958b1ee971c02ee559691eaf642', 0, '2023-05-10 10:52:44'),
	('f930c60b3b3ae83da907f7f80082f57ea27fa8480174edcbdeb0378732064a95505fe1c3de8be413', '5a3a81b5df03f759eb29f5a23acf543ae0677d7740dc838d77ee360e81f54463f6b639f73685307d', 0, '2022-11-23 14:20:55');

-- Dumping structure for table quatenus.operators
CREATE TABLE IF NOT EXISTS `operators` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1234',
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'activo',
  `profile` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'operador',
  `session_status` int(11) NOT NULL DEFAULT 0,
  `store_id` int(10) unsigned DEFAULT 1,
  `user_id` int(10) unsigned DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `operators_email_unique` (`email`),
  UNIQUE KEY `operators_phone_unique` (`phone`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table quatenus.operators: ~1 rows (approximately)
INSERT INTO `operators` (`id`, `name`, `last_name`, `email`, `phone`, `email_verified_at`, `password`, `pin`, `status`, `profile`, `session_status`, `store_id`, `user_id`, `remember_token`, `created_at`, `updated_at`) VALUES
	(4, 'rodrigues.mafumo', 'Math', 'mafumorodrigues@gmail.com', '+258849231169', NULL, '$2y$10$4bVIrzsgO/y3qWEtP849jeLLtNpYFJRcdfnkp/tJCBXQNKJewTLSq', '1234', 'activo', 'operador', 0, 1, NULL, NULL, '2022-05-26 16:13:02', '2022-05-26 16:22:58');

-- Dumping structure for table quatenus.password_resets
CREATE TABLE IF NOT EXISTS `password_resets` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table quatenus.password_resets: ~0 rows (approximately)

-- Dumping structure for table quatenus.payments
CREATE TABLE IF NOT EXISTS `payments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `transaction` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` double NOT NULL,
  `amount_debited` double NOT NULL,
  `amount_credited` double NOT NULL,
  `amount_card` double NOT NULL,
  `amount_account` double NOT NULL,
  `fee` double NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'sucesso',
  `customer_account_id` int(10) unsigned DEFAULT NULL,
  `customer_card_id` int(10) unsigned DEFAULT NULL,
  `store_id` int(10) unsigned DEFAULT NULL,
  `user_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table quatenus.payments: ~18 rows (approximately)
INSERT INTO `payments` (`id`, `transaction`, `amount`, `amount_debited`, `amount_credited`, `amount_card`, `amount_account`, `fee`, `description`, `status`, `customer_account_id`, `customer_card_id`, `store_id`, `user_id`, `created_at`, `updated_at`) VALUES
	(1, 'Py0Q9SGeLIcVUhT', 100, 100, 0, 0, 100, 0, 'Pagamento de factura na clinica amparo', 'sucesso', 1, 1, 1, 1, '2021-10-28 16:13:56', '2021-10-28 16:13:56'),
	(2, 'ZfFca3KZbY3Jx7p', 100, 100, 0, 0, 100, 0, 'Pagamento de factura na clinica amparo', 'sucesso', 7, 1, 1, 1, '2021-11-09 14:36:02', '2021-11-09 14:36:02'),
	(3, '1Y6EHhyC4dT6smv', 320, 320, 0, 0, 320, 0, 'Pagamento de factura na clinica amparo', 'sucesso', 7, 1, 1, 1, '2021-11-09 14:40:59', '2021-11-09 14:40:59'),
	(4, '5niGbSZKb8YmJGh', 100, 100, 0, 0, 100, 0, 'Pagamento de factura na clinica amparo', 'sucesso', 7, 1, 1, 1, '2021-11-09 14:48:39', '2021-11-09 14:48:39'),
	(5, 'Ancr2nDQplv9I8m', 200, 200, 0, 0, 200, 0, 'Pagamento de factura na clinica amparo', 'sucesso', 7, 1, 1, 1, '2021-11-09 15:54:26', '2021-11-09 15:54:26'),
	(6, '5Mu7J2NTItjaQAL', 20, 20, 0, 0, 20, 0, 'Pagamento de factura na clinica amparo', 'sucesso', 1, 13, 1, 1, '2021-11-16 14:52:12', '2021-11-16 14:52:12'),
	(7, 'cR4jb4SUzHSaJFz', 20, 20, 0, 0, 20, 0, 'Pagamento de factura na clinica amparo', 'sucesso', 8, 16, 1, 2, '2021-11-23 15:53:16', '2021-11-23 15:53:16'),
	(8, 'jUHpCorfPSzxCHU', 9, 9, 0, 0, 9, 0, 'Pagamento de factura na clinica amparo', 'sucesso', 9, 15, 1, 2, '2021-11-23 16:00:36', '2021-11-23 16:00:36'),
	(9, 'atMMnQkBq8Z7xHu', 100, 100, 0, 0, 100, 0, 'Pagamento de factura na clinica amparo', 'sucesso', 10, 18, 1, 1, '2022-02-11 11:58:06', '2022-02-11 11:58:06'),
	(10, 'LN8pqEdvXoHZT0M', 10, 10, 0, 0, 10, 0, 'Pagamento de factura na clinica amparo', 'sucesso', 10, 18, 1, 3, '2022-03-03 16:27:12', '2022-03-03 16:27:12'),
	(11, 'gtgu4MTt7qxkvzy', 15, 15, 0, 0, 15, 0, 'Pagamento de factura na clinica amparo', 'sucesso', 11, 21, 1, 3, '2022-03-03 17:36:40', '2022-03-03 17:36:40'),
	(12, 'oFKThwngTwNsJWY', 28, 28, 0, 0, 28, 0, 'Pagamento de factura na clinica amparo', 'sucesso', 11, 21, 1, 3, '2022-03-03 18:30:33', '2022-03-03 18:30:33'),
	(13, 'bytBydnI5KlOOMd', 45, 45, 0, 0, 45, 0, 'Pagamento de factura na clinica amparo', 'sucesso', 11, 21, 1, 3, '2022-03-03 18:31:50', '2022-03-03 18:31:50'),
	(14, 'u0FjdBoMnDOUKKH', 15, 15, 0, 0, 15, 0, 'Pagamento de factura na clinica amparo', 'sucesso', 11, 21, 1, 3, '2022-03-04 09:25:52', '2022-03-04 09:25:52'),
	(15, 'fXI08jHWvwB8gdI', 25, 25, 0, 0, 25, 0, 'Pagamento de factura na clinica amparo', 'sucesso', 11, 21, 1, 3, '2022-04-25 17:19:55', '2022-04-25 17:19:55'),
	(16, 'YenGRUI98YFPDMO', 20, 20, 0, 0, 20, 0, 'Pagamento de factura na clinica amparo', 'sucesso', 11, 22, 1, 1, '2022-04-26 11:05:18', '2022-04-26 11:05:18'),
	(17, 'HgZGcYxMU8MTNBF', 17, 17, 0, 0, 17, 0, 'Pagamento de factura na clinica amparo', 'sucesso', 11, 22, 1, 1, '2022-04-26 11:06:45', '2022-04-26 11:06:45'),
	(18, 'yIoqpAwSxN5ph9L', 23, 23, 0, 0, 23, 0, 'Pagamento de factura na clinica amparo', 'sucesso', 11, 22, 1, 1, '2022-04-26 11:44:06', '2022-04-26 11:44:06');

-- Dumping structure for table quatenus.payment_tokens
CREATE TABLE IF NOT EXISTS `payment_tokens` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `codigo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `expire_in` date NOT NULL,
  `duration` int(11) NOT NULL,
  `country_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '+258',
  `is_Validated` tinyint(1) NOT NULL DEFAULT 0,
  `customer_card_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table quatenus.payment_tokens: ~37 rows (approximately)
INSERT INTO `payment_tokens` (`id`, `phone`, `codigo`, `expire_in`, `duration`, `country_code`, `is_Validated`, `customer_card_id`, `created_at`, `updated_at`) VALUES
	(1, '845030902', '102958', '2021-10-28', 3, '+258', 1, 1, '2021-10-28 16:13:16', '2021-10-28 16:13:56'),
	(2, '845030902', '535405', '2021-10-29', 3, '+258', 0, 1, '2021-10-29 10:42:29', '2021-10-29 10:42:29'),
	(3, '827738993', '321092', '2021-11-09', 3, '+258', 1, 1, '2021-11-09 14:28:37', '2021-11-09 14:29:02'),
	(4, '827738993', '137148', '2021-11-09', 3, '+258', 1, 1, '2021-11-09 14:32:38', '2021-11-09 14:33:02'),
	(5, '827738993', '553681', '2021-11-09', 3, '+258', 1, 1, '2021-11-09 14:35:31', '2021-11-09 14:36:02'),
	(6, '827738993', '605724', '2021-11-09', 3, '+258', 1, 1, '2021-11-09 14:40:19', '2021-11-09 14:40:59'),
	(7, '827738993', '669681', '2021-11-09', 3, '+258', 1, 1, '2021-11-09 14:48:04', '2021-11-09 14:48:39'),
	(8, '827738993', '869708', '2021-11-09', 3, '+258', 1, 1, '2021-11-09 15:52:57', '2021-11-09 15:54:26'),
	(9, '845030902', '062974', '2021-11-12', 3, '+258', 0, 16, '2021-11-12 15:52:51', '2021-11-12 15:52:51'),
	(10, '845030902', '290434', '2021-11-12', 3, '+258', 1, 15, '2021-11-12 16:00:02', '2021-11-12 16:04:39'),
	(11, '845030902', '443954', '2021-11-12', 3, '+258', 0, 15, '2021-11-12 16:04:14', '2021-11-12 16:04:14'),
	(12, '845030902', '839413', '2021-11-16', 3, '+258', 1, 13, '2021-11-16 14:51:39', '2021-11-16 14:52:12'),
	(13, '845030902', '173016', '2021-11-16', 3, '+258', 0, 13, '2021-11-16 14:53:04', '2021-11-16 14:53:04'),
	(14, '845030902', '934655', '2021-11-16', 3, '+258', 1, 16, '2021-11-16 15:43:40', '2021-11-16 15:47:12'),
	(15, '845030902', '766589', '2021-11-16', 3, '+258', 1, 16, '2021-11-16 15:46:43', '2021-11-16 15:47:40'),
	(16, '846979379', '392088', '2021-11-23', 3, '+258', 1, 16, '2021-11-23 15:52:16', '2021-11-23 15:53:16'),
	(17, '847875406', '513861', '2021-11-23', 3, '+258', 1, 15, '2021-11-23 15:59:53', '2021-11-23 16:00:36'),
	(18, '847875406', '430809', '2021-11-23', 3, '+258', 1, 15, '2021-11-23 16:01:49', '2021-11-23 16:02:16'),
	(19, '845030902', '801722', '2022-02-11', 3, '+258', 0, 18, '2022-02-11 11:56:44', '2022-02-11 11:56:44'),
	(20, '845030902', '653164', '2022-02-11', 3, '+258', 1, 18, '2022-02-11 11:57:35', '2022-02-11 11:58:06'),
	(21, '845030902', '580097', '2022-03-03', 3, '+258', 1, 18, '2022-03-03 16:23:18', '2022-03-03 16:27:12'),
	(22, '845030902', '887512', '2022-03-03', 3, '+258', 0, 18, '2022-03-03 16:27:49', '2022-03-03 16:27:49'),
	(23, '845030902', '513025', '2022-03-03', 3, '+258', 0, 20, '2022-03-03 17:28:39', '2022-03-03 17:28:39'),
	(24, '845030902', '256155', '2022-03-03', 3, '+258', 0, 21, '2022-03-03 17:30:11', '2022-03-03 17:30:11'),
	(25, '845030902', '365876', '2022-03-03', 3, '+258', 0, 21, '2022-03-03 17:32:13', '2022-03-03 17:32:13'),
	(26, '849113915', '497656', '2022-03-03', 3, '+258', 0, 21, '2022-03-03 17:34:20', '2022-03-03 17:34:20'),
	(27, '849113015', '067575', '2022-03-03', 3, '+258', 1, 21, '2022-03-03 17:35:59', '2022-03-03 17:36:40'),
	(28, '849113015', '700142', '2022-03-03', 3, '+258', 1, 21, '2022-03-03 18:30:00', '2022-03-03 18:30:32'),
	(29, '849113015', '333308', '2022-03-03', 3, '+258', 1, 21, '2022-03-03 18:30:58', '2022-03-03 18:31:50'),
	(30, '849113015', '348912', '2022-03-04', 3, '+258', 1, 21, '2022-03-04 09:25:18', '2022-03-04 09:25:52'),
	(31, '849113015', '057313', '2022-04-25', 3, '+258', 0, 21, '2022-04-25 17:18:41', '2022-04-25 17:18:41'),
	(32, '849113015', '894063', '2022-04-25', 3, '+258', 1, 21, '2022-04-25 17:19:13', '2022-04-25 17:19:55'),
	(33, '849113015', '999609', '2022-04-26', 3, '+258', 0, 22, '2022-04-26 10:43:29', '2022-04-26 10:43:29'),
	(34, '849113015', '193728', '2022-04-26', 3, '+258', 0, 22, '2022-04-26 10:47:50', '2022-04-26 10:47:50'),
	(35, '849113015', '695553', '2022-04-26', 3, '+258', 1, 22, '2022-04-26 11:04:52', '2022-04-26 11:05:18'),
	(36, '849113015', '061267', '2022-04-26', 3, '+258', 1, 22, '2022-04-26 11:06:21', '2022-04-26 11:06:45'),
	(37, '849113015', '357267', '2022-04-26', 3, '+258', 1, 22, '2022-04-26 11:43:10', '2022-04-26 11:44:06');

-- Dumping structure for table quatenus.personal_access_tokens
CREATE TABLE IF NOT EXISTS `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 DEFAULT NULL,
  `last_used_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 quatenus.personal_access_tokens: ~0 rows (approximately)

-- Dumping structure for table quatenus.recharges
CREATE TABLE IF NOT EXISTS `recharges` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `transaction` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'sucesso',
  `amount` double NOT NULL,
  `last_balance` double NOT NULL,
  `balance` double NOT NULL,
  `recharge_way` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `recharge_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_account_id` int(10) unsigned DEFAULT NULL,
  `customer_card_id` int(10) unsigned DEFAULT NULL,
  `user_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table quatenus.recharges: ~4 rows (approximately)
INSERT INTO `recharges` (`id`, `transaction`, `status`, `amount`, `last_balance`, `balance`, `recharge_way`, `recharge_type`, `customer_account_id`, `customer_card_id`, `user_id`, `created_at`, `updated_at`) VALUES
	(1, '8f33b26b52c143539b10641538769844', 'sucesso', 20, 20, 40, 'Quatenus', 'account', 1, NULL, 3, '2022-05-27 10:20:53', '2022-05-27 10:20:53'),
	(2, '44dea879645047fda1cfb0cedd5efffc', 'sucesso', 50, 75, 125, 'Quatenus', 'account', 2, NULL, 3, '2022-05-27 10:21:33', '2022-05-27 10:21:33'),
	(3, '3475e1d443dc4c0d94ae0ba358818c7c', 'sucesso', 100, 0, 100, 'Quatenus', 'account', 6, NULL, 3, '2022-05-27 10:36:33', '2022-05-27 10:36:33'),
	(4, 'e865cd12985543bd8ea6d1bc4fd74512', 'sucesso', 200, 100, 300, 'Quatenus', 'account', 6, NULL, 3, '2022-05-27 10:39:32', '2022-05-27 10:39:32');

-- Dumping structure for table quatenus.refunds
CREATE TABLE IF NOT EXISTS `refunds` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `transaction` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` double NOT NULL,
  `fee` double NOT NULL DEFAULT 0,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'sucesso',
  `payment_id` int(10) unsigned DEFAULT NULL,
  `customer_account_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table quatenus.refunds: ~0 rows (approximately)

-- Dumping structure for table quatenus.stores
CREATE TABLE IF NOT EXISTS `stores` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `store_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `store_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `manager` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `manager_phone_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `store_public_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `store_mobile_phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `qrcode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nuit` int(11) DEFAULT 12345678,
  `store_nib` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `store_logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `store_balance` double NOT NULL DEFAULT 0,
  `store_firebase_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `merchant_id` int(10) unsigned DEFAULT 1,
  `user_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `stores_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table quatenus.stores: ~4 rows (approximately)
INSERT INTO `stores` (`id`, `store_name`, `store_address`, `manager`, `manager_phone_number`, `store_public_id`, `store_mobile_phone`, `qrcode`, `status`, `email`, `password`, `nuit`, `store_nib`, `store_logo`, `store_balance`, `store_firebase_token`, `merchant_id`, `user_id`, `created_at`, `updated_at`) VALUES
	(1, 'lojas333', 'Maxaquene', 'Math Silva', '+258849231169', '11d4fdb8-d87e-4a7d-bd05-eb62013668df', '827739993', '842141561', 1, 'mafumorodrigueis@gmail.com', '$2y$10$DYmrCzG0iji8j1EQmu42teYL8RoM2UuuzEAXMOq3G39uRq.X55iBu', 12345678, NULL, NULL, 0, NULL, NULL, 1, '2021-10-28 15:03:01', '2022-05-26 15:41:59'),
	(2, 'Loja1', 'Maxaquene', 'Mathi', '+258849231169', '11d4fdb8-d87e-4a7d-bd05-eb62013668d7', '842713926', NULL, 1, 'naftalivo2@gmail.com', '$2y$10$N08.nrJidNSnR0lWOmcNVeaI.edcYOKCWW28ukioSoPo5OPa56ffS', 12345678, NULL, NULL, 0, NULL, 1, 1, '2021-10-28 16:18:20', '2022-05-26 15:54:06'),
	(3, 'Loja iMali Paytek', 'Cidade da Matola', 'Yan Silvana', '83292929', NULL, '842713926', NULL, 1, 'naftalivo@gmail.com', '$2y$10$wxulAmCDloCL6U47EVGbLeMogkVTqamNJRmE6E8lRSHAZoKdMvVTO', 12345678, NULL, NULL, 0, NULL, 1, 3, '2022-05-26 08:30:45', '2022-05-26 15:54:23'),
	(4, 'rewsrew', 'Matola, bairro de Mapandane', 'IVORE', '849231169', 'd5c556c251b84bc0a566196d1b4de997', '849231169', NULL, 1, 'user@petromoc.tst', '$2y$10$9Z8pGqALICk41/ooU.1HGOfDKeuGYLUSUR2cXN9EiBrbZ3w17/NRa', 12345678, NULL, NULL, 0, NULL, 1, 3, '2022-05-26 15:51:07', '2022-05-26 15:51:41');

-- Dumping structure for table quatenus.users
CREATE TABLE IF NOT EXISTS `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'activo',
  `profile` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'operador',
  `session_status` int(11) NOT NULL DEFAULT 0,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`),
  UNIQUE KEY `users_phone_unique` (`phone`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table quatenus.users: ~3 rows (approximately)
INSERT INTO `users` (`id`, `name`, `last_name`, `email`, `email_verified_at`, `password`, `phone`, `status`, `profile`, `session_status`, `remember_token`, `created_at`, `updated_at`) VALUES
	(1, 'Miguel Vasco', 'Macamo', 'miguelmacamo9@gmail.com', NULL, '$2y$10$6vZrQlWcjufsACjtwceegOc.boXykhChJHWw08KOEdGlmtoFBp4h.', '845030902', 'activo', 'ADMIN', 1, NULL, '2021-10-28 15:03:00', '2022-05-26 16:23:57'),
	(2, 'João', 'Gaspar', 'joao.gaspar@paytek-africa.com', NULL, '$2y$10$DjlKzBRKuxKfp7h7/pVpHuJ2J6t9X8GhazQe4nbarJ6wVBFi8iJN6', NULL, 'activo', 'ADMIN', 1, NULL, '2021-10-29 09:00:50', '2021-10-29 10:07:06'),
	(3, 'Petromoc', 'Admin', 'user@petromoc.tst', NULL, '$2y$10$Etn6/ZCBtOYdH/mIAOh3gecv.4b6wozbrOuNn8t7jx2.jT/Yf6wMi', NULL, 'activo', 'ADMIN', 1, NULL, '2021-10-29 09:46:52', '2022-05-26 16:25:21');

