Specify explicit DatabaseTablePrimaryIndex in install_com.woltlab.wcf.people.php

[GitHub/WoltLab/woltlab.github.io.git] / snippets / tutorial / tutorial-series / part-6 / files / acp / database / install_com.woltlab.wcf.people.php

diff --git a/snippets/tutorial/tutorial-series/part-6/files/acp/database/install_com.woltlab.wcf.people.php b/snippets/tutorial/tutorial-series/part-6/files/acp/database/install_com.woltlab.wcf.people.php
index 5d737157a03f3378fc1ac8df6357f3afa0491f7f..03041e68e0afe4e41305b783948de31dbab5a0c8 100644 (file)
--- a/snippets/tutorial/tutorial-series/part-6/files/acp/database/install_com.woltlab.wcf.people.php
+++ b/snippets/tutorial/tutorial-series/part-6/files/acp/database/install_com.woltlab.wcf.people.php
@@ -10,6 +10,7 @@ use wcf\system\database\table\column\TextDatabaseTableColumn;
 use wcf\system\database\table\column\VarcharDatabaseTableColumn;
 use wcf\system\database\table\DatabaseTable;
 use wcf\system\database\table\index\DatabaseTableForeignKey;
+use wcf\system\database\table\index\DatabaseTablePrimaryIndex;
 
 return [
     DatabaseTable::create('wcf1_person')
@@ -24,6 +25,10 @@ return [
                 ->notNull()
                 ->defaultValue(0),
             DefaultTrueBooleanDatabaseTableColumn::create('enableComments'),
+        ])
+        ->indices([
+            DatabaseTablePrimaryIndex::create()
+                ->columns(['personID']),
         ]),
 
     DatabaseTable::create('wcf1_person_information')
@@ -40,6 +45,10 @@ return [
                 ->defaultValue(''),
             NotNullInt10DatabaseTableColumn::create('time'),
         ])
+        ->indices([
+            DatabaseTablePrimaryIndex::create()
+                ->columns(['informationID']),
+        ])
         ->foreignKeys([
             DatabaseTableForeignKey::create()
                 ->columns(['personID'])