-- phpMyAdmin SQL Dump
-- version 4.9.0.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Aug 19, 2020 at 06:35 PM
-- Server version: 10.4.6-MariaDB
-- PHP Version: 7.3.9
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `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, 'Clube', 'userClube@userClube.com', '842200555555555', 'Clube', '11000000a', '#f22f15', '/storage/club/1200px-Liverpool_FC.svg.png', 'User Clube', NULL, NULL, 15, 1, '2020-06-17 08:48:55', '2020-06-30 01:04:45'),
(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 `members`
--
CREATE TABLE `members` (
`id` bigint(20) UNSIGNED NOT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`member_number` bigint(20) NOT NULL,
`address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`phone` bigint(20) NOT NULL,
`photo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`document_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`status_user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`quotas_id` int(10) UNSIGNED NOT NULL,
`code` int(11) DEFAULT NULL,
`password` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`member_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`documents_id` bigint(20) UNSIGNED NOT NULL,
`clubs_id` bigint(20) UNSIGNED NOT NULL,
`cities_id` bigint(20) UNSIGNED NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `members`
--
INSERT INTO `members` (`id`, `name`, `member_number`, `address`, `phone`, `photo`, `email`, `document_number`, `status_user`, `quotas_id`, `code`, `password`, `member_type`, `documents_id`, `clubs_id`, `cities_id`, `created_at`, `updated_at`) VALUES
(1, 'Socio Teste', 2500000, 'Maxaquene', 84512659899, '/storage/member/1596127584829444_man_512x512.png', 'socio@socio.com', '1100112111212', NULL, 1, NULL, NULL, NULL, 1, 1, 4, '2020-07-30 14:46:24', '2020-07-30 14:46:24'),
(2, 'Socio Teste2', 2225, 'Machava', 841256489788888, '/storage/member/1596127878man3-512.png', 'maxa@gmail.com', '1002020200002', NULL, 1, NULL, NULL, NULL, 6, 1, 2, '2020-07-30 14:51:18', '2020-07-30 14:51:18'),
(3, 'Lira Zhiha', 263, 'RZA', 127201115515515, '/storage/member/1596152575images (15).png', 'lira@hotmail.com', '111002021111', NULL, 1, NULL, NULL, NULL, 5, 1, 1, '2020-07-30 21:42:55', '2020-07-30 21:42:55'),
(4, 'Ana Perola', 252, 'Xai-Xai', 840124699520000, '/storage/member/1596157287icone-de-perfil-de-pessoas_24877-40761.jpg', 'perola@outlook.com', '1100012151515', NULL, 1, NULL, NULL, NULL, 7, 2, 4, '2020-07-30 23:01:27', '2020-07-30 23:01:27'),
(5, 'Pedro Perreira', 205001, 'Maxaquene', 84511313, '/storage/member/149071.png', 'maxaquene@gmail.com', '11100202', NULL, 1, NULL, NULL, NULL, 1, 1, 1, '2020-05-10 08:43:53', '2020-05-29 15:19:02'),
(6, 'Rodrigo Machava', 1256, 'Malhangalene', 845151, '/storage/member/149071.png', 'teste@teste.com', '11100202', NULL, 1, NULL, NULL, NULL, 1, 5, 1, '2020-05-14 08:00:40', '2020-05-14 08:00:40'),
(7, 'Osvaldo Rombe', 145993, 'Chopal 25 de Junho', 84152369, '/storage/member/149071.png', 'rombe@hotmail.com', '110021161', NULL, 1, NULL, NULL, NULL, 1, 3, 1, '2020-05-15 03:18:51', '2020-05-15 03:18:51'),
(8, 'Membro Teste', 101241, 'Coop', 8456466, '/storage/member/149071.png', 'teste1@teste1.com', '111002', NULL, 1, NULL, NULL, NULL, 1, 2, 3, '2020-05-15 05:55:04', '2020-05-27 17:12:59'),
(9, 'Adao Zimba', 4446661, 'Matola', 8412564911, '/storage/member/avatar-masculino-étnico-afro-americano-do-ícone-do-perfil-do-homem-de-negócio-69046204.jpg', 'adao@gmail.com', '110215166', NULL, 8, NULL, NULL, NULL, 2, 1, 1, '2020-05-19 15:19:02', '2020-07-04 00:56:54'),
(10, 'Ana Maria', 841421, 'Malhangalene', 84615123, '/storage/member/149071.png', 'ana@gmail.com', '122121111', NULL, 7, NULL, NULL, NULL, 1, 1, 4, '2020-05-24 19:59:01', '2020-06-06 12:25:33'),
(11, 'João Gaspar', 12221, 'Av. Filipe Samuel Magaia, 1530', 849113015, '/storage/member/avatar.jpg', 'joao.gasparpaytek-africa.com', '1234565665512', NULL, 3, NULL, NULL, NULL, 1, 7, 1, '2020-05-29 19:59:56', '2020-06-02 08:37:24'),
(12, 'Roberto Carlos', 14502151, 'Malhangalene', 84102118848, '/storage/member/149071.png', 'robcarlos@gmail.com', '1100112222', NULL, 1, NULL, NULL, NULL, 1, 1, 2, '2020-06-02 02:51:21', '2020-06-02 08:32:36'),
(13, 'Adao ZimbaX', 115025102, 'Malhazine', 842592349, '/storage/member/149071.png', 'adaoZ@gmail.com', '1110020200', NULL, 7, NULL, NULL, NULL, 1, 1, 2, '2020-06-02 02:38:28', '2020-06-09 10:16:56'),
(14, 'Samuel Xiluva', 10, 'Washinton DC', 84552121212, '/storage/member/149071.png', 'kendrick@lamar.com', '111151504551', NULL, 8, NULL, NULL, NULL, 1, 5, 1, '2020-06-03 19:52:58', '2020-06-03 20:13:21'),
(15, 'João Gaspar', 12234, 'Av. Vladimir Lenine, 3071 R/C Esqº3071', 849113015, '/storage/member/avatar-circle-human-male-2-512.png', 'joao@jrconsuling.co.mz', '12345656655324', NULL, 3, NULL, NULL, NULL, 1, 8, 3, '2020-06-02 09:06:54', '2020-06-02 09:07:22'),
(16, 'Maria de fatima', 123, 'Rua da se, n 23', 7437373773773, '/storage/member/149071.png', 'fatima@gmail.com', '1234565665512', NULL, 7, NULL, NULL, NULL, 1, 1, 4, '2020-06-02 09:28:59', '2020-06-02 09:28:59'),
(17, 'Rodrigues Mafumo', 1, 'Maputo', 258849231169, '/storage/member/1594014028photo3.png', 'a@gmail.com', '25664374234324J', NULL, 8, NULL, NULL, NULL, 1, 5, 2, '2020-06-29 06:02:58', '2020-07-06 01:40:28'),
(18, 'Joao Gaspar', 211212, 'Av. Filipe Samuel Magaia, 1530', 258849113015, '/storage/member/15943961513,5x4,5_Abril 2016.png', 'joao.gaspar@paytek-africa.com', '121212121', NULL, 10, NULL, NULL, NULL, 3, 11, 1, '2020-06-29 16:39:32', '2020-07-10 11:49:11'),
(19, 'User Teste', 1005411, 'Maputo', 842001555515151, '/storage/member/1593838564photo3.png', 'usertest@gmail.com', '1004555555555', NULL, 2, NULL, NULL, NULL, 1, 8, 1, '2020-06-29 17:20:15', '2020-07-04 00:56:04'),
(20, 'Socio Z', 4501151, 'Maputo', 842004414400000, '/storage/member/1593806615i.png', 'socios@socios.com', '4101515151515', NULL, 8, NULL, NULL, NULL, 7, 11, 5, '2020-07-03 16:03:35', '2020-07-03 16:03:35');
-- --------------------------------------------------------
--
-- 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
(1, NULL, NULL, 1, 1, '2020-07-30 14:46:25', '2020-07-30 14:46:25'),
(2, NULL, NULL, 2, 1, '2020-07-30 14:51:18', '2020-07-30 14:51:18'),
(3, NULL, NULL, 3, 1, '2020-07-30 21:42:55', '2020-07-30 21:42:55'),
(4, NULL, NULL, 4, 2, '2020-07-30 23:01:27', '2020-07-30 23:01:27');
-- --------------------------------------------------------
--
-- 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_access_tokens`
--
CREATE TABLE `oauth_access_tokens` (
`id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`user_id` bigint(20) UNSIGNED DEFAULT NULL,
`client_id` bigint(20) UNSIGNED NOT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`scopes` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`revoked` tinyint(1) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `oauth_access_tokens`
--
INSERT INTO `oauth_access_tokens` (`id`, `user_id`, `client_id`, `name`, `scopes`, `revoked`, `created_at`, `updated_at`, `expires_at`) VALUES
('6ccc1a4de15420ca8d4199e0c9e834795c106f4f431020dad1c23ea78eb00450743e411fed9bf89a', 1, 2, NULL, '[]', 0, '2020-07-30 07:26:07', '2020-07-30 07:26:07', '2020-07-30 11:06:07'),
('b04dd03e92bfa6709e20760a776ebee01b67cbd5e261a6e8da39bdaceade0e9efb8b38fc24949e9a', 1, 2, NULL, '[]', 0, '2020-07-30 08:29:40', '2020-07-30 08:29:40', '2020-07-30 12:09:40');
-- --------------------------------------------------------
--
-- 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_clients`
--
CREATE TABLE `oauth_clients` (
`id` bigint(20) UNSIGNED NOT NULL,
`user_id` bigint(20) UNSIGNED DEFAULT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`secret` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`provider` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`redirect` text COLLATE utf8mb4_unicode_ci NOT NULL,
`personal_access_client` tinyint(1) NOT NULL,
`password_client` tinyint(1) NOT NULL,
`revoked` tinyint(1) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `oauth_clients`
--
INSERT INTO `oauth_clients` (`id`, `user_id`, `name`, `secret`, `provider`, `redirect`, `personal_access_client`, `password_client`, `revoked`, `created_at`, `updated_at`) VALUES
(1, NULL, 'Laravel Personal Access Client', 'AzSkBjY6ho2CtZzs5vuTC4S5dSDvJFBcNO8OCSdW', NULL, 'http://localhost', 1, 0, 0, '2020-07-30 07:25:31', '2020-07-30 07:25:31'),
(2, NULL, 'Laravel Password Grant Client', 'GRC5k4Siublff68GZqnbwMET0R9CS71uOEUWMDjD', 'users', 'http://localhost', 0, 1, 0, '2020-07-30 07:25:32', '2020-07-30 07:25:32'),
(3, NULL, 'Khuzela Personal Access Client', 'HpychHNx161KCLx4CW3bRte7HGim3RXqwk3jF7gb', NULL, 'http://localhost', 1, 0, 0, '2020-07-30 11:36:30', '2020-07-30 11:36:30'),
(4, NULL, 'Khuzela Password Grant Client', '8NLKsY2Q8sADCx7hb2zHgRmYQQ23t5Yiu3SpOwHV', 'users', 'http://localhost', 0, 1, 0, '2020-07-30 11:36:33', '2020-07-30 11:36:33');
-- --------------------------------------------------------
--
-- 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 `oauth_refresh_tokens`
--
CREATE TABLE `oauth_refresh_tokens` (
`id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`access_token_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`revoked` tinyint(1) NOT NULL,
`expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `oauth_refresh_tokens`
--
INSERT INTO `oauth_refresh_tokens` (`id`, `access_token_id`, `revoked`, `expires_at`) VALUES
('34294461c77169b3ddee9551f17b43e328b21724c798f170cd5716fc5f98bde1c6a61921994c5f76', 'b04dd03e92bfa6709e20760a776ebee01b67cbd5e261a6e8da39bdaceade0e9efb8b38fc24949e9a', 0, '2020-08-29 10:29:40'),
('7217b66ff44e296ba7f5d5f3421f165748520e41149aa3ddd703f292417c2de7baa8d12fcb459fdf', '6ccc1a4de15420ca8d4199e0c9e834795c106f4f431020dad1c23ea78eb00450743e411fed9bf89a', 0, '2020-08-29 09:26:07');
-- --------------------------------------------------------
--
-- 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', 'Bombas de Combustivel', 845100255515151, 'Coop', '122120020', '/storage/partner/15961289493d62773a421755449d8a32e8dbc0a9f9.jpeg', 'Ana Cordeiro', '845455515151515', 'galp@mz.com', 4, '2020-07-30 13:09:09', '2020-07-30 13:09:09'),
(2, 'Linhas Aerias de Mocambique', 'LAM', 841220121121221, 'Maputo', '111002222', '/storage/partner/1596150599images (9).png', NULL, NULL, NULL, 1, '2020-07-30 19:09:59', '2020-07-30 19:09:59'),
(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 `password_resets`
--
CREATE TABLE `password_resets` (
`email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- 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,
`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;
--
-- Dumping data for table `posts`
--
INSERT INTO `posts` (`id`, `title`, `description`, `photo`, `status`, `source`, `estados_id`, `users_id`, `clubs_id`, `created_at`, `updated_at`) VALUES
(1, 'Noticia', 'Noticia.... Teste', '/storage/posts/1596153230bruno.jpg', NULL, NULL, 1, 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', '/storage/posts/D1A6B48C-2B8C-4516-B706-47D6D7BA6E0C.jpeg', NULL, NULL, 1, 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...', '/storage/posts/1591227422maxresdefault.jpg', NULL, NULL, 1, 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.', '/storage/posts/bruno.jpg', NULL, NULL, 1, 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', '/storage/posts/Captura-de-ecrã-2017-08-19-às-17.34.25-800x445.png', NULL, NULL, 1, 2, 1, '2020-06-02 08:17:51', '2020-06-02 08:17:51'),
(6, 'Exemplo', 'Edes', '/storage/posts/1593492667download (1).png', NULL, NULL, 1, 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, 1, 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 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;
--
-- 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
(1, 'Novo Titulo', 'vdmsn ', '/storage/postsKhuzela/Captura-de-ecrã-2017-08-19-às-17.34.25-800x445.png', 1, 0, 1, '2020-07-30 05:57:33', '2020-07-30 05:57:55', NULL),
(2, 'Noticia Exemplo', '<div>MMMMMMM</div>', '/storage/postsKhuzela/1596140613etd1ottxsaaryhi-780x520.jpg', 1, 0, 0, '2020-07-30 16:23:33', '2020-07-30 16:23:33', NULL),
(3, 'Noticia 2', '<div>MMMMMMMMM</div>', '/storage/postsKhuzela/1596140729download.jpg', 1, 1, 1, '2020-07-30 16:25:29', '2020-07-30 16:25:29', NULL),
(5, 'Noticia do Clube', '<div>MMMVVVCCCJJJJJHHHHH</div>', '/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,
`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;
-- --------------------------------------------------------
--
-- 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,
`product_item_id` int(10) UNSIGNED DEFAULT NULL,
`status` 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;
-- --------------------------------------------------------
--
-- 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, 2, 1, 1, '2020-06-01 22:49:37', '2020-06-01 22:49:37'),
(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, 'Normal', 900, 20, 1, 3, '2020-06-29 13:35:43', '2020-06-29 23:19:14'),
(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);
-- --------------------------------------------------------
--
-- 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..', 15, 10, 5, 2, 1, '2020-06-04 05:44:43', '2020-07-01 09:32:00'),
(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...', 1, 1, 1, '2020-07-30 13:50:33', '2020-07-30 13:50:33'),
(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);
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`id` bigint(20) UNSIGNED NOT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`email_verified_at` timestamp NULL DEFAULT NULL,
`password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`nuit` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`bi` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`picture` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`responsible_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`responsible_phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`clubs_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `phone`, `address`, `nuit`, `bi`, `picture`, `responsible_name`, `responsible_phone`, `clubs_id`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'Khuzela', 'khuzela@khuzela.com', NULL, '$2y$10$EZRltBgE4BtPh81JWJHoqOGi5K1I7FlAxkIm7pPKboUuO5WwjAwfe', '841000006', 'Khuzela Sede', '100000006', '1005515050517', '/storage/khuzela/Khuzela.png', 'Khuzela', '841000023', '10', NULL, '2020-07-30 05:24:35', '2020-07-30 06:00:13'),
(2, 'Manager', 'manager@manager.com', NULL, '$2y$10$g1webVAID0bCaQfuGAXZN.skno4X2WeN88hwxGc3Rl1LbR8vuWaqi', '841000002', 'Coop - Rua da Franca', '100000002', '1100524933300', '/storage/khuzela/149071.png', 'Admin Clube', '841000002', '1', NULL, '2020-07-30 05:24:35', '2020-07-30 06:07:13'),
(3, 'User Khuzela', 'userk@userk.com', NULL, '$2y$10$QgUw85XXFRuB9cHxFmcNZuTPJ5akO3T/wAT.APHR15pydvdv/3vhG', '841000102200000', 'Maputo', '110215154', '110155448498v', '/storage/khuzela/149071.png', 'User Khuzela', '841000102200000', '7', NULL, '2020-07-30 05:24:35', '2020-07-30 05:24:35'),
(4, 'User Clube', 'user@user.com', NULL, '$2y$10$44RdI.DhxZr7kI3YWvGui.iCfdHKj8SuGJ4wON8xAK/cqEA84uy62', '841000255533333', 'Maputo', '110022258', '110022255555c', '/storage/khuzela/149071.png', 'User Clube', '841000255533333', '2', NULL, '2020-07-30 05:24:35', '2020-07-30 05:24:35'),
(8, 'Andre', 'andre@gmail.com', NULL, '$2y$10$c2kLKzSf5Pzu4OMqrIhC5O56wkPefbcUBXn1G8fmXkb6oJ563nS5q', '841000003', 'Coop1', '100000007', '1005515050516', '/storage/khuzela/Khuzela.png', NULL, NULL, '7', NULL, '2020-05-10 01:51:48', '2020-06-04 02:25:28'),
(21, 'João Gaspar', 'jgaspar59@gmail.com', NULL, '$2y$10$4Yx8cyyK617ISZK1GmMcF.J4SdlAj462FDdrfyH6tcyBuNcYdr9Jy', '+258849113015', 'Av. Vladimir Lenine, 3071 R/C Esqº3071', '123455566', '1005515050519', '/storage/khuzela/Khuzela.png', 'João Gaspar', '+258849113015', '3', NULL, '2020-06-01 03:36:36', '2020-06-02 04:32:54'),
(22, 'João Gaspar', 'joao@jrconsuling.co.mz', NULL, '$2y$10$TVpvoxMjXLhHj6ONdtq3FeK04lPdBkiDK.DMJAzGtYMx2qiXXkB.i', '+258849113015', 'Av. Vladimir Lenine, 3071 R/C Esqº\r\n3071', '123456789', '1005515050520', '/storage/khuzela/Khuzela.png', NULL, NULL, '8', NULL, '2020-06-02 04:53:30', '2020-06-02 04:53:30'),
(23, 'Edson', 'ed@gmail.com', NULL, '$2y$10$adU6VjC4FEMdAcIvKTc.rOdIl4tWuNf7BERC39pQky2jZQoIKsa2S', '+25823323727277', 'sdsadasd', '123445567', '1005515050521', '/storage/khuzela/Khuzela.png', NULL, NULL, '3', NULL, '2020-06-02 05:13:16', '2020-06-02 05:13:16'),
(29, 'Samuel', 'samuel@gmail.com', NULL, '$2y$10$MOkj7fNFg3Rs2sTPghCpAuFmVQ4A8LWIdw4GuMAXqtJ0U8muTptSO', '+258849231169', 'Endereç Fake', '232342343', '343243423243K', '/storage/khuzela/149071.png', 'SamU', '+258849231169', '5', NULL, '2020-07-03 21:45:39', '2020-07-03 21:45:39');
--
-- 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 `members`
--
ALTER TABLE `members`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `members_email_unique` (`email`),
ADD KEY `members_documents_id_foreign` (`documents_id`),
ADD KEY `members_clubs_id_foreign` (`clubs_id`),
ADD KEY `members_cities_id_foreign` (`cities_id`);
--
-- Indexes for table `member_clubs`
--
ALTER TABLE `member_clubs`
ADD PRIMARY KEY (`id`),
ADD KEY `member_clubs_members_id_foreign` (`members_id`),
ADD KEY `member_clubs_clubs_id_foreign` (`clubs_id`);
--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `oauth_access_tokens`
--
ALTER TABLE `oauth_access_tokens`
ADD PRIMARY KEY (`id`),
ADD KEY `oauth_access_tokens_user_id_index` (`user_id`);
--
-- Indexes for table `oauth_auth_codes`
--
ALTER TABLE `oauth_auth_codes`
ADD PRIMARY KEY (`id`),
ADD KEY `oauth_auth_codes_user_id_index` (`user_id`);
--
-- Indexes for table `oauth_clients`
--
ALTER TABLE `oauth_clients`
ADD PRIMARY KEY (`id`),
ADD KEY `oauth_clients_user_id_index` (`user_id`);
--
-- Indexes for table `oauth_personal_access_clients`
--
ALTER TABLE `oauth_personal_access_clients`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `oauth_refresh_tokens`
--
ALTER TABLE `oauth_refresh_tokens`
ADD PRIMARY KEY (`id`),
ADD KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`);
--
-- Indexes for table `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 `password_resets`
--
ALTER TABLE `password_resets`
ADD KEY `password_resets_email_index` (`email`);
--
-- Indexes for table `percentagems`
--
ALTER TABLE `percentagems`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `periods`
--
ALTER TABLE `periods`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `posts`
--
ALTER TABLE `posts`
ADD PRIMARY KEY (`id`),
ADD KEY `posts_clubs_id_foreign` (`clubs_id`);
--
-- Indexes for table `post_khuzelas`
--
ALTER TABLE `post_khuzelas`
ADD PRIMARY KEY (`id`),
ADD KEY `post_khuzelas_clubs_id_foreign` (`clubs_id`);
--
-- Indexes for table `producto_categorias`
--
ALTER TABLE `producto_categorias`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `producto_subcategorias`
--
ALTER TABLE `producto_subcategorias`
ADD PRIMARY KEY (`id`),
ADD KEY `producto_subcategorias_producto_categorias_id_foreign` (`producto_categorias_id`);
--
-- Indexes for table `products`
--
ALTER TABLE `products`
ADD PRIMARY KEY (`id`),
ADD KEY `products_clubs_id_foreign` (`clubs_id`),
ADD KEY `products_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`);
--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `users_email_unique` (`email`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `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 `members`
--
ALTER TABLE `members`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;
--
-- AUTO_INCREMENT for table `member_clubs`
--
ALTER TABLE `member_clubs`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- 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_clients`
--
ALTER TABLE `oauth_clients`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- 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 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=15;
--
-- 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;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;
--
-- 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 `members`
--
ALTER TABLE `members`
ADD CONSTRAINT `members_cities_id_foreign` FOREIGN KEY (`cities_id`) REFERENCES `cities` (`id`) ON DELETE NO ACTION,
ADD CONSTRAINT `members_clubs_id_foreign` FOREIGN KEY (`clubs_id`) REFERENCES `clubs` (`id`) ON DELETE NO ACTION,
ADD CONSTRAINT `members_documents_id_foreign` FOREIGN KEY (`documents_id`) REFERENCES `documents` (`id`) ON DELETE NO ACTION;
--
-- 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;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;