14/08/2024

    update adm_mst_tmoduleangular set module_gid='ITS' where sref='/ITS/ItsMstDashboard'

23/08/2024-sathish

alter table tsk_trn_ttasksheet add sub_task varchar(256) default null;
alter table tsk_mst_ttaskmanagement add assigned_member varchar(256) default null;
alter table tsk_mst_ttaskmanagement add assigned_member_gid varchar(45) default null;

update adm_mst_tmoduleangular set module_gid='ITS' where sref='/ITS/ItsMstDashboard';

10/09/2024-Bala

insert into adm_mst_tmoduleangular(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, k_sref)
values('ITSMGTTRA', 'ITSMGT', 'ITSMGTTRA', '5', '', '3', NULL, 'Deployment Tracker', NULL, NULL, NULL, NULL, 'Deployment Tracker', NULL, NULL, NULL, 'N', 'N', NULL, NULL, NULL, NULL, 'Y', 'ITS/ItsMstDeploymentTracker', NULL, NULL, NULL, NULL
);

CREATE TABLE `tsk_mst_tdeployment_tracker` (
  `deployment_trackergid` varchar(45) NOT NULL,
  `version` varchar(30) default null,
  `version_number` varchar(256) DEFAULT NULL,
  `file_name` varchar(100) DEFAULT NULL,
  `file_gid` varchar(45) DEFAULT NULL,
  `dll_status` varchar(20) default null,
  `dependency_status`varchar(20) default null,
  `routes_status`varchar(20) default null,
  `script_status`varchar(20) default null,
  `approval_name` varchar(256) default null,
    `file_description` text default null,
  `created_by` varchar(64) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
   `updated_by` varchar(64) DEFAULT NULL,
  `updated_date` datetime DEFAULT NULL,
  PRIMARY KEY (`deployment_trackergid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

  insert into adm_mst_tsequence(sequence_gid, sequence_code, sequence_name, sequence_format, sequence_curval, sequence_flag, branch_flag, department_flag, year_flag, month_flag, location_flag, company_code, delimeter, runningno_prefix, finyear, carry_forward, created_by, created_date, updated_by, updated_date) values
('SSQM2407301287', 'DPTR', 'deployment_trackergid', '4', '0', 'N', 'N', 'N', 'N', '', 'N', '', '', '', '2024', 'N', NULL, NULL, NULL, NULL
);  

 CREATE TABLE `tsk_mst_tscript` (
  `script_gid` varchar(45) NOT NULL,
  `deployment_trackergid` varchar(45) DEFAULT NULL,
  `docupload_type` text,
  `file_path` text,
  `created_by` varchar(64) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  PRIMARY KEY (`script_gid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  insert into adm_mst_tsequence(sequence_gid, sequence_code, sequence_name, sequence_format, sequence_curval, sequence_flag, branch_flag, department_flag, year_flag, month_flag, location_flag, company_code, delimeter, runningno_prefix, finyear, carry_forward, created_by, created_date, updated_by, updated_date) values
('SSQM2407301288', 'SCPG', 'script_gid', '4', '0', 'N', 'N', 'N', 'N', '', 'N', '', '', '', '2024', 'N', NULL, NULL, NULL, NULL
);  




CREATE TABLE `tsk_mst_tdeploy2module` (
  `deploymodule_gid` varchar(45) NOT NULL,
  `deployment_trackergid` varchar(45) DEFAULT NULL,
  `module_name` varchar(256) DEFAULT NULL,
  `module_gid` varchar(45) DEFAULT NULL,
  `created_by` varchar(64) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  PRIMARY KEY (`deploymodule_gid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

select * from adm_mst_tsequence where sequence_code='DEME';
 insert into adm_mst_tsequence(sequence_gid, sequence_code, sequence_name, sequence_format, sequence_curval, sequence_flag, branch_flag, department_flag, year_flag, month_flag, location_flag, company_code, delimeter, runningno_prefix, finyear, carry_forward, created_by, created_date, updated_by, updated_date) values
('SSQM2407301289', 'D2ME', 'deploymodule_gid', '4', '0', 'N', 'N', 'N', 'N', '', 'N', '', '', '', '2024', 'N', NULL, NULL, NULL, NULL
);
CREATE TABLE `tsk_mst_tdependencymodule` (
  `depency_gid` varchar(45) NOT NULL,
  `deployment_trackergid` varchar(45) DEFAULT NULL,
  `dependency_module` varchar(256) DEFAULT NULL,
  `dependency_module_gid` varchar(45) DEFAULT NULL,
  `created_by` varchar(64) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  PRIMARY KEY (`depency_gid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 insert into adm_mst_tsequence(sequence_gid, sequence_code, sequence_name, sequence_format, sequence_curval, sequence_flag, branch_flag, department_flag, year_flag, month_flag, location_flag, company_code, delimeter, runningno_prefix, finyear, carry_forward, created_by, created_date, updated_by, updated_date) values
('SSQM2407301290', 'DEME', 'depency_gid', '4', '0', 'N', 'N', 'N', 'N', '', 'N', '', '', '', '2024', 'N', NULL, NULL, NULL, NULL
);

alter table tsk_trn_ttasksheet add task_detail varchar(64) default null;	
alter table tsk_trn_ttasksheet add updated_by varchar(64) default null;
alter table tsk_trn_ttasksheet add updated_date datetime default null;
alter table tsk_mst_ttaskmanagement add retesting_flag char(1) default 'N';