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

[Steve W. <wai...@us...>]

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,