#!/bin/bash
mysql -u root --password=safescrypt -D era -e "Create Index ReqIdIndex On IntimationMail ( TransactionId )";

mysql -u root --password=safescrypt -D era -e "Create Index ReqIdIndex on RequestEML ( RequestId )" ;
mysql -u root --password=safescrypt -D era -e "Create Index ReqIdIndex on RequestEML ( EMLType )" ;

mysql -u root --password=safescrypt -D era -e "Create Index PClassIndex on Uniqueness ( PolicyClassId )" ;
mysql -u root --password=safescrypt -D era -e "Create Index ReqIdIndex on Uniqueness ( RequestId )" ;

mysql -u root --password=safescrypt -D era -e "Create Index ReqIdIndex on RequestDocStatus ( RequestId )" ;
mysql -u root --password=safescrypt -D era -e "Create Index ReqIdIndex on RequestDocStatus ( UpdateTime )" ;

mysql -u root --password=safescrypt -D era -e "Create Index AdIdIndex on AdminActivity ( AdminId )" ;
mysql -u root --password=safescrypt -D era -e "Create Index ActTimeIndex on AdminActivity ( ActionTime )" ;
mysql -u root --password=safescrypt -D era -e "Create Index ActTypeIndex on AdminActivity ( ActivityType )" ;
mysql -u root --password=safescrypt -D era -e "Create Index ActionTypeIndex on AdminActivity ( ActionType )" ;
mysql -u root --password=safescrypt -D era -e "Create Index StatIndex on AdminActivity ( Status )" ;

mysql -u root --password=safescrypt -D era -e "Create Index AdIdIndex on QuotaDetails ( AdminId )" ;
mysql -u root --password=safescrypt -D era -e "Create Index ActTimeIndex on QuotaDetails ( ActionTime )" ;
mysql -u root --password=safescrypt -D era -e "Create Index MakFlagIndex on QuotaDetails ( MakerFlag )" ;

mysql -u root --password=safescrypt -D era -e "Create Index AgentRegNoIndex on AgentToRegNo ( RegistrationNo )" ;
mysql -u root --password=safescrypt -D era -e "Create Index AgentStatIndex on AgentToRegNo ( Status )" ;
mysql -u root --password=safescrypt -D era -e "Create Index AgentPIdIndex on AgentToRegNo ( PolicyClassId )" ;
mysql -u root --password=safescrypt -D era -e "Create Index AgentVeraIndex on AgentToRegNo ( VeraId )" ;
mysql -u root --password=safescrypt -D era -e "Create Index AgentIdIndex on AgentToRegNo ( AgentId )" ;