Linux p3plzcpnl507038.prod.phx3.secureserver.net 4.18.0-553.141.2.lve.el8.x86_64 #1 SMP Wed Jul 8 16:10:02 UTC 2026 x86_64
Apache
: 107.180.60.7 | : 216.73.217.35
Cant Read [ /etc/named.conf ]
8.2.33
xq1lly2rxbs0
Bypass.pw
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
Backdoor Scanner
Backdoor Create
Alfa Webshell
CPANEL RESET
CREATE WP USER
README
+ Create Folder
+ Create File
/
home /
xq1lly2rxbs0 /
public_html /
schema /
[ HOME SHELL ]
Name
Size
Permission
Action
schema.sql
51.31
KB
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : schema.sql
---sonali 22/11/2023 CREATE TABLE `social_icon` (`id` INT(11) NOT NULL AUTO_INCREMENT , `social_url` VARCHAR(255) NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; ALTER TABLE `social_icon` ADD `title` VARCHAR(100) NULL DEFAULT NULL AFTER `id`; ALTER TABLE `social_icon` ADD `social_icon` VARCHAR(255) NULL DEFAULT NULL AFTER `title`; ALTER TABLE `social_icon` ADD `order_by` INT(100) NULL DEFAULT NULL AFTER `social_url`; CREATE TABLE `footer` (`id` INT NOT NULL AUTO_INCREMENT , `title` VARCHAR(100) NULL DEFAULT NULL , `column_no` INT(11) NULL DEFAULT NULL , `order_by` INT(11) NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not, 1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; ---sachin 23/11/2023 CREATE TABLE`homepage` (`id` INT NOT NULL AUTO_INCREMENT , `title` VARCHAR(100) NULL , `sub_title` VARCHAR(100) NULL , `thumbnail_video` VARCHAR(100) NULL , `section_1_title` VARCHAR(100) NULL , `section_1_description` TEXT NULL , `section_1_image` VARCHAR(100) NULL , `section_2_title` VARCHAR(100) NULL , `section_2_subtitle` VARCHAR(100) NULL , `section_2_description` TEXT NULL , `section_2_icon` VARCHAR(100) NULL , `section_2_image` VARCHAR(100) NULL , `footer_card_title` VARCHAR(100) NULL , `footer_card_subtitle` VARCHAR(100) NULL , `footer_card_description` TEXT NULL , `created_at` DATETIME NULL , `updated_at` DATETIME NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; ---sonali 23/11/2023 CREATE TABLE `cards` (`id` INT(11) NOT NULL AUTO_INCREMENT , `title` INT(100) NULL DEFAULT NULL , `categoery_name` VARCHAR(100) NULL DEFAULT NULL , `description` TEXT NULL DEFAULT NULL , `image` VARCHAR(255) NULL DEFAULT NULL , `url` VARCHAR(100) NULL DEFAULT NULL , `order_by` INT(11) NULL DEFAULT NULL , `slug` VARCHAR(100) NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; ALTER TABLE `cards` CHANGE `title` `title` VARCHAR(100) NULL DEFAULT NULL; ALTER TABLE `cards` ADD `subtitle` VARCHAR(100) NULL DEFAULT NULL AFTER `title`; CREATE TABLE `site_setting` (`id` INT(11) NOT NULL AUTO_INCREMENT , `header_logo` VARCHAR(255) NULL DEFAULT NULL , `footer_logo` VARCHAR(255) NULL DEFAULT NULL , `footer_title` VARCHAR(100) NULL DEFAULT NULL , `footer_banner_img` VARCHAR(255) NULL DEFAULT NULL , `copyright_title` VARCHAR(100) NULL DEFAULT NULL , `copyright_menu` VARCHAR(255) NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; CREATE TABLE `footer_menu` (`id` INT(11) NOT NULL AUTO_INCREMENT , `title` VARCHAR(100) NULL DEFAULT NULL , `section` ENUM('1','2','3') NULL DEFAULT NULL , `url` VARCHAR(100) NULL DEFAULT NULL , `order_by` INT(11) NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; CREATE TABLE `gulfpharma`.`company_logo` (`id` INT(11) NOT NULL AUTO_INCREMENT , `company_name` VARCHAR(100) NULL DEFAULT NULL , `logo` VARCHAR(255) NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; ---sachin 23/11/2023 CREATE TABLE `header_menu` (`id` INT NOT NULL AUTO_INCREMENT , `parent_id` INT NULL , `title` VARCHAR(100) NULL , `url` VARCHAR(10) NULL , `order_by` INT NULL , `is_deleted` TINYINT NULL DEFAULT '0' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; ---sonali 24/11/2023 CREATE TABLE `resource` (`id` INT(11) NOT NULL AUTO_INCREMENT , `title` INT(100) NULL DEFAULT NULL , `icon` VARCHAR(255) NULL DEFAULT NULL , `count` VARCHAR(255) NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; ALTER TABLE `resource` CHANGE `count` `count` INT(11) NULL DEFAULT NULL; ALTER TABLE `resource` CHANGE `title` `title` VARCHAR(100) NULL DEFAULT NULL; ALTER TABLE `resource` ADD `color` VARCHAR(100) NULL DEFAULT NULL AFTER `icon`; RENAME TABLE `gulfpharma`.`company_logo` TO `gulfpharma`.`company`; ---sonali 25/11/2023 CREATE TABLE `product` (`id` INT(11) NOT NULL AUTO_INCREMENT , `product_name` VARCHAR(100) NULL DEFAULT NULL , `description` TEXT NULL DEFAULT NULL , `image` VARCHAR(255) NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; CREATE TABLE `critical_care_page` (`id` INT(11) NOT NULL AUTO_INCREMENT , `title` VARCHAR(100) NULL DEFAULT NULL , `subtitle` VARCHAR(100) NULL DEFAULT NULL , `banner_image` VARCHAR(255) NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; CREATE TABLE `equipment` (`id` INT(11) NOT NULL AUTO_INCREMENT , `title` VARCHAR(100) NULL DEFAULT NULL , `description` TEXT NULL DEFAULT NULL , `icon` VARCHAR(255) NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; CREATE TABLE `our_team` (`id` INT(11) NOT NULL AUTO_INCREMENT , `first_name` VARCHAR(100) NULL DEFAULT NULL , `last_name` VARCHAR(100) NULL DEFAULT NULL , `profile_image` VARCHAR(255) NULL DEFAULT NULL , `degination` VARCHAR(255) NULL DEFAULT NULL , `description` TEXT NULL DEFAULT NULL , `link` VARCHAR(100) NULL DEFAULT NULL , `social_icon` VARCHAR(500) NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; CREATE TABLE `logistics_page` (`id` INT(11) NOT NULL AUTO_INCREMENT , `title` VARCHAR(100) NULL DEFAULT NULL , `subtitle` VARCHAR(100) NULL DEFAULT NULL , `banner_image` VARCHAR(255) NULL DEFAULT NULL , `benifits` VARCHAR(500) NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; CREATE TABLE `contact_us` (`id` INT NOT NULL AUTO_INCREMENT , `title` VARCHAR(100) NULL DEFAULT NULL , `description` TEXT NULL DEFAULT NULL , `icon` VARCHAR(255) NULL DEFAULT NULL , `info` VARCHAR(100) NULL DEFAULT NULL , `order_by` INT(11) NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; CREATE TABLE `logistics_section` (`id` INT NOT NULL AUTO_INCREMENT , `title` VARCHAR(100) NULL DEFAULT NULL , `description` TEXT NULL DEFAULT NULL , `image` VARCHAR(255) NULL DEFAULT NULL , `section` VARCHAR(255) NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; CREATE TABLE `medical_equipment_page` (`id` INT(11) NOT NULL AUTO_INCREMENT , `title` VARCHAR(100) NULL DEFAULT NULL , `subtitle` VARCHAR(255) NULL DEFAULT NULL , `banner_image` VARCHAR(255) NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` INT NOT NULL , `updated_at` INT NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; CREATE TABLE `product_division_page` (`id` INT(11) NOT NULL AUTO_INCREMENT , `title` VARCHAR(255) NULL DEFAULT NULL , `subtitle` VARCHAR(255) NULL DEFAULT NULL , `banner_image` VARCHAR(255) NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; CREATE TABLE `product_division` (`id` INT(11) NOT NULL AUTO_INCREMENT , `title` VARCHAR(100) NULL DEFAULT NULL , `category` VARCHAR(100) NULL DEFAULT NULL , `description` TEXT NULL DEFAULT NULL , `image` VARCHAR(255) NULL DEFAULT NULL , `url` VARCHAR(100) NULL DEFAULT NULL , `order_by` INT(11) NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; ALTER TABLE `product_division` ADD `section` VARCHAR(255) NULL DEFAULT NULL AFTER `order_by`; CREATE TABLE `project_services_page` (`id` INT(11) NOT NULL AUTO_INCREMENT , `title` VARCHAR(100) NULL DEFAULT NULL , `subtitle` VARCHAR(255) NULL DEFAULT NULL , `banner_image` VARCHAR(255) NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; CREATE TABLE `projects` (`id` INT(11) NOT NULL AUTO_INCREMENT , `title` VARCHAR(100) NULL DEFAULT NULL , `description` TEXT NULL DEFAULT NULL , `image` VARCHAR(255) NULL DEFAULT NULL , `url` VARCHAR(100) NULL DEFAULT NULL , `order_by` INT(11) NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; ALTER TABLE `medical_equipment_page` CHANGE `created_at` `created_at` DATETIME NOT NULL, CHANGE `updated_at` `updated_at` DATETIME NOT NULL; ALTER TABLE `logistics_page` CHANGE `benifits` `benifits` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL; ---sonali 29/11/2023 ALTER TABLE `critical_care_page` ADD `section1_title` VARCHAR(100) NULL DEFAULT NULL AFTER `banner_image`, ADD `description` TEXT NULL DEFAULT NULL AFTER `section1_title`; ALTER TABLE `equipment` ADD `category` VARCHAR(100) NULL DEFAULT NULL AFTER `title`; ALTER TABLE `equipment` ADD `image` VARCHAR(255) NULL DEFAULT NULL AFTER `icon`; ALTER TABLE `critical_care_page` CHANGE `section1_title` `introduction` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, CHANGE `description` `intro_description` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL; ALTER TABLE `logistics_page` ADD `introduction` VARCHAR(100) NULL DEFAULT NULL AFTER `banner_image`, ADD `intro_description` TEXT NULL DEFAULT NULL AFTER `introduction`; ALTER TABLE `medical_equipment_page` ADD `introduction` VARCHAR(100) NULL DEFAULT NULL AFTER `banner_image`, ADD `intro_description` TEXT NULL DEFAULT NULL AFTER `introduction`; ALTER TABLE `project_services_page` ADD `introduction` VARCHAR(100) NULL DEFAULT NULL AFTER `banner_image`, ADD `intro_description` TEXT NULL DEFAULT NULL AFTER `introduction`; ALTER TABLE `product_division_page` ADD `introduction` VARCHAR(100) NULL DEFAULT NULL AFTER `banner_image`, ADD `intro_description` TEXT NULL DEFAULT NULL AFTER `introduction`; CREATE TABLE `benefit_critical_equipment` (`id` INT(11) NOT NULL AUTO_INCREMENT , `title` VARCHAR(100) NULL DEFAULT NULL , `description` TEXT NULL DEFAULT NULL , `icon` VARCHAR(255) NULL DEFAULT NULL , `url` VARCHAR(100) NULL DEFAULT NULL , `order_by` INT(11) NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; --mayank 29/11/23 CREATE TABLE `languages` (`id` INT(11) NOT NULL AUTO_INCREMENT , `language` INT(255) NULL , `lang_id` VARCHAR(255) NULL , `is_active` TINYINT(1) NULL DEFAULT '1' COMMENT '1=active,0=not' , `is_deleted` TINYINT(1) NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; ALTER TABLE `languages` CHANGE `language` `language` VARCHAR(255) NULL DEFAULT NULL; INSERT INTO `languages` (`id`, `language`, `lang_id`, `is_active`, `is_deleted`, `created_at`, `updated_at`) VALUES (NULL, 'English', 'en', '1', '0', '2023-11-29 07:55:03.000000', '2023-11-29 07:55:03.000000'); INSERT INTO `languages` (`id`, `language`, `lang_id`, `is_active`, `is_deleted`, `created_at`, `updated_at`) VALUES (NULL, 'Arabic', 'ar', '1', '0', '2023-11-29 07:55:03.000000', '2023-11-29 07:55:03.000000'); ALTER TABLE `homepage` ADD `lang_id` INT(11) NULL AFTER `id`; UPDATE `homepage` SET `lang_id` = '1' WHERE `homepage`.`id` = 1; INSERT INTO `homepage` (`id`, `lang_id`, `title`, `sub_title`, `thumbnail_video`, `section_1_title`, `section_1_description`, `section_1_image`, `section_2_title`, `section_2_subtitle`, `section_2_description`, `section_2_icon`, `section_2_image`, `footer_card_title`, `footer_card_subtitle`, `footer_card_description`, `created_at`, `updated_at`) VALUES (NULL, '2', 'Pioneering Healthcare Solutions', 'Your trusted partner in health and wellness', 'public/storage/home-page/17007401511.mp4', 'Who we are', 'At Gulf Drug, we see the nation and its people’s health and wellbeing as our key responsibility. We support the UAE’s wise leadership by making reliable pharmaceutical products and world-class healthcare solutions accessible to all. Powered by our extensive expertise and unceasing innovation, we ensure Gulf Drug continues to be a key player in the ever-changing healthcare landscape.', 'public/storage/home-page/17007403232.png', 'Empowering', 'Emiratizations: Fostering Opportunities and Talent', 'At Gulf Drug LLC, we are committed Emiratisation, fostering opportunities and nurturing local talent. We believe in the importance of empowering Emiratis and', 'public/storage/home-page/17007403233.png', 'public/storage/home-page/17007403234.jpg', 'Projects', 'Advancing Healthcare Unitive', 'Advancing Healthcare Discover the latest stories related to healthcare and our initiatives', '2023-11-23 11:54:35', '2023-11-23 17:22:03'); ALTER TABLE `critical_care_page` ADD `lang_id` INT(11) NULL AFTER `id`; UPDATE `critical_care_page` SET `lang_id` = '1' WHERE `critical_care_page`.`id` = 1; ALTER TABLE `product_division_page` ADD `lang_id` INT(11) NULL AFTER `id`; UPDATE `product_division_page` SET `lang_id` = '1' WHERE `product_division_page`.`id` = 1; ALTER TABLE `medical_equipment_page` ADD `lang_id` INT(11) NULL AFTER `id`; ----local done sonali ---sonali 30/11/2023 ALTER TABLE `product_division` CHANGE `section` `section` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL; ALTER TABLE `logistics_page` CHANGE `subtitle` `subtitle` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL; ALTER TABLE `logistics_section` CHANGE `section` `section` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL; ALTER TABLE `logistics_section` ADD `category` VARCHAR(100) NULL DEFAULT NULL AFTER `title`; CREATE TABLE `logistics_benefits` (`id` INT(11) NOT NULL AUTO_INCREMENT , `title` VARCHAR(100) NULL DEFAULT NULL , `description` TEXT NULL DEFAULT NULL , `icon` VARCHAR(255) NULL DEFAULT NULL , `url` VARCHAR(100) NULL DEFAULT NULL , `order_by` INT(11) NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; CREATE TABLE `project_cards` (`id` INT(11) NOT NULL AUTO_INCREMENT , `title` VARCHAR(100) NULL DEFAULT NULL , `category` VARCHAR(100) NULL DEFAULT NULL , `description` TEXT NULL DEFAULT NULL , `url` VARCHAR(100) NULL DEFAULT NULL , `order_by` INT(11) NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; ALTER TABLE `project_cards` ADD `image` VARCHAR(255) NULL DEFAULT NULL AFTER `description`; ---sonali 01/12/2023 ALTER TABLE `header_menu` ADD `image` VARCHAR(255) NULL DEFAULT NULL AFTER `parent_id`; CREATE TABLE `chat_box` (`id` INT(11) NOT NULL , `title` VARCHAR(100) NULL DEFAULT NULL , `image` VARCHAR(255) NULL DEFAULT NULL , `chat_icon` TEXT NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL ) ENGINE = InnoDB; ALTER TABLE `chat_box` CHANGE `id` `id` INT(11) NOT NULL AUTO_INCREMENT; ALTER TABLE `chat_box` ADD `hover_image` VARCHAR(255) NULL DEFAULT NULL AFTER `image`; ---sonali 04/12/2023 ALTER TABLE `logistics_page` ADD `lang_id` INT(11) NULL DEFAULT NULL AFTER `id`; ALTER TABLE `project_services_page` ADD `lang_id` INT(11) NULL DEFAULT NULL AFTER `id`; ALTER TABLE `company` ADD `lang_id` INT(11) NULL DEFAULT NULL AFTER `id`; ALTER TABLE `product` ADD `lang_id` INT(11) NULL DEFAULT NULL AFTER `id`; ALTER TABLE `equipment` ADD `lang_id` INT(11) NULL DEFAULT NULL AFTER `id`; ALTER TABLE `projects` ADD `lang_id` INT(11) NULL DEFAULT NULL AFTER `id`; ALTER TABLE `our_team` ADD `lang_id` INT(11) NULL DEFAULT NULL AFTER `id`; ALTER TABLE `chat_box` ADD `lang_id` INT(11) NULL DEFAULT NULL AFTER `id`; ALTER TABLE `resource` ADD `lang_id` INT(11) NULL DEFAULT NULL AFTER `id`; ALTER TABLE `cards` ADD `lang_id` INT(11) NULL DEFAULT NULL AFTER `id`; ALTER TABLE `footer_menu` ADD `lang_id` INT(11) NULL DEFAULT NULL AFTER `id`; ALTER TABLE `product_division` ADD `lang_id` INT(11) NULL DEFAULT NULL AFTER `id`; ALTER TABLE `logistics_section` ADD `lang_id` INT(11) NULL DEFAULT NULL AFTER `id`; ALTER TABLE `contact_us` ADD `lang_id` INT(11) NULL DEFAULT NULL AFTER `id`; ALTER TABLE `site_setting` ADD `lang_id` INT(11) NULL DEFAULT NULL AFTER `id`; ALTER TABLE `header_menu` ADD `lang_id` INT(11) NULL DEFAULT NULL AFTER `id`; ALTER TABLE `project_cards` ADD `lang_id` INT(11) NULL DEFAULT NULL AFTER `id`; ALTER TABLE `logistics_benefits` ADD `lang_id` INT(11) NULL DEFAULT NULL AFTER `id`; ALTER TABLE `benefit_critical_equipment` ADD `lang_id` INT(11) NULL DEFAULT NULL AFTER `id`; ---sonali 05/12/2023 ALTER TABLE `medical_equipment_page` CHANGE `subtitle` `subtitle` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL; ALTER TABLE `header_menu` CHANGE `url` `url` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL; ---kaushal 07/12/2023 ---sonali 07/12/2023 ALTER TABLE `equipment` ADD `url` VARCHAR(100) NULL DEFAULT NULL AFTER `image`; ALTER TABLE `product` ADD `url` VARCHAR(100) NULL DEFAULT NULL AFTER `image`; ---sonali 08/12/2023 ALTER TABLE `project_cards` CHANGE `title` `project_title` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL; ALTER TABLE `critical_care_page` ADD `product_id` TEXT NULL DEFAULT NULL AFTER `intro_description`, ADD `company_id` TEXT NULL DEFAULT NULL AFTER `product_id`; CREATE TABLE `details_page` (`id` INT(11) NOT NULL AUTO_INCREMENT , `title` VARCHAR(255) NULL DEFAULT NULL , `subtitle` TEXT NULL DEFAULT NULL , `banner_image` VARCHAR(255) NULL DEFAULT NULL , `introduction` VARCHAR(255) NULL DEFAULT NULL , `intro_description` TEXT NULL DEFAULT NULL , `id_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; ALTER TABLE `details_page` ADD `description` TEXT NULL DEFAULT NULL AFTER `intro_description`; ALTER TABLE `details_page` ADD `lang_id` INT(11) NULL DEFAULT NULL AFTER `id`; ALTER TABLE `details_page` CHANGE `id_deleted` `is_deleted` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted'; ---sonali 09/12/2023 ALTER TABLE `contact_us` ADD `url` VARCHAR(255) NULL DEFAULT NULL AFTER `info`; ALTER TABLE `project_cards` ADD `project_services_id` INT(11) NULL DEFAULT NULL AFTER `id`; ALTER TABLE `benefit_critical_equipment` ADD `critical_care_page_id` INT(11) NULL DEFAULT NULL AFTER `id`; ---sonali 11/12/2023 ALTER TABLE `logistics_benefits` ADD `logistics_page_id` INT(11) NULL DEFAULT NULL AFTER `id`; ALTER TABLE `product_division_page` CHANGE `subtitle` `subtitle` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL; ALTER TABLE `details_page` ADD `slug` TEXT NULL DEFAULT NULL AFTER `description`; ALTER TABLE `equipment` ADD `detail_title` VARCHAR(255) NULL DEFAULT NULL AFTER `url`, ADD `subtitle` TEXT NULL DEFAULT NULL AFTER `detail_title`, ADD `banner_image` VARCHAR(255) NULL DEFAULT NULL AFTER `subtitle`, ADD `introduction` VARCHAR(255) NULL DEFAULT NULL AFTER `banner_image`, ADD `intro_description` TEXT NULL DEFAULT NULL AFTER `introduction`, ADD `slug` VARCHAR(255) NULL DEFAULT NULL AFTER `intro_description`, ADD `product_id` INT(11) NULL DEFAULT NULL AFTER `slug`, ADD `company_id` INT(11) NULL DEFAULT NULL AFTER `product_id`; ALTER TABLE `equipment` CHANGE `product_id` `product_id` BIGINT(20) NULL DEFAULT NULL, CHANGE `company_id` `company_id` BIGINT(20) NULL DEFAULT NULL; ALTER TABLE `equipment` CHANGE `product_id` `product_id` TEXT NULL DEFAULT NULL, CHANGE `company_id` `company_id` TEXT NULL DEFAULT NULL; ---sonali 13/12/2023 ALTER TABLE `product` ADD `detail_title` VARCHAR(255) NULL DEFAULT NULL AFTER `url`, ADD `subtitle` TEXT NULL DEFAULT NULL AFTER `detail_title`, ADD `banner_image` VARCHAR(300) NULL DEFAULT NULL AFTER `subtitle`, ADD `introduction` VARCHAR(255) NULL DEFAULT NULL AFTER `banner_image`, ADD `intro_description` TEXT NULL DEFAULT NULL AFTER `introduction`, ADD `pro_description` TEXT NULL DEFAULT NULL AFTER `intro_description`; ALTER TABLE `product` ADD `slug` TEXT NULL DEFAULT NULL AFTER `detail_title`; ---sonali 15/12/2023 ALTER TABLE `critical_care_page` ADD `product_title` VARCHAR(255) NULL DEFAULT NULL AFTER `intro_description`, ADD `product_category` VARCHAR(255) NULL DEFAULT NULL AFTER `product_title`; ALTER TABLE `critical_care_page` ADD `benefits_title` VARCHAR(255) NULL DEFAULT NULL AFTER `product_category`, ADD `benefits_category` VARCHAR(255) NULL DEFAULT NULL AFTER `benefits_title`; ALTER TABLE `critical_care_page` ADD `company_title` VARCHAR(255) NULL DEFAULT NULL AFTER `benefits_category`, ADD `company_subtitle` VARCHAR(255) NULL DEFAULT NULL AFTER `company_title`, ADD `company_category` VARCHAR(255) NULL DEFAULT NULL AFTER `company_subtitle`; ALTER TABLE `critical_care_page` ADD `our_title` VARCHAR(255) NULL DEFAULT NULL AFTER `company_category`, ADD `our_category` VARCHAR(255) NULL DEFAULT NULL AFTER `our_title`; ALTER TABLE `logistics_page` ADD `benefits_title` VARCHAR(255) NULL DEFAULT NULL AFTER `intro_description`, ADD `benefits_category` VARCHAR(255) NULL DEFAULT NULL AFTER `benefits_title`; ALTER TABLE `equipment` ADD `product_title` VARCHAR(255) NULL DEFAULT NULL AFTER `slug`, ADD `product_category` VARCHAR(255) NULL DEFAULT NULL AFTER `product_title`, ADD `benefits_title` VARCHAR(255) NULL DEFAULT NULL AFTER `product_category`, ADD `benefits_category` VARCHAR(255) NULL DEFAULT NULL AFTER `benefits_title`, ADD `company_title` VARCHAR(255) NULL DEFAULT NULL AFTER `benefits_category`, ADD `company_subtitle` VARCHAR(255) NULL DEFAULT NULL AFTER `company_title`, ADD `company_category` VARCHAR(255) NULL DEFAULT NULL AFTER `company_subtitle`, ADD `our_title` VARCHAR(255) NULL DEFAULT NULL AFTER `company_category`, ADD `our_category` VARCHAR(255) NULL DEFAULT NULL AFTER `our_title`; ALTER TABLE `site_setting` ADD `contact_title` VARCHAR(255) NULL DEFAULT NULL AFTER `copyright_menu`, ADD `contact_subtitle` VARCHAR(255) NULL DEFAULT NULL AFTER `contact_title`, ADD `contact_category` VARCHAR(255) NULL DEFAULT NULL AFTER `contact_subtitle`; ALTER TABLE `project_services_page` ADD `project_title` VARCHAR(255) NULL DEFAULT NULL AFTER `intro_description`, ADD `project_category` VARCHAR(255) NULL DEFAULT NULL AFTER `project_title`, ADD `project_desc` TEXT NULL DEFAULT NULL AFTER `project_category`; CREATE TABLE `subscriber_email` (`id` INT(11) NOT NULL AUTO_INCREMENT , `email` VARCHAR(255) NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; ALTER TABLE `subscriber_email` ADD `lang_id` INT(11) NULL DEFAULT NULL AFTER `id`; ---sonali 16/12/2023 ALTER TABLE `homepage` ADD `Page_title` VARCHAR(255) NULL DEFAULT NULL AFTER `footer_card_description`, ADD `meta_title` VARCHAR(255) NULL DEFAULT NULL AFTER `Page_title`, ADD `meta_desc` VARCHAR(255) NULL DEFAULT NULL AFTER `meta_title`, ADD `meta_keyword` VARCHAR(255) NULL DEFAULT NULL AFTER `meta_desc`, ADD `url_schema` VARCHAR(255) NULL DEFAULT NULL AFTER `meta_keyword`, ADD `canonical_tag` VARCHAR(255) NULL DEFAULT NULL AFTER `url_schema`, ADD `canonical_rel` VARCHAR(255) NULL DEFAULT NULL AFTER `canonical_tag`; ALTER TABLE `homepage` CHANGE `Page_title` `page_title` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL; ALTER TABLE `critical_care_page` ADD `page_title` VARCHAR(255) NULL DEFAULT NULL AFTER `our_category`, ADD `meta_title` VARCHAR(255) NULL DEFAULT NULL AFTER `page_title`, ADD `meta_desc` VARCHAR(255) NULL DEFAULT NULL AFTER `meta_title`, ADD `meta_keyword` VARCHAR(255) NULL DEFAULT NULL AFTER `meta_desc`, ADD `url_schema` VARCHAR(255) NULL DEFAULT NULL AFTER `meta_keyword`, ADD `canonical_tag` VARCHAR(255) NULL DEFAULT NULL AFTER `url_schema`, ADD `canonical_rel` VARCHAR(255) NULL DEFAULT NULL AFTER `canonical_tag`; ALTER TABLE `product_division_page` ADD `page_title` VARCHAR(255) NULL DEFAULT NULL AFTER `intro_description`, ADD `meta_title` VARCHAR(255) NULL DEFAULT NULL AFTER `page_title`, ADD `meta_desc` VARCHAR(255) NULL DEFAULT NULL AFTER `meta_title`, ADD `meta_keyword` VARCHAR(255) NULL DEFAULT NULL AFTER `meta_desc`, ADD `url_schema` VARCHAR(255) NULL DEFAULT NULL AFTER `meta_keyword`, ADD `canonical_tag` VARCHAR(255) NULL DEFAULT NULL AFTER `url_schema`, ADD `canonical_rel` VARCHAR(255) NULL DEFAULT NULL AFTER `canonical_tag`; ALTER TABLE `medical_equipment_page` ADD `page_title` VARCHAR(255) NULL DEFAULT NULL AFTER `intro_description`, ADD `meta_title` VARCHAR(255) NULL DEFAULT NULL AFTER `page_title`, ADD `meta_desc` VARCHAR(255) NULL DEFAULT NULL AFTER `meta_title`, ADD `meta_keyword` VARCHAR(255) NULL DEFAULT NULL AFTER `meta_desc`, ADD `url_schema` VARCHAR(255) NULL DEFAULT NULL AFTER `meta_keyword`, ADD `canonical_tag` VARCHAR(255) NULL DEFAULT NULL AFTER `url_schema`, ADD `canonical_rel` VARCHAR(255) NULL DEFAULT NULL AFTER `canonical_tag`; ALTER TABLE `logistics_page` ADD `page_title` VARCHAR(255) NULL DEFAULT NULL AFTER `benefits_category`, ADD `meta_title` VARCHAR(255) NULL DEFAULT NULL AFTER `page_title`, ADD `meta_desc` VARCHAR(255) NULL DEFAULT NULL AFTER `meta_title`, ADD `meta_keyword` VARCHAR(255) NULL DEFAULT NULL AFTER `meta_desc`, ADD `url_schema` VARCHAR(255) NULL DEFAULT NULL AFTER `meta_keyword`, ADD `canonical_tag` VARCHAR(255) NULL DEFAULT NULL AFTER `url_schema`, ADD `canonical_rel` VARCHAR(255) NULL DEFAULT NULL AFTER `canonical_tag`; ALTER TABLE `project_services_page` ADD `page_title` VARCHAR(255) NULL DEFAULT NULL AFTER `project_desc`, ADD `meta_title` VARCHAR(255) NULL DEFAULT NULL AFTER `page_title`, ADD `meta_desc` VARCHAR(255) NULL DEFAULT NULL AFTER `meta_title`, ADD `meta_keyword` VARCHAR(255) NULL DEFAULT NULL AFTER `meta_desc`, ADD `url_schema` VARCHAR(255) NULL DEFAULT NULL AFTER `meta_keyword`, ADD `canonical_tag` VARCHAR(255) NULL DEFAULT NULL AFTER `url_schema`, ADD `canonical_rel` VARCHAR(255) NULL DEFAULT NULL AFTER `canonical_tag`; ALTER TABLE `site_setting` ADD `icon_title` VARCHAR(255) NULL DEFAULT NULL AFTER `contact_category`; ---sonali 18/12/2023 ALTER TABLE `site_setting` ADD `email_button` VARCHAR(50) NULL DEFAULT NULL AFTER `icon_title`; ---sonali 20/12/2023 CREATE TABLE `medical_supplies_page` (`id` INT(11) NULL DEFAULT NULL AUTO_INCREMENT , `lang_id` INT(11) NULL DEFAULT NULL , `title` VARCHAR(255) NULL DEFAULT NULL , `subtitle` TEXT NULL DEFAULT NULL , `banner_image` VARCHAR(255) NULL DEFAULT NULL , `introduction` VARCHAR(255) NULL DEFAULT NULL , `intro_description` TEXT NULL DEFAULT NULL , `page_title` VARCHAR(255) NULL DEFAULT NULL , `meta_title` VARCHAR(255) NULL DEFAULT NULL , `meta_desc` VARCHAR(255) NULL DEFAULT NULL , `meta_keyword` VARCHAR(255) NULL DEFAULT NULL , `url_schema` VARCHAR(255) NULL DEFAULT NULL , `canonical_tag` VARCHAR(255) NULL DEFAULT NULL , `canonical_rel` VARCHAR(255) NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; CREATE TABLE `medical_supplies` (`id` INT(11) NOT NULL AUTO_INCREMENT , `lang_id` INT(11) NULL DEFAULT NULL , `title` VARCHAR(255) NULL DEFAULT NULL , `category` VARCHAR(255) NULL DEFAULT NULL , `description` TEXT NULL DEFAULT NULL , `image` VARCHAR(255) NULL DEFAULT NULL , `url` VARCHAR(255) NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; ---sonali 23/12/2023 ALTER TABLE `site_setting` CHANGE `copyright_menu` `copyright_menu` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL; ---sonali 26/12/2023 CREATE TABLE `logistics_our_team` (`id` INT(11) NOT NULL AUTO_INCREMENT , `lang_id` INT(11) NULL DEFAULT NULL , `first_name` VARCHAR(100) NULL DEFAULT NULL , `last_name` VARCHAR(100) NULL DEFAULT NULL , `profile_image` VARCHAR(255) NULL DEFAULT NULL , `degination` VARCHAR(255) NULL DEFAULT NULL , `description` TEXT NULL DEFAULT NULL , `link` VARCHAR(255) NULL DEFAULT NULL , `social_icon` TEXT NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; CREATE TABLE `equipment_benefits` (`id` INT(11) NOT NULL AUTO_INCREMENT , `lang_id` INT(11) NULL DEFAULT NULL , `title` VARCHAR(255) NULL DEFAULT NULL , `description` TEXT NULL DEFAULT NULL , `icon` VARCHAR(255) NULL DEFAULT NULL , `url` VARCHAR(255) NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; ALTER TABLE `equipment` ADD `equipment_benefits_id` TEXT NULL DEFAULT NULL AFTER `company_id`; ALTER TABLE `equipment` ADD `our_team_id` TEXT NULL DEFAULT NULL AFTER `equipment_benefits_id`; ---sonali 27/12/2023 ALTER TABLE `logistics_section` ADD `url` VARCHAR(255) NULL DEFAULT NULL AFTER `image`; CREATE TABLE `logistics_new_page` (`id` INT(11) NOT NULL AUTO_INCREMENT , `lang_id` INT(11) NULL DEFAULT NULL , `title` VARCHAR(255) NULL DEFAULT NULL , `sub_title` VARCHAR(255) NULL DEFAULT NULL , `banner_video` VARCHAR(255) NULL DEFAULT NULL , `section_2_title` VARCHAR(255) NULL DEFAULT NULL , `section_2_description` TEXT NULL DEFAULT NULL , `section_3_add` TEXT NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; ALTER TABLE `logistics_new_page` CHANGE `sub_title` `sub_title` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL; CREATE TABLE `logistics_detail_page` (`id` INT(11) NOT NULL AUTO_INCREMENT , `lang_id` INT(11) NULL DEFAULT NULL , `title` VARCHAR(255) NULL DEFAULT NULL , `sub_title` TEXT NULL DEFAULT NULL , `banner_image` VARCHAR(255) NULL DEFAULT NULL , `section_2_title` VARCHAR(255) NULL DEFAULT NULL , `section_2_description` TEXT NULL DEFAULT NULL , `location_name` VARCHAR(255) NULL DEFAULT NULL , `image` TEXT NULL DEFAULT NULL , `sub_section` TEXT NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; ALTER TABLE `logistics_detail_page` DROP `location_name`, DROP `image`, DROP `sub_section`; CREATE TABLE `logistics_detail_section` (`id` INT(11) NOT NULL AUTO_INCREMENT , `lang_id` INT(11) NULL DEFAULT NULL , `location_name` VARCHAR(255) NULL DEFAULT NULL , `image` TEXT NULL DEFAULT NULL , `sub_section` TEXT NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; ---sonali 28/12/2023 CREATE TABLE `logistics_deliverysupply_detail` (`id` INT(11) NOT NULL AUTO_INCREMENT , `lang_id` INT(11) NULL DEFAULT NULL , `title` VARCHAR(255) NULL DEFAULT NULL , `sub_title` TEXT NULL DEFAULT NULL , `banner_image` VARCHAR(255) NULL DEFAULT NULL , `section_2_title` VARCHAR(255) NULL DEFAULT NULL , `section_2_description` TEXT NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; CREATE TABLE `logistics_deliverysupply_section` (`id` INT(11) NOT NULL , `lang_id` INT(11) NULL DEFAULT NULL , `title` VARCHAR(255) NULL DEFAULT NULL , `sub_section_add` TEXT NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL ) ENGINE = InnoDB; ALTER TABLE `logistics_deliverysupply_section` CHANGE `id` `id` INT(11) NOT NULL AUTO_INCREMENT, add PRIMARY KEY (`id`); ALTER TABLE `logistics_deliverysupply_detail` ADD `section_3_title` VARCHAR(255) NULL DEFAULT NULL AFTER `section_2_description`; ---sonali 29/12/2023 CREATE TABLE `veterinary_heathcare_solution` (`id` INT NOT NULL AUTO_INCREMENT , `lang_id` INT(11) NULL DEFAULT NULL , `section_1_title` VARCHAR(255) NULL DEFAULT NULL , `section_1_subtitle` TEXT NULL DEFAULT NULL , `banner_image` VARCHAR(255) NULL DEFAULT NULL , `section_2_title` VARCHAR(255) NULL DEFAULT NULL , `section_2_description` TEXT NULL DEFAULT NULL , `section_3_title` VARCHAR(255) NULL DEFAULT NULL , `section_3_subtitle` VARCHAR(255) NULL DEFAULT NULL , `product_image` VARCHAR(255) NULL DEFAULT NULL , `product_image_title` VARCHAR(100) NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; ALTER TABLE `veterinary_heathcare_solution` DROP `product_image_title`; ALTER TABLE `veterinary_heathcare_solution` CHANGE `product_image` `section_product_add` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL; ---sonali 29/12/2023 CREATE TABLE `pharmaceutical` (`id` INT(11) NOT NULL AUTO_INCREMENT , `lang_id` INT(11) NULL DEFAULT NULL , `section_1_title` VARCHAR(255) NULL DEFAULT NULL , `section_1_subtitle` TEXT NULL DEFAULT NULL , `banner_image` VARCHAR(255) NULL DEFAULT NULL , `section_2_title` VARCHAR(255) NULL DEFAULT NULL , `section_2_description` TEXT NULL DEFAULT NULL , `section_3_title` VARCHAR(255) NULL DEFAULT NULL , `section_3_addmore` TEXT NULL DEFAULT NULL , `section_4_title` VARCHAR(255) NULL DEFAULT NULL , `section_4_addmore` TEXT NULL DEFAULT NULL , `section_5_title` VARCHAR(255) NULL DEFAULT NULL , `section_5_addmore` TEXT NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; ---sonali 01/01/2024 ALTER TABLE `medical_supplies` ADD `detail_title` VARCHAR(255) NULL DEFAULT NULL AFTER `url`, ADD `subtitle` TEXT NULL DEFAULT NULL AFTER `detail_title`, ADD `banner_image` VARCHAR(255) NULL DEFAULT NULL AFTER `subtitle`, ADD `introduction` VARCHAR(255) NULL DEFAULT NULL AFTER `banner_image`, ADD `intro_description` TEXT NULL DEFAULT NULL AFTER `introduction`, ADD `slug` VARCHAR(255) NULL DEFAULT NULL AFTER `intro_description`; CREATE TABLE `medical_supplies_detail_products` (`id` INT(11) NOT NULL AUTO_INCREMENT , `lang_id` INT(11) NULL DEFAULT NULL , `product_title` VARCHAR(255) NULL DEFAULT NULL , `product_image` VARCHAR(255) NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; ALTER TABLE `medical_supplies` DROP `url`; CREATE TABLE `medical_supplies_detail_species` (`id` INT(11) NOT NULL AUTO_INCREMENT , `lang_id` INT(11) NULL DEFAULT NULL , `species_title` VARCHAR(255) NULL DEFAULT NULL , `species_image` VARCHAR(255) NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; ALTER TABLE `medical_supplies_page` ADD `detail_product_title` VARCHAR(255) NULL DEFAULT NULL AFTER `intro_description`, ADD `detail_product_button` VARCHAR(255) NULL DEFAULT NULL AFTER `detail_product_title`, ADD `detail_species_title` VARCHAR(255) NULL DEFAULT NULL AFTER `detail_product_button`; CREATE TABLE `medical_supplies_product_category` (`id` INT(11) NOT NULL AUTO_INCREMENT , `lang_id` INT(11) NULL DEFAULT NULL , `category_title` VARCHAR(255) NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; CREATE TABLE `medical_supplies_detail_supplier` (`id` INT(11) NOT NULL AUTO_INCREMENT , `lang_id` INT(11) NULL DEFAULT NULL , `supplier_title` VARCHAR(255) NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; ALTER TABLE `medical_supplies_page` ADD `detail_filter` VARCHAR(100) NULL DEFAULT NULL AFTER `detail_species_title`, ADD `detail_clear_button` VARCHAR(100) NULL DEFAULT NULL AFTER `detail_filter`, ADD `detail_p_caregory` VARCHAR(100) NULL DEFAULT NULL AFTER `detail_clear_button`, ADD `detail_supplier` VARCHAR(100) NULL DEFAULT NULL AFTER `detail_p_caregory`; ALTER TABLE `medical_supplies_detail_products` ADD `product_category_id` INT(11) NULL DEFAULT NULL COMMENT 'medical_supplies_product_category' AFTER `product_image`, ADD `supplier_id` INT(11) NULL DEFAULT NULL AFTER `product_category_id`; ALTER TABLE `medical_supplies_detail_products` CHANGE `supplier_id` `supplier_id` INT(11) NULL DEFAULT NULL COMMENT 'medical_supplies_detail_supplier'; ALTER TABLE `medical_supplies_detail_products` ADD `division_id` INT(11) NULL DEFAULT NULL COMMENT 'medical_supplies_detail_species' AFTER `supplier_id`; ALTER TABLE `medical_supplies_product_category` ADD `division_id` INT(11) NULL DEFAULT NULL COMMENT 'medical_supplies_detail_species' AFTER `category_title`; ALTER TABLE `medical_supplies_detail_products` CHANGE `supplier_id` `supplier_id` TEXT NULL DEFAULT NULL COMMENT 'medical_supplies_detail_supplier'; ---sonali 04/01/2024 CREATE TABLE `veterinary_detail_product` (`id` INT(11) NOT NULL AUTO_INCREMENT , `lang_id` INT(11) NULL DEFAULT NULL , `product_title` VARCHAR(255) NULL DEFAULT NULL , `product_image` VARCHAR(255) NULL DEFAULT NULL , `product_category_id` INT(11) NULL DEFAULT NULL , `supplier_id` TEXT NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; CREATE TABLE `veterinary_detail_p_category` (`id` INT(11) NOT NULL AUTO_INCREMENT , `lang_id` INT(11) NULL DEFAULT NULL , `category_title` VARCHAR(255) NULL DEFAULT NULL , `species_id` INT(11) NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; CREATE TABLE `veterinary_detail_supplier` (`id` INT(11) NOT NULL AUTO_INCREMENT , `lang_id` INT(11) NULL DEFAULT NULL , `supplier_title` VARCHAR(255) NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; CREATE TABLE `veterinary_detail_species` (`id` INT(11) NOT NULL AUTO_INCREMENT , `lang_id` INT(11) NULL DEFAULT NULL , `species_title` VARCHAR(255) NULL DEFAULT NULL , `species_image` VARCHAR(255) NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; ALTER TABLE `veterinary_detail_product` CHANGE `product_category_id` `product_category_id` INT(11) NULL DEFAULT NULL COMMENT 'veterinary_detail_p_category', CHANGE `supplier_id` `supplier_id` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'veterinary_detail_supplier'; ---sonali 05/01/2024 CREATE TABLE `veterinary_page_section` (`id` INT(11) NOT NULL AUTO_INCREMENT , `lang_id` INT(11) NULL DEFAULT NULL , `title` VARCHAR(255) NULL DEFAULT NULL , `image` VARCHAR(255) NULL DEFAULT NULL , `slug` VARCHAR(255) NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; ALTER TABLE `veterinary_heathcare_solution` DROP `section_product_add`; ALTER TABLE `veterinary_page_section` ADD `detail_title` VARCHAR(255) NULL DEFAULT NULL AFTER `slug`, ADD `subtitle` TEXT NULL DEFAULT NULL AFTER `detail_title`, ADD `detail_image` VARCHAR(255) NULL DEFAULT NULL AFTER `subtitle`, ADD `introduction` VARCHAR(255) NULL DEFAULT NULL AFTER `detail_image`; ALTER TABLE `veterinary_page_section` DROP `introduction`; ALTER TABLE `veterinary_page_section` ADD `detail_product_title` VARCHAR(255) NULL DEFAULT NULL AFTER `detail_image`, ADD `detail_product_button` VARCHAR(255) NULL DEFAULT NULL AFTER `detail_product_title`, ADD `detail_species_title` VARCHAR(255) NULL DEFAULT NULL AFTER `detail_product_button`, ADD `detail_filter` VARCHAR(255) NULL DEFAULT NULL AFTER `detail_species_title`, ADD `detail_clear_button` VARCHAR(255) NULL DEFAULT NULL AFTER `detail_filter`, ADD `detail_p_caregory` VARCHAR(255) NULL DEFAULT NULL AFTER `detail_clear_button`, ADD `detail_supplier` VARCHAR(255) NULL DEFAULT NULL AFTER `detail_p_caregory`; ALTER TABLE `projects` ADD `slug` VARCHAR(255) NULL DEFAULT NULL AFTER `order_by`, ADD `detail_title` VARCHAR(255) NULL DEFAULT NULL AFTER `slug`, ADD `subtitle` TEXT NULL DEFAULT NULL AFTER `detail_title`, ADD `banner_image` VARCHAR(255) NULL DEFAULT NULL AFTER `subtitle`, ADD `introduction` VARCHAR(255) NULL DEFAULT NULL AFTER `banner_image`, ADD `intro_description` TEXT NULL DEFAULT NULL AFTER `introduction`, ADD `pro_description` TEXT NULL DEFAULT NULL AFTER `intro_description`; ---sonali 06/01/2024 CREATE TABLE `human_resource_page` (`id` INT(11) NOT NULL AUTO_INCREMENT , `lang_id` INT(11) NULL DEFAULT NULL , `title` VARCHAR(255) NULL DEFAULT NULL , `sub_title` TEXT NULL DEFAULT NULL , `banner_image` VARCHAR(255) NULL DEFAULT NULL , `section_description` TEXT NULL DEFAULT NULL , `website_name` VARCHAR(100) NULL DEFAULT NULL , `website_url` VARCHAR(255) NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; ALTER TABLE `human_resource_page` ADD `page_title` VARCHAR(255) NULL DEFAULT NULL AFTER `website_url`, ADD `meta_title` VARCHAR(255) NULL DEFAULT NULL AFTER `page_title`, ADD `meta_desc` VARCHAR(255) NULL DEFAULT NULL AFTER `meta_title`, ADD `meta_keyword` VARCHAR(255) NULL DEFAULT NULL AFTER `meta_desc`, ADD `url_schema` VARCHAR(255) NULL DEFAULT NULL AFTER `meta_keyword`, ADD `canonical_tag` VARCHAR(255) NULL DEFAULT NULL AFTER `url_schema`, ADD `canonical_rel` VARCHAR(255) NULL DEFAULT NULL AFTER `canonical_tag`; CREATE TABLE `human_resource_form` (`id` INT(11) NOT NULL AUTO_INCREMENT , `lang_id` INT(11) NULL DEFAULT NULL , `name` VARCHAR(255) NULL DEFAULT NULL , `email` VARCHAR(255) NULL DEFAULT NULL , `designation` VARCHAR(255) NULL DEFAULT NULL , `upload_file` VARCHAR(255) NULL DEFAULT NULL , `comment` TEXT NULL DEFAULT NULL , `is_deleted` TINYINT NOT NULL DEFAULT '0' COMMENT '0=not,1=deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; ALTER TABLE `human_resource_page` ADD `name` VARCHAR(100) NULL DEFAULT NULL AFTER `website_url`, ADD `email` VARCHAR(100) NULL DEFAULT NULL AFTER `name`, ADD `designation` VARCHAR(100) NULL DEFAULT NULL AFTER `email`, ADD `upload_documents` VARCHAR(100) NULL DEFAULT NULL AFTER `designation`, ADD `comment` VARCHAR(100) NULL DEFAULT NULL AFTER `upload_documents`, ADD `submit_button` VARCHAR(100) NULL DEFAULT NULL AFTER `comment`; ----local done---- ------------Daya----------- CREATE TABLE `founders` ( `id` int(11) NOT NULL, `lang_id` int(11) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `image` text DEFAULT NULL, `banner_image` varchar(255) DEFAULT NULL, `designation` varchar(255) DEFAULT NULL, `about` text DEFAULT NULL, `is_deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0=Not deleted 1=deleted', `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; ALTER TABLE `founders` ADD PRIMARY KEY (`id`); ALTER TABLE `founders` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; CREATE TABLE `about-us` ( `id` int(11) NOT NULL, `lang_id` int(11) DEFAULT NULL, `title` varchar(255) DEFAULT NULL, `subtitle` varchar(255) DEFAULT NULL, `image` varchar(255) DEFAULT NULL, `page_title` varchar(255) DEFAULT NULL, `founder_title` varchar(255) DEFAULT NULL, `founder_subtitle` varchar(255) DEFAULT NULL, `founder_description` text DEFAULT NULL, `founders_partners` text DEFAULT NULL, `vision_image` varchar(255) DEFAULT NULL, `vision_title` varchar(255) DEFAULT NULL, `vision_subtitle` varchar(255) DEFAULT NULL, `vision_description` varchar(255) DEFAULT NULL, `vision_info` text DEFAULT NULL, `page_subtitle` varchar(255) DEFAULT NULL, `page_description` text DEFAULT NULL, `page_section` text DEFAULT NULL, `is_deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0=Not deleted 1=deleted', `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; ALTER TABLE `about-us` ADD PRIMARY KEY (`id`); ALTER TABLE `about-us` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20; -- Daya 15-12-2024-- ALTER TABLE `founders` ADD `slug` VARCHAR(255) NULL DEFAULT NULL AFTER `id`; --------17/12/2023------------- CREATE TABLE `medical_equipment_product_category` ( `id` int(11) NOT NULL, `lang_id` int(11) DEFAULT NULL, `category_title` varchar(255) DEFAULT NULL, `equipment_id` varchar(255) DEFAULT NULL, `product_id` varchar(255) DEFAULT NULL, `is_deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0=Not deleted 1=Deleted', `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; ALTER TABLE `medical_equipment_product_category` ADD PRIMARY KEY (`id`); ALTER TABLE `medical_equipment_product_category` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; CREATE TABLE `medical_equipment_product_supplier` ( `id` int(11) NOT NULL, `lang_id` int(11) DEFAULT NULL, `supplier_title` varchar(255) DEFAULT NULL, `equipment_id` varchar(255) DEFAULT NULL, `product_id` varchar(255) DEFAULT NULL, `is_deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0=Not deleted 1=deleted', `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; ALTER TABLE `medical_equipment_product_supplier` ADD PRIMARY KEY (`id`); ALTER TABLE `medical_equipment_product_supplier` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; CREATE TABLE `medical_equipment-subproducts` ( `id` int(11) NOT NULL, `lang_id` int(11) DEFAULT NULL, `title` varchar(255) DEFAULT NULL, `product_title` varchar(255) DEFAULT NULL, `product_image` varchar(255) DEFAULT NULL, `supplier_id` varchar(255) DEFAULT NULL, `category_id` varchar(255) DEFAULT NULL, `equipment_slug` varchar(255) DEFAULT NULL, `product_slug` varchar(255) DEFAULT NULL, `is_deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0=deleted 1=Deleted', `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; ALTER TABLE `medical_equipment-subproducts` ADD PRIMARY KEY (`id`); ALTER TABLE `medical_equipment-subproducts` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; ALTER TABLE `medical_equipment_page` ADD `mobile_banner_image` VARCHAR(255) NULL DEFAULT NULL AFTER `banner_image`; ALTER TABLE `medical_supplies_page` ADD `mobile_banner_image` VARCHAR(255) NULL DEFAULT NULL AFTER `banner_image`; ALTER TABLE `pharmaceutical` ADD `mobile_banner_image` VARCHAR(255) NULL DEFAULT NULL AFTER `banner_image`; ALTER TABLE `veterinary_heathcare_solution` ADD `mobile_banner_image` VARCHAR(255) NULL DEFAULT NULL AFTER `banner_image`; ----------20/01/20240------------- ALTER TABLE `about-us` ADD `philosophy_title` VARCHAR(255) NULL DEFAULT NULL AFTER `vision_info`, ADD `philosophy_subtitle` VARCHAR(255) NULL DEFAULT NULL AFTER `philosophy_title`, ADD `philosophy_image` VARCHAR(255) NULL DEFAULT NULL AFTER `philosophy_subtitle`; ALTER TABLE `about-us` ADD `philosophy_description` TEXT NULL DEFAULT NULL AFTER `philosophy_image`; CREATE TABLE `sister-companies` (`id` INT NOT NULL AUTO_INCREMENT , `lang_id` INT(11) NULL DEFAULT NULL , `company_name` VARCHAR(255) NULL DEFAULT NULL , `company_url` VARCHAR(255) NULL DEFAULT NULL , `company_image` VARCHAR(255) NULL DEFAULT NULL , `is_deleted` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '0=Not Deleted 1=Deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; ALTER TABLE `human_resource_page` ADD `video_url` VARCHAR(255) NULL DEFAULT NULL AFTER `website_url`; ALTER TABLE `about-us` ADD `mobile_banner` VARCHAR(255) NULL DEFAULT NULL AFTER `vision_image`; ALTER TABLE `human_resource_page` ADD `mobile_banner_image` VARCHAR(255) NULL DEFAULT NULL AFTER `banner_image`; ALTER TABLE `logistics_new_page` ADD `mobile_banner_video` VARCHAR(255) NULL DEFAULT NULL AFTER `banner_video`; ----------------live done------------------ CREATE TABLE `contact_us_page` (`id` INT(11) NOT NULL AUTO_INCREMENT , `banner_title` VARCHAR(255) NULL DEFAULT NULL , `banner_subtitle` VARCHAR(255) NULL DEFAULT NULL , `banner_image` VARCHAR(255) NULL DEFAULT NULL , `title` VARCHAR(255) NULL DEFAULT NULL , `image` VARCHAR(255) NULL DEFAULT NULL , `company_name` VARCHAR(255) NULL DEFAULT NULL , `company_address` VARCHAR(255) NULL DEFAULT NULL , `is_deleted` TINYINT(4) NULL DEFAULT NULL COMMENT '0=Not 1=Deleted' , `created_at` DATETIME NULL , `updated_at` DATETIME NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; CREATE TABLE `frontend_contactus` (`id` INT(11) NOT NULL AUTO_INCREMENT , `first_name` VARCHAR(255) NULL DEFAULT NULL , `last_name` VARCHAR(255) NULL DEFAULT NULL , `phone` INT(11) NULL DEFAULT NULL , `email` VARCHAR(255) NULL DEFAULT NULL , `description` TEXT NULL DEFAULT NULL , `is_deleted` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '0=Not Deleted 1=Deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; ALTER TABLE `frontend_contactus` ADD `department` VARCHAR(255) NULL DEFAULT NULL AFTER `description`; CREATE TABLE `departments` (`id` INT(11) NOT NULL AUTO_INCREMENT , `name` VARCHAR(255) NULL DEFAULT NULL , `is_active` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '1=Active 0=Deactive' , `is_deleted` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '0=Not Deleted 1=Deleted' , `created_at` DATETIME NOT NULL , `updated_at` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; ALTER TABLE `departments` CHANGE `name` `name_en` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL; ALTER TABLE `departments` ADD `name_ar` VARCHAR(255) NULL DEFAULT NULL AFTER `name_en`; ALTER TABLE `product` ADD `is_active` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '1=Active 0=Deactive' AFTER `pro_description`;
Close
