[8/28 11:01 AM] Shanmugam B
alter table hrm_Mst_tbranch

add column msgsend_manger char(1) DEFAULT NULL;

alter table hrm_Mst_tbranch

add column owner_number varchar(24) DEFAULT NULL;

alter table hrm_Mst_tbranch

add column msgsend_owner char(1) DEFAULT NULL;
 
alter table adm_mst_tuser

add column user_type varchar(64) Default null;
 
alter table adm_mst_tuser

add column kot_user char(1) Default 'N';
 
alter table adm_Mst_tcompany

add column enable_kot char(1) default 'N';

[05/09/2024] Shanmugam B
alter table hrm_mst_temployee add column file_name varchar (64) default null
 /*
-- Query: select * from adm_mst_tmoduleangular where module_name='Error Manager'
LIMIT 0, 1000
 
-- Date: 2024-06-28 20:15
*/
INSERT INTO `` (`module_gid`,`module_gid_parent`,`module_code`,`display_order`,`module_link`,`menu_level`,`max_menulevel`,`module_name`,`status`,`image_url`,`group_type`,`modulemanager_gid`,`breadcrumb_name`,`approval_flag`,`approval_tablename`,`approval_type`,`approval_limit`,`module_flag`,`created_by`,`created_date`,`updated_by`,`updated_date`,`lw_flag`,`sref`,`icon`,`shopify_flag`,`icon_name`) VALUES ('SYSSETERM','SYSSET','SYSSETERM',8,'ems_system/sys_mst_errormanager.aspx',3,NULL,'Error Manager','1','../images/ico_hrpolicymanager_RS.gif','SETTINGS','','Error Manager','','','','N','N',NULL,NULL,NULL,NULL,'Y','/system/SysMstErrormanagement',NULL,NULL,NULL);

13-09-2024---Bharathi
node --max_old_space_size=8192 ./node_modules/@angular/cli/bin/ng serve
ALTER TABLE hrm_mst_tbranch ADD status CHAR(2) NOT NULL DEFAULT 'Y';

17/09/2024--Bharathi
CREATE TABLE `sys_mst_tbloodgroup` (   `bloodgroup_gid` varchar(45) NOT NULL,   `bloodgroup_name` varchar(256) DEFAULT NULL,   `lms_code` varchar(125) DEFAULT NULL,   `bureau_code` varchar(125) DEFAULT NULL,   `status` char(1) DEFAULT 'Y',   `remarks` longtext,   `created_by` varchar(45) DEFAULT NULL,   `created_date` datetime DEFAULT NULL,   `updated_by` varchar(45) DEFAULT NULL,   `updated_date` datetime DEFAULT NULL,   `delete_flag` char(1) DEFAULT 'N',   `deleted_date` datetime DEFAULT NULL,   `deleted_by` varchar(45) DEFAULT NULL,   `api_code` varchar(65) DEFAULT NULL,   PRIMARY KEY (`bloodgroup_gid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1
ALTER TABLE adm_mst_tentity ADD COLUMN status CHAR(2) NOT NULL DEFAULT 'Y';
ALTER TABLE adm_mst_tdesignation ADD COLUMN designation_flag CHAR(2) NOT NULL DEFAULT 'Y';