Update of /cvsroot/phpwiki/phpwiki/schemas
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv5816
Modified Files:
mysql-1_3_11.sql mysql-initialize.sql
Log Message:
use the default table type (InnoDB or MyIsam)
remove the HEAP sugegstion. this will not work with mysql yet.
Index: mysql-initialize.sql
===================================================================
RCS file: /cvsroot/phpwiki/phpwiki/schemas/mysql-initialize.sql,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -2 -b -p -d -r1.5 -r1.6
--- mysql-initialize.sql 25 Jan 2005 08:13:14 -0000 1.5
+++ mysql-initialize.sql 7 Feb 2005 15:18:52 -0000 1.6
@@ -54,5 +54,5 @@ CREATE TABLE session (
PRIMARY KEY (sess_id),
INDEX (sess_date)
-); -- TYPE=heap; -- if your Mysql supports it and you have enough RAM
+);
-- upgrade to 1.3.8: (see lib/upgrade.php)
@@ -72,5 +72,5 @@ CREATE TABLE pref (
prefs TEXT NULL DEFAULT '',
PRIMARY KEY (userid)
-) TYPE=MyISAM;
+);
-- better use the extra pref table where such users can be created easily
@@ -82,5 +82,5 @@ CREATE TABLE user (
-- groupname CHAR(48) BINARY DEFAULT 'users',
PRIMARY KEY (userid)
-) TYPE=MyISAM;
+);
CREATE TABLE member (
@@ -89,5 +89,5 @@ CREATE TABLE member (
INDEX (userid),
INDEX (groupname)
-) TYPE=MyISAM;
+);
-- only if you plan to use the wikilens theme
-------------------------------------------------------
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
|
|