CREATE TABLE CMVFS (
CMFNAM char (255),
CMDTYP int ,
CMMODD int,
CMWHOM char (50) NULL,
CMDATA CLOB NULL
);
ALTER TABLE CMVFS
ADD
(
PRIMARY KEY (CMFNAM)
);
CREATE TABLE CMCHAB (
CMUSERID char (50) NULL ,
CMABID char (50) NULL ,
CMABPF int NULL ,
CMABTX CLOB NULL
);
ALTER TABLE CMCHAB
ADD
(
PRIMARY KEY (CMUSERID,CMABID)
);
CREATE TABLE CMSTAT (
CMSTRT int,
CMENDT int,
CMDATA CLOB NULL
);
ALTER TABLE CMSTAT
ADD
(
PRIMARY KEY (CMSTRT)
);
CREATE TABLE CMPOLL (
CMNAME char (100) ,
CMBYNM char (100) NULL ,
CMSUBJ char (255) NULL ,
CMDESC CLOB NULL ,
CMOPTN CLOB NULL ,
CMFLAG int NULL ,
CMQUAL char (255) NULL ,
CMRESL CLOB NULL,
CMEXPI int NULL
);
ALTER TABLE CMPOLL
ADD
(
PRIMARY KEY (CMNAME)
);
CREATE TABLE CMCHAR (
CMCHID char (50),
CMUSERID char (50),
CMPASS char (50) NULL ,
CMCLAS char (200) NULL ,
CMSTRE int NULL ,
CMRACE char (50) NULL ,
CMDEXT int NULL ,
CMCONS int NULL ,
CMGEND char (50) NULL ,
CMWISD int NULL ,
CMINTE int NULL ,
CMCHAR int NULL ,
CMHITP int NULL ,
CMLEVL char (50) NULL ,
CMMANA int NULL ,
CMMOVE int NULL ,
CMDESC CLOB NULL ,
CMALIG int NULL ,
CMEXPE int NULL ,
CMEXLV int NULL ,
CMWORS char (50) NULL ,
CMPRAC int NULL ,
CMTRAI int NULL ,
CMAGEH int NULL ,
CMGOLD int NULL ,
CMWIMP int NULL ,
CMQUES int NULL ,
CMROID char (100) NULL ,
CMDATE char (50) NULL ,
CMCHAN int NULL ,
CMATTA int NULL ,
CMAMOR int NULL ,
CMDAMG int NULL ,
CMBTMP int NULL ,
CMLEIG char (50) NULL ,
CMHEIT int NULL ,
CMWEIT int NULL ,
CMPRPT char (250) NULL,
CMCOLR char (100) NULL,
CMLSIP char (100) NULL,
CMEMAL char (255) NULL,
CMPFIL CLOB NULL,
CMSAVE char (150) NULL,
CMMXML CLOB NULL
);
ALTER TABLE CMCHAR
ADD
(
PRIMARY KEY (CMUSERID)
);
CREATE TABLE CMCHFO (
CMUSERID char (50) NULL ,
CMFONM int NULL ,
CMFOID char (50) NULL ,
CMFOTX CLOB NULL ,
CMFOLV int NULL ,
CMFOAB int NULL
);
ALTER TABLE CMCHFO
ADD
(
PRIMARY KEY (CMUSERID,CMFONM)
);
CREATE TABLE CMCHCL (
CMUSERID char (50) NULL ,
CMCLAN char (100) NULL ,
CMCLRO int NULL,
CMCLSTS char (100) NULL
);
ALTER TABLE CMCHCL
ADD
(
PRIMARY KEY (CMUSERID,CMCLAN)
);
CREATE TABLE CMCHIT (
CMUSERID char (50) NULL ,
CMITNM char (100) NULL ,
CMITID char (50) NULL ,
CMITTX CLOB NULL ,
CMITLO char (100) NULL ,
CMITWO int NULL ,
CMITUR int NULL ,
CMITLV int NULL ,
CMITAB int NULL ,
CMHEIT int NULL
);
ALTER TABLE CMCHIT
ADD
(
PRIMARY KEY (CMUSERID,CMITNM)
);
CREATE TABLE CMROCH (
CMROID char (50) NULL ,
CMCHNM char (100) NULL ,
CMCHID char (50) NULL ,
CMCHTX CLOB NULL ,
CMCHLV int NULL ,
CMCHAB int NULL ,
CMCHRE int NULL ,
CMCHRI char (100) NULL
);
ALTER TABLE CMROCH
ADD
(
PRIMARY KEY (CMROID,CMCHNM)
);
CREATE TABLE CMROEX (
CMROID char (50) NULL ,
CMDIRE int NULL ,
CMEXID char (50) NULL ,
CMEXTX CLOB NULL ,
CMNRID char (50) NULL
);
ALTER TABLE CMROEX
ADD
(
PRIMARY KEY (CMROID,CMDIRE)
);
CREATE TABLE CMROIT (
CMROID char (50) NULL ,
CMITNM char (100) NULL ,
CMITID char (50) NULL ,
CMITLO char (100) NULL ,
CMITTX CLOB NULL ,
CMITRE int NULL ,
CMITUR int NULL ,
CMITLV int NULL ,
CMITAB int NULL ,
CMHEIT int NULL
);
ALTER TABLE CMROIT
ADD
(
PRIMARY KEY (CMROID,CMITNM)
);
CREATE TABLE CMROOM (
CMROID char (50) NULL ,
CMLOID char (50) NULL ,
CMAREA char (50) NULL ,
CMDESC1 char (255) NULL ,
CMDESC2 CLOB NULL ,
CMROTX CLOB NULL
);
ALTER TABLE CMROOM
ADD
(
PRIMARY KEY (CMROID)
);
CREATE TABLE CMQUESTS (
CMQUESID char (50) NULL ,
CMQUTYPE char (50) NULL ,
CMQFLAGS int NULL ,
CMQSCRPT CLOB NULL ,
CMQWINNS CLOB NULL
);
ALTER TABLE CMQUESTS
ADD
(
PRIMARY KEY (CMQUESID)
);
CREATE TABLE CMAREA (
CMAREA char (50) ,
CMTYPE char (50) ,
CMCLIM int NULL ,
CMSUBS char (100) NULL ,
CMDESC CLOB NULL ,
CMROTX CLOB NULL ,
CMTECH int NULL
);
ALTER TABLE CMAREA
ADD
(
PRIMARY KEY (CMAREA)
);
CREATE TABLE CMJRNL (
CMJKEY char (75) ,
CMJRNL char (50) NULL ,
CMFROM char (50) NULL ,
CMDATE char (50) NULL ,
CMTONM char (50) NULL ,
CMSUBJ char (100) NULL ,
CMPART char (75) NULL ,
CMATTR int NULL,
CMDATA char (255) NULL ,
CMUPTM number(20) NULL,
CMIMGP char (50) NULL,
CMVIEW int NULL,
CMREPL int NULL,
CMMSGT CLOB NULL
);
ALTER TABLE CMJRNL
ADD
(
PRIMARY KEY (CMJKEY)
);
CREATE INDEX CMJRNLNAME on CMJRNL (CMJRNL);
CREATE INDEX CMJRNLCMPART on CMJRNL (CMPART);
CREATE INDEX CMJRNLCMTONM on CMJRNL (CMTONM);
CREATE INDEX CMJRNLCMUPTM on CMJRNL (CMUPTM);
CREATE TABLE CMCLAN (
CMCLID char (100) ,
CMTYPE int ,
CMDESC CLOB NULL ,
CMACPT char (255) NULL ,
CMPOLI CLOB NULL ,
CMRCLL char (50) NULL ,
CMDNAT char (50) NULL ,
CMSTAT int NULL ,
CMMORG char (50) NULL ,
CMTROP int NULL
);
ALTER TABLE CMCLAN
ADD
(
PRIMARY KEY (CMCLID)
);
CREATE TABLE CMPDAT (
CMPLID char (100) ,
CMSECT char (100) ,
CMPKEY char (100) ,
CMPDAT CLOB NULL
);
ALTER TABLE CMPDAT
ADD
(
PRIMARY KEY (CMPLID,CMSECT,CMPKEY)
);
CREATE TABLE CMGRAC (
CMRCID char (50) ,
CMRDAT CLOB NULL
);
ALTER TABLE CMGRAC
ADD
(
PRIMARY KEY (CMRCID)
);
CREATE TABLE CMCCAC (
CMCCID char (50) ,
CMCDAT CLOB NULL
);
ALTER TABLE CMCCAC
ADD
(
PRIMARY KEY (CMCCID)
);
CREATE TABLE CMGAAC (
CMGAID char (50) ,
CMGAAT CLOB NULL ,
CMGACL char (50) NULL
);
ALTER TABLE CMGAAC
ADD
(
PRIMARY KEY (CMGAID)
);
CREATE TABLE CMACCT (
CMANAM char (50),
CMPASS char (50),
CMCHRS CLOB NULL,
CMAXML CLOB NULL
);
ALTER TABLE CMACCT
ADD
(
PRIMARY KEY (CMANAM)
);
CREATE TABLE CMBKLG (
CMNAME char (50),
CMINDX int,
CMDATE number(20) NULL,
CMDATA CLOB NULL
);
ALTER TABLE CMBKLG
ADD
(
PRIMARY KEY (CMNAME,CMINDX)
);
CREATE TABLE CMCLIT (
CMCLID char (100) ,
CMITNM char (100) ,
CMITID char (50) NULL ,
CMITTX CLOB NULL ,
CMITLO char (100) NULL ,
CMITWO int NULL ,
CMITUR int NULL ,
CMITLV int NULL ,
CMITAB int NULL ,
CMHEIT int NULL
);
ALTER TABLE CMCLIT
ADD
(
PRIMARY KEY (CMCLID,CMITNM)
);
