CREATE TABLE `support_groups` (
	`id` text PRIMARY KEY NOT NULL,
	`name` text NOT NULL,
	`owner` text NOT NULL,
	`invite` text NOT NULL,
	`whatsapp` text DEFAULT '' NOT NULL
);
--> statement-breakpoint
CREATE UNIQUE INDEX `support_groups_invite_unique` ON `support_groups` (`invite`);--> statement-breakpoint
CREATE TABLE `support_members` (
	`id` text PRIMARY KEY NOT NULL,
	`group_id` text NOT NULL,
	`user_id` text NOT NULL,
	`nickname` text NOT NULL
);
--> statement-breakpoint
CREATE UNIQUE INDEX `support_members_group_user` ON `support_members` (`group_id`,`user_id`);--> statement-breakpoint
CREATE TABLE `support_messages` (
	`id` text PRIMARY KEY NOT NULL,
	`group_id` text NOT NULL,
	`user_id` text NOT NULL,
	`nickname` text NOT NULL,
	`body` text NOT NULL,
	`created_at` integer NOT NULL
);
--> statement-breakpoint
CREATE INDEX `support_messages_group_time` ON `support_messages` (`group_id`,`created_at`);