UPDATE setting set value='1.2' where name='ClientExec Version';
UPDATE setting set type='10' where name='Ensure Proper Domain Format';
ALTER TABLE `customdomainfields` ADD `dropdownoptions` LONGTEXT NOT NULL ;
ALTER TABLE `customuserfields` ADD `dropdownoptions` LONGTEXT NOT NULL ;
ALTER TABLE `server` ADD `plugin` VARCHAR( 25 ) NOT NULL ;
CREATE TABLE `serverplugin_options` (
`serverid` INT NOT NULL ,
`optionname` VARCHAR( 125 ) NOT NULL ,
`value` LONGTEXT NOT NULL ,
PRIMARY KEY ( `serverid`, `optionname`)
);
CREATE TABLE `taxrule` (
`countrycode` VARCHAR( 5 ) NOT NULL ,
`state` VARCHAR( 20 ) NOT NULL ,
`tax` FLOAT NOT NULL ,
PRIMARY KEY ( `countrycode` , `state` )
);
CREATE TABLE `package_variable` (
`packageid` INT NOT NULL ,
`varname` VARCHAR( 35 ) NOT NULL ,
`value` VARCHAR( 200 ) NOT NULL ,
PRIMARY KEY ( `packageid` , `varname` )
);
ALTER TABLE `users` ADD `taxable` TINYINT DEFAULT '0' NOT NULL ;
UPDATE `module_group` SET `viewall` = '0' WHERE `moduleid` = '3' AND `groupid` = '3' LIMIT 1 ;
UPDATE `module_group` SET `viewable` = '0', `viewall` = '0' WHERE `moduleid` = '4' AND `groupid` = '3' LIMIT 1 ;
INSERT INTO `module_group` ( `moduleid` , `groupid` , `viewable` , `viewall` ) VALUES ( '2', '4', '1', '0');
INSERT INTO `module_group` ( `moduleid` , `groupid` , `viewable` , `viewall` ) VALUES ( '3', '4', '1', '0');
INSERT INTO `module_group` ( `moduleid` , `groupid` , `viewable` , `viewall` ) VALUES ( '4', '4', '1', '1');
INSERT INTO `module_group` ( `moduleid` , `groupid` , `viewable` , `viewall` ) VALUES ( '5', '4', '0', '0');
INSERT INTO `module_group` ( `moduleid` , `groupid` , `viewable` , `viewall` ) VALUES ( '6', '4', '1', '0');
INSERT INTO `module_group` ( `moduleid` , `groupid` , `viewable` , `viewall` ) VALUES ( '7', '4', '1', '0');
UPDATE `setting` SET `description` = 'Initial email customer receives to confirm a password change to his account.' WHERE name='Forgot Password Template';
ALTER TABLE `package` ADD `taxable` TINYINT DEFAULT '0' NOT NULL;
ALTER TABLE `invoice` ADD `tax` FLOAT DEFAULT '0.0' NOT NULL ;
ALTER TABLE `invoice` ADD `processorid` VARCHAR( 255 ) NOT NULL ;
CREATE TABLE `currency` (
`id` INT NOT NULL AUTO_INCREMENT ,
`name` VARCHAR( 250 ) NOT NULL ,
`symbol` VARCHAR( 3 ) NOT NULL ,
`abrv` VARCHAR( 4 ) NOT NULL ,
INDEX ( `id` )
);
INSERT INTO `currency` ( `id` , `name` , `symbol` , `abrv` ) VALUES ('', 'Slovenia Tolar', 'SIT', 'SIT');
INSERT INTO `currency` ( `id` , `name` , `symbol` , `abrv` ) VALUES ('', 'Swiss Franc', 'CHF', 'CHF');
INSERT INTO `currency` ( `id` , `name` , `symbol` , `abrv` ) VALUES ('', 'Malaysian Ringgit', 'MYR', 'MYR');
INSERT INTO `currency` ( `id` , `name` , `symbol` , `abrv` ) VALUES ('', 'Australian Dollar', '$', 'AUD');
INSERT INTO `currency` ( `id` , `name` , `symbol` , `abrv` ) VALUES ('', 'US Dollar', '$', 'USD');
INSERT INTO `currency` ( `id` , `name` , `symbol` , `abrv` ) VALUES ('', 'Canadian Dollar', '$', 'CAD');
INSERT INTO `currency` ( `id` , `name` , `symbol` , `abrv` ) VALUES ('', 'New Zealand Dollars', 'NZ$', 'NZD');
INSERT INTO `currency` ( `id` , `name` , `symbol` , `abrv` ) VALUES ('', 'Saudi Riyal', 'SR', 'SAR');
INSERT INTO `currency` ( `id` , `name` , `symbol` , `abrv` ) VALUES ('', 'Turkish Lira', 'TRL', 'TRL');
INSERT INTO `currency` ( `id` , `name` , `symbol` , `abrv` ) VALUES ('', 'Swedish Krona', 'Sk', 'SEK');
INSERT INTO `currency` ( `id` , `name` , `symbol` , `abrv` ) VALUES ('', 'Singapore Dollar', '$', 'SGD');
INSERT INTO `currency` ( `id` , `name` , `symbol` , `abrv` ) VALUES ('', 'Euro', '€', 'EUR');
INSERT INTO `currency` ( `id` , `name` , `symbol` , `abrv` ) VALUES ('', 'Indian Rupees', 'Rs.', 'INR');
INSERT INTO `currency` ( `id` , `name` , `symbol` , `abrv` ) VALUES ('', 'Philippine Peso', 'PHP', 'PHP');
INSERT INTO `currency` ( `id` , `name` , `symbol` , `abrv` ) VALUES ('', 'Yen', '¥', 'JPY');
INSERT INTO `currency` ( `id` , `name` , `symbol` , `abrv` ) VALUES ('', 'Pound Sterling (GBP)', '£', 'GBP');
INSERT INTO `currency` ( `id` , `name` , `symbol` , `abrv` ) VALUES ('', 'Indonesia Rupiah (Rp)', 'Rp', 'IDR');
UPDATE `setting` SET `type` = '-1' WHERE `name` = 'Default Currency';
UPDATE customuserfields set type='11',isChangable = '2' where name='First Name';
UPDATE customuserfields set type='12',isChangable = '2' where name='Last Name';
UPDATE customuserfields set type='13',isChangable = '2' where name='Email';
UPDATE customuserfields set type='14',isChangable = '2' where name='Organization';
UPDATE customuserfields SET isChangable = '2' where name='Language';
UPDATE customuserfields SET inSettings = '0',showcustomer = '0',showadmin = '0',InSignup = '0' where name='IM on New Signup';
UPDATE customuserfields SET inSettings = '0',showcustomer = '0',showadmin = '0',InSignup = '0' where name='IM on New Ticket';
UPDATE customuserfields SET inSettings = '0',showcustomer = '0',showadmin = '0',InSignup = '0' where name='IM on Payment';
UPDATE customuserfields SET inSettings = '0',showcustomer = '0',showadmin = '0',InSignup = '0' where name='IM on Login';
UPDATE customuserfields SET inSettings = '0',showcustomer = '0',showadmin = '0',InSignup = '0' where name='ICQ Number';
UPDATE `cache` SET `content` = '' WHERE `cachekey` = 'ADMINSUMMARY';
