UPDATE setting set value='2.2.1' where name='ClientExec Version';
INSERT INTO `module_group` ( `moduleid` , `groupid` , `viewable` , `viewall` ) VALUES ( '2', '5', '1', '0');
INSERT INTO `module_group` ( `moduleid` , `groupid` , `viewable` , `viewall` ) VALUES ( '3', '5', '1', '0');
INSERT INTO `module_group` ( `moduleid` , `groupid` , `viewable` , `viewall` ) VALUES ( '4', '5', '0', '0');
INSERT INTO `module_group` ( `moduleid` , `groupid` , `viewable` , `viewall` ) VALUES ( '5', '5', '1', '1');
INSERT INTO `module_group` ( `moduleid` , `groupid` , `viewable` , `viewall` ) VALUES ( '6', '5', '1', '0');
INSERT INTO `module_group` ( `moduleid` , `groupid` , `viewable` , `viewall` ) VALUES ( '7', '5', '1', '1');
ALTER TABLE `troubleticket_log` ADD `logaction` TINYINT DEFAULT '0' NOT NULL ;
INSERT INTO `setting` VALUES ('', 'Support Ticket Assigned Template', 'ATTN: [COMPANYNAME] Support Staff,\r\n\r\nTrouble Ticket #[TICKETNUMBER], submitted by [CLIENTNAME] has just been assigned to you.  Please take a look at your earliest convenience.\r\n\r\nDescription:\r\n[DESCRIPTION]\r\n\r\nMember Center:\r\n[CLIENTAPPLICATIONURL]\r\n\r\nThank you,\r\n[COMPANYNAME]', 'Template for the email sent to support staff after a ticket is assigned.', 7, 1, 0, 1, 0, 0, 6, 0, 0, 0);
INSERT INTO `setting` VALUES ('', 'Enable MaxMind Fraud Control', '0', 'Setting allowing MaxMind customers to check orders for fraud.', 12, 1, 1, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES ('', 'MaxMind License Key', '', 'Enter your MaxMind License Key here.<br>You can obtain a license at <br><a href=http://www.maxmind.com/app/ccv_buynow?rId=clientexec target=_blank>http://www.maxmind.com/app/ccv_buynow</a>', 12, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES ('', 'Reject Free Email Service', '0', 'Setting allowing you to reject any order using free email services like hotmail and yahoo (free e-mail = higher risk).<br><b>Note: </b>Requires MaxMind', 12, 1, 1, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES ('', 'Reject Country Mismatch', '1', 'Setting allowing you to reject any order where country of IP address does not match the billing address country (mismatch = higher risk).<br><b>Note: </b>Requires MaxMind', 12, 1, 1, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES ('', 'Reject Anonymous Proxy', '1', 'Setting allowing you to reject any order where the IP address is an Anonymous Proxy (anonymous proxy = very high risk).<br><b>Note: </b>Requires MaxMind', 12, 1, 1, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES ('', 'Reject High Risk Country', '0', 'Setting allowing you to reject any order where the country the IP is based from is considered a country where fraudulent order is likely.<br><b>Note: </b>Requires MaxMind', 12, 1, 1, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES ('', 'MaxMind Fraud Risk Score', 'none', 'MaxMind risk score is based on known risk factors and their likelihood to indicate possible fraud. Select the threshold you want CE to reject on. ( 0=low risk 10=high risk)<br><b>Note:</b> Requires MaxMind<br>To see how the fraud score is obtained visit <br><a href=http://www.maxmind.com/app/web_services_score2?rId=clientexec target=_blank>http://www.maxmind.com/app/web_services_score2</a>', 12, 0, 0, 0, 0, 0, 0, 0, 0, 0);
CREATE TABLE `tld` (
`id` INT NOT NULL AUTO_INCREMENT ,
`name` VARCHAR( 15 ) NOT NULL ,
`period` INT DEFAULT '1' NOT NULL ,
`price` FLOAT DEFAULT '9.95' NOT NULL ,
`transferprice` FLOAT DEFAULT '9.95' NOT NULL ,
`package` INT DEFAULT '0' NOT NULL ,
`billingcycle` INT DEFAULT '1' NOT NULL ,
PRIMARY KEY ( `id` )
);
INSERT INTO `tld` ( `id` , `name` , `period` , `price` , `transferprice`, `billingcycle` )VALUES ('', 'net', '1', '9.95', '0','0');
INSERT INTO `tld` ( `id` , `name` , `period` , `price` , `transferprice`, `billingcycle` )VALUES ('', 'com', '1', '9.95', '0','0');
INSERT INTO `tld` ( `id` , `name` , `period` , `price` , `transferprice`, `billingcycle` )VALUES ('', 'org', '1', '9.95', '0','0');
ALTER TABLE `promotion` CHANGE `showuser` `showuser` TINYINT( 4 ) DEFAULT '1' NOT NULL;
ALTER TABLE `promotion` ADD `regdomain` SMALLINT( 1 ) DEFAULT '1' NOT NULL ;
ALTER TABLE `domains` ADD `promotionid` INT NOT NULL ;