fix sql

pgmot · Nov 25, 2023 · 37abeda · 37abeda
1 parent 1a8a15d
commit 37abeda
Showing 1 changed file with 1 addition and 1 deletion.
diff --git a/sql/init.sql b/sql/init.sql
@@ -96,7 +96,7 @@ CREATE TABLE `livecomments` (
   `tip` BIGINT NOT NULL DEFAULT 0,
   `created_at` BIGINT NOT NULL
 ) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
-CREATE INDEX livecomments_live_id ON livecomments(`livestream_id`);
+CREATE INDEX livecomments_live_id ON livecomments(`livestream_id`, `created_at`);
 
 -- ユーザからのライブコメントのスパム報告
 CREATE TABLE `livecomment_reports` (