diff options
| author | Derek Jones <derek.jones@ellislab.com> | 2008-02-13 05:34:10 +0100 |
|---|---|---|
| committer | Derek Jones <derek.jones@ellislab.com> | 2008-02-13 05:34:10 +0100 |
| commit | 5b4d53271a841c60e43d64f4b6b3c32794b41ac7 (patch) | |
| tree | 36118ab77e8e04c72fafa81240facdfa6979c26f /system/database/drivers/sqlite | |
| parent | d33972bed776a8e95d1e5602534898672eb56cae (diff) | |
fixes to _create_table() in sqlite_forge.php:
removed space between table name and parenthesis
added version check for IF NOT EXISTS
Diffstat (limited to 'system/database/drivers/sqlite')
| -rw-r--r-- | system/database/drivers/sqlite/sqlite_forge.php | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/system/database/drivers/sqlite/sqlite_forge.php b/system/database/drivers/sqlite/sqlite_forge.php index e3196cce1..1fd2a2bd4 100644 --- a/system/database/drivers/sqlite/sqlite_forge.php +++ b/system/database/drivers/sqlite/sqlite_forge.php @@ -76,12 +76,13 @@ class CI_DB_sqlite_forge extends CI_DB_forge { {
$sql = 'CREATE TABLE ';
- if ($if_not_exists === TRUE)
+ // IF NOT EXISTS added to SQLite in 3.3.0
+ if ($if_not_exists === TRUE && version_compare($this->_version(), '3.3.0', '>=') === TRUE)
{
$sql .= 'IF NOT EXISTS ';
}
- $sql .= $this->db->_escape_table($table)." (";
+ $sql .= $this->db->_escape_table($table)."(";
$current_field_count = 0;
foreach ($fields as $field=>$attributes)
|