Apply PSR-12 code style (#3886)
[GitHub/WoltLab/WCF.git] / wcfsetup / install / files / acp / update_com.woltlab.wcf_5.4_db.php
index e818cffc46c5b6011fa8d1e2ab95d4f092298086..ae96518da8f06d07ac963ad7d1c08fefb1281a31 100644 (file)
@@ -1,4 +1,5 @@
 <?php
+
 use wcf\system\database\table\column\BigintDatabaseTableColumn;
 use wcf\system\database\table\column\BinaryDatabaseTableColumn;
 use wcf\system\database\table\column\DefaultFalseBooleanDatabaseTableColumn;
@@ -18,138 +19,139 @@ use wcf\system\package\plugin\ScriptPackageInstallationPlugin;
 use wcf\system\WCF;
 
 $tables = [
-       DatabaseTable::create('wcf1_flood_control')
-               ->columns([
-                       BigintDatabaseTableColumn::create('logID')
-                               ->length(20)
-                               ->notNull()
-                               ->autoIncrement(),
-                       NotNullInt10DatabaseTableColumn::create('objectTypeID'),
-                       BinaryDatabaseTableColumn::create('identifier')
-                               ->length(16)
-                               ->notNull(),
-                       NotNullInt10DatabaseTableColumn::create('time'),
-               ])
-               ->indices([
-                       DatabaseTablePrimaryIndex::create()
-                               ->columns(['logID']),
-                       DatabaseTableIndex::create()
-                               ->columns(['identifier']),
-                       DatabaseTableIndex::create()
-                               ->columns(['time']),
-               ]),
-       
-       PartialDatabaseTable::create('wcf1_page_content')
-               ->columns([
-                       TextDatabaseTableColumn::create('metaKeywords')
-                               ->drop()
-               ]),
-       
-       PartialDatabaseTable::create('wcf1_user')
-               ->columns([
-                       DefaultFalseBooleanDatabaseTableColumn::create('multifactorActive'),
-               ]),
-       
-       DatabaseTable::create('wcf1_user_multifactor')
-               ->columns([
-                       ObjectIdDatabaseTableColumn::create('setupID'),
-                       NotNullInt10DatabaseTableColumn::create('userID'),
-                       NotNullInt10DatabaseTableColumn::create('objectTypeID'),
-               ])
-               ->indices([
-                       DatabaseTablePrimaryIndex::create()
-                               ->columns(['setupID']),
-                       DatabaseTableIndex::create()
-                               ->type(DatabaseTableIndex::UNIQUE_TYPE)
-                               ->columns(['userID', 'objectTypeID']),
-               ])
-               ->foreignKeys([
-                       DatabaseTableForeignKey::create()
-                               ->columns(['userID'])
-                               ->referencedTable('wcf1_user')
-                               ->referencedColumns(['userID'])
-                               ->onDelete('CASCADE'),
-                       DatabaseTableForeignKey::create()
-                               ->columns(['objectTypeID'])
-                               ->referencedTable('wcf1_object_type')
-                               ->referencedColumns(['objectTypeID'])
-                               ->onDelete('CASCADE'),
-               ]),
-       
-       DatabaseTable::create('wcf1_user_multifactor_backup')
-               ->columns([
-                       NotNullInt10DatabaseTableColumn::create('setupID'),
-                       NotNullVarchar255DatabaseTableColumn::create('identifier'),
-                       NotNullVarchar255DatabaseTableColumn::create('code'),
-                       NotNullInt10DatabaseTableColumn::create('createTime'),
-                       IntDatabaseTableColumn::create('useTime')
-                               ->length(10)
-                               ->defaultValue(null),
-               ])
-               ->indices([
-                       DatabaseTableIndex::create()
-                               ->type(DatabaseTableIndex::UNIQUE_TYPE)
-                               ->columns(['setupID', 'identifier']),
-               ])
-               ->foreignKeys([
-                       DatabaseTableForeignKey::create()
-                               ->columns(['setupID'])
-                               ->referencedTable('wcf1_user_multifactor')
-                               ->referencedColumns(['setupID'])
-                               ->onDelete('CASCADE'),
-               ]),
-               
-       DatabaseTable::create('wcf1_user_multifactor_email')
-               ->columns([
-                       NotNullInt10DatabaseTableColumn::create('setupID'),
-                       NotNullVarchar255DatabaseTableColumn::create('code'),
-                       NotNullInt10DatabaseTableColumn::create('createTime'),
-               ])
-               ->indices([
-                       DatabaseTableIndex::create()
-                               ->type(DatabaseTableIndex::UNIQUE_TYPE)
-                               ->columns(['setupID', 'code']),
-               ])
-               ->foreignKeys([
-                       DatabaseTableForeignKey::create()
-                               ->columns(['setupID'])
-                               ->referencedTable('wcf1_user_multifactor')
-                               ->referencedColumns(['setupID'])
-                               ->onDelete('CASCADE'),
-               ]),
-       
-       DatabaseTable::create('wcf1_user_multifactor_totp')
-               ->columns([
-                       NotNullInt10DatabaseTableColumn::create('setupID'),
-                       NotNullVarchar255DatabaseTableColumn::create('deviceID'),
-                       NotNullVarchar255DatabaseTableColumn::create('deviceName'),
-                       VarbinaryDatabaseTableColumn::create('secret')
-                               ->notNull()
-                               ->length(255),
-                       NotNullInt10DatabaseTableColumn::create('minCounter'),
-                       NotNullInt10DatabaseTableColumn::create('createTime'),
-                       IntDatabaseTableColumn::create('useTime')
-                               ->length(10)
-                               ->notNull(false)
-                               ->defaultValue(null),
-               ])
-               ->indices([
-                       DatabaseTableIndex::create()
-                               ->type(DatabaseTableIndex::UNIQUE_TYPE)
-                               ->columns(['setupID', 'deviceID']),
-               ])
-               ->foreignKeys([
-                       DatabaseTableForeignKey::create()
-                               ->columns(['setupID'])
-                               ->referencedTable('wcf1_user_multifactor')
-                               ->referencedColumns(['setupID'])
-                               ->onDelete('CASCADE'),
-               ]),
+    DatabaseTable::create('wcf1_flood_control')
+        ->columns([
+            BigintDatabaseTableColumn::create('logID')
+                ->length(20)
+                ->notNull()
+                ->autoIncrement(),
+            NotNullInt10DatabaseTableColumn::create('objectTypeID'),
+            BinaryDatabaseTableColumn::create('identifier')
+                ->length(16)
+                ->notNull(),
+            NotNullInt10DatabaseTableColumn::create('time'),
+        ])
+        ->indices([
+            DatabaseTablePrimaryIndex::create()
+                ->columns(['logID']),
+            DatabaseTableIndex::create()
+                ->columns(['identifier']),
+            DatabaseTableIndex::create()
+                ->columns(['time']),
+        ]),
+
+    PartialDatabaseTable::create('wcf1_page_content')
+        ->columns([
+            TextDatabaseTableColumn::create('metaKeywords')
+                ->drop(),
+        ]),
+
+    PartialDatabaseTable::create('wcf1_user')
+        ->columns([
+            DefaultFalseBooleanDatabaseTableColumn::create('multifactorActive'),
+        ]),
+
+    DatabaseTable::create('wcf1_user_multifactor')
+        ->columns([
+            ObjectIdDatabaseTableColumn::create('setupID'),
+            NotNullInt10DatabaseTableColumn::create('userID'),
+            NotNullInt10DatabaseTableColumn::create('objectTypeID'),
+        ])
+        ->indices([
+            DatabaseTablePrimaryIndex::create()
+                ->columns(['setupID']),
+            DatabaseTableIndex::create()
+                ->type(DatabaseTableIndex::UNIQUE_TYPE)
+                ->columns(['userID', 'objectTypeID']),
+        ])
+        ->foreignKeys([
+            DatabaseTableForeignKey::create()
+                ->columns(['userID'])
+                ->referencedTable('wcf1_user')
+                ->referencedColumns(['userID'])
+                ->onDelete('CASCADE'),
+            DatabaseTableForeignKey::create()
+                ->columns(['objectTypeID'])
+                ->referencedTable('wcf1_object_type')
+                ->referencedColumns(['objectTypeID'])
+                ->onDelete('CASCADE'),
+        ]),
+
+    DatabaseTable::create('wcf1_user_multifactor_backup')
+        ->columns([
+            NotNullInt10DatabaseTableColumn::create('setupID'),
+            NotNullVarchar255DatabaseTableColumn::create('identifier'),
+            NotNullVarchar255DatabaseTableColumn::create('code'),
+            NotNullInt10DatabaseTableColumn::create('createTime'),
+            IntDatabaseTableColumn::create('useTime')
+                ->length(10)
+                ->defaultValue(null),
+        ])
+        ->indices([
+            DatabaseTableIndex::create()
+                ->type(DatabaseTableIndex::UNIQUE_TYPE)
+                ->columns(['setupID', 'identifier']),
+        ])
+        ->foreignKeys([
+            DatabaseTableForeignKey::create()
+                ->columns(['setupID'])
+                ->referencedTable('wcf1_user_multifactor')
+                ->referencedColumns(['setupID'])
+                ->onDelete('CASCADE'),
+        ]),
+
+    DatabaseTable::create('wcf1_user_multifactor_email')
+        ->columns([
+            NotNullInt10DatabaseTableColumn::create('setupID'),
+            NotNullVarchar255DatabaseTableColumn::create('code'),
+            NotNullInt10DatabaseTableColumn::create('createTime'),
+        ])
+        ->indices([
+            DatabaseTableIndex::create()
+                ->type(DatabaseTableIndex::UNIQUE_TYPE)
+                ->columns(['setupID', 'code']),
+        ])
+        ->foreignKeys([
+            DatabaseTableForeignKey::create()
+                ->columns(['setupID'])
+                ->referencedTable('wcf1_user_multifactor')
+                ->referencedColumns(['setupID'])
+                ->onDelete('CASCADE'),
+        ]),
+
+    DatabaseTable::create('wcf1_user_multifactor_totp')
+        ->columns([
+            NotNullInt10DatabaseTableColumn::create('setupID'),
+            NotNullVarchar255DatabaseTableColumn::create('deviceID'),
+            NotNullVarchar255DatabaseTableColumn::create('deviceName'),
+            VarbinaryDatabaseTableColumn::create('secret')
+                ->notNull()
+                ->length(255),
+            NotNullInt10DatabaseTableColumn::create('minCounter'),
+            NotNullInt10DatabaseTableColumn::create('createTime'),
+            IntDatabaseTableColumn::create('useTime')
+                ->length(10)
+                ->notNull(false)
+                ->defaultValue(null),
+        ])
+        ->indices([
+            DatabaseTableIndex::create()
+                ->type(DatabaseTableIndex::UNIQUE_TYPE)
+                ->columns(['setupID', 'deviceID']),
+        ])
+        ->foreignKeys([
+            DatabaseTableForeignKey::create()
+                ->columns(['setupID'])
+                ->referencedTable('wcf1_user_multifactor')
+                ->referencedColumns(['setupID'])
+                ->onDelete('CASCADE'),
+        ]),
 ];
 
 (new DatabaseTableChangeProcessor(
-       /** @var ScriptPackageInstallationPlugin $this */
-       $this->installation->getPackage(),
-       $tables,
-       WCF::getDB()->getEditor())
+/** @var ScriptPackageInstallationPlugin $this */
+    $this->installation->getPackage(),
+    $tables,
+    WCF::getDB()->getEditor()
+)
 )->process();