31-10-2013 jay (live done)

CREATE TABLE `alt_benefits` (
  `id` int(10) UNSIGNED NOT NULL,
  `pid` int(10) UNSIGNED NOT NULL,
  `benefits` text NOT NULL,
  `technical_details` text NOT NULL,
  `isDelete` int(11) NOT NULL,
  `isActive` int(11) NOT NULL DEFAULT 1,
  `adate` datetime NOT NULL
)



09-11-2023 Naveen (live done)

ALTER TABLE `alt_benefits` CHANGE `technical_details` `technical_details` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL;

ALTER TABLE `alt_benefits` CHANGE `benefits` `benefits` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL;


10-11-2023 Khushi (live done)

ALTER TABLE `contact_us_info` ADD `insta_link` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL AFTER `twitter_link`;

16-11-2023 Jay (live done)

ALTER TABLE `about_us` ADD `short_title2` TEXT NOT NULL AFTER `image_path3`, ADD `long_title2` TEXT NOT NULL AFTER `short_title2`, ADD `title3` TEXT NOT NULL AFTER `long_title2`, ADD `short_description2` TEXT NOT NULL AFTER `title3`, ADD `long_description2` TEXT NOT NULL AFTER `short_description2`, ADD `short_title3` TEXT NOT NULL AFTER `long_description2`, ADD `long_title3` TEXT NOT NULL AFTER `short_title3`, ADD `short_description3` TEXT NOT NULL AFTER `long_title3`, ADD `long_description3` TEXT NOT NULL AFTER `short_description3`, ADD `title4` TEXT NOT NULL AFTER `long_description3`, ADD `short_title4` TEXT NOT NULL AFTER `title4`, ADD `long_title4` TEXT NOT NULL AFTER `short_title4`, ADD `short_description4` TEXT NOT NULL AFTER `long_title4`, ADD `long_description4` TEXT NOT NULL AFTER `short_description4`, ADD `title5` TEXT NOT NULL AFTER `long_description4`, ADD `image_path4` TEXT NOT NULL AFTER `title5`;


16-11-23 Khushi (live done)

ALTER TABLE `certificate` ADD `display_order` INT(11) NOT NULL AFTER `cid`;

ALTER TABLE `gallery` ADD `display_order` INT(11) NOT NULL AFTER `cid`;

ALTER TABLE `testimony` ADD `display_order` INT(11) NOT NULL AFTER `isActive`;


18-11-23 Khushi (live done)

ALTER TABLE `inquiry` CHANGE `phone` `mobile_no` VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL;

ALTER TABLE `inquiry` ADD `company` varchar(100) NOT NULL AFTER `created_date`;
ALTER TABLE `inquiry` ADD `country` varchar(100) NOT NULL AFTER `company`;
ALTER TABLE `inquiry` ADD `state` varchar(100) NOT NULL AFTER `country`;
ALTER TABLE `inquiry` ADD `city` varchar(100) NOT NULL AFTER `state`;
ALTER TABLE `inquiry` ADD `contact_number` varchar(100) NOT NULL AFTER `city`;

define line no 268
define("HTTP_PROTOCOL","http://");

20-11-23 Khushi (live done)

ALTER TABLE `about_us` ADD `meta_title` TEXT NOT NULL AFTER `big_description`, ADD `meta_title_index` TEXT NOT NULL AFTER `meta_title`, ADD `meta_title_global` TEXT NOT NULL AFTER `meta_title_index`, ADD `meta_title_blog_list` TEXT NOT NULL AFTER `meta_title_global`, ADD `meta_title_product_list` TEXT NOT NULL AFTER `meta_title_blog_list`;

21-11-23 Khushi (live done)

ALTER TABLE `about_us` ADD `meta_tag_index` TEXT NOT NULL AFTER `title2`;

ALTER TABLE `about_us` ADD `meta_title_product` TEXT NOT NULL AFTER `meta_tag_index`, ADD `meta_descr_product` TEXT NOT NULL AFTER `meta_title_product`, ADD `meta_tag_product` TEXT NOT NULL AFTER `meta_descr_product`;

ALTER TABLE `about_us` ADD `meta_descr_blog` TEXT NOT NULL AFTER `meta_tag_product`, ADD `meta_title_blog` TEXT NOT NULL AFTER `meta_descr_blog`, ADD `meta_tag_blog` TEXT NOT NULL AFTER `meta_title_blog`;

ALTER TABLE `about_us` ADD `meta_title_gallery` TEXT NOT NULL AFTER `meta_tag_blog`, ADD `meta_descr_gallery` TEXT NOT NULL AFTER `meta_title_gallery`, ADD `meta_tag_gallery` TEXT NOT NULL AFTER `meta_descr_gallery`;

ALTER TABLE `contact_us_info` ADD `meta_title` TEXT NOT NULL AFTER `address3`, ADD `meta_descr` TEXT NOT NULL AFTER `meta_title`, ADD `meta_tag` TEXT NOT NULL AFTER `meta_descr`;

ALTER TABLE `inquiry` ADD `meta_title` TEXT NOT NULL AFTER `contact_number`, ADD `meta_descr` TEXT NOT NULL AFTER `meta_title`, ADD `meta_tag` TEXT NOT NULL AFTER `meta_descr`;

ALTER TABLE `about_us` ADD `meta_title_inquiry` TEXT NOT NULL AFTER `meta_tag_gallery`, ADD `meta_descr_inquiry` TEXT NOT NULL AFTER `meta_title_inquiry`, ADD `meta_tag_inquiry` TEXT NOT NULL AFTER `meta_descr_inquiry`;

ALTER TABLE `product` ADD `meta_title` TEXT NOT NULL AFTER `meta_descr`, ADD `meta_tag` TEXT NOT NULL AFTER `meta_title`;

ALTER TABLE `blog` ADD `meta_title` TEXT NOT NULL AFTER `adate`, ADD `meta_descr` TEXT NOT NULL AFTER `meta_title`, ADD `meta_tag` TEXT NOT NULL AFTER `meta_descr`;


24-11-2023 Naveen (live done)
webassets/img/video_play_icon.png => new image add karel 

25-11-2023 Nvaeen (live done)
images/catalog => new folder banavel
images/catalog/tempImg => new folder banavel

define("CATALOG","images/catalog/");
define("CATALOG_A","../images/catalog/");
define("CATALOG_T","../images/catalog/tempImg/"); => new define add karel => line no. 272

25-11-2023 aakruti (live done)

webassets/img/search_icon.png => new image add  
\\24.24.25.116\htdocs\demo\js\webassets\img\search_icon.png


04-12-2023 Naveen (live done)
ALTER TABLE `product` ADD `catalog` VARCHAR(255) NOT NULL AFTER `image_path`;

05-12-20223 Naveen
UPDATE `catalog` SET `image_path` = '';