src/Component.php
public function create($table, array $fields, $index = array(), array $changes = array())
    {
        $columns = array();
        foreach ($fields as $name => $type) {
            $columns[] = (is_int($name)) ? $type : $name.' '.$type;
        }
        $columns = implode(", \n\t", $columns);
        $query = 'CREATE TABLE '.$table.' ('.$columns.')';
        $executed = $this->info('tables', $table);
        // See http://www.sqlite.org/fileformat2.html - 2.5 Storage Of The SQL Database Schema
        if (preg_replace('/(\'|")/', '', $query) == preg_replace('/(\'|")/', '', $executed)) {
            $this->index($table, $index); // make sure they are all correct also
            return false; // the table has already been created in it's requested state
        }
        $this->info('tables', $table, $query); // to either add or update
        if ($executed) { // then this table is being altered in some way
            $this->index($table, '');
            $this->alter($table, $fields, $changes, $columns);
        } else {
            $this->exec($query); // We should only get here once
        }
        $this->index($table, $index);

        return true; // the table has been created (or altered)
    }
public function create($table, array $fields, $index = array(), array $changes = array())
    {
        $columns = array();
        foreach ($fields as $name => $type) {
            $columns[] = (is_int($name)) ? $type : $name.' '.$type;
        }
        $columns = implode(", \n\t", $columns);
        $query = 'CREATE TABLE '.$table.' ('.$columns.')';
        $executed = $this->info('tables', $table);
        // See http://www.sqlite.org/fileformat2.html - 2.5 Storage Of The SQL Database Schema
        if (preg_replace('/(\'|")/', '', $query) == preg_replace('/(\'|")/', '', $executed)) {
            $this->index($table, $index); // make sure they are all correct also
            return false; // the table has already been created in it's requested state
        }
        $this->info('tables', $table, $query); // to either add or update
        if ($executed) { // then this table is being altered in some way
            $this->index($table, '');
            $this->alter($table, $fields, $changes, $columns);
        } else {
            $this->exec($query); // We should only get here once
        }
        $this->index($table, $index);

        return true; // the table has been created (or altered)
    }
public function create ( $ table , array $ fields , $ index = array ( ) , array $ changes = array ( ) ) { $ columns = array ( ) ; foreach ( $ fields as $ name => $ type ) { $ columns [ ] = ( is_int ( $ name ) ) ? $ type : $ name . ' ' . $ type ; } $ columns = implode ( ", \n\t" , $ columns ) ; $ query = 'CREATE TABLE ' . $ table . ' (' . $ columns . ')' ; $ executed = $ this -> info ( 'tables' , $ table ) ; // See http://www.sqlite.org/fileformat2.html - 2.5 Storage Of The SQL Database Schema if ( preg_replace ( '/(\'|")/' , '' , $ query ) == preg_replace ( '/(\'|")/' , '' , $ executed ) ) { $ this -> index ( $ table , $ index ) ; // make sure they are all correct also return false ; // the table has already been created in it's requested state } $ this -> info ( 'tables' , $ table , $ query ) ; // to either add or update if ( $ executed ) { // then this table is being altered in some way $ this -> index ( $ table , '' ) ; $ this -> alter ( $ table , $ fields , $ changes , $ columns ) ; } else { $ this -> exec ( $ query ) ; // We should only get here once } $ this -> index ( $ table , $ index ) ; return true ; // the table has been created (or altered) }
Either create an SQLite **$table** if it has not already been created, or verify that it matches the sqlite_master table index. If something has changed, then the **$table** will be altered accordingly.

@param string $table   The database table name.
@param array  $fields  An ``array($name => $type, ...)`` of fields that define this **$table**.
@param mixed  $index   A string of comma-separated '**field, name, ...**'s to index. If you are creating multiple indexes, then make this an ``array('field', 'name', ... )`` of all the indexes you would like to create. If it is a unique index, then make it an ``array('unique' => 'field, name, ...')``.
@param array  $changes When changing field names, make an ``array($old => $new, ...)`` to map the old field name with the new field name, so that all of the data is updated accordingly. You can change the **$fields** order and type no problem, but if you change field names and don't map them, we'll send the old (missing) field name to the scrapheap, and every new field name will receive it's default value.

@return bool Either ``false`` if nothing has changed and the **$table** is exactly as you would like it, or ``true`` if the **$table** has been newly created or updated in any way.

@example

```php
if ($db->created) {

$db->create('employees', array(
'id' => 'INTEGER PRIMARY KEY',
'name' => 'TEXT COLLATE NOCASE',
'position' => 'TEXT NOT NULL DEFAULT ""',
), array('unique'=>'position'));

// Wait, I just changed my mind
$db->create('employees', array(
'id' => 'INTEGER PRIMARY KEY',
'name' => 'TEXT UNIQUE COLLATE NOCASE',
'title' => 'TEXT DEFAULT ""',
), 'title', array(
'position' => 'title',
));

}
```
Either create an SQLite ** $table ** if it has not already been created or verify that it matches the sqlite_master table index . If something has changed then the ** $table ** will be altered accordingly .