=== FLASHCARD SET DIAGNOSIS ===

--- Flashcard Sets for PSP / Domain 2 ---
  Set ID 7: PSP - Domain 1 Chapter 1 - Concepts in Security Risk Management (Domain: Domain 1) — 20 cards
  Set ID 8: PSP - Domain 1 Chapter 2 - Functions of Physical Security (Domain: Domain 1) — 19 cards
  Set ID 9: PSP - Domain 1 Chapter 3 - Planning and Conducting Physical Security Assessments (Domain: Domain 1) — 24 cards
  Set ID 10: PSP - Domain 1 Chapter 4 - Measuring Effectiveness: Concepts in Physical Security Metrics (Domain: Domain 1) — 17 cards
  Set ID 11: PSP - Domain 1 Chapter 5 - Basic Design Concepts (Domain: Domain 1) — 20 cards
  Set ID 12: PSP - Domain 2 Chapter 6 - Perimeter Security & Lighting (Domain: Domain 2) — 40 cards
  Set ID 13: PSP - Domain 2 Chapter 7 - Security Architecture and Engineering (Domain: Domain 2) — 19 cards
  Set ID 14: PSP - Domain 2 Chapter 9 - Comprehensive Domain Review (Domain: Domain 2) — 105 cards
  Set ID 15: PSP - Domain 2 Chapter 10 - Implementation & Maintenance (Domain: Domain 2) — 50 cards
  Set ID 16: PSP - Domain 3 Chapter 11 - Electronic Security Systems (Domain: Domain 3) — 100 cards
  Set ID 17: PSP - Domain 3 Chapter 12 - Security Officers and the Human Element (Domain: Domain 3) — 90 cards
  Set ID 18: PSP - Domain 3 Chapter 13 - Principles of Project Management (Domain: Domain 3) — 160 cards
  Set ID 19: PSP - Domain 3 Chapter 14 - Project Planning and Preparation (Domain: Domain 3) — 50 cards
  Set ID 20: PSP - Domain 3 Chapter 15 - Project Implementation (Domain: Domain 3) — 75 cards
  Set ID 21: PSP - Domain 3 Chapter 16 - Follow-on and Support Activities (Domain: Domain 3) — 100 cards
  Set ID 22: PSP - Domain 1 Chapter 1 - Concepts in Security Risk Management (Domain: Domain 1) — 2 cards
  Set ID 23: PSP - Domain 1 Chapter 2 - Functions of Physical Security (Domain: Domain 1) — 2 cards
  Set ID 24: PSP - Domain 1 Chapter 3 - Planning and Conducting Physical Security Assessments (Domain: Domain 1) — 2 cards
  Set ID 25: PSP - Domain 1 Chapter 4 - Measuring Effectiveness: Concepts in Physical Security Metrics (Domain: Domain 1) — 2 cards
  Set ID 26: PSP - Domain 1 Chapter 5 - Basic Design Concepts (Domain: Domain 1) — 2 cards
  Set ID 27: PSP - Domain 2 Chapter 6 - Influencing Factors in Physical Security Design (Domain: Domain 2) — 15 cards
  Set ID 28: PSP - Domain 2 Chapter 13 - Flash Card 13 & 14 (Domain: Domain 2) — 160 cards
  Set ID 29: PSP - Domain 2 Chapter 8 - Integrated Security and Protection Strategies (Domain: Domain 2) — 11 cards
  Set ID 30: PSP - Domain 2 Chapter 9 - Structural Security Measures (Domain: Domain 2) — 60 cards
  Set ID 31: PSP - Domain 2 Chapter 10 - Crime Prevention Through Environmental Design (Domain: Domain 2) — 20 cards

--- Looking for Chapter 6 specifically ---

  Set ID: 12
  Title: PSP - Domain 2 Chapter 6 - Perimeter Security & Lighting
  Description: PSP Domain 2 - Perimeter security fundamentals, barriers, lighting, and CPTED principles.
  Card Count: 40
  First Question: What is the primary purpose of perimeter security?

  Set ID: 27
  Title: PSP - Domain 2 Chapter 6 - Influencing Factors in Physical Security Design
  Description: Domain 2 Chapter 6 flashcards imported from FLASH CARD-06 DOMAIN 02.docx
  Card Count: 15
  First Question: 1. What is critical for construction, expansion, renovation, upgrade, or protect

--- Learning Steps for Chapter 6 ---
  No Chapter 6 found via chapter_number=6 or id=6.

--- All Chapters ---
  Chapter ID 1: ch#1 - Domain 1 Chapter 1 - Concepts in Security Risk Management (Domain 1)
  Chapter ID 2: ch#2 - Domain 1 Chapter 2 - Functions of Physical Security (Domain 1)
  Chapter ID 3: ch#3 - Domain 1 Chapter 3 - Planning and Conducting Physical Security Assessments (Domain 1)
  Chapter ID 4: ch#4 - Domain 1 Chapter 4 - Measuring Effectiveness: Concepts in Physical Security Metrics (Domain 1)
  Chapter ID 5: ch#5 - Domain 1 Chapter 5 - Basic Design Concepts (Domain 1)
  Chapter ID 6: ch#6 - Domain 2 Chapter 6 - Influencing Factors in Physical Security Design (Domain 2)
  Chapter ID 7: ch#7 - Domain 2 Chapter 7 - Security Architecture and Engineering (Domain 2)
  Chapter ID 8: ch#8 - Domain 2 Chapter 8 - Integrated Security and Protection Strategies (Domain 2)
  Chapter ID 9: ch#9 - Domain 2 Chapter 9 - Structural Security Measures (Domain 2)
  Chapter ID 10: ch#10 - Domain 2 Chapter 10 - Crime Prevention Through Environmental Design (Domain 2)
  Chapter ID 11: ch#11 - Domain 3 Chapter 11 - Electronic Security Systems (Domain 3)
  Chapter ID 12: ch#12 - Domain 3 Chapter 12 - Security Officers and the Human Element (Domain 3)
  Chapter ID 13: ch#13 - Domain 3 Chapter 13 - Principles of Project Management (Domain 3)
  Chapter ID 14: ch#14 - Domain 3 Chapter 14 - Project Planning and Preparation (Domain 3)
  Chapter ID 15: ch#15 - Domain 3 Chapter 15 - Project Implementation (Domain 3)
  Chapter ID 16: ch#16 - Domain 3 Chapter 16 - Follow-on and Support Activities (Domain 3)

=== SUMMARY ===
Look above for the 'Content ID (flashcard_set_id)' value next to flashcard_normal or flashcard_table.
That is the CORRECT flashcard_set_id to use in your SQL file.
If it shows 40 cards with 'What is the primary purpose of perimeter security?', that set needs updating.

Once you identify the correct set_id, update the SQL file:
  - Replace '27' with the correct set_id in both DELETE and INSERT lines
  - Or just tell me the set_id and I'll generate a new SQL file.

=== DELETE THIS FILE AFTER USE FOR SECURITY ===