[phpwiki-checkins] CVS: phpwiki/schemas mysql-initialize.sql, 1.10, 1.11

[Reini U. <ru...@us...>]

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

Modified Files:
	mysql-initialize.sql 
Log Message:
fix bug 1492846: blanks after --, no CHARSET for portability

Index: mysql-initialize.sql
===================================================================
RCS file: /cvsroot/phpwiki/phpwiki/schemas/mysql-initialize.sql,v
retrieving revision 1.10
retrieving revision 1.11
diff -u -2 -b -p -d -r1.10 -r1.11
--- mysql-initialize.sql	15 Nov 2005 21:12:22 -0000	1.10
+++ mysql-initialize.sql	10 Jun 2006 12:02:18 -0000	1.11
@@ -15,5 +15,5 @@ CREATE TABLE page (
         PRIMARY KEY (id),
 	UNIQUE KEY (pagename)
-) CHARSET=latin1;
+);
 
 CREATE TABLE version (
@@ -79,5 +79,7 @@ CREATE TABLE pref (
   	PRIMARY KEY (userid)
 );
+
 -- update to 1.3.12: (see lib/upgrade.php)
+
 -- ALTER TABLE pref ADD passwd 	CHAR(48) BINARY DEFAULT '';
 -- ALTER TABLE pref ADD groupname CHAR(48) BINARY DEFAULT 'users';
@@ -86,5 +88,6 @@ CREATE TABLE pref (
 -- better use the extra pref table where such users can be created easily 
 -- without password.
---CREATE TABLE user (
+
+-- CREATE TABLE user (
 --  	userid 	CHAR(48) BINARY NOT NULL UNIQUE,
 --  	passwd 	CHAR(48) BINARY DEFAULT '',
@@ -92,8 +95,9 @@ CREATE TABLE pref (
 --	groupname CHAR(48) BINARY DEFAULT 'users',
 --  	PRIMARY KEY (userid)
---);
+-- );
 
 -- Use the member table, if you need it for n:m user-group relations,
 -- and adjust your DBAUTH_AUTH_ SQL statements.
+
 CREATE TABLE member (
 	userid    CHAR(48) BINARY NOT NULL,