From ae3586869a7a85109cc5e38eccc862af1f09fa3c Mon Sep 17 00:00:00 2001 From: Joas Schilling Date: Fri, 2 May 2014 11:10:03 +0200 Subject: [feature/sqlite3] Remove unneeded ORDER BY type from sqlite_master queries PHPBB3-9728 --- phpBB/phpbb/db/tools.php | 6 ++---- 1 file changed, 2 insertions(+), 4 deletions(-) (limited to 'phpBB/phpbb/db/tools.php') diff --git a/phpBB/phpbb/db/tools.php b/phpBB/phpbb/db/tools.php index addb57ac0a..a983ed91b5 100644 --- a/phpBB/phpbb/db/tools.php +++ b/phpBB/phpbb/db/tools.php @@ -2755,8 +2755,7 @@ class tools $sql = "SELECT sql FROM sqlite_master WHERE type = 'table' - AND name = '{$table_name}' - ORDER BY type DESC, name;"; + AND name = '{$table_name}'"; $result = $this->db->sql_query($sql); $sql_create_table = $this->db->sql_fetchfield('sql'); $this->db->sql_freeresult($result); @@ -2770,8 +2769,7 @@ class tools $sql = "SELECT sql FROM sqlite_master WHERE type = 'index' - AND tbl_name = '{$table_name}' - ORDER BY type DESC, name;"; + AND tbl_name = '{$table_name}'"; $result = $this->db->sql_query($sql); while ($sql_create_index = $this->db->sql_fetchfield('sql')) { -- cgit v1.2.1