[Rapforums-developer] properties tables.xml,1.1.1.1,1.2
Status: Beta
Brought to you by:
brippe
Menu
▾
▴
[Rapforums-developer] properties tables.xml,1.1.1.1,1.2
|
From: <br...@pr...> - 2004-01-26 18:41:30
|
Update of /cvsroot/rapforums/properties In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv17673 Modified Files: tables.xml Log Message: Update classpath to version 0.8.3 Index: tables.xml =================================================================== RCS file: /cvsroot/rapforums/properties/tables.xml,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** tables.xml 25 Sep 2003 23:08:38 -0000 1.1.1.1 --- tables.xml 26 Jan 2004 18:40:31 -0000 1.2 *************** *** 3,11 **** <tables> <table> ! <name>rapCategory</name> <desc>Forum categories</desc> <columns> <column> ! <name>categoryID</name> <type>INTEGER</type> <desc>Internal id for each category</desc> --- 3,11 ---- <tables> <table> ! <name>rapcategory</name> <desc>Forum categories</desc> <columns> <column> ! <name>categoryid</name> <type>INTEGER</type> <desc>Internal id for each category</desc> *************** *** 25,34 **** </column> <column> ! <name>creationDate</name> <type>TIMESTAMP</type> <desc>Date the category was created</desc> </column> <column> ! <name>modifiedDate</name> <type>TIMESTAMP</type> <desc>Last date the category was modified</desc> --- 25,34 ---- </column> <column> ! <name>creationdate</name> <type>TIMESTAMP</type> <desc>Date the category was created</desc> </column> <column> ! <name>modifieddate</name> <type>TIMESTAMP</type> <desc>Last date the category was modified</desc> *************** *** 37,74 **** <name>lft</name> <type>INTEGER</type> ! <desc></desc> </column> <column> <name>rgt</name> <type>INTEGER</type> ! <desc></desc> </column> </columns> ! <not-null>categoryID</not-null> <not-null>name</not-null> </table> <table> ! <name>rapComment</name> <desc>Contains user messages. These are message in each forum and thread</desc> <columns> <column> ! <name>commentID</name> <type>INTEGER</type> <key>PK</key> </column> <column> ! <name>parentCommentID</name> <type>INTEGER</type> </column> <column> ! <name>threadID</name> <type>INTEGER</type> </column> <column> ! <name>forumID</name> <type>INTEGER</type> </column> <column> ! <name>userID</name> <type>VARCHAR</type> <param>255</param> --- 37,74 ---- <name>lft</name> <type>INTEGER</type> ! <desc/> </column> <column> <name>rgt</name> <type>INTEGER</type> ! <desc/> </column> </columns> ! <not-null>categoryid</not-null> <not-null>name</not-null> </table> <table> ! <name>rapcomment</name> <desc>Contains user messages. These are message in each forum and thread</desc> <columns> <column> ! <name>commentid</name> <type>INTEGER</type> <key>PK</key> </column> <column> ! <name>parentcommentid</name> <type>INTEGER</type> </column> <column> ! <name>threadid</name> <type>INTEGER</type> </column> <column> ! <name>forumid</name> <type>INTEGER</type> </column> <column> ! <name>userid</name> <type>VARCHAR</type> <param>255</param> *************** *** 88,120 **** </column> <column> ! <name>modValue</name> <type>INTEGER</type> </column> <column> ! <name>bonusPoints</name> <type>INTEGER</type> </column> <column> ! <name>creationDate</name> <type>TIMESTAMP</type> <desc>Date the category was created</desc> </column> <column> ! <name>modifiedDate</name> <type>TIMESTAMP</type> <desc>Last date the category was modified</desc> </column> </columns> ! <not-null>commentID</not-null> </table> <table> ! <name>rapForum</name> <desc>Information about individual forums.</desc> <columns> <column> ! <name>forumID</name> <type>INTEGER</type> <key>PK</key> ! </column> <column> <name>name</name> --- 88,120 ---- </column> <column> ! <name>modvalue</name> <type>INTEGER</type> </column> <column> ! <name>bonuspoints</name> <type>INTEGER</type> </column> <column> ! <name>creationdate</name> <type>TIMESTAMP</type> <desc>Date the category was created</desc> </column> <column> ! <name>modifieddate</name> <type>TIMESTAMP</type> <desc>Last date the category was modified</desc> </column> </columns> ! <not-null>commentid</not-null> </table> <table> ! <name>rapforum</name> <desc>Information about individual forums.</desc> <columns> <column> ! <name>forumid</name> <type>INTEGER</type> <key>PK</key> ! </column> <column> <name>name</name> *************** *** 126,157 **** <type>VARCHAR</type> <param>255</param> ! </column> <column> ! <name>creationDate</name> <type>TIMESTAMP</type> <desc>Date the forum was created</desc> </column> <column> ! <name>modifiedDate</name> <type>TIMESTAMP</type> <desc>Last date the forum was modified</desc> </column> <column> ! <name>categoryID</name> <type>INTEGER</type> </column> </columns> ! <not-null>forumID</not-null> ! <not-null>categoryID</not-null> </table> <table> ! <name>rapID</name> <desc>Cache of identification number for Forums, Threads, Comments, and Categories.</desc> <columns> <column> ! <name>idType</name> <type>INTEGER</type> ! <desc>Types are Forums = 1, Threads = 2, Comments = 3, and Categories = 4. Please see edu.fullcoll.uportal.channels.rap.forum.IDManager for more information.</desc> ! </column> <column> <name>id</name> --- 126,157 ---- <type>VARCHAR</type> <param>255</param> ! </column> <column> ! <name>creationdate</name> <type>TIMESTAMP</type> <desc>Date the forum was created</desc> </column> <column> ! <name>modifieddate</name> <type>TIMESTAMP</type> <desc>Last date the forum was modified</desc> </column> <column> ! <name>categoryid</name> <type>INTEGER</type> </column> </columns> ! <not-null>forumid</not-null> ! <not-null>categoryid</not-null> </table> <table> ! <name>rapid</name> <desc>Cache of identification number for Forums, Threads, Comments, and Categories.</desc> <columns> <column> ! <name>idtype</name> <type>INTEGER</type> ! <desc>Types are Forums = 1, Threads = 2, Comments = 3, and Categories = 4. Please see edu.fullcoll.uportal.channels.rap.forum.IDManager for more information.</desc> ! </column> <column> <name>id</name> *************** *** 161,202 **** </table> <table> ! <name>rapThread</name> <desc>Contains thread information.</desc> <columns> <column> ! <name>threadID</name> <type>INTEGER</type> <key>PK</key> </column> <column> ! <name>forumID</name> <type>INTEGER</type> <key>PK</key> </column> <column> ! <name>rootCommentID</name> <type>INTEGER</type> ! </column> <column> ! <name>modValue</name> <type>INTEGER</type> </column> <column> ! <name>bonusPoints</name> <type>INTEGER</type> </column> <column> ! <name>creationDate</name> <type>TIMESTAMP</type> <desc>Date the category was created</desc> </column> <column> ! <name>modifiedDate</name> <type>TIMESTAMP</type> <desc>Last date the category was modified</desc> </column> </columns> ! <not-null>threadID</not-null> ! <not-null>forumID</not-null> </table> </tables> --- 161,202 ---- </table> <table> ! <name>rapthread</name> <desc>Contains thread information.</desc> <columns> <column> ! <name>threadid</name> <type>INTEGER</type> <key>PK</key> </column> <column> ! <name>forumid</name> <type>INTEGER</type> <key>PK</key> </column> <column> ! <name>rootcommentid</name> <type>INTEGER</type> ! </column> <column> ! <name>modvalue</name> <type>INTEGER</type> </column> <column> ! <name>bonuspoints</name> <type>INTEGER</type> </column> <column> ! <name>creationdate</name> <type>TIMESTAMP</type> <desc>Date the category was created</desc> </column> <column> ! <name>modifieddate</name> <type>TIMESTAMP</type> <desc>Last date the category was modified</desc> </column> </columns> ! <not-null>threadid</not-null> ! <not-null>forumid</not-null> </table> </tables> |
