1ALTER TABLE `tblpromotions` ADD `existingclient` INT NOT NULL , ADD `onceperclient` INT NOT NULL ;
  2
  3ALTER TABLE `tblcredit` ADD `relid` INT( 10 ) NOT NULL DEFAULT '0' ;
  4
  5ALTER TABLE `tblclients` ADD `currency` INT( 10 ) NOT NULL AFTER `password` ;
  6UPDATE tblclients SET currency=1;
  7
  8CREATE TABLE IF NOT EXISTS `tblcurrencies` (
  9`id` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
 10`code` TEXT COLLATE utf8_unicode_ci NOT NULL ,
 11`prefix` TEXT COLLATE utf8_unicode_ci NOT NULL ,
 12`suffix` TEXT COLLATE utf8_unicode_ci NOT NULL ,
 13`format` INT( 1 ) NOT NULL ,
 14`rate` DECIMAL( 10, 5 ) NOT NULL DEFAULT '1',
 15`default` INT( 1 ) NOT NULL
 16) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 17INSERT INTO `tblcurrencies` (`id`, `code`, `prefix`, `suffix`, `format`, `rate`, `default`) VALUES
 18(1, 'USD', '$', ' USD', 1, 1.00000, 1);
 19
 20CREATE TABLE IF NOT EXISTS `tblpricing` (
 21`id` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
 22`type` ENUM( "product", "addon", "configoptions", "domainregister", "domaintransfer", "domainrenew", "domainaddons" ) NOT NULL ,
 23`currency` INT( 10 ) NOT NULL ,
 24`relid` INT( 10 ) NOT NULL ,
 25`msetupfee` DECIMAL( 10, 2 ) NOT NULL ,
 26`qsetupfee` DECIMAL( 10, 2 ) NOT NULL ,
 27`ssetupfee` DECIMAL( 10, 2 ) NOT NULL ,
 28`asetupfee` DECIMAL( 10, 2 ) NOT NULL ,
 29`bsetupfee` DECIMAL( 10, 2 ) NOT NULL ,
 30`monthly` DECIMAL( 10, 2 ) NOT NULL ,
 31`quarterly` DECIMAL( 10, 2 ) NOT NULL ,
 32`semiannually` DECIMAL( 10, 2 ) NOT NULL ,
 33`annually` DECIMAL( 10, 2 ) NOT NULL ,
 34`biennially` DECIMAL( 10, 2 ) NOT NULL
 35) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 36
 37INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('CurrencyAutoUpdateExchangeRates', 'on');
 38INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('CurrencyAutoUpdateProductPrices', '');
 39
 40ALTER TABLE `tblaccounts` ADD `currency` INT( 10 ) NOT NULL AFTER `userid` ;
 41
 42ALTER TABLE `tblquotes` ADD `currency` INT( 10 ) NOT NULL AFTER `phonenumber` ;
 43
 44ALTER TABLE `tblpaymentgateways`  DROP `id`,  DROP `type`,  DROP `name`,  DROP `size`,  DROP `notes`,  DROP `description`;
 45
 46CREATE TABLE IF NOT EXISTS `tbladminsecurityquestions` (
 47  `id` int(10) unsigned NOT NULL auto_increment,
 48  `question` text NOT NULL,
 49  PRIMARY KEY  (`id`)
 50) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 51
 52ALTER TABLE `tblclients` ADD `securityqid` INT( 10 ) NOT NULL AFTER `billingcid` , ADD `securityqans` TEXT NOT NULL AFTER `securityqid` ;
 53
 54ALTER TABLE `tblemails` ADD `to` TEXT NULL, ADD `cc` TEXT NULL, ADD `bcc` TEXT NULL;
 55
 56ALTER TABLE `tbladmins` ADD `template` TEXT NOT NULL AFTER `notes` ;
 57UPDATE tbladmins SET template='blend';
 58
 59ALTER TABLE `tblaccounts` ADD `refundid` INT( 10 ) NOT NULL DEFAULT '0' ;
 60
 61INSERT INTO `tblconfiguration` (`setting` ,`value`) VALUES ('RequiredPWStrength', '50');
 62
 63INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('MaintenanceMode', '');
 64INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('MaintenanceModeMessage', 'We are currently performing maintenance and will be back shortly.');
 65
 66ALTER TABLE `tblaccounts` ADD `rate` DECIMAL( 10, 5 ) NOT NULL DEFAULT '1' AFTER `amountout` ;
 67
 68UPDATE tblaccounts SET rate='1';
 69UPDATE tblaccounts SET currency='1' WHERE userid='0';
 70
 71ALTER TABLE `tblcustomfields` ADD `regexpr` TEXT NOT NULL AFTER `fieldoptions` ;
 72
 73CREATE TABLE IF NOT EXISTS `tblknowledgebaselinks` (
 74`categoryid` INT( 10 ) NOT NULL ,
 75`articleid` INT( 10 ) NOT NULL
 76) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 77
 78CREATE TABLE IF NOT EXISTS `tblbillableitems` (
 79  `id` int(10) NOT NULL auto_increment,
 80  `userid` int(10) NOT NULL,
 81  `description` text NOT NULL,
 82  `amount` decimal(10,2) NOT NULL,
 83  `recur` int(5) NOT NULL default '0',
 84  `recurcycle` text NOT NULL,
 85  `recurfor` int(5) NOT NULL default '0',
 86  `invoiceaction` int(1) NOT NULL,
 87  `duedate` date NOT NULL,
 88  `invoicecount` int(5) NOT NULL default '0',
 89  PRIMARY KEY  (`id`)
 90) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 91
 92INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('SkipFraudForExisting', '');
 93INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('SMTPSSL', '');
 94INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('ContactFormDept', '');
 95INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('ContactFormTo', '');
 96
 97CREATE TABLE IF NOT EXISTS  `tblclientgroups` (
 98  `id` int(10) unsigned NOT NULL auto_increment,
 99  `groupname` varchar(45) NOT NULL,
100  `groupcolour` varchar(45) default NULL,
101  `discountpercent` decimal(10,2) unsigned default '0.00',
102  `susptermexempt` text COLLATE utf8_unicode_ci,
103  PRIMARY KEY  (`id`)
104) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
105
106ALTER TABLE `tblclients` ADD `groupid` INT( 10 ) NOT NULL AFTER `securityqans` ;
107
108CREATE TABLE IF NOT EXISTS `tblticketescalations` (
109`id` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
110`name` TEXT COLLATE utf8_unicode_ci NOT NULL ,
111`departments` TEXT COLLATE utf8_unicode_ci NOT NULL ,
112`statuses` TEXT COLLATE utf8_unicode_ci NOT NULL ,
113`priorities` TEXT COLLATE utf8_unicode_ci NOT NULL ,
114`timeelapsed` INT( 5 ) NOT NULL ,
115`newdepartment` TEXT COLLATE utf8_unicode_ci NOT NULL ,
116`newpriority` TEXT COLLATE utf8_unicode_ci NOT NULL ,
117`newstatus` TEXT COLLATE utf8_unicode_ci NOT NULL ,
118`flagto` TEXT COLLATE utf8_unicode_ci NOT NULL ,
119`notify` TEXT COLLATE utf8_unicode_ci NOT NULL ,
120`addreply` TEXT COLLATE utf8_unicode_ci NOT NULL
121) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
122
123ALTER TABLE `tblhosting` ADD `overidesuspenduntil` DATE NOT NULL AFTER `overideautosuspend` ;
124
125INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('TicketEscalationLastRun', '2009-01-01 00:00:00');
126
127INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('APIAllowedIPs', '');
128
129ALTER TABLE `tblclients` ADD `gatewayid` TEXT NOT NULL AFTER `issuenumber` ;
130
131INSERT INTO `tbladminperms` (`roleid` ,`permid` )VALUES ('1', '86'),('1', '87'),('1', '88'),('1', '89'),('1', '90'),('1', '91'),('1', '92'),('1', '93'),('1', '94');
132