-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Tempo de geração: 19-Fev-2026 às 20:35
-- Versão do servidor: 8.2.0
-- versão do PHP: 8.2.13

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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 */;

--
-- Banco de dados: `donamarmita2026`
--

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

--
-- Estrutura da tabela `banners`
--

DROP TABLE IF EXISTS `banners`;
CREATE TABLE IF NOT EXISTS `banners` (
  `ban_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `ban_type` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ban_img` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ban_txt1_pt` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ban_txt2_pt` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ban_txt3_pt` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ban_txt4_pt` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ban_txt5_pt` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ban_txt1_en` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ban_txt2_en` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ban_txt3_en` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ban_txt4_en` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ban_txt5_en` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ban_txt1_es` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ban_txt2_es` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ban_txt3_es` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ban_txt4_es` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ban_txt5_es` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ban_txt1_fr` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ban_txt2_fr` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ban_txt3_fr` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ban_txt4_fr` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ban_txt5_fr` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ban_link` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ban_sort` int NOT NULL DEFAULT '0',
  `ban_text_position` enum('left','center','right') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'left',
  `ban_visible` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`ban_id`),
  KEY `banners_ban_type_index` (`ban_type`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Extraindo dados da tabela `banners`
--

INSERT INTO `banners` (`ban_id`, `ban_type`, `ban_img`, `ban_txt1_pt`, `ban_txt2_pt`, `ban_txt3_pt`, `ban_txt4_pt`, `ban_txt5_pt`, `ban_txt1_en`, `ban_txt2_en`, `ban_txt3_en`, `ban_txt4_en`, `ban_txt5_en`, `ban_txt1_es`, `ban_txt2_es`, `ban_txt3_es`, `ban_txt4_es`, `ban_txt5_es`, `ban_txt1_fr`, `ban_txt2_fr`, `ban_txt3_fr`, `ban_txt4_fr`, `ban_txt5_fr`, `ban_link`, `ban_sort`, `ban_text_position`, `ban_visible`, `created_at`, `updated_at`) VALUES
(1, 'main', 'ban_69973c58c4d43_1771519064.png', 'Sem Lactose', 'Nunca Foi Tão Fácil Comer Saudável!', NULL, NULL, NULL, 'Lactose-free', 'Eating healthily has never been easier!', NULL, NULL, NULL, 'Sin Lactosa', '¡Nunca fue tan fácil comer sano!', NULL, NULL, NULL, 'Sans Lactose', 'Il n\'a jamais été aussi facile de manger sainement !', NULL, NULL, NULL, NULL, 0, 'left', 1, '2026-02-19 11:50:04', '2026-02-19 16:37:46'),
(2, 'main', 'ban_69973d5747c05_1771519319.jpg', 'Sem Processados', 'O Sabor Natural Que Merece', NULL, NULL, NULL, 'Unprocessed', 'The Natural Flavour You Deserve', NULL, NULL, NULL, 'Sin Procesados', 'El Sabor Natural Que Mereces', NULL, NULL, NULL, 'Sans Produits Transformés', 'La Saveur Naturelle Que Vous Méritez', NULL, NULL, NULL, NULL, 1, 'left', 1, '2026-02-19 16:42:02', '2026-02-19 16:42:02');
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 */;
