mirror of
https://github.com/CherryHQ/cherry-studio.git
synced 2026-07-07 07:03:00 +08:00
6c61f33c18
Co-authored-by: Claude Opus 4.8 <noreply@anthropic.com> Co-authored-by: jdzhang <625013594@qq.com> Co-authored-by: jd <59188306+zhangjiadi225@users.noreply.github.com> Co-authored-by: fullex <106392080+0xfullex@users.noreply.github.com> Signed-off-by: suyao <sy20010504@gmail.com> Signed-off-by: jdzhang <625013594@qq.com>
32 lines
2.1 KiB
SQL
32 lines
2.1 KiB
SQL
PRAGMA foreign_keys=OFF;--> statement-breakpoint
|
|
CREATE TABLE `__new_message` (
|
|
`id` text PRIMARY KEY NOT NULL,
|
|
`parent_id` text,
|
|
`topic_id` text NOT NULL,
|
|
`role` text NOT NULL,
|
|
`data` text NOT NULL,
|
|
`searchable_text` text DEFAULT '' NOT NULL,
|
|
`status` text NOT NULL,
|
|
`siblings_group_id` integer DEFAULT 0 NOT NULL,
|
|
`model_id` text,
|
|
`model_snapshot` text,
|
|
`stats` text,
|
|
`created_at` integer NOT NULL,
|
|
`updated_at` integer NOT NULL,
|
|
`deleted_at` integer,
|
|
FOREIGN KEY (`topic_id`) REFERENCES `topic`(`id`) ON UPDATE no action ON DELETE cascade,
|
|
FOREIGN KEY (`model_id`) REFERENCES `user_model`(`id`) ON UPDATE no action ON DELETE set null,
|
|
FOREIGN KEY (`parent_id`) REFERENCES `message`(`id`) ON UPDATE no action ON DELETE cascade,
|
|
CONSTRAINT "message_role_check" CHECK("__new_message"."role" IN ('user', 'assistant', 'system', 'root')),
|
|
CONSTRAINT "message_status_check" CHECK("__new_message"."status" IN ('pending', 'success', 'error', 'paused')),
|
|
CONSTRAINT "message_root_parent_check" CHECK(("__new_message"."role" = 'root') = ("__new_message"."parent_id" is null))
|
|
);
|
|
--> statement-breakpoint
|
|
INSERT INTO `__new_message`("id", "parent_id", "topic_id", "role", "data", "searchable_text", "status", "siblings_group_id", "model_id", "model_snapshot", "stats", "created_at", "updated_at", "deleted_at") SELECT "id", "parent_id", "topic_id", "role", "data", "searchable_text", "status", "siblings_group_id", "model_id", "model_snapshot", "stats", "created_at", "updated_at", "deleted_at" FROM `message`;--> statement-breakpoint
|
|
DROP TABLE `message`;--> statement-breakpoint
|
|
ALTER TABLE `__new_message` RENAME TO `message`;--> statement-breakpoint
|
|
PRAGMA foreign_keys=ON;--> statement-breakpoint
|
|
CREATE INDEX `message_parent_id_idx` ON `message` (`parent_id`);--> statement-breakpoint
|
|
CREATE INDEX `message_topic_created_idx` ON `message` (`topic_id`,`created_at`);--> statement-breakpoint
|
|
CREATE INDEX `message_status_idx` ON `message` (`status`);--> statement-breakpoint
|
|
CREATE UNIQUE INDEX `message_topic_root_uniq` ON `message` (`topic_id`) WHERE "message"."parent_id" is null and "message"."deleted_at" is null; |