1ALTER TABLE `tblclients` ADD `defaultgateway` TEXT NOT NULL AFTER `currency` ;
  2
  3ALTER TABLE `tbltickets`  ADD `contactid` INT(10) NOT NULL AFTER `userid`;
  4ALTER TABLE `tblticketreplies`  ADD `contactid` INT(10) NOT NULL AFTER `userid`;
  5
  6ALTER TABLE `tbldownloads`  ADD `hidden` TEXT NOT NULL AFTER `clientsonly`;
  7
  8ALTER TABLE `tblorders` ADD `orderdata` TEXT NOT NULL AFTER `promovalue` ;
  9
 10INSERT INTO `tbladminperms` (`roleid`, `permid`) VALUES ('2', '71'), ('2', '73'), ('1', '104'), ('2', '104'), ('1', '105'), ('2', '105'), ('3', '105'), ('1', '106'), ('1', '107'), ('1', '108'), ('1', '109'), ('1', '110'), ('2', '110'), ('1', '111'), ('1', '112'), ('1', '113'), ('1', '114'), ('1', '115'), ('1', '116'), ('1', '117'), ('1', '118'), ('1', '119'), ('1', '120'), ('2', '120');
 11
 12UPDATE `tbladmins` SET template='blend' WHERE template='simple';
 13ALTER TABLE `tblclients`  ADD `bankname` TEXT NOT NULL AFTER `issuenumber`,  ADD `banktype` TEXT NOT NULL AFTER `bankname`,  ADD `bankcode` BLOB NOT NULL AFTER `banktype`,  ADD `bankacct` BLOB NOT NULL AFTER `bankcode`;
 14