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)
|
