8 lines
285 B
JavaScript
8 lines
285 B
JavaScript
exports.up = (pgm) => {
|
|
pgm.sql(`
|
|
ALTER TABLE board_event ADD COLUMN IF NOT EXISTS first_serial int;
|
|
UPDATE board_event SET first_serial = COALESCE(CAST(events#>'{events, 0, serial}' as int), 0);
|
|
ALTER TABLE board_event ALTER COLUMN first_serial SET NOT NULL;
|
|
`)
|
|
}
|