From 8aaa341a8ee51853737eabf52fe369f75be07e93 Mon Sep 17 00:00:00 2001
From: Yohann Ferreira <yohann_dot_ferreira_at_orange_dot_efer>
Date: Wed, 27 Jul 2011 14:46:41 +0200
Subject: Begun Applying the new equipment slot handling design.

now, the equipment slots are independant from the inventory slots
according to the inventory and equipment data.
This will permit to avoid checking the equipment each time
one touches the inventory and vice versa, and make the former
delayed mode useless.
Also, note that equipped items will be removed from inventory
and readded once unequipped.

The design will permit the following, even if not implemented yet:
- To make equipment items stackable again, if wanted.
- Have more than one item with the same id equipped on different
slots using the itemInstance field.

Note: I didn't add the database structure updates yet, to see
whether other changes may later go along with those.
---
 src/sql/sqlite/createTables.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'src/sql/sqlite/createTables.sql')

diff --git a/src/sql/sqlite/createTables.sql b/src/sql/sqlite/createTables.sql
index b366606..1027b58 100644
--- a/src/sql/sqlite/createTables.sql
+++ b/src/sql/sqlite/createTables.sql
@@ -178,7 +178,8 @@ CREATE TABLE mana_char_equips
     id               INTEGER    PRIMARY KEY,
     owner_id         INTEGER    NOT NULL,
     slot_type        INTEGER    NOT NULL,
-    inventory_slot   INTEGER    NOT NULL,
+    item_id          INTEGER    NOT NULL,
+    item_instance    INTEGER    NOT NULL,
     --
     FOREIGN KEY (owner_id) REFERENCES mana_characters(id)
 );
-- 
cgit 

