From 81db92232e50d47a318c94bc34fb63b67493559a Mon Sep 17 00:00:00 2001
From: Thorbjørn Lindeijer <thorbjorn@lindeijer.nl>
Date: Sat, 7 Aug 2010 19:28:19 +0200
Subject: Fixed index creation on mana_char_kill_stats table

Reviewed-by: Philipp Sehmisch
---
 src/sql/sqlite/updates/update_9_to_10.sql | 9 +++++++++
 1 file changed, 9 insertions(+)
 create mode 100644 src/sql/sqlite/updates/update_9_to_10.sql

(limited to 'src/sql/sqlite/updates')

diff --git a/src/sql/sqlite/updates/update_9_to_10.sql b/src/sql/sqlite/updates/update_9_to_10.sql
new file mode 100644
index 0000000..6340fe4
--- /dev/null
+++ b/src/sql/sqlite/updates/update_9_to_10.sql
@@ -0,0 +1,9 @@
+DROP INDEX mana_char_kill_stats_char;
+CREATE INDEX mana_char_kill_stats_char on mana_char_kill_stats ( char_id );
+
+-- update the database version, and set date of update
+UPDATE mana_world_states
+   SET value      = '10',
+       moddate    = strftime('%s','now')
+ WHERE state_name = 'database_version';
+
-- 
cgit