-- SQL update for 2.9.0

ALTER TABLE `chats`
CHANGE COLUMN `_uid` `_uid` CHAR(36) UNIQUE NOT NULL ,
CHANGE COLUMN `message` `message` VARCHAR(500) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_general_ci' NOT NULL ,
DROP INDEX `_uid` ;
;

ALTER TABLE `financial_transactions`
ADD COLUMN `txn_id` VARCHAR(45) NULL DEFAULT NULL AFTER `is_test`,
CHANGE COLUMN `_uid` `_uid` CHAR(36) UNIQUE NOT NULL ,
CHANGE COLUMN `method` `method` VARCHAR(36) NOT NULL ,
DROP INDEX `_uid` ;
;