10 lines
504 B
MySQL
10 lines
504 B
MySQL
|
ALTER TABLE "user" ADD COLUMN "lastName" text;--> statement-breakpoint
|
||
|
|
ALTER TABLE "user" ADD COLUMN "phone" text;--> statement-breakpoint
|
||
|
|
ALTER TABLE "user" ADD COLUMN "mobile" text;--> statement-breakpoint
|
||
|
|
ALTER TABLE "user" ADD COLUMN "street" text;--> statement-breakpoint
|
||
|
|
ALTER TABLE "user" ADD COLUMN "postalCode" text;--> statement-breakpoint
|
||
|
|
ALTER TABLE "user" ADD COLUMN "city" text;--> statement-breakpoint
|
||
|
|
UPDATE "user"
|
||
|
|
SET "lastName" = "name"
|
||
|
|
WHERE "lastName" IS NULL AND "name" IS NOT NULL;
|