From 47612ee2e02badb3f2b5a6987b72fe4d4df51222 Mon Sep 17 00:00:00 2001 From: rurban Date: Mon, 6 Sep 2004 08:31:27 +0000 Subject: [PATCH] better updating hints git-svn-id: svn://svn.code.sf.net/p/phpwiki/code/trunk@3928 96ab9672-09ca-45d6-a79d-3d69d39ca109 --- schemas/mysql-initialize.sql | 8 +++++--- 1 file changed, 5 insertions(+), 3 deletions(-) diff --git a/schemas/mysql-initialize.sql b/schemas/mysql-initialize.sql index 9cfb575be..2b70f3044 100644 --- a/schemas/mysql-initialize.sql +++ b/schemas/mysql-initialize.sql @@ -1,4 +1,4 @@ --- $Id: mysql-initialize.sql,v 1.1 2004-07-22 16:49:20 dfrankow Exp $ +-- $Id: mysql-initialize.sql,v 1.2 2004-09-06 08:31:27 rurban Exp $ CREATE TABLE page ( id INT NOT NULL AUTO_INCREMENT, @@ -49,9 +49,11 @@ CREATE TABLE session ( INDEX (sess_date) ); -- TYPE=heap; -- if your Mysql supports it and you have enough RAM --- upgrade from 1.3.7: +-- upgrade to 1.3.8: (see lib/upgrade.php) -- ALTER TABLE session ADD sess_ip CHAR(15) NOT NULL; -- CREATE INDEX sess_date on session (sess_date); +-- update to 1.3.10: (see lib/upgrade.php) +-- ALTER TABLE page CHANGE id id INT NOT NULL AUTO_INCREMENT; -- Optional DB Auth and Prefs -- For these tables below the default table prefix must be used @@ -80,7 +82,7 @@ CREATE TABLE member ( INDEX (groupname) ) TYPE=MyISAM; --- if you plan to use the wikilens theme +-- only if you plan to use the wikilens theme CREATE TABLE rating ( dimension INT(4) NOT NULL, raterpage INT(11) NOT NULL, -- 2.45.0