diff options
Diffstat (limited to 'src/account-server/storagesql.hpp')
-rw-r--r-- | src/account-server/storagesql.hpp | 148 |
1 files changed, 0 insertions, 148 deletions
diff --git a/src/account-server/storagesql.hpp b/src/account-server/storagesql.hpp deleted file mode 100644 index ac4c2c6e..00000000 --- a/src/account-server/storagesql.hpp +++ /dev/null @@ -1,148 +0,0 @@ -/* - * The Mana Server - * Copyright (C) 2008 The Mana World Development Team - * - * This file is part of The Mana Server. - * - * The Mana Server is free software; you can redistribute it and/or modify - * it under the terms of the GNU General Public License as published by - * the Free Software Foundation; either version 2 of the License, or - * any later version. - * - * The Mana Server is distributed in the hope that it will be useful, - * but WITHOUT ANY WARRANTY; without even the implied warranty of - * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the - * GNU General Public License for more details. - * - * You should have received a copy of the GNU General Public License - * along with The Mana Server. If not, see <http://www.gnu.org/licenses/>. - */ - -#ifndef _MANASERV_DALSTORAGE_SQL_H -#define _MANASERV_DALSTORAGE_SQL_H - -#ifdef HAVE_CONFIG_H -#include "config.h" -#endif - -#if !defined (MYSQL_SUPPORT) && !defined (SQLITE_SUPPORT) && \ - !defined (POSTGRESQL_SUPPORT) -#error "(storage.hpp) no database backend defined" -#endif - -// TODO: Fix problem with PostgreSQL null primary key's. - -/** - * MySQL specificities: - * - TINYINT is an integer (1 byte) type defined as an extension to - * the SQL standard. - * - all integer types can have an optional (non-standard) attribute - * UNSIGNED (http://dev.mysql.com/doc/mysql/en/numeric-types.html) - * - * SQLite3 specificities: - * - any column (but only one for each table) with the exact type of - * 'INTEGER PRIMARY KEY' is taken as auto-increment. - * - the supported data types are: NULL, INTEGER, REAL, TEXT and BLOB - * (http://www.sqlite.org/datatype3.html) - * - the size of TEXT cannot be set, it is just ignored by the engine. - * - IMPORTANT: foreign key constraints are not yet supported - * (http://www.sqlite.org/omitted.html). Included in case of future - * support. - * - * Notes: - * - the SQL queries will take advantage of the most appropriate data - * types supported by a particular database engine in order to - * optimize the server database size. - */ - - -/** - * TABLE: mana_accounts. - */ -static const char *ACCOUNTS_TBL_NAME = "mana_accounts"; - -/** - * TABLE: mana_characters. - * - gender is 0 for male, 1 for female. - */ -static const char *CHARACTERS_TBL_NAME = "mana_characters"; - -/** - * TABLE: mana_char_skills. - */ -static const char *CHAR_SKILLS_TBL_NAME = "mana_char_skills"; - -/** - * TABLE: mana_char_status_effects. - */ -static const char *CHAR_STATUS_EFFECTS_TBL_NAME = "mana_char_status_effects"; - -/** - * TABLE: mana_inventories. - */ -static const char *INVENTORIES_TBL_NAME = "mana_inventories"; - -/** - * TABLE: mana_items. - */ -static const char *ITEMS_TBL_NAME = "mana_items"; - -/** - * TABLE: mana_guilds. - * Store player guilds - */ -static const char *GUILDS_TBL_NAME = "mana_guilds"; - -/** - * TABLE: mana_guild_members. - * Store guild members - */ -static const char *GUILD_MEMBERS_TBL_NAME = "mana_guild_members"; - -/** - * TABLE: mana_quests. - */ -static const char *QUESTS_TBL_NAME = "mana_quests"; - -/** - * TABLE: mana_world_states - */ -static const char *WORLD_STATES_TBL_NAME = "mana_world_states"; - -/** - * TABLE: mana_post - * Store letters sent by characters - */ -static const char *POST_TBL_NAME = "mana_post"; - -/** - * TABLE: mana_post_attachments - * Store attachments per letter. - */ -static const char *POST_ATTACHMENTS_TBL_NAME = "mana_post_attachments"; - -/** - * TABLE: mana_auctions - * Store items auctions. - */ -static const char *AUCTION_TBL_NAME = "mana_auctions"; - -/** - * TABLE: mana_auction_bids - * Store bids on auctions. - */ -static const char *AUCTION_BIDS_TBL_NAME = "mana_auction_bids"; - -/** - * TABLE: mana_online_list - * List currently online users. - */ -static const char *ONLINE_USERS_TBL_NAME = "mana_online_list"; - -/** - * TABLE: mana_transactions - * Stores all transactions - */ -static const char *TRANSACTION_TBL_NAME = "mana_transactions"; - -#endif // _MANASERV_DALSTORAGE_SQL_H |