

ALTER TABLE bi_message MODIFY COLUMN rule TEXT DEFAULT '';

ALTER TABLE bi_message ADD COLUMN qdc TEXT, ADD COLUMN message_category VARCHAR(20) NOT NULL DEFAULT '';



ALTER TABLE company_bi_message MODIFY COLUMN rule VARCHAR( DEFAULT '';

ALTER TABLE company_bi_message ADD COLUMN qdc TEXT, ADD COLUMN message_category VARCHAR(20) NOT NULL DEFAULT '';


ALTER TABLE broadcast_message ADD COLUMN broadcast_name VARCHAR(50) NOT NULL;

ALTER TABLE broadcast_message ADD COLUMN total_msg_count BIGINT DEFAULT 0 NOT NULL;



----------------------------------------

ALTER TABLE whatsapp_bi.`broadcast_contact` ADD COLUMN contact_type CHAR(1) NOT NULL DEFAULT 'N';

ALTER TABLE whatsapp_bi.`broadcast_contact` MODIFY COLUMN contact VARCHAR(30) NOT NULL;

ALTER TABLE whatsapp_bi.`broadcast_contact` ADD COLUMN message_id VARCHAR(40) DEFAULT '';


------------------------------------------


ALTER TABLE whatsapp_bi.`broadcast_message` ADD COLUMN template_name VARCHAR(50) NOT NULL DEFAULT '';
ALTER TABLE whatsapp_bi.`broadcast_message` ADD COLUMN template_language VARCHAR(10) NOT NULL DEFAULT '';



-----------------------------------------


ALTER TABLE whatsapp_bi.excel_import ADD COLUMN ref_type ENUM('Associates','Vendors','Customers','Others') DEFAULT 'Customers';
ALTER TABLE whatsapp_bi.excel_import ADD COLUMN department VARCHAR(30) DEFAULT '';

ALTER TABLE whatsapp_bi.excel_import ADD COLUMN company_id INT NOT NULL;
ALTER TABLE whatsapp_bi.excel_import ADD COLUMN ref_code VARCHAR(20) NOT NULL DEFAULT '';


ALTER TABLE whatsapp_bi.excel_import ADD COLUMN created_at DATETIME DEFAULT CURRENT_TIMESTAMP()

