/*
  Warnings:

  - You are about to drop the column `memberId` on the `guild` table. All the data in the column will be lost.
  - A unique constraint covering the columns `[ownerId]` on the table `Guild` will be added. If there are existing duplicate values, this will fail.
  - Added the required column `ownerId` to the `Guild` table without a default value. This is not possible if the table is not empty.

*/
-- DropIndex
DROP INDEX `Guild_memberId_key` ON `guild`;

-- AlterTable
ALTER TABLE `guild` DROP COLUMN `memberId`,
    ADD COLUMN `ownerId` INTEGER NOT NULL;

-- CreateIndex
CREATE UNIQUE INDEX `Guild_ownerId_key` ON `Guild`(`ownerId`);