diff options
author | Aaron Marks <nymacro@gmail.com> | 2005-08-04 08:54:03 +0000 |
---|---|---|
committer | Aaron Marks <nymacro@gmail.com> | 2005-08-04 08:54:03 +0000 |
commit | ca4fec29828b55ea66c5835ab20d2287bb1eb4ff (patch) | |
tree | 7211660bd5fed954a82a234faf14de1db0d612ab /src/dalstoragesql.h | |
parent | 18b778662388e98e90b13f28f28a83911ee96e95 (diff) | |
download | manaserv-ca4fec29828b55ea66c5835ab20d2287bb1eb4ff.tar.gz manaserv-ca4fec29828b55ea66c5835ab20d2287bb1eb4ff.tar.bz2 manaserv-ca4fec29828b55ea66c5835ab20d2287bb1eb4ff.tar.xz manaserv-ca4fec29828b55ea66c5835ab20d2287bb1eb4ff.zip |
Added basic inventory (not fully functional)
Extended GameHandler
Extended protocol
Fixed problem with SQL query
Diffstat (limited to 'src/dalstoragesql.h')
-rw-r--r-- | src/dalstoragesql.h | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/src/dalstoragesql.h b/src/dalstoragesql.h index 3d1ffc05..077b7b0a 100644 --- a/src/dalstoragesql.h +++ b/src/dalstoragesql.h @@ -244,6 +244,7 @@ const std::string SQL_ITEMS_TABLE( * - store items on the ground in the game world. */ const std::string WORLD_ITEMS_TBL_NAME("tmw_world_items"); +// NOTE: Problem here with primary key (only one type of item is allowed on the same map at one time). const std::string SQL_WORLD_ITEMS_TABLE( "CREATE TABLE tmw_world_items (" #if defined (MYSQL_SUPPORT) @@ -254,7 +255,7 @@ const std::string SQL_WORLD_ITEMS_TABLE( "map_id TINYINT NOT NULL," // time to die (UNIX time) "deathtime INTEGER UNSIGNED NOT NULL," - "PRIMARY KEY (id, map_id)," + "PRIMARY KEY (id, map_id)," "FOREIGN KEY (id) REFERENCES tmw_items(id)," "FOREIGN KEY (map_id) REFERENCES tmw_maps(id)" #elif defined (SQLITE_SUPPORT) |