/ 
MySQL-Admin-0.74
River stage zero No dependents
/ cgi-bin/Content/tables.pl

styleguide

Action: means the sub is called from GUI.pm via do('tables.pl'); eval('sub()');

sometimes it is possible that there also parameters used instead of param('table') values.

For example SaveNewTable() call ShowNewTable( 'table', 'column count' )

again if CREATE TABLE failed.

ShowNewTable($tbl,$count)

Action:

Shows a form to create a new table.

SaveNewTable()

Action: Dont call direct.

ShowDumpTable()

Action:

DumpTable($table)

Action: table will be append to $m_sContent

in void context param('table') will be used.

ShowDumpDatabase()

Action

Export the Database.

DumpDatabase($database)

In void context $m_sCurrentDb db will be used.

HighlightSQl()

$formated_string = HighlightSQl();

todo: HighlightSQl as html and link to mysql documentation.

getLink()

searchHelpTopic()

AddFulltext($table,$columnName)

Action:

In void context param('table') and param('column') will be used.

DropFulltext($table,$columnName)

Action:

In void context param('table') and param('column') will be used.

AddIndex($table,$indexName)

Action:

In void context param('table') and param('column') will be used.

DropIndex($table,$indexName)

Action:

In void context param('table') and param('column') will be used.

AddUnique($table,$indexName))

Action:

In void context param('table') and param('column') will be used.

DropUnique($table,$indexName)

Action:

In void context param('table') and param('column') will be used.

ExecSql($sql,$boolShowSQL)

this is the 'main' sub to excute sql within this system.

If you write your own sub write something like this:

sub foo{

$m_sContent .= qq(

#requestURI( url,id,txt )

<a href="javascript:requestURI('$ENV{SCRIPT_NAME}?action=bar&foo=true','bar','bar');">
bar
</a>);

}

sub bar{

ExecSql('select * from bar') if param('foo');

}

SQL()

Action: Excute SQL with the "SQL Editor".

ShowTable($table)

Action:

Call this to show the table overview.

MultipleAction()

Action:

Multiple Table Actions.

MultipleDbAction()

Action:

Multiple Database Actions

EditEntry()

Action:

EditEntry( $table, $id )

In void context param('table') and param('edit') will be used.

EditAction()

Action:

EditAction()

ShowNewEntry($table)

Action:

In void context param('table') will be used.

SaveEntry()

Action:

NewEntry()

Action:

DeleteEntry()

Action:

In void context param('table') will ne used.

round()

private

ShowTables()

Action:

DropTable()

Action:

ShowTableDetails($table)

Action:

AddPrimaryKey($table,$col)

action:

DropCol($table,$column)

Action:

TruncateTable($table)

Action:

EditTable($table)

Action:

ShowEditIndex()

Action:

SaveNewIndex()

Action:

SaveEditTable()

Action:

SaveNewColumn()

Action:

RenameTable($table,$newtable)

Action:

ChangeEngine($table,$engine)

Action:

ChangeAutoInCrementValue($table,$autoInCrement)

Action:

ShowDbHeader()

create the Table Menu and CreateDatabase CreateUser CreateTable ChangeCurrentDb SqlEditor SqlSearch forms.

_insertTables()

Action:

AnalyzeTable($table)

Action:

RepairTable($table)

Action:

OptimizeTable($table)

Action:

ShowUsers()

Action:

ShowRights()

Action:

initRights($user,$host)

the rights for $m_hUserRights will be initialized

HasRight()

private

GetTables()

Auswahliste (select) wird zurueck gegeben

GetTables(name)
todo nach Database.pm verschieben

GetDatabases()

Auswahliste (select) wird zurueck gegeben

GetDatabases(name)
todo nach Database.pm verschieben

GetUsers()

Auswahliste (select) wird zurueck gegeben

GetUsers(name)
todo nach Database.pm verschieben

SaveRights()

Action:

CreateUser()

Action;

DeleteUser()

Action:

ShowDatabases()

Action:

DropDatabase($databaseName)

Action:

CreateDatabase($databaseName)

Action:

ShowProcesslist()

Action:

ShowVariables()

Action:

ChangeCharset()

Action:

searchForm()

Action:

searchDatabase()

Action:

showProfile()

Action:

saveProfile()

Action: