From 48e4f8df9b1171bb93cc50a7f1f42148e3118026 Mon Sep 17 00:00:00 2001 From: raylu 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') 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