From ca5afebc85cbf769122105904b512942272c0ea3 Mon Sep 17 00:00:00 2001
From: Yohann Ferreira <yohann_dot_ferreira_at_orange_dot_efer>
Date: Tue, 30 Aug 2011 20:31:46 +0200
Subject: Added missing sql update scripts.

---
 src/sql/sqlite/updates/update_14_to_15.sql | 21 +++++++++++++++++++++
 1 file changed, 21 insertions(+)
 create mode 100644 src/sql/sqlite/updates/update_14_to_15.sql

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

diff --git a/src/sql/sqlite/updates/update_14_to_15.sql b/src/sql/sqlite/updates/update_14_to_15.sql
new file mode 100644
index 0000000..777764d
--- /dev/null
+++ b/src/sql/sqlite/updates/update_14_to_15.sql
@@ -0,0 +1,21 @@
+
+-- Dropping the table will only unequip characters, so it's not an issue.
+DROP TABLE mana_char_equips;
+
+-- Recreate the table using the latest definition.
+CREATE TABLE mana_char_equips
+(
+    id               INTEGER    PRIMARY KEY,
+    owner_id         INTEGER    NOT NULL,
+    slot_type        INTEGER    NOT NULL,
+    item_id          INTEGER    NOT NULL,
+    item_instance    INTEGER    NOT NULL,
+    --
+    FOREIGN KEY (owner_id) REFERENCES mana_characters(id)
+);
+
+-- Update the database version, and set date of update
+UPDATE mana_world_states
+   SET value      = '15',
+       moddate    = strftime('%s','now')
+   WHERE state_name = 'database_version';
-- 
cgit