run migration 0005 on access-api staging

[gobengo]

For some reason when I try to run the migrations on staging, they don't seem to fully apply/'stick'?

bengo@bengo ~/protocol.ai/w3protocol/packages/access-api ⚡  npx wrangler d1 migrations list __D1_BETA__ --env staging
▲ [WARNING] Processing wrangler.toml configuration:

    - 😶 Ignored: "miniflare":
      Wrangler does not use configuration in the `miniflare` section. Unless you
  are using Miniflare directly you can remove this section.
    - "env.staging" environment configuration
      - "unsafe" fields are experimental and may change or break at any time.



🌀 Mapping SQL input into an array of statements
🌀 Parsing 1 statements
🌀 Executing on __D1_BETA__ (16f0660e-2a8e-4e13-9f05-0a2a594d91ed):
🚣 Executed 2 commands in 0.14677099883556366ms
🌀 Mapping SQL input into an array of statements
🌀 Parsing 1 statements
🌀 Executing on __D1_BETA__ (16f0660e-2a8e-4e13-9f05-0a2a594d91ed):
🚣 Executed 1 command in 4.921460002660751ms
Migrations to be applied:
┌───────────────────────────────────────────────────────┐
│ Name                                                  │
├───────────────────────────────────────────────────────┤
│ 0005_drop_delegations_audience_to_accounts_did_fk.sql │
└───────────────────────────────────────────────────────┘
bengo@bengo ~/protocol.ai/w3protocol/packages/access-api ⚡  npx wrangler d1 migrations apply __D1_BETA__ --env staging
▲ [WARNING] Processing wrangler.toml configuration:

    - 😶 Ignored: "miniflare":
      Wrangler does not use configuration in the `miniflare` section. Unless you
  are using Miniflare directly you can remove this section.
    - "env.staging" environment configuration
      - "unsafe" fields are experimental and may change or break at any time.



🌀 Mapping SQL input into an array of statements
🌀 Parsing 1 statements
🌀 Executing on __D1_BETA__ (16f0660e-2a8e-4e13-9f05-0a2a594d91ed):
🚣 Executed 2 commands in 0.12004999816417693ms
🌀 Mapping SQL input into an array of statements
🌀 Parsing 1 statements
🌀 Executing on __D1_BETA__ (16f0660e-2a8e-4e13-9f05-0a2a594d91ed):
🚣 Executed 1 command in 1.940445989370346ms
Migrations to be applied:
┌───────────────────────────────────────────────────────┐
│ Name                                                  │
🌀 Mapping SQL input into an array of statements
🌀 Parsing 5 statements
🌀 Executing on __D1_BETA__ (16f0660e-2a8e-4e13-9f05-0a2a594d91ed):
🚣 Executed 1 command in 0.22679200768470764ms
┌───────────────────────────────────────────────────────┬────────┐
│ Name                                                  │ Status │
├───────────────────────────────────────────────────────┼────────┤
│ 0005_drop_delegations_audience_to_accounts_did_fk.sql │ ✅       │
└───────────────────────────────────────────────────────┴────────┘
bengo@bengo ~/protocol.ai/w3protocol/packages/access-api ⚡  npx wrangler d1 migrations list __D1_BETA__ --env staging
▲ [WARNING] Processing wrangler.toml configuration:

    - 😶 Ignored: "miniflare":
      Wrangler does not use configuration in the `miniflare` section. Unless you
  are using Miniflare directly you can remove this section.
    - "env.staging" environment configuration
      - "unsafe" fields are experimental and may change or break at any time.



🌀 Mapping SQL input into an array of statements
🌀 Parsing 1 statements
🌀 Executing on __D1_BETA__ (16f0660e-2a8e-4e13-9f05-0a2a594d91ed):
🚣 Executed 2 commands in 0.1396310031414032ms
🌀 Mapping SQL input into an array of statements
🌀 Parsing 1 statements
🌀 Executing on __D1_BETA__ (16f0660e-2a8e-4e13-9f05-0a2a594d91ed):
🚣 Executed 1 command in 1.6049530059099195ms
Migrations to be applied:
┌───────────────────────────────────────────────────────┐
│ Name                                                  │
├───────────────────────────────────────────────────────┤
│ 0005_drop_delegations_audience_to_accounts_did_fk.sql │
└───────────────────────────────────────────────────────┘
bengo@bengo ~/protocol.ai/w3protocol/packages/access-api ⚡

[gobengo]

Discovered while testing this on staging: #460
Clicking the authorize confirmation link leads to a error

[gobengo]

after poking around I think the migration ran, but cf refused to execute the last two lines (but also didn't error?)

DROP TABLE delegations;
ALTER TABLE delegations_new RENAME TO delegations;

I see in cloudflare staging that there is still a delegations table with the schema from before migration.
There is also the delegations_new table created in the migration.

Maybe d1 doesn't support dropping table nor renaming?

[gobengo]

I need to modify the sql schema again via migration as part of #459 , which on the whole I still need in order to fully verify on staging #393
I'm going to do that first and, once merged, get this 0005 migration working on staging along with any subsequent ones I add there.

[gobengo]

This change to the migration ended up having it 'stick'.
#469
https://github.com/web3-storage/w3protocol/actions/runs/4326422423/jobs/7553830691#step:7:52

but to do it required not doing the DROP TABLE nor RENAME