23 lines
1008 B
SQL
23 lines
1008 B
SQL
/*
|
|
Warnings:
|
|
|
|
- A unique constraint covering the columns `[name]` on the table `PortfolioCategory` will be added. If there are existing duplicate values, this will fail.
|
|
- A unique constraint covering the columns `[name]` on the table `PortfolioTag` will be added. If there are existing duplicate values, this will fail.
|
|
- Made the column `name` on table `PortfolioCategory` required. This step will fail if there are existing NULL values in that column.
|
|
- Made the column `name` on table `PortfolioTag` required. This step will fail if there are existing NULL values in that column.
|
|
|
|
*/
|
|
-- AlterTable
|
|
ALTER TABLE "PortfolioCategory" ADD COLUMN "description" TEXT,
|
|
ALTER COLUMN "name" SET NOT NULL;
|
|
|
|
-- AlterTable
|
|
ALTER TABLE "PortfolioTag" ADD COLUMN "description" TEXT,
|
|
ALTER COLUMN "name" SET NOT NULL;
|
|
|
|
-- CreateIndex
|
|
CREATE UNIQUE INDEX "PortfolioCategory_name_key" ON "PortfolioCategory"("name");
|
|
|
|
-- CreateIndex
|
|
CREATE UNIQUE INDEX "PortfolioTag_name_key" ON "PortfolioTag"("name");
|