--  16/12/2017


ALTER TABLE  `user` ADD  `phone` BIGINT NOT NULL ,
ADD  `email` VARCHAR( 255 ) NOT NULL ;

ALTER TABLE  `prop_item` CHANGE  `prop_item_parchasing_rate`  `prop_item_parchasing_rate` DOUBLE NOT NULL ;



-- 18/12/2017


ALTER TABLE  `prop_customer` ADD  `prop_customer_passport_no` VARCHAR( 255 ) NOT NULL ,
ADD  `prop_customer_country` VARCHAR( 255 ) NOT NULL ,
ADD  `prop_customer_gender` ENUM(  'male',  'female' ) NOT NULL ;
ALTER TABLE  `prop_customer` CHANGE  `gender`  `	prop_customer_gender` ENUM(  'male',  'female' ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ;


-- 19/12/2017

ALTER TABLE  `prop_lease_payment_details` ADD  `prop_lease_payment_details_service_amount` DOUBLE NOT NULL ;


-- 20/12/2017

--
-- Table structure for table `prop_item_stock`
--

CREATE TABLE IF NOT EXISTS `prop_item_stock` (
  `prop_item_stock_id` int(11) NOT NULL AUTO_INCREMENT,
  `prop_item_id` int(11) NOT NULL,
  `prop_godown_id` int(11) NOT NULL,
  `prop_item_stock_qty` int(11) NOT NULL,
  PRIMARY KEY (`prop_item_stock`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;




INSERT INTO  `erp`.`menu` (
`menu_id` ,
`module_id` ,
`parent_menu_id` ,
`caption` ,
`target` ,
`sort` ,
`active`
)
VALUES (
NULL ,  '13',  '0',  'Item Stock',  'property/master/manage_item_stock',  '7',  '1'
);


-- 29/12/2017



INSERT INTO `erp`.`menu` (`menu_id`, `module_id`, `parent_menu_id`, `caption`, `target`, `sort`, `active`) VALUES (NULL, '15', '0', 'Leave Balance Report', 'hr/report/manage_leave_balance', '3', '1');

-- 1/01/2018

CREATE TABLE IF NOT EXISTS `hr_employee_overtime` (
  `hr_employee_overtime_id` int(11) NOT NULL AUTO_INCREMENT,
  `hr_employee_overtime_salary_id` int(11) NOT NULL,
  `hr_employee_overtime_type` varchar(100) NOT NULL,
  `hr_employee_overtime_value` float NOT NULL,
  PRIMARY KEY (`hr_employee_overtime_id`),
  KEY `hr_employee_overtime_salary_id` (`hr_employee_overtime_salary_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

ALTER TABLE  `hr_employee_salary` ADD  `hr_employee_salary_isovertime` ENUM(  '1',  '0' ) NOT NULL ;

ALTER TABLE  `hr_employee_overtime` CHANGE  `hr_employee_overtime_type`  `hr_employee_overtime_type` ENUM(  'holiday_hr', 'normal_hr' ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ;

-- 03/01/2018
INSERT INTO `erp`.`menu` (`menu_id`, `module_id`, `parent_menu_id`, `caption`, `target`, `sort`, `active`) VALUES (NULL, '16', '0', 'General Settings', 'accounting/master/manage_general_settings', '5', '1');