dumplingmiku/ubicloud
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
velioglu/use_local_ip
ubicloud/migrate
History
Enes Cakir c427e67871 Make project invitation emails case insensitive 
When a user registers using an invitation email with different casing,
the system fails to find the invitation because the email column is
case-sensitive. I reviewed the rodauth code and found that it uses a
`citext` column for emails to ensure case insensitivity [^1]. Given that
we match `accounts.email` with `project_invitation.email`, we also need
to make `project_invitations.email` case-insensitive.

[^1]: 24bc83ff54/README.rdoc (L317)
2024-09-18 15:42:03 +03: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
postgres_monitor_db.sql
Use Ubicloud managed PostgreSQL for lsn recording
2024-02-21 10:54:31 +01:00