DBCreateTable

Purpose:

This class was created to help in creating a table in the database.

Properties:

The class properties are as follows:

String $field - what is the field name
String $datatype - what is the SQL datatype stored here (can use optional DBConst values, if not present in DBConst, you can just use the string value of that datatype)
String $default - what is the default value for this field
String $option - optional SQL flags (AUTO_INCREMENT, UNIQUE, PRIMARY KEY, NOT NULL, etc)

Methods:

There is a magic setter method, so if you need to change any of these properties you can do so by calling it directly:

$dbc->field = 'george';
$dbc->datatype = 'yo mama';

There is also a __toString method to auto convert the class to the require syntax appropriate for SQL