-- https://www.phpmyadmin.net/
--
-- Erstellungszeit: 10. Jan 2022 um 20:52
-- Server-Version: 10.4.21-MariaDB
-- PHP-Version: 8.0.10

START TRANSACTION;



--
-- Datenbank: `kundencenter`
--

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

--
-- Tabellenstruktur für Tabelle `advertising_entity`
--

CREATE TABLE `advertising_entity` (
  `id` int(11) NOT NULL,
  `file` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` datetime NOT NULL,
  `fallback` tinyint(1) NOT NULL,
  `campaign_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Daten für Tabelle `advertising_entity`
--

INSERT INTO `advertising_entity` (`id`, `file`, `status`, `type`, `date`, `fallback`, `campaign_id`) VALUES
(1, 'telwebko_meeting_1006_120x240.gif', 'aktualisiert', 'image/gif', '2021-09-24 09:52:14', 0, 4),
(18, 'telwebko_meeting_1006_1200x240.gif', 'aktualisiert', 'image/gif', '2021-10-19 09:52:14', 0, 4),
(28, 'telwebko_meeting_1006_1200x2400.gif', 'neu', 'image/gif', '2021-09-24 09:52:14', 0, 4),
(60, 'sample_surfing_with_audio_1280x720.swf', 'neu', 'application/x-shockwave-flash', '2021-11-08 19:18:11', 0, 4),
(61, 'Sams_Galaxy_S9_1e_cam_1807_telekom_SC_HD_1928x1080.mp4', 'neu', 'video/mp4', '2021-11-09 09:50:11', 0, 4),
(62, '50Proz_iPhone8_9998_MMLmTS_1801_l_320x75.html', 'neu', 'text/html', '2021-11-09 12:50:11', 0, 4),
(63, 'SamsZFlip3_5G_2108_passde.xlsx', 'neu', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', '2021-11-08 08:50:11', 0, 4),
(89, 'Hundetracker-2109-Serviceseiten-981x792_AppShop.jpg', 'neu', 'image/jpeg', '2021-11-15 12:07:41', 1, 9),
(90, 'Hundetracker_2109_Serviceseiten.html', 'neu', 'text/html', '2021-11-15 12:08:38', 0, 9),
(93, 'iPhone12_1e_MMMmPS_2105-W02_GDN.xlsx', 'neu', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', '2021-11-17 13:04:45', 0, 9),
(94, 'iPhone12_1e_MMMmPS_2105-W02_GDN_960x1200.jpg', 'neu', 'image/jpeg', '2021-11-17 13:13:19', 0, 9),
(95, 'MagSmartHome_Aktion_3zahl2_2109_GDN_Logo_128x128.png', 'neu', 'image/png', '2021-11-17 13:13:19', 0, 9),
(96, 'SamsS21_5G_1e_MMMmPS_2101-W06_teltarif_300x150.gif', 'neu', 'image/gif', '2021-11-17 13:13:19', 0, 9),
(99, 'Fallback_PK_MF_l0_adform_dyn_300x250.gif', 'neu', 'image/gif', '2021-11-17 16:42:39', 1, 9),
(100, 'MagTV_3Liga_dyn_2110_l0_adform_dyn_300x250.html', 'neu', 'text/html', '2021-11-17 16:42:39', 0, 9),
(105, 'X_120e_Cashback_Xiaomi_11T_5G_NL_adRom.html', 'neu', 'text/html', '2021-11-18 11:04:38', 0, 9);

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

--
-- Tabellenstruktur für Tabelle `alias_entity`
--

CREATE TABLE `alias_entity` (
  `id` int(11) NOT NULL,
  `alias` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `roles` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:json)',
  `role` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `company` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notification` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:json)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Daten für Tabelle `alias_entity`
--

INSERT INTO `alias_entity` (`id`, `alias`, `roles`, `role`, `company`, `notification`) VALUES
(1, 'mille', '[\"ROLE_ADM\",\"ROLE_USER\"]', 'ROLE_ADM', 'Millemedia', '[\"m.lingert@gmx.net\"]'),
(14, 'mindshare', '[\"ROLE_AGY_DC\",\"ROLE_USER\"]', 'ROLE_AGY_DC', 'Mindshare', '[\"Ilona.Hansen@telekom.de\",\"A.Laurent@telekom.de\"]'),
(15, 'emetriq', '[\"ROLE_AGY_DC\",\"ROLE_USER\"]', 'ROLE_AGY_DC', 'emetriq', '[\"cm@emetriq.com\",\"Ilona.Hansen@telekom.de\",\"A.Laurent@telekom.de\"]'),
(16, 'Artefact', '[\"ROLE_AGY_DC\",\"ROLE_USER\"]', 'ROLE_AGY_DC', 'Artefact', '[\"telekom-germany-aff-de@artefact.com\",\"telekom-affiliates@telekom.de\"]'),
(61, 'telekom', '[\"ROLE_CUS_KC\",\"ROLE_USER\"]', 'ROLE_CUS_KC', 'Telekom', ''),
(62, 'telekom+', '[\"ROLE_CUS_KC_DC\",\"ROLE_USER\"]', 'ROLE_CUS_KC_DC', 'Telekom', '');

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

--
-- Tabellenstruktur für Tabelle `campaign_entity`
--

CREATE TABLE `campaign_entity` (
  `id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `client` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order_date` datetime NOT NULL,
  `submission_date` datetime NOT NULL,
  `details` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dyn_banner` tinyint(1) NOT NULL,
  `json` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kmp_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `category` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Daten für Tabelle `campaign_entity`
--

INSERT INTO `campaign_entity` (`id`, `name`, `client`, `order_date`, `submission_date`, `details`, `dyn_banner`, `json`, `kmp_status`, `category`) VALUES
(4, 'Testkampagne', 'dumm', '2021-09-02 16:22:00', '2021-09-22 16:22:00', 'sadasd', 1, 'oneplus7t_dyn_1910-w03', 'neu', 'eSales'),
(6, 'Testkampagne 2', 'Ich GmbH', '2021-09-01 13:24:00', '2021-09-15 13:24:00', 'Test', 1, 'huawei_p40pro_hochdyn_2006-w01', 'neu', 'Affiliate'),
(9, 'Kampagne 3', 'Ich AG', '2021-11-05 13:54:00', '2021-11-26 13:54:00', NULL, 1, 'weih_silv_5g_1912-w08', 'neu', 'Corporate Benefits');

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

--
-- Tabellenstruktur für Tabelle `category_entity`
--

CREATE TABLE `category_entity` (
  `id` int(11) NOT NULL,
  `category` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Daten für Tabelle `category_entity`
--

INSERT INTO `category_entity` (`id`, `category`) VALUES
(9, 'eSales'),
(10, 'Affiliate'),
(11, 'Corporate Benefits'),
(12, 'emetriq'),
(13, 'mindshare'),
(21, 'Serviceseiten'),
(22, 'master');

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

--
-- Tabellenstruktur für Tabelle `comment_entity`
--

CREATE TABLE `comment_entity` (
  `id` bigint(20) NOT NULL,
  `date` datetime NOT NULL,
  `comment` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `advertising_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Daten für Tabelle `comment_entity`
--

INSERT INTO `comment_entity` (`id`, `date`, `comment`, `advertising_id`, `user_id`) VALUES
(12, '2021-09-28 12:36:05', 'Erster Kommentar', 1, 3),
(14, '2021-09-28 12:38:13', 'Zweiter Kommentar', 1, 3),
(41, '2021-10-19 19:14:56', '[Abgenommen]', 1, 3),
(42, '2021-10-19 19:15:11', '[Abnahme zurückgenommen]', 1, 3),
(43, '2021-10-20 08:54:07', 'Banana', 18, 3),
(44, '2021-10-20 09:29:43', '[Abgenommen]', 18, 3),
(45, '2021-10-20 09:32:04', 'Looney Toons', 28, 3),
(61, '2021-12-23 09:54:09', '[Abnahme zurückgenommen]', 18, 3);

--
-- Indizes für die Tabelle `alias_entity`
--
ALTER TABLE `alias_entity`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `campaign_entity`
--
ALTER TABLE `campaign_entity`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `category_entity`
--
ALTER TABLE `category_entity`
  ADD PRIMARY KEY (`id`);

--
-- Indizes für die Tabelle `comment_entity`
--
ALTER TABLE `comment_entity`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_C43B1C7A9F084B42` (`advertising_id`),
  ADD KEY `IDX_C43B1C7AA76ED395` (`user_id`);

--
-- AUTO_INCREMENT für exportierte Tabellen
--

--
-- AUTO_INCREMENT für Tabelle `advertising_entity`
--
ALTER TABLE `advertising_entity`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=112;

--
-- AUTO_INCREMENT für Tabelle `alias_entity`
--
ALTER TABLE `alias_entity`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=68;

--
-- AUTO_INCREMENT für Tabelle `campaign_entity`
--
ALTER TABLE `campaign_entity`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT für Tabelle `category_entity`
--
ALTER TABLE `category_entity`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT für Tabelle `comment_entity`
--
ALTER TABLE `comment_entity`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=62;

--
-- Constraints der exportierten Tabellen
--

--
-- Constraints der Tabelle `advertising_entity`
--
ALTER TABLE `advertising_entity`
  ADD CONSTRAINT `FK_385C4382F639F774` FOREIGN KEY (`campaign_id`) REFERENCES `campaign_entity` (`id`);

--
-- Constraints der Tabelle `comment_entity`
--
ALTER TABLE `comment_entity`
  ADD CONSTRAINT `FK_C43B1C7A9F084B42` FOREIGN KEY (`advertising_id`) REFERENCES `advertising_entity` (`id`),
  ADD CONSTRAINT `FK_C43B1C7AA76ED395` FOREIGN KEY (`user_id`) REFERENCES `user_entity` (`id`);
COMMIT;

