#!/bin/sh

./run_tool.sh<<EOF
open db salesdemo;
show table;

ALTER INDEX index_item_name RENAME TO index_item_name_new ;
ALTER INDEX index_cust_post_phone_no RENAME TO index_cust_post_phone_no_new ;
ALTER INDEX index_dwpt_name RENAME TO index_dwpt_name_new ;
ALTER INDEX index_ent_date RENAME TO index_ent_date_new ;
ALTER INDEX index_sum RENAME TO index_sum_new ;
close db;
EOF
