From 2365761ba5445f26c8b66b3b20ef4be44e70d549 Mon Sep 17 00:00:00 2001
From: syuilo <Syuilotan@yahoo.co.jp>
Date: Sun, 15 Aug 2021 17:13:23 +0900
Subject: perf(server): Optimize db indexes of chart tables

---
 src/services/chart/core.ts | 11 ++++++-----
 1 file changed, 6 insertions(+), 5 deletions(-)

(limited to 'src/services/chart/core.ts')

diff --git a/src/services/chart/core.ts b/src/services/chart/core.ts
index 14cbd92802..8e301e8309 100644
--- a/src/services/chart/core.ts
+++ b/src/services/chart/core.ts
@@ -201,11 +201,12 @@ export default abstract class Chart<T extends Record<string, any>> {
 				...Chart.convertSchemaToFlatColumnDefinitions(schema)
 			},
 			indices: [{
-				columns: ['date']
-			}, {
-				columns: ['group']
-			}, {
-				columns: ['date', 'group']
+				columns: ['date', 'group'],
+				unique: true,
+			}, { // groupにnullが含まれると↑のuniqeuは機能しないので↓の部分インデックスでカバー
+				columns: ['date'],
+				unique: true,
+				where: '"group" IS NULL'
 			}]
 		});
 	}
-- 
cgit v1.2.3-freya