ADODB2_mysql Class Reference

Inheritance diagram for ADODB2_mysql:

Public Member Functions
	MetaType ($t, $len=-1, $fieldobj=false)
	ActualType ($meta)
	_CreateSuffix ($fname, &$ftype, $fnotnull, $fdefault, $fautoinc, $fconstraint, $funsigned)
	_IndexSQL ($idxname, $tabname, $flds, $idxoptions)
Public Member Functions inherited from ADODB_DataDict
	GetCommentSQL ($table, $col)
	SetCommentSQL ($table, $col, $cmt)
	MetaTables ()
	MetaColumns ($tab, $upper=true, $schema=false)
	MetaPrimaryKeys ($tab, $owner=false, $intkey=false)
	MetaIndexes ($table, $primary=false, $owner=false)
	MetaType ($t, $len=-1, $fieldobj=false)
	NameQuote ($name=NULL, $allowBrackets=false)
	TableName ($name)
	ExecuteSQLArray ($sql, $continueOnError=true)
	ActualType ($meta)
	CreateDatabase ($dbname, $options=false)
	CreateIndexSQL ($idxname, $tabname, $flds, $idxoptions=false)
	DropIndexSQL ($idxname, $tabname=NULL)
	SetSchema ($schema)
	AddColumnSQL ($tabname, $flds)
	AlterColumnSQL ($tabname, $flds, $tableflds='', $tableoptions='')
	RenameColumnSQL ($tabname, $oldcolumn, $newcolumn, $flds='')
	DropColumnSQL ($tabname, $flds, $tableflds='', $tableoptions='')
	DropTableSQL ($tabname)
	RenameTableSQL ($tabname, $newname)
	CreateTableSQL ($tabname, $flds, $tableoptions=array())
	_GenFields ($flds, $widespacing=false)
	_GetSize ($ftype, $ty, $fsize, $fprec)
	_CreateSuffix ($fname, &$ftype, $fnotnull, $fdefault, $fautoinc, $fconstraint, $funsigned)
	_IndexSQL ($idxname, $tabname, $flds, $idxoptions)
	_DropAutoIncrement ($tabname)
	_TableSQL ($tabname, $lines, $pkey, $tableoptions)
	_Triggers ($tabname, $taboptions)
	_Options ($opts)
	_getSizePrec ($size)
	ChangeTableSQL ($tablename, $flds, $tableoptions=false, $dropOldFlds=false)

Public Attributes
	$databaseType = 'mysql'
	$alterCol = ' MODIFY COLUMN'
	$alterTableAddIndex = true
	$dropTable = 'DROP TABLE IF EXISTS %s'
	$dropIndex = 'DROP INDEX %s ON %s'
	$renameColumn = 'ALTER TABLE %s CHANGE COLUMN %s %s %s'
	$blobNotNull = true
Public Attributes inherited from ADODB_DataDict
	$connection
	$debug = false
	$dropTable = 'DROP TABLE %s'
	$renameTable = 'RENAME TABLE %s TO %s'
	$dropIndex = 'DROP INDEX %s'
	$addCol = ' ADD'
	$alterCol = ' ALTER COLUMN'
	$dropCol = ' DROP COLUMN'
	$renameColumn = 'ALTER TABLE %s RENAME COLUMN %s TO %s'
	$nameRegex = '\w'
	$nameRegexBrackets = 'a-zA-Z0-9_\(\)'
	$schema = false
	$serverInfo = array()
	$autoIncrement = false
	$dataProvider
	$invalidResizeTypes4 = array('CLOB','BLOB','TEXT','DATE','TIME')
	$blobNotNull = false
	$blobDefaults = false
	$blobSize = 100

Detailed Description

Definition at line 18 of file datadict-mysql.inc.php.

Member Function Documentation

_CreateSuffix()

ADODB2_mysql::_CreateSuffix	(		$fname,
		&	$ftype,
			$fnotnull,
			$fdefault,
			$fautoinc,
			$fconstraint,
			$funsigned
	)

Definition at line 114 of file datadict-mysql.inc.php.

_IndexSQL()

ADODB2_mysql::_IndexSQL	(		$idxname,
			$tabname,
			$flds,
			$idxoptions
	)

Definition at line 146 of file datadict-mysql.inc.php.

References $sql.

ActualType()

ADODB2_mysql::ActualType

(

$meta

)

Definition at line 82 of file datadict-mysql.inc.php.

MetaType()

ADODB2_mysql::MetaType	(		$t,
			$len = -1,
			$fieldobj = false
	)

Definition at line 28 of file datadict-mysql.inc.php.

Member Data Documentation

$alterCol

ADODB2_mysql::$alterCol = ' MODIFY COLUMN'

Definition at line 20 of file datadict-mysql.inc.php.

$alterTableAddIndex

ADODB2_mysql::$alterTableAddIndex = true

Definition at line 21 of file datadict-mysql.inc.php.

$blobNotNull

ADODB2_mysql::$blobNotNull = true

Definition at line 26 of file datadict-mysql.inc.php.

$databaseType

ADODB2_mysql::$databaseType = 'mysql'

Definition at line 19 of file datadict-mysql.inc.php.

$dropIndex

ADODB2_mysql::$dropIndex = 'DROP INDEX %s ON %s'

Definition at line 24 of file datadict-mysql.inc.php.

$dropTable

ADODB2_mysql::$dropTable = 'DROP TABLE IF EXISTS %s'

Definition at line 22 of file datadict-mysql.inc.php.

$renameColumn

ADODB2_mysql::$renameColumn = 'ALTER TABLE %s CHANGE COLUMN %s %s %s'

Definition at line 25 of file datadict-mysql.inc.php.