CREATE TABLE ATTRIBUTE ( 
  ATTRID    NUMBER (8)    NOT NULL, 
  ATTRNAME  VARCHAR2 (50)  NOT NULL, 
  PRIMARY KEY ( ATTRID ) 
    USING INDEX 
     TABLESPACE SYSTEM PCTFREE 10
     STORAGE ( INITIAL 10K NEXT 10K PCTINCREASE 50 ))
   TABLESPACE SYSTEM
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
 STORAGE ( 
   INITIAL 10240
   NEXT 10240
   PCTINCREASE 50
   MINEXTENTS 1
   MAXEXTENTS 121
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

CREATE TABLE CATEGORYS ( 
  CATEGORYID  NUMBER (8)    NOT NULL, 
  CATTYPEID   NUMBER (8)    NOT NULL, 
  CATEGORY    VARCHAR2 (50)  NOT NULL, 
  CREATED     DATE          DEFAULT SYSDATE  NOT NULL, 
  CREATEDBY   NUMBER (8)    NOT NULL, 
  ACTIVE      NUMBER (1)    DEFAULT 0   NOT NULL, 
  ACTIVEBY    NUMBER (8), 
  DATEMOD     DATE)
   TABLESPACE SYSTEM
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
 STORAGE ( 
   INITIAL 10240
   NEXT 10240
   PCTINCREASE 50
   MINEXTENTS 1
   MAXEXTENTS 121
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

CREATE TABLE CATTYPE ( 
  CATTYPEID    NUMBER (8)    NOT NULL, 
  CATTYPENAME  VARCHAR2 (50)  NOT NULL, 
  CREATED      DATE          DEFAULT SYSDATE  NOT NULL, 
  CREATEDBY    NUMBER (8)    NOT NULL, 
  ACTIVE       NUMBER (1)    DEFAULT 0   NOT NULL, 
  ACTIVEBY     NUMBER (8), 
  DATEMOD      DATE)
   TABLESPACE SYSTEM
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
 STORAGE ( 
   INITIAL 10240
   NEXT 10240
   PCTINCREASE 50
   MINEXTENTS 1
   MAXEXTENTS 121
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

CREATE TABLE CONTACT ( 
  CONTACTID  NUMBER (10), 
  FIRSTNAME  VARCHAR2 (50), 
  LASTNAME   VARCHAR2 (50), 
  EMAIL      VARCHAR2 (50), 
  MESSAGE    LONG, 
  MAILDATE   DATE, 
  USERID     NUMBER (10), 
  ANSWER     NUMBER (10), 
  ACTIVE     NUMBER, 
  MESSAGE1   VARCHAR2 (2000))
   TABLESPACE SYSTEM
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
 STORAGE ( 
   INITIAL 159744
   NEXT 83968
   PCTINCREASE 50
   MINEXTENTS 1
   MAXEXTENTS 121
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

CREATE TABLE CONTACTA ( 
  CONTACTID  NUMBER (10), 
  FIRSTNAME  VARCHAR2 (50), 
  LASTNAME   VARCHAR2 (50), 
  EMAIL      VARCHAR2 (50), 
  MESSAGE    CLOB, 
  MAILDATE   DATE, 
  USERID     NUMBER (10), 
  ANSWER     NUMBER (10), 
  ACTIVE     NUMBER)
   TABLESPACE SYSTEM
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
 STORAGE ( 
   INITIAL 10240
   NEXT 10240
   PCTINCREASE 50
   MINEXTENTS 1
   MAXEXTENTS 121
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 


CREATE UNIQUE INDEX SYS_IL0000023837C00005$$ ON 
  CONTACTA() 
  TABLESPACE SYSTEM PCTFREE 10
  STORAGE(INITIAL 10240 NEXT 10240 PCTINCREASE 50 ) 
; 


CREATE TABLE CONTENT ( 
  CONTENTID    NUMBER (10)   NOT NULL, 
  CONTENTNAME  VARCHAR2 (50), 
  BODY         LONG, 
  USERID       NUMBER (10), 
  DATEMOD      DATE, 
  SIGNOFF      NUMBER (10), 
  ADMINID      NUMBER (10), 
  CATEGORYID   NUMBER (10), 
  SIGNDATE     DATE, 
  SYNOPSIS     VARCHAR2 (500), 
  RATING       NUMBER (3,2)  DEFAULT 0
     NOT NULL, 
  RATINGS      NUMBER (8)    DEFAULT 0
     NOT NULL, 
  REPLIES      NUMBER (8)    DEFAULT 0 NOT NULL, 
  PRIMARY KEY ( CONTENTID ) 
    USING INDEX 
     TABLESPACE SYSTEM PCTFREE 10
     STORAGE ( INITIAL 10K NEXT 24K PCTINCREASE 50 ))
   TABLESPACE SYSTEM
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
 STORAGE ( 
   INITIAL 4339712
   NEXT 2181120
   PCTINCREASE 50
   MINEXTENTS 1
   MAXEXTENTS 121
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

CREATE TABLE CONTENT2 ( 
  CONTENTID    NUMBER (8)    NOT NULL, 
  LANGUAGEID   NUMBER (8)    DEFAULT 3846   NOT NULL, 
  CATEGORYID   NUMBER (8)    NOT NULL, 
  USERID       NUMBER (8)    NOT NULL, 
  DATEMOD      DATE          DEFAULT SYSDATE  NOT NULL, 
  SIGNOFF      NUMBER (1)    DEFAULT 0   NOT NULL, 
  SIGNDATE     DATE, 
  ADMINID      NUMBER (8), 
  PRIV         NUMBER (1)    DEFAULT 0   NOT NULL, 
  CONTENTNAME  VARCHAR2 (50)  NOT NULL, 
  SYNOPSIS     VARCHAR2 (255), 
  BODY         CLOB, 
  RATING       NUMBER (3,2)  DEFAULT 0
     NOT NULL, 
  RATINGS      NUMBER (8)    DEFAULT 0
     NOT NULL, 
  REPLIES      NUMBER (8)    DEFAULT 0 NOT NULL)
   TABLESPACE SYSTEM
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
 STORAGE ( 
   INITIAL 10240
   NEXT 968704
   PCTINCREASE 50
   MINEXTENTS 1
   MAXEXTENTS 121
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 


CREATE UNIQUE INDEX SYS_IL0000023768C00012$$ ON 
  CONTENT2() 
  TABLESPACE SYSTEM PCTFREE 10
  STORAGE(INITIAL 10240 NEXT 10240 PCTINCREASE 50 ) 
; 


CREATE TABLE ELEMENT ( 
  ELEMENTID    NUMBER (8)    NOT NULL, 
  ELEMENTNAME  VARCHAR2 (100)  NOT NULL, 
  PRIMARY KEY ( ELEMENTID ) 
    USING INDEX 
     TABLESPACE SYSTEM PCTFREE 10
     STORAGE ( INITIAL 10K NEXT 10K PCTINCREASE 50 ))
   TABLESPACE SYSTEM
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
 STORAGE ( 
   INITIAL 10240
   NEXT 10240
   PCTINCREASE 50
   MINEXTENTS 1
   MAXEXTENTS 121
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

CREATE TABLE LANGUAGE ( 
  LANGUAGEID    NUMBER (8)    NOT NULL, 
  LANGUAGENAME  VARCHAR2 (50)  NOT NULL)
   TABLESPACE SYSTEM
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
 STORAGE ( 
   INITIAL 10240
   NEXT 10240
   PCTINCREASE 50
   MINEXTENTS 1
   MAXEXTENTS 121
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

CREATE TABLE MEMBATTR ( 
  MEMBATTRID  NUMBER (8)    NOT NULL, 
  MEMBERID    NUMBER (8)    NOT NULL, 
  ATTRID      NUMBER (8)    NOT NULL, 
  SEQ         NUMBER (2)    NOT NULL, 
  PRIV        NUMBER (1)    NOT NULL, 
  ATTRVALUE   VARCHAR2 (255), 
  REMARKS     VARCHAR2 (255), 
  PRIMARY KEY ( MEMBATTRID ) 
    USING INDEX 
     TABLESPACE SYSTEM PCTFREE 10
     STORAGE ( INITIAL 10K NEXT 10K PCTINCREASE 50 ))
   TABLESPACE SYSTEM
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
 STORAGE ( 
   INITIAL 10240
   NEXT 10240
   PCTINCREASE 50
   MINEXTENTS 1
   MAXEXTENTS 121
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

CREATE TABLE MEMBER ( 
  MEMBERID    NUMBER (8)    NOT NULL, 
  CREATEDATE  DATE          DEFAULT SYSDATE  NOT NULL, 
  DATEMOD     DATE          DEFAULT sysdate  NOT NULL, 
  FIRSTNAME   VARCHAR2 (50)  NOT NULL, 
  LASTNAME    VARCHAR2 (50)  NOT NULL, 
  PRIV        NUMBER (1)    DEFAULT 2  NOT NULL, 
  ACTIVE      NUMBER (1)    DEFAULT 1  NOT NULL, 
  PRIMARY KEY ( MEMBERID ) 
    USING INDEX 
     TABLESPACE SYSTEM PCTFREE 10
     STORAGE ( INITIAL 10K NEXT 10K PCTINCREASE 50 ))
   TABLESPACE SYSTEM
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
 STORAGE ( 
   INITIAL 10240
   NEXT 10240
   PCTINCREASE 50
   MINEXTENTS 1
   MAXEXTENTS 121
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

CREATE TABLE POSTS ( 
  POSTDATE     DATE, 
  POPDATE      VARCHAR2 (350), 
  AUTHOR       VARCHAR2 (350), 
  SUBJECT      VARCHAR2 (350), 
  SORTSUBJECT  VARCHAR2 (350), 
  HEADER       VARCHAR2 (2000), 
  ID           NUMBER (8), 
  BODY         LONG, 
  TESTDATE     VARCHAR2 (50))
   TABLESPACE USERS
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
 STORAGE ( 
   INITIAL 134666240
   NEXT 83894272
   PCTINCREASE 50
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 


CREATE INDEX POSTS_INDEX ON 
  POSTS(ID, SUBJECT) 
  TABLESPACE SYSTEM PCTFREE 10
  STORAGE(INITIAL 2912256 NEXT 1454080 PCTINCREASE 50 ) 
; 


CREATE TABLE RATING ( 
  RATINGID     NUMBER (8)    NOT NULL, 
  USERID       NUMBER (8)    NOT NULL, 
  CONTENTID    NUMBER (8)    NOT NULL, 
  DATECREATED  DATE          DEFAULT sysdate  NOT NULL, 
  LASTMOD      DATE          DEFAULT sysdate  NOT NULL, 
  RATINGVALUE  NUMBER (1)    NOT NULL, 
  PRIMARY KEY ( RATINGID ) 
    USING INDEX 
     TABLESPACE SYSTEM PCTFREE 10
     STORAGE ( INITIAL 10K NEXT 10K PCTINCREASE 50 ))
   TABLESPACE SYSTEM
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
 STORAGE ( 
   INITIAL 10240
   NEXT 10240
   PCTINCREASE 50
   MINEXTENTS 1
   MAXEXTENTS 121
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

ALTER TABLE RATING ADD  CONSTRAINT ONERATINGPERUSERPERARTICLE
 UNIQUE (USERID, CONTENTID)     USING INDEX 
     TABLESPACE SYSTEM PCTFREE 10
     STORAGE ( INITIAL 10K NEXT 10K PCTINCREASE 50 ) ;



ALTER TABLE RATING ADD CONSTRAINT 
RATINGBETWEEN1AND5 CHECK  (ratingvalue between 1 and 5 ) ;



CREATE TABLE REPLIES ( 
  COMMENTID    NUMBER (10), 
  CONTENTID    NUMBER (10), 
  USERID       VARCHAR2 (50), 
  MESSAGE      LONG, 
  DATEMOD      DATE, 
  GRRRS        NUMBER (5), 
  MESSAGENAME  VARCHAR2 (50))
   TABLESPACE SYSTEM
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
 STORAGE ( 
   INITIAL 841728
   NEXT 430080
   PCTINCREASE 50
   MINEXTENTS 1
   MAXEXTENTS 121
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

CREATE TABLE RESPONSE ( 
  CONRESID   NUMBER (11), 
  CONTACTID  NUMBER (11), 
  RESPONDER  NUMBER (11), 
  RESPONSE   CLOB, 
  MAILDATE   DATE, 
  ACTIVE     NUMBER (11), 
  RESPNDR    NUMBER (10), 
  RESPNS     NUMBER (10), 
  REPLY      CLOB)
   TABLESPACE SYSTEM
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
 STORAGE ( 
   INITIAL 67584
   NEXT 36864
   PCTINCREASE 50
   MINEXTENTS 1
   MAXEXTENTS 121
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 


CREATE UNIQUE INDEX SYS_IL0000023736C00004$$ ON 
  RESPONSE() 
  TABLESPACE SYSTEM PCTFREE 10
  STORAGE(INITIAL 10240 NEXT 10240 PCTINCREASE 50 ) 
; 

CREATE UNIQUE INDEX SYS_IL0000023736C00009$$ ON 
  RESPONSE() 
  TABLESPACE SYSTEM PCTFREE 10
  STORAGE(INITIAL 10240 NEXT 10240 PCTINCREASE 50 ) 
; 


CREATE TABLE SCHEME ( 
  SCHEMEID      NUMBER (8)    NOT NULL, 
  SCHEMEUSERID  NUMBER (8)    NOT NULL, 
  SCHEMENAME    VARCHAR2 (50)  NOT NULL, 
  PRIV          NUMBER (1)    DEFAULT 0  NOT NULL, 
  PRIMARY KEY ( SCHEMEID ) 
    USING INDEX 
     TABLESPACE SYSTEM PCTFREE 10
     STORAGE ( INITIAL 10K NEXT 10K PCTINCREASE 50 ))
   TABLESPACE SYSTEM
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
 STORAGE ( 
   INITIAL 10240
   NEXT 10240
   PCTINCREASE 50
   MINEXTENTS 1
   MAXEXTENTS 121
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

CREATE TABLE SCHEMEELEMENT ( 
  SCHEMEELEMID     NUMBER (8)    NOT NULL, 
  SCHEMEID         NUMBER (8)    NOT NULL, 
  ELEMENTID        NUMBER (8)    NOT NULL, 
  SCHEMEELEMVALUE  VARCHAR2 (100)  NOT NULL, 
  PRIMARY KEY ( SCHEMEELEMID ) 
    USING INDEX 
     TABLESPACE SYSTEM PCTFREE 10
     STORAGE ( INITIAL 10K NEXT 10K PCTINCREASE 50 ))
   TABLESPACE SYSTEM
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
 STORAGE ( 
   INITIAL 10240
   NEXT 10240
   PCTINCREASE 50
   MINEXTENTS 1
   MAXEXTENTS 121
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

CREATE TABLE SEARCHINDEX ( 
  SINDEX   NUMBER (10), 
  USERID   NUMBER (10), 
  DATEMOD  DATE)
   TABLESPACE SYSTEM
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
 STORAGE ( 
   INITIAL 10240
   NEXT 10240
   PCTINCREASE 50
   MINEXTENTS 1
   MAXEXTENTS 121
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

CREATE TABLE THETIPS ( 
  TIP_ID     NUMBER (8)    NOT NULL, 
  TIP_DATE   DATE          NOT NULL, 
  AUTHOR_ID  NUMBER (8), 
  TIP_TYPE   VARCHAR2 (200), 
  AUTHOR     VARCHAR2 (50), 
  BODY       LONG, 
  PRIMARY KEY ( TIP_ID ) 
    USING INDEX 
     TABLESPACE SYSTEM PCTFREE 10
     STORAGE ( INITIAL 10K NEXT 10K PCTINCREASE 50 ))
   TABLESPACE SYSTEM
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
 STORAGE ( 
   INITIAL 10240
   NEXT 10240
   PCTINCREASE 50
   MINEXTENTS 1
   MAXEXTENTS 121
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

CREATE TABLE USERS ( 
  USERID      NUMBER (8)    NOT NULL, 
  WHO         VARCHAR2 (50)  NOT NULL, 
  PASS        VARCHAR2 (50)  NOT NULL, 
  CREATEDATE  DATE          DEFAULT SYSDATE  NOT NULL, 
  DATEMOD     DATE          DEFAULT SYSDATE  NOT NULL, 
  LASTLOGIN   DATE          DEFAULT SYSDATE  NOT NULL, 
  LEAVEOUT    NUMBER (1)    DEFAULT 0   NOT NULL, 
  NOTIFY      NUMBER (1)    DEFAULT 1   NOT NULL, 
  ADMIN       NUMBER (1)    DEFAULT 0   NOT NULL, 
  ACTIVE      NUMBER (1)    DEFAULT 1   NOT NULL, 
  GOD         NUMBER (1)    DEFAULT 0   NOT NULL, 
  THELIST     NUMBER (1)    DEFAULT 0   NOT NULL, 
  USERPRIV    NUMBER (1)    DEFAULT 1   NOT NULL, 
  PRIV        NUMBER (1)    DEFAULT 3   NOT NULL, 
  FIRSTNAME   VARCHAR2 (50), 
  LASTNAME    VARCHAR2 (50), 
  EMAIL       VARCHAR2 (50), 
  MEMBERID    NUMBER (8), 
  COOKIE      VARCHAR2 (50), 
  PRIMARY KEY ( USERID ) 
    USING INDEX 
     TABLESPACE SYSTEM PCTFREE 10
     STORAGE ( INITIAL 66K NEXT 36K PCTINCREASE 50 ))
   TABLESPACE SYSTEM
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
 STORAGE ( 
   INITIAL 237568
   NEXT 126976
   PCTINCREASE 50
   MINEXTENTS 1
   MAXEXTENTS 121
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

ALTER TABLE MEMBATTR ADD 
 FOREIGN KEY (MEMBERID) 
  REFERENCES EVOLTCLONE.MEMBER (MEMBERID) ;

ALTER TABLE MEMBATTR ADD 
 FOREIGN KEY (ATTRID) 
  REFERENCES EVOLTCLONE.ATTRIBUTE (ATTRID) ;

ALTER TABLE RATING ADD 
 FOREIGN KEY (USERID) 
  REFERENCES EVOLTCLONE.USERS (USERID) ;

ALTER TABLE RATING ADD 
 FOREIGN KEY (CONTENTID) 
  REFERENCES EVOLTCLONE.CONTENT (CONTENTID) ;

ALTER TABLE SCHEME ADD 
 FOREIGN KEY (SCHEMEUSERID) 
  REFERENCES EVOLTCLONE.USERS (USERID) ;

ALTER TABLE SCHEMEELEMENT ADD 
 FOREIGN KEY (SCHEMEID) 
  REFERENCES EVOLTCLONE.SCHEME (SCHEMEID) ;

ALTER TABLE SCHEMEELEMENT ADD 
 FOREIGN KEY (ELEMENTID) 
  REFERENCES EVOLTCLONE.ELEMENT (ELEMENTID) ;