/* ── postgresql_guide.css ────────────────────────────────────────────
   PostgreSQL Migration Guide - aligned with knowledge_graph_update.css
   ──────────────────────────────────────────────────────────────────── */

/* Override base content width to match KG */
.pg-content {
  max-width: 960px !important;
}

/* ── Icon helper ─────────────────────────────────────────────────── */

.icon {
  display: inline-block;
  width: 1em;
  height: 1em;
  stroke-width: 0;
  stroke: currentColor;
  fill: currentColor;
}
.icon-lucide {
  fill: none;
  stroke-width: 2;
  stroke-linecap: round;
  stroke-linejoin: round;
}
.icon-inline-arrow {
  width: 0.9em;
  height: 0.9em;
  vertical-align: -0.12em;
  opacity: 0.6;
}

/* ── Header Actions ─────────────────────────────────────────────── */

.header-actions {
  position: absolute;
  top: 1.5rem;
  left: 1.5rem;
  right: 1.5rem;
  display: flex;
  justify-content: space-between;
  align-items: center;
  z-index: 100;
}

/* Match .hero-badge pill style */
.back-btn {
  display: inline-flex;
  align-items: center;
  gap: 0.45rem;
  font-family: var(--font-accent);
  font-size: 0.75rem;
  font-weight: 500;
  color: var(--text-2);
  background: var(--bg-card);
  border: 1px solid var(--border-mid);
  padding: 0.35rem 0.75rem;
  border-radius: 8px;
  transition: color 0.15s, border-color 0.15s, background 0.15s, box-shadow 0.15s;
  box-shadow: 0 1px 3px rgba(0,0,0,0.06);
}

.back-btn:hover {
  color: var(--text);
  border-color: var(--border-strong);
  background: var(--bg-subtle);
  box-shadow: 0 2px 6px rgba(0,0,0,0.08);
}

.back-btn .icon { width: 0.8rem; height: 0.8rem; flex-shrink: 0; }

/* ── Page Header ─────────────────────────────────────────────────── */

.pg-header {
  text-align: center;
  margin-bottom: 2rem;
  padding-top: 4rem; /* space for absolute header-actions bar */
}

.pg-header__title {
  font-size: clamp(1.8rem, 4vw, 2.75rem);
  font-weight: 700;
  letter-spacing: -0.03em;
  line-height: 1.15;
  color: var(--text);
  margin: 0 0 0.75rem;
}

.pg-header__title span { color: var(--accent); }

.pg-header__sub {
  font-size: 0.875rem;
  color: var(--text-2);
  line-height: 1.65;
  font-weight: 300;
  max-width: 560px;
  margin: 0 auto 1.5rem;
}

/* ── Stats bar ───────────────────────────────────────────────────── */

.pg-stats {
  display: inline-flex;
  align-items: center;
  gap: 0;
  background: var(--bg-card);
  border: 1px solid var(--border);
  border-radius: 12px;
  padding: 0.625rem 0;
  box-shadow: var(--shadow-card);
}

.pg-stat {
  display: flex;
  flex-direction: column;
  align-items: center;
  padding: 0 1.5rem;
  gap: 0.1rem;
}

.pg-stat__val {
  font-size: 1.25rem;
  font-weight: 700;
  letter-spacing: -0.03em;
  color: var(--accent);
  font-variant-numeric: tabular-nums;
}

.pg-stat__lbl {
  font-size: 0.68rem;
  color: var(--text-3);
  font-weight: 400;
  white-space: nowrap;
}

.pg-stat__sep {
  width: 1px;
  height: 2rem;
  background: var(--border);
  flex-shrink: 0;
}

/* ── Section wrapper ─────────────────────────────────────────────── */

.pg-section {
  background: var(--bg-card);
  border: 1px solid var(--border);
  border-radius: 14px;
  overflow: hidden;
  box-shadow: var(--shadow-card);
  margin-bottom: 1rem;
  transition: box-shadow 0.3s;
}

.pg-section:hover {
  box-shadow: var(--shadow-hover);
}

/* Section header bar */
.pg-section__head {
  display: flex;
  align-items: center;
  gap: 0.75rem;
  padding: 0.875rem 1.25rem;
  border-bottom: 1px solid var(--border);
  background: var(--bg-card);
}

.pg-section__icon {
  display: flex;
  align-items: center;
  justify-content: center;
  width: 2rem;
  height: 2rem;
  border-radius: 9px;
  flex-shrink: 0;
}

.pg-section__icon .icon { width: 1rem; height: 1rem; }

.pg-section__num {
  font-family: var(--font-mono);
  font-size: 0.635rem;
  font-weight: 600;
  color: var(--accent);
  background: transparent;
  border: 1px solid var(--accent);
  opacity: 0.85;
  padding: 0.08rem 0.35rem;
  border-radius: 4px;
  white-space: nowrap;
  flex-shrink: 0;
}

.pg-section__title {
  font-family: var(--font-accent);
  font-size: 0.875rem;
  font-weight: 600;
  color: var(--text);
  letter-spacing: -0.01em;
  flex: 1;
}

/* Section body */
.pg-section__body {
  padding: 1.125rem 1.25rem;
}

.pg-section__lead {
  font-size: 0.795rem;
  color: var(--text-2);
  line-height: 1.65;
  font-weight: 300;
  margin-bottom: 1rem;
}

/* ── Chapter heading inside section ─────────────────────────────── */

.pg-chapter {
  display: flex;
  align-items: center;
  gap: 0.5rem;
  font-family: var(--font-accent);
  font-size: 0.78rem;
  font-weight: 600;
  color: var(--text);
  letter-spacing: -0.01em;
  margin: 1.25rem 0 0.625rem;
  padding-bottom: 0.5rem;
  border-bottom: 1px solid var(--border);
}

.pg-chapter:first-of-type { margin-top: 0; }

.pg-chapter .icon { width: 0.9rem; height: 0.9rem; color: var(--accent); }

/* ── Example query boxes ─────────────────────────────────────────── */

.pg-example {
  background: var(--bg-subtle);
  border: 1px solid var(--border);
  border-radius: 10px;
  padding: 0.875rem 1rem;
  margin-bottom: 0.75rem;
}

.pg-example__label {
  display: flex;
  align-items: center;
  gap: 0.4rem;
  font-family: var(--font-accent);
  font-size: 0.7rem;
  font-weight: 600;
  color: var(--text-2);
  margin-bottom: 0.5rem;
}

.pg-example__label .icon { width: 0.8rem; height: 0.8rem; color: var(--accent); }

.pg-query {
  background: var(--bg-card);
  border: 1px solid var(--border);
  border-radius: 7px;
  padding: 0.5rem 0.75rem;
  font-size: 0.775rem;
  color: var(--text);
  line-height: 1.55;
  margin-bottom: 0.35rem;
}

.pg-query:last-child { margin-bottom: 0; }

.pg-query code {
  font-family: var(--font-mono);
  font-size: 0.85em;
  color: var(--accent);
  background: rgba(37,99,235,0.06);
  padding: 0.1em 0.3em;
  border-radius: 3px;
}

.dark .pg-query code {
  background: rgba(91,156,246,0.1);
}

/* ── Process grid (chapter items) ───────────────────────────────── */

.pg-grid {
  display: grid;
  grid-template-columns: repeat(auto-fill, minmax(210px, 1fr));
  gap: 0.5rem;
  margin-bottom: 0.25rem;
}

.pg-item {
  background: var(--bg-subtle);
  border: 1px solid var(--border);
  border-radius: 9px;
  padding: 0.75rem 0.875rem;
  transition: border-color 0.2s, box-shadow 0.2s;
}

.pg-item:hover {
  border-color: var(--accent);
  box-shadow: 0 0 0 3px rgba(37,99,235,0.05);
}

.pg-item__code {
  font-family: var(--font-mono);
  font-size: 0.635rem;
  font-weight: 600;
  color: var(--accent);
  background: transparent;
  border: 1px solid var(--accent);
  opacity: 0.85;
  padding: 0.06rem 0.3rem;
  border-radius: 3px;
  display: inline-block;
  margin-bottom: 0.35rem;
}

.pg-item__name {
  font-size: 0.775rem;
  color: var(--text-2);
  line-height: 1.5;
  font-weight: 300;
}

.pg-item__name code {
  font-family: var(--font-mono);
  font-size: 0.85em;
  color: var(--accent);
}

/* ── Diff grid (MSSQL → PostgreSQL) ─────────────────────────────── */

.pg-diff {
  display: grid;
  grid-template-columns: 1fr 1fr;
  gap: 0.5rem;
  margin: 0.875rem 0;
}

.pg-diff-cell {
  background: var(--bg-subtle);
  border: 1px solid var(--border);
  border-radius: 9px;
  padding: 0.75rem 0.875rem;
  font-family: var(--font-mono);
  font-size: 0.78rem;
  color: var(--text);
  line-height: 1.6;
  white-space: pre-wrap;
  word-break: break-word;
}

.pg-diff-cell__label {
  display: block;
  font-size: 0.63rem;
  font-weight: 600;
  text-transform: uppercase;
  letter-spacing: 0.06em;
  color: var(--text-3);
  margin-bottom: 0.5rem;
}

.pg-diff-cell--from {
  border-left: 2px solid #ef4444;
}
.pg-diff-cell--from .pg-diff-cell__label { color: #dc2626; }
.dark .pg-diff-cell--from .pg-diff-cell__label { color: #f87171; }

.pg-diff-cell--to {
  border-left: 2px solid #22c55e;
}
.pg-diff-cell--to .pg-diff-cell__label { color: #16a34a; }
.dark .pg-diff-cell--to .pg-diff-cell__label { color: #4ade80; }

@media (max-width: 580px) {
  .pg-diff { grid-template-columns: 1fr; }
}

/* ── Highlight callout boxes ─────────────────────────────────────── */

.pg-callout {
  border: 1px solid var(--border);
  border-radius: 9px;
  padding: 0.875rem 1rem;
  margin: 0.875rem 0;
}

.pg-callout__head {
  display: flex;
  align-items: center;
  gap: 0.4rem;
  font-family: var(--font-accent);
  font-size: 0.75rem;
  font-weight: 600;
  margin-bottom: 0.5rem;
}

.pg-callout__head .icon { width: 0.85rem; height: 0.85rem; }

.pg-callout p {
  font-size: 0.775rem;
  color: var(--text-2);
  line-height: 1.6;
  font-weight: 300;
  margin-bottom: 0.35rem;
}

.pg-callout p:last-child { margin-bottom: 0; }

.pg-callout ul {
  font-size: 0.775rem;
  color: var(--text-2);
  line-height: 1.6;
  font-weight: 300;
  padding-left: 1.25rem;
}

.pg-callout li { margin-bottom: 0.2rem; }
.pg-callout li::marker { color: var(--text-3); }

.pg-callout code {
  font-family: var(--font-mono);
  font-size: 0.85em;
  color: var(--accent);
  background: rgba(37,99,235,0.06);
  padding: 0.1em 0.3em;
  border-radius: 3px;
}

.dark .pg-callout code {
  background: rgba(91,156,246,0.1);
}

/* Variants */
.pg-callout--info {
  background: rgba(37,99,235,0.04);
  border-color: rgba(37,99,235,0.18);
}
.pg-callout--info .pg-callout__head { color: #2563eb; }
.dark .pg-callout--info .pg-callout__head { color: #60a5fa; }

.pg-callout--warn {
  background: rgba(245,158,11,0.04);
  border-color: rgba(245,158,11,0.18);
}
.pg-callout--warn .pg-callout__head { color: #d97706; }
.dark .pg-callout--warn .pg-callout__head { color: #fbbf24; }

.pg-callout--danger {
  background: rgba(239,68,68,0.04);
  border-color: rgba(239,68,68,0.18);
}
.pg-callout--danger .pg-callout__head { color: #dc2626; }
.dark .pg-callout--danger .pg-callout__head { color: #f87171; }

/* ── Conversation example ────────────────────────────────────────── */

.pg-convo {
  display: flex;
  flex-direction: column;
  gap: 0.5rem;
  margin: 0.875rem 0;
}

.pg-convo-bubble {
  border-radius: 10px;
  padding: 0.75rem 0.875rem;
  font-size: 0.775rem;
  line-height: 1.6;
  border: 1px solid var(--border);
}

.pg-convo-bubble--user {
  background: rgba(37,99,235,0.04);
  border-color: rgba(37,99,235,0.15);
  align-self: flex-end;
  max-width: 90%;
}

.pg-convo-bubble--ai {
  background: var(--bg-subtle);
  align-self: flex-start;
  max-width: 100%;
}

.pg-convo-bubble__who {
  font-family: var(--font-accent);
  font-size: 0.63rem;
  font-weight: 600;
  text-transform: uppercase;
  letter-spacing: 0.07em;
  margin-bottom: 0.3rem;
}

.pg-convo-bubble--user .pg-convo-bubble__who { color: var(--accent); }
.pg-convo-bubble--ai  .pg-convo-bubble__who { color: var(--text-3); }

.pg-convo-bubble p { color: var(--text-2); margin-bottom: 0.35rem; }
.pg-convo-bubble p:last-child { margin-bottom: 0; }

.pg-convo-bubble code {
  font-family: var(--font-mono);
  font-size: 0.85em;
  color: var(--accent);
  background: rgba(37,99,235,0.07);
  padding: 0.1em 0.3em;
  border-radius: 3px;
}

.dark .pg-convo-bubble code { background: rgba(91,156,246,0.1); }

.pg-convo-bubble pre {
  font-family: var(--font-mono);
  font-size: 0.75rem;
  background: var(--bg-card);
  border: 1px solid var(--border);
  border-radius: 7px;
  padding: 0.625rem 0.75rem;
  margin: 0.5rem 0 0;
  white-space: pre-wrap;
  word-break: break-word;
  color: var(--text);
  line-height: 1.6;
}

/* Suggested follow-ups */
.pg-followups {
  display: flex;
  flex-direction: column;
  gap: 0.225rem;
  margin-top: 0.5rem;
}

.pg-followup-item {
  display: flex;
  align-items: flex-start;
  gap: 0.4rem;
  font-size: 0.755rem;
  color: var(--text-2);
  line-height: 1.5;
  font-weight: 300;
}

.pg-followup-dot {
  width: 4px;
  height: 4px;
  border-radius: 50%;
  background: var(--accent);
  flex-shrink: 0;
  margin-top: 0.5em;
  opacity: 0.7;
}

/* ── Source citation ─────────────────────────────────────────────── */

.pg-source {
  display: flex;
  align-items: center;
  gap: 0.4rem;
  flex-wrap: wrap;
  font-size: 0.725rem;
  color: var(--text-3);
  border-top: 1px solid var(--border);
  padding-top: 0.625rem;
  margin-top: 0.625rem;
}

.pg-source .icon { width: 0.75rem; height: 0.75rem; }

.pg-source-tag {
  font-family: var(--font-mono);
  font-size: 0.635rem;
  font-weight: 600;
  color: var(--accent);
  background: transparent;
  border: 1px solid var(--accent);
  opacity: 0.8;
  padding: 0.04rem 0.3rem;
  border-radius: 3px;
}

/* ── Feature cards at bottom (2-col grid) ───────────────────────── */

.pg-features {
  display: grid;
  grid-template-columns: 1fr 1fr;
  gap: 0.75rem;
  margin-bottom: 2rem;
}

@media (max-width: 640px) {
  .pg-features { grid-template-columns: 1fr; }
}

.pg-feat {
  display: flex;
  flex-direction: column;
  gap: 0.75rem;
  background: var(--bg-card);
  border: 1px solid var(--border);
  border-radius: 14px;
  padding: 1.125rem 1.25rem;
  box-shadow: var(--shadow-card);
  transition: box-shadow 0.25s, border-color 0.25s;
}

.pg-feat:hover {
  box-shadow: var(--shadow-hover);
  border-color: var(--border-mid);
}

.pg-feat__header {
  display: flex;
  align-items: center;
  gap: 0.75rem;
}

.pg-feat__icon {
  display: flex;
  align-items: center;
  justify-content: center;
  width: 2rem;
  height: 2rem;
  border-radius: 9px;
  flex-shrink: 0;
}

.pg-feat__icon .icon { width: 1rem; height: 1rem; }

.pg-feat__title {
  font-family: var(--font-accent);
  font-size: 0.82rem;
  font-weight: 600;
  color: var(--text);
  letter-spacing: -0.01em;
}

.pg-feat__text {
  font-size: 0.795rem;
  color: var(--text-2);
  line-height: 1.65;
  font-weight: 300;
}

/* Node-type compact list inside feat card */
.pg-scope-list {
  display: flex;
  flex-direction: column;
  gap: 0.225rem;
}

.pg-scope-item {
  display: flex;
  align-items: center;
  gap: 0.45rem;
  font-size: 0.755rem;
  color: var(--text-2);
  font-weight: 300;
}

.pg-scope-dot {
  width: 4px;
  height: 4px;
  border-radius: 50%;
  background: var(--accent);
  flex-shrink: 0;
  opacity: 0.7;
}

/* Links */
.pg-section__body a {
  color: var(--accent);
  text-decoration: underline;
  text-underline-offset: 2px;
}
.pg-section__body a:hover { color: var(--accent-hover); }

/* ── Responsive ─────────────────────────────────────────────────── */

@media (max-width: 580px) {
  .header-actions {
    top: 1rem;
    left: 1rem;
    right: 1rem;
  }

  .pg-header {
    padding-top: 3.5rem;
  }

  .pg-stats {
    flex-wrap: wrap;
    justify-content: center;
    gap: 0.5rem;
    padding: 0.75rem 1rem;
  }

  .pg-stat__sep { display: none; }
  .pg-stat { padding: 0 0.875rem; }

  .pg-section__head { padding: 0.75rem 1rem; }
  .pg-section__body { padding: 0.875rem 1rem; }

  .pg-grid { grid-template-columns: 1fr; }

  .pg-features { grid-template-columns: 1fr; }
}