diff options
Diffstat (limited to 'src/shared/Database/DatabaseEnv.h')
| -rw-r--r-- | src/shared/Database/DatabaseEnv.h | 10 |
1 files changed, 6 insertions, 4 deletions
diff --git a/src/shared/Database/DatabaseEnv.h b/src/shared/Database/DatabaseEnv.h index 0e6b1607aa5..7491464285d 100644 --- a/src/shared/Database/DatabaseEnv.h +++ b/src/shared/Database/DatabaseEnv.h @@ -34,9 +34,10 @@ #include "Database/Database.h" #include "Database/DatabasePostgre.h" typedef DatabasePostgre DatabaseType; -#define _LIKE_ "ILIKE" -#define _TABLE_SIM_ "\"" +#define _LIKE_ "ILIKE" +#define _TABLE_SIM_ "\"" #define _CONCAT3_(A,B,C) "( " A " || " B " || " C " )" +#define _OFFSET_ "LIMIT 1 OFFSET %d" #else #include "Database/QueryResultMysql.h" #include "Database/QueryResultSqlite.h" @@ -44,9 +45,10 @@ typedef DatabasePostgre DatabaseType; #include "Database/DatabaseMysql.h" #include "Database/DatabaseSqlite.h" typedef DatabaseMysql DatabaseType; -#define _LIKE_ "LIKE" -#define _TABLE_SIM_ "`" +#define _LIKE_ "LIKE" +#define _TABLE_SIM_ "`" #define _CONCAT3_(A,B,C) "CONCAT( " A " , " B " , " C " )" +#define _OFFSET_ "LIMIT %d,1" #endif extern DatabaseType WorldDatabase; |