CVS: phpwiki/schemas mysql-initialize.sql,1.4,1.5

Update of /cvsroot/phpwiki/phpwiki/schemas
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9037/schemas

Modified Files:
        mysql-initialize.sql 
Log Message:
explain about charset problems

Index: mysql-initialize.sql
===================================================================
RCS file: /cvsroot/phpwiki/phpwiki/schemas/mysql-initialize.sql,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -2 -b -p -d -r1.4 -r1.5
--- mysql-initialize.sql        10 Dec 2004 02:45:27 -0000      1.4
+++ mysql-initialize.sql        25 Jan 2005 08:13:14 -0000      1.5
@@ -3,4 +3,8 @@
 CREATE TABLE page (
        id              INT NOT NULL AUTO_INCREMENT,
+-- for mysql => 4.1 define the charset here
+-- this is esp. needed for mysql 4.1.0 up to 4.1.6. not yet confirmed, at 
least since 4.1.8 it's okay with binary.
+--      pagename        VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_bin 
NOT NULL,
+-- otherwise use the old syntax to do case-sensitive comparison
         pagename        VARCHAR(100) BINARY NOT NULL,
        hits            INT NOT NULL DEFAULT 0,
@@ -10,5 +14,5 @@ CREATE TABLE page (
         PRIMARY KEY (id),
        UNIQUE KEY (pagename)
-);
+) CHARSET=latin1;
 
 CREATE TABLE version (
@@ -57,4 +61,6 @@ CREATE TABLE session (
 -- update to 1.3.10: (see lib/upgrade.php)
 -- ALTER TABLE page CHANGE id id INT NOT NULL AUTO_INCREMENT;
+-- update to 1.3.11: (see lib/upgrade.php)
+-- ALTER TABLE page ADD cached_html MEDIUMBLOB;
 
 -- Optional DB Auth and Prefs



-------------------------------------------------------
This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting
Tool for open source databases. Create drag-&-drop reports. Save time
by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc.
Download a FREE copy at http://www.intelliview.com/go/osdn_nl