SetBased / php-audit

   *

   * @return \array[]

   */

  public static function getTableColumns($schemaName, $tableName)

  {

    $sql = sprintf('

select COLUMN_NAME        as column_name

,      COLUMN_TYPE        as column_type

,      IS_NULLABLE        as is_nullable

,      CHARACTER_SET_NAME as character_set_name

,      COLLATION_NAME     as collation_name

from   information_schema.COLUMNS

where  TABLE_SCHEMA = %s

and    TABLE_NAME   = %s

order by ORDINAL_POSITION',

                   self::$dl->quoteString($schemaName),

                   self::$dl->quoteString($tableName));

    return self::$dl->executeRows($sql);

  }

   *

   * @return array

   */

  public static function getTableOptions($schemaName, $tableName)

  {

    $sql = sprintf('

SELECT t1.TABLE_COLLATION    as table_collation

,      t1.ENGINE             as engine

,      t2.CHARACTER_SET_NAME as character_set_name

FROM       information_schema.TABLES                                t1

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));

    return self::$dl->executeRow1($sql);

  }

  //--------------------------------------------------------------------------------------------------------------------

  /**

   *

   * @return \array[]

   */

  public static function getTableTriggers($schemaName, $tableName)

  {

    $sql = sprintf('

select Trigger_Name as trigger_name

from   information_schema.TRIGGERS

where  TRIGGER_SCHEMA     = %s

and    EVENT_OBJECT_TABLE = %s

order by Trigger_Name',

                   self::$dl->quoteString($schemaName),

                   self::$dl->quoteString($tableName));

    return self::$dl->executeRows($sql);

  }

  //--------------------------------------------------------------------------------------------------------------------

  /**