----------------------------------------------------------- 30.5.2024  praveen---------------------------
alter table crm_smm_tshopifyproduct add column sku varchar(160) ;

alter table crm_trn_tfiles add column leadbank_gid varchar (100),add column filename varchar(1000);

-----------------------------------------------------------3.6.2024   vishwa--------------------------
alter table crm_trn_tleadbank add column lead_type varchar(32) after main_branch;

drop  procedure crm_trn_spleadbanksummary;
DELIMITER $$
CREATE DEFINER=`Report`@`%` PROCEDURE `crm_trn_spleadbanksummary`()
BEGIN
SELECT a.leadbank_gid,b.leadbankcontact_gid,a.leadbank_pin, a.leadbank_id,a.approval_flag,m.country_name,b.mobile,a.leadbank_state,b.email,b.address1,b.address2,a.leadbank_city, a.leadbank_name,b.leadbankcontact_name,ifnull(a.customer_gid,' ') as customer_gid, 
                     a.remarks,CONCAT(IFNULL(b.leadbankcontact_name, ''),' / ',IFNULL(b.country_code1, ''), IFNULL('-', ''),IFNULL(b.mobile, ''),' / ',IFNULL(b.email, '')) AS contact_details,a.lead_status,  
                     concat(d.region_name,' / ',a.leadbank_city,' / ',a.leadbank_state) as region_name,  
                     concat(b.address1,b.address2) As address_details,a.customer_type,concat_ws('-',c.user_firstname,c.user_lastname) as created_by, 
                     date_format(a.created_date,'%d-%m-%Y') as created_date, 
                     CONCAT(CASE WHEN e.source_name IS NULL THEN '' ELSE e.source_name END,' / ',CASE WHEN l.categoryindustry_name IS NULL THEN '' ELSE l.categoryindustry_name END) AS source_name, 
                     ( g.assign_to )as assigned ,   
                     concat(j.user_firstname,' ',j.user_lastname) as assign_to,a.lead_type from crm_trn_tleadbank a   
                     left join crm_trn_tleadbankcontact b on a.leadbank_gid=b.leadbank_gid   
                     left join crm_mst_tregion d on a.leadbank_region=d.region_gid   
                     left join crm_mst_tsource e on a.source_gid=e.source_gid   
                     left join crm_mst_tcategoryindustry l on a.categoryindustry_gid = l.categoryindustry_gid   
                     left join hrm_mst_temployee k on a.created_by=k.employee_gid   
                     left join adm_mst_tuser c on  c.user_gid = k.user_gid   
                     left join crm_trn_tlead2campaign g on a.leadbank_gid = g.leadbank_gid  
                     left join hrm_mst_temployee h on  g.assign_to = h.employee_gid   
                     left join adm_mst_tuser j on h.user_gid = j.user_gid  
                     left join adm_mst_tcountry m on a.leadbank_country = m.country_gid  
                     where a.leadbank_gid is not null
                     group by a.leadbank_gid Order by date(a.created_date) desc,a.created_date asc,a.leadbank_gid desc;
END $$
DELIMITER ;

---------------------------------------------------------------4.6.24  karthi-------------------------------
INSERT INTO  `adm_mst_tmoduleangular` (`module_gid`, `module_gid_parent`, `module_code`, `display_order`, `menu_level`, `module_name`, `status`, `group_type`, `breadcrumb_name`, `approval_limit`, `module_flag`, `lw_flag`,`sref`) VALUES ('MKTLEDLAY', 'MKTLED', 'MKTLEDLAY', '1404', '3', 'Advocacy', '1', 'Lead', 'Advocacy', 'N', 'N', 'Y','/crm/CrmTrnAdvocacymanagement');

----------------------------------------------------------------5.6.24 praveen-----------------------
UPDATE `adm_mst_tmoduleangular` SET `module_gid_parent` = 'MKTLEG' WHERE (`module_gid` = 'MKTECMWS');
UPDATE `adm_mst_tmoduleangular` SET `module_gid_parent` = 'SMR' WHERE (`module_gid` = 'MKTECM');
UPDATE `adm_mst_tmoduleangular` SET `module_name` = 'Inside Sales', `breadcrumb_name` = 'Inside Sales' WHERE (`module_gid` = 'MKTTEM');
UPDATE `adm_mst_tmoduleangular` SET `module_name` = 'Inside Sales Team', `breadcrumb_name` = 'Inside Sales Team' WHERE (`module_gid` = 'MKTTLCTCT');
UPDATE `adm_mst_tmoduleangular` SET `module_name` = 'My Inside Sales', `breadcrumb_name` = 'My Inside Sales' WHERE (`module_gid` = 'MKTTLCMYC');
UPDATE `adm_mst_tmoduleangular` SET `module_name` = 'Inside Sales Manager', `breadcrumb_name` = 'Inside Sales Manager' WHERE (`module_gid` = 'MKTTLCTCM');

---------------------------------------------------------------5.6.24   vishwa-------------------------------
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`, `finyear`, `carry_forward`) VALUES ('SSQM2406050001', 'ADML', 'Advocacy Management', '4', '0', 'N', 'N', 'N', 'N', 'N', 'N', '2023', 'N');

CREATE TABLE `crm_trn_tadvocacy` (
  `advocacy_gid` varchar(32) NOT NULL,
  `reference_gid` int(16) NOT NULL AUTO_INCREMENT,
  `advocacy_leadbankgid` varchar(32) DEFAULT NULL,
  `reference_leadbankgid` varchar(32) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `created_by` varchar(32) DEFAULT NULL,
  `updated_date` varchar(32) DEFAULT NULL,
  `updated_by` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`advocacy_gid`),
  UNIQUE KEY `reference_gid` (`reference_gid`)
);

--------------------------------------------------6.6.24 karthi-------------------------------
CREATE TABLE `crm_trn_toutlooktemplate` ( 

   `template_gid` int(11) NOT NULL AUTO_INCREMENT, 

   `template_name` varchar(1024) DEFAULT NULL, 

   `template_subject` varchar(1024) DEFAULT NULL, 

   `template_body` longtext, 

   `template_flag` varchar(1) DEFAULT 'Y', 

   `created_by` varchar(64) DEFAULT NULL, 

   `created_date` datetime DEFAULT NULL, 

   PRIMARY KEY (`template_gid`) 

 ) ; 

CREATE TABLE `crm_smm_outlook_service` ( 

   `s_no` int(11) NOT NULL AUTO_INCREMENT, 

   `client_id` longtext, 

   `client_secret` longtext, 

   `tenant_id` longtext, 

   `outlook_status` varchar(2) DEFAULT NULL, 

   `created_date` datetime DEFAULT NULL, 

   `created_by` varchar(64) DEFAULT NULL, 

   `updated_by` varchar(64) DEFAULT NULL, 

   `updated_date` datetime DEFAULT NULL, 

   PRIMARY KEY (`s_no`) );
alter table crm_smm_outlook_service add column outlook_status varchar(2) after tenant_id;
alter table crm_smm_outlook_service add column outlook_status varchar(2) after tenant_id; 

---------------------------------------------------6.6.24 praveen-----------------------
INSERT INTO  `adm_mst_tsequence` (`sequence_gid`, `sequence_code`, `sequence_name`, `sequence_format`, `sequence_curval`, `sequence_flag`, `branch_flag`, `department_flag`, `year_flag`, `location_flag`, `finyear`, `carry_forward`) VALUES ('SSQM2006160001', 'CO2M', 'Contact2Mobile', '4', '0', 'N', 'N', 'N', 'N', 'N', '2023', 'N');
 
INSERT INTO  `adm_mst_tsequence` (`sequence_gid`, `sequence_code`, `sequence_name`, `sequence_format`, `sequence_curval`, `sequence_flag`, `branch_flag`, `department_flag`, `year_flag`, `location_flag`, `finyear`, `carry_forward`) VALUES ('SSQM2006160002', 'CO2E', 'Contact2Email', '4', '0', 'N', 'N', 'N', 'N', 'N', '2023', 'N');
 
INSERT INTO  `adm_mst_tsequence` (`sequence_gid`, `sequence_code`, `sequence_name`, `sequence_format`, `sequence_curval`, `sequence_flag`, `branch_flag`, `department_flag`, `year_flag`, `location_flag`, `finyear`, `carry_forward`) VALUES ('SSQM2006160003', 'COGT', 'Contact GST', '4', '0', 'N', 'N', 'N', 'N', 'N', '2023', 'N');
 
INSERT INTO  `adm_mst_tsequence` (`sequence_gid`, `sequence_code`, `sequence_name`, `sequence_format`, `sequence_curval`, `sequence_flag`, `branch_flag`, `department_flag`, `year_flag`, `location_flag`, `finyear`, `carry_forward`) VALUES ('SSQM2006160004', 'COAD', 'Contact Address', '4', '0', 'N', 'N', 'N', 'N', 'N', '2023', 'N');


INSERT INTO  `adm_mst_tsequence` (`sequence_gid`, `sequence_code`, `sequence_name`, `sequence_format`, `sequence_curval`, `sequence_flag`, `branch_flag`, `department_flag`, `year_flag`, `location_flag`, `finyear`, `carry_forward`) VALUES ('SSQM2006160006', 'COPR', 'Contact Promoter', '4', '0', 'N', 'N', 'N', 'N', 'N', '2023', 'N');
 INSERT INTO  `adm_mst_tsequence` (`sequence_gid`, `sequence_code`, `sequence_name`, `sequence_format`, `sequence_curval`, `sequence_flag`, `branch_flag`, `department_flag`, `year_flag`, `location_flag`, `finyear`, `carry_forward`) VALUES ('SSQM2006160007', 'COGR', 'Contact Director', '4', '0', 'N', 'N', 'N', 'N', 'N', '2023', 'N');
 
 alter table  crm_trn_tleadbank add column leadbankcountry_gid varchar (248) after leadbank_country; 

alter table crm_mst_tcontact2promotor change contact_gid  leadbank_gid varchar(128); 

alter table crm_mst_tcontact2director change contact_gid  leadbank_gid varchar(128); 

---------------------------------------------------------10.06.2024  Karthik---------------------------------------------------------
CREATE TABLE crm_smm_tgraphtoken(
    token varchar(2500),
    expiry_time  DATETIME DEFAULT NULL
);

CREATE TABLE `crm_trn_toutlook` (
   `mail_gid` int(11) NOT NULL AUTO_INCREMENT,
   `from_mailaddress` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
   `to_mailaddress` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
   `mail_subject` longtext,
   `mail_body` longtext,
   `sent_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
   `sent_date` datetime DEFAULT NULL,
   `template_gid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
   `leadbank_gid` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
   PRIMARY KEY (`mail_gid`),
   KEY `mail_gid` (`mail_gid`)
 ) ;
 
alter table crm_trn_toutlook add column sent_flag varchar(1) default 'Y' after mail_body;

-----------------------------------------------------------12.06.2024  Karthik --------------------------------------------------------
INSERT INTO `crm_mst_tleadstage` (`leadstage_gid`,`leadstage_name`,`is_fixed`,`created_by`,`updated_by`,`created_date`,`updated_date`) VALUES (1,'Awareness','Y',NULL,NULL,NULL,NULL);
INSERT INTO `crm_mst_tleadstage` (`leadstage_gid`,`leadstage_name`,`is_fixed`,`created_by`,`updated_by`,`created_date`,`updated_date`) VALUES (2,'Interest','Y',NULL,NULL,NULL,NULL);
INSERT INTO `crm_mst_tleadstage` (`leadstage_gid`,`leadstage_name`,`is_fixed`,`created_by`,`updated_by`,`created_date`,`updated_date`) VALUES (3,'Evaluation','Y',NULL,NULL,NULL,NULL);
INSERT INTO `crm_mst_tleadstage` (`leadstage_gid`,`leadstage_name`,`is_fixed`,`created_by`,`updated_by`,`created_date`,`updated_date`) VALUES (4,'Decision','y',NULL,NULL,NULL,NULL);
INSERT INTO `crm_mst_tleadstage` (`leadstage_gid`,`leadstage_name`,`is_fixed`,`created_by`,`updated_by`,`created_date`,`updated_date`) VALUES (5,'Drop','Y',NULL,NULL,NULL,NULL);
INSERT INTO `crm_mst_tleadstage` (`leadstage_gid`,`leadstage_name`,`is_fixed`,`created_by`,`updated_by`,`created_date`,`updated_date`) VALUES (6,'Purchase','Y',NULL,NULL,NULL,NULL);
INSERT INTO `crm_mst_tleadstage` (`leadstage_gid`,`leadstage_name`,`is_fixed`,`created_by`,`updated_by`,`created_date`,`updated_date`) VALUES (7,'Consideration','Y',NULL,NULL,NULL,NULL);

------------------------------13.06.2024 praveen-------------------------
CREATE TABLE crm_mst_tconstitution (

	constitution_gid VARCHAR(45) NOT NULL,

	constitution_code VARCHAR(45) NULL,

	constitution_name VARCHAR(64) NULL,

	created_by VARCHAR(64) NULL,

	created_date DATETIME NULL,

	updated_by VARCHAR(64) NULL,

	updated_date DATETIME NULL,

	status CHAR(1) NULL,

	remarks TEXT NULL,

    PRIMARY KEY (`constitution_gid`)

);

INSERT INTO `adm_mst_tsequence` (`sequence_gid`, `sequence_code`, `sequence_name`, `sequence_format`, `sequence_curval`, `sequence_flag`, `branch_flag`, `department_flag`, `year_flag`, `location_flag`, `finyear`, `carry_forward`) VALUES ('SSQM2006150012', 'AENG', 'Constitution Gid', '4', '0', 'N', 'N', 'N', 'N', 'N', '2023', 'N');

INSERT INTO `adm_mst_tsequence` (`sequence_gid`, `sequence_code`, `sequence_name`, `sequence_format`, `sequence_curval`, `sequence_flag`, `branch_flag`, `department_flag`, `year_flag`, `location_flag`, `finyear`, `carry_forward`) VALUES ('SSQM2006150013', 'AENC', 'Constitution Code', '4', '0', 'N', 'N', 'N', 'N', 'N', '2023', 'N');

-------------------------------15.06.24  vishwa ----------------
UPDATE `adm_mst_tmoduleangular` SET `sref` = '/smr/SmrMstProductunitsSummary' WHERE (`module_gid` = 'MKTPDMPOU');
---------------------------17.06.2024 vishwa---------------------------

alter table  crm_trn_toutlook modify column mail_gid varchar(16) ;

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 ('SSQM2406170001','OILC','MailCampaign','4','0','N','N','N','N','','N',NULL,NULL,NULL,'2023','N',NULL,NULL,NULL,NULL);
----------------------------------17.06.2024 pathmanaban-----------
alter table smr_trn_tsalesorder
add column message_id varchar(120) default null;
----------------------------------18.06.2024 praveen---------------
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`, `module_gid_parent`, `module_code`, `display_order`, `menu_level`, `module_name`, `status`, `breadcrumb_name`, `approval_limit`, `module_flag`, `lw_flag`) VALUES ('MKTMAL', 'MKT', 'MKTMAL', '1007', '2', 'Mail Management', '1', 'Mail Management', 'N', 'N', 'Y');

INSERT INTO `adm_mst_tmoduleangular` (`module_gid`, `module_gid_parent`, `module_code`, `display_order`, `menu_level`, `module_name`, `status`, `breadcrumb_name`, `approval_limit`, `module_flag`, `lw_flag`, `sref`) VALUES ('MKTMALM', 'MKTMAL', 'MKTMALM', '1001', '3', 'Inbox', '1', 'Inbox', 'N', 'N', 'Y', 'crm/CrmSmmGmailcampaignsummary');

INSERT INTO `adm_mst_tmoduleangular` (`module_gid`, `module_gid_parent`, `module_code`, `display_order`, `menu_level`, `module_name`, `status`, `breadcrumb_name`, `approval_limit`, `module_flag`, `lw_flag`, `sref`) VALUES ('MKTMACM', 'MKTMAL', 'MKTMACM', '1002', '3', 'Compose Mail', '1', 'Compose Mail', 'N', 'N', 'Y', ' ');

INSERT INTO `adm_mst_tmoduleangular` (`module_gid`, `module_gid_parent`, `module_code`, `display_order`, `menu_level`, `module_name`, `status`, `breadcrumb_name`, `approval_limit`, `module_flag`, `lw_flag`, `sref`) VALUES ('MKTMALF', 'MKTMAL', 'MKTMALF', '1003', '3', 'Mail Folders', '1', 'Mail Folders', 'N', 'N', 'Y', ' ');

INSERT INTO `adm_mst_tmoduleangular` (`module_gid`, `module_gid_parent`, `module_code`, `display_order`, `menu_level`, `module_name`, `status`, `breadcrumb_name`, `approval_limit`, `module_flag`, `lw_flag`, `sref`) VALUES ('MKTMALS', 'MKTMAL', 'MKTMALS', '1004', '3', 'Sent Items', '1', 'Sent Items', 'N', 'N', 'Y', ' ');

#------------------------------- 2nd section of script---------------------
#---------#---------#---------------13.06.2024  praveeen#---------#---------
CREATE TABLE crm_mst_tconstitution (
	constitution_gid VARCHAR(45) NOT NULL,
	constitution_code VARCHAR(45) NULL,
	constitution_name VARCHAR(64) NULL,
	created_by VARCHAR(64) NULL,
	created_date DATETIME NULL,
	updated_by VARCHAR(64) NULL,
	updated_date DATETIME NULL,
	status CHAR(1) NULL,
	remarks TEXT NULL,
    PRIMARY KEY (`constitution_gid`)
);

INSERT INTO `adm_mst_tsequence` (`sequence_gid`, `sequence_code`, `sequence_name`, `sequence_format`, `sequence_curval`, `sequence_flag`, `branch_flag`, `department_flag`, `year_flag`, `location_flag`, `finyear`, `carry_forward`) VALUES ('SSQM2006150012', 'AENG', 'Constitution Gid', '4', '0', 'N', 'N', 'N', 'N', 'N', '2024', 'N');
INSERT INTO `adm_mst_tsequence` (`sequence_gid`, `sequence_code`, `sequence_name`, `sequence_format`, `sequence_curval`, `sequence_flag`, `branch_flag`, `department_flag`, `year_flag`, `location_flag`, `finyear`, `carry_forward`) VALUES ('SSQM2006150013', 'AENC', 'Constitution Code', '4', '0', 'N', 'N', 'N', 'N', 'N', '2024', 'N');

#---------#---------#---------#---------#----------15.06.2024 vishwa#------------
UPDATE `adm_mst_tmoduleangular` SET `sref` = '/smr/SmrMstProductunitsSummary' WHERE (`module_gid` = 'MKTPDMPOU');

#---------#---------#---------#------------ 17.06.24 karthi#---------
alter table  crm_trn_toutlook modify column mail_gid varchar(16) ;
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 ('SSQM2406170001','OILC','MailCampaign','4','0','N','N','N','N','','N',NULL,NULL,NULL,'2024','N',NULL,NULL,NULL,NULL);

#---------#---------#---------#--------------17.06.24 pathama#---------#---------#---------
alter table smr_trn_tsalesorder
add column message_id varchar(120) default null;


#---------#---------#---------#-----------------20.06.24 praveeen#---------#---------
CREATE TABLE crm_trn_tgmailinbox (
     s_no INT PRIMARY KEY AUTO_INCREMENT,
    inbox_id VARCHAR(1020),
	from_id VARCHAR(1020),
    cc VARCHAR(1020),
    sent_date LONGTEXT,
    bcc VARCHAR(1020),
    subject LONGTEXT,
    body LONGTEXT,
attachement_flag varchar(64)
);
ALTER TABLE crm_trn_tgmailinbox MODIFY subject LONGTEXT;
ALTER TABLE crm_trn_tgmailinbox MODIFY sent_date LONGTEXT;
CREATE TABLE crm_trn_tgmailinboxattachment (
  s_no INT PRIMARY KEY AUTO_INCREMENT,
    inbox_id VARCHAR(1020),
    original_filename LONGTEXT,
    modified_filename LONGTEXT,
    file_path LONGTEXT
);
 CREATE TABLE crm_trn_tgmailinboxreply (
     s_no INT PRIMARY KEY AUTO_INCREMENT,
	reply_id VARCHAR(1020),
    inbox_id VARCHAR(1020),
	from_id VARCHAR(1020),
    cc VARCHAR(1020),
    sent_date LONGTEXT,
    bcc VARCHAR(1020),
    subject LONGTEXT,
    body LONGTEXT,
attachement_flag varchar(64)
);
alter table crm_trn_tgmailinboxreply add column both_body LONGTEXT;
CREATE TABLE crm_trn_tgmailreplyattachment (
  s_no INT PRIMARY KEY AUTO_INCREMENT,
     reply_id VARCHAR(1020),
    inbox_id VARCHAR(1020),
    original_filename LONGTEXT,
    modified_filename LONGTEXT,
    file_path LONGTEXT
);

CREATE TABLE crm_trn_tgmailinboxreplyforward (
     s_no INT PRIMARY KEY AUTO_INCREMENT,
	forward_id VARCHAR(1020),
	reply_id VARCHAR(1020),
    inbox_id VARCHAR(1020),
	to_id VARCHAR(1020),
    cc VARCHAR(1020),
    sent_date LONGTEXT,
    bcc VARCHAR(1020),
    subject LONGTEXT,
    body LONGTEXT,
both_body LONGTEXT,
attachement_flag varchar(64)
);
CREATE TABLE `crm_smm_tgmailcomment` (
 
   `s_no` int(20) NOT NULL AUTO_INCREMENT,
 
   `comments` longtext,
 
   `created_date` datetime DEFAULT NULL,
 
   `created_by` varchar(64) DEFAULT NULL,
 
   `updated_date` datetime DEFAULT NULL,
 
   `updated_by` varchar(64) DEFAULT NULL,
 
   PRIMARY KEY (`s_no`)
 
) ;
alter table crm_smm_tgmailcomment add column inbox_id varchar(1020);
alter table crm_trn_tgmailinbox add column inbox_status varchar(10120);
alter table crm_trn_tgmailinboxreplyforward add column fwd_id varchar(1020);
CREATE TABLE crm_trn_tgmailllabel (
 
    s_no INT AUTO_INCREMENT PRIMARY KEY,
 
    label_id VARCHAR(255),
 
    label_name VARCHAR(255),
 
    label_type VARCHAR(50),
 
    created_by VARCHAR(50),
 
    created_date DATETIME
 
);
 
alter table crm_trn_tgmailllabel add column company_code varchar(1020);

#---------#---------#-------------21.06.2024 vishwa#------------
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 ('SSQM240621001','GILC','GmailCampaign','4','0','N','N','N','N','','N',NULL,NULL,NULL,'2024','N',NULL,NULL,NULL,NULL);
UPDATE `adm_mst_tsequence` SET `sequence_name` = 'Outlook MailCampaign' WHERE (`sequence_gid` = 'SSQM2406170001');
 ALTER TABLE crm_trn_gmail MODIFY COLUMN gmail_gid VARCHAR(32) NOT NULL;
 #---------#---------#---------#---------------21.06.24 praveeen#---------#---------
 alter table crm_trn_tgmailinbox add column shopify_enquiry varchar (64);
 
 #---------#---------#---------#----------------24.06.2024 praveeen#---------#---------
 
 INSERT INTO `adm_mst_tmoduleangular` (`module_gid`, `module_gid_parent`, `module_code`, `display_order`, `menu_level`, `module_name`, `status`, `group_type`, `breadcrumb_name`, `approval_limit`, `module_flag`, `lw_flag`, `sref`) VALUES ('MKTMSOPE', 'MKTLEG', 'MKTMSOPE', '1809', '3', 'Shopify Enquiry', '1', 'Shopify Enquiry', 'Shopify Enquiry', 'N', 'N', 'Y', '/crm/CrmTrnShopifycontactus');
 alter table crm_trn_tteleteam add column `campaign_mailid` varchar(64) DEFAULT NULL;
alter table crm_trn_tappointment modify column `appointment_date` varchar(64) DEFAULT NULL;

CREATE TABLE `crm_trn_tOpportunitylog` (
  `Opportunitylog_gid` int(64) auto_increment,
  `appointment_gid` varchar(64) DEFAULT NULL,
  `log_type` varchar(45) DEFAULT NULL,
  `log_date`  varchar(64) DEFAULT NULL,
  `log_remarks` text,
  `created_by` varchar(64) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  PRIMARY KEY (`Opportunitylog_gid`),
  KEY `Index_2` (`appointment_gid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `crm_trn_topportunitylog` (
  `Opportunitylog_gid` int(64) NOT NULL AUTO_INCREMENT,
  `appointment_gid` varchar(64) DEFAULT NULL,
  `log_type` varchar(45) DEFAULT NULL,
  `log_date` varchar(64) DEFAULT NULL,
  `log_remarks` text,
  `created_by` varchar(64) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  PRIMARY KEY (`Opportunitylog_gid`),
  KEY `Index_2` (`appointment_gid`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1

#---------#---------#---------#-------------24.05.24 vishwa#------------
UPDATE `adm_mst_tmoduleangular` SET `module_gid` = 'SMRECM', `module_code` = 'SMRECM' WHERE (`module_gid` = 'MKTECM');
UPDATE `adm_mst_tmoduleangular` SET `module_gid` = 'SMRMCNSC', `module_gid_parent` = 'SMRECM', `module_code` = 'SMRMCNSC' WHERE (`module_gid` = 'MKTMCNSC');

#---------#---------#---------#----------24.05.24 karthi#---------

 alter table crm_trn_tleadbankcontact add column `birthday` varchar(64) DEFAULT NULL;
alter table crm_trn_tleadbankcontact add column `wedding_day` varchar(64) DEFAULT NULL;
alter table crm_trn_tleadbankcontact modify column wedding_day varchar(64) DEFAULT NULL ;
alter table crm_trn_tleadbankcontact modify column birthday varchar(64) DEFAULT NULL ;

#---------#---------#---------#------------25.06.24 vishwa#------------
UPDATE `adm_mst_tmoduleangular` SET `sref` = '/crm/CrmSmmMailsent' WHERE (`module_gid` = 'MKTMALS');
UPDATE `adm_mst_tmoduleangular` SET `sref` = '/crm/CrmSmmMailscompose' WHERE (`module_gid` = 'MKTMACM');
 UPDATE `adm_mst_tmoduleangular` SET `sref` = 'crm/CrmSmmGmailInboxSummary' WHERE (`module_gid` = 'MKTMALM');
 
 #---------#---------#------------26.06.24 praveeen#---------#---------
 
 alter table crm_trn_tleadbankcontact modify column `birthday` varchar(64) DEFAULT NULL;
alter table crm_trn_tleadbankcontact modify column `wedding_day` varchar(64) DEFAULT NULL;
alter table crm_trn_twhatsappmessages add column reason longtext COLLATE utf8mb4_bin after status;


#---------#---------#-----------27.06.2024 vishwa#------------
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`, `module_gid_parent`, `module_code`, `display_order`, `menu_level`, `module_name`, `status`, `breadcrumb_name`, `approval_limit`, `module_flag`, `lw_flag`,`sref`) VALUES ('SMRSSO', 'SMRSMR', 'SMRSSO', '1600', '3', 'Shopify Orders', '1', 'Shopify Orders', 'N', 'N', 'Y','/smr/SmrTrnShopifyorders');
alter table smr_trn_tsalesorder add column source_flag varchar(64);

#---------#---------#---------#----------28.06.24 pathama#---------#---------#---------
alter table pmr_mst_tproduct
add column whatsappproduct_updatedby varchar(64) DEFAULT NULL;
 
 
alter table pmr_mst_tproduct
add column whatsapp_id varchar(120) DEFAULT 'null';
 
alter table pmr_mst_tproduct
add column whatsappstock_status char(1) DEFAULT 'Y';

#---------#---------#---------#---------#---------#---------27.06.24 praveeen#---------#---------
CREATE TABLE crm_trn_tgmailinbox (
     s_no INT PRIMARY KEY AUTO_INCREMENT,
    inbox_id VARCHAR(1020),
	from_id VARCHAR(1020),
    cc VARCHAR(1020),
    sent_date LONGTEXT,
    bcc VARCHAR(1020),
    subject LONGTEXT,
    body LONGTEXT,
attachement_flag varchar(64)
);
ALTER TABLE crm_trn_tgmailinbox MODIFY subject LONGTEXT;
ALTER TABLE crm_trn_tgmailinbox MODIFY sent_date LONGTEXT;
CREATE TABLE crm_trn_tgmailinboxattachment (
  s_no INT PRIMARY KEY AUTO_INCREMENT,
    inbox_id VARCHAR(1020),
    original_filename LONGTEXT,
    modified_filename LONGTEXT,
    file_path LONGTEXT
);
 CREATE TABLE crm_trn_tgmailinboxreply (
     s_no INT PRIMARY KEY AUTO_INCREMENT,
	reply_id VARCHAR(1020),
    inbox_id VARCHAR(1020),
	from_id VARCHAR(1020),
    cc VARCHAR(1020),
    sent_date LONGTEXT,
    bcc VARCHAR(1020),
    subject LONGTEXT,
    body LONGTEXT,
attachement_flag varchar(64)
);
alter table crm_trn_tgmailinboxreply add column both_body LONGTEXT;
CREATE TABLE crm_trn_tgmailreplyattachment (
  s_no INT PRIMARY KEY AUTO_INCREMENT,
     reply_id VARCHAR(1020),
    inbox_id VARCHAR(1020),
    original_filename LONGTEXT,
    modified_filename LONGTEXT,
    file_path LONGTEXT
);

CREATE TABLE crm_trn_tgmailinboxreplyforward (
     s_no INT PRIMARY KEY AUTO_INCREMENT,
	forward_id VARCHAR(1020),
	reply_id VARCHAR(1020),
    inbox_id VARCHAR(1020),
	to_id VARCHAR(1020),
    cc VARCHAR(1020),
    sent_date LONGTEXT,
    bcc VARCHAR(1020),
    subject LONGTEXT,
    body LONGTEXT,
both_body LONGTEXT,
attachement_flag varchar(64)
);
CREATE TABLE `crm_trn_tgmail2customer` (
  `s_no` INT(11) NOT NULL AUTO_INCREMENT,
  `inbox_id` VARCHAR(1020) NOT NULL,
  `customer_gid` VARCHAR(1020) NOT NULL,
  `created_date` DATETIME DEFAULT NULL,
  `created_by` VARCHAR(64) DEFAULT NULL,
  `updated_date` DATETIME DEFAULT NULL,
  `updated_by` VARCHAR(64) DEFAULT NULL,
  PRIMARY KEY (`s_no`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

 
 #---------#---------#---------#---------#---------27.06.24 karthi#---------
 alter table crm_trn_tgmailinbox add column leadbank_gid varchar(64);
 
#---------#---------#-----------------29.06.24 vishwa#------------
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`, `module_gid_parent`, `module_code`, `display_order`, `menu_level`, `module_name`, `status`, `breadcrumb_name`, `approval_limit`, `module_flag`, `lw_flag`, `sref`) VALUES ('MKTMALT', 'MKTMAL', 'MKTMALT', '1005', '3', 'Trash', '1', 'Trash', 'N', 'N', 'Y', '/crm/CrmSmmGmailTrashSummary');
UPDATE `adm_mst_tmoduleangular` SET `sref` = '/crm/CrmSmmGmailFolderSummary' WHERE (`module_gid` = 'MKTMALF');

drop  procedure crm_trn_spleadbanksummary;
DELIMITER $$
CREATE PROCEDURE `crm_trn_spleadbanksummary`()
BEGIN
SELECT a.leadbank_gid,b.leadbankcontact_gid,a.leadbank_pin, a.leadbank_id,a.approval_flag,m.country_name,b.mobile,a.leadbank_state,b.email,b.address1,b.address2,a.leadbank_city, a.leadbank_name,b.leadbankcontact_name,ifnull(a.customer_gid,' ') as customer_gid, 
                     a.remarks,CONCAT(IFNULL(b.leadbankcontact_name, ''),' / ',IFNULL(b.country_code1, ''), IFNULL('-', ''),IFNULL(b.mobile, ''),' / ',IFNULL(b.email, '')) AS contact_details,a.lead_status,  
                     concat(d.region_name,' / ',a.leadbank_city,' / ',a.leadbank_state) as region_name,  
                     concat(b.address1,b.address2) As address_details,a.customer_type,concat_ws('-',c.user_firstname,c.user_lastname) as created_by, 
                     date_format(a.created_date,'%d-%m-%Y') as created_date, 
                     CONCAT(CASE WHEN e.source_name IS NULL THEN '' ELSE e.source_name END,' / ',CASE WHEN l.categoryindustry_name IS NULL THEN '' ELSE l.categoryindustry_name END) AS source_name, 
                     ( g.assign_to )as assigned ,   
                     concat(j.user_firstname,' ',j.user_lastname) as assign_to,a.lead_type from crm_trn_tleadbank a   
                     left join crm_trn_tleadbankcontact b on a.leadbank_gid=b.leadbank_gid   
                     left join crm_mst_tregion d on a.leadbank_region=d.region_gid   
                     left join crm_mst_tsource e on a.source_gid=e.source_gid   
                     left join crm_mst_tcategoryindustry l on a.categoryindustry_gid = l.categoryindustry_gid   
                     left join hrm_mst_temployee k on a.created_by=k.employee_gid   
                     left join adm_mst_tuser c on  c.user_gid = k.user_gid   
                     left join crm_trn_tappointment g on a.leadbank_gid = g.leadbank_gid  
                     left join hrm_mst_temployee h on  g.assign_to = h.employee_gid   
                     left join adm_mst_tuser j on h.user_gid = j.user_gid  
                     left join adm_mst_tcountry m on a.leadbank_country = m.country_gid  
                     where a.leadbank_gid is not null
                     group by a.leadbank_gid Order by date(a.created_date) desc,a.created_date asc,a.leadbank_gid desc;
END $$
DELIMITER ;

UPDATE`adm_mst_tsequence` SET `finyear` = '2024' WHERE (`sequence_gid` = 'SSQM240621001');
UPDATE `adm_mst_tsequence` SET `finyear` = '2024' WHERE (`sequence_gid` = 'SSQM2406170001');

#--------------------------------02.07.2024 karthi-------------

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`) VALUES ('SMRSHOINV','SMRINM','SMRSHOINV',3012,NULL,3,NULL,'Shopify Inventory','1','../images/ico_invoice_report_RS.gif','Shopify Inventory',NULL,'Shopify Inventory','T',NULL,NULL,'N','N',NULL,NULL,NULL,NULL,'Y','/smr/SmrTrnShopifyinventory',NULL,NULL,NULL);

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`) VALUES ('SMRSHOPMT','SMRINM','SMRSHOPMT',3009,NULL,3,NULL,'Shopify Payment','1','../images/ico_invoice_report_RS.gif','Shopify Payment',NULL,'Shopify Payment','T',NULL,NULL,'N','N',NULL,NULL,NULL,NULL,'Y','/smr/SmrTrnShopifypayment',NULL,NULL,NULL);

INSERT INTO `adm_mst_tmoduleangular` (`module_gid`, `module_gid_parent`, `module_code`, `display_order`, `module_link`, `menu_level`, `module_name`, `status`, `breadcrumb_name`, `approval_limit`, `module_flag`, `lw_flag`, `sref`) VALUES ('SMRSHOCUS', 'SMRMST', 'SMRSHOCUS', '1402', 'ems_crm/crm_trn_shopifycustomersummary.aspx', '3', 'Shopify Customer', '1', 'Shopify Customer', 'N', 'N', 'Y', '/smr/SmrTrnShopifycustomer');

INSERT INTO`adm_mst_tmoduleangular` (`module_gid`, `module_gid_parent`, `module_code`, `display_order`, `module_link`, `menu_level`, `module_name`, `status`, `breadcrumb_name`, `approval_limit`, `module_flag`, `lw_flag`, `sref`) VALUES ('SMRSHPT', 'SMRMST', 'SMRSHPT', '1305', 'ems_crm/crm_trn_shopifyproduct.aspx', '3', 'Shopify Product', '1', 'Shopify Product', 'N', 'N', 'Y', '/smr/SmrTrnShopifyproduct');

UPDATE `adm_mst_tmoduleangular` SET `display_order` = '1305' WHERE (`module_gid` = 'SMRMSTTXDT');
UPDATE `adm_mst_tmoduleangular` SET `display_order` = '1303' WHERE (`module_gid` = 'SMRSHPT');
#---------------------------------------------03-07-2024----------------------------------------------------
UPDATE `adm_mst_tmoduleangular` SET `module_name` = 'WhatsApp', `group_type` = 'WhatsApp', `breadcrumb_name` = 'WhatsApp' WHERE (`module_gid` = 'MKTMCNWA');
#--------------------------------------------04-07-2024------------------------------------------------------
alter table smr_trn_tsalesorderdtl add column taxable varchar(8) after discount_amount;
alter table crm_trn_tleadbankcontact add column interests longtext;
##---------------------------------------------05-07-2024-----------------------------------------------------
alter table smr_trn_tsalesorderdtl add column shopify_lineitemid varchar(256);
alter table  smr_trn_tcampaign add column `team_prefix` varchar(45) DEFAULT NULL; 
#----------------------------------05.07.2024 vishwa------------
alter table smr_trn_tsalesorder add column billing_to longtext after shipping_to;
alter table crm_smm_gmail_service add column default_template longtext after  gmail_address;
ALTER TABLE crm_smm_gmail_service  ADD PRIMARY KEY (s_no), MODIFY COLUMN s_no INT(8) AUTO_INCREMENT;

UPDATE `adm_mst_tmoduleangular` SET `module_name` = 'WhatsApp', `group_type` = 'WhatsApp', `breadcrumb_name` = 'WhatsApp' WHERE (`module_gid` = 'MKTMCNWA');
alter table crm_trn_tleadbankcontact add column interests longtext;
DELETE FROM `adm_mst_tmoduleangular` WHERE (`module_gid` = 'MKTSTG');
update  boba_tea.crm_smm_gmail_service set default_template='
<p><br></p><p><br></p><p>Kind regards<br><span style="font-weight: 700;">Tina Huang</span><br><span style="font-weight: 700;">Boba Tea Company</span><br>Tel: 01164030188<br>Email:&nbsp;info@bobateacompany.co.uk<br>Website:<a>&nbsp;www.bobateacompany.co.uk</a><br>Address:&nbsp;Unit 1, Cornwall Business Centre,&nbsp;Cornwall Rd, Leicester,&nbsp;LE18 4XH<br></p><img src="https://devstoragevcx.file.core.windows.net/bobatea/BobaTea_GmailLogo.png?sv=2023-01-03&se=2024-08-08T09%3A52%3A40Z&sr=s&sp=rl&sig=6EE6hAHCBNrACkQcNjDKGG0b%2BR%2FHNUSqpmJixRXMgZ0%3D"><br></p><p></p><p><span style="font-weight: 700;">IMPORTANT</span>: The contents of this email and any attachments are confidential. They are intended for the named recipient(s) only. If you have received this email by mistake, please notify the sender immediately and do not disclose the contents to anyone or make copies thereof. World Options and subsidiaries companies is committed to ensuring the protection of personal data, for more information please read our privacy policy on our website. If you no longer want to receive emails from us, please contact our GDPR department to register your request.</p>';
#---------------------------------------10.07.2024 vishwa---------------------------
alter table cmr_smm_tshopifysalesorder add column billing_to longtext after shipping_to;
#---------------------------------------------11.07.2024-------------------
alter table smr_trn_tsalesorder add column fulfillment_status varchar(32) after billing_to ;
alter table cmr_smm_tshopifysalesorder add column fulfillment_status varchar(32) after billing_to ;
ALTER TABLE cmr_smm_tshopifysalesorderdtl CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE cmr_smm_tshopifysalesorder CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE smr_trn_tsalesorder CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE smr_trn_tsalesorderdtl CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
alter table smr_trn_tsalesorder add column shopify_customerid varchar(32) after customer_gid ;
alter table cmr_smm_tshopifysalesorder add column shopify_customerid varchar(32) after customer_gid ;
#---------------------------------15.07.2024 snehith-----------------
alter table crm_trn_tgmailinbox add column  integrated_gmail varchar (1000);
alter table crm_trn_tgmailinbox add column company_code varchar(1020);
alter table crm_trn_tgmailllabel add column integrated_gmail varchar(1000);
alter table hrm_mst_temployee add column integrated_gmail varchar(1020);
#-------------------------------------20.07.2024 snehith-------------
CREATE TABLE `crm_trn_tgmailinboxdeletelog` (

   `s_no` int(11) NOT NULL AUTO_INCREMENT,

   `inbox_id` varchar(1020) DEFAULT NULL,

   `from_id` varchar(1020) DEFAULT NULL,

   `cc` varchar(1020) DEFAULT NULL,

   `sent_date` longtext,

   `bcc` varchar(1020) DEFAULT NULL,

   `subject` longtext,

   `body` longtext,

   `attachement_flag` varchar(64) DEFAULT NULL,

   `inbox_status` varchar(10120) DEFAULT NULL,

   `shopify_enquiry` varchar(64) DEFAULT 'N',

   `leadbank_gid` varchar(64) DEFAULT NULL,

   `read_flag` varchar(1020) DEFAULT NULL,

   `integrated_gmail` varchar(1000) DEFAULT NULL,

   `company_code` varchar(1020) DEFAULT NULL,

   PRIMARY KEY (`s_no`)

) ;
#----------------------------------

13/08/2024-Praveen 

alter table adm_mst_tcompany
add column key1 varchar(120) DEFAULT NULL;
alter table adm_mst_tcompany
add column key2 varchar(120) DEFAULT NULL;
alter table adm_mst_tcompany
add column payment_gateway varchar(12) DEFAULT NULL;
ALTER TABLE crm_trn_toutlookinbox 
ADD COLUMN `to_id` LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci AFTER `from_id`;
CREATE TABLE crm_trn_toutlookinbox (
    s_no INT(11) NOT NULL AUTO_INCREMENT,
    inbox_id VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    from_id VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    cc VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    bcc VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    subject LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci,
    body LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci,
    sent_date VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    inbox_status VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    read_flag VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    attachement_flag VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    parentfolder_id VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    conversation_id VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    conversation_index VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    company_code VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    integrated_gmail VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    PRIMARY KEY (s_no)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE crm_trn_toutlookinboxattachement (
    s_no INT(11) NOT NULL AUTO_INCREMENT,
    inbox_id VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    attachment_id VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    original_filename VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    modified_filename VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    file_path LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci,
    created_by VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
	created_date VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
   PRIMARY KEY (s_no)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 
CREATE TABLE `crm_trn_toutlookinboxreply` (
   `s_no` int(11) NOT NULL AUTO_INCREMENT,
   `reply_id` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `inbox_id` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `from_id` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `cc` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `sent_date` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
   `bcc` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `subject` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
   `body` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
   `attachement_flag` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `both_subject` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
   `both_body` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
   PRIMARY KEY (`s_no`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
CREATE TABLE `crm_trn_toutlookreplyattachment` (
   `s_no` int(11) NOT NULL AUTO_INCREMENT,
   `reply_id` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `inbox_id` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `original_filename` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
   `modified_filename` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
   `file_path` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
   PRIMARY KEY (`s_no`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `crm_trn_toutlookinboxreplyforward` (
   `s_no` int(11) NOT NULL AUTO_INCREMENT,
   `forward_id` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `reply_id` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `inbox_id` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `to_id` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `cc` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `sent_date` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
   `bcc` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `subject` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
   `body` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
   `attachement_flag` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `both_body` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
   `fwd_id` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   PRIMARY KEY (`s_no`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE crm_trn_toutlookfolder (
    s_no int(11) NOT NULL AUTO_INCREMENT,
    label_id VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    label_name VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    parent_folder_id VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    child_folder_count VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    unread_item_count VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    total_item_count VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    size_in_bytes VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    is_hidden VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    company_code VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    integrated_gmail VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    created_by VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    created_date VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    PRIMARY KEY (s_no)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
CREATE TABLE `crm_trn_toutlookinboxdeletelog` (
   `s_no` INT(11) NOT NULL AUTO_INCREMENT,
   `inbox_id` VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `from_id` VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `cc` VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `sent_date` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci,
   `bcc` VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `subject` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci,
   `body` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci,
   `attachement_flag` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `inbox_status` VARCHAR(10120) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `shopify_enquiry` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT 'N',
   `leadbank_gid` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `read_flag` VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `integrated_gmail` VARCHAR(1000) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `company_code` VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   PRIMARY KEY (`s_no`)
) ENGINE=InnoDB AUTO_INCREMENT=2001 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
alter table crm_trn_tdocumentupload add column azure_path longtext;
CREATE TABLE `crm_trn_tleadnotes` (
  `s_no` int(20) NOT NULL AUTO_INCREMENT,
  `internal_notes` longtext,
  `leadbank_gid` varchar(64) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `created_by` varchar(64) DEFAULT NULL,
  `updated_date` datetime DEFAULT NULL,
  `updated_by` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`s_no`)
) ;
 
27/08/2024-vishwa

#-----------------------------14.08.2024 PRAVEEN & SNEHITH------
alter table adm_mst_tcompany
add column key1 varchar(120) DEFAULT NULL;
alter table adm_mst_tcompany
add column key2 varchar(120) DEFAULT NULL;
alter table adm_mst_tcompany
add column payment_gateway varchar(12) DEFAULT NULL;
ALTER TABLE crm_trn_toutlookinbox 
ADD COLUMN `to_id` LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci AFTER `from_id`;
CREATE TABLE crm_trn_toutlookinbox (
    s_no INT(11) NOT NULL AUTO_INCREMENT,
    inbox_id VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    from_id VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    cc VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    bcc VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    subject LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci,
    body LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci,
    sent_date VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    inbox_status VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    read_flag VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    attachement_flag VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    parentfolder_id VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    conversation_id VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    conversation_index VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    company_code VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    integrated_gmail VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    PRIMARY KEY (s_no)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE crm_trn_toutlookinboxattachement (
    s_no INT(11) NOT NULL AUTO_INCREMENT,
    inbox_id VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    attachment_id VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    original_filename VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    modified_filename VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    file_path LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci,
    created_by VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
	created_date VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
   PRIMARY KEY (s_no)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `crm_trn_toutlookinboxreply` (
   `s_no` int(11) NOT NULL AUTO_INCREMENT,
   `reply_id` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `inbox_id` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `from_id` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `cc` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `sent_date` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
   `bcc` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `subject` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
   `body` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
   `attachement_flag` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `both_subject` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
   `both_body` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
   PRIMARY KEY (`s_no`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `crm_trn_toutlookreplyattachment` (
   `s_no` int(11) NOT NULL AUTO_INCREMENT,
   `reply_id` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `inbox_id` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `original_filename` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
   `modified_filename` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
   `file_path` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
   PRIMARY KEY (`s_no`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `crm_trn_toutlookinboxreplyforward` (
   `s_no` int(11) NOT NULL AUTO_INCREMENT,
   `forward_id` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `reply_id` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `inbox_id` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `to_id` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `cc` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `sent_date` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
   `bcc` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `subject` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
   `body` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
   `attachement_flag` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `both_body` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
   `fwd_id` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   PRIMARY KEY (`s_no`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE crm_trn_toutlookfolder (
    s_no int(11) NOT NULL AUTO_INCREMENT,
    label_id VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    label_name VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    parent_folder_id VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    child_folder_count VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    unread_item_count VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    total_item_count VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    size_in_bytes VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    is_hidden VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    company_code VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    integrated_gmail VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    created_by VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    created_date VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    PRIMARY KEY (s_no)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `crm_trn_toutlookinboxdeletelog` (
   `s_no` INT(11) NOT NULL AUTO_INCREMENT,
   `inbox_id` VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `from_id` VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `cc` VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `sent_date` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci,
   `bcc` VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `subject` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci,
   `body` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci,
   `attachement_flag` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `inbox_status` VARCHAR(10120) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `shopify_enquiry` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT 'N',
   `leadbank_gid` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `read_flag` VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `integrated_gmail` VARCHAR(1000) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `company_code` VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   PRIMARY KEY (`s_no`)
) ENGINE=InnoDB AUTO_INCREMENT=2001 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
alter table crm_trn_tdocumentupload add column azure_path longtext;
#------------------------------16.08.2024 PATHMA------
alter table hrm_mst_temployee
add column home_page char(1) Default'N';
 
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 ('SMRHMP','SMRMST','SMRHMP',1307,'ems_crm/crm_mst_homepage.aspx',3,NULL,'Home Page','1',NULL,'Home Page',NULL,'Home Page',NULL,NULL,NULL,'N','N',NULL,NULL,NULL,NULL,'Y','/auth/HomePage',NULL,NULL,NULL,NULL);
#-------------------------20.08.2024 PRAVEEN---------
INSERT INTO `adm_mst_tsequence` (`sequence_gid`, `sequence_code`, `sequence_name`, `sequence_format`, `sequence_curval`, `sequence_flag`, `branch_flag`, `department_flag`, `year_flag`, `location_flag`, `company_code`, `delimeter`, `finyear`, `carry_forward`) VALUES ('SSQM17033109221', 'PG', 'Producttype', '4', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '2024', 'N');

set sql_safe_updates=0;
update crm_trn_tleadbank  set customer_type='Corporate' ;
update crm_trn_tleadbankcontact set main_contact='Y' where main_contact='y';
#-------------------------26.08.2024 sukendar---------
alter table crm_trn_tdocument add column customer_gid varchar(45)default null;
 alter table crm_trn_tleadnotes add column customer_gid varchar(45)default null;
#------------------------ 27.08.2024 pathama#---------#---------#---------
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';
#------------------------27.08.2024 praveeen#---------#---------
alter table hrm_mst_temployee add column integrated_gmail varchar(1020);
alter table crm_trn_tgmailinbox add column read_flag varchar(16);
#-----------------------
----------------------------------------------------------- 30.5.2024  praveen---------------------------
alter table crm_smm_tshopifyproduct add column sku varchar(160) ;

alter table crm_trn_tfiles add column leadbank_gid varchar (100),add column filename varchar(1000);

-----------------------------------------------------------3.6.2024   vishwa--------------------------
alter table crm_trn_tleadbank add column lead_type varchar(32) after main_branch;


---------------------------------------------------------------4.6.24  karthi-------------------------------
INSERT INTO  `adm_mst_tmoduleangular` (`module_gid`, `module_gid_parent`, `module_code`, `display_order`, `menu_level`, `module_name`, `status`, `group_type`, `breadcrumb_name`, `approval_limit`, `module_flag`, `lw_flag`,`sref`) VALUES ('MKTLEDLAY', 'MKTLED', 'MKTLEDLAY', '1404', '3', 'Advocacy', '1', 'Lead', 'Advocacy', 'N', 'N', 'Y','/crm/CrmTrnAdvocacymanagement');

----------------------------------------------------------------5.6.24 praveen-----------------------
UPDATE `adm_mst_tmoduleangular` SET `module_gid_parent` = 'MKTLEG' WHERE (`module_gid` = 'MKTECMWS');
UPDATE `adm_mst_tmoduleangular` SET `module_gid_parent` = 'SMR' WHERE (`module_gid` = 'MKTECM');
UPDATE `adm_mst_tmoduleangular` SET `module_name` = 'Inside Sales', `breadcrumb_name` = 'Inside Sales' WHERE (`module_gid` = 'MKTTEM');
UPDATE `adm_mst_tmoduleangular` SET `module_name` = 'Inside Sales Team', `breadcrumb_name` = 'Inside Sales Team' WHERE (`module_gid` = 'MKTTLCTCT');
UPDATE `adm_mst_tmoduleangular` SET `module_name` = 'My Inside Sales', `breadcrumb_name` = 'My Inside Sales' WHERE (`module_gid` = 'MKTTLCMYC');
UPDATE `adm_mst_tmoduleangular` SET `module_name` = 'Inside Sales Manager', `breadcrumb_name` = 'Inside Sales Manager' WHERE (`module_gid` = 'MKTTLCTCM');

---------------------------------------------------------------5.6.24   vishwa-------------------------------
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`, `finyear`, `carry_forward`) VALUES ('SSQM2406050001', 'ADML', 'Advocacy Management', '4', '0', 'N', 'N', 'N', 'N', 'N', 'N', '2023', 'N');

CREATE TABLE `crm_trn_tadvocacy` (
  `advocacy_gid` varchar(32) NOT NULL,
  `reference_gid` int(16) NOT NULL AUTO_INCREMENT,
  `advocacy_leadbankgid` varchar(32) DEFAULT NULL,
  `reference_leadbankgid` varchar(32) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `created_by` varchar(32) DEFAULT NULL,
  `updated_date` varchar(32) DEFAULT NULL,
  `updated_by` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`advocacy_gid`),
  UNIQUE KEY `reference_gid` (`reference_gid`)
);

--------------------------------------------------6.6.24 karthi-------------------------------
CREATE TABLE `crm_trn_toutlooktemplate` ( 

   `template_gid` int(11) NOT NULL AUTO_INCREMENT, 

   `template_name` varchar(1024) DEFAULT NULL, 

   `template_subject` varchar(1024) DEFAULT NULL, 

   `template_body` longtext, 

   `template_flag` varchar(1) DEFAULT 'Y', 

   `created_by` varchar(64) DEFAULT NULL, 

   `created_date` datetime DEFAULT NULL, 

   PRIMARY KEY (`template_gid`) 

 ) ; 

CREATE TABLE `crm_smm_outlook_service` ( 

   `s_no` int(11) NOT NULL AUTO_INCREMENT, 

   `client_id` longtext, 

   `client_secret` longtext, 

   `tenant_id` longtext, 

   `outlook_status` varchar(2) DEFAULT NULL, 

   `created_date` datetime DEFAULT NULL, 

   `created_by` varchar(64) DEFAULT NULL, 

   `updated_by` varchar(64) DEFAULT NULL, 

   `updated_date` datetime DEFAULT NULL, 

   PRIMARY KEY (`s_no`) );
alter table crm_smm_outlook_service add column outlook_status varchar(2) after tenant_id;
alter table crm_smm_outlook_service add column outlook_status varchar(2) after tenant_id; 

---------------------------------------------------6.6.24 praveen-----------------------
INSERT INTO  `adm_mst_tsequence` (`sequence_gid`, `sequence_code`, `sequence_name`, `sequence_format`, `sequence_curval`, `sequence_flag`, `branch_flag`, `department_flag`, `year_flag`, `location_flag`, `finyear`, `carry_forward`) VALUES ('SSQM2006160001', 'CO2M', 'Contact2Mobile', '4', '0', 'N', 'N', 'N', 'N', 'N', '2023', 'N');
 
INSERT INTO  `adm_mst_tsequence` (`sequence_gid`, `sequence_code`, `sequence_name`, `sequence_format`, `sequence_curval`, `sequence_flag`, `branch_flag`, `department_flag`, `year_flag`, `location_flag`, `finyear`, `carry_forward`) VALUES ('SSQM2006160002', 'CO2E', 'Contact2Email', '4', '0', 'N', 'N', 'N', 'N', 'N', '2023', 'N');
 
INSERT INTO  `adm_mst_tsequence` (`sequence_gid`, `sequence_code`, `sequence_name`, `sequence_format`, `sequence_curval`, `sequence_flag`, `branch_flag`, `department_flag`, `year_flag`, `location_flag`, `finyear`, `carry_forward`) VALUES ('SSQM2006160003', 'COGT', 'Contact GST', '4', '0', 'N', 'N', 'N', 'N', 'N', '2023', 'N');
 
INSERT INTO  `adm_mst_tsequence` (`sequence_gid`, `sequence_code`, `sequence_name`, `sequence_format`, `sequence_curval`, `sequence_flag`, `branch_flag`, `department_flag`, `year_flag`, `location_flag`, `finyear`, `carry_forward`) VALUES ('SSQM2006160004', 'COAD', 'Contact Address', '4', '0', 'N', 'N', 'N', 'N', 'N', '2023', 'N');


INSERT INTO  `adm_mst_tsequence` (`sequence_gid`, `sequence_code`, `sequence_name`, `sequence_format`, `sequence_curval`, `sequence_flag`, `branch_flag`, `department_flag`, `year_flag`, `location_flag`, `finyear`, `carry_forward`) VALUES ('SSQM2006160006', 'COPR', 'Contact Promoter', '4', '0', 'N', 'N', 'N', 'N', 'N', '2023', 'N');
 INSERT INTO  `adm_mst_tsequence` (`sequence_gid`, `sequence_code`, `sequence_name`, `sequence_format`, `sequence_curval`, `sequence_flag`, `branch_flag`, `department_flag`, `year_flag`, `location_flag`, `finyear`, `carry_forward`) VALUES ('SSQM2006160007', 'COGR', 'Contact Director', '4', '0', 'N', 'N', 'N', 'N', 'N', '2023', 'N');
 
 alter table  crm_trn_tleadbank add column leadbankcountry_gid varchar (248) after leadbank_country; 

alter table crm_mst_tcontact2promotor change contact_gid  leadbank_gid varchar(128); 

alter table crm_mst_tcontact2director change contact_gid  leadbank_gid varchar(128); 

---------------------------------------------------------10.06.2024  Karthik---------------------------------------------------------
CREATE TABLE crm_smm_tgraphtoken(
    token varchar(2500),
    expiry_time  DATETIME DEFAULT NULL
);

CREATE TABLE `crm_trn_toutlook` (
   `mail_gid` int(11) NOT NULL AUTO_INCREMENT,
   `from_mailaddress` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
   `to_mailaddress` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
   `mail_subject` longtext,
   `mail_body` longtext,
   `sent_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
   `sent_date` datetime DEFAULT NULL,
   `template_gid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
   `leadbank_gid` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
   PRIMARY KEY (`mail_gid`),
   KEY `mail_gid` (`mail_gid`)
 ) ;
 
alter table crm_trn_toutlook add column sent_flag varchar(1) default 'Y' after mail_body;

-----------------------------------------------------------12.06.2024  Karthik --------------------------------------------------------
INSERT INTO `crm_mst_tleadstage` (`leadstage_gid`,`leadstage_name`,`is_fixed`,`created_by`,`updated_by`,`created_date`,`updated_date`) VALUES (1,'Awareness','Y',NULL,NULL,NULL,NULL);
INSERT INTO `crm_mst_tleadstage` (`leadstage_gid`,`leadstage_name`,`is_fixed`,`created_by`,`updated_by`,`created_date`,`updated_date`) VALUES (2,'Interest','Y',NULL,NULL,NULL,NULL);
INSERT INTO `crm_mst_tleadstage` (`leadstage_gid`,`leadstage_name`,`is_fixed`,`created_by`,`updated_by`,`created_date`,`updated_date`) VALUES (3,'Evaluation','Y',NULL,NULL,NULL,NULL);
INSERT INTO `crm_mst_tleadstage` (`leadstage_gid`,`leadstage_name`,`is_fixed`,`created_by`,`updated_by`,`created_date`,`updated_date`) VALUES (4,'Decision','y',NULL,NULL,NULL,NULL);
INSERT INTO `crm_mst_tleadstage` (`leadstage_gid`,`leadstage_name`,`is_fixed`,`created_by`,`updated_by`,`created_date`,`updated_date`) VALUES (5,'Drop','Y',NULL,NULL,NULL,NULL);
INSERT INTO `crm_mst_tleadstage` (`leadstage_gid`,`leadstage_name`,`is_fixed`,`created_by`,`updated_by`,`created_date`,`updated_date`) VALUES (6,'Purchase','Y',NULL,NULL,NULL,NULL);
INSERT INTO `crm_mst_tleadstage` (`leadstage_gid`,`leadstage_name`,`is_fixed`,`created_by`,`updated_by`,`created_date`,`updated_date`) VALUES (7,'Consideration','Y',NULL,NULL,NULL,NULL);

------------------------------13.06.2024 praveen-------------------------
CREATE TABLE crm_mst_tconstitution (

	constitution_gid VARCHAR(45) NOT NULL,

	constitution_code VARCHAR(45) NULL,

	constitution_name VARCHAR(64) NULL,

	created_by VARCHAR(64) NULL,

	created_date DATETIME NULL,

	updated_by VARCHAR(64) NULL,

	updated_date DATETIME NULL,

	status CHAR(1) NULL,

	remarks TEXT NULL,

    PRIMARY KEY (`constitution_gid`)

);

INSERT INTO `adm_mst_tsequence` (`sequence_gid`, `sequence_code`, `sequence_name`, `sequence_format`, `sequence_curval`, `sequence_flag`, `branch_flag`, `department_flag`, `year_flag`, `location_flag`, `finyear`, `carry_forward`) VALUES ('SSQM2006150012', 'AENG', 'Constitution Gid', '4', '0', 'N', 'N', 'N', 'N', 'N', '2023', 'N');

INSERT INTO `adm_mst_tsequence` (`sequence_gid`, `sequence_code`, `sequence_name`, `sequence_format`, `sequence_curval`, `sequence_flag`, `branch_flag`, `department_flag`, `year_flag`, `location_flag`, `finyear`, `carry_forward`) VALUES ('SSQM2006150013', 'AENC', 'Constitution Code', '4', '0', 'N', 'N', 'N', 'N', 'N', '2023', 'N');

-------------------------------15.06.24  vishwa ----------------
UPDATE `adm_mst_tmoduleangular` SET `sref` = '/smr/SmrMstProductunitsSummary' WHERE (`module_gid` = 'MKTPDMPOU');
---------------------------17.06.2024 vishwa---------------------------

alter table  crm_trn_toutlook modify column mail_gid varchar(16) ;

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 ('SSQM2406170001','OILC','MailCampaign','4','0','N','N','N','N','','N',NULL,NULL,NULL,'2023','N',NULL,NULL,NULL,NULL);
----------------------------------17.06.2024 pathmanaban-----------
alter table smr_trn_tsalesorder
add column message_id varchar(120) default null;
----------------------------------18.06.2024 praveen---------------
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`, `module_gid_parent`, `module_code`, `display_order`, `menu_level`, `module_name`, `status`, `breadcrumb_name`, `approval_limit`, `module_flag`, `lw_flag`) VALUES ('MKTMAL', 'MKT', 'MKTMAL', '1007', '2', 'Mail Management', '1', 'Mail Management', 'N', 'N', 'Y');

INSERT INTO `adm_mst_tmoduleangular` (`module_gid`, `module_gid_parent`, `module_code`, `display_order`, `menu_level`, `module_name`, `status`, `breadcrumb_name`, `approval_limit`, `module_flag`, `lw_flag`, `sref`) VALUES ('MKTMALM', 'MKTMAL', 'MKTMALM', '1001', '3', 'Inbox', '1', 'Inbox', 'N', 'N', 'Y', 'crm/CrmSmmGmailcampaignsummary');

INSERT INTO `adm_mst_tmoduleangular` (`module_gid`, `module_gid_parent`, `module_code`, `display_order`, `menu_level`, `module_name`, `status`, `breadcrumb_name`, `approval_limit`, `module_flag`, `lw_flag`, `sref`) VALUES ('MKTMACM', 'MKTMAL', 'MKTMACM', '1002', '3', 'Compose Mail', '1', 'Compose Mail', 'N', 'N', 'Y', ' ');

INSERT INTO `adm_mst_tmoduleangular` (`module_gid`, `module_gid_parent`, `module_code`, `display_order`, `menu_level`, `module_name`, `status`, `breadcrumb_name`, `approval_limit`, `module_flag`, `lw_flag`, `sref`) VALUES ('MKTMALF', 'MKTMAL', 'MKTMALF', '1003', '3', 'Mail Folders', '1', 'Mail Folders', 'N', 'N', 'Y', ' ');

INSERT INTO `adm_mst_tmoduleangular` (`module_gid`, `module_gid_parent`, `module_code`, `display_order`, `menu_level`, `module_name`, `status`, `breadcrumb_name`, `approval_limit`, `module_flag`, `lw_flag`, `sref`) VALUES ('MKTMALS', 'MKTMAL', 'MKTMALS', '1004', '3', 'Sent Items', '1', 'Sent Items', 'N', 'N', 'Y', ' ');

#------------------------------- 2nd section of script---------------------
#---------#---------#---------------13.06.2024  praveeen#---------#---------
CREATE TABLE crm_mst_tconstitution (
	constitution_gid VARCHAR(45) NOT NULL,
	constitution_code VARCHAR(45) NULL,
	constitution_name VARCHAR(64) NULL,
	created_by VARCHAR(64) NULL,
	created_date DATETIME NULL,
	updated_by VARCHAR(64) NULL,
	updated_date DATETIME NULL,
	status CHAR(1) NULL,
	remarks TEXT NULL,
    PRIMARY KEY (`constitution_gid`)
);

INSERT INTO `adm_mst_tsequence` (`sequence_gid`, `sequence_code`, `sequence_name`, `sequence_format`, `sequence_curval`, `sequence_flag`, `branch_flag`, `department_flag`, `year_flag`, `location_flag`, `finyear`, `carry_forward`) VALUES ('SSQM2006150012', 'AENG', 'Constitution Gid', '4', '0', 'N', 'N', 'N', 'N', 'N', '2024', 'N');
INSERT INTO `adm_mst_tsequence` (`sequence_gid`, `sequence_code`, `sequence_name`, `sequence_format`, `sequence_curval`, `sequence_flag`, `branch_flag`, `department_flag`, `year_flag`, `location_flag`, `finyear`, `carry_forward`) VALUES ('SSQM2006150013', 'AENC', 'Constitution Code', '4', '0', 'N', 'N', 'N', 'N', 'N', '2024', 'N');

#---------#---------#---------#---------#----------15.06.2024 vishwa#------------
UPDATE `adm_mst_tmoduleangular` SET `sref` = '/smr/SmrMstProductunitsSummary' WHERE (`module_gid` = 'MKTPDMPOU');

#---------#---------#---------#------------ 17.06.24 karthi#---------
alter table  crm_trn_toutlook modify column mail_gid varchar(16) ;
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 ('SSQM2406170001','OILC','MailCampaign','4','0','N','N','N','N','','N',NULL,NULL,NULL,'2024','N',NULL,NULL,NULL,NULL);

#---------#---------#---------#--------------17.06.24 pathama#---------#---------#---------
alter table smr_trn_tsalesorder
add column message_id varchar(120) default null;


#---------#---------#---------#-----------------20.06.24 praveeen#---------#---------
CREATE TABLE crm_trn_tgmailinbox (
     s_no INT PRIMARY KEY AUTO_INCREMENT,
    inbox_id VARCHAR(1020),
	from_id VARCHAR(1020),
    cc VARCHAR(1020),
    sent_date LONGTEXT,
    bcc VARCHAR(1020),
    subject LONGTEXT,
    body LONGTEXT,
attachement_flag varchar(64)
);
ALTER TABLE crm_trn_tgmailinbox MODIFY subject LONGTEXT;
ALTER TABLE crm_trn_tgmailinbox MODIFY sent_date LONGTEXT;
CREATE TABLE crm_trn_tgmailinboxattachment (
  s_no INT PRIMARY KEY AUTO_INCREMENT,
    inbox_id VARCHAR(1020),
    original_filename LONGTEXT,
    modified_filename LONGTEXT,
    file_path LONGTEXT
);
 CREATE TABLE crm_trn_tgmailinboxreply (
     s_no INT PRIMARY KEY AUTO_INCREMENT,
	reply_id VARCHAR(1020),
    inbox_id VARCHAR(1020),
	from_id VARCHAR(1020),
    cc VARCHAR(1020),
    sent_date LONGTEXT,
    bcc VARCHAR(1020),
    subject LONGTEXT,
    body LONGTEXT,
attachement_flag varchar(64)
);
alter table crm_trn_tgmailinboxreply add column both_body LONGTEXT;
CREATE TABLE crm_trn_tgmailreplyattachment (
  s_no INT PRIMARY KEY AUTO_INCREMENT,
     reply_id VARCHAR(1020),
    inbox_id VARCHAR(1020),
    original_filename LONGTEXT,
    modified_filename LONGTEXT,
    file_path LONGTEXT
);

CREATE TABLE crm_trn_tgmailinboxreplyforward (
     s_no INT PRIMARY KEY AUTO_INCREMENT,
	forward_id VARCHAR(1020),
	reply_id VARCHAR(1020),
    inbox_id VARCHAR(1020),
	to_id VARCHAR(1020),
    cc VARCHAR(1020),
    sent_date LONGTEXT,
    bcc VARCHAR(1020),
    subject LONGTEXT,
    body LONGTEXT,
both_body LONGTEXT,
attachement_flag varchar(64)
);
CREATE TABLE `crm_smm_tgmailcomment` (
 
   `s_no` int(20) NOT NULL AUTO_INCREMENT,
 
   `comments` longtext,
 
   `created_date` datetime DEFAULT NULL,
 
   `created_by` varchar(64) DEFAULT NULL,
 
   `updated_date` datetime DEFAULT NULL,
 
   `updated_by` varchar(64) DEFAULT NULL,
 
   PRIMARY KEY (`s_no`)
 
) ;
alter table crm_smm_tgmailcomment add column inbox_id varchar(1020);
alter table crm_trn_tgmailinbox add column inbox_status varchar(10120);
alter table crm_trn_tgmailinboxreplyforward add column fwd_id varchar(1020);
CREATE TABLE crm_trn_tgmailllabel (
 
    s_no INT AUTO_INCREMENT PRIMARY KEY,
 
    label_id VARCHAR(255),
 
    label_name VARCHAR(255),
 
    label_type VARCHAR(50),
 
    created_by VARCHAR(50),
 
    created_date DATETIME
 
);
 
alter table crm_trn_tgmailllabel add column company_code varchar(1020);

#---------#---------#-------------21.06.2024 vishwa#------------
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 ('SSQM240621001','GILC','GmailCampaign','4','0','N','N','N','N','','N',NULL,NULL,NULL,'2024','N',NULL,NULL,NULL,NULL);
UPDATE `adm_mst_tsequence` SET `sequence_name` = 'Outlook MailCampaign' WHERE (`sequence_gid` = 'SSQM2406170001');
 ALTER TABLE crm_trn_gmail MODIFY COLUMN gmail_gid VARCHAR(32) NOT NULL;
 #---------#---------#---------#---------------21.06.24 praveeen#---------#---------
 alter table crm_trn_tgmailinbox add column shopify_enquiry varchar (64);
 
 #---------#---------#---------#----------------24.06.2024 praveeen#---------#---------
 
 INSERT INTO `adm_mst_tmoduleangular` (`module_gid`, `module_gid_parent`, `module_code`, `display_order`, `menu_level`, `module_name`, `status`, `group_type`, `breadcrumb_name`, `approval_limit`, `module_flag`, `lw_flag`, `sref`) VALUES ('MKTMSOPE', 'MKTLEG', 'MKTMSOPE', '1809', '3', 'Shopify Enquiry', '1', 'Shopify Enquiry', 'Shopify Enquiry', 'N', 'N', 'Y', '/crm/CrmTrnShopifycontactus');
 alter table crm_trn_tteleteam add column `campaign_mailid` varchar(64) DEFAULT NULL;
alter table crm_trn_tappointment modify column `appointment_date` varchar(64) DEFAULT NULL;

CREATE TABLE `crm_trn_tOpportunitylog` (
  `Opportunitylog_gid` int(64) auto_increment,
  `appointment_gid` varchar(64) DEFAULT NULL,
  `log_type` varchar(45) DEFAULT NULL,
  `log_date`  varchar(64) DEFAULT NULL,
  `log_remarks` text,
  `created_by` varchar(64) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  PRIMARY KEY (`Opportunitylog_gid`),
  KEY `Index_2` (`appointment_gid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `crm_trn_topportunitylog` (
  `Opportunitylog_gid` int(64) NOT NULL AUTO_INCREMENT,
  `appointment_gid` varchar(64) DEFAULT NULL,
  `log_type` varchar(45) DEFAULT NULL,
  `log_date` varchar(64) DEFAULT NULL,
  `log_remarks` text,
  `created_by` varchar(64) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  PRIMARY KEY (`Opportunitylog_gid`),
  KEY `Index_2` (`appointment_gid`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1

#---------#---------#---------#-------------24.05.24 vishwa#------------
UPDATE `adm_mst_tmoduleangular` SET `module_gid` = 'SMRECM', `module_code` = 'SMRECM' WHERE (`module_gid` = 'MKTECM');
UPDATE `adm_mst_tmoduleangular` SET `module_gid` = 'SMRMCNSC', `module_gid_parent` = 'SMRECM', `module_code` = 'SMRMCNSC' WHERE (`module_gid` = 'MKTMCNSC');

#---------#---------#---------#----------24.05.24 karthi#---------

 alter table crm_trn_tleadbankcontact add column `birthday` varchar(64) DEFAULT NULL;
alter table crm_trn_tleadbankcontact add column `wedding_day` varchar(64) DEFAULT NULL;
alter table crm_trn_tleadbankcontact modify column wedding_day varchar(64) DEFAULT NULL ;
alter table crm_trn_tleadbankcontact modify column birthday varchar(64) DEFAULT NULL ;

#---------#---------#---------#------------25.06.24 vishwa#------------
UPDATE `adm_mst_tmoduleangular` SET `sref` = '/crm/CrmSmmMailsent' WHERE (`module_gid` = 'MKTMALS');
UPDATE `adm_mst_tmoduleangular` SET `sref` = '/crm/CrmSmmMailscompose' WHERE (`module_gid` = 'MKTMACM');
 UPDATE `adm_mst_tmoduleangular` SET `sref` = 'crm/CrmSmmGmailInboxSummary' WHERE (`module_gid` = 'MKTMALM');
 
 #---------#---------#------------26.06.24 praveeen#---------#---------
 
 alter table crm_trn_tleadbankcontact modify column `birthday` varchar(64) DEFAULT NULL;
alter table crm_trn_tleadbankcontact modify column `wedding_day` varchar(64) DEFAULT NULL;
alter table crm_trn_twhatsappmessages add column reason longtext COLLATE utf8mb4_bin after status;


#---------#---------#-----------27.06.2024 vishwa#------------
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`, `module_gid_parent`, `module_code`, `display_order`, `menu_level`, `module_name`, `status`, `breadcrumb_name`, `approval_limit`, `module_flag`, `lw_flag`,`sref`) VALUES ('SMRSSO', 'SMRSMR', 'SMRSSO', '1600', '3', 'Shopify Orders', '1', 'Shopify Orders', 'N', 'N', 'Y','/smr/SmrTrnShopifyorders');
alter table smr_trn_tsalesorder add column source_flag varchar(64);

#---------#---------#---------#----------28.06.24 pathama#---------#---------#---------
alter table pmr_mst_tproduct
add column whatsappproduct_updatedby varchar(64) DEFAULT NULL;
 
 
alter table pmr_mst_tproduct
add column whatsapp_id varchar(120) DEFAULT 'null';
 
alter table pmr_mst_tproduct
add column whatsappstock_status char(1) DEFAULT 'Y';

#---------#---------#---------#---------#---------#---------27.06.24 praveeen#---------#---------
CREATE TABLE crm_trn_tgmailinbox (
     s_no INT PRIMARY KEY AUTO_INCREMENT,
    inbox_id VARCHAR(1020),
	from_id VARCHAR(1020),
    cc VARCHAR(1020),
    sent_date LONGTEXT,
    bcc VARCHAR(1020),
    subject LONGTEXT,
    body LONGTEXT,
attachement_flag varchar(64)
);
ALTER TABLE crm_trn_tgmailinbox MODIFY subject LONGTEXT;
ALTER TABLE crm_trn_tgmailinbox MODIFY sent_date LONGTEXT;
CREATE TABLE crm_trn_tgmailinboxattachment (
  s_no INT PRIMARY KEY AUTO_INCREMENT,
    inbox_id VARCHAR(1020),
    original_filename LONGTEXT,
    modified_filename LONGTEXT,
    file_path LONGTEXT
);
 CREATE TABLE crm_trn_tgmailinboxreply (
     s_no INT PRIMARY KEY AUTO_INCREMENT,
	reply_id VARCHAR(1020),
    inbox_id VARCHAR(1020),
	from_id VARCHAR(1020),
    cc VARCHAR(1020),
    sent_date LONGTEXT,
    bcc VARCHAR(1020),
    subject LONGTEXT,
    body LONGTEXT,
attachement_flag varchar(64)
);
alter table crm_trn_tgmailinboxreply add column both_body LONGTEXT;
CREATE TABLE crm_trn_tgmailreplyattachment (
  s_no INT PRIMARY KEY AUTO_INCREMENT,
     reply_id VARCHAR(1020),
    inbox_id VARCHAR(1020),
    original_filename LONGTEXT,
    modified_filename LONGTEXT,
    file_path LONGTEXT
);

CREATE TABLE crm_trn_tgmailinboxreplyforward (
     s_no INT PRIMARY KEY AUTO_INCREMENT,
	forward_id VARCHAR(1020),
	reply_id VARCHAR(1020),
    inbox_id VARCHAR(1020),
	to_id VARCHAR(1020),
    cc VARCHAR(1020),
    sent_date LONGTEXT,
    bcc VARCHAR(1020),
    subject LONGTEXT,
    body LONGTEXT,
both_body LONGTEXT,
attachement_flag varchar(64)
);
CREATE TABLE `crm_trn_tgmail2customer` (
  `s_no` INT(11) NOT NULL AUTO_INCREMENT,
  `inbox_id` VARCHAR(1020) NOT NULL,
  `customer_gid` VARCHAR(1020) NOT NULL,
  `created_date` DATETIME DEFAULT NULL,
  `created_by` VARCHAR(64) DEFAULT NULL,
  `updated_date` DATETIME DEFAULT NULL,
  `updated_by` VARCHAR(64) DEFAULT NULL,
  PRIMARY KEY (`s_no`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

 
 #---------#---------#---------#---------#---------27.06.24 karthi#---------
 alter table crm_trn_tgmailinbox add column leadbank_gid varchar(64);
 
#---------#---------#-----------------29.06.24 vishwa#------------
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`, `module_gid_parent`, `module_code`, `display_order`, `menu_level`, `module_name`, `status`, `breadcrumb_name`, `approval_limit`, `module_flag`, `lw_flag`, `sref`) VALUES ('MKTMALT', 'MKTMAL', 'MKTMALT', '1005', '3', 'Trash', '1', 'Trash', 'N', 'N', 'Y', '/crm/CrmSmmGmailTrashSummary');
UPDATE `adm_mst_tmoduleangular` SET `sref` = '/crm/CrmSmmGmailFolderSummary' WHERE (`module_gid` = 'MKTMALF');
UPDATE`adm_mst_tsequence` SET `finyear` = '2024' WHERE (`sequence_gid` = 'SSQM240621001');
UPDATE `adm_mst_tsequence` SET `finyear` = '2024' WHERE (`sequence_gid` = 'SSQM2406170001');

#--------------------------------02.07.2024 karthi-------------

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`) VALUES ('SMRSHOINV','SMRINM','SMRSHOINV',3012,NULL,3,NULL,'Shopify Inventory','1','../images/ico_invoice_report_RS.gif','Shopify Inventory',NULL,'Shopify Inventory','T',NULL,NULL,'N','N',NULL,NULL,NULL,NULL,'Y','/smr/SmrTrnShopifyinventory',NULL,NULL,NULL);

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`) VALUES ('SMRSHOPMT','SMRINM','SMRSHOPMT',3009,NULL,3,NULL,'Shopify Payment','1','../images/ico_invoice_report_RS.gif','Shopify Payment',NULL,'Shopify Payment','T',NULL,NULL,'N','N',NULL,NULL,NULL,NULL,'Y','/smr/SmrTrnShopifypayment',NULL,NULL,NULL);

INSERT INTO `adm_mst_tmoduleangular` (`module_gid`, `module_gid_parent`, `module_code`, `display_order`, `module_link`, `menu_level`, `module_name`, `status`, `breadcrumb_name`, `approval_limit`, `module_flag`, `lw_flag`, `sref`) VALUES ('SMRSHOCUS', 'SMRMST', 'SMRSHOCUS', '1402', 'ems_crm/crm_trn_shopifycustomersummary.aspx', '3', 'Shopify Customer', '1', 'Shopify Customer', 'N', 'N', 'Y', '/smr/SmrTrnShopifycustomer');

INSERT INTO`adm_mst_tmoduleangular` (`module_gid`, `module_gid_parent`, `module_code`, `display_order`, `module_link`, `menu_level`, `module_name`, `status`, `breadcrumb_name`, `approval_limit`, `module_flag`, `lw_flag`, `sref`) VALUES ('SMRSHPT', 'SMRMST', 'SMRSHPT', '1305', 'ems_crm/crm_trn_shopifyproduct.aspx', '3', 'Shopify Product', '1', 'Shopify Product', 'N', 'N', 'Y', '/smr/SmrTrnShopifyproduct');

UPDATE `adm_mst_tmoduleangular` SET `display_order` = '1305' WHERE (`module_gid` = 'SMRMSTTXDT');
UPDATE `adm_mst_tmoduleangular` SET `display_order` = '1303' WHERE (`module_gid` = 'SMRSHPT');
#---------------------------------------------03-07-2024----------------------------------------------------
UPDATE `adm_mst_tmoduleangular` SET `module_name` = 'WhatsApp', `group_type` = 'WhatsApp', `breadcrumb_name` = 'WhatsApp' WHERE (`module_gid` = 'MKTMCNWA');
#--------------------------------------------04-07-2024------------------------------------------------------
alter table smr_trn_tsalesorderdtl add column taxable varchar(8) after discount_amount;
alter table crm_trn_tleadbankcontact add column interests longtext;
##---------------------------------------------05-07-2024-----------------------------------------------------
alter table smr_trn_tsalesorderdtl add column shopify_lineitemid varchar(256);
alter table  smr_trn_tcampaign add column `team_prefix` varchar(45) DEFAULT NULL; 
#----------------------------------05.07.2024 vishwa------------
alter table smr_trn_tsalesorder add column billing_to longtext after shipping_to;
alter table crm_smm_gmail_service add column default_template longtext after  gmail_address;
ALTER TABLE crm_smm_gmail_service  ADD PRIMARY KEY (s_no), MODIFY COLUMN s_no INT(8) AUTO_INCREMENT;

UPDATE `adm_mst_tmoduleangular` SET `module_name` = 'WhatsApp', `group_type` = 'WhatsApp', `breadcrumb_name` = 'WhatsApp' WHERE (`module_gid` = 'MKTMCNWA');
alter table crm_trn_tleadbankcontact add column interests longtext;
DELETE FROM `adm_mst_tmoduleangular` WHERE (`module_gid` = 'MKTSTG');
update  boba_tea.crm_smm_gmail_service set default_template='
<p><br></p><p><br></p><p>Kind regards<br><span style="font-weight: 700;">Tina Huang</span><br><span style="font-weight: 700;">Boba Tea Company</span><br>Tel: 01164030188<br>Email:&nbsp;info@bobateacompany.co.uk<br>Website:<a>&nbsp;www.bobateacompany.co.uk</a><br>Address:&nbsp;Unit 1, Cornwall Business Centre,&nbsp;Cornwall Rd, Leicester,&nbsp;LE18 4XH<br></p><img src="https://devstoragevcx.file.core.windows.net/bobatea/BobaTea_GmailLogo.png?sv=2023-01-03&se=2024-08-08T09%3A52%3A40Z&sr=s&sp=rl&sig=6EE6hAHCBNrACkQcNjDKGG0b%2BR%2FHNUSqpmJixRXMgZ0%3D"><br></p><p></p><p><span style="font-weight: 700;">IMPORTANT</span>: The contents of this email and any attachments are confidential. They are intended for the named recipient(s) only. If you have received this email by mistake, please notify the sender immediately and do not disclose the contents to anyone or make copies thereof. World Options and subsidiaries companies is committed to ensuring the protection of personal data, for more information please read our privacy policy on our website. If you no longer want to receive emails from us, please contact our GDPR department to register your request.</p>';
#---------------------------------------10.07.2024 vishwa---------------------------
alter table cmr_smm_tshopifysalesorder add column billing_to longtext after shipping_to;
#---------------------------------------------11.07.2024-------------------
alter table smr_trn_tsalesorder add column fulfillment_status varchar(32) after billing_to ;
alter table cmr_smm_tshopifysalesorder add column fulfillment_status varchar(32) after billing_to ;
ALTER TABLE cmr_smm_tshopifysalesorderdtl CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE cmr_smm_tshopifysalesorder CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE smr_trn_tsalesorder CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE smr_trn_tsalesorderdtl CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
alter table smr_trn_tsalesorder add column shopify_customerid varchar(32) after customer_gid ;
alter table cmr_smm_tshopifysalesorder add column shopify_customerid varchar(32) after customer_gid ;
#---------------------------------15.07.2024 snehith-----------------
alter table crm_trn_tgmailinbox add column  integrated_gmail varchar (1000);
alter table crm_trn_tgmailinbox add column company_code varchar(1020);
alter table crm_trn_tgmailllabel add column integrated_gmail varchar(1000);
alter table hrm_mst_temployee add column integrated_gmail varchar(1020);
alter table crm_trn_tgmailinbox add column read_flag varchar(16);
#-------------------------------------20.07.2024 snehith-------------
CREATE TABLE `crm_trn_tgmailinboxdeletelog` (

   `s_no` int(11) NOT NULL AUTO_INCREMENT,

   `inbox_id` varchar(1020) DEFAULT NULL,

   `from_id` varchar(1020) DEFAULT NULL,

   `cc` varchar(1020) DEFAULT NULL,

   `sent_date` longtext,

   `bcc` varchar(1020) DEFAULT NULL,

   `subject` longtext,

   `body` longtext,

   `attachement_flag` varchar(64) DEFAULT NULL,

   `inbox_status` varchar(10120) DEFAULT NULL,

   `shopify_enquiry` varchar(64) DEFAULT 'N',

   `leadbank_gid` varchar(64) DEFAULT NULL,

   `read_flag` varchar(1020) DEFAULT NULL,

   `integrated_gmail` varchar(1000) DEFAULT NULL,

   `company_code` varchar(1020) DEFAULT NULL,

   PRIMARY KEY (`s_no`)

) ;
#----------------------------------24.07.2024 vishwa---------------
CREATE TABLE `crm_trn_tleadnotes` (
  `s_no` int(20) NOT NULL AUTO_INCREMENT,
  `internal_notes` longtext,
  `leadbank_gid` varchar(64) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `created_by` varchar(64) DEFAULT NULL,
  `updated_date` datetime DEFAULT NULL,
  `updated_by` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`s_no`)
) ;
#-----------------------------07.08.2024 PATHAMA-----
alter table adm_mst_tcompany
add column key1 varchar(120) DEFAULT NULL;
alter table adm_mst_tcompany
add column key2 varchar(120) DEFAULT NULL;
alter table adm_mst_tcompany
add column payment_gateway varchar(12) DEFAULT NULL;
#---------------------------13.08.2024 KARTHI-----
CREATE TABLE `crm_trn_tdocumentupload` (
  `docupload_gid` varchar(1020) NOT NULL,
  `docupload_name` varchar(1020) DEFAULT NULL,
  `docupload_type` varchar(1020) DEFAULT NULL,
  `created_by` varchar(1020) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `updated_by` varchar(1020) DEFAULT NULL,
  `updated_date` datetime DEFAULT NULL,
  `docuploadparent_gid` varchar(1020) DEFAULT NULL,
  `file_path` longtext,
  `fileupload_name` varchar(1020) DEFAULT NULL,
  `azure_path` longtext,
  PRIMARY KEY (`docupload_gid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#-----------------------------14.08.2024 PRAVEEN & SNEHITH------
alter table adm_mst_tcompany
add column key1 varchar(120) DEFAULT NULL;
alter table adm_mst_tcompany
add column key2 varchar(120) DEFAULT NULL;
alter table adm_mst_tcompany
add column payment_gateway varchar(12) DEFAULT NULL;
ALTER TABLE crm_trn_toutlookinbox 
ADD COLUMN `to_id` LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci AFTER `from_id`;
CREATE TABLE crm_trn_toutlookinbox (
    s_no INT(11) NOT NULL AUTO_INCREMENT,
    inbox_id VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    from_id VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    cc VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    bcc VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    subject LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci,
    body LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci,
    sent_date VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    inbox_status VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    read_flag VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    attachement_flag VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    parentfolder_id VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    conversation_id VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    conversation_index VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    company_code VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    integrated_gmail VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    PRIMARY KEY (s_no)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE crm_trn_toutlookinboxattachement (
    s_no INT(11) NOT NULL AUTO_INCREMENT,
    inbox_id VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    attachment_id VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    original_filename VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    modified_filename VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    file_path LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci,
    created_by VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
	created_date VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
   PRIMARY KEY (s_no)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `crm_trn_toutlookinboxreply` (
   `s_no` int(11) NOT NULL AUTO_INCREMENT,
   `reply_id` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `inbox_id` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `from_id` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `cc` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `sent_date` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
   `bcc` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `subject` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
   `body` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
   `attachement_flag` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `both_subject` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
   `both_body` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
   PRIMARY KEY (`s_no`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `crm_trn_toutlookreplyattachment` (
   `s_no` int(11) NOT NULL AUTO_INCREMENT,
   `reply_id` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `inbox_id` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `original_filename` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
   `modified_filename` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
   `file_path` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
   PRIMARY KEY (`s_no`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `crm_trn_toutlookinboxreplyforward` (
   `s_no` int(11) NOT NULL AUTO_INCREMENT,
   `forward_id` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `reply_id` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `inbox_id` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `to_id` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `cc` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `sent_date` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
   `bcc` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `subject` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
   `body` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
   `attachement_flag` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `both_body` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
   `fwd_id` varchar(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   PRIMARY KEY (`s_no`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE crm_trn_toutlookfolder (
    s_no int(11) NOT NULL AUTO_INCREMENT,
    label_id VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    label_name VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    parent_folder_id VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    child_folder_count VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    unread_item_count VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    total_item_count VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    size_in_bytes VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    is_hidden VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    company_code VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    integrated_gmail VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    created_by VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    created_date VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci,
    PRIMARY KEY (s_no)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `crm_trn_toutlookinboxdeletelog` (
   `s_no` INT(11) NOT NULL AUTO_INCREMENT,
   `inbox_id` VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `from_id` VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `cc` VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `sent_date` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci,
   `bcc` VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `subject` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci,
   `body` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci,
   `attachement_flag` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `inbox_status` VARCHAR(10120) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `shopify_enquiry` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT 'N',
   `leadbank_gid` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `read_flag` VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `integrated_gmail` VARCHAR(1000) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `company_code` VARCHAR(1020) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   PRIMARY KEY (`s_no`)
) ENGINE=InnoDB AUTO_INCREMENT=2001 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
alter table crm_trn_tdocumentupload add column azure_path longtext;
#------------------------------16.08.2024 PATHMA------
alter table hrm_mst_temployee
add column home_page char(1) Default'N';
 
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 ('SMRHMP','SMRMST','SMRHMP',1307,'ems_crm/crm_mst_homepage.aspx',3,NULL,'Home Page','1',NULL,'Home Page',NULL,'Home Page',NULL,NULL,NULL,'N','N',NULL,NULL,NULL,NULL,'Y','/auth/HomePage',NULL,NULL,NULL,NULL);
#-------------------------20.08.2024 PRAVEEN---------
INSERT INTO `adm_mst_tsequence` (`sequence_gid`, `sequence_code`, `sequence_name`, `sequence_format`, `sequence_curval`, `sequence_flag`, `branch_flag`, `department_flag`, `year_flag`, `location_flag`, `company_code`, `delimeter`, `finyear`, `carry_forward`) VALUES ('SSQM17033109221', 'PG', 'Producttype', '4', '0', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '2024', 'N');
set sql_safe_updates=0;
update crm_trn_tleadbank  set customer_type='Corporate' ;
update crm_trn_tleadbankcontact set main_contact='Y' where main_contact='y';
#-------------------------26.08.2024 sukendar---------
alter table crm_trn_tdocument add column customer_gid varchar(45)default null;
 alter table crm_trn_tleadnotes add column customer_gid varchar(45)default null;
#------------------------ 27.08.2024 pathama#---------#---------#---------
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';
#------------------------27.08.2024 praveeen#---------#---------
alter table hrm_mst_temployee add column integrated_gmail varchar(1020);
alter table crm_trn_tgmailinbox add column read_flag varchar(16);
#-----------------------

19/09/2024--Vishwa

CREATE TABLE `crm_smm_tmailconfig` (
  `s_no` int(8) NOT NULL AUTO_INCREMENT,
  `mail_service` longtext DEFAULT NULL,
  `switch_flag` varchar(1) DEFAULT 'N',
  `created_date` datetime DEFAULT NULL,
  `created_by` varchar(64) DEFAULT NULL,
  `updated_date` datetime DEFAULT NULL,
  `updated_by` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`s_no`)
);
INSERT INTO `crm_smm_tmailconfig` (`s_no`, `mail_service`, `switch_flag`) VALUES ('1', 'Gmail ', 'N');
INSERT INTO `crm_smm_tmailconfig` (`s_no`, `mail_service`, `switch_flag`) VALUES ('2', 'Outlook', 'N');
INSERT INTO `crm_smm_tmailconfig` (`s_no`, `mail_service`, `switch_flag`) VALUES ('3', 'Sparkpost', 'N');
 #-------------------11.09.2024 praveeen--------------
 CREATE TABLE `crm_smm_tmailconfig` (
  `s_no` int(8) NOT NULL AUTO_INCREMENT,
  `mail_service` longtext DEFAULT NULL,
  `switch_flag` varchar(1) DEFAULT 'N',
  `created_date` datetime DEFAULT NULL,
  `created_by` varchar(64) DEFAULT NULL,
  `updated_date` datetime DEFAULT NULL,
  `updated_by` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`s_no`)
);
INSERT INTO `crm_smm_tmailconfig` (`s_no`, `mail_service`, `switch_flag`) VALUES ('1', 'Gmail ', 'N');
INSERT INTO `crm_smm_tmailconfig` (`s_no`, `mail_service`, `switch_flag`) VALUES ('2', 'Outlook', 'N');
INSERT INTO `crm_smm_tmailconfig` (`s_no`, `mail_service`, `switch_flag`) VALUES ('3', 'Sparkpost', 'N');
#-----------------------16.09.2024 praveeen---------
INSERT INTO `adm_mst_tmoduleangular` (`module_gid`, `module_gid_parent`, `module_code`, `display_order`, `menu_level`, `module_name`, `status`, `breadcrumb_name`, `approval_limit`, `module_flag`, `lw_flag`, `sref`) VALUES ('MKTMSTLTE', 'MKTMST', 'MKTMSTLTE', '1210', '3', 'Lead Type', '1', 'Lead Type', 'N', 'N', 'Y', '/crm/crmmstleadtype');

 #-------------------------16.09.2024 vishwa-------------
 UPDATE `adm_mst_tmoduleangular` SET `module_name` = 'My Campaign' WHERE (`module_gid` = 'MKTTLCMYC');

UPDATE `adm_mst_tmoduleangular` SET `module_name` = 'Campaign Manager' WHERE (`module_gid` = 'MKTTLCTCM');

UPDATE `adm_mst_tmoduleangular` SET `module_name` = 'Campaign Team' WHERE (`module_gid` = 'MKTTLCTCT');

UPDATE `adm_mst_tmoduleangular` SET `module_gid_parent` = 'MKTMCN', `display_order` = '1805' WHERE (`module_gid` = 'MKTTLCMYC');

UPDATE `adm_mst_tmoduleangular` SET `module_gid_parent` = 'MKTMCN', `display_order` = '1806' WHERE (`module_gid` = 'MKTTLCTCM');

UPDATE `adm_mst_tmoduleangular` SET `module_gid_parent` = 'MKTMCN', `display_order` = '1807' WHERE (`module_gid` = 'MKTTLCTCT');

UPDATE `adm_mst_tmoduleangular` SET `display_order` = '1807' WHERE (`module_gid` = 'MKTTLCMYC');

UPDATE `adm_mst_tmoduleangular` SET `display_order` = '1805' WHERE (`module_gid` = 'MKTTLCTCT');

set sql_safe_updates=0;

//update adm_mst_tprivilegeangular set module_parent_gid='MKTMCN' WHERE module_gid IN ('MKTTLCMYC', 'MKTTLCTCM', 'MKTTLCTCT');////

UPDATE `adm_mst_tmoduleangular` SET `lw_flag` = 'N' WHERE (`module_gid` = 'MKTTEM');

UPDATE `adm_mst_tmoduleangular` SET `breadcrumb_name` = 'My Campaign' WHERE (`module_gid` = 'MKTTLCMYC');

UPDATE `adm_mst_tmoduleangular` SET `breadcrumb_name` = 'Campaign Manager' WHERE (`module_gid` = 'MKTTLCTCM');

UPDATE `adm_mst_tmoduleangular` SET `breadcrumb_name` = 'Campaign Team' WHERE (`module_gid` = 'MKTTLCTCT');

 #--------------------17.09.2024 praveeen------------
 alter table crm_trn_tleadbank add column FI varchar (1026);
 #-----------------------17.09.2024 vishwa------------
 UPDATE `adm_mst_tsequence` SET `finyear` = '2024' WHERE (`sequence_gid` = 'SSQM1703310365');

 #----------------------18.09.2024 vignesh------------
 CREATE TABLE `crm_mst_tleadtype` (
   `leadtype_gid` varchar(64) NOT NULL,
   `leadtype_code` varchar(32) DEFAULT NULL,
   `leadtype_name` varchar(64) 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 (`leadtype_gid`)
) ;
#-------------------------------

UPDATE adm_mst_tmoduleangular` SET `sref` = '/crm/CrmMstLeadtype' WHERE (`module_gid` = 'MKTMSTLTE');
UPDATE `adm_mst_tmoduleangular` SET `lw_flag` = 'N' WHERE (`module_gid` = 'MKTLEDLAD');

update crm_trn_tleadbank set lead_type='BLTM24091825' where lead_type='Technical Buyer';
update crm_trn_tleadbank set lead_type='BLTM24091827' where lead_type='Influencers';
update crm_trn_tleadbank set lead_type='BLTM24091828' where lead_type='Commercial Buyer';

 truncate crm_mst_tleadtype;
INSERT INTO `crm_mst_tleadtype` (`leadtype_gid`,`leadtype_code`,`leadtype_name`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('BLTM24091825','LTM00025','Technical Buyer','U1','2024-09-18 17:35:28',NULL,NULL);
INSERT INTO `crm_mst_tleadtype` (`leadtype_gid`,`leadtype_code`,`leadtype_name`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('BLTM24091827','LTM00027','Influencer','U1','2024-09-18 17:38:11',NULL,NULL);
INSERT INTO `crm_mst_tleadtype` (`leadtype_gid`,`leadtype_code`,`leadtype_name`,`created_by`,`created_date`,`updated_by`,`updated_date`) VALUES ('BLTM24091828','LTM00028','Commerical Buyer','U1','2024-09-18 17:38:38',NULL,NULL);

 25/09/2024--Vignesh 

alter table crm_mst_tregion  
add column  status char(1) default 'Y';

alter table crm_mst_tconstitution
modify column status char(1) default 'Y';

25/09/2024--vishwa

alter table crm_trn_tcalllog add column callresponse_gid varchar(16) ;

25/09/2024--Praveen D

alter table crm_trn_tfiles add column created_by varchar(64) DEFAULT NULL;

26/09/2024--Praveen D

ALTER TABLE crm_trn_tleadbank MODIFY businessstart_date VARCHAR(64), MODIFY cin_date VARCHAR(64);

ALTER TABLE crm_trn_tleadbank MODIFY individual_dob VARCHAR(64);

alter table crm_mst_tcontact2email modify email_address varchar(128);

26/09/2024--Vishwa

ALTER TABLE crm_trn_tcalllog CHANGE callresponse_gid moving_stage VARCHAR(16);

27/09/2024--Vishwa

alter table crm_trn_tdocument add column customer_gid varchar(45)default null;
alter table crm_trn_tleadnotes add column customer_gid varchar(45)default null;