From 48e4f8df9b1171bb93cc50a7f1f42148e3118026 Mon Sep 17 00:00:00 2001
From: raylu <raylu@mixpanel.com>
Date: Fri, 9 Sep 2011 23:39:07 -0700
Subject: use InnoDB and utf8

---
 changelog/datascheme.sql | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

(limited to 'changelog/datascheme.sql')

diff --git a/changelog/datascheme.sql b/changelog/datascheme.sql
index bb00b23..7e88d91 100644
--- a/changelog/datascheme.sql
+++ b/changelog/datascheme.sql
@@ -31,7 +31,7 @@ CREATE TABLE `mapOfTheDay` (
   `mapType` tinyint(4) NOT NULL,
   `mapDate` date NOT NULL,
   PRIMARY KEY  (`ID`)
-) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 
@@ -44,7 +44,7 @@ CREATE TABLE `maps` (
   `code` varchar(512) collate latin1_general_ci NOT NULL,
   `dateCreated` timestamp NOT NULL default CURRENT_TIMESTAMP,
   PRIMARY KEY  (`ID`)
-) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 
@@ -61,7 +61,7 @@ CREATE TABLE `solutions` (
   `dateModified` timestamp NOT NULL default CURRENT_TIMESTAMP,
   PRIMARY KEY  (`ID`),
   KEY `userID` (`userID`,`mapID`)
-) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------
 
@@ -79,4 +79,4 @@ CREATE TABLE `users` (
   `isAdmin` tinyint(1) NOT NULL default '0',
   PRIMARY KEY  (`ID`),
   UNIQUE KEY `openID` (`openID`)
-) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
-- 
cgit v1.2.3

