diff options
| author | Andreas Habel <mail@exceptionfault.de> | 2008-09-17 18:33:43 +0000 |
|---|---|---|
| committer | Andreas Habel <mail@exceptionfault.de> | 2008-09-17 18:33:43 +0000 |
| commit | 12c585f16ec1918e9d3ab44a3a19d7bc4539e214 (patch) | |
| tree | 238488bf65394efb57b0d5f52ce2b875ee62c19d /src/sql | |
| parent | a2af298fd993a129b657671a41f20e3975baf0ef (diff) | |
| download | manaserv-12c585f16ec1918e9d3ab44a3a19d7bc4539e214.tar.gz manaserv-12c585f16ec1918e9d3ab44a3a19d7bc4539e214.tar.xz manaserv-12c585f16ec1918e9d3ab44a3a19d7bc4539e214.zip | |
fixed CHARSET parameter to utf8
Diffstat (limited to 'src/sql')
| -rw-r--r-- | src/sql/mysql/createTables.sql | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/src/sql/mysql/createTables.sql b/src/sql/mysql/createTables.sql index 3bcf665..2f164cc 100644 --- a/src/sql/mysql/createTables.sql +++ b/src/sql/mysql/createTables.sql @@ -16,7 +16,7 @@ CREATE TABLE IF NOT EXISTS `tmw_accounts` ( UNIQUE KEY `username` (`username`), UNIQUE KEY `email` (`email`) ) ENGINE=InnoDB -DEFAULT CHARSET=utf8_general_ci +DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- @@ -66,7 +66,7 @@ CREATE TABLE IF NOT EXISTS `tmw_characters` ( REFERENCES `tmw_accounts` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB -DEFAULT CHARSET=utf8_general_ci +DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- @@ -86,7 +86,7 @@ CREATE TABLE IF NOT EXISTS `tmw_inventories` ( REFERENCES `tmw_characters` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB -DEFAULT CHARSET=utf8_general_ci +DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- @@ -101,7 +101,7 @@ CREATE TABLE IF NOT EXISTS `tmw_world_states` ( -- KEY `state_name` (`state_name`) ) ENGINE=InnoDB -DEFAULT CHARSET=utf8_general_ci; +DEFAULT CHARSET=utf8; -- -- table: `tmw_guilds` @@ -114,7 +114,7 @@ CREATE TABLE IF NOT EXISTS `tmw_guilds` ( PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB -DEFAULT CHARSET=utf8_general_ci +DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- @@ -134,7 +134,7 @@ CREATE TABLE IF NOT EXISTS `tmw_guild_members` ( REFERENCES `tmw_characters` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB -DEFAULT CHARSET=utf8_general_ci; +DEFAULT CHARSET=utf8; -- -- table: `tmw_quests` @@ -150,4 +150,4 @@ CREATE TABLE IF NOT EXISTS `tmw_quests` ( REFERENCES `tmw_characters` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB -DEFAULT CHARSET=utf8_general_ci; +DEFAULT CHARSET=utf8; |