Update of /cvsroot/phpwiki/phpwiki/schemas
In directory slayer.i.sourceforge.net:/tmp/cvs-serv14447
Modified Files:
schema.minisql
Log Message:
Added/tested wikiscore table.
Index: schema.minisql
===================================================================
RCS file: /cvsroot/phpwiki/phpwiki/schemas/schema.minisql,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -r1.5 -r1.6
*** schema.minisql 2000/06/29 04:30:31 1.5
--- schema.minisql 2000/11/03 05:50:52 1.6
***************
*** 9,12 ****
--- 9,13 ----
drop table hottopics\g
drop table hitcount\g
+ drop table wikiscore\g
# metadata about the page
***************
*** 99,100 ****
--- 100,109 ----
\g
+ CREATE TABLE wikiscore (
+ pagename CHAR(100) NOT NULL,
+ score INT NOT NULL
+ )
+ \g
+
+ CREATE UNIQUE INDEX hitcount_index ON wikiscore (pagename)
+ \g
|
