[Rapforums-developer] sql rapforumsOracleTables.sql,NONE,1.1

[<br...@us...>]

Update of /cvsroot/rapforums/sql
In directory sc8-pr-cvs1:/tmp/cvs-serv31926

Added Files:
	rapforumsOracleTables.sql 
Log Message:
Add Oracle DB Dump - Creation script for forums tables

--- NEW FILE: rapforumsOracleTables.sql ---
-- By Steve Barrett sm...@co...
DROP TABLE RAPCATEGORY CASCADE CONSTRAINTS ; 

CREATE TABLE RAPCATEGORY ( 
  CATEGORYID    NUMBER        NOT NULL, 
  NAME          VARCHAR2 (85)  NOT NULL, 
  DESCRIPTION   VARCHAR2 (255), 
  CREATIONDATE  TIMESTAMP(6)  DEFAULT sysdate, 
  MODIFIEDDATE  TIMESTAMP(6)  DEFAULT sysdate, 
  LFT           NUMBER, 
  RGT           NUMBER, 
  CONSTRAINT RAPCATEGORY_IDX
  PRIMARY KEY ( CATEGORYID ) ) ; 

DROP TABLE RAPCOMMENT CASCADE CONSTRAINTS ; 

CREATE TABLE RAPCOMMENT ( 
  COMMENTID        NUMBER        NOT NULL, 
  PARENTCOMMENTID  NUMBER, 
  THREADID         NUMBER, 
  FORUMID          NUMBER, 
  USERID           VARCHAR2 (255), 
  SUBJECT          VARCHAR2 (255), 
  BODY             VARCHAR2 (255), 
  MODVALUE         NUMBER, 
  BONUSPOINTS      NUMBER, 
  CREATIONDATE     TIMESTAMP(6)  DEFAULT sysdate, 
  MODIFIEDDATE     TIMESTAMP(6)  DEFAULT sysdate, 
  CONSTRAINT RAPCOMMENT_IDX
  PRIMARY KEY ( COMMENTID ) ) ; 

DROP TABLE RAPFORUM CASCADE CONSTRAINTS ; 

CREATE TABLE RAPFORUM ( 
  FORUMID       NUMBER        NOT NULL, 
  NAME          VARCHAR2 (255), 
  DESCRIPTION   VARCHAR2 (255), 
  CREATIONDATE  TIMESTAMP(6)  DEFAULT sysdate, 
  MODIFIEDDATE  TIMESTAMP(6)  DEFAULT sysdate, 
  CATEGORYID    NUMBER        NOT NULL, 
  CONSTRAINT RAPFORUM_IDX
  PRIMARY KEY ( FORUMID ) ) ; 

DROP TABLE RAPID CASCADE CONSTRAINTS ; 

CREATE TABLE RAPID ( 
  IDTYPE  NUMBER, 
  ID      NUMBER ) ; 

DROP TABLE RAPTHREAD CASCADE CONSTRAINTS ; 

CREATE TABLE RAPTHREAD ( 
  THREADID       NUMBER        NOT NULL, 
  FORUMID        NUMBER        NOT NULL, 
  ROOTCOMMENTID  NUMBER, 
  MODVALUE       NUMBER, 
  BONUSPOINTS    NUMBER, 
  CREATIONDATE   TIMESTAMP(6)  DEFAULT sysdate, 
  MODIFIEDDATE   TIMESTAMP(6)  DEFAULT sysdate, 
  CONSTRAINT RAPTHREAD_IDX
  PRIMARY KEY ( THREADID, FORUMID ) ) ;