WIKIPEDIA Novo Khuzela SQL.sql

File: Novo Khuzela SQL.sql
Full Path: /var/www/paytekchalenge/Novo Khuzela SQL.sql
Date Modified: 07/19/2022 7:23 PM
File size: 55.41 KB
MIME-type: text/plain
Charset: utf-8
Delete Open Edit Advanced Editor Back
-- phpMyAdmin SQL Dump
-- version 4.8.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: 30-Jul-2020 às 12:19
-- Versão do servidor: 10.1.33-MariaDB
-- PHP Version: 7.2.6

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `khuzela`
--

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

--
-- Estrutura da tabela `categories`
--

CREATE TABLE `categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cody` varchar(2) 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;

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

--
-- Estrutura da tabela `cities`
--

CREATE TABLE `cities` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) 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 `cities`
--

INSERT INTO `cities` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Maputo Cidade', '2020-07-30 07:23:32', '2020-07-30 07:23:32'),
(2, 'Maputo Provincia', '2020-07-30 07:23:32', '2020-07-30 07:23:32'),
(3, 'Gaza', '2020-07-30 07:23:32', '2020-07-30 07:23:32'),
(4, 'Inhambane', '2020-07-30 07:23:32', '2020-07-30 07:23:32'),
(5, 'Sofala', '2020-07-30 07:23:32', '2020-07-30 07:23:32'),
(6, 'Nampula', '2020-07-30 07:23:32', '2020-07-30 07:23:32'),
(7, 'Tete', '2020-07-30 07:23:32', '2020-07-30 07:23:32'),
(8, 'Zambézia', '2020-07-30 07:23:32', '2020-07-30 07:23:32'),
(9, 'Sofala', '2020-07-30 07:23:32', '2020-07-30 07:23:32'),
(10, 'Cabo Delgado', '2020-07-30 07:23:32', '2020-07-30 07:23:32'),
(11, 'Quelimane', '2020-07-30 07:23:32', '2020-07-30 07:23:32'),
(12, 'Maputo Cidade', '2020-07-30 07:24:15', '2020-07-30 07:24:15'),
(13, 'Maputo Provincia', '2020-07-30 07:24:15', '2020-07-30 07:24:15'),
(14, 'Gaza', '2020-07-30 07:24:15', '2020-07-30 07:24:15'),
(15, 'Inhambane', '2020-07-30 07:24:15', '2020-07-30 07:24:15'),
(16, 'Sofala', '2020-07-30 07:24:15', '2020-07-30 07:24:15'),
(17, 'Nampula', '2020-07-30 07:24:15', '2020-07-30 07:24:15'),
(18, 'Tete', '2020-07-30 07:24:15', '2020-07-30 07:24:15'),
(19, 'Zambézia', '2020-07-30 07:24:15', '2020-07-30 07:24:15'),
(20, 'Sofala', '2020-07-30 07:24:15', '2020-07-30 07:24:15'),
(21, 'Cabo Delgado', '2020-07-30 07:24:15', '2020-07-30 07:24:15'),
(22, 'Quelimane', '2020-07-30 07:24:15', '2020-07-30 07:24:15');

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

--
-- Estrutura da tabela `clubs`
--

CREATE TABLE `clubs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nuit` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `color` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `picture` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `responsible_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `responsible_phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `responsible_email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `users_id` int(10) UNSIGNED NOT NULL,
  `cities_id` bigint(20) 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 `clubs`
--

INSERT INTO `clubs` (`id`, `name`, `email`, `phone`, `address`, `nuit`, `color`, `picture`, `responsible_name`, `responsible_phone`, `responsible_email`, `users_id`, `cities_id`, `created_at`, `updated_at`) VALUES
(1, 'ClubeX', 'clube@email.com', '849231169', 'Av. de Moçambique, Maputo', '362531233', '#b50000', 'http://localhost:8000/storage/club/1596101528imageedit_11_6024129081.png', 'Nome', NULL, NULL, 1, 2, '2020-07-30 07:32:08', '2020-07-30 07:32:08');

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

--
-- Estrutura da tabela `colors`
--

CREATE TABLE `colors` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cody` varchar(191) 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 `colors`
--

INSERT INTO `colors` (`id`, `description`, `cody`, `created_at`, `updated_at`) VALUES
(1, 'cor 01', '01', '2020-07-30 07:30:32', '2020-07-30 07:30:32'),
(2, 'cor 02', '02', '2020-07-30 07:30:37', '2020-07-30 07:30:37'),
(3, 'cor 03', '03', '2020-07-30 07:30:42', '2020-07-30 07:30:42'),
(4, 'cor 04', '04', '2020-07-30 07:30:46', '2020-07-30 07:30:46'),
(5, 'cor 05', '05', '2020-07-30 07:30:51', '2020-07-30 07:30:51');

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

--
-- Estrutura da tabela `compras`
--

CREATE TABLE `compras` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `codigo_compra` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantTotal` int(11) NOT NULL,
  `precoTotal` int(11) NOT NULL,
  `meios_pagamentos_id` bigint(20) UNSIGNED NOT NULL,
  `statuses_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura da tabela `documents`
--

CREATE TABLE `documents` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) 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 `documents`
--

INSERT INTO `documents` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'BI', NULL, NULL),
(2, 'Passaporte', NULL, NULL),
(3, 'Carta de Condução', NULL, NULL),
(4, 'NUIT', NULL, NULL),
(5, 'DIR', NULL, NULL),
(6, 'Cédula Pessoal', NULL, NULL),
(7, 'Cartão de Eleitor', NULL, NULL);

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

--
-- Estrutura da tabela `estados`
--

CREATE TABLE `estados` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) 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 `estados`
--

INSERT INTO `estados` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Activo', '2020-07-30 07:48:49', '2020-07-30 07:48:49'),
(2, 'Suspenso', '2020-07-30 07:48:49', '2020-07-30 07:48:49');

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

--
-- Estrutura da tabela `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura da tabela `images`
--

CREATE TABLE `images` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `url` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `products_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 `images`
--

INSERT INTO `images` (`id`, `url`, `products_id`, `created_at`, `updated_at`) VALUES
(1, 'http://localhost:8000/storage/storage/productsKhuzela/1596101754Copy of youtube chartart (1).png', 1, '2020-07-30 07:35:54', '2020-07-30 07:35:54'),
(2, 'http://localhost:8000/storage/storage/productsKhuzela/1596101754Copy of youtube chartart.png', 1, '2020-07-30 07:35:55', '2020-07-30 07:35:55'),
(3, 'http://localhost:8000/storage/storage/productsKhuzela/1596101754Rufus Plays Jazz.png', 1, '2020-07-30 07:35:55', '2020-07-30 07:35:55'),
(4, 'http://localhost:8000/storage/storage/productsKhuzela/1596101895Imagem2.jpg', 2, '2020-07-30 07:38:15', '2020-07-30 07:38:15'),
(5, 'http://localhost:8000/storage/storage/productsKhuzela/1596102375Copy of youtube chartart (1).png', 3, '2020-07-30 07:46:15', '2020-07-30 07:46:15'),
(6, 'http://localhost:8000/storage/storage/productsKhuzela/1596102375Rufus Plays Jazz.png', 3, '2020-07-30 07:46:15', '2020-07-30 07:46:15'),
(7, 'http://localhost:8000/storage/storage/productsKhuzela/1596102375Rufus Plays Jazz2.png', 3, '2020-07-30 07:46:15', '2020-07-30 07:46:15'),
(8, 'http://localhost:8000/storage/storage/productsKhuzela/1596102897Rodrigues Mafumo (1).png', 4, '2020-07-30 07:54:57', '2020-07-30 07:54:57'),
(9, 'http://localhost:8000/storage/storage/productsKhuzela/1596102897Rodrigues Mafumo (2).png', 4, '2020-07-30 07:54:57', '2020-07-30 07:54:57'),
(10, 'http://localhost:8000/storage/storage/productsKhuzela/1596102897Rodrigues Mafumo.png', 4, '2020-07-30 07:54:57', '2020-07-30 07:54:57');

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

--
-- Estrutura da tabela `item_compras`
--

CREATE TABLE `item_compras` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `quantidade` int(11) NOT NULL,
  `price` int(11) NOT NULL,
  `products_id` bigint(20) UNSIGNED NOT NULL,
  `compras_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura da tabela `meios_pagamentos`
--

CREATE TABLE `meios_pagamentos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) 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;

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

--
-- Estrutura da tabela `members`
--

CREATE TABLE `members` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `member_number` bigint(20) NOT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` bigint(20) NOT NULL,
  `photo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `document_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quotas_id` int(10) UNSIGNED NOT NULL,
  `code` int(11) DEFAULT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `member_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `documents_id` bigint(20) UNSIGNED NOT NULL,
  `clubs_id` bigint(20) UNSIGNED NOT NULL,
  `cities_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura da tabela `member_clubs`
--

CREATE TABLE `member_clubs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nr_quotas_em_divida` bigint(20) DEFAULT NULL,
  `next_payment_date` date DEFAULT NULL,
  `members_id` bigint(20) UNSIGNED NOT NULL,
  `clubs_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(191) 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
(85, '2014_02_12_000000_create_documents_table', 1),
(86, '2014_10_12_000000_create_users_table', 1),
(87, '2014_10_12_100000_create_password_resets_table', 1),
(88, '2016_06_01_000001_create_oauth_auth_codes_table', 1),
(89, '2016_06_01_000002_create_oauth_access_tokens_table', 1),
(90, '2016_06_01_000003_create_oauth_refresh_tokens_table', 1),
(91, '2016_06_01_000004_create_oauth_clients_table', 1),
(92, '2016_06_01_000005_create_oauth_personal_access_clients_table', 1),
(93, '2019_08_19_000000_create_failed_jobs_table', 1),
(94, '2019_09_25_182323_create_roles_table', 1),
(95, '2019_09_25_183138_create_role_user_table', 1),
(96, '2020_04_30_150270_create_categories_table', 1),
(97, '2020_04_30_150301_create_subcategorias_table', 1),
(98, '2020_04_30_150360_create_colors_table', 1),
(99, '2020_05_09_222554_create_cities_table', 1),
(100, '2020_05_09_222573_create_estados_table', 1),
(101, '2020_05_09_222600_create_percentagems_table', 1),
(102, '2020_05_09_222648_create_clubs_table', 1),
(103, '2020_05_09_222854_create_quotas_table', 1),
(104, '2020_05_09_222932_create_members_table', 1),
(105, '2020_05_09_223009_create_member_clubs_table', 1),
(106, '2020_05_09_223134_create_partners_table', 1),
(107, '2020_05_09_223160_create_meios_pagamentos_table', 1),
(108, '2020_05_09_223180_create_tamanhos_table', 1),
(109, '2020_05_09_223230_create_producto_categorias_table', 1),
(110, '2020_05_09_223360_create_producto_subcategorias_table', 1),
(111, '2020_05_09_223442_create_services_table', 1),
(112, '2020_05_09_223500_create_statuses_table', 1),
(113, '2020_05_09_223516_create_products_table', 1),
(114, '2020_05_09_223533_create_compras_table', 1),
(115, '2020_05_22_110712_create_partner_clubs_table', 1),
(116, '2020_05_22_110720_create_service_clubs_table', 1),
(117, '2020_05_26_15452_create_images_table', 1),
(118, '2020_05_28_084059_create_posts_table', 1),
(119, '2020_06_02_043936_create_periods_table', 1),
(120, '2020_06_11_045954_create_post_khuzelas_table', 1),
(121, '2020_06_24_154927_create_product_colors_table', 1),
(122, '2020_06_28_193359_add_soft_deletes_to_post_khuzela_table', 1),
(123, '2020_07_01_220301_create_product_items_table', 1),
(124, '2020_07_01_221917_create_product_item_images_table', 1),
(125, '2020_07_07_095030_create_stocks_table', 1),
(126, '2020_07_07_162317_create_item_compras_table', 1);

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

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

CREATE TABLE `oauth_access_tokens` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `client_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `scopes` text COLLATE utf8mb4_unicode_ci,
  `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
('6ccc1a4de15420ca8d4199e0c9e834795c106f4f431020dad1c23ea78eb00450743e411fed9bf89a', 1, 2, NULL, '[]', 0, '2020-07-30 07:26:07', '2020-07-30 07:26:07', '2020-07-30 11:06:07');

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

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

CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `client_id` bigint(20) UNSIGNED NOT NULL,
  `scopes` text COLLATE utf8mb4_unicode_ci,
  `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` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `secret` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `provider` varchar(191) 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `oauth_clients` (`id`, `user_id`, `name`, `secret`, `provider`, `redirect`, `personal_access_client`, `password_client`, `revoked`, `created_at`, `updated_at`) VALUES
(1, NULL, 'Laravel Personal Access Client', 'AzSkBjY6ho2CtZzs5vuTC4S5dSDvJFBcNO8OCSdW', NULL, 'http://localhost', 1, 0, 0, '2020-07-30 07:25:31', '2020-07-30 07:25:31'),
(2, NULL, 'Laravel Password Grant Client', 'GRC5k4Siublff68GZqnbwMET0R9CS71uOEUWMDjD', 'users', 'http://localhost', 0, 1, 0, '2020-07-30 07:25:32', '2020-07-30 07:25:32');

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

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

CREATE TABLE `oauth_personal_access_clients` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `client_id` bigint(20) 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, '2020-07-30 07:25:32', '2020-07-30 07:25:32');

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

--
-- 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;

--
-- Extraindo dados da tabela `oauth_refresh_tokens`
--

INSERT INTO `oauth_refresh_tokens` (`id`, `access_token_id`, `revoked`, `expires_at`) VALUES
('7217b66ff44e296ba7f5d5f3421f165748520e41149aa3ddd703f292417c2de7baa8d12fcb459fdf', '6ccc1a4de15420ca8d4199e0c9e834795c106f4f431020dad1c23ea78eb00450743e411fed9bf89a', 0, '2020-08-29 09:26:07');

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

--
-- Estrutura da tabela `partners`
--

CREATE TABLE `partners` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `partner_description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` bigint(20) NOT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nuit` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `picture` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `responsible_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `responsible_phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `responsible_email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cities_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura da tabela `partner_clubs`
--

CREATE TABLE `partner_clubs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `destription` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `clubs_id` bigint(20) UNSIGNED NOT NULL,
  `partners_id` bigint(20) UNSIGNED NOT NULL,
  `users_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;

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

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

CREATE TABLE `password_resets` (
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura da tabela `percentagems`
--

CREATE TABLE `percentagems` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) 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 `percentagems`
--

INSERT INTO `percentagems` (`id`, `name`, `description`, `created_at`, `updated_at`) VALUES
(1, 'MZN', 'Valor - MZN', NULL, NULL),
(3, '%', 'Percentagem - %', NULL, NULL);

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

--
-- Estrutura da tabela `periods`
--

CREATE TABLE `periods` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) 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 `periods`
--

INSERT INTO `periods` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Mensal', '2020-07-30 07:48:49', '2020-07-30 07:48:49'),
(2, 'Trimestral', '2020-07-30 07:48:49', '2020-07-30 07:48:49'),
(3, 'Semestral', '2020-07-30 07:48:50', '2020-07-30 07:48:50'),
(4, 'Anual', '2020-07-30 07:48:50', '2020-07-30 07:48:50');

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

--
-- Estrutura da tabela `posts`
--

CREATE TABLE `posts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `photo` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `source` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `estados_id` int(10) UNSIGNED NOT NULL,
  `users_id` int(10) UNSIGNED NOT NULL,
  `clubs_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura da tabela `post_khuzelas`
--

CREATE TABLE `post_khuzelas` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `photo` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `estados_id` int(10) UNSIGNED NOT NULL,
  `origin` int(11) NOT NULL,
  `clubs_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Extraindo dados da tabela `post_khuzelas`
--

INSERT INTO `post_khuzelas` (`id`, `title`, `description`, `photo`, `estados_id`, `origin`, `clubs_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Novo Titulo', 'vdmsn&#160;', 'http://localhost:8000/storage/postsKhuzela/1596103053Rodrigues Mafumo (2).png', 1, 0, 1, '2020-07-30 07:57:33', '2020-07-30 07:57:55', NULL);

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

--
-- Estrutura da tabela `producto_categorias`
--

CREATE TABLE `producto_categorias` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cody` varchar(191) 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 `producto_categorias`
--

INSERT INTO `producto_categorias` (`id`, `name`, `cody`, `created_at`, `updated_at`) VALUES
(1, 'Categoria 01', '01', '2020-07-30 07:26:31', '2020-07-30 07:26:31'),
(2, 'Categoria 02', '02', '2020-07-30 07:26:36', '2020-07-30 07:26:36'),
(3, 'Categoria 03', '03', '2020-07-30 07:26:41', '2020-07-30 07:26:41'),
(4, 'Categoria 04', '04', '2020-07-30 07:26:45', '2020-07-30 07:26:45'),
(5, 'Categoria 05', '05', '2020-07-30 07:26:50', '2020-07-30 07:26:50'),
(6, 'Categoria 06', '06', '2020-07-30 07:26:54', '2020-07-30 07:26:54'),
(7, 'Categoria 07', '07', '2020-07-30 07:26:59', '2020-07-30 07:26:59'),
(8, 'Categoria 08', '08', '2020-07-30 07:27:04', '2020-07-30 07:27:04'),
(9, 'Categoria 09', '09', '2020-07-30 07:27:09', '2020-07-30 07:27:09'),
(10, 'Categoria 10', '10', '2020-07-30 07:27:13', '2020-07-30 07:27:13'),
(11, 'Categoria 11', '11', '2020-07-30 07:27:22', '2020-07-30 07:27:22');

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

--
-- Estrutura da tabela `producto_subcategorias`
--

CREATE TABLE `producto_subcategorias` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cody` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `producto_categorias_id` bigint(20) 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 `producto_subcategorias`
--

INSERT INTO `producto_subcategorias` (`id`, `name`, `cody`, `producto_categorias_id`, `created_at`, `updated_at`) VALUES
(1, 'Subcategoria 01', '01', 1, '2020-07-30 07:27:51', '2020-07-30 07:27:51'),
(2, 'Subcategoria 02', '02', 1, '2020-07-30 07:27:57', '2020-07-30 07:27:57'),
(3, 'Subcategoria 03', '03', 2, '2020-07-30 07:28:02', '2020-07-30 07:28:02'),
(4, 'Subcategoria 04', '04', 2, '2020-07-30 07:28:09', '2020-07-30 07:28:09'),
(5, 'Subcategoria 05', '05', 3, '2020-07-30 07:28:15', '2020-07-30 07:28:15'),
(6, 'Subcategoria 06', '06', 3, '2020-07-30 07:28:20', '2020-07-30 07:28:20'),
(7, 'Subcategoria 07', '07', 4, '2020-07-30 07:28:27', '2020-07-30 07:28:27'),
(8, 'Subcategoria 08', '08', 4, '2020-07-30 07:28:35', '2020-07-30 07:28:35'),
(9, 'Subcategoria 09', '09', 5, '2020-07-30 07:28:43', '2020-07-30 07:28:43'),
(10, 'Subcategoria 10', '10', 5, '2020-07-30 07:28:50', '2020-07-30 07:28:50'),
(11, 'Subcategoria 11', '11', 6, '2020-07-30 07:28:57', '2020-07-30 07:28:57'),
(12, 'Subcategoria 12', '12', 6, '2020-07-30 07:29:04', '2020-07-30 07:29:04');

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

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

CREATE TABLE `products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantMin` int(11) NOT NULL,
  `quantity` int(11) NOT NULL,
  `price` int(11) NOT NULL,
  `product_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `statuses_id` int(10) UNSIGNED NOT NULL,
  `clubs_id` bigint(20) UNSIGNED NOT NULL,
  `colors_id` int(10) UNSIGNED NOT NULL,
  `tamanhos_id` int(10) UNSIGNED NOT NULL,
  `subcategorias_id` bigint(20) 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 `products`
--

INSERT INTO `products` (`id`, `title`, `description`, `quantMin`, `quantity`, `price`, `product_code`, `statuses_id`, `clubs_id`, `colors_id`, `tamanhos_id`, `subcategorias_id`, `created_at`, `updated_at`) VALUES
(3, 'ProdutoXY', 'dhvdhvasdksabd', 100, 2000, 10, '04.07.01.01.0001', 1, 1, 1, 1, 7, '2020-07-30 07:46:15', '2020-07-30 07:46:15'),
(4, 'ProdutoXY', 'djh,sagudksbadsa', 10, 200, 200, '03.05.01.03.0004', 1, 1, 3, 1, 5, '2020-07-30 07:54:57', '2020-07-30 07:54:57');

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

--
-- Estrutura da tabela `product_colors`
--

CREATE TABLE `product_colors` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `colors_id` int(10) UNSIGNED NOT NULL,
  `products_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura da tabela `product_items`
--

CREATE TABLE `product_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `product_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `quant_min` int(11) NOT NULL,
  `quant_total` int(11) NOT NULL,
  `price` int(11) NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color_id` int(10) UNSIGNED DEFAULT NULL,
  `product_id` int(10) UNSIGNED NOT NULL,
  `size_id` int(10) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura da tabela `product_item_images`
--

CREATE TABLE `product_item_images` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_item_id` int(10) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura da tabela `quotas`
--

CREATE TABLE `quotas` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `quota_description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quota_value` bigint(20) NOT NULL,
  `payment_date` int(11) NOT NULL,
  `periods_id` int(10) UNSIGNED NOT NULL,
  `clubs_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura da tabela `roles`
--

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) 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 `roles`
--

INSERT INTO `roles` (`id`, `name`, `description`, `created_at`, `updated_at`) VALUES
(1, 'admin', 'Administrador Khuzela', '2020-07-30 07:24:35', '2020-07-30 07:24:35'),
(2, 'manager', 'Administrador Clube', '2020-07-30 07:24:35', '2020-07-30 07:24:35'),
(3, 'user', 'Utilizador Khuzela', '2020-07-30 07:24:35', '2020-07-30 07:24:35'),
(4, 'userClube', 'Utilizador Clube', '2020-07-30 07:24:35', '2020-07-30 07:24:35');

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

--
-- Estrutura da tabela `role_user`
--

CREATE TABLE `role_user` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `role_id` int(10) UNSIGNED NOT NULL,
  `user_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 `role_user`
--

INSERT INTO `role_user` (`id`, `role_id`, `user_id`, `created_at`, `updated_at`) VALUES
(1, 1, 1, NULL, NULL),
(2, 2, 2, NULL, NULL),
(3, 3, 3, NULL, NULL),
(4, 4, 4, NULL, NULL),
(5, 1, 1, NULL, NULL),
(6, 2, 2, NULL, NULL),
(7, 3, 3, NULL, NULL),
(8, 4, 4, NULL, NULL),
(9, 1, 1, NULL, NULL),
(10, 2, 2, NULL, NULL),
(11, 3, 3, NULL, NULL),
(12, 4, 4, NULL, NULL);

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

--
-- Estrutura da tabela `services`
--

CREATE TABLE `services` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `khuzelaBonus` int(11) NOT NULL,
  `clubBonus` int(11) NOT NULL,
  `partnerBonus` int(11) NOT NULL,
  `partners_id` bigint(20) UNSIGNED NOT NULL,
  `percentagems_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;

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

--
-- Estrutura da tabela `service_clubs`
--

CREATE TABLE `service_clubs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `destription` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `clubs_id` bigint(20) UNSIGNED NOT NULL,
  `services_id` bigint(20) UNSIGNED NOT NULL,
  `users_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;

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

--
-- Estrutura da tabela `statuses`
--

CREATE TABLE `statuses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) 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 `statuses`
--

INSERT INTO `statuses` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Disponivel', NULL, NULL),
(2, 'Indisponivel', NULL, NULL),
(3, 'Por Esgotar', NULL, NULL),
(4, 'Completa', NULL, NULL),
(5, 'Cancelada', NULL, NULL),
(6, 'Pendente', NULL, NULL);

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

--
-- Estrutura da tabela `stocks`
--

CREATE TABLE `stocks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `quantMin` int(11) NOT NULL,
  `quantity` int(11) NOT NULL,
  `products_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura da tabela `subcategorias`
--

CREATE TABLE `subcategorias` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cody` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `categories_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estrutura da tabela `tamanhos`
--

CREATE TABLE `tamanhos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `size` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cody` varchar(191) 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 `tamanhos`
--

INSERT INTO `tamanhos` (`id`, `size`, `description`, `cody`, `created_at`, `updated_at`) VALUES
(1, 'X', 'X - Tamanho X', '01', '2020-07-30 07:29:52', '2020-07-30 07:29:52'),
(2, 'S', 'S-Tamaho S', '02', '2020-07-30 07:30:05', '2020-07-30 07:30:05');

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

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

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nuit` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bi` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `picture` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `responsible_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `responsible_phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `clubs_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT 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`, `password`, `phone`, `address`, `nuit`, `bi`, `picture`, `responsible_name`, `responsible_phone`, `clubs_id`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'Khuzela', 'khuzela@khuzela.com', NULL, '$2y$10$EZRltBgE4BtPh81JWJHoqOGi5K1I7FlAxkIm7pPKboUuO5WwjAwfe', '841000006', 'Khuzela Sede', '100000006', '1005515050517', 'http://localhost:8000/storage/khuzela/1596103213Rodrigues Mafumo (3).png', 'Khuzela', '841000023', '10', NULL, '2020-07-30 07:24:35', '2020-07-30 08:00:13'),
(2, 'Manager', 'manager@manager.com', NULL, '$2y$10$g1webVAID0bCaQfuGAXZN.skno4X2WeN88hwxGc3Rl1LbR8vuWaqi', '841000002', 'Coop - Rua da Franca', '100000002', '1100524933300', 'http://localhost:8000/storage/khuzela/1596103633photo3.png', 'Admin Clube', '841000002', '1', NULL, '2020-07-30 07:24:35', '2020-07-30 08:07:13'),
(3, 'User Khuzela', 'userk@userk.com', NULL, '$2y$10$QgUw85XXFRuB9cHxFmcNZuTPJ5akO3T/wAT.APHR15pydvdv/3vhG', '841000102200000', 'Maputo', '110215154', '110155448498v', '/storage/khuzela/1592307222Cover.png', 'User Khuzela', '841000102200000', '7', NULL, '2020-07-30 07:24:35', '2020-07-30 07:24:35'),
(4, 'User Clube', 'user@user.com', NULL, '$2y$10$44RdI.DhxZr7kI3YWvGui.iCfdHKj8SuGJ4wON8xAK/cqEA84uy62', '841000255533333', 'Maputo', '110022258', '110022255555c', '/storage/khuzela/1592307222Cover.png', 'User Clube', '841000255533333', '10', NULL, '2020-07-30 07:24:35', '2020-07-30 07:24:35');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cities`
--
ALTER TABLE `cities`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `clubs`
--
ALTER TABLE `clubs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `clubs_email_unique` (`email`),
  ADD KEY `clubs_cities_id_foreign` (`cities_id`);

--
-- Indexes for table `colors`
--
ALTER TABLE `colors`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `compras`
--
ALTER TABLE `compras`
  ADD PRIMARY KEY (`id`),
  ADD KEY `compras_meios_pagamentos_id_foreign` (`meios_pagamentos_id`),
  ADD KEY `compras_statuses_id_foreign` (`statuses_id`);

--
-- Indexes for table `documents`
--
ALTER TABLE `documents`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `estados`
--
ALTER TABLE `estados`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `images`
--
ALTER TABLE `images`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `item_compras`
--
ALTER TABLE `item_compras`
  ADD PRIMARY KEY (`id`),
  ADD KEY `item_compras_products_id_foreign` (`products_id`),
  ADD KEY `item_compras_compras_id_foreign` (`compras_id`);

--
-- Indexes for table `meios_pagamentos`
--
ALTER TABLE `meios_pagamentos`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `members`
--
ALTER TABLE `members`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `members_email_unique` (`email`),
  ADD KEY `members_documents_id_foreign` (`documents_id`),
  ADD KEY `members_clubs_id_foreign` (`clubs_id`),
  ADD KEY `members_cities_id_foreign` (`cities_id`);

--
-- Indexes for table `member_clubs`
--
ALTER TABLE `member_clubs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `member_clubs_members_id_foreign` (`members_id`),
  ADD KEY `member_clubs_clubs_id_foreign` (`clubs_id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `oauth_access_tokens`
--
ALTER TABLE `oauth_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_access_tokens_user_id_index` (`user_id`);

--
-- Indexes for table `oauth_auth_codes`
--
ALTER TABLE `oauth_auth_codes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_auth_codes_user_id_index` (`user_id`);

--
-- Indexes for table `oauth_clients`
--
ALTER TABLE `oauth_clients`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_clients_user_id_index` (`user_id`);

--
-- Indexes for table `oauth_personal_access_clients`
--
ALTER TABLE `oauth_personal_access_clients`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `oauth_refresh_tokens`
--
ALTER TABLE `oauth_refresh_tokens`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`);

--
-- Indexes for table `partners`
--
ALTER TABLE `partners`
  ADD PRIMARY KEY (`id`),
  ADD KEY `partners_cities_id_foreign` (`cities_id`);

--
-- Indexes for table `partner_clubs`
--
ALTER TABLE `partner_clubs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `partner_clubs_clubs_id_foreign` (`clubs_id`),
  ADD KEY `partner_clubs_partners_id_foreign` (`partners_id`);

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

--
-- Indexes for table `percentagems`
--
ALTER TABLE `percentagems`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `periods`
--
ALTER TABLE `periods`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `posts`
--
ALTER TABLE `posts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `posts_clubs_id_foreign` (`clubs_id`);

--
-- Indexes for table `post_khuzelas`
--
ALTER TABLE `post_khuzelas`
  ADD PRIMARY KEY (`id`),
  ADD KEY `post_khuzelas_clubs_id_foreign` (`clubs_id`);

--
-- Indexes for table `producto_categorias`
--
ALTER TABLE `producto_categorias`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `producto_subcategorias`
--
ALTER TABLE `producto_subcategorias`
  ADD PRIMARY KEY (`id`),
  ADD KEY `producto_subcategorias_producto_categorias_id_foreign` (`producto_categorias_id`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `products_clubs_id_foreign` (`clubs_id`),
  ADD KEY `products_subcategorias_id_foreign` (`subcategorias_id`);

--
-- Indexes for table `product_colors`
--
ALTER TABLE `product_colors`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_colors_products_id_foreign` (`products_id`);

--
-- Indexes for table `product_items`
--
ALTER TABLE `product_items`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `product_item_images`
--
ALTER TABLE `product_item_images`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `quotas`
--
ALTER TABLE `quotas`
  ADD PRIMARY KEY (`id`),
  ADD KEY `quotas_clubs_id_foreign` (`clubs_id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `role_user`
--
ALTER TABLE `role_user`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `services`
--
ALTER TABLE `services`
  ADD PRIMARY KEY (`id`),
  ADD KEY `services_partners_id_foreign` (`partners_id`);

--
-- Indexes for table `service_clubs`
--
ALTER TABLE `service_clubs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `service_clubs_clubs_id_foreign` (`clubs_id`),
  ADD KEY `service_clubs_services_id_foreign` (`services_id`);

--
-- Indexes for table `statuses`
--
ALTER TABLE `statuses`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `stocks`
--
ALTER TABLE `stocks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `stocks_products_id_foreign` (`products_id`);

--
-- Indexes for table `subcategorias`
--
ALTER TABLE `subcategorias`
  ADD PRIMARY KEY (`id`),
  ADD KEY `subcategorias_categories_id_foreign` (`categories_id`);

--
-- Indexes for table `tamanhos`
--
ALTER TABLE `tamanhos`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cities`
--
ALTER TABLE `cities`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `clubs`
--
ALTER TABLE `clubs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `colors`
--
ALTER TABLE `colors`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `compras`
--
ALTER TABLE `compras`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `documents`
--
ALTER TABLE `documents`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `estados`
--
ALTER TABLE `estados`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `images`
--
ALTER TABLE `images`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `item_compras`
--
ALTER TABLE `item_compras`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `meios_pagamentos`
--
ALTER TABLE `meios_pagamentos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `members`
--
ALTER TABLE `members`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `member_clubs`
--
ALTER TABLE `member_clubs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=127;

--
-- AUTO_INCREMENT for table `oauth_clients`
--
ALTER TABLE `oauth_clients`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `oauth_personal_access_clients`
--
ALTER TABLE `oauth_personal_access_clients`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `partners`
--
ALTER TABLE `partners`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `partner_clubs`
--
ALTER TABLE `partner_clubs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `percentagems`
--
ALTER TABLE `percentagems`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `periods`
--
ALTER TABLE `periods`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `posts`
--
ALTER TABLE `posts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `post_khuzelas`
--
ALTER TABLE `post_khuzelas`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `producto_categorias`
--
ALTER TABLE `producto_categorias`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `producto_subcategorias`
--
ALTER TABLE `producto_subcategorias`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

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

--
-- AUTO_INCREMENT for table `product_colors`
--
ALTER TABLE `product_colors`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_items`
--
ALTER TABLE `product_items`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_item_images`
--
ALTER TABLE `product_item_images`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `quotas`
--
ALTER TABLE `quotas`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `role_user`
--
ALTER TABLE `role_user`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `service_clubs`
--
ALTER TABLE `service_clubs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `statuses`
--
ALTER TABLE `statuses`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `stocks`
--
ALTER TABLE `stocks`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `subcategorias`
--
ALTER TABLE `subcategorias`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tamanhos`
--
ALTER TABLE `tamanhos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- Constraints for dumped tables
--

--
-- Limitadores para a tabela `clubs`
--
ALTER TABLE `clubs`
  ADD CONSTRAINT `clubs_cities_id_foreign` FOREIGN KEY (`cities_id`) REFERENCES `cities` (`id`) ON DELETE NO ACTION;

--
-- Limitadores para a tabela `compras`
--
ALTER TABLE `compras`
  ADD CONSTRAINT `compras_meios_pagamentos_id_foreign` FOREIGN KEY (`meios_pagamentos_id`) REFERENCES `meios_pagamentos` (`id`) ON DELETE NO ACTION,
  ADD CONSTRAINT `compras_statuses_id_foreign` FOREIGN KEY (`statuses_id`) REFERENCES `statuses` (`id`) ON DELETE NO ACTION;

--
-- Limitadores para a tabela `item_compras`
--
ALTER TABLE `item_compras`
  ADD CONSTRAINT `item_compras_compras_id_foreign` FOREIGN KEY (`compras_id`) REFERENCES `compras` (`id`) ON DELETE NO ACTION,
  ADD CONSTRAINT `item_compras_products_id_foreign` FOREIGN KEY (`products_id`) REFERENCES `products` (`id`) ON DELETE NO ACTION;

--
-- Limitadores para a tabela `members`
--
ALTER TABLE `members`
  ADD CONSTRAINT `members_cities_id_foreign` FOREIGN KEY (`cities_id`) REFERENCES `cities` (`id`) ON DELETE NO ACTION,
  ADD CONSTRAINT `members_clubs_id_foreign` FOREIGN KEY (`clubs_id`) REFERENCES `clubs` (`id`) ON DELETE NO ACTION,
  ADD CONSTRAINT `members_documents_id_foreign` FOREIGN KEY (`documents_id`) REFERENCES `documents` (`id`) ON DELETE NO ACTION;

--
-- Limitadores para a tabela `member_clubs`
--
ALTER TABLE `member_clubs`
  ADD CONSTRAINT `member_clubs_clubs_id_foreign` FOREIGN KEY (`clubs_id`) REFERENCES `clubs` (`id`) ON DELETE NO ACTION,
  ADD CONSTRAINT `member_clubs_members_id_foreign` FOREIGN KEY (`members_id`) REFERENCES `members` (`id`) ON DELETE NO ACTION;

--
-- Limitadores para a tabela `partners`
--
ALTER TABLE `partners`
  ADD CONSTRAINT `partners_cities_id_foreign` FOREIGN KEY (`cities_id`) REFERENCES `cities` (`id`) ON DELETE NO ACTION;

--
-- Limitadores para a tabela `partner_clubs`
--
ALTER TABLE `partner_clubs`
  ADD CONSTRAINT `partner_clubs_clubs_id_foreign` FOREIGN KEY (`clubs_id`) REFERENCES `clubs` (`id`) ON DELETE NO ACTION,
  ADD CONSTRAINT `partner_clubs_partners_id_foreign` FOREIGN KEY (`partners_id`) REFERENCES `partners` (`id`) ON DELETE NO ACTION;

--
-- Limitadores para a tabela `posts`
--
ALTER TABLE `posts`
  ADD CONSTRAINT `posts_clubs_id_foreign` FOREIGN KEY (`clubs_id`) REFERENCES `clubs` (`id`) ON DELETE NO ACTION;

--
-- Limitadores para a tabela `post_khuzelas`
--
ALTER TABLE `post_khuzelas`
  ADD CONSTRAINT `post_khuzelas_clubs_id_foreign` FOREIGN KEY (`clubs_id`) REFERENCES `clubs` (`id`) ON DELETE NO ACTION;

--
-- Limitadores para a tabela `producto_subcategorias`
--
ALTER TABLE `producto_subcategorias`
  ADD CONSTRAINT `producto_subcategorias_producto_categorias_id_foreign` FOREIGN KEY (`producto_categorias_id`) REFERENCES `producto_categorias` (`id`) ON DELETE NO ACTION;

--
-- Limitadores para a tabela `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_clubs_id_foreign` FOREIGN KEY (`clubs_id`) REFERENCES `clubs` (`id`) ON DELETE NO ACTION,
  ADD CONSTRAINT `products_subcategorias_id_foreign` FOREIGN KEY (`subcategorias_id`) REFERENCES `producto_subcategorias` (`id`) ON DELETE NO ACTION;

--
-- Limitadores para a tabela `product_colors`
--
ALTER TABLE `product_colors`
  ADD CONSTRAINT `product_colors_products_id_foreign` FOREIGN KEY (`products_id`) REFERENCES `products` (`id`) ON DELETE NO ACTION;

--
-- Limitadores para a tabela `quotas`
--
ALTER TABLE `quotas`
  ADD CONSTRAINT `quotas_clubs_id_foreign` FOREIGN KEY (`clubs_id`) REFERENCES `clubs` (`id`) ON DELETE NO ACTION;

--
-- Limitadores para a tabela `services`
--
ALTER TABLE `services`
  ADD CONSTRAINT `services_partners_id_foreign` FOREIGN KEY (`partners_id`) REFERENCES `partners` (`id`) ON DELETE NO ACTION;

--
-- Limitadores para a tabela `service_clubs`
--
ALTER TABLE `service_clubs`
  ADD CONSTRAINT `service_clubs_clubs_id_foreign` FOREIGN KEY (`clubs_id`) REFERENCES `clubs` (`id`) ON DELETE NO ACTION,
  ADD CONSTRAINT `service_clubs_services_id_foreign` FOREIGN KEY (`services_id`) REFERENCES `services` (`id`) ON DELETE NO ACTION;

--
-- Limitadores para a tabela `stocks`
--
ALTER TABLE `stocks`
  ADD CONSTRAINT `stocks_products_id_foreign` FOREIGN KEY (`products_id`) REFERENCES `products` (`id`) ON DELETE NO ACTION;

--
-- Limitadores para a tabela `subcategorias`
--
ALTER TABLE `subcategorias`
  ADD CONSTRAINT `subcategorias_categories_id_foreign` FOREIGN KEY (`categories_id`) REFERENCES `categories` (`id`) ON DELETE NO ACTION;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;