-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `paytekaf_khuzela`
--

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

--
-- Table structure for table `auditoria_delete_membros`
--

CREATE TABLE `auditoria_delete_membros` (
  `id` int(11) UNSIGNED NOT NULL,
  `members_id` int(11) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `member_number` int(11) NOT NULL,
  `address` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `photo` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `document_number` varchar(255) NOT NULL,
  `clubs_id` int(11) UNSIGNED NOT NULL,
  `quotas_id` int(11) UNSIGNED NOT NULL,
  `cities_id` int(11) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `auditoria_insert_clubes`
--

CREATE TABLE `auditoria_insert_clubes` (
  `id` int(11) NOT NULL,
  `user` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(200) NOT NULL,
  `picture` varchar(200) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `auditoria_insert_clubes`
--

INSERT INTO `auditoria_insert_clubes` (`id`, `user`, `name`, `email`, `phone`, `picture`, `created_at`, `updated_at`) VALUES
(1, 15, 'Clube De Teste', 'Corinthians@gmail.com', '258000664777778', '/storage/club/1593806484esporte-clube-corinthians-de-laguna-sc.svg', '2020-07-03 16:01:24', '2020-07-03 16:01:24');

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

--
-- Table structure for table `auditoria_insert_membros`
--

CREATE TABLE `auditoria_insert_membros` (
  `id` int(11) UNSIGNED NOT NULL,
  `members_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `member_number` int(11) NOT NULL,
  `address` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `photo` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `document_number` varchar(255) NOT NULL,
  `clubs_id` int(11) NOT NULL,
  `quotas_id` int(11) NOT NULL,
  `cities_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `auditoria_insert_membros`
--

INSERT INTO `auditoria_insert_membros` (`id`, `members_id`, `name`, `member_number`, `address`, `phone`, `photo`, `email`, `document_number`, `clubs_id`, `quotas_id`, `cities_id`, `created_at`, `updated_at`) VALUES
(1, 31, 'Socio Z', 4501151, 'Maputo', '842004414400000', '/storage/member/1593806615i.png', 'socio@socio.com', '4101515151515', 1, 1, 5, '2020-07-03 16:03:35', '2020-07-03 16:03:35');

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

--
-- Table structure for table `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;

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

--
-- Table structure for table `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;

--
-- Dumping data for table `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');

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

--
-- Table structure for table `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;

--
-- Dumping data for table `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
(0, 'Todos', 'todos@todos.com', '841234567891000', 'Khuzela', '110028585', '#ed5716', '/storage/club/1596141427images (13).png', 'Khuzela', NULL, NULL, 1, 1, '2020-07-30 18:37:07', '2020-07-30 18:37:07'),
(1, 'ClubeX', 'clube@email.com', '849231169', 'Av. de Moçambique, Maputo', '362531233', '#b50000', '/storage/club/66906f43adefb3bc553f7601fa7c1ed9.jpg', 'Nome', NULL, NULL, 1, 2, '2020-07-30 07:32:08', '2020-07-30 07:32:08'),
(2, 'Clube S', 'clube@gmail.com', '845211151151151', 'Costa do Sol', '111202555', '#7a3737', '/storage/club/1596128701slb.png', 'Armando Costa', '840205510', 'costa@galp.com', 1, 7, '2020-07-30 15:05:01', '2020-07-30 15:05:01'),
(3, 'Clube Desportivo de Maputo', 'desp@gmail.com', '845123568', 'Av. 25 de Setembro, Maputo', '111212', '#0d0b0b', '/storage/club/520-5204981_arsenal-logo-symbol-arsenal-stl-model-grb-stl.png', 'Ana Cordeiro', '512121', 'maxa@gmail.com', 2, 1, '2020-05-10 09:16:08', '2020-05-24 20:34:53'),
(4, 'Clube Ferroviario de Maputo', 'cfm@gmail.com', '8412345678', 'maputo Cidade', '11021225', 'rgba(219,247,18,0.94)', '/storage/club/download (1).png', 'Carlos Pereira', '00258841245451', 'carlos@gmail.com', 15, 1, '2020-05-11 22:00:22', '2020-06-29 16:31:31'),
(5, 'Clube Costa do Sol..', 'costasol@gmail.com', '841234567', 'Maputo, Costa do Sol', '111011616', 'rgba(246,241,0,0.98)', '/storage/club/560px-Borussia_Dortmund_logo.svg.png', 'Amade Momed', '841221516', 'amade@gmail.com', 15, 1, '2020-05-11 23:02:25', '2020-06-29 15:47:09'),
(6, 'Clube Maxaquene', 'maxa@gmail.com', '845121619', 'Maxaquene', '10205121', '#f21001', '/storage/club/66906f43adefb3bc553f7601fa7c1ed9.jpg', 'Fariah Momed', '845121619', 'faria@gmail.com', 2, 1, '2020-05-11 23:15:03', '2020-05-24 20:35:58'),
(7, 'Clube das Mahotas', 'mahotas@gmail.com', '8451215100', 'Bairro das Mahotas', '11005541', '#1089f7', '/storage/club/i.png', 'Rogerio Armando', '8451339', 'maxa@gmail.com', 1, 1, '2020-05-14 01:41:38', '2020-06-30 01:18:41'),
(8, 'Sport Lisboa e Benfica', 'slb@benfica.pt', '+25884512', 'Lisboa Portugual', '10005116', '#fa0000', '/storage/club/slb.png', 'Luis Filipe Vieira', '21554664', 'lfv@hotmail.com', 15, 1, '2020-05-14 09:03:06', '2020-05-14 09:03:06'),
(9, 'Khuzela', 'khuzela@khuzela.com', '840000000000000', 'Maputo', '100000000', '#ff2e00', '/storage/club/oficial-novo-do-molde-logotipo-futebol-134846476.jpg', 'Khuzela', NULL, NULL, 15, 1, '2020-06-15 16:22:26', '2020-06-15 16:22:26'),
(10, 'FC Porto', 'clube@clube.com', '840051580022255', 'Maputo, Bairro do Jardim, Rua das Dalias,', '110002558', '#e8400a', '/storage/club/download.png', 'Manueal Almeida', NULL, NULL, 15, 1, '2020-06-16 03:18:36', '2020-06-16 03:18:36'),
(11, 'Liverpool', 'userClube@userClube.com', '8422005500000', 'Clube', '11010000a', '#f22f15', '/storage/club/1200px-Liverpool_FC.svg.png', 'User Clube', NULL, NULL, 15, 1, '2020-06-17 08:48:55', '2020-11-16 14:40:53'),
(12, 'Clube do Bairro', 'pank@gmail.com', '100518152145484', 'Maputo', '11005155p', '#1aed3c', '/storage/club/FreeVector-FC-Barcelona-2002.jpg', 'Lam', NULL, NULL, 15, 1, '2020-06-19 22:13:20', '2020-06-22 13:07:30'),
(13, 'Sporting Clube de Portugal', 'a@gmail.conm', '432432423', 'Lisboa', '432432432', '#40c735', '/storage/club/Sporting_Clube_de_Portugal_-_Emblema.png', 'dsadsads', NULL, NULL, 15, 3, '2020-06-28 03:46:46', '2020-07-10 11:49:57'),
(14, 'Clube De Teste', 'Corinthians@gmail.com', '258000664777778', 'Rio', '100115515', '#8c817d', '/storage/club/esporte-clube-corinthians-de-laguna-sc.svg', 'Mario Brasil', '845550055', 'mario@corinthians.com', 15, 9, '2020-07-03 16:01:24', '2020-07-03 16:01:24');

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

--
-- Table structure for table `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;

--
-- Dumping data for table `colors`
--

INSERT INTO `colors` (`id`, `description`, `cody`, `created_at`, `updated_at`) VALUES
(1, 'cor 01', '01', '2020-07-30 07:30:51', '2020-07-30 07:30:51'),
(2, 'cor 02', '02', '2020-07-30 07:30:51', '2020-07-30 07:30:51'),
(3, 'cor 03', '03', '2020-07-30 07:30:51', '2020-07-30 07:30:51'),
(4, 'cor 04', '04', '2020-07-30 07:30:51', '2020-07-30 07:30:51'),
(5, 'cor 05', '05', '2020-07-30 07:30:51', '2020-07-30 07:30:51'),
(6, 'Branco', '06', '2020-07-30 07:30:51', '2020-07-30 07:30:51'),
(7, 'Amarelo', '07', '2020-07-30 07:30:51', '2020-07-30 07:30:51'),
(8, 'Vermelho', '08', '2020-07-30 07:30:51', '2020-07-30 07:30:51'),
(9, 'Verde', '09', '2020-07-30 07:30:51', '2020-07-30 07:30:51'),
(10, 'Cinza', '10', '2020-07-30 07:30:51', '2020-07-30 07:30:51'),
(11, 'Castanho', '11', '2020-07-30 07:30:51', '2020-07-30 07:30:51'),
(12, 'Laranja', '12', '2020-07-30 07:30:51', '2020-07-30 07:30:51'),
(13, 'Violeta', '13', '2020-07-30 07:30:51', '2020-07-30 07:30:51');

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

--
-- Table structure for table `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;

--
-- Dumping data for table `compras`
--

INSERT INTO `compras` (`id`, `codigo_compra`, `quantTotal`, `precoTotal`, `meios_pagamentos_id`, `statuses_id`, `created_at`, `updated_at`) VALUES
(1, '3N0vC67u', 10, 5000, 2, 4, '2020-07-30 17:05:06', '2020-07-30 17:05:06');

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

--
-- Table structure for table `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;

--
-- Dumping data for table `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);

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

--
-- Table structure for table `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;

--
-- Dumping data for table `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');

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

--
-- Table structure for table `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;

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

--
-- Table structure for table `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;

--
-- Dumping data for table `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'),
(8, '/storage/productsKhuzela/2bcd24fab8297a1a94c5b29e9e59aea6.jpg', 4, '2020-07-30 07:54:57', '2020-07-30 07:54:57'),
(9, '/storage/productsKhuzela/e8d3fe412155b8275b77fc1150edadd7.jpg', 4, '2020-07-30 07:54:57', '2020-07-30 07:54:57'),
(10, '/storage/productsKhuzela/f6213d6209b3b714772866dc1d68d38b.jpg', 4, '2020-07-30 07:54:57', '2020-07-30 07:54:57'),
(11, '/storage/productsKhuzela/thumb (6).jpeg', 3, '2020-07-30 08:31:04', '2020-07-30 08:31:04'),
(12, '/storage/productsKhuzela/thumb (7).jpeg', 3, '2020-07-30 08:31:04', '2020-07-30 08:31:04'),
(13, '/storage/productsKhuzela/thumb (8).jpeg', 3, '2020-07-30 08:31:04', '2020-07-30 08:31:04'),
(14, '/storage/productsKhuzela/Adidas-Original-Nova-Chegada-17-4-dos-homens-AG-Futebol-Futebol-Cal-a-As-Sapatilhas.jpg', 5, '2020-07-30 16:19:32', '2020-07-30 16:19:32');

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

--
-- Table structure for table `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;

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

--
-- Table structure for table `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;

--
-- Dumping data for table `meios_pagamentos`
--

INSERT INTO `meios_pagamentos` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'IMali', NULL, NULL),
(2, 'Cartao VISA', NULL, NULL),
(3, 'mPesa', NULL, NULL),
(4, 'IZI', NULL, NULL),
(5, 'mKesh', NULL, NULL),
(6, 'eMola', NULL, NULL);

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

--
-- Table structure for table `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;

--
-- Dumping data for table `member_clubs`
--

INSERT INTO `member_clubs` (`id`, `nr_quotas_em_divida`, `next_payment_date`, `members_id`, `clubs_id`, `created_at`, `updated_at`) VALUES
(18, NULL, NULL, 25, 1, '2020-11-17 06:01:04', '2020-11-17 06:01:04');

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

--
-- Table structure for table `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;

--
-- Dumping data for table `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),
(127, '2014_02_12_000000_create_documents_table', 1),
(128, '2014_10_12_000000_create_users_table', 1),
(129, '2014_10_12_100000_create_password_resets_table', 1),
(130, '2016_06_01_000001_create_oauth_auth_codes_table', 1),
(131, '2016_06_01_000002_create_oauth_access_tokens_table', 1),
(132, '2016_06_01_000003_create_oauth_refresh_tokens_table', 1),
(133, '2016_06_01_000004_create_oauth_clients_table', 1),
(134, '2016_06_01_000005_create_oauth_personal_access_clients_table', 1),
(135, '2019_08_19_000000_create_failed_jobs_table', 1),
(136, '2019_09_25_182323_create_roles_table', 1),
(137, '2019_09_25_183138_create_role_user_table', 1),
(138, '2020_04_30_150270_create_categories_table', 1),
(139, '2020_04_30_150301_create_subcategorias_table', 1),
(140, '2020_04_30_150360_create_colors_table', 1),
(141, '2020_05_09_222554_create_cities_table', 1),
(142, '2020_05_09_222573_create_estados_table', 1),
(143, '2020_05_09_222600_create_percentagems_table', 1),
(144, '2020_05_09_222648_create_clubs_table', 1),
(145, '2020_05_09_222854_create_quotas_table', 1),
(146, '2020_05_09_222932_create_members_table', 1),
(147, '2020_05_09_223009_create_member_clubs_table', 1),
(148, '2020_05_09_223134_create_partners_table', 1),
(149, '2020_05_09_223160_create_meios_pagamentos_table', 1),
(150, '2020_05_09_223180_create_tamanhos_table', 1),
(151, '2020_05_09_223230_create_producto_categorias_table', 1),
(152, '2020_05_09_223360_create_producto_subcategorias_table', 1),
(153, '2020_05_09_223442_create_services_table', 1),
(154, '2020_05_09_223500_create_statuses_table', 1),
(155, '2020_05_09_223516_create_products_table', 1),
(156, '2020_05_09_223533_create_compras_table', 1),
(157, '2020_05_22_110712_create_partner_clubs_table', 1),
(158, '2020_05_22_110720_create_service_clubs_table', 1),
(159, '2020_05_26_15452_create_images_table', 1),
(160, '2020_05_28_084059_create_posts_table', 1),
(161, '2020_06_02_043936_create_periods_table', 1),
(162, '2020_06_11_045954_create_post_khuzelas_table', 1),
(163, '2020_06_24_154927_create_product_colors_table', 1),
(164, '2020_06_28_193359_add_soft_deletes_to_post_khuzela_table', 1),
(165, '2020_07_01_220301_create_product_items_table', 1),
(166, '2020_07_01_221917_create_product_item_images_table', 1),
(167, '2020_07_07_095030_create_stocks_table', 1),
(168, '2020_07_07_162317_create_item_compras_table', 1);

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

--
-- Table structure for table `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 DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `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;

--
-- Dumping data for table `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'),
(2, 3, '2020-07-30 11:36:33', '2020-07-30 11:36:33');

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

--
-- Table structure for table `origims`
--

CREATE TABLE `origims` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `origims`
--

INSERT INTO `origims` (`id`, `name`) VALUES
(0, 'Todos'),
(1, 'Clubes');

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

--
-- Table structure for table `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;

--
-- Dumping data for table `partners`
--

INSERT INTO `partners` (`id`, `name`, `partner_description`, `phone`, `address`, `nuit`, `picture`, `responsible_name`, `responsible_phone`, `responsible_email`, `cities_id`, `created_at`, `updated_at`) VALUES
(1, 'Galp Energia', 'Bomba de Combustivel', 845100255515151, 'Coop Rua da Franca', '122120020', '/storage/partner/15961289493d62773a421755449d8a32e8dbc0a9f9.jpeg', 'Ana Cordeiro', '845455515151515', 'galp@mz.com', 4, '2020-07-30 13:09:09', '2020-11-14 14:49:08'),
(2, 'Linhas Aereas de Mozambique', 'LAM', 841220121121221, 'Maputo', '111002222', '/storage/partner/1596150599images (9).png', NULL, NULL, NULL, 1, '2020-07-30 19:09:59', '2020-11-16 14:41:57'),
(3, 'Bombas de Combustivel Total', 'Bombas de Combustivel', 845123560000000, 'Av. Vladimir Lenine', '11120121', '/storage/partner/1590154718557.jpg', 'Amade Machava', '84515161', 'maxa@gmail.com', 1, '2020-05-10 08:58:14', '2020-06-29 15:21:09'),
(4, 'Loja Adidas', 'Loja de Equipamentos Desportivos', 8451268, 'Av. Vladimir Lenine - Maputo Shopping', '125545', '/storage/partner/1590288147744.jpg', 'Joao Gaspar', '+258849113015', 'jgaspar59@gmail.com', 1, '2020-05-24 18:44:33', '2020-06-29 13:33:46'),
(5, 'Novo Parceiro', 'Parceiro Test', 849231169, 'fdsfdsfdssd', '332132321', '/storage/partner/15937134413d62773a421755449d8a32e8dbc0a9f9.jpeg', 'Nox', '849231169', 'nox@gmail.com', 3, '2020-06-30 09:59:12', '2020-07-06 03:16:31');

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

--
-- Table structure for table `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;

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

--
-- Table structure for table `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;

--
-- Dumping data for table `percentagems`
--

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

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

--
-- Table structure for table `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;

--
-- Dumping data for table `periods`
--

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

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

--
-- Table structure for table `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,
  `origin` int(11) NOT NULL,
  `estados_id` int(10) UNSIGNED NOT NULL,
  `club_default_id` int(11) 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;

--
-- Dumping data for table `posts`
--

INSERT INTO `posts` (`id`, `title`, `description`, `photo`, `status`, `source`, `origin`, `estados_id`, `club_default_id`, `users_id`, `clubs_id`, `created_at`, `updated_at`) VALUES
(1, 'Noticia', 'Noticia.... Teste', 'http://localhost:8000/storage/posts/1596153230bruno.jpg', NULL, NULL, 0, 1, 0, 2, 1, '2020-07-30 19:53:50', '2020-07-30 19:53:50'),
(2, 'Taca de Mocambique...', 'Jogo da taca de Mocambique.. a se realizar no estado do Zimpeto pelas 7h da noite', 'http://localhost:8000/storage/posts/D1A6B48C-2B8C-4516-B706-47D6D7BA6E0C.jpeg', NULL, NULL, 0, 1, 0, 2, 1, '2020-05-28 05:42:18', '2020-06-29 22:59:04'),
(3, 'Noticia do Clube das Mahotas', 'Publicacao de Publicidade da marca patrocinadora dos nossos enventos...', 'http://localhost:8000/storage/posts/1591227422maxresdefault.jpg', NULL, NULL, 0, 1, 0, 2, 5, '2020-06-03 17:37:02', '2020-06-03 17:37:43'),
(4, 'Grande Golo!!!!', 'Grande golo do Bruno Fernandes neste fim de semana no classico Benfica Sporting.', 'http://localhost:8000/storage/posts/bruno.jpg', NULL, NULL, 0, 1, 0, 2, 1, '2020-06-01 06:07:24', '2020-06-29 22:59:35'),
(5, 'Jogo final da semana', 'Proximo finald e seman grande jogo', 'http://localhost:8000/storage/posts/Captura-de-ecrã-2017-08-19-às-17.34.25-800x445.png', NULL, NULL, 0, 1, 0, 2, 1, '2020-06-02 08:17:51', '2020-06-02 08:17:51'),
(6, 'Exemplo', 'Edes', 'http://localhost:8000/storage/posts/1593492667download (1).png', NULL, NULL, 0, 1, 0, 2, 1, '2020-06-29 22:51:07', '2020-06-29 22:51:07'),
(7, 'Noticia de Teste', 'Teste', 'http://localhost:8000/storage/posts/1593984009etd1ottxsaaryhi-780x520.jpg', NULL, NULL, 0, 1, 0, 2, 10, '2020-07-05 15:20:09', '2020-07-05 15:20:09');

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

--
-- Table structure for table `post_khuzelas`
--

CREATE TABLE `post_khuzelas` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT 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;

--
-- Dumping data for table `post_khuzelas`
--

INSERT INTO `post_khuzelas` (`id`, `title`, `description`, `photo`, `estados_id`, `origin`, `clubs_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
(2, 'Noticia Exemplo', 'MMMMMMM', '/storage/postsKhuzela/1596140613etd1ottxsaaryhi-780x520.jpg', 1, 0, 0, '2020-07-30 16:23:33', '2020-07-30 16:23:33', NULL),
(3, 'Noticia ', 'MeMMeMMeMeMeMMe', '/storage/postsKhuzela/1596140729download.jpg', 1, 1, 1, '2020-07-30 16:25:29', '2020-07-30 16:25:29', NULL),
(5, 'Noticia do Clube', 'MMeMVeVVCeCCJJJeJJHHHHH', '/storage/postsKhuzela/159615743444644105_1832327190227393_7835615277171208765_n.jpg', 1, 1, 2, '2020-07-30 21:03:54', '2020-07-30 21:03:54', NULL);

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

--
-- Table structure for table `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,
  `status` 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;

--
-- Dumping data for table `producto_categorias`
--

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

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

--
-- Table structure for table `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,
  `status` 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;

--
-- Dumping data for table `producto_subcategorias`
--

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

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `statuses_id` int(10) UNSIGNED NOT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `visible` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `clubs_id` bigint(20) UNSIGNED NOT NULL,
  `colors_id` int(10) UNSIGNED NOT NULL,
  `tamanhos_id` int(10) UNSIGNED NOT NULL,
  `product_category_id` bigint(20) 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;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`id`, `title`, `product_code`, `statuses_id`, `description`, `visible`, `image`, `clubs_id`, `colors_id`, `tamanhos_id`, `product_category_id`, `subcategorias_id`, `created_at`, `updated_at`) VALUES
(1, 'Sapatilhas', '120', 1, 'Sapatilhas', 'YES', '/storage/productsKhuzela/b8c6ca393c6494c2f821f5314393c167.jpg', 1, 1, 1, 3, 2, NULL, NULL);

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

--
-- Table structure for table `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;

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

--
-- Table structure for table `product_items`
--

CREATE TABLE `product_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci NOT 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,
  `color_id` int(10) UNSIGNED DEFAULT NULL,
  `product_id` int(10) UNSIGNED NOT NULL,
  `size_id` int(10) UNSIGNED DEFAULT NULL,
  `statuses_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;

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

--
-- Table structure for table `product_item_images`
--

CREATE TABLE `product_item_images` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_item_id` int(10) UNSIGNED DEFAULT 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;

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

--
-- Table structure for table `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;

--
-- Dumping data for table `quotas`
--

INSERT INTO `quotas` (`id`, `quota_description`, `quota_value`, `payment_date`, `periods_id`, `clubs_id`, `created_at`, `updated_at`) VALUES
(1, 'Quota Platina', 150, 2, 1, 1, '2020-07-30 11:34:43', '2020-07-30 11:34:43'),
(2, 'Quota Mensal', 150, 30, 1, 2, '2020-07-30 21:02:06', '2020-07-30 21:02:06'),
(7, 'Lugar Anual no Estadio', 150, 25, 1, 1, '2020-06-01 22:49:37', '2020-11-14 14:51:26'),
(8, 'Quota Mensal', 75, 27, 1, 5, '2020-06-03 17:42:27', '2020-06-04 15:11:19'),
(9, 'Quota Seamanal', 50, 10, 3, 5, '2020-06-04 13:04:34', '2020-06-09 10:26:57'),
(10, 'Quota Normal', 900, 20, 1, 3, '2020-06-29 13:35:43', '2020-11-16 16:40:18'),
(11, 'Sócio honorário', 3000, 1, 1, 11, '2020-06-29 14:42:09', '2020-06-29 14:42:26');

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

--
-- Table structure for table `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;

--
-- Dumping data for table `roles`
--

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

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

--
-- Table structure for table `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;

--
-- Dumping data for table `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),
(13, 4, 6, '2020-07-30 19:20:29', '2020-07-30 19:20:29'),
(14, 2, 21, NULL, NULL),
(17, 4, 29, NULL, NULL);

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

--
-- Table structure for table `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;

--
-- Dumping data for table `services`
--

INSERT INTO `services` (`id`, `name`, `description`, `khuzelaBonus`, `clubBonus`, `partnerBonus`, `partners_id`, `percentagems_id`, `created_at`, `updated_at`) VALUES
(1, 'Servico de Teste', 'Servico de Combustivel', 10, 25, 35, 1, 3, '2020-07-30 13:21:30', '2020-07-30 13:21:30'),
(2, 'Sapatilhas Adidas', 'Venda de Equipamento Desportivo..', 25, 10, 5, 2, 1, '2020-06-04 05:44:43', '2020-11-14 14:50:51'),
(3, 'Sapatilhas Adidas', 'Sapatos adidas 2020', 20, 10, 5, 2, 1, '2020-06-04 11:52:30', '2020-07-02 18:12:27'),
(4, 'Servico de Teste', 'Descrisao Descrisao', 10, 10, 52, 2, 0, '2020-06-10 23:29:29', '2020-06-22 04:45:38'),
(5, 'Serviço1', 'Alguma Descrisao ..', 10, 5, 7, 1, 0, '2020-06-29 03:41:25', '2020-07-01 09:32:29');

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

--
-- Table structure for table `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;

--
-- Dumping data for table `service_clubs`
--

INSERT INTO `service_clubs` (`id`, `destription`, `clubs_id`, `services_id`, `users_id`, `created_at`, `updated_at`) VALUES
(1, 'Parceria entre servico e Clube..', 1, 1, 1, '2020-07-30 13:50:33', '2020-11-16 16:17:04'),
(2, 'Descrisao...', 1, 2, 15, '2020-07-20 06:15:17', '2020-07-20 06:15:17');

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

--
-- Table structure for table `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;

--
-- Dumping data for table `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);

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

--
-- Table structure for table `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;

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

--
-- Table structure for table `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;

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

--
-- Table structure for table `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;

--
-- Dumping data for table `tamanhos`
--

INSERT INTO `tamanhos` (`id`, `size`, `description`, `cody`, `created_at`, `updated_at`) VALUES
(1, 'XL', 'Extra Smal - extra pequeno', '01', NULL, NULL),
(2, 'S', 'Smal - pequeno', '02', NULL, NULL),
(3, 'M', 'Medium - Medio', '03', NULL, NULL),
(4, 'L', 'Large - Grande', '04', NULL, NULL),
(5, 'XL ', 'Extra Large - extra grande', '05', NULL, NULL);

--
-- Indexes for dumped tables
--

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

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

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

--
-- 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_clubs_id_foreign` (`clubs_id`),
  ADD KEY `members_id` (`members_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 `origims`
--
ALTER TABLE `origims`
  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_product_category_id_foreign` (`product_category_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 `auditoria_delete_membros`
--
ALTER TABLE `auditoria_delete_membros`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `auditoria_insert_clubes`
--
ALTER TABLE `auditoria_insert_clubes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `auditoria_insert_membros`
--
ALTER TABLE `auditoria_insert_membros`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `origims`
--
ALTER TABLE `origims`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `clubs`
--
ALTER TABLE `clubs`
  ADD CONSTRAINT `clubs_cities_id_foreign` FOREIGN KEY (`cities_id`) REFERENCES `cities` (`id`) ON DELETE NO ACTION;

--
-- Constraints for table `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;

--
-- Constraints for table `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;

--
-- Constraints for table `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;

--
-- Constraints for table `partners`
--
ALTER TABLE `partners`
  ADD CONSTRAINT `partners_cities_id_foreign` FOREIGN KEY (`cities_id`) REFERENCES `cities` (`id`) ON DELETE NO ACTION;

--
-- Constraints for table `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;

--
-- Constraints for table `posts`
--
ALTER TABLE `posts`
  ADD CONSTRAINT `posts_clubs_id_foreign` FOREIGN KEY (`clubs_id`) REFERENCES `clubs` (`id`) ON DELETE NO ACTION;

--
-- Constraints for table `post_khuzelas`
--
ALTER TABLE `post_khuzelas`
  ADD CONSTRAINT `post_khuzelas_clubs_id_foreign` FOREIGN KEY (`clubs_id`) REFERENCES `clubs` (`id`) ON DELETE NO ACTION;

--
-- Constraints for table `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;

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_clubs_id_foreign` FOREIGN KEY (`clubs_id`) REFERENCES `clubs` (`id`) ON DELETE NO ACTION,
  ADD CONSTRAINT `products_product_category_id_foreign` FOREIGN KEY (`product_category_id`) REFERENCES `producto_categorias` (`id`) ON DELETE NO ACTION,
  ADD CONSTRAINT `products_subcategorias_id_foreign` FOREIGN KEY (`subcategorias_id`) REFERENCES `producto_subcategorias` (`id`) ON DELETE NO ACTION;

--
-- Constraints for table `product_colors`
--
ALTER TABLE `product_colors`
  ADD CONSTRAINT `product_colors_products_id_foreign` FOREIGN KEY (`products_id`) REFERENCES `products` (`id`) ON DELETE NO ACTION;

--
-- Constraints for table `quotas`
--
ALTER TABLE `quotas`
  ADD CONSTRAINT `quotas_clubs_id_foreign` FOREIGN KEY (`clubs_id`) REFERENCES `clubs` (`id`) ON DELETE NO ACTION;

--
-- Constraints for table `services`
--
ALTER TABLE `services`
  ADD CONSTRAINT `services_partners_id_foreign` FOREIGN KEY (`partners_id`) REFERENCES `partners` (`id`) ON DELETE NO ACTION;

--
-- Constraints for table `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;

--
-- Constraints for table `stocks`
--
ALTER TABLE `stocks`
  ADD CONSTRAINT `stocks_products_id_foreign` FOREIGN KEY (`products_id`) REFERENCES `products` (`id`) ON DELETE NO ACTION;

--
-- Constraints for table `subcategorias`
--
ALTER TABLE `subcategorias`
  ADD CONSTRAINT `subcategorias_categories_id_foreign` FOREIGN KEY (`categories_id`) REFERENCES `categories` (`id`) ON DELETE NO ACTION;
COMMIT;

