/* ============================================================
 * FGZ Design System – SQL Lernplattform
 * Following the FGZ Brand Guidelines (v1.0, 30.10.2024)
 * Hausschrift: Lab Grotesque · Primary: FGZ Blau (#2350AC)
 *
 * ============================================================ */

@font-face {
  font-family: "Lab Grotesque";
  src: url("assets/fonts/LabGrotesque-Regular.otf") format("opentype");
  font-weight: 400;
  font-style: normal;
  font-display: swap;
}
@font-face {
  font-family: "Lab Grotesque";
  src: url("assets/fonts/LabGrotesque-Italic.otf") format("opentype");
  font-weight: 400;
  font-style: italic;
  font-display: swap;
}
@font-face {
  font-family: "Lab Grotesque";
  src: url("assets/fonts/LabGrotesque-Bold.otf") format("opentype");
  font-weight: 700;
  font-style: normal;
  font-display: swap;
}
@font-face {
  font-family: "Lab Grotesque";
  src: url("assets/fonts/LabGrotesque-Black.otf") format("opentype");
  font-weight: 900;
  font-style: normal;
  font-display: swap;
}

/* ---------- FGZ Brand Tokens ---------- */
:root {
  /* Primary brand colors */
  --fgz-blau:            #2350AC;
  --fgz-blau-pastell:    #BCD5F4;
  --fgz-nachtblau:       #002F71;
  --fgz-nachtblau-pastell:#BFCCDC;
  --fgz-seegruen:        #1C6979;
  --fgz-seegruen-pastell:#90BBC9;
  --fgz-himmelblau:      #00C3F5;
  --fgz-himmelblau-pastell:#AFEEFF;
  --fgz-aprikose:        #FF8766;
  --fgz-aprikose-pastell:#FFE8DE;
  --fgz-pflaume:         #9B7AED;
  --fgz-pflaume-pastell: #E0D6FF;
  --fgz-pistazie:        #B9D668;
  --fgz-pistazie-pastell:#EDFDC3;
  --fgz-minzgruen:       #28C7B5;
  --fgz-minzgruen-pastell:#B3EDE3;
  --fgz-honig:           #FFB54D;
  --fgz-honig-pastell:   #FFE0C0;

  /* Semantic mapping */
  --bg-page:        #FFFFFF;
  --bg-soft:        #F5F8FD;
  --bg-elevated:    #FFFFFF;
  --bg-tint:        var(--fgz-blau-pastell);
  --bg-code:        #0E1B3A;        /* dunkle Codefläche, FGZ-Nachtblau-tief für Lesbarkeit */
  --bg-code-soft:   #F1F4F9;

  --border:         #DCE3EE;
  --border-strong:  #B9C6DA;

  --text:           #0E1B3A;
  --text-soft:      #4A556B;
  --text-muted:     #7E8AA0;
  --text-inverse:   #FFFFFF;

  --primary:        var(--fgz-blau);
  --primary-hover:  var(--fgz-nachtblau);
  --accent:         var(--fgz-himmelblau);

  --success:        var(--fgz-pistazie);
  --warn:           var(--fgz-honig);
  --danger:         var(--fgz-aprikose);

  /* Typography (Brand Guidelines page 15, scaled for app UI) */
  --font-sans: "Lab Grotesque", Arial, "Helvetica Neue", Helvetica, sans-serif;
  --font-mono: "JetBrains Mono", "Fira Code", Consolas, Monaco, monospace;

  --fs-h1: 40px;
  --fs-h2: 26px;
  --fs-h3: 20px;
  --fs-lead: 18px;
  --fs-body: 16px;
  --fs-small: 13px;

  --shadow-sm: 0 1px 2px rgba(14,27,58,0.06);
  --shadow-md: 0 4px 16px rgba(14,27,58,0.08);
  --shadow-lg: 0 16px 48px rgba(14,27,58,0.12);

  --radius: 6px;       /* FGZ verwendet eckige Formen, deshalb dezente Rundungen */
  --radius-lg: 10px;
}

/* ---------- Resets & base ---------- */
* { box-sizing: border-box; }
html, body {
  margin: 0; padding: 0;
  height: 100%;
  font-family: var(--font-sans);
  font-size: var(--fs-body);
  line-height: 1.5;
  color: var(--text);
  background: var(--bg-page);
  overflow: hidden;
}
body { display: flex; flex-direction: column; }

a { color: var(--primary); text-decoration: none; }
a:hover { text-decoration: underline; }

/* ---------- Header ---------- */
.app-header {
  display: flex;
  justify-content: space-between;
  align-items: center;
  padding: 14px 32px;
  background: #FFFFFF;
  border-bottom: 2px solid var(--fgz-blau);
  flex-shrink: 0;
  position: relative;
}
.brand {
  display: flex;
  align-items: center;
  gap: 18px;
}
.brand-logo {
  height: 48px;
  width: auto;
  display: block;
}
.brand-divider {
  width: 1px; height: 36px;
  background: var(--border-strong);
}
.brand-text h1 {
  font-family: var(--font-sans);
  font-weight: 900;
  font-size: 18px;
  margin: 0;
  color: var(--fgz-nachtblau);
  letter-spacing: -0.01em;
}
.subtitle {
  font-size: 13px;
  color: var(--text-muted);
  margin: 2px 0 0;
  font-weight: 400;
}

.header-actions {
  display: flex;
  align-items: center;
  gap: 10px;
}
.db-status {
  padding: 6px 12px;
  border-radius: var(--radius);
  background: var(--fgz-honig-pastell);
  color: #8a5a00;
  font-size: 12px;
  font-family: var(--font-mono);
  font-weight: 700;
}
.db-status.ready  { background: var(--fgz-pistazie-pastell); color: #4a6a00; }
.db-status.error  { background: var(--fgz-aprikose-pastell); color: #a13b1c; }

/* ---------- Lerncode-Eingabe ---------- */
.code-group {
  display: flex;
  align-items: center;
  gap: 6px;
  padding: 4px 6px 4px 10px;
  background: var(--bg-soft);
  border: 1px solid var(--border);
  border-radius: var(--radius);
}
.code-label {
  font-family: var(--font-mono);
  font-size: 11px;
  font-weight: 700;
  color: var(--fgz-nachtblau);
  text-transform: uppercase;
  letter-spacing: 0.6px;
}
.code-input {
  border: none;
  background: transparent;
  outline: none;
  font-family: var(--font-mono);
  font-size: 13px;
  color: var(--fgz-nachtblau);
  padding: 4px 6px;
  width: 130px;
  min-width: 130px;
}
.code-input::placeholder { color: var(--text-muted); font-style: italic; }
.code-input:focus { background: #FFFFFF; border-radius: 4px; }

.code-status {
  padding: 3px 8px;
  border-radius: 10px;
  font-family: var(--font-mono);
  font-size: 10px;
  font-weight: 700;
  text-transform: uppercase;
  letter-spacing: 0.5px;
  white-space: nowrap;
}
.code-status-anon  { background: var(--bg-soft);                 color: var(--text-muted); border: 1px solid var(--border); }
.code-status-local { background: var(--fgz-blau-pastell);        color: var(--fgz-nachtblau); }
.code-status-syncing { background: var(--fgz-honig-pastell);     color: #7a4400; }
.code-status-synced { background: var(--fgz-pistazie-pastell);   color: #4a6a00; }
.code-status-error { background: var(--fgz-aprikose-pastell);    color: #a13b1c; }

/* ---------- Buttons ---------- */
.btn {
  font-family: var(--font-sans);
  font-size: 14px;
  font-weight: 700;
  padding: 8px 16px;
  border: 1px solid var(--border);
  background: #FFFFFF;
  color: var(--text);
  border-radius: var(--radius);
  cursor: pointer;
  transition: all 0.15s ease;
  line-height: 1.2;
}
.btn:hover  { background: var(--bg-soft); border-color: var(--border-strong); }
.btn:active { transform: translateY(1px); }
.btn:disabled { opacity: 0.4; cursor: not-allowed; }

.btn-primary {
  background: var(--fgz-blau);
  border-color: var(--fgz-blau);
  color: #FFFFFF;
}
.btn-primary:hover {
  background: var(--fgz-nachtblau);
  border-color: var(--fgz-nachtblau);
}

.btn-secondary {
  background: #FFFFFF;
  border-color: var(--fgz-blau);
  color: var(--fgz-blau);
}
.btn-secondary:hover {
  background: var(--fgz-blau-pastell);
}

.btn-ghost {
  background: transparent;
  border-color: transparent;
  color: var(--text-soft);
  font-weight: 700;
}
.btn-ghost:hover { background: var(--bg-soft); color: var(--fgz-blau); }

/* ---------- Layout ---------- */
.app-body {
  display: flex;
  flex: 1;
  overflow: hidden;
}

.sidebar {
  width: 280px;
  flex-shrink: 0;
  background: var(--bg-soft);
  border-right: 1px solid var(--border);
  overflow-y: auto;
  padding: 18px 10px;
  position: relative;
}

.main-content {
  flex: 1;
  overflow-y: auto;
  padding: 56px 48px 40px;
  position: relative;
}

.app-footer {
  padding: 10px 32px;
  background: #FFFFFF;
  border-top: 1px solid var(--border);
  font-size: 12px;
  color: var(--text-muted);
  text-align: center;
  flex-shrink: 0;
}

/* ---------- Sidebar ---------- */
.sidebar-title {
  padding: 4px 12px 14px;
  font-size: 11px;
  font-weight: 900;
  text-transform: uppercase;
  letter-spacing: 1.2px;
  color: var(--fgz-nachtblau);
  border-bottom: 1px solid var(--border);
  margin-bottom: 8px;
}

#chapter-nav { display: flex; flex-direction: column; gap: 1px; }

.nav-chapter {
  display: block;
  padding: 9px 12px;
  margin: 0 4px;
  border-radius: var(--radius);
  color: var(--text-soft);
  cursor: pointer;
  font-family: var(--font-sans);
  font-size: 13.5px;
  font-weight: 400;
  line-height: 1.4;
  user-select: none;
  border: none;
  background: none;
  text-align: left;
  width: calc(100% - 8px);
  transition: background 0.12s, color 0.12s;
}
.nav-chapter:hover {
  background: #FFFFFF;
  color: var(--fgz-nachtblau);
}
.nav-chapter.active {
  background: var(--fgz-blau);
  color: #FFFFFF;
  font-weight: 700;
}
.nav-chapter.active .badge { background: rgba(255,255,255,0.2); color: #FFFFFF; }
.nav-chapter .badge {
  float: right;
  font-size: 10px;
  background: #FFFFFF;
  border: 1px solid var(--border);
  padding: 1px 7px;
  border-radius: 10px;
  color: var(--text-muted);
  font-family: var(--font-mono);
  font-weight: 400;
}
.nav-chapter.done {
  color: var(--text);
}
.nav-chapter.done::before {
  content: "✓ ";
  color: var(--fgz-pistazie);
  font-weight: 900;
}
.nav-chapter.active.done::before { color: #FFFFFF; }

/* Globaler Fortschritt in Sidebar */
.global-progress {
  margin: 18px 6px 90px;
  padding: 12px 14px;
  background: #FFFFFF;
  border: 1px solid var(--border);
  border-radius: var(--radius-lg);
  font-size: 12px;
}
.global-progress .progress-label {
  display: block;
  margin-bottom: 8px;
  font-family: var(--font-mono);
  color: var(--fgz-nachtblau);
  font-weight: 700;
}
.global-progress .progress-bar {
  height: 6px;
  background: var(--bg-soft);
  border-radius: 3px;
  overflow: hidden;
}

/* ---------- Panels ---------- */
.panel.hidden { display: none; }
.panel-header { margin-bottom: 22px; }
.panel-header h2 { margin: 0 0 6px; font-size: var(--fs-h2); font-weight: 900; color: var(--fgz-nachtblau); letter-spacing: -0.01em; }
.muted { color: var(--text-muted); font-size: 14px; }

/* Lesson meta strip (entfernt im aktuellen Layout) */

/* ---------- Theory ---------- */
#theory-content { max-width: 880px; }
#theory-content h1 {
  font-size: var(--fs-h1);
  font-weight: 900;
  color: var(--fgz-nachtblau);
  letter-spacing: -0.02em;
  line-height: 1.1;
  margin: 0 0 18px;
}
#theory-content h2 {
  font-size: var(--fs-h2);
  font-weight: 900;
  color: var(--fgz-blau);
  letter-spacing: -0.01em;
  margin: 36px 0 10px;
}
#theory-content h3 {
  font-size: var(--fs-h3);
  font-weight: 700;
  color: var(--fgz-nachtblau);
  margin: 22px 0 8px;
}
#theory-content p, #theory-content li {
  font-size: var(--fs-body);
  line-height: 1.65;
  color: var(--text);
}
#theory-content code {
  font-family: var(--font-mono);
  background: var(--bg-code-soft);
  padding: 2px 6px;
  border-radius: 3px;
  font-size: 13.5px;
  color: var(--fgz-nachtblau);
  border: 1px solid var(--border);
}
#theory-content pre {
  background: var(--bg-code);
  border: 1px solid var(--bg-code);
  padding: 14px 18px;
  border-radius: var(--radius);
  overflow-x: auto;
  position: relative;
  margin: 14px 0;
  box-shadow: var(--shadow-sm);
}
#theory-content pre code {
  background: none;
  border: none;
  padding: 0;
  line-height: 1.55;
  color: #DCE6F8;
  font-size: 13.5px;
  white-space: pre;
}
#theory-content pre .try-btn {
  position: absolute;
  top: 8px; right: 8px;
  padding: 4px 10px;
  font-size: 11px;
  font-weight: 700;
  background: var(--fgz-himmelblau);
  color: var(--fgz-nachtblau);
  border: none;
  border-radius: var(--radius);
  cursor: pointer;
  opacity: 0;
  transition: opacity 0.15s;
}
#theory-content pre:hover .try-btn { opacity: 1; }

#theory-content table {
  width: 100%;
  border-collapse: collapse;
  margin: 14px 0;
  font-size: 14px;
  background: #FFFFFF;
  border: 1px solid var(--border);
  border-radius: var(--radius);
  overflow: hidden;
}
#theory-content th, #theory-content td {
  padding: 9px 12px;
  border-bottom: 1px solid var(--border);
  text-align: left;
}
#theory-content tr:last-child td { border-bottom: none; }
#theory-content th {
  background: var(--fgz-blau-pastell);
  color: var(--fgz-nachtblau);
  font-weight: 700;
}

/* Info-Boxen mit FGZ-Pastellen */
.info-box {
  padding: 14px 16px;
  border-radius: var(--radius-lg);
  margin: 16px 0;
  border-left: 4px solid;
  font-size: 14px;
  line-height: 1.6;
}
.info-box.tip    { background: var(--fgz-himmelblau-pastell); border-color: var(--fgz-himmelblau); color: #064f73; }
.info-box.warn   { background: var(--fgz-honig-pastell);      border-color: var(--fgz-honig);      color: #7a4400; }
.info-box.danger { background: var(--fgz-aprikose-pastell);   border-color: var(--fgz-aprikose);   color: #a13b1c; }
.info-box strong { display: block; margin-bottom: 4px; color: inherit; }

/* Merkzettel: kompakte FGZ-Box am Ende jeder Lektion */
.merkzettel {
  margin: 32px 0 12px;
  padding: 18px 22px 18px 22px;
  background: var(--fgz-blau-pastell);
  border-left: 6px solid var(--fgz-blau);
  border-radius: var(--radius-lg);
  position: relative;
  overflow: hidden;
}
.merkzettel h3 {
  margin: 0 0 10px;
  color: var(--fgz-nachtblau);
  font-size: 13px;
  font-weight: 900;
  text-transform: uppercase;
  letter-spacing: 1.2px;
}
.merkzettel ul {
  margin: 0;
  padding-left: 20px;
  line-height: 1.75;
  font-size: 14px;
  color: var(--text);
}
.merkzettel li { margin-bottom: 4px; }
.merkzettel code {
  background: rgba(255,255,255,0.65);
  padding: 1px 6px;
  border-radius: 3px;
  font-size: 12.5px;
  color: var(--fgz-nachtblau);
  border: 1px solid rgba(35,80,172,0.2);
}

/* ---------- DB Vorschau ---------- */
.db-preview {
  margin-top: 40px;
  padding-top: 26px;
  border-top: 2px solid var(--fgz-blau-pastell);
}
.db-preview h2 { color: var(--fgz-blau); font-size: var(--fs-h3); margin: 0 0 6px; font-weight: 900; }

.db-picker {
  display: flex;
  align-items: center;
  gap: 10px;
  padding: 14px 16px;
  background: var(--bg-soft);
  border: 1px solid var(--border);
  border-radius: var(--radius-lg);
  margin-bottom: 14px;
  flex-wrap: wrap;
}
.db-picker select, .sample-queries select {
  font-family: var(--font-sans);
  background: #FFFFFF;
  color: var(--text);
  border: 1px solid var(--border);
  border-radius: var(--radius);
  padding: 7px 10px;
  font-size: 13.5px;
}
.db-description {
  padding: 12px 16px;
  background: var(--fgz-himmelblau-pastell);
  border-left: 3px solid var(--fgz-himmelblau);
  border-radius: var(--radius);
  margin-bottom: 14px;
  font-size: 14px;
  line-height: 1.55;
  color: #074f70;
}
.db-description:empty { display: none; }

.schema-viewer:empty { display: none; }
.schema-viewer { display: grid; grid-template-columns: repeat(auto-fill, minmax(280px, 1fr)); gap: 12px; margin-bottom: 16px; }
.schema-table {
  background: #FFFFFF;
  border-radius: var(--radius-lg);
  padding: 12px 14px;
  border: 1px solid var(--border);
  box-shadow: var(--shadow-sm);
  transition: border-color 0.15s, box-shadow 0.15s;
}
.schema-table:hover { border-color: var(--fgz-blau); }
.schema-table-header {
  font-family: var(--font-mono);
  font-weight: 700;
  font-size: 13.5px;
  color: var(--fgz-blau);
  margin-bottom: 8px;
  cursor: pointer;
  user-select: none;
}
.schema-table-cols {
  font-family: var(--font-mono);
  font-size: 12px;
  color: var(--text-muted);
  line-height: 1.7;
}
.schema-table-cols .pk { color: var(--fgz-honig); font-weight: 700; }
.schema-table-cols .fk { color: var(--fgz-pflaume); font-weight: 700; }

/* ---------- Editor ---------- */
.editor-wrapper { margin-bottom: 14px; }
.editor-toolbar {
  display: flex;
  align-items: center;
  gap: 10px;
  padding: 10px 12px;
  background: var(--bg-soft);
  border: 1px solid var(--border);
  border-bottom: none;
  border-radius: var(--radius-lg) var(--radius-lg) 0 0;
  flex-wrap: wrap;
}
.sample-queries { margin-left: auto; display: flex; align-items: center; gap: 8px; font-size: 12px; color: var(--text-muted); }
.sample-queries select { max-width: 280px; }

#sql-editor {
  width: 100%;
  min-height: 200px;
  padding: 14px 16px;
  background: var(--bg-code);
  color: #DCE6F8;
  font-family: var(--font-mono);
  font-size: 14px;
  line-height: 1.55;
  border: 1px solid var(--border);
  border-radius: 0 0 var(--radius-lg) var(--radius-lg);
  resize: vertical;
  tab-size: 2;
  outline: none;
}
#sql-editor:focus { border-color: var(--fgz-blau); box-shadow: 0 0 0 3px var(--fgz-blau-pastell); }

/* ---------- Result-Tabellen ---------- */
.query-results:empty { display: none; }
.result-block {
  margin-top: 16px;
  border: 1px solid var(--border);
  border-radius: var(--radius-lg);
  overflow: hidden;
  background: #FFFFFF;
  box-shadow: var(--shadow-sm);
}
.result-header {
  padding: 9px 14px;
  background: var(--bg-soft);
  font-size: 12px;
  color: var(--text-soft);
  display: flex;
  justify-content: space-between;
  font-family: var(--font-mono);
  border-bottom: 1px solid var(--border);
}
.result-table-wrapper { overflow-x: auto; max-height: 420px; }
.result-table {
  width: 100%;
  border-collapse: collapse;
  font-family: var(--font-mono);
  font-size: 13px;
  background: #FFFFFF;
}
.result-table th, .result-table td {
  padding: 8px 14px;
  border-bottom: 1px solid var(--border);
  text-align: left;
  white-space: nowrap;
}
.result-table th {
  background: var(--fgz-blau-pastell);
  color: var(--fgz-nachtblau);
  position: sticky;
  top: 0;
  font-weight: 700;
}
.result-table tr:hover td { background: var(--bg-soft); }
.result-table .null { color: var(--text-muted); font-style: italic; }

.result-error {
  padding: 14px 16px;
  background: var(--fgz-aprikose-pastell);
  color: #a13b1c;
  border-radius: var(--radius-lg);
  font-family: var(--font-mono);
  font-size: 13px;
  white-space: pre-wrap;
  margin-top: 14px;
  border-left: 4px solid var(--fgz-aprikose);
}
.result-info {
  padding: 12px 16px;
  background: var(--fgz-pistazie-pastell);
  color: #4a6a00;
  border-radius: var(--radius-lg);
  font-size: 14px;
  margin-top: 14px;
  border-left: 4px solid var(--fgz-pistazie);
}

/* ---------- Übungen ---------- */
.exercises-section {
  margin-top: 40px;
  padding-top: 26px;
  border-top: 2px solid var(--fgz-blau-pastell);
}
.exercises-section h2 { color: var(--fgz-blau); font-size: var(--fs-h3); margin: 0; font-weight: 900; }
.exercises-header {
  display: flex;
  justify-content: space-between;
  align-items: center;
  flex-wrap: wrap;
  gap: 16px;
  margin-bottom: 8px;
}
.progress-bar-wrapper {
  display: flex;
  align-items: center;
  gap: 12px;
  margin-bottom: 18px;
  min-width: 220px;
}
.progress-bar {
  flex: 1;
  height: 8px;
  background: var(--bg-soft);
  border: 1px solid var(--border);
  border-radius: 4px;
  overflow: hidden;
}
.progress-fill {
  height: 100%;
  background: linear-gradient(90deg, var(--fgz-blau), var(--fgz-himmelblau));
  width: 0%;
  transition: width 0.4s;
}
.progress-label { font-size: 12px; color: var(--text-muted); font-family: var(--font-mono); min-width: 60px; text-align: right; }

.exercise {
  background: #FFFFFF;
  border: 1px solid var(--border);
  border-radius: var(--radius-lg);
  padding: 20px 24px;
  margin-bottom: 18px;
  box-shadow: var(--shadow-sm);
  transition: border-color 0.2s, box-shadow 0.2s;
}
.exercise:hover { box-shadow: var(--shadow-md); }
.exercise.solved {
  border-color: var(--fgz-pistazie);
  background: linear-gradient(135deg, #FFFFFF 0%, var(--fgz-pistazie-pastell) 130%);
}
.exercise-title {
  display: flex;
  align-items: center;
  gap: 10px;
  margin-bottom: 10px;
  flex-wrap: wrap;
}
.exercise-title h3 { margin: 0; font-size: 17px; font-weight: 900; color: var(--fgz-nachtblau); }

.difficulty-badge { display: none; }

.db-chip {
  display: inline-block;
  padding: 3px 10px;
  background: var(--bg-soft);
  color: var(--text-soft);
  border: 1px solid var(--border);
  border-radius: 10px;
  font-family: var(--font-mono);
  font-size: 10px;
  font-weight: 700;
}
.solved-check {
  margin-left: auto;
  color: var(--fgz-pistazie);
  font-size: 22px;
  font-weight: 900;
}

.exercise-prompt { color: var(--text); line-height: 1.65; margin-bottom: 14px; font-size: 15px; }
.exercise-prompt code {
  background: var(--bg-code-soft);
  padding: 1px 6px;
  border-radius: 3px;
  font-family: var(--font-mono);
  font-size: 13px;
  color: var(--fgz-nachtblau);
  border: 1px solid var(--border);
}

.exercise-hints { margin-bottom: 10px; }
.hint-item {
  margin: 8px 0;
  animation: slide-in 0.25s ease;
  font-size: 14px;
}
@keyframes slide-in {
  from { opacity: 0; transform: translateY(-4px); }
  to   { opacity: 1; transform: translateY(0); }
}
.hint-counter {
  display: inline-block;
  margin-left: 4px;
  padding: 1px 6px;
  background: var(--fgz-blau-pastell);
  color: var(--fgz-nachtblau);
  border-radius: 8px;
  font-family: var(--font-mono);
  font-size: 10px;
  font-weight: 700;
}

.exercise-editor {
  width: 100%;
  min-height: 90px;
  padding: 12px 14px;
  background: var(--bg-code);
  color: #DCE6F8;
  font-family: var(--font-mono);
  font-size: 13.5px;
  line-height: 1.55;
  border: 1px solid var(--border);
  border-radius: var(--radius);
  resize: vertical;
  tab-size: 2;
  outline: none;
  margin-bottom: 12px;
}
.exercise-editor:focus { border-color: var(--fgz-blau); box-shadow: 0 0 0 3px var(--fgz-blau-pastell); }

.exercise-actions { display: flex; gap: 10px; flex-wrap: wrap; }

.exercise-feedback {
  margin-top: 14px;
  padding: 11px 14px;
  border-radius: var(--radius);
  font-size: 14px;
  line-height: 1.55;
  border-left: 4px solid;
}
.exercise-feedback.success { background: var(--fgz-pistazie-pastell); border-color: var(--fgz-pistazie); color: #3d5800; }
.exercise-feedback.error   { background: var(--fgz-aprikose-pastell); border-color: var(--fgz-aprikose); color: #a13b1c; }
.exercise-feedback.info    { background: var(--fgz-himmelblau-pastell); border-color: var(--fgz-himmelblau); color: #074f70; }

.exercise-comparison {
  margin-top: 12px;
  display: grid;
  grid-template-columns: 1fr 1fr;
  gap: 12px;
}
.exercise-comparison > div {
  background: #FFFFFF;
  border: 1px solid var(--border);
  border-radius: var(--radius);
  overflow: auto;
  max-height: 260px;
}
.exercise-comparison h4 {
  margin: 0;
  padding: 7px 12px;
  font-size: 11px;
  text-transform: uppercase;
  letter-spacing: 0.6px;
  color: var(--fgz-nachtblau);
  border-bottom: 1px solid var(--border);
  background: var(--bg-soft);
  position: sticky;
  top: 0;
  font-weight: 700;
}
.exercise-comparison table {
  width: 100%;
  font-family: var(--font-mono);
  font-size: 12px;
  border-collapse: collapse;
}
.exercise-comparison th, .exercise-comparison td {
  padding: 5px 12px;
  border-bottom: 1px solid var(--border);
  text-align: left;
  white-space: nowrap;
}
.exercise-comparison th { color: var(--fgz-blau); }

.solution-block {
  margin-top: 12px;
  background: var(--bg-code);
  border-left: 4px solid var(--fgz-pflaume);
  padding: 12px 14px;
  border-radius: var(--radius);
  font-family: var(--font-mono);
  font-size: 13px;
  line-height: 1.55;
  white-space: pre-wrap;
  color: #DCE6F8;
}

/* ---------- Exercise type chips ---------- */
.type-chip {
  display: inline-block;
  padding: 3px 10px;
  border-radius: 10px;
  font-size: 10px;
  font-family: var(--font-mono);
  font-weight: 700;
  letter-spacing: 0.4px;
  text-transform: uppercase;
}
.type-chip.type-sql   { background: var(--fgz-blau-pastell);     color: var(--fgz-nachtblau); }
.type-chip.type-mc    { background: var(--fgz-pflaume-pastell);  color: #4a338f; }
.type-chip.type-tf    { background: var(--fgz-minzgruen-pastell);color: #00604f; }
.type-chip.type-order { background: var(--fgz-himmelblau-pastell);color: #064f73; }

/* ---------- Multiple Choice / TF ---------- */
.mc-options {
  display: flex;
  flex-direction: column;
  gap: 8px;
  margin-bottom: 14px;
}
.mc-option {
  display: flex;
  align-items: center;
  gap: 12px;
  padding: 12px 14px;
  background: #FFFFFF;
  border: 2px solid var(--border);
  border-radius: var(--radius-lg);
  cursor: pointer;
  transition: border-color 0.15s, background 0.15s;
}
.mc-option:hover { border-color: var(--fgz-blau); background: var(--bg-soft); }
.mc-option input { position: absolute; opacity: 0; pointer-events: none; }
.mc-option .mc-letter {
  display: grid;
  place-items: center;
  width: 28px; height: 28px;
  border-radius: 50%;
  background: var(--bg-soft);
  border: 1px solid var(--border);
  color: var(--text-soft);
  font-family: var(--font-mono);
  font-weight: 700;
  font-size: 13px;
  flex-shrink: 0;
}
.mc-option.selected {
  border-color: var(--fgz-blau);
  background: var(--fgz-blau-pastell);
}
.mc-option.selected .mc-letter {
  background: var(--fgz-blau);
  color: #FFFFFF;
  border-color: var(--fgz-blau);
}
.mc-option.correct {
  border-color: var(--fgz-pistazie);
  background: var(--fgz-pistazie-pastell);
}
.mc-option.correct .mc-letter {
  background: var(--fgz-pistazie);
  color: #FFFFFF;
  border-color: var(--fgz-pistazie);
}
.mc-option.wrong {
  border-color: var(--fgz-aprikose);
  background: var(--fgz-aprikose-pastell);
}
.mc-option.wrong .mc-letter {
  background: var(--fgz-aprikose);
  color: #FFFFFF;
  border-color: var(--fgz-aprikose);
}
.mc-option .mc-text {
  flex: 1;
  font-size: 14.5px;
  line-height: 1.45;
  color: var(--text);
}
.mc-option .mc-text code {
  background: var(--bg-code-soft);
  padding: 1px 6px;
  border-radius: 3px;
  font-family: var(--font-mono);
  font-size: 13px;
  color: var(--fgz-nachtblau);
  border: 1px solid var(--border);
}

/* ---------- Order list (sortable up/down) ---------- */
.order-list {
  list-style: none;
  margin: 0 0 14px;
  padding: 0;
  counter-reset: order-counter;
}
.order-item {
  display: flex;
  align-items: center;
  gap: 12px;
  padding: 10px 14px;
  background: #FFFFFF;
  border: 2px solid var(--border);
  border-radius: var(--radius-lg);
  margin-bottom: 6px;
  counter-increment: order-counter;
  transition: border-color 0.15s, background 0.15s, transform 0.15s;
}
.order-item::before {
  content: counter(order-counter);
  display: grid;
  place-items: center;
  width: 28px; height: 28px;
  border-radius: 50%;
  background: var(--fgz-blau-pastell);
  color: var(--fgz-nachtblau);
  font-family: var(--font-mono);
  font-weight: 700;
  font-size: 13px;
  flex-shrink: 0;
}
.order-item.correct {
  border-color: var(--fgz-pistazie);
  background: var(--fgz-pistazie-pastell);
}
.order-item.wrong {
  border-color: var(--fgz-aprikose);
  background: var(--fgz-aprikose-pastell);
}
.order-text {
  flex: 1;
  font-family: var(--font-mono);
  font-size: 14px;
  color: var(--text);
}
.order-arrows {
  display: flex;
  flex-direction: column;
  gap: 2px;
}
.order-arrow {
  width: 26px; height: 22px;
  border: 1px solid var(--border);
  background: #FFFFFF;
  cursor: pointer;
  border-radius: 4px;
  font-size: 12px;
  color: var(--fgz-blau);
  font-weight: 700;
  display: grid;
  place-items: center;
  padding: 0;
}
.order-arrow:hover:not(:disabled) { background: var(--fgz-blau-pastell); }
.order-arrow:disabled { opacity: 0.3; cursor: not-allowed; }

/* MC/Order solution block override (it's HTML, not pre) */
.exercise-mc .solution-block,
.exercise-order .solution-block,
.exercise-tf .solution-block {
  background: var(--fgz-pflaume-pastell);
  color: #2a1d5a;
  border-left-color: var(--fgz-pflaume);
  font-family: var(--font-sans);
  white-space: normal;
  font-size: 14px;
}

/* ---------- Inline Daten-Vorschau ---------- */
.table-preview {
  margin: -4px 4px 12px 16px;
  border: 2px solid var(--fgz-blau);
  border-radius: var(--radius);
  overflow: hidden;
  animation: slide-in 0.2s ease;
  background: #FFFFFF;
}
.table-preview .result-header {
  background: var(--fgz-blau-pastell);
  color: var(--fgz-nachtblau);
  font-size: 11px;
  padding: 6px 12px;
}
.table-preview .result-table { font-size: 12px; }
.table-preview .result-table th, .table-preview .result-table td { padding: 4px 10px; }
.table-preview .result-table-wrapper { max-height: 260px; }

/* ---------- Lesson nav ---------- */
.lesson-nav {
  margin-top: 50px;
  padding-top: 24px;
  border-top: 2px solid var(--fgz-blau-pastell);
  display: flex;
  justify-content: space-between;
  gap: 10px;
}
.lesson-nav .btn { padding: 11px 22px; font-size: 14px; }

/* ---------- Footer ---------- */
.app-footer a { color: var(--fgz-blau); }

/* ---------- Responsive ---------- */
@media (max-width: 1100px) {
  .main-content { padding: 24px 28px; }
  .schema-viewer { grid-template-columns: 1fr 1fr; }
}
@media (max-width: 900px) {
  .sidebar { width: 240px; }
  .exercise-comparison { grid-template-columns: 1fr; }
  html, body { overflow: auto; }
  .app-body { overflow: visible; }
  .schema-viewer { grid-template-columns: 1fr; }
}
@media (max-width: 640px) {
  .app-header { flex-direction: column; align-items: flex-start; gap: 10px; padding: 14px 18px; }
  .sidebar { width: 100%; height: auto; border-right: none; border-bottom: 1px solid var(--border); }
  .app-body { flex-direction: column; }
  .main-content { padding: 18px; }
  .brand-logo { height: 36px; }
  #theory-content h1 { font-size: 28px; }
  #theory-content h2 { font-size: 22px; }
}