phpeveryday.com

When you create table using sql statement, may be you still can not set free from sql command. For example, in mysql we can use auto_increment for id (integer as primary key). Other databases may be can not recognize auto_increment. ADOdb provide solution of this problem.

Here is example ( from manual ):

include_once('adodb.inc.php');

# First create a normal connection
$db->NewADOConnection('mysql');
$db->Connect(...);

# Then create a data dictionary object, 
#using this connection
$dict = NewDataDictionary($db);

# We have a portable declarative data 
#dictionary format in ADOdb 3.50, 
#similar to SQL.
# Field types use 1 character codes, 
#and fields are separated by commas.
# The following example creates three 
#fields: "col1", "col2" and "col3":

$flds = " 
 col1 C(32) NOTNULL DEFAULT 'abc',
 col2 I  DEFAULT 0,
 col3 N(12.2)";

# We demonstrate creating tables and indexes

$sqlarray = $dict->CreateTableSQL($tabname, $flds, $taboptarray);
$dict->ExecuteSQLArray($sqlarray);
$idxflds = 'co11, col2';
$sqlarray = $dict->CreateIndexSQL($idxname, $tabname, $idxflds);
$dict->ExecuteSQLArray($sqlarray);

Currently the following databases are supported: Well-tested: PostgreSQL, MySQL, Oracle, MSSQL.
Beta-quality: DB2, Informix, Sybase, Interbase, Firebird.
Alpha-quality: MS Access (does not support DEFAULT values) and generic ODBC.

function

function CreateDatabase($dbname, $optionsarray=false) 
function CreateTableSQL($tabname, $fldarray, $taboptarray=false) 

Legal portable type codes include:

The $colsize field represents the size of the field. If a decimal number is used, then it is assumed that the number following the dot is the precision, so 6.2 means a number of size 6 digits and 2 decimal places. It is recommended that the default for number types be represented as a string to avoid any rounding errors.

The $otheroptions include the following keywords (case-insensitive):

AUTO			For autoincrement number. 
                        Emulated with triggers if not
                        available.
			Sets NOTNULL also.
AUTOINCREMENT	Same as auto.
KEY			Primary key field. 
                        Sets NOTNULL also. 
                        Compound keys are supported.
PRIMARY 		Same as KEY.
DEF			Synonym for DEFAULT for lazy typists.
DEFAULT		The default value. 
                Character strings are auto-quoted 
                unless the string begins and ends 
                with spaces, eg ' SYSDATE '.
NOTNULL		If field is not null.
DEFDATE		Set default value to call function 
                to get today's date.
DEFTIMESTAMP	Set default to call function 
                to get today's datetime.
NOQUOTE		Prevents autoquoting of default 
                string values.
CONSTRAINTS	Additional constraints defined at 
                the end of the field definition.

The Data Dictonary accepts two formats, the older array specification:

$flds = array(
	array('COLNAME', 'DECIMAL', '8.4', 'DEFAULT' => 0, 'NotNull'),
	array('ID',      'I'      , 'AUTO'),
	array('MYDATE',  'D'      , 'DEFDATE'),
	array('NAME',    'C'      ,'32', 
		  'CONSTRAINTS' => 'FOREIGN KEY 
                             REFERENCES reftable')
);