oracle_RogueStruct.sql.txt at ProNuke. Postnuke To Oracle

DROP TABLE NUKE_AUTOLINKS CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_AUTOLINKS ( 
  LID       NUMBER (11)   NOT NULL, 
  KEYWORD   VARCHAR2 (100), 
  TITLE     VARCHAR2 (100), 
  URL       VARCHAR2 (200), 
  COMMENT_  VARCHAR2 (200), 
  CONSTRAINT PK_NUKE_AUTOLINKS
  PRIMARY KEY ( LID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 524288 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 


CREATE UNIQUE INDEX KEYWORD ON 
  "POST_NUKE".NUKE_AUTOLINKS(KEYWORD) 
  TABLESPACE USERS PCTFREE 10  STORAGE(INITIAL 524288 ) 
; 


DROP TABLE NUKE_AUTONEWS CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_AUTONEWS ( 
  ANID       NUMBER (11)   NOT NULL, 
  CATID      NUMBER (11)   DEFAULT 0, 
  AID        VARCHAR2 (30), 
  TITLE      VARCHAR2 (80), 
  TIME       VARCHAR2 (19), 
  HOMETEXT   VARCHAR2 (4000), 
  BODYTEXT   VARCHAR2 (4000), 
  TOPIC      NUMBER (10)   DEFAULT 1, 
  INFORMANT  VARCHAR2 (20), 
  NOTES      VARCHAR2 (4000), 
  IHOME      NUMBER (10)   DEFAULT 0, 
  ALANGUAGE  VARCHAR2 (30), 
  WITHCOMM   NUMBER (10)   DEFAULT 0, 
  CONSTRAINT PK_NUKE_AUTONEWS
  PRIMARY KEY ( ANID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 524288 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_BANNER CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_BANNER ( 
  BID       NUMBER (11)   NOT NULL, 
  CID       NUMBER (11)   DEFAULT 0, 
  IMPTOTAL  NUMBER (11)   DEFAULT 0, 
  IMPMADE   NUMBER (11)   DEFAULT 0, 
  CLICKS    NUMBER (11)   DEFAULT 0, 
  IMAGEURL  VARCHAR2 (255), 
  CLICKURL  VARCHAR2 (255), 
  DATE_     DATE, 
  CONSTRAINT PK_NUKE_BANNER
  PRIMARY KEY ( BID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_BANNERCLIENT CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_BANNERCLIENT ( 
  CID        NUMBER (11)   NOT NULL, 
  NAME       VARCHAR2 (60), 
  CONTACT    VARCHAR2 (60), 
  EMAIL      VARCHAR2 (60), 
  LOGIN      VARCHAR2 (10), 
  PASSWD     VARCHAR2 (10), 
  EXTRAINFO  VARCHAR2 (4000), 
  CONSTRAINT PK_NUKE_BANNERCLIENT
  PRIMARY KEY ( CID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_BANNERFINISH CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_BANNERFINISH ( 
  BID          NUMBER (11)   NOT NULL, 
  CID          NUMBER (11)   DEFAULT 0, 
  IMPRESSIONS  NUMBER (11)   DEFAULT 0, 
  CLICKS       NUMBER (11)   DEFAULT 0, 
  DATESTART    DATE, 
  DATEEND      DATE, 
  CONSTRAINT PK_NUKE_BANNERFINISH
  PRIMARY KEY ( BID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_BLOCKS CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_BLOCKS ( 
  BID          NUMBER (10)   NOT NULL, 
  BKEY         VARCHAR2 (255), 
  TITLE        VARCHAR2 (255), 
  CONTENT      VARCHAR2 (4000), 
  URL          VARCHAR2 (255), 
  POSITION     CHAR (1)      DEFAULT 'l', 
  WEIGHT       FLOAT (24)    DEFAULT 0.0, 
  ACTIVE       NUMBER (3)    DEFAULT 1, 
  REFRESH      NUMBER (10)   DEFAULT 0, 
  LAST_UPDATE  DATE          DEFAULT SYSDATE, 
  BLANGUAGE    VARCHAR2 (30), 
  CONSTRAINT PK_NUKE_BLOCKS
  PRIMARY KEY ( BID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_BLOCKS_BUTTONS CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_BLOCKS_BUTTONS ( 
  ID      NUMBER (10)   NOT NULL, 
  BID     NUMBER (10)   DEFAULT 0, 
  TITLE   VARCHAR2 (255), 
  URL     VARCHAR2 (255), 
  IMAGES  CLOB, 
  CONSTRAINT PK_NUKE_BLOCKS_BUTTONS
  PRIMARY KEY ( ID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_COMMENTS CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_COMMENTS ( 
  TID        NUMBER (11)   NOT NULL, 
  PID        NUMBER (11)   DEFAULT 0, 
  SID        NUMBER (11)   DEFAULT 0, 
  DATE_      DATE, 
  NAME       VARCHAR2 (60), 
  EMAIL      VARCHAR2 (60), 
  URL        VARCHAR2 (60), 
  HOST_NAME  VARCHAR2 (60), 
  SUBJECT    VARCHAR2 (85), 
  COMMENT_   VARCHAR2 (4000), 
  SCORE      NUMBER (4)    DEFAULT 0, 
  REASON     NUMBER (4)    DEFAULT 0, 
  CONSTRAINT PK_NUKE_COMMENTS
  PRIMARY KEY ( TID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_COUNTER CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_COUNTER ( 
  TYPE_  VARCHAR2 (80), 
  VAR    VARCHAR2 (80), 
  COUNT  NUMBER (10)   DEFAULT 0)
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_DOWNLOADS_CATEGORIES CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_DOWNLOADS_CATEGORIES ( 
  CID           NUMBER (11)   NOT NULL, 
  TITLE         VARCHAR2 (50), 
  CDESCRIPTION  VARCHAR2 (4000), 
  CONSTRAINT PK_NUKE_DOWNLOADS_CATEGORIES
  PRIMARY KEY ( CID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_DOWNLOADS_DOWNLOADS CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_DOWNLOADS_DOWNLOADS ( 
  LID                    NUMBER (11)   NOT NULL, 
  CID                    NUMBER (11)   DEFAULT 0, 
  SID                    NUMBER (11)   DEFAULT 0, 
  TITLE                  VARCHAR2 (100), 
  URL                    VARCHAR2 (100), 
  DESCRIPTION            VARCHAR2 (4000), 
  DATE_                  DATE, 
  NAME                   VARCHAR2 (100), 
  EMAIL                  VARCHAR2 (100), 
  HITS                   NUMBER (11)   DEFAULT 0, 
  SUBMITTER              VARCHAR2 (60), 
  DOWNLOADRATINGSUMMARY  FLOAT         DEFAULT 0.0000, 
  TOTALVOTES             NUMBER (11)   DEFAULT 0, 
  TOTALCOMMENTS          NUMBER (11)   DEFAULT 0, 
  FILESIZE               NUMBER (11)   DEFAULT 0, 
  VERSION                VARCHAR2 (10), 
  HOMEPAGE               VARCHAR2 (200), 
  CONSTRAINT PK_NUKE_DOWNLOADS_DOWNLOADS
  PRIMARY KEY ( LID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_DOWNLOADS_EDITORIALS CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_DOWNLOADS_EDITORIALS ( 
  DOWNLOADID          NUMBER (11)   DEFAULT 0 NOT NULL, 
  ADMINID             VARCHAR2 (60), 
  EDITORIALTIMESTAMP  DATE          DEFAULT SYSDATE, 
  EDITORIALTEXT       VARCHAR2 (4000), 
  EDITORIALTITLE      VARCHAR2 (100), 
  CONSTRAINT PK_NUKE_DOWNLOADS_EDITORIALS
  PRIMARY KEY ( DOWNLOADID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_DOWNLOADS_MODREQUEST CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_DOWNLOADS_MODREQUEST ( 
  REQUESTID        NUMBER (11)   NOT NULL, 
  LID              NUMBER (11)   DEFAULT 0, 
  CID              NUMBER (11)   DEFAULT 0, 
  SID              NUMBER (11)   DEFAULT 0, 
  TITLE            VARCHAR2 (100), 
  URL              VARCHAR2 (100), 
  DESCRIPTION      VARCHAR2 (4000), 
  MODIFYSUBMITTER  VARCHAR2 (60), 
  BROKENDOWNLOAD   NUMBER (10)   DEFAULT 0, 
  NAME             VARCHAR2 (100), 
  EMAIL            VARCHAR2 (100), 
  FILESIZE         NUMBER (11)   DEFAULT 0, 
  VERSION          VARCHAR2 (10), 
  HOMEPAGE         VARCHAR2 (200), 
  CONSTRAINT PK_NUKE_DOWNLOADS_MODREQUEST
  PRIMARY KEY ( REQUESTID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_DOWNLOADS_NEWDOWNLOAD CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_DOWNLOADS_NEWDOWNLOAD ( 
  LID          NUMBER (11)   NOT NULL, 
  CID          NUMBER (11)   DEFAULT 0, 
  SID          NUMBER (11)   DEFAULT 0, 
  TITLE        VARCHAR2 (100), 
  URL          VARCHAR2 (100), 
  DESCRIPTION  VARCHAR2 (4000), 
  NAME         VARCHAR2 (100), 
  EMAIL        VARCHAR2 (100), 
  SUBMITTER    VARCHAR2 (60), 
  FILESIZE     NUMBER (11)   DEFAULT 0, 
  VERSION      VARCHAR2 (10), 
  HOMEPAGE     VARCHAR2 (200), 
  CONSTRAINT PK_NUKE_DOWNLOADS_NEWDOWNLOAD
  PRIMARY KEY ( LID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_DOWNLOADS_SUBCATEGORIES CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_DOWNLOADS_SUBCATEGORIES ( 
  SID    NUMBER (11)   NOT NULL, 
  CID    NUMBER (11)   DEFAULT 0, 
  TITLE  VARCHAR2 (50), 
  CONSTRAINT PK_NUKE_DOWNLOADS_SUBCATEGORIE
  PRIMARY KEY ( SID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_DOWNLOADS_VOTEDATA CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_DOWNLOADS_VOTEDATA ( 
  RATINGDBID       NUMBER (11)   NOT NULL, 
  RATINGLID        NUMBER (11)   DEFAULT 0, 
  RATINGUSER       VARCHAR2 (60), 
  RATING           NUMBER (11)   DEFAULT 0, 
  RATINGHOSTNAME   VARCHAR2 (60), 
  RATINGCOMMENTS   VARCHAR2 (4000), 
  RATINGTIMESTAMP  DATE          DEFAULT SYSDATE, 
  CONSTRAINT PK_NUKE_DOWNLOADS_VOTEDATA
  PRIMARY KEY ( RATINGDBID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_EPHEM CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_EPHEM ( 
  EID        NUMBER (11)   NOT NULL, 
  DID        NUMBER (10)   DEFAULT 0, 
  MID        NUMBER (10)   DEFAULT 0, 
  YID        NUMBER (10)   DEFAULT 0, 
  CONTENT    VARCHAR2 (4000), 
  ELANGUAGE  VARCHAR2 (30), 
  CONSTRAINT PK_NUKE_EPHEM
  PRIMARY KEY ( EID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_FAQANSWER CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_FAQANSWER ( 
  ID           NUMBER (4)    NOT NULL, 
  ID_CAT       NUMBER (4), 
  QUESTION     VARCHAR2 (255), 
  ANSWER       VARCHAR2 (4000), 
  SUBMITTEDBY  VARCHAR2 (250), 
  CONSTRAINT PK_NUKE_FAQANSWER
  PRIMARY KEY ( ID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_FAQCATEGORIES CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_FAQCATEGORIES ( 
  ID_CAT      NUMBER (3)    NOT NULL, 
  CATEGORIES  VARCHAR2 (255), 
  FLANGUAGE   VARCHAR2 (30), 
  PARENT_ID   NUMBER (3)    DEFAULT 0, 
  CONSTRAINT PK_NUKE_FAQCATEGORIES
  PRIMARY KEY ( ID_CAT ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_GLOSSARY CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_GLOSSARY ( 
  GID          NUMBER (10)   NOT NULL, 
  GTERM        VARCHAR2 (255), 
  GDEFINITION  VARCHAR2 (255), 
  CONSTRAINT PK_NUKE_GLOSSARY
  PRIMARY KEY ( GID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_GROUPS CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_GROUPS ( 
  GID   NUMBER (10)   NOT NULL, 
  NAME  VARCHAR2 (255), 
  CONSTRAINT PK_NUKE_GROUPS
  PRIMARY KEY ( GID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_GROUP_MEMBERSHIP CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_GROUP_MEMBERSHIP ( 
  GID   NUMBER (10)   DEFAULT 0, 
  UID_  NUMBER (11)   DEFAULT 0)
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_GROUP_PERMS CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_GROUP_PERMS ( 
  PID        NUMBER (11)   NOT NULL, 
  GID        NUMBER (10)   DEFAULT 0, 
  SEQUENCE   NUMBER (10)   DEFAULT 0, 
  REALM      NUMBER (10)   DEFAULT 0, 
  COMPONENT  VARCHAR2 (255), 
  INSTANCE   VARCHAR2 (255), 
  LEVEL_     NUMBER (10)   DEFAULT 0, 
  BOND       NUMBER (10)   DEFAULT 0, 
  CONSTRAINT PK_NUKE_GROUP_PERMS
  PRIMARY KEY ( PID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_GUESTBOOK CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_GUESTBOOK ( 
  ID_MSG    NUMBER (11)   NOT NULL, 
  NAME      VARCHAR2 (255), 
  EMAIL     VARCHAR2 (255), 
  IP        VARCHAR2 (255), 
  MESSAGE   VARCHAR2 (4000), 
  ICQ       NUMBER (11), 
  HOMEPAGE  VARCHAR2 (255), 
  BDATE     DATE, 
  MEMBERS   NUMBER (10)   DEFAULT 0, 
  PRIVATE_  NUMBER (10)   DEFAULT 0, 
  CONSTRAINT PK_NUKE_GUESTBOOK
  PRIMARY KEY ( ID_MSG ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_HEADLINES CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_HEADLINES ( 
  ID         NUMBER (10)   NOT NULL, 
  SITENAME   VARCHAR2 (255), 
  RSSUSER    VARCHAR2 (10), 
  RSSPASSWD  VARCHAR2 (10), 
  USE_PROXY  NUMBER (3)    DEFAULT 0, 
  RSSURL     VARCHAR2 (255), 
  MAXROWS    NUMBER (3)    DEFAULT 10, 
  SITEURL    VARCHAR2 (255), 
  OPTIONS    VARCHAR2 (20), 
  CONSTRAINT PK_NUKE_HEADLINES
  PRIMARY KEY ( ID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_INC_CATS CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_INC_CATS ( 
  SECID      NUMBER (11)   NOT NULL, 
  PARENT_ID  NUMBER (11), 
  SECNAME    VARCHAR2 (40), 
  CONSTRAINT PK_NUKE_INC_CATS
  PRIMARY KEY ( SECID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_INC_PAGES CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_INC_PAGES ( 
  ARTID        NUMBER (11)   NOT NULL, 
  SECID        NUMBER (11)   DEFAULT 0, 
  TITLE        VARCHAR2 (100), 
  DESCRIPTION  VARCHAR2 (4000), 
  DATE_        DATE, 
  URL          VARCHAR2 (100), 
  COUNTER      NUMBER (11)   DEFAULT 0, 
  METHOD       VARCHAR2 (100)  DEFAULT 'I', 
  CONSTRAINT PK_NUKE_INC_PAGES
  PRIMARY KEY ( ARTID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

ALTER TABLE NUKE_INC_PAGES ADD CONSTRAINT 
CK_METHOD CHECK  ( method
 in  ( 'I','P','F' )   ) ;



DROP TABLE NUKE_LANGUAGES_CONSTANT CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_LANGUAGES_CONSTANT ( 
  CONSTANT_  VARCHAR2 (32)  NOT NULL, 
  FILE_      VARCHAR2 (64)  NOT NULL, 
  CONSTRAINT PK_NUKE_LANGUAGES_CONSTANT
  PRIMARY KEY ( CONSTANT_ ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_LANGUAGES_FILE CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_LANGUAGES_FILE ( 
  TARGET  VARCHAR2 (64)  NOT NULL, 
  SOURCE  VARCHAR2 (64)  NOT NULL, 
  CONSTRAINT PK_NUKE_LANGUAGES_FILE
  PRIMARY KEY ( TARGET, SOURCE ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 


CREATE UNIQUE INDEX SOURCE ON 
  "POST_NUKE".NUKE_LANGUAGES_FILE(SOURCE) 
  TABLESPACE USERS PCTFREE 10  STORAGE(INITIAL 65536 ) 
; 


DROP TABLE NUKE_LANGUAGES_TRANSLATION CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_LANGUAGES_TRANSLATION ( 
  LANGUAGE     VARCHAR2 (32)  NOT NULL, 
  CONSTANT_    VARCHAR2 (32)  NOT NULL, 
  TRANSLATION  VARCHAR2 (4000), 
  LEVEL_       NUMBER (4)    DEFAULT 0, 
  CONSTRAINT PK_NUKE_LANGUAGES_TRANSLATION
  PRIMARY KEY ( CONSTANT_, LANGUAGE ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_LINKS_CATEGORIES CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_LINKS_CATEGORIES ( 
  CAT_ID        NUMBER (11)   NOT NULL, 
  PARENT_ID     NUMBER (11), 
  TITLE         VARCHAR2 (50), 
  CDESCRIPTION  VARCHAR2 (4000), 
  CONSTRAINT PK_NUKE_LINKS_CATEGORIES
  PRIMARY KEY ( CAT_ID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_LINKS_EDITORIALS CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_LINKS_EDITORIALS ( 
  LINKID              NUMBER (11)   DEFAULT 0 NOT NULL, 
  ADMINID             VARCHAR2 (60), 
  EDITORIALTIMESTAMP  DATE          DEFAULT SYSDATE, 
  EDITORIALTEXT       VARCHAR2 (4000), 
  EDITORIALTITLE      VARCHAR2 (100), 
  CONSTRAINT PK_NUKE_LINKS_EDITORIALS
  PRIMARY KEY ( LINKID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_LINKS_LINKS CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_LINKS_LINKS ( 
  LID                NUMBER (11)   NOT NULL, 
  CAT_ID             NUMBER (11)   DEFAULT 0, 
  TITLE              VARCHAR2 (100), 
  URL                VARCHAR2 (100), 
  DESCRIPTION        VARCHAR2 (2000), 
  DATE_              DATE, 
  NAME               VARCHAR2 (100), 
  EMAIL              VARCHAR2 (100), 
  HITS               NUMBER (11)   DEFAULT 0, 
  SUBMITTER          VARCHAR2 (60), 
  LINKRATINGSUMMARY  FLOAT         DEFAULT 0.0000, 
  TOTALVOTES         NUMBER (11)   DEFAULT 0, 
  TOTALCOMMENTS      NUMBER (11)   DEFAULT 0, 
  CONSTRAINT PK_NUKE_LINKS_LINKS
  PRIMARY KEY ( LID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_LINKS_MODREQUEST CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_LINKS_MODREQUEST ( 
  REQUESTID        NUMBER (11)   NOT NULL, 
  LID              NUMBER (11)   DEFAULT 0, 
  CAT_ID           NUMBER (11)   DEFAULT 0, 
  SID              NUMBER (11)   DEFAULT 0, 
  TITLE            VARCHAR2 (100), 
  URL              VARCHAR2 (100), 
  DESCRIPTION      VARCHAR2 (2000), 
  MODIFYSUBMITTER  VARCHAR2 (60), 
  BROKENLINK       NUMBER (10)   DEFAULT 0, 
  CONSTRAINT PK_NUKE_LINKS_MODREQUEST
  PRIMARY KEY ( REQUESTID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_LINKS_NEWLINK CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_LINKS_NEWLINK ( 
  LID          NUMBER (11)   NOT NULL, 
  CAT_ID       NUMBER (11)   DEFAULT 0, 
  TITLE        VARCHAR2 (100), 
  URL          VARCHAR2 (100), 
  DESCRIPTION  VARCHAR2 (2000), 
  NAME         VARCHAR2 (100), 
  EMAIL        VARCHAR2 (100), 
  SUBMITTER    VARCHAR2 (60), 
  CONSTRAINT PK_NUKE_LINKS_NEWLINK
  PRIMARY KEY ( LID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_LINKS_VOTEDATA CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_LINKS_VOTEDATA ( 
  RATINGDBID       NUMBER (11)   NOT NULL, 
  RATINGLID        NUMBER (11)   DEFAULT 0, 
  RATINGUSER       VARCHAR2 (60), 
  RATING           NUMBER (11)   DEFAULT 0, 
  RATINGHOSTNAME   VARCHAR2 (60), 
  RATINGCOMMENTS   VARCHAR2 (4000), 
  RATINGTIMESTAMP  DATE          DEFAULT SYSDATE, 
  CONSTRAINT PK_NUKE_LINKS_VOTEDATA
  PRIMARY KEY ( RATINGDBID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_LISTWEATHER CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_LISTWEATHER ( 
  WID      NUMBER (10)   NOT NULL, 
  COUNTRY  VARCHAR2 (100), 
  CITY     VARCHAR2 (100), 
  REGION   VARCHAR2 (100), 
  SUBDIV   VARCHAR2 (100), 
  CODE     VARCHAR2 (4000), 
  CONSTRAINT PK_NUKE_LISTWEATHER
  PRIMARY KEY ( WID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_MESSAGE CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_MESSAGE ( 
  MID        NUMBER (11)   NOT NULL, 
  TITLE      VARCHAR2 (100), 
  CONTENT    VARCHAR2 (4000), 
  DATE_      VARCHAR2 (14), 
  EXPIRE     NUMBER (10)   DEFAULT 0, 
  ACTIVE     NUMBER (10)   DEFAULT 1, 
  VIEW_      NUMBER (10)   DEFAULT 1, 
  MLANGUAGE  VARCHAR2 (30), 
  CONSTRAINT PK_NUKE_MESSAGE
  PRIMARY KEY ( MID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_NICSERVER CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_NICSERVER ( 
  IDNS     NUMBER (10)   NOT NULL, 
  NSERVER  VARCHAR2 (100), 
  NSEXT    VARCHAR2 (20), 
  NSERROR  VARCHAR2 (100)  DEFAULT 'No match', 
  CONSTRAINT PK_NUKE_NICSERVER
  PRIMARY KEY ( IDNS ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_POLLCOMMENTS CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_POLLCOMMENTS ( 
  TID        NUMBER (11)   NOT NULL, 
  PID        NUMBER (11)   DEFAULT 0, 
  POLLID     NUMBER (11)   DEFAULT 0, 
  DATE_      DATE, 
  NAME       VARCHAR2 (60), 
  EMAIL      VARCHAR2 (60), 
  URL        VARCHAR2 (60), 
  HOST_NAME  VARCHAR2 (60), 
  SUBJECT    VARCHAR2 (60), 
  COMMENT_   LONG, 
  SCORE      NUMBER (4)    DEFAULT 0, 
  REASON     NUMBER (4)    DEFAULT 0, 
  CONSTRAINT PK_NUKE_POLLCOMMENTS
  PRIMARY KEY ( TID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_POLL_CHECK CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_POLL_CHECK ( 
  IP    VARCHAR2 (20), 
  TIME  VARCHAR2 (14))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_POLL_DATA CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_POLL_DATA ( 
  POLLID       NUMBER (11)   DEFAULT 0, 
  OPTIONTEXT   CHAR (50), 
  OPTIONCOUNT  NUMBER (11)   DEFAULT 0, 
  VOTEID       NUMBER (11)   DEFAULT 0)
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_POLL_DESC CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_POLL_DESC ( 
  POLLID     NUMBER (11)   NOT NULL, 
  POLLTITLE  VARCHAR2 (100), 
  TIMESTAMP  NUMBER (11)   DEFAULT 0, 
  VOTERS     NUMBER (9)    DEFAULT 0, 
  PLANGUAGE  VARCHAR2 (30), 
  CONSTRAINT PK_NUKE_POLL_DESC
  PRIMARY KEY ( POLLID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_POSTBOARD_ACCESS CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_POSTBOARD_ACCESS ( 
  FORUM_ID  NUMBER (10)   DEFAULT 0 NOT NULL, 
  USER_ID   NUMBER (10)   DEFAULT 0 NOT NULL, 
  CONSTRAINT PK_NUKE_POSTBOARD_ACCESS
  PRIMARY KEY ( FORUM_ID, USER_ID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_POSTBOARD_CATEGORIES CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_POSTBOARD_CATEGORIES ( 
  CAT_ID     NUMBER (10)   NOT NULL, 
  CAT_TITLE  VARCHAR2 (100), 
  CAT_ORDER  VARCHAR2 (10), 
  CONSTRAINT PK_NUKE_POSTBOARD_CATEGORIES
  PRIMARY KEY ( CAT_ID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_POSTBOARD_FORUMS CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_POSTBOARD_FORUMS ( 
  FORUM_ID            NUMBER (10)   NOT NULL, 
  FORUM_NAME          VARCHAR2 (150), 
  FORUM_DESC          VARCHAR2 (2000), 
  FORUM_READACCESS    VARCHAR2 (100)  DEFAULT 'Anonymous', 
  FORUM_TOPICS        NUMBER (10)   DEFAULT 0, 
  FORUM_POSTS         NUMBER (10)   DEFAULT 0, 
  FORUM_LAST_POST_ID  NUMBER (10)   DEFAULT 0, 
  FORUM_CAT_ID        NUMBER (8), 
  FORUM_WRITEACCESS   VARCHAR2 (100)  DEFAULT 'Anonymous', 
  FORUM_ORDER         NUMBER (8), 
  CONSTRAINT PK_NUKE_POSTBOARD_FORUMS
  PRIMARY KEY ( FORUM_ID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

ALTER TABLE NUKE_POSTBOARD_FORUMS ADD CONSTRAINT 
CK_FORUM_READACCESS CHECK  ( forum_readaccess in  ( 'Anonymous','Registered','Member','Moderator'
 )   ) ;

ALTER TABLE NUKE_POSTBOARD_FORUMS ADD CONSTRAINT 
CK_FORUM_WRITEACCESS CHECK  ( forum_writeaccess in  ( 'Anonymous','Registered','Member','Moderator'
 )   ) ;




CREATE INDEX FORUM_LAST_POST_ID ON 
  "POST_NUKE".NUKE_POSTBOARD_FORUMS(FORUM_LAST_POST_ID) 
  TABLESPACE USERS PCTFREE 10  STORAGE(INITIAL 65536 ) 
; 


DROP TABLE NUKE_POSTBOARD_FORUMSUBSCRIBE CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_POSTBOARD_FORUMSUBSCRIBE ( 
  UID_      NUMBER (11)   DEFAULT 0, 
  FORUM_ID  NUMBER (11)   DEFAULT 0, 
  METHOD    CHAR (1)      DEFAULT 'm')
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_POSTBOARD_LEVELS CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_POSTBOARD_LEVELS ( 
  LEVEL_ID        NUMBER (7)    NOT NULL, 
  LEVEL_TITLE     VARCHAR2 (50), 
  LEVEL_MINPOSTS  NUMBER (9)    DEFAULT 0, 
  LEVEL_MAXPOSTS  NUMBER (9)    DEFAULT 0, 
  LEVEL_SPECIAL   NUMBER (3)    DEFAULT 0, 
  LEVEL_IMAGE     VARCHAR2 (255), 
  CONSTRAINT PK_NUKE_POSTBOARD_LEVELS
  PRIMARY KEY ( LEVEL_ID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 


CREATE INDEX RANK_MAX ON 
  "POST_NUKE".NUKE_POSTBOARD_LEVELS(LEVEL_MAXPOSTS) 
  TABLESPACE USERS PCTFREE 10  STORAGE(INITIAL 65536 ) 
; 

CREATE INDEX RANK_MIN ON 
  "POST_NUKE".NUKE_POSTBOARD_LEVELS(LEVEL_MINPOSTS) 
  TABLESPACE USERS PCTFREE 10  STORAGE(INITIAL 65536 ) 
; 


DROP TABLE NUKE_POSTBOARD_MODS CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_POSTBOARD_MODS ( 
  FORUM_ID  NUMBER (10)   DEFAULT 0, 
  USER_ID   NUMBER (10)   DEFAULT 0)
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_POSTBOARD_POSTS CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_POSTBOARD_POSTS ( 
  POST_ID    NUMBER (11)   NOT NULL, 
  TOPIC_ID   NUMBER (11)   DEFAULT 0, 
  FORUM_ID   NUMBER (11)   DEFAULT 0, 
  POSTER_ID  NUMBER (11)   DEFAULT 0, 
  POST_TIME  DATE          DEFAULT SYSDATE, 
  CONSTRAINT PK_NUKE_POSTBOARD_POSTS
  PRIMARY KEY ( POST_ID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 


CREATE INDEX FORUM_ID ON 
  "POST_NUKE".NUKE_POSTBOARD_POSTS(FORUM_ID) 
  TABLESPACE USERS PCTFREE 10  STORAGE(INITIAL 65536 ) 
; 

CREATE INDEX POSTER_ID ON 
  "POST_NUKE".NUKE_POSTBOARD_POSTS(POSTER_ID) 
  TABLESPACE USERS PCTFREE 10  STORAGE(INITIAL 65536 ) 
; 

CREATE INDEX TOPIC_ID ON 
  "POST_NUKE".NUKE_POSTBOARD_POSTS(TOPIC_ID) 
  TABLESPACE USERS PCTFREE 10  STORAGE(INITIAL 65536 ) 
; 


DROP TABLE NUKE_POSTBOARD_SMILIES CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_POSTBOARD_SMILIES ( 
  ID         NUMBER (11)   NOT NULL, 
  CODE       VARCHAR2 (50), 
  SMILE_URL  VARCHAR2 (100), 
  EMOTION    VARCHAR2 (75), 
  CONSTRAINT PK_NUKE_POSTBOARD_SMILIES
  PRIMARY KEY ( ID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_POSTBOARD_TEXT CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_POSTBOARD_TEXT ( 
  POST_ID    NUMBER (11)   DEFAULT 0 NOT NULL, 
  POST_TEXT  LONG, 
  CONSTRAINT PK_NUKE_POSTBOARD_TEXT
  PRIMARY KEY ( POST_ID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_POSTBOARD_TOPICS CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_POSTBOARD_TOPICS ( 
  TOPIC_ID            NUMBER (11)   NOT NULL, 
  TOPIC_TITLE         VARCHAR2 (100), 
  TOPIC_POSTER        NUMBER (11)   DEFAULT 0, 
  TOPIC_TIME          DATE          DEFAULT SYSDATE, 
  TOPIC_VIEWS         NUMBER (11)   DEFAULT 0, 
  TOPIC_REPLIES       NUMBER (11)   DEFAULT 0, 
  TOPIC_LAST_POST_ID  NUMBER (11)   DEFAULT 0, 
  FORUM_ID            NUMBER (11)   DEFAULT 0, 
  TOPIC_STATUS        VARCHAR2 (100)  DEFAULT 'U', 
  TOPIC_STICKY        NUMBER (3)    DEFAULT 0, 
  CONSTRAINT PK_NUKE_POSTBOARD_TOPICS
  PRIMARY KEY ( TOPIC_ID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

ALTER TABLE NUKE_POSTBOARD_TOPICS ADD CONSTRAINT 
CK_TOPIC_STATUS CHECK  ( topic_status in  ( 'U','L' )   ) ;




CREATE INDEX FORUM_ID_1 ON 
  "POST_NUKE".NUKE_POSTBOARD_TOPICS(FORUM_ID) 
  TABLESPACE USERS PCTFREE 10  STORAGE(INITIAL 65536 ) 
; 

CREATE INDEX TOPIC_LAST_POST_ID ON 
  "POST_NUKE".NUKE_POSTBOARD_TOPICS(TOPIC_LAST_POST_ID) 
  TABLESPACE USERS PCTFREE 10  STORAGE(INITIAL 65536 ) 
; 


DROP TABLE NUKE_POSTBOARD_TOPICSUBSCRIBE CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_POSTBOARD_TOPICSUBSCRIBE ( 
  UID_      NUMBER (11)   DEFAULT 0, 
  TOPIC_ID  NUMBER (11)   DEFAULT 0, 
  METHOD    CHAR (1)      DEFAULT 'm')
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_POSTBOARD_USERS CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_POSTBOARD_USERS ( 
  UID_       NUMBER (11)   DEFAULT 0 NOT NULL, 
  POSTS      NUMBER (11)   DEFAULT 0, 
  LEVEL_     NUMBER (8)    DEFAULT 0, 
  LASTVISIT  NUMBER (38), 
  CONSTRAINT PK_NUKE_POSTBOARD_USERS
  PRIMARY KEY ( UID_ ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_POSTBOARD_WORDS CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_POSTBOARD_WORDS ( 
  WORD_ID      NUMBER (11)   NOT NULL, 
  WORD         VARCHAR2 (255), 
  REPLACEMENT  VARCHAR2 (255), 
  CONSTRAINT PK_NUKE_POSTBOARD_WORDS
  PRIMARY KEY ( WORD_ID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_PRIV_MSGS CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_PRIV_MSGS ( 
  MSG_ID       NUMBER (10)   NOT NULL, 
  MSG_IMAGE    VARCHAR2 (100), 
  SUBJECT      VARCHAR2 (100), 
  FROM_USERID  NUMBER (10)   DEFAULT 0, 
  TO_USERID    NUMBER (10)   DEFAULT 0, 
  MSG_TIME     VARCHAR2 (20), 
  MSG_TEXT     VARCHAR2 (4000), 
  READ_MSG     NUMBER (10)   DEFAULT 0, 
  CONSTRAINT PK_NUKE_PRIV_MSGS
  PRIMARY KEY ( MSG_ID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 


CREATE INDEX TO_USERID ON 
  "POST_NUKE".NUKE_PRIV_MSGS(TO_USERID) 
  TABLESPACE USERS PCTFREE 10  STORAGE(INITIAL 65536 ) 
; 


DROP TABLE NUKE_QUEUE CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_QUEUE ( 
  QID        NUMBER (5)    NOT NULL, 
  UID_       NUMBER (9)    DEFAULT 0, 
  ARCD       NUMBER (10)   DEFAULT 0, 
  UNAME      VARCHAR2 (40), 
  SUBJECT    VARCHAR2 (100), 
  STORY      VARCHAR2 (4000), 
  TIMESTAMP  DATE          DEFAULT SYSDATE, 
  TOPIC      VARCHAR2 (20), 
  ALANGUAGE  VARCHAR2 (30), 
  BODYTEXT   VARCHAR2 (4000), 
  CONSTRAINT PK_NUKE_QUEUE
  PRIMARY KEY ( QID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_QUOTES CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_QUOTES ( 
  QID     NUMBER (10)   NOT NULL, 
  QUOTE   LONG, 
  AUTHOR  VARCHAR2 (150), 
  CONSTRAINT PK_NUKE_QUOTES
  PRIMARY KEY ( QID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_REALMS CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_REALMS ( 
  RID   NUMBER (10)   NOT NULL, 
  NAME  VARCHAR2 (255), 
  CONSTRAINT PK_NUKE_REALMS
  PRIMARY KEY ( RID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_REFERER CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_REFERER ( 
  RID        NUMBER (11)   NOT NULL, 
  URL        VARCHAR2 (100), 
  FREQUENCY  NUMBER (15), 
  CONSTRAINT PK_NUKE_REFERER
  PRIMARY KEY ( RID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_RELATED CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_RELATED ( 
  RID   NUMBER (11)   NOT NULL, 
  TID   NUMBER (11)   DEFAULT 0, 
  NAME  VARCHAR2 (30), 
  URL   VARCHAR2 (200), 
  CONSTRAINT PK_NUKE_RELATED
  PRIMARY KEY ( RID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_REVIEWS CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_REVIEWS ( 
  ID         NUMBER (10)   NOT NULL, 
  DATE_      DATE, 
  TITLE      VARCHAR2 (150), 
  TEXT       LONG, 
  REVIEWER   VARCHAR2 (20), 
  EMAIL      VARCHAR2 (60), 
  SCORE      NUMBER (10)   DEFAULT 0, 
  COVER      VARCHAR2 (100), 
  URL        VARCHAR2 (100), 
  URL_TITLE  VARCHAR2 (50), 
  HITS       NUMBER (10)   DEFAULT 0, 
  RLANGUAGE  VARCHAR2 (30), 
  CONSTRAINT PK_NUKE_REVIEWS
  PRIMARY KEY ( ID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_REVIEWS_ADD CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_REVIEWS_ADD ( 
  ID         NUMBER (10)   NOT NULL, 
  DATE_      DATE, 
  TITLE      VARCHAR2 (150), 
  TEXT       LONG, 
  REVIEWER   VARCHAR2 (20), 
  EMAIL      VARCHAR2 (60), 
  SCORE      NUMBER (10)   DEFAULT 0, 
  URL        VARCHAR2 (100), 
  URL_TITLE  VARCHAR2 (50), 
  RLANGUAGE  VARCHAR2 (30), 
  CONSTRAINT PK_NUKE_REVIEWS_ADD
  PRIMARY KEY ( ID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_REVIEWS_COMMENTS CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_REVIEWS_COMMENTS ( 
  CID       NUMBER (10)   NOT NULL, 
  RID       NUMBER (10)   DEFAULT 0, 
  USERID    VARCHAR2 (25), 
  DATE_     DATE, 
  COMMENTS  LONG, 
  SCORE     NUMBER (10)   DEFAULT 0, 
  CONSTRAINT PK_NUKE_REVIEWS_COMMENTS
  PRIMARY KEY ( CID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_REVIEWS_MAIN CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_REVIEWS_MAIN ( 
  TITLE        VARCHAR2 (100), 
  DESCRIPTION  VARCHAR2 (2000))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_SECCONT CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_SECCONT ( 
  ARTID      NUMBER (11)   NOT NULL, 
  SECID      NUMBER (11)   DEFAULT 0, 
  TITLE      VARCHAR2 (2000), 
  CONTENT    LONG, 
  COUNTER    NUMBER (11)   DEFAULT 0, 
  SLANGUAGE  VARCHAR2 (30), 
  CONSTRAINT PK_NUKE_SECCONT
  PRIMARY KEY ( ARTID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_SECTIONS CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_SECTIONS ( 
  SECID    NUMBER (11)   NOT NULL, 
  SECNAME  VARCHAR2 (40), 
  IMAGE    VARCHAR2 (50), 
  CONSTRAINT PK_NUKE_SECTIONS
  PRIMARY KEY ( SECID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_SESSION CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_SESSION ( 
  USERNAME   VARCHAR2 (25), 
  TIME       VARCHAR2 (14), 
  HOST_ADDR  VARCHAR2 (20), 
  GUEST      NUMBER (10)   DEFAULT 0)
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 


CREATE INDEX NUKE_SESSION_IDX_HOST_ADDR ON 
  "POST_NUKE".NUKE_SESSION(HOST_ADDR) 
  TABLESPACE USERS PCTFREE 10  STORAGE(INITIAL 65536 ) 
; 

CREATE INDEX NUKE_SESSION_IDX_USERNAME ON 
  "POST_NUKE".NUKE_SESSION(USERNAME) 
  TABLESPACE USERS PCTFREE 10  STORAGE(INITIAL 65536 ) 
; 


DROP TABLE NUKE_STATS_DATE CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_STATS_DATE ( 
  DATE_  VARCHAR2 (80), 
  HITS   NUMBER (11)   DEFAULT 0)
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_STATS_HOUR CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_STATS_HOUR ( 
  HOUR  NUMBER (3)    DEFAULT 0, 
  HITS  NUMBER (10)   DEFAULT 0)
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_STATS_MONTH CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_STATS_MONTH ( 
  MONTH  NUMBER (3)    DEFAULT 0, 
  HITS   NUMBER (10)   DEFAULT 0)
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_STATS_WEEK CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_STATS_WEEK ( 
  WEEKDAY  NUMBER (3)    DEFAULT 0, 
  HITS     NUMBER (10)   DEFAULT 0)
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_STORIES CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_STORIES ( 
  SID            NUMBER (11)   NOT NULL, 
  CATID          NUMBER (11)   DEFAULT 0, 
  AID            VARCHAR2 (30), 
  TITLE          VARCHAR2 (80), 
  TIME           DATE, 
  HOMETEXT       VARCHAR2 (4000), 
  BODYTEXT       VARCHAR2 (4000), 
  COMMENTS       NUMBER (11)   DEFAULT 0, 
  COUNTER        NUMBER (8), 
  TOPIC          NUMBER (10)   DEFAULT 1, 
  INFORMANT      VARCHAR2 (20), 
  NOTES          VARCHAR2 (4000), 
  IHOME          NUMBER (10)   DEFAULT 0, 
  THEMEOVERRIDE  VARCHAR2 (30), 
  ALANGUAGE      VARCHAR2 (30), 
  WITHCOMM       NUMBER (10)   DEFAULT 0, 
  CONSTRAINT PK_NUKE_STORIES
  PRIMARY KEY ( SID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_STORIES_CAT CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_STORIES_CAT ( 
  CATID          NUMBER (11)   NOT NULL, 
  CATITLE        VARCHAR2 (40), 
  COUNTER        NUMBER (11)   DEFAULT 0, 
  THEMEOVERRIDE  VARCHAR2 (30), 
  CONSTRAINT PK_NUKE_STORIES_CAT
  PRIMARY KEY ( CATID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_TOPICS CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_TOPICS ( 
  TOPICID     NUMBER (10)   NOT NULL, 
  TOPICNAME   VARCHAR2 (255), 
  TOPICIMAGE  VARCHAR2 (255), 
  TOPICTEXT   VARCHAR2 (255), 
  COUNTER     NUMBER (11)   DEFAULT 0, 
  CONSTRAINT PK_NUKE_TOPICS
  PRIMARY KEY ( TOPICID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_USERBLOCKS CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_USERBLOCKS ( 
  UID_         NUMBER (11)   DEFAULT 0, 
  BID          NUMBER (10)   DEFAULT 0, 
  ACTIVE       NUMBER (3)    DEFAULT 1, 
  LAST_UPDATE  NUMBER (38))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_USERS CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_USERS ( 
  UID_             NUMBER (11)   NOT NULL, 
  NAME             VARCHAR2 (60), 
  UNAME            VARCHAR2 (25), 
  EMAIL            VARCHAR2 (60), 
  FEMAIL           VARCHAR2 (60), 
  URL              VARCHAR2 (100), 
  USER_AVATAR      VARCHAR2 (30), 
  USER_REGDATE     VARCHAR2 (20), 
  USER_ICQ         VARCHAR2 (15), 
  USER_OCC         VARCHAR2 (100), 
  USER_FROM        VARCHAR2 (100), 
  USER_INTREST     VARCHAR2 (150), 
  USER_SIG         VARCHAR2 (255), 
  USER_VIEWEMAIL   NUMBER (3), 
  USER_THEME       NUMBER (10), 
  USER_AIM         VARCHAR2 (18), 
  USER_YIM         VARCHAR2 (25), 
  USER_MSNM        VARCHAR2 (25), 
  PASS             VARCHAR2 (40), 
  STORYNUM         NUMBER (4)    DEFAULT 10, 
  UMODE            VARCHAR2 (10), 
  UORDER           NUMBER (3)    DEFAULT 0, 
  THOLD            NUMBER (3)    DEFAULT 0, 
  NOSCORE          NUMBER (3)    DEFAULT 0, 
  BIO              VARCHAR2 (3), 
  UBLOCKON         NUMBER (3)    DEFAULT 0, 
  UBLOCK           VARCHAR2 (3), 
  THEME            VARCHAR2 (255), 
  COMMENTMAX       NUMBER (11)   DEFAULT 4096, 
  COUNTER          NUMBER (11)   DEFAULT 0, 
  TIMEZONE_OFFSET  FLOAT         DEFAULT 0.0, 
  CONSTRAINT PK_NUKE_USERS
  PRIMARY KEY ( UID_ ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

DROP TABLE NUKE_USER_PERMS CASCADE CONSTRAINTS ; 

CREATE TABLE NUKE_USER_PERMS ( 
  PID        NUMBER (11)   NOT NULL, 
  UID_       NUMBER (11)   DEFAULT 0, 
  SEQUENCE   NUMBER (10)   DEFAULT 0, 
  REALM      NUMBER (10)   DEFAULT 0, 
  COMPONENT  VARCHAR2 (255), 
  INSTANCE   VARCHAR2 (255), 
  LEVEL_     NUMBER (10)   DEFAULT 0, 
  BOND       NUMBER (10)   DEFAULT 0, 
  CONSTRAINT PK_NUKE_USER_PERMS
  PRIMARY KEY ( PID ) 
    USING INDEX 
     TABLESPACE USERS PCTFREE 10
     STORAGE ( INITIAL 65536 ))
   TABLESPACE USERS
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 524288
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE;