rapforums-developer

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

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

Added Files:
	rapforumsMYSQLTables.sql 
Log Message:
no message

--- NEW FILE: rapforumsMYSQLTables.sql ---
--The default table type in MySQL is MyISAM. If you are trying to use a table type that is not incompiled or activated, MySQL will instead create a table of type MyISAM.
--Advantages of not transaction-safe tables (NTST): 
--Much faster as there is no transcation overhead. 
--Will use less disk space as there is no overhead of transactions. 
--Will use less memory to do updates. 

CREATE DATABASE IF NOT EXISTS portaldb;
USE portaldb

DROP TABLE RAPCATEGORY CASCADE CONSTRAINTS ; 

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

DROP TABLE RAPCOMMENT CASCADE CONSTRAINTS ; 

CREATE TABLE RAPCOMMENT ( 
  COMMENTID        INTEGER        NOT NULL, 
  PARENTCOMMENTID  INTEGER, 
  THREADID         INTEGER, 
  FORUMID          INTEGER, 
  USERID           VARCHAR (255), 
  SUBJECT          VARCHAR (255), 
  BODY             VARCHAR (255), 
  MODVALUE         DECIMAL , 
  BONUSPOINTS      INTEGER, 
  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       INTEGER        NOT NULL, 
  NAME          VARCHAR (255), 
  DESCRIPTION   VARCHAR (255), 
  CREATIONDATE  TIMESTAMP(6), --  DEFAULT sysdate, 
  MODIFIEDDATE  TIMESTAMP(6), --  DEFAULT sysdate, 
  CATEGORYID    INTEGER        NOT NULL, 
  CONSTRAINT RAPFORUM_IDX
  PRIMARY KEY ( FORUMID ) ) ; 

DROP TABLE RAPID CASCADE CONSTRAINTS ; 

CREATE TABLE RAPID ( 
  IDTYPE  INTEGER, 
  ID      INTEGER ) ; 

DROP TABLE RAPTHREAD CASCADE CONSTRAINTS ; 

CREATE TABLE RAPTHREAD ( 
  THREADID       INTEGER        NOT NULL, 
  FORUMID        INTEGER        NOT NULL, 
  ROOTCOMMENTID  INTEGER, 
  MODVALUE       INTEGER, 
  BONUSPOINTS    INTEGER, -- default 0
  CREATIONDATE   TIMESTAMP(6), --  DEFAULT sysdate, 
  MODIFIEDDATE   TIMESTAMP(6), --  DEFAULT sysdate, 
  CONSTRAINT RAPTHREAD_IDX
  PRIMARY KEY ( THREADID, FORUMID ) ) ; 
  
insert into rapCategory(CATEGORYID,name,description, creationDate, modifiedDate, lft, rgt)  values (1,'General', 'This is a tempory category for Rap Forums','2003-09-24 08:00:00','2003-09-24 08:00:00', 1, 2);
insert into rapForum(forumID,name,description,creationDate, modifiedDate, categoryID) values(1,'New Forums Channel', 'This is a tempory Forum for information about Rap Forums', '2003-09-24 08:00:00', '2003-09-24 08:00:00', 1);
insert into rapID(idType, id) values (1, 1);
insert into rapID(idType, id) values (4, 1);