-- https://www.phpmyadmin.net/
--
-- Versão do servidor: 10.1.33-MariaDB

START TRANSACTION;



--
-- 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 `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_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_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 `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 `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');

--
-- 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 `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_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_personal_access_clients`
--
ALTER TABLE `oauth_personal_access_clients`
  ADD PRIMARY KEY (`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 `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`);

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

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

