From 14e81ffb5ebe0941d36a3be44e29990a18026a99 Mon Sep 17 00:00:00 2001
From: joonhoekim <26rote@gmail.com>
Date: Mon, 18 Aug 2025 03:09:13 +0000
Subject: (김준회) users phone 컬럼 size 20으로 롤백, TELNO가 아닌 HP_NO를
 users에 upsert하도록 변경, package.json에 next 참조 명시 추가
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 db/schema/users.ts           | 2 +-
 lib/shi-api/shi-api-utils.ts | 2 +-
 package.json                 | 8 ++++----
 3 files changed, 6 insertions(+), 6 deletions(-)

diff --git a/db/schema/users.ts b/db/schema/users.ts
index bfea20a1..0e8809b7 100644
--- a/db/schema/users.ts
+++ b/db/schema/users.ts
@@ -33,7 +33,7 @@ export const users = pgTable("users", {
   language: varchar("language", { length: 10 }).default("en"),
 
   // MFA 관련 새 컬럼들
-  phone: varchar("phone", { length: 255 }), // 국제 형식 전화번호 (+82-10-1234-5678), 해외번호 20자 초과건으로 사이즈 변경
+  phone: varchar("phone", { length: 20 }), // 국제 형식 전화번호 (+82-10-1234-5678), 해외번호 20자 초과건으로 사이즈 변경
   mfaEnabled: boolean("mfa_enabled").default(false).notNull(),
   mfaSecret: varchar("mfa_secret", { length: 32 }), // TOTP secret (나중에 사용)
 
diff --git a/lib/shi-api/shi-api-utils.ts b/lib/shi-api/shi-api-utils.ts
index 3906883a..b8eeff29 100644
--- a/lib/shi-api/shi-api-utils.ts
+++ b/lib/shi-api/shi-api-utils.ts
@@ -67,7 +67,7 @@ export const getAllNonsapUser = async () => {
           epId: u.MYSNG_ID || undefined,
           deptCode: u.DEPTCD || undefined,
           deptName: u.DEPTNM || undefined,
-          phone: u.TELNO || undefined,
+          phone: u.HP_NO || undefined,
           isAbsent,
           isDeletedOnNonSap: isDeleted,
           isActive,
diff --git a/package.json b/package.json
index aa51b6ea..7bde68bb 100644
--- a/package.json
+++ b/package.json
@@ -3,10 +3,10 @@
   "version": "0.1.0",
   "private": true,
   "scripts": {
-    "dev": "export NODE_OPTIONS=--openssl-legacy-provider && next dev --turbopack",
-    "build": "export NODE_OPTIONS=--openssl-legacy-provider && next build",
-    "start": "export NODE_OPTIONS=--openssl-legacy-provider && next start",
-    "lint": "next lint",
+    "dev": "export NODE_OPTIONS=--openssl-legacy-provider && ./node_modules/next/dist/bin/next dev --turbopack",
+    "build": "export NODE_OPTIONS=--openssl-legacy-provider && ./node_modules/next/dist/bin/next build",
+    "start": "export NODE_OPTIONS=--openssl-legacy-provider && ./node_modules/next/dist/bin/next start",
+    "lint": "./node_modules/next/dist/bin/next lint",
     "db:seed_2": "tsx db/seeds_2/seed.ts"
   },
   "dependencies": {
-- 
cgit v1.2.3