diff options
author | Yohann Ferreira <yohann_dot_ferreira_at_orange_dot_efer> | 2011-09-09 02:35:25 +0200 |
---|---|---|
committer | Yohann Ferreira <yohann_dot_ferreira_at_orange_dot_efer> | 2011-09-09 02:36:30 +0200 |
commit | 6ae2001e91eaaeb8b72031e96f88820711bb1ca0 (patch) | |
tree | 8ab01e1d9e59860837560e6cd8bbd7eabaa428de /src/sql/mysql/createTables.sql | |
parent | 40a31c52aebc19221cc9da8a0f764d21e672937b (diff) | |
download | manaserv-6ae2001e91eaaeb8b72031e96f88820711bb1ca0.tar.gz manaserv-6ae2001e91eaaeb8b72031e96f88820711bb1ca0.tar.bz2 manaserv-6ae2001e91eaaeb8b72031e96f88820711bb1ca0.tar.xz manaserv-6ae2001e91eaaeb8b72031e96f88820711bb1ca0.zip |
Add persistent items support based on seeseekey's work.
Also made some random changes where useful, including:
- Code formatting fixes,
- Design fix about the fact that only the game config option
should be checked.
- Fixed the size of the values sent and receive to follow
the rest of the development.
- Fixed variables names to make them show what they are,
and not why they are used.
Resolves: Mana-Mantis #142.
Diffstat (limited to 'src/sql/mysql/createTables.sql')
-rw-r--r-- | src/sql/mysql/createTables.sql | 18 |
1 files changed, 17 insertions, 1 deletions
diff --git a/src/sql/mysql/createTables.sql b/src/sql/mysql/createTables.sql index f6365031..b75fc0ed 100644 --- a/src/sql/mysql/createTables.sql +++ b/src/sql/mysql/createTables.sql @@ -179,6 +179,22 @@ DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- +-- table: `mana_floor_items` +-- +CREATE TABLE IF NOT EXISTS `mana_floor_items` ( + `id` int(10) unsigned NOT NULL auto_increment, + `map_id` int(10) unsigned NOT NULL, + `item_id` int(10) unsigned NOT NULL, + `amount` smallint(5) unsigned NOT NULL, + `pos_x` smallint(5) unsigned NOT NULL, + `pos_y` smallint(5) unsigned NOT NULL, + -- + PRIMARY KEY (`id`) +) ENGINE=InnoDB +DEFAULT CHARSET=utf8 +AUTO_INCREMENT=1 ; + +-- -- table: `mana_char_equips` -- CREATE TABLE IF NOT EXISTS `mana_char_equips` ( @@ -421,7 +437,7 @@ AUTO_INCREMENT=0 ; INSERT INTO mana_world_states VALUES('accountserver_startup',NULL,NULL, NOW()); INSERT INTO mana_world_states VALUES('accountserver_version',NULL,NULL, NOW()); -INSERT INTO mana_world_states VALUES('database_version', NULL,'16', NOW()); +INSERT INTO mana_world_states VALUES('database_version', NULL,'17', NOW()); -- all known transaction codes |