Decouple registrar actions `id` from Ponder

[Goader]

Decouple registrar actions id from Ponder

related to: #1742

Right now, the SQL table for registrar actions uses Ponder-specific checkpoint ID encoding as its primary key.

Ponder checkpoint IDs are 75 characters long:

[blockTimestamp: 10][chainId: 16][blockNumber: 16][transactionIndex: 16][eventType: 1][eventIndex: 16]

All components except eventType are general descriptors of registrar actions, while eventType is the only Ponder-specific part. To decouple it from Ponder, we want to change the ID column to remove eventType and therefore be of the following format:

[blockTimestamp: 10][chainId: 16][blockNumber: 16][transactionIndex: 16][eventIndex: 16]

This would require introducing changes to ENSIndexer to transform Ponder data appropriately.

[coderabbitai]

🔗 Related PRs

#1655 - Registration/Renewal Superceding Refactor [merged]

---

📝 Issue Planner

_{Check the box below or use the @coderabbitai plan command to generate an implementation plan and prompts that you can use with your favorite coding assistant.}

• Create Plan

---

🧪 Issue enrichment is currently in open beta.

You can configure auto-planning by selecting labels in the issue_enrichment configuration.

To disable automatic issue enrichment, add the following to your .coderabbit.yaml:

issue_enrichment:
  auto_enrich:
    enabled: false

💬 Have feedback or questions? Drop into our discord!