This is an automated email from the ASF dual-hosted git repository.
lahirujayathilake pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/airavata-custos.git
The following commit(s) were added to refs/heads/master by this push:
new 669000302 Fix project_memberships migration charset
669000302 is described below
commit 66900030285dd51c4e17613dd67a72d577a566e0
Author: lahiruj <[email protected]>
AuthorDate: Tue Jun 23 19:10:26 2026 -0400
Fix project_memberships migration charset
---
internal/db/migrations/000014_project_memberships.up.sql | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/internal/db/migrations/000014_project_memberships.up.sql
b/internal/db/migrations/000014_project_memberships.up.sql
index e14847b38..7626447e6 100644
--- a/internal/db/migrations/000014_project_memberships.up.sql
+++ b/internal/db/migrations/000014_project_memberships.up.sql
@@ -28,7 +28,7 @@ CREATE TABLE project_memberships (
CONSTRAINT fk_project_memberships_project FOREIGN KEY (project_id)
REFERENCES projects(id) ON DELETE CASCADE,
CONSTRAINT fk_project_memberships_user FOREIGN KEY (user_id)
REFERENCES users(id) ON DELETE CASCADE,
CONSTRAINT chk_project_memberships_role CHECK (role IN ('PI', 'CO_PI',
'ALLOCATION_MANAGER'))
-);
+) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
-- Carry forward existing special roles that 000013 wrote onto
-- compute_allocation_memberships. The same user can appear on multiple
