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

[Carsten K. <car...@us...>]

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)