Thread: [phpwiki-checkins] CVS: phpwiki/schemas schema.mysql,1.4,1.5

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,