/* Database Management Styles */

/* Notification Animations */
@keyframes slideIn {
  from {
    transform: translateX(100%);
    opacity: 0;
  }
  to {
    transform: translateX(0);
    opacity: 1;
  }
}

@keyframes slideOut {
  from {
    transform: translateX(0);
    opacity: 1;
  }
  to {
    transform: translateX(100%);
    opacity: 0;
  }
}

.database-container {
  max-width: 1200px;
  margin: 0 auto;
  padding: 20px;
  background: rgba(0, 0, 0, 0.2); /* translucent to show blur */
  -webkit-backdrop-filter: blur(10px);
  backdrop-filter: blur(10px);
  border: 1px solid rgba(255, 255, 255, 0.08);
  border-radius: 12px;
}

.database-section {
  background: var(--card-background);
  border-radius: 8px;
  padding: 20px;
  margin-bottom: 20px;
  box-shadow: 0 2px 4px rgba(0, 0, 0, 0.1);
}

.section-header {
  display: flex;
  justify-content: space-between;
  align-items: center;
  margin-bottom: 20px;
}

.section-header h2 {
  margin: 0;
  color: var(--heading-color);
  display: flex;
  align-items: center;
  gap: 10px;
}

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

.table-actions .btn {
  display: flex;
  align-items: center;
  gap: 5px;
}

.text-muted {
  color: var(--secondary-color);
  font-size: 0.8em;
  font-style: italic;
}

.info-card {
  background: var(--card-background-translucent, rgba(0,0,0,0.18));
  -webkit-backdrop-filter: blur(8px);
  backdrop-filter: blur(8px);
  border-radius: 6px;
  padding: 15px;
  margin-bottom: 15px;
  border: 1px solid var(--border-color);
  box-shadow: 0 1px 6px rgba(0,0,0,0.12);
}

.info-card h3 {
  margin: 0 0 10px 0;
  color: var(--heading-color);
  font-size: 16px;
}

.info-grid {
  display: grid;
  grid-template-columns: repeat(auto-fit, minmax(260px, 1fr));
  gap: 12px;
}

.info-item {
  display: flex;
  align-items: center;
  justify-content: space-between;
  gap: 12px;
  padding: 12px 14px;
  border: 1px solid var(--border-color);
  border-radius: 10px;
  background: var(--card-background-translucent, rgba(0,0,0,0.14));
  -webkit-backdrop-filter: blur(6px);
  backdrop-filter: blur(6px);
  transition: border-color 0.2s ease, box-shadow 0.2s ease, transform 0.1s ease;
}

.info-item:hover {
  border-color: var(--primary-color);
  box-shadow: 0 4px 16px rgba(0,0,0,0.2);
}

.info-label {
  font-weight: 600;
  color: var(--secondary-color);
  text-transform: uppercase;
  font-size: 12px;
  letter-spacing: 0.4px;
}

.info-value {
  color: var(--text-color);
  font-weight: 600;
  background: var(--card-background);
  padding: 6px 10px;
  border-radius: 8px;
  max-width: 60%;
  overflow-wrap: anywhere;
}

.stats-grid {
  display: grid;
  grid-template-columns: repeat(auto-fit, minmax(200px, 1fr));
  gap: 15px;
  margin-top: 15px;
}

.stat-card {
  background: var(--background-color);
  border-radius: 6px;
  padding: 15px;
  text-align: center;
}

.stat-number {
  font-size: 2em;
  font-weight: bold;
  color: var(--primary-color);
}

.stat-label {
  color: var(--secondary-color);
  margin-top: 5px;
}

.table-controls {
  display: grid;
  grid-template-columns: 2fr 2fr 1fr;
  gap: 16px;
  margin-bottom: 24px;
  padding: 20px;
  background: var(--card-background);
  border-radius: 12px;
  border: 1px solid var(--border-color);
  box-shadow: 0 2px 8px rgba(0,0,0,0.3);
}

.control-group {
  display: flex;
  flex-direction: column;
  gap: 8px;
}

.control-group label {
  font-weight: 600;
  color: var(--text-color);
  font-size: 14px;
  display: flex;
  align-items: center;
  gap: 6px;
}

.control-group label i {
  color: var(--primary-color);
  font-size: 13px;
}

.control-group select,
.control-group input {
  padding: 10px 14px;
  border: 1px solid var(--border-color);
  border-radius: 8px;
  background: var(--background-color);
  color: var(--text-color);
  font-size: 14px;
  transition: all 0.3s ease;
  box-shadow: 0 1px 3px rgba(0,0,0,0.3);
}

.control-group select:focus,
.control-group input:focus {
  outline: none;
  border-color: var(--primary-color);
  box-shadow: 0 0 0 3px rgba(59,130,246,0.25);
}

.control-group select:hover,
.control-group input:hover {
  border-color: var(--primary-color);
}

@media (max-width: 768px) {
  .table-controls {
    grid-template-columns: 1fr;
    gap: 12px;
    padding: 16px;
  }
}

.structure-table,
.data-table {
  overflow-x: auto;
  margin-top: 20px;
  border-radius: 12px;
  border: 1px solid var(--border-color);
  box-shadow: 0 2px 8px rgba(0,0,0,0.3);
}

.structure-table table,
.data-table table {
  width: 100%;
  border-collapse: collapse;
  background: var(--background-color);
  border-radius: 12px;
  overflow: hidden;
}

.structure-table th,
.structure-table td,
.data-table th,
.data-table td {
  padding: 14px 16px;
  text-align: left;
  border-bottom: 1px solid var(--border-color);
  font-size: 14px;
  color: var(--text-color);
}

.structure-table th,
.data-table th {
  background: var(--card-background);
  font-weight: 600;
  color: var(--text-color);
  text-transform: uppercase;
  font-size: 12px;
  letter-spacing: 0.5px;
  position: sticky;
  top: 0;
  z-index: 10;
  border-bottom: 2px solid var(--primary-color);
}

.structure-table tbody tr,
.data-table tbody tr {
  transition: all 0.2s ease;
}

.structure-table tbody tr:hover,
.data-table tbody tr:hover {
  background: var(--surface-hover);
  transform: scale(1.005);
}

.structure-table tbody tr:last-child td,
.data-table tbody tr:last-child td {
  border-bottom: none;
}

.sortable-column {
  cursor: pointer;
  user-select: none;
  transition: all 0.2s ease;
}

.sortable-column:hover {
  background: rgba(255,255,255,0.2);
}

.sortable-column i {
  margin-left: 6px;
  opacity: 0.7;
  transition: opacity 0.2s ease;
}

.sortable-column:hover i {
  opacity: 1;
}

.action-buttons {
  display: flex;
  gap: 6px;
  justify-content: center;
  flex-wrap: wrap;
}

.action-buttons .btn {
  padding: 6px 12px;
  font-size: 12px;
  border-radius: 6px;
  transition: all 0.2s ease;
  display: flex;
  align-items: center;
  gap: 4px;
}

.action-buttons .btn i {
  font-size: 11px;
}

.action-buttons .btn-info {
  background: var(--primary-color);
  border: none;
  color: white;
}

.action-buttons .btn-info:hover {
  transform: translateY(-2px);
  box-shadow: 0 4px 12px rgba(59,130,246,0.4);
}

.action-buttons .btn-danger {
  background: var(--danger-color);
  border: none;
  color: white;
}

.action-buttons .btn-danger:hover {
  transform: translateY(-2px);
  box-shadow: 0 4px 12px rgba(239,68,68,0.4);
}

.query-container {
  margin-top: 15px;
}

.query-input-group {
  margin-bottom: 15px;
}

.query-input-group label {
  display: block;
  margin-bottom: 5px;
  font-weight: 600;
  color: var(--text-color);
}

#sql-query-input {
  width: 100%;
  min-height: 100px;
  padding: 12px;
  border: 1px solid var(--border-color);
  border-radius: 4px;
  background: var(--background-color);
  color: var(--text-color);
  font-family: 'Courier New', monospace;
  resize: vertical;
}

.backup-list {
  margin-top: 15px;
}

.backup-item {
  display: flex;
  justify-content: space-between;
  align-items: center;
  padding: 15px;
  background: var(--background-color);
  border-radius: 6px;
  margin-bottom: 10px;
}

.backup-info {
  flex: 1;
}

.backup-name {
  font-weight: 600;
  color: var(--heading-color);
  margin-bottom: 5px;
}

.backup-meta {
  font-size: 0.9em;
  color: var(--secondary-color);
}

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

.empty-state {
  text-align: center;
  padding: 40px 20px;
  color: var(--secondary-color);
}

.empty-state i {
  font-size: 3em;
  margin-bottom: 15px;
  opacity: 0.5;
}

.loading {
  text-align: center;
  padding: 20px;
  color: var(--secondary-color);
}

.pagination {
  display: flex;
  justify-content: space-between;
  align-items: center;
  margin-top: 20px;
  padding: 15px 0;
}

.pagination-info {
  color: var(--secondary-color);
  font-size: 0.9em;
}

.pagination-controls {
  display: flex;
  gap: 10px;
  align-items: center;
}

.page-info {
  color: var(--secondary-color);
  font-size: 0.9em;
}

.query-result {
  margin-top: 15px;
}

.result-table {
  overflow-x: auto;
  margin-top: 10px;
}

.result-table table {
  width: 100%;
  border-collapse: collapse;
  background: var(--background-color);
  border-radius: 6px;
  overflow: hidden;
}

.result-table th,
.result-table td {
  padding: 12px;
  text-align: left;
  border-bottom: 1px solid var(--border-color);
}

.result-table th {
  background: var(--card-background);
  font-weight: 600;
  color: var(--heading-color);
}

/* Responsive Design */
@media (max-width: 768px) {
  .database-container {
    padding: 10px;
  }
  
  .section-header {
    flex-direction: column;
    gap: 10px;
    align-items: stretch;
  }
  
  .table-controls {
    flex-direction: column;
  }
  
  .control-group {
    width: 100%;
  }
  
  .pagination {
    flex-direction: column;
    gap: 10px;
  }
  
  .backup-item {
    flex-direction: column;
    gap: 10px;
    align-items: stretch;
  }
  
  .backup-actions {
    justify-content: center;
  }
}

/* Modal Styles */
.modal-overlay {
  position: fixed;
  top: 0;
  left: 0;
  width: 100%;
  height: 100%;
  background: rgba(0, 0, 0, 0.5);
  display: none;
  justify-content: center;
  align-items: center;
  z-index: 1000;
}

.modal-overlay.active {
  display: flex;
}

.modal {
  background: var(--card-background);
  border-radius: 8px;
  box-shadow: 0 4px 20px rgba(0, 0, 0, 0.3);
  max-width: 90%;
  max-height: 90%;
  overflow: auto;
  position: relative;
}

.modal-header {
  display: flex;
  justify-content: space-between;
  align-items: center;
  padding: 20px;
  border-bottom: 1px solid var(--border-color);
}

.modal-header h2 {
  margin: 0;
  color: var(--heading-color);
}

.modal-close {
  background: none;
  border: none;
  font-size: 24px;
  cursor: pointer;
  color: var(--secondary-color);
  padding: 0;
  width: 30px;
  height: 30px;
  display: flex;
  align-items: center;
  justify-content: center;
  border-radius: 50%;
  transition: background-color 0.3s;
}

.modal-close:hover {
  background: var(--hover-color);
  color: var(--text-color);
}

.modal-content {
  padding: 20px;
}

.modal-content .form-group {
  margin-bottom: 15px;
}

.modal-content label {
  display: block;
  margin-bottom: 5px;
  font-weight: 600;
  color: var(--text-color);
}

.modal-content input,
.modal-content select,
.modal-content textarea {
  width: 100%;
  padding: 8px 12px;
  border: 1px solid var(--border-color);
  border-radius: 4px;
  background: var(--background-color);
  color: var(--text-color);
}

.modal-content input:focus,
.modal-content select:focus,
.modal-content textarea:focus {
  outline: none;
  border-color: var(--primary-color);
  box-shadow: 0 0 0 2px rgba(59, 130, 246, 0.25);
}

.modal-content small {
  display: block;
  margin-top: 5px;
  color: var(--secondary-color);
  font-size: 0.8em;
}

.form-actions {
  display: flex;
  gap: 10px;
  justify-content: flex-end;
  margin-top: 20px;
  padding-top: 20px;
  border-top: 1px solid var(--border-color);
}

.form-actions .btn {
  min-width: 100px;
}

/* Confirmation Modal */
.confirmation-modal .modal-content {
  text-align: center;
}

.confirmation-modal .modal-content p {
  margin-bottom: 20px;
  color: var(--text-color);
}

.confirmation-modal .form-actions {
  justify-content: center;
}

/* Button Styles */
.btn {
  padding: 8px 16px;
  border: none;
  border-radius: 4px;
  cursor: pointer;
  font-size: 0.9rem;
  font-weight: 500;
  text-decoration: none;
  display: inline-flex;
  align-items: center;
  gap: 5px;
  transition: all 0.2s ease;
}

.btn:disabled {
  opacity: 0.6;
  cursor: not-allowed;
}

.btn-primary {
  background: var(--primary-color);
  color: white;
}

.btn-primary:hover:not(:disabled) {
  background: var(--primary-hover);
}

.btn-secondary {
  background: var(--secondary-color);
  color: white;
}

.btn-secondary:hover:not(:disabled) {
  background: #475569;
}

.btn-success {
  background: var(--success-color);
  color: white;
}

.btn-success:hover:not(:disabled) {
  background: #059669;
}

.btn-warning {
  background: var(--warning-color);
  color: var(--background-color);
}

.btn-warning:hover:not(:disabled) {
  background: #d97706;
}

.btn-danger {
  background: var(--danger-color);
  color: white;
}

.btn-danger:hover:not(:disabled) {
  background: #b91c1c;
}