/* Google Fonts & Material Symbols Import */
@import url('https://fonts.googleapis.com/css2?family=Material+Symbols+Outlined:opsz,wght,FILL,GRAD@24,400,0,0&family=Space+Grotesk:wght@400;500;600;700&display=swap');

:root {
    /* Color Tokens (Material 3 - Tonal Palette) */
    --md-sys-color-primary: #6750A4;
    --md-sys-color-primary-hover: #553E90;
    --md-sys-color-on-primary: #FFFFFF;
    --md-sys-color-surface: #FEF7FF;
    --md-sys-color-surface-container: #F3EDF7;
    --md-sys-color-surface-container-high: #ECE6F0;
    --md-sys-color-outline: #79747E;
    --md-sys-color-outline-variant: #CAC4D0;
    --md-sys-color-on-surface-variant: #49454F;

    /* Shape Tokens */
    --md-shape-corner-extra-large: 28px;
    --md-shape-corner-medium: 16px;
    --md-shape-corner-small: 8px;
    --md-shape-pill: 100px;

    /* Elevation & Shadows */
    --md-elevation-1: 0px 1px 3px rgba(0, 0, 0, 0.08), 0px 1px 2px rgba(0, 0, 0, 0.12);
    --md-elevation-2: 0px 4px 8px 3px rgba(0, 0, 0, 0.05), 0px 1px 3px rgba(0, 0, 0, 0.1);
}

/* ==========================================
   Material 3 Typography Scale (Space Grotesk)
   ========================================== */

/* Base HTML Defaults */
html {
    font-size: 16px; /* Base 1rem = 16px */
}

body {
    font-family: 'Space Grotesk', sans-serif;
    color: #1D1B20;
    line-height: 1.5;
    -webkit-font-smoothing: antialiased;
}

/* Headings Hierarchy */
h1, .h1 {
    font-size: 1.875rem; /* 30px */
    font-weight: 700;
    line-height: 1.25;
    letter-spacing: -0.02em;
    margin-bottom: 0.75rem;
}

h2, .h2 {
    font-size: 1.5rem; /* 24px */
    font-weight: 700;
    line-height: 1.3;
    letter-spacing: -0.01em;
    margin-bottom: 0.625rem;
}

h3, .h3 {
    font-size: 1.25rem; /* 20px */
    font-weight: 600;
    line-height: 1.35;
    margin-bottom: 0.5rem;
}

h4, .h4 {
    font-size: 1.125rem; /* 18px */
    font-weight: 600;
    line-height: 1.4;
    margin-bottom: 0.5rem;
}

h5, .h5 {
    font-size: 1rem; /* 16px */
    font-weight: 600;
    line-height: 1.4;
    margin-bottom: 0.375rem;
}

h6, .h6 {
    font-size: 0.875rem; /* 14px */
    font-weight: 600;
    line-height: 1.4;
    text-transform: uppercase;
    letter-spacing: 0.05em;
    margin-bottom: 0.25rem;
}

/* Paragraphs & Text Variants */
p {
    font-size: 0.95rem; /* ~15px - keeps dense text readable without being bulky */
    line-height: 1.6;
    margin-bottom: 1rem;
    color: #313033;
}

.lead {
    font-size: 1.1rem; /* ~17.5px */
    font-weight: 400;
    line-height: 1.5;
    color: #49454F;
}

small, .small {
    font-size: 0.8125rem; /* ~13px */
    line-height: 1.4;
    color: #605D64;
}

.text-muted {
    color: #605D64 !important;
}

/* Links */
a {
    color: var(--md-sys-color-primary);
    transition: color 0.15s ease;
}
-- ========================================================
-- 1. ADD A NEW STUDENT
-- ========================================================
INSERT INTO students (first_name, last_name, email) VALUES 
('John', 'Doe', 'john.doe@example.com');

-- Get the generated student ID (replace '1' below with this ID)


-- ========================================================
-- 2. CREATE A USER LOGIN FOR THE STUDENT
-- Note: Replace 'a43da652a26569eb2ecfe7f1c1f4e15b' with your desired MD5 hash
-- (a43da652a26569eb2ecfe7f1c1f4e15b = 'Password123!')
-- ========================================================
INSERT INTO users (student_id, username, password_hash, role) VALUES 
(1, 'john.doe', 'a43da652a26569eb2ecfe7f1c1f4e15b', 'student');


-- ========================================================
-- 3. ADD A NEW COURSE
-- ========================================================
INSERT INTO courses (course_code, course_name, description, credits) VALUES 
('DMD201', 'Digital Media Design & Production', 'Comprehensive workshop covering UI/UX principles, video production, and interactive media assets.', 3);

-- Get the generated course ID (replace '3' below with this ID)


-- ========================================================
-- 4. ENROLL A STUDENT INTO A COURSE
-- (student_id, course_id)
-- ========================================================
INSERT INTO student_courses (student_id, course_id) VALUES 
(1, 3);


-- ========================================================
-- 5. ADD COURSE MATERIAL TO A COURSE
-- resource_type options: 'Portal', 'Video', 'Slides', 'Assignment', 'Link'
-- ========================================================
INSERT INTO course_materials (course_id, title, description, external_url, resource_type, sort_order) VALUES 
(3, 'Figma Design System Template', 'Starter kit containing Material 3 component libraries and design tokens.', 'https://figma.com/@sample-template', 'Portal', 1);
a:hover {
    color: var(--md-sys-color-primary-hover);
}

/* Material 3 App Bar */
.m3-app-bar {
    background-color: var(--md-sys-color-surface-container);
    border-bottom: 1px solid var(--md-sys-color-outline-variant);
}

/* Universal Material 3 Card */
.m3-card {
    background-color: #FFFFFF;
    border-radius: var(--md-shape-corner-extra-large);
    border: none;
    box-shadow: var(--md-elevation-2);
    transition: transform 0.2s ease, box-shadow 0.2s ease;
}

.m3-card.m3-card-interactive:hover {
    transform: translateY(-2px);
    box-shadow: 0px 6px 12px rgba(0, 0, 0, 0.12);
}

/* Header / Icon Containers */
.m3-icon-header {
    width: 56px;
    height: 56px;
    background-color: var(--md-sys-color-surface-container);
    color: var(--md-sys-color-primary);
    border-radius: 50%;
    display: inline-flex;
    align-items: center;
    justify-content: center;
}

.m3-avatar {
    width: 80px;
    height: 80px;
    background-color: var(--md-sys-color-primary);
    color: var(--md-sys-color-on-primary);
    border-radius: 50%;
    display: inline-flex;
    align-items: center;
    justify-content: center;
    font-size: 2rem;
    font-weight: 600;
}

/* M3 Filled Form Controls */
.form-floating > .form-control {
    background-color: var(--md-sys-color-surface-container);
    border: none;
    border-bottom: 2px solid var(--md-sys-color-outline);
    border-radius: 4px 4px 0 0;
    font-family: 'Space Grotesk', sans-serif;
}

.form-floating > .form-control:focus {
    background-color: #EAE3ED;
    border-bottom-color: var(--md-sys-color-primary);
    box-shadow: none;
}

/* Buttons */
.btn-m3-primary {
    background-color: var(--md-sys-color-primary);
    color: var(--md-sys-color-on-primary);
    border-radius: var(--md-shape-pill);
    font-weight: 600;
    padding: 12px 24px;
    border: none;
    text-decoration: none;
    transition: all 0.2s ease-in-out;
}

.btn-m3-primary:hover {
    background-color: var(--md-sys-color-primary-hover);
    color: var(--md-sys-color-on-primary);
    box-shadow: var(--md-elevation-1);
}

.btn-m3-tonal {
    background-color: var(--md-sys-color-surface-container-high);
    color: var(--md-sys-color-primary);
    border-radius: var(--md-shape-pill);
    font-weight: 600;
    padding: 8px 20px;
    border: none;
    text-decoration: none;
    transition: background-color 0.2s ease;
}

.btn-m3-tonal:hover {
    background-color: #E8DEF8;
    color: var(--md-sys-color-primary);
}

/* Badges & Chips */
.m3-chip {
    background-color: var(--md-sys-color-surface-container-high);
    color: var(--md-sys-color-on-surface-variant);
    border-radius: var(--md-shape-corner-small);
    padding: 4px 12px;
    font-size: 0.85rem;
    font-weight: 500;
    display: inline-flex;
    align-items: center;
    gap: 4px;
}

.m3-code-badge {
    background-color: var(--md-sys-color-surface-container-high);
    color: var(--md-sys-color-primary);
    font-weight: 700;
    border-radius: var(--md-shape-corner-small);
    padding: 6px 12px;
    font-size: 0.85rem;
    letter-spacing: 0.5px;
}

/* Split Layout & Hero Section */
.m3-login-card {
    max-width: 980px;
}

.m3-login-hero {
    background: url('https://images.unsplash.com/photo-1523240795612-9a054b0db644?q=80&w=1200&auto=format&fit=crop') center/cover no-repeat;
    min-height: 520px;
}

.m3-hero-overlay {
    position: absolute;
    inset: 0;
    background: linear-gradient(180deg, rgba(103, 80, 164, 0.4) 0%, rgba(29, 27, 32, 0.85) 100%);
}

.tracking-wide {
    letter-spacing: 0.5px;
}