table_information.inc File Reference

Go to the source code of this file.

Variables
	$menu_item = "Table Information"
	$tables = Query::create(TableInformation, "WHERE TABLE_SCHEMA=DATABASE() AND TABLE_TYPE='BASE TABLE' ORDER BY TABLE_TYPE, TABLE_NAME")->execute()
	$charset = new TableCharacterSet()
	$form = new AutoForm($charset)
	$characterSets = Query::create(CharacterSet, "ORDER BY CHARACTER_SET_NAME")->execute()
	$options = array(""=>"")
$form	submitLabel = "Update Character Sets"
	$tableSelect
if($method=="POST")	$script = $form->writeScript()

Variable Documentation

$characterSets

$characterSets = Query::create(CharacterSet, "ORDER BY CHARACTER_SET_NAME")->execute()

Definition at line 12 of file table_information.inc.

$charset

$charset = new TableCharacterSet()

Definition at line 8 of file table_information.inc.

$form

$form = new AutoForm($charset)

Definition at line 10 of file table_information.inc.

$menu_item

$menu_item = "Table Information"

Definition at line 4 of file table_information.inc.

$options

$options = array(""=>"")

Definition at line 13 of file table_information.inc.

$script

if ( $method=="POST") $script = $form->writeScript()

Definition at line 73 of file table_information.inc.

$tables

$tables = Query::create(TableInformation, "WHERE TABLE_SCHEMA=DATABASE() AND TABLE_TYPE='BASE TABLE' ORDER BY TABLE_TYPE, TABLE_NAME")->execute()

Definition at line 6 of file table_information.inc.

$tableSelect

$tableSelect

Initial value:

= new TableSelectFieldRenderer($form, "tables", "Tables",
     function($table)
     {
          $table->column("Table Name", "{TABLE_NAME}", true)
                 ->column("Collation", "{TABLE_COLLATION}", true)
                 ->column("# Rows", "{TABLE_ROWS}", true, "text-align: right");
          
          $table->sortable = true;
          $table->filter = true;
          $table->pageSize = 20;
          $table->emptyMessage = "Schema is empty";
          $table->excelFile = "table_list.xls";
          
          $table->showSelectAll = true;
          $table->commandMenu();
     },
     
     function($field)
     {
          if (!$field) $field = $this->field;
          $tables = $_POST[$field];
          $charset =  $_POST["character_set"];
          
          foreach($tables as $table)
          {
               trace("Updating character set for $table to $charset", 3);  
               TableCharacterSet::updateCharacterSet($table, $charset);
          }
          
          return true;
     },
     
     "multi", $tables
)

Definition at line 24 of file table_information.inc.

submitLabel

$form submitLabel = "Update Character Sets"

Definition at line 22 of file table_information.inc.