-- 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
(3, 'Clube Desportivo de Maputo', 'desp@gmail.com', '845123568', 'Av. 25 de Setembro, Maputo', '111212333', '#0d0b0b', 'http://khuzeladmin.paytek-africa.com/storage/club/1599240552Grupo desportivo de Maputo.jpg', 'Ana Cordeiro', '512121443', 'maxa@gmail.com', 1, 1, '2020-05-10 09:16:08', '2020-11-17 07:53:41'),
(4, 'Clube Ferroviario de Maputo', 'cfm@gmail.com', '8412345678', 'maputo Cidade', '11021225', 'rgba(219,247,18,0.94)', 'http://khuzeladmin.paytek-africa.com/storage/club/1599240537Ferroviario Maputo.jpg', 'Carlos Pereira', '00258841245451', 'carlos@gmail.com', 15, 1, '2020-05-11 22:00:22', '2020-09-04 15:28:57'),
(5, 'Clube Costa do Sol', 'info@costadosol.co.mz', '821605322', 'Maputo, Costa do Sol', '111011616', 'rgba(246,241,0,0.98)', 'http://khuzeladmin.paytek-africa.com/storage/club/CD_Costa_do_Sol.png', 'Amade Momed', '841221516', 'amade@gmail.com', 1, 1, '2020-05-11 23:02:25', '2020-09-04 15:37:12'),
(6, 'Clube Maxaquene', 'maxa@gmail.com', '845121619', 'Maxaquene', '10205121', '#f21001', 'http://khuzeladmin.paytek-africa.com/storage/club/download (4).jpeg', 'Fariah Momed', '845121619', 'faria@gmail.com', 2, 1, '2020-05-11 23:15:03', '2020-08-17 11:21:46'),
(8, 'Sport Lisboa e Benfica', 'slb@benfica.pt', '+25884512', 'Lisboa Portugual', '10005116', '#fa0000', 'http://khuzeladmin.paytek-africa.com/storage/club/1599059227slb.png', 'Luis Filipe Vieira', '21554664', 'lfv@hotmail.com', 15, 1, '2020-05-14 09:03:06', '2020-09-02 13:07:07'),
(9, 'Khuzela', 'khuzela@khuzela.com', '840000000000000', 'Maputo', '100000000', '#ff2e00', 'http://khuzeladmin.paytek-africa.com/storage/club/1599240580Khuzela.jpeg', 'Khuzela', 'null', 'null', 15, 1, '2020-06-15 16:22:26', '2020-09-04 15:29:40'),
(10, 'FC Porto', 'clube@clube.com', '840051580022255', 'Maputo, Bairro do Jardim, Rua das Dalias,', '110002558', '#e8400a', 'http://khuzeladmin.paytek-africa.com/storage/club/download.png', 'Manueal Almeida', NULL, NULL, 15, 1, '2020-06-16 03:18:36', '2020-06-16 03:18:36'),
(13, 'Sporting Clube de Portugal', 'a@gmail.conm', '432432423', 'Lisboa', '432432432', '#40c735', 'http://khuzeladmin.paytek-africa.com/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');

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

--
-- 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, 'Vermelho', '01', '2020-07-30 07:30:51', '2020-07-30 07:30:51'),
(2, 'Branco', '02', '2020-07-30 07:30:51', '2020-07-31 11:28:42'),
(3, 'Amarelo', '03', '2020-07-30 07:30:51', '2020-07-30 07:30:51'),
(4, 'Verde', '04', '2020-07-30 07:30:51', '2020-07-30 07:30:51'),
(5, 'Cinza', '05', '2020-07-30 07:30:51', '2020-07-30 07:30:51'),
(6, 'Laranja', '06', '2020-07-30 07:30:51', '2020-07-30 07:30:51'),
(7, 'Violeta', '07', '2020-07-30 07:30:51', '2020-07-30 07:30:51'),
(8, 'Preto', '08', '2020-07-30 07:30:51', '2020-07-30 07:30:51'),
(9, 'Encarnado', '09', '2020-07-30 07:30:51', '2020-07-30 07:30:51'),
(10, 'Azul Celeste', '10', '2020-07-30 07:30:51', '2020-07-30 07:30:51'),
(11, 'Rosa', '11', '2020-07-30 07:30:51', '2020-07-30 07:30:51'),
(12, 'Castanho', '12', '2020-07-30 07:30:51', '2020-07-30 07:30:51'),
(13, 'Creme', '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;

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

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

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

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

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

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

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

--
-- 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,
  `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 `orders`
--

CREATE TABLE `orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `quantity` int(11) NOT NULL,
  `amount` double NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'success',
  `product_item_id` int(10) UNSIGNED NOT NULL,
  `product_id` int(10) UNSIGNED NOT NULL,
  `size_id` int(10) UNSIGNED DEFAULT NULL,
  `member_id` int(11) 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 `orders`
--

INSERT INTO `orders` (`id`, `quantity`, `amount`, `status`, `product_item_id`, `product_id`, `size_id`, `member_id`, `created_at`, `updated_at`) VALUES
(19, 2, 850, 'pending', 19, 21, 3, 32, '2020-09-14 09:57:41', '2020-09-14 09:57:41'),
(20, 1, 0, 'pending', 0, 0, 0, 32, '2020-09-25 08:25:19', '2020-09-25 08:25:19'),
(21, 1, 0, 'pending', 0, 0, 0, 57, '2020-11-17 08:00:48', '2020-11-17 08:00:48'),
(22, 2, 1200, 'pending', 17, 19, 3, 57, '2020-11-17 08:00:58', '2020-11-17 08:00:58');

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

--
-- 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', 'http://khuzeladmin.paytek-africa.com/storage/partner/3d62773a421755449d8a32e8dbc0a9f9.jpeg', 'Ana Cordeiro', '8454555151515', 'galp@mz.com', 4, '2020-07-30 15:09:09', '2020-08-10 14:09:14'),
(2, 'Linhas Aerias de Mocambique', 'LAM', 841220121121221, 'Maputo', '111002222', 'http://khuzeladmin.paytek-africa.com/storage/partner/images (9).png', NULL, NULL, NULL, 1, '2020-07-30 21:09:59', '2020-07-30 21:09:59'),
(3, 'Bombas de Combustivel Total', 'Bombas de Combustivel', 84512356000000, 'Av. Vladimir Lenine', '111201265', 'http://khuzeladmin.paytek-africa.com/storage/partner/1598386174stop-sign-hand-512.png', 'Amade Machava', '845151617886', 'maxa@gmail.com', 1, '2020-05-10 10:58:14', '2020-08-25 18:09:34'),
(4, 'Loja Adidas', 'Loja de Equipamentos Desportivos', 8451268, 'Av. Vladimir Lenine - Maputo Shopping', '125545', 'http://khuzeladmin.paytek-africa.com/storage/partner/1598386187imageedit_11_6024129081.png', 'Joao Gaspar', '+258849113015', 'jgaspar59@gmail.com', 1, '2020-05-24 20:44:33', '2020-08-25 18:09:47'),
(5, 'Mafalala Cervejas SA', 'Parceiro Ouro', 258843015752, 'Rua da DNEP 843', '400942978', 'http://khuzeladmin.paytek-africa.com/storage/partner/images (11).jpeg', 'Helder Buvana', '+258843015752', 'buvahe@yahoo.com.br', 1, '2020-06-30 11:59:12', '2020-10-20 15:12:19');

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

--
-- 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 07:48:49', '2020-07-30 07:48:49'),
(2, 'Trimestral', '2020-07-30 07:48:49', '2020-07-30 07:48:49'),
(3, 'Semestral', '2020-07-30 07:48:50', '2020-07-30 07:48:50'),
(4, 'Anual', '2020-07-30 07:48:50', '2020-07-30 07:48:50');

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

--
-- 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 do Clube', 'http://localhost:8000/storage/posts/1596153230bruno.jpg', 'active', 'all', 0, 1, 0, 2, 4, '2020-07-30 17:53:50', '2020-07-30 17: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', 'active', 'all', 0, 1, 0, 2, 4, '2020-05-28 03:42:18', '2020-06-29 20:59:04'),
(3, 'Noticia do Clube das Mahotas', 'Publicacao de Publicidade da marca patrocinadora dos nossos enventos...', 'http://localhost:8000/storage/posts/1591227422maxresdefault.jpg', 'active', 'all', 0, 1, 0, 2, 5, '2020-06-03 15:37:02', '2020-06-03 15: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', 'active', 'all', 0, 1, 0, 2, 4, '2020-06-01 04:07:24', '2020-06-29 20: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', 'active', 'all', 0, 1, 0, 2, 4, '2020-06-02 06:17:51', '2020-06-02 06:17:51'),
(6, 'Noticia da semana', 'Edes', 'http://localhost:8000/storage/posts/1593492667download (1).png', 'active', 'all', 0, 1, 0, 2, 9, '2020-06-29 20:51:07', '2020-06-29 20:51:07'),
(7, 'Noticia de Teste', 'Teste', 'http://localhost:8000/storage/posts/1593984009etd1ottxsaaryhi-780x520.jpg', 'active', 'all', 0, 1, 0, 2, 9, '2020-07-05 13:20:09', '2020-07-05 13:20:09'),
(8, 'Sonho da Champions inícia em Novembro', 'Noticia.... Teste', 'http://localhost:8000/storage/posts/1596153230bruno.jpg', 'active', 'all', 0, 1, 0, 2, 4, '2020-07-30 17:53:50', '2020-07-30 17:53:50'),
(9, 'Ferroviário de Maputo apresenta o seu Plantel para a epoca 2020/21', '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', 'active', 'all', 0, 1, 0, 2, 4, '2020-05-28 03:42:18', '2020-06-29 20:59:04'),
(10, 'Sporting Clube de Portugal no mercado', 'Publicacao de Publicidade da marca patrocinadora dos nossos enventos...', 'http://localhost:8000/storage/posts/1591227422maxresdefault.jpg', 'active', 'all', 0, 1, 0, 2, 4, '2020-06-03 15:37:02', '2020-06-03 15:37:43'),
(11, 'MANCHESTER UNITED E SEVILHA NO LEILÃO POR ALEX TELLES', 'Grande golo do Bruno Fernandes neste fim de semana no classico Benfica Sporting.', 'http://localhost:8000/storage/posts/bruno.jpg', 'active', 'all', 0, 1, 0, 2, 9, '2020-06-01 04:07:24', '2020-06-29 20:59:35'),
(12, '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', 'active', 'all', 0, 1, 0, 2, 1, '2020-06-02 06:17:51', '2020-06-02 06:17:51'),
(13, 'Exemplo', 'Edes', 'http://localhost:8000/storage/posts/1593492667download (1).png', 'active', 'all', 0, 1, 0, 2, 4, '2020-06-29 20:51:07', '2020-06-29 20:51:07'),
(14, 'Noticia de Teste', 'Teste', 'http://localhost:8000/storage/posts/1593984009etd1ottxsaaryhi-780x520.jpg', 'active', 'all', 0, 1, 0, 2, 10, '2020-07-05 13:20:09', '2020-07-05 13:20:09');

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

--
-- Table structure for table `post_comments`
--

CREATE TABLE `post_comments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `comment` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `member_id` int(10) UNSIGNED DEFAULT NULL,
  `post_id` int(11) 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 `post_comments`
--

INSERT INTO `post_comments` (`id`, `comment`, `status`, `member_id`, `post_id`, `created_at`, `updated_at`) VALUES
(1, 'wow que optimo', 'active', 22, 2, '2020-08-03 11:35:37', '2020-08-03 11:35:37'),
(2, 'Temos que melhorar a equipa', 'active', 22, 2, '2020-08-03 11:38:12', '2020-08-03 11:38:12'),
(3, 'data', 'active', 22, 2, '2020-08-03 11:58:35', '2020-08-03 11:58:35'),
(4, 'teste de comentario', 'active', 21, 2, '2020-08-03 12:29:09', '2020-08-03 12:29:09'),
(5, 'adicionar um comentário neste espaço muito pequeno', 'active', 24, 2, '2020-08-03 13:06:21', '2020-08-03 13:06:21'),
(6, 'vou fazer um comentário muito grande para ver como fica neste espaço e depois se e possível fazer scroll para baixo e para cima. vamos ver como fica para depois melhorar se for possível.', 'active', 21, 2, '2020-08-03 14:04:53', '2020-08-03 14:04:53'),
(7, 'gjf', 'active', 22, 2, '2020-08-06 08:54:10', '2020-08-06 08:54:10'),
(8, 'hdhcj', 'active', 22, 2, '2020-08-06 09:15:55', '2020-08-06 09:15:55'),
(9, 'Testando o comentário', 'active', 22, 2, '2020-08-06 09:18:12', '2020-08-06 09:18:12'),
(10, 'Vamos testar', 'active', 22, 1, '2020-08-07 07:50:13', '2020-08-07 07:50:13'),
(11, 'gosto mais deste estilo embora o campo seja pequeno. vai crescendo a medida que escrevemos mais texto. \n\nassim está bom.😁', 'active', 21, 2, '2020-08-07 08:46:59', '2020-08-07 08:46:59'),
(12, 'Realmente está bom este campo.', 'active', 22, 2, '2020-08-07 09:22:33', '2020-08-07 09:22:33'),
(13, 'Acabo criar uma conta, como faço para ser um sócio do clube?', 'active', 31, 2, '2020-08-10 10:35:16', '2020-08-10 10:35:16'),
(14, 'Teste de comentario', 'active', 22, 1, '2020-09-02 10:31:19', '2020-09-02 10:31:19'),
(15, 'Já terminamos :)', 'active', 22, 2, '2020-09-02 12:36:59', '2020-09-02 12:36:59'),
(16, 'ops', 'active', 32, 2, '2020-11-24 08:59:33', '2020-11-24 08:59:33');

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

--
-- 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` text 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
(7, 'Sonho da Champions inícia em Novembro', '<p><span>E o Costa do Sol vai disputar o acesso a fase de grupos da Liga dos Campe&#245;es.</span></p>', 'http://khuzeladmin.paytek-africa.com/storage/postsKhuzela/1599241496costa do sol imagem 1.jpg', 1, 0, 3, '2020-09-04 15:44:56', '2020-09-08 10:40:33', NULL),
(8, 'Teste do Covid-19', '<span>O plantel do Clube de Desportos da Costa do Sol, realizou na manh&#227; desta segunda-feira, o teste da Covid-19, no hospital provincial da Matola. </span>', 'http://khuzeladmin.paytek-africa.com/storage/postsKhuzela/1599248923118406377_3620565357968395_542609756944249959_o.jpg', 1, 0, 3, '2020-09-04 17:48:43', '2020-09-08 10:40:47', NULL),
(9, 'Do reforço ao riscado, eis o ponto de situação dos \'matadores\' de Jesus', '<h2 class=\"news-subheadline\"><font face=\"Calibri\">Primeiro jogo da nova &#233;poca aproxima-se, mas ainda pairam muitas d&#250;vidas na frente de ataque do Benfica.</font></h2><div><span class=\"news_capital_letter\"><font face=\"Calibri\"><br></font></span><font face=\"Calibri\"><span>O jovem uruguaio Darwin&#160;</span><span class=\"nanospell-typo\">N&#250;&#241;ez</span><span>,&#160;</span><a href=\"https://www.noticiasaominuto.com/desporto/1576800/desacordo-entre-clubes-adiou-apresentacao-de-darwin-nunez-no-benfica\" target=\"_blank\">cuja apresenta&#231;&#227;o formal como refor&#231;o do Benfica foi adiada</a><span>, &#233; a primeira contrata&#231;&#227;o, na nova era de Jorge Jesus na Luz, para a posi&#231;&#227;o mais adiantada do terreno de jogo, na qual, ali&#225;s, existem muitas d&#250;vidas numa altura em que faltam pouco mais de 10 dias para o primeiro jogo da temporada, ante o&#160;</span><span class=\"nanospell-typo\">PAOK</span><span>, referente &#224; 3.&#170; pr&#233;-eliminat&#243;ria&#160;da Liga dos Campe&#245;es.&#160;</span></font><br></div>', 'http://khuzeladmin.paytek-africa.com/storage/postsKhuzela/1599576799naom_5f50f2500033d.jpg', 1, 0, 8, '2020-09-08 12:53:19', '2020-09-08 12:53:19', NULL),
(10, 'Ferroviário de Maputo apresenta o seu Plantel para a epoca 2020/21', '<p class=\"MsoNormal\"><span lang=\"PT\">Com o in&#237;cio da &#233;poca 2020 / 21 marcada j&#225; para o in&#237;cio do ano. O clube Ferrovi&#225;rio&#10;de Maputo apresentou o seu novo plantel para a luta da Liga Mo&#231;ambicana de&#10;Futebol.</span></p>', 'http://khuzeladmin.paytek-africa.com/storage/postsKhuzela/1599577215img001420-398-20190723-072526.jpg', 1, 0, 4, '2020-09-08 13:00:15', '2020-09-08 13:00:15', NULL),
(11, 'Maxaquene prepara com muita força o próximo jogo', '<p class=\"MsoNormal\"><span lang=\"PT\">Maxaquene prepara com muita for&#231;a o pr&#243;ximo jogo, depois de golear em pleno&#10;est&#225;dio do Zimpeto a equipa de Clube de Chibuto.</span></p>', 'http://khuzeladmin.paytek-africa.com/storage/postsKhuzela/1599577580MAXAQUENE(1).jpg', 1, 0, 6, '2020-09-08 13:06:20', '2020-09-08 13:06:20', NULL),
(13, 'Sporting Clube de Portugal no mercado', '<p><span lang=\"PT\">O lateral esquerdo portugu&#234;s Antunes e o&#10;defesa direito espanhol Pedro Porro v&#227;o refor&#231;ar o Sporting.</span></p>&#10;&#10;<span lang=\"PT\">O experiente Antunes, de 33 anos, chegou ao Sporting como jogador livre,&#10;depois de ter rescindido o contracto com o Getafe.</span>', 'http://khuzeladmin.paytek-africa.com/storage/postsKhuzela/1599578233img_920x518$2020_08_15_19_43_18_1740821.jpg', 1, 0, 13, '2020-09-08 13:17:13', '2020-09-08 13:17:13', NULL),
(14, 'MANCHESTER UNITED E SEVILHA NO LEILÃO POR ALEX TELLES', '<p>Representantes de Alex Telles est&#227;o em Manchester por estes dias a intensificar esfor&#231;os no sentido de levar o neg&#243;cio a bom porto.</p><p>&#160;</p><p>Atento a tudo isto est&#225; o Sevilha, apesar de, neste instante, para a posi&#231;&#227;o de lateral-esquerdo a mira do conjunto treinado por Julen Lopetegui estar mais apontada na dire&#231;&#227;o de Acu&#241;a, do Sporting, que pede pelo seu jogador um valor bastante mais acess&#237;vel aos cofres sevilhanos - algures entre 10 e 15 milh&#245;es de euros.</p>', 'http://khuzeladmin.paytek-africa.com/storage/postsKhuzela/1599578511naom_5e530b7b1069a.jpg', 1, 0, 10, '2020-09-08 13:21:51', '2020-09-08 13:21:51', NULL),
(15, 'Desportivo de Maputo, aposta forte no mercado.', '<p><span lang=\"PT\">Desportivo de Maputo, aposta forte no mercado&#10;e refor&#231;a equipa para concorrer com os grandes do Futebol Mo&#231;ambicano.</span></p>', 'http://khuzeladmin.paytek-africa.com/storage/postsKhuzela/15995787278cb6d515-e02e-49eb-bcc9-4789cabb1dad.jpg', 1, 0, 3, '2020-09-08 13:25:27', '2020-09-08 13:25:27', NULL),
(16, 'Costa do Sol autorizado a regressar aos treinos', '<p><span>O Costa do Sol campe&#227;o nacional em t&#237;tulo, e que vai representar o pa&#237;s nas competi&#231;&#245;es africanas em futebol, est&#225; autorizado a regressar aos treinos. A informa&#231;&#227;o foi avan&#231;ada pelo Secret&#225;rio de Estado do Desporto, Gilberto Mendes.</span></p><p>&#34;O Costa do Sol e a Uni&#227;o Desportiva de Songo em futebol porque t&#234;m compromissos internacionais, foram autorizados a voltar a treinar&#34; disse Gilberto Mendes.</p><p></p><p>Os campe&#245;es nacionais apesar de estarem autorizados a voltar aos treinos, j&#225; foram alvos de inspec&#231;&#257;o por parte da equipa multissetorial que t&#234;m feito vistoria dos clubes do Mo&#231;ambola com vista o regresso aos treinos.</p><p></p><p>O Costa do Sol, vai disputar as eliminat&#243;rias de acesso a fase de grupos da Liga dos Campe&#245;es Africanos.</p>', 'http://khuzeladmin.paytek-africa.com/storage/postsKhuzela/1600784610img000714-279-20200809-103842.jpg', 1, 0, 5, '2020-09-22 12:23:30', '2020-09-22 12:23:30', NULL),
(17, 'Campo do Costa do Sol recebe nota máxima', '<p><span>O Costa do Sol, recebeu esta sexta-feira nota m&#225;xima, por parte dos inspectores do MISAU, SED, INAE, pelas condi&#231;&#245;es sanit&#225;rias criadas para responder ao protocolo de preven&#231;&#227;o da covid-19.</span></p><p>Os campe&#245;es nacionais que hoje foram visitados pela segunda vez pela equipa multisectorial surpreenderam pela positiva, tendo cumprido todas as recomenda&#231;&#245;es deixadas a quando da primeira inspe&#231;&#227;o.</p><p></p><p>Reunidas as condi&#231;&#245;es a equipa principal de futebol poder&#225; regressar aos treinos na pr&#243;xima semana para preparar as eliminat&#243;rias de acesso a fase de grupos da Liga dos Campe&#245;es Africanos e o Mo&#231;ambola (ainda sem data para o arranque).</p><p></p><p>Os&#160;<i>canarinhos</i>&#160;que logo na entrada para o seu campo colocaram tanques para a lavagem das m&#227;os com &#225;gua e sab&#227;o e foi colocado o pedil&#250;vio para a desinfec&#231;&#227;o dos p&#233;s. A Dire&#231;&#227;o do clube com mais t&#237;tulos no pa&#237;s, tamb&#233;m criou condi&#231;&#245;es para a exist&#234;ncia de uma sala de isolamento para eventuais casos de atletas contaminados, os balne&#225;rios est&#227;o com os cacifos perfeitamente identificados para que os jogadores coloquem as suas mochilas.</p><p></p><p>No campo onde os atletas v&#227;o realizar os treinos foram colocados cestos com nomes de cada atleta, onde ser&#227;o colocadas as m&#225;scaras e outros pertences de cada jogador.</p>', 'http://khuzeladmin.paytek-africa.com/storage/postsKhuzela/1600784720img000718-280-20200814-135805.jpg', 1, 0, 5, '2020-09-22 12:25:20', '2020-09-22 12:25:20', NULL),
(18, 'Nova APP Khuzela para clubes', 'Esta dispon&#237;vel uma nova APP Para Khuzela.&#160;', 'http://khuzeladmin.paytek-africa.com/storage/postsKhuzela/1605608668Africa.jpg', 1, 0, 9, '2020-11-17 08:24:28', '2020-11-17 08:24:28', 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, 'Equipamentos', '01', 'NULL', '2020-07-30 07:26:31', '2020-08-27 10:12:30'),
(2, 'Bola', '02', 'NULL', '2020-07-30 07:26:36', '2020-08-31 11:24:04'),
(3, 'Carteira', '03', 'NULL', '2020-07-30 07:26:41', '2020-08-31 11:24:23'),
(4, 'Camisetes', '04', 'NULL', '2020-07-30 07:26:45', '2020-08-27 10:22:52'),
(5, 'Bandeiras', '05', 'NULL', '2020-07-30 07:26:50', '2020-08-31 11:24:49'),
(6, 'Relogios', '06', 'NULL', '2020-07-30 07:26:54', '2020-08-31 11:25:37'),
(7, 'Cachecóis', '07', 'NULL', '2020-07-30 07:26:59', '2020-08-31 11:26:26'),
(8, 'Porta-Chaves', '08', 'NULL', '2020-07-30 07:27:04', '2020-08-31 11:26:57'),
(9, 'Chapeos e Gorros', '09', 'NULL', '2020-07-30 07:27:09', '2020-08-31 11:27:30'),
(10, 'Toalhas', '10', 'NULL', '2020-07-30 07:27:13', '2020-08-31 11:27:50'),
(11, 'Bijoteria', '11', 'NULL', '2020-07-30 07:27:22', '2020-08-31 11:28:11'),
(12, 'Institucional', '12', 'NULL', '2020-07-30 18:55:02', '2020-08-31 11:29:03');

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

--
-- 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
(14, 'Bola de Futebol', '01', '1', 2, '2020-09-04 16:46:35', '2020-09-04 16:46:35'),
(15, 'Carteira Escolar', '15', '1', 3, '2020-09-04 16:47:54', '2020-09-04 16:47:54'),
(16, 'Carteira Porta-cartões em Pele Preta', '16', '1', 3, '2020-09-04 16:48:27', '2020-09-04 16:48:27'),
(17, 'Camiseta do Clube', '17', '1', 4, '2020-09-04 16:49:27', '2020-09-04 16:49:27'),
(18, 'Camiseta de Treino', '18', '1', 4, '2020-09-04 16:49:44', '2020-09-04 16:49:44'),
(19, 'Bandeira Lista', '19', '1', 5, '2020-09-04 16:50:21', '2020-09-04 16:50:21'),
(20, 'Bandeira Stromp', '20', '1', 5, '2020-09-04 16:50:40', '2020-09-04 16:50:40'),
(21, 'Relogio / Bracelete Preto', '21', '1', 6, '2020-09-04 16:51:44', '2020-09-04 16:51:44'),
(22, 'Relógio Pulso Preto', '22', '1', 6, '2020-09-04 16:52:21', '2020-09-04 16:52:21'),
(23, 'Cachecol Efeito Tricotado', '23', '1', 7, '2020-09-04 16:53:49', '2020-09-04 16:53:49'),
(24, 'Cachecol Listado', '24', '1', 7, '2020-09-04 16:54:10', '2020-09-04 16:54:10'),
(25, 'Cachecol Listado Logo Bordado', '25', '1', 7, '2020-09-04 16:54:47', '2020-09-04 16:54:47'),
(26, 'Porta-chaves em Pele', '26', '1', 8, '2020-09-04 16:55:46', '2020-09-04 16:55:46'),
(27, 'Porta-Chaves Emblema do Clube', '27', '1', 8, '2020-09-04 16:56:05', '2020-09-04 16:56:05'),
(28, 'Porta-Chaves Camisola de Metal', '28', '1', 8, '2020-09-04 16:56:20', '2020-09-04 16:56:20'),
(29, 'Cap Monograma Cinza', '29', '1', 9, '2020-09-04 16:58:01', '2020-09-04 16:58:01'),
(30, 'Gorro Mescla', '30', '1', 9, '2020-09-04 16:58:20', '2020-09-04 16:58:20'),
(31, 'Toalha de Praia', '31', '1', 10, '2020-09-04 16:58:59', '2020-09-04 16:58:59'),
(32, 'Pulseira de Silicone', '32', '1', 11, '2020-09-04 17:13:48', '2020-09-04 17:13:48'),
(33, 'Autocolante do Clube', '33', '1', 12, '2020-09-04 17:14:46', '2020-09-04 17:14:46');

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

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

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

INSERT INTO `products` (`id`, `title`, `product_code`, `statuses_id`, `description`, `visible`, `image`, `clubs_id`, `product_category_id`, `subcategorias_id`, `created_at`, `updated_at`) VALUES
(19, 'Camisola Principal', '0001', 1, 'Camisola Principal do Clube', 'MNA', 'http://khuzeladmin.paytek-africa.com/storage/storage/productsKhuzela/1599247094download.jpeg', 5, 4, 17, '2020-09-04 17:18:14', '2020-11-06 12:42:07'),
(20, 'Bola do Clube', '0020', 1, 'Bola Persolanizada com as Cores do Clube', 'MNA', 'http://khuzeladmin.paytek-africa.com/storage/storage/productsKhuzela/1599247278cw4170-bola-de-futebol-adidas-glider-tam-5-branca-aamarela-azul-e-preta.jpg', 5, 2, 14, '2020-09-04 17:21:18', '2020-11-17 07:07:17'),
(21, 'Bola de Treino', '0021', 1, 'Bola do Clube para treino', 'NMNAK', 'http://khuzeladmin.paytek-africa.com/storage/storage/productsKhuzela/159924783638601_bola-adidas-glider-preta-e-branca_m1_636857418842930881.jpg', 3, 2, 14, '2020-09-04 17:30:36', '2020-09-04 17:30:36'),
(22, 'Cachecol do Clube', '0022', 1, 'Cachecol com sibolo do Clube  Tricotado', 'MNAK', 'http://khuzeladmin.paytek-africa.com/storage/storage/productsKhuzela/1599248292thumb-816x460-2d6e5b6c4159e84b078b18b.desktop-gallery-large.jpg', 3, 7, 23, '2020-09-04 17:38:12', '2020-09-04 17:38:12'),
(23, 'Cachecol do Clube', '0023', 1, 'Cachecol com sibolo do Clube  Tricotado', 'MNAK', 'http://khuzeladmin.paytek-africa.com/storage/storage/productsKhuzela/1599248292thumb-816x460-2d6e5b6c4159e84b078b18b.desktop-gallery-large.jpg', 4, 7, 23, NULL, NULL),
(24, 'Bola de Andebol', '0024', 1, 'Bola de Andebol', 'MNAK', 'http://khuzeladmin.paytek-africa.com/storage/storage/productsKhuzela/16062025051.PNG', 5, 2, 14, '2020-11-24 05:21:45', '2020-11-24 05:21:45'),
(25, 'Camisola Principal', '0025', 1, 'Camisola Principal Ferroviario', 'NMNAK', 'http://khuzeladmin.paytek-africa.com/storage/storage/productsKhuzela/16062031272.2.PNG', 4, 4, 17, '2020-11-24 05:32:07', '2020-11-24 05:32:07');

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

--
-- 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,
  `visible` varchar(191) COLLATE utf8mb4_unicode_ci 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;

--
-- Dumping data for table `product_items`
--

INSERT INTO `product_items` (`id`, `name`, `description`, `product_code`, `quant_min`, `quant_total`, `visible`, `price`, `color_id`, `product_id`, `size_id`, `statuses_id`, `created_at`, `updated_at`) VALUES
(17, 'null', 'null', '041703030001', 5, 20, 'MNA', 1250, 3, 19, 3, 1, '2020-09-04 17:24:04', '2020-11-17 08:17:44'),
(18, 'null', 'null', '020103030018', 25, 100, 'NMNAK', 900, 3, 20, 3, 1, '2020-09-04 17:25:19', '2020-09-04 17:25:19'),
(19, 'null', 'null', '020103080019', 20, 100, 'MNA', 850, 8, 21, 3, 1, '2020-09-04 17:31:29', '2020-09-04 17:31:29'),
(20, 'null', 'null', '072305020020', 20, 100, 'MNAK', 250, 2, 22, 5, 1, '2020-09-04 17:39:07', '2020-09-04 17:39:07'),
(21, 'null', 'null', '041703030021', 2, 20, 'NMNAK', 500, 3, 25, 3, 1, '2020-11-24 05:34:22', '2020-11-24 05:34:22');

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

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

--
-- Dumping data for table `product_item_images`
--

INSERT INTO `product_item_images` (`id`, `image`, `status`, `product_item_id`, `description`, `created_at`, `updated_at`) VALUES
(61, 'http://khuzeladmin.paytek-africa.com/storage/storage/productsKhuzela/1599247519cw4170-bola-de-futebol-adidas-glider-tam-5-branca-aamarela-azul-e-preta-d2.jpg', '1', 18, 'null', '2020-09-04 17:25:19', '2020-09-04 17:25:19'),
(62, 'http://khuzeladmin.paytek-africa.com/storage/storage/productsKhuzela/1599247519cw4170-bola-de-futebol-adidas-glider-tam-5-branca-aamarela-azul-e-preta-d4.jpg', '1', 18, 'null', '2020-09-04 17:25:19', '2020-09-04 17:25:19'),
(63, 'http://khuzeladmin.paytek-africa.com/storage/storage/productsKhuzela/159924788938601_bola-adidas-glider-preta-e-branca_m4_636857418891640486.jpg', '1', 19, 'null', '2020-09-04 17:31:29', '2020-09-04 17:31:29'),
(64, 'http://khuzeladmin.paytek-africa.com/storage/storage/productsKhuzela/159924788938601_bola-adidas-glider-preta-e-branca_m1_636857418842930881.jpg', '1', 19, 'null', '2020-09-04 17:31:29', '2020-09-04 17:31:29'),
(65, 'http://khuzeladmin.paytek-africa.com/storage/storage/productsKhuzela/1599248347thumb-816x460-2d6e5b6c4159e84b078b18b.desktop-gallery-large.jpg', '1', 20, 'null', '2020-09-04 17:39:07', '2020-09-04 17:39:07'),
(66, 'http://khuzeladmin.paytek-africa.com/storage/storage/productsKhuzela/16056083051269624913Adg3d3.jpg', '1', 17, 'null', '2020-11-17 08:18:25', '2020-11-17 08:18:25'),
(67, 'http://khuzeladmin.paytek-africa.com/storage/storage/productsKhuzela/1605608305Africa.jpg', '1', 17, 'null', '2020-11-17 08:18:25', '2020-11-17 08:18:25'),
(68, 'http://khuzeladmin.paytek-africa.com/storage/storage/productsKhuzela/1605608305alfa romeo.jpg', '1', 17, 'null', '2020-11-17 08:18:25', '2020-11-17 08:18:25'),
(69, 'http://khuzeladmin.paytek-africa.com/storage/storage/productsKhuzela/160620326232.PNG', '1', 21, 'null', '2020-11-24 05:34:22', '2020-11-24 05:34:22');

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

--
-- 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, 'Socio normal', 150, 2, 1, 5, '2020-09-22 12:27:46', '2020-11-17 07:55:33'),
(2, 'Socio Loco - Platina', 2000, 31, 1, 4, '2020-10-20 15:01:13', '2020-10-20 15:06:17'),
(3, 'Socio Loco Bronze', 100, 31, 1, 4, '2020-10-20 15:02:31', '2020-10-20 15:07:22'),
(4, 'Socio Loco Prata', 300, 31, 1, 4, '2020-10-20 15:03:58', '2020-10-20 15:03:58'),
(5, 'Socio Loco - Ouro', 1000, 31, 1, 4, '2020-10-20 15:04:52', '2020-10-20 15:04:52'),
(6, 'Ouro', 750, 1, 1, 5, '2020-11-17 07:55:10', '2020-11-17 07:55:10');

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

--
-- 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 07:24:35', '2020-07-30 07:24:35'),
(2, 'manager', 'Administrador Clube', '2020-07-30 07:24:35', '2020-07-30 07:24:35'),
(3, 'user', 'Utilizador Khuzela', '2020-07-30 07:24:35', '2020-07-30 07:24:35'),
(4, 'userClube', 'Utilizador Clube', '2020-07-30 07:24:35', '2020-07-30 07:24:35');

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

--
-- 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),
(3, 3, 3, NULL, NULL),
(13, 4, 6, '2020-07-30 21:20:29', '2020-07-30 21:20:29'),
(14, 2, 21, NULL, NULL),
(15, 1, 30, NULL, NULL),
(19, 1, 34, 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, 'Passagens', 'Desconto em passagens aereas para clubes associados', 1, 2, 3, 2, 3, '2020-11-06 12:34:57', '2020-11-06 12:34:57'),
(2, 'Combustiveis', 'Desconto de 3 meticais por litro de combustível para o sócio do clube.\n2 Meticais por litro para o clube onde o socio está fidelizado\n1 Metical por litro para a Khuzela..', 1, 2, 3, 1, 1, '2020-11-06 12:36:45', '2020-11-21 17:15:55'),
(3, 'Oleos', 'Desconto de 7% para o socio do clube, 3% para o clube e 1% para a Khuzela em compras de oleos Galp', 1, 3, 7, 1, 3, '2020-11-06 12:37:45', '2020-11-06 12:37:45'),
(4, 'Promoção Mafalala', 'Desconto de 5 Mzn por garrafa de 33cl para o socio, 2Mzn para o clube e 1Mzn para Khuzela.', 1, 2, 5, 5, 1, '2020-11-06 12:39:05', '2020-11-06 12:39:05'),
(5, 'Equipamentos', 'Desconto de 13% na compra de produtos ADIDAS nas lojas oficiais. 10% para o socio, 2% para o clube e 1% para Khuzela.', 1, 2, 10, 4, 3, '2020-11-06 12:39:59', '2020-11-06 12:39:59');

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

--
-- 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, 'Descontos em combustiveis GALP', 5, 2, 1, '2020-11-06 12:40:37', '2020-11-17 08:12:28'),
(2, 'Descontos em equipamentos ADIDAS', 5, 5, 34, '2020-11-06 12:41:12', '2020-11-06 12:41:12'),
(3, 'Serviço galp e costa do sol', 5, 3, 1, '2020-11-20 14:03:30', '2020-11-20 14:03:30');

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

--
-- 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_members_id_foreign` (`members_id`),
  ADD KEY `member_clubs_clubs_id_foreign` (`clubs_id`);

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

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

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

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  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 `clubs_id` (`clubs_id`);

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

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

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

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

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `products_clubs_id_foreign` (`clubs_id`),
  ADD KEY `products_subcategorias_id_foreign` (`subcategorias_id`),
  ADD KEY `product_category_id` (`product_category_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=14;

--
-- 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 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 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 for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=127;

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

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

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

--
-- AUTO_INCREMENT for table `partners`
--
ALTER TABLE `partners`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=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=15;

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

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

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

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

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

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

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

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

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

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

