gabriel / musehub public
0048_proposal_proposer_signature.py python
34 lines 886 B
Raw
sha256:20b27796ed512236119feef48b4577a8fd9ded05a15267dd4e6da23604ad1f1a docs: update Suggested Ownership Split table to reflect ful… Sonnet 5 28 days ago
1 """Add proposer_signature and proposer_public_key to musehub_proposals.
2
3 Every proposal carries an Ed25519 signature by the proposer over the
4 canonical PROPOSE message — binding their cryptographic identity to the
5 specific act of opening this proposal.
6
7 Revision ID: 0048
8 Revises: 0047
9 """
10 from __future__ import annotations
11
12 import sqlalchemy as sa
13 from alembic import op
14
15 revision: str = "0048"
16 down_revision: str = "0047"
17 branch_labels = None
18 depends_on = None
19
20
21 def upgrade() -> None:
22 op.add_column(
23 "musehub_proposals",
24 sa.Column("proposer_signature", sa.Text(), nullable=True),
25 )
26 op.add_column(
27 "musehub_proposals",
28 sa.Column("proposer_public_key", sa.Text(), nullable=True),
29 )
30
31
32 def downgrade() -> None:
33 op.drop_column("musehub_proposals", "proposer_public_key")
34 op.drop_column("musehub_proposals", "proposer_signature")
File History 3 commits
sha256:20b27796ed512236119feef48b4577a8fd9ded05a15267dd4e6da23604ad1f1a docs: update Suggested Ownership Split table to reflect ful… Sonnet 5 28 days ago
sha256:8ea2f75226d5834770ccaddbaa6efda1cc337446fd481bb385de8bec4555ae79 docs: Section 9 CI pipeline — confirm job queue is idempote… Sonnet 5 28 days ago
sha256:80e1a60a39562f6e616aaafbb27487f03abbec7d8ffc6164302b7a0c0bfc63ee docs: check off Section 0 items verified in inventory doc, … Sonnet 5 28 days ago