Backups Created:
/home/japatmex/public_html/wp-content/edit-wolf.php

SavvyWolf - MANAGER

Edit File: script.php

<?php
defined('BASEPATH') OR exit('No direct script access allowed');

$queries = array(
	// v1 queries start
	"CREATE TABLE `tbl_gf_form_type` (
	  `FormTypeId` int(11) NOT NULL auto_increment,
	  `FormType` varchar(100) DEFAULT NULL,
	  `InHeader` tinyint(1) DEFAULT '0',
	  `Class` varchar(30) DEFAULT NULL,
	  `FTOrderBy` tinyint(1) DEFAULT '0',
	  PRIMARY KEY  (`FormTypeId`)
	) ENGINE=MyISAM DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_custom_fields` (
	  `FieldId` int(11) NOT NULL auto_increment,
	  `FieldLabel` varchar(100) DEFAULT NULL,
	  `FieldType` varchar(30) DEFAULT NULL,
	  `FieldColName` varchar(100) DEFAULT NULL,
	  `DisableField` tinyint(1) DEFAULT '0',
	  `Mandatory` tinyint(1) DEFAULT '0',
	  `ServiceType` tinyint(1) DEFAULT '0',
	  `SystemField` tinyint(1) DEFAULT '0',
	  `MaxLength` int(3) DEFAULT '0',
	  `FieldOrderBy` tinyint(2) NOT NULL DEFAULT '0',
	  `FInstructions` text,
	  PRIMARY KEY  (`FieldId`)
	) ENGINE=MyISAM DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_custom_field_values` (
	  `RegValueId` int(11) NOT NULL AUTO_INCREMENT,
	  `RegValue` varchar(100) DEFAULT NULL,
	  `FieldId` int(11) DEFAULT '0',
	  `DisableRegValue` tinyint(1) DEFAULT NULL,
	  PRIMARY KEY  (`RegValueId`)
	) ENGINE=MyISAM DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_rservice_custom_fields` (
	 `Id` int(11) NOT NULL auto_increment,
	 `PackageId` int(11) default NULL,
	 `FieldId` int(11) default NULL,
	  `ServiceType` tinyint(1) default '0',
	   PRIMARY KEY  (`Id`)
	 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_service_api_pricing` (
	  `Id` int(11) NOT NULL auto_increment,
	  `ServiceId` int(11) default 0,
	  `GroupId` int(11) default 0,
	  `ServiceType` tinyint(1) default 0,
	  `MarginType` tinyint(1) default 0,
	  `PriceMargin` float default 0,
	  PRIMARY KEY (`Id`)
	) ENGINE=MyISAM DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_manufacturer` (
	  `CategoryId` int(11) NOT NULL auto_increment,
	  `Category` varchar(50) DEFAULT NULL,
	  `DisableCategory` tinyint(1) DEFAULT '0',
	  `OrderBy` int(4) DEFAULT '0',
	  `ArchivedCategory` tinyint(1) DEFAULT '0',
	  `HTMLTitle` varchar(200) NOT NULL,
	  `SEOURLName` varchar(100) NOT NULL,
	  `MetaKW` text NOT NULL,
	  `MetaTags` text NOT NULL,
	  `BrandImg` varchar(100) NOT NULL,
	  PRIMARY KEY (`CategoryId`)
	) ENGINE=MyISAM DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_service_promo_history` (
	  `HistoryId` int(11) NOT NULL auto_increment,
	  `StartDate` date DEFAULT '0000-00-00',
	  `EndDate` date DEFAULT '0000-00-00',
	  `Discount` float DEFAULT '0',
	  `ServiceId` int(11) DEFAULT '0',
	  `ServiceType` tinyint(1) DEFAULT '0',
	  PRIMARY KEY (`HistoryId`)
	) ENGINE=MyISAM DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_task_category` (
	  `CategoryId` int(11) NOT NULL auto_increment,
	  `category` varchar(50) default NULL,
	  `Disablecategory` tinyint(1) default '0',
	  PRIMARY KEY  (`CategoryId`)
	) ENGINE=MyISAM  DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_tasks` (
	  `TaskId` int(11) NOT NULL auto_increment,
	  `DtTm` datetime DEFAULT NULL,
	  `MySelf` tinyint(1) DEFAULT '0',
	  `UserType` tinyint(1) DEFAULT '0',
	  `Users` text DEFAULT NULL,
	  `Message` text DEFAULT NULL,
	  `CategoryId` tinyint(3) DEFAULT '0',
	  `ReplyLock` tinyint(1) DEFAULT '0',
	  PRIMARY KEY (`TaskId`)
	) ENGINE=MyISAM DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_service_features` (
	  `FeatureId` int(11) NOT NULL auto_increment,
	  `Icon` VARCHAR(30) DEFAULT NULL,
	  `Feature` VARCHAR(100) DEFAULT NULL,
	  PRIMARY KEY (`FeatureId`)
	) ENGINE=MyISAM DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_pack_selected_features` (
	 `Id` int(11) NOT NULL auto_increment,
	 `ServiceId` int(11) default NULL,
	 `FeatureId` int(11) default NULL,
	 `ServiceType` TINYINT( 1 ) NULL DEFAULT  '0', 
	 PRIMARY KEY  (`Id`)
	) ENGINE=MyISAM;",
	"CREATE TABLE `tbl_gf_brand_logos` (
	  `Id` int(11) NOT NULL auto_increment,
	  `BrandImage` varchar(255) character set utf8 collate utf8_unicode_ci default NULL,
	  PRIMARY KEY  (`Id`)
	) ENGINE=MyISAM DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_pp_receivers` (
	  `ReceiverId` int(11) NOT NULL auto_increment,
	  `Username` varchar(100) default NULL,
	  `DisablePP` tinyint(1) default '0',
	  `APIUsername` varchar(100) default NULL,
	  `APIPassword` varchar(100) default NULL,
	  `APISignature` varchar(100) default NULL,
	  `MassPaymentTime` tinyint(1) default '1',
	  PRIMARY KEY  (`ReceiverId`)
	) ENGINE=MyISAM  DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_home_ecategory` (
	  `CategoryId` int(11) NOT NULL auto_increment,
	  `Category` varchar(50) default NULL,
	  `DisableCategory` tinyint(1) default '0',
	  `OrderBy` int(4) default '0',
	  `HTMLTitle` varchar(200) default NULL,
	  `SEOURLName` varchar(100) default NULL,
	  `MetaKW` text,
	  `MetaTags` text,
	  `Description` text,
	  `ArchivedCategory` tinyint(1) default '0',
	  PRIMARY KEY  (`CategoryId`)
	) ENGINE=MyISAM DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_ecat_products` (
	  `Id` int(11) NOT NULL auto_increment,
	  `CategoryId` int(11) NOT NULL,
	  `ProductId` int(11) NOT NULL,
	  PRIMARY KEY  (`Id`)
	) ENGINE=MyISAM DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_product_email` (
	  `Id` int(10) unsigned NOT NULL auto_increment,
	  `ClientName` varchar(100) default NULL,
	  `ClientEmail` varchar(100) default NULL,
	  `UserNotes` text,
	  `ProdURL` varchar(100) default NULL,
	  `ServiceName` varchar(100) default NULL,
	  `DeliveryTime` varchar(100) default NULL,
	  `Description` text,
	  `PackageId` int(11) default '0',
	  PRIMARY KEY  (`Id`)
	) ENGINE=MyISAM DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_shipping_addresses` (
	  `ShipAddressId` int(11) NOT NULL auto_increment,
	  `FirstName` varchar(50) default NULL,
	  `LastName` varchar(50) default NULL,
	  `CustomerId` int(11) default '0',
	  `Mobile` varchar(50) default NULL,
	  `Address` varchar(255) default NULL,
	  `City` varchar(50) default NULL,
	  `State` varchar(75) default NULL,
	  `CountryId` int(5) default NULL,
	  `Zip` varchar(50) default NULL,
	  `DefaultAddress` tinyint(1) default 0,
	  PRIMARY KEY  (`ShipAddressId`)
	) ENGINE=MyISAM  DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_product_visitors` (
	  `Id` int(11) NOT NULL auto_increment,
	  `IP` varchar(50) default NULL,
	  `Referer` varchar(200) default NULL,
	  `VisitDtTm` datetime default NULL,
	  `ProductId` int(11) default '0',
	  PRIMARY KEY  (`Id`)
	) ENGINE=MyISAM  DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_service_service_types` (
	  `Id` int(11) NOT NULL auto_increment,
	  `APIId` int(11) NOT NULL,
	  `ServiceId` int(11) NOT NULL,
	  `ServiceTypeId` int(11) NOT NULL,
	  `ServiceTypeName` varchar(100) default NULL,
	  `ServiceTypePrice` float default '0',
	  `ServiceType` tinyint(1) default '0',
	  PRIMARY KEY  (`Id`)
	) ENGINE=MyISAM  DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_related_products` (
	  `Id` int(11) NOT NULL auto_increment,
	  `ProductId` int(11) default NULL,
	  `RelatedProdId` int(11) default NULL,
	  PRIMARY KEY  (`Id`)
	) ENGINE=MyISAM  DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_product_wish_list` (
	  `Id` int(11) NOT NULL auto_increment,
	  `ProductId` int(11) default NULL,
	  `CustomerId` int(11) default NULL,
	  `DtTm` datetime DEFAULT NULL,
	  PRIMARY KEY  (`Id`)
	) ENGINE=MyISAM  DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_zones` (
	  `ZoneId` int(11) NOT NULL auto_increment,
	  `Zone` varchar(100) default NULL,
	  `DisableZone` tinyint(1) DEFAULT '0',
	  PRIMARY KEY  (`ZoneId`)
	) ENGINE=MyISAM DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_zone_country` (
	  `Id` int(11) NOT NULL auto_increment,
	  `ZoneId` int(11) default NULL,
	  `CountryId` int(11) default NULL,
	  PRIMARY KEY  (`Id`)
	) ENGINE=MyISAM  DEFAULT CHARSET=utf8;",
	"CREATE TABLE tbl_gf_shipping_rates (
	  `ShippingRateId` int(11) NOT NULL auto_increment,
	  `FromWeight` float default 0,
	  `ToWeight` float default 0,
	  `ShippingRate` float default 0,
	  `ShippingMethodId` int(11) default '0',
	  `ZoneId` int(11) default '0',
	  PRIMARY KEY  (`ShippingRateId`)
	) ENGINE=MyISAM  DEFAULT CHARSET=utf8;",
	"CREATE TABLE tbl_gf_imei_restricted_series(
	  `SeriesId` int(11) NOT NULL auto_increment,
	  `SeriesName` varchar(50) default NULL,
	  `IMEISeries` text default NULL,
	  `DisableSeries` tinyint(1) default 0,
	  PRIMARY KEY (`SeriesId`)
	) ENGINE=MyISAM DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_forms` (
	  `FormId` int(11) NOT NULL auto_increment,
	  `Form` varchar(255) DEFAULT NULL,
	  `FormTypeId` int(11) DEFAULT NULL,
	  `FormURL` varchar(100) DEFAULT NULL,
	  `IsNew` tinyint(1) DEFAULT '0',
	  `HiddenForm` tinyint(1) DEFAULT '0',
	  PRIMARY KEY  (`FormId`)
	) ENGINE=MyISAM DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_allowed_ips` (
	  `Id` int(11) NOT NULL auto_increment,
	  `IP` varchar(100) DEFAULT NULL,
	  `IPType` tinyint(1) DEFAULT '0',
	  PRIMARY KEY  (`Id`)
	) ENGINE=MyISAM DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_request_ips` (
	  `Id` int(11) NOT NULL auto_increment,
	  `IP` varchar(100) DEFAULT NULL,
	  `LCode` varchar(100) DEFAULT NULL,
	  PRIMARY KEY  (`Id`)
	) ENGINE=MyISAM DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_downloads` (
	  `DownloadId` int(11) NOT NULL auto_increment,
	  `Title` varchar(100) character set utf8 collate utf8_general_ci default NULL,
	  `FileURL` varchar(255) character set utf8 collate utf8_general_ci default NULL,
	  `DisableDownload` tinyint(1) default NULL,
	  PRIMARY KEY  (`DownloadId`)
	) ENGINE=MyISAM  DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_fcm_tokens` (
	  `id` int(11) NOT NULL,
	  `user_id` int(11) NOT NULL,
	  `token` varchar(500) NOT NULL
	) ENGINE=MyISAM DEFAULT CHARSET=latin1;",
	"CREATE TABLE `tbl_gf_admin_api_ips` (
	  `Id` int(11) NOT NULL auto_increment,
	  `IP` varchar(50) default NULL,
	  PRIMARY KEY  (`Id`)
	) ENGINE=MyISAM  DEFAULT CHARSET=utf8;",

"ALTER TABLE  `tbl_gf_log_requests` ADD `Q6H1H9H4I2H2I4Y2K6` varchar(100)  DEFAULT  NULL;",
	"ALTER TABLE `tbl_gf_packages` CHANGE `PackageTitle` `PackageTitle` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_credit_history` CHANGE `IMEINo` `IMEINo` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;",
	"ALTER TABLE  `tbl_gf_credit_history` ADD  `OType` TINYINT NULL DEFAULT  '0';",
	"ALTER TABLE  `tbl_gf_log_requests` ADD  `O7V8E3J2J4X6X1V6V2` varchar(100)  DEFAULT  NULL;",
	"ALTER TABLE `tbl_gf_log_requests` CHANGE `OrderAPIServiceId` `OrderAPIServiceId` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_codes_slbf` CHANGE `OrderAPIServiceId` `OrderAPIServiceId` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_codes` CHANGE `OrderAPIServiceId` `OrderAPIServiceId` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;",
	"ALTER TABLE  `tbl_gf_custom_fields` ADD  `UseAsQuantity` TINYINT( 1 ) NULL DEFAULT  '0';",
	"ALTER TABLE  `tbl_gf_log_requests` ADD `R5C9X7Y9C2J3K9J9P0` varchar(100)  DEFAULT  NULL;",
	"ALTER TABLE `tbl_gf_users` ADD `CanAddCredits` TINYINT(1) NULL DEFAULT '1';",
	"ALTER TABLE tbl_gf_pages ADD ActivateRetail TINYINT(1) NULL DEFAULT '0';",
	"ALTER TABLE `tbl_gf_retail_orders` DROP `ModelId`;",
	"ALTER TABLE  `tbl_gf_retail_orders` ADD  `CategoryId` INT NULL DEFAULT  '0';",
	"ALTER TABLE  `tbl_gf_retail_orders` ADD  `ModelId` INT NULL DEFAULT  '0';",
	"ALTER TABLE  `tbl_gf_retail_orders` ADD  `CarrierId` INT NULL DEFAULT  '0';",
	"ALTER TABLE  `tbl_gf_retail_orders` ADD  `CountryId` INT NULL DEFAULT  '0';",
	"ALTER TABLE `tbl_gf_service_api_pricing` ADD `ServiceAPIId` INT NULL DEFAULT  '0';",
	"ALTER TABLE `tbl_gf_retail_services` DROP `NewTplType`, DROP `SuccessTplType`, DROP `CancelledTplType`, DROP `NewTplSubject`, DROP `NewTplBody`, DROP `SuccessTplSubject`, DROP `SuccessTplBody`, DROP `CancelTplSubject`, DROP `CancelTplBody`, DROP `SendNewCopyToAdmin`, DROP `SendSuccessCopyToAdmin`, DROP `SendRejectCopyToAdmin`, DROP `CountryId`, DROP `ModelId`, DROP `CarrierId`;",
	"ALTER TABLE `tbl_gf_retail_services` DROP `ToolForUnlockBase`, DROP `FileName`, DROP `CalculatePreCodes`, DROP `SendSMS`, DROP `CancelOrders`, DROP `VerifyOrders`, DROP `OrderVerifyMins`, DROP `RedirectionURL`;",
	"ALTER TABLE `tbl_gf_retail_services` ADD `CostPriceFromAPI` TINYINT( 1 ) NULL DEFAULT  '0';",
	"ALTER TABLE  `tbl_gf_retail_services` ADD  `RedirectionURL` VARCHAR( 100 ) NULL ;",
	"ALTER TABLE `tbl_gf_retail_orders` DROP `MobileId`, DROP `CategoryId`, DROP `ModelId`, DROP `CountryId`, DROP `CarrierId`;",
	"ALTER TABLE tbl_gf_retail_orders ADD MobileId VARCHAR(50) NULL DEFAULT NULL;",
	"ALTER TABLE tbl_gf_retail_orders ADD ModelId VARCHAR(50) NULL DEFAULT NULL;",
	"ALTER TABLE tbl_gf_retail_orders ADD ModelNo VARCHAR(100) NULL DEFAULT NULL;",
	"ALTER TABLE tbl_gf_retail_orders ADD OrderType TINYINT( 1 ) NULL DEFAULT  '1';",
	"ALTER TABLE tbl_gf_retail_services ADD ShowAtHomePage TINYINT(1) NULL DEFAULT '0';",
	"ALTER TABLE  `tbl_gf_retail_services` CHANGE  `ServiceType`  `ServiceType` TINYINT( 1 ) NOT NULL DEFAULT  '1';",
	"ALTER TABLE tbl_gf_manufacturer ADD BrandType TINYINT(1) NOT NULL DEFAULT '0';",
	"ALTER TABLE tbl_gf_pages ADD URL VARCHAR(100) NULL DEFAULT NULL;",
	"ALTER TABLE tbl_gf_retail_services ADD RetailType TINYINT(1) NOT NULL DEFAULT '0';",
	"ALTER TABLE  `tbl_gf_retail_orders` ADD  `serialno_U4L6` varchar(100)  DEFAULT  NULL;",
	"ALTER TABLE  `tbl_gf_retail_orders` ADD  `email_B5D9` varchar(100)  DEFAULT  NULL;",
	"ALTER TABLE  `tbl_gf_retail_orders` ADD  `quantity_G7V7` varchar(100)  DEFAULT  NULL;",
	"ALTER TABLE  `tbl_gf_retail_orders` ADD  `username_K4I8` varchar(100)  DEFAULT  NULL;",
	"ALTER TABLE  `tbl_gf_retail_orders` ADD  `K9Y2N8V1A4X1C4Y7Y8` varchar(100)  DEFAULT  NULL;",
	"ALTER TABLE  `tbl_gf_retail_orders` ADD  `dongleid_D7V1` varchar(100)  DEFAULT  NULL;",
	"ALTER TABLE  `tbl_gf_retail_orders` ADD  `activecode_Q7B2` varchar(100)  DEFAULT  NULL;",
	"ALTER TABLE  `tbl_gf_retail_orders` ADD  `pasward_V6I0` varchar(100)  DEFAULT  NULL;",
	"ALTER TABLE  `tbl_gf_retail_orders` ADD  `O7V8E3J2J4X6X1V6V2` varchar(100)  DEFAULT  NULL;",
	"ALTER TABLE  `tbl_gf_retail_orders` ADD  `Q6H1H9H4I2H2I4Y2K6` varchar(100)  DEFAULT  NULL;",
	"ALTER TABLE  `tbl_gf_retail_orders` ADD `R5C9X7Y9C2J3K9J9P0` varchar(100)  DEFAULT  NULL;",
	"ALTER TABLE tbl_gf_retail_orders ADD RetailOrderType TINYINT(1) NOT NULL DEFAULT '0';",
	"ALTER TABLE tbl_gf_retail_orders ADD ReplyDtTm datetime default NULL;",
	"ALTER TABLE tbl_gf_retail_orders ADD CostPrice FLOAT NULL DEFAULT  '0';",
	"ALTER TABLE tbl_gf_retail_orders ADD Profit FLOAT NULL DEFAULT '0';",
	"ALTER TABLE tbl_gf_retail_orders ADD  `OrderCostPrice` FLOAT NULL DEFAULT  '0';",
	"ALTER TABLE tbl_gf_retail_orders ADD LinkedOrderId INT NULL DEFAULT '0';",
	"ALTER TABLE tbl_gf_retail_orders ADD AdminArchived tinyint(1) default '0';",
	"ALTER TABLE tbl_gf_retail_orders ADD `OrderData` VARCHAR(255) NULL;",
	"ALTER TABLE tbl_gf_retail_orders ADD `Comments1` TEXT NULL;",
	"ALTER TABLE tbl_gf_retail_orders ADD LastUpdatedBy VARCHAR(50) NULL DEFAULT '';",
	"ALTER TABLE  `tbl_gf_packages` CHANGE  `PackageTitle`  `PackageTitle` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL;",
	"ALTER TABLE  `tbl_gf_log_packages` CHANGE  `LogPackageTitle`  `LogPackageTitle` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL;",
	"ALTER TABLE tbl_gf_retail_services ADD PromoStartDate date default '0000-00-00';",
	"ALTER TABLE tbl_gf_retail_services ADD PromoEndDate date default '0000-00-00';",
	"ALTER TABLE tbl_gf_retail_services ADD PromoDiscount FLOAT NULL DEFAULT '0';",
	"ALTER TABLE tbl_gf_retail_orders ADD PromotionDiscount FLOAT NULL DEFAULT '0';",
	"ALTER TABLE tbl_gf_custom_fields ADD Restriction TINYINT (1) NULL DEFAULT 0;",
	"ALTER TABLE tbl_gf_users ADD TwoStepVerification TINYINT (1) NULL DEFAULT 0;",
	"ALTER TABLE `tbl_gf_log_packages` CHANGE `LogPackageTitle` `LogPackageTitle` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;",
	"ALTER TABLE tbl_gf_tasks ADD AdminId TINYINT (3) DEFAULT 0;",
	"ALTER TABLE tbl_gf_tasks ADD Reply TEXT DEFAULT NULL;",
	"ALTER TABLE tbl_gf_tasks ADD TaskRead TINYINT (1) DEFAULT 0;",
	"ALTER TABLE  `tbl_gf_log_requests` ADD  `A5C9F8O2Y0W8Q9M7C7` varchar(255)  DEFAULT  NULL;",
	"ALTER TABLE  `tbl_gf_log_requests` ADD  `I9E8C7S2D7I3R0T7Z1` varchar(255)  DEFAULT  NULL;",
	"ALTER TABLE  `tbl_gf_codes` ADD  `S9Z5X9R6B4M8C9J5L5` varchar(255)  DEFAULT  NULL;",
	"ALTER TABLE `tbl_gf_service_price_email` ADD `Features` TEXT DEFAULT  NULL;",
	"ALTER TABLE  `tbl_gf_log_requests` ADD  `W6A2C3K7V9A4Z1D1R2` varchar(100)  DEFAULT  NULL;",
	"ALTER TABLE  `tbl_gf_retail_orders` ADD  `W6A2C3K7V9A4Z1D1R2` varchar(100)  DEFAULT  NULL;",
	"ALTER TABLE  `tbl_gf_email_settings` CHANGE  `LocalLang`  `ShowEPricesAtWeb` TINYINT( 1 ) NULL DEFAULT  '1';",
	"ALTER TABLE  `tbl_gf_email_settings` ADD `AdminLoginCaptcha` TINYINT( 1 ) NULL DEFAULT  '1';",
	"ALTER TABLE  `tbl_gf_email_settings` ADD `ClientLoginCaptcha` TINYINT( 1 ) NULL DEFAULT  '0';",
	"ALTER TABLE `tbl_gf_payment_methods` ADD `RestrictedCurrency` TINYINT(1) NULL DEFAULT '0';",
	"ALTER TABLE `tbl_gf_users` ADD `UserArchived` TINYINT(1) NULL DEFAULT '0';",
	"ALTER TABLE  `tbl_gf_email_settings` CHANGE  `SMTPPwd`  `SMTPPwd` VARCHAR( 150 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_payment_methods` ADD `FeeType` TINYINT(1) NULL DEFAULT '0';",
	"ALTER TABLE `tbl_gf_pp_receivers` ADD `FeeType` TINYINT(1) NULL DEFAULT '0';",
	"ALTER TABLE `tbl_gf_pp_receivers` ADD `Fee` FLOAT NULL DEFAULT '0';",
	"ALTER TABLE  `tbl_gf_banner` ADD `URL` VARCHAR(100) NULL DEFAULT NULL;",
	"ALTER TABLE  `tbl_gf_payment_methods` ADD  `Vat` FLOAT NULL DEFAULT  '0';",
	"ALTER TABLE  `tbl_gf_payments` ADD `Vat` FLOAT NULL DEFAULT  '0';",
	"ALTER TABLE  `tbl_gf_retail_orders` ADD  `I9E8C7S2D7I3R0T7Z1` varchar(255)  DEFAULT  NULL;",
	"ALTER TABLE  `tbl_gf_retail_orders` ADD  `A5C9F8O2Y0W8Q9M7C7` varchar(255)  DEFAULT  NULL;",
	"ALTER TABLE  `tbl_gf_retail_orders` ADD  `S9Z5X9R6B4M8C9J5L5` varchar(255)  DEFAULT  NULL;",
	"ALTER TABLE tbl_gf_email_settings ADD GTranslatorS TINYINT(1) NULL DEFAULT '0';",
	"ALTER TABLE tbl_gf_email_settings ADD GTranslatorU TINYINT(1) NULL DEFAULT '0';",
	"ALTER TABLE tbl_gf_products ADD Shipping TINYINT(1) NULL DEFAULT '0';",
	"ALTER TABLE `tbl_gf_customers` DROP `CurrencyId`;",
	"ALTER TABLE tbl_gf_products ADD ProdWeight FLOAT NULL DEFAULT '0';",
	"ALTER TABLE tbl_gf_products ADD ProdWeightType VARCHAR (20) NULL DEFAULT NULL;",
	"ALTER TABLE tbl_gf_payment_methods ADD PayImage VARCHAR (100) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_supplier_services` ADD `RequiredParams` VARCHAR(150) NULL ;",
	"ALTER TABLE `tbl_gf_log_packages` ADD `ServiceTypeId` INT default 0;",
	"ALTER TABLE `tbl_gf_log_requests` ADD `OrderServiceTypeId` INT default 0;",
	"ALTER TABLE  `tbl_gf_shipping_method` DROP  `ShippingAmount`;",
	"ALTER TABLE  `tbl_gf_supplier_services` CHANGE  `ServiceId`  `ServiceId` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;",
	"ALTER TABLE  `tbl_gf_codes` CHANGE  `OrderAPIServiceId`  `OrderAPIServiceId` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;",
	"ALTER TABLE  `tbl_gf_packages` CHANGE  `ExternalNetworkId`  `ExternalNetworkId` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;",
	"ALTER TABLE tbl_gf_socialmedia ADD APPID VARCHAR(40) NULL DEFAULT '';",
	"ALTER TABLE `tbl_gf_email_settings` ADD `RushPaymentNotification` TINYINT(2) NULL DEFAULT 0;",
	"ALTER TABLE `tbl_gf_email_settings` ADD `AdminInvoiceNotification` TINYINT(2) NULL DEFAULT 0;",
	"ALTER TABLE `tbl_gf_log_packages` ADD `MinimumQty` FLOAT NULL DEFAULT 1;",
	"ALTER TABLE  `tbl_gf_email_settings` DROP  `NegativeCredits`;",
	"ALTER TABLE  `tbl_gf_users` ADD  `OverdraftLimit` FLOAT NULL DEFAULT  '0';",
	"ALTER TABLE `tbl_gf_packages` ADD `SeriesId` INT(11) NULL DEFAULT 0;",
	"ALTER TABLE `tbl_gf_payments` ADD `RushPaymentNotified` TINYINT(1) NULL DEFAULT 0;",
	"ALTER TABLE tbl_gf_price_plans ADD `IMEIPricesAtWeb` TINYINT(1) NULL DEFAULT 0;",
	"ALTER TABLE tbl_gf_price_plans ADD `FilePricesAtWeb` TINYINT(1) NULL DEFAULT 0;",
	"ALTER TABLE tbl_gf_price_plans ADD `ServerPricesAtWeb` TINYINT(1) NULL DEFAULT 0;",
	"ALTER TABLE  `tbl_gf_email_settings` ADD `RegisterCaptcha` TINYINT(1) NULL DEFAULT '1';",
	"ALTER TABLE  `tbl_gf_email_settings` ADD `ContactCaptcha` TINYINT(1) NULL DEFAULT '1';",
	"ALTER TABLE `tbl_gf_codes` CHANGE `OrderData` `OrderData` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;",
	"ALTER TABLE  `tbl_gf_email_settings` CHANGE  `LocalLanguage`  `LocalLanguage` VARCHAR( 3 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT  'en';",
	"ALTER TABLE  `tbl_gf_packages` ADD  `OrderCancelMins` INT NULL DEFAULT  '60';",
	"ALTER TABLE  `tbl_gf_log_packages` ADD  `OrderCancelMins` INT NULL DEFAULT  '60';",
	"ALTER TABLE `tbl_gf_package_category` CHANGE `Category` `Category` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;",
	"ALTER TABLE tbl_gf_codes ADD INDEX (CodeStatusId, UserId, PackageId);",
	"ALTER TABLE `tbl_gf_countries` ADD `BlockedPMethodIds` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_packages` CHANGE `PackageTitle` `PackageTitle` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_payment_methods` CHANGE `MassPaymentTime` `MassPaymentTime` TINYINT(1) NULL DEFAULT '1';",
	"ALTER TABLE `tbl_gf_pp_receivers` CHANGE `MassPaymentTime` `MassPaymentTime` TINYINT(1) NULL DEFAULT '1';",
	"ALTER TABLE  `tbl_gf_admin` ADD `GAuthSecret` varchar(100)  DEFAULT  NULL;",
	"ALTER TABLE  `tbl_gf_admin` ADD  `GoogleAuth` TINYINT NULL DEFAULT  '0';",
	"ALTER TABLE  `tbl_gf_pages` ADD  `SubMenuLink` TINYINT(1) NULL DEFAULT  '0';",
	"ALTER TABLE  `tbl_gf_email_settings` ADD `RestrictAPIIP` TINYINT(1) NULL DEFAULT  '1';",
	"ALTER TABLE  `tbl_gf_email_settings` ADD `AdminTitle` VARCHAR(100) NULL DEFAULT  NULL;",
	"ALTER TABLE  `tbl_gf_email_settings` ADD `SiteTitle` VARCHAR(100) NULL DEFAULT  NULL;",
	"ALTER TABLE  `tbl_gf_email_settings` ADD `ShopSiteTitle` VARCHAR(100) NULL DEFAULT  NULL;",
	"ALTER TABLE  `tbl_gf_email_settings` ADD `Copyrights` VARCHAR(100) NULL DEFAULT  NULL;",
	"ALTER TABLE `tbl_gf_payment_methods` CHANGE `RestrictedCurrency` `RestrictedCurrency` TINYINT(4) NULL DEFAULT '0';",
	"ALTER TABLE  `tbl_gf_payments` ADD `BillingFName` VARCHAR(50) NULL DEFAULT  NULL;",
	"ALTER TABLE  `tbl_gf_payments` ADD `BillingLName` VARCHAR(50) NULL DEFAULT  NULL;",
	"ALTER TABLE  `tbl_gf_payments` ADD `BillingEmail` VARCHAR(50) NULL DEFAULT  NULL;",
	"ALTER TABLE  `tbl_gf_payments` ADD `BillingPhone` VARCHAR(50) NULL DEFAULT  NULL;",
	"ALTER TABLE  `tbl_gf_payments` ADD `BillingAddress` TEXT NULL DEFAULT  NULL;",
	"ALTER TABLE  `tbl_gf_payments` ADD `BillingState` VARCHAR(50) NULL DEFAULT  NULL;",
	"ALTER TABLE  `tbl_gf_payments` ADD `BillingCity` VARCHAR(50) NULL DEFAULT  NULL;",
	"ALTER TABLE  `tbl_gf_payments` ADD `BillingZip` VARCHAR(20) NULL DEFAULT  NULL;",
	"ALTER TABLE  `tbl_gf_payments` ADD `BillingCountry` VARCHAR(5) NULL DEFAULT  NULL;",
	"ALTER TABLE  `tbl_gf_users` ADD `GAuthSecret` varchar(100)  DEFAULT  NULL;",
	"ALTER TABLE  `tbl_gf_users` ADD  `GoogleAuth` TINYINT NULL DEFAULT  '0';",
	"ALTER TABLE  `tbl_gf_order_payments` ADD `BillingFName` VARCHAR(50) NULL DEFAULT  NULL;",
	"ALTER TABLE  `tbl_gf_order_payments` ADD `BillingLName` VARCHAR(50) NULL DEFAULT  NULL;",
	"ALTER TABLE  `tbl_gf_order_payments` ADD `BillingEmail` VARCHAR(50) NULL DEFAULT  NULL;",
	"ALTER TABLE  `tbl_gf_order_payments` ADD `BillingPhone` VARCHAR(50) NULL DEFAULT  NULL;",
	"ALTER TABLE  `tbl_gf_order_payments` ADD `BillingAddress` TEXT NULL DEFAULT  NULL;",
	"ALTER TABLE  `tbl_gf_order_payments` ADD `BillingState` VARCHAR(50) NULL DEFAULT  NULL;",
	"ALTER TABLE  `tbl_gf_order_payments` ADD `BillingCity` VARCHAR(50) NULL DEFAULT  NULL;",
	"ALTER TABLE  `tbl_gf_order_payments` ADD `BillingZip` VARCHAR(20) NULL DEFAULT  NULL;",
	"ALTER TABLE  `tbl_gf_order_payments` ADD `BillingCountry` VARCHAR(5) NULL DEFAULT  NULL;",
	"ALTER TABLE `tbl_gf_users` DROP `TwoStepVerification`;",
	"ALTER TABLE `tbl_gf_admin_login_log` ADD `CldFrm` TINYINT(0) NOT NULL DEFAULT '0';",
	"ALTER TABLE `tbl_gf_admin` CHANGE `AdminUserPassword` `AdminUserPassword` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;",
	"ALTER TABLE `tbl_gf_users` CHANGE `UserPassword` `UserPassword` VARCHAR(75) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;",
	"ALTER TABLE `tbl_gf_users` CHANGE `AutoFillCredits` `AutoFillCredits` TINYINT(1) NULL DEFAULT '0';",
	"ALTER TABLE tbl_gf_users ADD TwoStepVerification TINYINT (1) NULL DEFAULT 0;",
	"ALTER TABLE tbl_gf_users ADD ThemeColor varchar(10) NULL DEFAULT 'blue';",
	"ALTER TABLE `tbl_gf_fcm_tokens`
	  ADD PRIMARY KEY (`id`);",
	"ALTER TABLE `tbl_gf_fcm_tokens`
	  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;",
	"ALTER TABLE tbl_gf_email_settings ADD MobileApp tinyint(1) NULL DEFAULT '0';",
	"ALTER TABLE  `tbl_gf_log_requests` ADD `T4Y3T4S9U5F2O4W5R3` varchar(100)  DEFAULT  NULL;",
	"ALTER TABLE `tbl_gf_users` CHANGE `UserEmail` `UserEmail` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_payment_methods` CHANGE `Username` `Username` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_email_settings` CHANGE `TimeDifference` `TimeDifference` VARCHAR(20) NULL DEFAULT '';",
	"ALTER TABLE `tbl_gf_email_settings` ADD ContactUsEmail varchar(50) DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_custom_fields` ADD MinLength int(3) DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_users` ADD CPanel int(1) DEFAULT 1;",
	"ALTER TABLE tbl_gf_log_requests ADD OrderPlcdFrm tinyint(1) NULL DEFAULT '0';",
	"ALTER TABLE `tbl_gf_manufacturer` ADD `BrandDesc` TEXT NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_subscriptions` ADD `FName` VARCHAR(100) NULL DEFAULT NULL, ADD `LName` VARCHAR(100) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_subscriptions` CHANGE `Email` `Email` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;",
	"ALTER TABLE `tbl_gf_payment_methods` ADD PaymentURL varchar(100) DEFAULT NULL;",
	"ALTER TABLE  `tbl_gf_email_settings` ADD `EncDataAlgo` VARCHAR(20) NULL;",
	"ALTER TABLE  `tbl_gf_payments` ADD `Token` VARCHAR(20) NULL;",
	"ALTER TABLE  `tbl_gf_products` ADD `CountryId` int NULL;",
	"ALTER TABLE  `tbl_gf_products` ADD `RestrictedCountryIds` VARCHAR(255) NULL;",
	"ALTER TABLE  `tbl_gf_payment_methods` ADD `SecretAPIKey` VARCHAR(255) NULL;",
	"ALTER TABLE  `tbl_gf_payments` ADD EcomInvId int NULL;",
	"ALTER TABLE `tbl_gf_package_category` ADD RemoteCategory tinyint(1) DEFAULT 0;",
	"ALTER TABLE `tbl_gf_log_package_category` ADD RemoteCategory tinyint(1) DEFAULT 0;",
	"ALTER TABLE `tbl_gf_home_ecategory` ADD RemoteCategory tinyint(1) DEFAULT 0;",
	"ALTER TABLE `tbl_gf_category` ADD RemoteCategory tinyint(1) DEFAULT 0;",
	"ALTER TABLE tbl_gf_users ADD OrderStyle tinyint(1) NULL DEFAULT '0';",
	"ALTER TABLE  `tbl_gf_email_settings` ADD `EncDataKey` VARCHAR(50) NULL;",
	"ALTER TABLE  `tbl_gf_payment_methods` ADD `PaymentMethodSubTypeId` INT NULL;",
	"ALTER TABLE  `tbl_gf_payment_methods` ADD `PaymentGatewayID` VARCHAR(100) NULL;",
	"ALTER TABLE  `tbl_gf_payment_methods` ADD `MinCredits` INT default NULL;",
	"ALTER TABLE  `tbl_gf_payment_methods` ADD `MaxCredits` INT default NULL;",
	"ALTER TABLE tbl_gf_countries ADD ISO3 varchar(3) NULL;",
	"ALTER TABLE `tbl_gf_payment_methods` ADD `DisabledAtSignUp` TINYINT(1) NULL DEFAULT '0';",
	"ALTER TABLE tbl_gf_custom_fields ADD `description` varchar(1000) NOT NULL;",
	"ALTER TABLE tbl_gf_custom_fields ADD `fieldOptions` varchar(1000) NOT NULL;",
	"ALTER TABLE tbl_gf_custom_fields ADD `serviceId` int(11) NOT NULL;",
	"ALTER TABLE tbl_gf_custom_fields ADD `ApiFieldId` int(11) DEFAULT NULL;",
	"ALTER TABLE tbl_gf_custom_fields ADD `ApiFieldName` varchar(255) DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_payment_methods` ADD `VATInCredits` TINYINT(1) NULL DEFAULT '0';",
	"ALTER TABLE `tbl_gf_payments` ADD `RemoveVAT` TINYINT(1) NULL DEFAULT '0';",
	// v1 queries end

"CREATE TABLE `tbl_gf_allow_ips` (`Id` int(11) NOT NULL,`IP` varchar(250) CHARACTER SET utf8 DEFAULT NULL,`UserId` int(11) DEFAULT NULL,`Comments` text,`DtTm` datetime DEFAULT NULL) ENGINE=MyISAM DEFAULT CHARSET=latin1;",
	"CREATE TABLE `tbl_gf_brands` (`brand_id` int(11) NOT NULL,`brand_title` varchar(250) NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=latin1;",
	"CREATE TABLE `tbl_gf_brand_models` (`model_id` int(11) NOT NULL,`model_title` varchar(250) NOT NULL,`brand_id` int(11) NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=latin1;",
	"CREATE TABLE `tbl_gf_downloads` (`DownloadId` int(11) NOT NULL,`Title` varchar(100) DEFAULT NULL,`FileURL` varchar(255) DEFAULT NULL,`DisableDownload` tinyint(1) DEFAULT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_fcm_tokens` (`id` int(11) NOT NULL,`user_id` int(11) NOT NULL,`token` varchar(500) NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=latin1;",
	"CREATE TABLE `tbl_gf_labels` (`id` int(11) NOT NULL,`label_name` varchar(250) CHARACTER SET utf8 NOT NULL,`label_value` varchar(250) CHARACTER SET utf8 NOT NULL,`translation` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,`lang` varchar(250) CHARACTER SET utf8 NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;",
	"CREATE TABLE `tbl_gf_labels_translate` (`id` int(11) NOT NULL,`label_name` varchar(250) CHARACTER SET utf8 NOT NULL,`label_value` varchar(250) CHARACTER SET utf8 NOT NULL,`translation` varchar(20) CHARACTER SET utf8 NOT NULL,`lang` varchar(250) CHARACTER SET utf8 NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;",
	"CREATE TABLE `tbl_gf_push_notifications` (`Id` int(11) NOT NULL,`UserId` int(11) NOT NULL,`Text` varchar(500) DEFAULT NULL,`Link` varchar(500) DEFAULT NULL,`IsRead` tinyint(1) NOT NULL DEFAULT '0',`CreatedAt` datetime NOT NULL DEFAULT now()) ENGINE=InnoDB DEFAULT CHARSET=latin1;",
	"CREATE TABLE `tbl_gf_tbl_addresses` (`id` int(10) NOT NULL,`user_id` int(5) NOT NULL,`pincode` varchar(10) NOT NULL,`building_name` varchar(100) NOT NULL,`road_area_colony` text NOT NULL,`city` varchar(100) NOT NULL,`district` varchar(100) NOT NULL,`state` varchar(100) NOT NULL,`landmark` varchar(100) NOT NULL,`name` varchar(100) NOT NULL,`email` varchar(100) NOT NULL,`mobile_no` varchar(12) NOT NULL,`alter_mobile_no` varchar(12) NOT NULL,`address_type` varchar(30) NOT NULL,`is_default` varchar(10) NOT NULL DEFAULT 'false',`created_at` varchar(150) NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_tbl_bank_details` (`id` int(10) NOT NULL,`user_id` int(10) NOT NULL,`bank_holder_name` varchar(150) NOT NULL,`bank_holder_phone` varchar(20) NOT NULL,`bank_holder_email` varchar(150) NOT NULL,`account_no` varchar(100) NOT NULL,`account_type` varchar(50) NOT NULL,`bank_ifsc` varchar(20) NOT NULL,`bank_name` varchar(150) NOT NULL,`is_default` int(1) NOT NULL DEFAULT '0',`created_at` varchar(255) NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_tbl_brands` (`id` int(10) NOT NULL,`category_id` text NOT NULL,`brand_name` varchar(150) NOT NULL,`brand_slug` varchar(150) NOT NULL,`brand_image` text NOT NULL,`created_at` varchar(150) NOT NULL,`status` int(1) NOT NULL DEFAULT '1') ENGINE=InnoDB DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_tbl_cart` (`id` int(10) NOT NULL,`product_id` int(10) NOT NULL,`user_id` int(10) NOT NULL,`product_qty` int(5) NOT NULL DEFAULT '1',`product_size` varchar(10) NOT NULL DEFAULT '0',`created_at` varchar(150) NOT NULL,`last_update` varchar(150) NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_tbl_cart_tmp` (`id` int(10) NOT NULL,`product_id` int(10) NOT NULL,`user_id` int(10) NOT NULL,`product_qty` int(5) NOT NULL DEFAULT '1',`product_size` varchar(10) NOT NULL DEFAULT '0',`created_at` varchar(150) NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_tbl_category` (`id` int(10) NOT NULL,`category_name` varchar(150) NOT NULL,`category_slug` varchar(150) NOT NULL,`category_image` text NOT NULL,`product_features` longtext NOT NULL,`set_on_home` int(1) NOT NULL DEFAULT '0',`created_at` varchar(150) NOT NULL,`status` int(1) NOT NULL DEFAULT '1') ENGINE=InnoDB DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_tbl_coupon` (`id` int(10) NOT NULL,`coupon_desc` text NOT NULL,`coupon_code` varchar(25) NOT NULL,`coupon_image` text NOT NULL,`coupon_per` int(10) NOT NULL,`coupon_amt` int(10) NOT NULL,`max_amt_status` varchar(5) NOT NULL,`coupon_max_amt` int(10) NOT NULL,`cart_status` varchar(5) NOT NULL,`coupon_cart_min` varchar(10) NOT NULL,`coupon_limit_use` int(10) NOT NULL DEFAULT '1',`created_at` varchar(150) NOT NULL,`status` int(1) NOT NULL DEFAULT '1') ENGINE=InnoDB DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_tbl_offers` (`id` int(10) NOT NULL,`offer_title` varchar(150) NOT NULL,`offer_slug` varchar(150) NOT NULL,`offer_desc` longtext NOT NULL,`offer_percentage` int(10) NOT NULL,`offer_image` text NOT NULL,`created_at` varchar(150) NOT NULL,`status` int(1) NOT NULL DEFAULT '1') ENGINE=InnoDB DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_tbl_order_details` (`id` int(10) NOT NULL,`user_id` int(10) NOT NULL,`coupon_id` int(5) NOT NULL DEFAULT '0',`order_unique_id` text NOT NULL,`order_address` int(5) NOT NULL,`total_amt` double NOT NULL,`discount` varchar(10) DEFAULT '0',`discount_amt` double NOT NULL,`payable_amt` double NOT NULL,`new_payable_amt` double NOT NULL,`refund_amt` double NOT NULL DEFAULT '0',`refund_per` double NOT NULL DEFAULT '0',`order_date` varchar(150) NOT NULL,`delivery_date` varchar(150) NOT NULL,`order_status` int(2) NOT NULL DEFAULT '-1',`delivery_charge` varchar(5) NOT NULL DEFAULT '0',`is_seen` int(1) NOT NULL DEFAULT '0') ENGINE=InnoDB DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_tbl_order_items` (`id` int(10) NOT NULL,`order_id` int(10) NOT NULL,`user_id` int(10) NOT NULL,`product_id` int(10) NOT NULL,`product_title` varchar(150) NOT NULL,`product_qty` int(5) NOT NULL,`product_price` double NOT NULL,`product_size` varchar(10) NOT NULL,`total_price` double NOT NULL,`pro_order_status` int(3) NOT NULL DEFAULT '-1') ENGINE=InnoDB DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_tbl_order_status` (`id` int(20) NOT NULL,`order_id` int(10) NOT NULL,`user_id` int(10) NOT NULL,`product_id` int(10) NOT NULL,`status_title` varchar(100) NOT NULL,`status_desc` text NOT NULL,`created_at` varchar(150) NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_tbl_product` (`id` int(10) NOT NULL,`category_id` int(5) NOT NULL,`sub_category_id` int(5) NOT NULL,`brand_id` int(11) NOT NULL,`offer_id` int(10) NOT NULL DEFAULT '0',`product_title` varchar(255) NOT NULL,`product_slug` varchar(150) NOT NULL,`product_desc` longtext NOT NULL,`product_features` longtext NOT NULL,`featured_image` text NOT NULL,`featured_image2` text NOT NULL,`size_chart` text NOT NULL,`product_mrp` double NOT NULL,`selling_price` double NOT NULL DEFAULT '0',`you_save_amt` double NOT NULL DEFAULT '0',`you_save_per` double NOT NULL DEFAULT '0',`other_color_product` text NOT NULL,`color` varchar(100) NOT NULL,`product_size` text NOT NULL,`product_quantity` int(5) NOT NULL DEFAULT '1',`max_unit_buy` int(5) NOT NULL DEFAULT '1',`delivery_charge` float NOT NULL,`total_views` varchar(10) NOT NULL DEFAULT '0',`total_rate` int(10) NOT NULL DEFAULT '0',`rate_avg` double NOT NULL DEFAULT '0',`is_featured` int(1) DEFAULT '0',`today_deal` int(2) NOT NULL DEFAULT '0',`today_deal_date` varchar(150) NOT NULL DEFAULT '0',`total_sale` int(10) NOT NULL DEFAULT '0',`created_at` varchar(150) NOT NULL,`status` int(1) NOT NULL DEFAULT '1',`deleted` int(11) NOT NULL DEFAULT '0') ENGINE=InnoDB DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_tbl_product_images` (`id` int(10) NOT NULL,`parent_id` int(10) NOT NULL,`image_file` text NOT NULL,`type` varchar(60) NOT NULL,`status` int(1) NOT NULL DEFAULT '1') ENGINE=InnoDB DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_tbl_rating` (`id` int(10) NOT NULL,`product_id` int(10) NOT NULL,`user_id` int(10) NOT NULL,`order_id` int(10) NOT NULL DEFAULT '0',`rating` double NOT NULL,`rating_desc` longtext NOT NULL,`created_at` varchar(150) NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_tbl_status_title` (`id` int(5) NOT NULL,`title` varchar(100) NOT NULL,`status` int(1) NOT NULL DEFAULT '1') ENGINE=InnoDB DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_tbl_sub_category` (`id` int(11) NOT NULL,`category_id` int(10) NOT NULL,`sub_category_name` varchar(150) NOT NULL,`sub_category_slug` varchar(150) NOT NULL,`sub_category_image` text NOT NULL,`created_at` varchar(150) NOT NULL,`show_on_off` int(1) NOT NULL DEFAULT '0',`status` int(1) NOT NULL DEFAULT '1') ENGINE=InnoDB DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_tbl_transaction` (`id` int(11) NOT NULL,`user_id` int(11) NOT NULL,`email` varchar(100) NOT NULL,`order_id` int(11) NOT NULL,`order_unique_id` text NOT NULL,`gateway` varchar(30) NOT NULL,`payment_amt` varchar(50) NOT NULL,`payment_id` varchar(255) NOT NULL,`date` varchar(150) NOT NULL,`status` int(2) NOT NULL DEFAULT '0') ENGINE=InnoDB DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_tbl_wishlist` (`id` int(10) NOT NULL,`user_id` int(10) NOT NULL,`product_id` int(10) NOT NULL,`created_at` varchar(150) NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8;",
	"CREATE TABLE `tbl_gf_api_custom_fields` (`Id` int(11) NOT NULL,`ApiId` int(11) DEFAULT NULL,`ServiceId` int(11) DEFAULT NULL,`PackId` int(11) DEFAULT NULL,`PackType` int(11) DEFAULT NULL,`FieldLabel` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,`FieldName` varchar(255) CHARACTER SET latin1 DEFAULT NULL,`FieldType` varchar(255) CHARACTER SET latin1 DEFAULT NULL,`MinQnt` int(11) DEFAULT NULL,`MaxQnt` int(11) DEFAULT NULL,`UserCreated` tinyint(1) DEFAULT '0',`Bulk` tinyint(1) DEFAULT '0',`MinLen` int(11) DEFAULT NULL,`MaxLen` int(11) DEFAULT NULL,`IsCustomIMEI` tinyint(1) DEFAULT '0',`AllowDigits` tinyint(1) DEFAULT '0',`AllowSmallAlphabets` tinyint(1) DEFAULT '0',`AllowCapitalAlphabets` tinyint(1) DEFAULT '0',`Description` varchar(255) CHARACTER SET latin1 DEFAULT NULL,`CustomField` tinyint(1) DEFAULT '0',`UseAsQuantity` tinyint(1) DEFAULT '0',`UseAsIMEI` tinyint(4) DEFAULT '0',`IsDeleted` tinyint(1) DEFAULT '0',`FieldOptions` varchar(255) CHARACTER SET latin1 DEFAULT NULL,`Required` tinyint(1) DEFAULT NULL,`CreatedAt` datetime DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;",
	"CREATE TABLE `tbl_gf_order_fields` (`Id` int(11) NOT NULL,`OrderId` int(11) DEFAULT NULL,`OrderType` tinyint(1) DEFAULT NULL,`ApiFieldId` int(11) DEFAULT NULL,`FieldValue` text) ENGINE=MyISAM DEFAULT CHARSET=latin1;",
	"CREATE TABLE IF NOT EXISTS `tbl_gf_client_menu` ( `id` int(11) NOT NULL, `dashboard` varchar(100) DEFAULT NULL, `ordernow` varchar(100) DEFAULT NULL, `imeiservices` varchar(100) DEFAULT NULL, `fileservices` varchar(100) DEFAULT NULL, `serverservices` varchar(100) DEFAULT NULL, `orderhistory` varchar(100) DEFAULT NULL, `imeiorders` varchar(100) DEFAULT NULL, `fileorders` varchar(100) DEFAULT NULL, `serverorders` varchar(100) DEFAULT NULL, `tickets` varchar(100) DEFAULT NULL, `submitticket` varchar(100) DEFAULT NULL, `mytickets` varchar(100) DEFAULT NULL, `invoices` varchar(100) DEFAULT NULL, `clientinvoices` varchar(100) DEFAULT NULL, `admininvoices` varchar(100) DEFAULT NULL, `addcredits` varchar(100) DEFAULT NULL, `myprofile` varchar(100) DEFAULT NULL, `changepassword` varchar(100) DEFAULT NULL, `loginhistory` varchar(100) DEFAULT NULL, `transfercredits` varchar(100) DEFAULT NULL, `thresholdamount` varchar(100) DEFAULT NULL, `mystatement` varchar(100) DEFAULT NULL, `productsandservices` varchar(100) DEFAULT NULL, `downloads` varchar(100) DEFAULT NULL, `logout` varchar(100) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;",
	"CREATE TABLE `tbl_gf_user_news_popup_opened` ( `Id` INT(11) NOT NULL AUTO_INCREMENT , `UserId` INT(11) NULL , `CreatedAt` DATETIME NULL DEFAULT NULL , PRIMARY KEY (`Id`)) ENGINE = InnoDB;",
	
	"ALTER TABLE `tbl_gf_allow_ips` ADD PRIMARY KEY (`Id`);",
	"ALTER TABLE `tbl_gf_brands` ADD PRIMARY KEY (`brand_id`);",
	"ALTER TABLE `tbl_gf_brand_models` ADD PRIMARY KEY (`model_id`);",
	"ALTER TABLE `tbl_gf_downloads` ADD PRIMARY KEY (`DownloadId`);",
	"ALTER TABLE `tbl_gf_fcm_tokens` ADD PRIMARY KEY (`id`);",
	"ALTER TABLE `tbl_gf_labels` ADD PRIMARY KEY (`id`);",
	"ALTER TABLE `tbl_gf_labels_translate` ADD PRIMARY KEY (`id`);",
	"ALTER TABLE `tbl_gf_push_notifications` ADD PRIMARY KEY (`Id`),ADD KEY `UserId` (`UserId`);",
	"ALTER TABLE `tbl_gf_tbl_addresses` ADD PRIMARY KEY (`id`);",
	"ALTER TABLE `tbl_gf_tbl_bank_details` ADD PRIMARY KEY (`id`);",
	"ALTER TABLE `tbl_gf_tbl_brands` ADD PRIMARY KEY (`id`);",
	"ALTER TABLE `tbl_gf_tbl_cart` ADD PRIMARY KEY (`id`);",
	"ALTER TABLE `tbl_gf_tbl_cart_tmp` ADD PRIMARY KEY (`id`);",
	"ALTER TABLE `tbl_gf_tbl_category` ADD PRIMARY KEY (`id`);",
	"ALTER TABLE `tbl_gf_tbl_coupon` ADD PRIMARY KEY (`id`);",
	"ALTER TABLE `tbl_gf_tbl_offers` ADD PRIMARY KEY (`id`);",
	"ALTER TABLE `tbl_gf_tbl_order_details` ADD PRIMARY KEY (`id`);",
	"ALTER TABLE `tbl_gf_tbl_order_items` ADD PRIMARY KEY (`id`);",
	"ALTER TABLE `tbl_gf_tbl_order_status` ADD PRIMARY KEY (`id`);",
	"ALTER TABLE `tbl_gf_tbl_product` ADD PRIMARY KEY (`id`);",
	"ALTER TABLE `tbl_gf_tbl_product_images` ADD PRIMARY KEY (`id`);",
	"ALTER TABLE `tbl_gf_tbl_rating` ADD PRIMARY KEY (`id`);",
	"ALTER TABLE `tbl_gf_tbl_status_title` ADD PRIMARY KEY (`id`);",
	"ALTER TABLE `tbl_gf_tbl_sub_category` ADD PRIMARY KEY (`id`);",
	"ALTER TABLE `tbl_gf_tbl_transaction` ADD PRIMARY KEY (`id`);",
	"ALTER TABLE `tbl_gf_tbl_wishlist` ADD PRIMARY KEY (`id`);",
	"ALTER TABLE `tbl_gf_api_custom_fields` ADD PRIMARY KEY (`Id`);",
	"ALTER TABLE `tbl_gf_order_fields` ADD PRIMARY KEY (`Id`);",
	"ALTER TABLE `tbl_gf_client_menu` ADD PRIMARY KEY (`id`);",
	
	"ALTER TABLE `tbl_gf_allow_ips` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT;",
	"ALTER TABLE `tbl_gf_brands` MODIFY `brand_id` int(11) NOT NULL AUTO_INCREMENT;",
	"ALTER TABLE `tbl_gf_brand_models` MODIFY `model_id` int(11) NOT NULL AUTO_INCREMENT;",
	"ALTER TABLE `tbl_gf_downloads` MODIFY `DownloadId` int(11) NOT NULL AUTO_INCREMENT;",
	"ALTER TABLE `tbl_gf_fcm_tokens` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;",
	"ALTER TABLE `tbl_gf_labels` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;",
	"ALTER TABLE `tbl_gf_labels_translate` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;",
	"ALTER TABLE `tbl_gf_push_notifications` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT;",
	"ALTER TABLE `tbl_gf_tbl_addresses` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;",
	"ALTER TABLE `tbl_gf_tbl_bank_details` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;",
	"ALTER TABLE `tbl_gf_tbl_brands` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;",
	"ALTER TABLE `tbl_gf_tbl_cart` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;",
	"ALTER TABLE `tbl_gf_tbl_cart_tmp` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;",
	"ALTER TABLE `tbl_gf_tbl_category` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;",
	"ALTER TABLE `tbl_gf_tbl_coupon` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;",
	"ALTER TABLE `tbl_gf_tbl_offers` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;",
	"ALTER TABLE `tbl_gf_tbl_order_details` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;",
	"ALTER TABLE `tbl_gf_tbl_order_items` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;",
	"ALTER TABLE `tbl_gf_tbl_order_status` MODIFY `id` int(20) NOT NULL AUTO_INCREMENT;",
	"ALTER TABLE `tbl_gf_tbl_product` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;",
	"ALTER TABLE `tbl_gf_tbl_product_images` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;",
	"ALTER TABLE `tbl_gf_tbl_rating` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;",
	"ALTER TABLE `tbl_gf_tbl_status_title` MODIFY `id` int(5) NOT NULL AUTO_INCREMENT;",
	"ALTER TABLE `tbl_gf_tbl_sub_category` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;",
	"ALTER TABLE `tbl_gf_tbl_transaction` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;",
	"ALTER TABLE `tbl_gf_tbl_wishlist` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;",
	"ALTER TABLE `tbl_gf_api_custom_fields` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT;",
	"ALTER TABLE `tbl_gf_order_fields`MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT;",
	
	"ALTER TABLE `tbl_gf_category` CHANGE `OrderBy` `OrderBy` INT(4) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_category` CHANGE `HTMLTitle` `HTMLTitle` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_category` CHANGE `SEOURLName` `SEOURLName` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_category` CHANGE `MetaKW` `MetaKW` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_category` CHANGE `MetaTags` `MetaTags` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_codes` ADD `bulkIMEINo` VARCHAR(555) NOT NULL;",
	"ALTER TABLE `tbl_gf_codes` ADD `csutomIMEINo` VARCHAR(555) NOT NULL;",
	"ALTER TABLE `tbl_gf_codes` CHANGE `CodeSentToOtherServer` `CodeSentToOtherServer` TINYINT(4) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_codes` CHANGE `OrderAPIKey` `OrderAPIKey` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_codes_slbf` ADD `FileName` VARCHAR(500) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_codes_slbf` CHANGE `OrderAPIKey` `OrderAPIKey` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_credit_history` ADD `InvoiceId` INT(11) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_custom_fields` ADD `description` VARCHAR(1000) NOT NULL;",
	"ALTER TABLE `tbl_gf_custom_fields` ADD `fieldOptions` VARCHAR(1000) NOT NULL;",
	"ALTER TABLE `tbl_gf_custom_fields` ADD `serviceId` INT(11) NOT NULL;",
	"ALTER TABLE `tbl_gf_email_settings` CHANGE `CanAddNewAPI` `CanAddNewAPI` TINYINT(4) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_email_settings` CHANGE `Brnd` `Brnd` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'GSM Tool|www.gsmtool.net';",
	"ALTER TABLE `tbl_gf_email_settings` CHANGE `EncKeyLen` `EncKeyLen` VARCHAR(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '22';",
	"ALTER TABLE `tbl_gf_email_settings` ADD `ForcedGoogleAuth` TINYINT(1) NOT NULL DEFAULT '1';",
	"ALTER TABLE `tbl_gf_email_settings` ADD `PwdUpdated` TINYINT(1) NOT NULL DEFAULT '0';",
	"ALTER TABLE `tbl_gf_email_settings` ADD `MobileApp` TINYINT(1) NOT NULL DEFAULT '0';",
	"ALTER TABLE `tbl_gf_email_settings` ADD `ContactUsEmail` VARCHAR(50) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_forms` ADD `FormUrlNew` VARCHAR(255) NOT NULL;",
	"ALTER TABLE `tbl_gf_log_packages` CHANGE `SuccessTplSubject` `SuccessTplSubject` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_log_packages` ADD `OrderVerifyUnit` VARCHAR(250) NOT NULL;",
	"ALTER TABLE `tbl_gf_log_packages` ADD `TOCs` TINYINT(1) NOT NULL DEFAULT '0';",
	"ALTER TABLE `tbl_gf_log_packages` ADD `OrderCancelUnit` VARCHAR(255) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_log_packages` ADD `chkCnvrtPrice` INT(2) NULL DEFAULT '0';",
	"ALTER TABLE `tbl_gf_log_packages` ADD `allowQty` INT(2) NOT NULL DEFAULT '0';",
	"ALTER TABLE `tbl_gf_log_packages` ADD `qntyDropDown` VARCHAR(250) NOT NULL;",
	"ALTER TABLE `tbl_gf_log_packages` ADD `minQnty` INT(10) NOT NULL;",
	"ALTER TABLE `tbl_gf_log_packages` ADD `maxQnty` INT(10) NOT NULL;",
	"ALTER TABLE `tbl_gf_log_requests` CHANGE `OrderAPIKey` `OrderAPIKey` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_log_requests` ADD `CheckDuplication` TINYINT(1) NOT NULL DEFAULT '1';",
	"ALTER TABLE `tbl_gf_log_requests` CHANGE `OrderPlcdFrm` `OrderPlcdFrm` VARCHAR(250) NOT NULL;",
	"ALTER TABLE `tbl_gf_packages` CHANGE `PackageTitle` `PackageTitle` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_packages` CHANGE `IMEIFieldType` `IMEIFieldType` VARCHAR(100) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_packages` ADD `bulkIMEIFieldType` TINYINT(10) NOT NULL;",
	"ALTER TABLE `tbl_gf_packages` ADD `customIMEIFieldType` TINYINT(10) NOT NULL;",
	"ALTER TABLE `tbl_gf_packages` CHANGE `SuccessTplSubject` `SuccessTplSubject` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_packages` ADD `RetailService` TINYINT(1) NOT NULL DEFAULT '0';",
	"ALTER TABLE `tbl_gf_packages` ADD `RetailPrice` FLOAT NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_packages` ADD `RetailServiceTitle` VARCHAR(100) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_packages` ADD `RetailDelTime` VARCHAR(100) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_packages` ADD `RetailMustRead` TEXT NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_packages` ADD `RetailThumbnail` VARCHAR(100) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_packages` ADD `OrderCancelUnit` VARCHAR(255) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_packages` ADD `OrderVerifyUnit` VARCHAR(250) NULL DEFAULT NULL",
	"ALTER TABLE `tbl_gf_packages` ADD `imei_custom_name` VARCHAR(255) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_packages` ADD `imei_custom_length` INT(10) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_packages` ADD `imei_custom_max_length` VARCHAR(255) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_packages` ADD `imei_custom_information` VARCHAR(255) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_packages` ADD `imei_allow_alphabit` INT(10) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_packages` ADD `imei_allow_digits` INT(11) NULL DEFAULT '0';",
	"ALTER TABLE `tbl_gf_packages` ADD `imei_capital_alphabets` INT(11) NULL DEFAULT '0';",
	"ALTER TABLE `tbl_gf_packages` ADD `imei_small_alphabets` INT(11) NULL DEFAULT '0';",
	"ALTER TABLE `tbl_gf_packages` ADD `chkCnvrtPrice` INT(2) NULL DEFAULT '0';",
	"ALTER TABLE `tbl_gf_packages` ADD `chkFetchCPr` INT(2) NULL DEFAULT '0';",
	"ALTER TABLE `tbl_gf_payment_methods` CHANGE `PaymentMethod` `PaymentMethod` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_payment_methods` CHANGE `MassPaymentTime` `MassPaymentTime` TINYINT(1) NULL DEFAULT '0';",
	"ALTER TABLE `tbl_gf_plans_prices_email` CHANGE `PlanId` `PlanId` VARCHAR(11) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL;",
	"ALTER TABLE `tbl_gf_pp_receivers` CHANGE `MassPaymentTime` `MassPaymentTime` TINYINT(1) NULL DEFAULT '0';",
	"ALTER TABLE `tbl_gf_precodes` ADD `Addedat` VARCHAR(250) NOT NULL;",
	"ALTER TABLE `tbl_gf_retail_orders` ADD `Mep` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_retail_orders` ADD `Model` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_retail_orders` ADD `SerialNo` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_retail_orders` ADD `ServiceId` VARCHAR(50) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_retail_orders` ADD `ProviderId` VARCHAR(50) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_retail_orders` ADD `OperatorId` VARCHAR(50) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_retail_orders` ADD `PRD` VARCHAR(50) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_retail_orders` ADD `PIN` VARCHAR(50) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_retail_orders` ADD `KBH` VARCHAR(50) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_retail_orders` ADD `OtherId` VARCHAR(50) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_retail_orders` ADD `OtherValue` VARCHAR(50) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_retail_orders` ADD `ZTE` VARCHAR(50) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_retail_orders` ADD `MType` VARCHAR(50) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_retail_orders` ADD `Network` VARCHAR(50) NULL DEFAULT NULL, ADD `Locks` VARCHAR(50) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_retail_orders` CHANGE `OrderAPIKey` `OrderAPIKey` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_retail_payments` ADD `OrderNoAtMerchant` INT(11) NULL DEFAULT '0';",
	"ALTER TABLE `tbl_gf_retail_services` ADD `AltAPIId` INT(11) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_retail_services` ADD `bulkIMEIFieldType` TINYINT(10) NOT NULL;",
	"ALTER TABLE `tbl_gf_retail_services` ADD `customIMEIFieldType` TINYINT(10) NOT NULL;",
	"ALTER TABLE `tbl_gf_retail_services` ADD `RetailType` TINYINT(1) NOT NULL DEFAULT '0';",
	"ALTER TABLE `tbl_gf_retail_services` ADD `SendSMS` TINYINT(1) NULL DEFAULT '0';",
	"ALTER TABLE `tbl_gf_retail_services` ADD `imei_custom_name` VARCHAR(250) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_retail_services` ADD `imei_custom_length` INT(10) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_retail_services` ADD `imei_custom_max_length` VARCHAR(255) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_retail_services` ADD `imei_custom_information` VARCHAR(250) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_retail_services` ADD `imei_allow_alphabit` INT(11) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_retail_services` ADD `imei_allow_digits` INT(11) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_retail_services` ADD `imei_capital_alphabets` INT(11) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_retail_services` ADD `imei_small_alphabets` INT(11) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_supplier_services` CHANGE `ServiceId` `ServiceId` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_supplier_services` CHANGE `ServiceTime` `ServiceTime` VARCHAR(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_tckt_dept` ADD `categories` VARCHAR(250) NOT NULL;",
	"ALTER TABLE `tbl_gf_tckt_dept` CHANGE `DeptDescription` `DeptDescription` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL;",
	"ALTER TABLE `tbl_gf_tickets` CHANGE `TicketNo` `TicketNo` VARCHAR(8) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_tickets` ADD `order_id` VARCHAR(11) NOT NULL;",
	"ALTER TABLE `tbl_gf_tickets` CHANGE `Name` `Name` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL;",
	"ALTER TABLE `tbl_gf_tickets` CHANGE `Subject` `Subject` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL;",
	"ALTER TABLE `tbl_gf_tickets` ADD `invoice_id` VARCHAR(100) NOT NULL;",
	"ALTER TABLE `tbl_gf_tickets` ADD `payment_id` VARCHAR(100) NOT NULL;",
	"ALTER TABLE `tbl_gf_users` ADD `CycleTime` INT(11) NOT NULL DEFAULT '0';",
	"ALTER TABLE `tbl_gf_users` ADD `MaxReqPerCycle` INT(11) NOT NULL DEFAULT '0';",
	"ALTER TABLE `tbl_gf_users` ADD `BlockReqTime` INT(11) NOT NULL DEFAULT '0';",
	"ALTER TABLE `tbl_gf_users` ADD `ApiCycleStatus` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '0 = inactive, 1 = active';",
	"ALTER TABLE `tbl_gf_users` ADD `AllowCycleIPs` TEXT NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_users` ADD `picture` VARCHAR(255) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_users` CHANGE `CanLoginFrmOtherCntry` `CanLoginFrmOtherCntry` TINYINT(1) NULL DEFAULT '1';",
	"ALTER TABLE `tbl_gf_users` ADD `payment_hide_comment` VARCHAR(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_users` ADD `remPmntMthd` INT(2) NOT NULL DEFAULT '0';",
	"ALTER TABLE `tbl_gf_users` CHANGE `CPanel` `CPanel` INT(1) NULL DEFAULT '0';",
	"ALTER TABLE `tbl_gf_user_news_popup` ADD `NewsTitle` VARCHAR(250) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_user_news_popup` ADD `AddedAt` TIMESTAMP NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_tckt_category` ADD `DisableEdit` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '0 = can be edit, 1 = cannot be edit';",
	"ALTER TABLE `tbl_gf_tckt_dept` ADD `DisableEdit` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '0 = can be edit, 1 = cannot be edit';",
	"ALTER TABLE `tbl_gf_log_requests` ADD `Day` VARCHAR(10) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_log_requests` ADD `Month` VARCHAR(10) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_log_requests` ADD `Year` VARCHAR(10) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_codes` ADD `Day` VARCHAR(10) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_codes` ADD `Month` VARCHAR(10) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_codes` ADD `Year` VARCHAR(10) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_codes_slbf` ADD `Day` VARCHAR(10) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_codes_slbf` ADD `Month` VARCHAR(10) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_codes_slbf` ADD `Year` VARCHAR(10) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_retail_orders` ADD `Day` VARCHAR(10) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_retail_orders` ADD `Month` VARCHAR(10) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_retail_orders` ADD `Year` VARCHAR(10) NULL DEFAULT NULL;",

"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/dashboard' WHERE `FormURL` = 'dashboard.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'package.php' WHERE `FormURL` = 'package.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/category/add' WHERE `FormURL` = 'categories.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/services' WHERE `FormURL` = 'services.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/quickpricing' WHERE `FormURL` = 'quickpricing.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/customfields' WHERE `FormURL` = 'customfields.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/ipserverorders' WHERE `FormURL` = 'ipserverorders.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/smsintegration' WHERE `FormURL` = 'smsintegration.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'services_quickedit.php' WHERE `FormURL` = 'services_quickedit.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'services_quickedit.php' WHERE `FormURL` = 'services_quickedit.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/services?fs=1' WHERE `FormURL` = 'services.php?fs=1';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/quickpricing?srvc=1' WHERE `FormURL` = 'quickpricing.php?srvc=1';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/smsintegration?type=1' WHERE `FormURL` = 'smsintegration.php?type=1';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'services_quickedit.php' WHERE `FormURL` = 'services_quickedit.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'category.php' WHERE `FormURL` = 'category.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/serverservices' WHERE `FormURL` = 'serverservices.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/quickpricing?srvc=2' WHERE `FormURL` = 'quickpricing.php?srvc=2';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/customfields?sc=2' WHERE `FormURL` = 'customfields.php?sc=2';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/smsintegration?type=2' WHERE `FormURL` = 'smsintegration.php?type=2';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/clients/user' WHERE `FormURL` = 'user.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/clients/users' WHERE `FormURL` = 'users.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/clients/newspopup' WHERE `FormURL` = 'newspopup.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/clients/clientgroup' WHERE `FormURL` = 'clientgroup.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/clients/clientgroups' WHERE `FormURL` = 'clientgroups.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/clients/resetpasswords' WHERE `FormURL` = 'resetpasswords.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/clients/resetpins' WHERE `FormURL` = 'resetpins.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/smsintegration?type=3' WHERE `FormURL` = 'smsintegration.php?type=3';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/system/subadmin' WHERE `FormURL` = 'subadmin.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/system/subadmins' WHERE `FormURL` = 'subadmins.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/system/adminrole' WHERE `FormURL` = 'adminrole.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/system/adminroles' WHERE `FormURL` = 'adminroles.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/clients/payments' WHERE `FormURL` = 'payments.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/Settings/viewlookuplist?iFrm=7' WHERE `FormURL` = 'viewlookuplist.php?iFrm=7';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/sales/paymentmethods' WHERE `FormURL` = 'paymentmethods.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/cms/reviews' WHERE `FormURL` = 'reviews.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/cms/logos' WHERE `FormURL` = 'logos.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/cms/banners' WHERE `FormURL` = 'banners.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/cms/socialmedialinks' WHERE `FormURL` = 'socialmedialinks.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/cms/pages' WHERE `FormURL` = 'pages.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/Settings/allowips' WHERE `FormURL` = 'allowips.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/template/emailtpls' WHERE `FormURL` = 'emailtpls.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/hideservices?sc=2' WHERE `FormURL` = 'hideservices.php?sc=2';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/smsgateway/smsgateways' WHERE `FormURL` = 'smsgateways.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/chat/livechat' WHERE `FormURL` = 'livechat.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/tickets/tickets' WHERE `FormURL` = 'tickets.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/tickets/departments' WHERE `FormURL` = 'departments.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/Settings/viewlookuplist?iFrm=15' WHERE `FormURL` = 'viewlookuplist.php?iFrm=15';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/Settings/viewlookuplist?iFrm=14' WHERE `FormURL` = 'viewlookuplist.php?iFrm=14';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/Settings/viewlookuplist?iFrm=9' WHERE `FormURL` = 'viewlookuplist.php?iFrm=9';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/Settings/settings' WHERE `FormURL` = 'settings.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/Settings/apis' WHERE `FormURL` = 'apis.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/Settings/regfields' WHERE `FormURL` = 'regfields.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/Settings/viewlookuplist?iFrm=3' WHERE `FormURL` = 'viewlookuplist.php?iFrm=3';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/Settings/maintenance' WHERE `FormURL` = 'maintenance.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/Settings/convertprices' WHERE `FormURL` = 'convertprices.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/Settings/currencies' WHERE `FormURL` = 'currencies.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/miscellaneous/newscats' WHERE `FormURL` = 'newscats.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/miscellaneous/viewnews' WHERE `FormURL` = 'viewnews.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/miscellaneous/viewfaqs' WHERE `FormURL` = 'viewfaqs.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/miscellaneous/knowledgebasecats' WHERE `FormURL` = 'knowledgebasecats.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/miscellaneous/knbasecontents' WHERE `FormURL` = 'knbasecontents.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/miscellaneous/newsltrcats' WHERE `FormURL` = 'newsltrcats.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/miscellaneous/newsletters' WHERE `FormURL` = 'newsletters.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/miscellaneous/sendnewsletter' WHERE `FormURL` = 'sendnewsletter.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/miscellaneous/videos' WHERE `FormURL` = 'videos.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/miscellaneous/flagcounter' WHERE `FormURL` = 'flagcounter.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/miscellaneous/analytics' WHERE `FormURL` = 'analytics.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/miscellaneous/marquee' WHERE `FormURL` = 'marquee.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/Miscellaneous/gsm_fusion_api' WHERE `FormURL` = '../data/api/GSM_Fusion_API.pdf';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/Miscellaneous/apisamplecode' WHERE `FormURL` = '../data/api/apisamplecode.rar';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/miscellaneous/databasebackup' WHERE `FormURL` = 'databasebackup.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/reports/statistics' WHERE `FormURL` = 'statistics.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/reports/apisrpt' WHERE `FormURL` = 'apisrpt.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/reports/profitlossrpt' WHERE `FormURL` = 'profitlossrpt.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'category.php?fs=1' WHERE `FormURL` = 'category.php?fs=1';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/reports/creditsrpt' WHERE `FormURL` = 'creditsrpt.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/reports/clientsbyincomerpt' WHERE `FormURL` = 'clientsbyincomerpt.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/reports/precodeshistory' WHERE `FormURL` = 'precodeshistory.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/reports/creditseatenrpt' WHERE `FormURL` = 'creditseatenrpt.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/reports/creditseatenrpt?sc=1' WHERE `FormURL` = 'creditseatenrpt.php?sc=1';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/reports/creditseatenrpt?sc=2' WHERE `FormURL` = 'creditseatenrpt.php?sc=2';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/reports/admincrlog' WHERE `FormURL` = 'admincrlog.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/reports/clientiplogrpt' WHERE `FormURL` = 'clientiplogrpt.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/reports/iplogrpt' WHERE `FormURL` = 'iplogrpt.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/reports/blockedipsrpt' WHERE `FormURL` = 'blockedipsrpt.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/newimeiorders' WHERE `FormURL` = 'newimeiorders.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/inprocessimeiorders' WHERE `FormURL` = 'inprocessimeiorders.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/codes?codeStatusId=4&pT=2&searchType=3' WHERE `FormURL` = 'codes.php?codeStatusId=4&pT=2&searchType=3';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/codes?bulk=1&searchType=3' WHERE `FormURL` = 'codes.php?bulk=1&searchType=3';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/verifyorders' WHERE `FormURL` = 'verifyorders.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/multilinebulkreply' WHERE `FormURL` = 'multilinebulkreply.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/apiorders' WHERE `FormURL` = 'apiorders.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/newfileorders' WHERE `FormURL` = 'newfileorders.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/codesslbf?codeStatusId=4&searchType=3' WHERE `FormURL` = 'codesslbf.php?codeStatusId=4&searchType=3';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/codesslbf?searchType=3' WHERE `FormURL` = 'codesslbf.php?searchType=3';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/verifyfileorders' WHERE `FormURL` = 'verifyfileorders.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/clients/resetclientprices' WHERE `FormURL` = 'resetclientprices.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/newserverorders' WHERE `FormURL` = 'newserverorders.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/logrequests?codeStatusId=4&searchType=3' WHERE `FormURL` = 'logrequests.php?codeStatusId=4&searchType=3';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/logrequests?searchType=3' WHERE `FormURL` = 'logrequests.php?searchType=3';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/verifyserverorders' WHERE `FormURL` = 'verifyserverorders.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/reports/monthlyordersrpt' WHERE `FormURL` = 'monthlyordersrpt.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/retail/ipretailorders' WHERE `FormURL` = 'ipretailorders.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/retail/newretailorders?type=1' WHERE `FormURL` = 'newretailorders.php?type=1';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/pendingorders?sc=1' WHERE `FormURL` = 'pendingorders.php?sc=1';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/retail/manufacturer' WHERE `FormURL` = 'manufacturer.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/hideservices?sc=1' WHERE `FormURL` = 'hideservices.php?sc=1';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/hideservices?sc=0' WHERE `FormURL` = 'hideservices.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/sales/rinvoices' WHERE `FormURL` = 'rinvoices.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/resetprices' WHERE `FormURL` = 'resetprices.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/resetprices?srvc=1' WHERE `FormURL` = 'resetprices.php?srvc=1';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/resetprices?srvc=2' WHERE `FormURL` = 'resetprices.php?srvc=2';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/clients/emailintegrations' WHERE `FormURL` = 'emailintegrations.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/retail/manufacturers' WHERE `FormURL` = 'manufacturers.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/retail/rtlservice' WHERE `FormURL` = 'rtlservice.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/retail/rtlservices' WHERE `FormURL` = 'rtlservices.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/retail/ipretailorders?type=1' WHERE `FormURL` = 'ipretailorders.php?type=1';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/retail/rtlservices?type=1' WHERE `FormURL` = 'rtlservices.php?type=1';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/retail/rtlservice?type=1' WHERE `FormURL` = 'rtlservice.php?type=1';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/Settings/viewlookuplist?iFrm=21' WHERE `FormURL` = 'viewlookuplist.php?iFrm=21';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'equickpricing.php' WHERE `FormURL` = 'equickpricing.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'products.php' WHERE `FormURL` = 'products.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'product.php' WHERE `FormURL` = 'product.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/category/add?iFrm=2' WHERE `FormURL` = 'categories.php?iFrm=2';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/category' WHERE `FormURL` = 'ecategory.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/Settings/viewlookuplist?iFrm=20' WHERE `FormURL` = 'viewlookuplist.php?iFrm=20';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'eorders.php?statusId=1&searchType=1' WHERE `FormURL` = 'eorders.php?statusId=1&searchType=1';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'eorders.php?statusId=4&searchType=3' WHERE `FormURL` = 'eorders.php?statusId=4&searchType=3';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'eorders.php' WHERE `FormURL` = 'eorders.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'logo.php?id=5' WHERE `FormURL` = 'logo.php?id=5';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'banners.php?type=1' WHERE `FormURL` = 'banners.php?type=1';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'pages.php?type=1' WHERE `FormURL` = 'pages.php?type=1';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/cms/socialmedialinks' WHERE `FormURL` = 'socialmedialinks.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/miscellaneous/viewnews?type=1' WHERE `FormURL` = 'viewnews.php?type=1';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/cms/reviews?type=1' WHERE `FormURL` = 'reviews.php?type=1';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'customers.php' WHERE `FormURL` = 'customers.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/sales/einvoices' WHERE `FormURL` = 'einvoices.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'sortproducts.php' WHERE `FormURL` = 'sortproducts.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'hcategories.php' WHERE `FormURL` = 'hcategories.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'shippingcountries.php' WHERE `FormURL` = 'shippingcountries.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'code.php' WHERE `FormURL` = 'code.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'codeslbf.php' WHERE `FormURL` = 'codeslbf.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'logrequest.php' WHERE `FormURL` = 'logrequest.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/retail/newretailorders' WHERE `FormURL` = 'newretailorders.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'eorder.php' WHERE `FormURL` = 'eorder.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/category/add?fs=1' WHERE `FormURL` = 'categories.php?fs=1';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'package.php?fs=1' WHERE `FormURL` = 'package.php?fs=1';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'category.php?iFrm=1' WHERE `FormURL` = 'category.php?iFrm=1';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/category/add?iFrm=1' WHERE `FormURL` = 'categories.php?iFrm=1';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'serverservice.php' WHERE `FormURL` = 'serverservice.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/clients/autopayments' WHERE `FormURL` = 'autopayments.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/Settings/cpaneltheme' WHERE `FormURL` = 'cpaneltheme.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/retail/retailorders?codeStatusId=4&pT=2&searchType=3' WHERE `FormURL` = 'retailorders.php?codeStatusId=4&pT=2&searchType=3';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'serverrtlorders.php?codeStatusId=4&pT=2&searchType=3' WHERE `FormURL` = 'serverrtlorders.php?codeStatusId=4&pT=2&searchType=3';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/retail/retailorders?searchType=3' WHERE `FormURL` = 'retailorders.php?searchType=3';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'serverrtlorders.php?searchType=3' WHERE `FormURL` = 'serverrtlorders.php?searchType=3';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/cms/brandlogos' WHERE `FormURL` = 'brandlogos.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/unarchiveservices?sc=0' WHERE `FormURL` = 'unarchiveservices.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/unarchiveservices?sc=1' WHERE `FormURL` = 'unarchiveservices.php?sc=1';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/unarchiveservices?sc=2' WHERE `FormURL` = 'unarchiveservices.php?sc=2';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/clients/unarchiveclients' WHERE `FormURL` = 'unarchiveclients.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/category/add?iFrm=3' WHERE `FormURL` = 'categories.php?iFrm=3';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/reports/eproductvisitors' WHERE `FormURL` = 'eproductvisitors.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'zones.php' WHERE `FormURL` = 'zones.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'shipmethods.php' WHERE `FormURL` = 'shipmethods.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/groupquickpricing' WHERE `FormURL` = 'groupquickpricing.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/groupquickpricing?srvc=1' WHERE `FormURL` = 'groupquickpricing.php?srvc=1';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/groupquickpricing?srvc=2' WHERE `FormURL` = 'groupquickpricing.php?srvc=2';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'updategsmtool.php' WHERE `FormURL` = 'updategsmtool.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'news.php' WHERE `FormURL` = 'news.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/sales/blockpmethods' WHERE `FormURL` = 'blockpmethods.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/clients/user' WHERE `FormURL` = 'user.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/miscellaneous/nlsubscriptions' WHERE `FormURL` = 'nlsubscriptions.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'review.php' WHERE `FormURL` = 'review.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'logo.php' WHERE `FormURL` = 'logo.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'banner.php' WHERE `FormURL` = 'banner.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'socialmedialink.php' WHERE `FormURL` = 'socialmedialink.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'page.php' WHERE `FormURL` = 'page.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'addbrandlogo.php' WHERE `FormURL` = 'addbrandlogo.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/clients/payments' WHERE `FormURL` = 'payments.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/clients/payments' WHERE `FormURL` = 'payments.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/clients/payments' WHERE `FormURL` = 'payments.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/services' WHERE `FormURL` = 'services.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/services' WHERE `FormURL` = 'services.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/serverservices' WHERE `FormURL` = 'serverservices.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'clients.php' WHERE `FormURL` = 'clients.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'overview.php' WHERE `FormURL` = 'overview.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'lgn_a_s_clint.php' WHERE `FormURL` = 'lgn_a_s_clint.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'credithistory.php' WHERE `FormURL` = 'credithistory.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'addcredits.php' WHERE `FormURL` = 'addcredits.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'userapi.php' WHERE `FormURL` = 'userapi.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'faqs.php' WHERE `FormURL` = 'faqs.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'knbasecontent.php' WHERE `FormURL` = 'knbasecontent.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'newsletter.php' WHERE `FormURL` = 'newsletter.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'video.php' WHERE `FormURL` = 'video.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'currency.php' WHERE `FormURL` = 'currency.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'manageapi.php' WHERE `FormURL` = 'manageapi.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'regfield.php' WHERE `FormURL` = 'regfield.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'userpackageprices.php' WHERE `FormURL` = 'userpackageprices.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'resetpackprices.php' WHERE `FormURL` = 'resetpackprices.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'setpcksforusers.php' WHERE `FormURL` = 'setpcksforusers.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'changepassword.php' WHERE `FormURL` = 'changepassword.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'payment.php' WHERE `FormURL` = 'payment.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'importemails.php' WHERE `FormURL` = 'importemails.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'paymentaggregators.php' WHERE `FormURL` = 'paymentaggregators.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'fetch_nck_shops_products.php?clear' WHERE `FormURL` = 'fetch_nck_shops_products.php?clear';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'rptpayments.php' WHERE `FormURL` = 'rptpayments.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'suspiciouspmntsrpt.php' WHERE `FormURL` = 'suspiciouspmntsrpt.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/pendingapiorders' WHERE `FormURL` = 'pendingapiorders.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/miscellaneous/downloads' WHERE `FormURL` = 'downloads.php';",
	"UPDATE `tbl_gf_forms` SET `FormUrlNew`= 'admin/services/brands' WHERE `FormURL` = 'admin/services/brands';",
	"INSERT INTO `tbl_gf_forms` (`FormId`, `Form`, `FormTypeId`, `FormURL`, `IsNew`, `HiddenForm`, `FormUrlNew`) VALUES (NULL, 'Client Menu Settings', '13', 'admin/clients/clientmenu', '0', '0', 'admin/clients/clientmenu');",
	"DELETE FROM `tbl_gf_tckt_category` WHERE `DisableEdit` = 1;",
	"INSERT INTO `tbl_gf_tckt_category` (`TcktCategory`, `DisableTcktCategory`, `DisableEdit`) VALUES('Payments', 0, 1),('Order Verification', 0, 1),('Order Delay', 0, 1),('General Inquiry', 0, 1),('Payment not added', 0, 1);",
	"UPDATE `tbl_gf_log_requests` SET `Day` = DATE_FORMAT(`RequestedAt`, '%d'), `Month` = DATE_FORMAT(`RequestedAt`, '%m'), `Year` = DATE_FORMAT(`RequestedAt`, '%Y');",
	"UPDATE `tbl_gf_codes` SET `Day` = DATE_FORMAT(`RequestedAt`, '%d'), `Month` = DATE_FORMAT(`RequestedAt`, '%m'), `Year` = DATE_FORMAT(`RequestedAt`, '%Y');",
	"UPDATE `tbl_gf_codes_slbf` SET `Day` = DATE_FORMAT(`RequestedAt`, '%d'), `Month` = DATE_FORMAT(`RequestedAt`, '%m'), `Year` = DATE_FORMAT(`RequestedAt`, '%Y');",
	"UPDATE `tbl_gf_retail_orders` SET `Day` = DATE_FORMAT(`RequestedAt`, '%d'), `Month` = DATE_FORMAT(`RequestedAt`, '%m'), `Year` = DATE_FORMAT(`RequestedAt`, '%Y');",
	"ALTER TABLE `tbl_gf_retail_services` ADD `allowQty` INT(2) NULL DEFAULT '0';",
	"ALTER TABLE `tbl_gf_retail_services` ADD `qntyDropDown` VARCHAR(250) NULL;",
	"ALTER TABLE `tbl_gf_retail_services` ADD `minQnty` INT(10) NULL DEFAULT '0';",
	"ALTER TABLE `tbl_gf_retail_services` ADD `maxQnty` INT(10) NULL DEFAULT '0';",
	"ALTER TABLE `tbl_gf_email_settings` ADD `Telegram` VARCHAR(255) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_custom_fields` ADD `ApiFieldId` INT(11) NULL DEFAULT NULL, ADD `ApiFieldName` VARCHAR(255) NULL DEFAULT NULL; ",
	"ALTER TABLE `tbl_gf_api_custom_fields` ADD `MinQnt` INT(11) NULL DEFAULT NULL, ADD `MaxQnt` INT(11) NULL DEFAULT NULL;",
	"ALTER TABLE `tbl_gf_api_custom_fields` ADD `IsDeleted` TINYINT(1) NULL DEFAULT '0'; ",
	"update `tbl_gf_pages` set FileName = null",
	"ALTER TABLE `tbl_gf_users` ADD `PasswordResetAt` DATETIME NULL DEFAULT NULL;",
);

foreach($queries as $query) {
	$CI->db->query($query);
	$error = $CI->db->error();
	if($error && $error['message']) {
		$CI->db->insert('tbl_gf_v2_db_log', ['Query' => $query, 'Error' => $error['message']]);
	}
}

$conn = $CI->db->conn_id;
$packs_single = $conn->query("SELECT `PackageId`, `IMEIFieldType`, `CustomFieldId` FROM `tbl_gf_packages` WHERE `IMEIFieldType` = 1");
while($pack = $packs_single->fetch_object()) { 
	$customFieldData = array(
		'PackId' => (int) $pack->PackageId,
		'PackType' => 0,
		'FieldLabel' => 'IMEI',
        'FieldName' => NULL,
		'FieldType' => 'text',
        'UserCreated' => 1,
        'CustomField' => 1,
		'UseAsIMEI' => 1,
		'Bulk' => 0,
		'IsDeleted' => 0,
		'Required' => 1,
		'CreatedAt' => date('Y-m-d H:i:s'),
	);
	$conn->query("INSERT INTO `tbl_gf_api_custom_fields`(".implode(', ', array_keys($customFieldData)).") VALUES ('".implode("', '", array_values($customFieldData))."')");
}
$packs_both = $conn->query("SELECT `PackageId`, `IMEIFieldType`, `CustomFieldId` FROM `tbl_gf_packages` WHERE `IMEIFieldType` = 0");
while($pack = $packs_both->fetch_object()) {
	$customFieldData = array(
		'PackId' => (int) $pack->PackageId,
		'PackType' => 0,
		'FieldLabel' => 'IMEI',
        'FieldName' => NULL,
		'FieldType' => 'textarea',
        'UserCreated' => 1,
        'CustomField' => 1,
		'UseAsIMEI' => 1,
		'Bulk' => 1,
		'IsDeleted' => 0,
		'Required' => 1,
		'CreatedAt' => date('Y-m-d H:i:s'),
	);
	$conn->query("INSERT INTO `tbl_gf_api_custom_fields`(".implode(', ', array_keys($customFieldData)).") VALUES ('".implode("', '", array_values($customFieldData))."')");
}
$packs_bulk = $conn->query("SELECT `PackageId`, `IMEIFieldType`, `CustomFieldId` FROM `tbl_gf_packages` WHERE `IMEIFieldType` = 2");
while($pack = $packs_bulk->fetch_object()) {
	$customFieldData = array(
		'PackId' => (int) $pack->PackageId,
		'PackType' => 0,
		'FieldLabel' => 'IMEI',
        'FieldName' => NULL,
		'FieldType' => 'textarea',
        'UserCreated' => 1,
        'CustomField' => 1,
		'UseAsIMEI' => 1,
		'Bulk' => 1,
		'IsDeleted' => 0,
		'Required' => 1,
		'CreatedAt' => date('Y-m-d H:i:s'),
	);
	$conn->query("INSERT INTO `tbl_gf_api_custom_fields`(".implode(', ', array_keys($customFieldData)).") VALUES ('".implode("', '", array_values($customFieldData))."')");
}
$packs_custom = $conn->query("SELECT `PackageId`, `IMEIFieldType`, `CustomFieldId` FROM `tbl_gf_packages` WHERE `IMEIFieldType` = 3");
while($pack = $packs_custom->fetch_object()) {
	$field_info = $conn->query("SELECT * FROM `tbl_gf_custom_fields` WHERE `FieldId` = {$pack->CustomFieldId}");
	if($field_info) {
		$field_info = $field_info->fetch_object();
		$customFieldData = array(
			'PackId' => (int) $pack->PackageId,
	        'PackType' => 0,
	        'FieldLabel' => $field_info->FieldLabel,
	        'FieldName' => NULL,
	        'FieldType' => 'text',
	        'UserCreated' => 1,
	        'Bulk' => 0,
	        'MinLen' => ($field_info->MinLength ?: NULL),
	        'MaxLen' => ($field_info->MaxLength ?: NULL),
	        'AllowDigits' => 0,
	        'AllowSmallAlphabets' => 0,
	        'AllowCapitalAlphabets' => 0,
	        'UseAsIMEI' => 1,
	        'Description' => $field_info->FInstructions,
	        'CustomField' => 1,
	        'IsCustomIMEI' => 1,
	        'IsDeleted' => 0,
	        'Required' => 1,
	        'CreatedAt' => date('Y-m-d H:i:s'),
		);
		$conn->query("INSERT INTO `tbl_gf_api_custom_fields`(".implode(', ', array_keys($customFieldData)).") VALUES ('".implode("', '", array_map('addslashes', array_values($customFieldData)))."')");
	}
}

$data = $conn->query("select * from tbl_gf_package_custom_fields");
while($row = $data->fetch_object()) {
    $field = $conn->query("select * from tbl_gf_custom_fields where FieldId = $row->FieldId");
    if($field) {
    	$field = $field->fetch_assoc();
    	if($field) {
	    	$fieldTypes = array(
				'Text Box' => 'text',
				'Drop Down' => 'dropdown',
				'Radio Button' => 'radio',
				'Text Area' => 'textarea',
			);
	    	$customFieldData = array(
	    		'PackId' => $row->PackageId,
	            'PackType' => $row->ServiceType,
	            'FieldLabel' => $field['FieldLabel'],
	            'FieldName' => $field['FieldColName'],
	            'FieldType' => $fieldTypes[$field['FieldType']],
	            'MinQnt' => NULL,
	            'MaxQnt' => NULL,
	            'UserCreated' => 1,
	            'Bulk' => 0,
	            'MinLen' => ($field['MinLength'] ?: NULL),
	            'MaxLen' => ($field['MaxLength'] ?: NULL),
	            'AllowDigits' => 0,
	            'AllowSmallAlphabets' => 0,
	            'AllowCapitalAlphabets' => 0,
	            'UseAsIMEI' => 0,
	            'UseAsQuantity' => (($field['UseAsQuantity'] || $field['FieldColName']=="quantity_G7V7")&& $row->ServiceType == 2 ? 1 : 0),
	            'Description' => ($field['description'] ?: NULL),
	            'CustomField' => 1,
	            'IsCustomIMEI' => 0,
	            'IsDeleted' => 0,
	            'Required' => 1,
	            'CreatedAt' => date('Y-m-d H:i:s'),
	    	);
	    	$conn->query("INSERT INTO `tbl_gf_api_custom_fields`(".implode(', ', array_keys($customFieldData)).") VALUES ('".implode("', '", array_map('addslashes', array_values($customFieldData)))."')");
	    }
    }
}

$conn->query("delete from tbl_gf_tckt_dept where DisableEdit = 1;");
// first dep
$sql1 = "INSERT INTO `tbl_gf_tckt_dept` (`DeptName`, `DeptEmail`, `DeptDescription`, `categories`, `DisableDept`, `DisableEdit`) VALUES ('Payments/Accounts', 'support@yourwebsite.com', 'Any Kind Of Payments Or Account Issue Please Use This Support', '%s', 0, 0);";
$sql1_cats = $conn->query("select * from tbl_gf_tckt_category where DisableEdit = 1 and TcktCategory IN('Payment not added', 'Payments') order by TcktCategoryId desc");
$sql1_cat_ids = array();
while($sql1_cat = $sql1_cats->fetch_object()) {
    $sql1_cat_ids[] = $sql1_cat->TcktCategoryId;
}
$sql1 = sprintf($sql1, implode(',', $sql1_cat_ids));

// second dep
$sql2 = "INSERT INTO `tbl_gf_tckt_dept` (`DeptName`, `DeptEmail`, `DeptDescription`, `categories`, `DisableDept`, `DisableEdit`) VALUES ('Customer Support For Orders', 'order@yourwebsite.com', 'This Section Will Help You To Resolve Issues Regarding Not Unlock issue, Code Not Working or Orders Delay.', '%s', 0, 0);";
$sql2_cats = $conn->query("select * from tbl_gf_tckt_category where DisableEdit = 1 and TcktCategory IN('Order Delay', 'Order Verification') order by TcktCategoryId desc");
$sql2_cat_ids = array();
while($sql2_cat = $sql2_cats->fetch_object()) {
    $sql2_cat_ids[] = $sql2_cat->TcktCategoryId;
}
$sql2 = sprintf($sql2, implode(',', $sql2_cat_ids));

// third dep
$sql3 = "INSERT INTO `tbl_gf_tckt_dept` (`DeptName`, `DeptEmail`, `DeptDescription`, `categories`, `DisableDept`, `DisableEdit`) VALUES ('General Support', 'order@yourwebsite.com', 'For Any Kind Of General Information Contact Here', '%s', 0, 0);";
$sql3_cats = $conn->query("select * from tbl_gf_tckt_category where DisableEdit = 1 and TcktCategory IN('General Inquiry') order by TcktCategoryId desc");
$sql3_cat_ids = array();
while($sql3_cat = $sql3_cats->fetch_object()) {
    $sql3_cat_ids[] = $sql3_cat->TcktCategoryId;
}
$sql3 = sprintf($sql3, implode(',', $sql3_cat_ids));
$conn->query($sql1);
$conn->query($sql2);
$conn->query($sql3);

// updating tbl_gf_forms updating admin with dynamic name
$forms = $conn->query("SELECT * FROM `tbl_gf_forms`");
while($form = $forms->fetch_object()) {
	$url = $form->FormUrlNew;
	$updated_url = str_replace('admin/', $CI->config->item('apanel_name').'/', $url);
	$conn->query("UPDATE `tbl_gf_forms` SET FormUrlNew = '{$updated_url}' WHERE `FormId` = {$form->FormId}");
}