芝麻web文件管理V1.00

编辑当前文件:/home/mgatv524/public_html/db/migrations/20211109130951_fix_orphaned_display_groups_migration.php
<?php /** * Set Display Group owner to existing Super Admin user * @phpcs:disable PSR1.Classes.ClassDeclaration.MissingNamespace */ use Phinx\Migration\AbstractMigration; class FixOrphanedDisplayGroupsMigration extends AbstractMigration { /** @inheritDoc */ public function change() { $this->execute('UPDATE `displaygroup` SET userId = (SELECT userId FROM `user` WHERE userTypeId = 1 LIMIT 1) WHERE userId NOT IN (SELECT userId FROM `user`)'); } }