summary refs log tree commit diff
path: root/src/util/migration
diff options
context:
space:
mode:
authorTomatoCake <60300461+DEVTomatoCake@users.noreply.github.com>2024-08-24 07:37:34 +0200
committerTomatoCake <60300461+DEVTomatoCake@users.noreply.github.com>2024-08-24 07:37:34 +0200
commiteca4f1b56c1d71d381a287e9558cd28167e39ca3 (patch)
treeeacc003298fdfecb3103baff5fb8d1f31e5b9b40 /src/util/migration
parentMerge pull request #1194 from DEVTomatoCake/fix/update-vanity-url-widget-invite (diff)
downloadserver-ts-eca4f1b56c1d71d381a287e9558cd28167e39ca3.tar.xz
Listing & creation of Developer Portal teams
Diffstat (limited to 'src/util/migration')
-rw-r--r--src/util/migration/mariadb/1724477620293-teamMemberRole.ts17
-rw-r--r--src/util/migration/mysql/1724477620293-teamMemberRole.ts17
-rw-r--r--src/util/migration/postgres/1724477620293-teamMemberRole.ts15
3 files changed, 49 insertions, 0 deletions
diff --git a/src/util/migration/mariadb/1724477620293-teamMemberRole.ts b/src/util/migration/mariadb/1724477620293-teamMemberRole.ts
new file mode 100644

index 000000000..ff4be7bf5 --- /dev/null +++ b/src/util/migration/mariadb/1724477620293-teamMemberRole.ts
@@ -0,0 +1,17 @@ +import { MigrationInterface, QueryRunner } from "typeorm"; + +export class TeamMemberRole1724477620293 implements MigrationInterface { + name = "TeamMemberRole1724477620293"; + + public async up(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query( + "ALTER TABLE `team_members` ADD COLUMN `role` VARCHAR(255) NOT NULL AFTER `permissions`", + ); + } + + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query( + "ALTER TABLE `team_members` DROP COLUMN `role`", + ); + } +} diff --git a/src/util/migration/mysql/1724477620293-teamMemberRole.ts b/src/util/migration/mysql/1724477620293-teamMemberRole.ts new file mode 100644
index 000000000..ff4be7bf5 --- /dev/null +++ b/src/util/migration/mysql/1724477620293-teamMemberRole.ts
@@ -0,0 +1,17 @@ +import { MigrationInterface, QueryRunner } from "typeorm"; + +export class TeamMemberRole1724477620293 implements MigrationInterface { + name = "TeamMemberRole1724477620293"; + + public async up(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query( + "ALTER TABLE `team_members` ADD COLUMN `role` VARCHAR(255) NOT NULL AFTER `permissions`", + ); + } + + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query( + "ALTER TABLE `team_members` DROP COLUMN `role`", + ); + } +} diff --git a/src/util/migration/postgres/1724477620293-teamMemberRole.ts b/src/util/migration/postgres/1724477620293-teamMemberRole.ts new file mode 100644
index 000000000..d3276d918 --- /dev/null +++ b/src/util/migration/postgres/1724477620293-teamMemberRole.ts
@@ -0,0 +1,15 @@ +import { MigrationInterface, QueryRunner } from "typeorm"; + +export class TeamMemberRole1724477620293 implements MigrationInterface { + name = "TeamMemberRole1724477620293"; + + public async up(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query( + "ALTER TABLE team_members ADD COLUMN role text NOT NULL", + ); + } + + public async down(queryRunner: QueryRunner): Promise<void> { + await queryRunner.query("ALTER TABLE team_members DROP COLUMN role"); + } +}