UPDATE setting set value='2.2.2' where name='ClientExec Version';
INSERT INTO `setting` VALUES ('', 'Alternate Support Address', '', '<i>For email piping only</i><br>In the event that a user submit an email to your support email piping address without an existing account or recognizable email address, ClientExec will forward to this email address.  Leaving this setting blank will signal ClientExec to bounce back the email with the text found in the \'Bounce Back Template\' Setting', 8, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES ('', 'Bounce Back Template', 'Your suppor email can not be processed at this time because our support center did not recognize your email as one belonging to one of our customers.  If you need assistance please email using your email of record or submit a support ticket.\n\nSupport Team', '<i>For email piping only</i><br>Text used in the bounced email sent by ClientExec when an email is recieved via the pipe cron that does not belong to one of your customers.', 8, 0, 0, 1, 0, 0, 0, 0, 0, 0);
ALTER TABLE `users` ADD `usernotes` LONGTEXT NOT NULL;
ALTER TABLE `users` ADD `usernotespos` VARCHAR( 75 ) NOT NULL ;
update promotion set regdomain=1;
ALTER TABLE `customdomainfields` ADD `inSettings` TINYINT DEFAULT '1' NOT NULL ;
UPDATE `customdomainfields` SET `inSettings` = 0 WHERE `id` = '1';
INSERT INTO `module` ( `id` , `name` , `description` , `moduleorder` , `deletable` ) VALUES ('8', 'FILES', 'Files module description', '7', '0');
INSERT INTO `module_group` VALUES (8, 1, 1, 0);
INSERT INTO `module_group` VALUES (8, 2, 1, 1);
INSERT INTO `module_group` VALUES (8, 3, 1, 0);
INSERT INTO `module_group` VALUES (8, 4, 1, 0);
INSERT INTO `module_group` VALUES (8, 5, 1, 0);
ALTER TABLE `customdomainfields` ADD `InSignup` TINYINT DEFAULT '0' NOT NULL;
INSERT INTO `setting` ( `id` , `name` , `value` , `description` , `type` , `isrequired` , `istruefalse` , `istextarea` , `isfromoptions` , `myorder` , `helpid` , `plugin` , `ispassword` , `ishidden` ) VALUES ('', 'license', '', '', '-1', '1', '0', '0', '0', '0', '0', '0', '0', '0');
UPDATE help set detail='[<font class=bodyhighlight>COMPANYNAME</font>] <br> Company name<br>[<font class=bodyhighlight>ACCOUNTINFORMATION</font>]<br> Includes Domain Name, Username, Password, IP<br>[<font class=bodyhighlight>DOMAINNAME</font>]<br> domain name without http://www.<br>[<font class=bodyhighlight>DOMAINUSERNAME</font>]<br> Domain User Name<br>[<font class=bodyhighlight>DOMAINPASSWORD</font>]<br> Domain Password<br>[<font class=bodyhighlight>DOMAINIP</font>]<br> IP Address to Domain<br>[<font class=bodyhighlight>COMPANYURL</font>]<br> URL to your website<br>[<font class=bodyhighlight>SUPPORTEMAIL</font>]<br> Email to support staff<br>[<font class=bodyhighlight>CLIENTAPPLICATIONURL</font>]<br> URL to Client Exec.<br>[<font class=bodyhighlight>FORGOTPASSWORDURL</font>] URL to retrieve forgotten password.<br>[<font class=bodyhighlight>CLIENTNAME</font>]<br>Both first and last name<br>[<font class=bodyhighlight>CLIENTEMAIL</font>]<br>[<font class=bodyhighlight>NAMESERVERS</font>]<br>lists only hostnames<br>[<font class=bodyhighlight>NAMESERVERSANDIPS</font>]<br>lists both IPs and hostnames<br>[<font class=bodyhighlight>SERVERHOSTNAME</font>]<br>example server1.yourdomain.com<br>[<font class=bodyhighlight>SERVERSHAREDIP</font>]<br>shared IP for server<br>[<font class=bodyhighlight>CUSTOMPROFILE_xxxx</font>]<br>where xxx is custom profile field name<br>[<font class=bodyhighlight>CUSTOMPACKAGE_xxxx</font>]<br>where xxx is custom package field name' where title='Welcome Email Tags';