[phpwiki-checkins] CVS: phpwiki/schemas schema.psql,1.5,1.6

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

Update of /cvsroot/phpwiki/phpwiki/schemas
In directory usw-pr-cvs1:/tmp/cvs-serv26877

Modified Files:
	schema.psql 
Log Message:
Updated table names so all are prefaced with 'phpwiki_'. This is not
tested with Postgresql yet though.

Index: schema.psql
===================================================================
RCS file: /cvsroot/phpwiki/phpwiki/schemas/schema.psql,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -r1.5 -r1.6
*** schema.psql	2000/11/02 04:34:41	1.5
--- schema.psql	2001/07/12 03:24:18	1.6
***************
*** 1,10 ****
  -- $Id$
  
! drop table wiki;
! drop table archive;
! drop table wikilinks;
! drop table hottopics;
! drop table hitcount;
! drop table wikiscore;
  
  CREATE TABLE wiki (
--- 1,10 ----
  -- $Id$
  
! drop table phpwiki_pages;
! drop table phpwiki_archive;
! drop table phpwiki_links;
! drop table phpwiki_hottopics;
! drop table phpwiki_hitcount;
! drop table phpwiki_score;
  
  CREATE TABLE wiki (
***************
*** 20,24 ****
          );
  
! CREATE TABLE archive (
          pagename VARCHAR(100) NOT NULL,
          version INT NOT NULL DEFAULT 1,
--- 20,24 ----
          );
  
! CREATE TABLE phpwiki_archive (
          pagename VARCHAR(100) NOT NULL,
          version INT NOT NULL DEFAULT 1,
***************
*** 32,36 ****
          );
  
! CREATE TABLE wikilinks (
          frompage VARCHAR(100) NOT NULL,
          topage VARCHAR(100) NOT NULL,
--- 32,36 ----
          );
  
! CREATE TABLE phpwiki_links (
          frompage VARCHAR(100) NOT NULL,
          topage VARCHAR(100) NOT NULL,
***************
*** 38,42 ****
          );
  
! CREATE TABLE hottopics (                
          pagename VARCHAR(100) NOT NULL,
          lastmodified INT NOT NULL,
--- 38,42 ----
          );
  
! CREATE TABLE phpwiki_hottopics (                
          pagename VARCHAR(100) NOT NULL,
          lastmodified INT NOT NULL,
***************
*** 44,48 ****
          );
  
! CREATE TABLE hitcount (                 
          pagename VARCHAR(100) NOT NULL, 
          hits INT NOT NULL DEFAULT 0,    
--- 44,48 ----
          );
  
! CREATE TABLE phpwiki_hitcount (                 
          pagename VARCHAR(100) NOT NULL, 
          hits INT NOT NULL DEFAULT 0,    
***************
*** 50,54 ****
          );
  
! CREATE TABLE wikiscore (
          pagename VARCHAR(100) NOT NULL,
          score INT NOT NULL DEFAULT 0,
--- 50,54 ----
          );
  
! CREATE TABLE phpwiki_score (
          pagename VARCHAR(100) NOT NULL,
          score INT NOT NULL DEFAULT 0,
***************
*** 57,65 ****
  
  
! GRANT ALL ON wiki TO nobody;
! GRANT ALL ON archive TO nobody;
! GRANT ALL ON wikilinks TO nobody;
! GRANT ALL ON hottopics TO nobody;
! GRANT ALL ON hitcount TO nobody;
! GRANT ALL ON wikiscore TO nobody;
  
--- 57,65 ----
  
  
! GRANT ALL ON phpwiki_pages TO nobody;
! GRANT ALL ON phpwiki_archive TO nobody;
! GRANT ALL ON phpwiki_links TO nobody;
! GRANT ALL ON phpwiki_hottopics TO nobody;
! GRANT ALL ON phpwiki_hitcount TO nobody;
! GRANT ALL ON phpwiki_score TO nobody;