text: ALTER TABLE `tblpromotions` ADD `existingclient` INT NOT NULL , ADD `onceperclient` INT NOT NULL ;
  
  ALTER TABLE `tblcredit` ADD `relid` INT( 10 ) NOT NULL DEFAULT '0' ;
  
  ALTER TABLE `tblclients` ADD `currency` INT( 10 ) NOT NULL AFTER `password` ;
  UPDATE tblclients SET currency=1;
  
  CREATE TABLE IF NOT EXISTS `tblcurrencies` (
  `id` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
  `code` TEXT COLLATE utf8_unicode_ci NOT NULL ,
  `prefix` TEXT COLLATE utf8_unicode_ci NOT NULL ,
  `suffix` TEXT COLLATE utf8_unicode_ci NOT NULL ,
  `format` INT( 1 ) NOT NULL ,
  `rate` DECIMAL( 10, 5 ) NOT NULL DEFAULT '1',
  `default` INT( 1 ) NOT NULL
  ) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  INSERT INTO `tblcurrencies` (`id`, `code`, `prefix`, `suffix`, `format`, `rate`, `default`) VALUES
  (1, 'USD', '$', ' USD', 1, 1.00000, 1);
  
  CREATE TABLE IF NOT EXISTS `tblpricing` (
  `id` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
  `type` ENUM( "product", "addon", "configoptions", "domainregister", "domaintransfer", "domainrenew", "domainaddons" ) NOT NULL ,
  `currency` INT( 10 ) NOT NULL ,
  `relid` INT( 10 ) NOT NULL ,
  `msetupfee` DECIMAL( 10, 2 ) NOT NULL ,
  `qsetupfee` DECIMAL( 10, 2 ) NOT NULL ,
  `ssetupfee` DECIMAL( 10, 2 ) NOT NULL ,
  `asetupfee` DECIMAL( 10, 2 ) NOT NULL ,
  `bsetupfee` DECIMAL( 10, 2 ) NOT NULL ,
  `monthly` DECIMAL( 10, 2 ) NOT NULL ,
  `quarterly` DECIMAL( 10, 2 ) NOT NULL ,
  `semiannually` DECIMAL( 10, 2 ) NOT NULL ,
  `annually` DECIMAL( 10, 2 ) NOT NULL ,
  `biennially` DECIMAL( 10, 2 ) NOT NULL
  ) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('CurrencyAutoUpdateExchangeRates', 'on');
  INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('CurrencyAutoUpdateProductPrices', '');
  
  ALTER TABLE `tblaccounts` ADD `currency` INT( 10 ) NOT NULL AFTER `userid` ;
  
  ALTER TABLE `tblquotes` ADD `currency` INT( 10 ) NOT NULL AFTER `phonenumber` ;
  
  ALTER TABLE `tblpaymentgateways`  DROP `id`,  DROP `type`,  DROP `name`,  DROP `size`,  DROP `notes`,  DROP `description`;
  
  CREATE TABLE IF NOT EXISTS `tbladminsecurityquestions` (
    `id` int(10) unsigned NOT NULL auto_increment,
    `question` text NOT NULL,
    PRIMARY KEY  (`id`)
  ) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  ALTER TABLE `tblclients` ADD `securityqid` INT( 10 ) NOT NULL AFTER `billingcid` , ADD `securityqans` TEXT NOT NULL AFTER `securityqid` ;
  
  ALTER TABLE `tblemails` ADD `to` TEXT NULL, ADD `cc` TEXT NULL, ADD `bcc` TEXT NULL;
  
  ALTER TABLE `tbladmins` ADD `template` TEXT NOT NULL AFTER `notes` ;
  UPDATE tbladmins SET template='blend';
  
  ALTER TABLE `tblaccounts` ADD `refundid` INT( 10 ) NOT NULL DEFAULT '0' ;
  
  INSERT INTO `tblconfiguration` (`setting` ,`value`) VALUES ('RequiredPWStrength', '50');
  
  INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('MaintenanceMode', '');
  INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('MaintenanceModeMessage', 'We are currently performing maintenance and will be back shortly.');
  
  ALTER TABLE `tblaccounts` ADD `rate` DECIMAL( 10, 5 ) NOT NULL DEFAULT '1' AFTER `amountout` ;
  
  UPDATE tblaccounts SET rate='1';
  UPDATE tblaccounts SET currency='1' WHERE userid='0';
  
  ALTER TABLE `tblcustomfields` ADD `regexpr` TEXT NOT NULL AFTER `fieldoptions` ;
  
  CREATE TABLE IF NOT EXISTS `tblknowledgebaselinks` (
  `categoryid` INT( 10 ) NOT NULL ,
  `articleid` INT( 10 ) NOT NULL
  ) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  CREATE TABLE IF NOT EXISTS `tblbillableitems` (
    `id` int(10) NOT NULL auto_increment,
    `userid` int(10) NOT NULL,
    `description` text NOT NULL,
    `amount` decimal(10,2) NOT NULL,
    `recur` int(5) NOT NULL default '0',
    `recurcycle` text NOT NULL,
    `recurfor` int(5) NOT NULL default '0',
    `invoiceaction` int(1) NOT NULL,
    `duedate` date NOT NULL,
    `invoicecount` int(5) NOT NULL default '0',
    PRIMARY KEY  (`id`)
  ) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('SkipFraudForExisting', '');
  INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('SMTPSSL', '');
  INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('ContactFormDept', '');
  INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('ContactFormTo', '');
  
  CREATE TABLE IF NOT EXISTS  `tblclientgroups` (
    `id` int(10) unsigned NOT NULL auto_increment,
    `groupname` varchar(45) NOT NULL,
    `groupcolour` varchar(45) default NULL,
    `discountpercent` decimal(10,2) unsigned default '0.00',
    `susptermexempt` text COLLATE utf8_unicode_ci,
    PRIMARY KEY  (`id`)
  ) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  ALTER TABLE `tblclients` ADD `groupid` INT( 10 ) NOT NULL AFTER `securityqans` ;
  
  CREATE TABLE IF NOT EXISTS `tblticketescalations` (
  `id` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
  `name` TEXT COLLATE utf8_unicode_ci NOT NULL ,
  `departments` TEXT COLLATE utf8_unicode_ci NOT NULL ,
  `statuses` TEXT COLLATE utf8_unicode_ci NOT NULL ,
  `priorities` TEXT COLLATE utf8_unicode_ci NOT NULL ,
  `timeelapsed` INT( 5 ) NOT NULL ,
  `newdepartment` TEXT COLLATE utf8_unicode_ci NOT NULL ,
  `newpriority` TEXT COLLATE utf8_unicode_ci NOT NULL ,
  `newstatus` TEXT COLLATE utf8_unicode_ci NOT NULL ,
  `flagto` TEXT COLLATE utf8_unicode_ci NOT NULL ,
  `notify` TEXT COLLATE utf8_unicode_ci NOT NULL ,
  `addreply` TEXT COLLATE utf8_unicode_ci NOT NULL
  ) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  ALTER TABLE `tblhosting` ADD `overidesuspenduntil` DATE NOT NULL AFTER `overideautosuspend` ;
  
  INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('TicketEscalationLastRun', '2009-01-01 00:00:00');
  
  INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('APIAllowedIPs', '');
  
  ALTER TABLE `tblclients` ADD `gatewayid` TEXT NOT NULL AFTER `issuenumber` ;
  
  INSERT INTO `tbladminperms` (`roleid` ,`permid` )VALUES ('1', '86'),('1', '87'),('1', '88'),('1', '89'),('1', '90'),('1', '91'),('1', '92'),('1', '93'),('1', '94');
  