Thread: [phpwiki-checkins] CVS: phpwiki/schemas mysql.sql,1.1,1.2

Update of /cvsroot/phpwiki/phpwiki/schemas
In directory usw-pr-cvs1:/tmp/cvs-serv10439/phpwiki/schemas
Modified Files:
	mysql.sql 
Log Message:
Converted tabs to spaces, mysql doesn't like tabs :-(
Index: mysql.sql
===================================================================
RCS file: /cvsroot/phpwiki/phpwiki/schemas/mysql.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -r1.1 -r1.2
*** mysql.sql	2001年12月03日 04:05:38	1.1
--- mysql.sql	2001年12月04日 23:49:33	1.2
***************
*** 3,10 ****
 drop table if exists page;
 CREATE TABLE page (
! 	id		INT NOT NULL,
! pagename	VARCHAR(100) BINARY NOT NULL,
! 	hits		INT NOT NULL DEFAULT 0,
! pagedata	MEDIUMTEXT NOT NULL DEFAULT '',
 PRIMARY KEY (id),
 	UNIQUE KEY (pagename)
--- 3,10 ----
 drop table if exists page;
 CREATE TABLE page (
! 	id INT NOT NULL,
! pagename VARCHAR(100) BINARY NOT NULL,
! 	hits INT NOT NULL DEFAULT 0,
! pagedata MEDIUMTEXT NOT NULL DEFAULT '',
 PRIMARY KEY (id),
 	UNIQUE KEY (pagename)
***************
*** 13,22 ****
 drop table if exists version;
 CREATE TABLE version (
! 	id		INT NOT NULL,
! version		INT NOT NULL,
! 	mtime		INT NOT NULL,
! 	minor_edit	TINYINT DEFAULT 0,
! content		MEDIUMTEXT NOT NULL DEFAULT '',
! versiondata	MEDIUMTEXT NOT NULL DEFAULT '',
 PRIMARY KEY (id,version),
 	INDEX (mtime)
--- 13,22 ----
 drop table if exists version;
 CREATE TABLE version (
! 	id INT NOT NULL,
! version INT NOT NULL,
! 	mtime INT NOT NULL,
! 	minor_edit TINYINT DEFAULT 0,
! content MEDIUMTEXT NOT NULL DEFAULT '',
! versiondata MEDIUMTEXT NOT NULL DEFAULT '',
 PRIMARY KEY (id,version),
 	INDEX (mtime)
***************
*** 25,32 ****
 drop table if exists recent;
 CREATE TABLE recent (
! 	id		INT NOT NULL,
! 	latestversion	INT,
! 	latestmajor	INT,
! 	latestminor	INT,
 PRIMARY KEY (id)
 );
--- 25,32 ----
 drop table if exists recent;
 CREATE TABLE recent (
! 	id INT NOT NULL,
! 	latestversion INT,
! 	latestmajor INT,
! 	latestminor INT,
 PRIMARY KEY (id)
 );
***************
*** 34,38 ****
 drop table if exists nonempty;
 CREATE TABLE nonempty (
! 	id		INT NOT NULL,
 	PRIMARY KEY (id)
 );
--- 34,38 ----
 drop table if exists nonempty;
 CREATE TABLE nonempty (
! 	id INT NOT NULL,
 	PRIMARY KEY (id)
 );
***************
*** 40,45 ****
 drop table if exists link;
 CREATE TABLE link (
! linkfrom	INT NOT NULL,
! linkto		INT NOT NULL,
 	INDEX (linkfrom),
 INDEX (linkto)
--- 40,45 ----
 drop table if exists link;
 CREATE TABLE link (
! linkfrom INT NOT NULL,
! linkto INT NOT NULL,
 	INDEX (linkfrom),
 INDEX (linkto)