Update of /cvsroot/phpwiki/phpwiki/schemas
In directory usw-pr-cvs1:/tmp/cvs-serv26353/schemas
Modified Files:
schema.mysql
Log Message:
I changed the table names in the schema so all are prefaced with phpwiki_.
I updated index.php (where the config info is) as well; seems to test OK.
Index: schema.mysql
===================================================================
RCS file: /cvsroot/phpwiki/phpwiki/schemas/schema.mysql,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -r1.4 -r1.5
*** schema.mysql 2001/06/26 17:51:30 1.4
--- schema.mysql 2001/07/12 03:21:35 1.5
***************
*** 1,13 ****
-- $Id$
! drop table if exists wiki;
! drop table if exists archive;
! drop table if exists wikilinks;
! drop table if exists hitcount;
! drop table if exists wikiscore;
! drop table if exists hottopics;
! CREATE TABLE wiki (
pagename VARCHAR(100) NOT NULL,
version INT NOT NULL DEFAULT 1,
--- 1,13 ----
-- $Id$
! drop table if exists phpwiki_pages;
! drop table if exists phpwiki_archive;
! drop table if exists phpwiki_wikilinks;
! drop table if exists phpwiki_hitcount;
! drop table if exists phpwiki_score;
! drop table if exists phpwiki_hottopics;
! CREATE TABLE phpwiki_pages (
pagename VARCHAR(100) NOT NULL,
version INT NOT NULL DEFAULT 1,
***************
*** 21,25 ****
);
! CREATE TABLE archive (
pagename VARCHAR(100) NOT NULL,
version INT NOT NULL DEFAULT 1,
--- 21,25 ----
);
! CREATE TABLE phpwiki_archive (
pagename VARCHAR(100) NOT NULL,
version INT NOT NULL DEFAULT 1,
***************
*** 33,37 ****
);
! CREATE TABLE wikilinks (
frompage VARCHAR(100) NOT NULL,
topage VARCHAR(100) NOT NULL,
--- 33,37 ----
);
! CREATE TABLE phpwiki_links (
frompage VARCHAR(100) NOT NULL,
topage VARCHAR(100) NOT NULL,
***************
*** 39,43 ****
);
! CREATE TABLE hitcount (
pagename VARCHAR(100) NOT NULL,
hits INT NOT NULL DEFAULT 0,
--- 39,43 ----
);
! CREATE TABLE phpwiki_hitcount (
pagename VARCHAR(100) NOT NULL,
hits INT NOT NULL DEFAULT 0,
***************
*** 45,49 ****
);
! CREATE TABLE wikiscore (
pagename VARCHAR(100) NOT NULL,
score INT NOT NULL DEFAULT 0,
--- 45,49 ----
);
! CREATE TABLE phpwiki_score (
pagename VARCHAR(100) NOT NULL,
score INT NOT NULL DEFAULT 0,
***************
*** 54,58 ****
-- tables below are not yet used
! CREATE TABLE hottopics (
pagename VARCHAR(100) NOT NULL,
lastmodified INT NOT NULL,
--- 54,58 ----
-- tables below are not yet used
! CREATE TABLE phpwiki_hottopics (
pagename VARCHAR(100) NOT NULL,
lastmodified INT NOT NULL,
|