1 /***************************************************************************** 2 * PokerTH - The open source texas holdem engine * 3 * Copyright (C) 2006-2016 Felix Hammer, Florian Thauer, Lothar May * 4 * * 5 * This program is free software: you can redistribute it and/or modify * 6 * it under the terms of the GNU Affero General Public License as * 7 * published by the Free Software Foundation, either version 3 of the * 8 * License, or (at your option) any later version. * 9 * * 10 * This program is distributed in the hope that it will be useful, * 11 * but WITHOUT ANY WARRANTY; without even the implied warranty of * 12 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * 13 * GNU Affero General Public License for more details. * 14 * * 15 * You should have received a copy of the GNU Affero General Public License * 16 * along with this program. If not, see <http://www.gnu.org/licenses/>. * 17 * * 18 * * 19 * Additional permission under GNU AGPL version 3 section 7 * 20 * * 21 * If you modify this program, or any covered work, by linking or * 22 * combining it with the OpenSSL project's OpenSSL library (or a * 23 * modified version of that library), containing parts covered by the * 24 * terms of the OpenSSL or SSLeay licenses, the authors of PokerTH * 25 * (Felix Hammer, Florian Thauer, Lothar May) grant you additional * 26 * permission to convey the resulting work. * 27 * Corresponding Source for a non-source form of such a combination * 28 * shall include the source code for the parts of OpenSSL used as well * 29 * as that of the covered work. * 30 *****************************************************************************/ 31 32 #ifndef _DB_TABLE_DEFS_H_ 33 #define _DB_TABLE_DEFS_H_ 34 35 #define DB_TABLE_PLAYER "player" 36 #define DB_TABLE_PLAYER_COL_ID "player_id" 37 #define DB_TABLE_PLAYER_COL_USERNAME "username" 38 #define DB_TABLE_PLAYER_COL_PASSWORD "password" 39 #define DB_TABLE_PLAYER_COL_VALID "blocked" 40 #define DB_TABLE_PLAYER_COL_COUNTRY "country_iso" 41 #define DB_TABLE_PLAYER_COL_LASTLOGIN "last_login" 42 #define DB_TABLE_PLAYER_COL_ACTIVE "active" 43 #define DB_TABLE_PLAYER_COL_AVATARHASH "avatar_hash" 44 #define DB_TABLE_PLAYER_COL_AVATARTYPE "avatar_mime" 45 46 #define DB_TABLE_GAME "game" 47 #define DB_TABLE_GAME_COL_ID "idgame" 48 #define DB_TABLE_GAME_COL_NAME "name" 49 #define DB_TABLE_GAME_COL_STARTTIME "start_time" 50 #define DB_TABLE_GAME_COL_ENDTIME "end_time" 51 52 #define DB_TABLE_GAMEPLAYER "game_has_player" 53 #define DB_TABLE_GAMEPLAYER_COL_GAMEID "game_idgame" 54 #define DB_TABLE_GAMEPLAYER_COL_PLAYERID "player_idplayer" 55 #define DB_TABLE_GAMEPLAYER_COL_PLACE "place" 56 57 #define DB_TABLE_REP_AVATAR "reported_avatar" 58 #define DB_TABLE_REP_AVATAR_COL_PLAYERID "idplayer" 59 #define DB_TABLE_REP_AVATAR_COL_AVATARHASH "avatar_hash" 60 #define DB_TABLE_REP_AVATAR_COL_AVATARTYPE "avatar_type" 61 #define DB_TABLE_REP_AVATAR_COL_BY_PLAYERID "by_idplayer" 62 #define DB_TABLE_REP_AVATAR_COL_TIMESTAMP "timestamp" 63 64 #define DB_TABLE_REP_GAME "reported_gamename" 65 #define DB_TABLE_REP_GAME_COL_CREATOR "game_creator_idplayer" 66 #define DB_TABLE_REP_GAME_COL_GAMEID "game_idgame" 67 #define DB_TABLE_REP_GAME_COL_GAMENAME "game_name" 68 #define DB_TABLE_REP_GAME_COL_BY_PLAYERID "by_idplayer" 69 #define DB_TABLE_REP_GAME_COL_TIMESTAMP "timestamp" 70 71 #define DB_TABLE_AVATAR_BLACKLIST "avatar_blacklist" 72 #define DB_TABLE_AVATAR_BLACKLIST_COL_ID "id" 73 #define DB_TABLE_AVATAR_BLACKLIST_COL_AVATAR_HASH "avatar_hash" 74 75 #define DB_TABLE_ADMIN_PLAYER "admin_player" 76 #define DB_TABLE_ADMIN_PLAYER_COL_PLAYERID "admin_idplayer" 77 78 #endif // DB_TABLE_DEFS_H 79