TYPO3 CMS
TYPO3_6-2
|
Public Member Functions | |
MetaType ($t, $len=-1, $fieldobj=false) | |
ActualType ($meta) | |
AddColumnSQL ($tabname, $flds) | |
DropColumnSQL ($tabname, $flds, $tableflds='', $tableoptions='') | |
_CreateSuffix ($fname, &$ftype, $fnotnull, $fdefault, $fautoinc, $fconstraint, $funsigned) | |
_IndexSQL ($idxname, $tabname, $flds, $idxoptions) | |
_GetSize ($ftype, $ty, $fsize, $fprec) | |
![]() | |
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 = 'mssqlnative' | |
$dropIndex = 'DROP INDEX %1$s ON %2$s' | |
$renameTable = "EXEC sp_rename '%s','%s'" | |
$renameColumn = "EXEC sp_rename '%s.%s','%s'" | |
$typeX = 'TEXT' | |
$typeXL = 'TEXT' | |
![]() | |
$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') | |
$blobSize = 100 | |
Definition at line 44 of file datadict-mssqlnative.inc.php.
ADODB2_mssqlnative::_CreateSuffix | ( | $fname, | |
& | $ftype, | ||
$fnotnull, | |||
$fdefault, | |||
$fautoinc, | |||
$fconstraint, | |||
$funsigned | |||
) |
Definition at line 188 of file datadict-mssqlnative.inc.php.
ADODB2_mssqlnative::_GetSize | ( | $ftype, | |
$ty, | |||
$fsize, | |||
$fprec | |||
) |
Definition at line 302 of file datadict-mssqlnative.inc.php.
ADODB2_mssqlnative::_IndexSQL | ( | $idxname, | |
$tabname, | |||
$flds, | |||
$idxoptions | |||
) |
Definition at line 271 of file datadict-mssqlnative.inc.php.
References $sql.
ADODB2_mssqlnative::ActualType | ( | $meta | ) |
Definition at line 99 of file datadict-mssqlnative.inc.php.
ADODB2_mssqlnative::AddColumnSQL | ( | $tabname, | |
$flds | |||
) |
Definition at line 133 of file datadict-mssqlnative.inc.php.
References $sql, ADODB_DataDict\_GenFields(), and ADODB_DataDict\TableName().
ADODB2_mssqlnative::DropColumnSQL | ( | $tabname, | |
$flds, | |||
$tableflds = '' , |
|||
$tableoptions = '' |
|||
) |
Drop a column, syntax is ALTER TABLE table DROP COLUMN column,column
string | $tabname | Table Name |
string[] | $flds One, or an array of Fields To Drop | |
string | $tableflds | Throwaway value to make the function match the parent |
string | $tableoptions | Throway value to make the function match the parent |
Definition at line 171 of file datadict-mssqlnative.inc.php.
References $sql, ADODB_DataDict\NameQuote(), and ADODB_DataDict\TableName().
ADODB2_mssqlnative::MetaType | ( | $t, | |
$len = -1 , |
|||
$fieldobj = false |
|||
) |
Definition at line 54 of file datadict-mssqlnative.inc.php.
ADODB2_mssqlnative::$databaseType = 'mssqlnative' |
Definition at line 45 of file datadict-mssqlnative.inc.php.
ADODB2_mssqlnative::$dropIndex = 'DROP INDEX %1$s ON %2$s' |
Definition at line 46 of file datadict-mssqlnative.inc.php.
ADODB2_mssqlnative::$renameColumn = "EXEC sp_rename '%s.%s','%s'" |
Definition at line 48 of file datadict-mssqlnative.inc.php.
ADODB2_mssqlnative::$renameTable = "EXEC sp_rename '%s','%s'" |
Definition at line 47 of file datadict-mssqlnative.inc.php.
ADODB2_mssqlnative::$typeX = 'TEXT' |
Definition at line 49 of file datadict-mssqlnative.inc.php.
ADODB2_mssqlnative::$typeXL = 'TEXT' |
Definition at line 50 of file datadict-mssqlnative.inc.php.