ALTER TABLE `messages` ADD `uid` text;--> statement-breakpoint
UPDATE `messages` SET `uid` = lower(hex(randomblob(8))) WHERE `uid` IS NULL;--> statement-breakpoint
CREATE UNIQUE INDEX `messages_uid_unique` ON `messages` (`uid`);--> statement-breakpoint
ALTER TABLE `tasks` ADD `uid` text;--> statement-breakpoint
UPDATE `tasks` SET `uid` = lower(hex(randomblob(8))) WHERE `uid` IS NULL;--> statement-breakpoint
CREATE UNIQUE INDEX `tasks_uid_unique` ON `tasks` (`uid`);
