32 lines
808 B
JavaScript
32 lines
808 B
JavaScript
import pg from 'pg'
|
|
|
|
const pool = new pg.Pool({
|
|
host: '172.25.0.79',
|
|
port: 5433,
|
|
database: 'weeklyreport',
|
|
user: 'weeklyreport',
|
|
password: 'weeklyreport2026'
|
|
})
|
|
|
|
async function migrate() {
|
|
const client = await pool.connect()
|
|
try {
|
|
// 완료여부 컬럼 추가 (WORK 타입에만 사용)
|
|
await client.query(`
|
|
ALTER TABLE wr_weekly_report_task
|
|
ADD COLUMN IF NOT EXISTS is_completed BOOLEAN DEFAULT true
|
|
`)
|
|
console.log('is_completed 컬럼 추가 완료')
|
|
|
|
await client.query(`
|
|
COMMENT ON COLUMN wr_weekly_report_task.is_completed IS '완료여부 (WORK 타입에만 사용, true=완료, false=진행중)'
|
|
`)
|
|
console.log('마이그레이션 완료!')
|
|
} finally {
|
|
client.release()
|
|
await pool.end()
|
|
}
|
|
}
|
|
|
|
migrate().catch(console.error)
|