0054_dmca_hold_quarantine_abuse_tables.py
python
sha256:25d96102cb2d69a038356dff26f4633156da2f1faf98fe0d0e4438ff3f367f12
refactor: rename 0054/0055 migrations to standard convention
Sonnet 4.6
minor
⚠ breaking
20 days ago
| 1 | """0054_dmca_hold_quarantine_abuse_tables |
| 2 | |
| 3 | Revision ID: 0054 |
| 4 | Revises: 0053 |
| 5 | Create Date: 2026-05-11 20:05:28.628315+00:00 |
| 6 | |
| 7 | """ |
| 8 | from __future__ import annotations |
| 9 | |
| 10 | from typing import Sequence, Union |
| 11 | |
| 12 | from alembic import op |
| 13 | import sqlalchemy as sa |
| 14 | from sqlalchemy.dialects import postgresql |
| 15 | |
| 16 | # revision identifiers, used by Alembic. |
| 17 | revision: str = '0054' |
| 18 | down_revision: Union[str, None] = '0053' |
| 19 | branch_labels: Union[str, Sequence[str], None] = None |
| 20 | depends_on: Union[str, Sequence[str], None] = None |
| 21 | |
| 22 | |
| 23 | def upgrade() -> None: |
| 24 | # ### commands auto generated by Alembic - please adjust! ### |
| 25 | op.alter_column('musehub_attestation_claim_types', 'introduced_at', |
| 26 | existing_type=postgresql.TIMESTAMP(timezone=True), |
| 27 | server_default=None, |
| 28 | existing_nullable=False) |
| 29 | op.alter_column('musehub_attestations', 'scope', |
| 30 | existing_type=sa.VARCHAR(length=32), |
| 31 | server_default=None, |
| 32 | existing_nullable=False) |
| 33 | op.alter_column('musehub_commits', 'agent_id', |
| 34 | existing_type=sa.VARCHAR(length=255), |
| 35 | server_default=None, |
| 36 | existing_nullable=True) |
| 37 | op.alter_column('musehub_commits', 'model_id', |
| 38 | existing_type=sa.VARCHAR(length=255), |
| 39 | server_default=None, |
| 40 | existing_nullable=True) |
| 41 | op.alter_column('musehub_commits', 'toolchain_id', |
| 42 | existing_type=sa.VARCHAR(length=255), |
| 43 | server_default=None, |
| 44 | existing_nullable=True) |
| 45 | op.alter_column('musehub_commits', 'signature', |
| 46 | existing_type=sa.TEXT(), |
| 47 | server_default=None, |
| 48 | existing_nullable=True) |
| 49 | op.alter_column('musehub_commits', 'signer_public_key', |
| 50 | existing_type=sa.TEXT(), |
| 51 | server_default=None, |
| 52 | existing_nullable=True) |
| 53 | op.alter_column('musehub_commits', 'signer_key_id', |
| 54 | existing_type=sa.VARCHAR(length=255), |
| 55 | server_default=None, |
| 56 | existing_nullable=True) |
| 57 | op.alter_column('musehub_commits', 'sem_ver_bump', |
| 58 | existing_type=sa.VARCHAR(length=10), |
| 59 | server_default=None, |
| 60 | existing_nullable=True) |
| 61 | op.alter_column('musehub_commits', 'test_runs', |
| 62 | existing_type=sa.INTEGER(), |
| 63 | server_default=None, |
| 64 | existing_nullable=True) |
| 65 | op.alter_column('musehub_commits', 'prompt_hash', |
| 66 | existing_type=sa.VARCHAR(length=255), |
| 67 | server_default=None, |
| 68 | existing_nullable=True) |
| 69 | op.alter_column('musehub_file_last_commits', 'commit_message', |
| 70 | existing_type=sa.TEXT(), |
| 71 | server_default=None, |
| 72 | existing_nullable=False) |
| 73 | op.alter_column('musehub_file_last_commits', 'commit_author', |
| 74 | existing_type=sa.VARCHAR(length=255), |
| 75 | server_default=None, |
| 76 | existing_nullable=False) |
| 77 | op.alter_column('musehub_intel_blast_risk', 'risk', |
| 78 | existing_type=sa.VARCHAR(length=16), |
| 79 | server_default=None, |
| 80 | existing_nullable=False) |
| 81 | op.alter_column('musehub_intel_blast_risk', 'risk_score', |
| 82 | existing_type=sa.INTEGER(), |
| 83 | server_default=None, |
| 84 | existing_nullable=False) |
| 85 | op.alter_column('musehub_intel_blast_risk', 'impact_score', |
| 86 | existing_type=sa.DOUBLE_PRECISION(precision=53), |
| 87 | server_default=None, |
| 88 | existing_nullable=False) |
| 89 | op.alter_column('musehub_intel_blast_risk', 'churn_score', |
| 90 | existing_type=sa.DOUBLE_PRECISION(precision=53), |
| 91 | server_default=None, |
| 92 | existing_nullable=False) |
| 93 | op.alter_column('musehub_intel_blast_risk', 'test_gap_score', |
| 94 | existing_type=sa.DOUBLE_PRECISION(precision=53), |
| 95 | server_default=None, |
| 96 | existing_nullable=False) |
| 97 | op.alter_column('musehub_intel_blast_risk', 'coupling_score', |
| 98 | existing_type=sa.DOUBLE_PRECISION(precision=53), |
| 99 | server_default=None, |
| 100 | existing_nullable=False) |
| 101 | op.alter_column('musehub_intel_breakage_meta', 'total_issues', |
| 102 | existing_type=sa.INTEGER(), |
| 103 | server_default=None, |
| 104 | existing_nullable=False) |
| 105 | op.alter_column('musehub_intel_breakage_meta', 'warning_count', |
| 106 | existing_type=sa.INTEGER(), |
| 107 | server_default=None, |
| 108 | existing_nullable=False) |
| 109 | op.alter_column('musehub_intel_breakage_meta', 'error_count', |
| 110 | existing_type=sa.INTEGER(), |
| 111 | server_default=None, |
| 112 | existing_nullable=False) |
| 113 | op.alter_column('musehub_intel_breakage_meta', 'file_count', |
| 114 | existing_type=sa.INTEGER(), |
| 115 | server_default=None, |
| 116 | existing_nullable=False) |
| 117 | op.alter_column('musehub_intel_clones', 'member_count', |
| 118 | existing_type=sa.INTEGER(), |
| 119 | server_default=None, |
| 120 | existing_nullable=False) |
| 121 | op.alter_column('musehub_intel_clones', 'members_json', |
| 122 | existing_type=sa.TEXT(), |
| 123 | server_default=None, |
| 124 | existing_nullable=False) |
| 125 | op.alter_column('musehub_intel_codemap_meta', 'total_modules', |
| 126 | existing_type=sa.INTEGER(), |
| 127 | server_default=None, |
| 128 | existing_nullable=False) |
| 129 | op.alter_column('musehub_intel_codemap_meta', 'total_edges', |
| 130 | existing_type=sa.INTEGER(), |
| 131 | server_default=None, |
| 132 | existing_nullable=False) |
| 133 | op.alter_column('musehub_intel_codemap_meta', 'cycle_count', |
| 134 | existing_type=sa.INTEGER(), |
| 135 | server_default=None, |
| 136 | existing_nullable=False) |
| 137 | op.alter_column('musehub_intel_codemap_modules', 'symbol_count', |
| 138 | existing_type=sa.INTEGER(), |
| 139 | server_default=None, |
| 140 | existing_nullable=False) |
| 141 | op.alter_column('musehub_intel_codemap_modules', 'fan_in', |
| 142 | existing_type=sa.INTEGER(), |
| 143 | server_default=None, |
| 144 | existing_nullable=False) |
| 145 | op.alter_column('musehub_intel_codemap_modules', 'fan_out', |
| 146 | existing_type=sa.INTEGER(), |
| 147 | server_default=None, |
| 148 | existing_nullable=False) |
| 149 | op.alter_column('musehub_intel_codemap_modules', 'language', |
| 150 | existing_type=sa.VARCHAR(length=128), |
| 151 | server_default=None, |
| 152 | existing_nullable=False) |
| 153 | op.alter_column('musehub_intel_coupling', 'co_changes', |
| 154 | existing_type=sa.INTEGER(), |
| 155 | server_default=None, |
| 156 | existing_nullable=False) |
| 157 | op.alter_column('musehub_intel_dead', 'confidence', |
| 158 | existing_type=sa.VARCHAR(length=16), |
| 159 | server_default=None, |
| 160 | existing_nullable=False) |
| 161 | op.alter_column('musehub_intel_entangle', 'co_change_rate', |
| 162 | existing_type=sa.DOUBLE_PRECISION(precision=53), |
| 163 | server_default=None, |
| 164 | existing_nullable=False) |
| 165 | op.alter_column('musehub_intel_entangle', 'co_changes', |
| 166 | existing_type=sa.INTEGER(), |
| 167 | server_default=None, |
| 168 | existing_nullable=False) |
| 169 | op.alter_column('musehub_intel_languages', 'symbol_count', |
| 170 | existing_type=sa.INTEGER(), |
| 171 | server_default=None, |
| 172 | existing_nullable=False) |
| 173 | op.alter_column('musehub_intel_languages', 'file_count', |
| 174 | existing_type=sa.INTEGER(), |
| 175 | server_default=None, |
| 176 | existing_nullable=False) |
| 177 | op.alter_column('musehub_intel_languages', 'pct', |
| 178 | existing_type=sa.DOUBLE_PRECISION(precision=53), |
| 179 | server_default=None, |
| 180 | existing_nullable=False) |
| 181 | op.alter_column('musehub_intel_languages', 'kinds_json', |
| 182 | existing_type=postgresql.JSONB(astext_type=sa.Text()), |
| 183 | comment=None, |
| 184 | existing_comment="kind → count breakdown, e.g. {'function': 1346, 'class': 1447}", |
| 185 | existing_nullable=True) |
| 186 | op.alter_column('musehub_intel_stable', 'days_stable', |
| 187 | existing_type=sa.INTEGER(), |
| 188 | server_default=None, |
| 189 | existing_nullable=False) |
| 190 | op.alter_column('musehub_intel_type', 'params_total', |
| 191 | existing_type=sa.INTEGER(), |
| 192 | server_default=None, |
| 193 | existing_nullable=False) |
| 194 | op.alter_column('musehub_intel_type', 'params_annotated', |
| 195 | existing_type=sa.INTEGER(), |
| 196 | server_default=None, |
| 197 | existing_nullable=False) |
| 198 | op.alter_column('musehub_intel_type', 'params_with_any', |
| 199 | existing_type=sa.INTEGER(), |
| 200 | server_default=None, |
| 201 | existing_nullable=False) |
| 202 | op.alter_column('musehub_intel_type', 'type_score', |
| 203 | existing_type=sa.DOUBLE_PRECISION(precision=53), |
| 204 | server_default=None, |
| 205 | existing_nullable=False) |
| 206 | op.alter_column('musehub_intel_velocity', 'added', |
| 207 | existing_type=sa.INTEGER(), |
| 208 | server_default=None, |
| 209 | existing_nullable=False) |
| 210 | op.alter_column('musehub_intel_velocity', 'removed', |
| 211 | existing_type=sa.INTEGER(), |
| 212 | server_default=None, |
| 213 | existing_nullable=False) |
| 214 | op.alter_column('musehub_intel_velocity', 'net', |
| 215 | existing_type=sa.INTEGER(), |
| 216 | server_default=None, |
| 217 | existing_nullable=False) |
| 218 | op.alter_column('musehub_intel_velocity', 'modified', |
| 219 | existing_type=sa.INTEGER(), |
| 220 | server_default=None, |
| 221 | existing_nullable=False) |
| 222 | op.alter_column('musehub_intel_velocity', 'active_commits', |
| 223 | existing_type=sa.INTEGER(), |
| 224 | server_default=None, |
| 225 | existing_nullable=False) |
| 226 | op.alter_column('musehub_intel_velocity', 'prior_added', |
| 227 | existing_type=sa.INTEGER(), |
| 228 | server_default=None, |
| 229 | existing_nullable=False) |
| 230 | op.alter_column('musehub_intel_velocity', 'prior_net', |
| 231 | existing_type=sa.INTEGER(), |
| 232 | server_default=None, |
| 233 | existing_nullable=False) |
| 234 | op.alter_column('musehub_intel_velocity', 'prior_modified', |
| 235 | existing_type=sa.INTEGER(), |
| 236 | server_default=None, |
| 237 | existing_nullable=False) |
| 238 | op.alter_column('musehub_intel_velocity', 'prior_active_commits', |
| 239 | existing_type=sa.INTEGER(), |
| 240 | server_default=None, |
| 241 | existing_nullable=False) |
| 242 | op.alter_column('musehub_intel_velocity', 'acceleration', |
| 243 | existing_type=sa.DOUBLE_PRECISION(precision=53), |
| 244 | server_default=None, |
| 245 | existing_nullable=False) |
| 246 | op.alter_column('musehub_intel_velocity', 'stagnant_commits', |
| 247 | existing_type=sa.INTEGER(), |
| 248 | server_default=None, |
| 249 | existing_nullable=False) |
| 250 | op.alter_column('musehub_intel_velocity', 'window_size', |
| 251 | existing_type=sa.INTEGER(), |
| 252 | server_default=None, |
| 253 | existing_nullable=False) |
| 254 | op.alter_column('musehub_intel_velocity', 'commits_analysed', |
| 255 | existing_type=sa.INTEGER(), |
| 256 | server_default=None, |
| 257 | existing_nullable=False) |
| 258 | op.drop_index(op.f('ix_musehub_object_refs_object_id'), table_name='musehub_object_refs') |
| 259 | op.alter_column('musehub_proposal_dependencies', 'created_at', |
| 260 | existing_type=postgresql.TIMESTAMP(timezone=True), |
| 261 | server_default=None, |
| 262 | existing_nullable=False) |
| 263 | op.alter_column('musehub_proposal_reviews', 'reviewed_domains', |
| 264 | existing_type=postgresql.ARRAY(sa.TEXT()), |
| 265 | server_default=None, |
| 266 | existing_nullable=False) |
| 267 | op.alter_column('musehub_proposal_reviews', 'domain_risk_acknowledged', |
| 268 | existing_type=postgresql.JSONB(astext_type=sa.Text()), |
| 269 | server_default=None, |
| 270 | existing_nullable=False) |
| 271 | op.alter_column('musehub_proposal_simulations', 'from_branch_commit_id', |
| 272 | existing_type=sa.VARCHAR(length=128), |
| 273 | server_default=None, |
| 274 | existing_nullable=False) |
| 275 | op.alter_column('musehub_proposal_simulations', 'result', |
| 276 | existing_type=postgresql.JSONB(astext_type=sa.Text()), |
| 277 | server_default=None, |
| 278 | existing_nullable=False) |
| 279 | op.alter_column('musehub_proposal_simulations', 'duration_ms', |
| 280 | existing_type=sa.INTEGER(), |
| 281 | server_default=None, |
| 282 | existing_nullable=False) |
| 283 | op.alter_column('musehub_proposal_simulations', 'created_at', |
| 284 | existing_type=postgresql.TIMESTAMP(timezone=True), |
| 285 | server_default=None, |
| 286 | existing_nullable=False) |
| 287 | op.alter_column('musehub_proposals', 'dimensional_risk', |
| 288 | existing_type=postgresql.JSONB(astext_type=sa.Text()), |
| 289 | server_default=None, |
| 290 | existing_nullable=False) |
| 291 | op.alter_column('musehub_proposals', 'midi_tracks_changed', |
| 292 | existing_type=sa.INTEGER(), |
| 293 | server_default=None, |
| 294 | existing_nullable=False) |
| 295 | op.alter_column('musehub_proposals', 'midi_notes_delta', |
| 296 | existing_type=sa.INTEGER(), |
| 297 | server_default=None, |
| 298 | existing_nullable=False) |
| 299 | op.alter_column('musehub_proposals', 'payment_claim_count', |
| 300 | existing_type=sa.INTEGER(), |
| 301 | server_default=None, |
| 302 | existing_nullable=False) |
| 303 | op.alter_column('musehub_proposals', 'payment_ledger_delta_nano', |
| 304 | existing_type=sa.BIGINT(), |
| 305 | server_default=None, |
| 306 | existing_nullable=False) |
| 307 | op.alter_column('musehub_repos', 'default_branch', |
| 308 | existing_type=sa.VARCHAR(length=255), |
| 309 | server_default='main', |
| 310 | existing_nullable=False) |
| 311 | op.alter_column('musehub_repos', 'created_at', |
| 312 | existing_type=postgresql.TIMESTAMP(timezone=True), |
| 313 | server_default=sa.text('now()'), |
| 314 | existing_nullable=False) |
| 315 | op.alter_column('musehub_repos', 'updated_at', |
| 316 | existing_type=postgresql.TIMESTAMP(timezone=True), |
| 317 | server_default=sa.text('now()'), |
| 318 | existing_nullable=False) |
| 319 | # Delete snapshot rows that have no manifest_blob before enforcing NOT NULL. |
| 320 | # These are orphaned rows from pre-0053 pushes that were never backfilled. |
| 321 | op.execute("DELETE FROM musehub_snapshots WHERE manifest_blob IS NULL") |
| 322 | op.alter_column('musehub_snapshots', 'manifest_blob', |
| 323 | existing_type=postgresql.BYTEA(), |
| 324 | nullable=False) |
| 325 | op.alter_column('musehub_symbol_coupling', 'shared_commits', |
| 326 | existing_type=sa.INTEGER(), |
| 327 | server_default=None, |
| 328 | existing_nullable=False) |
| 329 | op.alter_column('musehub_symbol_intel', 'churn', |
| 330 | existing_type=sa.INTEGER(), |
| 331 | server_default=None, |
| 332 | existing_nullable=False) |
| 333 | op.alter_column('musehub_symbol_intel', 'churn_30d', |
| 334 | existing_type=sa.INTEGER(), |
| 335 | server_default=None, |
| 336 | existing_nullable=False) |
| 337 | op.alter_column('musehub_symbol_intel', 'churn_90d', |
| 338 | existing_type=sa.INTEGER(), |
| 339 | server_default=None, |
| 340 | existing_nullable=False) |
| 341 | op.alter_column('musehub_symbol_intel', 'blast', |
| 342 | existing_type=sa.INTEGER(), |
| 343 | server_default=None, |
| 344 | existing_nullable=False) |
| 345 | op.alter_column('musehub_symbol_intel', 'blast_direct', |
| 346 | existing_type=sa.INTEGER(), |
| 347 | server_default=None, |
| 348 | existing_nullable=False) |
| 349 | op.alter_column('musehub_symbol_intel', 'blast_cross', |
| 350 | existing_type=sa.INTEGER(), |
| 351 | server_default=None, |
| 352 | existing_nullable=False) |
| 353 | op.alter_column('musehub_symbol_intel', 'blast_top', |
| 354 | existing_type=postgresql.ARRAY(sa.TEXT()), |
| 355 | server_default=None, |
| 356 | existing_nullable=False) |
| 357 | op.alter_column('musehub_symbol_intel', 'author_count', |
| 358 | existing_type=sa.INTEGER(), |
| 359 | server_default=None, |
| 360 | existing_nullable=False) |
| 361 | op.alter_column('musehub_symbol_intel', 'gravity', |
| 362 | existing_type=sa.DOUBLE_PRECISION(precision=53), |
| 363 | server_default=None, |
| 364 | existing_nullable=False) |
| 365 | op.alter_column('musehub_symbol_intel', 'weekly', |
| 366 | existing_type=postgresql.ARRAY(sa.INTEGER()), |
| 367 | server_default=None, |
| 368 | existing_nullable=False) |
| 369 | op.alter_column('musehub_symbol_vitals', 'change_count', |
| 370 | existing_type=sa.INTEGER(), |
| 371 | server_default=None, |
| 372 | existing_nullable=False) |
| 373 | op.alter_column('musehub_symbol_vitals', 'version_count', |
| 374 | existing_type=sa.INTEGER(), |
| 375 | server_default=None, |
| 376 | existing_nullable=False) |
| 377 | op.alter_column('musehub_symbol_vitals', 'op_add', |
| 378 | existing_type=sa.INTEGER(), |
| 379 | server_default=None, |
| 380 | existing_nullable=False) |
| 381 | op.alter_column('musehub_symbol_vitals', 'op_modify', |
| 382 | existing_type=sa.INTEGER(), |
| 383 | server_default=None, |
| 384 | existing_nullable=False) |
| 385 | op.alter_column('musehub_symbol_vitals', 'op_delete', |
| 386 | existing_type=sa.INTEGER(), |
| 387 | server_default=None, |
| 388 | existing_nullable=False) |
| 389 | op.alter_column('musehub_symbol_vitals', 'op_move', |
| 390 | existing_type=sa.INTEGER(), |
| 391 | server_default=None, |
| 392 | existing_nullable=False) |
| 393 | # ### end Alembic commands ### |
| 394 | |
| 395 | |
| 396 | def downgrade() -> None: |
| 397 | # ### commands auto generated by Alembic - please adjust! ### |
| 398 | op.alter_column('musehub_symbol_vitals', 'op_move', |
| 399 | existing_type=sa.INTEGER(), |
| 400 | server_default=sa.text('0'), |
| 401 | existing_nullable=False) |
| 402 | op.alter_column('musehub_symbol_vitals', 'op_delete', |
| 403 | existing_type=sa.INTEGER(), |
| 404 | server_default=sa.text('0'), |
| 405 | existing_nullable=False) |
| 406 | op.alter_column('musehub_symbol_vitals', 'op_modify', |
| 407 | existing_type=sa.INTEGER(), |
| 408 | server_default=sa.text('0'), |
| 409 | existing_nullable=False) |
| 410 | op.alter_column('musehub_symbol_vitals', 'op_add', |
| 411 | existing_type=sa.INTEGER(), |
| 412 | server_default=sa.text('0'), |
| 413 | existing_nullable=False) |
| 414 | op.alter_column('musehub_symbol_vitals', 'version_count', |
| 415 | existing_type=sa.INTEGER(), |
| 416 | server_default=sa.text('0'), |
| 417 | existing_nullable=False) |
| 418 | op.alter_column('musehub_symbol_vitals', 'change_count', |
| 419 | existing_type=sa.INTEGER(), |
| 420 | server_default=sa.text('0'), |
| 421 | existing_nullable=False) |
| 422 | op.alter_column('musehub_symbol_intel', 'weekly', |
| 423 | existing_type=postgresql.ARRAY(sa.INTEGER()), |
| 424 | server_default=sa.text("'{}'::integer[]"), |
| 425 | existing_nullable=False) |
| 426 | op.alter_column('musehub_symbol_intel', 'gravity', |
| 427 | existing_type=sa.DOUBLE_PRECISION(precision=53), |
| 428 | server_default=sa.text("'0'::double precision"), |
| 429 | existing_nullable=False) |
| 430 | op.alter_column('musehub_symbol_intel', 'author_count', |
| 431 | existing_type=sa.INTEGER(), |
| 432 | server_default=sa.text('0'), |
| 433 | existing_nullable=False) |
| 434 | op.alter_column('musehub_symbol_intel', 'blast_top', |
| 435 | existing_type=postgresql.ARRAY(sa.TEXT()), |
| 436 | server_default=sa.text("'{}'::text[]"), |
| 437 | existing_nullable=False) |
| 438 | op.alter_column('musehub_symbol_intel', 'blast_cross', |
| 439 | existing_type=sa.INTEGER(), |
| 440 | server_default=sa.text('0'), |
| 441 | existing_nullable=False) |
| 442 | op.alter_column('musehub_symbol_intel', 'blast_direct', |
| 443 | existing_type=sa.INTEGER(), |
| 444 | server_default=sa.text('0'), |
| 445 | existing_nullable=False) |
| 446 | op.alter_column('musehub_symbol_intel', 'blast', |
| 447 | existing_type=sa.INTEGER(), |
| 448 | server_default=sa.text('0'), |
| 449 | existing_nullable=False) |
| 450 | op.alter_column('musehub_symbol_intel', 'churn_90d', |
| 451 | existing_type=sa.INTEGER(), |
| 452 | server_default=sa.text('0'), |
| 453 | existing_nullable=False) |
| 454 | op.alter_column('musehub_symbol_intel', 'churn_30d', |
| 455 | existing_type=sa.INTEGER(), |
| 456 | server_default=sa.text('0'), |
| 457 | existing_nullable=False) |
| 458 | op.alter_column('musehub_symbol_intel', 'churn', |
| 459 | existing_type=sa.INTEGER(), |
| 460 | server_default=sa.text('0'), |
| 461 | existing_nullable=False) |
| 462 | op.alter_column('musehub_symbol_coupling', 'shared_commits', |
| 463 | existing_type=sa.INTEGER(), |
| 464 | server_default=sa.text('0'), |
| 465 | existing_nullable=False) |
| 466 | op.alter_column('musehub_snapshots', 'manifest_blob', |
| 467 | existing_type=postgresql.BYTEA(), |
| 468 | nullable=True) |
| 469 | op.alter_column('musehub_repos', 'updated_at', |
| 470 | existing_type=postgresql.TIMESTAMP(timezone=True), |
| 471 | server_default=None, |
| 472 | existing_nullable=False) |
| 473 | op.alter_column('musehub_repos', 'created_at', |
| 474 | existing_type=postgresql.TIMESTAMP(timezone=True), |
| 475 | server_default=None, |
| 476 | existing_nullable=False) |
| 477 | op.alter_column('musehub_repos', 'default_branch', |
| 478 | existing_type=sa.VARCHAR(length=255), |
| 479 | server_default=None, |
| 480 | existing_nullable=False) |
| 481 | op.alter_column('musehub_proposals', 'payment_ledger_delta_nano', |
| 482 | existing_type=sa.BIGINT(), |
| 483 | server_default=sa.text("'0'::bigint"), |
| 484 | existing_nullable=False) |
| 485 | op.alter_column('musehub_proposals', 'payment_claim_count', |
| 486 | existing_type=sa.INTEGER(), |
| 487 | server_default=sa.text('0'), |
| 488 | existing_nullable=False) |
| 489 | op.alter_column('musehub_proposals', 'midi_notes_delta', |
| 490 | existing_type=sa.INTEGER(), |
| 491 | server_default=sa.text('0'), |
| 492 | existing_nullable=False) |
| 493 | op.alter_column('musehub_proposals', 'midi_tracks_changed', |
| 494 | existing_type=sa.INTEGER(), |
| 495 | server_default=sa.text('0'), |
| 496 | existing_nullable=False) |
| 497 | op.alter_column('musehub_proposals', 'dimensional_risk', |
| 498 | existing_type=postgresql.JSONB(astext_type=sa.Text()), |
| 499 | server_default=sa.text("'{}'::jsonb"), |
| 500 | existing_nullable=False) |
| 501 | op.alter_column('musehub_proposal_simulations', 'created_at', |
| 502 | existing_type=postgresql.TIMESTAMP(timezone=True), |
| 503 | server_default=sa.text('now()'), |
| 504 | existing_nullable=False) |
| 505 | op.alter_column('musehub_proposal_simulations', 'duration_ms', |
| 506 | existing_type=sa.INTEGER(), |
| 507 | server_default=sa.text('0'), |
| 508 | existing_nullable=False) |
| 509 | op.alter_column('musehub_proposal_simulations', 'result', |
| 510 | existing_type=postgresql.JSONB(astext_type=sa.Text()), |
| 511 | server_default=sa.text("'{}'::jsonb"), |
| 512 | existing_nullable=False) |
| 513 | op.alter_column('musehub_proposal_simulations', 'from_branch_commit_id', |
| 514 | existing_type=sa.VARCHAR(length=128), |
| 515 | server_default=sa.text("''::character varying"), |
| 516 | existing_nullable=False) |
| 517 | op.alter_column('musehub_proposal_reviews', 'domain_risk_acknowledged', |
| 518 | existing_type=postgresql.JSONB(astext_type=sa.Text()), |
| 519 | server_default=sa.text("'{}'::jsonb"), |
| 520 | existing_nullable=False) |
| 521 | op.alter_column('musehub_proposal_reviews', 'reviewed_domains', |
| 522 | existing_type=postgresql.ARRAY(sa.TEXT()), |
| 523 | server_default=sa.text("'{}'::text[]"), |
| 524 | existing_nullable=False) |
| 525 | op.alter_column('musehub_proposal_dependencies', 'created_at', |
| 526 | existing_type=postgresql.TIMESTAMP(timezone=True), |
| 527 | server_default=sa.text('now()'), |
| 528 | existing_nullable=False) |
| 529 | op.create_index(op.f('ix_musehub_object_refs_object_id'), 'musehub_object_refs', ['object_id'], unique=False) |
| 530 | op.alter_column('musehub_intel_velocity', 'commits_analysed', |
| 531 | existing_type=sa.INTEGER(), |
| 532 | server_default=sa.text('0'), |
| 533 | existing_nullable=False) |
| 534 | op.alter_column('musehub_intel_velocity', 'window_size', |
| 535 | existing_type=sa.INTEGER(), |
| 536 | server_default=sa.text('20'), |
| 537 | existing_nullable=False) |
| 538 | op.alter_column('musehub_intel_velocity', 'stagnant_commits', |
| 539 | existing_type=sa.INTEGER(), |
| 540 | server_default=sa.text('0'), |
| 541 | existing_nullable=False) |
| 542 | op.alter_column('musehub_intel_velocity', 'acceleration', |
| 543 | existing_type=sa.DOUBLE_PRECISION(precision=53), |
| 544 | server_default=sa.text("'0'::double precision"), |
| 545 | existing_nullable=False) |
| 546 | op.alter_column('musehub_intel_velocity', 'prior_active_commits', |
| 547 | existing_type=sa.INTEGER(), |
| 548 | server_default=sa.text('0'), |
| 549 | existing_nullable=False) |
| 550 | op.alter_column('musehub_intel_velocity', 'prior_modified', |
| 551 | existing_type=sa.INTEGER(), |
| 552 | server_default=sa.text('0'), |
| 553 | existing_nullable=False) |
| 554 | op.alter_column('musehub_intel_velocity', 'prior_net', |
| 555 | existing_type=sa.INTEGER(), |
| 556 | server_default=sa.text('0'), |
| 557 | existing_nullable=False) |
| 558 | op.alter_column('musehub_intel_velocity', 'prior_added', |
| 559 | existing_type=sa.INTEGER(), |
| 560 | server_default=sa.text('0'), |
| 561 | existing_nullable=False) |
| 562 | op.alter_column('musehub_intel_velocity', 'active_commits', |
| 563 | existing_type=sa.INTEGER(), |
| 564 | server_default=sa.text('0'), |
| 565 | existing_nullable=False) |
| 566 | op.alter_column('musehub_intel_velocity', 'modified', |
| 567 | existing_type=sa.INTEGER(), |
| 568 | server_default=sa.text('0'), |
| 569 | existing_nullable=False) |
| 570 | op.alter_column('musehub_intel_velocity', 'net', |
| 571 | existing_type=sa.INTEGER(), |
| 572 | server_default=sa.text('0'), |
| 573 | existing_nullable=False) |
| 574 | op.alter_column('musehub_intel_velocity', 'removed', |
| 575 | existing_type=sa.INTEGER(), |
| 576 | server_default=sa.text('0'), |
| 577 | existing_nullable=False) |
| 578 | op.alter_column('musehub_intel_velocity', 'added', |
| 579 | existing_type=sa.INTEGER(), |
| 580 | server_default=sa.text('0'), |
| 581 | existing_nullable=False) |
| 582 | op.alter_column('musehub_intel_type', 'type_score', |
| 583 | existing_type=sa.DOUBLE_PRECISION(precision=53), |
| 584 | server_default=sa.text("'0'::double precision"), |
| 585 | existing_nullable=False) |
| 586 | op.alter_column('musehub_intel_type', 'params_with_any', |
| 587 | existing_type=sa.INTEGER(), |
| 588 | server_default=sa.text('0'), |
| 589 | existing_nullable=False) |
| 590 | op.alter_column('musehub_intel_type', 'params_annotated', |
| 591 | existing_type=sa.INTEGER(), |
| 592 | server_default=sa.text('0'), |
| 593 | existing_nullable=False) |
| 594 | op.alter_column('musehub_intel_type', 'params_total', |
| 595 | existing_type=sa.INTEGER(), |
| 596 | server_default=sa.text('0'), |
| 597 | existing_nullable=False) |
| 598 | op.alter_column('musehub_intel_stable', 'days_stable', |
| 599 | existing_type=sa.INTEGER(), |
| 600 | server_default=sa.text('0'), |
| 601 | existing_nullable=False) |
| 602 | op.alter_column('musehub_intel_languages', 'kinds_json', |
| 603 | existing_type=postgresql.JSONB(astext_type=sa.Text()), |
| 604 | comment="kind → count breakdown, e.g. {'function': 1346, 'class': 1447}", |
| 605 | existing_nullable=True) |
| 606 | op.alter_column('musehub_intel_languages', 'pct', |
| 607 | existing_type=sa.DOUBLE_PRECISION(precision=53), |
| 608 | server_default=sa.text("'0'::double precision"), |
| 609 | existing_nullable=False) |
| 610 | op.alter_column('musehub_intel_languages', 'file_count', |
| 611 | existing_type=sa.INTEGER(), |
| 612 | server_default=sa.text('0'), |
| 613 | existing_nullable=False) |
| 614 | op.alter_column('musehub_intel_languages', 'symbol_count', |
| 615 | existing_type=sa.INTEGER(), |
| 616 | server_default=sa.text('0'), |
| 617 | existing_nullable=False) |
| 618 | op.alter_column('musehub_intel_entangle', 'co_changes', |
| 619 | existing_type=sa.INTEGER(), |
| 620 | server_default=sa.text('0'), |
| 621 | existing_nullable=False) |
| 622 | op.alter_column('musehub_intel_entangle', 'co_change_rate', |
| 623 | existing_type=sa.DOUBLE_PRECISION(precision=53), |
| 624 | server_default=sa.text("'0'::double precision"), |
| 625 | existing_nullable=False) |
| 626 | op.alter_column('musehub_intel_dead', 'confidence', |
| 627 | existing_type=sa.VARCHAR(length=16), |
| 628 | server_default=sa.text("'medium'::character varying"), |
| 629 | existing_nullable=False) |
| 630 | op.alter_column('musehub_intel_coupling', 'co_changes', |
| 631 | existing_type=sa.INTEGER(), |
| 632 | server_default=sa.text('0'), |
| 633 | existing_nullable=False) |
| 634 | op.alter_column('musehub_intel_codemap_modules', 'language', |
| 635 | existing_type=sa.VARCHAR(length=128), |
| 636 | server_default=sa.text("''::character varying"), |
| 637 | existing_nullable=False) |
| 638 | op.alter_column('musehub_intel_codemap_modules', 'fan_out', |
| 639 | existing_type=sa.INTEGER(), |
| 640 | server_default=sa.text('0'), |
| 641 | existing_nullable=False) |
| 642 | op.alter_column('musehub_intel_codemap_modules', 'fan_in', |
| 643 | existing_type=sa.INTEGER(), |
| 644 | server_default=sa.text('0'), |
| 645 | existing_nullable=False) |
| 646 | op.alter_column('musehub_intel_codemap_modules', 'symbol_count', |
| 647 | existing_type=sa.INTEGER(), |
| 648 | server_default=sa.text('0'), |
| 649 | existing_nullable=False) |
| 650 | op.alter_column('musehub_intel_codemap_meta', 'cycle_count', |
| 651 | existing_type=sa.INTEGER(), |
| 652 | server_default=sa.text('0'), |
| 653 | existing_nullable=False) |
| 654 | op.alter_column('musehub_intel_codemap_meta', 'total_edges', |
| 655 | existing_type=sa.INTEGER(), |
| 656 | server_default=sa.text('0'), |
| 657 | existing_nullable=False) |
| 658 | op.alter_column('musehub_intel_codemap_meta', 'total_modules', |
| 659 | existing_type=sa.INTEGER(), |
| 660 | server_default=sa.text('0'), |
| 661 | existing_nullable=False) |
| 662 | op.alter_column('musehub_intel_clones', 'members_json', |
| 663 | existing_type=sa.TEXT(), |
| 664 | server_default=sa.text("'[]'::text"), |
| 665 | existing_nullable=False) |
| 666 | op.alter_column('musehub_intel_clones', 'member_count', |
| 667 | existing_type=sa.INTEGER(), |
| 668 | server_default=sa.text('0'), |
| 669 | existing_nullable=False) |
| 670 | op.alter_column('musehub_intel_breakage_meta', 'file_count', |
| 671 | existing_type=sa.INTEGER(), |
| 672 | server_default=sa.text('0'), |
| 673 | existing_nullable=False) |
| 674 | op.alter_column('musehub_intel_breakage_meta', 'error_count', |
| 675 | existing_type=sa.INTEGER(), |
| 676 | server_default=sa.text('0'), |
| 677 | existing_nullable=False) |
| 678 | op.alter_column('musehub_intel_breakage_meta', 'warning_count', |
| 679 | existing_type=sa.INTEGER(), |
| 680 | server_default=sa.text('0'), |
| 681 | existing_nullable=False) |
| 682 | op.alter_column('musehub_intel_breakage_meta', 'total_issues', |
| 683 | existing_type=sa.INTEGER(), |
| 684 | server_default=sa.text('0'), |
| 685 | existing_nullable=False) |
| 686 | op.alter_column('musehub_intel_blast_risk', 'coupling_score', |
| 687 | existing_type=sa.DOUBLE_PRECISION(precision=53), |
| 688 | server_default=sa.text("'0'::double precision"), |
| 689 | existing_nullable=False) |
| 690 | op.alter_column('musehub_intel_blast_risk', 'test_gap_score', |
| 691 | existing_type=sa.DOUBLE_PRECISION(precision=53), |
| 692 | server_default=sa.text("'0'::double precision"), |
| 693 | existing_nullable=False) |
| 694 | op.alter_column('musehub_intel_blast_risk', 'churn_score', |
| 695 | existing_type=sa.DOUBLE_PRECISION(precision=53), |
| 696 | server_default=sa.text("'0'::double precision"), |
| 697 | existing_nullable=False) |
| 698 | op.alter_column('musehub_intel_blast_risk', 'impact_score', |
| 699 | existing_type=sa.DOUBLE_PRECISION(precision=53), |
| 700 | server_default=sa.text("'0'::double precision"), |
| 701 | existing_nullable=False) |
| 702 | op.alter_column('musehub_intel_blast_risk', 'risk_score', |
| 703 | existing_type=sa.INTEGER(), |
| 704 | server_default=sa.text('0'), |
| 705 | existing_nullable=False) |
| 706 | op.alter_column('musehub_intel_blast_risk', 'risk', |
| 707 | existing_type=sa.VARCHAR(length=16), |
| 708 | server_default=sa.text("'low'::character varying"), |
| 709 | existing_nullable=False) |
| 710 | op.alter_column('musehub_file_last_commits', 'commit_author', |
| 711 | existing_type=sa.VARCHAR(length=255), |
| 712 | server_default=sa.text("''::character varying"), |
| 713 | existing_nullable=False) |
| 714 | op.alter_column('musehub_file_last_commits', 'commit_message', |
| 715 | existing_type=sa.TEXT(), |
| 716 | server_default=sa.text("''::text"), |
| 717 | existing_nullable=False) |
| 718 | op.alter_column('musehub_commits', 'prompt_hash', |
| 719 | existing_type=sa.VARCHAR(length=255), |
| 720 | server_default=sa.text("''::character varying"), |
| 721 | existing_nullable=True) |
| 722 | op.alter_column('musehub_commits', 'test_runs', |
| 723 | existing_type=sa.INTEGER(), |
| 724 | server_default=sa.text('0'), |
| 725 | existing_nullable=True) |
| 726 | op.alter_column('musehub_commits', 'sem_ver_bump', |
| 727 | existing_type=sa.VARCHAR(length=10), |
| 728 | server_default=sa.text("'none'::character varying"), |
| 729 | existing_nullable=True) |
| 730 | op.alter_column('musehub_commits', 'signer_key_id', |
| 731 | existing_type=sa.VARCHAR(length=255), |
| 732 | server_default=sa.text("''::character varying"), |
| 733 | existing_nullable=True) |
| 734 | op.alter_column('musehub_commits', 'signer_public_key', |
| 735 | existing_type=sa.TEXT(), |
| 736 | server_default=sa.text("''::text"), |
| 737 | existing_nullable=True) |
| 738 | op.alter_column('musehub_commits', 'signature', |
| 739 | existing_type=sa.TEXT(), |
| 740 | server_default=sa.text("''::text"), |
| 741 | existing_nullable=True) |
| 742 | op.alter_column('musehub_commits', 'toolchain_id', |
| 743 | existing_type=sa.VARCHAR(length=255), |
| 744 | server_default=sa.text("''::character varying"), |
| 745 | existing_nullable=True) |
| 746 | op.alter_column('musehub_commits', 'model_id', |
| 747 | existing_type=sa.VARCHAR(length=255), |
| 748 | server_default=sa.text("''::character varying"), |
| 749 | existing_nullable=True) |
| 750 | op.alter_column('musehub_commits', 'agent_id', |
| 751 | existing_type=sa.VARCHAR(length=255), |
| 752 | server_default=sa.text("''::character varying"), |
| 753 | existing_nullable=True) |
| 754 | op.alter_column('musehub_attestations', 'scope', |
| 755 | existing_type=sa.VARCHAR(length=32), |
| 756 | server_default=sa.text("'identity'::character varying"), |
| 757 | existing_nullable=False) |
| 758 | op.alter_column('musehub_attestation_claim_types', 'introduced_at', |
| 759 | existing_type=postgresql.TIMESTAMP(timezone=True), |
| 760 | server_default=sa.text('now()'), |
| 761 | existing_nullable=False) |
| 762 | # ### end Alembic commands ### |
File History
1 commit
sha256:25d96102cb2d69a038356dff26f4633156da2f1faf98fe0d0e4438ff3f367f12
refactor: rename 0054/0055 migrations to standard convention
Sonnet 4.6
minor
⚠
20 days ago