Exportiere die aktuelle Datenstruktur als CREATE TABLE-Statements im MySQL-Format.
-- CREATE TABLE für `courses`
DROP TABLE IF EXISTS `courses`;
CREATE TABLE `courses` (
`id` INT AUTO_INCREMENT,
`subject` VARCHAR(255),
`level` ENUM(''),
`weekday` ENUM(''),
`time_from` VARCHAR(255),
`time_to` VARCHAR(255),
`teacher_id` INT,
`created_at` DATETIME,
`updated_at` DATETIME,
PRIMARY KEY (`id`)
) ENGINE=InnoDB CHARACTER SET=utf8mb4;
-- Datenexport für Tabelle: `courses`
-- Block 1
START TRANSACTION;
INSERT INTO `courses` (`id`, `subject`, `level`, `weekday`, `time_from`, `time_to`, `teacher_id`, `created_at`, `updated_at`) VALUES (37, 'Biologie', 'I', 'Montag', '10:00', '11:30', 52, '2025-04-20 23:10:52', '2025-04-20 23:10:52');
INSERT INTO `courses` (`id`, `subject`, `level`, `weekday`, `time_from`, `time_to`, `teacher_id`, `created_at`, `updated_at`) VALUES (38, 'Informatik', 'II', 'Mittwoch', '14:00', '15:30', 53, '2025-04-20 23:10:52', '2025-04-20 23:10:52');
INSERT INTO `courses` (`id`, `subject`, `level`, `weekday`, `time_from`, `time_to`, `teacher_id`, `created_at`, `updated_at`) VALUES (39, 'Informatik', 'I', 'Freitag', '14:00', '15:30', 60, '2025-04-20 23:10:52', '2025-04-20 23:10:52');
INSERT INTO `courses` (`id`, `subject`, `level`, `weekday`, `time_from`, `time_to`, `teacher_id`, `created_at`, `updated_at`) VALUES (40, 'Biologie', 'I', 'Dienstag', '14:00', '15:30', 60, '2025-04-20 23:10:52', '2025-04-20 23:10:52');
INSERT INTO `courses` (`id`, `subject`, `level`, `weekday`, `time_from`, `time_to`, `teacher_id`, `created_at`, `updated_at`) VALUES (41, 'Mathematik', 'I', 'Dienstag', '14:00', '15:30', 59, '2025-04-20 23:10:52', '2025-04-20 23:10:52');
COMMIT;
-- Block 2
START TRANSACTION;
INSERT INTO `courses` (`id`, `subject`, `level`, `weekday`, `time_from`, `time_to`, `teacher_id`, `created_at`, `updated_at`) VALUES (42, 'Deutsch', 'I', 'Freitag', '08:00', '09:30', 57, '2025-04-20 23:10:52', '2025-04-20 23:10:52');
INSERT INTO `courses` (`id`, `subject`, `level`, `weekday`, `time_from`, `time_to`, `teacher_id`, `created_at`, `updated_at`) VALUES (43, 'Mathematik', 'II', 'Dienstag', '10:00', '11:30', 58, '2025-04-20 23:10:52', '2025-04-20 23:10:52');
INSERT INTO `courses` (`id`, `subject`, `level`, `weekday`, `time_from`, `time_to`, `teacher_id`, `created_at`, `updated_at`) VALUES (44, 'Deutsch', 'I', 'Freitag', '14:00', '15:30', 60, '2025-04-20 23:10:52', '2025-04-20 23:10:52');
INSERT INTO `courses` (`id`, `subject`, `level`, `weekday`, `time_from`, `time_to`, `teacher_id`, `created_at`, `updated_at`) VALUES (45, 'Mathematik', 'Grundlagen', 'Montag', '14:00', '15:30', 54, '2025-04-20 23:10:52', '2025-04-20 23:10:52');
INSERT INTO `courses` (`id`, `subject`, `level`, `weekday`, `time_from`, `time_to`, `teacher_id`, `created_at`, `updated_at`) VALUES (46, 'Informatik', 'II', 'Dienstag', '12:00', '13:30', 59, '2025-04-20 23:10:52', '2025-04-20 23:10:52');
COMMIT;
-- Block 3
START TRANSACTION;
INSERT INTO `courses` (`id`, `subject`, `level`, `weekday`, `time_from`, `time_to`, `teacher_id`, `created_at`, `updated_at`) VALUES (47, 'Mathematik', 'Grundlagen', 'Donnerstag', '10:00', '11:30', 61, '2025-04-20 23:10:52', '2025-04-20 23:10:52');
INSERT INTO `courses` (`id`, `subject`, `level`, `weekday`, `time_from`, `time_to`, `teacher_id`, `created_at`, `updated_at`) VALUES (48, 'Biologie', 'Grundlagen', 'Dienstag', '14:00', '15:30', 62, '2025-04-20 23:10:52', '2025-04-20 23:10:52');
INSERT INTO `courses` (`id`, `subject`, `level`, `weekday`, `time_from`, `time_to`, `teacher_id`, `created_at`, `updated_at`) VALUES (49, 'Biologie', 'II', 'Freitag', '10:00', '11:30', 56, '2025-04-20 23:10:52', '2025-04-20 23:10:52');
INSERT INTO `courses` (`id`, `subject`, `level`, `weekday`, `time_from`, `time_to`, `teacher_id`, `created_at`, `updated_at`) VALUES (50, 'Informatik', 'I', 'Montag', '08:00', '09:30', 56, '2025-04-20 23:10:52', '2025-04-20 23:10:52');
INSERT INTO `courses` (`id`, `subject`, `level`, `weekday`, `time_from`, `time_to`, `teacher_id`, `created_at`, `updated_at`) VALUES (51, 'Deutsch', 'Grundlagen', 'Donnerstag', '08:00', '09:30', 62, '2025-04-20 23:10:52', '2025-04-20 23:10:52');
COMMIT;
-- Block 4
START TRANSACTION;
INSERT INTO `courses` (`id`, `subject`, `level`, `weekday`, `time_from`, `time_to`, `teacher_id`, `created_at`, `updated_at`) VALUES (52, 'Informatik', 'II', 'Montag', '12:00', '13:30', 58, '2025-04-20 23:10:52', '2025-04-20 23:10:52');
INSERT INTO `courses` (`id`, `subject`, `level`, `weekday`, `time_from`, `time_to`, `teacher_id`, `created_at`, `updated_at`) VALUES (53, 'Mathematik', 'I', 'Dienstag', '08:00', '09:30', 58, '2025-04-20 23:10:52', '2025-04-20 23:10:52');
INSERT INTO `courses` (`id`, `subject`, `level`, `weekday`, `time_from`, `time_to`, `teacher_id`, `created_at`, `updated_at`) VALUES (54, 'Biologie', 'II', 'Freitag', '14:00', '15:30', 53, '2025-04-20 23:10:52', '2025-04-20 23:10:52');
INSERT INTO `courses` (`id`, `subject`, `level`, `weekday`, `time_from`, `time_to`, `teacher_id`, `created_at`, `updated_at`) VALUES (55, 'Mathematik', 'II', 'Mittwoch', '12:00', '13:30', 59, '2025-04-20 23:10:52', '2025-04-20 23:10:52');
INSERT INTO `courses` (`id`, `subject`, `level`, `weekday`, `time_from`, `time_to`, `teacher_id`, `created_at`, `updated_at`) VALUES (56, 'Deutsch', 'Grundlagen', 'Montag', '12:00', '13:30', 52, '2025-04-20 23:10:52', '2025-04-20 23:10:52');
COMMIT;
| Tabelle | Aktion |
|---|---|
🗂️ classes |
📄 CREATE 🧾 INSERTs 📦 Komplett (CREATE + INSERT) |
🗂️ courses |
📄 CREATE 🧾 INSERTs 📦 Komplett (CREATE + INSERT) |
🗂️ enrollments |
📄 CREATE 🧾 INSERTs 📦 Komplett (CREATE + INSERT) |
🗂️ students |
📄 CREATE 🧾 INSERTs 📦 Komplett (CREATE + INSERT) |
🗂️ teachers |
📄 CREATE 🧾 INSERTs 📦 Komplett (CREATE + INSERT) |
🛢️ Alle Tabellen |
📄 CREATE (alle) 🧾 INSERTs (alle) 📦 Komplett (alle) |