[Rapforums-developer] sql rapforumsMYSQLTables.sql,1.1,1.2

[<br...@pr...>]

Update of /cvsroot/rapforums/sql
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv18860

Modified Files:
	rapforumsMYSQLTables.sql 
Log Message:
Update to version 0.8.3

Index: rapforumsMYSQLTables.sql
===================================================================
RCS file: /cvsroot/rapforums/sql/rapforumsMYSQLTables.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** rapforumsMYSQLTables.sql	9 Dec 2003 19:00:45 -0000	1.1
--- rapforumsMYSQLTables.sql	26 Jan 2004 18:43:46 -0000	1.2
***************
*** 14,19 ****
    NAME          VARCHAR (85)  NOT NULL, 
    DESCRIPTION   VARCHAR (255), 
!   CREATIONDATE  TIMESTAMP(6),  --DEFAULT sysdate, 
!   MODIFIEDDATE  TIMESTAMP(6), -- DEFAULT sysdate, 
    LFT           INTEGER , 
    RGT           INTEGER , 
--- 14,19 ----
    NAME          VARCHAR (85)  NOT NULL, 
    DESCRIPTION   VARCHAR (255), 
!   CREATIONDATE  TIMESTAMP(10),  --DEFAULT sysdate, 
!   MODIFIEDDATE  TIMESTAMP(10), -- DEFAULT sysdate, 
    LFT           INTEGER , 
    RGT           INTEGER , 
***************
*** 33,38 ****
    MODVALUE         DECIMAL , 
    BONUSPOINTS      INTEGER, 
!   CREATIONDATE     TIMESTAMP(6), -- DEFAULT sysdate, 
!   MODIFIEDDATE     TIMESTAMP(6), -- DEFAULT sysdate, 
    CONSTRAINT RAPCOMMENT_IDX
    PRIMARY KEY ( COMMENTID ) ) ; 
--- 33,38 ----
    MODVALUE         DECIMAL , 
    BONUSPOINTS      INTEGER, 
!   CREATIONDATE     TIMESTAMP(10), -- DEFAULT sysdate, 
!   MODIFIEDDATE     TIMESTAMP(10), -- DEFAULT sysdate, 
    CONSTRAINT RAPCOMMENT_IDX
    PRIMARY KEY ( COMMENTID ) ) ; 
***************
*** 44,49 ****
    NAME          VARCHAR (255), 
    DESCRIPTION   VARCHAR (255), 
!   CREATIONDATE  TIMESTAMP(6), --  DEFAULT sysdate, 
!   MODIFIEDDATE  TIMESTAMP(6), --  DEFAULT sysdate, 
    CATEGORYID    INTEGER        NOT NULL, 
    CONSTRAINT RAPFORUM_IDX
--- 44,49 ----
    NAME          VARCHAR (255), 
    DESCRIPTION   VARCHAR (255), 
!   CREATIONDATE  TIMESTAMP(10), --  DEFAULT sysdate, 
!   MODIFIEDDATE  TIMESTAMP(10), --  DEFAULT sysdate, 
    CATEGORYID    INTEGER        NOT NULL, 
    CONSTRAINT RAPFORUM_IDX
***************
*** 64,69 ****
    MODVALUE       INTEGER, 
    BONUSPOINTS    INTEGER, -- default 0
!   CREATIONDATE   TIMESTAMP(6), --  DEFAULT sysdate, 
!   MODIFIEDDATE   TIMESTAMP(6), --  DEFAULT sysdate, 
    CONSTRAINT RAPTHREAD_IDX
    PRIMARY KEY ( THREADID, FORUMID ) ) ; 
--- 64,69 ----
    MODVALUE       INTEGER, 
    BONUSPOINTS    INTEGER, -- default 0
!   CREATIONDATE   TIMESTAMP(10), --  DEFAULT sysdate, 
!   MODIFIEDDATE   TIMESTAMP(10), --  DEFAULT sysdate, 
    CONSTRAINT RAPTHREAD_IDX
    PRIMARY KEY ( THREADID, FORUMID ) ) ;