From 59791ea1fd5a93b758be40df2322ac0070deed5b Mon Sep 17 00:00:00 2001 From: Guillaume Melquiond Date: Sun, 1 Jul 2007 21:04:14 +0000 Subject: Added support for storing inventory in database. --- src/account-server/dalstoragesql.hpp | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'src/account-server/dalstoragesql.hpp') diff --git a/src/account-server/dalstoragesql.hpp b/src/account-server/dalstoragesql.hpp index df141f69..b129b797 100644 --- a/src/account-server/dalstoragesql.hpp +++ b/src/account-server/dalstoragesql.hpp @@ -282,24 +282,24 @@ const std::string SQL_INVENTORIES_TABLE( #if defined (MYSQL_SUPPORT) "id INTEGER PRIMARY KEY AUTO_INCREMENT," "owner_id INTEGER NOT NULL," + "slot SMALLINT NOT NULL," "class_id INTEGER NOT NULL," "amount SMALLINT NOT NULL," - "equipped TINYINT NOT NULL," "FOREIGN KEY (owner_id) REFERENCES tmw_characters(id)" "INDEX (id)" #elif defined (SQLITE_SUPPORT) "id INTEGER PRIMARY KEY," "owner_id INTEGER NOT NULL," + "slot INTEGER NOT NULL," "class_id INTEGER NOT NULL," "amount INTEGER NOT NULL," - "equipped INTEGER NOT NULL," "FOREIGN KEY (owner_id) REFERENCES tmw_characters(id)" #elif defined (POSTGRESQL_SUPPORT) "id SERIAL PRIMARY KEY," "owner_id INTEGER NOT NULL," + "slot INTEGER NOT NULL," "class_id INTEGER NOT NULL," "amount INTEGER NOT NULL," - "equipped INTEGER NOT NULL," "FOREIGN KEY (owner_id) REFERENCES tmw_characters(id)" #endif ");" -- cgit v1.2.3-60-g2f50