0001-Fix-broken-SQL-statement.patch

From 2ebb783485432920241e67e85be6fbec2afc14c2 Mon Sep 17 00:00:00 2001
From: Andrew Fyfe <andrew@neptune-one.net>
Date: Thu, 22 Dec 2011 22:03:59 +0000
Subject: [PATCH 1/5] Fix broken SQL statement.

Signed-off-by: Andrew Fyfe <andrew@neptune-one.net>
---
 SQL/sqlite.initial.sql |    2 +-
 SQL/sqlite.update.sql  |    2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/SQL/sqlite.initial.sql b/SQL/sqlite.initial.sql
index 8c8da5c..2c4f9dc 100644
--- a/SQL/sqlite.initial.sql
+++ b/SQL/sqlite.initial.sql
@@ -147,7 +147,7 @@ CREATE TABLE searches (
   data text NOT NULL
 );

-CREATE UNIQUE INDEX ix_searches_user_type_name (user_id, type, name);
+CREATE UNIQUE INDEX ix_searches_user_type_name ON searches (user_id, type, name);

 -- --------------------------------------------------------

diff --git a/SQL/sqlite.update.sql b/SQL/sqlite.update.sql
index 92f6da1..c722a84 100644
--- a/SQL/sqlite.update.sql
+++ b/SQL/sqlite.update.sql
@@ -246,7 +246,7 @@ CREATE TABLE searches (
   data text NOT NULL
 );

-CREATE UNIQUE INDEX ix_searches_user_type_name (user_id, type, name);
+CREATE UNIQUE INDEX ix_searches_user_type_name ON searches (user_id, type, name);

 DROP TABLE messages;

--
1.7.5.4