db:reset

Drop all tables and re-apply migrations from scratch.

---

Usage

splent db:reset [-y]

Examples

Full reset with confirmation prompt.

splent db:reset

Skip the confirmation.

splent db:reset -y

---

Options

Option	Description
-y, --yes	Skip the confirmation prompt.

---

Description

Performs a full database reset in this order.

1. Drops ALL tables, including data tables, alembic_<feature> version tables, and splent_migrations. Uses SET FOREIGN_KEY_CHECKS = 0 to handle FK constraints.
2. Recreates the splent_migrations tracking table.
3. Clears uploaded files.
4. Re-applies all existing feature migrations via alembic upgrade head, respecting UVL dependency order (e.g., auth before profile). Features without a models module (e.g. config-only features like admin or phpmyadmin) are silently skipped.

This command destroys all data in the database. Feature migration files are NOT deleted. Only the database is wiped and rebuilt.

---

Migration order

Migrations are applied in dependency order based on UVL constraints, ensuring that tables referenced by foreign keys are created first.

---

Requirements

• SPLENT_APP must be set.
• The database must be reachable.

See also

• db:migrate. Generate and apply new migrations
• db:upgrade. Apply pending migrations
• db:status. Show current migration status
• db:seed. Populate the database after reset