dumplingmiku/ubicloud
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
pykello/vmstats
ubicloud/migrate
History
Jeremy Evans 4a4efb1da9 Drop columns from access_tag, and drop applied_tag and access_policy 
This makes access_tag a pure project <-> accounts join table
(modulo the created_at column to see when the two were
associated).

This removes non-account entries from the access_tag table,
because that is required for the foreign key constraint to work.

While here, drop the applied_tag and access_policy tables, as they
are no longer used.
2025-01-20 13:08:20 -08:00
..
ph
Switch TimestampMigrator from IntegerMigrator
2023-07-05 11:15:03 -07:00
20230117_tables.rb
Switch TimestampMigrator from IntegerMigrator
2023-07-05 11:15:03 -07:00
20230315_rodauth.rb
Switch TimestampMigrator from IntegerMigrator
2023-07-05 11:15:03 -07:00
20230322_add_ssh_users.rb
Switch TimestampMigrator from IntegerMigrator
2023-07-05 11:15:03 -07:00
20230323_add_vm_display.rb
Switch TimestampMigrator from IntegerMigrator
2023-07-05 11:15:03 -07:00
20230328_networking.rb
Switch TimestampMigrator from IntegerMigrator
2023-07-05 11:15:03 -07:00
20230404_ipsec.rb
Switch TimestampMigrator from IntegerMigrator
2023-07-05 11:15:03 -07:00
20230413_add_vmhost_sizes.rb
Switch TimestampMigrator from IntegerMigrator
2023-07-05 11:15:03 -07:00
20230415_add_vm_allocation_counters.rb
Switch TimestampMigrator from IntegerMigrator
2023-07-05 11:15:03 -07:00
20230425_ssh_generation.rb
Switch TimestampMigrator from IntegerMigrator
2023-07-05 11:15:03 -07:00
20230517_authorization.rb
Switch TimestampMigrator from IntegerMigrator
2023-07-05 11:15:03 -07:00
20230605_ipv6_ndp_support.rb
Switch TimestampMigrator from IntegerMigrator
2023-07-05 11:15:03 -07:00
20230613_hugepages.rb
Switch TimestampMigrator from IntegerMigrator
2023-07-05 11:15:03 -07:00
20230615_add_ipv4.rb
Switch TimestampMigrator from IntegerMigrator
2023-07-05 11:15:03 -07:00
20230619_add_ipv4_hetzner_api.rb
Switch TimestampMigrator from IntegerMigrator
2023-07-05 11:15:03 -07:00
20230620_storage.rb
Switch TimestampMigrator from IntegerMigrator
2023-07-05 11:15:03 -07:00
20230705_storage_encryption.rb
Enable encrypted-at-rest storage
2023-07-06 21:42:07 -07:00
20230706_add_private_subnet_ipv4.rb
working ipv6 private + ipv4-in-ipv6
2023-07-07 13:15:37 +02:00
20230713_add_user_name.rb
Add full name field to user
2023-07-13 19:46:18 +03:00
20230714_not_unique_project_name.rb
Remove unique constraint for project name
2023-07-19 08:49:56 +03:00
20230717_set_stack_default.rb
Ensure stacks to have one empty frame by default
2023-07-17 22:26:44 +02:00
20230720_add_storage_cap.rb
Add storage size accounting
2023-07-20 12:54:15 -07:00
20230721_add_project_provider.rb
Add provider to project
2023-07-25 10:19:26 +03:00
20230721_pages.rb
Introduce Page model
2023-07-21 13:43:08 +02:00
20230721_remove_default_ids.rb
Use UBID for model identifiers
2023-07-20 15:24:53 -07:00
20230722_add_nic.rb
Adds PrivateSubnet, Nic and changes model of private networking
2023-07-26 17:15:59 +03:00
20230725_add_billing_rate.rb
Introduce billing rates
2023-07-31 07:13:00 +03:00
20230727_add_primary_keys_to_applied_tags.rb
Use destroy instead of delete
2023-08-01 11:58:57 +03:00
20230727_soft_delete_models.rb
Archive deleted records to a separate table
2023-08-01 11:58:57 +03:00
20230731_add_enable_ip4.rb
Add enable/disable public ipv4
2023-08-01 09:56:03 +02:00
20230802_change_mac_type.rb
Change MAC column type for Nic model
2023-08-02 15:44:29 +02:00
20230804_host_reboot.rb
Semaphore to reboot host
2023-08-06 17:17:43 -07:00
20230805_billing_records.rb
Introduce billing records
2023-08-07 10:52:22 +03:00
20230806_invoices.rb
Add mechanism to generate invoices
2023-08-07 10:52:22 +03:00
20230807_add_visible_to_project.rb
Soft delete projects before archiving
2023-08-07 10:52:22 +03:00
20230807_update_billing.rb
Don't use DB variable in migration scripts
2024-03-04 10:39:35 +01:00
20230808_add_ipv4_billing.rb
Don't use DB variable in migration scripts
2024-03-04 10:39:35 +01:00
20230809_allow_nil_encr_key.rb
Start encrypting and forgetting nic encryption key
2023-08-11 10:52:48 +02:00
20230809_drop_billing_rate.rb
Don't use DB variable in migration scripts
2024-03-04 10:39:35 +01:00
20230810_add_billing_info.rb
Introduce billing details
2023-08-11 11:33:06 +03:00
20230810_add_last_rekey_time.rb
Auto rekeys every 24 hours
2023-08-17 09:42:21 +02:00
20230811_add_nic_rekey_payload.rb
Private Subnet IpsecTunnel rekeying
2023-08-17 09:38:44 +02:00
20230814_add_vm_deleting.rb
Show vm state as "deleting" after delete button clicked
2023-08-15 08:30:10 +03:00
20230820_add_tag_to_page.rb
Fix page storms by using a tag
2023-08-22 22:43:01 +03:00
20230823_split_vm_size.rb
Split VM size into family and cores in DB
2023-08-24 12:03:46 +03:00
20230824_add_tunnel_nic_const.rb
Refactor tunnel creation and nic setup
2023-08-28 09:06:44 +02:00
20230825_add_sshable_user.rb
Make Sshable unix_user configurable.
2023-08-25 12:40:22 -07:00
20230829_restrict_project_id.rb
Generate invoice numbers
2023-08-30 21:38:57 +03:00
20230830_add_credits_to_project.rb
Enable credits and discounts
2023-08-30 21:51:38 +03:00
20230831_add_dates_to_invoice.rb
Add additional data invoice to use at UI
2023-08-31 14:03:15 +03:00
20230901_github_runner.rb
Add models for GitHub action self-hosted runner integration
2023-09-11 14:18:04 +03:00
20230914_add_exponential_backoff.rb
Add exponential backoff migration
2023-09-15 08:56:37 -07:00
20230914_multiple_billing_records_per_resource.rb
Allow multiple billing records per resource
2023-09-14 13:51:22 +03:00
20230919_add_branch_to_github_runner.rb
Add head_branch info to the GitHub runners
2023-09-21 11:12:03 +03:00
20230919_add_vm_pool.rb
Adds Vm Pools
2023-09-26 09:58:47 +02:00
20230920_add_vm_created_at.rb
Add created_at column to Vm and VmHost
2023-09-21 11:11:29 +03:00
20230926_postgres.rb
Protect postgres superuser password
2023-10-09 12:38:58 +03:00
20230928_minio.rb
Add MinIO migration file
2023-10-17 17:49:24 +02:00
20231004_add_host_data_center.rb
Adds Datacenter Information for Hosts
2023-10-05 09:58:14 +01:00
20231014_arm64.rb
Add CPU architecture migration
2023-11-06 10:55:51 -08:00
20231015_make_vm_unique_to_runner.rb
Make VmPool wait until VM is destroyed to provision new VMs
2023-10-17 10:00:36 +02:00
20231016_runner_allow_null_vm.rb
Make the vm_id column nullable for a GitHub runner
2023-10-19 09:19:28 +03:00
20231018_dns_zones.rb
Add migration files for DNS zones
2023-10-20 18:31:14 +02:00
20231019_dns_servers.rb
Add migration files for name servers
2023-10-20 18:31:14 +02:00
20231020_add_cert_to_pg.rb
Add migration file for PG certificates
2023-10-21 00:32:25 +02:00
20231023_rotate_pg_certificates.rb
Add migration file for PG certificate rotation
2023-10-23 10:39:32 +02:00
20231024_add_created_at.rb
Add created_at column to various tables
2023-10-24 08:33:29 +03:00
20231025_add_purge_to_dns_zones.rb
Add migration for dns record purge
2023-10-25 21:58:28 +02:00
20231026_rename_postgres_server.rb
Add migration file for renaming postgres server
2023-10-26 10:54:14 +02:00
20231027_add_storage_to_vm_pool.rb
Add migration file to add storage size to the vm pool
2023-10-31 16:18:34 +03:00
20231102_add_details_to_page.rb
Add migration file to add metadata to the page model
2023-11-02 16:40:48 +03:00
20231102_make_active_page_tag_unique.rb
Make the tag unique for only active pages
2023-11-02 15:05:53 +03:00
20231106_postgres_server.rb
Add migration file for PostgresServer
2023-11-08 10:30:18 +01:00
20231107_add_basic_fw.rb
FirewallRule schema update
2023-11-14 00:15:10 +01:00
20231107_add_total_dies.rb
Add total_dies column to vm_host
2023-11-14 10:20:21 -08:00
20231107_postgres_timeline.rb
Add migration file for PostgresTimeline
2023-11-14 17:06:11 +01:00
20231108_postgres_backups.rb
Add migration file for PostgreSQL backups
2023-11-14 17:06:11 +01:00
20231109_postgres_restore.rb
Add migration file for PostgreSQL restore
2023-11-14 17:06:11 +01:00
20231116_project_flag.rb
Add migration file for project flags
2023-11-15 09:47:50 +01:00
20231122_add_account_suspend.rb
Add migration file to add suspended_at column to accounts
2023-11-23 11:43:01 +03:00
20231122_spdk_upgrade.rb
Enable multiple SPDK installations
2023-11-22 11:39:28 -08:00
20231123_bdev_ubi.rb
Migrations for enabling bdev_ubi for a storage volume.
2023-11-22 15:38:24 -08:00
20231124_project_billable.rb
Add migration file to add billable column to the project
2023-11-24 13:46:02 +03:00
20231125_drop_runner_columns.rb
Drop unused workflow job related columns
2023-11-25 14:01:27 +03:00
20231125_runner_job_data.rb
Add migration file to add workflow_job column to runner
2023-11-25 14:01:27 +03:00
20231128_skip_sync.rb
Migrations to enable storage no_sync
2023-11-28 11:30:13 -08:00
20231129_delete_total_nodes.rb
Drop obsolete vm_host.total_nodes column
2024-01-09 15:44:03 -08:00
20231130_postgres_earliest_backup.rb
Add migration file to add earliest_backup_at to postgres
2023-12-04 11:45:48 +03:00
20231202_concurrency_safe_dns_zones.rb
Add migration files for fixing concurrency bug in DNS operations
2023-12-08 12:10:46 +01:00
20231203_add_latest_backup_started_at_to_timeline.rb
Add migration file for latest_backup_started_at column
2023-12-04 12:33:37 +01:00
20231203_drop_last_ineffective_check_at.rb
Add migration file for dropping last_ineffective_check_at
2023-12-04 12:12:02 +01:00
20231204_drop_last_backup_started_at.rb
Add migration file for dropping last_backup_started_at
2023-12-04 12:33:37 +01:00
20231205_add_fw_rule_port.rb
Adds port ranges to the firewall_rules
2023-12-08 09:16:27 +01:00
20231207_add_pg_blob_str_id.rb
Adds blob_storage_id column to postgres_timeline
2023-12-07 18:59:32 +01:00
20231207_storage_device.rb
Migrations for storage device support
2024-01-24 09:19:33 -08:00
20231208_drop_pg_foreign_key_constraints.rb
Drop foreign key constraints in PostgresResource and PostgresTimeline
2023-12-08 13:23:50 +01:00
20231209_webauthn_name.rb
Configure WebAuthn authentication in rodauth
2023-12-09 14:04:47 +03:00
20231218_minio_drive_rename.rb
Rename minio_cluster driver column to drive
2024-01-09 09:56:14 +01:00
20231222_minio_scale_out.rb
Add pool specific configuration to MinioPool
2024-01-09 09:56:14 +01:00
20231227_add_minio_pool_vm_size.rb
Fix minio_pool vm_size column related migration
2024-01-09 11:33:58 +01:00
20231227_remove_minio_cluster_red_cols.rb
Remove redundant columns from minio_cluster
2024-01-09 10:20:17 +01:00
20240108_add_arch_to_vm_pool.rb
Add migration to add arch to vm pool
2024-01-10 16:51:41 +03:00
20240112_rename_server_name.rb
Add migraton file for renaming server_name column
2024-01-15 14:23:16 +03:00
20240118_core_constraint.rb
Relax core_allocation_limit to allow allocating all host cores.
2024-01-19 10:28:24 -08:00
20240121_move_fw_rules.rb
Migrate firewall_rules from ps to firewall entity
2024-02-01 11:30:43 +01:00
20240122_pg_resource_fw_rules.rb
Add PostgresResourceFirewallRule model
2024-02-01 11:30:43 +01:00
20240123_add_storage_flags_to_vm_pool.rb
Add migration to add storage flags to vm pool
2024-01-19 10:49:29 -08:00
20240123_remove_fwrules_ps_rel.rb
Cleanup for migration of firewall_rules under firewall entity
2024-02-01 11:30:43 +01:00
20240125_add_minio_certs.rb
MinIO Certs DB migration
2024-02-07 11:28:19 +01:00
20240208_add_postgres_lsn_monitor.rb
Add migration file for PostgresLsnMonitor
2024-02-12 12:23:41 +01:00
20240209_postgres_multiple_servers.rb
Add migration file for supporting multiple PostgresServers
2024-02-15 14:19:35 +01:00
20240210_postgres_ha.rb
Add migration file for PostgreSQL standby setup
2024-02-15 14:19:35 +01:00
20240213_allow_using_same_billing_rate.rb
Allow using same billing rate multiple times for same resource
2024-02-19 14:30:10 +01:00
20240220_postgres_hostname_version.rb
Add migration file for hostname_version
2024-02-21 10:42:41 +01:00
20240305_add_runner_core_limit.rb
Add project based runner concurrency limit migration
2024-03-08 15:37:38 +01:00
20240311_add_globally_blocked_dnsname.rb
Add globally blocked dnsname infrastructure migration
2024-03-13 10:50:40 +01:00
20240314_encrypt_vm_pool_tuples.rb
Encrypt VMs on vm pool
2024-03-27 01:29:11 -07:00
20240320_add_vm_provision_timestamps.rb
Add migration to add provisioning timestamps to virtual machine
2024-03-26 14:58:36 +03:00
20240326_add_spdk_cpu_count.rb
Add SPDK cpu count migration.
2024-03-28 11:05:33 -07:00
20240409_move_firewall_to_subnet.rb
Move Firewalls from VM to Subnet model migration
2024-05-02 20:04:04 +02:00
20240412_add_multiple_fw_to_subnet.rb
Make Firewalls assignable to multiple Subnets migration
2024-05-02 20:34:47 +02:00
20240417_github_repository.rb
Add migration for GithubRepository model
2024-04-17 18:49:52 +03:00
20240417_rename_tag_location_names.rb
Convert existing access tag and policy location names
2024-04-24 01:46:35 -07:00
20240418_add_semaphore_strand_index.rb
Add migration to index semaphore.strand_id
2024-04-18 18:38:04 -07:00
20240419_add_constratins_for_volume_device.rb
StorageDevice and VmStorageVolume schema updates
2024-04-22 13:29:34 +02:00
20240422_add_usage_alerts.rb
Add migration file for usage alerts
2024-04-22 16:00:57 +02:00
20240422_drop_vmh_storage_gib_cols.rb
Drop VmHost.total_storage_gib and available_storage_gib columns mig
2024-04-22 13:29:34 +02:00
20240423_add_fraud_columns.rb
Add fraud and card fingerprint columns to payment method
2024-04-25 00:32:38 -07:00
20240423_add_spdk_hugepages.rb
Migrations for SPDK installation hugepage tracking
2024-04-24 18:12:46 -07:00
20240424_drop_project_provider.rb
Remove Project.provider column
2024-04-26 14:01:34 +02:00
20240425_remove_fw_vm_id.rb
Remove vm_id from the firewall table
2024-05-02 20:04:04 +02:00
20240507_pci_device.rb
Migration to create pci_device table
2024-05-07 16:10:05 +02:00
20240509_boot_image.rb
Migrations for versioned boot images
2024-05-09 19:08:40 -07:00
20240516_boot_image_size_gib.rb
Migrations to add size_gib to the boot_image table
2024-05-16 09:32:05 -07:00
20240528_github_default_branch.rb
Add migration to add default branch to GitHub repository
2024-06-06 11:30:36 +03:00
20240529_fix_broken_index.rb
Fix broken billing record index
2024-05-31 18:17:34 +03:00
20240529_github_cache.rb
Add github cache entry migration
2024-06-28 10:06:23 +03:00
20240628_pg_metric_destinations.rb
Add migration file for PostgresMetricDestination
2024-07-03 01:52:02 +02:00
20240701_load_balancer.rb
Load Balancer Basic Migration
2024-07-10 13:17:48 +02:00
20240702_load_balancer_health_probes.rb
Load Balancer Health Probes Migration
2024-07-10 13:17:48 +02:00
20240705_change_runner_core_limit.rb
Reduce runner_core_limit from 300 to 150
2024-07-05 12:25:01 +02:00
20240711_add_severity_to_page.rb
Add severity column to page table
2024-07-12 14:36:29 +03:00
20240711_attach_subnets_and_firewall_to_pg_resource.rb
Add migration file for Postgres subnets and firewalls
2024-07-12 21:43:50 +02:00
20240720_project_quota.rb
Add migration file to add project quotas
2024-07-26 11:51:20 +02:00
20240721_drop_runner_core_limit.rb
Add migration file to drop runner_core_limit column
2024-07-26 11:51:20 +02:00
20240722_add_project_reputation.rb
Add migration file for project reputation
2024-07-26 12:33:43 +02:00
20240723_add_acme_cert.rb
Add ACME Cert Migration
2024-08-20 10:43:13 +02:00
20240730_add_firewall_location.rb
Add migration file to add location for firewall
2024-07-31 14:26:54 +03:00
20240731_firewall_location_not_null.rb
Do not allow firewall location to be null
2024-07-31 14:26:54 +03:00
20240801_add_load_balancer_cert.rb
Load Balancer's Cert integration Migration
2024-08-20 10:43:13 +02:00
20240805_add_lb_health_prob_detaching.rb
Add Load Balancer VM detaching state
2024-08-21 10:47:15 +02:00
20240826_drop_earliest_backup_completed_at.rb
Migration file for dropping earliest_backup_completed_at column
2024-08-28 09:56:26 +02:00
20240827_add_project_invitation.rb
Add migration to create ProjectInvitation table
2024-09-10 19:21:45 +03:00
20240913_add_preauth_columns.rb
Add pre-authorized money amount to payment method model
2024-09-13 16:06:49 +03:00
20240918_make_invitation_email_citex.rb
Make project invitation emails case insensitive
2024-09-18 15:42:03 +03:00
20240924_add_postgres_flavor.rb
Add migration file for flavor column in PostgresResource
2024-09-27 10:46:13 +02:00
20240925_api_key.rb
API key migration
2024-10-01 15:36:57 +02:00
20240925_managed_policies.rb
Add migration for managed access policies
2024-10-10 16:27:55 +03:00
20240926_inference_endpoint.rb
Inference Endpoint migration
2024-10-01 15:36:57 +02:00
20240930_cert_allow_null_dns_zone.rb
Migration to allow null dns zone id for certs
2024-10-01 15:36:57 +02:00
20241007_lb_custom_hostname.rb
Add Load Balancer custom hostname support migration
2024-10-07 17:08:25 +02:00
20241011_add_lantern_as_flavor.rb
Add migration file for adding lantern as new PostgreSQL flavor
2024-10-10 20:49:41 +02:00
20241014_add_connected_subnet.rb
Add Connected Subnet Migration
2024-11-04 16:34:05 +01:00
20241022_add_postgres_version.rb
Add migration file for Postgres version
2024-10-25 13:44:27 +03:00
20241030_add_inference_endpoint_gpu_count.rb
Migration to add gpu_count to inference_endpoint
2024-10-31 12:44:39 +01:00
20241106_add_lb_stack.rb
Add load balancer stack option migration
2024-11-06 13:04:07 +01:00
20241120_add_storage_rate_limits.rb
Migration to add disk rate limit columns.
2024-11-20 13:26:27 -08:00
20241121_add_os_info.rb
Migrations to include OS information for VmHost.
2024-11-21 11:50:30 -08:00
20241122_add_transparent_cache.rb
Add cache enablement migration for github installation
2024-11-29 16:09:47 +03:00
20241204_vm_add_vcpus_memory.rb
Migrations to add vcpus & memory_gib to Vm
2024-12-11 16:34:54 -08:00
20241204_vm_enforce_vcpus_memory.rb
Enforce vcpus & memory_gib to be set for Vm.
2024-12-11 16:34:54 -08:00
20241213_archived_record.rb
Migration: Add partitioned table archived_record
2024-12-14 11:48:31 +01:00
20241214_access_tag_hyper_tag_project_index.rb
Add a migration for an index for access_tag.{hyper_tag_id,project_id}
2024-12-18 09:39:56 -08:00
20241215_authorization_refactor.rb
Add migration for new authorization/access control system
2024-12-23 11:46:38 -08:00
20241221_add_social_login.rb
Add migration for social login
2024-12-30 12:22:26 +03:00
20241224_member_action_tag_inference_endpoint_view.rb
Add InferenceEndpoint:view to the Member global action tag
2024-12-30 08:25:55 -08:00
20241230_archived_record_trigger.rb
Add migration to use archived_record for applied_{subject,action,object}_tag
2024-12-31 11:34:51 -08:00
20241231_inference_endpoint_tags.rb
Migration: Add tags to inference_endpoint
2025-01-02 19:55:10 +01:00
20250101_update_project_quotas.rb
Add migration file to update quota values
2025-01-03 13:26:43 +01:00
20250108_drop_deleted_record.rb
Drop deleted records table
2025-01-10 10:50:54 +01:00
20250109_rename_action_type_inference_token_to_api_key.rb
Migration: Rename InferenceToken to InferenceApiKey
2025-01-10 09:31:56 +01:00
20250113_vm_host_slice.rb
Add VmHostSlice migrations.
2025-01-13 16:11:57 -08:00
20250114_project_id_columns_for_models.rb
Add project_id to tables that should only be associated with a single project
2025-01-14 11:56:06 -08:00
20250115_project_id_name_indexes.rb
Add unique indexes and constraints
2025-01-16 13:29:34 -08:00
20250116_fix_usage_alert_unique_index.rb
Fix unique index for usage_alert
2025-01-16 14:31:53 -08:00
20250117_project_id_not_null.rb
Mark project_id columns newly added to tables as NOT NULL
2025-01-17 12:47:51 -08:00
20250118_drop_applied_tag_foreign_key.rb
Remove some constraints on access_tag and applied tag
2025-01-20 09:05:57 -08:00
20250119_add_vm_host_cpus.rb
Add VmHostCpu
2025-01-19 08:53:54 -08:00
20250119_insert_vm_host_cpus.rb
Insert missing VmHostCpus.
2025-01-19 08:53:54 -08:00
20250120_access_tag_null_changes.rb
Drop columns from access_tag, and drop applied_tag and access_policy
2025-01-20 13:08:20 -08:00
postgres_monitor_db.sql
Use Ubicloud managed PostgreSQL for lsn recording
2024-02-21 10:54:31 +01:00