From 8b0fc579113af6be4357f881b2d12cd885af3d46 Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Tue, 15 Dec 2009 08:30:53 +0000 Subject: - Patch #360854 by sammys, Crell: added missing db_index_exists(), required to provide proper upgrade path from Drupal 6 to Drupal 7. --- includes/database/sqlite/schema.inc | 16 ++++++++++------ 1 file changed, 10 insertions(+), 6 deletions(-) (limited to 'includes/database/sqlite') diff --git a/includes/database/sqlite/schema.inc b/includes/database/sqlite/schema.inc index 893f54be7..ff3f35c68 100644 --- a/includes/database/sqlite/schema.inc +++ b/includes/database/sqlite/schema.inc @@ -220,7 +220,7 @@ class DatabaseSchema_sqlite extends DatabaseSchema { * The new name for the table. */ public function renameTable($table, $new_name) { - $this->connection->query('ALTER TABLE {' . $table . '} RENAME TO {' . $new_name . '}'); + $this->connection->query('ALTER TABLE {' . $table . '} RENAME TO {' . $new_name . '}'); } /** @@ -230,7 +230,7 @@ class DatabaseSchema_sqlite extends DatabaseSchema { * The table to be dropped. */ public function dropTable($table) { - $this->connection->query('DROP TABLE {' . $table . '}'); + $this->connection->query('DROP TABLE {' . $table . '}'); } /** @@ -429,10 +429,14 @@ class DatabaseSchema_sqlite extends DatabaseSchema { $schema['indexes'][$name] = $fields; $statements = $this->createIndexSql($table, $schema); foreach ($statements as $statement) { - $this->connection->query($statement); + $this->connection->query($statement); } } + public function indexExists($table, $name) { + return ($this->connection->query("PRAGMA index_info($name)")->fetchField() != ''); + } + /** * Drop an index. * @@ -442,7 +446,7 @@ class DatabaseSchema_sqlite extends DatabaseSchema { * The name of the index. */ public function dropIndex($table, $name) { - $this->connection->query('DROP INDEX ' . '{' . $table . '}_' . $name); + $this->connection->query('DROP INDEX ' . '{' . $table . '}_' . $name); } /** @@ -459,7 +463,7 @@ class DatabaseSchema_sqlite extends DatabaseSchema { $schema['unique keys'][$name] = $fields; $statements = $this->createIndexSql($table, $schema); foreach ($statements as $statement) { - $this->connection->query($statement); + $this->connection->query($statement); } } @@ -472,7 +476,7 @@ class DatabaseSchema_sqlite extends DatabaseSchema { * The name of the key. */ public function dropUniqueKey($table, $name) { - $this->connection->query('DROP INDEX ' . '{' . $table . '}_' . $name); + $this->connection->query('DROP INDEX ' . '{' . $table . '}_' . $name); } /** -- cgit v1.2.3