-- https://www.phpmyadmin.net/
--
-- Tempo de geração: 10-Maio-2021 às 18:31
-- Versão do servidor: 10.4.18-MariaDB
-- versão do PHP: 7.3.27

START TRANSACTION;



--
-- Banco de dados: `dashboard`
--

-- --------------------------------------------------------

--
-- Estrutura da tabela `clients`
--

CREATE TABLE `clients` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL DEFAULT 1,
  `json` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Extraindo dados da tabela `clients`
--

INSERT INTO `clients` (`id`, `user_id`, `json`, `created_at`, `updated_at`) VALUES
(1, 1, '{\"total\":\"111\",\"cpf\":\"110\",\"cnpj\":\"1\"}', NULL, NULL);

-- --------------------------------------------------------

--
-- Estrutura da tabela `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Extraindo dados da tabela `migrations`
--

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, '2021_05_06_223157_create_store_configurations_table', 2),
(4, '2016_06_01_000001_create_oauth_auth_codes_table', 3),
(5, '2016_06_01_000002_create_oauth_access_tokens_table', 3),
(6, '2016_06_01_000003_create_oauth_refresh_tokens_table', 3),
(7, '2016_06_01_000004_create_oauth_clients_table', 3),
(8, '2016_06_01_000005_create_oauth_personal_access_clients_table', 3),
(9, '2021_05_07_003334_create_products_table', 3),
(10, '2021_05_07_125157_add_url_to_users', 4),
(11, '2021_05_07_134611_add_bearer_to_users', 5),
(12, '2021_05_07_144734_create_orders_table', 6),
(14, '2021_05_07_170155_create_clients_table', 7),
(15, '2021_05_09_141005_add_user_id_to_products', 8),
(16, '2021_05_09_141920_add_user_id_to_orders', 9),
(17, '2021_05_09_141941_add_user_id_to_clients', 9);

-- --------------------------------------------------------

--
-- Estrutura da tabela `oauth_access_tokens`
--

CREATE TABLE `oauth_access_tokens` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  `client_id` int(10) UNSIGNED 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Extraindo dados da tabela `oauth_access_tokens`
--

INSERT INTO `oauth_access_tokens` (`id`, `user_id`, `client_id`, `name`, `scopes`, `revoked`, `created_at`, `updated_at`, `expires_at`) VALUES
('16d4d32b1e295fb7661855fc0bc2dbc6fb7acb46ab5a95bc05f59b464d0205111c495a8f952d2c62', 1, 1, 'Personal Access Token', '[]', 0, '2021-05-09 16:12:49', '2021-05-09 16:12:49', '2022-05-09 13:12:49'),
('20bf8a713ff3d190f2ec46a7e03f8b6931d9adf03d20e46423cc2d95b5d467d5798aeeefde994f8d', 5, 1, 'Personal Access Token', '[]', 0, '2021-05-08 15:38:25', '2021-05-08 15:38:25', '2022-05-08 12:38:25'),
('30f675e26e5ba5dc20d11a46d8ccaa7e12bb15f1158d3f7c1f3e02bb498c7925492e79d0f5135e8a', 1, 1, 'Personal Access Token', '[]', 0, '2021-05-09 16:13:15', '2021-05-09 16:13:15', '2022-05-09 13:13:15'),
('4351b4fb73b8b92e5c18eb26e7525a490ec775a409612dddda351f1ee4628d49acd17cda62c3bfeb', 1, 1, NULL, '[]', 0, '2021-05-07 16:33:42', '2021-05-07 16:33:42', '2022-05-07 13:33:42'),
('4a61e39954b4a396967ffa6b56f59ff77d74148caf59c83c0a1aa94b41218a563d38971c6861b8f5', 1, 1, 'Personal Access Token', '[]', 0, '2021-05-07 23:52:53', '2021-05-07 23:52:53', '2022-05-07 20:52:53'),
('7a2fd7beeda523841f324832704de88ad60fec1b0fd1bb607a004d69b046f9dd40d3acbcab63101a', 1, 1, 'Personal Access Token', '[]', 0, '2021-05-08 15:55:32', '2021-05-08 15:55:32', '2022-05-08 12:55:32'),
('7abee24f2c48e3d554ce414c268f9f6d98bac0b7e0a2bcabb1911c0ff6d02b58d94109c9c6dd7202', 1, 1, 'Personal Access Token', '[]', 0, '2021-05-07 23:56:32', '2021-05-07 23:56:32', '2022-05-07 20:56:32'),
('7b174381583f8abf358fc1abe4c5d3313b58a5bb7e0d0bbe84e94159f32edbfd7d8e9cc4149afee9', 3, 1, 'Personal Access Token', '[]', 0, '2021-05-08 15:34:13', '2021-05-08 15:34:13', '2022-05-08 12:34:13'),
('809e506595804f3cabd762723049207413170f3d015967e2f7b228b476e9595a6dfca3a6b65642d6', 1, 1, 'Personal Access Token', '[]', 0, '2021-05-07 23:30:50', '2021-05-07 23:30:50', '2022-05-07 20:30:50'),
('813b068764fa839edd34f8ddcefb1c5439e78dfa5e9fe3afd81329532eadabf1934be6b04e0b6fab', 1, 1, 'Personal Access Token', '[]', 0, '2021-05-07 22:25:14', '2021-05-07 22:25:14', '2022-05-07 19:25:14'),
('977dec27016d62c8e488e2f00c6938c0785b0f76f2ae439886a09830ecc3141106a7ad7703d5c561', 1, 1, 'Personal Access Token', '[]', 0, '2021-05-07 23:17:59', '2021-05-07 23:17:59', '2022-05-07 20:17:59'),
('99c4cd147430d24326f1055c4c4b714322ea00a0d17db96335d0ed6496c72cd4739e3f46abe50263', 2, 1, 'Personal Access Token', '[]', 0, '2021-05-08 15:30:52', '2021-05-08 15:30:52', '2022-05-08 12:30:52'),
('9ac59eaee2bae384750b491ff4092c5c766d4201387a0c6bc59803dab0fd45478bbec5a56ce4fa8b', 1, 1, 'Personal Access Token', '[]', 0, '2021-05-07 16:38:05', '2021-05-07 16:38:05', '2022-05-07 13:38:05'),
('a39ffb2db1c75719f9a6c9e5e26d5dbf107fe3b043bb1ab2944b29557a4a8aa304f193a37a4870a1', 1, 1, 'Personal Access Token', '[]', 0, '2021-05-08 15:45:55', '2021-05-08 15:45:55', '2022-05-08 12:45:55'),
('ca867d4518392bcaaaad28701081177f47ffc1f4136cc9f8781cec6938b125f6c0a71ae6a50837d7', 1, 1, 'Personal Access Token', '[]', 0, '2021-05-07 23:55:28', '2021-05-07 23:55:28', '2022-05-07 20:55:28'),
('cb94f043430e2130acf8c920802caa21e7582f5aeaac0f6ade784ce2350a895679ab8dcd700d307d', 4, 1, 'Personal Access Token', '[]', 0, '2021-05-08 15:35:35', '2021-05-08 15:35:35', '2022-05-08 12:35:35'),
('d152ffb4db4d4bb85ae310702ef992d7246201140aad77eccc56e61fb8bd55658fd4778287fc567b', 1, 1, 'Personal Access Token', '[]', 0, '2021-05-07 23:51:28', '2021-05-07 23:51:28', '2022-05-07 20:51:28'),
('d238ef258087a49612bea614e8d95f9add5139aae1f97232bbda9e86a176dff0de857038bf4b67bd', 1, 1, 'Personal Access Token', '[]', 0, '2021-05-07 23:49:29', '2021-05-07 23:49:29', '2022-05-07 20:49:29'),
('dd77923b92007e8146b36ad9881107e4d404b85d3c89fb82844da635a5b9300e1c71b5eb2f8469a2', 1, 1, 'Personal Access Token', '[]', 0, '2021-05-07 22:29:50', '2021-05-07 22:29:50', '2022-05-07 19:29:50'),
('ffb43b1ba808b46ebe5985ac63d4b65e95de438adc846973e8b91eaba54cd43d30e54f907f1e9d25', 1, 1, 'Personal Access Token', '[]', 0, '2021-05-07 23:54:17', '2021-05-07 23:54:17', '2022-05-07 20:54:17');

-- --------------------------------------------------------

--
-- Estrutura da tabela `oauth_auth_codes`
--

CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `client_id` int(10) UNSIGNED NOT NULL,
  `scopes` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Estrutura da tabela `oauth_clients`
--

CREATE TABLE `oauth_clients` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `secret` varchar(100) COLLATE utf8mb4_unicode_ci NOT 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Extraindo dados da tabela `oauth_clients`
--

INSERT INTO `oauth_clients` (`id`, `user_id`, `name`, `secret`, `redirect`, `personal_access_client`, `password_client`, `revoked`, `created_at`, `updated_at`) VALUES
(1, NULL, 'Laravel Personal Access Client', '2pieQN58XJaD7o1s0Ntx80KRwbk0PE3rw0WRPCo4', 'http://localhost', 1, 0, 0, '2021-05-07 15:19:11', '2021-05-07 15:19:11'),
(2, NULL, 'Laravel Password Grant Client', 'C5nG2DtoyaWZ3fk2bYhrITr1O5CdPCYe0VUn3bYv', 'http://localhost', 0, 1, 0, '2021-05-07 15:19:11', '2021-05-07 15:19:11');

-- --------------------------------------------------------

--
-- Estrutura da tabela `oauth_personal_access_clients`
--

CREATE TABLE `oauth_personal_access_clients` (
  `id` int(10) UNSIGNED NOT NULL,
  `client_id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Extraindo dados da tabela `oauth_personal_access_clients`
--

INSERT INTO `oauth_personal_access_clients` (`id`, `client_id`, `created_at`, `updated_at`) VALUES
(1, 1, '2021-05-07 15:19:11', '2021-05-07 15:19:11');

-- --------------------------------------------------------

--
-- Estrutura da tabela `oauth_refresh_tokens`
--

CREATE TABLE `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Estrutura da tabela `orders`
--

CREATE TABLE `orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL DEFAULT 1,
  `json` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Extraindo dados da tabela `orders`
--

INSERT INTO `orders` (`id`, `user_id`, `json`, `created_at`, `updated_at`) VALUES
(1, 1, '{\"total\":\"62\",\"complete\":\"5\",\"processing\":\"22\",\"pending\":\"1\",\"canceled\":\"34\",\"grand_total\":\"43900.35\",\"ticket_medio\":\"708.07\"}', NULL, '2021-05-10 02:03:00'),
(2, 1, '{\"total\":\"62\",\"complete\":\"5\",\"processing\":\"22\",\"pending\":\"1\",\"canceled\":\"34\",\"grand_total\":\"43900.35\",\"ticket_medio\":\"708.07\"}', NULL, '2021-05-10 02:03:00');

-- --------------------------------------------------------

--
-- Estrutura da tabela `password_resets`
--

CREATE TABLE `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Estrutura da tabela `products`
--

CREATE TABLE `products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL DEFAULT 1,
  `json` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Extraindo dados da tabela `products`
--

INSERT INTO `products` (`id`, `user_id`, `json`, `created_at`, `updated_at`) VALUES
(4, 1, '{\"total\":\"535\",\"active\":\"531\",\"inactive\":\"4\"}', NULL, NULL);

-- --------------------------------------------------------

--
-- Estrutura da tabela `store_configurations`
--

CREATE TABLE `store_configurations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bearer` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Extraindo dados da tabela `store_configurations`
--

INSERT INTO `store_configurations` (`id`, `user`, `password`, `url`, `bearer`, `created_at`, `updated_at`) VALUES
(1, 'origami', 'Orig@me$4dmin', 'http://homolog.origamicriacoes.com.br/lojas/lojabase', '58ylgt8hsgvdmp0gvbvdoe4kwrx6faub', NULL, NULL);

-- --------------------------------------------------------

--
-- Estrutura da tabela `users`
--

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bearer` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Extraindo dados da tabela `users`
--

INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `url`, `bearer`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'origami', 'le@le.com', NULL, 'www.musicamais.com.br', 't9o0g3kbc83b3bxrxj3j9ypvcrki1cko', '$2y$10$ac254P4hnk5NMVIYke4CxeMpvN9WBoMPrFjDOa3vkQwrjSxj8P4he', NULL, '2021-05-07 15:42:46', '2021-05-07 15:42:46'),
(5, 'origami', 'le@teste.com', NULL, 'homolog.origamicriacoes.com.br/lojas/lojabase', '0eqzp8cytsayvbzadxppn5dlwa9fb50m', '$2y$10$cLr7O4tErcUUoqq3dRscf.8sl27XNkO70osRXrhlx56twwSyGxMKW', NULL, '2021-05-08 15:38:24', '2021-05-08 15:38:24');

--
-- Índices para tabelas despejadas
--

--
-- Índices para tabela `clients`
--
ALTER TABLE `clients`
  ADD PRIMARY KEY (`id`),
  ADD KEY `clients_user_id_foreign` (`user_id`);

--
-- Índices para tabela `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Índices para tabela `oauth_access_tokens`
--
ALTER TABLE `oauth_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_access_tokens_user_id_index` (`user_id`);

--
-- Índices para tabela `oauth_auth_codes`
--
ALTER TABLE `oauth_auth_codes`
  ADD PRIMARY KEY (`id`);

--
-- Índices para tabela `oauth_clients`
--
ALTER TABLE `oauth_clients`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_clients_user_id_index` (`user_id`);

--
-- Índices para tabela `oauth_personal_access_clients`
--
ALTER TABLE `oauth_personal_access_clients`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_personal_access_clients_client_id_index` (`client_id`);

--
-- Índices para tabela `oauth_refresh_tokens`
--
ALTER TABLE `oauth_refresh_tokens`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`);

--
-- Índices para tabela `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `orders_user_id_foreign` (`user_id`);

--
-- Índices para tabela `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

--
-- Índices para tabela `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `products_user_id_foreign` (`user_id`);

--
-- Índices para tabela `store_configurations`
--
ALTER TABLE `store_configurations`
  ADD PRIMARY KEY (`id`);

--
-- Índices para tabela `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- AUTO_INCREMENT de tabelas despejadas
--

--
-- AUTO_INCREMENT de tabela `clients`
--
ALTER TABLE `clients`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de tabela `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT de tabela `oauth_clients`
--
ALTER TABLE `oauth_clients`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT de tabela `oauth_personal_access_clients`
--
ALTER TABLE `oauth_personal_access_clients`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de tabela `orders`
--
ALTER TABLE `orders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT de tabela `products`
--
ALTER TABLE `products`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT de tabela `store_configurations`
--
ALTER TABLE `store_configurations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de tabela `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- Restrições para despejos de tabelas
--

--
-- Limitadores para a tabela `clients`
--
ALTER TABLE `clients`
  ADD CONSTRAINT `clients_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Limitadores para a tabela `orders`
--
ALTER TABLE `orders`
  ADD CONSTRAINT `orders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Limitadores para a tabela `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);
COMMIT;

