Muhammad Zhafran Ilham
24 lines
976 B
SQL
24 lines
976 B
SQL
/*
|
|
Warnings:
|
|
|
|
- A unique constraint covering the columns `[slug]` on the table `project` will be added. If there are existing duplicate values, this will fail.
|
|
- A unique constraint covering the columns `[id_project,slug]` on the table `task` will be added. If there are existing duplicate values, this will fail.
|
|
- Added the required column `slug` to the `project` table without a default value. This is not possible if the table is not empty.
|
|
- Added the required column `slug` to the `task` table without a default value. This is not possible if the table is not empty.
|
|
|
|
*/
|
|
-- AlterTable
|
|
ALTER TABLE `project` ADD COLUMN `slug` VARCHAR(255) NOT NULL;
|
|
|
|
-- AlterTable
|
|
ALTER TABLE `task` ADD COLUMN `slug` VARCHAR(255) NOT NULL;
|
|
|
|
-- CreateIndex
|
|
CREATE UNIQUE INDEX `project_slug_key` ON `project`(`slug`);
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX `task_slug_idx` ON `task`(`slug`);
|
|
|
|
-- CreateIndex
|
|
CREATE UNIQUE INDEX `task_id_project_slug_key` ON `task`(`id_project`, `slug`);
|