16 lines
758 B
SQL
16 lines
758 B
SQL
/*
|
|
Warnings:
|
|
|
|
- The primary key for the `Provisionen` table will be changed. If it partially fails, the table could be left without primary key constraint.
|
|
- The `id` column on the `Provisionen` table would be dropped and recreated. This will lead to data loss if there is data in the column.
|
|
- Changed the type of `ausweisart` on the `Provisionen` table. No cast exists, the column would be dropped and recreated, which cannot be done if there is data, since the column is required.
|
|
|
|
*/
|
|
-- AlterTable
|
|
ALTER TABLE "Provisionen" DROP CONSTRAINT "Provisionen_pkey",
|
|
DROP COLUMN "id",
|
|
ADD COLUMN "id" SERIAL NOT NULL,
|
|
DROP COLUMN "ausweisart",
|
|
ADD COLUMN "ausweisart" "Ausweisart" NOT NULL,
|
|
ADD CONSTRAINT "Provisionen_pkey" PRIMARY KEY ("id");
|