init_db_now.bat

@echo off
chcp 65001 >nul
echo [WMS] 开始初始化数据库...

set PGPASSWORD=123456

echo.
echo [步骤1] 删除旧数据库...
"D:\Program Files\PostgreSQL\17\bin\psql.exe" -U postgres -c "DROP DATABASE IF EXISTS wms_db;" 2>nul

echo [步骤2] 创建新数据库...
"D:\Program Files\PostgreSQL\17\bin\psql.exe" -U postgres -c "CREATE DATABASE wms_db ENCODING = 'UTF8';"

echo [步骤3] 导入表结构和数据...
"D:\Program Files\PostgreSQL\17\bin\psql.exe" -U postgres -d wms_db -f "D:\WMS\database\quick_init.sql"

echo.
echo [步骤4] 验证数据...
"D:\Program Files\PostgreSQL\17\bin\psql.exe" -U postgres -d wms_db -c "SELECT 'Tables: ' || COUNT(*) FROM information_schema.tables WHERE table_schema IN ('wms', 'sys');"
"D:\Program Files\PostgreSQL\17\bin\psql.exe" -U postgres -d wms_db -c "SELECT 'Users: ' || COUNT(*) FROM sys.sys_user;"

echo.
echo [完成] 数据库初始化完成!
echo.