AutoGPT/autogpt_platform/backend/migrations
Zamil Majdy c36c239dd5
feat(backend): Add graph/node id & execution id on CreditTransaction table (#9217)
We need to be able to determine the cost of graph/node execution.

### Changes 🏗️

* Add these columns into CreditTransaction `metadata` column:
    - graph_id
    - node_id
    - graph_exec_id
    - node_exec_id
    - block_id
* Drop the `blockId` column and backfill the dropped value into
metadata->>block_id.
* Frequent queries on these values will require an index created on
demand through a migration, depending on the use case.

---------

Co-authored-by: Krzysztof Czerwinski <kpczerwinski@gmail.com>
Co-authored-by: Reinier van der Leer <pwuts@agpt.co>
2025-01-16 20:59:49 +00:00
..
20240722143307_migrations refactor: AutoGPT Platform Stealth Launch Repo Re-Org (#8113) 2024-09-20 16:50:43 +02:00
20240726131311_node_input_unique_constraint refactor: AutoGPT Platform Stealth Launch Repo Re-Org (#8113) 2024-09-20 16:50:43 +02:00
20240729061216_static_input_link refactor: AutoGPT Platform Stealth Launch Repo Re-Org (#8113) 2024-09-20 16:50:43 +02:00
20240804040801_add_subgraph refactor: AutoGPT Platform Stealth Launch Repo Re-Org (#8113) 2024-09-20 16:50:43 +02:00
20240805115810_add_user_management refactor: AutoGPT Platform Stealth Launch Repo Re-Org (#8113) 2024-09-20 16:50:43 +02:00
20240807123738_add_index_users refactor: AutoGPT Platform Stealth Launch Repo Re-Org (#8113) 2024-09-20 16:50:43 +02:00
20240808095419_add_required_user_ids refactor: AutoGPT Platform Stealth Launch Repo Re-Org (#8113) 2024-09-20 16:50:43 +02:00
20240902223334_add_stats_column refactor: AutoGPT Platform Stealth Launch Repo Re-Org (#8113) 2024-09-20 16:50:43 +02:00
20240906155206_add_created_at_updated_at refactor: AutoGPT Platform Stealth Launch Repo Re-Org (#8113) 2024-09-20 16:50:43 +02:00
20240914033334_user_credit refactor: AutoGPT Platform Stealth Launch Repo Re-Org (#8113) 2024-09-20 16:50:43 +02:00
20240918163611_add_analytics_tables refactor: AutoGPT Platform Stealth Launch Repo Re-Org (#8113) 2024-09-20 16:50:43 +02:00
20240930151406_reassign_block_ids refactor(blocks): Reassign non-random IDs (#8229) 2024-10-01 15:08:42 +01:00
20241007090536_add_on_delete_platform feat(platform,db): Add on deletes (#8272) 2024-10-07 14:44:37 +04:00
20241007115713_cascade_graph_deletion feat(platform): Add delete agent functionality (#8273) 2024-10-08 16:03:26 +00:00
20241007175111_move_oauth_creds_to_user_obj refactor(backend): Move credentials storage to prisma user (#8283) 2024-10-22 13:33:54 +01:00
20241007175112_add_oauth_creds_user_trigger refactor(backend): Move credentials storage to prisma user (#8283) 2024-10-22 13:33:54 +01:00
20241017180251_add_webhooks_and_their_relation_to_nodes feat(platform, blocks): Webhook-triggered blocks (#8358) 2024-11-25 18:42:36 +01:00
20241030014950_move_integration_creds_to_platform.User feat(backend): credential swap to api keys in cred store (#8403) 2024-10-31 02:36:38 +00:00
20241030061705_encrypt_user_metadata feat(backend): credential swap to api keys in cred store (#8403) 2024-10-31 02:36:38 +00:00
20241030063332_drop_all_credentials_from_constant_input feat(backend): credential swap to api keys in cred store (#8403) 2024-10-31 02:36:38 +00:00
20241103133307_remove_subgraph refactor(backend): Introduced Graph Input & Output Schema, Merge GraphMeta & Graph, Remove subgraph functionality (#8526) 2024-11-07 09:30:51 +07:00
20241103144418_graph_exec_stats_list_to_obj refactor(backend): Introduced Graph Input & Output Schema, Merge GraphMeta & Graph, Remove subgraph functionality (#8526) 2024-11-07 09:30:51 +07:00
20241108170448_add_api_key_support feat(backend): Add API key DB table (#8593) 2024-11-08 17:48:37 +00:00
20241113104933_remove_scheduler fix(backend): Add execution persistence for execution scheduler service (#8649) 2024-11-15 11:17:37 +01:00
20241115170707_fix_llm_provider_credentials fix(backend): Add migrations to fix credentials inputs with invalid provider "llm" (vol. 2) 2024-11-15 20:32:24 +01:00
20241210013740_add_indexes fix(backend): Add missing DB indexes (#8929) 2024-12-10 10:19:22 +00:00
20241211160646_rename_credit_model_and_add_stripe_customer feat(backend): Update schema for PAYG System (#8944) 2024-12-11 16:52:13 +00:00
20241212141024_agent_store_v2 feat(platform): Agent Store V2 (#8874) 2024-12-13 16:35:02 +00:00
20241212142024_creator_featured_flag feat(platform): updated schema to allow featuring of specific creators (#9048) 2024-12-18 13:32:03 +00:00
20241212150828_agent_store_v2_views feat(platform): updated schema to allow featuring of specific creators (#9048) 2024-12-18 13:32:03 +00:00
20241230102007_update_store_agent_view fix(platform): minor fixes (#9147) 2024-12-30 16:04:35 +01:00
20250103143207_add_terminated_execution_status feat(backend/executor): Add `TERMINATED` execution status (#9185) 2025-01-06 22:59:49 +00:00
20250105254106_migrate_brace_to_double_brace_string_format hotfix(backend): Increase statement timeout for the double brace migration (#9245) 2025-01-09 21:59:22 +00:00
20250115213557_add_running_balance feat(platform): Implement top-up flow for PAYG System (#9050) 2025-01-15 23:46:52 +00:00
20250115382614_reshape_transaction_metadata_column feat(backend): Add graph/node id & execution id on CreditTransaction table (#9217) 2025-01-16 20:59:49 +00:00
migration_lock.toml refactor: AutoGPT Platform Stealth Launch Repo Re-Org (#8113) 2024-09-20 16:50:43 +02:00