CREATE TABLE `acctypeindx` (
  `acctypeid` int(10) NOT NULL AUTO_INCREMENT,
  `acctypename` varchar(75) DEFAULT NULL,
  `acctypename_en` varchar(50) DEFAULT NULL,
  `status` int(1) DEFAULT '1',
  `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`acctypeid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

insert into acctypeindx (
   acctypeid,acctypename,acctypename_en) values (1,'Banks','Banks');
   
   
ALTER TABLE bbo.userights ADD xdatabase VARCHAR(45);
update bbo.userights set xdatabase='ibnbuttota19';

ALTER TABLE extspcomm
 ADD tktype INT DEFAULT '0',
 ADD tktStatus VARCHAR(3);