升級Database version script.
使用方式：
- 修正你的Database 資訊
- 切換至你要升級的script 資料夾，執行這個script
#!/bin/bash
### BEGIN INIT INFO
# Provides: Ninniku Consulting
# Email: ray@ninniku.tw
# Description: 1. change db user password information.
# 2. Switch folder to what you want to import, then excute it
#
### END INIT INFO
ADEMPIERE_DB_USER=adempiere
ADEMPIERE_DB_PASSWORD=adempiere
ADEMPIERE_DB_SERVER=localhost
ADEMPIERE_DB_PORT=5432
ADEMPIERE_DB_NAME=idempiere
PGPASSWORD=$ADEMPIERE_DB_PASSWORD
export PGPASSWORD
echo 'argc=' $#
for filename in ./*.sql; do
echo $filename
psql -h $ADEMPIERE_DB_SERVER -p $ADEMPIERE_DB_PORT -d $ADEMPIERE_DB_NAME -U $ADEMPIERE_DB_USER -f $filename
done
PGPASSWORD=
export PGPASSWORD
English Version
Database version upgrade script.
Usage:
- Modify your database connection information
- Switch to the script folder you want to upgrade, then execute this script
#!/bin/bash
### BEGIN INIT INFO
# Provides: Ninniku Consulting
# Email: ray@ninniku.tw
# Description: 1. change db user password information.
# 2. Switch folder to what you want to import, then excute it
#
### END INIT INFO
ADEMPIERE_DB_USER=adempiere
ADEMPIERE_DB_PASSWORD=adempiere
ADEMPIERE_DB_SERVER=localhost
ADEMPIERE_DB_PORT=5432
ADEMPIERE_DB_NAME=idempiere
PGPASSWORD=$ADEMPIERE_DB_PASSWORD
export PGPASSWORD
echo 'argc=' $#
for filename in ./*.sql; do
echo $filename
psql -h $ADEMPIERE_DB_SERVER -p $ADEMPIERE_DB_PORT -d $ADEMPIERE_DB_NAME -U $ADEMPIERE_DB_USER -f $filename
done
PGPASSWORD=
export PGPASSWORD
日本語版
データベースバージョンアップグレードスクリプト。
使用方法：
- データベースの接続情報を修正する
- アップグレードしたいスクリプトのフォルダに切り替え、このスクリプトを実行する
#!/bin/bash
### BEGIN INIT INFO
# Provides: Ninniku Consulting
# Email: ray@ninniku.tw
# Description: 1. change db user password information.
# 2. Switch folder to what you want to import, then excute it
#
### END INIT INFO
ADEMPIERE_DB_USER=adempiere
ADEMPIERE_DB_PASSWORD=adempiere
ADEMPIERE_DB_SERVER=localhost
ADEMPIERE_DB_PORT=5432
ADEMPIERE_DB_NAME=idempiere
PGPASSWORD=$ADEMPIERE_DB_PASSWORD
export PGPASSWORD
echo 'argc=' $#
for filename in ./*.sql; do
echo $filename
psql -h $ADEMPIERE_DB_SERVER -p $ADEMPIERE_DB_PORT -d $ADEMPIERE_DB_NAME -U $ADEMPIERE_DB_USER -f $filename
done
PGPASSWORD=
export PGPASSWORD
