-- phpMyAdmin SQL Dump -- version 4.9.11 -- https://www.phpmyadmin.net/ -- -- Host: db5018537291.hosting-data.io -- Erstellungszeit: 20. Sep 2025 um 09:44 -- Server-Version: 8.0.36 -- PHP-Version: 7.4.33 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 */; -- -- Datenbank: `dbs14717264` -- -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `rezepte_bilder` -- CREATE TABLE `rezepte_bilder` ( `id` int NOT NULL, `rezepte_id` int NOT NULL, `datei_pfad` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Daten für Tabelle `rezepte_bilder` -- INSERT INTO `rezepte_bilder` (`id`, `rezepte_id`, `datei_pfad`) VALUES (1, 6, 'uploads/R001/R001_0.jpg'), (2, 6, 'uploads/R001/R001_1.jpg'), (3, 6, 'uploads/R001/R001_2.jpg'), (4, 11, 'uploads/R002/R002_0.jpg'), (5, 11, 'uploads/R002/R002_1.jpg'), (6, 11, 'uploads/R002/R002_2.jpg'), (7, 11, 'uploads/R002/R002_3.jpg'), (8, 7, 'uploads/R003/R003_0.jpg'), (9, 7, 'uploads/R003/R003_1.jpg'), (10, 7, 'uploads/R003/R003_2.jpg'), (11, 8, 'uploads/R004/R004_0.jpg'), (12, 8, 'uploads/R004/R004_1.jpg'), (13, 8, 'uploads/R004/R004_2.jpg'), (14, 8, 'uploads/R004/R004_3.jpg'), (15, 8, 'uploads/R004/R004_4.jpg'), (16, 8, 'uploads/R004/R004_5.jpg'), (17, 12, 'uploads/R005/R005_0.jpg'), (18, 9, 'uploads/R006/R006_0.jpg'), (19, 9, 'uploads/R006/R006_1.jpg'), (20, 9, 'uploads/R006/R006_2.jpg'), (21, 9, 'uploads/R006/R006_3.jpg'), (22, 9, 'uploads/R006/R006_4.jpg'), (23, 10, 'uploads/R007/R007_0.jpg'), (24, 10, 'uploads/R007/R007_1.jpg'), (25, 10, 'uploads/R007/R007_2.jpg'), (26, 10, 'uploads/R007/R007_3.jpg'), (27, 10, 'uploads/R007/R007_4.jpg'), (28, 10, 'uploads/R007/R007_5.jpg'), (29, 13, 'uploads/R009/R009_0.jpg'), (30, 13, 'uploads/R009/R009_1.jpg'), (31, 13, 'uploads/R009/R009_2.jpg'), (32, 13, 'uploads/R009/R009_3.jpg'), (33, 13, 'uploads/R009/R009_4.jpg'), (34, 5, 'uploads/R010/R010_0.jpg'), (35, 5, 'uploads/R010/R010_1.jpg'), (36, 5, 'uploads/R010/R010_2.jpg'), (37, 5, 'uploads/R010/R010_3.jpg'), (38, 4, 'uploads/R011/R011_0.jpg'), (39, 14, 'uploads/R013/R013_0.jpg'), (40, 14, 'uploads/R013/R013_1.jpg'), (41, 14, 'uploads/R013/R013_2.jpg'), (42, 14, 'uploads/R013/R013_3.jpg'), (43, 14, 'uploads/R013/R013_4.jpg'), (44, 16, 'uploads/R014/R014_0.jpg'), (45, 16, 'uploads/R014/R014_1.jpg'), (46, 16, 'uploads/R014/R014_2.jpg'), (47, 16, 'uploads/R014/R014_3.jpg'), (48, 16, 'uploads/R014/R014_4.jpg'), (49, 15, 'uploads/R015/R015_0.jpg'), (50, 15, 'uploads/R015/R015_1.jpg'), (51, 15, 'uploads/R015/R015_2.jpg'), (52, 15, 'uploads/R015/R015_3.jpg'), (53, 15, 'uploads/R015/R015_4.jpg'), (54, 17, 'uploads/R016/R016_0.jpg'), (55, 17, 'uploads/R016/R016_1.jpg'), (58, 17, 'uploads/R016/R016_4.jpg'), (59, 18, 'uploads/R017/R017_0.jpg'), (61, 19, 'uploads/R018/R018_0.jpg'), (62, 19, 'uploads/R018/R018_1.jpg'), (63, 19, 'uploads/R018/R018_2.jpg'), (64, 19, 'uploads/R018/R018_3.jpg'), (65, 20, 'uploads/R019/R019_0.jpg'), (69, 21, 'uploads/R020/R020_0.jpg'), (70, 21, 'uploads/R020/R020_1.jpg'), (71, 21, 'uploads/R020/R020_2.jpg'), (72, 22, 'uploads/R021/R021_0.jpg'), (73, 22, 'uploads/R021/R021_1.jpg'), (74, 22, 'uploads/R021/R021_2.jpg'), (75, 22, 'uploads/R021/R021_3.jpg'), (76, 23, 'uploads/R022/R022_0.jpg'), (77, 23, 'uploads/R022/R022_1.jpg'), (78, 23, 'uploads/R022/R022_2.jpg'), (79, 23, 'uploads/R022/R022_3.jpg'), (80, 24, 'uploads/R023/R023_0.jpg'), (81, 25, 'uploads/R024/R024_1.jpg'), (82, 26, 'uploads/R025/R025_0.jpg'), (83, 27, 'uploads/R026/R026_0.jpg'), (84, 28, 'uploads/R027/R027_0.jpg'), (85, 28, 'uploads/R027/R027_1.jpg'), (86, 29, 'uploads/R028/R028_0.jpg'), (87, 29, 'uploads/R028/R028_1.jpg'), (88, 29, 'uploads/R028/R028_2.jpg'), (89, 30, 'uploads/R029/R029_0.jpg'), (90, 31, 'uploads/R030/R030_0.jpg'), (91, 31, 'uploads/R030/R030_1.jpg'), (92, 31, 'uploads/R030/R030_2.jpg'), (93, 31, 'uploads/R030/R030_3.jpg'), (94, 32, 'uploads/R031/R031_0.jpg'), (95, 32, 'uploads/R031/R031_1.jpg'), (96, 32, 'uploads/R031/R031_2.jpg'), (97, 32, 'uploads/R031/R031_3.jpg'), (98, 32, 'uploads/R031/R031_4.jpg'), (99, 33, 'uploads/R032/R032_0.jpg'), (100, 34, 'uploads/R033/R033_0.jpg'), (101, 34, 'uploads/R033/R033_1.jpg'), (102, 34, 'uploads/R033/R033_2.jpg'), (103, 34, 'uploads/R033/R033_3.jpg'), (104, 34, 'uploads/R033/R033_4.jpg'), (105, 35, 'uploads/R034/R034_0.jpg'), (106, 35, 'uploads/R034/R034_1.jpg'), (107, 35, 'uploads/R034/R034_2.jpg'), (108, 35, 'uploads/R034/R034_3.jpg'), (109, 35, 'uploads/R034/R034_4.jpg'), (110, 36, 'uploads/R035/R035_0.jpg'), (111, 36, 'uploads/R035/R035_1.jpg'), (112, 36, 'uploads/R035/R035_2.jpg'), (113, 36, 'uploads/R035/R035_3.jpg'), (114, 36, 'uploads/R035/R035_4.jpg'), (115, 36, 'uploads/R035/R035_5.jpg'), (116, 37, 'uploads/R036/R036_0.jpg'), (117, 37, 'uploads/R036/R036_1.jpg'), (118, 37, 'uploads/R036/R036_2.jpg'), (119, 37, 'uploads/R036/R036_3.jpg'), (120, 37, 'uploads/R036/R036_4.jpg'), (121, 40, 'uploads/R039/R039_0.jpg'), (122, 41, 'uploads/R040/R040_0.jpg'), (123, 41, 'uploads/R040/R040_1.jpg'), (124, 41, 'uploads/R040/R040_2.jpg'), (125, 41, 'uploads/R040/R040_3.jpg'), (126, 41, 'uploads/R040/R040_4.jpg'), (127, 42, 'uploads/R041/R041_0.jpg'), (128, 42, 'uploads/R041/R041_1.jpg'), (129, 43, 'uploads/R042/R042_0.jpg'), (130, 44, 'uploads/R043/R043_0.jpg'), (134, 50, 'uploads/R050/R050_0.jpg'), (135, 50, 'uploads/R050/R050_1.jpg'), (136, 51, 'uploads/R051/R051_0.jpg'), (137, 12, 'uploads/R005/R005_2.jpg'), (138, 12, 'uploads/R005/R005_3.jpg'), (139, 12, 'uploads/R005/R005_4.jpg'), (140, 12, 'uploads/R005/R005_5.jpg'), (141, 12, 'uploads/R005/R005_6.jpg'), (142, 12, 'uploads/R005/R005_7.jpg'), (147, 20, 'uploads/R019/R019_1.jpg'), (148, 20, 'uploads/R019/R019_2.jpg'), (149, 20, 'uploads/R019/R019_3.jpg'), (153, 18, 'uploads/R017/R017_1.jpg'), (156, 52, 'uploads/R050/R050_2.jpg'); -- -- Indizes der exportierten Tabellen -- -- -- Indizes für die Tabelle `rezepte_bilder` -- ALTER TABLE `rezepte_bilder` ADD PRIMARY KEY (`id`), ADD KEY `rezepte_id` (`rezepte_id`); -- -- AUTO_INCREMENT für exportierte Tabellen -- -- -- AUTO_INCREMENT für Tabelle `rezepte_bilder` -- ALTER TABLE `rezepte_bilder` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=157; 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 */;