SetBased / php-audit

src/MySql/Command/DropTriggersCommand.php

Indentation +4 added lines, -4 removed lines

@@ -21,8 +21,8 @@ 
   protected function configure()
   {
     $this->setName('drop-triggers')
-         ->setDescription('Drops all triggers')
-         ->addArgument('config file', InputArgument::REQUIRED, 'The audit configuration file');
+          ->setDescription('Drops all triggers')
+          ->addArgument('config file', InputArgument::REQUIRED, 'The audit configuration file');
   }
 
   //--------------------------------------------------------------------------------------------------------------------
@@ -58,8 +58,8 @@ 
     foreach ($triggers as $trigger)
     {
       $this->io->logInfo('Dropping trigger <dbo>%s</dbo> from table <dbo>%s</dbo>',
-                         $trigger['trigger_name'],
-                         $trigger['table_name']);
+                          $trigger['trigger_name'],
+                          $trigger['table_name']);
 
       AuditDataLayer::dropTrigger($data_schema, $trigger['trigger_name']);
     }

src/MySql/AuditDataLayer.php

Indentation +15 added lines, -15 removed lines

@@ -113,14 +113,14 @@ 
                                             $additionSql)
   {
     $helper = new CreateAuditTrigger($dataSchemaName,
-                                     $auditSchemaName,
-                                     $tableName,
-                                     $triggerAction,
-                                     $triggerName,
-                                     $auditColumns,
-                                     $tableColumns,
-                                     $skipVariable,
-                                     $additionSql);
+                                      $auditSchemaName,
+                                      $tableName,
+                                      $triggerAction,
+                                      $triggerName,
+                                      $auditColumns,
+                                      $tableColumns,
+                                      $skipVariable,
+                                      $additionSql);
     $sql    = $helper->buildStatement();
 
     self::executeNone($sql);
@@ -305,8 +305,8 @@ 
 where  TABLE_SCHEMA = %s
 and    TABLE_NAME   = %s
 order by ORDINAL_POSITION',
-                   self::$dl->quoteString($schemaName),
-                   self::$dl->quoteString($tableName));
+                    self::$dl->quoteString($schemaName),
+                    self::$dl->quoteString($tableName));
 
     return self::executeRows($sql);
   }
@@ -330,8 +330,8 @@ 
 inner join information_schema.COLLATION_CHARACTER_SET_APPLICABILITY t2  on  t2.COLLATION_NAME = t1.TABLE_COLLATION
 WHERE t1.TABLE_SCHEMA = %s
 AND   t1.TABLE_NAME   = %s',
-                   self::$dl->quoteString($schemaName),
-                   self::$dl->quoteString($tableName));
+                    self::$dl->quoteString($schemaName),
+                    self::$dl->quoteString($tableName));
 
     return self::executeRow1($sql);
   }
@@ -353,8 +353,8 @@ 
 where  TRIGGER_SCHEMA     = %s
 and    EVENT_OBJECT_TABLE = %s
 order by Trigger_Name',
-                   self::$dl->quoteString($schemaName),
-                   self::$dl->quoteString($tableName));
+                    self::$dl->quoteString($schemaName),
+                    self::$dl->quoteString($tableName));
 
     return self::executeRows($sql);
   }
@@ -376,7 +376,7 @@ 
 where  TRIGGER_SCHEMA     = %s
 order by EVENT_OBJECT_TABLE
 ,        TRIGGER_NAME',
-                   self::$dl->quoteString($schemaName));
+                    self::$dl->quoteString($schemaName));
 
     return self::executeRows($sql);
   }