1ALTER TABLE `tblannouncements` CHANGE `date` `date` DATETIME NULL DEFAULT NULL ;
  2ALTER TABLE `tblaccounts` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT , CHANGE `userid` `userid` INT( 10 ) NOT NULL,CHANGE `invoiceid` `invoiceid` INT( 10 ) NOT NULL DEFAULT '0'  ;
  3CREATE INDEX invoiceid ON tblaccounts (invoiceid);
  4CREATE INDEX userid ON tblaccounts (userid);
  5CREATE INDEX date ON tblaccounts (date);
  6CREATE INDEX transid ON tblaccounts (transid(32));
  7ALTER TABLE `tblactivitylog` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ;
  8ALTER TABLE `tbladdons` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ;
  9CREATE INDEX name ON tbladdons (name(32));
 10ALTER TABLE `tbladminlog` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ;
 11CREATE INDEX logouttime ON tbladminlog (logouttime);
 12CREATE INDEX roleid_permid ON tbladminperms (roleid,permid);
 13ALTER TABLE `tbladmins` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ;
 14CREATE INDEX username ON tbladmins (username(32));
 15ALTER TABLE `tblaffiliates` CHANGE `clientid` `clientid` INT( 10 ) NOT NULL ;
 16CREATE INDEX affiliateid ON tblaffiliates (id);
 17CREATE INDEX clientid ON tblaffiliates (clientid);
 18ALTER TABLE `tblaffiliates` DROP PRIMARY KEY;
 19ALTER TABLE `tblaffiliatesaccounts` CHANGE `id` `id` INT( 1 ) NOT NULL AUTO_INCREMENT ;
 20ALTER TABLE `tblaffiliatesaccounts` CHANGE `affiliateid` `affiliateid` INT( 10 ) NOT NULL ;
 21CREATE INDEX affiliateid ON tblaffiliatesaccounts (affiliateid);
 22ALTER TABLE `tblaffiliateshistory` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ,CHANGE `affiliateid` `affiliateid` INT( 10 ) NOT NULL , CHANGE `affaccid` `affaccid` INT( 10 ) NOT NULL ;
 23CREATE INDEX affiliateid ON tblaffiliateshistory (affiliateid);
 24ALTER TABLE `tblaffiliatespending` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT , CHANGE `affaccid` `affaccid` INT( 10 ) NOT NULL DEFAULT '0' ;
 25CREATE INDEX clearingdate ON tblaffiliatespending (clearingdate);
 26ALTER TABLE `tblannouncements` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ;
 27CREATE INDEX date ON tblannouncements (date);
 28ALTER TABLE `tblbannedemails` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ,CHANGE `count` `count` INT( 10 ) NOT NULL DEFAULT '0' ;
 29CREATE INDEX domain ON tblbannedemails (domain(64));
 30ALTER TABLE `tblbannedips` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ;
 31CREATE INDEX ip ON tblbannedips (ip(32));
 32ALTER TABLE `tblbrowserlinks` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ;
 33CREATE INDEX name ON tblbrowserlinks (name(32));
 34ALTER TABLE `tblcalendar` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT , CHANGE `adminid` `adminid` INT( 10 ) NOT NULL ;
 35CREATE INDEX day_month_year ON tblcalendar (day(2),month(2),year(4));
 36ALTER TABLE `tblcancelrequests` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT , CHANGE `relid` `relid` INT( 10 ) NOT NULL ;
 37CREATE INDEX serviceid ON tblcancelrequests (relid);
 38ALTER TABLE `tblclients` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT , CHANGE `billingcid` `billingcid` INT( 10 ) NOT NULL ;
 39CREATE INDEX firstname_lastname ON tblclients (firstname(32),lastname(32));
 40CREATE INDEX email ON tblclients (email(64));
 41CREATE INDEX setting ON tblconfiguration (setting(32));
 42CREATE INDEX userid_firstname_lastname ON tblcontacts (userid,firstname(32),lastname(32));
 43ALTER TABLE `tblcontacts` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT , CHANGE `userid` `userid` INT( 10 ) NOT NULL ;
 44CREATE INDEX email ON tblcontacts (email(64));
 45ALTER TABLE `tblcredit` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT , CHANGE `clientid` `clientid` INT( 10 ) NOT NULL ;
 46ALTER TABLE `tblcustomfields` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT , CHANGE `relid` `relid` INT( 10 ) NOT NULL ;
 47CREATE INDEX serviceid ON tblcustomfields (relid);
 48ALTER TABLE `tblcustomfieldsvalues` CHANGE `fieldid` `fieldid` INT( 10 ) NOT NULL , CHANGE `relid` `relid` INT( 10 ) NOT NULL ;
 49CREATE INDEX fieldid_relid ON tblcustomfieldsvalues (fieldid,relid);
 50ALTER TABLE `tbldomainpricing` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ;
 51CREATE INDEX extension_registrationperiod ON tbldomainpricing (extension(32),registrationperiod);
 52CREATE INDEX `order` ON tbldomainpricing (`order`);
 53ALTER TABLE `tbldomains` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT , CHANGE `userid` `userid` INT( 10 ) NOT NULL ;
 54CREATE INDEX userid ON tbldomains (userid);
 55CREATE INDEX orderid ON tbldomains (orderid);
 56CREATE INDEX domain ON tbldomains (domain(64));
 57CREATE INDEX status ON tbldomains (status);
 58ALTER TABLE `tbldomainsadditionalfields` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ,CHANGE `domainid` `domainid` INT( 10 ) NOT NULL ;
 59CREATE INDEX domainid ON tbldomainsadditionalfields (domainid);
 60ALTER TABLE `tbldownloadcats` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT , CHANGE `parentid` `parentid` INT( 10 ) NOT NULL DEFAULT '0' ;
 61CREATE INDEX parentid ON tbldownloadcats (parentid);
 62ALTER TABLE `tbldownloads` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT , CHANGE `category` `category` INT( 10 ) NOT NULL AFTER id , CHANGE `downloads` `downloads` INT( 10 ) NOT NULL DEFAULT '0' ;
 63CREATE INDEX title ON tbldownloads (title(32));
 64ALTER TABLE `tbldownloads` ADD INDEX ( `downloads` ) ;
 65ALTER TABLE `tblemails` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT , CHANGE `userid` `userid` INT( 10 ) NOT NULL ;
 66CREATE INDEX userid ON tblemails (userid);
 67ALTER TABLE `tblemailtemplates` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ;
 68CREATE INDEX type ON tblemailtemplates (type(32));
 69CREATE INDEX name ON tblemailtemplates (name(64));
 70ALTER TABLE `tblfraud` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ;
 71CREATE INDEX fraud ON tblfraud (fraud(32));
 72ALTER TABLE `tblgatewaylog` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ;
 73ALTER TABLE `tblhosting` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ,CHANGE `userid` `userid` INT( 10 ) NOT NULL ,CHANGE `orderid` `orderid` INT( 10 ) NOT NULL ,CHANGE `packageid` `packageid` INT( 10 ) NOT NULL AFTER `orderid` ,CHANGE `server` `server` INT( 10 ) NOT NULL AFTER `packageid`;
 74UPDATE tblhosting SET password=rootpassword WHERE password='' AND rootpassword!='';
 75ALTER TABLE `tblhosting` DROP `rootpassword` ;
 76CREATE INDEX serviceid ON tblhosting (id);
 77CREATE INDEX userid ON tblhosting (userid);
 78CREATE INDEX orderid ON tblhosting (orderid);
 79CREATE INDEX productid ON tblhosting (packageid);
 80CREATE INDEX serverid ON tblhosting (server);
 81CREATE INDEX domain ON tblhosting (domain(64));
 82CREATE INDEX domainstatus ON tblhosting (domainstatus);
 83ALTER TABLE `tblhostingaddons` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ,CHANGE `orderid` `orderid` INT( 10 ) NOT NULL ,CHANGE `hostingid` `hostingid` INT( 10 ) NOT NULL ;
 84ALTER TABLE `tblhostingaddons` ADD INDEX ( `orderid` ) ;
 85CREATE INDEX serviceid ON tblhostingaddons (hostingid);
 86CREATE INDEX name ON tblhostingaddons (name(32));
 87CREATE INDEX status ON tblhostingaddons (status);
 88ALTER TABLE `tblhostingconfigoptions` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ,CHANGE `relid` `relid` INT( 10 ) NOT NULL ,CHANGE `configid` `configid` INT( 10 ) NOT NULL ,CHANGE `optionid` `optionid` INT( 10 ) NOT NULL ;
 89CREATE INDEX relid_configid ON tblhostingconfigoptions (relid,configid);
 90ALTER TABLE `tblinvoiceitems` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ,CHANGE `invoiceid` `invoiceid` INT( 10 ) NOT NULL DEFAULT '0' , CHANGE `userid` `userid` INT( 10 ) NOT NULL ,CHANGE `relid` `relid` INT( 10 ) NOT NULL ;
 91ALTER TABLE `tblinvoiceitems` ADD INDEX ( `invoiceid` ) ;
 92ALTER TABLE `tblinvoices` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ,CHANGE `userid` `userid` INT( 10 ) NOT NULL AFTER `id`;
 93ALTER TABLE `tblinvoices` ADD INDEX ( `userid` ) ;
 94CREATE INDEX status ON tblinvoices (status(3));
 95ALTER TABLE `tblknowledgebase` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ,CHANGE `category` `category` INT( 10 ) NOT NULL DEFAULT '0',CHANGE `views` `views` INT( 10 ) NOT NULL DEFAULT '0',CHANGE `useful` `useful` INT( 10 ) NOT NULL DEFAULT '0',CHANGE `votes` `votes` INT( 10 ) NOT NULL DEFAULT '0' ;
 96ALTER TABLE `tblknowledgebasecats` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ,CHANGE `parentid` `parentid` INT( 10 ) NOT NULL DEFAULT '0' ;
 97ALTER TABLE `tblknowledgebasecats` ADD INDEX ( `parentid` ) ;
 98CREATE INDEX name ON tblknowledgebasecats (name(64));
 99ALTER TABLE `tbllinks` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ,CHANGE `clicks` `clicks` INT( 10 ) NOT NULL ,CHANGE `conversions` `conversions` INT( 10 ) NOT NULL ;
100CREATE INDEX name ON tbllinks (name(64));
101ALTER TABLE `tblnotes` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ,CHANGE `userid` `userid` INT( 10 ) NOT NULL ,CHANGE `adminid` `adminid` INT( 10 ) NOT NULL DEFAULT '0' ;
102CREATE INDEX userid ON tblnotes (userid);
103ALTER TABLE `tblorders` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ,CHANGE `userid` `userid` INT( 10 ) NOT NULL ,CHANGE `contactid` `contactid` INT( 10 ) NOT NULL ,CHANGE `invoiceid` `invoiceid` INT( 10 ) NOT NULL DEFAULT '0' ;
104CREATE INDEX ordernum ON tblorders (ordernum);
105CREATE INDEX userid ON tblorders (userid);
106CREATE INDEX contactid ON tblorders (contactid);
107CREATE INDEX date ON tblorders (date);
108ALTER TABLE `tblpaymentgateways` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ;
109CREATE INDEX gateway_setting ON tblpaymentgateways (gateway(32),setting(32));
110CREATE INDEX setting_value ON tblpaymentgateways (setting(32),value(32));
111ALTER TABLE `tblproductconfigoptions` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ,CHANGE `productid` `productid` INT( 10 ) NOT NULL ;
112ALTER TABLE `tblproductconfigoptions` ADD INDEX ( `productid` ) ;
113ALTER TABLE `tblproductconfigoptionssub` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ,CHANGE `configid` `configid` INT( 10 ) NOT NULL ;
114CREATE INDEX configid ON tblproductconfigoptionssub (configid);
115CREATE INDEX `order` ON tblproductgroups (`order`);
116ALTER TABLE `tblproductgroups` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ;
117ALTER TABLE `tblproducts` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ,CHANGE `gid` `gid` INT( 10 ) NOT NULL ,CHANGE `welcomeemail` `welcomeemail` INT( 1 ) NOT NULL DEFAULT '0',CHANGE `qty` `qty` INT( 1 ) NOT NULL DEFAULT '0',CHANGE `defaultserver` `defaultserver` INT( 1 ) NOT NULL DEFAULT '0' ;
118CREATE INDEX gid ON tblproducts (gid);
119CREATE INDEX name ON tblproducts (name(64));
120ALTER TABLE `tblpromotions` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ,CHANGE `maxuses` `maxuses` INT( 10 ) NOT NULL DEFAULT '0',CHANGE `uses` `uses` INT( 10 ) NOT NULL DEFAULT '0' ;
121CREATE INDEX code ON tblpromotions (code(32));
122ALTER TABLE `tblregistrars` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ;
123CREATE INDEX registrar_setting ON tblregistrars(registrar(32),setting(32));
124ALTER TABLE `tblservers` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ,CHANGE `maxaccounts` `maxaccounts` INT( 10 ) NOT NULL DEFAULT '0' ;
125ALTER TABLE `tbltax` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ;
126CREATE INDEX state_country ON tbltax (state(32),country(2));
127ALTER TABLE `tblticketbreaklines` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ;
128ALTER TABLE `tblticketdepartments` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ;
129CREATE INDEX name ON tblticketdepartments (name(64));
130ALTER TABLE `tblticketlog` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ,CHANGE `tid` `tid` INT( 10 ) NOT NULL ;
131CREATE INDEX tid ON tblticketlog (tid);
132ALTER TABLE `tblticketmaillog` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ;
133ALTER TABLE `tblticketnotes` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ,CHANGE `ticketid` `ticketid` INT( 10 ) NOT NULL AFTER `id`;
134CREATE INDEX ticketid_date ON tblticketnotes (ticketid,date);
135ALTER TABLE `tblticketpredefinedcats` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ,CHANGE `parentid` `parentid` INT( 10 ) NOT NULL DEFAULT '0' ;
136CREATE INDEX parentid_name ON tblticketpredefinedcats (parentid,name(64));
137ALTER TABLE `tblticketpredefinedreplies` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ,CHANGE `catid` `catid` INT( 10 ) NOT NULL ;
138ALTER TABLE `tblticketreplies` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ,CHANGE `tid` `tid` INT( 10 ) NOT NULL ,CHANGE `userid` `userid` INT( 10 ) NOT NULL ;
139CREATE INDEX tid_date ON tblticketreplies (tid,date);
140ALTER TABLE `tbltickets` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ,CHANGE `did` `did` INT( 10 ) NOT NULL ,CHANGE `userid` `userid` INT( 10 ) NOT NULL ;
141CREATE INDEX tid_c ON tbltickets (tid,c(64));
142CREATE INDEX userid ON tbltickets (userid);
143CREATE INDEX status ON tbltickets (status(10));
144CREATE INDEX date ON tbltickets (date);
145ALTER TABLE `tblticketspamfilters` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ;
146ALTER TABLE `tblticketspamfilters` ADD INDEX ( `type` ) ;
147ALTER TABLE `tbltodolist` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ,CHANGE `admin` `admin` INT( 10 ) NOT NULL DEFAULT '0' ;
148CREATE INDEX duedate ON tbltodolist (duedate);
149ALTER TABLE `tblupgrades` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ,CHANGE `orderid` `orderid` INT( 10 ) NOT NULL ;
150CREATE INDEX orderid ON tblupgrades (orderid);
151CREATE INDEX serviceid ON tblupgrades (relid);
152ALTER TABLE `tblwhoislog` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT ;
153INSERT INTO tblconfiguration (setting,value) VALUES ('CCRetryEveryWeekFor','0');
154INSERT INTO tblconfiguration (setting,value) VALUES ('SupportTicketKBSuggestions','on');
155CREATE TABLE IF NOT EXISTS `tblsslorders` ( `id` int(10) NOT NULL auto_increment, `userid` int(10) NOT NULL, `serviceid` int(10) NOT NULL, `remoteid` text COLLATE utf8_unicode_ci NOT NULL,  `module` text COLLATE utf8_unicode_ci NOT NULL,  `certtype` text COLLATE utf8_unicode_ci NOT NULL,  `completiondate` datetime NOT NULL, `status` enum('Incomplete','Completed','Cancelled') NOT NULL,  PRIMARY KEY  (`id`)) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
156ALTER TABLE `tblhostingaddons` CHANGE `status` `status` ENUM( 'Pending', 'Active', 'Suspended', 'Terminated', 'Cancelled', 'Fraud' ) NOT NULL DEFAULT 'Pending';
157INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('DailyEmailBackup', '');
158INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('FTPBackupHostname', '');
159INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('FTPBackupUsername', '');
160INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('FTPBackupPassword', '');
161INSERT INTO `tblconfiguration` (`setting`, `value`) VALUES ('FTPBackupDestination', '/');
162