Thread: [phpwiki-checkins] CVS: phpwiki/schemas update.mysql.1.2.0-1.2.1,NONE,1.1.2.1 schema.mysql,1.3,1.3.2

Update of /cvsroot/phpwiki/phpwiki/schemas
In directory usw-pr-cvs1:/tmp/cvs-serv10849/schemas
Modified Files:
 Tag: release-1_2-branch
	schema.mysql 
Added Files:
 Tag: release-1_2-branch
	update.mysql.1.2.0-1.2.1 
Log Message:
Fixed SF Bug #233898. (MySQL backend insensitive to case in page names.)
Note that this involves a change to the MySQL schema. A convenient
mysql script, schemas/update.mysql.1.2.0-1.2.1, is provided which can
be used to update your schema in-place.
***** Error reading new file: [Errno 2] No such file or directory: 'update.mysql.1.2.0-1.2.1'
Index: schema.mysql
===================================================================
RCS file: /cvsroot/phpwiki/phpwiki/schemas/schema.mysql,v
retrieving revision 1.3
retrieving revision 1.3.2.1
diff -C2 -r1.3 -r1.3.2.1
*** schema.mysql	2000年09月23日 14:31:38	1.3
--- schema.mysql	2001年08月18日 03:57:27	1.3.2.1
***************
*** 10,14 ****
 
 CREATE TABLE wiki (
! pagename VARCHAR(100) NOT NULL,
 version INT NOT NULL DEFAULT 1,
 flags INT NOT NULL DEFAULT 0,
--- 10,14 ----
 
 CREATE TABLE wiki (
! pagename VARCHAR(100) BINARY NOT NULL,
 version INT NOT NULL DEFAULT 1,
 flags INT NOT NULL DEFAULT 0,
***************
*** 22,26 ****
 
 CREATE TABLE archive (
! pagename VARCHAR(100) NOT NULL,
 version INT NOT NULL DEFAULT 1,
 flags INT NOT NULL DEFAULT 0,
--- 22,26 ----
 
 CREATE TABLE archive (
! pagename VARCHAR(100) BINARY NOT NULL,
 version INT NOT NULL DEFAULT 1,
 flags INT NOT NULL DEFAULT 0,
***************
*** 34,44 ****
 
 CREATE TABLE wikilinks (
! frompage VARCHAR(100) NOT NULL,
! topage VARCHAR(100) NOT NULL,
 PRIMARY KEY (frompage, topage)
 );
 
 CREATE TABLE hitcount (
! pagename VARCHAR(100) NOT NULL,
 hits INT NOT NULL DEFAULT 0,
 PRIMARY KEY (pagename)
--- 34,44 ----
 
 CREATE TABLE wikilinks (
! frompage VARCHAR(100) BINARY NOT NULL,
! topage VARCHAR(100) BINARY NOT NULL,
 PRIMARY KEY (frompage, topage)
 );
 
 CREATE TABLE hitcount (
! pagename VARCHAR(100) BINARY NOT NULL,
 hits INT NOT NULL DEFAULT 0,
 PRIMARY KEY (pagename)
***************
*** 46,50 ****
 
 CREATE TABLE wikiscore (
! pagename VARCHAR(100) NOT NULL,
 score INT NOT NULL DEFAULT 0,
 PRIMARY KEY (pagename)
--- 46,50 ----
 
 CREATE TABLE wikiscore (
! pagename VARCHAR(100) BINARY NOT NULL,
 score INT NOT NULL DEFAULT 0,
 PRIMARY KEY (pagename)
***************
*** 55,59 ****
 
 CREATE TABLE hottopics ( 
! pagename VARCHAR(100) NOT NULL,
 lastmodified INT NOT NULL,
 PRIMARY KEY (pagename, lastmodified)
--- 55,59 ----
 
 CREATE TABLE hottopics ( 
! pagename VARCHAR(100) BINARY NOT NULL,
 lastmodified INT NOT NULL,
 PRIMARY KEY (pagename, lastmodified)