From a28758e1f17e4a340e922000037addb089722ef1 Mon Sep 17 00:00:00 2001
From: wainstead <wainstead@96ab9672-09ca-45d6-a79d-3d69d39ca109>
Date: Thu, 12 Jul 2001 03:21:35 +0000
Subject: [PATCH] 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.

git-svn-id: svn://svn.code.sf.net/p/phpwiki/code/trunk@518 96ab9672-09ca-45d6-a79d-3d69d39ca109
---
 index.php            |  4 ++--
 schemas/schema.mysql | 26 +++++++++++++-------------
 2 files changed, 15 insertions(+), 15 deletions(-)

diff --git a/index.php b/index.php
index cb7aa703b..cf122e93f 100644
--- a/index.php
+++ b/index.php
@@ -23,7 +23,7 @@
 
 define ('PHPWIKI_VERSION', '1.3.0pre');
 require "lib/prepend.php";
-rcs_id('$Id: index.php,v 1.17 2001-05-31 17:39:01 dairiki Exp $');
+rcs_id('$Id: index.php,v 1.18 2001-07-12 03:21:35 wainstead Exp $');
 
 /////////////////////////////////////////////////////////////////////
 //
@@ -85,7 +85,7 @@ $DBParams = array(
    
    // Used by all DB types:
    'database' => 'wiki',
-   'prefix' => '',	// prefix for filenames or table names
+   'prefix' => 'phpwiki_',	// prefix for filenames or table names
    
    // Used by 'dbm', 'dba', 'file'
    'directory' => "/tmp",
diff --git a/schemas/schema.mysql b/schemas/schema.mysql
index 4ddbfacfb..00521a187 100644
--- a/schemas/schema.mysql
+++ b/schemas/schema.mysql
@@ -1,14 +1,14 @@
--- $Id: schema.mysql,v 1.4 2001-06-26 17:51:30 uckelman Exp $
+-- $Id: schema.mysql,v 1.5 2001-07-12 03:21:35 wainstead Exp $
 
-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;
+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 wiki (
+CREATE TABLE phpwiki_pages (
         pagename VARCHAR(100) NOT NULL,
         version INT NOT NULL DEFAULT 1,
         flags INT NOT NULL DEFAULT 0,
@@ -20,7 +20,7 @@ CREATE TABLE wiki (
         PRIMARY KEY (pagename)
         );
 
-CREATE TABLE archive (
+CREATE TABLE phpwiki_archive (
         pagename VARCHAR(100) NOT NULL,
         version INT NOT NULL DEFAULT 1,
         flags INT NOT NULL DEFAULT 0,
@@ -32,19 +32,19 @@ CREATE TABLE archive (
         PRIMARY KEY (pagename, version)
         );
 
-CREATE TABLE wikilinks (
+CREATE TABLE phpwiki_links (
         frompage VARCHAR(100) NOT NULL,
         topage VARCHAR(100) NOT NULL,
         PRIMARY KEY (frompage, topage)
         );
 
-CREATE TABLE hitcount (
+CREATE TABLE phpwiki_hitcount (
         pagename VARCHAR(100) NOT NULL,
         hits INT NOT NULL DEFAULT 0,
         PRIMARY KEY (pagename)
         );
 
-CREATE TABLE wikiscore (
+CREATE TABLE phpwiki_score (
         pagename VARCHAR(100) NOT NULL,
         score INT NOT NULL DEFAULT 0,
         PRIMARY KEY (pagename)
@@ -53,7 +53,7 @@ CREATE TABLE wikiscore (
 
 -- tables below are not yet used
 
-CREATE TABLE hottopics (                
+CREATE TABLE phpwiki_hottopics (                
         pagename VARCHAR(100) NOT NULL,
         lastmodified INT NOT NULL,
         PRIMARY KEY (pagename, lastmodified)
-- 
2.45.0