21 lines
864 B
SQL
21 lines
864 B
SQL
/*
|
|
Warnings:
|
|
|
|
- You are about to drop the column `code` on the `QuotationWorker` table. All the data in the column will be lost.
|
|
- Added the required column `code` to the `Institution` table without a default value. This is not possible if the table is not empty.
|
|
- Added the required column `group` to the `Institution` table without a default value. This is not possible if the table is not empty.
|
|
- Added the required column `code` to the `Invoice` table without a default value. This is not possible if the table is not empty.
|
|
|
|
*/
|
|
-- AlterTable
|
|
ALTER TABLE "Institution" ADD COLUMN "code" TEXT NOT NULL,
|
|
ADD COLUMN "group" TEXT NOT NULL;
|
|
|
|
-- AlterTable
|
|
ALTER TABLE "Invoice" ADD COLUMN "code" TEXT NOT NULL;
|
|
|
|
-- AlterTable
|
|
ALTER TABLE "Payment" ADD COLUMN "code" TEXT;
|
|
|
|
-- AlterTable
|
|
ALTER TABLE "QuotationWorker" DROP COLUMN "code";
|