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

START TRANSACTION;



--
-- Database: `crm_New_requirment`
--

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

--
-- Table structure for table `advertisement`
--

CREATE TABLE `advertisement` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` text NOT NULL,
  `text` text NOT NULL,
  `picture` varchar(600) NOT NULL,
  `link` varchar(500) NOT NULL,
  `status` tinyint(4) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `is_converted` int(11) NOT NULL DEFAULT 0,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `advertisement`
--

INSERT INTO `advertisement` (`id`, `name`, `text`, `picture`, `link`, `status`, `start_date`, `end_date`, `is_converted`, `created_at`, `updated_at`) VALUES
(11, 'Real deals, real products, no fake advertising here!', '<span>Lorem ipsum dolor sit amet. Qui dolorem reiciendis sit cumque nostrum est repellendus cupiditate aut nihil sunt aut inventore neque in quas consectetur. Est repudiandae rerum et voluptatum nulla ea dignissimos placeat ut illum neque.</span>', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/October/Images/key_daisies_inscription_119219_1024x768.jpg', 'www.testurl', 0, '2024-03-05', '2024-03-06', 0, '2023-10-26 07:20:20', '2024-03-05 14:05:23'),
(12, 'test05', 'test', 'https://minio.staging.verein.cloud/tineon/Leipzig/2024/March/Documents/Bildschirm%C2%ADfoto%202023-03-18%20um%2009.39.16.png', 'http://crmangular.mangoitsol.com/add-advertisement', 0, '2024-03-04', '2024-03-06', 0, '2024-01-15 13:20:00', '2024-03-05 14:06:14'),
(13, 'language changes not supported', 'dfsf', 'https://minio.staging.verein.cloud/tineon/Leipzig/2024/July/Images/Volleyball%20M%C3%A4dels.jpeg', 'http://crmangular.mangoitsol.com/add-advertisement', 0, '2024-07-04', '2024-07-13', 0, '2024-07-03 16:29:17', NULL);

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

--
-- Table structure for table `advertisement_image`
--

CREATE TABLE `advertisement_image` (
  `id` int(11) NOT NULL,
  `advertisement_id` int(11) NOT NULL,
  `advertisement_image` longtext NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `advertisement_image`
--

INSERT INTO `advertisement_image` (`id`, `advertisement_id`, `advertisement_image`, `created_at`, `updated_at`) VALUES
(8, 11, '[encoded data, 209348 characters]', '2023-10-26 05:20:21', NULL);
INSERT INTO `advertisement_image` (`id`, `advertisement_id`, `advertisement_image`, `created_at`, `updated_at`) VALUES
(9, 12, '[encoded data, 311718 characters]