From: Geoffrey T. D. <da...@us...> - 2001-08-18 03:57:30
|
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) |