SHARE
TWEET

0001-Fix-broken-SQL-statement.patch

fyfe Dec 22nd, 2011 130 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. From 2ebb783485432920241e67e85be6fbec2afc14c2 Mon Sep 17 00:00:00 2001
  2. From: Andrew Fyfe <andrew@neptune-one.net>
  3. Date: Thu, 22 Dec 2011 22:03:59 +0000
  4. Subject: [PATCH 1/5] Fix broken SQL statement.
  5.  
  6. Signed-off-by: Andrew Fyfe <andrew@neptune-one.net>
  7. ---
  8. SQL/sqlite.initial.sql |    2 +-
  9.  SQL/sqlite.update.sql  |    2 +-
  10.  2 files changed, 2 insertions(+), 2 deletions(-)
  11.  
  12. diff --git a/SQL/sqlite.initial.sql b/SQL/sqlite.initial.sql
  13. index 8c8da5c..2c4f9dc 100644
  14. --- a/SQL/sqlite.initial.sql
  15. +++ b/SQL/sqlite.initial.sql
  16. @@ -147,7 +147,7 @@ CREATE TABLE searches (
  17.    data text NOT NULL
  18.  );
  19.  
  20. -CREATE UNIQUE INDEX ix_searches_user_type_name (user_id, type, name);
  21. +CREATE UNIQUE INDEX ix_searches_user_type_name ON searches (user_id, type, name);
  22.  
  23.  -- --------------------------------------------------------
  24.  
  25. diff --git a/SQL/sqlite.update.sql b/SQL/sqlite.update.sql
  26. index 92f6da1..c722a84 100644
  27. --- a/SQL/sqlite.update.sql
  28. +++ b/SQL/sqlite.update.sql
  29. @@ -246,7 +246,7 @@ CREATE TABLE searches (
  30.    data text NOT NULL
  31.  );
  32.  
  33. -CREATE UNIQUE INDEX ix_searches_user_type_name (user_id, type, name);
  34. +CREATE UNIQUE INDEX ix_searches_user_type_name ON searches (user_id, type, name);
  35.  
  36.  DROP TABLE messages;
  37.  
  38. --
  39. 1.7.5.4
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top