Differences Between: [Versions 310 and 311] [Versions 310 and 400] [Versions 310 and 401] [Versions 310 and 402] [Versions 310 and 403]
(no description)
File Size: | 1033 lines (28 kb) |
Included or required: | 3 times |
Referenced: | 0 times |
Includes or requires: | 0 files |
ADODB_DataDict:: (32 methods):
GetCommentSQL()
SetCommentSQL()
MetaTables()
MetaColumns()
MetaPrimaryKeys()
MetaIndexes()
MetaType()
NameQuote()
TableName()
ExecuteSQLArray()
ActualType()
CreateDatabase()
CreateIndexSQL()
DropIndexSQL()
SetSchema()
AddColumnSQL()
AlterColumnSQL()
RenameColumnSQL()
DropColumnSQL()
DropTableSQL()
RenameTableSQL()
CreateTableSQL()
_GenFields()
_GetSize()
_CreateSuffix()
_IndexSQL()
_DropAutoIncrement()
_TableSQL()
_Triggers()
_Options()
_getSizePrec()
ChangeTableSQL()
Class: ADODB_DataDict - X-Ref
GetCommentSQL($table,$col) X-Ref |
No description |
SetCommentSQL($table,$col,$cmt) X-Ref |
No description |
MetaTables() X-Ref |
No description |
MetaColumns($tab, $upper=true, $schema=false) X-Ref |
No description |
MetaPrimaryKeys($tab,$owner=false,$intkey=false) X-Ref |
No description |
MetaIndexes($table, $primary = false, $owner = false) X-Ref |
No description |
MetaType($t,$len=-1,$fieldobj=false) X-Ref |
No description |
NameQuote($name = NULL,$allowBrackets=false) X-Ref |
No description |
TableName($name) X-Ref |
No description |
ExecuteSQLArray($sql, $continueOnError = true) X-Ref |
No description |
ActualType($meta) X-Ref |
No description |
CreateDatabase($dbname,$options=false) X-Ref |
No description |
CreateIndexSQL($idxname, $tabname, $flds, $idxoptions = false) X-Ref |
No description |
DropIndexSQL($idxname, $tabname = NULL) X-Ref |
No description |
SetSchema($schema) X-Ref |
No description |
AddColumnSQL($tabname, $flds) X-Ref |
No description |
AlterColumnSQL($tabname, $flds, $tableflds='',$tableoptions='') X-Ref |
Change the definition of one column As some DBM's can't do that on there own, you need to supply the complete defintion of the new table, to allow, recreating the table and copying the content over to the new table param: string $tabname table-name param: string $flds column-name and type for the changed column param: string $tableflds='' complete defintion of the new table, eg. for postgres, default '' param: array/string $tableoptions='' options for the new table see CreateTableSQL, default '' return: array with SQL strings |
RenameColumnSQL($tabname,$oldcolumn,$newcolumn,$flds='') X-Ref |
Rename one column Some DBM's can only do this together with changeing the type of the column (even if that stays the same, eg. mysql) param: string $tabname table-name param: string $oldcolumn column-name to be renamed param: string $newcolumn new column-name param: string $flds='' complete column-defintion-string like for AddColumnSQL, only used by mysql atm., default='' return: array with SQL strings |
DropColumnSQL($tabname, $flds, $tableflds='',$tableoptions='') X-Ref |
Drop one column Some DBM's can't do that on there own, you need to supply the complete defintion of the new table, to allow, recreating the table and copying the content over to the new table param: string $tabname table-name param: string $flds column-name and type for the changed column param: string $tableflds='' complete defintion of the new table, eg. for postgres, default '' param: array/string $tableoptions='' options for the new table see CreateTableSQL, default '' return: array with SQL strings |
DropTableSQL($tabname) X-Ref |
No description |
RenameTableSQL($tabname,$newname) X-Ref |
No description |
CreateTableSQL($tabname, $flds, $tableoptions=array() X-Ref |
No description |
_GenFields($flds,$widespacing=false) X-Ref |
No description |
_GetSize($ftype, $ty, $fsize, $fprec) X-Ref |
No description |
_CreateSuffix($fname,&$ftype,$fnotnull,$fdefault,$fautoinc,$fconstraint,$funsigned) X-Ref |
No description |
_IndexSQL($idxname, $tabname, $flds, $idxoptions) X-Ref |
No description |
_DropAutoIncrement($tabname) X-Ref |
No description |
_TableSQL($tabname,$lines,$pkey,$tableoptions) X-Ref |
No description |
_Triggers($tabname,$taboptions) X-Ref |
No description |
_Options($opts) X-Ref |
No description |
_getSizePrec($size) X-Ref |
No description |
ChangeTableSQL($tablename, $flds, $tableoptions = false, $dropOldFlds=false) X-Ref |
No description |
Lens_ParseTest() X-Ref |
No description |
ctype_alnum($text) X-Ref |
No description |
Lens_ParseArgs($args,$endstmtchar=',',$tokenchars='_.-') X-Ref |
No description |