diff options
author | Guillaume Melquiond <guillaume.melquiond@gmail.com> | 2007-07-01 21:04:14 +0000 |
---|---|---|
committer | Guillaume Melquiond <guillaume.melquiond@gmail.com> | 2007-07-01 21:04:14 +0000 |
commit | 59791ea1fd5a93b758be40df2322ac0070deed5b (patch) | |
tree | 650c8d1f9f7fb879e454339ec29f47232b639d1c /src/account-server/dalstoragesql.hpp | |
parent | d4edf76ec16c63ad126712ffbe86d8ed63ab70eb (diff) | |
download | manaserv-59791ea1fd5a93b758be40df2322ac0070deed5b.tar.gz manaserv-59791ea1fd5a93b758be40df2322ac0070deed5b.tar.bz2 manaserv-59791ea1fd5a93b758be40df2322ac0070deed5b.tar.xz manaserv-59791ea1fd5a93b758be40df2322ac0070deed5b.zip |
Added support for storing inventory in database.
Diffstat (limited to 'src/account-server/dalstoragesql.hpp')
-rw-r--r-- | src/account-server/dalstoragesql.hpp | 6 |
1 files changed, 3 insertions, 3 deletions
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 ");" |