diff options
Diffstat (limited to 'src/sql/sqlite/createTables.sql')
| -rw-r--r-- | src/sql/sqlite/createTables.sql | 16 |
1 files changed, 2 insertions, 14 deletions
diff --git a/src/sql/sqlite/createTables.sql b/src/sql/sqlite/createTables.sql index 9d7d1c2c..95dc5a23 100644 --- a/src/sql/sqlite/createTables.sql +++ b/src/sql/sqlite/createTables.sql @@ -173,19 +173,6 @@ CREATE TABLE mana_floor_items ----------------------------------------------------------------------------- -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) -); - ------------------------------------------------------------------------------ - -- todo: remove class_id and amount and reference on mana_item_instances CREATE TABLE mana_inventories ( @@ -194,6 +181,7 @@ CREATE TABLE mana_inventories slot INTEGER NOT NULL, class_id INTEGER NOT NULL, amount INTEGER NOT NULL, + equipped INTEGER NOT NULL, -- FOREIGN KEY (owner_id) REFERENCES mana_characters(id) ); @@ -408,7 +396,7 @@ AS INSERT INTO mana_world_states VALUES('accountserver_startup',-1,'0', strftime('%s','now')); INSERT INTO mana_world_states VALUES('accountserver_version',-1,'0', strftime('%s','now')); -INSERT INTO mana_world_states VALUES('database_version', -1,'24', strftime('%s','now')); +INSERT INTO mana_world_states VALUES('database_version', -1,'25', strftime('%s','now')); -- all known transaction codes |