Skip to content

SQL exports drop French (fr) instructions #58

Description

@thejesh23

Every exercise ships French instructions (instructions.fr in data/exercises.json, and fr is required in data/exercises.schema.json), but the generated SQL never carries them:

  • CREATE TABLE in all 4 dialects (mssql, postgresql, mysql, sqlite) has no instructions_fr column — index.html DB_SQL and setup.html DB_SQL.
  • buildInserts() never reads ex.instructions.fr, and the INSERT column list omits instructions_frindex.html and setup.html.

The setup.html LLM prompt on line 1404 already documents instructions_fr as an expected column, so the schema mismatch is internal too.

Impact: running the generated SQL loses all 1,324 French translations silently.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions