add brokerinfo sql scripts