41 lines
1.1 KiB
MySQL
41 lines
1.1 KiB
MySQL
|
/*
|
||
|
|
Warnings:
|
||
|
|
|
||
|
|
- You are about to drop the column `zipCode` on the `Branch` table. All the data in the column will be lost.
|
||
|
|
- You are about to drop the column `zipCode` on the `User` table. All the data in the column will be lost.
|
||
|
|
|
||
|
|
*/
|
||
|
|
-- AlterTable
|
||
|
|
ALTER TABLE "Branch" DROP COLUMN "zipCode",
|
||
|
|
ADD COLUMN "moo" TEXT,
|
||
|
|
ADD COLUMN "mooEN" TEXT,
|
||
|
|
ADD COLUMN "soi" TEXT,
|
||
|
|
ADD COLUMN "soiEN" TEXT,
|
||
|
|
ADD COLUMN "street" TEXT,
|
||
|
|
ADD COLUMN "streetEN" TEXT;
|
||
|
|
|
||
|
|
-- AlterTable
|
||
|
|
ALTER TABLE "CustomerBranch" ADD COLUMN "moo" TEXT,
|
||
|
|
ADD COLUMN "mooEN" TEXT,
|
||
|
|
ADD COLUMN "soi" TEXT,
|
||
|
|
ADD COLUMN "soiEN" TEXT,
|
||
|
|
ADD COLUMN "street" TEXT,
|
||
|
|
ADD COLUMN "streetEN" TEXT;
|
||
|
|
|
||
|
|
-- AlterTable
|
||
|
|
ALTER TABLE "Employee" ADD COLUMN "moo" TEXT,
|
||
|
|
ADD COLUMN "mooEN" TEXT,
|
||
|
|
ADD COLUMN "soi" TEXT,
|
||
|
|
ADD COLUMN "soiEN" TEXT,
|
||
|
|
ADD COLUMN "street" TEXT,
|
||
|
|
ADD COLUMN "streetEN" TEXT;
|
||
|
|
|
||
|
|
-- AlterTable
|
||
|
|
ALTER TABLE "User" DROP COLUMN "zipCode",
|
||
|
|
ADD COLUMN "moo" TEXT,
|
||
|
|
ADD COLUMN "mooEN" TEXT,
|
||
|
|
ADD COLUMN "soi" TEXT,
|
||
|
|
ADD COLUMN "soiEN" TEXT,
|
||
|
|
ADD COLUMN "street" TEXT,
|
||
|
|
ADD COLUMN "streetEN" TEXT;
|