/* ===== Classio SQL 练习场 ===== */
:root {
  --sql-green: #3eaf7c;
  --sql-green-dark: #2f8f65;
  --sql-green-soft: #e9f6ef;
  --sql-blue: #2f6fbf;
  --sql-ink: #24292f;
  --sql-muted: #6b7a8c;
  --sql-line: #e5e9ed;
  --sql-bg: #f7f9fa;
  --sql-warn: #9a6b00;
  --sql-warn-bg: #fff8e6;
  --sql-err: #b3261e;
  --sql-err-bg: #fff2f0;
  --sql-mono: Consolas, Monaco, "Andale Mono", "Ubuntu Mono", monospace;
}

/* ---------- 课程页 SQL 代码块 ---------- */
.sql-example {
  margin: 20px 0;
  border: 1px solid var(--sql-line);
  border-radius: 8px;
  overflow: hidden;
  background: #fff;
  box-shadow: 0 1px 2px rgba(36, 41, 47, .03);
}
.content .sql-example > pre,
.sql-example > pre {
  margin: 0;
  border-radius: 0;
}
/* 课程页内联编辑：进入编辑时用 textarea 代替高亮代码块 */
.sql-example.is-editing > pre { display: none; }
.sql-example-editor {
  display: block;
  width: 100%;
  min-height: 9em;
  box-sizing: border-box;
  margin: 0;
  padding: 14px 16px;
  border: 0;
  background: #0e1621;
  color: #e6edf3;
  font-family: var(--sql-mono);
  font-size: 13px;
  line-height: 1.65;
  tab-size: 2;
  resize: vertical;
  outline: none;
}
.sql-example-editor:focus { box-shadow: inset 0 0 0 2px rgba(110, 231, 183, .35); }
/* 非数据库课程的 SQL 块：不显示运行条，恢复成普通代码块外观 */
.sql-example.sql-example--plain {
  border: 0;
  box-shadow: none;
  border-radius: 0;
  background: transparent;
  margin: 18px 0;
}
.content .sql-example.sql-example--plain > pre,
.sql-example.sql-example--plain > pre {
  border-radius: 6px;
}
.sql-example-bar {
  display: flex;
  align-items: center;
  flex-wrap: wrap;
  gap: 8px;
  padding: 8px 12px;
  background: var(--sql-bg);
  border-top: 1px solid var(--sql-line);
}
.sql-run-btn,
.sql-edit-btn,
.sql-open-btn,
.sqlp-run,
.sqlp-btn,
.sqlp-clear,
.sqlp-refresh,
.sqlp-wipe {
  font-family: inherit;
  cursor: pointer;
  border-radius: 5px;
  border: 1px solid transparent;
  transition: background .15s ease, border-color .15s ease, color .15s ease;
}
.sql-run-btn {
  font-size: 12.5px;
  font-weight: 600;
  color: #fff;
  background: var(--sql-green);
  border-color: var(--sql-green);
  padding: 4px 12px;
}
.sql-run-btn:hover { background: var(--sql-green-dark); border-color: var(--sql-green-dark); }
.sql-run-btn:disabled { opacity: .65; cursor: progress; }
.sql-edit-btn {
  font-size: 12.5px;
  color: #5b6b7c;
  background: #fff;
  border-color: #d5dee8;
  padding: 4px 10px;
}
.sql-edit-btn:hover { background: #f6f8fa; color: #24313f; border-color: #b9c7d6; }
.sql-edit-btn.is-active { color: #9a5b00; background: #fff8eb; border-color: #efc36a; }
.sql-open-btn {
  font-size: 12.5px;
  color: var(--sql-blue);
  background: #fff;
  border-color: #c9d8ea;
  padding: 4px 10px;
}
.sql-open-btn:hover { background: #f0f6ff; border-color: var(--sql-blue); }
.sql-example-badge {
  font-size: 11px;
  letter-spacing: .02em;
  color: #2f8f65;
  background: var(--sql-green-soft);
  border: 1px solid #cceedd;
  border-radius: 999px;
  padding: 2px 8px;
  white-space: nowrap;
}
.sql-example-spacer { flex: 1 1 auto; }
.sql-example-hint { font-size: 11.5px; color: #9aa7b4; white-space: nowrap; }
.sql-example-out {
  padding: 12px;
  border-top: 1px solid var(--sql-line);
  background: #fbfcfd;
  font-size: 13px;
}
.sql-example-out.has-error { background: #fffafa; }
.sql-rebuild-box {
  margin: 12px 0 0;
  padding: 12px 14px;
  border: 1px solid #efc36a;
  border-radius: 6px;
  background: #fffaf0;
  font-size: 13px;
}
.sql-rebuild-box p { margin: 0 0 8px; color: #7a4b00; line-height: 1.6; }
.sql-rebuild-btn {
  font-family: inherit;
  font-size: 12.5px;
  font-weight: 600;
  color: #fff;
  background: #c77700;
  border: 1px solid #c77700;
  border-radius: 5px;
  padding: 5px 12px;
  cursor: pointer;
}
.sql-rebuild-btn:hover { background: #a86100; border-color: #a86100; }
.sql-rebuild-btn:disabled { opacity: .65; cursor: progress; }
.sql-rebuild-note { margin-left: 8px; color: #8a6a3a; font-size: 12px; }

/* ---------- 结果 ---------- */
.sql-res {
  margin: 8px 0 14px;
  border: 1px solid var(--sql-line);
  border-radius: 6px;
  overflow: hidden;
  background: #fff;
}
.sql-res:last-child { margin-bottom: 0; }
.sql-res-meta {
  display: flex;
  align-items: center;
  flex-wrap: wrap;
  gap: 10px;
  padding: 6px 10px;
  background: #f6f8fa;
  border-bottom: 1px solid var(--sql-line);
  color: var(--sql-muted);
  font-size: 12px;
}
.sql-res-tag {
  color: #2f8f65;
  background: var(--sql-green-soft);
  border-radius: 4px;
  padding: 1px 7px;
  font-weight: 600;
}
.sql-table-wrap {
  max-height: 380px;
  overflow: auto;
}
.content .sql-table {
  display: table;
  width: 100%;
  margin: 0;
  border-collapse: collapse;
  border: 0;
  font-family: var(--sql-mono);
  font-size: 12.5px;
}
.content .sql-table th,
.content .sql-table td {
  border: 0;
  border-right: 1px solid #eef1f4;
  border-bottom: 1px solid #eef1f4;
  padding: 6px 10px;
  text-align: left;
  vertical-align: top;
  white-space: pre-wrap;
  word-break: break-word;
  max-width: 420px;
}
.content .sql-table th {
  position: sticky;
  top: 0;
  z-index: 1;
  background: #f1f4f7;
  color: #34495e;
  font-weight: 600;
  white-space: nowrap;
}
.content .sql-table tr:nth-child(2n) { background: #fafcfd; }
.content .sql-table tr:hover { background: #f2fbf6; }
.content .sql-table th:last-child,
.content .sql-table td:last-child { border-right: 0; }
.sql-empty-cell { color: #9aa7b4; text-align: center !important; padding: 18px !important; }
.sql-null { color: #9aa7b4; font-style: italic; }
.sql-res-note {
  margin: 0;
  padding: 6px 10px;
  border-top: 1px solid #eef1f4;
  color: var(--sql-muted);
  font-size: 12px;
}

/* ---------- 消息 ---------- */
.sql-msg {
  margin: 8px 0;
  padding: 10px 12px;
  border-radius: 5px;
  border-left: 4px solid var(--sql-green);
  background: #f3fbf6;
  font-size: 13px;
  line-height: 1.65;
}
.sql-msg p { margin: 4px 0; }
.sql-msg strong { display: block; margin-bottom: 2px; }
.sql-msg-ok { color: #23684a; }
.sql-msg-warn {
  border-left-color: #e7c000;
  background: var(--sql-warn-bg);
  color: #6b5200;
}
.sql-msg-error {
  border-left-color: var(--sql-err);
  background: var(--sql-err-bg);
  color: #7a1d17;
}
.sql-msg-hint { color: #7a6a3a; font-size: 12px; }
.sql-msg-time { float: right; color: #9aa7b4; font-size: 11.5px; }
.sql-err-sql { margin: 8px 0 2px; }
.sql-err-sql > span {
  display: block;
  margin-bottom: 3px;
  color: #9a3b34;
  font-size: 11.5px;
  font-weight: 600;
}
.sql-err-sql > pre {
  margin: 0;
  padding: 8px 10px;
  background: #fff7f6;
  border: 1px solid #f0c9c5;
  border-radius: 4px;
  color: #6b2b26;
  font-family: var(--sql-mono);
  font-size: 12px;
  line-height: 1.55;
  white-space: pre-wrap;
  overflow-x: auto;
}
.sql-err-detail {
  margin-top: 6px;
  border: 0;
  background: transparent;
}
.sql-err-detail summary {
  cursor: pointer;
  color: #9a5a54;
  font-size: 12px;
  background: transparent;
  padding: 2px 0;
  border: 0;
}
.content .sql-err-detail > pre {
  margin: 6px 0 0;
  padding: 8px 10px;
  background: #2b2f36;
  border-radius: 4px;
  color: #e6a6a0;
  font-size: 12px;
  white-space: pre-wrap;
}
.sql-loading {
  display: flex;
  align-items: center;
  gap: 8px;
  color: var(--sql-muted);
  font-size: 13px;
  padding: 8px 2px;
}
.sql-spinner {
  width: 14px;
  height: 14px;
  border: 2px solid #d7e3dd;
  border-top-color: var(--sql-green);
  border-radius: 50%;
  animation: sql-spin .7s linear infinite;
}
@keyframes sql-spin { to { transform: rotate(360deg); } }
.sql-out-title {
  margin: 4px 0 8px;
  color: var(--sql-muted);
  font-size: 12px;
  letter-spacing: .04em;
  text-transform: uppercase;
}
.sql-init-warn {
  margin: 0 0 10px;
  border: 1px solid #f0dfa8;
  border-radius: 5px;
  background: #fffdf4;
  font-size: 12.5px;
}
.sql-init-warn summary {
  cursor: pointer;
  padding: 7px 10px;
  color: var(--sql-warn);
  background: transparent;
  border: 0;
  font-weight: 600;
}
.sql-init-warn ul { margin: 0; padding: 0 14px 8px 28px; color: #6b5a2a; }
.sql-init-warn li { margin: 3px 0; }

/* ---------- 练习场页面 ---------- */
.content .sqlp,
.sqlp {
  margin: 26px 0 40px;
  border: 1px solid var(--sql-line);
  border-radius: 10px;
  overflow: hidden;
  background: #fff;
  box-shadow: 0 2px 10px rgba(36, 41, 47, .04);
}
.sqlp-head {
  padding: 16px 18px 12px;
  background: linear-gradient(180deg, #fbfdfc 0%, #f6faf8 100%);
  border-bottom: 1px solid var(--sql-line);
}
.sqlp-title {
  display: flex;
  align-items: center;
  flex-wrap: wrap;
  gap: 8px;
  font-size: 17px;
  font-weight: 700;
  color: var(--sql-ink);
}
.sqlp-dot {
  width: 9px;
  height: 9px;
  border-radius: 50%;
  background: var(--sql-green);
  box-shadow: 0 0 0 4px rgba(62, 175, 124, .12);
}
.sqlp-badge {
  font-size: 11px;
  font-weight: 500;
  color: #2f8f65;
  background: var(--sql-green-soft);
  border: 1px solid #cceedd;
  border-radius: 999px;
  padding: 2px 8px;
}
.sqlp-sub { margin-top: 4px; color: var(--sql-muted); font-size: 12.5px; }
.sqlp-toolbar {
  display: flex;
  align-items: center;
  flex-wrap: wrap;
  gap: 8px 12px;
  padding: 10px 14px;
  background: var(--sql-bg);
  border-bottom: 1px solid var(--sql-line);
}
.sqlp-field {
  display: inline-flex;
  align-items: center;
  gap: 6px;
  font-size: 12.5px;
  color: var(--sql-muted);
  white-space: nowrap;
}
.sqlp-field select {
  font-family: inherit;
  font-size: 12.5px;
  color: var(--sql-ink);
  background: #fff;
  border: 1px solid #d6dde4;
  border-radius: 5px;
  padding: 4px 8px;
  max-width: 240px;
}
.sqlp-field select:focus { outline: 2px solid rgba(62, 175, 124, .25); border-color: var(--sql-green); }
.sqlp-btn {
  font-size: 12.5px;
  color: var(--sql-ink);
  background: #fff;
  border-color: #d6dde4;
  padding: 4px 10px;
}
.sqlp-btn:hover { border-color: var(--sql-green); color: var(--sql-green-dark); }
.sqlp-status {
  margin-left: auto;
  font-size: 12px;
  color: var(--sql-muted);
  white-space: nowrap;
}
.sqlp-status.is-ok { color: #2f8f65; }
.sqlp-status.is-err { color: var(--sql-err); }
.sqlp-note {
  padding: 9px 14px;
  background: var(--sql-warn-bg);
  border-bottom: 1px solid #f0dfa8;
  color: #6b5200;
  font-size: 12.5px;
  line-height: 1.7;
}
.sqlp-grid {
  display: grid;
  grid-template-columns: minmax(0, 1fr) 260px;
  gap: 0;
  align-items: stretch;
}
.sqlp-main { min-width: 0; padding: 14px; }
.sqlp-editor-head {
  display: flex;
  justify-content: space-between;
  align-items: baseline;
  gap: 8px;
  margin-bottom: 6px;
  color: var(--sql-muted);
  font-size: 12px;
}
.sqlp-kbd { color: #9aa7b4; font-size: 11.5px; }
.sqlp-editor-shell {
  display: flex;
  min-height: 230px;
  max-height: 440px;
  border-radius: 7px;
  overflow: hidden;
  background: #282c34;
  border: 1px solid #1f2329;
}
.sqlp-gutter {
  flex: none;
  min-width: 42px;
  margin: 0;
  padding: 14px 8px 14px 6px;
  background: #21252b;
  color: #636d7a;
  text-align: right;
  font-family: var(--sql-mono);
  font-size: 13px;
  line-height: 1.6;
  overflow: hidden;
  user-select: none;
  white-space: pre;
}
.sqlp-editor {
  flex: 1;
  min-width: 0;
  margin: 0;
  padding: 14px;
  border: 0;
  outline: 0;
  resize: none;
  background: transparent;
  color: #d7dae0;
  font-family: var(--sql-mono);
  font-size: 13px;
  line-height: 1.6;
  white-space: pre;
  overflow: auto;
  tab-size: 2;
}
.sqlp-editor::selection { background: rgba(62, 175, 124, .35); }
.sqlp-actions {
  display: flex;
  align-items: center;
  flex-wrap: wrap;
  gap: 8px;
  padding: 10px 0 2px;
}
.sqlp-run {
  font-size: 13px;
  font-weight: 700;
  color: #fff;
  background: var(--sql-green);
  border-color: var(--sql-green);
  padding: 6px 18px;
}
.sqlp-run:hover { background: var(--sql-green-dark); border-color: var(--sql-green-dark); }
.sqlp-run:disabled { opacity: .65; cursor: progress; }
.sqlp-clear,
.sqlp-refresh {
  font-size: 12.5px;
  color: var(--sql-muted);
  background: transparent;
  border-color: #d6dde4;
  padding: 4px 10px;
}
.sqlp-clear:hover,
.sqlp-refresh:hover { color: var(--sql-ink); border-color: #aab6c1; }
.sqlp-run-hint { color: #9aa7b4; font-size: 11.5px; }
.sqlp-out { margin-top: 12px; }
.sqlp-side {
  min-width: 0;
  padding: 14px;
  border-left: 1px solid var(--sql-line);
  background: #fbfcfd;
  display: flex;
  flex-direction: column;
}
.sqlp-side-head {
  display: flex;
  align-items: baseline;
  justify-content: space-between;
  gap: 8px;
  margin-bottom: 8px;
  font-size: 12px;
  color: var(--sql-muted);
}
.sqlp-tables {
  min-height: 80px;
  max-height: 400px;
  overflow: auto;
}
.sqlp-table-item {
  display: flex;
  align-items: baseline;
  justify-content: space-between;
  gap: 8px;
  width: 100%;
  padding: 6px 7px;
  border: 0;
  border-bottom: 1px dashed #e9edf1;
  background: transparent;
  color: var(--sql-ink);
  font-family: var(--sql-mono);
  font-size: 12.5px;
  text-align: left;
  cursor: pointer;
}
.sqlp-table-item:hover { background: var(--sql-green-soft); color: var(--sql-green-dark); }
.sqlp-table-type {
  flex: none;
  color: #9aa7b4;
  font-family: var(--font-sans);
  font-size: 11px;
}
.sqlp-empty {
  margin: 10px 2px;
  color: #9aa7b4;
  font-size: 12.5px;
  line-height: 1.7;
}
.sqlp-side-foot {
  margin-top: auto;
  padding-top: 14px;
  border-top: 1px dashed #e2e8ee;
}
.sqlp-wipe {
  font-size: 11.5px;
  color: #a05a54;
  background: transparent;
  border-color: transparent;
  padding: 2px 0;
  text-decoration: underline;
  text-underline-offset: 3px;
}
.sqlp-wipe:hover { color: var(--sql-err); }
.sqlp-side .sql-msg { font-size: 12.5px; }

/* ---------- 响应式 ---------- */
@media (max-width: 900px) {
  .sqlp-grid { grid-template-columns: 1fr; }
  .sqlp-side {
    border-left: 0;
    border-top: 1px solid var(--sql-line);
    padding-top: 12px;
  }
  .sqlp-status { margin-left: 0; width: 100%; }
  .sql-example-hint { display: none; }
  .content .sql-table th,
  .content .sql-table td { max-width: 260px; }
}
@media (max-width: 620px) {
  .sqlp-toolbar { gap: 8px; }
  .sqlp-field { width: 100%; }
  .sqlp-field select { flex: 1; max-width: none; }
  .sqlp-btn { flex: 1 1 auto; text-align: center; }
  .sqlp-main { padding: 10px; }
  .sqlp-editor-shell { min-height: 190px; }
  .sqlp-editor { font-size: 12.5px; }
  .sqlp-gutter { font-size: 12.5px; }
  .sql-example-bar { gap: 6px; }
  .sql-run-btn,
  .sql-open-btn { padding: 4px 8px; }
  .sql-example-badge { display: none; }
}