DROP TABLE IF EXISTS exercise
REPAIR TABLE exercise

    public function listAll(OrganisationFilterRequest $filterRequest, OrganisationService $service): JsonResponse
    {
        $filter = $filterRequest->has('filter') ? $filterRequest->input('filter') : 'all';
        $query = Organisation::select('name', 'owner_user_id', 'trial_end', 'subscribed');

        $subbed = ['subbed' => 1, 'trial' => 0];
        if (array_key_exists($filter, $subbed)) {
            $query = $query->where('subscribed', $subbed[$filter]);
        }
        $organisations = $query->get();
        return response()->json($organisations);