Server : Apache/2 System : Linux server-15-235-50-60 5.15.0-164-generic #174-Ubuntu SMP Fri Nov 14 20:25:16 UTC 2025 x86_64 User : gositeme ( 1004) PHP Version : 8.2.29 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname Directory :  /home/gositeme/domains/gositeme.com/public_html/whmcs/resources/sql/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

ALTER TABLE `tblannouncements` ADD `parentid` INT( 10 ) NOT NULL , ADD `language` TEXT NOT NULL ;

ALTER TABLE `tblknowledgebase` ADD `parentid` INT( 10 ) NOT NULL , ADD `language` TEXT NOT NULL ;
ALTER TABLE `tblknowledgebasecats` ADD `catid` INT( 10 ) NOT NULL , ADD `language` TEXT NOT NULL ;

ALTER TABLE `tbltickets` CHANGE `adminunread` `adminunread` TEXT NOT NULL ;

ALTER TABLE `tblpromotions` ADD `requires` TEXT NOT NULL AFTER `appliesto` , ADD `requiresexisting` INT( 1 ) NOT NULL AFTER `requires` ;

ALTER TABLE `tblcontacts` ADD `subaccount` INT( 1 ) NOT NULL DEFAULT '0' AFTER `phonenumber` ,
ADD `password` TEXT NOT NULL AFTER `subaccount` ,
ADD `permissions` TEXT NOT NULL AFTER `password`;

INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('CreateDomainInvoiceDaysBefore', '');
INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('NoInvoiceEmailOnOrder', '');
INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('TaxInclusiveDeduct', '');
INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('LateFeeMinimum', '0.00');
INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('AutoProvisionExistingOnly', '');

CREATE TABLE IF NOT EXISTS `tblticketstatuses` (
  `id` int(10) NOT NULL auto_increment,
  `title` text COLLATE utf8_unicode_ci NOT NULL,
  `color` text COLLATE utf8_unicode_ci NOT NULL,
  `sortorder` int(2) NOT NULL,
  `showactive` int(1) NOT NULL,
  `showawaiting` int(1) NOT NULL,
  `autoclose` int(1) NOT NULL,
  PRIMARY KEY  (`id`)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `tblticketstatuses` (`id`, `title`, `color`, `sortorder`, `showactive`, `showawaiting`, `autoclose`) VALUES
(1, 'Open', '#779500', 1, 1, 1, 0),
(2, 'Answered', '#000000', 2, 1, 0, 1),
(3, 'Customer-Reply', '#ff6600', 3, 1, 1, 1),
(4, 'Closed', '#888888', 10, 0, 0, 0),
(5, 'On Hold', '#224488', 5, 1, 0, 0),
(6, 'In Progress', '#cc0000', 6, 1, 0, 0);

ALTER TABLE `tblhosting` ADD `promoid` INT( 10 ) NOT NULL AFTER `subscriptionid` ;
ALTER TABLE `tbldomains` ADD `promoid` INT( 10 ) NOT NULL AFTER `subscriptionid` ;

ALTER TABLE `tblpricing` ADD `triennially` DECIMAL( 10, 2 ) NOT NULL ;
ALTER TABLE `tblpricing` ADD `tsetupfee` DECIMAL( 10, 2 ) NOT NULL AFTER `bsetupfee` ;
UPDATE tblpricing SET triennially='-1' WHERE type='product';

INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('EnableDomainRenewalOrders', 'on');
INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('EnableMassPay', 'on');

ALTER TABLE `tblorders` ADD `renewals` TEXT NOT NULL AFTER `transfersecret` ;

ALTER TABLE `tblbillableitems` ADD `hours` DECIMAL( 5, 1 ) NOT NULL AFTER `description` ;