23 lines
1.0 KiB
JavaScript
23 lines
1.0 KiB
JavaScript
/*
|
|
* SPDX-FileCopyrightText: syuilo and other misskey contributors
|
|
* SPDX-License-Identifier: AGPL-3.0-only
|
|
*/
|
|
|
|
export class ApprovalSignup1697580470000 {
|
|
name = 'ApprovalSignup1697580470000'
|
|
|
|
async up(queryRunner) {
|
|
await queryRunner.query(`ALTER TABLE "meta" ADD "approvalRequiredForSignup" boolean DEFAULT false NOT NULL`);
|
|
await queryRunner.query(`ALTER TABLE "user" ADD "approved" boolean DEFAULT false NOT NULL`);
|
|
await queryRunner.query(`ALTER TABLE "user" ADD "signupReason" character varying(1000) NULL`);
|
|
await queryRunner.query(`ALTER TABLE "user_pending" ADD "reason" character varying(1000) NULL`);
|
|
}
|
|
|
|
async down(queryRunner) {
|
|
await queryRunner.query(`ALTER TABLE "meta" DROP COLUMN "approvalRequiredForSignup"`);
|
|
await queryRunner.query(`ALTER TABLE "user" DROP COLUMN "approved"`);
|
|
await queryRunner.query(`ALTER TABLE "user" DROP COLUMN "signupReason"`);
|
|
await queryRunner.query(`ALTER TABLE "user_pending" DROP COLUMN "reason"`);
|
|
}
|
|
}
|