Specify explicit DatabaseTablePrimaryIndex in install_com.woltlab.wcf.people.php
[GitHub/WoltLab/woltlab.github.io.git] / snippets / tutorial / tutorial-series / part-1 / files / acp / database / install_com.woltlab.wcf.people.php
index 57b341b5599c08034f0a43443b8b3d7a1b2472aa..e3b11455531f4c2d1f78cdaa02480a934242f850 100644 (file)
@@ -3,6 +3,7 @@
 use wcf\system\database\table\column\NotNullVarchar255DatabaseTableColumn;
 use wcf\system\database\table\column\ObjectIdDatabaseTableColumn;
 use wcf\system\database\table\DatabaseTable;
+use wcf\system\database\table\index\DatabaseTablePrimaryIndex;
 
 return [
     DatabaseTable::create('wcf1_person')
@@ -10,5 +11,9 @@ return [
             ObjectIdDatabaseTableColumn::create('personID'),
             NotNullVarchar255DatabaseTableColumn::create('firstName'),
             NotNullVarchar255DatabaseTableColumn::create('lastName'),
+        ])
+        ->indices([
+            DatabaseTablePrimaryIndex::create()
+                ->columns(['personID']),
         ]),
 ];