summaryrefslogtreecommitdiffstats
path: root/changelog/datascheme.sql
diff options
context:
space:
mode:
authorPatrick Davison <snapwilliam@gmail.com>2011-09-10 01:51:18 -0700
committerPatrick Davison <snapwilliam@gmail.com>2011-09-10 01:51:18 -0700
commit183773d794a5d3ec5b5e6a0897b384bb16540a92 (patch)
treee42a2cc4a8df7cf35d0d72580e582ea96ce27a11 /changelog/datascheme.sql
parent632c6e40b7e93eae0341fadcc8afda62b64951e8 (diff)
parent2d64f6e2e79737feb805d8c9b32b60825c5a9dcb (diff)
downloadpathery-183773d794a5d3ec5b5e6a0897b384bb16540a92.tar.xz
Merge branch 'HEAD' of ssh://git@git.raylu.net/pathery
Diffstat (limited to 'changelog/datascheme.sql')
-rw-r--r--changelog/datascheme.sql8
1 files changed, 4 insertions, 4 deletions
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;