|
From: Steve W. <wai...@us...> - 2000-11-03 05:50:55
|
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 |