fix erc1155_token_transfer pkey (HemeraProtocol#160)

xuzh2024 · web-flow · commit 94ec10e38384 · 2024-09-20T14:36:58.000+08:00
diff --git a/migrations/versions/20240725_update_index_table_optimize.py b/migrations/versions/20240725_update_index_table_optimize.py
@@ -210,6 +210,12 @@ def upgrade() -> None:
         ["token_address", "to_address"],
         unique=False,
     )
+    op.drop_constraint("erc1155_token_transfers_pkey", "erc1155_token_transfers", type_="primary")
+    op.create_primary_key(
+        "erc1155_token_transfers_pkey",
+        "erc1155_token_transfers",
+        ["transaction_hash", "block_hash", "log_index", "token_id"],
+    )
     op.alter_column(
         "erc20_token_transfers",
         "block_hash",
@@ -671,6 +677,12 @@ def downgrade() -> None:
         existing_type=sa.NUMERIC(precision=78, scale=0),
         nullable=True,
     )
+    op.drop_constraint("erc1155_token_transfers_pkey", "erc1155_token_transfers", type_="primary")
+    op.create_primary_key(
+        "erc1155_token_transfers_pkey",
+        "erc1155_token_transfers",
+        ["transaction_hash", "log_index"],
+    )
     op.drop_index("erc1155_detail_desc_address_id_index", table_name="erc1155_token_id_details")
     op.drop_constraint("erc1155_token_id_details_pkey", "erc1155_token_id_details", type_="primary")
     op.alter_column("erc1155_token_id_details", "token_address", new_column_name="address")
