1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / projects_ilium / db /
Filename : yukesh_txt.txt
back
24-7-2025
INSERT INTO `tbl_menu` (`id`, `menu_name`, `menu_url`, `menu_icon`, `menu_order`, `menu_nav`, `menu_parent_id`, `menu_admin`, `deleted`) VALUES (NULL, 'Material Request', NULL, 'fas fa-recycle', '4', '1', '0', '0', '0');

INSERT INTO `tbl_menu` (`id`, `menu_name`, `menu_url`, `menu_icon`, `menu_order`, `menu_nav`, `menu_parent_id`, `menu_admin`, `deleted`) VALUES (NULL, 'Material Request', 'material', 'far fa-circle', '1', '1', '32', '0', '0');

25-7-2025
ALTER TABLE `tbl_material_request` ADD `request_status` INT(11) NOT NULL COMMENT '0 - No , 1 - Approve , 2 - Reject' AFTER `file`, ADD `request_approve_by` INT(11) NULL DEFAULT NULL AFTER `request_status`, ADD `request_reject_by` INT(11) NULL DEFAULT NULL AFTER `request_approve_by`;

28-7-2025
INSERT INTO `tbl_menu` (`id`, `menu_name`, `menu_url`, `menu_icon`, `menu_order`, `menu_nav`, `menu_parent_id`, `menu_admin`, `deleted`) VALUES (NULL, 'Inventory Master', NULL, 'fas fa-money-check-alt', '5', '1', '0', '0', '0');

INSERT INTO `tbl_menu` (`id`, `menu_name`, `menu_url`, `menu_icon`, `menu_order`, `menu_nav`, `menu_parent_id`, `menu_admin`, `deleted`) VALUES (NULL, 'Item Master', 'inventory_master', 'far fa-circle', '1', '1', '34', '0', '0');

INSERT INTO `tbl_menu` (`id`, `menu_name`, `menu_url`, `menu_icon`, `menu_order`, `menu_nav`, `menu_parent_id`, `menu_admin`, `deleted`) VALUES (NULL, 'Assets', 'inventory_master/assets', 'far fa-circle', '2', '1', '34', '0', '0');

INSERT INTO `tbl_menu` (`id`, `menu_name`, `menu_url`, `menu_icon`, `menu_order`, `menu_nav`, `menu_parent_id`, `menu_admin`, `deleted`) VALUES (NULL, 'Licenses', 'inventory_master/licenses', 'far fa-circle', '3', '1', '34', '0', '0');

07-08-2025
ALTER TABLE `purchasequote` ADD `request_status` INT(11) NOT NULL COMMENT '0 - No , 1 - Approve , 2 - Reject' AFTER `incoterms`, ADD `request_reason` LONGTEXT NULL DEFAULT NULL AFTER `request_status`, ADD `request_approve_by` INT(11) NULL DEFAULT NULL AFTER `request_reason`, ADD `request_reject_by` INT(11) NULL DEFAULT NULL AFTER `request_approve_by`;

ALTER TABLE `purchaseorder` ADD `request_status` INT(11) NOT NULL COMMENT '0 - No , 1 - Approve , 2 - Reject' AFTER `terms`, ADD `request_reason` LONGTEXT NULL DEFAULT NULL AFTER `request_status`, ADD `request_approve_by` INT(11) NULL DEFAULT NULL AFTER `request_reason`, ADD `request_reject_by` INT(11) NULL DEFAULT NULL AFTER `request_approve_by`;

08-08-2025
ALTER TABLE `salesorder` ADD `request_status` INT(11) NOT NULL COMMENT '0 - No , 1 - Approve , 2 - Reject' AFTER `status`, ADD `request_reason` LONGTEXT NULL DEFAULT NULL AFTER `request_status`, ADD `request_approve_by` INT(11) NULL DEFAULT NULL AFTER `request_reason`, ADD `request_reject_by` INT(11) NULL DEFAULT NULL AFTER `request_approve_by`;

ALTER TABLE `salesinvoice` ADD `request_status` INT(11) NOT NULL COMMENT '0 - No , 1 - Approve , 2 - Reject' AFTER `account_num`, ADD `request_reason` LONGTEXT NULL DEFAULT NULL AFTER `request_status`, ADD `request_approve_by` INT(11) NULL DEFAULT NULL AFTER `request_reason`, ADD `request_reject_by` INT(11) NULL DEFAULT NULL AFTER `request_approve_by`;