19 lines
873 B
SQL
19 lines
873 B
SQL
-- AlterTable
|
|
ALTER TABLE "Asistencia" ALTER COLUMN "created_at" SET DEFAULT (now() AT TIME ZONE 'utc'),
|
|
ALTER COLUMN "updated_at" SET DEFAULT (now() AT TIME ZONE 'utc'),
|
|
ALTER COLUMN "entrada" SET DEFAULT (now() AT TIME ZONE 'utc');
|
|
|
|
-- AlterTable
|
|
ALTER TABLE "Cliente" ALTER COLUMN "created_at" SET DEFAULT (now() AT TIME ZONE 'utc'),
|
|
ALTER COLUMN "updated_at" SET DEFAULT (now() AT TIME ZONE 'utc');
|
|
|
|
-- AlterTable
|
|
ALTER TABLE "Planilla" ALTER COLUMN "created_at" SET DEFAULT (now() AT TIME ZONE 'utc'),
|
|
ALTER COLUMN "updated_at" SET DEFAULT (now() AT TIME ZONE 'utc');
|
|
|
|
-- AlterTable
|
|
ALTER TABLE "TareaRealizada" ALTER COLUMN "created_at" SET DEFAULT (now() AT TIME ZONE 'utc');
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "TareaRealizada" ADD CONSTRAINT "TareaRealizada_planilla_id_fkey" FOREIGN KEY ("planilla_id") REFERENCES "Planilla"("id") ON DELETE SET NULL ON UPDATE CASCADE;
|