ALTER TABLE  `maintenance_contarct` ADD  `maintenance_contarct_type` ENUM(  'completely',  'tender' ) NULL ;

-- 20/12/17
ALTER TABLE  `profile_settings` ADD  `customer_profile_id` INT( 11 ) NOT NULL ;
ALTER TABLE  `prop_customer` ADD  `prop_customer_user_id` INT( 11 ) NOT NULL ;

--23/12/17
INSERT INTO  `erp`.`menu` (
`module_id` ,
`parent_menu_id` ,
`caption` ,
`target` ,
`sort` ,
`active`
)
VALUES (
 '10',  '0',  'SHIFT DETAILS',  'hr/master/manage_shift_details',  '9',  '1'
);
--28/12/17
ALTER TABLE  `hr_leave_allocation_details` ADD FOREIGN KEY (  `hr_leave_allocation_id` ) REFERENCES  `erp`.`hr_leave_allocation` (
`hr_leave_allocation_id`
) ON DELETE CASCADE ON UPDATE RESTRICT ;
ALTER TABLE  `hr_leave_allocation` ADD INDEX (  `hr_leave_allocation_designation` ) ;

ALTER TABLE  `hr_leave_allocation` ADD FOREIGN KEY (  `hr_leave_allocation_designation` ) REFERENCES  `erp`.`hr_designation` (
`hr_designation_id`
) ON DELETE CASCADE ON UPDATE RESTRICT ;

--29/12/17
INSERT INTO  `erp`.`menu` (

`module_id` ,
`parent_menu_id` ,
`caption` ,
`target` ,
`sort` ,
`active`
)
VALUES (
  '15',  '0',  'Leave Report',  'hr/report/manage_leave',  '2',  '1'
);
INSERT INTO  `erp`.`menu` (
`module_id` ,
`parent_menu_id` ,
`caption` ,
`target` ,
`sort` ,
`active`
)
VALUES (
 '15',  '0',  'Shift Report',  'hr/report/manage_shift',  '4',  '1'
);
--3/1/17
ALTER TABLE  `account_group` ADD  `account_group_count` INT( 100 ) NOT NULL ;


INSERT INTO `menu` (`menu_id`, `module_id`, `parent_menu_id`, `caption`, `target`, `sort`, `active`, `project_id`) VALUES (NULL, '10', '148', 'Expiry Report', 'hr/report/manage_expiry', '7', '1', '1,2,3,4');

INSERT INTO `menu` (`menu_id`, `module_id`, `parent_menu_id`, `caption`, `target`, `sort`, `active`, `project_id`) VALUES (NULL, '10', '148', 'Employee Late Report', 'hr/report/manage_employee_late', '8', '1', '1,2,3,4');


ALTER TABLE  `pos_purchase_return` CHANGE  `credit_account`  `credit_account` INT( 11 ) NULL ;

15/09/2018
UPDATE  `greeniit_crm`.`menu` SET  `sort` =  '1' WHERE  `menu`.`menu_id` =110;
UPDATE  `greeniit_crm`.`menu` SET  `sort` =  '2' WHERE  `menu`.`menu_id` =109;
UPDATE  `greeniit_crm`.`menu` SET  `sort` =  '3' WHERE  `menu`.`menu_id` =111;
UPDATE  `greeniit_crm`.`menu` SET  `sort` =  '4' WHERE  `menu`.`menu_id` =108;
UPDATE  `greeniit_crm`.`menu` SET  `sort` =  '5' WHERE  `menu`.`menu_id` =120;
UPDATE  `greeniit_crm`.`menu` SET  `sort` =  '6' WHERE  `menu`.`menu_id` =132;
UPDATE  `greeniit_crm`.`menu` SET  `sort` =  '7' WHERE  `menu`.`menu_id` =119;

18/09/2018
ALTER TABLE  `hr_employees` ADD  `hr_employees_grade_id` INT( 11 ) NULL ;

01/10/2018
ALTER TABLE  `hr_leave_application` ADD  `days` ENUM(  'full_day',  'half_day' ) NOT NULL DEFAULT  'full_day';