Create all tables and stored routines this engine needs, from the canonical schema file
db/mysql-schema.sql (the MySQL counterpart to db/postgresql-schema.sql). The file drops and
recreates the tables, so running this resets to a clean schema (convenient for tests). Run once
during setup (operations tooling or CI), never automatically at app startup.
mysql2 sends one statement per query, so the file is split into individual statements first
(honoring the mysql CLI's DELIMITER directive for routine bodies), then each is run in order.
Create all tables and stored routines this engine needs, from the canonical schema file
db/mysql-schema.sql(the MySQL counterpart todb/postgresql-schema.sql). The file drops and recreates the tables, so running this resets to a clean schema (convenient for tests). Run once during setup (operations tooling or CI), never automatically at app startup.mysql2 sends one statement per
query, so the file is split into individual statements first (honoring the mysql CLI'sDELIMITERdirective for routine bodies), then each is run in order.