-- DropForeignKey
ALTER TABLE `adminlog` DROP FOREIGN KEY `AdminLog_actorUserId_fkey`;

-- DropForeignKey
ALTER TABLE `commissionauditlog` DROP FOREIGN KEY `CommissionAuditLog_adminUserId_fkey`;

-- DropIndex
DROP INDEX `AdminLog_actorUserId_createdAt_idx` ON `adminlog`;

-- DropIndex
DROP INDEX `AdminLog_affectedUserId_createdAt_idx` ON `adminlog`;

-- AlterTable
ALTER TABLE `adminlog` ADD COLUMN `actorAdminId` VARCHAR(191) NULL,
    ADD COLUMN `actorSuperAdminId` VARCHAR(191) NULL;

-- AlterTable
ALTER TABLE `auditlog` ADD COLUMN `adminId` VARCHAR(191) NULL,
    ADD COLUMN `superAdminId` VARCHAR(191) NULL;

-- AlterTable
ALTER TABLE `commissionauditlog` ADD COLUMN `adminId` VARCHAR(191) NULL,
    ADD COLUMN `superAdminId` VARCHAR(191) NULL;

-- CreateIndex
CREATE INDEX `Admin_adminId_idx` ON `Admin`(`adminId`);

-- CreateIndex
CREATE INDEX `Admin_username_idx` ON `Admin`(`username`);

-- CreateIndex
CREATE INDEX `AdminLog_actorAdminId_idx` ON `AdminLog`(`actorAdminId`);

-- CreateIndex
CREATE INDEX `AdminLog_actorSuperAdminId_idx` ON `AdminLog`(`actorSuperAdminId`);

-- CreateIndex
CREATE INDEX `CommissionAuditLog_adminId_idx` ON `CommissionAuditLog`(`adminId`);

-- CreateIndex
CREATE INDEX `CommissionAuditLog_superAdminId_idx` ON `CommissionAuditLog`(`superAdminId`);

-- CreateIndex
CREATE INDEX `SuperAdmin_superAdminId_idx` ON `SuperAdmin`(`superAdminId`);

-- CreateIndex
CREATE INDEX `SuperAdmin_username_idx` ON `SuperAdmin`(`username`);