[phpwiki-checkins] CVS: phpwiki/schemas schema.psql,1.3,1.4

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

Update of /cvsroot/phpwiki/phpwiki/schemas
In directory slayer.i.sourceforge.net:/tmp/cvs-serv9132

Modified Files:
	schema.psql 
Log Message:
Added the wikiscore table; stripped out the grant statements that gave
me access to all postgresql databases worldwide ;-)

Index: schema.psql
===================================================================
RCS file: /cvsroot/phpwiki/phpwiki/schemas/schema.psql,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -r1.3 -r1.4
*** schema.psql	2000/06/20 04:39:16	1.3
--- schema.psql	2000/11/02 04:06:21	1.4
***************
*** 49,52 ****
--- 49,59 ----
          );
  
+ CREATE TABLE wikiscore (
+         pagename VARCHAR(100) NOT NULL,
+         score INT NOT NULL DEFAULT 0,
+         PRIMARY KEY (pagename)
+         );
+ 
+ 
  GRANT ALL ON wiki TO nobody;
  GRANT ALL ON archive TO nobody;
***************
*** 54,61 ****
  GRANT ALL ON hottopics TO nobody;
  GRANT ALL ON hitcount TO nobody;
  
- GRANT ALL ON wiki TO swain;
- GRANT ALL ON archive TO swain;
- GRANT ALL ON wikilinks TO swain;
- GRANT ALL ON hottopics TO swain;
- GRANT ALL ON hitcount TO swain;
--- 61,64 ----
  GRANT ALL ON hottopics TO nobody;
  GRANT ALL ON hitcount TO nobody;
+ GRANT ALL ON wikiscore TO nobody;