From 12c585f16ec1918e9d3ab44a3a19d7bc4539e214 Mon Sep 17 00:00:00 2001
From: Andreas Habel <mail@exceptionfault.de>
Date: Wed, 17 Sep 2008 18:33:43 +0000
Subject: fixed CHARSET parameter to utf8

---
 src/sql/mysql/createTables.sql | 14 +++++++-------
 1 file changed, 7 insertions(+), 7 deletions(-)

(limited to 'src/sql/mysql/createTables.sql')

diff --git a/src/sql/mysql/createTables.sql b/src/sql/mysql/createTables.sql
index 3bcf665e..2f164cca 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;
-- 
cgit v1.2.3-70-g09d2

