29 lines
642 B
JavaScript
29 lines
642 B
JavaScript
|
/**
|
||
|
|
* @type {import('node-pg-migrate').ColumnDefinitions | undefined}
|
||
|
|
*/
|
||
|
|
export const shorthands = undefined;
|
||
|
|
|
||
|
|
/**
|
||
|
|
* @param pgm {import('node-pg-migrate').MigrationBuilder}
|
||
|
|
* @param run {() => void | undefined}
|
||
|
|
* @returns {Promise<void> | void}
|
||
|
|
*/
|
||
|
|
export const up = (pgm) => {
|
||
|
|
pgm.sql(`
|
||
|
|
ALTER TABLE user_cards
|
||
|
|
ADD COLUMN IF NOT EXISTS scan_image_url TEXT
|
||
|
|
`);
|
||
|
|
};
|
||
|
|
|
||
|
|
/**
|
||
|
|
* @param pgm {import('node-pg-migrate').MigrationBuilder}
|
||
|
|
* @param run {() => void | undefined}
|
||
|
|
* @returns {Promise<void> | void}
|
||
|
|
*/
|
||
|
|
export const down = (pgm) => {
|
||
|
|
pgm.sql(`
|
||
|
|
ALTER TABLE user_cards
|
||
|
|
DROP COLUMN IF EXISTS scan_image_url
|
||
|
|
`);
|
||
|
|
};
|