Feat: additional indexes

2026-05-26 13:51:13 +00:00 · 2025-04-09 11:44:57 +05:45
2 changed files with 29 additions and 1 deletions
@@ -1424,6 +1424,13 @@ return [
                'lengths' => [128],
                'orders' => [],
            ],
+            [
+                '$id' => ID::custom('_key_team_confirm'),
+                'type' => Database::INDEX_KEY,
+                'attributes' => ['teamInternalId', 'confirm'],
+                'lengths' => [],
+                'orders' => [],
+            ],
        ],
    ],

@@ -356,7 +356,14 @@ return [
                'attributes' => ['pingedAt'],
                'lengths' => [],
                'orders' => [],
-            ]
+            ],
+            [
+                '$id' => ID::custom('_key_teamInternalId'), // Todo: index move to Appwrite!
+                'type' => Database::INDEX_KEY,
+                'attributes' => ['teamInternalId'],
+                'lengths' => [],
+                'orders' => [],
+            ],
        ],
    ],

@@ -574,6 +581,13 @@ return [
                'lengths' => [Database::LENGTH_KEY],
                'orders' => [Database::ORDER_ASC],
            ],
+            [
+                '$id' => ID::custom('_key_project_id'),
+                'type' => Database::INDEX_KEY,
+                'attributes' => ['projectId'],
+                'lengths' => [],
+                'orders' => [],
+            ],
        ],
    ],

@@ -834,6 +848,13 @@ return [
                'attributes' => ['projectInternalId'],
                'lengths' => [Database::LENGTH_KEY],
                'orders' => [Database::ORDER_ASC],
+            ],
+            [
+                '$id' => ID::custom('_key_project_id'),
+                'type' => Database::INDEX_KEY,
+                'attributes' => ['projectId'],
+                'lengths' => [],
+                'orders' => [],
            ]
        ],
    ],