#!/bin/sh
echo "欢迎使用定损系统2.0.0.0预留数据脚本"
echo "-----------------------------------------"
echo ""
echo "请输入本地库数据库名称，例：bj1100pjbj_bd"
read pjbj_bd
echo "-------- 定损工具数据库预留数据开始 --------"
cd sql
echo " "
echo "-------- 表结构建立开始 --------"
dbaccess $pjbj_bd 1>>../log/create.log 2>>../log/create.log create.sql<<!
!
echo " "
echo "-------- 表结构建立完成 --------"
echo " "
echo "-------- 锁模式更改开始 --------"
#dbaccess $pjbj_bd 1>>../log/lock.log 2>>../log/lock.log lock.sql<<!
#!
echo " "
echo "-------- 锁模式更改完成 --------"
cd ..
cd data
echo " "
echo "-------- 其它数据预留开始 --------"
dbaccess $pjbj_bd 1>>../log/load_other.log 2>>../log/load_other.log load_other.sql<<!
!
echo " "
echo "-------- 其它数据预留完成 --------"
echo " "
echo "-------- 零件数据预留开始 --------"
dbaccess $pjbj_bd 1>>../log/load_cllj.log 2>>../log/load_cllj.log load_cllj.sql<<!
!
echo " "
echo "-------- 零件数据预留完成 --------"
echo " "
echo "-------- 零件图形数据预留开始 --------"
dbaccess $pjbj_bd 1>>../log/load_ljtx.log 2>>../log/load_ljtx.log load_ljtx.sql<<!
!
echo " "
echo "-------- 零件图形数据预留完成 --------"
cd ..
cd sql
echo " "
echo "-------- 索引建立开始 --------"
dbaccess $pjbj_bd 1>>../log/alter.log 2>>../log/alter.log alter.sql<<!
!
dbaccess $pjbj_bd 1>>../log/index.log 2>>../log/index.log index.sql<<!
!
echo " "
echo "-------- 索引建立完成 --------"
echo " "
echo "-------- 统计更新开始 --------"
dbaccess $pjbj_bd 1>>../log/statistics.log 2>>../log/statistics.log statistics.sql<<!
!
echo " "
echo "-------- 统计更新完成 --------"
echo " "
echo "-------- 重命名开始 --------"
dbaccess $pjbj_bd 1>>../log/rename.log 2>>../log/rename.log rename.sql<<!
!
echo " "
echo "-------- 重命名完成 --------"
echo " "
echo "恭喜您，本次预留数据已经完成，请检查日志信息"
脚本中不是已经说得很清楚了吗。不过是封装了dbaccess这个命令