Missing TOTP fields and customers table in database schema causing server errors

[sydro]

I’m encountering a blocking issue due to missing database fields and tables in the current schema.

In particular:

• The app_users table is missing the following columns:

  • totp_enabled

  • totp_secret

These fields are required for TOTP / 2FA handling, but they are referenced by the backend, which results in runtime errors.

• The customers table is completely missing from the database schema, even though it is required by the application.

Because of this, the server fails at startup or when executing queries related to users and customers.
I did not use the install.sh script. Instead, I followed the steps described in the documentation and manually imported the SQL files from both the init and migrations folders. Even following the documented procedure, the resulting database schema is incomplete and leads to the errors described above.

Expected behavior

The database schema should include:

• totp_enabled and totp_secret columns in the app_users table

• A properly defined customers table

and any required migrations should create them automatically.

Actual behavior

The database is created without these columns and tables, causing SQL errors and preventing the server from working correctly.

Let me know if you need logs or error traces — I’ll be happy to provide them.

[sydro]

I made a migration that resolve the problem.

2026_01_15_customers_and_totp.sql