UPDATE setting set value='2.2.5' where name='ClientExec Version';
UPDATE `module_group` SET `viewall` = '1' WHERE `moduleid` = '3' AND `groupid` = '5' LIMIT 1 ;
UPDATE `module_group` SET `viewable` = '0',`viewall` = '0' WHERE `moduleid` = '7' AND `groupid` = '5' LIMIT 1 ;
UPDATE `module_group` SET `viewable` = '0' WHERE `moduleid` = '7' AND `groupid` = '4' LIMIT 1 ;
UPDATE `module_group` SET `viewall` = '1' WHERE `moduleid` = '3' AND `groupid` = '4' LIMIT 1 ;
ALTER TABLE `promotion` ADD `issub` TINYINT DEFAULT '0' NOT NULL ,
ADD `allowreg` TINYINT DEFAULT '1' NOT NULL ,
ADD `allowtransfer` TINYINT DEFAULT '0' NOT NULL ,
ADD `allowselfmanage` TINYINT DEFAULT '1' NOT NULL ;
ALTER TABLE `promotion` ADD `maindomain` VARCHAR( 50 ) DEFAULT 'yourdomain.com' NOT NULL AFTER `issub` ;
ALTER TABLE `package` ADD `usedefaultwelcome` TINYINT DEFAULT '1' NOT NULL AFTER `setup` ;
CREATE TABLE files_servers (
  id_file int(11) NOT NULL default '0',
  id_server int(11) NOT NULL default '0',
  PRIMARY KEY  (id_file,id_server)
) ENGINE=MyISAM;
CREATE TABLE files_cats_servers (
  id_cat int(11) NOT NULL default '0',
  id_server int(11) NOT NULL default '0',
  PRIMARY KEY  (id_cat,id_server)
) ENGINE=MyISAM;
ALTER TABLE `files` ADD `size` INT( 11 ) DEFAULT '0' NOT NULL ;
ALTER TABLE `files` ADD `added` DATE DEFAULT '0000-00-00' NOT NULL ;
UPDATE `cache` SET `content` = '' WHERE `cachekey` = 'ADMINSUMMARY';
