/*
  Warnings:

  - A unique constraint covering the columns `[no]` on the table `ShopCategory` will be added. If there are existing duplicate values, this will fail.
  - Added the required column `active` to the `ShopCategory` table without a default value. This is not possible if the table is not empty.
  - Added the required column `no` to the `ShopCategory` table without a default value. This is not possible if the table is not empty.

*/
-- AlterTable
ALTER TABLE `shopcategory` ADD COLUMN `active` BOOLEAN NOT NULL,
    ADD COLUMN `no` INTEGER NOT NULL;

-- CreateIndex
CREATE UNIQUE INDEX `ShopCategory_no_key` ON `ShopCategory`(`no`);
