phpwiki-checkins

[Geoffrey T. D. <da...@us...>]

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)