Cannot rollback migrations with SQLite

[robinstraub]

Cashier Stripe Version

15.4.1

Laravel Version

11.18.1

PHP Version

8.3

Database Driver & Version

SQLite 3

Description

When attempting to rollback the migrations generated with Laravel Cashier, it fails with the following error:

SQLSTATE[HY000]: General error: 1 no such index: stripe_id (Connection: sqlite, SQL: drop index "stripe_id")

I am using SQLite in testing environment and actually have a testsuite for testing my migrations and their rollback ability.

I am ensure if this is considered a bug, a.k.a. is cashier supposed to support SQLite (or maybe I missed something and the error is on my end).

If you feel Cashier should behave properly with SQLite and the migrate/rollback behavior should work out of the box, I can have a more in-depth look and issue a PR.

Steps To Reproduce

1. create a new project and add cashier
2. import publish the migrations (php artisan vendor:publish --tag="cashier-migrations")
3. define the database connection to SQLite
4. attempt to rollback the migrations (php artisan migrate:rollback)