1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / projects_ilium / db / Arun /
Filename : queries.txt
back
19-09-2024 

ALTER TABLE `tbl_department_category` ADD `created_by` INT NULL DEFAULT NULL AFTER `updated_at`, ADD `updated_by` INT NULL DEFAULT NULL AFTER `created_by`, ADD `deleted` INT NOT NULL DEFAULT '0' AFTER `updated_by`, ADD `deleted_at` DATETIME NULL DEFAULT NULL AFTER `deleted`, ADD `deleted_by` INT NULL DEFAULT NULL AFTER `deleted_at`;

ALTER TABLE `tbl_desigantion_category` ADD `created_by` INT NULL DEFAULT NULL AFTER `updated_at`, ADD `updated_by` INT NULL DEFAULT NULL AFTER `created_by`, ADD `deleted` INT NULL DEFAULT '0' AFTER `updated_by`, ADD `deleted_at` DATETIME NULL DEFAULT NULL AFTER `deleted`, ADD `deleted_by` INT NULL DEFAULT NULL AFTER `deleted_at`;

ALTER TABLE `tbl_attendance_leave_category` ADD `created_by` INT NULL DEFAULT NULL AFTER `updated_at`, ADD `updated_by` INT NULL DEFAULT NULL AFTER `created_by`, ADD `deleted` INT NOT NULL DEFAULT '0' AFTER `updated_by`, ADD `deleted_at` DATETIME NULL DEFAULT NULL AFTER `deleted`, ADD `deleted_by` INT NULL DEFAULT NULL AFTER `deleted_at`;

ALTER TABLE `tbl_shift_timing_master` ADD `created_by` INT NULL DEFAULT NULL AFTER `updated_at`, ADD `updated_by` INT NULL DEFAULT NULL AFTER `created_by`, ADD `deleted` INT NOT NULL DEFAULT '0' AFTER `updated_by`, ADD `deleted_at` DATETIME NULL DEFAULT NULL AFTER `deleted`, ADD `deleted_by` INT NULL DEFAULT NULL AFTER `deleted_at`;


20-09-2024

ALTER TABLE `tbl_unit_category` ADD `created_by` INT NULL DEFAULT NULL AFTER `updated_at`, ADD `updated_by` INT NULL DEFAULT NULL AFTER `created_by`, ADD `deleted` INT NOT NULL DEFAULT '0' AFTER `updated_by`, ADD `deleted_at` DATETIME NULL DEFAULT NULL AFTER `deleted`, ADD `deleted_by` INT NULL DEFAULT NULL AFTER `deleted_at`;

ALTER TABLE `tbl_payment_terms` ADD `created_by` INT NULL DEFAULT NULL AFTER `updated_at`, ADD `updated_by` INT NULL DEFAULT NULL AFTER `created_by`, ADD `deleted` INT NOT NULL DEFAULT '0' AFTER `updated_by`, ADD `deleted_at` DATETIME NULL DEFAULT NULL AFTER `deleted`, ADD `deleted_by` INT NULL DEFAULT NULL AFTER `deleted_at`;

ALTER TABLE `tbl_incoterms` ADD `created_by` INT NULL DEFAULT NULL AFTER `updated_at`, ADD `updated_by` INT NULL DEFAULT NULL AFTER `created_by`, ADD `deleted` INT NOT NULL DEFAULT '0' AFTER `updated_by`, ADD `deleted_at` DATETIME NULL DEFAULT NULL AFTER `deleted`, ADD `deleted_by` INT NULL DEFAULT NULL AFTER `deleted_at`;

ALTER TABLE `tbl_transport` ADD `created_by` INT NULL DEFAULT NULL AFTER `updated_at`, ADD `updated_by` INT NULL DEFAULT NULL AFTER `created_by`, ADD `deleted` INT NOT NULL DEFAULT '0' AFTER `updated_by`, ADD `deleted_at` DATETIME NULL DEFAULT NULL AFTER `deleted`, ADD `deleted_by` INT NULL DEFAULT NULL AFTER `deleted_at`;

ALTER TABLE `tbl_currency` ADD `created_by` INT NULL DEFAULT NULL AFTER `updated_at`, ADD `updated_by` INT NULL DEFAULT NULL AFTER `created_by`, ADD `deleted` INT NOT NULL DEFAULT '0' AFTER `updated_by`, ADD `deleted_at` DATETIME NULL DEFAULT NULL AFTER `deleted`, ADD `deleted_by` INT NULL DEFAULT NULL AFTER `deleted_at`;

ALTER TABLE `tbl_holidays` ADD `created_by` INT NULL DEFAULT NULL AFTER `updated_at`, ADD `updated_by` INT NULL DEFAULT NULL AFTER `created_by`, ADD `deleted` INT NOT NULL DEFAULT '0' AFTER `updated_by`, ADD `deleted_at` DATETIME NULL DEFAULT NULL AFTER `deleted`, ADD `deleted_by` INT NULL DEFAULT NULL AFTER `deleted_at`;

ALTER TABLE `tbl_vat_master` ADD `created_by` INT NULL DEFAULT NULL AFTER `updated_at`, ADD `updated_by` INT NULL DEFAULT NULL AFTER `created_by`, ADD `deleted` INT NOT NULL DEFAULT '0' AFTER `updated_by`, ADD `deleted_at` DATETIME NULL DEFAULT NULL AFTER `deleted`, ADD `deleted_by` INT NULL DEFAULT NULL AFTER `deleted_at`;

ALTER TABLE `tbl_salary_earninings` ADD `created_by` INT NULL DEFAULT NULL AFTER `updated_at`, ADD `updated_by` INT NULL DEFAULT NULL AFTER `created_by`, ADD `deleted` INT NOT NULL DEFAULT '0' AFTER `updated_by`, ADD `deleted_at` DATETIME NULL DEFAULT NULL AFTER `deleted`, ADD `deleted_by` INT NULL DEFAULT NULL AFTER `deleted_at`;

ALTER TABLE `tbl_salary_deductions` ADD `created_by` INT NULL DEFAULT NULL AFTER `updated_at`, ADD `updated_by` INT NULL DEFAULT NULL AFTER `created_by`, ADD `deleted` INT NOT NULL DEFAULT '0' AFTER `updated_by`, ADD `deleted_at` DATETIME NULL DEFAULT NULL AFTER `deleted`, ADD `deleted_by` INT NULL DEFAULT NULL AFTER `deleted_at`;


21-04-2021

ALTER TABLE `tbl_leave_request_master` ADD `request_updated_by` INT NULL DEFAULT NULL AFTER `request_created_by`;

ALTER TABLE `tbl_leave_request_master` ADD `deleted` INT NOT NULL DEFAULT '0' AFTER `updated_at`, ADD `deleted_at` DATETIME NULL DEFAULT NULL AFTER `deleted`, ADD `deleted_by` INT NULL DEFAULT NULL AFTER `deleted_at`;

ALTER TABLE `tbl_leave_request_master` ADD `request_approve_by` INT NULL DEFAULT NULL AFTER `request_status`, ADD `request_reject_by` INT NULL DEFAULT NULL AFTER `request_approve_by`;

ALTER TABLE `tbl_ot_time` ADD `company_id` INT NULL DEFAULT NULL AFTER `id`;

ALTER TABLE `tbl_ot_time` ADD `amount` VARCHAR NULL DEFAULT NULL AFTER `total_hours`;

ALTER TABLE `tbl_ot_time` ADD `updated_by` INT NULL DEFAULT NULL AFTER `created_by`, ADD `deleted` INT NOT NULL DEFAULT '0' AFTER `updated_by`, ADD `deleted_at` DATETIME NULL DEFAULT NULL AFTER `deleted`, ADD `deleted_by` INT NULL DEFAULT NULL AFTER `deleted_at`;

ALTER TABLE `tbl_ot_time` ADD `updated_at` DATETIME NULL DEFAULT NULL AFTER `created_at`;



24-09-2024

DELETE FROM `tbl_menu` WHERE `tbl_menu`.`id` = 12";

ALTER TABLE `financialyear` CHANGE `createdBy` `created_by` INT NOT NULL, CHANGE `createdTime` `created_at` DATETIME NULL DEFAULT NULL, CHANGE `modifiedBy` `updated_by` INT NOT NULL, CHANGE `modifiedTime` `updated_at` DATETIME NULL DEFAULT NULL;

ALTER TABLE `financialyear` ADD `deleted` INT NULL DEFAULT NULL AFTER `updated_at`, ADD `deleted_at` DATETIME NULL DEFAULT NULL AFTER `deleted`, ADD `deleted_by` INT NULL DEFAULT NULL AFTER `deleted_at`;

ALTER TABLE `financialyear` CHANGE `deleted` `deleted` INT NULL DEFAULT '0';

ALTER TABLE `financialyear` CHANGE `updated_by` `updated_by` INT NULL DEFAULT NULL;

ALTER TABLE `tbl_users` ADD `user_manager_id` INT NOT NULL AFTER `user_status`;


03/10/2024

ALTER TABLE `tbl_bom` ADD `volume` INT NULL DEFAULT NULL AFTER `company_id`, ADD `fixiation1` INT NULL DEFAULT NULL AFTER `volume`, ADD `layer1` INT NOT NULL AFTER `fixiation1`, ADD `layer2` INT NOT NULL AFTER `layer1`, ADD `core` INT NULL DEFAULT NULL AFTER `layer2`, ADD `layer3` INT NOT NULL AFTER `core`, ADD `layer4` INT NOT NULL AFTER `layer3`, ADD `fixiation2` INT NULL DEFAULT NULL AFTER `layer4`, ADD `diameter` INT NULL DEFAULT NULL AFTER `fixiation2`, ADD `width` INT NULL DEFAULT NULL AFTER `diameter`, ADD `length` INT NULL DEFAULT NULL AFTER `width`, ADD `full_weight` INT NULL DEFAULT NULL AFTER `length`, ADD `production_target` INT NULL DEFAULT NULL AFTER `full_weight`, ADD `production_actual` INT NOT NULL AFTER `production_target`, ADD `product_id` INT NULL DEFAULT NULL AFTER `production_actual`, ADD `subset_id` INT NOT NULL AFTER `product_id`, ADD `total` INT NULL DEFAULT NULL AFTER `subset_id`;


18/10/2024

ALTER TABLE loan_master ADD loan_category VARCHAR(255) NULL DEFAULT NULL AFTER employee_id;

ALTER TABLE `tbl_department_category` ADD `company_id` INT NOT NULL AFTER `id`;

ALTER TABLE `tbl_desigantion_category` ADD `company_id` INT NOT NULL AFTER `id`;

ALTER TABLE `tbl_salary_earninings` ADD `company_id` INT NOT NULL AFTER `id`;

ALTER TABLE `tbl_salary_deductions` ADD `company_id` INT NOT NULL AFTER `id`;

ALTER TABLE `tbl_shift_timing_master` ADD `company_id` INT NOT NULL AFTER `id`;

ALTER TABLE `tbl_vat_master` ADD `company_id` INT NOT NULL AFTER `id`;

ALTER TABLE `tbl_unit_category` ADD `company_id` INT NOT NULL AFTER `id`;