12 lines
349 B
MySQL
12 lines
349 B
MySQL
|
-- Add missing updatedAt column to AssignmentJob table
|
||
|
|
|
||
|
|
DO $$
|
||
|
|
BEGIN
|
||
|
|
IF NOT EXISTS (
|
||
|
|
SELECT 1 FROM information_schema.columns
|
||
|
|
WHERE table_name = 'AssignmentJob' AND column_name = 'updatedAt'
|
||
|
|
) THEN
|
||
|
|
ALTER TABLE "AssignmentJob" ADD COLUMN "updatedAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP;
|
||
|
|
END IF;
|
||
|
|
END $$;
|