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;
|
