1INSERT INTO `tblconfiguration` (`setting` ,`value` )VALUES ('SEOFriendlyUrls', '');
  2INSERT INTO `tblconfiguration` (`setting` ,`value` )VALUES ('ShowCCIssueStart', '');
  3
  4ALTER TABLE `tblcustomfields` CHANGE `relid` `relid` INT( 10 ) NOT NULL DEFAULT '0' ;
  5ALTER TABLE `tblcustomfields` ADD `sortorder` INT( 10 ) NOT NULL DEFAULT '0';
  6
  7ALTER TABLE `tblproductconfigoptionssub` ADD `sortorder` INT( 10 ) NOT NULL DEFAULT '0';
  8
  9ALTER TABLE `tbladdons` ADD `tax` TEXT NOT NULL AFTER `billingcycle` ;
 10UPDATE tbladdons SET tax='on';
 11ALTER TABLE `tblhostingaddons` ADD `tax` TEXT NOT NULL AFTER `billingcycle` ;
 12UPDATE tblhostingaddons SET tax='on';
 13
 14INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('ClientDropdownFormat', '1');
 15
 16INSERT INTO `tblconfiguration` (`setting` ,`value` )VALUES ('TicketRatingEnabled', 'on');
 17ALTER TABLE `tblticketreplies` ADD `rating` INT( 5 ) NOT NULL ;
 18
 19CREATE TABLE IF NOT EXISTS `tblproductconfiggroups` (
 20  `id` int(10) NOT NULL auto_increment,
 21  `name` text COLLATE utf8_unicode_ci NOT NULL,
 22  `description` text COLLATE utf8_unicode_ci NOT NULL,
 23  PRIMARY KEY  (`id`)
 24) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 25
 26CREATE TABLE IF NOT EXISTS `tblproductconfiglinks` (
 27  `gid` int(10) NOT NULL,
 28  `pid` int(10) NOT NULL
 29) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 30
 31ALTER TABLE `tblproductconfigoptions` CHANGE `productid` `gid` INT( 10 ) NOT NULL DEFAULT '0' ;
 32
 33CREATE TABLE IF NOT EXISTS `tblnetworkissues` (
 34  `id` int(10) unsigned NOT NULL auto_increment,
 35  `title` varchar(45) NOT NULL,
 36  `description` text COLLATE utf8_unicode_ci NOT NULL,
 37  `type` enum('Server','System','Other') NOT NULL,
 38  `affecting` varchar(100) default NULL,
 39  `server` int(10) unsigned default NULL,
 40  `priority` enum('Critical','Low','Medium','High') NOT NULL,
 41  `startdate` datetime NOT NULL,
 42  `enddate` datetime default NULL,
 43  `status` enum('Reported','Investigating','In Progress','Outage','Scheduled','Resolved') NOT NULL,
 44  `lastupdate` datetime NOT NULL,
 45  PRIMARY KEY  (`id`)
 46) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 47INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('NetworkIssuesRequireLogin', 'on');
 48
 49INSERT INTO `tblconfiguration` (`setting` ,`value` )VALUES ('ShowNotesFieldonCheckout', 'on');
 50ALTER TABLE `tblorders` ADD `notes` TEXT NOT NULL ;
 51
 52INSERT INTO `tblconfiguration` (`setting` ,`value` )VALUES ('RequireLoginforClientTickets', 'on');
 53
 54ALTER TABLE `tblhostingaddons` CHANGE `subscriptionid` `notes` TEXT NOT NULL ;
 55
 56CREATE TABLE IF NOT EXISTS `tblquotes` (
 57`id` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
 58`subject` TEXT COLLATE utf8_unicode_ci NOT NULL ,
 59`stage` ENUM( 'Draft', 'Delivered', 'On Hold', 'Accepted', 'Lost', 'Dead' ) NOT NULL ,
 60`validuntil` DATE NOT NULL ,
 61`userid` INT( 10 ) NOT NULL ,
 62`firstname` TEXT COLLATE utf8_unicode_ci NOT NULL ,
 63`lastname` TEXT COLLATE utf8_unicode_ci NOT NULL ,
 64`companyname` TEXT COLLATE utf8_unicode_ci NOT NULL ,
 65`email` TEXT COLLATE utf8_unicode_ci NOT NULL ,
 66`address1` TEXT COLLATE utf8_unicode_ci NOT NULL ,
 67`address2` TEXT COLLATE utf8_unicode_ci NOT NULL ,
 68`city` TEXT COLLATE utf8_unicode_ci NOT NULL ,
 69`state` TEXT COLLATE utf8_unicode_ci NOT NULL ,
 70`postcode` TEXT COLLATE utf8_unicode_ci NOT NULL ,
 71`country` TEXT COLLATE utf8_unicode_ci NOT NULL ,
 72`phonenumber` TEXT COLLATE utf8_unicode_ci NOT NULL ,
 73`subtotal` DECIMAL( 10, 2 ) NOT NULL ,
 74`tax1` DECIMAL( 10, 2 ) NOT NULL ,
 75`tax2` DECIMAL( 10, 2 ) NOT NULL ,
 76`total` DECIMAL( 10, 2 ) NOT NULL ,
 77`customernotes` TEXT COLLATE utf8_unicode_ci NOT NULL ,
 78`adminnotes` TEXT COLLATE utf8_unicode_ci NOT NULL ,
 79`datecreated` DATE NOT NULL ,
 80`lastmodified` DATE NOT NULL
 81) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 82
 83CREATE TABLE IF NOT EXISTS `tblquoteitems` (
 84`id` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
 85`quoteid` INT( 10 ) NOT NULL ,
 86`description` TEXT COLLATE utf8_unicode_ci NOT NULL ,
 87`quantity` TEXT COLLATE utf8_unicode_ci NOT NULL ,
 88`unitprice` DECIMAL( 10, 2 ) NOT NULL ,
 89`discount` DECIMAL( 10, 2 ) NOT NULL ,
 90`taxable` INT( 1 ) NOT NULL
 91) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 92
 93INSERT INTO `tblemailtemplates` (`id`, `type`, `name`, `subject`, `message`, `fromname`, `fromemail`, `disabled`, `custom`, `language`, `copyto`, `plaintext`) VALUES('', 'general', 'Quote Delivery with PDF', 'Quote #{$quote_number} - {$quote_subject}', '<p>Dear {$client_name},</p>\r\n<p>Here is the quote you requested for {$quote_subject}. The quote is valid until {$quote_valid_until}. You may simply reply to this email with any furthur questions or requirement.</p>\r\n<p>{$signature}</p>', '', '', '', '', '', '', 0);
 94
 95INSERT INTO `tbladminperms` (`roleid` ,`permid` ) VALUES ('1', '84'), ('1', '85'), ('2', '85');
 96