diff options
| author | Blue112 <bluesansdouze@gmail.com> | 2009-04-19 19:01:28 +0200 |
|---|---|---|
| committer | Jared Adams <jaxad0127@gmail.com> | 2009-04-19 11:24:08 -0600 |
| commit | a894af35f20a6f7c0b1d86e3f9b35863cea75d2d (patch) | |
| tree | 7dac2b2148133677e35245b0fe10210664e5a144 /src | |
| parent | 3a54fb903f9cc2cc47a852dab6569848d19c6dad (diff) | |
| download | manaserv-a894af35f20a6f7c0b1d86e3f9b35863cea75d2d.tar.gz manaserv-a894af35f20a6f7c0b1d86e3f9b35863cea75d2d.tar.bz2 manaserv-a894af35f20a6f7c0b1d86e3f9b35863cea75d2d.tar.xz manaserv-a894af35f20a6f7c0b1d86e3f9b35863cea75d2d.zip | |
Mysql Backend Update mysql database to version 3 Fixed compile error with mysql backend
Diffstat (limited to 'src')
| -rw-r--r-- | src/dal/mysqldataprovider.h | 1 | ||||
| -rw-r--r-- | src/sql/mysql/createTables.sql | 12 |
2 files changed, 11 insertions, 2 deletions
diff --git a/src/dal/mysqldataprovider.h b/src/dal/mysqldataprovider.h index c5b796f5..ef0f4cfc 100644 --- a/src/dal/mysqldataprovider.h +++ b/src/dal/mysqldataprovider.h @@ -28,6 +28,7 @@ #include <winsock2.h> #endif #include <mysql/mysql.h> +#include <climits> #include "dataprovider.h" #include "common/configuration.hpp" diff --git a/src/sql/mysql/createTables.sql b/src/sql/mysql/createTables.sql index 5d412095..7b533c7b 100644 --- a/src/sql/mysql/createTables.sql +++ b/src/sql/mysql/createTables.sql @@ -158,7 +158,7 @@ DEFAULT CHARSET=utf8; INSERT INTO tmw_world_states VALUES('accountserver_startup',NULL,NULL,UNIX_TIMESTAMP()); INSERT INTO tmw_world_states VALUES('accountserver_version',NULL,NULL,UNIX_TIMESTAMP()); -INSERT INTO tmw_world_states VALUES('database_version', NULL,'2', UNIX_TIMESTAMP()); +INSERT INTO tmw_world_states VALUES('database_version', NULL,'3', UNIX_TIMESTAMP()); -- -- table: `tmw_guilds` @@ -335,4 +335,12 @@ AS JOIN tmw_characters c ON l.char_id = c.id; -
\ No newline at end of file + +CREATE TABLE tmw_transactions +( + id INTEGER PRIMARY KEY, + char_id INTEGER NOT NULL, + action INTEGER NOT NULL, + message TEXT, + time INTEGER NOT NULL +);
\ No newline at end of file |